| 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 | AIN11 | Inventory Counting - Individual Counters - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
3 | AIN3 | Inventory Count - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
4 | AIN7 | Inventory Counting - Team Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
5 | AQI2 | Inventory Opening Balance - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
6 | AQR3 | Inventory Count - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
7 | ICD11 | Inventory Counting Draft - Individual Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
8 | ICD3 | Inventory Count Draft - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
9 | ICD7 | Inventory Counting Draft - Team Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
10 | IGE16 | Goods Issue - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
11 | IGE19 | Goods Issue - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
12 | IGN16 | Goods Receipt - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
13 | IGN19 | Goods Receipt - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
14 | INC11 | Inventory Counting - Individual Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
15 | INC3 | Inventory Count - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
16 | INC7 | Inventory Counting - Team Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
17 | IOD2 | Inventory Opening Balance Draft - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
18 | IPD3 | Inventory Posting Draft - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
19 | IQI2 | Inventory Opening Balance - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
20 | IQR3 | Inventory Posting - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
21 | OAIM | Archive Inventory Message | 43 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
22 | OILM | Inventory Log Message | 57 | SubLineNum | Sub Line Number | Int | 11 | 0 | -1 | |
23 | OITL | Inventory Transactions Log | 30 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
24 | OIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
25 | SIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
26 | UILM | IVI Inventory Log Message | 57 | SubLineNum | Sub Line Number | Int | 11 | 0 | -1 | |
27 | UIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
28 | WTQ16 | Inventory Transfer Request - SnB Properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
29 | WTQ19 | Inventory Transfer Request - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
30 | WTR16 | Inventory Transfer - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
31 | WTR19 | Inventory Transfer - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
TOPMarketing Documents |
32 | ADO16 | Draft - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
33 | ADO19 | Bin Allocation Data - History | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
34 | CIN19 | Correction Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
35 | CPI16 | A/P Corr. Inv - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
36 | CPI19 | A/P Correction Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
37 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
38 | CPV19 | A/P Correction Invoice Reversal - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
39 | CSI16 | A/R Corr. Inv. - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
40 | CSI19 | A/R Correction Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
41 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
42 | CSV19 | A/R Correction Invoice Reversal - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
43 | DLN16 | Delivery - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
44 | DLN19 | Delivery - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
45 | DPI16 | A/R Down Payment - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
46 | DPI19 | A/R Down Payment - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
47 | DPO16 | A/P Down Payment - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
48 | DPO19 | A/P Down Payment - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
49 | DRF16 | Draft - SnB - Rows | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
50 | DRF19 | Draft - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
51 | IEI16 | Incoming Excise Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
52 | IEI19 | Incoming Excise Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
53 | INV16 | A/R Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
54 | INV19 | A/R Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
55 | OEI16 | Outgoing Excise Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
56 | OEI19 | Outgoing Excise Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
57 | PCH16 | A/P Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
58 | PCH19 | A/P Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
59 | PDN16 | Goods Receipt PO - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
60 | PDN19 | Goods Receipt PO - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
61 | POR16 | Purchase Order - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
62 | POR19 | Purchase Order - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
63 | PQT16 | Purchase Quotation - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
64 | PQT19 | Purchase Quotation - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
65 | PRQ16 | Purchase Request - SnB Properties | 10 | SubLineNum | Sub-Row Number | Int | 11 | 0 | -1 | |
66 | PRQ19 | Purchase Request - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
67 | QUT16 | Sales Quotation - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
68 | QUT19 | Sales Quotation - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
69 | RDN16 | Returns - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
70 | RDN19 | Returns - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
71 | RDR16 | Sales Order - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
72 | RDR19 | Sales Order - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
73 | RIN16 | A/R Credit Memo - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
74 | RIN19 | A/R Credit Memo - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
75 | RPC16 | A/P Credit Memo - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
76 | RPC19 | A/P Credit Memo - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
77 | RPD16 | Goods Return - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
78 | RPD19 | Goods Return - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |