Flow Instances

The Flow Instances view object stores task information which includes the status of the task, the initiating event for which this task is waiting, and the target document number and corresponding agreement task information. One row of this Flow Instances view object will exactly map to one target document creation task.

Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosFlowInstanceExtractPVO

Primary Keys : FlowInstancePEOFlowInstanceId

Initial Extract Date : FlowInstancePEOCreationDate

Incremental Extract Date : FlowInstancePEOLastUpdateDate

Attributes

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

Name	Description
FlowInstancePEOAgreementFtrId	Value that uniquely identifies the financial route of financial orchestration flow. This is a foreign key to the Financial Routes view object.
FlowInstancePEOAgreementPtrId	Value that uniquely identifies the primary route of financial orchestration flow. This is a foreign key to the Primary Routes view object.
FlowInstancePEOCreatedBy	User who created the flow instance.
FlowInstancePEOCreationDate	Date when the flow instance was created.
FlowInstancePEODocumentFlowAssignmentId	Value that identifies the foreign key to the Document Flow Assignments view object.
FlowInstancePEOEnterpriseId	Value that identifies the enterprise that's being used for multiple tenancy partitioning.
FlowInstancePEOEventDataId	Value that identifies the event document that initiated the task.
FlowInstancePEOEventDefinitionId	Value that identifies the foreign key to the Event Definitions view object.
FlowInstancePEOFlowInstanceId	Value that uniquely identifies the flow Instances. This is the primary key of the Flow Instances view object.
FlowInstancePEOFlowType	Value that identifies the type of flow. Valid values are contained within the FOS_FLOW_TYPE_FOR_TASK lookup type.
FlowInstancePEOGroupId	Value that identifies the identifier for a group of tasks that needs to be processed together during task reprocessing.
FlowInstancePEOImportDate	Date when the interface record was populated into the transaction table.
FlowInstancePEOJobDefinitionName	Value that identifies the name of the job that created or last updated the row.
FlowInstancePEOJobDefinitionPackage	Value that identifies the package name of the job that created or last updated the row.
FlowInstancePEOLastUpdateDate	Date when the flow instance was last updated.
FlowInstancePEOLastUpdateLogin	Session login associated with the user who last updated the flow instance.
FlowInstancePEOLastUpdatedBy	User who last updated the flow instance.
FlowInstancePEOObjectVersionNumber	Value that identifies the number of times the flow instances row has been updated.
FlowInstancePEOProcessBatchId	Value that uniquely identifies the batch identifier used to represent a group of orchestration tasks that have been submitted for processing.
FlowInstancePEORequestId	Value that identifies the request ID of the job that created or last updated the row.
FlowInstancePEOStatus	Value that identifies the status indicating the state of the task. Valid values are contained within the FOS_TASK_STATUS lookup type.
FlowInstancePEOSystemId	Value that identifies the source system of the event that triggers this task.
FlowInstancePEOTaDocumentId	Value that identifies the document that's created as part of orchestration of this flow instance.
FlowInstancePEOTargetDocumentDetail	Value that identifies the line detail information of the target document that was created by this task.
FlowInstancePEOTargetDocumentDetailId	Value that identifies the detail identifier of the target document created by this task.
FlowInstancePEOTargetDocumentHeader	Value that identifies the header number of the target document that was created by this task.
FlowInstancePEOTargetDocumentHeaderId	Value that identifies the header ID of the target document that was created by this task.
FlowInstancePEOTargetDocumentLine	Value that identifies the line number of the target document that was created by this task.
FlowInstancePEOTargetDocumentLineId	Value that identifies the line ID of the target document that was created by this task.
FlowInstancePEOTargetSystemId	Value that identifies the target system where this document was created.
FlowInstancePEOTaskGroup	Value that identifies the mediator which logically groups the tasks.
FlowInstancePEOTaskSequence	Value that identifies the mediator for which the sequences will be generated for each group.
FlowInstancePEOTaskType	Value that identifies the task type. Task types are defined in the Task Types view object.
FlowInstancePEOTaxCalculationStatus	Value that identifies the tax calculation status for the Financial Orchestration task. Valid values are NEEDED, NOT_NEEDED, CALCULATED, and ERROR.
FlowInstancePEOTransactionType	Value that identifies the transaction type of the task type.