| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VDSEPA_AUTODEB | Records for new auto debit (SEPA direct debit) | 15 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
2 | VDSEPA_AUTODEB_O | Records for new auto debit (SEPA direct debit) (up to 604) | 15 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
TOPAccounting |
3 | VDIOA_CALC_CF | Original Documents Without Model Account Int. on Arrears | 8 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
4 | VDIOA_CALC_HEAD | Calculation Details for Interest on Arrears Calculation | 25 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
TOPLoans Management |
5 | BCKTRLET_LOAN_FL | Treasury: Loans Transferred | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
6 | TDESRVDINVIP | CML Corr.: Invoice Positions | 17 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
7 | TRLET_LOAN_FLOW | OBSOLETE: Previous Solution: Loans Flows Transferred | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
8 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 8 | RBELKPFD | Belegnummer des Belegkopfes (Darlehen) | nvarchar | 10 | 0 | | |
9 | VDARC_DOC_IND | Index Table for the Loan Document Data Archiving | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
10 | VDBEKI | Flow Data: Document Header for Actual Record | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
11 | VDBEKI_SHADOW | Shadow Table for VDBEKI (Restrictions) | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
12 | VDBEL | Document relationship between FI and subledger document | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
13 | VDBEPI | Posted line items for document header | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
14 | VDBEPI_EU | Flow Data / Actual Position Before EURO Conversion | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
15 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
16 | VDCHK_AWKEY | Storage of unique links between FI and CML doc | 4 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
17 | VDCHK_DOC_IP | Payments for Subsequent Posting | 3 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
18 | VDDAB | Data Transfer - Loans - Flows - Actual Records | 5 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
19 | VDDAST | TR-EDT: Transfer Loans | 8 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
20 | VZFZE_VDBEKI | Central Entry Table for Release Procedure | 6 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
21 | VZFZE_VDNBZE | Central Entry Table for Release Procedure | 24 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |
TOPPortfolio |
22 | VDBILL_ITEMS | Billing Items | 5 | RBELKPFD | Document Number of Document Header (Loan) | nvarchar | 10 | 0 | | |