DW_NS_REVENUE_PLAN_F
This fact contains information about the revenue plans which are used to indicate the posting periods in which revenue should be recognized and the amount to be recognized in each 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 | 999 | 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. | ||||
| accountingbook | NUMBER | 38 | 0 | Accounting Book Identifier . | DW_NS_accountingBook_D | id | |
| amountsource | VARCHAR2 | 64 | The amount source defines how the amount for a revenue recognition plan is derived from a fixed amount or percentage. | DW_NS_revRecAmountSourceType_D | key | ||
| 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. | DW_NS_accountingPeriod_D | id | |
| createdfrom | NUMBER | 38 | 0 | Transaction identifier of source transaction from which this transaction is created. | DW_NS_REVENUE_ELEMENT_F | id | |
| creationtriggeredbydisplay | VARCHAR2 | 999 | Display Name of the record that triggered revenue recognition plan creation. | ||||
| enddatechangeimpactfordisplay | VARCHAR2 | 64 | This determines how revenue recognition plans are updated when only the end date changes, options are either to update the revenue amount in all the periods or only for the remaining periods. | DW_NS_revRecChangeImpactType_D | key | ||
| holdrevenuerecognition | VARCHAR2 | 16 | Flag to indicate if a Revenue Plan is on hold, during which revenue recognition journal entries cannot be generated for any period in the plan. . | ||||
| iseliminate | VARCHAR2 | 16 | Flag to indicate if the source of the revenue element for the plan is an intercompany transaction. | ||||
| item | NUMBER | 38 | 0 | Identifier of the item. | DW_NS_item_D | id | |
| lastmodifieddate | TIMESTAMP | Last Modification Date. | |||||
| recognitionmethod | VARCHAR2 | 64 | The recognition method which was specified in the revenue recognition rule. | DW_NS_revRecRecurrenceType_D | key | ||
| recordnumber | VARCHAR2 | 128 | Revenue Plan Number. | ||||
| reforecastmethod | VARCHAR2 | 64 | The method used to calculate the revenue forecast plans. | DW_NS_reforecastMethod_D | key | ||
| revenueplantype | VARCHAR2 | 64 | The type of revenue plan such as Actual, Forecast. | DW_NS_revenuePlanType_D | key | ||
| revenuerecognitionrule | NUMBER | 38 | 0 | Revenue recognition rule identifier associated with the revenue element. It is used to generate Revenue Plan. | DW_NS_RevenueRecognitionRule_D | id | |
| revrecenddate | TIMESTAMP | Revenue recognition end date. | |||||
| revrecenddatesource | VARCHAR2 | 64 | The source used to determine the default end date on the revenue recognition plan, such as Rev Term in Months, Element End Date etc. . | DW_NS_revRecDateSourceType_D | key | ||
| revrecstartdate | TIMESTAMP | Revenue recognition start date. | |||||
| revrecstartdatesource | VARCHAR2 | 64 | The source used to determine the initial revenue recognition start date on the revenue recognition plan, such as Arrangement Transaction Date, Event Date etc. | DW_NS_revRecDateSourceType_D | key | ||
| statusfordisplay | VARCHAR2 | 64 | Read-only field that indicates the current status of the Revenue Plan. | DW_NS_revenuePlanStatus_D | key | ||
| parentlinecurrency | NUMBER | 38 | 0 | This is the currency from the source customer obligation document. | DW_NS_currency_D | id | |
| revenueplancurrency | NUMBER | 38 | 0 | This is the base currency for the accounting book and subsidiary. | DW_NS_currency_D | id | |
| accountingbook_exchangerate | NUMBER | Exchange rate between accounting book currency and transaction currency. | |||||
| accountingbook_amount | NUMBER | Transaction amount in accounting book currency. | |||||
| accountingbook_remainingdeferredbalance | NUMBER | Remaining Amount yet to be recognized in a Revenue Plan in accounting book currency. | |||||
| accountingbook_totalrecognized | NUMBER | The total revenue that has been recognized on the revenue plan in accounting book currency. | |||||
| amount | NUMBER | Amount in transaction currency. | |||||
| totalrecognized | NUMBER | The total revenue that has been recognized on the revenue plan in source transaction currency. | |||||
| remainingdeferredbalance | NUMBER | The total revenue that has been recognized on the revenue plan in source transaction currency. |