Items Vendor/Partners Table Formats (VendorItem)
Follow GovWin Capture Management specifications for preparing a file containing vendor/partner data.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| Vendor/partner | 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 | |
| LastPriceDate | datetime | 8 | |
| TotalAmt | decimal | 9 | |
| TotalQty | decimal | 9 | |
| UOM | varchar | 10 | Null or must exist in CFGPOUOM (UOM/Description) |
| Vendor/partner Item | varchar | 30 |