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.    

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