| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKPRNH | SEPA: Direct Debit Pre-Notifications (FI-CA) | 15 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
TOPBank Accounting |
2 | DFPAYMENT_KEY_ID | Contains ID for Payment Data Key | 8 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
TOPContract Accounts Receivable and Payable |
3 | DFKKAWM | Foreign Trade Reporting: Report File | 12 | DOC1R | Reference for Report Document | nvarchar | 24 | 0 | | |
4 | DFKKAWM_CORR | Request for Corrections for Entries in DFKKAWM | 3 | DOC1R | Reference for Report Document | nvarchar | 24 | 0 | | |
5 | DFKKCR | Repository For Checks | 19 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
6 | DFKKCRCL | Table for Checks To Be Clarified | 12 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
7 | DFKKCRDEL | CR: Deleted Payment Medium / Basic Data | 22 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
8 | DFKKDDA | Debit Memo Notification | 11 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
9 | DFKKIP_GRP | Payment Specification: Header Data | 22 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
10 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 24 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
11 | DFKKPPD_PAY | Promise to Pay Debit Memo Amounts per Date | 20 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
12 | DPAYCHKP | Header: Accounting Using Creation of Payment Media | 11 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
13 | DPAYD | Payment Program - Payments (Check of Direct Debit Limit) | 3 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
14 | DPAYH | Payment program - data for payment | 22 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |
15 | FKKCRDOC | Aux. Table for Block Object EFKKCRDOC/Check Management | 3 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | |