| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD010CO | Items for Class SD01 - Raw Data | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
2 | /1RA/0SD012CO | Items for Class SD01 - Processable | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
3 | /1RA/0SD014CO | Items for Class SD01 - Processed | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
4 | /1RA/0SD020CO | Items for Class SD02 - Raw Data | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
5 | /1RA/0SD022CO | Items for Class SD02 - Processable | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
6 | /1RA/0SD024CO | Items for Class SD02 - Processed | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
7 | /1RA/0SD030CO | Items for Class SD03 - Raw Data | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
8 | /1RA/0SD032CO | Items for Class SD03 - Processable | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
9 | /1RA/0SD034CO | Items for Class SD03 - Processed | 13 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
10 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 21 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
11 | DFKKFWKORRN | Cumul. Table for Adjustment and Inverse Postings (New) | 16 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
12 | DFKK_ACCADJ | Adjustment Postings when Implementing Acct Assgmt Chars | 14 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
13 | DFKK_NEWACCADJ | Obsolete: See DFKK_ACCADJ | 14 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
14 | FARR_D_INVOICE | Invoice Entries | 12 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
15 | FARR_D_POSTING | Posting table | 12 | BETRH | Amount in Local Currency | decimal | 23 | 2 | | |
16 | T043G | Tolerances for Groups of Customers/Vendors | 5 | BETRH | Maximum Payment Difference for Expense | decimal | 7 | 2 | | |
17 | T043S | Tolerances for Groups of G/L Accounts | 5 | BETRH | Maximum Expense Difference on Clearing | decimal | 7 | 2 | | |
18 | T043T | FI tolerance groups for employees | 5 | BETRH | Maximum Payment Difference for Expense | decimal | 7 | 2 | | |
TOPBusiness transactions |
19 | DFKKTXINV | Tax Invoices | 14 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
TOPContract Accounts Receivable and Payable |
20 | DFKKBRPOPNOT | Balance reporting: noticed contract account document items | 11 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
21 | DFKKCIBW | FICA: Extraction of Cleared Items | 16 | BETRH | Amount in Local Currency with +/- Signs | decimal | 15 | 2 | | |
22 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
23 | DFKKFMBGAINFO | Tax Information for Public-Owned Commercial Operations | 20 | BETRH | Amount in Local Currency | decimal | 13 | 2 | | |
24 | DFKKFWKORR | Cumulation Table for Adjustment and Inverse Postings | 15 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
25 | DFKKIPBW_ITEM | Installment Plan Items for Business Warehouse | 16 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
26 | DFKKIPBW_ORIG | Installment Plan Original Items for Business Warehouse | 19 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
27 | DFKKIP_GRP | Payment Specification: Header Data | 41 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
28 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 43 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
29 | DFKKMOP | Items in contract account document | 41 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
30 | DFKKMOPK | Items in contract account document | 20 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
31 | DFKKOP | Items in contract account document | 41 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
32 | DFKKOPAA | Distribution Items with Account Assignment | 5 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
33 | DFKKOPBW | OI Extraction | 17 | BETRH | Amount in Local Currency with +/- Signs | decimal | 15 | 2 | | |
34 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 24 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
35 | DFKKOPK | Items in contract account document | 20 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
36 | DFKKOPK_SHORT | Offsetting Items for FI-CA Document - Extracts | 8 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
37 | DFKKOP_REP | Open Items from FPO4 | 45 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
38 | DFKKOP_SHORT | Partner Items for FI-CA Document - Extracts | 12 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
39 | DFKKORDERPOS | Requests: Items | 23 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
40 | DFKKORDERPOS_S | Request Templates: Items | 22 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
41 | DFKKPPI | Open Items for Promise to Pay, with Amount | 8 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
42 | DFKKQSR | Individual Records for Withholding Tax Report | 14 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
43 | DFKKRAP | Clearing/Reversal History (Line Item Level) < 4.62 | 11 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
44 | DFKKRAPT | Clearing/Reversal History (Line Item Level) | 11 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
45 | DFKKREP01 | Data for Sales Lists (Belgium) | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
46 | DFKKREP02 | Data for Sales Lists (Belgium) | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
47 | DFKKREP03 | Payment History: Posting Totals for Debit Entries | 8 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
48 | DFKKREP04 | Payment History: Open Items at End of Period | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
49 | DFKKREPTD | Adjusted Tax Data (Currently Not Used) | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
50 | DFKKRES | Reserve Postings | 11 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
51 | DFKKREV06 | Report for Tax on Sales/Purchases (bill. time or triggered) | 12 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
52 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 13 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
53 | DFKKRP | Returns lot: Data for payment | 7 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
54 | DFKKRP3 | Returns: Manual Posting Specifications | 18 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
55 | DFKKRP3H | Returns: History for Manual Posting Items | 14 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
56 | DFKKSUM | Posting totals from FI-CA | 47 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
57 | DFKKZA | Repayment Request | 7 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
58 | DFKKZP | Payment lot: Data for payment | 11 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
59 | DFKK_DUEGRID | OI - Reclassifications | 14 | BETRH | Amount in Local Currency with +/- Signs | decimal | 15 | 2 | | |
60 | DFKK_IPL_ITEMS | Installment Plan Key Date Recording (Original Items) | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
61 | DFKK_RECLASS | OI - Reclassifications | 12 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
62 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 7 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
63 | FKKMAREDUCT | Dunning Reductions | 11 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
TOPContract Billing |
64 | EPPMDEBTOPBELNR | Documents Transferred to PPM | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
TOPFinancial Services Localization |
65 | /GSINS/UPR_FKUPR | UPR - Calculation of unearned insurance premium reserve | 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
TOPInvoicing |
66 | DEABPS | Customer change table: Logical view of BB amounts | 36 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |
67 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 25 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | |