| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKPRNH | SEPA: Direct Debit Pre-Notifications (FI-CA) | 28 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
TOPBilling in Contract Accounts Receivable and Payable |
2 | DFKKBIEDRAT | EDRs for Payment, Receivable, and Credit Amounts | 11 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
3 | DFKKBIEDRRJAT | Provisionally Rejected EDRs (Payments, Receivables, Credit) | 9 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
4 | DFKKBIEDRWOAT | Permanently Rejected EDRs (Payments, Receivables, Credit) | 9 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
TOPBusiness Partner |
5 | EKUN | IS-U-Specific Fields for Business Partner | 33 | EMBVT | Bank details ID for donations/fund payments | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
6 | ITAGCYPYMETSET | Setting Payment Methods in Agency Collections | 10 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
7 | VVKKFOP | Single Doc in Posting Data Interface | 23 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
8 | VVKKFOPT | Table for FS-CD Test Data of Structure VKKKFOP | 22 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
9 | VVSCPOS | Payment Plan Item | 120 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
10 | DFKKMOP | Items in contract account document | 96 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
11 | DFKKOP | Items in contract account document | 96 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
12 | DFKKOP_REP | Open Items from FPO4 | 100 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
13 | DFKKORDERPOS | Requests: Items | 33 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
14 | DFKKORDERPOS_S | Request Templates: Items | 32 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
15 | DFKKPPD_PAY | Promise to Pay Debit Memo Amounts per Date | 10 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
16 | DFKKPPD_PAY_HIS | Promise to Pay Debit Memo Amounts per Date | 9 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
17 | TE016 | Characterization for Alternate Payee | 5 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
TOPInvoicing |
18 | DEABPS | Customer change table: Logical view of BB amounts | 88 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
19 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 52 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
20 | DFKKINVBILL_PY | Payment Data Items of Billing Document | 8 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
21 | DFMCA_BRF152 | BRF: Parameters for Calculation Line Items | 19 | EMBVT | Alternataive Bank Details ID | nvarchar | 20 | 0 | | |
22 | TFMCA_BRF221 | BRF: Parameters for Calculation Line Items | 20 | EMBVT | Alternataive Bank Details ID | nvarchar | 20 | 0 | | |
23 | TFMCA_BRF222 | BRF: Parameters for Refund Line Items | 11 | EMBVT | Alternataive Bank Details ID | nvarchar | 20 | 0 | | |