This table contains the hold and release reasons for Payables invoices.
Module: Payables
HOLD_OR_RELEASE_CODE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
HOLD_OR_RELEASE_CODE | VARCHAR2 | 32 | True | Hold or release code name. | DW_CODE_VALUES_LKP_TL | CODE | |
SOURCE_RECORD_ID | VARCHAR2 | 32 | Source record identifier. | ||||
HOLD_OR_RELEASE_TYPE | VARCHAR2 | 32 | Hold or release type. | DW_CODE_VALUES_LKP_TL | CODE | ||
TYPE_FLAG | VARCHAR2 | 16 | Identifies type as hold or release. Possible values are H or R. | ||||
ACTIVE_FLAG | VARCHAR2 | 16 | Indicates that the hold is active. Values are from the DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | CODE | ||
POSTABLE_FLAG | VARCHAR2 | 16 | Indicates whether this hold should prevent the invoice from being accounted. Values are from the DW_CODE_VALUES_LKP_TL with CODE_TYPE=YES_NO_NEVER. | DW_CODE_VALUES_LKP_TL | CODE | ||
USER_RELEASEABLE_FLAG | VARCHAR2 | 16 | Indicates if hold can be released by user. Values are from the DW_CODE_VALUES_LKP_TL with CODE_TYPE=YES_NO_NEVER. | DW_CODE_VALUES_LKP_TL | CODE |
Copyright © 2019, 2023, Oracle and/or its affiliates.