| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKBIXPABIT_REL | Release Order for Partner BITs for Billing | 5 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
2 | DFKKHUREPDS | Recording Data for Domestic Sales Hungary | 23 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
3 | DFKKINVDOC_REV | Reversal Request for Invoicing Document | 19 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
4 | DFKKPARTADJ | Trigger for Adjustment of Partner Billable Items | 7 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
5 | DFKKPARTREL | Release Order of Partner Items for Partner Settlement | 8 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
6 | ITAGCYTCBP | Agency Collections: Temporary Collections with BP | 9 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
TOPCollectionsDisbursements |
7 | IBROSTMSUM | Broker Summary Postings - Restart Information | 10 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
8 | VINTEGBALANCED | Trigger for Fully Cleared Documents | 8 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
9 | VKKQUOTS | Quotation Monitoring FS-CD Acceptance Status | 9 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
10 | VVKKCFREC | Cash Receipts to be Transferred to Claims System | 20 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
11 | VVKKDRKO | Dunning Printout:Header Items | 13 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
12 | VVKKDRZE | Dunning Notice Output: Repetition Items | 18 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
13 | VVKKEXPTRIGGER | Trigger for Expiry Notes | 9 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
14 | VVKKFOP | Single Doc in Posting Data Interface | 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
15 | VVKKFOPT | Table for FS-CD Test Data of Structure VKKKFOP | 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
16 | VVKKMAKT | Executed Dunning Activities | 14 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
17 | VVKKMHIST | Contract-Related Dunning History | 36 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
18 | VVKKTAXREP | Tax Reporting ITA: Data for Tax Report | 24 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
19 | VVKK_COINSH | Coinsurance Shares Header Table | 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
20 | VVSCPOS | Payment Plan Item | 129 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
21 | DFKKCIBW | FICA: Extraction of Cleared Items | 20 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
22 | DFKKCMP | Manually Issued Checks Lot: Item Data | 16 | FAEDN | Check Redeemable/Valid From | nvarchar | 8 | 0 | | |
23 | DFKKCOMA | Correspondence Dunning | 25 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
24 | DFKKCR | Repository For Checks | 28 | FAEDN | Check Redeemable/Valid From | nvarchar | 8 | 0 | | |
25 | DFKKCRDEL | CR: Deleted Payment Medium / Basic Data | 31 | FAEDN | Check Redeemable/Valid From | nvarchar | 8 | 0 | | |
26 | DFKKDDA | Debit Memo Notification | 4 | FAEDN | Collection Date | nvarchar | 8 | 0 | | |
27 | DFKKDOUBTD_RET_W | Buffer: Printout for Ind.Val.Ad - Return Values (User Event) | 13 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
28 | DFKKDOUBTD_W | Buffer: Create Printout for Receivables Adjustment | 19 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
29 | DFKKIPBW_ITEM | Installment Plan Items for Business Warehouse | 13 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
30 | DFKKIPBW_ORIG | Installment Plan Original Items for Business Warehouse | 16 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
31 | DFKKMOP | Items in contract account document | 34 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
32 | DFKKMOPW | Items in contract account document | 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
33 | DFKKOP | Items in contract account document | 34 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
34 | DFKKOPBW | OI Extraction | 16 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
35 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 23 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
36 | DFKKOPW | Items in contract account document | 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
37 | DFKKOP_REP | Open Items from FPO4 | 38 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
38 | DFKKOP_SHORT | Partner Items for FI-CA Document - Extracts | 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
39 | DFKKORDERPOS | Requests: Items | 18 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
40 | DFKKORDERPOS_S | Request Templates: Items | 17 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
41 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 22 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
42 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 22 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
43 | DFKKREP07 | Tax Report Data (Clearing Time) | 28 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
44 | DFKKREPZM | Recording Data for EC Sales List | 19 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
45 | DFKKREV06 | Report for Tax on Sales/Purchases (bill. time or triggered) | 18 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
46 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 24 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
47 | DFKKRP3 | Returns: Manual Posting Specifications | 15 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
48 | DFKKRP3H | Returns: History for Manual Posting Items | 11 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
49 | DFKKWLI_IL | Item List of Work Item | 9 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
50 | DFKKZA | Repayment Request | 10 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
51 | DFKK_IPL_ITEMS | Installment Plan Key Date Recording (Original Items) | 7 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
52 | DFKK_IPL_RATES | Installment Plan Key Date Recording (Installments) | 4 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
53 | FKKMAZE | Dunning history of line items | 15 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
54 | FKK_INSTPLN_INVH | History of Installment Plan Due Dates from Invoicing | 7 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
TOPIncentive and Commission Management ICM |
55 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 24 | FAEDN | Date | nvarchar | 8 | 0 | | |
TOPInvoicing |
56 | DBERDL | Print Document Line Items | 33 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
57 | DBERDZ | DB Table: Individ. Lines - Print Document | 15 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
58 | DEABPS | Customer change table: Logical view of BB amounts | 29 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
59 | EABPJVL_CORR | Correspondence Print: Bud. Bill. Plan Header and YAP Info. | 20 | FAEDN | YAP Due Date | nvarchar | 8 | 0 | | |
60 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 9 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
61 | EITR | Temporary Selection Data for IS-U Invoicing | 15 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
62 | EJVL | Yearly Advance Payment | 13 | FAEDN | YAP Due Date | nvarchar | 8 | 0 | | |
63 | ERDK | Print Document/Header Data | 4 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
64 | ERDK_SHORT | Header Data for Print Document - Extract | 4 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
65 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 10 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
66 | DFKKINVBILL_I | Billing Document Items | 17 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
67 | DFKKINVDOC_H | Invoicing Document Header | 22 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
68 | DFKKINVDOC_I | Items of Invoicing Document | 52 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
TOPLease Accounting |
69 | /LSIERP/WLI_IL | Item List of Work Item | 9 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
TOPMigration |
70 | TEM_BBP_CB | IS-U Mig: Assgt of BB Due Date for Collective Document No. | 3 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
71 | TEM_BBP_DEREG | IS-U Mig.: Budget Billing Request in legacy system (dereg.) | 3 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
72 | DFMCA_BRF150 | Text Parameters for Billing Line | 17 | FAEDN | BRF: Expression | nvarchar | 20 | 0 | | |
73 | DFMCA_BRF152 | BRF: Parameters for Calculation Line Items | 13 | FAEDN | Expression for Due Date | nvarchar | 20 | 0 | | |
74 | DFMCA_CORRM_ICR | Temp table for saving enhanced ICR setting for manual corr. | 5 | FAEDN | Inbound Correspondence Due Date | nvarchar | 8 | 0 | | |
75 | TFMCA_BRF221 | BRF: Parameters for Calculation Line Items | 14 | FAEDN | Expression for Due Date | nvarchar | 20 | 0 | | |
76 | TFMCA_BRF222 | BRF: Parameters for Refund Line Items | 9 | FAEDN | Expression for Due Date | nvarchar | 20 | 0 | | |