Document Flow Assignments

The Document Flow Assignments view object stores the mapping between the source document and the corresponding agreement to that document. Logically, one row will correspond to one financial flow within Supply Chain Financial Orchestration.

Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosFlowAssignmentExtractPVO

Primary Keys : FlowAssignmentPEODocumentFlowAssignmentId

Initial Extract Date : FlowAssignmentPEOCreationDate

Incremental Extract Date : FlowAssignmentPEOLastUpdateDate

Attributes

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

Name	Description
FlowAssignmentPEOActivationDate	Date on which the flow became active.
FlowAssignmentPEOAgreementPtrId	Value that uniquely identifies the primary route of financial orchestration flow. This is a foreign key to the Primary Routes view object.
FlowAssignmentPEOAgreementType	Value that represents the type of the agreement. Valid values are contained within the ORA_FOS_AGREEMENT_TYPE_FOR_VAL lookup type.
FlowAssignmentPEOCreatedBy	User who created the document flow assignment.
FlowAssignmentPEOCreationDate	Date when the document flow assignment was created.
FlowAssignmentPEODocumentFlowAssignmentId	Value that uniquely identifies the Document Flow Assignment. This is the primary key of the Document Flow Assignment view object.
FlowAssignmentPEODocumentType	Value that identifies the type of document to which this event belongs. Valid values are contained within the FOS_IMT_DOCUMENT_TYPES, FOS_PROCUREMENT_DOCUMENT_TYPES, and FOS_SHIPMENT_DOCUMENT_TYPES lookup types.
FlowAssignmentPEODropShipFlag	Value that indicates whether the flow is a drop ship flow.
FlowAssignmentPEOEffectiveDocumentDate	Value that identifies the source document date that was used to retrieve all agreement related entities that were effective on this date.
FlowAssignmentPEOEnterpriseId	Value that identifies the enterprise that's being used for multiple tenancy partitioning.
FlowAssignmentPEOLastUpdateDate	Date when the document flow assignment was last updated.
FlowAssignmentPEOLastUpdateLogin	Session login associated with the user who last updated the document flow assignment.
FlowAssignmentPEOLastUpdatedBy	User who last updated the document flow assignment.
FlowAssignmentPEOLinkToDocumentId	Value that identifies the drop ship flow, this column will contain the second source document ID.
FlowAssignmentPEOObjectVersionNumber	Value that identifies the number of times the document flow assignment row has been updated.
FlowAssignmentPEOSourceDocumentId	Value that identifies the source document created for the physical flow.
FlowAssignmentPEOStatus	Value that indicates whether the flow is ready for processing. Valid values are contained within the FOS_FLOW_HEADER_STATUS lookup type.
FlowAssignmentPEOSystemId	Value identifies the source system.