| 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 | | |
6 | UXILM | IVI Irrelevant Message IDs | 5 | DocLineNum | Doc Row Number | Int | 11 | 0 | | |
TOPInventory and Production |
7 | AQI1 | Inventory Opening Balance - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
8 | AQR1 | Inventory Posting - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
9 | IOD1 | Inventory Opening Balance Draft - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
10 | IPD1 | Inventory Posting Draft - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
11 | IQI1 | Inventory Opening Balance - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
12 | IQR1 | Inventory Posting - Rows | 2 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
13 | OAIM | Archive Inventory Message | 4 | DocLineNum | Document Row Number | Int | 11 | 0 | | |
14 | OILM | Inventory Log Message | 4 | DocLineNum | Doc Line Number | Int | 11 | 0 | | |
15 | OIVL | Whse Journal | 4 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
16 | OTNL | CCD Log | 9 | DocLineNum | Doc Line Number | Int | 11 | 0 | | |
17 | SIVL | Whse Journal | 4 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
18 | UILM | IVI Inventory Log Message | 4 | DocLineNum | Doc Row Number | Int | 11 | 0 | | |
19 | UIVL | Whse Journal | 4 | DocLineNum | Row Number in Document | Int | 11 | 0 | | |
TOPMarketing Documents |
20 | ATR1 | Transportation Document Lines - History | 5 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
21 | GPA1 | Gross Profit Adjustment - Documents | 8 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
22 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 12 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
23 | GPA9 | Applied Gross Profit Adjustments | 5 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
24 | TGPA | Gross Profit Adjustment - Log | 9 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
25 | TRO1 | Lines of Transportation Document | 5 | DocLineNum | Document Line Number | Int | 11 | 0 | | |
TOPReports |
26 | SOI5 | Statement of Import - Lines | 6 | DocLineNum | Line No. | Int | 11 | 0 | | |