Field Name Map

Contents

Here is a table of all fields within Artisan and their corresponding code.

Field Name Map

Field Code Field Name
STATUS Availability
AVGCOST Average Cost
BASEPROD Base Product
BRIEFDESC Brief Description
CASESIZE Case Size
SORTORDER Catalog Order
CATEGORY Category
CHANGESTATION Changed At
CHANGEDBY Changed By
CHANGEDDATE Changed On
COSTMODEL Consignment Cost Model
DFLTCONSIGN Consignment Set by Vendor?
SPLIT Consignment Split
CONSIGN Consignment?
CREATESTATION Created At
CREATEDBY Created By
CREATEDATE Created On
CUSTFLD1 Custom Field 1
CUSTFLD2 Custom Field 2
CUSTFLD3 Custom Field 3
CUSTFLD4 Custom Field 4
CUSTFLD5 Custom Field 5
CUSTFLD6 Custom Field 6
CUSTFLD7 Custom Field 7
CUSTFLD8 Custom Field 8
CUSTFLD9 Custom Field 9
CUSTFLD10 Custom Field 10
CUSTFLD11 Custom Field 11
CUSTFLD12 Custom Field 12
CUSTFLD13 Custom Field 13
CUSTFLD14 Custom Field 14
CUSTFLD15 Custom Field 15
CUSTFLD16 Custom Field 16
CUSTFLD17 Custom Field 17
CUSTFLD18 Custom Field 18
CUSTFLD19 Custom Field 19
CUSTFLD20 Custom Field 20
CUSTFLD21 Custom Field 21
CUSTFLD22 Custom Field 22
CUSTFLD23 Custom Field 23
CUSTFLD24 Custom Field 24
CUSTFLD25 Custom Field 25
CUSTFLD26 Custom Field 26
CUSTFLD27 Custom Field 27
CUSTFLD28 Custom Field 28
CUSTFLD29 Custom Field 29
CUSTFLD30 Custom Field 30
BASEDEL Deleted By Base Product
DEPTH Depth
IDESC Description
DETAILDESC Detailed Description
DISCOUNT Discount
DISCEND Discount End Date
DISCSTART Discount Start Date
DISCTYPE Discount Type
NODISCOUNT Don't Discount?
EDITIONSZ Edition Size
COSTPERCENT Estimated Cost
DESC2 Extended Description
XCATCODES Extra Categories (Online)
FEATURED Featured Product (Online)
FILLDESC Fill In Description?
HEIGHT Height
ID ID
INSTORE In-Store Only?
ISLAYOPTS Internet Store Layout Options
ISLAYOUT Internet Store Layout Template
ISKIT Inventory Kit?
INVTRACK Inventory Tracking Mode
ITEMCODE Item Code
KEYWORDS Keywords
KITSHOWSAV Kit Savings Message
LABELDESC Label Description
LABELQTY Label Qty
COUNTDATE Last Physical Count Date
LASTRCVDATE Last Receive Date
LASTSALEDATE Last Sale Date
LISTPRICE List Price (MSRP)
MFRPARTNO Manufacturer's P/N
MFR_PUB Manufacturer/Publisher
MEMO Memo
MENUCOLOR Menu Color
MENUORDER Menu Order
MINPRICE Minimum Price
MODCOUNT Modification Count
NOTE Pop-Up Note
PRICEMODEL Pricing Model
PRICESCHEME Pricing Scheme
BARCODE Private Barcode
PRODNAME Product Name
TAGS Product Tags (Online)
KITORDCOMP Put Kit Components on PO?
QTYCOUNTED Qty Counted
QTYMULT Qty Multiplier
QTYONHAND Qty On Hand (QOH)
QTYONORDER Qty On Order
QTYORDRESV Qty On Order Reserved
QTYOUT Qty Out (on loan or rented)
QTYREQUEST Qty Requested
QTYREQRESV Qty Requested Reserved
QTYRESERVE Qty Reserved from On Hand
QUICKPICK Quick Pick?
RCPTDESC Receipt Description
RELPRODS Related Products (Online)
RENTALMODE Rental Mode
RENTALTIME Rental Period
REORDERMIN Reorder Level (Minimum Threshold)
REORDERMAX Reorder Level (Maximum Threshold)
REORDERQTY Reorder Minimum Quantity
PRICE Retail Price
QTYSCHEME Retail Quantity Break Scheme
SALEPERCENT Sale % Price
KITMANWEIGHT Set Kit Weight Manually?
LOCATION Shelf Location
SHIPPRICE Shipping Price
SHIPWEIGHT Shipping Weight
STDCOST Standard Cost (Case Cost)
SCHGAMOUNT Surcharge Amount
TOTAL_RCV_AMT Total Amount Received
TOTAL_SOLD_AMT Total Amount Sold
TOTAL_RCV_UNITS Total Units Received
TOTAL_SOLD_UNITS Total Units Sold
UPC UPC (GTIN)
COST Unit Cost
UOM Unit of Measure
DESC2LABEL Use Ext Desc on Labels?
DESC2PACK Use Ext Desc on Packing Slips?
DESC2PO Use Ext Desc on Purchase Orders?
DESC2SALE Use Ext Desc on Sales Receipts?
ONLINE Use Online?
QSCHEMEALL Use Retail Qty Break Scheme for All Levels?
VARORDER Variant Order
VARTEMPL Variant Template
VIVALUE1 Variant Value 1
VIVALUE2 Variant Value 2
VIVALUE3 Variant Value 3
VIVALUE4 Variant Value 4
VIVALUE5 Variant Value 5
VIVALUE6 Variant Value 6
VIVALUE7 Variant Value 7
VIVALUE8 Variant Value 8
VIVALUE9 Variant Value 9
VENDOR Vendor Code (Preferred)
VITEM Vendor's P/N
VISIBILITY Visibility
WIDTH Width
YTD_RCV_AMT YTD Amount Received
YTD_SOLD_AMT YTD Amount Sold
YTD_RCV_UNITS YTD Units Received
YTD_SOLD_UNITS YTD Units Sold
Updated on June 14, 2023

Related Articles