# DW_AP_HOLD_RELEASE_REASON_D

This table contains the hold and release reasons for Payables invoices.

## Details

Module: Payables

## Key Columns

HOLD_OR_RELEASE_CODE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
HOLD_OR_RELEASE_CODE | VARCHAR2 | 32 |  | True | Hold or release code name. | DW_AP_HOLD_LKP_TL | AP_HOLD_LKP_CODE
SOURCE_RECORD_ID | VARCHAR2 | 32 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
HOLD_OR_RELEASE_TYPE | VARCHAR2 | 32 |  |  | Hold or release type. | DW_AP_HOLD_TYPE_LKP_TL | AP_HOLD_TYPE_LKP_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_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_CODE
POSTABLE_FLAG | VARCHAR2 | 16 |  |  | Indicates whether this hold should prevent the invoice from being accounted. Values are from the DW_YESNONEVER_LKP_TL with CODE_TYPE=YES_NO_NEVER. | DW_YESNONEVER_LKP_TL | YESNONEVER_LKP_CODE
USER_RELEASEABLE_FLAG | VARCHAR2 | 16 |  |  | Indicates if hold can be released by user. Values are from the DW_YESNONEVER_LKP_TL with CODE_TYPE=YES_NO_NEVER. | DW_YESNONEVER_LKP_TL | YESNONEVER_LKP_CODE

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