| 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 | AQR2 | Inventory Counting - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
5 | ATT1 | Bill of Materials - Components - History | 2 | ChildNum | Child Element No. | Int | 11 | 0 | | |
6 | ICD10 | Inventory Counting Draft - Individual Counter - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
7 | ICD2 | Inventory Counting Draft - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
8 | ICD6 | Inventory Counting Draft - Team Counter - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
9 | IGE14 | Goods Issue - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
10 | IGN14 | Goods Receipt - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
11 | INC10 | Inventory Counting - Individual Counters - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
12 | INC2 | Inventory Counting - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
13 | INC6 | Inventory Counting - Team Counter - Row UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
14 | IPD2 | Inventory Posting Draft - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
15 | IQR2 | Inventory Posting - UoM | 3 | ChildNum | Child Number | Int | 11 | 0 | | |
16 | ITT1 | Bill of Materials - Components | 2 | ChildNum | Component Element Number | Int | 11 | 0 | | |
17 | WTQ14 | Inventory Transfer Request - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
18 | WTR14 | Inventory Transfer - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
TOPMarketing Documents |
19 | ADO14 | Invoice - Assembly - Rows - History | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
20 | CPI14 | A/P Correction Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
21 | CPV14 | A/P Correction Invoice Reversal - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
22 | CSI14 | A/R Correction Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
23 | CSV14 | A/R Correction Invoice Reversal - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
24 | DLN14 | Delivery Notes - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
25 | DPI14 | A/R Down Payment - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
26 | DPO14 | A/P Down Payment - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
27 | DRF14 | Draft - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
28 | IEI14 | Incoming Excise Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
29 | INV14 | A/R Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
30 | OEI14 | Outgoing Excise Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
31 | PCH14 | A/P Invoice - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
32 | PDN14 | Goods Receipt PO - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
33 | POR14 | Purchase Order - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
34 | PQT14 | Purchase Quotation - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
35 | PRQ14 | Purchase Request - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
36 | QUT14 | Sales Quotation - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
37 | RDN14 | Return - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
38 | RDR14 | Sales Order - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
39 | RIN14 | A/R Credit Memo - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
40 | RPC14 | A/P Credit Memo - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |
41 | RPD14 | Goods Return - Assembly - Rows | 3 | ChildNum | Child Number | Int | 11 | 0 | -1 | |