| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | DFKKPRND | SEPA: Direct Debit Pre-Notification (FI-CA) Deleted Items | 2 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
| 2 | DFKKPRNH | SEPA: Direct Debit Pre-Notifications (FI-CA) | 2 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 3 | DFKKMOP | Items in contract account document | 142 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
| 4 | DFKKMOPW | Items in contract account document | 26 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
| 5 | DFKKOP | Items in contract account document | 142 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
| 6 | DFKKOPW | Items in contract account document | 26 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
| 7 | DFKKOP_REP | Open Items from FPO4 | 148 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
| 8 | DFKKORDERPOS | Requests: Items | 35 | PNNUM | SEPA: Number of Direct Debit Pre-Notification | nvarchar | 16 | 0 | | |
