| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | DAR1 | Data Archive - Transaction Log | 5 | DocAbs | Document Internal ID | Int | 11 | 0 | | |
2 | DAR2 | Data Archive - Transaction Log | 6 | DocAbs | Document Abs Entry | Int | 11 | 0 | | |
3 | DAR3 | Data Archive - Handwritten Documents | 4 | DocAbs | Doc. No. | Int | 11 | 0 | | |
4 | TDR1 | Can Be Archive | 12 | DocAbs | Document Internal ID | Int | 11 | 0 | | |
TOPMarketing Documents |
5 | DWZ2 | Dunning Wizard Array 2-Invoice Filter | 9 | DocAbs | Document Internal Number | Int | 11 | 0 | | |
6 | DWZ3 | Dunning Wizard Array 3 - Recommended Service Invoice | 5 | DocAbs | Internal Document Number | Int | 11 | 0 | | |
7 | GPA1 | Gross Profit Adjustment - Documents | 7 | DocAbs | Document Abs. Entry | Int | 11 | 0 | | |
8 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 10 | DocAbs | Document Abs. Entry | Int | 11 | 0 | | |
9 | GPA9 | Applied Gross Profit Adjustments | 3 | DocAbs | Document Abs. Entry | Int | 11 | 0 | | |
10 | TGPA | Gross Profit Adjustment - Log | 8 | DocAbs | Document Abs. Entry | Int | 11 | 0 | | |
TOPService |
11 | ASC4 | Service Call Travel/Labor Expenses - History | 4 | DocAbs | Document Internal Number | Int | 11 | 0 | | |
12 | SCL4 | Expense Documents | 4 | DocAbs | Document Internal Number | Int | 11 | 0 | | |