| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBPD_SUS_BP_DUPL | SUS/BP: Staging Table for Duplicate Check | 7 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
2 | BBP_PCPOS | Procurement Card Statement: Position Data | 53 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
3 | BBP_SUS_STG_ADR | Staging address table | 33 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
4 | BBP_SUS_STG_FAX | Staging address table | 5 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
5 | BBP_SUS_STG_TEL | Staging table for telephone | 5 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
6 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 34 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
7 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 34 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
8 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 74 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
9 | PIQDB_NL_ADDR | Maintain GBA Address | 36 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | | |
TOPTransaction Tax Engine |
10 | TTE2C_AGGREG | Country Specific Rule Assignments | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
11 | TTE2C_AUTHID | Tax Authority | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
12 | TTE2C_AUTHID_T | Tax Authority Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
13 | TTE2C_BPPRPTYP | Business Partner Property Type | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
14 | TTE2C_BPPRPTYP_T | Product Property Type Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
15 | TTE2C_BPPRPVAL | Business Partner Properties | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
16 | TTE2C_BPPRPVAL_T | Business Partner Properties | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
17 | TTE2C_BPTXGRP | Business Partner Tax Group | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
18 | TTE2C_BPTXGRP_T | Description for Business Partner Tax Group | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
19 | TTE2C_CHECK | TTE Entity Checking Master Table | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
20 | TTE2C_CNTY_COMM | Country / Community Assignment | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
21 | TTE2C_DEDREAS | Deductibility Reason | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
22 | TTE2C_DEDREAS_T | Description for Deductibility Reason | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
23 | TTE2C_EXPREA | Exemption Reason | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
24 | TTE2C_EXPREA_T | Exemption Reason Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
25 | TTE2C_FISCCD | Fiscal Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
26 | TTE2C_FISCCD_T | Fiscal Code Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
27 | TTE2C_PROCED | Valid Tax Calculation Procedures for Country | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
28 | TTE2C_PROCED_DET | Tax Calculation Procedure Determination | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
29 | TTE2C_PRPRPTYP | Product Property Type | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
30 | TTE2C_PRPRPTYP_T | Product Property Type Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
31 | TTE2C_PRPRPVAL | Product Properties | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
32 | TTE2C_PRPRPVAL_T | Product Properties | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
33 | TTE2C_PRTXGRP | Product Tax Group | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
34 | TTE2C_PRTXGRP_T | Product Tax Group Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
35 | TTE2C_RETLVL | Jurisdiction Level | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
36 | TTE2C_RETLVL_T | Jurisdiction Level Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
37 | TTE2C_ROUNDING | Rounding Decimals: Exceptions | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
38 | TTE2C_TAXEVENT | Tax Event | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
39 | TTE2C_TAXEVENT_T | Tax Event Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
40 | TTE2C_TAXTYP_DET | Tax Type Determination | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
41 | TTE2C_TAXTYP_T | Tax Type Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
42 | TTE2C_TAX_MAP | Mapping between Tax Type and Procedure | 7 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
43 | TTE2C_USAGE | Product Usage Indicator | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
44 | TTE2C_USAGE_T | Product Usage Indicator Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
45 | TTEC_ACCUM_PER | Accumulation Period | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
46 | TTEC_AGGREG | [Obsolete] Aggregation Rule For Tax Amounts | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
47 | TTEC_AUTHORITY | Tax Authority | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
48 | TTEC_AUTHORITY_T | Tax Authority | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
49 | TTEC_BUSTRANS | [Obsolete] Business Transactions | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
50 | TTEC_BUSTRANS_T | [Obsolete] Business Transactions | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
51 | TTEC_CHECKING | TTE Entity Checking Master Table | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
52 | TTEC_COUNTRIES | Country codes (2 char ISO codes) | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
53 | TTEC_COUNTRIES_T | Country Text Table | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
54 | TTEC_COUNTRY | Country to Community Assignment | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
55 | TTEC_COUNTRY_T | Country name | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
56 | TTEC_CURR | Tax Currencies per Country | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
57 | TTEC_CURR_HDL | Tax Currency Handling | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
58 | TTEC_CURR_HDL3 | Tax Currency Handling | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
59 | TTEC_DECTR_DET | Decision Tree Determination | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
60 | TTEC_DEDREAS | [Obsolete] Deductibility Reason | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
61 | TTEC_DEDREAS_T | [Obsolete] Description for Deductibility Reason | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
62 | TTEC_EXEMPREAS | Exemption reason | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
63 | TTEC_EXEMPREAS_T | Exemption reason | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
64 | TTEC_EXEMP_CND | Exemption condition types for tax types | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
65 | TTEC_FISCCODE | Fiscal Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
66 | TTEC_FISCCODE_T | Description Fiscal Code | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
67 | TTEC_FISCOVERS | Fiscal Code Version | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
68 | TTEC_FISCOVERS_T | Fiscal Code Version Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
69 | TTEC_INCIDENCE | Tax Incidence | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
70 | TTEC_INCIDENCE_T | Tax Incidence in Tax Transaction Engine | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
71 | TTEC_LEGTXT | Legal Text | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
72 | TTEC_LEGTXT_T | Legal Text | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
73 | TTEC_MAPACCVAL | Mapping Accumulated Values | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
74 | TTEC_NEXUS | TTE: Nexus Data | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
75 | TTEC_NONDD_CND | Condition Type for Non-deductibility | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
76 | TTEC_ORIGIN | Product Origin | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
77 | TTEC_ORIGIN_T | Description for Tax Origin | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
78 | TTEC_PATXGRP | Partner Tax Group | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
79 | TTEC_PATXGRP_T | Description for Partner Tax Group | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
80 | TTEC_PRC_TAX_MAP | [3.x only] Mapping between Tax Type and Procedure | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
81 | TTEC_PROCEDURE | Tax Procedure | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
82 | TTEC_PRTXGRP | Product Tax Group | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
83 | TTEC_PRTXGRP_T | Product Tax Group Description | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
84 | TTEC_RATES_CND | Condition type for tax rates | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
85 | TTEC_RATE_ID | Rate IDs | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
86 | TTEC_RATE_ID_T | Rate IDs | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
87 | TTEC_RNDRULE | Rounding Rules | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
88 | TTEC_ROUNDING | Rounding Decimals: Exceptions | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
89 | TTEC_SPREG | Exempted Region | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
90 | TTEC_SPREG_JSD | Determine Exempted Region from Tax Jurisdiction Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
91 | TTEC_SPREG_PCD | Determine Exempted Region from Postal Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
92 | TTEC_SPREG_REG | Determine Exempted Region from Region | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
93 | TTEC_SPREG_T | Exempted Region Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
94 | TTEC_TAXBASECAL | Aggregation rules | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
95 | TTEC_TAXCATAGGR | Aggregation rules | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
96 | TTEC_TAXCATPAR | Tax Category Parameters | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
97 | TTEC_TAXCODE | Tax Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
98 | TTEC_TAXCODE_2 | Assign Tax Events to Tax Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
99 | TTEC_TAXCODE_3 | Assign TTE Entities to Tax Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
100 | TTEC_TAXCODE_T | Tax Code | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
101 | TTEC_TAXDET | Tax Determination Default | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
102 | TTEC_TAXDET_EU | Tax Determination Intra-EU | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
103 | TTEC_TAXEVENT | [Obsolete] Tax Event | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
104 | TTEC_TAXEVENT_T | [Obsolete] Tax Event Description | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
105 | TTEC_TAXFRTO_DET | Partner Role determination: Tax from/Tax to | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
106 | TTEC_TAXTYP | Tax Type | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
107 | TTEC_TAXTYP_DET | [Obsolete] Tax Types by Tax Event | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
108 | TTEC_TAXTYP_T | [Obsolete] Tax Type Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
109 | TTEC_TAX_REG | Tax Region | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
110 | TTEC_TAX_REG_T | Tax Region Name | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
111 | TTEC_TAX_TCODE | Tax Tariff Code | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
112 | TTEC_TAX_TCODE_T | Tax Tariff Code Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
113 | TTEC_USAGE | [Obsolete] Usage | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
114 | TTEC_USAGE_T | [Obsolete] Usage Description | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
115 | TTEM_BPTXGRP2 | Mapping: Business Partner Tax Group | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
116 | TTEM_PRTXGRP2 | Mapping: Product Tax Group | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
117 | TTEM_TAXCODE | Mapping: Tax Code | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
118 | TTEM_TAXTYPE2 | Mapping: Tax Type | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
119 | TTEM_TAXTYPEC | [TTE 3.0 only] Mapping: Tax Type | 1 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
120 | TTEM_TAXTYP_EXT | Mapping TTE Tax Types to External Tax Types | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
121 | TTEPDT_COUNTRIES | Persistency TTE Document COUNTRY spez. | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
122 | TTEPDT_EXEMPVALU | Persistency TTE Document Item Exemption Value | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
123 | TTEPDT_ITEMPART | Persistency TTE Document item partner | 6 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
124 | TTEPDT_PAPROP | Persistency TTE Document business partner property | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
125 | TTEPDT_PARTNER | Persistency TTE Document business partner | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
126 | TTEPDT_PATAXCL | Persistency TTE Document business partner tax class. | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
127 | TTEPDT_PATAXNUM | Persistency TTE Document business partner tax number | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
128 | TTEPDT_PRPROP | Persistency TTE Document product property | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
129 | TTEPDT_PRTAXCL | Persistency TTE Document product tax class. | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
130 | TTEPDT_TAXEL | Persistency TTE Document / Item tax element | 5 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
131 | TTEPDT_TAXEVENT | Persistency TTE Document / Item tax event | 5 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
132 | TTEPDT_TAXVALUE | Persistency TTE Document / Item tax value | 5 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
133 | TTESDT_ACCUMVALU | Document business partner accum. values of with. tax. | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
134 | TTESDT_COUNTRIES | Document COUNTRY spez. | 3 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
135 | TTESDT_DOCUMENT | TTE Simulaton Document | 2 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
136 | TTESDT_EXEMPVALU | Document business partner exemption values for with. tax. | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
137 | TTESDT_ITEMPART | Document item partner | 6 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
138 | TTESDT_PAPROP | Document business partner property | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
139 | TTESDT_PARTNER | Document business partner | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
140 | TTESDT_PATAXCL | Document business partner tax class. | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
141 | TTESDT_PATAXNUM | Document business partner tax number | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
142 | TTESDT_PRPROP | Document product property | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
143 | TTESDT_PRTAXCL | Document product tax class. | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
144 | TTESDT_TAXEL | Document / Item tax element | 5 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
145 | TTESDT_TAXEVENT | Document / Item tax event | 5 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
146 | TTESDT_TAXVALUE | Document / Item tax value | 5 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |
147 | TTE_WT_ACCUMVALU | AP-TTE accumulated base amounts and withholding tax amounts | 4 | COUNTRYISO | Country | nvarchar | 2 | 0 | | |