Purchasing Document Action History Details
The Purchasing Document Action History Details view object contains action history of the purchasing document.
Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentActionHistoryExtractPVO
Primary Keys : ActionCode, ObjectId, ObjectTypeCode, SequenceNum, ObjectSubTypeCode
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
ActionCode | Code that identifies the approval or control action type. |
ActionDate | Approval or control action date. |
AssignmentDate | Date and time when the document was assigned to a user for action. |
CorrelationId | Value that uniquely identifies the correlation. |
CreatedBy | User who created the purchasing document action history details. |
CreationDate | Date and time when the purchasing document action history details was created. |
IdentificationKey | Identification Key for approval actions from AMX. |
LastUpdateDate | Date when the purchasing document action history details was last updated. |
LastUpdateLogin | Session login associated with the user who last updated the purchasing document action history details. |
LastUpdatedBy | User who last updated the purchasing document action history details. |
Note | Note for next approver or reason for control action. |
ObjectId | Value that uniquely identifies the purchasing document action history details. |
ObjectRevisionNum | Document revision number. |
ObjectSubTypeCode | Code that identifies the document subtype associated with a purchasing transaction. |
ObjectTypeCode | Code that identifies the document type associated with a purchasing transaction. |
ObjectVersionNumber | Number of times the purchasing document action history details has been updated. |
OfflineCode | Code that indicates whether or not the document was sent to an offline approver. |
PerformerId | Value that uniquely identifies the person taking action. The types of IDs depend on ROLE_CODE column. If ROLE_CODE is SUPPLIER, this ID is person PARTY_ID for supplier contact. Otherwise, the ID is PERSON_ID for the internal person that's an employee. |
PoVersionId | Value that uniquely identifies the PO version. |
RoleCode | Code that identifies the role of the action performer. Possible values are: BUYER, REQUESTER, APPROVER, CAT_ADMIN, and SUPPLIER. |
SequenceNum | Sequence of the approval or control action for a document. |
SupplierAccessibleFlag | Contains one of the following values: true or false. If true, then this action is accessible to the supplier. If false, then this action isn't accessible to the supplier. The default value is false. |