| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AWO5 | Production Order - Document Reference Information - History | 7 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
2 | IGE21 | Goods Issue - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
3 | IGN21 | Goods Receipt - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
4 | UWOR5 | Production Order - Document Reference Information | 7 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
5 | WOR5 | Production Order - Document Reference Information | 7 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
6 | WTQ21 | Inventory Transfer Request - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
7 | WTR21 | Inventory Transfer - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
TOPMarketing Documents |
8 | ADO21 | A/R Invoice - Document Reference Information - History | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
9 | ATX3 | Tax Invoice Archive - Document Reference Information | 7 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
10 | CIN21 | Correction Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
11 | CPI21 | A/P Correction Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
12 | CPV21 | A/P Correction Invoice Reversal - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
13 | CSI21 | A/R Correction Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
14 | CSV21 | A/R Correction Invoice Reversal - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
15 | DLN21 | Delivery - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
16 | DPI21 | A/R Down Payment - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
17 | DPO21 | A/P Down Payment - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
18 | DRF21 | Draft - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
19 | IEI21 | Incoming Excise Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
20 | INV21 | A/R Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
21 | OEI21 | Outgoing Excise Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
22 | PCH21 | A/P Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
23 | PDN21 | Goods Receipt PO - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
24 | POR21 | Purchase Order - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
25 | PQT21 | Purchase Quotation - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
26 | PRQ21 | Purchase Request - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
27 | PRR21 | A/P Return Request - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
28 | QUT21 | Sales Quotation - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
29 | RDN21 | Returns - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
30 | RDR21 | Sales Order - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
31 | RIN21 | A/R Credit Memo - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
32 | RPC21 | A/P Credit Memo - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
33 | RPD21 | Goods Return - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
34 | RRR21 | A/R Return Request - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
35 | SFC21 | Self Credit Memo - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
36 | SFI21 | Self Invoice - Document Reference Information | 8 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
37 | TPI3 | Purchase Tax Invoice - Document Reference Information | 7 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
38 | TSI3 | Sales Tax Invoice - Document Reference Information | 7 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |
39 | TXD3 | Tax Invoice Draft - Document Reference Information | 7 | ExtDocNum | External Referenced Document Number | nVarChar | 100 | 0 | | |