DW_AR_SCHEDULING_RULE_D

This table contains the details of the AR scheduling rules.

Details

Module: Receivables

Key Columns

SCHEDULING_RULE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SCHEDULING_RULE_ID NUMBER 38 0 True Scheduling Rule Id
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier for scheduling rules
SCHEDULING_RULE_NAME VARCHAR2 32 Scheduling Rule Name
RULE_DESCRIPTION VARCHAR2 128 Scheduling Rule Description
SETID NUMBER 38 0 Identifies a set of reference data shared across business units and other entities
RULE_STATUS VARCHAR2 16 Scheduling Rule Status. Values are from the table DW_AR_SCH_RULE_STATUS_LKP_TL with CODE_TYPE=SCHEDULING_RULE_STATUS DW_AR_SCH_RULE_STATUS_LKP_TL AR_SCH_RULE_STATUS_LKP_CODE
RULE_TYPE VARCHAR2 16 Scheduling Rule Type.Values are from the table DW_AR_SCH_RULE_TYPE_LKP_TL with CODE_TYPE=SCHEDULING_RULE_TYPE DW_AR_SCH_RULE_TYPE_LKP_TL AR_SCH_RULE_TYPE_LKP_CODE
OCCURRENCES NUMBER Number of accounting dates to recognize revenue