Product Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Product Import.

Column	Position	Field	Maximum Length	Format	Required	Description
A	1	Product Code	40	Character	Yes	Enter the product's identification code. The format of the code is set up in Product Code Length Maintenance and Product Code Element Maintenance. You can use the default format, or create format and element definitions based on your company's requirements. A unique product code must be used for each product. NOTE Do not include delimiters in the product code.
B	2	Product Name	40	Character	Yes	Enter the product's name. This field does not require a unique name for each product.
C	3	Location Prefix	3	Character	No	Enter a valid location prefix in which the product is stored. For information on setting up locations, see Location Maintenance.
D	4	Product Type	7	Character	No	Enter Merch or Service to indicate if the product is merchandise or a service. Inventory is tracked for merchandise products, but not for service products. Separate pick demands are created for service products, and these pick demands must be confirmed before you can invoice the associated order. If this field is blank, it defaults to Merch. Example You are creating a new product called Repackaging Services. The product should be set up as a service product.
E	5	Description	30	Character	No	Enter a short description of the product. This description can be used for searching by product.
F	6	Search Name	20	Character	No	Enter a search name for the product. The search name is used as another search criterion in Lookup windows for rapid selection.
G	7	UPC	25	Character	No	Enter the UPC for the product. Note The product import can calculate a UPC if the Automatic UPC Generation check box is selected in Warehouse Management Control Maintenance and no UPC is entered in this field.
H	8	Product Unit of Measure	8	Character	Yes, only if the Use Category Defaults field (position 218) is No or blank	Enter a valid unit of measure that is the smallest inventory transaction unit of measure for the product. Example A canned product is only sold in cases, but the customer can return damaged cans for credit. If these cans are restocked and resold (at a discount, for example), then the smallest unit of measure is can, not case. If these cans are thrown (or given) away, then the smallest unit of measure is case, not can. For information on setting up units of measure, see Unit of Measure Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
I	9	Category	12	Character	Yes	Enter a valid product category for the product. For information on setting up product categories, see Product Category Maintenance. Inquiries can be made by product category. Reports generally have options to print in product category sequence.
J	10	Harmonization Codes		Character	No	Enter valid harmonization codes for the product separated by a \| character. EXAMPLE 2204.21.20\|9811.00.20 The order of the harmonization codes controls the hierarchy of the codes. A harmonization code is generally a tariff identified by customs stating the commodity of a product. For information on setting up harmonization codes, see Harmonization Code Maintenance.
K	11	Subcategory	12	Character	No	Enter a valid product subcategory for the product. A subcategory is an optional hierarchical level below the category. For information on setting up subcategories, see Product Subcategory Maintenance.
L	12	MSDS Number	12	Character	No	Enter the Material Safety Data Sheet (MSDS) number for the product if the product is a hazardous chemical. The MSDS number corresponds to hazards of various chemicals. This field is informational only.
M	13	Hazard Code	12	Character	No	Enter a valid hazard code if one is required for the product. Hazard codes are identification codes for products that have special handling, selling, or purchasing requirements (usually products for the chemical materials industry). For information on setting up hazard codes, see Hazardous Material Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
N	14	Image File 1	255	Character	No	Enter the folder path and file name for the product's first image file.
O	15	Image File 2	255	Character	No	Enter the folder path and file name for the product's second image file.
P	16	Image File 3	255	Character	No	Enter the folder path and file name for the product's third image file.
Q	17	Detail Description	16959	Character	No	Enter detailed characteristics of the product.
R	18	Internal Buyer	60	Character	No	Enter a valid user ID of the buyer responsible for the replenishment of the product. For information on setting up user ID's, see User Profile Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
S	19	Minimum Stock Level	12	>>>>>>>>9.99	No	Enter a minimum stocking level for the product. This is used for min-max purchasing and DRP. Both a minimum and maximum stock level are necessary to purchase a product using min-max (Min-Max Buying Recommendations). Stocking levels defined in this field are in the default purchasing unit of measure. You must enter zero if Yes is entered for the Not Stocked field.
T	20	Maximum Stock Level	12	>>>>>>>>9.99	No	Enter a maximum stocking level for the product. This is used for min-max purchasing and DRP. Both a minimum and maximum stock level are necessary to purchase a product using min-max (Min-Max Buying Recommendations). Stocking levels defined in this field are in the default purchasing unit of measure. You must enter zero if Yes is entered for the Not Stocked field.
U	21	Safety Stock	12	>>>>>>>>9.99	No	Enter the safety stock quantity for the product in the default purchase unit of measure. This is informational only, and not used in calculations.
V	22	Buying Method	20	Character	Yes, only if the Use Category Defaults field (position 218) is No or blank	Enter a valid buying method for the product. The buying method determines how a product is purchased. For information on setting up buying methods, see Buying Method Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
W	23	Cost Class	10	Character	No	Enter a valid cost class for the product. Cost classes are used to group similar products so that a single cost may be assigned by cost class in Purchase Cost Matrix Maintenance. For information on setting up cost classes, see Purchase Cost Class Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
X	24	Review Days	4	9999	No	Enter the number of days the product is to be reviewed in determining purchase levels for the product. This field is used for the Demand Forecasting buying method. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
Y	25	Standard Cost	14	>>>>>>>>9.9999	No	Enter the standard cost of the product for the product unit of measure. For more information, see cost basis. If standard cost is the accounting cost, this field must be entered.
Z	26	Burden Cost	14	>>>>>>>>9.9999	No	Enter the burden cost of the product for the product unit of measure. For more information, see cost basis.
AA	27	Average Cost	14	>>>>>>>>9.9999	No	Enter the average cost of the product for the product unit of measure. You can only enter this amount during import.
AB	28	Last Cost	14	>>>>>>>>9.9999	No	Enter the last cost of the product for the product unit of measure. You can only enter this amount during import.
AC	29	Beginning Year Cost	14	>>>>>>>>9.9999	No	Enter the beginning year cost of the product for the product unit of measure. You can only enter this amount during import. This field is not used for kit and service products.
AD	30	Tax Category	12	Character	No	Enter a valid sales tax category for the product. Tax categories are used to group together similar products solely for taxation purposes. For information on setting up sales tax categories, see Sales Tax Category Maintenance. If this field is blank, it defaults from the product category entered for the Category field (position 9). NOTE This field is ignored when AvaTax interface is used.
AE	31	Price Classes		Character	No	Enter valid price classes for the product. Separate each price class with the following delimiter character: \| Example PriceClassA\|PriceClassB\|PriceClassC You can use price classes to create price matrices for price books (groups of customers) in Price Book Price Maintenance or for specific customers in Customer Price Maintenance. The order of price classes in this field determines the hierarchy for the product's price classes. For information on setting up price classes, see Price Class Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9). Note This field is not used for configuration kits.
AF	32	Family Price Code	10	Character	No	Enter a valid family price code for the product. A family price code is used to group together similar products if you want to give customers a price break on the total quantity ordered for the group, instead of the quantity ordered for each product in the group. The family price code you enter is used as the default for price matrixes for the product. Example You sell paint by the case. Each color is packed in a separate case, has a separate product code, and is priced at $10.00 per case. You want to give a special price break for customers that buy 100 cases, regardless of color, of $7.00 per case. For information on setting up family price codes, see Family Price Maintenance. Note This field is not used for configuration kits.
AG	33	Commission Class	12	Character	No	Enter a valid commission class for the product. Commission classes are used to group together similar products solely for sales representative commissions. For information on setting up commission classes, see Commission Class Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
AH	34	Catalog Page	8	Character	No	Enter the catalog page on which the product is displayed if your company's products are catalogued.
AI	35	Margin Option	6	Character	No	Enter one of the following margin options: Ignore - Do not verify minimum and maximum sales margin rules and allow the product to be ordered. Hold - Verify the margin is within an acceptable range, and if it is not, display a warning message and place the sales order on hold. Warn - Verify the margin is within an acceptable range, and if it is not, display a warning message. If this field is left blank, it defaults to Ignore. If the product is a kit, enter Ignore.
AJ	36	Minimum Sales Margin Percent	5	>9.99	No	Enter a minimum margin percentage for sales orders between 1 and 99.99. You must leave this field blank if Ignore is entered for the Margin Option field. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
AK	37	Maximum Sales Margin Percent	5	>9.99	No	Enter a maximum margin percentage for sales orders between 1 and 99.99. You must leave this field blank if Ignore is entered for the Margin Option field. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
AL	38	Kit	3	Yes/No	No	Enter Yes if the product is sold as a kit or is a phantom assembly. Kits are a compilation of products and/or components that are used to make up a whole product. Kits are set up in Bill of Material Maintenance. If the product is a kit, you can specify whether it is a fixed or configuration kit using the Kit Type field (position 39). For more information on kits, see Kit FAQ. If this field is blank, it defaults to No.
AM	39	Kit Type	18	Character	No	If No is entered for the Kit field (position 38), leave this field blank. If Yes is entered for the Kit field, enter one of the following: Configuration Kit - A configuration kit is composed of a set of products and/or components where you can change the mix. Kit - A phantom assembly or fixed kit is composed of a fixed set of products and/or components. No alterations to the product mix can be made. For more information, see Fixed Kit FAQ. If this field is blank, and Yes is entered for the Kit field, it defaults to Kit.
AN	40	Allocate X Business Days before Required Date	4	9999	No	If you only want to reserve the product for orders required within a certain number of business days, enter the number of business days. Inventory is not allocated if an order’s required date is beyond this number of business days from the entered date. (The line item is considered a future line item.) Business days are calculated based on how your business calendar is set up in Business Calendar Day Maintenance. Example You allocate inventory 10 days before the required date for Product A. You create an order for this product with the order date 01/05 and the required date 01/18. If sufficient inventory exists, it will be allocated for Product A on 01/05 because there are 9 business days between 01/05 and 01/18. The number of units allocated displays on the Items tab in Order Entry. You cannot import a value in this field if the product is a kit. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
AO	41	List Price 1	14	>>>>>>>>9.99<<	No	Enter the first list price for the product with two to four decimal places. This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned in this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance.
AP	42	List Price 2	14	>>>>>>>>9.99<<	No	Enter the second list price for the product with two to four decimal places. This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned in this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance.
AQ	43	List Price 3	14	>>>>>>>>9.99<<	No	Enter the third list price for the product with two to four decimal places. This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned in this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance.
AR	44	List Price 4	14	>>>>>>>>9.99<<	No	Enter the fourth list price for the product with two to four decimal places. This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned in this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance.
AS	45	Sales	29	Character	No	Enter all or part of the sales general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on sales general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
AT	46	Drop Ship Sales	29	Character	No	Enter all or part of the drop-ship sales general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on drop-ship sales general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
AU	47	Inventory	29	Character	No	Enter all or part of the inventory general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on inventory general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
AV	48	Cost of Goods Sold	29	Character	No	Enter all or part of the cost of goods sold general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on cost of goods sold general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
AW	49	Returns Expense	29	Character	No	Enter all or part of the returns expense general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on returns expense general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
AX	50	Transfer Sale	29	Character	No	Enter all or part of the transfer sale general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on transfer sale general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
AY	51	In Transit	29	Character	No	Enter all or part of the in transit general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on in transit general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
AZ	52	Adjustments Expense	29	Character	No	Enter all or part of the adjustments expense general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on adjustments expense general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
BA	53	Transfer Buy	29	Character	No	Enter all or part of the transfer buy general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on transfer buy general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
BB	54	Standard Cost Variance	29	Character	No	Enter all or part of the standard cost variance general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on standard cost variance general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
BC	55	Transfer Expense	29	Character	No	Enter all or part of the transfer expense general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on transfer expense general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
BD	56	Accounts Payable Inventory Variance	29	Character	No	Enter all or part of the accounts payable inventory variance general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on accounts payable inventory variance general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
BE	57	Drop Ship Cost of Goods Sold	29	Character	No	Enter all or part of the drop-ship cost of goods sold general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on drop-ship cost of goods sold general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. General ledger accounts are required. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
BF	58	Sales Track Level	6	Character	No	Enter None, Lot, or Serial to indicate the sales tracking level for the product. A product that is tracked at the sales level is assigned a tracking number (lot or serial) only when the product is shipped. Inquiries at sales-tracked levels are performed in Sales Tracking Inquiry. For more information, see Serial and Lot Tracking FAQ. Note If a product is either serial or lot tracked at the inventory level and is sales tracked, the inventory information will default to the sales tracking information. If you only need customer outbound tracking by lot or serial number, use only the Sales Track Level option. After a product has been created, its tracking level can only be changed if there are no existing inventory records for the product; therefore, it is important to determine appropriate tracking levels for a product. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9). Otherwise, if this field is blank, it defaults to None.
BG	59	Track Quantity at Lot	3	Yes/No	No	Enter Yes if you want to track product quantities by lot. For more information, see Serial and Lot Tracking FAQ. You must enter No if Serial is entered for the Sales Track Level field or Yes is entered for the Kit field. You cannot enter Yes for this field and the Track Quantity at Serial Number field. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9). Otherwise, if this field is blank, it defaults to No.
BH	60	Track Quantity at Serial Number	3	Yes/No	No	Enter Yes if you want to track product quantities by serial number. For more information, see Serial and Lot Tracking FAQ. You must enter No if Lot is entered for the Sales Track Level field or Yes is entered for the Kit field. You cannot enter Yes for this field and the Track Quantity at Lot field. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9). Otherwise, if this field is blank, it defaults to No.
BI	61	Can Be Sold	3	Yes/No	No	Enter No if the product cannot be entered on a sales order. If this field is blank, it defaults to Yes.
BJ	62	Not Stocked	3	Yes/No	No	Enter Yes if your company can only purchase the product when there is a sales order. If you enter Yes, then you must also enter Yes for the Hold Inventory for Backorders field and you must enter 0 for the Minimum Stock Level and Maximum Stock Level fields. You can set up the software to not allow returns on non-stocked products, produce a warning, or allow returns. Non-stocked products will not appear in Min-Max Buying Recommendations or Demand Forecast processing. If this field is blank, it defaults to No.
BK	63					This field is not used.
BL	64	Drop Ship Allowed	3	Yes/No	No	Enter Yes if the product can be drop shipped to customers. Note If you enter Yes, then the Primary Supplier Code field is required (position 109). You cannot enter Yes for a product that is a kit or that is a catch weight product. If this field is blank, it defaults to No.
BM	65	Must Drop Ship	3	Yes/No	No	Enter Yes if the product must be drop shipped. You can only enter Yes for this field if you enter Yes for the Drop Ship Allowed field. If this field is blank, it defaults to No.
BN	66	Discontinued	3	Yes/No	No	Enter Yes if the product is no longer available for sale. Existing inventory of the product can be ordered; however, the product will not go on backorder for insufficient order quantity. This allows the product to be phased out of inventory. The quantity available and quantity on hand will determine how much of the product can be sold. If there are existing backorders for the product, they must be manually cancelled by the order processor. On the purchasing side, discontinued products are not recommended for purchases in Min-Max Buying Recommendations. You can also exclude discontinued products from 3rd Party Forecasting Export and reports, such as Inventory Status Report. Users can still create standalone purchase orders in Purchase Order Maintenance, but when the discontinued product is selected, a warning message appears, which indicates that the product is discontinued. Users can then continue processing the purchase order for the product, or remove the discontinued product from the order. Discontinued products can still be used for work orders if sufficient inventory is available. If this field is blank, it defaults to No.
BO	67	Allow Larger Unit of Measure Picking Recommendations	3	Yes/No	Yes, only if the Use Category Defaults field (position 218) is No or blank	Enter Yes to permit a larger unit of measure to be broken to fulfill a sales order allocation for a smaller unit of measure. The alternative would be to replenish the smaller unit of measure. Upward picking takes precedence over downward picking. Note A product has three units of measure - each, case/10, and pallet/100. There are 3 each, 1 case/10, and 1 pallet/100 available. A new sales order is created for 2 case/10. If larger unit of measure picking recommendations are allowed, the pick demand for this sales order will have a line item for 1 case/10 and another line item to break the pallet/100 to pick another case/10. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
BP	68	Allow Smaller Unit of Measure Picking Recommendations	3	Yes/No	Yes, only if the Use Category Defaults field (position 218) is No or blank	Enter Yes to permit a larger unit of measure to be assembled from smaller units of measure to fulfill a sales order allocation. Note A product has three units of measure - each, case/10, and pallet/100. There are 11 each, 0 case/10, and 1 pallet/100 available. A new sales order is created for 1 case/10. If smaller unit of measure picking recommendations are allowed, the pick demand for this sales order will have a line item for 10 each to assemble to 1 case/10. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
BQ	69	Pick Method	11	Character	No	Enter one of the following pick method values: FIFO/UM/SEQ LIFO/UM/SEQ UM/FIFO/SEQ UM/LIFO/SEQ If this field is blank, this defaults from the product category entered for the Category field (position 9).
BR	70	Pick Group	20	Character	Yes, only if the Use Category Defaults field (position 218) is No or blank	Enter a valid product pick group for the product. For information on setting up product pick groups, see Product Pick Group Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
BS	71	Lot Life	6	>>>>>9	No	If the product is lot tracked, enter the default number of days after which a lot expires.
BT	72	Unit of Packaging	8	Character	No	This field is not used.
BU	73	Weight Unit of Measure	8	Character	No	Enter a valid weight unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance. If this is blank, it defaults to the default weight unit of measure entered in Warehouse Management Control Maintenance.
BV	74	Unit Gross Weight	11	>>>>>9.9999	No	Enter the gross unit weight (including packaging) of the product. This must be entered in the weight unit of measure.
BW	75	Unit Net Weight	11	>>>>>9.9999	No	Enter the net unit weight of the product. This must be entered in the weight unit of measure.
BX	76	Volume	11	>>>>>9.9999	No	Enter the volume of the product. This must be entered in the volume unit of measure. If this field is blank, it defaults to 0.
BY	77	Volume Unit of Measure	8	Character	No	Enter a valid volume unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance. If this is blank, it defaults to the ship volume unit of measure entered in Location Maintenance for the location that is set up as the default shipping location for your user ID.
BZ	78	Dimensional Basis	8	Character	No	Enter a valid dimensional unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance.
CA	79	Density Volume Basis	8	Character	No	Enter a valid density volume unit of measure (basis) for the product. This field cannot be blank if the volume is entered. This must be entered in the stock unit of measure.
CB	80					Leave this field blank.
CC	81	Display on Purchase Order Lookup	3	Yes/No	No	Enter Yes if you want the product to appear in the Lookup window when entering a purchase order in Purchase Order Maintenance. Enter No if you do not want the product to appear in the Lookup window. If you enter No, users cannot view or search for the product during purchase order entry; however, if a user types the product code or name in the appropriate field, the product can still be ordered. If this field is blank, it defaults to Yes.
CD	82	Display on Order Entry Lookup	3	Yes/No	No	Enter Yes if you want the product to appear in the Lookup window accessed during order entry in O/E Line Item Entry. Enter No if you do not want the product to appear in the Lookup window. If you enter No, users cannot view or search for the product during order entry; however, if a user types the product code or name in the appropriate field, the product can still be ordered. If this field is blank, it defaults to Yes.
CE	83	User Defined 1	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CF	84	User Defined 2	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CG	85	User Defined 3	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CH	86	User Defined 4	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CI	87	User Defined 5	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CJ	88	User Defined 6	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CK	89	User Defined 7	30	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CL	90	User Defined 8	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CM	91	User Defined 9	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CN	92	User Defined 10	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
CO	93	Default Selling Unit of Measure	8	Character	No	Enter a valid default selling unit of measure for the product. This must be the same type of unit of measure as the unit of measure entered for the Product Unit of Measure field. This should be the unit of measure code, not the unit of measure's usage name. For information on setting up units of measure, see Unit of Measure Maintenance. If this field is blank, it defaults to the product unit of measure.
CP	94	Default Purchasing Unit of Measure	8	Character	No	Enter a valid default purchasing unit of measure for the product. This must be the same type of unit of measure as the unit of measure entered for the Product Unit of Measure field. This should be the unit of measure code, not the unit of measure's usage name. For information on setting up units of measure, see Unit of Measure Maintenance. If this field is blank, it defaults to the product unit of measure.
CQ	95	Default Display Unit of Measure	8	Character	No	Enter a valid default display unit of measure for the product. This must be the same type of unit of measure as the unit of measure entered for the Product Unit of Measure field. This should be the unit of measure code, not the unit of measure's usage name. For information on setting up units of measure, see Unit of Measure Maintenance. If this field is blank, it defaults to the product unit of measure.
CR	96	Primary Putaway Bin	20	Character	No	Enter an available bin into which the product will be put away. If this bin does not exist, the bin will be created. For information on setting up bins, see Bin Maintenance. Note Leave this field blank if the product is a kit.
CS	97	Primary Pick Bin	20	Character	No	Enter a primary pick bin for the product. You must enter an available bin from which products can be picked. If this bin does not exist, the bin will be created. For information on setting up bins, see Bin Maintenance. Note Leave this field blank if the product is a kit.
CT	98	Primary Backflush Bin	20	Character	No	Enter a valid primary backflush bin for the product. This bin must be a bin from which material can be issued, and which is not used for picking. If you enter a value in this field, the Must Backflush check box is selected for the product location in Product Location Maintenance. A backflush bin is not required for manufactured products. For more information on backflush bins, see Backflush Bin and Bin Maintenance. Note Leave this field blank if the product is a kit.
CU	99	Use Primary Pick Bin for All Bins	3	Yes/No	No	Enter Yes to use the bin defined for the Primary Pick Bin field as the default bin for picking and putting away, and as the default work order bin. If this field is blank, it defaults to No.
CV	100	Replenishment Path: Purchase	3	Yes/No	No	Enter Yes if the product can be replenished by purchasing directly from a supplier. Enter No if the product cannot be replenished by purchasing from a supplier. If this field is blank, it defaults to Yes.
CW	101	Replenishment Path: Transfer	3	Yes/No	No	Enter Yes if the product can be replenished by transferring it from another location. If this field is blank, it defaults to No.
CX	102	Replenishment Path: Build	3	Yes/No	No	Enter Yes if the product can be built (manufactured). If this field is blank, it defaults to No. Note You must enter Yes if the product is a kit.
CY	103	Hold Inventory for Backorders	3	Yes/No	No	Enter Yes to hold inventory of the product for backorders before releasing to new orders or No if you do not want to hold inventory for backorders. Example If a product has 0 available, 100 on backorder, and you receive 120, only 20 become available for new orders if this field is Yes. If inventory is not held for backorders, all 120 become immediately available for new orders and some backorders may end up not being released. Enter Yes if Yes is entered for the Not Stocked field. If this field is blank, this defaults from the product category entered for the Category field (position 9).
CZ	104	Allow Reallocation	3	Yes/No	No	Enter Yes to permit the product to be reallocated to other sales orders. This is useful for a product where demand exceeds supply and you need to ration the product to multiple customers until there is enough available supply. For more information, see Order Allocation Management. If this field is blank, this defaults from the product category entered for the Category field (position 9).
DA	105	Pick Bin Minimum Level	10	>>>>>>>>>9	No	Enter the minimum bin level of the product for the primary pick bin. This is the minimum number of units of the product that the specified pick bin should hold. Note This minimum is not used during replenishment. Replenishment uses the value entered in the Replenish Min column in the Selected U/M grid on the Units of Measure tab in Product Location Maintenance.
DB	106	Pick Bin Maximum Level	10	>>>>>>>>>9	No	Enter the maximum bin level of the product for the primary pick bin. This is the maximum number of units of the product that the specified pick bin should hold. Note This maximum is not used during replenishment. Replenishment uses the value entered in the Replenish Max column in the Selected U/M grid on the Units of Measure tab in Product Location Maintenance.
DC	107	Only Release Backorders Manually	3	Yes/No	No	Enter Yes to only allow backorders to be released in Product Backorder Allocate. If you enter Yes, batch and future inventory allocations cannot be used to release backorders for the product. If this field is blank, this defaults from the product category entered for the Category field (position 9).
DD	108	Seasonal Class	20	Character	No	Enter a seasonal class for the product. The seasonal class is used for demand forecasting and DRP. If you enter a seasonal class that does not already exist in the system, the seasonal class is created. For information on setting up seasonal classes, see Seasonal Class Maintenance.
DE	109	Primary Supplier Code	15	Character	Yes, only if Yes is entered for the Drop Ship Allowed field (position 64) and the Use Category Defaults field (position 218) is No or blank	Enter a valid supplier code for the primary supplier of the product. For information on setting up supplier codes, see Supplier Maintenance. Note A supplier product record is created only if you enter a value in this field and at least one supplier product field. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
DF	110	Supplier Product Code	20	Character	No	Enter the product code used by the supplier for the product. Example The product code for a product is 123 in Product Maintenance. Supplier ABC identifies the product as A314-B6. Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field (position 109).
DG	111	Supplier Product Description	60	Character	No	Enter the description used by the supplier for the product. Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field (position 109).
DH	112	Supplier Product Name	30	Character	No	Enter the name used by the supplier to identify the product. Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field (position 109).
DI	113	Supplier Product Delivery Rating	8	Character	No	Enter the delivery rating for the supplier. This rating is only used for reporting. Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field (position 109).
DJ	114	Supplier Product Quality Rating	8	Character	No	Enter the quality rating for the supplier. This rating is only used for reporting. Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field (position 109).
DK	115	Supplier Product Lead Time	8	>>>>>>>9	No	Enter the number of days between the purchase order date and the date the product is expected to be received (and available to be sold). This will be loaded into the supplier product record if a supplier is defined in the Primary Supplier Code field (position 109). If a supplier is not defined, then this field is loaded into the product for the location entered in the Location Prefix field (position 3). Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field.
DL	116	Minimum Purchase Quantity	14	>>>>>>>>9.99<<	No	Enter a minimum purchase order quantity if there is a minimum order quantity requirement for the product. This will be imported into the supplier product record if a supplier is defined in the Primary Supplier Code field (position 109). This field is imported into the product for the location entered in the Location Prefix field (position 3). (Entered in the default purchase unit of measure.) Example The product can only be ordered from this supplier if 25 cases or more are ordered. NOTE This cannot be less than the value entered for the Purchase Increment field (position 117). Note If there is a quantity entered, it is used in Purchase Order Maintenance. For information on how this field is used for DRP, see DRP - Suggested Planned Receipt FAQ. Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field.
DM	117	Purchase Increment	14	>>>>>>>>9.9999	No	Enter the supplier's purchase increment for the product. This will be imported into the supplier product record if a supplier is defined in the Primary Supplier Code field (position 109). This field is imported into the product for the location entered in the Location Prefix field (position 3). (Entered in the default purchase unit of measure.) Example The product can only be ordered in increments of 10 cases from this supplier. Note If there is a quantity entered, it is used in Purchase Order Maintenance. For information on how this field is used for DRP, see DRP - Suggested Planned Receipt FAQ. Note This field is used to create a supplier product record only if you enter a value for the Primary Supplier Code field.
DN	118	Putaway Group	30	Character	No	Enter a valid putaway group name for the product. Putaway groups are product groupings used during the product receipt and putaway process. For information on setting up putaway groups, see Putaway Group Maintenance.
DO	119	Product Style	12	Character	No	Enter a valid style for the product. For information on setting up product styles, see Style Maintenance.
DP	120	Sales Order Minimum	6	>>>>>9	No	Enter the minimum order quantity allowed to be entered during sales order entry for the product (in the stock, or lowest, level unit of measure). $Images\warning.gif$ When setting up order minimums and order multiples, be careful if the product has multiple units of measure defined so that expected results are achieved. Note If there is an order multiple value entered for the Sales Order Multiple field, the order minimum must be specified in that order multiple value. For example, if an order multiple is 4 each, then the order minimum must be a multiple of 4, such as 4, 8, or 12. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
DQ	121	Sales Order Multiple	6	>>>>>9	No	Enter the order quantity multiple allowed to be entered during sales order entry (in the stock, or lowest, level unit of measure). $Images\warning.gif$ When setting up order minimums and order multiples, be careful if the product has multiple units of measure defined so that expected results are achieved. Example A product has a stock, or lowest, unit of measure of each, an inner pack consisting of 3 eaches unit of measure, and a master carton consisting of 30 eaches. The order minimum was set up as 6 eaches and the order multiple was set up as 4 eaches. If an order is entered for 2 inner packs, it has met the minimum requirement (6), but not the multiple (6 is not evenly divisible by 4). So, it would either warn the user or round down (for information on specifying how this situation is handled, see Customer Service Control Maintenance). If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
DR	122	Perform Sanity Check on Product Cost	3	Yes/No	No	Enter Yes if you want the system to display a warning when a product cost is manually entered in Purchase Order Maintenance that varies from the most recent purchase order product cost from the same supplier by a given cost variance percentage. Enter No if you do not want to perform the check on the product cost. If you enter Yes, enter the cost variance percentage in the Cost Variance Percentage field. If this field is blank, this defaults from the product category entered for the Category field (position 9).
DS	123	Cost Variance Percentage	9	>>>>>9.99	No	Enter a cost variance percentage if Yes is entered for the Perform Sanity Check on Product Cost field. The cost variance percentage entered in this field is used in performing the sanity check against a cost assigned to a product. If No is entered for the Perform Sanity Check on Product Cost field, this will be imported as zero (regardless of what is entered here). If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
DT	124	Break-to Unit of Measure	8	Character	No	If units of measure for the product can be broken down to a smaller unit of measure, enter a valid smaller unit of measure. This must be a valid unit of measure for the product. This unit of measure must be smaller than and must be a factor of at least one other unit of measure for the product. This unit of measure is only set as the break-to unit of measure for units of measure of the product that are larger than and evenly divisible by this unit of measure. For information on units of measure, see Unit of Measure Maintenance.
DU	125	ABC Product Class	1	Character	No	Enter a letter to represent the product class. This field is used in conjunction with paper-based cycle counting. Enter A for this field for high-value products that can be selected for cycle counting. You must enter one of the following values: A, B, C, or X.
DV	126	NMFC Number	16	Character	No	Enter the National Motor Freight Classification (NMFC) number used for bill of lading printing. For more information, see National Motor Freight Classification Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
DW	127	Package Unit of Measure	8	Character	No	Enter a valid package unit of measure for the product. This unit of measure is used in package building determination. Example Some products, such as refrigerators, come in a box from a vendor that is already a packaged unit of measure, and the UCC128 label is placed on the box. When you set up a package unit of measure, you are specifying the packages to create automatically for pick demand confirmation. A pallet of refrigerators has labels on each box, so if you are shipping a pallet, you still make packages in terms of 1 each refrigerator.
DX	128	Product Status	12	Character	No	Enter a valid product status code for the product. For information on setting up product status codes, see Product Status Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
DY	129	Color Code	8	Character	No	Enter a valid color code for the product. For information on setting up color codes, see Color Maintenance.
DZ	130	Size Code	8	Character	No	Enter a valid size code for the product. For information on setting up size codes, see Size Maintenance.
EA	131	Royalty Class	12	Character	No	Enter a valid royalty class for the product if it is part of a royalty arrangement. For information on setting up royalty classes, see Royalty Class Maintenance.
EB	132	Active	3	Yes/No	No	Enter Yes if the product is currently active or No if the product is not active. If this field is blank, it defaults to Yes. Note If you enter No, users can still enter sales orders and purchase orders for the product. However, the product will not be available for selection in the Lookup window.
EC	133	Returns	29	Character	No	Enter all or part of the returns general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on returns general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
ED	134	Sales Discount	29	Character	No	Enter all or part of the sales discount general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on sales discount general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
EE	135	Returns Discount	29	Character	No	Enter all or part of the returns discount general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on returns discount general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
EF	136	Cost of Goods Sold Returned	29	Character	No	Enter all or part of the cost of goods sold returned general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on cost of goods sold returned general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. If this field is left blank, the associated account will be retrieved from the supplied category. If the category account is invalid, the import will not work.
EG	137	Companion Classes		Character	No	Enter the product's companion classes separated by a \| character if another product is sold as a companion of this product. For information on setting up companion classes, see Companion Class Maintenance. EXAMPLE ClassA\|ClassB\|ClassC
EH	138	Replenishment Location Prefix	3	Character	Yes, only if Yes is entered for the Replenishment Path: Transfer field (position 101).	Enter a valid transfer location prefix for the product if the product is replenished by transfer order. For information on setting up locations, see Location Maintenance.
EI	139	Forecast Transfer Rule	8	Character	Yes, only if Yes is entered for the Replenishment Path: Transfer field (position 101).	Enter one of the following values to specify whether transfer orders initiated for this product location are used to update sales demand for DRP. Sale - This option updates sales demand when the transfer order is prepped in Invoice Create and Print (this is not the typical scenario). Transfer - This option does not update sales demand for transfer orders; the sales demand will ultimately happen when the product is sold from the location to which it was transferred (this is the typical scenario). Example Location B is a warehouse and location A is a retail outlet. Product is transferred from location B to location A. Location A has its own POS system for dealing with the retail public. Once a month, a physical inventory is done to adjust the inventory levels at location A. Location A is set up with Sale selected for the Forecast Transfer Rule field. Whenever product is transferred into location A (from any other location), the quantity transferred is added to the sales demand of the transfer-from location.
EJ	140	GTIN	14	Character	No	Enter the GTIN for the product. This is the number that will be used for Electronic Product Code (EPC) and RFID requirements. This number must be 14 characters. Prefix it with zeros if necessary. Leave this field blank if your system is set up to automatically generate GTIN's.
EK	141	Discontinued Date	10	MM/DD/YYYY	No	Enter the discontinued date if the product is discontinued. Only enter a value for this field if you enter Yes for the Discontinued field.
EL	142	Primary Replenishment Path	8	Character	No	Enter the default replenishment path for the product (and location) for DRP. You can enter one of the following: Purchase - For DRP, the product is primarily replenished by purchasing directly from a supplier. Transfer - For DRP, the product is primarily replenished by transferring it from another location. Build - For DRP, the product is a bill of material product and is primarily replenished by creating work orders. If this field is blank, it defaults to Purchase.
EM	143	Recount Variance Percentage	4	>>>9	No	Enter the recount variance percentage. This field is used in conjunction with Wireless Warehouse Cycle Counting.
EN	144	Recount Variance Amount	8	>>>>>>>9	No	Enter a recount variance amount. This field is used in conjunction with Wireless Warehouse Cycle Counting.
EO	145	Recount Required	3	Yes/No	No	Enter Yes to require a recount. This is used in conjunction with Wireless Warehouse Cycle Counting. A recount is only required if this is Yes and a recount variance amount or percentage is entered. If this field is blank, it defaults to No.
EP	146	Count Display	7	Character	No	Enter one of the following count display values: Blank, Visible, or Blind. This field is used in conjunction with Wireless Warehouse Cycle Counting. If this field is blank, it defaults to Blank.
EQ	147	Recount Display	7	Character	No	Enter one of the following recount display values: Blank, Visible, or Blind. This field is used in conjunction with Wireless Warehouse Cycle Counting. If this field is blank, it defaults to Blank.
ER	148	Cycle Class Code	12	Character	No	Enter a valid cycle class code for the product. The cycle class code is used to group together similar products and locations for Wireless Warehouse cycle counting. For information on setting up cycle class codes, see Product Cycle Count Class Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
ES	149					Leave this field blank.
ET	150	Do Not Reclassify	3	Yes/No	No	Enter Yes to not allow the automatic reclassification of the cycle class code when running product cycle count reclassification. If this field is blank, it defaults to No.
EU	151	Label Format	40	Character	No	Enter the label format on the product unit of measure. This is the format of the receiving label for this unit of measure. For more information, see Receiving Labels Print. Note To print receiving labels, this must match a label format set up in External Interface Maintenance.
EV	152	Can be Packaged	3	Yes/No	No	Enter Yes if the product unit of measure can be packaged into other larger packages for picking cartonization. If this field is blank, it defaults to No.
EW	153	Catch Weight Variance	29	Character	No	Enter all or part of the catch weight variance general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on catch weight variance general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
EX	154	Lot Expiration	29	Character	No	Enter all or part of the lot expiration general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on lot expiration general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
EY	155	Catch Weight Product	3	Yes/No	No	Enter Yes if the product is a random weight. You cannot enter Yes if the product is a kit or a service product. Catch weight products must be tracked by lot or serial number. If this field is blank, this defaults from the product category entered for the Category field (position 9).
EZ	156	User Defined 11	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FA	157	User Defined 12	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FB	158	User Defined 13	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FC	159	User Defined 14	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FD	160	User Defined 15	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FE	161	User Defined 16	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FF	162	User Defined 17	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FG	163	User Defined 18	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FH	164	User Defined 19	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FI	165	User Defined 20	400	Character, Date, Decimal, Integer, or Logical	No	Enter the appropriate user-defined information for the product. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.
FJ	166	Catch Weight Sanity Over Amount	10	>>>>>>9.99	No	Enter the acceptable maximum variance amount over the gross packaged weight for a catch weight product. Entering a variance amount prevents users from receiving or confirming pick demands for products with excessive weight. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
FK	167	Catch Weight Sanity Under Amount	10	>>>>>>9.99	No	Enter the acceptable maximum variance amount under the gross packaged weight for a catch weight product. Entering a variance amount prevents users from receiving or confirming pick demands for products that are underweight. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
FL	168	Catch Weight Sanity Over Percent	6	>>9.99	No	Enter the acceptable maximum variance percentage over the gross packaged weight for a catch weight product. Entering a variance percentage prevents users from receiving or confirming pick demands for products with excessive weight. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
FM	169	Catch Weight Sanity Under Percent	6	>>9.99	No	Enter the acceptable maximum variance percentage under the gross packaged weight for a catch weight product. Entering a variance percentage prevents users from receiving or confirming pick demands for products that are underweight. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
FN	170	Density	10	>>>>>>9.99	No	Enter the density of the product. Density is the ratio of mass per volume.
FO	171	Density Mass Basis	8	Character	No	Enter a valid unit of measure (basis) for the mass.
FP	172	Dimensional Unit of Measure	8	Character	No	Enter a valid unit of measure used for height, length, and width dimensions of the specific unit of measure of the product.
FQ	173	Cube (Unit of Measure)	11	>>>,>>9.9999	No	Enter a valid cube (volume) unit of measure of the specific unit of measure of the product.
FR	174	Cube Unit of Measure	8	Character	No	Enter a valid volume unit of measure for the specific unit of measure of the product.
FS	175	Break to Unit of Measure	8	Character	No	If the product's base unit of measure can be broken down into a smaller unit of measure (or assembled up to a larger unit of measure), enter the unit of measure. This must be a valid unit of measure. If this field is blank, it is assumed that the base unit of measure cannot be broken down (or assembled up).
FT	176	Country of Origin	10	Character	No	Enter a valid country code for the product's country of origin. For information on setting up country codes, see Country Maintenance.
FU	177	Bookings Class	12	Character	No	Enter a valid bookings class for the product. For information on setting up bookings classes, see Bookings Class Maintenance.
FV	178	Default Receipt (Unit of Measure)	8	Character	No	Enter a valid default receipt unit of measure for the product. This must be the same type of unit of measure as the unit of measure entered for the Product Unit of Measure field.
FW	179	Web (Unit of Measure)	8	Character	No	Enter a valid unit of measure in which the product is available for customer portal sites. This must be the same type of unit of measure as the unit of measure entered for the Product Unit of Measure field. If this field is blank, the product unit of measure is marked as a Web unit of measure.
FX	180	Include On Order Quantity in Order Entry Discontinued Validation	3	Yes/No	No	Enter Yes if you want to include the on order quantity in the order validation that occurs for discontinued products during order entry. If you enter No, the validation only allows users to order a discontinued product if the sum of the available quantity and any applicable inventory reservations is greater than the ordered quantity. If you enter Yes, the on order quantity is added to the sum of the available quantity and inventory reservations and may allow the discontinued product to be ordered. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
FY	181	Production Monitoring Class	20	Character	No	Enter a valid supplier production monitoring class for the product. You can use supplier production monitoring classes to group products for supplier production monitoring rules. For information on setting up supplier production monitoring classes, see Monitoring Class Maintenance. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
FZ	182	Profit Category Code Sales (Customer)	12	Character	No	Enter a valid customer scorecard profit category code for sales for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.
GA	183	Profit Subcategory Code Sales (Customer)	12	Character	No	Enter a valid customer scorecard profit subcategory code for sales for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.
GB	184	Profit Category Code Cost (Customer)	12	Character	No	Enter a valid customer scorecard profit category code for costs for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.
GC	185	Profit Subcategory Code Cost (Customer)	12	Character	No	Enter a valid customer scorecard profit subcategory code for costs for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.
GD	186	Profit Category Code Sales (Supplier)	12	Character	No	Enter a valid supplier scorecard profit category code for sales for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.
GE	187	Profit Subcategory Code Sales (Supplier)	12	Character	No	Enter a valid supplier scorecard profit subcategory code for sales for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.
GF	188	Profit Category Code Cost (Supplier)	12	Character	No	Enter a valid supplier scorecard profit category code for costs for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.
GG	189	Profit Subcategory Code Cost (Supplier)	12	Character	No	Enter a valid supplier scorecard profit subcategory code for costs for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.
GH	190	Profit Category Code Sales (Product)	12	Character	No	Enter a valid product scorecard profit category code for sales for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.
GI	191	Profit Subcategory Code Sales (Product)	12	Character	No	Enter a valid product scorecard profit subcategory code for sales for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.
GJ	192	Profit Category Code Cost (Product)	12	Character	No	Enter a valid product scorecard profit category code for costs for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.
GK	193	Profit Subcategory Code Cost (Product)	12	Character	No	Enter a valid product scorecard profit subcategory code for costs for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.
GL	194	Profit Group	12	Character	Yes, only if the Profit Group is required for products check box is selected in Scorecard Control Maintenance	Enter a valid scorecard profit group code for the product. For information on setting up scorecard profit group codes, see Scorecard Profit Group Maintenance.
GM	195	Input VAT Clearing	29	Character	No	Enter all or part of the input VAT clearing general ledger account to use when resolving the account from the product. For more information on input VAT clearing accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
GN	196	Input VAT	29	Character	No	Enter all or part of the input VAT general ledger account to use when resolving the account from the product. For more information on input VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
GO	197	Input VAT Write-off	29	Character	No	Enter all or part of the input VAT write-off general ledger account to use when resolving the account from the product. For more information on input VAT write-off accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
GP	198	Input VAT Pending	29	Character	No	Enter all or part of the input VAT pending general ledger account to use when resolving the account from the product. For more information on input VAT pending accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
GQ	199	Output VAT	29	Character	No	Enter all or part of the output VAT general ledger account to use when resolving the account from the product. For more information on output VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
GR	200	Output VAT Variance	29	Character	No	Enter all or part of the output VAT variance general ledger account to use when resolving the account from the product. For more information on output VAT variance accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
GS	201	Price Includes VAT	3	Yes/No	No	Enter Yes if the price for the product includes VAT. If this field is blank, it defaults to No. Note This field is not used for configuration kits.
GT	202	Country 1	10	Character	Yes, only if you enter a VAT class code in the VAT Class Code 1 field or a VAT exempt reason code in the VAT Exempt Reason Code 1 field	Enter a valid country code for which you want to enter VAT information for the product. For information on setting up countries, see Country Maintenance. Note You can set up VAT information for two countries in a single row in the import file.
GU	203	VAT Class Code 1	20	Character	No	Enter a valid VAT class code associated with the country entered in the Country 1 field for the product. For information on setting up VAT class codes, see VAT Class Maintenance.
GV	204	VAT Exempt Reason Code 1	20	Character	No	Enter a valid VAT exempt reason code to explain why orders for the country entered in the Country 1 field are exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.
GW	205	Country 2	10	Character	Yes, only if you enter a VAT class code in the VAT Class Code 2 field or a VAT exempt reason code in the VAT Exempt Reason Code 2 field	Enter a valid country code for which you want to enter VAT information for the product. For information on setting up countries, see Country Maintenance. Note You can set up VAT information for two countries in a single row in the import file.
GX	206	VAT Class Code 2	20	Character	No	Enter a valid VAT class code associated with the country entered in the Country 2 field for the product. For information on setting up VAT class codes, see VAT Class Maintenance.
GY	207	VAT Exempt Reason Code 2	20	Character	No	Enter a valid VAT exempt reason code to explain why orders for the country entered in the Country 2 field are exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.
GZ	208	Product Scan	7	Character	No	Enter one of the following options: Default - Require or do not require users to validate (scan) the product for Wireless Warehouse picking based on whether the Product check box is selected for picking in Zone Task Options. Yes - Require users to scan the product for Wireless Warehouse picking. If you select this option, it overrides the Product check box in Zone Task Options. No - Do not require users to scan the product for Wireless Warehouse picking. If you select this option, it overrides the selected Product check box option in Zone Task Options. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
HA	209	Quantity Scan	7	Character	No	Enter one of the following options: Default - Require users to scan or enter product quantities for Wireless Warehouse picking based on the Quantity Scan option selected for picking in Zone Task Options. Each - Require users to scan every product, one at a time, and keep track of the count during Wireless Warehouse picking. If you select this option, it overrides the selected Quantity Scan option in Zone Task Options. Example If you select this option and a user is picking 15 cases, the user must scan each case (15 scans). Qty - Require users to enter quantities manually during Wireless Warehouse picking. If you select this option, it overrides the selected Quantity Scan option in Zone Task Options. If this field is blank, and Yes is entered for the Use Category Defaults field (position 218), this defaults from the product category entered for the Category field (position 9).
HB	210	Sales Tax Code	20	Character	No	Enter the appropriate and unique Avalara tax code for the product, which determines the applicable tax rules and rates for the transaction. This field is only used when the system is integrated with AvaTax. For more information, see AvaTax Interface FAQ.
HC	211	VAT Exempt 1	3	Yes/No	No	Enter Yes if the product is exempt from VAT for the country entered for the Country 1 field.
HD	212	VAT Exempt 2	3	Yes/No	No	Enter Yes if the product is exempt from VAT for the country entered for the Country 2 field.
HE	213	Do Not Pick X Days Before Lot Expiration	3	>>9	No	Enter the number of days before the lot expiration date that picking for the product should not occur. This is only used for lot-tracked products. Importing this value sets up a default lot shipping rule for all customers.
HF	214	Allow Samples	3	Yes/No	No	Enter Yes if the product can be entered as a line item on sample orders.
HG	215	Sample Frequency Days	4	>>>9	No	Enter the number of days a customer must wait after receiving a sample of the product before the customer can receive a sample of the product again. If this is 0, there is no limit to how often the customer can receive a sample of the product. The frequency can be overridden by the sample frequency days entered for specific sample reason codes.
HH	216	Beverage Bottle Size	11	>>>>>9.99<<	No	If the product is a beverage product, enter the size of the bottle in the unit of measure entered for the Beverage Bottle Size Unit of Measure field (position 217).
HI	217	Beverage Bottle Size Unit of Measure	8	Character	Yes, if a value is entered for the Beverage Bottle Size field (position 216)	If the product is a beverage product, enter a valid volume unit of measure of the bottle size entered for the Beverage Bottle Size field (position 216).
HJ	218	Use Category Defaults	3	Yes/No	No	Enter Yes if you want product category settings to be used as default settings for the product.
HK	219	Work in Process - Material	29	Character	No	Enter all or part of the material work in process general ledger account to use when resolving the account from the product. For more information on material work in process accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HL	220	Work in Process - Labor	29	Character	No	Enter all or part of the labor work in process general ledger account to use when resolving the account from the product. For more information on labor work in process accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HM	221	Work in Process - Outside Processing	29	Character	No	Enter all or part of the outside processing work in process general ledger account to use when resolving the account from the product. For more information on outside processing work in process accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HN	222	Work in Process - Overhead	29	Character	No	Enter all or part of the overhead work in process general ledger account to use when resolving the account from the product. For more information on overhead work in process accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HO	223	Scrap Expenses	29	Character	No	Enter all or part of the scrap expenses general ledger account to use when resolving the account from the product. For more information on scrap expenses accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HP	224	Inventory (Manufacturing)	29	Character	No	Enter all or part of the inventory general ledger account to use when resolving the account from the product for manufacturing. For more information on inventory accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HQ	225	Variance - Labor	29	Character	No	Enter all or part of the variance labor general ledger account to use when resolving the account from the product. For more information on variance labor accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HR	226	Variance - Outside Processing	29	Character	No	Enter all or part of the variance outside processing general ledger account to use when resolving the account from the product. For more information on variance outside processing accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HS	227	Variance - Overhead	29	Character	No	Enter all or part of the variance overhead general ledger account to use when resolving the account from the product. For more information on variance overhead accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HT	228	Absorbed - Labor	29	Character	No	Enter all or part of the absorbed labor general ledger account to use when resolving the account from the product. For more information on absorbed labor accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HU	229	Absorbed - Outside Processing	29	Character	No	Enter all or part of the absorbed outside processing general ledger account to use when resolving the account from the product. For more information on absorbed outside processing accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HV	230	Absorbed - Overhead	29	Character	No	Enter all or part of the absorbed overhead general ledger account to use when resolving the account from the product. For more information on absorbed overhead accounts, see Manufacturing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HW	231	Allocation Minimum	10	>>>,>>9.99	No	Enter the minimum quantity that can be allocated for the product in the selling default unit of measure. This can be overridden by the allocation minimum value entered for the product in Product Location Maintenance and Customer Product Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance. Note If there is an allocation multiple value entered for the Allocation Multiple field, the allocation minimum must be specified in that allocation multiple value. For example, if an allocation multiple is 4 each, then the allocation minimum must be multiple of 4, such as 4, 8, or 12. The allocation minimum must be less than or equal to the order minimum value entered for the Sales Order Minimum field.
HX	232	Allocation Multiple	10	>>>,>>9.99	No	Enter a value of which a multiple can be allocated for the product in the selling default unit of measure. This can be overridden by the multiple allocation value entered for the product in Product Location Maintenance and Customer Product Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance.
HY	233	Drop Ship In Transit	29	Character	No	Enter all or part of the drop-ship in transit general ledger account to use when resolving the account from the product. The account must be unformatted (no hyphens, periods, etc.). For more information on drop-ship in transit general ledger accounts, see General Ledger Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the product. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
HZ	234	Restricted Allocation	3	Yes/No	No	Enter Yes to automatically put all sales order line items for the product on backorder even if inventory is available. This ensures that allocation of the product is monitored.
IA	235	Excise Tax Category	20	Character	No	If the product is subject to excise tax, enter a valid excise tax category for the product. For information on setting up excise tax categories, see Excise Tax Category Maintenance.
IB	236	Alcohol Content	8	>>9.9999	No	If the product is a beverage, enter the alcohol content of the product. This is used in conjunction with excise tax category rules to control reporting.
IC	237	Warehouse Product Code	40	Character	No	Enter a warehouse product code for the product/location. This is used if a third-party warehouse uses a different product code for the product.
ID	238	Warehouse Product Name	40	Character	No	Enter a warehouse product name for the product/location. This is used if a third-party warehouse uses a different product name for the product.
IE	239	Ship and Debit Account Mask	29	Character	No	Enter a ship and debit account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default. For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.
IF	240	Ship and Debit Variance Account Mask	29	Character	No	Enter a ship and debit variance account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default. For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.
IG	241	Ship and Debit Amount 1	14	>>>,>>>,>>9.99	No	Enter a default ship and debit amount for the first list price.
IH	242	Free Goods Billback Percent 1	6	999.99	No	Enter a percentage of cost to bill back to the supplier if the product is shipped free of charge to a customer for the first list price.
II	243	Ship and Debit Amount 2	14	>>>,>>>,>>9.99	No	Enter a default ship and debit amount for the second list price.
IJ	244	Free Goods Billback Percent 2	6	999.99	No	Enter a percentage of cost to bill back to the supplier if the product is shipped free of charge to a customer for the second list price.
IK	245	Ship and Debit Amount 3	14	>>>,>>>,>>9.99	No	Enter a default ship and debit amount for the third list price.
IL	246	Free Goods Billback Percent 3	6	999.99	No	Enter a percentage of cost to bill back to the supplier if the product is shipped free of charge to a customer for the third list price.
IM	247	Ship and Debit Amount 4	14	>>>,>>>,>>9.99	No	Enter a default ship and debit amount for the fourth list price.
IN	248	Free Goods Billback Percent 4	6	999.99	No	Enter a percentage of cost to bill back to the supplier if the product is shipped free of charge to a customer for the fourth list price.
IO	249	Default Web Unit of Measure	8	Character	No	Enter a valid unit of measure that is the default unit of measure for customer portal sites. This unit of measure must be a web unit of measure for the product.
IP	250	Commission Cost Charge Type	12	Character	No	Enter a drop-ship commission additional charge type to use for the product on drop-ship commission orders for which commissions are based on costs. For more information, see Drop-Ship Commission Orders FAQ. For information on setting up additional charge types, see Order Entry Additional Charge Maintenance.
IQ	251	Bill and Hold Clearing	29	Character	No	Enter a bill and hold clearing account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default. For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.
IR	252	Bill and Hold Variance	29	Character	No	Enter a bill and hold variance account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default. For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.
IS	253	CAD Image	255	Character	No	Enter the path and file name for a CAD image file for the product. The path must be a local system path.
IT	254	DRP Product Class Code	10	Character	No	Enter a valid active DRP product class for the product. For information on setting up DRP product classes, see DRP Product Class Maintenance.
IU	255	Exclude from Goal Seeking	3	Yes/No	No	Enter Yes if you do not want the product to be included in goal seek calculations. If you enter Yes, the product will not appear in the Purchase Details grid on the Purchase tab in Summary DRP Management or in output production forecast spreadsheets. For information on goal seek, see Using Goal Seek. Enter No if you want the product to be included in goal seek calculations.
IV	256	Must Use Primary Work Order Bin	3	Yes/No	No	Enter Yes if you only want allocations of the product for material issues to come from the primary work order bin. Enter No if you want product to first be allocated from the primary work order bin, and then use other bins for allocation if additional quantities are required. If this field is blank, it defaults to No.
IW	257	Primary Work Order Bin	20	Character	No	Enter a valid primary bin that is used to allocate the product as a component for material issues. For information on setting up bins, see Bin Maintenance.
IX	258	Single-single Line Carton Code	15	Character	No	Enter the carton code associated with the product. This carton code contains the package dimension information required to pack a single base unit of measure of the product.

Prerequisites

Before using this import, the following must be set up:

product categories

Import Format Notes

All general ledger accounts are validated against existing accounts. If there are no existing accounts that partially or completely match the account, you will receive an error in the import error log.
Min-Max Buying Recommendations only includes products with a buying method of Min-Max. If you will be importing data from Demand Forecasting Import to create purchase orders, you may enter either Min-Max or Demand Forecasting.
Default selling, purchasing, and display units of measure should be imported with the unit of measure code (8 characters), not their usage name (4 characters). If any are left blank, the product unit of measure imported earlier (from Column H) is used by default. Units of measure are defined and maintained in Unit of Measure Maintenance.
All imports are based on the stocking unit of measure.

NOTE To acquire a thorough understanding of the fields and buttons required for creating a product/location record, see Product Maintenance or Product Location Maintenance. The two windows are equivalent with the exception of location-specific fields and buttons defined in Product Location Maintenance.

There must be a record of blank space(s) at the end of an import file.