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) |