Negotiations and Purchasing Transactions

Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.NegotiationIotSupplierTransactionExtractPVO

Primary Keys : SupplierTransactionId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
BidHeaderId	Value that uniquely identifies the supplier response.
BidLineId	Value that uniquely identifies the supplier response line.
CategoryDescription	Description of the purchasing category for the negotiation line.
CategoryId	Value that identifies the purchasing category for the negotiation line.
CategoryName	Name of the purchasing category for the negotiation line.
CreatedBy	User who created the sourcing or purchasing transaction.
CreationDate	Date and time when the sourcing or purchasing transaction was created.
HeaderId	Value that uniquely identifies the negotiation or purchasing document.
Item	Name of the inventory item.
ItemId	Value that identifies the inventory item.
LastUpdateDate	Date and time when the sourcing or purchasing transaction was last updated.
LastUpdateLogin	Session login associated with the user who last updated the sourcing or purchasing transaction.
LastUpdatedBy	User who last updated the sourcing or purchasing transaction.
LineDescription	Description of the negotiation line.
LineId	Value that uniquely identifies the negotiation line.
ObjectVersionNumber	Indicates the version number of the sourcing or purchasing transaction.
ProjectId	Value that uniquely identifies the supplier transaction project.
RecordTimestamp	Date and time of an event in the life cycle of a transaction that's related to providing supplier recommendations using the AI model. Values include awarded date when negotiation was awarded to a supplier, publish date when supplier was invited to participate in a negotiation but didn't respond to the invitation, response date when supplier responded to a negotiation but wasn't awarded, and creation date for purchase orders and agreements.
Source	Value that identifies the document type of the transaction. Values include REQUEST_FOR_INFORMATION, REQUEST_FOR_QUOTE, BUYER_AUCTION, STANDARD, or BLANKET.
SupplierAndSiteId	Value that uniquely identifies the supplier and site.
SupplierId	Value that identifies the supplier company.
SupplierScenario1	Scenario considered by the AI model to give supplier recommendations. Contains one of the following values: Y or N. If Y, the supplier was invited to the negotiation but didn't submit a response.
SupplierScenario2	Scenario considered by the AI model to give supplier recommendations. Contains one of the following values: Y or N. If Y, the supplier submitted a response but wasn't awarded.
SupplierScenario3	Scenario considered by the AI model to give supplier recommendations. Contains one of the following values: Y or N. If Y, the supplier was awarded negotiation in the past for the item and category.
SupplierScenario4	Scenario considered by the AI model to give supplier recommendations. Contains one of the following values: Y or N. If Y, the supplier has an existing purchase order line for the item and category.
SupplierScenario5	Scenario considered by the AI model to give supplier recommendations. Contains one of the following values: Y or N. If Y, the supplier has an existing purchase agreement line for the item and category.
SupplierSiteId	Value that identifies the supplier site of the supplier company.
SupplierTransactionId	Value that uniquely identifies the negotiation or purchasing transaction considered by the AI model to give supplier recommendations.