| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FARR_C_ACCTPRINC | Revenue Accounting: Configuration of Accounting Principle | 2 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
2 | FARR_C_ACCT_PARA | Revenue accounting parameters | 5 | ACCT_PRINCIPLE | Base Accounting Principle | nvarchar | 4 | 0 | | |
3 | FARR_C_ACPR_BUKR | Revenue Accounting: Supported Company Codes per Acct. Princ. | 2 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
4 | FARR_D_ACCRRUN | Accrual run table | 4 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
5 | FARR_D_COMP | Compound groups of Contract items | 2 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
6 | FARR_D_CONTRACT | Contract | 6 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
7 | FARR_D_DEFITEM | Deferral item table | 10 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
8 | FARR_D_EV_CONTR | Contract Table with Event Occuring | 3 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
9 | FARR_D_FULFILLMT | Fulfillment Entries | 4 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
10 | FARR_D_INVOICE | Invoice Entries | 4 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
11 | FARR_D_LEGACY | Legacy data for initial load of revenue accounting items | 6 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
12 | FARR_D_LEGACYC | Legacy data for initial load of conditions for rev.acc.it. | 6 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
13 | FARR_D_LEGACYSF | legacy data for scheduled fulfillments (time based) | 6 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
14 | FARR_D_MAPPING | Mapping Table to map source document to POBs of RA-Contracts | 9 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
15 | FARR_D_MAPPING_F | Mapping table for Fulfillment | 6 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
16 | FARR_D_MAPPING_I | Mapping table for Invoices | 6 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
17 | FARR_D_POB | Performance Obligation | 6 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
18 | FARR_D_POSTING | Posting table | 3 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
19 | FARR_D_PPRANGE | Range table for Parallel Process | 3 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
20 | FARR_D_RAI2_PROC | Acct. principles RAI2 was successfully processed for | 7 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
21 | FARR_D_RECON_HIS | History table for reconcilition between logistics and RA | 3 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |
22 | FARR_D_RECON_KEY | Reconciliation Key | 3 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | | |