Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Transaction Tax Engine | ||||||||||
1 | TTED_ACQUISI_COM | Acquisition | 8 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
2 | TTED_OTAXSIT_COM | Output TaxSituation | 16 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
3 | TTED_PARTNER_COM | Partner | 14 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
4 | TTED_PARTN_O_COM | Partner in OutputDocument | 14 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
5 | TTED_TAXLOC_COM | Taxlocation | 10 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
6 | TTED_TAXSITU_COM | TaxSituation | 16 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
7 | TTEPD3_PARTNER | Partner | 13 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
8 | TTEPD3_TAXSITU | TaxSituation | 16 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
9 | TTEPDT_ITEMPART | Persistency TTE Document item partner | 12 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
10 | TTEPDT_PARTNER | Persistency TTE Document business partner | 10 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
11 | TTEPDT_TAXEL | Persistency TTE Document / Item tax element | 9 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
12 | TTEPDT_TAXVALUE | Persistency TTE Document / Item tax value | 9 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
13 | TTESDT_ITEMPART | Document item partner | 12 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
14 | TTESDT_PARTNER | Document business partner | 10 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
15 | TTESDT_TAXEL | Document / Item tax element | 9 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 | ||
16 | TTESDT_TAXVALUE | Document / Item tax value | 9 | JURISDICTIONCODE | Jurisdiction Code | nvarchar | 15 | 0 |