| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMarketing Documents |
1 | ADO17 | A/R Invoice - Import Process - History | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
2 | CIN17 | Correction Invoice - Bin Allocation Data | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
3 | CPI17 | A/P Correction Invoice - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
4 | CPV17 | A/P Correction Invoice Reversal - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
5 | CSI17 | A/R Correction Invoice - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
6 | CSV17 | A/R Correction Invoice Reversal - Bin Allocation Data | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
7 | DLN17 | Delivery - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
8 | DPI17 | A/R Down Payment - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
9 | DPO17 | A/P Down Payment - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
10 | DRF17 | Draft - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
11 | IEI17 | Incoming Excise Invoice - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
12 | IGE17 | Goods Issue - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
13 | IGN17 | Goods Receipt - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
14 | INV17 | A/R Invoice - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
15 | OEI17 | Outgoing Excise Invoice - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
16 | PCH17 | A/P Invoice - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
17 | PDN17 | Goods Receipt PO - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
18 | POR17 | Purchase Order - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
19 | PQT17 | Purchase Quotation - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
20 | PRQ17 | Purchase Request - Bin Allocation Data | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
21 | QUT17 | Sales Quotation - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
22 | RDN17 | Returns - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
23 | RDR17 | Sales Order - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
24 | RIN17 | A/R Credit Memo - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
25 | RPC17 | A/P Credit Memo - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
26 | RPD17 | Goods Return - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
27 | WTQ17 | Inventory Transfer Request - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |
28 | WTR17 | Inventory Transfer - Import Process | 12 | tpVTransp | Overland Transport Route | Int | 6 | 0 | | 10=Input/Output Fictitious, 1=Maritime, 2=Waterway, 3=Lakeside, 4=Air, 5=Post, 6=Train, 7=Road, 8=Network Transmission, 9=Own Means |