| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ODCI | Intrastat Configuration | 10 | DateFrom | Valid From | Date | 8 | 0 | | |
TOPBusiness Partners |
2 | ACRD | Business Partners - History | 315 | DateFrom | Relationship Initial Date | Date | 8 | 0 | | |
3 | AWD3 | WTax Codes Details for BP | 6 | DateFrom | Effective Date From | Date | 8 | 0 | | |
4 | AWD4 | WTax Codes Details for Item | 5 | DateFrom | Effective Date From | Date | 8 | 0 | | |
5 | AWD5 | WTax Codes Details for Freight | 5 | DateFrom | Effective Date From | Date | 8 | 0 | | |
6 | OCRD | Business Partner | 315 | DateFrom | Relationship Initial Date | Date | 8 | 0 | | |
7 | ODDT | Withholding Tax Deduction Hierarchy | 5 | DateFrom | Valid From | Date | 8 | 0 | | |
8 | WTD3 | WTax Codes Details for BP | 6 | DateFrom | Effective Date From | Date | 8 | 0 | | |
9 | WTD4 | WTax Codes Details for Item | 5 | DateFrom | Effective Date From | Date | 8 | 0 | | |
10 | WTD5 | WTax Codes Details for Freight | 5 | DateFrom | Effective Date From | Date | 8 | 0 | | |
TOPFinance |
11 | AWD1 | Withholding Tax Dates | 3 | DateFrom | Effective From | Date | 8 | 0 | | |
12 | OISW | Intrastat Wizard | 3 | DateFrom | Starting Date of Declaration | Date | 8 | 0 | | |
13 | OSLM | Special Ledger - Analytical Accounting Report: Material | 6 | DateFrom | Document Start Date | Date | 8 | 0 | | |
14 | OSLR | Special Ledger - Analytical Accounting Report: Revenues & Expenses | 6 | DateFrom | Document Start Date | Date | 8 | 0 | | |
15 | OVRW | VAT Reposting Wizard | 12 | DateFrom | Date From | Date | 8 | 0 | | |
16 | WTD1 | Withholding Tax Dates | 3 | DateFrom | Effective From | Date | 8 | 0 | | |
TOPGeneral |
17 | SEWBU | SEWBU | 7 | DateFrom | Bck Date From | nVarChar | 10 | 0 | | |
TOPReports |
18 | AEC2 | Electronic Transactions | 17 | DateFrom | Report - Date From | Date | 8 | 0 | | |
19 | ECM2 | Electronic Transactions | 17 | DateFrom | Report - Date From | Date | 8 | 0 | | |
20 | OAMD | Amount Differences Report | 2 | DateFrom | Date From | Date | 8 | 0 | | |
21 | OECDW | ECD Wizard | 7 | DateFrom | Date From | Date | 8 | 0 | | |
22 | OEFDW | EFD Wizard | 7 | DateFrom | Date From | Date | 8 | 0 | | |