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