| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAutomatic Payments |
1 | PAYRQ | Payment Requests | 103 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
TOPContract Accounts Receivable and Payable |
2 | DFKKDDA | Debit Memo Notification | 28 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
3 | DFKKPNBKA | Prenotification data (latest) | 12 | ZBNKN | Bank account number | nvarchar | 18 | 0 | | |
4 | DFKKPNBKH | Prenotification data (history) | 12 | ZBNKN | Bank account number | nvarchar | 18 | 0 | | |
5 | DPAYH | Payment program - data for payment | 49 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
6 | TFK042Q | Payment Medium: Note of First Direct Debit | 6 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
TOPFinancial Accounting |
7 | AVIK | Payment Advice Header | 16 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
TOPLocalization |
8 | J_3R0 | Payment with correspondent account | 7 | ZBNKN | Bank account number of payment receiver | nvarchar | 18 | 0 | | |
TOPPayment Transactions |
9 | FPRL_ITEM | Item Data | 131 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
10 | PAYR | Payment Medium File | 41 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
11 | PNBK | Prenotification: New bank data from master records | 4 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
12 | REGUH | Settlement data from payment program | 37 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
13 | REGUHH | REGUH version before the 'n'th change | 12 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |
14 | REGUHO | REGUH version before the 'n'th change | 12 | ZBNKN | Bank account number of the payee | nvarchar | 18 | 0 | | |