| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | TRN2 | Subtable of OTRN | 3 | SubLineNum | Subline Number | Int | 11 | 0 | | |
TOPInventory and Production |
2 | IGE16 | Goods Issue - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
3 | IGN16 | Goods Receipt - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
4 | OAIM | Archive Inventory Message | 43 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
5 | OILM | Inventory Log Message | 57 | SubLineNum | Sub Line Number | Int | 11 | 0 | -1 | |
6 | OINM | Whse Journal | 62 | SubLineNum | Sub Line Number | Int | 11 | 0 | -1 | |
7 | OITL | Inventory Transactions Log | 30 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
8 | OIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
9 | SIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
10 | UILM | IVI Inventory Log Message | 57 | SubLineNum | Sub Line Number | Int | 11 | 0 | -1 | |
11 | UIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
12 | WTQ16 | Inventory Transfer Request - SnB Properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
13 | WTR16 | Inventory Transfer - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
TOPMarketing Documents |
14 | ADO16 | Draft - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
15 | CPI16 | A/P Corr. Inv - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
16 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
17 | CSI16 | A/R Corr. Inv. - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
18 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
19 | DLN16 | Delivery - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
20 | DPI16 | A/R Down Payment - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
21 | DPO16 | A/P Down Payment - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
22 | DRF16 | Draft - SnB - Rows | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
23 | IEI16 | Incoming Excise Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
24 | INV16 | A/R Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
25 | OEI16 | Outgoing Excise Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
26 | PCH16 | A/P Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
27 | PDN16 | Goods Receipt PO - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
28 | POR16 | Purchase Order - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
29 | PQT16 | Purchase Quotation - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
30 | QUT16 | Sales Quotation - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
31 | RDN16 | Returns - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
32 | RDR16 | Sales Order - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
33 | RIN16 | A/R Credit Memo - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
34 | RPC16 | A/P Credit Memo - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
35 | RPD16 | Goods Return - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |