DW_NS_RevenueRecognitionRule_D
This table contains information about Revenue Recognition Rule. It stores details about recognition method, the trigger for revenue plan start and end dates, the source of the revenue plan amount.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. This is source record id column. | ||||
| amountsource | VARCHAR2 | 64 | Amount Source | DW_NS_revRecAmountSourceType_D | key | ||
| enddatechangeimpact | VARCHAR2 | 64 | End Date Change Impact | DW_NS_revRecChangeImpactType_D | key | ||
| inactive | VARCHAR2 | 16 | Is Inactive | ||||
| initialamount | NUMBER | Initial Amount | |||||
| name | VARCHAR2 | 256 | Name | ||||
| periodoffset | NUMBER | Period Offset | |||||
| recalcadjustperiodoffset | NUMBER | Recalculation Adjustment Period Offset | |||||
| recognitionmethod | VARCHAR2 | 64 | Recognition Method | DW_NS_revRecRecurrenceType_D | key | ||
| recognitionperiod | NUMBER | Recognition Period | |||||
| reforecastmethod | VARCHAR2 | 64 | Reforecast Method | DW_NS_reforecastMethod_D | key | ||
| revrecenddatesource | VARCHAR2 | 64 | Revenue Recognition End Date Source | DW_NS_revRecDateSourceType_D | key | ||
| revrecstartdatesource | VARCHAR2 | 64 | Revenue Recognition Start Date Source | DW_NS_revRecDateSourceType_D | key | ||
| startoffset | NUMBER | Start Offset | |||||
| termindays | NUMBER | Revenue Term In Days | |||||
| terminmonths | NUMBER | Revenue Term In Months |