Primary Routes

The Primary Routes view object stores the information related to the primary trade relationships defined for financial trade agreements.

Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosPrimaryTradeRelationExtractPVO

Primary Keys : PrimaryTradeRelationPEOAgreementPtrId, PrimaryTradeRelationPEOEffectiveEndDate, PrimaryTradeRelationPEOEffectiveStartDate

Initial Extract Date : PrimaryTradeRelationPEOCreationDate

Incremental Extract Date : PrimaryTradeRelationPEOLastUpdateDate

Attributes

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

Name Description
PrimaryTradeRelationPEOAgreementId Value that identifies the parent agreement to which this primary trade relationship belongs.
PrimaryTradeRelationPEOAgreementPtrId Value that uniquely identifies the primary route. This is the primary key of the Primary Routes view object.
PrimaryTradeRelationPEOAttributeCategory Context definition of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar1 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar10 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar11 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar12 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar13 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar14 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar15 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar2 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar3 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar4 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar5 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar6 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar7 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar8 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeChar9 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeDate1 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeDate2 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeDate3 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeNumber1 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeNumber2 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeNumber3 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeNumber4 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeNumber5 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeTimestamp1 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeTimestamp2 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOAttributeTimestamp3 Segment of the user descriptive flexfield.
PrimaryTradeRelationPEOCreatedBy User who created the primary route.
PrimaryTradeRelationPEOCreationDate Date when the primary route was created.
PrimaryTradeRelationPEOEffectiveEndDate Date at the end of the date range within which the row is effective.
PrimaryTradeRelationPEOEffectiveStartDate Date at the beginning of the date range within which the row is effective.
PrimaryTradeRelationPEOEnterpriseId Value that identifies the enterprise that's used for multiple tenancy partitioning.
PrimaryTradeRelationPEOFromBuId Value that uniquely identifies the starting business unit.
PrimaryTradeRelationPEOFromLeId Value that uniquely identifies the starting legal entity.
PrimaryTradeRelationPEOFromTradeOrganizationId Value that uniquely identifies the starting trade organization.
PrimaryTradeRelationPEOLastUpdateDate Date when the primary route was last updated.
PrimaryTradeRelationPEOLastUpdateLogin Session login associated with the user who last updated the primary route.
PrimaryTradeRelationPEOLastUpdatedBy User who last updated the primary route.
PrimaryTradeRelationPEOObjectVersionNumber Value that identifies the number of times the primary route row has been updated.
PrimaryTradeRelationPEOPtrNumber Value that uniquely identifies the primary trade relationship line which will be displayed to the user.
PrimaryTradeRelationPEOToBuId Value that uniquely identifies the destination business unit.
PrimaryTradeRelationPEOToLeId Value that uniquely identifies the destination legal entity.
PrimaryTradeRelationPEOToTradeOrganizationId Value that uniquely identifies the destination trade organization.