| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | IDCFM_HU_DERIV | HU GAAP: Relevant BT Categories per Derivation Method | 2 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
TOPBack Office |
2 | TPMT_DEDOC_HDR | Derivatives Document: Document Header | 11 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
3 | TRFT_BUSTRANS | Treasury: TRF Business Transaction | 4 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
4 | TRFT_MAN_POST | Manual Posting | 4 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
5 | TRFT_MATCH_TRANS | Treasury: Matching Process Business Transaction | 4 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
6 | TRFT_SUBTRANS | Treasury: TRF Business Subtransaction | 4 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
TOPInformation System |
7 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 39 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
TOPLoans Management |
8 | TRLET_LOAN_FLOW | OBSOLETE: Previous Solution: Loans Flows Transferred | 10 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
9 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 267 | BUSTRANSCAT | Geschäftsvorfallstyp | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
10 | TISSR_P_BUSCAT | ISSR: Ausnahmetabelle RWIN-Buchungen | 2 | BUSTRANSCAT | Geschäftsvorfallstyp | nvarchar | 4 | 0 | | |
TOPTransaction Management |
11 | THXT_HR_TRANS | Treasury: Hedging Relationship Transactions | 3 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
12 | SLDT_TRANSACTION | Subledger Distributor Business Transactions | 10 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
13 | TCORT_CO | Correspondence Administrative Data | 9 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
14 | TRCT_BUSTRANS | Table of business transactions | 7 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
15 | TRDTS_BT_CAT | Treasury: Business Transaction Categories | 1 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
16 | TRDTS_BT_CAT_T | Treasury: Texts for distributor bus. transaction categories | 1 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
17 | TRDT_TRDBUSTRANS | Treasury: Persistent distributor business transaction | 11 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
18 | TRGTS_BT_CONTROL | Control of Relevant/Irrelevant Bus.Transactions for Partners | 2 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
19 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 7 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
20 | TRLT_VCL_TRANS | Valuation Class Transfers | 5 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
21 | TRQC_SCHEMA_ASSG | Treasury: Quantity Ledger Position Description | 3 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
22 | TRQTS_BT_CAT | Treasury: TRQ-Relevant Business Transaction Categories | 1 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
23 | TRQT_BUSTRANS | Treasury: Business Transactions | 6 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
24 | TRQT_INIT_LOT | (obsolete) | 13 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
25 | TRQT_VWVORTR_LOT | (obsolete) | 15 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
26 | TRXT_TRANSACTION | TRM Tax Transactions | 8 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
27 | VWBEPI | Treasury Securities: Actual Flows - Item | 111 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
28 | VWBEPP | Treasury Securities: Planned Flows | 166 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
29 | VWVORTR | Securities: Carry-Forward Totals | 19 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
TOPTransfer to Financial Accounting |
30 | TRACT_DOCUMENT | Treasury: Accounting Adaptor Document | 25 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
31 | TRACT_QUEUE | Resubmission for Reversal | 3 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
32 | TRILT_DTRANS | Derived Business Transactions in the Income Ledger | 9 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
33 | TRLTS_DERIV_REL | Treasury: Relevant BT Categories per Derivation Method | 2 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
34 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 45 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
35 | TRLT_TRANSACTION | Treasury Ledger Business Transactions | 4 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |
TOPTreasury and Risk Management |
36 | TREAT_FLOW | Treasury: TREA Flows | 10 | BUSTRANSCAT | Business Transaction Category | nvarchar | 4 | 0 | | |