DW_NS_REVENUE_PLAN_DETAILS_F
This fact contains information about the planned revenues of the revenue plans which have the recognition details by accounting period.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Transaction Identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. | ||||
| deferredrevenueaccount | NUMBER | 38 | 0 | DW_NS_account_D | id | ||
| isrecognized | VARCHAR2 | 16 | |||||
| journal | NUMBER | 38 | 0 | The Journal transaction identifier resulted from posting the time tracking record. | DW_NS_JOURNAL_F | id | |
| percentrecognizedinperiod | NUMBER | ||||||
| percenttotalrecognized | NUMBER | ||||||
| plannedperiod | NUMBER | 38 | 0 | DW_NS_accountingPeriod_D | id | ||
| plannedrevenuetype | VARCHAR2 | 128 | DW_NS_plannedRevenueType_D | key | |||
| postingperiod | NUMBER | 38 | 0 | Period identifier to which this transaction is posted. | DW_NS_accountingPeriod_D | id | |
| recognitionaccount | NUMBER | 38 | 0 | Income account for the revenue element. The default value is derived from the item record. | DW_NS_account_D | id | |
| revenueplan | NUMBER | 38 | 0 | DW_NS_REVENUE_PLAN_F | id | ||
| periodcomments | VARCHAR2 | 512 | |||||
| accountingbook_exchangerate | NUMBER | Exchange rate between accounting book currency and transaction currency. | |||||
| amount | NUMBER | Amount in transaction currency. | |||||
| totalrecognized | NUMBER | The total revenue that has been recognized on the revenue plan in source transaction currency. | |||||
| accountingbook_amount | NUMBER | Transaction amount in accounting book currency. | |||||
| accountingbook_totalrecognized | NUMBER | The total revenue that has been recognized on the revenue plan in accounting book currency. | |||||
| accountingbook | NUMBER | 38 | 0 | Accounting Book Identifier . | |||
| catchupperiod | NUMBER | 38 | 0 | The catch up period is the period during which we can recognize the revenue that was not recognized earlier due to a hold in it's schedule. | |||
| createdfrom | NUMBER | 38 | 0 | Transaction identifier of source transaction from which this transaction is created. | |||
| item | NUMBER | 38 | 0 | Identifier of the item. | |||
| parentlinecurrency | NUMBER | 38 | 0 | This is the currency from the source customer obligation document. | |||
| recognitionmethod | VARCHAR2 | 64 | The recognition method which was specified in the revenue recognition rule. | ||||
| reforecastmethod | VARCHAR2 | 64 | The method used to calculate the revenue forecast plans. | ||||
| revenueplantype | VARCHAR2 | 64 | The type of revenue plan such as Actual, Forecast. | ||||
| revenueplancurrency | NUMBER | 38 | 0 | This is the base currency for the accounting book and subsidiary. | |||
| revenuerecognitionrule | NUMBER | 38 | 0 | Revenue recognition rule identifier associated with the revenue element. It is used to generate Revenue Plan. | |||
| revrecenddate | TIMESTAMP | Revenue recognition end date. | |||||
| revrecstartdate | TIMESTAMP | Revenue recognition start date. |