| 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) | 16 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
2 | VDSEPA_AUTODEB_O | Records for new auto debit (SEPA direct debit) (up to 604) | 16 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
TOPAccounting |
3 | VDIOA_CALC_CF | Original Documents Without Model Account Int. on Arrears | 9 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
4 | VDIOA_CALC_HEAD | Calculation Details for Interest on Arrears Calculation | 26 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
TOPBack Office |
5 | TPMT_DEDOC_LOTPO | Derivatives Document: Document Item Per Lot | 4 | RPOSNR | Item in a derivatives document | nvarchar | 5 | 0 | | |
6 | TPMT_DEDOC_POS | Derivatives Document: Document Item | 4 | RPOSNR | Item in a derivatives document | nvarchar | 5 | 0 | | |
TOPGermany |
7 | TZBCKVWBEPI | Backup: Flow data - Position/Actual | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
TOPLoans Management |
8 | BCKTRLET_LOAN_FL | Treasury: Loans Transferred | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
9 | TDESRVDINVIP | CML Corr.: Invoice Positions | 18 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
10 | TRLET_LOAN_FLOW | OBSOLETE: Previous Solution: Loans Flows Transferred | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
11 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 184 | RPOSNR | Vorgangsnummer | nvarchar | 3 | 0 | | |
12 | VDARC_DOC_IND | Index Table for the Loan Document Data Archiving | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
13 | VDBEL | Document relationship between FI and subledger document | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
14 | VDBEPI | Posted line items for document header | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
15 | VDBEPI_EU | Flow Data / Actual Position Before EURO Conversion | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
16 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
TOPPortfolio |
17 | VDBILL_ITEMS | Billing Items | 6 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
TOPPosition Management |
18 | WBASSOC | Global Trade: Association Table | 5 | RPOSNR | Assoc. Mngt: Item No. of Document to Which Doc.is Assigned | nvarchar | 10 | 0 | | |
TOPTransaction Manager |
19 | BCKVWBEPI | Backup: Flow data - Position/Actual | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
20 | TRQT_ASSIGN_HIST | CFM: Lot Assignment History | 3 | RPOSNR | Item number of an executable right | nvarchar | 8 | 0 | | |
21 | TRQT_VWVORTR_LOT | (obsolete) | 7 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
22 | VWBEPI | Treasury Securities: Actual Flows - Item | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |
TOPTransfer to Financial Accounting |
23 | TRSET_FLOW | OLD: Prelim. Solution: Transferred Security Flows | 4 | RPOSNR | Activity number | nvarchar | 3 | 0 | | |