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.