Sourcing Objective Negotiation Details

The Sourcing Objective Negotiation view object contains details about the sourcing objective negotiation program

Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.SourcingObjectiveNegotiationPVO

Primary Keys : ObjectiveNegotiationPEOObjectiveNegotiationId, ProgramHeaderPEOProgramHeaderId, ProgramObjectivePEOObjectiveHeaderId

Initial Extract Date : ObjectiveNegotiationPEOCreationDate

Incremental Extract Date : ObjectiveNegotiationPEOLastUpdateDate

Attributes

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

Name	Description
NegHeaderPersonNamePEODisplayName	Display name of the person in the program.
NegHeaderPersonNamePEOEffectiveEndDate	Date when the program ends.
NegHeaderPersonNamePEOEffectiveStartDate	Date when the program starts.
NegHeaderPersonNamePEOFullName	Full name of the person in the program.
NegHeaderPersonNamePEOListName	List name of the person in the program.
NegHeaderPersonNamePEOObjectVersionNumber	Number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
NegHeaderPersonNamePEOPersonId	Value that uniquely identifies the person in the program.
NegHeaderPersonNamePEOPersonNameId	Value that uniquely identifies the name of the person in the program.
NegotiationAggToObjPEOAwardAmountByObj	Award amount identified in the objective.
NegotiationAggToObjPEOObjectiveHeaderId	Value that uniquely identifies the objective header in the program.
NegotiationAggToObjPEOPlannedCurrentSpendByObj	Sum of the current Amount of all award completed negotiations within the objective.
NegotiationAggToObjPEOPlannedSavingGoalsByObj	Planned Savings Goal of all award completed negotiations within the objective.
NegotiationAggToObjPEOPlannedTargetSpendByObj	Planned Target Spend of all award completed negotiation within the objective.
NegotiationAggToObjPEOProgramHeaderId	Unique identifier for the program header in the program.
NegotiationAggToProgPEOAwardAmountByProg	Award amount identified in the program.
NegotiationAggToProgPEOPlannedCurrentSpendByProg	Sum of all the negotiation current amounts of objectives.
NegotiationAggToProgPEOPlannedSavingGoalsByProg	Sum of negotiation Savings Goal for all objectives.
NegotiationAggToProgPEOPlannedTargetSpendByProg	Sum of Negotiation Target Spend for all the objectives.
NegotiationAggToProgPEOProgramHeaderId	Value that uniquely identifies the program header in the program.
NegotiationHeaderPEOAuctionHeaderId	Auction Header ID which is being generated by the application.
NegotiationHeaderPEOAuctionStatus	Indicates status of the auction.
NegotiationHeaderPEOAuctionTitle	Indicates auction title.
NegotiationHeaderPEOAwardCompleteDate	Date the negotiation award process was completed.
NegotiationHeaderPEOAwardDate	Date the latest Award was saved.
NegotiationHeaderPEOAwardStatus	Identifier that indicates award status of auction.
NegotiationHeaderPEOCancelDate	Date that indicates when the auction was canceled.
NegotiationHeaderPEOCreatedBy	Indicates the user who created the row.
NegotiationHeaderPEOCreationDate	Indicates the date and time of the creation of the row.
NegotiationHeaderPEOCurrencyCode	Base currency code in which the auction will be conducted.
NegotiationHeaderPEODescription	Template description.
NegotiationHeaderPEODoctypeId	Identifier for document type associated with this auction.
NegotiationHeaderPEODocumentNumber	Indicates negotiation number.
NegotiationHeaderPEOLastUpdateDate	Indicates the date and time of the last update of the row.
NegotiationHeaderPEOLastUpdatedBy	Indicates the session login associated to the user who last updated the row.
NegotiationHeaderPEONegApprovalStatus	Indicates approval status of the negotiation.
NegotiationHeaderPEOObjectVersionNumber	Unique identifier to implement optimistic locking. This number is incremented every time that the row is updated.
NegotiationHeaderPEOPersonId	Indicates ID of the auction creator.
NegotiationHeaderPEOPrcBuId	Unique identifier for a procurement business unit
NegotiationHeaderPEOSealedAuctionStatus	Status of sealed auction.
NegotiationHeaderPEOStyleId	ID that uniquely identifies negotiation style.
NegotiationStatus	Current status of the negotiation.
NegotiationStatusDisplayName	Display name of the negotiation.
ObjBaseTargetSpendNotAllocatedToNeg	Value that indicates if the target spend amount has not been allocated to the negotiation.
ObjectiveAggToProgPEOObjBsCurrentSpendByProg	Sum of all the negotiation current amounts of objectives.
ObjectiveAggToProgPEOObjBsSavingsGoalByProg	Sum of negotiation Savings Goal for all objectives.
ObjectiveAggToProgPEOObjBsTargetSpendByProg	Sum of Negotiation Target Spend for all the objectives.
ObjectiveAggToProgPEOProgramHeaderId	Value that uniquely identifies the program.
ObjectiveBrowseCategoryPEOCategoryDescription	Description of the category of the objective.
ObjectiveBrowseCategoryPEOCategoryId	Browsing category or an item category from the procurement category hierarchy that the program is associated with.
ObjectiveBrowseCategoryPEOCategoryName	Name of the program category.
ObjectiveBrowseCategoryPEOCreatedBy	User who created the objective row.
ObjectiveBrowseCategoryPEOCreationDate	Date and time when the objective row was created.
ObjectiveBrowseCategoryPEOImageUrl	Uniform Resource Locator of the image used in the program.
ObjectiveBrowseCategoryPEOLastUpdateDate	Date and time when the objective row was last updated.
ObjectiveBrowseCategoryPEOLastUpdateLogin	Session login associated with the user who last updated the objective row.
ObjectiveBrowseCategoryPEOLastUpdatedBy	User who last updated the objective row.
ObjectiveBrowseCategoryPEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ObjectiveBrowseCategoryPEOType	Type of browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryName	Name of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryCode	Code of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryContentCode	Content code of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryName	Name of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEODescription	Description of the objective category.
ObjectiveCategoryPEOEnabledFlag	Value that indicates whether the public entity object is enabled for the current program objective category.
ObjectiveCategoryPEOEndDateActive	Date when the objective category ends.
ObjectiveCategoryPEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ObjectiveCategoryPEOStartDateActive	Date when the objective category starts.
ObjectiveCategoryPEOSummaryFlag	Summary of the sourcing objective category.
ObjectiveCategoryPEOSupplierEnabledFlag	Value that indicates if the supplier has been enabled in the objective category.
ObjectiveCategoryPEOWebStatus	Web status of the objective category.
ObjectiveNegotiationPEOAuctionHeaderId	Value that uniquely identifies the negotiation.
ObjectiveNegotiationPEOAwardAmount	Actual award amount for the completed negotiation.
ObjectiveNegotiationPEOAwardAmountDisplay	Actual award amount displayed for the completed negotiation.
ObjectiveNegotiationPEOCreatedBy	User who created the negotiation objective row.
ObjectiveNegotiationPEOCreationDate	Date and time the negotiation objective row was created.
ObjectiveNegotiationPEOLastUpdateDate	Date and time the negotiation objective row was last updated.
ObjectiveNegotiationPEOLastUpdateLogin	Session login associated with the user who last updated the negotiation objective row.
ObjectiveNegotiationPEOLastUpdatedBy	User who last updated the negotiation objective row.
ObjectiveNegotiationPEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ObjectiveNegotiationPEOObjectiveHeaderId	Value that uniquely identifies the objective.
ObjectiveNegotiationPEOObjectiveNegotiationId	Value that uniquely identifies the objective negotiation mapping.
ObjectiveNegotiationPEOOverrideFlag	Value that indicates if the planned values are overridden manually.
ObjectiveNegotiationPEOPlannedCurrentSpend	Sum of all the negotiation current amounts.
ObjectiveNegotiationPEOPlannedCurrentSpendDisplay	Sum of all the negotiation current amounts displayed.
ObjectiveNegotiationPEOPlannedSavings	Planned current spend and planned target spend.
ObjectiveNegotiationPEOPlannedSavingsDisplay	Planned current spend and planned target spend displayed.
ObjectiveNegotiationPEOPlannedSavingsPercent	Ratio of Negotiated Savings and Negotiation Current Spend.
ObjectiveNegotiationPEOPlannedTargetSpend	Sum of all the negotiation target amounts.
ObjectiveNegotiationPEOPlannedTargetSpendDisplay	Sum of all the negotiation target amounts displayed
ObjectiveNegotiationPEOPlannedTitle	Title for the manual contributions added to the objective.
ObjectiveNegotiationPEOProgramHeaderId	Value that uniquely identifies the program.
ObjectivePersonNamePEODisplayName	Display name of the person in the objective.
ObjectivePersonNamePEOEffectiveEndDate	Date when the objective ends.
ObjectivePersonNamePEOEffectiveStartDate	Date when the objective starts.
ObjectivePersonNamePEOFullName	Full name of the person in the objective.
ObjectivePersonNamePEOListName	List name of the person in the objective.
ObjectivePersonNamePEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ObjectivePersonNamePEOPersonId	Value that uniquely identifies the person who created the program.
ObjectivePersonNamePEOPersonNameId	Value that uniquely identifies the name of the person who created the program.
ObjectiveStatusLookupPEOCreatedBy	User who created the objective status row.
ObjectiveStatusLookupPEOCreationDate	Date and time the objective status row was created.
ObjectiveStatusLookupPEODescription	Description of the objective status.
ObjectiveStatusLookupPEODisplaySequence	Display sequence of the Objective status.
ObjectiveStatusLookupPEOEnabledFlag	Value that indicates whether public entity object is enabled for the current program objective status.
ObjectiveStatusLookupPEOEndDateActive	Date when the objective ends.
ObjectiveStatusLookupPEOLastUpdateDate	Date and time the objective status row was last updated.
ObjectiveStatusLookupPEOLastUpdateLogin	Session login associated with the user who last updated the objective status row.
ObjectiveStatusLookupPEOLastUpdatedBy	User who last updated the objective status row.
ObjectiveStatusLookupPEOMeaning	Meaning of the objective status.
ObjectiveStatusLookupPEOSetId	Value that uniquely identifies the set of the objective status.
ObjectiveStatusLookupPEOStartDateActive	Date when the objective starts.
ObjectiveStatusLookupPEOViewApplicationId	Unique identifier of the objective status application.
ObjectiveTypeLookupPEOCreatedBy	User who created the object row.
ObjectiveTypeLookupPEOCreationDate	Date and time the object row was created.
ObjectiveTypeLookupPEODescription	Description of the objective type.
ObjectiveTypeLookupPEODisplaySequence	Sequence in which the objective type is displayed.
ObjectiveTypeLookupPEOEnabledFlag	Value that indicates whether public entity object is enabled for the current program objective.
ObjectiveTypeLookupPEOEndDateActive	Date when the objective ends.
ObjectiveTypeLookupPEOLastUpdateDate	Date and time the object row was last updated.
ObjectiveTypeLookupPEOLastUpdateLogin	Session login associated with the user who last updated the object row.
ObjectiveTypeLookupPEOLastUpdatedBy	User who last updated the object row.
ObjectiveTypeLookupPEOMeaning	Meaning of the objective type.
ObjectiveTypeLookupPEOSetId	Value that uniquely identifies the set of the objective type.
ObjectiveTypeLookupPEOStartDateActive	Date when the objective type starts.
ObjectiveTypeLookupPEOViewApplicationId	Unique identifier of the objective type application.
ProgBaseTargetSpendNotAllocatedToObj	Value that indicates that the target spend is not allocated to objective.
ProgSavingsGoalDiffBaseVsPlanned	Value that indicates the difference between base savings goal and planned savings goal.
ProgramBrowseCategoryPEOCategoryDescription	Description of the program browse category.
ProgramBrowseCategoryPEOCategoryId	Browsing category or an item category from the procurement category hierarchy that the program is associated with.
ProgramBrowseCategoryPEOCategoryName	Category name of the program browse category.
ProgramBrowseCategoryPEOCreatedBy	User who created the program row.
ProgramBrowseCategoryPEOCreationDate	Date and time the program row was created.
ProgramBrowseCategoryPEOImageUrl	Uniform Resource Locator of the image used in the program browse category.
ProgramBrowseCategoryPEOLastUpdateDate	Date and time the program row was last updated.
ProgramBrowseCategoryPEOLastUpdateLogin	Session login associated with the user who last updated the program row.
ProgramBrowseCategoryPEOLastUpdatedBy	User who last updated the program row.
ProgramBrowseCategoryPEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ProgramBrowseCategoryPEOType	Type of program browse category.
ProgramCategoryName	Name of the program category.
ProgramCategoryPEOCategoryCode	Category code of the program category.
ProgramCategoryPEOCategoryContentCode	Content code of the program category or an item category from the procurement category hierarchy that the program is associated with.
ProgramCategoryPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ProgramCategoryPEOCategoryName	Category name of the program.
ProgramCategoryPEODescription	Description of the program category.
ProgramCategoryPEOEnabledFlag	Value that indicates whether the public entity object is enabled for the current program category.
ProgramCategoryPEOEndDateActive	Date when the program category ends.
ProgramCategoryPEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ProgramCategoryPEOStartDateActive	Date when the objective starts.
ProgramCategoryPEOSummaryFlag	Summary of the sourcing program category.
ProgramCategoryPEOSupplierEnabledFlag	Value that indicates if the supplier has been enabled in the program category.
ProgramCategoryPEOWebStatus	Web status of the program category.
ProgramDailyConversionTypePEOConversionType	Type of conversion in daily sourcing program.
ProgramDailyConversionTypePEODescription	Description of the daily sourcing program.
ProgramDailyConversionTypePEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ProgramDailyConversionTypePEOUserConversionType	Type of user conversion in the daily sourcing program.
ProgramHeaderPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ProgramHeaderPEOComments	Comments provided while creating program.
ProgramHeaderPEOCreatedBy	User who created the program row.
ProgramHeaderPEOCreationDate	Date and time of the creation of the program row.
ProgramHeaderPEOCreationDateOnly	Date of the creation of the program row.
ProgramHeaderPEOCurrencyCode	Base currency code in which program is monitored.
ProgramHeaderPEOCurrentSpend	Current spend for which the program is created.
ProgramHeaderPEOEndDate	Date when the program ends.
ProgramHeaderPEOGlobalProgramFlag	Value that indicates whether program is global or not.
ProgramHeaderPEOLastUpdateDate	Date and time of the last update of the program row.
ProgramHeaderPEOLastUpdateLogin	Session login associated to the user who last updated the program row.
ProgramHeaderPEOLastUpdatedBy	User who last updated the program row.
ProgramHeaderPEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ProgramHeaderPEOPersonId	Value that uniquely identifies the person who created the program.
ProgramHeaderPEOPrcBuId	Value that uniquely identifies the procurement business unit for which the program was created. It is populated only when the program is not global.
ProgramHeaderPEOProgramHeaderId	System generated unique identifier for the program.
ProgramHeaderPEOProgramPhase	Indicates phase of the program.
ProgramHeaderPEOProgramStatus	Indicates status of the program.
ProgramHeaderPEOPurchasingCatFlag	Value that indicates whether the category associated with the program is purchasing category or not.
ProgramHeaderPEORateDate	Conversion date for the selected rate type.
ProgramHeaderPEORateType	Rate type selected for the program.
ProgramHeaderPEOSavings	Savings amount that the program is trying to achieve.
ProgramHeaderPEOSavingsPercent	Savings percentage that the program is trying to achieve.
ProgramHeaderPEOStartDate	Date when the program starts.
ProgramHeaderPEOSynopsis	Program synopsis as defined by the user.
ProgramHeaderPEOTargetSpend	Target spend that the program is trying to achieve.
ProgramHeaderPEOTitle	Program title as defined by the user.
ProgramObjectivePEOCategoryId	Browsing category or an item category from the procurement category hierarchy that the program is associated with.
ProgramObjectivePEOComments	Comments provided while creating program.
ProgramObjectivePEOCreatedBy	User who created the program objective row.
ProgramObjectivePEOCreationDate	Date and time the program objective row was created.
ProgramObjectivePEOCurrentSpend	Current spend for which the program is created.
ProgramObjectivePEODescription	Description of the objective.
ProgramObjectivePEOEndDate	The date when the program ends.
ProgramObjectivePEOLastUpdateDate	Date and time the program objective row was last updated.
ProgramObjectivePEOLastUpdateLogin	Session login associated with the user who last updated the program objective row.
ProgramObjectivePEOLastUpdatedBy	User who last updated the program objective row.
ProgramObjectivePEOName	Name of the objective.
ProgramObjectivePEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ProgramObjectivePEOObjectiveHeaderId	Value that uniquely identifies the objective.
ProgramObjectivePEOObjectiveType	A way to classify or categorize an objective for reporting purposes.
ProgramObjectivePEOPersonId	Value that uniquely identifies the person who created the program.
ProgramObjectivePEOProgramHeaderId	Value that uniquely identifies the program.
ProgramObjectivePEOPurchasingCatFlag	Value that indicates whether the category associated with the program is purchasing category or not.
ProgramObjectivePEORollUpFlag	Value that indicates whether the savings and spend values of the objective's negotiations will be counted for program level spend and savings.
ProgramObjectivePEOSavings	Savings amount that the program is trying to achieve.
ProgramObjectivePEOSavingsPercent	Savings percentage that the program is trying to achieve.
ProgramObjectivePEOStartDate	Date when the program starts.
ProgramObjectivePEOStatus	Determines the status of the objective.
ProgramObjectivePEOTargetSpend	Target spend that the program is trying to achieve.
ProgramPersonNamePEODisplayName	Display name of the user in the program
ProgramPersonNamePEOEffectiveEndDate	Date when the program ends.
ProgramPersonNamePEOEffectiveStartDate	Date when the program starts.
ProgramPersonNamePEOFullName	Full name of the person in the program.
ProgramPersonNamePEOListName	List name of the person in the program.
ProgramPersonNamePEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ProgramPersonNamePEOPersonId	Value that uniquely identifies the person who created the program.
ProgramPersonNamePEOPersonNameId	Value that uniquely identifies the name of the person who created the program.
ProgramPhaseLookupPEOCreatedBy	User who created the program phase row.
ProgramPhaseLookupPEOCreationDate	Date and time the program phase row was created.
ProgramPhaseLookupPEODescription	Description of the program phase.
ProgramPhaseLookupPEODisplaySequence	Sequence in which the program phase is displayed.
ProgramPhaseLookupPEOEnabledFlag	Value that indicates whether public entity object is enabled for the current program phase.
ProgramPhaseLookupPEOEndDateActive	Date when the program ends.
ProgramPhaseLookupPEOLastUpdateDate	Date and time the program phase row was last updated.
ProgramPhaseLookupPEOLastUpdateLogin	Session login associated with the user who last updated the program phase row.
ProgramPhaseLookupPEOLastUpdatedBy	User who last updated the program phase row.
ProgramPhaseLookupPEOMeaning	Meaning of the program phase.
ProgramPhaseLookupPEOSetId	Value that uniquely identifies the program phase set.
ProgramPhaseLookupPEOStartDateActive	Date when the program starts.
ProgramPhaseLookupPEOViewApplicationId	Value that uniquely identifies the program phase application.
ProgramStatusLookupPEOCreatedBy	User who created the program status row.
ProgramStatusLookupPEOCreationDate	Date and time the program status row was created.
ProgramStatusLookupPEODescription	Description of the program status.
ProgramStatusLookupPEODisplaySequence	Sequence in which the program status is displayed.
ProgramStatusLookupPEOEnabledFlag	Value that indicates whether public entity object is enabled for the current program status.
ProgramStatusLookupPEOEndDateActive	Date when the program ends.
ProgramStatusLookupPEOLastUpdateDate	Date and time the program status row was last updated.
ProgramStatusLookupPEOLastUpdateLogin	Session login associated with the user who last updated the program status row.
ProgramStatusLookupPEOLastUpdatedBy	User who last updated the program status row.
ProgramStatusLookupPEOMeaning	Meaning of the program status
ProgramStatusLookupPEOSetId	Value that uniquely identifies the program status set.
ProgramStatusLookupPEOStartDateActive	Date when the program starts.
ProgramStatusLookupPEOViewApplicationId	Value that uniquely identifies the program status application.
SysEffectiveDate	Date from which the program is effective from.