| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TREAT_FLOW_PM | Treasury: TREA Flow Payment Details | 7 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
TOPAccounting |
2 | TDIOA_TEMPL | Template for Interest On Arrears Calculation | 14 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
TOPBack Office |
3 | TRFT_PACC_BANK | Payment Information | 11 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
4 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 39 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
5 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 39 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
6 | TRST_SECACC_BANK | Payment Details for Securities Account | 11 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
7 | TRST_SECACC_PAY | Downport Payment Information for Securities Management | 10 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
TOPBusiness Partner |
8 | VTBSTC1 | Components of Payment Details for Standing Instruction | 12 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
TOPGermany |
9 | T5DP1 | PAISY Interface | 6 | SZART | PAISY: Record Type | nvarchar | 2 | 0 | | |
10 | T5DP2 | Conversion of Infotype Fields -> PAISY | 5 | SZART | PAISY: Record Type | nvarchar | 2 | 0 | | |
11 | T5DP4 | Assignment PAISY Company - Superordinate Company | 2 | SZART | PAISY: Record Type | nvarchar | 2 | 0 | | |
TOPLoans Management |
12 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 90 | SZART | Zahlungsvorgang | nvarchar | 1 | 0 | | |
13 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 204 | SZART | Zahlungsvorgang | nvarchar | 1 | 0 | | |
14 | VDBEPI | Posted line items for document header | 117 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
15 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 117 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
16 | VDBEPP | Flow Data - Planned Item | 143 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
17 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 143 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
18 | VDCFWAREHOUSE | Cash Flow Management | 76 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
19 | VDREPAYMENT | Payoff Master Data | 69 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
20 | VDZV | Payment Details for the Loan | 18 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
21 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 146 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
22 | TIV76 | Area types for each external usage type | 4 | SZART | Assignment type | nvarchar | 1 | 0 | | |
23 | TZK01 | Condition types | 13 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
TOPTransaction Manager |
24 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 31 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
25 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 29 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
26 | REFCC | References between CO object numbers, currency differences | 18 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
27 | SLDT_FLOW | Subledger Distributor Transactions | 56 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
28 | TERT_FLOW | Flow Table for Rights that can be Exercised | 25 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
29 | TRDT_FLOW | Persistent distributor flows | 54 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
30 | VTBFHAPO | Transaction Flow | 31 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
31 | VTBFHAPO_MIGR | Migrated Financial Flows | 31 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
32 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 31 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
33 | VTBPFHAPO | Treasury: Flow Shells | 30 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
34 | VTBZV | Payment Details for Transaction | 18 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
35 | VTIFHAPO | Underlying transaction flows | 29 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
36 | VWBEPI | Treasury Securities: Actual Flows - Item | 98 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
37 | VWBEPP | Treasury Securities: Planned Flows | 145 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
38 | VWORDE | Order Data | 98 | SZART | Payment transaction | nvarchar | 1 | 0 | | |
TOPTransfer to Financial Accounting |
39 | TRACC_MIG_ACCDET | Table for Migration of Account Determination | 9 | SZART | Payment Transaction | nvarchar | 1 | 0 | | |
40 | TRACT_ACCITEM | Accounting Items | 6 | SZART | Payment Transaction | nvarchar | 1 | 0 | | |
41 | TRAC_DFTRULE1 | Treasury: Assignment of Update Type to Posting Specs | 3 | SZART | Payment Transaction | nvarchar | 1 | 0 | | |
42 | TRAC_DFTRULE2 | Treasury: Assgmt of Update Type to Post. Specs per Valn Area | 4 | SZART | Payment Transaction | nvarchar | 1 | 0 | | |
TOPTreasury and Risk Management |
43 | TREAT_EXT_ACC_PM | Treasury: External Account Payment Details | 11 | SZART | Payment transaction | nvarchar | 1 | 0 | | |