Product Change Import Format
NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for changing a record in Product Change Import.
|
Product Code |
Field Key (see table below) |
Location Prefix (required only if you enter B, L, or X for the field key) |
Field Value Name or Number (see table below) |
New Value |
Unit of Measure (required only if you are updating unit of measure information; see table below) |
Note Leave the third field blank if you are importing using P as the field key. Leave the sixth field blank if it is not required.
The list of available fields below includes field keys for each field. If the field key is P you can only import using a P. If the field key is L you can run the import with either an L or an X. If the field key is a B you can use any of the four key data values depending on what you would like to import. For more information on field keys, see Product Change Import.
Example You import from a text file that includes the following: 110010040^B^All^15800^Ignore^Each
This reads: Product code 110010040 with a field key of B is being changed for All locations. The field number that is being changed is 15800, which corresponds to the field value name of Margin-action. The new value for this field is Ignore. The unit of measure is Each (the base unit of measure in this example).
The field key B was found in the format table below under Margin-action. For this change, field keys L or P cannot be used.
The following table lists fields that can be updated. You can indicate a field by either its value name or its number.
|
Field Key |
Value Name |
Number |
Unit of Measure Required |
Maximum Length |
Format |
Description |
Apprise Field |
|
B |
Accounting-Cost |
10100 |
No |
8 |
Character |
Enter the product's accounting cost basis. You must enter one of the following:
This field is not used for kit and service products. |
Accounting Cost field on the Cost tab in Product Maintenance and Product Location Maintenance |
|
B |
Allocate-days |
10200 |
No |
4 |
9999 |
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. |
Allocate X Business Days before Required Date field on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
P |
Search-name |
10300 |
No |
20 |
Character |
Enter a search name for the product. The search name is used as another search criterion in Lookup windows for rapid selection. |
Search Name field on the General tab in Product Maintenance |
|
L |
Auto-lead-time |
10400 |
No |
3 |
Yes/No |
Enter YES if you want to automatically update the lead time for the product location or NO if you do not want to automatically update the lead time. |
Auto Update check box on the Buying tab in Product Location Maintenance |
|
L |
Backflush-bin |
10500 |
No |
20 |
Character |
Enter a valid primary backflush bin for the product location. For more information on backflush bins, see Backflush Bin and Bin Maintenance. |
Primary Backflush Bin field on the Warehouse tab in Product Location Maintenance |
|
L |
Begin-yr-cost |
10600 |
No |
11 |
>>>>>>>9.99 |
Enter the beginning year cost of the product location. This cost is used for specialized LIFO layer calculations. This field is not used for kit and service products. |
Beginning Year Cost field on the Cost tab in Product Location Maintenance |
|
L |
Bin-min-level |
10700 |
No |
9 |
>>>>>>>>9 |
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. |
Pick Bin Min. Level field on the Warehouse tab in Product Location Maintenance |
|
|
|
|
|
|
|
|
|
|
B |
Release-bo-manual |
11000 |
No |
3 |
Yes/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. |
Only Release Backorders Manually field on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
Burden-Cost |
11100 |
No |
12 |
>>>>>>>>9.99 |
Enter the burden cost of the product for the product unit of measure. For more information, see cost basis. |
Burden Cost field on the Cost tab in Product Maintenance and Product Location Maintenance |
|
B |
Buying-Method |
11200 |
No |
20 |
Character |
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. |
Buying Method field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
L |
Build |
11300 |
No |
3 |
Yes/No |
Enter Yes if the product can be built (manufactured). Enter No if the product cannot be built. Note Enter Yes if the product is a kit. |
Build check box on the Buying tab in Product Location Maintenance |
|
L |
Location |
11400 |
No |
3 |
Yes/No |
Enter Yes if the product can be replenished by transferring it from another location. Enter No if the product is not replenished from another location. |
Transfer check box on the Buying tab in Product Location Maintenance |
|
L |
Supplier |
11500 |
No |
3 |
Yes/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. |
Purchase check box on the Buying tab in Product Location Maintenance |
|
B |
Can-be-sold |
11600 |
No |
3 |
Yes/No |
Enter Yes to allow the product to be sold regardless of what quantity is available in inventory. During order processing, the system verifies if the product can be sold by the selling and shipping locations. Enter No if the product cannot be entered on a sales order. |
Can Be Sold check box on the Status tab in Product Maintenance and the Warehouse tab in Product Location Maintenance |
|
P |
Catalog-page |
11700 |
No |
8 |
Character |
Enter the catalog page on which the product is displayed if your company's products are catalogued. |
Catalog Page field on the Selling tab in Product Maintenance |
|
P |
Category |
11800 |
No |
12 |
Character |
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. If the category is changed, the subcategory is set to blank. If the subcategory is required, then it must be imported. NOTE If you change the category of a product, it is changed in associated records (e.g., goals, sales orders, purchase orders, etc.). |
Category field on the General tab in Product Maintenance |
|
P |
Cogs-account |
11900 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Cost of Goods Sold field on the Accounts tab in Product Maintenance |
|
B |
Comm-class |
12000 |
No |
12 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Commission Class field on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
Comm-cost-basis |
12100 |
No |
11 |
Character |
Enter the product's commission cost basis. The commission cost basis is used for gross margin determination for commission reporting. You can enter one of the following:
This field is not used for kit and service products. |
Commission Cost field on the Cost tab in Product Maintenance and Product Location Maintenance |
|
B |
Co-op-amount |
12200 |
No |
12 |
>>>>>>>>9.99 |
Enter the product's co-op amount. The amount represents a monetary amount or a percentage based on how the product is set up. |
Co-Op Amount field on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
Co-op |
12300 |
No |
3 |
Yes/No |
Enter Yes if the product is considered a co-op product. Enter No if the product is not a co-op product. For more information, see Co-Op Year Maintenance and Co-op Sales Process Flow. |
Co-Op Product check box on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
Co-op-type |
12400 |
No |
15 |
Character |
Enter one of the following to indicate if the co-op is calculated based on an amount per unit or percentage:
|
Amount Per Unit and Percent radio buttons on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
Cost-class |
12500 |
No |
10 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Cost Class field on the Buying tab in Product Maintenance and the Cost tab in Product Location Maintenance |
|
L |
Cross-dock |
12600 |
No |
3 |
Yes/No |
Enter Yes if the default putaway bin during purchase order receiving is the cross-dock bin for the dock if the product has backorders. If you enter Yes, the product can be received on to the dock for filling backorders. |
Cross Dock Allowed check box on the Warehouse tab in Product Location Maintenance |
|
P |
Volume |
12700 |
No |
10 |
>>>>>>9.99 |
Enter the volume of the product. This must be entered in the volume unit of measure. |
Volume field on the Warehouse tab in Product Maintenance |
|
P |
Volume-um |
12800 |
No |
8 |
Character |
Enter a valid volume unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
field to the right of the Volume field on the Warehouse tab in Product Maintenance |
|
|
|
|
|
|
|
|
|
|
P |
lot-life |
13000 |
No |
5 |
>>>>9 |
If the product is lot tracked, enter the default number of days after which a lot expires. |
Lot Life field on the Warehouse tab in Product Maintenance |
|
P |
Desc |
13100 |
No |
30 |
Character |
Enter a short description of the product. This description can be used for searching by product. |
Description field on the General tab in Product Maintenance |
|
B |
Discontinued |
13200 |
No |
3 |
Yes/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. |
Discontinued check box on the Status tab in Product Maintenance and the Warehouse tab in Product Location Maintenance |
|
P |
Display-oe |
13300 |
No |
3 |
Yes/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. |
Display on Order Entry Lookup check box on the Status tab in Product Maintenance |
|
P |
display-po |
13400 |
No |
3 |
Yes/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. |
Display on Purchase Order Lookup check box on the Status tab in Product Maintenance |
|
B |
Drop-ship |
13500 |
No |
3 |
Yes/No |
Enter Yes if the product can be drop shipped to customers. Note You cannot enter Yes for a product that is a kit or that is a catch weight product. If you enter Yes, the supplier must be entered in a previous line or import. |
Drop Ship Allowed check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
P |
DS-exp-acct |
13600 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Drop Ship Cost of Goods Sold field on the Accounts tab in Product Maintenance |
|
P |
DS-sales-acct |
13700 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Drop Ship Sales field on the Accounts tab in Product Maintenance |
|
P |
Stock-adj-acct |
13800 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Adjustments Expense field on the Accounts tab in Product Maintenance |
|
P |
Returns-exp-acct |
13900 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Returns Expense field on the Accounts tab in Product Maintenance |
|
P |
Family |
14000 |
No |
10 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. Note This field is not used for configuration kits. |
Family Price Code field on the Pricing tab in Product Maintenance |
|
P |
Harmonization |
14100 |
No |
12 |
Character |
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. Harmonization codes are defined and maintained in Harmonization Code Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Harmonization Codes grid on the Buying tab in Product Maintenance |
|
P |
Hazard-code |
14200 |
No |
12 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Hazard Code field on the Warehouse tab in Product Maintenance |
|
B |
Hold-bo-inv |
14300 |
No |
3 |
Yes/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. This must be Yes if the product is not stocked. |
Hold Inventory for Backorders check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
P |
image-file-1 |
14400 |
No |
255 |
Character |
Enter the folder path and file name for the product's first image file. |
Image File 1 field on the General tab in Product Maintenance NOTE You can enter the label for this field in the Product Image Label 1 field in Warehouse Management Control Maintenance. |
|
P |
image-file-2 |
14500 |
No |
255 |
Character |
Enter the folder path and file name for the product's second image file. |
Image File 2 field on the Selling tab in Product Maintenance NOTE You can enter the label for this field in the Product Image Label 2 field in Warehouse Management Control Maintenance. |
|
P |
image-file-3 |
14600 |
No |
255 |
Character |
Enter the folder path and file name for the product's third image file. |
Image File 3 field on the Selling tab in Product Maintenance NOTE You can enter the label for this field in the Product Image Label 3 field in Warehouse Management Control Maintenance. |
|
B |
Internal-Buyer |
14700 |
No |
60 |
Character |
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. |
Internal Buyer field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
P |
Intransit-acct |
14800 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
In Transit field on the Accounts tab in Product Maintenance |
|
P |
Inventory-acct |
14900 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Inventory field in the Order Entry Account Resolution section on the Accounts tab in Product Maintenance |
|
P |
AP-inv-recon |
15000 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
A/P Inventory Variance field on the Accounts tab in Product Maintenance |
|
L |
Lead-time |
15100 |
No |
4 |
>>>9 |
Enter the lead time (in days) required to replenish the product in the location. For more information, see Lead Time Management. |
Lead Time field on the Buying tab in Product Location Maintenance |
|
B |
List-1 |
15200 |
No |
12 |
>>>>>>>>9.99<< |
Enter the first list price for the product with two to four decimal places. You can also optionally import an effective date for the price. If importing an effective date, separate the date with the following delimiter character: | Example 10.99|1/15/2018 This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned for this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance. |
List Prices and Future Prices grids on the Pricing tab in Product Maintenance and Product Location Maintenance |
|
B |
List-2 |
15300 |
No |
12 |
>>>>>>>>9.99<< |
Enter the second list price for the product with two to four decimal places. You can also optionally import an effective date for the price. If importing an effective date, separate the date with the following delimiter character: | Example 10.99|1/15/2018 This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned for this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance. |
List Prices and Future Prices grids on the Pricing tab in Product Maintenance and Product Location Maintenance |
|
B |
List-3 |
15400 |
No |
12 |
>>>>>>>>9.99<< |
Enter the third list price for the product with two to four decimal places. You can also optionally import an effective date for the price. If importing an effective date, separate the date with the following delimiter character: | Example 10.99|1/15/2018 This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned for this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance. |
List Prices and Future Prices grids on the Pricing tab in Product Maintenance and Product Location Maintenance |
|
B |
List-4 |
15500 |
No |
12 |
>>>>>>>>9.99<< |
Enter the fourth list price for the product with two to four decimal places. You can also optionally import an effective date for the price. If importing an effective date, separate the date with the following delimiter character: | Example 10.99|1/15/2018 This price can be used to manually assign prices for the product in the default selling unit of measure. The price assigned for this field can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance. |
List Prices and Future Prices grids on the Pricing tab in Product Maintenance and Product Location Maintenance |
|
P |
Detail-Desc |
15600 |
No |
16959 |
Character |
Enter detailed characteristics of the product. |
Detail Description field on the General tab in Product Maintenance |
|
|
|
|
|
|
|
|
|
|
B |
Margin-action |
15800 |
No |
6 |
Character |
Enter one of the following margin options:
|
Give Warning, Ignore Margins, and Place on Hold radio buttons on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
Max-stock |
15900 |
No |
8 |
>>>>>>>9 |
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 for this field are in the default purchasing unit of measure. You must enter zero if Yes is entered for the Non-Stocked field. |
Maximum Stock Level field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
B |
Max-margin |
16000 |
No |
6 |
>>9.99 |
Enter a maximum margin percentage for sales orders. This must be greater than the value for the Min-margin field. The maximum value for this field is 100.00. |
Max Sales Margin % field on the Selling tab in Product Maintenance and Max Margin % field on the Selling tab in Product Location Maintenance |
|
B |
Min-stock |
16100 |
No |
8 |
>>>>>>>9 |
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 for this field are in the default purchasing unit of measure. You must enter zero if Yes is entered for the Non-Stocked field. |
Minimum Stock Level field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
B |
Min-margin |
16200 |
No |
5 |
>9.99 |
Enter a minimum margin percentage for sales orders. This must be less than the value for the Max-margin field. |
Min Sales Margin % field on the Selling tab in Product Maintenance and Min Margin % field on the Selling tab in Product Location Maintenance |
|
B |
Min-order-qty |
16300 |
No |
9 |
>>>>>>>>9 |
Enter the minimum purchase quantity used by purchasing and DRP. The quantity defined in this field is in the default purchasing unit of measure. NOTE This cannot be less than the value entered for the Purchase-increment field. For information on how this field impacts DRP calculations, see DRP - Suggested Planned Receipt FAQ. |
Minimum Purchase Quantity field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
P |
MSDS |
16400 |
No |
12 |
Character |
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. |
MSDS Number field on the Warehouse tab in Product Maintenance |
|
B |
Must-drop |
16500 |
No |
3 |
Yes/No |
Enter Yes if the product must be drop shipped. Enter No if the product does not have to be drop shipped. You can only enter Yes for this field if the product is allowed to be drop shipped. |
Must Drop Ship check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
Non-stocked |
16600 |
No |
3 |
Yes/No |
Enter Yes if your company can only purchase the product when there is a sales order. Enter No if the product can be stocked. If you enter Yes, then the product must be set up to hold inventory for backorders, and the product's minimum and maximum stock levels must be zero. 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. |
Non Stocked Item check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
L |
Pick-bin |
16700 |
No |
20 |
Character |
Enter a valid primary pick bin for the product. You must enter an available bin from which products can be picked. For information on setting up bins, see Bin Maintenance. |
Primary Pick Bin field on the Warehouse tab in Product Location Maintenance |
|
B |
Price-class |
16800 |
No |
|
Character |
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. Note This field is not used for configuration kits. You can import a blank value in this field to clear all price classes for a product. Note This field is not used for configuration kits. |
Price Classes grid on the Pricing tab in Product Maintenance and Product Location Maintenance |
|
B |
Primary-supplier-code |
16900 |
No |
15 |
Character |
Enter a valid supplier code for the primary supplier of the product. For information on setting up supplier codes, see Supplier Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Primary Supplier Code field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
P |
Product-class |
17000 |
No |
1 |
Character |
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. |
ABC Product Class field on the Warehouse tab in Product Maintenance |
|
P |
Start-date |
17100 |
No |
10 |
Date |
This field is not used. |
|
|
P |
Name |
17200 |
No |
40 |
Character |
Enter the product's name. This field does not require a unique name for each product. If a product is used with customer portals, changing the name also changes the customer portal product name. This field cannot be blank. |
Product Name field on the General tab in Product Maintenance |
|
B |
Purchase-increment |
17300 |
No |
12 |
>>>>>>>>9.99 |
Enter the purchase increment used by purchasing and DRP. The increment quantity defined in this field is in the default purchasing unit of measure. For information on how this field impacts DRP calculations, see DRP - Suggested Planned Receipt FAQ. |
Purchase Increment field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
L |
Put-away-bin |
17400 |
No |
20 |
Character |
Enter a valid available bin into which the product will be put away. For information on setting up bins, see Bin Maintenance. |
Primary Putaway Bin field on the Warehouse tab in Product Location Maintenance |
|
B |
Review-days |
17500 |
No |
4 |
9999 |
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. |
Review Days field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
B |
Safety-stock |
17600 |
No |
12 |
>>>>>>>>9.99 |
Enter the safety stock quantity for the product in the default purchase unit of measure. This is informational only, and not used in calculations. |
Safety Stock field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
P |
Sales-acct |
17700 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Sales field on the Accounts tab in Product Maintenance |
|
B |
Sales-cost |
17800 |
No |
11 |
Character |
Enter the product's sales reporting cost basis. The sales reporting cost basis is used in gross margin determination for sales reporting, and is used for calculating royalties and commissions. Enter one of the following values:
You cannot enter LIFO or FIFO for catch weight products. This field is not used for kit and service products. |
Sales Reporting Cost field on the Cost tab in Product Maintenance and Product Location Maintenance |
|
B |
Sales-track |
17900 |
No |
6 |
Character |
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. |
Sales Track At radio set on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
P |
Sanity |
18000 |
No |
3 |
Yes/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 for the Sanity-percent field. |
Perform Sanity Check on Product Cost check box on the Buying tab in Product Maintenance |
|
P |
Sanity-percent |
18100 |
No |
6 |
>>9.99 |
Enter a cost variance percentage if Yes is entered for the Sanity field. The cost variance percentage entered for this field is used in performing the sanity check against a cost assigned to a product. |
Cost Variance % field on the Buying tab in Product Maintenance |
|
|
|
|
|
|
|
|
|
|
P |
Special-item-code |
18300 |
No |
2 |
Character |
Enter a user-defined special product code for the product. You can track products defined with special product codes in Customer Special Product Analysis and Sales Representative Special Product Analysis. For more information, see Special Product Tracking. |
Special Product Code field on the Selling tab in Product Maintenance |
|
B |
Standard-cost |
18400 |
No |
14 |
>>>>>>>>9.9999 |
Enter the standard cost of the product for the product unit of measure, a valid inventory adjustment code, and a remark, separated by | characters. EXAMPLE 5|Cost Adj|New Cost Remark For more information, see cost basis. If you change the standard cost of a product, the adjustment must be posted to the general ledger so that it will match inventory. |
New Cost, Adjustment Code, and Remark fields in Inventory Cost Adjust |
|
P |
Standard-cost-var |
18500 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Standard Cost Variance field on the Accounts tab in Product Maintenance |
|
P |
Sub-category |
18600 |
No |
12 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. NOTE If you change the subcategory of a product, it is changed in associated records (e.g., goals, sales orders, purchase orders, etc.). |
Subcategory field on the General tab in Product Maintenance |
|
P |
Tax-category |
18700 |
No |
12 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. NOTE This field is ignored when AvaTax interface is used. |
Sales Tax Category field on the Selling tab in Product Maintenance |
|
L |
Tax-included |
18800 |
No |
3 |
Yes/No |
Enter Yes if prices stored in the four list price fields for the product/location include tax. Enter No if the prices do not include tax. |
Tax Included check box on the Selling tab in Product Location Maintenance |
|
P |
Transfer-expense |
18900 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Transfer Expense field on the Accounts tab in Product Maintenance |
|
P |
Transfer-buy |
19000 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Transfer Buy field on the Accounts tab in Product Maintenance |
|
P |
Transfer-sale |
19100 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Transfer Sale field on the Accounts tab in Product Maintenance |
|
B |
TYPE |
19200 |
No |
7 |
Character |
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. Example You are updating a product called Repackaging Services. The product should be set up as a service product. |
Merchandise and Service radio buttons on the General tab in Product Maintenance |
|
P |
Weight |
19300 |
No |
9 |
>>>>>9.99 |
Enter the gross unit weight (including packaging) of the product. This must be entered in the weight unit of measure. |
Unit Gross Weight field on the Warehouse tab in Product Maintenance |
|
P |
Weight-um |
19400 |
No |
8 |
Character |
Enter a valid weight unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
field to the right of Unit Gross Weight field on the Warehouse tab in Product Maintenance |
|
P |
UPC-Code |
19500 |
No |
25 |
Character |
Enter the UPC for the product. |
UPC Code field on the General tab in Product Maintenance |
|
L |
Use-primary-for-all |
19600 |
No |
3 |
Yes/No |
Enter Yes if you want to use the primary pick bin for the product/location as the default bin for picking and putting away, and as the default work order bin. Enter No if you do not want to use the primary pick bin for the product/location as the default bin for picking and putting away, and as the default work order bin. If you enter Yes, there must be a primary pick bin set up for the product/location. |
Use Primary Pick Bin for All Bins check box on the Warehouse tab in Product Location Maintenance |
|
P |
user-1 |
19700 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
first user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-10 |
19800 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
tenth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-2 |
19900 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
second user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-3 |
20000 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
third user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-4 |
20100 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
fourth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-5 |
20200 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
fifth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-6 |
20300 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
sixth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-7 |
20400 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
seventh user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-8 |
20500 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
eighth user-defined field on the Other Information tab in Product Maintenance |
|
P |
User-9 |
20600 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
ninth user-defined field on the Other Information tab in Product Maintenance |
|
P |
Density-vol-basis |
20700 |
No |
8 |
Character |
Enter a valid density volume unit of measure (basis) for the product. You can import a blank value in this field to clear the value currently stored for it. |
Density Volume Basis field on the Warehouse tab in Product Maintenance |
|
P |
Density-mass-basis |
20800 |
No |
8 |
Character |
Enter a valid unit of measure (basis) for the mass of the product. You can import a blank value in this field to clear the value currently stored for it. |
Density Mass Basis field on the Warehouse tab in Product Maintenance |
|
P |
Density |
20900 |
No |
12 |
>>>>>>9.<<<< |
Enter the density of the product. Density is the ratio of mass per volume. |
Density field on the Warehouse tab in Product Maintenance |
|
B |
Sales-order-minimum |
21000 |
No |
6 |
>>>>>9 |
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).
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. |
Order Minimum field on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
Sales-order-multiple |
21100 |
No |
6 |
>>>>>9 |
Enter the order quantity multiple allowed to be entered during sales order entry (in the stock, or lowest, level unit of measure).
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). |
Order Multiple field on the Selling tab in Product Maintenance and Product Location Maintenance |
|
P |
GTIN |
21200 |
No |
14 |
Character |
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. |
GTIN field on the General tab in Product Maintenance |
|
|
|
|
|
|
|
|
|
|
P |
product-style-key |
22400 |
No |
12 |
Character |
Enter a valid style for the product. For information on setting up product styles, see Style Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Product Style field on the General tab in Product Maintenance |
|
P |
size-key |
22500 |
No |
10 |
Character |
Enter a valid size code for the product. For information on setting up size codes, see Size Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Size Code field on the General tab in Product Maintenance |
|
P |
color-key |
22600 |
No |
10 |
Character |
Enter a valid color code for the product. For information on setting up color codes, see Color Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Color Code field on the General tab in Product Maintenance |
|
P |
nmfc-number |
22700 |
No |
20 |
Character |
Enter the National Motor Freight Classification (NMFC) number used for bill of lading printing. For more information, see National Motor Freight Classification Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
NMFC Number field on the Warehouse tab in Product Maintenance |
|
P |
royal-class-name |
22800 |
No |
12 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Royalty Class field on the Selling tab in Product Maintenance |
|
B |
comp-class-key |
22900 |
No |
|
Character |
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 You can import a blank value in this field to clear the value currently stored for it. |
Companion Classes grid on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
product-status-code |
23000 |
No |
12 |
Character |
Enter a valid product status code to indicate the current status of the product. For information on setting up product status codes, see Product Status Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Product Status field on the Status tab in Product Maintenance and the Buying tab in Product Location Maintenance |
|
L |
forecast-transfer-rule |
23100 |
No |
8 |
Character |
Enter one of the following values to specify whether transfer orders initiated for the product/location are used to update sales demand for DRP.
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. |
Forecast Transfer Rule field on the Buying tab in Product Location Maintenance |
|
L |
transfer-location-key |
23200 |
No |
3 |
Character |
Enter a valid location prefix for the location from which the product is replenished. This field is required if Transfer is entered for the forecast-transfer-rule field. NOTE Transfer must be set up as a replenishment path for the product in this location. You can set this up using field number 31300. |
Replenishment Location field on the Buying tab in Product Location Maintenance |
|
B |
season-class-key |
23300 |
No |
20 |
Character |
Enter a valid seasonal class for the product. The seasonal class is used for demand forecasting and DRP. For information on setting up seasonal classes, see Seasonal Class Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Season Class field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
B |
selling-um-code |
23400 |
Yes |
3 |
Yes/No |
Enter Yes if the unit of measure can be used for sales orders. Enter No if it cannot be used for sales orders. |
Sell grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
purchasing-um-code |
23500 |
Yes |
3 |
Yes/No |
Enter Yes if the unit of measure can be used for purchase orders. Enter No if it cannot be used for purchase orders. |
Purch grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
picking-um-code |
23600 |
Yes |
3 |
Yes/No |
Enter Yes if the unit of measure can be used for pick demands. Enter No if it cannot be used for pick demands. |
Pick grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
is-default-selling-um |
23700 |
Yes |
3 |
Yes/No |
Enter Yes if this is the default unit of measure for sales and transfer orders. You can sell products in more than one unit of measure, but you can only define one default. The O/E Line Item Entry window uses this unit of measure. Note The default selling unit of measure is also used for price matrix definitions. |
Dflt. Sell grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
is-default-display-um |
23800 |
Yes |
3 |
Yes/No |
Enter Yes if this is the unit of measure you want to use for displaying the product in various inquiries and reports. Inventory Matrix Inquiry uses the default assigned here to display a product/location record. |
Dflt. Display grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
is-default-receipt-um |
23900 |
Yes |
3 |
Yes/No |
Enter Yes if this is the unit of measure in which you want to receive, regardless of the purchasing unit of measure. Note The software keeps track of inventory by unit of measure. Inventory by unit of measure is used during pick demand creation. For example, if your supplier requires your purchase order for a product to be in a master case unit of measure, but you want to put it away as eaches, you would set the default receipt unit of measure to each. |
Dflt. Rcpt grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
is-default-purchase-um |
24000 |
Yes |
3 |
Yes/No |
Enter Yes if this unit of measure is the default unit of measure for purchase orders. You can purchase in more than one unit of measure, but you can only define one default. Demand forecasting, Min-Max Buying Recommendations, and Purchase Order Maintenance use this unit of measure. |
Dflt. Purch grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
P |
is-web-selling-um |
24100 |
Yes |
3 |
Yes/No |
Enter Yes if this unit of measure is available for the Portals module. |
Web grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
|
|
|
|
|
|
|
|
|
B |
um-height |
24300 |
Yes |
10 |
>>>>9.>>>> |
Enter the height of the specific unit of measure for the product. |
Height grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-length |
24400 |
Yes |
10 |
>>>>9.>>>> |
Enter the length of the specific unit of measure for the product. |
Length grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-width |
24500 |
Yes |
10 |
>>>>9.>>>> |
Enter the width of the specific unit of measure for the product. |
Width grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-net-weight |
24600 |
Yes |
10 |
>>>>9.>>>> |
Enter the net weight of the specific unit of measure of the product. This excludes the packaging weight. |
Net Weight grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-gross-pack-weight |
24700 |
Yes |
10 |
>>>>9.>>>> |
Enter the gross weight of the specific unit of measure of the product, including the packaging weight. |
Gross Pkgd Weight grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-weight-code |
24800 |
Yes |
8 |
Character |
Enter a valid unit of measure for the unit of measure weight fields. Example lbs. |
Weight U/M grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-UPC |
24900 |
Yes |
25 |
Character |
Enter the Universal Product Code for the specific unit of measure of the product. |
UPC grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-GTIN |
25000 |
Yes |
14 |
Character |
Enter the GTIN for the specific unit of measure of the product. |
GTIN grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-putaway-group |
25100 |
Yes |
30 |
Character |
Enter the putaway group for the specific unit of measure of 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. |
Putaway Group grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-pick-seq-group |
25200 |
Yes |
20 |
Character |
Enter the pick sequence group for the specific unit of measure of the product. |
Pick Sequence Group grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
um-velocity-code |
25300 |
Yes |
12 |
Character |
Enter the velocity code associated with the frequency of picking activity for the specific unit of measure of the product. For information on setting up velocity codes, see Velocity Maintenance. |
Velocity grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
L |
um-pick-zone-name |
25400 |
Yes |
20 |
Character |
Enter the primary zone that the product should be picked from when stored in the specific unit of measure. |
Primary Pick Zone grid column on the Units of Measure tab in Product Location Maintenance |
|
L |
um-pick-bin-key |
25500 |
Yes |
20 |
Character |
Enter the first bin that the product should be picked from when stored in the specific unit of measure. |
Primary Pick Bin grid column on the Units of Measure tab in Product Location Maintenance |
|
L |
um-replenish-max |
25600 |
Yes |
6 |
>>>>>9 |
Enter the replenishment maximum quantity for the specific unit of measure of the product. |
Replenish Max grid column on the Units of Measure tab in Product Location Maintenance |
|
L |
um-replenish-min |
25700 |
Yes |
6 |
>>>>>9 |
Enter the replenishment minimum quantity for the specific unit of measure of the product. |
Replenish Min grid column on the Units of Measure tab in Product Location Maintenance |
|
|
|
|
|
|
|
|
|
|
B |
Discontinued-Date |
25900 |
No |
10 |
MM/DD/YYYY |
Enter the discontinued date if the product is discontinued. Only enter a value for this field if the product is discontinued. |
Discontinued Date field on the Status tab in Product Maintenance and the Warehouse tab in Product Location Maintenance |
|
L |
Replenishment-path |
26000 |
No |
8 |
Character |
Enter the primary replenishment path for the product (and location) for DRP. You can enter one of the following:
NOTE The primary replenishment path must be a valid replenishment path for the product/location. You can set up replenishment paths using field numbers 31200, 31300, and 31400. |
Primary radio set on the Buying tab in Product Location Maintenance |
|
P |
user-11 |
26100 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
eleventh user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-20 |
26200 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
twentieth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-12 |
26300 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
twelfth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-13 |
26400 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
thirteenth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-14 |
26500 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
fourteenth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-15 |
26600 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
fifteenth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-16 |
26700 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
sixteenth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-17 |
26800 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
seventeenth user-defined field on the Other Information tab in Product Maintenance |
|
P |
user-18 |
26900 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
eighteenth user-defined field on the Other Information tab in Product Maintenance |
|
P |
User-19 |
27000 |
No |
400 |
Character, Date, Decimal, Integer, or Logical |
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. |
nineteenth user-defined field on the Other Information tab in Product Maintenance |
|
B |
Allow Re-Allocation |
27100 |
No |
3 |
Yes/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. Enter No to not allow the product to be reallocated. |
Allow Re-Allocation check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
recount-var-pct |
27200 |
No |
4 |
>>>9 |
Enter the recount variance percentage for the product. This field is used in conjunction with Wireless Warehouse cycle counting. |
Recount Variance % field on the Warehouse tab in Product Maintenance and the Cycle Count tab in Product Location Maintenance |
|
B |
recount-var-amt |
27300 |
No |
8 |
>>>>>>>9 |
Enter a recount variance amount for the product. This field is used in conjunction with Wireless Warehouse cycle counting. |
Recount Variance Amt field on the Warehouse tab in Product Maintenance and the Cycle Count tab in Product Location Maintenance |
|
B |
recount-req |
27400 |
No |
3 |
Yes/No |
Enter Yes to require a recount of the product for Wireless Warehouse Cycle Counting. A recount is only required if this is Yes and a recount variance amount or percentage is entered. |
Recount Required check box on the Warehouse tab in Product Maintenance and the Cycle Count tab in Product Location Maintenance |
|
B |
count-display |
27500 |
No |
8 |
Character |
Enter one of the following count display values: Blank, Visible, or Blind. This field is used in conjunction with Wireless Warehouse Cycle Counting. |
Count Display field on the Warehouse tab in Product Maintenance and the Cycle Count tab in Product Location Maintenance |
|
B |
recount-display |
27600 |
No |
8 |
Character |
Enter one of the following recount display values: Blank, Visible, or Blind. This field is used in conjunction with Wireless Warehouse Cycle Counting. |
Recount Display field on the Warehouse tab in Product Maintenance and the Cycle Count tab in Product Location Maintenance |
|
B |
cycle-class-code |
27700 |
No |
12 |
Character |
Enter a valid cycle class code for the product or product/location. 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. |
Cycle Class Code field on the Warehouse tab in Product Maintenance and the Cycle Count tab in Product Location Maintenance |
|
|
|
|
|
|
|
|
|
|
L |
cycle-auto-reclass |
27900 |
No |
3 |
Yes/No |
Enter Yes to not allow the automatic reclassification of the cycle class code when running product cycle count reclassification. Enter No to allow automatic reclassification. |
Do Not Reclassify check box on the Cycle Count tab in Product Location Maintenance |
|
B |
label-format |
28000 |
Yes |
40 |
Character |
Enter the format of the receiving label for the 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. |
Label Format grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
P |
dimension-um |
28100 |
No |
8 |
Character |
Enter a valid unit of measure for height, width, and length dimensions. You can import a blank value in this field to clear the value currently stored for it. |
Dimensional Basis field on the Warehouse tab in Product Maintenance |
|
P |
active |
28200 |
No |
3 |
Yes/No |
Enter Yes if the product is active. Enter No if it is not active. 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. |
Active check box on the Status tab in Product Maintenance |
|
P |
catch-weight |
28300 |
No |
3 |
Yes/No |
Enter Yes if the product is a random weight, or No if it is not 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. |
This is a Catch Weight product check box on the Catch Weights tab in Product Maintenance |
|
P |
Sales-returns-acct |
28400 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Returns field on the Accounts tab in Product Maintenance |
|
P |
Sales-discount-acct |
28500 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Sales Discount field on the Accounts tab in Product Maintenance |
|
P |
Sales-returns-discount-acct |
28600 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Returns Discount field on the Accounts tab in Product Maintenance |
|
P |
Cogs-returns-acct |
28700 |
No |
29 |
Character |
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. |
Cost of Goods Sold Returned field on the Accounts tab in Product Maintenance |
|
|
|
|
|
|
|
|
|
|
P |
Catch-weight-acct |
28900 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. |
Catch Weight Variance field on the Accounts tab in Product Maintenance |
|
P |
Lot-expiration-acct |
29000 |
No |
29 |
Character |
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. |
Lot Expiration field on the Accounts tab in Product Maintenance |
|
P |
CAD-Image |
29100 |
No |
255 |
Character |
Enter the path and file name of a CAD image file for the product. |
CAD Image field on the Planning tab in Product Maintenance |
|
B |
Drop-ship-allowed |
29200 |
No |
3 |
Yes/No |
Enter Yes if the product can be drop shipped to customers. |
Drop Ship Allowed check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
Package-um |
29300 |
No |
8 |
Character |
Enter the package unit of measure for the product. This unit of measure is used in package building determination. You can import a blank value in this field to clear the value currently stored for it. |
Package U/M field on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
Downward-um-picking |
29400 |
No |
3 |
Yes/No |
Enter Yes to permit a larger unit of measure of the product 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. |
Allow Larger U/M Picking Recommendations check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
Upward-um-picking |
29500 |
No |
3 |
Yes/No |
Enter Yes to permit a larger unit of measure of the product to be assembled from smaller units of measure to fulfill a sales order allocation. |
Allow Smaller U/M Picking Recommendations check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
Pick-method |
29600 |
No |
11 |
Character |
Enter one of the following pick method values:
|
Pick Method field on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
Pick-group |
29700 |
No |
20 |
Character |
Enter a valid product pick group for the product. For information on setting up product pick groups, see Product Pick Group Maintenance. |
Pick Group field on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
|
|
|
|
|
|
|
|
|
P |
Unit-net-weight |
29900 |
No |
11 |
>>>>>9.9999 |
Enter the net unit weight of the product. This must be entered in the weight unit of measure. |
Unit Net Weight field on the Warehouse tab in Product Maintenance |
|
B |
Um-dimensional |
30000 |
Yes |
8 |
Character |
Enter an active length unit of measure for the height, length, and width dimensions of a specific unit of measure of the product. |
Dimensional U/M grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
Um-cube-size |
30100 |
Yes |
8 |
Character |
Enter the cube (volume) of a specific unit of measure of the product. If this field is being entered, the cube unit of measure must be entered in a previous line or import. |
Cube grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
Um-cube |
30200 |
Yes |
8 |
Character |
Enter the cube unit of measure for the unit of measure. |
Cube U/M grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
Um-can-be-packaged |
30300 |
Yes |
3 |
Yes/No |
Enter Yes if the unit of measure can be packaged into other larger packages for picking cartonization. Enter No if the unit of measure is a package and cannot be put into a larger package. |
Can be Packaged grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
B |
Break-um |
30400 |
Yes |
8 |
Character |
If a product unit of measure can be broken down into a smaller unit of measure, enter a valid unit of measure. Example A pallet/100 unit of measure is broken down into the case/10 unit of measure, which is broken down to the each unit of measure. This must be a valid unit of measure for the product. The unit of measure in the sixth position for the import record must be larger than and evenly divisible by this unit of measure. |
Break to U/M grid column on the Unit of Measure tab in Product Maintenance and the Units of Measure tab in Product Location Maintenance |
|
P |
Catch-weight-sanity-over-amt |
30500 |
No |
8 |
>>>>9.99 |
Enter the acceptable maximum variance amount over the gross packaged weight for a catch weight product. |
Sanity Over Amount field on the Catch Weights tab in Product Maintenance |
|
P |
Catch-weight-sanity-under-amt |
30600 |
No |
8 |
>>>>9.99 |
Enter the acceptable maximum variance amount under the gross packaged weight for a catch weight product. |
Sanity Under Amount field on the Catch Weights tab in Product Maintenance |
|
P |
Catch-weight-sanity-over-pct |
30700 |
No |
6 |
>>9.99 |
Enter the acceptable maximum variance percentage over the gross packaged weight for a catch weight product. |
Sanity Over Percent field on the Catch Weights tab in Product Maintenance |
|
P |
Catch-weight-sanity-under-pct |
30800 |
No |
6 |
>>9.99 |
Enter the acceptable maximum variance percentage under the gross packaged weight for a catch weight product. |
Sanity Under Percent field on the Catch Weights tab in Product Maintenance |
|
P |
country-of-origin |
30900 |
No |
10 |
Character |
Enter the country of origin of the product. You can import a blank value in this field to clear the value currently stored for it. |
Country of Origin field on the Buying tab in Product Maintenance |
|
P |
bookings-class |
31000 |
No |
12 |
Character |
Enter the bookings class for the product. For information on setting up bookings classes, see Bookings Class Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Bookings Class field on the Selling tab in Product Maintenance |
|
B |
use-qoo-in-discontinued-calc |
31100 |
No |
3 |
Yes/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. |
Include On Order Quantity in OE Discontinued Validation check box on the Status tab in Product Maintenance and the Warehouse tab in Product Location Maintenance |
|
L |
replenishment-path-purchase |
31200 |
No |
3 |
Yes/No |
Enter Yes if the product can be replenished by purchasing directly from a supplier. If the primary replenishment path is Purchase, this cannot be No. |
Purchase check box on the Buying tab in Product Location Maintenance |
|
L |
replenishment-path-transfer |
31300 |
No |
3 |
Yes/No |
Enter Yes if the product can be replenished by transferring it from another location. If the primary replenishment path is Transfer, this cannot be No. |
Transfer check box on the Buying tab in Product Location Maintenance |
|
L |
replenishment-path-build |
31400 |
No |
3 |
Yes/No |
Enter Yes if the product is a bill of material product and can be replenished by creating work orders in the location. If the primary replenishment path is Build, this cannot be No. |
Build check box on the Buying tab in Product Location Maintenance |
|
P |
pm-class-code |
31500 |
No |
20 |
Character |
Enter a supplier production monitoring class for the product. For information on setting up supplier production monitoring classes, see Monitoring Class Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Production Monitoring Class field on the Buying tab in Product Maintenance |
|
P |
cust-profit-sales |
31600 |
No |
25 |
Character |
Enter a customer scorecard profit category code and subcategory code for sales for the product. Enter a | character between the category and subcategory. For information on setting up scorecard profit categories and subcategories, see Scorecard Profit Category Maintenance. |
Profit Category Code Sales and Profit Subcategory Code Sales fields in the Customer section on the Profitability tab in Product Maintenance |
|
P |
cust-profit-cost |
31700 |
No |
25 |
Character |
Enter a customer scorecard profit category code and subcategory code for costs for the product. Enter a | character between the category and subcategory. For information on setting up scorecard profit categories and subcategories, see Scorecard Profit Category Maintenance. |
Profit Category Code Cost and Profit Subcategory Code Cost fields in the Customer section on the Profitability tab in Product Maintenance |
|
P |
supp-profit-sales |
31800 |
No |
25 |
Character |
Enter a supplier scorecard profit category code and subcategory code for sales for the product. Enter a | character between the category and subcategory. For information on setting up scorecard profit categories and subcategories, see Scorecard Profit Category Maintenance. |
Profit Category Code Sales and Profit Subcategory Code Sales fields in the Supplier section on the Profitability tab in Product Maintenance |
|
P |
supp-profit-cost |
31900 |
No |
25 |
Character |
Enter a supplier scorecard profit category code and subcategory code for costs for the product. Enter a | character between the category and subcategory. For information on setting up scorecard profit categories and subcategories, see Scorecard Profit Category Maintenance. |
Profit Category Code Cost and Profit Subcategory Code Cost fields in the Supplier section on the Profitability tab in Product Maintenance |
|
P |
prod-profit-sales |
32000 |
No |
25 |
Character |
Enter a product scorecard profit category code and subcategory code for sales for the product. Enter a | character between the category and subcategory. For information on setting up scorecard profit categories and subcategories, see Scorecard Profit Category Maintenance. |
Profit Category Code Sales and Profit Subcategory Code Sales fields in the Product section on the Profitability tab in Product Maintenance |
|
P |
prod-profit-cost |
32100 |
No |
25 |
Character |
Enter a product scorecard profit category code and subcategory code for costs for the product. Enter a | character between the category and subcategory. For information on setting up scorecard profit categories and subcategories, see Scorecard Profit Category Maintenance. |
Profit Category Code Cost and Profit Subcategory Code Cost fields in the Product section on the Profitability tab in Product Maintenance |
|
P |
prod-profit-group-code |
32200 |
No |
12 |
Character |
Enter the scorecard profit group code for the product. For information on setting up scorecard profit group codes, see Scorecard Profit Group Maintenance. You can import a blank value in this field to clear the value currently stored for it. |
Profit Group field on the Profitability tab in Product Maintenance |
|
P |
prod-vat |
32300 |
No |
44 |
Character |
Enter a country and the VAT information (VAT class, VAT exempt reason, and Yes or No to indicate if the product is VAT exempt) for the country. Use | as a separator character between each value. EXAMPLE US|class-A|reason-B|Yes Note To associate a specific product/location with a VAT class and/or reason, use field 32400 and/or 32500. To mark a product/location as VAT exempt, use field 33900. |
Selected VAT Class grid on the VAT tab in Product Maintenance |
|
L |
prod-loc-vat-class |
32400 |
No |
30 |
Character |
Enter a valid VAT class code for the product/location. For information on setting up VAT classes, see VAT Class Maintenance. Note To associate a specific product and country with a VAT class, use field 32300. |
VAT Class Code field on the VAT tab in Product Location Maintenance |
|
L |
prod-loc-vat-reason |
32500 |
No |
20 |
Character |
Enter a valid VAT exempt reason code for the product/location. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance. Note To associate a specific product and country with a VAT exempt reason, use field 32300. |
VAT Exempt Reason Code field on the VAT tab in Product Location Maintenance |
|
P |
input-vat-clearing-mask |
32600 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. 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. |
Input VAT Clearing field on the Accounts tab in Product Maintenance |
|
P |
input-vat-mask |
32700 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. 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. |
Input VAT field on the Accounts tab in Product Maintenance |
|
P |
input-vat-write-off-mask |
32800 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. 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. |
Input VAT Write-off field on the Accounts tab in Product Maintenance |
|
P |
input-vat-pending-mask |
32900 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. 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. |
Input VAT Pending field on the Accounts tab in Product Maintenance |
|
P |
output-vat-mask |
33000 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. 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. |
Output VAT field on the Accounts tab in Product Maintenance |
|
P |
output-vat-variance-mask |
33100 |
No |
29 |
Character |
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. You can import a blank value in this field to clear the value currently stored for it. 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. |
Output VAT Variance field on the Accounts tab in Product Maintenance |
|
B |
vat-included |
33200 |
No |
3 |
Yes/No |
Enter Yes if the price for the product or product/location includes VAT. Note This field is not used for configuration kits. |
Price Includes VAT and Price Excludes VAT radio buttons on the Pricing tab in Product Maintenance and Product Location Maintenance |
|
B |
product-scan |
33300 |
No |
7 |
Character |
Enter one of the following options:
|
Product Scan radio set on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
quantity-scan |
33400 |
No |
14 |
Character |
Enter one of the following options:
Example If you select this option and a user is picking 15 cases, the user must scan each case (15 scans).
|
Quantity Scan radio set on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
B |
backorder-priority |
33500 |
No |
51 |
Character |
Enter the product's backorder release priority, using a comma to separate each of the following four values:
Example Order Priority,Order Date,Order Class,Required Date If the product is ordered and goes on backorder, its backorder release priority is used to determine the release of the backorder. |
Backorder Release Priority grid on the Warehouse tab in Product Maintenance and Backorder Priority grid on the Warehouse tab in Product Location Maintenance |
|
P |
sales-tax-code |
33600 |
No |
20 |
Character |
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. |
Sales Tax Code field on the Selling tab in Product Maintenance |
|
L |
potential-discrepancy-flag |
33700 |
No |
3 |
YES/NO |
Enter YES if there is a potential discrepancy for the product's physical (cycle counting) inventory. |
Potential Discrepancy check box on the Warehouse tab in Product Location Maintenance |
|
L |
Transit-Lead-time |
33800 |
No |
4 |
>>>9 |
Enter the in-transit lead time for the product, which is the number of days between when the product is shipped and received. This is used by DRP to calculate purchase order and blanket release ship dates. Example If the in-transit lead time is 10 days, and the purchase order delivery date is 06/15, the purchase order ship date is calculated as 06/05. |
In Transit Lead Time field on the Buying tab in Product Location Maintenance |
|
L |
prod-loc-vat-exempt |
33900 |
No |
3 |
Yes/No |
Enter Yes if the product/location is exempt from VAT, or No if the product/location is not exempt from VAT. |
VAT Exempt check box on the VAT tab in Product Location Maintenance |
|
B |
lot-pick-days |
34000 |
No |
16 |
Character |
Enter a customer code and the number of days before the lot expiration date that picking for the product should not occur for the customer. The two values should be separated by a | character. Example 101|20 This is only used for lot-tracked products. |
Lot Shipping Rules grid on the Lot Shipping Rules tab in Product Maintenance and Product Location Maintenance |
|
P |
allow-samp |
34100 |
No |
3 |
Yes/No |
Enter Yes if the product can be entered as a line item on sample orders. |
Allow Samples check box on the Selling tab in Product Maintenance |
|
P |
samp-fre-days |
34200 |
No |
4 |
>>>9 |
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. |
Sample Frequency Days field on the Selling tab in Product Maintenance |
|
P |
bottle-size |
34300 |
Yes |
11 |
>>>>>9.99<< |
If the product is a beverage product, enter the size of the bottle in a specified valid volume unit of measure. |
Beverage Bottle Size field on the Selling tab in Product Maintenance |
|
B |
drp-prod-class |
34400 |
No |
10 |
Character |
Enter a valid DRP product class for the product or product/location. For information on setting up DRP product classes, see DRP Product Class Maintenance. |
DRP Product Class Code field on the Buying tab in Product Maintenance and Product Location Maintenance |
|
P |
wip-material-mask |
34500 |
No |
29 |
Character |
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. |
Work in Process - Material field on the Accounts tab in Product Maintenance |
|
P |
wip-labor-mask |
34600 |
No |
29 |
Character |
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. |
Work in Process - Labor field on the Accounts tab in Product Maintenance |
|
P |
wip-outside-mask |
34700 |
No |
29 |
Character |
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. |
Work in Process - Outside Processing field on the Accounts tab in Product Maintenance |
|
P |
wip-overhead-mask |
34800 |
No |
29 |
Character |
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. |
Work in Process - Overhead field on the Accounts tab in Product Maintenance |
|
P |
scrap-exp-mask |
34900 |
No |
29 |
Character |
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. |
Scrap Expenses field on the Accounts tab in Product Maintenance |
|
P |
wo-inventory-mask |
35000 |
No |
29 |
Character |
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. |
Inventory field in the Manufacturing Account Resolution section on the Accounts tab in Product Maintenance |
|
P |
var-labor-mask |
35100 |
No |
29 |
Character |
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. |
Variance - Labor field on the Accounts tab in Product Maintenance |
|
P |
var-outside-mask |
35200 |
No |
29 |
Character |
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. |
Variance - Outside Processing field on the Accounts tab in Product Maintenance |
|
P |
var-overhead-mask |
35300 |
No |
29 |
Character |
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. |
Variance - Overhead field on the Accounts tab in Product Maintenance |
|
P |
abs-labor-mask |
35400 |
No |
29 |
Character |
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. |
Absorbed - Labor field on the Accounts tab in Product Maintenance |
|
P |
abs-outside-mask |
35500 |
No |
29 |
Character |
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. |
Absorbed - Outside Processing field on the Accounts tab in Product Maintenance |
|
P |
abs-overhead-mask |
35600 |
No |
29 |
Character |
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. |
Absorbed - Overhead field on the Accounts tab in Product Maintenance |
|
B |
order-alloc-min |
35700 |
No |
10 |
>>>,>>9.99 |
Enter the minimum quantity that can be allocated for the product or product/location in the selling default unit of measure. 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 order-alloc-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. |
Allocation Minimum field on the Selling tab in Product Maintenance and Product Location Maintenance |
|
B |
order-alloc-multiple |
35800 |
No |
10 |
>>>,>>9.99 |
Enter a value of which a multiple can be allocated for the product in the selling default unit of measure. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance. |
Allocation Maximum field on the Selling tab in Product Maintenance and Product Location Maintenance |
|
P |
ds-in-transit-mask |
35900 |
No |
29 |
Character |
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. |
Drop Ship In Transit field on the Accounts tab in Product Maintenance |
|
B |
restricted-alloc |
36000 |
No |
3 |
Yes/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. Enter No to not automatically put all sales order line items for the product on backorder. |
Restricted Allocation check box on the Warehouse tab in Product Maintenance and Product Location Maintenance |
|
P |
bvgtax-cat-code |
36100 |
No |
20 |
Character |
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. |
Excise Tax Category field on the Selling tab in Product Maintenance |
|
P |
alc-content |
36200 |
No |
8 |
>>9.9999 |
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. |
Alcohol Content field on the Selling tab in Product Maintenance |
|
L |
wh-prod-code |
36300 |
No |
40 |
Character |
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. |
Warehouse Product Code field on the Warehouse tab in Product Location Maintenance |
|
L |
wh-prod-name |
36400 |
No |
40 |
Character |
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. |
Warehouse Product Name field on the Warehouse tab in Product Location Maintenance |
|
P |
ship-debit-acct-mask |
36500 |
No |
29 |
Character |
Enter a ship and debit account to use for the product. For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ. |
Ship and Debit field on the Accounts tab in Product Maintenance |
|
P |
ship-debit-var-acct-mask |
36600 |
No |
29 |
Character |
Enter a ship and debit variance account to use for the product. For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ. |
Ship and Debit Variance field on the Accounts tab in Product Maintenance |
|
B |
ship-debit-amount-1 |
36700 |
No |
14 |
>>>,>>>,>>9.99 |
Enter a default ship and debit amount for the first list price. |
Ship and Debit Amount grid column on the Pricing tab in Product Maintenance |
|
B |
fg-billback-pct-1 |
36800 |
No |
6 |
999.99 |
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. |
Free Goods Billback % grid column on the Pricing tab in Product Maintenance |
|
B |
ship-debit-amount-2 |
36900 |
No |
14 |
>>>,>>>,>>9.99 |
Enter a default ship and debit amount for the second list price. |
Ship and Debit Amount grid column on the Pricing tab in Product Maintenance |
|
B |
fg-billback-pct-2 |
37000 |
No |
6 |
999.99 |
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. |
Free Goods Billback % grid column on the Pricing tab in Product Maintenance |
|
B |
ship-debit-amount-3 |
37100 |
No |
14 |
>>>,>>>,>>9.99 |
Enter a default ship and debit amount for the third list price. |
Ship and Debit Amount grid column on the Pricing tab in Product Maintenance |
|
B |
fg-billback-pct-3 |
37200 |
No |
6 |
999.99 |
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. |
Free Goods Billback % grid column on the Pricing tab in Product Maintenance |
|
B |
ship-debit-amount-4 |
37300 |
No |
14 |
>>>,>>>,>>9.99 |
Enter a default ship and debit amount for the fourth list price. |
Ship and Debit Amount grid column on the Pricing tab in Product Maintenance |
|
B |
fg-billback-pct-4 |
37400 |
No |
6 |
999.99 |
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. |
Free Goods Billback % grid column on the Pricing tab in Product Maintenance |
|
P |
is-default-web-um |
37500 |
Yes |
3 |
Yes/No |
Enter Yes if the unit of measure is the default unit of measure for customer portal sites for the product. Enter No if the unit of measure is not the default unit of measure for customer portal sites for the product. |
Dflt. Web grid column on the Unit of Measure tab in Product Maintenance |
|
B |
comm-cost-chrg-type |
37600 |
No |
12 |
Character |
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. |
Commission Cost Charge Type field on the Selling tab in Product Maintenance |
|
P |
bill-and-hold-clearing-mask |
37700 |
No |
29 |
Character |
Enter all or part of the bill and hold clearing 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 bill and hold clearing 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. |
Bill and Hold Clearing field on the Accounts tab in Product Maintenance |
|
P |
bill-and-hold-variance-mask |
37800 |
No |
29 |
Character |
Enter all or part of the bill and hold 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 bill and hold 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. |
Bill and Hold Variance field on the Accounts tab in Product Maintenance |
|
L |
must-use-primary-bin |
37900 |
No |
3 |
Yes/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. |
Must Use Primary Work Order Bin check box on the Warehouse tab in Product Location Maintenance |
|
L |
primary-wo-bin |
38000 |
No |
20 |
Character |
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. |
Primary Work Order Bin field on the Warehouse tab in Product Location Maintenance |
|
P |
ss-line-carton-code |
38100 |
No |
15 |
Character |
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. |
Single-single Line Carton Code field on the Warehouse tab in Product Maintenance. |
|
L |
ecommerce-um |
38200 |
Yes |
3 |
Yes/No |
Enter Yes if this is the default unit of measure for Aptean eCommerce B2C sites. |
eCommerce U/M grid column on the Units of Measure tab in Product Location Maintenance |
|
L |
ecommerce-price |
38300 |
Yes |
12 |
>>>>>>>>9.99 |
Enter the price to be used for Aptean eCommerce B2C sites. |
eCommerce Price grid column on the Units of Measure tab in Product Location Maintenance |
When setting up order minimums and order multiples, be careful if the product has multiple units of measures defined so that expected results are achieved.Prerequisites
Before using this import, the following must be set up:
- products
Import Format Notes
-
Each import line uses a caret (^) as a delimiter.
-
The product code must be a valid existing product code for the specified location.
-
The only valid field keys are B, P, L, and X.
-
A valid location prefix or All must be used if field keys B or L is used. If the field key is X, you must specify a valid location prefix. If the field key is P, the location is ignored. If you use All or X, you cannot change fields for bins.
-
You must specify a valid field value name or number from the table above.
-
You cannot use the field value name if it is not displayed in the table above.
Processing Logic
-
If the key imported = P and the field is B or P, then change the product.
-
If the key imported = L and the field is B or L, then change only the location (a single location or all locations).
-
If the key imported = B and the field is B, then change the product and location (a single location or all locations).
-
If the key imported = X and the field is B or L, then change all locations except for the specified location (a single valid location).
When you import, processing statistics and an error file are created. The file contains both errors and products changes with old and new values. The file name is: prodcimp.txt and is stored in the working folder. (You must have a working folder in your file structure.)