This reference base table stores the definition of Hold Codes.
Module: Order Management
HOLD_CODE_ID
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.