| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInformation System |
1 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 11 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
TOPLoans Management |
2 | BCKTRLET_LOAN_FL | Treasury: Loans Transferred | 7 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
3 | TRLET_LOAN_FLOW | OBSOLETE: Previous Solution: Loans Flows Transferred | 8 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
TOPTransaction Management |
4 | THXT_MD_PV | market data present value | 6 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
TOPTransaction Manager |
5 | DIFT_POS_IDENT | Persistent Flow Selectors | 17 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
6 | IDCFM_FRIM_DATA | Impairment Main Data | 9 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
7 | IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values | 9 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
8 | POGT_POS_GUARD | Lock Objects | 31 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
9 | SLDT_FLOW | Subledger Distributor Transactions | 19 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
10 | THMEXT_PLANNER | E-HA: Hedge Plan | 19 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
11 | TRDT_FLOW | Persistent distributor flows | 17 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
12 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 18 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
TOPTransfer to Financial Accounting |
13 | BCKTLVT_VAL_FLOW | Backup: Treasury: Valuation Flow | 6 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
14 | BCKTRLT_DERIVFLO | Treasury: Flows for Derived Business Transactions | 7 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
15 | BCKTRLT_FLOW | Treasury Ledger Flows | 6 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
16 | BCKTRLT_POSITION | Backup: Treasury Ledger Position | 5 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
17 | BCKTRLT_SUBPOSIT | Backup: Treasury Ledger Position | 5 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
18 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 10 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
19 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 7 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
20 | TRLT_INIT_TRANS | List of Initializing Business Transactions | 10 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
21 | TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans | 6 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
22 | VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation | 9 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |
TOPTreasury and Risk Management |
23 | VDCSPREAD | Credit Spread per Loan | 3 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | |