| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ODGP | Document Generation Parameter Sets | 8 | PostDate | Posting Date | Date | 8 | 0 | | |
| 2 | OTOB | 1099 Opening Balance | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| TOPBanking |
| 3 | OBOT | Bill Of Exchang Transaction | 9 | PostDate | Posting Date | Date | 8 | 0 | | |
| 4 | PWZ3 | Payment Wizard - Rows 3 | 13 | PostDate | Posting Date | Date | 8 | 0 | | |
| 5 | PWZ5 | Payment Wizard - Rows 5 | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 6 | RTW2 | Boleto Retorno Wizard: Import Archive | 11 | PostDate | Posting Date | Date | 8 | 0 | | |
| TOPFinance |
| 7 | AFAD | Asset Document - History | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 8 | OACD | Credit Memo | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 9 | OACQ | Capitalization | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 10 | OCFT | Cash Flow Transactions - Rows | 18 | PostDate | Posting Date | Date | 8 | 0 | | |
| 11 | OFAR | Fixed Asset Revaluation | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 12 | OFTR | Transfer | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 13 | OMDP | Manual Depreciation | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 14 | ORTI | Retirement | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 15 | OVRW | VAT Reposting Wizard | 8 | PostDate | Posting Date | Date | 8 | 0 | | |
| TOPGeneral |
| 16 | AIRI | Input Service Distribution - Recipient Invoice | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 17 | AIRR | Input Service Distribution - Recipient Credit Memo | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 18 | AISC | Input Service Distribution - Credit Memo | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 19 | AISD | Input Service Distribution | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 20 | AISI | Input Service Distribution - Invoice | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 21 | OBTA | Brazil - Tax Adjustment | 14 | PostDate | Posting Date | Date | 8 | 0 | | |
| 22 | OIRI | Input Service Distribution - Recipient Invoice | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 23 | OIRR | Input Service Distribution - Recipient Credit Memo | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 24 | OISC | Input Service Distribution - Credit Memo | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| 25 | OISD | Input Service Distribution | 6 | PostDate | Posting Date | Date | 8 | 0 | | |
| 26 | OISI | Input Service Distribution - Invoice | 4 | PostDate | Posting Date | Date | 8 | 0 | | |
| TOPInventory and Production |
| 27 | AINC | Inventory Counting | 33 | PostDate | Posting Date | Date | 8 | 0 | | |
| 28 | AWOR | Production Order - History | 10 | PostDate | Order Date | Date | 8 | 0 | | |
| 29 | OICD | Inventory Counting Draft | 33 | PostDate | Posting Date | Date | 8 | 0 | | |
| 30 | OINC | Inventory Counting | 33 | PostDate | Posting Date | Date | 8 | 0 | | |
| 31 | ORTL | Resource Transaction Log | 13 | PostDate | Posting Date | Date | 8 | 0 | | |
| 32 | OWOR | Production Order | 10 | PostDate | Order Date | Date | 8 | 0 | | |
| 33 | UWOR | Production Order | 10 | PostDate | Order Date | Date | 8 | 0 | | |
| 34 | WOR2V | Production Order - Base | 5 | PostDate | Posting Date | nVarChar | 8 | 0 | | |
| TOPMarketing Documents |
| 35 | ATRO | Transportation Document - History | 3 | PostDate | Posting Date | Date | 8 | 0 | | |
| 36 | GPA1 | Gross Profit Adjustment - Documents | 12 | PostDate | Posting Date | Date | 8 | 0 | | |
| 37 | GPA3 | Gross Profit Adjustment - JE Details | 2 | PostDate | Posting Date | Date | 8 | 0 | | |
| 38 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 13 | PostDate | Posting Date | Date | 8 | 0 | | |
| 39 | GPA7 | Product Cost Adjustment - Journal Entry Details | 2 | PostDate | Posting Date | Date | 8 | 0 | | |
| 40 | OTRO | Transportation Document | 3 | PostDate | Posting Date | Date | 8 | 0 | | |
