| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGeneral |
1 | OTCN | Tracking Note | 5 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
2 | TCN1 | Tracking Note - Line Data | 6 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
TOPInventory and Production |
3 | AQI3 | Inventory Opening Balance - Tracking Note Assignment - History | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
4 | AQR4 | Inventory Opening Balance - Tracking Note Assignment - History | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
5 | IQI3 | Inventory Opening Balance - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
6 | IQR4 | Inventory Posting - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
7 | OTNL | CCD Log | 17 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
TOPMarketing Documents |
8 | ADO24 | Mktg Docs - Tracking Note Assignment - History | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
9 | CIN24 | Correction Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
10 | CPI24 | A/P Correction Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
11 | CPV24 | A/P Correction Invoice Reversal - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
12 | CSI24 | A/R Correction Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
13 | CSV24 | A/R Correction Invoice Reversal - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
14 | DLN24 | Delivery - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
15 | DOC24 | Mktg Docs - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
16 | DPI24 | A/R Down Payment - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
17 | DPO24 | A/P Down Payment - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
18 | DRF24 | Draft - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
19 | IEI24 | Incoming Excise Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
20 | IGE24 | Goods Issue - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
21 | IGN24 | Goods Receipt - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
22 | INV24 | A/R Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
23 | OEI24 | Outgoing Excise Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
24 | PCH24 | A/P Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
25 | PDN24 | Goods Receipt PO - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
26 | POR24 | Purchase Order - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
27 | PQT24 | Purchase Quotation - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
28 | PRQ24 | Purchase Request - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
29 | PRR24 | Goods Return Request - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
30 | QUT24 | Sales Quotation - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
31 | RDN24 | Returns - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
32 | RDR24 | Sales Order - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
33 | RIN24 | A/R Credit Memo - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
34 | RPC24 | A/P Credit Memo - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
35 | RPD24 | Goods Return - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
36 | RRR24 | Return Request - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
37 | SFC24 | Self Credit Memo - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
38 | SFI24 | Self Invoice - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
39 | WTQ24 | Inventory Transfer Request - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |
40 | WTR24 | Inventory Transfer - Tracking Note Assignment | 8 | CntrOrigin | Country of Origin | nVarChar | 3 | 0 | | |