| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AINF | Company Info | 190 | CreatedBy | Created By | VarChar | 1 | 0 | N | P=Solution Packager, W=Express Configuration Wizard |
| 2 | CINF | Company Info | 190 | CreatedBy | Created By | VarChar | 1 | 0 | N | P=Solution Packager, W=Express Configuration Wizard |
| TOPFinance |
| 3 | AFAD | Asset Document - History | 27 | CreatedBy | Original | Int | 11 | 0 | | |
| 4 | AJD1 | Journal Entry - History - Rows | 25 | CreatedBy | Origin | Int | 11 | 0 | | |
| 5 | AJDT | Journal Entry - History | 10 | CreatedBy | Original | Int | 11 | 0 | | |
| 6 | BTF1 | Journal Voucher - Rows | 25 | CreatedBy | Origin | Int | 11 | 0 | | |
| 7 | JDT1 | Journal Entry - Rows | 25 | CreatedBy | Origin | Int | 11 | 0 | | |
| 8 | OACD | Credit Memo | 27 | CreatedBy | Original | Int | 11 | 0 | | |
| 9 | OACQ | Capitalization | 27 | CreatedBy | Original | Int | 11 | 0 | | |
| 10 | OBTF | Journal Voucher Entry | 10 | CreatedBy | Origin | Int | 11 | 0 | | |
| 11 | OFTR | Transfer | 27 | CreatedBy | Original | Int | 11 | 0 | | |
| 12 | OJDT | Journal Entry | 10 | CreatedBy | Original | Int | 11 | 0 | | |
| 13 | OMDP | Manual Depreciation | 27 | CreatedBy | Original | Int | 11 | 0 | | |
| 14 | ORTI | Retirement | 27 | CreatedBy | Original | Int | 11 | 0 | | |
| TOPInventory and Production |
| 15 | AMRV | Inventory Revaluation - History | 32 | CreatedBy | Entry Creation Origin | VarChar | 1 | 0 | M | M=Created Manually by User, W=Created by Product Cost Recalculation Wizard |
| 16 | OIVL | Whse Journal | 2 | CreatedBy | Document Key Created | Int | 11 | 0 | | |
| 17 | OMRV | Inventory Revaluation | 32 | CreatedBy | Entry Creation Origin | VarChar | 1 | 0 | M | M=Created Manually by User, W=Created by Product Cost Recalculation Wizard |
| 18 | SIVL | Whse Journal | 2 | CreatedBy | Document Key Created | Int | 11 | 0 | | |
| 19 | UIVL | Whse Journal | 2 | CreatedBy | Document No. Created | Int | 11 | 0 | | |
| TOPService |
| 20 | OSLT | Service Call Solutions | 5 | CreatedBy | Created By | Int | 11 | 0 | | |
