| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | ABTN | Batch Numbers Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
2 | AQI3 | Inventory Opening Balance - Tracking Note Assignment - History | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
3 | AQR4 | Inventory Opening Balance - Tracking Note Assignment - History | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
4 | ASRN | Serial Numbers Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
5 | IQI3 | Inventory Opening Balance - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
6 | IQR4 | Inventory Posting - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
7 | OBTN | Batch Numbers Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
8 | OBTQ | Batch No. Quantities | 9 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
9 | ODBN | Bat. Nos - Draft - Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
10 | ODSN | SNs - Draft - Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
11 | OSRN | Serial Numbers Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
12 | OSRQ | Serial No. Quantities | 9 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
13 | UBTN | Batch Numbers Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
14 | USRN | Serial Numbers Master Data | 30 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
TOPMarketing Documents |
15 | ADO24 | Mktg Docs - Tracking Note Assignment - History | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
16 | CIN24 | Correction Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
17 | CPI24 | A/P Correction Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
18 | CPV24 | A/P Correction Invoice Reversal - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
19 | CSI24 | A/R Correction Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
20 | CSV24 | A/R Correction Invoice Reversal - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
21 | DLN24 | Delivery - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
22 | DOC24 | Mktg Docs - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
23 | DPI24 | A/R Down Payment - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
24 | DPO24 | A/P Down Payment - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
25 | DRF24 | Draft - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
26 | IEI24 | Incoming Excise Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
27 | IGE24 | Goods Issue - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
28 | IGN24 | Goods Receipt - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
29 | INV24 | A/R Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
30 | OEI24 | Outgoing Excise Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
31 | PCH24 | A/P Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
32 | PDN24 | Goods Receipt PO - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
33 | POR24 | Purchase Order - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
34 | PQT24 | Purchase Quotation - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
35 | PRQ24 | Purchase Request - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
36 | PRR24 | Goods Return Request - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
37 | QUT24 | Sales Quotation - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
38 | RDN24 | Returns - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
39 | RDR24 | Sales Order - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
40 | RIN24 | A/R Credit Memo - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
41 | RPC24 | A/P Credit Memo - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
42 | RPD24 | Goods Return - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
43 | RRR24 | Return Request - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
44 | SFC24 | Self Credit Memo - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
45 | SFI24 | Self Invoice - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
46 | WTQ24 | Inventory Transfer Request - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |
47 | WTR24 | Inventory Transfer - Tracking Note Assignment | 4 | TrackingNt | CCD Tracking Note | Int | 11 | 0 | | |