DW_OM_HOLD_CODES_D

This reference base table stores the definition of Hold Codes.

Details

Module: Order Management

Key Columns

HOLD_CODE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
HOLD_CODE_ID NUMBER 38 0 True Unique identifier of the hold code.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System Generated
HOLD_CODE VARCHAR2 32 Identifier for the hold.
EFFECTIVE_START_DATE DATE Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
GENERAL_HOLD_FLAG VARCHAR2 16 Indicates that a specific hold code prevents all services from being performed.
SYSTEM_FLAG VARCHAR2 16 System seeded holds that cannot be updated or deleted.