| 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 | | |