| 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 | OBTA | Brazil - Tax Adjustment | 14 | PostDate | Posting Date | Date | 8 | 0 | | |
| TOPInventory and Production |
| 17 | AINC | Inventory Counting | 33 | PostDate | Posting Date | Date | 8 | 0 | | |
| 18 | AWOR | Production Order - History | 10 | PostDate | Posting Date | Date | 8 | 0 | | |
| 19 | OICD | Inventory Counting Draft | 33 | PostDate | Posting Date | Date | 8 | 0 | | |
| 20 | OINC | Inventory Counting | 33 | PostDate | Posting Date | Date | 8 | 0 | | |
| 21 | ORTL | Resource Transaction Log | 13 | PostDate | Posting Date | Date | 8 | 0 | | |
| 22 | OWOR | Production Order | 10 | PostDate | Posting Date | Date | 8 | 0 | | |
| 23 | UWOR | Production Order | 10 | PostDate | Posting Date | Date | 8 | 0 | | |
| 24 | WOR2V | Production Order - Base | 5 | PostDate | Posting Date | nVarChar | 8 | 0 | | |
| TOPMarketing Documents |
| 25 | GPA1 | Gross Profit Adjustment - Documents | 12 | PostDate | Posting Date | Date | 8 | 0 | | |
| 26 | GPA3 | Gross Profit Adjustment - JE Details | 2 | PostDate | Posting Date | Date | 8 | 0 | | |
| 27 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 13 | PostDate | Posting Date | Date | 8 | 0 | | |
| 28 | GPA7 | Product Cost Adjustment - Journal Entry Details | 2 | PostDate | Posting Date | Date | 8 | 0 | | |
