| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TREAT_FLOW_PM | Treasury: TREA Flow Payment Details | 6 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
TOPBack Office |
2 | TRFT_PACC_BANK | Payment Information | 9 | RPZAHL | Payer/Payee | nvarchar | 10 | 0 | | |
3 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 37 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
4 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 37 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
5 | TRST_SECACC_BANK | Payment Details for Securities Account | 9 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
6 | TRST_SECACC_PAY | Downport Payment Information for Securities Management | 8 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
TOPBusiness Partner |
7 | VTBSTC1 | Components of Payment Details for Standing Instruction | 13 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
TOPLoans Management |
8 | TTONFTVDARL | Test neue Fima: Grunddaten und VDARL | 134 | RPZAHL | Zahlungsregulierer | nvarchar | 10 | 0 | | |
9 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 238 | RPZAHL | Zahlungsregulierer | nvarchar | 10 | 0 | | |
10 | VDARL | Loans | 120 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
11 | VDZV | Payment Details for the Loan | 16 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
TOPTransaction Manager |
12 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 29 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
13 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 27 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
14 | REFCC | References between CO object numbers, currency differences | 16 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
15 | SLDT_FLOW | Subledger Distributor Transactions | 55 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
16 | TERT_FLOW | Flow Table for Rights that can be Exercised | 23 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
17 | TRCT_FLOW | Table of business transactions flows | 5 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
18 | TRDT_FLOW | Persistent distributor flows | 53 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
19 | VTBFHAPO | Transaction Flow | 29 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
20 | VTBFHAPO_MIGR | Migrated Financial Flows | 29 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
21 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 29 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
22 | VTBPFHAPO | Treasury: Flow Shells | 28 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
23 | VTBZV | Payment Details for Transaction | 16 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
24 | VTIFHAPO | Underlying transaction flows | 27 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
25 | VWBEPI | Treasury Securities: Actual Flows - Item | 106 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
26 | VWBEPP | Treasury Securities: Planned Flows | 160 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
27 | VWORDE | Order Data | 114 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
TOPTransfer to Financial Accounting |
28 | TRACT_ACCITEM | Accounting Items | 28 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
29 | TRPRT_PAYMENTS | Persistent Data for Payment Requests | 24 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |
TOPTreasury and Risk Management |
30 | TREAT_EXT_ACC_PM | Treasury: External Account Payment Details | 9 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | |