# 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, 2025, Oracle and/or its affiliates.