| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTransaction Tax Engine |
1 | TTEC_SYS_REG | TTE Calling System Registry | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
2 | TTEC_SYS_REG2 | TTE Calling System Registry | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
3 | TTEC_SYS_SRC | TTE Customizing Client | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
4 | TTED_INHEAD_COM | Input document header data | 13 | SYSTEMID1 | System ID 1 | nvarchar | 32 | 0 | | |
5 | TTEM_ACCKEY | Mapping: Account Determination Key | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
6 | TTEM_BPTXGRP2 | Mapping: Business Partner Tax Group | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
7 | TTEM_BUSPRTYP | [Not used] Mapping: Business Process Type | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
8 | TTEM_PARTNERID | [TTE 3.0 only] Mapping: Partner Id | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
9 | TTEM_PARTNERID2 | Mapping: Business Partner Id | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
10 | TTEM_PATXGRP | [Obsolete] Mapping: Partner Taxability Group | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
11 | TTEM_PATXTYP | [Not used] Mapping: Partner Taxability Type | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
12 | TTEM_PRODUCTID | [TTE 3.0 only] Mapping: Product Id | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
13 | TTEM_PRODUCTID2 | Mapping: Product Id | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
14 | TTEM_PRTXGRP | [Obsolete] Mapping: Product taxability group | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
15 | TTEM_PRTXGRP2 | Mapping: Product Tax Group | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
16 | TTEM_PRTXTYP | [Not used] Mapping: Product Taxability Type | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
17 | TTEM_ROLE | [Not used] Mapping: Partner Roles | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
18 | TTEM_TAXCODE | Mapping: Tax Code | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
19 | TTEM_TAXTYPE | [Obsolete] Mapping: Tax Type | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
20 | TTEM_TAXTYPE2 | Mapping: Tax Type | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
21 | TTEM_TAXTYPEC | [TTE 3.0 only] Mapping: Tax Type | 2 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
22 | TTEM_USAGE | [Not used] Mapping: Usage Indicator | 1 | SYSTEMID1 | TTE Calling System Identifier | nvarchar | 32 | 0 | | |
23 | TTEPD3_HEADER | Header | 11 | SYSTEMID1 | System ID 1 | nvarchar | 32 | 0 | | |
24 | TTEPDT_HEADER | Persistency TTE Document Header | 9 | SYSTEMID1 | System ID 1 | nvarchar | 32 | 0 | | |
25 | TTESDT_HEADER | Document header | 9 | SYSTEMID1 | System ID 1 | nvarchar | 32 | 0 | | |