Negotiation Response Line Details

The Negotiation Response Line Details view object consolidates common information about response line details along with their attributes.

Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.NegotiationResponseLineExtractPVO

Primary Keys : BidNumber, LineNumber

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AdvanceAmount	Amount that will be paid to the supplier as an advance in auction currency.
AlternateDispLineNumber	Internal number used for ordering the alternate lines.
AlternateLineDescription	Description of an alternate line.
AlternateLineFlag	Value that indicates if alternate lines are present in the negotiation.
AuctionHeaderId	Unique identifier of the auction header.
AuctionLineNumber	Line number of the negotiation line.
AwardDate	Date when the line items are awarded.
AwardPrice	Final price of the awarded line items.
AwardQuantity	Quantity of the awarded line items.
AwardShipmentNumber	Shipment number of the award.
AwardStatus	Award status of bid.
BatchId	Unique identifier of the batch of the line items being uploaded via spreadsheet.
BidCurrAdvanceAmount	Amount that will be paid to the supplier as an advance in response currency.
BidCurrMaxRetainageAmt	Maximum amount that can be retained across all invoices for this line in response currency.
BidCurrencyLimitPrice	Bid limit price in bid currency.
BidCurrencyPrice	Currency of bid price.
BidCurrencyTransPrice	Transformed price in bid currency.
BidCurrencyUnitPrice	Unit price in bid currency.
BidNumber	Unique identifier of the bid.
BidStartPrice	Start price for a multiple round negotiation which is derived from previous bid price in the previous round specified by the buyer.
CancelledLimitPrice	Proxy bid limit price at the time the user canceled proxy bidding on a line.
CopyPriceForProxyFlag	Value that indicates if there is active proxy going on for that line. The Value will be cleared out when the proxy bid is exhausted.
CreatedBy	Indicates user who has created the row.
CreationDate	Date and time when the row was created.
DisplayPriceFactorsFlag	Value that indicates whether this line has applicable price factors for this supplier.
DocumentDispLineNumber	Line number displayed to the user.
FirstBidPrice	Price for first bid.
FixedAmountComponent	Calculated value that contains fixed amount cost factors.
GroupAmount	Total group amount for all lines in that group.
HasAttributesFlag	Value that indicates if item attributes are present in the line item.
HasBidFlag	Value that indicates whether supplier has bid on the line or not.
HasBidPaymentsFlag	Value that indicates if this line has payments defined under it.
HasPriceDifferentialsFlag	Value that indicates if the response item has price differentials.
HasQuantityTiers	Value that indicates if the line has quantity tiers.
HasShipmentsFlag	Value that indicates whether the line has shipments.
InterfaceLineId	Unique identifier of the line number in the spreadsheet file.
IsChangedLineFlag	Value that indicates if the bid on an item is changed compared to the previous bid.
LastUpdateDate	Date and time when last row was updated.
LastUpdateLogin	Session login associated to user who last updated the row.
LastUpdatedBy	Indicates user who last updated the row.
LineNumber	Bid line item number.
MaxAlternateDispLineNumber	Maximum alternate display line number for a negotiation line.
MaxRetainageAmount	Maximum amount that can be retained across all invoices for this line in auction currency.
NoteToAuctionOwner	Note to auction owner.
ObjectVersionNumber	Used for implementing optimistic locking. This number is incremented every time that the row is updated.
OldAlternateLineDescription	Alternate line description of source bid.
OldBidCurrAdvanceAmount	Current advance amount of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid.
OldBidCurrMaxRetainageAmt	Current maximum retainage amount of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid.
OldBidCurrencyLimitPrice	Proxy limit in bid currency from source bid.
OldBidCurrencyPrice	Total price or unit price in bid currency from source bid.
OldBidCurrencyUnitPrice	Unit price in bid currency from source bid.
OldNoOfPayments	Number of payments in the previous bid. This is only populated when the supplier's bid is defaulted from an earlier bid and is used to determine if any payments were deleted in the new bid.
OldNoteToAuctionOwner	Note to auction owner from source bid.
OldPoBidMinRelAmount	Minimum release amount in the purchase order in bid currency from source bid.
OldPrice	Total price from source bid.
OldProgressPymtRatePercent	Progress payment rate percentage of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid.
OldPromisedDate	Promised date from source bid.
OldPromisedDeliveryDate	The old date when the supplier promises to deliver the ordered item or service in the previous bid.
OldPromisedShipDate	The old date when the supplier promises to ship out the item ordered by the buying company in the previous bid.
OldPublishDate	Publish date from source bid.
OldQuantity	Quantity from source bid.
OldRecoupmentRatePercent	Recoup rate percentage of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid.
OldRetainageRatePercent	Retainage rate percentage of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid.
OldUomCode	Code for unit of measure from source bid for alternate lines.
ParentLineNumber	Bid line number of parent log or group. For lines that aren't alternate lines, this value will be defaulted from the negotiation and for alternate lines this will store the line number of the parent alternate lot or group.
PerUnitPriceComponent	Calculated value that contains line price, per unit cost factors and percentage cost factors.
PoBidMinRelAmount	Minimum Release Amount in bid currency.
PoMinRelAmount	Minimum Release Amount in negotiation currency.
Price	Price per unit.
PriceBreakType	Type of price break.
PriceDiffShipmentNumber	Price differential shipment number.
ProgramAppName	Identifies the application name spawning concurrent request.
ProgramName	Name of the concurrent program.
ProgramUpdateDate	Date when this row was last updated by a concurrent program.
ProgressPymtRatePercent	Percentage of the amount that will be due to the Supplier upon completion of a milestone.
PromisedDate	Date items are promised at receivers address.
PromisedDeliveryDate	Date that the supplier has promised to deliver the ordered item or service.
PromisedShipDate	Date that the supplier has promised to ship the item ordered by the buying company.
ProxyBidFlag	Value that indicates proxy bid is allowable.
ProxyBidLimitPrice	Price limit that can be bid in proxy bid.
PublishDate	Date when this row is published.
PurchasingItemDesc	Item Description associated to the purchasing line created from this line if it's an alternate line response.
PurchasingItemId	Item ID associated to the purchasing line created from this line if it's an alternate line response.
PurchasingItemRevision	Item Revision associated to the purchasing line created from this line if it's an alternate line response.
Quantity	Quantity of the line items in this bid.
Rank	Rank for this particular bid.
RecoupmentRatePercent	Percentage of each invoice that can be recouped when financing or advances are provided to the supplier.
RequestId	Unique identifier of request of the job that created or last updated the row.
RetainageRatePercent	Percentage of each invoice that will be retained until the work is completed and accepted.
TotalWeightedScore	Total weighted score for the scored attributes.
TriggerBidNumber	Bid number which triggered system to generate this bid.
UnitPrice	Unit price in auction currency.
UomCode	Code for unit of measure. For lines that aren't alternate lines, this value will be defaulted from the negotiation.
UomConversionFactor	Conversion factor between Negotiation Line UOM and Alternate Line UOM.
WorksheetName	Worksheet name in which this column appears during XML spreadsheet upload.
WorksheetSequenceNumber	Sequence number of the worksheet.