| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMarketing Documents |
1 | ADO17 | A/R Invoice - Import Process - History | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
2 | CIN17 | Correction Invoice - Bin Allocation Data | 10 | AdditNum | Warehouse Code | nVarChar | 30 | 0 | | |
3 | CPI17 | A/P Correction Invoice - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
4 | CPV17 | A/P Correction Invoice Reversal - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
5 | CSI17 | A/R Correction Invoice - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
6 | CSV17 | A/R Correction Invoice Reversal - Bin Allocation Data | 10 | AdditNum | Warehouse Code | nVarChar | 30 | 0 | | |
7 | DLN17 | Delivery - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
8 | DPI17 | A/R Down Payment - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
9 | DPO17 | A/P Down Payment - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
10 | DRF17 | Draft - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
11 | IEI17 | Incoming Excise Invoice - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
12 | IGE17 | Goods Issue - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
13 | IGN17 | Goods Receipt - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
14 | INV17 | A/R Invoice - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
15 | OEI17 | Outgoing Excise Invoice - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
16 | PCH17 | A/P Invoice - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
17 | PDN17 | Goods Receipt PO - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
18 | POR17 | Purchase Order - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
19 | PQT17 | Purchase Quotation - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
20 | PRQ17 | Purchase Request - Bin Allocation Data | 10 | AdditNum | Warehouse Code | nVarChar | 30 | 0 | | |
21 | PRR17 | A/P Return Request - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
22 | QUT17 | Sales Quotation - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
23 | RDN17 | Returns - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
24 | RDR17 | Sales Order - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
25 | RIN17 | A/R Credit Memo - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
26 | RPC17 | A/P Credit Memo - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
27 | RPD17 | Goods Return - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
28 | RRR17 | A/R Return Request - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
29 | SFC17 | Self Credit Memo - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
30 | SFI17 | Self Invoice - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
31 | WTQ17 | Inventory Transfer Request - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |
32 | WTR17 | Inventory Transfer - Import Process | 10 | AdditNum | Additional Number | nVarChar | 30 | 0 | | |