| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPGeneral |
| 1 | OBVL | Serial Numbers and Batch Valuation Log | 8 | ManagedBy | Managed By | Int | 11 | 0 | -1 | 10000044=Batch Numbers, 10000045=Serial Numbers |
| 2 | UBVL | Serial Numbers and Batch Valuation Log | 8 | ManagedBy | Managed By | Int | 11 | 0 | -1 | 10000044=Batch Numbers, 10000045=Serial Numbers |
| TOPInventory and Production |
| 3 | AKL2 | Pick List for SnB and Bin Details | 5 | ManagedBy | Management Method | Int | 11 | 0 | -1 | -1=NOB, 10000044=BTN, 10000045=SRN |
| 4 | OITL | Inventory Transactions Log | 5 | ManagedBy | Management Method | Int | 11 | 0 | 4 | 10000044=BTN, 10000045=SRN, 4=ITM |
| 5 | PKL2 | Pick List for SnB and Bin Details | 5 | ManagedBy | Management Method | Int | 11 | 0 | -1 | -1=NOB, 10000044=BTN, 10000045=SRN |
| TOPMarketing Documents |
| 6 | GPA1 | Gross Profit Adjustment - Documents | 9 | ManagedBy | Managed By | Int | 11 | 0 | -1 | 10000044=Batch Numbers, 10000045=Serial Numbers |
| 7 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 18 | ManagedBy | Managed By | Int | 11 | 0 | -1 | 10000044=Batch Numbers, 10000045=Serial Numbers |
| 8 | GPA8 | Product Cost Adjustment - MRV Document Lines | 7 | ManagedBy | Managed By | Int | 11 | 0 | -1 | 10000044=Batch Numbers, 10000045=Serial Numbers |
| 9 | GPA9 | Applied Gross Profit Adjustments | 7 | ManagedBy | Managed By | Int | 11 | 0 | -1 | 10000044=Batch Numbers, 10000045=Serial Numbers |
| 10 | TGPA | Gross Profit Adjustment - Log | 10 | ManagedBy | Managed By | Int | 11 | 0 | -1 | 10000044=Batch Numbers, 10000045=Serial Numbers |
