Items Vendors Table Formats (VendorItem)
Follow Vision specifications for preparing a file containing vendor data.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
|
Vendor |
varchar | 20 | Primary key; must exist in VE |
|
Item |
varchar | 30 | Primary key; must exist in CompanyItem |
|
Company |
varchar | 14 | Primary key; must exist in CFGMainData (Company/FirmName) |
|
LastPrice |
decimal | 9 | |
|
LastPriceCurrencyCode |
varchar | 3 | Null or must exist in CFGEnabledCurrencies |
|
LastPriceDate |
datetime | 8 | |
|
TotalAmt |
decimal | 9 | |
|
TotalQty |
decimal | 9 | |
|
UOM |
varchar | 10 | Null or must exist in CFGPOUOM (UOM/Description) |
|
VendorItem |
varchar | 30 |