| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CN/CTXSAPD0201 | Country/Tax Code | 4 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
2 | /1CN/CTXSAPR0201 | Country/Tax Code | 4 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
3 | /1CN/CTXSAPW0201 | Country/Tax Code | 4 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
4 | DFKKSAFTINV_I | SAF-T Source Document: Item | 25 | TAXCODE | Portugal: SAF-T Tax code | nvarchar | 10 | 0 | | |
5 | DFKKSAFTPAY_I | SAF-T Payment Source Document: Item | 14 | TAXCODE | Portugal: SAF-T Tax code | nvarchar | 10 | 0 | | |
6 | FIEUD_SBINV_I | SAFT: Self Billing Invoices ( Line Items) | 26 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
7 | FIEUD_SDINV_I | SAFT: Invoices from SD module(Item) | 25 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
8 | J_1GMYF0_M | MYF data | 6 | TAXCODE | MYF: TAX code/cashreg_id | nvarchar | 20 | 0 | | |
9 | J_1GWTR0 | Vendor Tax Data | 4 | TAXCODE | Tax Identification Number (AFM) | nvarchar | 11 | 0 | | |
10 | J_1UFDI_SPTXCODE | Tax Codes Relevant for Types of Reasons | 5 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
11 | TIVXCITIREFT | Mapping of IRE Status to Contract-Flow type-Taxcode | 6 | TAXCODE | IRE Tax Code | nvarchar | 4 | 0 | | |
TOPBasic Functions |
12 | RF07 | Withholding tax in Italy : Modello 770 - additional data | 21 | TAXCODE | Tax code | nvarchar | 16 | 0 | | |
TOPBSI |
13 | BTXCUTX | BSI: Customer Tax Formula | 4 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
14 | BTXCUTX_O | BSI: Customer Tax Formula | 3 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
15 | BTXOVER | BSI: Higher Level Tax Formula | 5 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
16 | BTXOVER_O | BSI: Higher Level Tax Formula | 4 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
17 | BTXOVFR | BSI: Higher Level Formulas for Employees | 5 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
18 | BTXOVFR_O | BSI: Higher Level Formulas for Employees | 4 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
19 | BTXRATE | BSI: Tax Rates per Company Based on Degree of Experience | 5 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
20 | BTXRATE_O | BSI: Tax Rates per Company Based on Degree of Experience | 4 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
21 | BTXTAXC | Tax Authority Mapping | 4 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
TOPContract Accounts Receivable and Payable |
22 | TFK_MAP_KOFIZ_SD | Fld Value Alloc. of Tax Features for Acct Determination IDs | 2 | TAXCODE | CRM: Tax Feature for Business Agreement | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
23 | J_1GMYF0 | MYF data | 5 | TAXCODE | Tax Identification Number (AFM) | nvarchar | 11 | 0 | | |
24 | J_1GWTC0 | Withholding tax certificates data | 4 | TAXCODE | Tax Identification Number (AFM) | nvarchar | 11 | 0 | | |
TOPFinancial Services Localization |
25 | /GSINS/BRBPWHT | Tax Details - Brazil Insurance | 3 | TAXCODE | Withholding Tax Code | nvarchar | 2 | 0 | | |
TOPFlexible Real Estate Management |
26 | TIVITTCACCTXCD | Assignment of Tax Code for Correction Posting | 3 | TAXCODE | Tax Code | nvarchar | 2 | 0 | | |
27 | VIITTCBASE | Basis for Input Tax Correction | 4 | TAXCODE | Tax Code | nvarchar | 2 | 0 | | |
28 | VIITTCCALCRES | Input Tax Correction: Line Item | 7 | TAXCODE | Tax Code | nvarchar | 2 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
29 | TFSC_MAP_KOFIZ | Fld Value Assgt. of Tax Features for Acct Determin. Features | 2 | TAXCODE | CRM: Tax Feature for Business Agreement | nvarchar | 2 | 0 | | |
TOPIntegration Customer Relationship Management |
30 | EPPSIMRESULTTX | Product Proposal Simulation Tax Results | 5 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
31 | T8J0F | Billing method Posting Rule | 7 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
32 | T8JO | Partner | 10 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
33 | T8JV | Joint Venture | 8 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPLocalization |
34 | J_1BPOSCOUPONS | POS-Database Coupons (Brazilian) | 15 | TAXCODE | Tax code | nvarchar | 5 | 0 | | |
35 | J_1BPOSREDUCTION | POS-Database Reduction (Brazilian) | 18 | TAXCODE | Tax code | nvarchar | 5 | 0 | | |
36 | J_1BTXSDC | SD tax codes | 2 | TAXCODE | SD tax code | nvarchar | 2 | 0 | | |
37 | J_1BTXSDCT | SD tax codes - description | 3 | TAXCODE | SD tax code | nvarchar | 2 | 0 | | |
38 | PTDART_TAX_DATA | Tax Code Data | 2 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
39 | SAFT_PT_TAX_DATA | Tax Details for SAFT-PT | 4 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
40 | OIUCM_T8JV | PRA Joint Venture Master Data | 8 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPRental Accounting |
41 | TIVEXFIDEEPTAX | Rows for Multilevel Tax Code | 3 | TAXCODE | Multilevel Tax Code | nvarchar | 2 | 0 | | |
42 | TIVEXFITAXMAP | Tax Code Assignment per RE Tax Type/Group | 7 | TAXCODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPTransaction Tax Engine |
43 | TTEC_TAXCODE | Tax Code | 3 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
44 | TTEC_TAXCODE_2 | Assign Tax Events to Tax Code | 3 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
45 | TTEC_TAXCODE_3 | Assign TTE Entities to Tax Code | 3 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
46 | TTEC_TAXCODE_T | Tax Code | 4 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
47 | TTEM_TAXCODE | Mapping: Tax Code | 8 | TAXCODE | Tax Code | nvarchar | 4 | 0 | | |
48 | TTEPDT_TAXCODVA | Document / Item TaxCode Value | 6 | TAXCODE | TaxCode | nvarchar | 4 | 0 | | |
49 | TTEPDT_TAXEL | Persistency TTE Document / Item tax element | 25 | TAXCODE | TaxCode | nvarchar | 4 | 0 | | |
50 | TTEPDT_TAXEVENT | Persistency TTE Document / Item tax event | 17 | TAXCODE | TaxCode | nvarchar | 4 | 0 | | |
51 | TTESDT_TAXCODVA | Document / Item pricing element | 6 | TAXCODE | TaxCode | nvarchar | 4 | 0 | | |
52 | TTESDT_TAXEL | Document / Item tax element | 25 | TAXCODE | TaxCode | nvarchar | 4 | 0 | | |
53 | TTESDT_TAXEVENT | Document / Item tax event | 17 | TAXCODE | TaxCode | nvarchar | 4 | 0 | | |
TOPUSA |
54 | BTXTERR | BSI: Employee Payroll Error Message Grouping | 5 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
55 | BTXTRES | BSI: Tax Results | 5 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |
56 | BTXTTAX | BSI: Test Taxes | 5 | TAXCODE | BSI: Tax Code | nvarchar | 11 | 0 | | |