JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationResponseslinespriceBreaks

Defines tiered or location-based discounts proposed by suppliers, applied to negotiated line pricing.

Columns

Name Type Description
SupplierNegotiationResponsesResponseNumber [KEY] Long Unique identifier for the response within the supplier negotiation, linking the price break data to a specific response in the negotiation process.
LinesLineId [KEY] Long Unique identifier for the line item associated with the response, linking the price break data to a specific line in the negotiation.
LinesResponseNumber [KEY] Long Unique identifier for the line item response, used to track and reference the supplier’s offer or bid for a particular line item within the negotiation.
ResponseNumber [KEY] Long Unique identifier for the overall response, linking the price break data to a specific supplier’s overall offer in the negotiation.
LineId [KEY] Long Unique identifier for the line item, used to reference specific line items in the negotiation process and link them to their respective price breaks.
Line String The description or label for the line item, providing identification for the specific item in the supplier’s response.
PriceBreakId [KEY] Long Unique identifier for the price break associated with the line item, helping to track and reference specific price adjustments in the negotiation.
ShipToOrganizationId Long Unique identifier for the ship-to organization, linking the price break data to a specific organization responsible for receiving the goods.
ShipToOrganization String The name of the organization that will receive the goods associated with the price break, providing a reference for the recipient organization.
ShipToLocationId Long Unique identifier for the ship-to location, linking the price break data to a specific physical location where the goods will be delivered.
ShipToLocation String The name or description of the location to which the goods will be shipped, providing clarity on the delivery address for the price break.
Quantity Decimal The quantity associated with the price break, representing the amount of goods for which the price break applies.
PriceBreakPrice Decimal The price for the line item when the specified quantity is met, reflecting the price after applying the price break.
PriceBreakPriceDiscountPercent Decimal The discount percentage applied to the price at the specified quantity threshold, showing the percentage reduction in price due to the price break.
PriceBreakResponsePrice Decimal The price submitted by the supplier in response to the price break, indicating the price they are offering based on the quantity and terms of the price break.
TargetPrice Decimal The target price for the line item, representing the price the supplier aims to achieve or negotiate for the item based on the price break structure.
PriceBreakStartDate Date The start date of the price break, indicating when the price break becomes valid or starts to apply for the specified quantity.
PriceBreakEndDate Date The end date of the price break, indicating when the price break expires or is no longer valid for the specified quantity.
PricingBasisCode String Code representing the pricing basis for the price break, such as 'unit', 'volume', or 'bulk', indicating how the price break is structured.
PricingBasis String Description of the pricing basis, explaining how the price break is calculated or applied (for example, 'per unit', 'per volume', 'for bulk orders').
CreatedBy String The name or identifier of the user who created the price break record, ensuring accountability for data entry.
CreationDate Datetime The date and time when the price break record was created, providing a timestamp for when the price break was initially entered into the system.
LastUpdateBy String The name or identifier of the user who last updated the price break record, ensuring accountability for changes made to the record.
LastUpdateDate Datetime The date and time when the price break record was last updated, providing a timestamp for the most recent change.
Finder String Search or query reference related to the SupplierNegotiationResponseslinespriceBreaks, used for filtering or looking up specific price break records in the negotiation process.

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