{"id":18133,"date":"2023-01-10T19:31:07","date_gmt":"2023-01-11T00:31:07","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=18133"},"modified":"2023-06-14T15:58:29","modified_gmt":"2023-06-14T19:58:29","slug":"field-name-map","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/field-name-map\/","title":{"rendered":"Field Name Map"},"content":{"rendered":"\n

Here is a table of all fields within Artisan and their corresponding code.<\/p>\n\n

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