Financial Orchestration Flows

The Financial Orchestration Flows view object stores all the nontranslatable and translatable attributes of the financial trade agreement definition.

Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosAgreementDefinitionExtractPVO

Primary Keys : AgreementDefinitionBPEOAgreementId, AgreementDefinitionBPEOEffectiveEndDate, AgreementDefinitionBPEOEffectiveStartDate

Initial Extract Date : AgreementDefinitionBPEOCreationDate

Incremental Extract Date : AgreementDefinitionBPEOLastUpdateDate

Attributes

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

Name Description
AgreementDefinitionBPEOAgreementId Value that uniquely identifies the Financial Orchestration Flow. This is the primary key of the Financial Orchestration Flows view object.
AgreementDefinitionBPEOAgreementNumber Value that uniquely identifies the agreement.
AgreementDefinitionBPEOAgreementType Value that indicates the type of agreement. Valid values are contained within the FOS_AGREEMENT_TYPES lookup.
AgreementDefinitionBPEOAttributeCategory Value that indicates the structure definition of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar1 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar10 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar11 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar12 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar13 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar14 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar15 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar2 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar3 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar4 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar5 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar6 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar7 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar8 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeChar9 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeDate1 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeDate2 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeDate3 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeNumber1 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeNumber2 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeNumber3 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeNumber4 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeNumber5 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeTimestamp1 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeTimestamp2 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAttributeTimestamp3 Segment of the user descriptive flexfield.
AgreementDefinitionBPEOAutoActiveFlag Value that's used to determine whether the agreement should become active automatically.
AgreementDefinitionBPEOCreatedBy User who created the financial orchestration flow.
AgreementDefinitionBPEOCreationDate Date when the financial orchestration flow was created.
AgreementDefinitionBPEODsFwdOwnsChangeEventId Value that uniquely identifies the event that triggers the ownership change from the supplier to the purchasing entity in a drop ship scenario.
AgreementDefinitionBPEOEffectiveEndDate Value that identifies the date at the end of the date range within which the row is effective.
AgreementDefinitionBPEOEffectiveStartDate Value that identifies the date at the beginning of the date range within which the row is effective.
AgreementDefinitionBPEOEnterpriseId Value that identifies the enterprise that's used for multiple tenancy partitioning.
AgreementDefinitionBPEOFromEntityBasis Value that identifies the type of starting point for the agreement.
AgreementDefinitionBPEOFromEntityOperator Value that identifies the logical operator to be used for the from entity.
AgreementDefinitionBPEOFromEntityValue Value that identifies the actual value for the starting point of the agreement.
AgreementDefinitionBPEOFwdCstOwnsChangeEventId Value that uniquely identifies the event that triggers the ownership change from the original equipment manufacturer to the customer in a shipment scenario.
AgreementDefinitionBPEOFwdSplrOwnsChangeEventId Value that uniquely identifies the event that triggers the ownership change from the supplier to the original equipment manufacturer in a global procurement scenario.
AgreementDefinitionBPEOLastUpdateDate Date when the financial orchestration flow was last updated.
AgreementDefinitionBPEOLastUpdateLogin Session login associated with the user who last updated the financial orchestration flow.
AgreementDefinitionBPEOLastUpdatedBy User who last updated the financial orchestration flow.
AgreementDefinitionBPEOMultiFtrFlag Value that indicates if multiple financial trade relationships can exist for a single primary trade relationship.
AgreementDefinitionBPEOObjectVersionNumber Value that identifies the number of times the financial orchestration flow row has been updated.
AgreementDefinitionBPEOPriority Value that identifies the priority of the agreement for a given agreement type.
AgreementDefinitionBPEOQualifierRuleSetId Value that's a foreign key to the Qualifier Rule Set view object.
AgreementDefinitionBPEORtnCstOwnsChangeEventId Value that uniquely identifies the event that triggers the ownership change from the customer to the original equipment manufacturer in a shipment scenario.
AgreementDefinitionBPEORtnSplrOwnsChangeEventId Value that uniquely identifies the event that triggers the ownership change from the original equipment manufacturer to a supplier in a global procurement scenario.
AgreementDefinitionBPEOSeedDataSource Value that identifies the source of the seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
AgreementDefinitionBPEOStatus Value that identifies the current status of the agreement. Valid values are contained within the FOS_AGREEMENT_STATUS lookup.
AgreementDefinitionBPEOToEntityBasis Value that identifies the type of the ending point for the agreement.
AgreementDefinitionBPEOToEntityOperator Value that identifies the logical operator to be used for the to entity.
AgreementDefinitionBPEOToEntityValue Value that describes the actual value of the starting point for the agreement.
AgreementDefinitionTLPEOAgreementId Value that uniquely identifies the financial orchestration flow translation. This is the primary key of the Financial Orchestration Flows Translation view object.
AgreementDefinitionTLPEOCreatedBy User who created the financial orchestration flow translation.
AgreementDefinitionTLPEOCreationDate Date when the financial orchestration flow translation was created.
AgreementDefinitionTLPEODescription Value that identifies the translatable description of the agreement.
AgreementDefinitionTLPEOEffectiveEndDate Value that identifies the date at the end of the date range within which the row is effective.
AgreementDefinitionTLPEOEffectiveStartDate Value that identifies the date at the beginning of the date range within which the row is effective.
AgreementDefinitionTLPEOEnterpriseId Value that identifies the enterprise.
AgreementDefinitionTLPEOLanguage Value that identifies the code of the language into which the contents of the translatable columns are translated.
AgreementDefinitionTLPEOLastUpdateDate Date when the financial orchestration flow translation was last updated.
AgreementDefinitionTLPEOLastUpdateLogin Session login associated with the user who last updated the financial orchestration flow translation.
AgreementDefinitionTLPEOLastUpdatedBy User who last updated the financial orchestration flow translation.
AgreementDefinitionTLPEOObjectVersionNumber Value that identifies the number of times the financial orchestration flow translation row has been updated.
AgreementDefinitionTLPEOSeedDataSource Value that identifies the source of the seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that the record was bulk loaded. Otherwise, it specifies the name of the seed data file.
AgreementDefinitionTLPEOSourceLang Value that identifies the language in which the contents of the translatable columns were originally created.