| 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 | 8 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | IGE19 | Goods Issue - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 3 | IGN19 | Goods Receipt - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 4 | PKL2 | Pick List for SnB and Bin Details | 8 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 5 | WTQ19 | Inventory Transfer Request - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 6 | WTR19 | Inventory Transfer - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPMarketing Documents |
| 7 | ADO19 | Bin Allocation Data - History | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 8 | CIN19 | Correction Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 9 | CPI19 | A/P Correction Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 10 | CPV19 | A/P Correction Invoice Reversal - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 11 | CSI19 | A/R Correction Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 12 | CSV19 | A/R Correction Invoice Reversal - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 13 | DLN19 | Delivery - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 14 | DPI19 | A/R Down Payment - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 15 | DPO19 | A/P Down Payment - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 16 | DRF19 | Draft - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 17 | IEI19 | Incoming Excise Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 18 | INV19 | A/R Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 19 | OEI19 | Outgoing Excise Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 20 | PCH19 | A/P Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 21 | PDN19 | Goods Receipt PO - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 22 | POR19 | Purchase Order - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 23 | PQT19 | Purchase Quotation - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 24 | PRQ19 | Purchase Request - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 25 | PRR19 | A/P Return Request - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 26 | QUT19 | Sales Quotation - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 27 | RDN19 | Returns - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 28 | RDR19 | Sales Order - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 29 | RIN19 | A/R Credit Memo - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 30 | RPC19 | A/P Credit Memo - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 31 | RPD19 | Goods Return - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 32 | RRR19 | A/R Return Request - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 33 | SFC19 | Self Credit Memo - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 34 | SFI19 | Self Invoice - Bin Allocation Data | 13 | AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | 0 | N | N=No, Y=Yes |
