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