| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKPRNH | SEPA: Direct Debit Pre-Notifications (FI-CA) | 27 | ZIBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
2 | FSEPA_INST_CD | Local Instrument and Lead Times for SEPA Direct Debits | 7 | ZIBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPAutomatic Payments |
3 | PAYRQ | Payment Requests | 155 | ZIBAN | IBAN of the Payee | nvarchar | 34 | 0 | | |
TOPContract Accounts Receivable and Payable |
4 | DPAYH | Payment program - data for payment | 92 | ZIBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPayment Transactions |
5 | FPRL_ITEM | Item Data | 135 | ZIBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
6 | PAYR | Payment Medium File | 45 | ZIBAN | IBAN of the Payee | nvarchar | 34 | 0 | | |
7 | REGUH | Settlement data from payment program | 168 | ZIBAN | IBAN of the Payee | nvarchar | 34 | 0 | | |
8 | REGUHH | REGUH version before the 'n'th change | 35 | ZIBAN | IBAN of the Payee | nvarchar | 34 | 0 | | |
TOPPayroll |
9 | T7BGA1 | Bank transfer - interface table | 28 | ZIBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
10 | T7ROA1 | Bank transfer - interface table | 29 | ZIBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |