Items Company Table Formats (CompanyItem)

Follow Vantagepoint 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)
InventoryInd varchar
InventoryReorderPoint decimal
InventoryUOM nvarchar
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)