| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTransaction Tax Engine |
1 | TTED_ATAXVAL_COM | Acquisition:TaxValue | 9 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
2 | TTED_INEXEMP_COM | Exemptions | 21 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
3 | TTED_OEXEMP_COM | Output Exemptions | 21 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
4 | TTED_OTAXVAL_COM | Output TaxElement | 9 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
5 | TTED_PRIELES_COM | Input document pricing elements information | 9 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
6 | TTEPD3_EXEMP | Exemptions | 21 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
7 | TTEPD3_PRIELES | Pricing Element | 8 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
8 | TTEPD3_TAXVAL | TaxValue | 9 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
9 | TTEPDT_EXEMPT | Persistency TTE Document Output Exemptions | 18 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
10 | TTEPDT_EXEMPVALU | Persistency TTE Document Item Exemption Value | 12 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
11 | TTEPDT_PRICEL | Persistency TTE Document / Item pricing element | 7 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
12 | TTEPDT_TAXCODVA | Document / Item TaxCode Value | 9 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
13 | TTEPDT_TAXVALUE | Persistency TTE Document / Item tax value | 14 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
14 | TTESDT_ACCUMVALU | Document business partner accum. values of with. tax. | 8 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
15 | TTESDT_EXEMPT | Output Exemptions | 18 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
16 | TTESDT_EXEMPVALU | Document business partner exemption values for with. tax. | 12 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
17 | TTESDT_PRICEL | Document / Item pricing element | 7 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
18 | TTESDT_TAXCODVA | Document / Item pricing element | 9 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
19 | TTESDT_TAXVALUE | Document / Item tax value | 14 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |
20 | TTE_WT_ACCUMVALU | AP-TTE accumulated base amounts and withholding tax amounts | 10 | CURRENCYUNIT | Currency Unit | nvarchar | 5 | 0 | | |