| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPGeneral |
| 1 | OBVL | Serial Numbers and Batch Valuation Log | 13 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
| 2 | UBVL | Serial Numbers and Batch Valuation Log | 13 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
| TOPInventory and Production |
| 3 | ABTN | Batch Numbers Master Data | 3 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
| 4 | ASRN | Serial Numbers Master Data | 3 | DistNumber | Serial Number | nVarChar | 36 | 0 | | |
| 5 | IPF1 | Landed Costs - Rows | 86 | DistNumber | Distinct Number | nVarChar | 36 | 0 | | |
| 6 | OBTN | Batch Numbers Master Data | 3 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
| 7 | ODBN | Bat. Nos - Draft - Master Data | 3 | DistNumber | Distinct Number | nVarChar | 36 | 0 | | |
| 8 | ODSN | SNs - Draft - Master Data | 3 | DistNumber | Distinct Number | nVarChar | 36 | 0 | | |
| 9 | OSRN | Serial Numbers Master Data | 3 | DistNumber | Serial Number | nVarChar | 36 | 0 | | |
| 10 | UBTN | Batch Numbers Master Data | 3 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
| 11 | USRN | Serial Numbers Master Data | 3 | DistNumber | Serial Number | nVarChar | 36 | 0 | | |
| TOPMarketing Documents |
| 12 | GPA1 | Gross Profit Adjustment - Documents | 11 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
| 13 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 16 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
| 14 | GPA8 | Product Cost Adjustment - MRV Document Lines | 5 | DistNumber | Batch Number | nVarChar | 36 | 0 | | |
