| 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 | | |
