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