| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AIN10 | Inventory Counting - Individual Counters - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
2 | AIN2 | Inventory Counting - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
3 | AIN6 | Inventory Counting - Team Counter - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
4 | AQI3 | Inventory Opening Balance - Tracking Note Assignment - History | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
5 | AQR2 | Inventory Counting - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
6 | AQR4 | Inventory Opening Balance - Tracking Note Assignment - History | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
7 | ATT1 | Bill of Materials - Components - History | 2 | ChildNum | Child Element No. | Int | 11 | 0 | | |
8 | ICD10 | Inventory Counting Draft - Individual Counter - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
9 | ICD2 | Inventory Counting Draft - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
10 | ICD6 | Inventory Counting Draft - Team Counter - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
11 | IGE14 | Goods Issue - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
12 | IGN14 | Goods Receipt - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
13 | INC10 | Inventory Counting - Individual Counters - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
14 | INC2 | Inventory Counting - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
15 | INC6 | Inventory Counting - Team Counter - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
16 | IPD2 | Inventory Posting Draft - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
17 | IQI3 | Inventory Opening Balance - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
18 | IQR2 | Inventory Posting - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
19 | IQR4 | Inventory Posting - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
20 | ITT1 | Bill of Materials - Components | 2 | ChildNum | Component Element Number | Int | 11 | 0 | | |
21 | WTQ14 | Inventory Transfer Request - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
22 | WTR14 | Inventory Transfer - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
TOPMarketing Documents |
23 | ADO14 | Invoice - Assembly - Rows - History | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
24 | ADO24 | Mktg Docs - Tracking Note Assignment - History | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
25 | CIN24 | Correction Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
26 | CPI14 | A/P Correction Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
27 | CPI24 | A/P Correction Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
28 | CPV14 | A/P Correction Invoice Reversal - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
29 | CPV24 | A/P Correction Invoice Reversal - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
30 | CSI14 | A/R Correction Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
31 | CSI24 | A/R Correction Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
32 | CSV14 | A/R Correction Invoice Reversal - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
33 | CSV24 | A/R Correction Invoice Reversal - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
34 | DLN14 | Delivery Notes - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
35 | DLN24 | Delivery - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
36 | DOC24 | Mktg Docs - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
37 | DPI14 | A/R Down Payment - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
38 | DPI24 | A/R Down Payment - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
39 | DPO14 | A/P Down Payment - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
40 | DPO24 | A/P Down Payment - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
41 | DRF14 | Draft - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
42 | DRF24 | Draft - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
43 | IEI14 | Incoming Excise Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
44 | IEI24 | Incoming Excise Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
45 | IGE24 | Goods Issue - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
46 | IGN24 | Goods Receipt - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
47 | INV14 | A/R Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
48 | INV24 | A/R Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
49 | OEI14 | Outgoing Excise Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
50 | OEI24 | Outgoing Excise Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
51 | PCH14 | A/P Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
52 | PCH24 | A/P Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
53 | PDN14 | Goods Receipt PO - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
54 | PDN24 | Goods Receipt PO - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
55 | POR14 | Purchase Order - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
56 | POR24 | Purchase Order - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
57 | PQT14 | Purchase Quotation - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
58 | PQT24 | Purchase Quotation - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
59 | PRQ14 | Purchase Request - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
60 | PRQ24 | Purchase Request - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
61 | PRR14 | A/P Return Request - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
62 | PRR24 | Goods Return Request - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
63 | QUT14 | Sales Quotation - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
64 | QUT24 | Sales Quotation - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
65 | RDN14 | Return - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
66 | RDN24 | Returns - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
67 | RDR14 | Sales Order - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
68 | RDR24 | Sales Order - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
69 | RIN14 | A/R Credit Memo - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
70 | RIN24 | A/R Credit Memo - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
71 | RPC14 | A/P Credit Memo - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
72 | RPC24 | A/P Credit Memo - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
73 | RPD14 | Goods Return - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
74 | RPD24 | Goods Return - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
75 | RRR14 | A/R Return Request - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
76 | RRR24 | Return Request - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
77 | SFC14 | Self Credit Memo - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
78 | SFC24 | Self Credit Memo - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
79 | SFI14 | Self Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
80 | SFI24 | Self Invoice - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
81 | WTQ24 | Inventory Transfer Request - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |
82 | WTR24 | Inventory Transfer - Tracking Note Assignment | 3 | ChildNum | Assignment Line | Int | 11 | 0 | | |