JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftSupplierNegotiationResponseslinespriceBreaks

Defines price variations based on location, volume, or date in a supplier’s draft negotiation response line.

Columns

Name Type Description
DraftSupplierNegotiationResponsesResponseNumber [KEY] Long The unique identifier for the negotiation response, linking it to a specific response within the negotiation line.
LinesLineId [KEY] Long The unique identifier for the negotiation line, linking the price break to a specific line item within the response.
LinesResponseNumber [KEY] Long The identifier for the response within the negotiation line, allowing for the price break to be associated with the correct response.
ResponseNumber [KEY] Long The unique identifier for the supplier’s response, helping to track and manage the specific offer made by the supplier.
LineId [KEY] Long The identifier for the negotiation line, allowing the price break to be associated with a particular item or service in the negotiation.
Line String The number that identifies the negotiation line, providing an easy reference to the specific item or service being negotiated.
PriceBreakId [KEY] Long The unique identifier for the price break, which is used to track the specific price reduction or discount applied to the negotiation line.
ShipToOrganizationId Long The identifier for the inventory organization to which the supplier will ship the item, ensuring the correct recipient organization is associated with the price break.
ShipToOrganization String The name of the inventory organization to which the supplier will ship the item, providing clarity on the destination for the goods.
ShipToLocationId Long The identifier for the location within the inventory organization to which the item will be shipped, specifying where the goods will be delivered.
ShipToLocation String The name of the location within the organization where the supplier will ship the item, providing further details about the delivery point.
Quantity Decimal The quantity of items that the price break applies to, specifying the minimum or applicable amount for the discount or reduced price.
ResponseValue Decimal The supplier's response value for the price break, indicating the price offered by the supplier for the specified quantity.
TargetPrice Decimal The target price for the price break, representing the price that the buyer expects or desires for the item in the negotiation line.
PriceBreakStartDate Date The date when the price break goes into effect, marking when the discount or reduced price becomes applicable.
PriceBreakEndDate Date The date when the price break expires, indicating the last day the price break is valid for the specified quantity.
PricingBasisCode String An abbreviation that identifies the method used to calculate the price break. Accepted values are defined in the 'PON_SHIPMENT_PRICING_BASIS' lookup.
PricingBasis String The basis used to calculate the price break, such as 'Per Unit', 'Cumulative', or other criteria defined in the 'PON_SHIPMENT_PRICING_BASIS' lookup.
CreatedBy String The user who created the price break record, providing accountability for the initial entry of the price break details.
CreationDate Datetime The timestamp when the price break record was created, establishing when the price break was first entered into the system.
LastUpdatedBy String The user who last updated the price break record, ensuring accountability for subsequent changes made to the price break.
LastUpdateDate Datetime The timestamp of the last update to the price break record, tracking when the record was last modified.
Finder String A search identifier used to locate specific price break records in the system.
EffectiveDate Date The date from which the price break is considered effective, marking when it starts to apply within the negotiation process.

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