Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Transaction Tax Engine | ||||||||||
1 | TTED_ACQUISI_COM | Acquisition | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
2 | TTED_ATAXELE_COM | Acquisition: TaxElement | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
3 | TTED_ATAXVAL_COM | Acquisition:TaxValue | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
4 | TTED_CURRCON_COM | CurrencyConversions | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
5 | TTED_INEXEMP_COM | Exemptions | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
6 | TTED_INHEAD_COM | Input document header data | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
7 | TTED_INITEM_COM | Input item | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
8 | TTED_OCURCON_COM | Output CurrencyConversions | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
9 | TTED_OEXEMP_COM | Output Exemptions | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
10 | TTED_OTAXELE_COM | Output TaxElement | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
11 | TTED_OTAXSIT_COM | Output TaxSituation | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
12 | TTED_OTAXVAL_COM | Output TaxElement | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
13 | TTED_OUTHEAD_COM | Output document header data | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
14 | TTED_OUTITEM_COM | Output Item | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
15 | TTED_PARTNER_COM | Partner | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
16 | TTED_PARTN_O_COM | Partner in OutputDocument | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
17 | TTED_PATAXNO_COM | PartnerTaxNumbers | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
18 | TTED_PATXNOO_COM | PartnerTaxNumbers in OutputDocument | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
19 | TTED_PRIELES_COM | Input document pricing elements information | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
20 | TTED_PRODUCT_COM | Product | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
21 | TTED_PROUSAG_COM | ProductUsage | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
22 | TTED_TAXCLAO_COM | TaxClassification in OutputDocument | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
23 | TTED_TAXCLAS_COM | TaxClassification | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
24 | TTED_TAXDETE_COM | Input item | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
25 | TTED_TAXSITU_COM | TaxSituation | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
26 | TTEPD3_CURRCON | CurrencyConversions | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
27 | TTEPD3_EXEMP | Exemptions | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
28 | TTEPD3_HEADER | Header | 3 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
29 | TTEPD3_ITEM | Item | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
30 | TTEPD3_PARTNER | Partner | 3 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
31 | TTEPD3_PATAXNO | PartnerTaxNumber | 3 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
32 | TTEPD3_PRIELES | Pricing Element | 3 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
33 | TTEPD3_PRODUCT | Product | 3 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
34 | TTEPD3_PROUSAG | ProductUsage | 3 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
35 | TTEPD3_TAXCLAS | TaxClassification | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
36 | TTEPD3_TAXDETE | TaxDetermination | 3 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
37 | TTEPD3_TAXELE | TaxElement | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
38 | TTEPD3_TAXSITU | TaxSituation | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 | ||
39 | TTEPD3_TAXVAL | TaxValue | 4 | ITEMNODEID | Node ID | nvarchar | 12 | 0 |