Negotiation Line Extract Details
The Negotiation Line Extract Details view object contains information about line items and associated attributes. It manages line items along with their child entities with their day-to-day procurement and delivery.
Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.NegotiationLineExtractPVO
Primary Keys : AuctionHeaderId, LineNumber
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AdditionalJobDetails | Unique identifier for additional job details. |
| AdvanceAmount | Amount that may be paid in advance for this line item. |
| AllocationStatus | Indicates the allocation status of the line item. |
| AllowAlternateLines | Value that indicates whether alternate lines are allowed or not. |
| Attribute1 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute10 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute11 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute12 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute13 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute14 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute15 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute16 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute17 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute18 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute19 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute2 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute20 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute3 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute4 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute5 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute6 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute7 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute8 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| Attribute9 | Segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeCategory | Context name for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate1 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate10 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate2 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate3 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate4 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate5 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate6 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate7 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate8 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeDate9 | Date segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber1 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber10 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber2 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber3 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber4 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber5 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber6 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber7 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber8 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeNumber9 | Number segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp10 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp6 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp7 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp8 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AttributeTimestamp9 | Date and time segment for the Negotiation and Line Extract descriptive flexfield. |
| AuctionHeaderId | Unique identifier for the auction header. |
| AwardMode | Indicates mode through which this item was awarded. |
| AwardStatus | Award status for this item. |
| AwardedQuantity | Total quantity awarded for auction. |
| BestBidBidCurrencyCode | Bid currency code for bid with the best price and score. |
| BestBidBidCurrencyPrice | Price in bid currency for bid with the best price and score. |
| BestBidBidNumber | Bid number for bid with the best price and score ratio. |
| BestBidBidPrice | Price for bid with the best price and score ratio. |
| BestBidCurrencyCode | Currency code of best bid. |
| BestBidCurrencyPrice | Best bid price in the best bid currency. |
| BestBidFirstBidPrice | First Bid price received. |
| BestBidNumber | Bid Number of bid containing best price. |
| BestBidPrice | Identifier for the price in best bid. |
| BestBidPromisedDate | Date on which the best bid is promised. |
| BestBidProxyLimitPrice | Proxy Bid price for the best bid. |
| BestBidQuantity | Indicates quantity in best bid. |
| BestBidScore | Score for bid with the best price and score ratio. |
| BidStartPrice | Price that bids can start from. |
| CarrierId | Indicates carrier ID of shipping method. |
| CategoryId | Unique Identifier for category. |
| CloseBiddingDate | Date when the bidding is closed for this item. |
| CreatedBy | Indicates user who created the row. |
| CreationDate | Indicates date and time of the creation of the row. |
| CurrentPrice | Indicates current price of item being paid outside auction. |
| DifferentialResponseType | Indicates negotiation item's price differential response type. |
| DispLineNumber | Indicates internal number used for ordering lines. |
| DisplayTargetPriceFlag | Value that indicates whether to display target price to bidders. |
| DocumentDispLineNumber | Indicates document line number to display. |
| GroupType | Unique identifier indicating group type. |
| HasAttributesFlag | Value that indicates if the line item has attributes. |
| HasBuyerPfsFlag | Value that indicates whether this line has any buyer price factors or not. |
| HasPaymentsFlag | Value that indicates whether this line has payments defined under it. |
| HasPriceDifferentialsFlag | Value that indicates if the item has price differentials. |
| HasPriceElementsFlag | Value that indicates if any supplier cost factors exists for the line. |
| HasQuantityTiers | Indicates whether there are quantity tiers or not. |
| HasShipmentsFlag | Value that indicates if the line has shipments. |
| InvOrgId | Unique identifier for inventory organization ID. |
| ItemDescription | Unique identifier for item description. |
| ItemId | Unique identifier for item ID. |
| ItemRevision | Unique identifier for item revision ID. |
| JobId | Unique identifier for job ID. |
| LastAmendmentUpdate | Amendment number for which this line was last modified. |
| LastUpdateDate | Indicates the date and time of the last update of the row. |
| LastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LastUpdatedBy | Indicates the user who last updated the row. |
| LineNumber | Identifier for the internal line number. |
| LineOriginationCode | Indicates line origination code. |
| LineTypeId | Indicates line type ID. |
| MaxRetainageAmount | Maximum amount that can be retained across all invoices for this line. |
| MaxSubLineSequenceNumber | Maximum subline sequence number for a lot or group. |
| ModeOfTransport | Type of transportation used to ship the product, such as truck, air, boat. |
| ModifiedDate | Indicates last modified date. |
| ModifiedFlag | Value that indicates if the item is modified in the current round compared to the previous round. |
| NeedByDate | Date on which the item is needed at shipping location. |
| NoAward | Value to identify if the negotiation line has been marked as no award. |
| NoteToBidders | Indicates note to the bidders in the negotiation. |
| NumberOfBids | Indicates number of bids received for this item. |
| NumberOfExtensions | Indicates number of auto extensions received on this line item. |
| ObjectVersionNumber | Used to implement optimistic locking. The number is incremented every time that the row is updated. |
| OrderTypeLookupCode | Indicates line type basis lookup code. |
| ParentLineNumber | Indicates line number of parent lot or group. |
| PoAgreedAmount | Indicates budgeted purchase order amount. |
| PoMinRelAmount | Indicates purchase order minimum release amount. |
| PrcBuId | Unique ID for procurement business unit. |
| PriceBreakNegFlag | Value that indicates if the price breaks are negotiable. |
| PriceBreakType | Indicates type of price break. |
| PriceDiffShipmentNumber | Indicates price differential shipment number. |
| PriceDisabledFlag | Value that indicates if price is disabled for the line in an RFI. |
| ProgressPymtRatePercent | Percentage of the amount that will be due to the supplier upon fulfillment of a pay item for each invoice for this line. |
| ProjectAwardId | Unique identifier of the award which is association with this line. |
| ProjectExpOrganizationId | Unique identifier of the expenditure organization associated with this line for Oracle Projects. |
| ProjectExpenditureItemDate | Date used for accounting the transaction for this line in Oracle Projects. |
| ProjectExpenditureType | Expenditure type in Oracle Projects associated with this line. |
| ProjectId | Unique identifier of the project in Oracle Projects to which the cost of this line will be charged when executed in Oracle Purchasing. |
| ProjectTaskId | Unique identifier of the task in Oracle projects to which the cost of this line will be charged when executed in Oracle purchasing. |
| PurchaseBasis | Indicates line type purchase basis. |
| Quantity | Identifies the quantity of the line items. |
| QuantityDisabledFlag | Value that indicates if quantity is disabled for the line in RFI. |
| RecommendedAwardAmount | Recommended award amount for a line. |
| RecoupmentRatePercent | Percentage of the amount of each invoice for this line that can be recouped when financing or advances are provided to the supplier. |
| ReqBuId | Identifies the requisitioning business unit for this item. |
| RequestedDeliveryDate | Date when the designated product that the procurement organization intends to buy is needed. |
| RequestedShipDate | Date when the buyer company wants the supplier to ship out the designated product that the buyer company intends to buy. |
| RequisitionNumber | Indicates requisition number. |
| RetainageRatePercent | Percentage of the invoice line amount that will be retained until the work is completed and accepted. |
| ServiceLevel | Priority of transportation that affects how quickly goods will be transported. |
| ShipToLocationId | Unique location identifier to which auction items will be shipped. |
| SourceDocId | Indicates source document ID. |
| SourceDocNumber | Indicates source document number for display. |
| SourceLineId | Indicates source document line ID. |
| SourceLineNumber | Indicates source document line number for display. |
| SubLineSequenceNumber | Indicates lot or group line's sequence within the lot or group. |
| TargetPrice | Indicates target price for item |
| UnitDisplayTargetFlag | Value that indicates whether to display target price of unit price to suppliers or not. |
| UnitTargetPrice | Indicates target price for auction item unit price. |
| UomCode | Indicates code for unit of measure. |
| WorkApproverUserId | Unique identifier of the user who's responsible for confirming that the supplier has performed work as agreed. |