| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinance |
| 1 | BOX1 | Box Definition - Rows | 6 | ReportType | Report Type | VarChar | 1 | 0 | B | B=Box Declaration, S=BAS Reporting |
| 2 | BOX2 | Box Definition - Accounts | 2 | ReportType | Report Type | VarChar | 1 | 0 | B | |
| 3 | BOX3 | Box Definition - Choice | 2 | ReportType | Report Type | VarChar | 1 | 0 | B | |
| 4 | BOX4 | Box Definition - Contra Accounts of Accounts | 1 | ReportType | Report Type | VarChar | 1 | 0 | B | |
| 5 | OBOS | Box Set Definition | 6 | ReportType | Report Type | VarChar | 1 | 0 | S | B=Box Declaration, S=BAS Report |
| 6 | OBOX | Box Definition | 9 | ReportType | Report Type | VarChar | 1 | 0 | B | B=Box Declaration, S=BAS Report, X=BAS Report - Empty Effective Date Holder |
| 7 | ORTS | CPI and FC Rates for Reports | 6 | ReportType | Report Rate Type | VarChar | 1 | 0 | S | I=Intrastat Exchange Rate, S=Standard Report Rate |
| TOPMarketing Documents |
| 8 | OVRT | Tax Invoice Report | 11 | ReportType | VAT: Tax Report Type ID | Int | 11 | 0 | | |
| TOPReports |
| 9 | EBL1 | E-Balance Report Data | 3 | ReportType | Report Type | Int | 11 | 0 | 0 | -1=Global Common Data, -2=Global Common Report Data, 1=E-General Information GCD (Global Common Document), 2=e-Balance Sheet, 3=e-Profit and Loss, 4=E-Taxable Profit and Loss, 5=E-Income Usage, 6=E-Assets History Sheet, 7=Shareholder, 8=Account Verification |
| 10 | OECDW | ECD Wizard | 14 | ReportType | Report Type | VarChar | 1 | 0 | | A=Livro Diário Auxiliar ao Diário com Escrituração Resumida, B=Livro Balancetes Diários e Balanços (matriz), G=Livro Diário, R=Livro Diário com Escrituração Resumida |
| 11 | ORFL | Already Displayed 347, 349 and WTax Reports | 1 | ReportType | Report Type | Int | 11 | 0 | | 1=347, 2=349, 3=WT, 4=O & P, 5=Annual List, 6=Tax Report |
| 12 | OSRA | Scheduled Report Actions | 9 | ReportType | Report Type | Int | 11 | 0 | 0 | 0=Invalid, 115=User Query, 6000=Inventory Valuation, 857=Sales/Purchase Analysis |
| 13 | OTRS | Tax Report Saving Object | 3 | ReportType | Report Type | Int | 11 | 0 | | 1=VAT Report (UK) |
