| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIVXCITCRMEMO | Tax group for credit memo over one year | 4 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
2 | VIYCADVPAY | Advance Payments | 69 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
3 | VIYCRECEIVABLE | Receivables from Settlement | 13 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
TOPClaims Management |
4 | TICL556 | Tax Group | 2 | TAXGROUP | Tax Group | nvarchar | 10 | 0 | | |
5 | TICL556T | Long Text Tax Group | 3 | TAXGROUP | Tax Group | nvarchar | 10 | 0 | | |
6 | TICL557 | Combination of Tax Role and Participant | 2 | TAXGROUP | Tax Group | nvarchar | 10 | 0 | | |
7 | TICL558 | OBSOLETE - Do not use | 2 | TAXGROUP | Tax Group | nvarchar | 10 | 0 | | |
TOPConditions |
8 | A602 | Condition Table for Pricing A602 | 9 | TAXGROUP | Tax Group for Dynamic Tax Exceptions | nvarchar | 2 | 0 | | |
TOPContract Billing |
9 | DBERCHZ4 | Individual line items (rarely used fields) | 30 | TAXGROUP | Categorize Amounts for Tax Determination | nvarchar | 4 | 0 | | |
10 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 30 | TAXGROUP | Categorize Amounts for Tax Determination | nvarchar | 4 | 0 | | |
11 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 76 | TAXGROUP | Categorize Amounts for Tax Determination | nvarchar | 4 | 0 | | |
12 | ESCHS | Billing Schema Steps | 18 | TAXGROUP | Categorize Amounts for Tax Determination | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
13 | J_1UFTASSGROUP | Definition of Tax Groups for Assets | 5 | TAXGROUP | Tax Group for Assets | nvarchar | 2 | 0 | | |
TOPFlexible Real Estate Management |
14 | TIVITTCTXCDMAP | Obsolete | 4 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
15 | TIVRATAXBOLLO | Steuergruppe | 2 | TAXGROUP | Steuergruppe | nvarchar | 20 | 0 | | |
16 | TIVRATAXBOLLOT | Steuergruppe (Text) | 3 | TAXGROUP | Steuergruppe | nvarchar | 20 | 0 | | |
17 | TIVXCFCSCKEYPROP | Service Charge Key: Properties for Fuel Management | 8 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
18 | TIVXCOTCOND | COA, Tax Information for Condition Type | 4 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
19 | TIVXCOTPARAM | Parameter for VAT on Expense for Service Charge Key | 4 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
20 | VISCS_RECEIVE | OBSOLETE: Receivables (Replaced by VISCRECEIVABLE) | 11 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
21 | VIXCOTDS | COA, Distribution of VAT | 12 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
TOPInput Tax Treatment |
22 | VIITTAXDSBASE | Tax Document Item to Be Broken Down (VIITTAXDSBASE) | 20 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
TOPLocalization |
23 | A346 | Land/Dyn.Schlüssel1/Dyn.Schlüssel2/Dyn.Schlüssel3/St.-Grp. | 8 | TAXGROUP | Steuergruppe für Dynamische Steuer-Ausnahmen | nvarchar | 2 | 0 | | |
24 | A347 | Land/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp. | 10 | TAXGROUP | Steuergruppe für Dynamische Steuer-Ausnahmen | nvarchar | 2 | 0 | | |
25 | A348 | Land/SF/ST/XSUBT/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp. | 11 | TAXGROUP | Steuergruppe für Dynamische Steuer-Ausnahmen | nvarchar | 2 | 0 | | |
26 | A382 | Land/Belegart/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp | 11 | TAXGROUP | Steuergruppe für Dynamische Steuer-Ausnahmen | nvarchar | 2 | 0 | | |
27 | VIXCJPFXDUNPRICE | Fixed Unit Prices for Service Charge Settlement | 18 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
28 | VIXCJPSCCOSTSEXT | Costs per Object - Legacy Data Transfer | 9 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
TOPReal Estate Contract |
29 | TIVCNCCTADD | Attribute for Contract | 17 | TAXGROUP | Default Value for Tax Group | nvarchar | 20 | 0 | | |
30 | VICDCFOBJ | Object-Related Cash Flow | 65 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
31 | VICDCFPAY | Payment-Related Cash Flow | 65 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
TOPRental Accounting |
32 | TIVEXFITAXMAP | Tax Code Assignment per RE Tax Type/Group | 4 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
33 | TIVEXTAXCODEMAP | Assignment of RE Tax Type/Group per Tax Code | 7 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
34 | TIVRAALTAX | Assignment of Accrual Type to Tax Code | 4 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
35 | TIVRATAXGROUP | Tax Group | 2 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
36 | TIVRATAXGROUPT | Tax Group (Text) | 3 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
37 | VIRAADVPAY | OBSOLETE: Advance Payment | 14 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
38 | VIRAADVPAYEXT | Advance Payment - Legacy Data Transfer | 14 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
39 | VIRAADVPAYPROC | Advance Payments per Settlement | 21 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
40 | VIRAADVPAYSPLIT | Split Advance Payments | 20 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
41 | VIRADOCITEM | RE Document Item | 53 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
42 | VIRAINVITEM | RE Invoice Item | 18 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
43 | VITMPY | Term: Posting Rule | 20 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
TOPSales-Based Rent and Settlement |
44 | VISRCALCCTFC | Amounts in Foreign Currency | 8 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
45 | VISRCALCDETAIL | Results of Sales Grading Calculation | 17 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
46 | VISRCALCSB | Interim Result | 15 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
47 | VISRCALCSUM | Calculation Results per Sales Rule | 19 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
48 | VISRCRSPLIT | Split Receivable | 10 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
49 | VISRMODIRESULT | Changed Sales-Based Settlement Results | 6 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
50 | VISRMOSPLIT | Split Receivable | 10 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
TOPService Charge Settlement |
51 | TIVSCCHRGCN | Calculation of Surcharges Dependent on Contract | 8 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
52 | TIVSCEXTRACHRG | Surcharge Schema for Surcharges in SCS | 12 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
53 | VISCCOSTSEXT | Costs per Object - Legacy Data Transfer | 9 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
54 | VISCCRSPLIT | Split Receivable | 10 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
55 | VISCRECEIVABLE | Receivables from Settlement | 14 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |
56 | VISCSCOSTS | Determined Costs | 8 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | |