| 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 | B=Box Declaration, S=BAS Reporting |
3 | BOX3 | Box Definition - Choice | 2 | ReportType | Report Type | VarChar | 1 | 0 | B | B=Box Declaration, S=BAS Reporting |
4 | OBOX | Box Definition | 9 | ReportType | Report Type | VarChar | 1 | 0 | B | B=Box Declaration, S=BAS Report |
TOPMarketing Documents |
5 | OVRT | Tax Invoice Report | 11 | ReportType | VAT: Tax Report Type ID | Int | 11 | 0 | | |
TOPReports |
6 | 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 |
7 | OTRS | Tax Report Saving Object | 3 | ReportType | Report Type | Int | 11 | 0 | | 1=VAT Report (UK) |