| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIVXCESPTPSTNG | Property Tax: Posting | 3 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
2 | VIYCADVPAY | Advance Payments | 73 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
3 | VIYCRECEIVABLE | Receivables from Settlement | 28 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
4 | TIVXAFCTRANSDET | FI-CA: Main and Subtransaction for Transaction Type | 2 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
5 | TIVXCITIBPARA | IB Stamp tax parameter | 6 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
6 | VISCS_RECEIVE | OBSOLETE: Receivables (Replaced by VISCRECEIVABLE) | 3 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPLoans Management |
7 | VDCHK_GROSS_NET | Storage of data for report RFVD_GROSS_TO_NET | 9 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPLocalization |
8 | TIVXCHUFF | Service continuity | 3 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
9 | TIVXCJPFLWTYP | Flow Type Defined for Service Charge Keys | 4 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
10 | TIVXCJPPCATF | Payment Categories and Flow Types Customizing | 2 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPPortfolio Analyzer |
11 | PFAIM_CF_FTMATCH | Assignment Cash flow type to PA flowtype | 5 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
12 | PFAIM_FTYPEMATCH | Assignment of Flow Types to PA Flow Types | 6 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
13 | PFAIM_TR_UTMATCH | Assignment of Update Type to Flow Types in PA | 5 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
14 | PFAIM_UMATCH_TRL | Assignment of Flow Types to PA Flow Types | 6 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
15 | PFA_FLOWTYPES | TRM-PA Flow Types | 2 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
16 | PFA_FLOWTYPEST | TRM-PA Flow Types: Text Table | 3 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
17 | RDBPA_REC_FLW | Key Figure Values FLW: Single Record Items with Currency | 6 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
18 | RDBPA_SUM_FLW | Key Figure Values FLW: Totals Records with Currency | 6 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
19 | RDBPA_SUM_FLWCC | Key Figure Values FLW: Totals Records w/o Currency | 6 | FLOWTYPE | Portfolio Analyzer: Flow Type | nvarchar | 4 | 0 | | |
TOPReal Estate Contract |
20 | TIVCDCONDTYPE | Condition Type | 4 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
21 | TIVCDFLOWREL | Reference Flow Type | 3 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
22 | TIVCDFLOWTYPE | Flow Type | 2 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
23 | TIVCDFLOWTYPET | Flow Type (Text) | 3 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
24 | VICDCFOBJ | Object-Related Cash Flow | 70 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
25 | VICDCFPAY | Payment-Related Cash Flow | 69 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
26 | ISSRFLDEO | Object table 1 | 21 | FLOWTYPE | | nvarchar | 8 | 0 | | |
TOPRental Accounting |
27 | TIVEXFIBANKSTAT | COA Mandate: Flow Types of Bank Statement | 3 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
28 | TIVEXFIDOCTYPE | Document Type Determination | 4 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
29 | TIVRAACCDET | Account Determination | 2 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
30 | TIVRAFLOWTPCNDS | Flow Type for Summarization | 2 | FLOWTYPE | Summarization Flow Type | nvarchar | 4 | 0 | | |
31 | TIVRAOPACTI | Settings for Line Item | 9 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
32 | VIRAADVPAY | OBSOLETE: Advance Payment | 12 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
33 | VIRAADVPAYEXT | Advance Payment - Legacy Data Transfer | 12 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
34 | VIRAADVPAYPROC | Advance Payments per Settlement | 14 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
35 | VIRAADVPAYSPLIT | Split Advance Payments | 13 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
36 | VIRADOCITEM | RE Document Item | 23 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
37 | VIRAINVITEM | RE Invoice Item | 8 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPRoom Reservations and Seating Arrangements |
38 | TIVORSRVGRPREL | Service Types for Service Group | 11 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
39 | VIORRSCOST | Reservation - Costs | 12 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPSales-Based Rent and Settlement |
40 | VISRCALCSUM | Calculation Results per Sales Rule | 14 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPService Charge Settlement |
41 | TIVSCEXTRACHRG | Surcharge Schema for Surcharges in SCS | 9 | FLOWTYPE | Original Flow Type for Surcharge | nvarchar | 4 | 0 | | |
42 | TIVSCSETTLMODE | Settlement Methods | 10 | FLOWTYPE | Must Be Possible to Determine Flow Type | nvarchar | 1 | 0 | | |
43 | VISCRECEIVABLE | Receivables from Settlement | 11 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
44 | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) | 15 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
45 | IDCFM_BST_HIST | History table for balance sheet transfer for Brazil | 22 | FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
46 | TCORT_CODFL | Deal: Flows | 7 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
47 | TCORT_CODUL2FL | Deal: 2nd Underlying's Flows | 10 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
48 | TCORT_CODULFL | Deal: Underlying Flows | 9 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | |
49 | TRLIC_AD_EX1 | TR: Accrual/Deferral: Further Update Types | 9 | FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
50 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 11 | FLOWTYPE | Accrual/Deferral: Update Type for Profit-Related Flow | nvarchar | 8 | 0 | | |
TOPTransfer to Financial Accounting |
51 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 14 | FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |
52 | TRLT_FLOW | Treasury Ledger Flows | 7 | FLOWTYPE | Update Type | nvarchar | 8 | 0 | | |