| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AKL2 | Pick List for SnB and Bin Details | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
2 | IGE19 | Goods Issue - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
3 | IGN19 | Goods Receipt - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
4 | ITW1 | Item Count Alert | 10 | BinAbs | Bin Internal Number | Int | 11 | 0 | -1 | |
5 | OBBQ | Item - Serial/Batch - Bin Accumulator | 4 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
6 | OBTL | Bin Transaction Log | 3 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
7 | OIBQ | Item - Bin Accumulator | 3 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
8 | OSBQ | Item - Serial/Batch - Bin Accumulator | 4 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
9 | PKL2 | Pick List for SnB and Bin Details | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
10 | WTQ19 | Inventory Transfer Request - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
11 | WTR19 | Inventory Transfer - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
TOPMarketing Documents |
12 | ADO19 | Bin Allocation Data - History | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
13 | CIN19 | Correction Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
14 | CPI19 | A/P Correction Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
15 | CPV19 | A/P Correction Invoice Reversal - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
16 | CSI19 | A/R Correction Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
17 | CSV19 | A/R Correction Invoice Reversal - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
18 | DLN19 | Delivery - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
19 | DPI19 | A/R Down Payment - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
20 | DPO19 | A/P Down Payment - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
21 | DRF19 | Draft - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
22 | IEI19 | Incoming Excise Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
23 | INV19 | A/R Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
24 | OEI19 | Outgoing Excise Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
25 | PCH19 | A/P Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
26 | PDN19 | Goods Receipt PO - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
27 | POR19 | Purchase Order - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
28 | PQT19 | Purchase Quotation - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
29 | PRQ19 | Purchase Request - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
30 | PRR19 | A/P Return Request - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
31 | QUT19 | Sales Quotation - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
32 | RDN19 | Returns - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
33 | RDR19 | Sales Order - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
34 | RIN19 | A/R Credit Memo - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
35 | RPC19 | A/P Credit Memo - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
36 | RPD19 | Goods Return - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
37 | RRR19 | A/R Return Request - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
38 | SFC19 | Self Credit Memo - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |
39 | SFI19 | Self Invoice - Bin Allocation Data | 7 | BinAbs | Bin Internal Number | Int | 11 | 0 | | |