| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNV_10520FICAMAP | Mappingtable for conversion of foreign currencies | 13 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 2 | CNV_10520_DOCMAP | CNV_10520: Mapping Table for FICA Documents | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 3 | DFKKCFKWL | KWL: KPI Cockpit Worklist | 11 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 4 | DFKKDFCNTRL | Control Table for Transfer Postings | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 5 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 6 | DFKKODNREP | Official Document Number for Reporting | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 7 | DFKKOP_DP | Down Payments: Tax Data for Business Partner Item | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 8 | DFKKPDC | FI-CA: Postdated Checks | 21 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 9 | DFKKPDCS | FI-CA: Status Changes for Postdated Checks | 10 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 10 | DFKKPICLARIF | Clarification Work List for Penalty and Interest | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 11 | DFKKPICLARIFIT | Penalty and Interest Clarification Case: Processed objects | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 12 | DFKKPICLARIFITA | Penalty and Interest Clarification Case: Mass Processes Log | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 13 | DFKKPRND | SEPA: Direct Debit Pre-Notification (FI-CA) Deleted Items | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 14 | DFKK_ACCADJ | Adjustment Postings when Implementing Acct Assgmt Chars | 21 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 15 | DFKK_NEWACCADJ | Obsolete: See DFKK_ACCADJ | 21 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 16 | DFKK_TRIGX_CL | Outbound Interface: New Trigger Table of Cleared Items | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 17 | DFKK_TRIGX_RCL | OI: New Trigger Table for Reopened Items | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 18 | FKKID_EXP_HDR_A | Cr.Mem.&Exp.Conf.: Export Confirmation Header | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 19 | FKKID_EXP_ITM_A | Cr.Mem.&Exp.Conf.: Export Confirmation Items | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 20 | FKKID_VAT_ITM_A | Cr.Mem.&Exp.Conf.: VAT Transfer Items | 11 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 21 | FKKSK_VATLED | FI-CA Slovakia: VAT Ledger Exported Data | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 22 | FKKSK_VATLED_D2 | FI-CA Slovakia: VAT Ledger Section D2 records(keys) | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPCollectionsDisbursements |
| 23 | IBROSTMS | ISCD: Broker Report - Selected Items Related to an Item | 7 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 24 | ITAGCYAGENCYFI | Agency Collections: Data for Transfer to Agency FI | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 25 | ITAGCYPYMETSET | Setting Payment Methods in Agency Collections | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 26 | ITAGCYSUBCOMMTRG | Trigger Table for Posting and Transferring Subcommission | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 27 | TKKV_VZK_LINK | Link Table Document <> Additional Acct Assignment for Ins. | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 28 | VVKKCFREC | Cash Receipts to be Transferred to Claims System | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 29 | VVKKDRZE | Dunning Notice Output: Repetition Items | 10 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 30 | VVKKEXPTRIGGER | Trigger for Expiry Notes | 7 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 31 | VVKKFAPOS | Invoicing Items in FS-CD | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 32 | VVKKMHIST | Contract-Related Dunning History | 33 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 33 | VVKKREPCL | Money Laundering Clarification Worklist | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 34 | VVKKREPCL_REP | FS-CD: Money Laundering Law Reporting State | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 35 | VVKKREPRP | Coinsurance Reporting: Recording Item OBSOLETE | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 36 | VVSCCLINFO | Bill Scheduling: Clearing Information | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 37 | VVSCITEM | Bill Scheduling: Scheduling Document | 10 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 38 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 10 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 39 | VVSCRESPAYMENT | Bill Scheduling: Universal Life | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 40 | VVSCULCFC | Customer-Initiated Payment Clearing | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 41 | DFKCRPO | Clarification Worklist Credit | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 42 | DFKK1099 | 1099 Statutory Reporting Data | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 43 | DFKKCASEITEMS | Item List in Cases, Lines | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 44 | DFKKCFPAYRUN | Clarif. Worklist: Payment Program (Obsolete) | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 45 | DFKKCFPAYRUN2 | Calrification Worklist: Payment Program (New Version) | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 46 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 47 | DFKKDOUBTD_W | Buffer: Create Printout for Receivables Adjustment | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 48 | DFKKEWUDOCCRIT | Euro: Critical Documents in Conversion | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 49 | DFKKFH | FI-CA: Table of Fine History | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 50 | DFKKFWTRIG | Trigger Table for Inverse Postings | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 51 | DFKKIA | FI-CA: Database table for FKKIA - intrst supp | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 52 | DFKKIAPT | Interest Calculation: Log for Interest Run | 10 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 53 | DFKKIH | FI-CA: Table with Interest History | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 54 | DFKKIPBW_ITEM | Installment Plan Items for Business Warehouse | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 55 | DFKKIPBW_ORIG | Installment Plan Original Items for Business Warehouse | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 56 | DFKKIP_ITM | Payment Specification: Related Items | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 57 | DFKKIP_ITMH | Payment Specification: Deletions Not Yet Confirmed | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 58 | DFKKIP_ITMV | Payment Specification: Preselected Items | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 59 | DFKKMOP | Items in contract account document | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 60 | DFKKMOPK | Items in contract account document | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 61 | DFKKOP | Items in contract account document | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 62 | DFKKOPAA | Distribution Items with Account Assignment | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 63 | DFKKOPBEW | FI-CA Foreign Currency Valuation | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 64 | DFKKOPBEW_LD | FI-CA Ledger-Specific Foreign Currency Valuation | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 65 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 66 | DFKKOPEW | Business Partner Items: Amounts Before Euro Conversion | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 67 | DFKKOPK | Items in contract account document | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 68 | DFKKOPKC | Card Data Appendix for FICA Document | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 69 | DFKKOPKC_ERR | Error Table for Payment Card Billing | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 70 | DFKKOPKC_RESEND | Card Data Supplement: Status After Resend | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 71 | DFKKOPKEW | G/L Account Items: Amounts Before Euro Conversion | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 72 | DFKKOPKX | Items for Contract Accounting Document (Enhancement) | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 73 | DFKKOPK_SHORT | Offsetting Items for FI-CA Document - Extracts | 5 | OPUPK | Item Number in Contract Account Document | nvarchar | 11 | 0 | | |
| 74 | DFKKOPK_TEXT_GL | Text G/L Item | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 75 | DFKKOPL | Locks for Open Items (Change Document Interface) | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 76 | DFKKOPVZ | Agreed Payment Amounts | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 77 | DFKKOPWH | Withholding Tax Data for Business Partner Item | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 78 | DFKKOP_REP | Open Items from FPO4 | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 79 | DFKKOP_SHORT | Partner Items for FI-CA Document - Extracts | 5 | OPUPK | Item Number in Contract Account Document | nvarchar | 11 | 0 | | |
| 80 | DFKKPPI | Open Items for Promise to Pay, with Amount | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 81 | DFKKPPP | Payment Assignments to Promises to Pay | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 82 | DFKKRAP | Clearing/Reversal History (Line Item Level) < 4.62 | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 83 | DFKKRAPT | Clearing/Reversal History (Line Item Level) | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 84 | DFKKRDI | Revenue Distribution | 7 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 85 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 3 | OPUPK | Item Number in Contract Account Document | nvarchar | 4 | 0 | | |
| 86 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 3 | OPUPK | Item Number in Contract Account Document | nvarchar | 4 | 0 | | |
| 87 | DFKKREP07 | Tax Report Data (Clearing Time) | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 88 | DFKKREP07_T | Tax Report Data (Additional Data for Transfer Posting) | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 89 | DFKKREPAP | Recording Record | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 90 | DFKKREPTCL | Clearing Information for Receipt Documents | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 91 | DFKKREPTD | Adjusted Tax Data (Currently Not Used) | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 92 | DFKKRES | Reserve Postings | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 93 | DFKKREV06 | Report for Tax on Sales/Purchases (bill. time or triggered) | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 94 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 95 | DFKKSUM | Posting totals from FI-CA | 13 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 96 | DFKKTHI | Transfer Records for Invoice Issue by Third Party | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 97 | DFKKTHI_HIST | Historical Entries of DFKKTHI | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 98 | DFKKTHI_HIST2 | Reversal: Historical Entries DFKKTHI (w/o Tax Posting) | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 99 | DFKKTHP | Transfer Records for Billing on Behalf of 3rd Party | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 100 | DFKKVBUND_REV | VBUND Adjustments for Revenues and Expenses | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 101 | DFKKWLI_IL | Item List of Work Item | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 102 | DFKKWOH | Write-Off History | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 103 | DFKKWOHTMP | Temporary Write-Off History | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 104 | DFKKWO_PROT | Line Items Written Off from Mass Run | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 105 | DFKKWRTOFF_WF | FI-CA Data for Write-Off in Workflow | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 106 | DFKKZR | Payment form | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 107 | DFKKZW | Doubtful/Individual Val. Adjust. for Receivables - Trigger | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 108 | DFKKZW2 | Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 109 | DFKKZWFH | Doubtful/Individually Adjusted Receivables: History | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 110 | DFKKZWFP | Doubtful/Individually Adjusted Receivables: Tfrd Receivables | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 111 | DFKKZWFT | Doubtful/Individually Adjusted Receivables: Trigger Table | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 112 | DFKKZWH | Doubtful/Ind.Val.Adj.Receivables - History | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 113 | DFKK_IPL_ITEMS | Installment Plan Key Date Recording (Original Items) | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 114 | DFKK_PYREF | Payment Reference | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 115 | DFKK_TRIGGER_CL | Outbound Interface: Trigger Table of Cleared Items | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 116 | DFKK_TRIGGER_RCL | Outbound Interface: Trigger Table for Reopened Items | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 117 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 118 | FKKMAZE | Dunning history of line items | 9 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 119 | FKK_INSTPLN_HIST | Installment Plan History | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 120 | FKK_INSTPLN_INVH | History of Installment Plan Due Dates from Invoicing | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 121 | FKK_IP_DEACT_DB | Installment Plan Deactivation History | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 122 | FKK_KONTL_LINK | Link Table: Document <> Variable Additional Account Assigmts | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 123 | FKK_UMBPOS | History of Document Transfer to Another Account | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 124 | IST_LOCK_PROP_DB | Dis/Reconnection Proposals Table for IS-T Services in RM-CA | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 125 | IST_WLTEL | IS-T/CA: Work List: Reconnect Tel. No. <- Post Document 0020 | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPContract Billing |
| 126 | EPPMDEBTOPBELNR | Documents Transferred to PPM | 8 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPFinancial Services Localization |
| 127 | /GSINS/UPR_DEFRE | UPR - Calculation of unearned insurance premium reserve | 7 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 128 | /GSINS/UPR_FKUPR | UPR - Calculation of unearned insurance premium reserve | 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPIntercompany Data Exchange |
| 129 | IUEEDPPLOTATREF3 | Distribution of Aggr. Payments: Admission Amts for Dist. Lot | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 130 | TINV_BW_TRIG_THI | Trigger for Delta Extraction of Transfer Recs f. Third Party | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPInvoicing |
| 131 | DEABPS | Customer change table: Logical view of BB amounts | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPInvoicing in Contract Accounts Receivable and Payable |
| 132 | DFKKINVDOC_C | Invoicing Document: Charges and Discounts | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 133 | DFKKINVDOC_CH | Invoicing Document: Charges and Discounts History Record | 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 134 | DFKKINVDOC_P | Invoicing: Posting Document Reference Table | 7 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 135 | DFKKINV_OTRIG | Order for Offsetting in Invoicing | 16 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPLease Accounting |
| 136 | /LSIERP/TRIG_NA | Leases Not Set to Non-Accrual | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 137 | /LSIERP/WLI_IL | Item List of Work Item | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| TOPPublic Sector Contract Accounts Receivable and Payable |
| 138 | DFMCAINVPOS | Invoice in IS-PS-CA: Items | 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
| 139 | DFMCA_OP_REFDOC | Items in contract account document of a Form Bundle | 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | |
