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