| 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 | AQI3 | Inventory Opening Balance - Tracking Note Assignment - History | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
7 | AQR3 | Inventory Count - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
8 | AQR4 | Inventory Opening Balance - Tracking Note Assignment - History | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
9 | ICD11 | Inventory Counting Draft - Individual Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
10 | ICD3 | Inventory Count Draft - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
11 | ICD7 | Inventory Counting Draft - Team Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
12 | IGE16 | Goods Issue - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
13 | IGE19 | Goods Issue - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
14 | IGN16 | Goods Receipt - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
15 | IGN19 | Goods Receipt - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
16 | INC11 | Inventory Counting - Individual Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
17 | INC3 | Inventory Count - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
18 | INC7 | Inventory Counting - Team Counter - Row SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
19 | IOD2 | Inventory Opening Balance Draft - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
20 | IPD3 | Inventory Posting Draft - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
21 | IQI2 | Inventory Opening Balance - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
22 | IQI3 | Inventory Opening Balance - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
23 | IQR3 | Inventory Posting - SnB | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
24 | IQR4 | Inventory Posting - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
25 | OAIM | Archive Inventory Message | 43 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
26 | OILM | Inventory Log Message | 57 | SubLineNum | Sub Line Number | Int | 11 | 0 | -1 | |
27 | OITL | Inventory Transactions Log | 30 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
28 | OIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
29 | SIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
30 | UILM | IVI Inventory Log Message | 57 | SubLineNum | Sub Line Number | Int | 11 | 0 | -1 | |
31 | UIVL | Whse Journal | 26 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
32 | WTQ16 | Inventory Transfer Request - SnB Properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
33 | WTQ19 | Inventory Transfer Request - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
34 | WTR16 | Inventory Transfer - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
35 | WTR19 | Inventory Transfer - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
TOPMarketing Documents |
36 | ADO16 | Draft - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
37 | ADO19 | Bin Allocation Data - History | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
38 | ADO24 | Mktg Docs - Tracking Note Assignment - History | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
39 | CIN19 | Correction Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
40 | CIN24 | Correction Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
41 | CPI16 | A/P Corr. Inv - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
42 | CPI19 | A/P Correction Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
43 | CPI24 | A/P Correction Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
44 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
45 | CPV19 | A/P Correction Invoice Reversal - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
46 | CPV24 | A/P Correction Invoice Reversal - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
47 | CSI16 | A/R Corr. Inv. - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
48 | CSI19 | A/R Correction Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
49 | CSI24 | A/R Correction Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
50 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
51 | CSV19 | A/R Correction Invoice Reversal - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
52 | CSV24 | A/R Correction Invoice Reversal - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
53 | DLN16 | Delivery - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
54 | DLN19 | Delivery - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
55 | DLN24 | Delivery - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
56 | DOC24 | Mktg Docs - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
57 | DPI16 | A/R Down Payment - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
58 | DPI19 | A/R Down Payment - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
59 | DPI24 | A/R Down Payment - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
60 | DPO16 | A/P Down Payment - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
61 | DPO19 | A/P Down Payment - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
62 | DPO24 | A/P Down Payment - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
63 | DRF16 | Draft - SnB - Rows | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
64 | DRF19 | Draft - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
65 | DRF24 | Draft - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
66 | IEI16 | Incoming Excise Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
67 | IEI19 | Incoming Excise Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
68 | IEI24 | Incoming Excise Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
69 | IGE24 | Goods Issue - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
70 | IGN24 | Goods Receipt - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
71 | INV16 | A/R Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
72 | INV19 | A/R Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
73 | INV24 | A/R Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
74 | OEI16 | Outgoing Excise Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
75 | OEI19 | Outgoing Excise Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
76 | OEI24 | Outgoing Excise Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
77 | PCH16 | A/P Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
78 | PCH19 | A/P Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
79 | PCH24 | A/P Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
80 | PDN16 | Goods Receipt PO - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
81 | PDN19 | Goods Receipt PO - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
82 | PDN24 | Goods Receipt PO - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
83 | POR16 | Purchase Order - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
84 | POR19 | Purchase Order - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
85 | POR24 | Purchase Order - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
86 | PQT16 | Purchase Quotation - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
87 | PQT19 | Purchase Quotation - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
88 | PQT24 | Purchase Quotation - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
89 | PRQ16 | Purchase Request - SnB Properties | 10 | SubLineNum | Sub-Row Number | Int | 11 | 0 | -1 | |
90 | PRQ19 | Purchase Request - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
91 | PRQ24 | Purchase Request - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
92 | PRR16 | A/P Return Request - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
93 | PRR19 | A/P Return Request - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
94 | PRR24 | Goods Return Request - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
95 | QUT16 | Sales Quotation - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
96 | QUT19 | Sales Quotation - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
97 | QUT24 | Sales Quotation - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
98 | RDN16 | Returns - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
99 | RDN19 | Returns - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
100 | RDN24 | Returns - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
101 | RDR16 | Sales Order - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
102 | RDR19 | Sales Order - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
103 | RDR24 | Sales Order - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
104 | RIN16 | A/R Credit Memo - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
105 | RIN19 | A/R Credit Memo - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
106 | RIN24 | A/R Credit Memo - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
107 | RPC16 | A/P Credit Memo - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
108 | RPC19 | A/P Credit Memo - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
109 | RPC24 | A/P Credit Memo - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
110 | RPD16 | Goods Return - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
111 | RPD19 | Goods Return - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
112 | RPD24 | Goods Return - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
113 | RRR16 | A/R Return Request - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
114 | RRR19 | A/R Return Request - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
115 | RRR24 | Return Request - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
116 | SFC16 | Self Credit Memo - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
117 | SFC19 | Self Credit Memo - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
118 | SFC24 | Self Credit Memo - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
119 | SFI16 | Self Invoice - SnB properties | 10 | SubLineNum | Subrow Number | Int | 11 | 0 | -1 | |
120 | SFI19 | Self Invoice - Bin Allocation Data | 4 | SubLineNum | Subline Number | Int | 11 | 0 | -1 | |
121 | SFI24 | Self Invoice - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
122 | WTQ24 | Inventory Transfer Request - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |
123 | WTR24 | Inventory Transfer - Tracking Note Assignment | 11 | SubLineNum | BOM Line No. | Int | 11 | 0 | | |