Invoice Approval History

The Invoice Approval History view object contains the approval and rejection history of each payables invoice that passes through the Invoice Approval Workflow process.

Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceApprovalHistoryExtractPVO

Primary Keys : ApInvAprvlHistAllApprovalHistoryId

Initial Extract Date : ApInvAprvlHistAllCreationDate

Incremental Extract Date : ApInvAprvlHistAllLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ApInvAprvlHistAllAmountApproved	The invoice amount at time of approver response.
ApInvAprvlHistAllApprovalHistoryId	The unique identifier for every record created for the invoice during the approval cycle. This is a primary key of the Invoice Approval History view object.
ApInvAprvlHistAllApproverComments	The comments provided by the approver on a given invoice.
ApInvAprvlHistAllApproverId	The login user name of the approver for a given invoice.
ApInvAprvlHistAllCreatedBy	The user who created the approval history row.
ApInvAprvlHistAllCreationDate	The date and time when the approval history row was created.
ApInvAprvlHistAllHistoryType	The approval type required on the invoice.
ApInvAprvlHistAllHoldId	The identifier of the hold applied on the invoice.
ApInvAprvlHistAllInvoiceId	The unique identifier of the invoice that is undergoing the approval cycle.
ApInvAprvlHistAllIteration	The count of times the invoice has passed through the Invoice Approval Workflow process.
ApInvAprvlHistAllLastUpdateDate	The date when the approval history row was last updated.
ApInvAprvlHistAllLastUpdateLogin	The session login associated with the user who last updated the approval history row.
ApInvAprvlHistAllLastUpdatedBy	The user who last updated the approval history row.
ApInvAprvlHistAllLineNumber	The unique number for the invoice line.
ApInvAprvlHistAllNotificationOrder	The order in which the notifications for the invoice were sent to the approvers.
ApInvAprvlHistAllObjectVersionNumber	The number of times the approval history row has been updated.
ApInvAprvlHistAllOrgId	The identifier of the business unit associated with the invoice.
ApInvAprvlHistAllOrigSystem	Indicates the approval status of the invoice.
ApInvAprvlHistAllResponse	The response of the approver on a given invoice.
ApInvAprvlHistAllUpperApproverId	The login user name of the approver for a given invoice expressed in uppercase.