| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | RLD1 | Reference Links Definition | 5 | OrderNum | Order Number | Int | 11 | 0 | | |
TOPInventory and Production |
2 | IGE10 | Goods Issue - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
3 | IGN10 | Goods Receipt - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
4 | OWKO | Production Instructions | 1 | OrderNum | Instruction Key | Int | 11 | 0 | 0 | |
5 | UWKO | Production Instructions | 1 | OrderNum | Instruction Key | Int | 11 | 0 | 0 | |
6 | UWKO1 | Production Instructions - Rows | 1 | OrderNum | Instruction Key | Int | 11 | 0 | | |
7 | WKO1 | Production Instructions - Rows | 1 | OrderNum | Instruction Key | Int | 11 | 0 | | |
8 | WTQ10 | Inventory Transfer Request - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
9 | WTR10 | Inventory Transfer - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
TOPMarketing Documents |
10 | ADO10 | A/R Invoice - Row Structure - History | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
11 | CIN10 | Correction Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
12 | CPI10 | A/P Correction Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
13 | CPV10 | A/P CrIn Rev - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
14 | CSI10 | A/R Correction Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
15 | CSV10 | A/R Correction Invoice Reversal - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
16 | DLN10 | Delivery - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
17 | DPI10 | A/R Down Payment - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
18 | DPO10 | A/P Down Payment - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
19 | DRF10 | Draft - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
20 | IEI10 | Incoming Excise Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
21 | INV10 | A/R Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
22 | OEI10 | Outgoing Excise Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
23 | PCH10 | A/P Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
24 | PDN10 | Goods Receipt PO - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
25 | POR10 | Purchase Order - Row structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
26 | PQT10 | Purchase Quotation - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
27 | PRQ10 | Purchase Request - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
28 | PRR10 | A/P Return Request - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
29 | QUT10 | Sales Quotation - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
30 | RDN10 | Returns - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
31 | RDR10 | Sales Order - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
32 | RIN10 | A/R Credit Memo - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
33 | RPC10 | A/P Credit Memo - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
34 | RPD10 | Goods Return - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
35 | RRR10 | A/R Return Request - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
36 | SFC10 | Self Credit Memo - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |
37 | SFI10 | Self Invoice - Row Structure | 4 | OrderNum | Order Number | Int | 11 | 0 | | |