Invoice Holds
The invoice holds view object contains information about holds that you or Oracle Payables application places on a supplier invoice. It contains attributes such as hold reason, release reason, line held, hold resolution workflow status and so on.
Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceHoldExtractPVO
Primary Keys : ApHoldsAllHoldId
Initial Extract Date : ApHoldsAllCreationDate
Incremental Extract Date : ApHoldsAllLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ApHoldsAllAttribute1 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute10 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute11 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute12 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute13 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute14 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute15 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute2 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute3 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute4 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute5 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute6 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute7 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute8 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttribute9 | A segment for the Invoice Holds descriptive flexfield. |
| ApHoldsAllAttributeCategory | The descriptive flexfield context name for the Invoice Holds descriptive flexfield. |
| ApHoldsAllConsumptionAdviceLineId | The identifier of the consumption advice line that the hold is associated with. |
| ApHoldsAllCreatedBy | The user who created the invoice hold. |
| ApHoldsAllCreationDate | The date and time when the invoice hold was created. |
| ApHoldsAllHeldBy | The user that placed the hold on the invoice. |
| ApHoldsAllHoldDate | The date when the user placed the hold on the invoice. |
| ApHoldsAllHoldDetails | The details of the hold placed on the invoice. |
| ApHoldsAllHoldId | The unique identifier of the hold placed on the invoice. This is the primary key of the Invoice Holds view object. |
| ApHoldsAllHoldLookupCode | The name of the hold that is applied on the invoice. A list of accepted values is defined in the lookup type HOLD TYPE. |
| ApHoldsAllHoldReason | The reason for the hold being placed on the invoice. |
| ApHoldsAllInvoiceId | The unique identifier of the invoice against which the hold is placed. This is a foreign key of the Invoices view object. |
| ApHoldsAllLastUpdateDate | The date when the invoice hold was last updated. |
| ApHoldsAllLastUpdateLogin | The session login associated with the user who last updated the invoice hold. |
| ApHoldsAllLastUpdatedBy | The user who last updated the invoice hold. |
| ApHoldsAllLineLocationId | The unique identifier of the purchase order line location. |
| ApHoldsAllLineNumber | The line number of the invoice line against which the hold is applied. |
| ApHoldsAllObjectVersionNumber | The number of times the invoice hold row has been updated. |
| ApHoldsAllOrgId | The unique identifier of the business unit associated with the invoice. |
| ApHoldsAllRcvTransactionId | The unique identifier of the receipt that this hold is associated with. |
| ApHoldsAllReleaseLookupCode | The release name that released the hold on the invoice. A list of accepted values is defined in the lookup type HOLD TYPE. |
| ApHoldsAllReleaseReason | The reason for the release being placed on invoice. |
| ApHoldsAllResponsibilityId | The identifier of the responsibility associated with the Insufficient Funds hold. |
| ApHoldsAllStatusFlag | Indicates the status of the invoice hold. Possible values are null, R and S. A value of R indicates a system hold that has been released. A value of S indicates a system hold that has not been released. Null value indicates a user placed hold. |
| ApHoldsAllWfStatus | The holds resolution workflow status for the invoice hold. A list of possible values is defined in the lookup type HOLD_WORKFLOW_STATUS. |