| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | TAX1 | VAT Transactions - Rows | 72 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
2 | UTX1 | Unreported VAT Transactions - Rows | 72 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
TOPInventory and Production |
3 | IGE4 | Goods Issue - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
4 | IGN4 | Goods Receipt - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
5 | WTQ4 | Inventory Transfer Request - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
6 | WTR4 | Inventory Transfer - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
TOPMarketing Documents |
7 | ADO4 | Documents - Tax - History | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
8 | CIN4 | Correction Invoice - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
9 | CPI4 | A/P Correction Invoice - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
10 | CPV4 | A/P Correction Invoice Reversal - Tax Amt per Doc. | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
11 | CSI4 | A/R Correction Invoice - Tax Amount Per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
12 | CSV4 | A/R Correction Invoice Reversal - Tax Amount Per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
13 | DLN4 | Delivery - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
14 | DPI4 | A/R Down Payment - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
15 | DPO4 | A/P Down Payment - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
16 | DRF4 | Draft Documents - Tax | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
17 | IEI4 | Incoming Excise Invoice - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
18 | INV4 | A/R Invoice - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
19 | OEI4 | Outgoing Excise Invoice - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
20 | PCH4 | A/P Invoice - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
21 | PDN4 | Goods Receipt PO - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
22 | POR4 | Purchase Order - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
23 | PQT4 | Purchase Quotation - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
24 | PRQ4 | Purchase Request - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
25 | PRR4 | A/P Return Request - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
26 | QUT4 | Sales Quotation - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
27 | RDN4 | Returns - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
28 | RDR4 | Sales Order - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
29 | RIN4 | A/R Credit Memo - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
30 | RPC4 | A/P Credit Memo - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
31 | RPD4 | Goods Return - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
32 | RRR4 | A/R Return Request - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
33 | SFC4 | Self Credit Memo - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |
34 | SFI4 | Self Invoice - Tax Amount per Document | 49 | Unencumbrd | Unencumbered | VarChar | 1 | 0 | N | N=No, Y=Yes |