JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationslines

Details products and services being sourced in the negotiation, including specifications, baseline pricing, or quantity.

Columns

Name Type Description
SupplierNegotiationsAuctionHeaderId [KEY] Long Unique identifier for the auction header, linking the negotiation line data to a specific auction event in the negotiation process.
AuctionHeaderId [KEY] Long Unique identifier for the auction event, linking the specific negotiation lines to the overall negotiation event.
LineId [KEY] Decimal Unique identifier for each negotiation line, helping to track the specific details of a line in the negotiation.
Line String The number that identifies the specific negotiation line, which helps to differentiate between various lines within the negotiation.
ParentLine String The number identifying a parent line in the negotiation, indicating whether the line belongs to a group or lot, and referencing an existing parent line in the negotiation.
Requisition String Requisition number associated with the negotiation line, providing a reference to the purchase request that initiated the negotiation.
RequisitionLine String Requisition line number associated with the specific line of the negotiation, linking it to the corresponding line in the requisition.
SourceAgreement String The source agreement that the current negotiation line is based on, used to track any renegotiation or reference to an existing agreement.
SourceAgreementLine String The source agreement line number that corresponds to the negotiation line, linking it to the original agreement.
LineCloseDate Datetime Date and time when the negotiation line closes, marking the end of the negotiation period for that specific line in a staggered or extended negotiation.
SequenceNumber Int Number specifying the order in which lines are added to the negotiation using a web service, providing a sequence for the negotiation lines.
ParentSequenceNumber Int Sequence number of the parent line to which a child line is added, helping to organize lines hierarchically in groups or lots.
GroupType String Type of negotiation line, such as line, group, group line, lot, or lot line, categorizing the line type. A list of accepted values is defined in the lookup type Negotiation Line Type.
GroupTypeCode String Abbreviation identifying the type of negotiation line, such as line, group, group line, lot, or lot line, used for classification in the negotiation process.
PriceAndQuantityEnabledFlag Bool Flag indicating whether each RFI (request for information) line can include price and quantity details. If true, price and quantity are allowed; if false, they are not.
UnitTargetPrice Decimal Preferred price that the procurement organization aims to pay for the negotiation line, excluding any cost factors.
DisplayUnitTargetPriceFlag Bool Flag indicating whether the supplier can view the unit target price. If true, the supplier can see the target price; if false, they cannot.
LineDescription String A description of the negotiation line, providing additional details or context for the specific line in the negotiation.
RequisitioningBU String The name of the requisition business unit that acts as a client to the procurement business unit handling the negotiation.
RequisitioningBUId Long Unique identifier for the requisition business unit associated with the negotiation line, linking it to the procurement organization.
LineType String The name of the line type, indicating whether the line is for items or services. A list of accepted values is defined in the lookup type ORDER TYPE.
LineTypeId Long Unique identifier for the line type, indicating whether the line represents items or services in the negotiation.
Item String Name of the inventory item associated with the negotiation line, identifying the specific goods or services being negotiated.
ItemId Long Unique identifier for the inventory item, used to track and reference the item within the negotiation.
ItemRevision String The revision number of the inventory item associated with the negotiation line, providing version control for item specifications.
CategoryName String The name of the purchasing category associated with the negotiation line, categorizing the item or service for procurement purposes.
CategoryId Long Unique identifier for the purchasing category associated with the negotiation line, linking the item or service to the relevant category.
Quantity Decimal Quantity of the item in the negotiation line, representing the amount being negotiated for procurement.
EstimatedQuantity Decimal Estimated quantity of the item in the negotiation line, providing a projection of the required amount.
UOM String Unit of measure for the item in the negotiation line, specifying the standard measurement for quantity (for example, 'each', 'kg').
UOMCode String Abbreviation identifying the unit of measure for the item in the negotiation line, offering a compact reference for the measurement unit.
ShipToLocation String The name of the location where the item will be shipped, or where the negotiated service will be performed, specifying the destination.
ShipToLocationId Long Unique identifier for the location where the item will be shipped, used to track and reference the delivery point.
RequestedDeliveryDate Date Date when the application requests that the item or service is delivered, providing the expected timeline for delivery.
RequestedShipDate Date Date when the application requests that the item is shipped, specifying the desired shipping date.
CurrentPrice Decimal Current price that the procurement organization is paying for the item or service, representing the agreed-upon cost in the negotiation.
TargetPrice Decimal The price that the procurement organization prefers to pay for the negotiation line, guiding the negotiation strategy.
DisplayTargetPriceFlag Bool Flag indicating whether the supplier can view the target price for the negotiation line. If true, the supplier can see the target price; if false, they cannot.
ResponseRevisionLineDecrementValue Decimal The minimum amount or percentage by which the line price must be reduced in each revised response, helping to track price adjustments.
StartPrice Decimal The highest price allowed for the supplier to enter in response to the negotiation line, providing an upper limit for the pricing.
RetainageRate Decimal Percentage of the amount requested that will be withheld before payments are released to the contractor, typically used to ensure completion.
MaximumRetainageAmount Decimal The maximum amount of retainage that can be withheld for the negotiation line, specifying the financial cap for withheld amounts.
NoteToSuppliers String A note to suppliers, providing additional instructions, information, or context related to the negotiation line.
AllowAlternateLinesFlag Bool Flag indicating whether the supplier can create alternate response lines for each negotiation line. If true, alternate lines are allowed; if false, they are not.
EstimatedTotalAmount Decimal Estimated total amount for the service or item in the negotiation line, providing a financial projection for the entire line.
MinimumReleaseAmount Decimal The minimum amount in any purchase order line that can be released for the purchase agreement, establishing the smallest allowed release value.
PriceBreakType String Type of price break applied to the negotiation line, specifying how price breaks are calculated (for example, single purchase order or cumulative across orders).
PriceBreakTypeCode String Code identifying the type of price break applied, such as 'CUMULATIVE' or 'NON-CUMULATIVE', determining how price reductions are applied.
SuppliersCanModifyPriceBreaksFlag Bool Flag indicating whether suppliers can modify price breaks set by the procurement organization. If true, modification is allowed; if false, it is not.
CreationDate Datetime The date and time when the negotiation line record was created, providing a timestamp for when the data was entered.
CreatedBy String The name or identifier of the person who created the negotiation line record, ensuring accountability for data entry.
LastUpdateDate Datetime The date and time when the negotiation line record was last updated, providing a timestamp for the most recent changes.
LastUpdatedBy String The name or identifier of the person who last updated the negotiation line record, ensuring accountability for changes made.
Finder String Search or query reference used for locating or filtering specific negotiation line records in the system.
EffectiveDate Date This query parameter is used to fetch resources that are effective as of the specified date, ensuring that only relevant data for the given period is retrieved.

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