JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationResponseslines

Displays line-level details, such as pricing or lead times, in a supplier’s negotiation response for each item or service.

Columns

Name Type Description
SupplierNegotiationResponsesResponseNumber [KEY] Long Unique identifier for the response within the supplier negotiation, linking the response line to a specific response in the negotiation process.
ResponseNumber [KEY] Long Unique identifier for the response, used to track and reference a specific supplier's offer or bid in the negotiation process.
AuctionHeaderId Long Unique identifier for the auction header, linking the response line to a specific auction event that is part of the negotiation.
LineId [KEY] Long Unique identifier for the line item within the response, used to reference specific items within the negotiation response.
Line String The description or label for the line item, providing identification for each specific offer or item in the supplier’s response.
LineTypeId Long Unique identifier for the line type, categorizing the line item (for example, product, service) in the context of the negotiation.
LineType String The type of line item (for example, 'Product', 'Service'), helping to categorize the nature of the item being negotiated.
GroupTypeCode String Code representing the group to which the line item belongs, used for categorizing and grouping similar items in the negotiation process.
GroupType String Description of the group type, offering further clarification on the grouping of line items in the negotiation.
ItemId Long Unique identifier for the item associated with the line, linking the line item to a specific product or service in the catalog.
Item String The name or description of the item associated with the response line, providing context for the specific product or service being offered.
ItemRevision String The revision number of the item, indicating the version of the product or service being offered in the negotiation.
LineDescription String Detailed description of the line item, providing additional context or specifications related to the item or service being negotiated.
AlternateLineNumber Decimal Alternative line number for the item, used for reference if there are multiple versions or variations of the line item.
AlternateLineDescription String Alternative description for the line item, used if there are alternative versions or variations of the item offered.
CategoryId Long Unique identifier for the category of the line item, helping to group the item into broader product or service categories.
CategoryName String The name of the category to which the line item belongs, providing a classification for grouping items in the negotiation.
StartPrice Decimal The starting price for the line item, often representing the initial offer or starting point for negotiation.
TargetPrice Decimal The target price for the line item, representing the price at which the supplier hopes to reach an agreement.
Score Decimal The score assigned to the line item based on evaluation criteria, showing how well the item meets the requirements of the negotiation.
Rank String The rank of the line item relative to other offers in the negotiation, providing an indication of how it compares in terms of price or other evaluation criteria.
ResponsePrice Decimal The price offered for the line item by the supplier, representing their bid or offer for the item in the negotiation.
ProxyDecrement Decimal The amount by which the price is reduced in subsequent rounds of negotiation, indicating price adjustments made by the supplier.
ProxyMinimum Decimal The minimum price limit for the line item that the supplier is willing to accept, establishing a lower threshold for negotiation.
TargetQuantity Decimal The quantity of the item that the supplier aims to offer in the negotiation, often linked to the target order size or quantity.
ResponseQuantity Decimal The quantity of the item offered by the supplier in their response, indicating how much of the item they are bidding for.
PartialQuantityFlag Bool Flag indicating whether the response includes partial quantities. If true, the supplier is offering less than the full quantity requested.
ResponseEstimatedQuantity Decimal The estimated quantity for the item as provided by the supplier, giving a forecasted amount they intend to offer.
UOMCode String Code representing the unit of measure for the line item (for example, 'EA' for each, 'KG' for kilograms), helping to standardize measurement units.
UOM String The unit of measure for the line item, indicating how the item is quantified (for example, each, kilogram, box).
LineCloseDate Datetime The date and time when the line item is scheduled to close, marking the deadline for finalizing negotiations related to the item.
LineTargetPrice Decimal The target price for the line item, representing the price the supplier aims to achieve for the specific item.
LinePrice Decimal The price of the line item, typically representing the final agreed price or the supplier’s proposed price for the item.
LineAmount Decimal The total amount for the line item, calculated by multiplying the line price by the quantity offered.
PricingBasisCode String Code representing the pricing basis for the line item, such as unit price, total price, or other pricing models.
PricingBasis String The basis for pricing the line item, describing how the price is calculated (for example, per unit, per service).
TargetMinimumReleaseAmount Decimal The minimum amount the supplier is willing to accept for releasing the line item, used to define lower price thresholds.
ResponseMinimumReleaseAmount Decimal The minimum release amount proposed by the supplier for the line item, setting a lower bound for their response.
EstimatedTotalAmount Decimal The estimated total amount for the entire line item based on the response price and quantity.
ActiveResponses Decimal Number of active responses for the line item, indicating how many suppliers have submitted responses for that item.
AgreementQuantity Decimal The quantity of the item agreed upon, based on the negotiation outcome, representing the final quantity to be ordered.
AwardQuantity Decimal The quantity of the line item awarded to the supplier, reflecting the agreed-upon order quantity after the negotiation.
AwardStatus String Status of the award for the line item, indicating whether the award has been made, pending, or canceled.
AwardReason String Reason for awarding the line item to the supplier, providing justification for the decision based on evaluation criteria.
ShipToLocationId Long Unique identifier for the ship-to location for the line item, linking the item to a specific delivery address or location.
ShipToLocation String The name of the location where the line item is to be shipped, providing the shipping address for the item.
RequestedDeliveryDate Date The date requested by the supplier for delivering the line item, representing the supplier’s proposed delivery timeline.
RequestedShipDate Date The date requested by the supplier for shipping the line item, representing their proposed shipping schedule.
PromisedDeliveryDate Date The date promised by the supplier for delivering the line item, representing the supplier's commitment.
PromisedShipDate Date The date promised by the supplier for shipping the line item, confirming their shipping commitment.
NoteToBuyer String Additional notes from the supplier to the buyer regarding the line item, providing further context or instructions.
NoteToSuppliers String Notes from the buyer to the suppliers, offering additional instructions or clarifications for the line item.
PriceBreakTypeCode String Code representing the price break type for the line item, indicating if there are quantity-based price breaks or other pricing structures.
PriceBreakType String Description of the price break type, explaining the basis for any discounts or adjustments based on quantity or other factors.
CreatedBy String The name or identifier of the user who created the response line, providing accountability for data entry.
CreationDate Datetime The date and time when the response line was created, marking when the line item was added to the negotiation.
LastUpdatedBy String The name or identifier of the user who last updated the response line, ensuring accountability for changes made.
LastUpdateDate Datetime The date and time when the response line was last updated, providing a timestamp for the most recent change.
Finder String Search or query reference related to the SupplierNegotiationResponseslines, used for filtering or looking up specific line item records in the negotiation process.

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