| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_SUS_STG_TAX | staging tax table | 4 | TAXTYPE | Tax Number Category | nvarchar | 4 | 0 | | |
2 | BBP_TAXTYPE_FAV | User-Specific Favorites for Tax Types per Country | 4 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
3 | DFKKHUREPDS | Recording Data for Domestic Sales Hungary | 27 | TAXTYPE | Type of Tax Number | nvarchar | 1 | 0 | | |
4 | DFKKSAFTINV_I | SAF-T Source Document: Item | 23 | TAXTYPE | Portugal: SAF-T Tax type | nvarchar | 3 | 0 | | |
5 | DFKKSAFTPAY_I | SAF-T Payment Source Document: Item | 12 | TAXTYPE | Portugal: SAF-T Tax type | nvarchar | 3 | 0 | | |
6 | J_1BDF_STAT_TAX | Set Tax Type as Statistical for Specific Scenarios | 4 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
7 | T011_XBRL | Financial Statement Versions | 10 | TAXTYPE | Type of XBRL Taxonomy | nvarchar | 5 | 0 | | |
8 | TFK_TAXTYPE_HU | Define Tax category for Domestic Sales | 2 | TAXTYPE | Type of Tax Number | nvarchar | 1 | 0 | | |
9 | TIVXCESCORRINV | Correction Invocie Settings for Spain | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
10 | TIVXCITCRMEMO | Tax group for credit memo over one year | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
11 | VIYCADVPAY | Advance Payments | 68 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
12 | VIYCRECEIVABLE | Receivables from Settlement | 12 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPBSI |
13 | BTXBGRP | BSI: Group Block Data | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
14 | BTXBLOK | BSI: Tax Formula Block Data | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
15 | BTXBRAK | BSI: Tax Formula Bracket Data | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
16 | BTXFDOC | BSI: Tax Formula Documentation | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
17 | BTXFORM | BSI Tax Formulas | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
18 | BTXOVER | BSI: Higher Level Tax Formula | 6 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
19 | BTXOVER_O | BSI: Higher Level Tax Formula | 5 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
20 | BTXOVFR | BSI: Higher Level Formulas for Employees | 6 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
21 | BTXOVFR_O | BSI: Higher Level Formulas for Employees | 5 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
22 | BTXPLNX | BSI: Benefit Plan | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
23 | BTXRATE | BSI: Tax Rates per Company Based on Degree of Experience | 6 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
24 | BTXRATE_O | BSI: Tax Rates per Company Based on Degree of Experience | 5 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
25 | BTXRCPT | BSI: Tax Formula Reciprocal Data | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
26 | BTXTAX | BSI: Grouping Tax Authority Tax Category | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
27 | BTXTAXT | BSI: Tax Category | 1 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
TOPClaims Management |
28 | ICL_CTAXBENTYP | Maintenance: Assignment of Tax Type to Benefit Type | 3 | TAXTYPE | Tax Type to Be Calculated | nvarchar | 5 | 0 | | |
29 | ICL_TAX_ITM | Tax Item | 10 | TAXTYPE | Tax Type to Be Calculated | nvarchar | 5 | 0 | | |
30 | ICS_TAX_ITM | Tax Item (Shadow Table) | 10 | TAXTYPE | Tax Type to Be Calculated | nvarchar | 5 | 0 | | |
TOPContract Accounts Receivable and Payable |
31 | BPPAN_IDTYP_IN | Maintain Taxtype/ID type for PAN number | 3 | TAXTYPE | Tax Number Category | nvarchar | 4 | 0 | | |
TOPCountry-Specific Objects |
32 | DFKKBPTAXNUM | Tax Numbers for Business Partner | 3 | TAXTYPE | Tax Number Category | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
33 | TIVITTCTXCDMAP | Obsolete | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
34 | TIVXCFCSCKEYPROP | Service Charge Key: Properties for Fuel Management | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
35 | TIVXCOTCOND | COA, Tax Information for Condition Type | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
36 | TIVXCOTPARAM | Parameter for VAT on Expense for Service Charge Key | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
37 | VISCS_RECEIVE | OBSOLETE: Receivables (Replaced by VISCRECEIVABLE) | 10 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
38 | VIXCOTDS | COA, Distribution of VAT | 11 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPInput Tax Treatment |
39 | VIITTAXDSBASE | Tax Document Item to Be Broken Down (VIITTAXDSBASE) | 19 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPLocalization |
40 | PTDART_TAX_DATA | Tax Code Data | 3 | TAXTYPE | Tax Type | nvarchar | 10 | 0 | | |
41 | SAFT_PT_TAX_DATA | Tax Details for SAFT-PT | 2 | TAXTYPE | Tax Type | nvarchar | 3 | 0 | | |
42 | VIXCJPFXDUNPRICE | Fixed Unit Prices for Service Charge Settlement | 17 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
43 | VIXCJPSCCOSTSEXT | Costs per Object - Legacy Data Transfer | 8 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPReal Estate Contract |
44 | TIVCNCCTADD | Attribute for Contract | 16 | TAXTYPE | Default Value for Tax Type | nvarchar | 4 | 0 | | |
45 | VICDCFOBJ | Object-Related Cash Flow | 64 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
46 | VICDCFPAY | Payment-Related Cash Flow | 64 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPRental Accounting |
47 | TIVEXFITAXMAP | Tax Code Assignment per RE Tax Type/Group | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
48 | TIVEXFITAXTRKEY | Assignment of Tax Transaction Key | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
49 | TIVEXTAXCODEMAP | Assignment of RE Tax Type/Group per Tax Code | 6 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
50 | TIVRAALTAX | Assignment of Accrual Type to Tax Code | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
51 | TIVRATAXTYPE | Tax Types | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
52 | TIVRATAXTYPET | Tax Type (Text) | 4 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
53 | VIRAADVPAY | OBSOLETE: Advance Payment | 13 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
54 | VIRAADVPAYEXT | Advance Payment - Legacy Data Transfer | 13 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
55 | VIRAADVPAYPROC | Advance Payments per Settlement | 20 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
56 | VIRAADVPAYSPLIT | Split Advance Payments | 19 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
57 | VIRADOCITEM | RE Document Item | 52 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
58 | VIRAINVITEM | RE Invoice Item | 17 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
59 | VITMPY | Term: Posting Rule | 19 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPRevenue |
60 | OIUH_PTR_REP_LOG | Production, Tax and Royalty Reporting Execution Log | 20 | TAXTYPE | Severance Tax Type | nvarchar | 2 | 0 | | |
TOPSales-Based Rent and Settlement |
61 | VISRCALCCTFC | Amounts in Foreign Currency | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
62 | VISRCALCDETAIL | Results of Sales Grading Calculation | 16 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
63 | VISRCALCSB | Interim Result | 14 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
64 | VISRCALCSUM | Calculation Results per Sales Rule | 18 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
65 | VISRCRSPLIT | Split Receivable | 9 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
66 | VISRMODIRESULT | Changed Sales-Based Settlement Results | 5 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
67 | VISRMOSPLIT | Split Receivable | 9 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPSAP Business Partner |
68 | TFKTAXNUMTYPE | Tax Number Categories of Business Partner | 2 | TAXTYPE | Tax Number Category | nvarchar | 4 | 0 | | |
69 | TFKTAXNUMTYPE_C | Customer Selection: Business Partner Tax Number Categories | 2 | TAXTYPE | Tax Number Category | nvarchar | 4 | 0 | | |
70 | TFKTAXNUMTYPE_T | Name: Business Partner Tax Number Categories | 3 | TAXTYPE | Tax Number Category | nvarchar | 4 | 0 | | |
TOPService Charge Settlement |
71 | TIVSCCHRGCN | Calculation of Surcharges Dependent on Contract | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
72 | TIVSCEXTRACHRG | Surcharge Schema for Surcharges in SCS | 11 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
73 | VISCCOSTSEXT | Costs per Object - Legacy Data Transfer | 8 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
74 | VISCCRSPLIT | Split Receivable | 9 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
75 | VISCRECEIVABLE | Receivables from Settlement | 13 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
76 | VISCSCOSTS | Determined Costs | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
77 | OIH2M_J1B | Check table for material tax group | 11 | TAXTYPE | General taxation type for sub. trib. | nvarchar | 1 | 0 | | |
78 | OIH_J1B_INC | Brazil: Incoming taxation table | 15 | TAXTYPE | Incoming taxation type (Brazil) | nvarchar | 1 | 0 | | |
79 | OIH_J1B_PIC | Brazil: Printing exceptions for ICMS | 7 | TAXTYPE | General taxation type for sub. trib. | nvarchar | 1 | 0 | | |
80 | OIH_J1B_TOU | Brazil: Check table for tax codes in Transfer Outgoing | 12 | TAXTYPE | Incoming taxation type (Brazil) | nvarchar | 1 | 0 | | |
TOPTransaction Tax Engine |
81 | TTEC_MAPACCVAL | Mapping Accumulated Values | 3 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
82 | TTED_ATAXELE_COM | Acquisition: TaxElement | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
83 | TTED_INEXEMP_COM | Exemptions | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
84 | TTED_OEXEMP_COM | Output Exemptions | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
85 | TTED_OTAXELE_COM | Output TaxElement | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
86 | TTED_TAXCLAO_COM | TaxClassification in OutputDocument | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
87 | TTED_TAXCLAS_COM | TaxClassification | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
88 | TTED_TAXELES_COM | Input document tax elements information | 8 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
89 | TTEM_BPTXGRP2 | Mapping: Business Partner Tax Group | 8 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
90 | TTEM_PRTXGRP2 | Mapping: Product Tax Group | 8 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
91 | TTEM_TAXTYPE | [Obsolete] Mapping: Tax Type | 4 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
92 | TTEM_TAXTYPE2 | Mapping: Tax Type | 6 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
93 | TTEM_TAXTYPEC | [TTE 3.0 only] Mapping: Tax Type | 5 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
94 | TTEPD3_EXEMP | Exemptions | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
95 | TTEPD3_TAXCLAS | TaxClassification | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
96 | TTEPD3_TAXELE | TaxElement | 7 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
97 | TTEPDT_EXEMPT | Persistency TTE Document Output Exemptions | 4 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
98 | TTESDT_EXEMPT | Output Exemptions | 4 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | |
TOPUSA |
99 | BRCDTA | BSI-TAX 4.0 BRCDTA | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
100 | BRCGDTA | BSI-TAX 4.0 BRCGDTA | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
101 | BRCGEN | BSI-TAX 4.0 BRCGEN | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
102 | BRCRCP | BSI-TAX 4.0 BRCRCP | 2 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
103 | BTXTERR | BSI: Employee Payroll Error Message Grouping | 6 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
104 | BTXTRES | BSI: Tax Results | 6 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |
105 | BTXTTAX | BSI: Test Taxes | 6 | TAXTYPE | BSI: Tax category | nvarchar | 2 | 0 | | |