# 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. |  |
amountsource | VARCHAR2 | 64 |  |  |  | DW_NS_revRecAmountSourceType_D | key
enddatechangeimpact | VARCHAR2 | 64 |  |  |  | DW_NS_revRecChangeImpactType_D | key
inactive | VARCHAR2 | 16 |  |  |  |  |
initialamount | NUMBER |  |  |  |  |  |
name | VARCHAR2 | 256 |  |  |  |  |
periodoffset | NUMBER |  |  |  |  |  |
recalcadjustperiodoffset | NUMBER |  |  |  |  |  |
recognitionmethod | VARCHAR2 | 64 |  |  |  | DW_NS_revRecRecurrenceType_D | key
recognitionperiod | NUMBER |  |  |  |  |  |
reforecastmethod | VARCHAR2 | 64 |  |  |  | DW_NS_reforecastMethod_D | key
revrecenddatesource | VARCHAR2 | 64 |  |  |  | DW_NS_revRecDateSourceType_D | key
revrecstartdatesource | VARCHAR2 | 64 |  |  |  | DW_NS_revRecDateSourceType_D | key
startoffset | NUMBER |  |  |  |  |  |
termindays | NUMBER |  |  |  |  |  |
terminmonths | NUMBER |  |  |  |  |  |

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