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