| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | IGE19 | Goods Issue - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
2 | IGN19 | Goods Receipt - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
3 | WTQ19 | Inventory Transfer Request - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
4 | WTR19 | Inventory Transfer - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
TOPMarketing Documents |
5 | ADO19 | Bin Allocation Data - History | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
6 | CIN19 | Correction Invoice - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
7 | CPI19 | A/P Correction Invoice - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
8 | CPV19 | A/P Correction Invoice Reversal - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
9 | CSI19 | A/R Correction Invoice - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
10 | CSV19 | A/R Correction Invoice Reversal - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
11 | DLN19 | Delivery - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
12 | DPI19 | A/R Down Payment - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
13 | DPO19 | A/P Down Payment - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
14 | DRF19 | Draft - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
15 | IEI19 | Incoming Excise Invoice - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
16 | INV19 | A/R Invoice - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
17 | OEI19 | Outgoing Excise Invoice - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
18 | PCH19 | A/P Invoice - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
19 | PDN19 | Goods Receipt PO - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
20 | POR19 | Purchase Order - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
21 | PQT19 | Purchase Quotation - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
22 | PRQ19 | Purchase Request - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
23 | QUT19 | Sales Quotation - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
24 | RDN19 | Returns - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
25 | RDR19 | Sales Order - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
26 | RIN19 | A/R Credit Memo - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
27 | RPC19 | A/P Credit Memo - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |
28 | RPD19 | Goods Return - Bin Allocation Data | 14 | BinActTyp | Bin Action Type | Int | 6 | 0 | | 1=Transaction In, 2=Transaction Out, 4=SnB Complete, 8=Bin First Then SnB |