| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | ISW3 | Declaration Rows | 8 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
TOPGeneral |
2 | OBVL | Serial Numbers and Batch Valuation Log | 3 | DocLineNum | Doc Line Number | Int | 11 | 0 | | |
3 | ODSL | Schedule Row Detail | 4 | DocLineNum | Associated Doc Row No. | Int | 11 | 0 | | |
4 | OSLD | Schedule Row Detail | 4 | DocLineNum | Associated Doc Row No. | Int | 11 | 0 | | |
5 | UBVL | Serial Numbers and Batch Valuation Log | 3 | DocLineNum | Doc. Line Number | Int | 11 | 0 | | |
TOPInventory and Production |
6 | AQI1 | Inventory Opening Balance - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
7 | AQR1 | Inventory Posting - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
8 | IOD1 | Inventory Opening Balance Draft - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
9 | IPD1 | Inventory Posting Draft - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
10 | IQI1 | Inventory Opening Balance - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
11 | IQR1 | Inventory Posting - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
12 | OAIM | Archive Inventory Message | 4 | DocLineNum | Document Row Number | Int | 11 | 0 | | |
13 | OILM | Inventory Log Message | 4 | DocLineNum | Doc Line Number | Int | 11 | 0 | | |
14 | OIVL | Whse Journal | 4 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
15 | SIVL | Whse Journal | 4 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
16 | UILM | IVI Inventory Log Message | 4 | DocLineNum | Doc Row Number | Int | 11 | 0 | | |
17 | UIVL | Whse Journal | 4 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
TOPMarketing Documents |
18 | GPA1 | Gross Profit Adjustment - Documents | 8 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
19 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 12 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
20 | GPA9 | Applied Gross Profit Adjustments | 5 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
21 | TGPA | Gross Profit Adjustment - Log | 9 | DocLineNum | Document Line Number | Int | 11 | 0 | | |