JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftSupplierNegotiationResponseslines

Captures line-level information in a supplier’s draft response, including price, quantity, and delivery terms.

Columns

Name Type Description
DraftSupplierNegotiationResponsesResponseNumber [KEY] Long The unique identifier for the negotiation response, linking the response to a specific negotiation line.
ResponseNumber [KEY] Long The identifier for the supplier's response, linking it to the original negotiation response.
AuctionHeaderId Long The unique identifier for the auction associated with the negotiation, allowing for tracking of responses in the auction context.
LineId [KEY] Long The identifier for the specific negotiation line within the response, allowing for detailed tracking of individual items or services in the negotiation.
Line String The line number that identifies a specific item or service within the negotiation response, helping to differentiate between multiple lines in the negotiation.
ParentLine Decimal The identifier for the parent line, used when the response is part of a hierarchical structure of negotiation lines.
LineTypeId Long The identifier for the line type, indicating whether the negotiation line is for goods (items) or services.
LineType String The name of the negotiation line type, indicating whether the line is for goods (for example, 'Fixed Price') or services (for example, 'Quantity').
GroupTypeCode String An identifier for the type of negotiation line, indicating whether it’s a standard line, group, group line, lot, or lot line. Values are defined in the 'PON_GROUP_TYPE' lookup.
GroupType String The type of negotiation line, specifying whether it’s a standard line, a grouped line, or part of a larger lot. Values are defined in the 'PON_GROUP_TYPE' lookup.
ItemId Long The unique identifier for the inventory item associated with the negotiation line, helping to link the response to specific products.
Item String The name of the inventory item offered in the negotiation line, providing a description of the goods or services being bid on.
ItemRevision String The revision number of the inventory item in the negotiation line, helping to track changes or updates to the item.
LineDescription String A description of the line item, providing additional details about the goods or services being offered in the negotiation.
AlternateLineNumber Decimal An alternate line number offered by the supplier in response to a negotiation line, providing an alternative option for the buyer.
AlternateLineDescription String A description of the alternate line item offered by the supplier, detailing the alternative product or service provided.
SupplierId Long The unique identifier for the supplier responding to the negotiation, helping to track which supplier provided the offer.
Supplier String The name of the supplier submitting the response to the negotiation, identifying the supplier entity involved.
CategoryId Long The identifier for the purchasing category associated with the negotiation line, helping to categorize the goods or services being negotiated.
CategoryName String The name of the purchasing category for the negotiation line, providing context for the type of goods or services being offered.
StartPrice Decimal The highest price the buyer is willing to accept for the item in the negotiation line, setting an upper limit for the supplier's offer.
TargetPrice Decimal The price the procurement organization aims to achieve in the negotiation, representing the preferred cost for the negotiation line.
ResponsePrice Decimal The price quoted by the supplier for the negotiation line, indicating the amount the supplier is offering for the item or service.
BestResponsePrice Decimal The best price quoted for the line item across all supplier responses, representing the lowest price offered.
BestResponseScore Decimal The highest score achieved based on multiattribute scoring, indicating the best response among suppliers based on multiple evaluation criteria.
LineAttributeScore Decimal The total weighted score for the supplier’s response, calculated based on predefined attributes such as price, quality, or delivery time.
ProxyDecrement Decimal The minimum price reduction set by the supplier, below which the price will not be automatically reduced during proxy bidding.
ProxyMinimum Decimal The minimum price threshold set by the supplier, under which the system will not reduce the response price automatically in a proxy bid.
TargetQuantity Decimal The quantity proposed by the procurement organization for the negotiation line, indicating how much of the item is required.
ResponseQuantity Decimal The quantity proposed by the supplier for the negotiation line, indicating how much of the item the supplier is offering.
ResponseEstimatedQuantity Decimal The estimated quantity for the negotiation line, typically used in long-term or blanket agreements to estimate future requirements.
UOMCode String The unit of measure code for the negotiation line, specifying the measurement unit used for the item (for example, 'EA' for each, 'KG' for kilogram).
UOM String The name of the unit of measure for the item in the negotiation, providing clarity on how the item is measured.
LineCloseDate Datetime The date and time when the negotiation line closes, marking the final moment when bids can be submitted for that specific line.
LineTargetPrice Decimal The target price the buyer wants to achieve for the negotiation line, helping to guide supplier offers within an acceptable range.
LinePrice Decimal The price of the negotiation line item that will be used on the purchasing document, typically displayed in the negotiation's transactional currency.
LineAmount Decimal The total amount for the line, calculated as the price multiplied by the quantity, representing the total cost for that line item.
PricingBasisCode String An abbreviation for the pricing basis, which identifies how the price is calculated for the negotiation line, with values defined in the 'PON_PRICING_BASIS' lookup.
PricingBasis String The basis used to calculate the price for the negotiation line, such as 'Fixed Price' or 'Per Unit', defined in the 'PON_PRICING_BASIS' lookup.
TargetMinimumReleaseAmount Decimal The minimum amount the buyer wants to receive in response to the negotiation line, typically used in agreements that involve multiple releases or deliveries.
ResponseMinimumReleaseAmount Decimal The minimum release amount the supplier quotes in response to the negotiation line, indicating the lowest price acceptable for releasing the contract.
EstimatedTotalAmount Decimal The estimated total cost for a fixed price negotiation line, calculated based on the price and the estimated quantity of the items.
ShipToLocationId Long The unique identifier for the location to which the line item is to be shipped, ensuring correct delivery of goods.
ShipToLocation String The name of the location to which the line item should be shipped, helping to identify the destination for the goods.
RequestedDeliveryDate Date The date by which the buyer requests the supplier to deliver the goods or services associated with the negotiation line.
RequestedShipDate Date The date by which the supplier is requested to ship the goods associated with the negotiation line.
PromisedDeliveryDate Date The date on which the supplier promises to deliver the goods or services associated with the negotiation line.
PromisedShipDate Date The date on which the supplier promises to ship the goods, specified if Buyer Managed transportation is enabled in the negotiation terms.
NoteToBuyer String A note entered by the supplier for the buyer when responding to the negotiation, often used to clarify or provide additional context for the offer.
NoteToSupplier String A note entered by the buyer for the supplier when responding to the negotiation, often used to provide further instructions or clarification.
SuppliersCanModifyPriceBreaksFlag Bool A flag indicating whether price breaks can be modified by the supplier in their response. If true, the supplier can modify price breaks; if false, they cannot.
PriceBreakTypeCode String An abbreviation that identifies the type of price break offered by the supplier, with accepted values such as 'CUMULATIVE' or 'NONCUMULATIVE'.
PriceBreakType String The type of price break, indicating whether the price break applies to a single purchase order or all purchase orders for the agreement.
CreatedBy String The user who created the negotiation line, providing accountability for the creation of the item.
CreationDate Datetime The date and time when the negotiation line was created, helping to track when the item was first added to the negotiation.
LastUpdatedBy String The user who last updated the negotiation line, helping to track modifications to the item.
LastUpdateDate Datetime The date and time when the negotiation line was last updated, providing a timestamp for the most recent changes.
OrderTypeLookupCode String An abbreviation for the line type in the negotiation, such as 'QUANTITY' or 'FIXED PRICE', specifying how the price is determined.
IsResponseQuantityEditableFlag Bool A flag indicating whether the supplier can modify the response quantity. If true, the supplier can edit the quantity; if false, it cannot be changed.
PriceDisabledFlag Bool A flag indicating whether the price can be modified by the supplier in blind negotiations. If true, the price is locked and cannot be altered.
LineFilteringNumber Long The identifier for the negotiation line used in filtering responses, helping to manage and sort items in the negotiation.
Finder String A search identifier used to locate specific negotiation lines within the system.
EffectiveDate Date The effective date of the negotiation line, indicating when the terms of the line become applicable and valid.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434