| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FSEPA_INST_CD | Local Instrument and Lead Times for SEPA Direct Debits | 5 | ZBNKS | Country Key of Bank of Payer | nvarchar | 3 | 0 | | |
TOPAutomatic Payments |
2 | PAYRQ | Payment Requests | 102 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
TOPBank Customer Accounts |
3 | TBKKIHB4 | FI Data for Manual Outgoing Payments In-House Bank | 5 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
4 | TBKKIHB5 | Payt Method Determination HQ FI for Payment In-House Bank | 8 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
5 | DFKKDDA | Debit Memo Notification | 26 | ZBNKS | Bank country key | nvarchar | 3 | 0 | | |
6 | DFKKPNBKA | Prenotification data (latest) | 10 | ZBNKS | Bank country key | nvarchar | 3 | 0 | | |
7 | DFKKPNBKH | Prenotification data (history) | 10 | ZBNKS | Bank country key | nvarchar | 3 | 0 | | |
8 | DPAYH | Payment program - data for payment | 45 | ZBNKS | Bank country key | nvarchar | 3 | 0 | | |
9 | TFK042Q | Payment Medium: Note of First Direct Debit | 4 | ZBNKS | Bank country key | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
10 | AVIK | Payment Advice Header | 41 | ZBNKS | Country key of partner bank | nvarchar | 3 | 0 | | |
TOPFunds Management |
11 | TBKWT | Processing Time per Country | 3 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
TOPPayment Transactions |
12 | FPRL_ITEM | Item Data | 128 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
13 | PAYR | Payment Medium File | 40 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
14 | PNBK | Prenotification: New bank data from master records | 2 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
15 | REGUH | Settlement data from payment program | 36 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
16 | REGUHH | REGUH version before the 'n'th change | 11 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |
17 | REGUHO | REGUH version before the 'n'th change | 11 | ZBNKS | Country Key | nvarchar | 3 | 0 | | |