| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBanking |
| 1 | ACHO | Checks for Payment - History | 16 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| 2 | OCHD | Checks for Payment Drafts | 16 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| 3 | OCHO | Checks for Payment | 16 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| TOPFinance |
| 4 | VRW2 | VAT Reposting Wizard - Rows 2 | 26 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| TOPGeneral |
| 5 | ARSC5 | Resources - Preferred Vendors - Log | 2 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| 6 | RSC5 | Resources - Preferred Vendors | 2 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| TOPInventory and Production |
| 7 | AIT2 | Items - Multiple Preferred Vendors - History | 2 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| 8 | ITM2 | Items - Multiple Preferred Vendors | 2 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
| 9 | OLCT | Location | 47 | VendorCode | Vendor Code | nVarChar | 15 | 0 | | |
