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