Negotiation Response Price Tier Details

This Negotiation Response Price Tier Details view object consolidates common information about price tiers in sourcing.

Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.NegotiationResponsePriceTierExtractPVO

Primary Keys : LineNumber, BidNumber, ShipmentNumber

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AuctionHeaderId	Unique identifier for the negotiation.
AuctionLineNumber	Line number of the negotiation line.
AuctionShipmentNumber	Value that identifies the shipment number of the negotiation.
BidCurrencyPrice	Value that identifies the response currency price of the shipment.
BidCurrencyUnitPrice	Value that identifies the response currency entered by the supplier bidder.
BidNumber	Unique identifier for the negotiation.
CreatedBy	User who created the negotiation parent line row.
CreationDate	Date on which the negotiation parent line row was created.
EffectiveEndDate	End of the date range within which the row is effective.
EffectiveStartDate	Beginning of the date range within which the row is effective.
HasPriceDifferentialsFlag	Value that indicates if the response shipment has price differentials.
InterfaceLineId	Value that identifies the interface line ID.
LastUpdateDate	Date and time of the last update of the negotiation parent line row.
LastUpdateLogin	Session login associated with the user who last updated the negotiation parent line row.
LastUpdatedBy	User who last updated the negotiation parent line row.
LineNumber	Value that identifies the line number of the negotiation.
MaxQuantity	Value that identifies the maximum quantity for quantity tiers.
ObjectVersionNumber	Used to implement optimistic locking. The number is incremented every time that the row is updated.
OldBidCurrencyPrice	Value that identifies the total price in response currency from source response.
OldBidCurrencyUnitPrice	Value that identifies the unit price in response currency for the source response.
OldEffectiveEndDate	Effective end date from source response.
OldEffectiveStartDate	Effective start date from source response.
OldMaxQuantity	Value that identifies the maximum quantity of the previous response.
OldPriceDiscount	Value that identifies the price discount from source response.
OldPriceType	Value that identifies the price type from source response.
OldQuantity	Value that identifies the quantity from source response.
OldShipToLocId	Value that identifies the ship to location ID from the source response.
OldShipToOrgId	Value that identifies the ship to organization ID from the source response.
PerUnitPriceComponent	Value that identifies the per unit price excluding fixed amount components.
Price	Value that identifies the price of the shipment.
PriceDiscount	Value that identifies the price discount of the shipment.
PriceType	Value that identifies the type of shipment price.
Quantity	Value that identifies the quantity of the shipment.
ShipToLocationId	Value that identifies the ship to location ID from the source response.
ShipToOrganizationId	Value that identifies the ship to organization ID from the source response.
ShipmentNumber	Value that identifies the response shipment number.
ShipmentType	Value that identifies the type of shipment.
UnitPrice	Value that identifies the unit price entered by the supplier.