Importing Item Codes
Multicurrency Users
The ITEM_CURTYPE field is only available if this module is installed and added to the organization by the Administrator (Organization>Add a Module).
Order Entry Users
The ITEM_AVAILFORRESALE field is only available if this module is installed and added to the organization.
Header
The following table defines the field references to be used in the PO Item Codes section of the MasterPO.DEF file:
| Table: tblPOItems | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ITEMCODES,HEADER,HITEMS | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
ITEM_CODE |
Y |
User Defined |
|
Item Code |
|
ITEM_STATUS |
Y |
1 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
ITEM_DESCRIPTION |
Y |
User Defined |
|
Item Code Description |
|
ITEM_ITYPE |
Y |
1 |
N |
Item Type: N (Non-Inventory), or S (Services). |
|
ITEM_CURTYPE |
Y |
3 |
|
Active or inactive Currency code for Item Code. |
|
ITEM_STDQTY |
N |
Single |
0.00 |
Standard Quantity |
|
ITEM_PUR_GLCODE |
N |
User Defined |
|
Purchase GL Account. Must be set up using Maintain>Chart of Accounts Codes. |
|
ITEM_DEF_DISTCODE |
N |
User Defined |
|
Distribution Code. |
|
ITEM_UNITCOST |
N |
Currency |
0.00 |
Unit Price |
|
ITEM_WEIGHT |
N |
Single |
0.0000 |
Weight |
|
ITEM_WEIGHT_UNIT |
N |
25 |
|
Weight Unit |
|
ITEM_AVAILFORRESALE |
N |
2 |
|
Available for Resale? 0 = No; 1 = Yes |
|
ITEM_PREF_VENDOR |
N |
User Defined |
|
Preferred Vendor |