# 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

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 |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.