JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseAgreementLinespriceBreaks

Displays volume-based or location-based price variations for each agreement line, providing cost details beyond the base unit price.

Columns

Name Type Description
PurchaseAgreementLinesAgreementLineId [KEY] Long The unique identifier for the agreement line in the purchase agreement, linking the price break to a specific item or service.
PriceBreakId [KEY] Long The unique identifier for the price break record, distinguishing different price breaks applied to the agreement line.
PriceBreakNumber Decimal The number assigned to the price break, helping to identify and order multiple price breaks within the same agreement line.
LineNumber Decimal The line number within the purchase agreement associated with the price break, helping to track and organize the price breaks on individual lines.
ShipToOrganizationId Long The unique identifier for the organization that will receive the item, ensuring correct shipping and logistics for the price break.
ShipToOrganizationCode String The code identifying the ship-to organization, used for internal classification and processing of shipping information.
ShipToOrganization String The name of the organization receiving the shipment, clarifying where the items covered by the price break will be delivered.
LocationId Long The unique identifier for the location where the item covered by the price break will be delivered, aiding in shipping and inventory management.
LocationCode String The code for the location receiving the shipment, used to manage shipping and ensure items are delivered to the correct destination.
Location String The name of the location where the item is delivered, providing a clear description of the delivery site for the price break.
Quantity Decimal The quantity of items required to trigger the price break, indicating the minimum number of units that must be purchased to receive the discount.
UOMCode String The unit of measure code for the price break, indicating how the quantity is measured (for example, 'EA' for each, 'KG' for kilogram).
UOM String The unit of measure for the price break, specifying how the quantity of items is quantified (for example, 'each,' 'kg,' 'box').
Price Decimal The unit price for the item after the price break has been applied, indicating the discounted price that will be charged.
DiscountPercent Decimal The percentage discount applied to the original price of the item, reflecting the savings gained through the price break.
StartDate Date The date on which the price break becomes effective, indicating when the discount will start to apply.
EndDate Date The date after which the price break expires, indicating when the discount will no longer be valid for the agreement line.
CurrencyCode String The currency code in which the price and discount are stated, ensuring consistency in financial terms for the price break.
Currency String The name of the currency in which the price and discount are expressed, making the terms more understandable (for example, USD, EUR).
CreatedBy String The name of the person or system that created the price break record, providing accountability for the entry.
CreationDate Datetime The date and time when the price break record was created, providing a historical record for tracking and auditing.
LastUpdatedBy String The name of the person or system that last updated the price break record, ensuring accountability for changes made.
LastUpdateDate Datetime The date and time when the price break record was last updated, helping to track the most recent changes.
AgreementLineId Long The unique identifier for the agreement line associated with the price break, linking the price break to the specific item or service in the purchase agreement.
Finder String The search function or query used to retrieve or filter price break records based on specified criteria such as quantity, price, or location.

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