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