| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VDSEPA_MND_USG | Overview of mandates used in Loans Management | 7 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
TOPBasic Functions |
2 | FDD1 | Cash mgmt and forecast-Loan line items-Memo records | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
3 | FDI1 | Cash Management Line Item for RE Classic Planning Records | 3 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
4 | FDW1 | Cash Mgt and Forecast - Securities Line Items- Planned Flows | 5 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
TOPFinancial Services |
5 | VDBIW_DATA | Extractor Flow Data - Data of Last Extraction | 6 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
TOPLoans Management |
6 | TDESRVDINVIP | CML Corr.: Invoice Positions | 5 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
7 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 5 | DTRANS | Schlüssel Bewegungsdaten: Systemdatum | nvarchar | 8 | 0 | | |
8 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 70 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
9 | VDAUSZ | Drawings on Disbursement | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
10 | VDAUSZ_EU | Disbursement Drawings Before EURO Conversion | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
11 | VDBEPI | Posted line items for document header | 64 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
12 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 64 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
13 | VDBEPP | Flow Data - Planned Item | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
14 | VDBEPP_EU | Flow Data / Planned Items Before EURO Changeover | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
15 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
16 | VDBOBEPP_EU | Flow Data / Planned Items Before EURO Changeover | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
17 | VDCFWAREHOUSE | Cash Flow Management | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
18 | VDGPO | Loan: Relationship Partner/Role Object | 6 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
19 | VDINSURE_PARTNE0 | Do Not Use: Link Partner <-> Insurance | 5 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
20 | VDKOREF | Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. | 6 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
21 | VDNOTEPAYEE | Note to Payee | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
22 | VZFZE_VDAUSZ | Central Entry Table for Release Procedure | 6 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
23 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 7 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
24 | VIBEPP | Flow data - Planned items for real estate management | 3 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
25 | BCKVWBEPP | BACKUP: Flow data - Position/Planned | 5 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
26 | BCKVWORDE | BACKUP: Order data | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
27 | VWBEPP | Treasury Securities: Planned Flows | 5 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
28 | VWORDE | Order Data | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
TOPTreasury |
29 | FLQITEMD1_FC | Liquidity Calculation: Forecast Line Items from Loans | 4 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |
30 | VZGPO | Partner/role object relationship | 6 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | | |