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
| 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 |