Items Company Table Formats (CompanyItem)
Follow Vision specifications for preparing a file containing company item data.
Field Name | Data Type | Length | Notes |
---|---|---|---|
Company | varchar | 14 | Primary key; must exist in CFGMainData (Company/FirmName) |
Item | varchar | 30 | Primary key; must exist in Item |
Category | varchar | 20 | Null or must exist in CFGPOCategory (Category/Description) |
LastVendor | varchar | 20 | Must exist in VE |
Primary Vendor | varchar | 20 | Must exist in VE |
Substitute | varchar | 30 | Null or must exist in CompanyItem |
UOM | varchar | 10 | Null or must exist in CFGPOUOM (UOM/Description) |