Items Company Table Formats (CompanyItem)
Follow DPS 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) |
| Last Vendor | 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) |