ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

PurchaseAgreementslinespriceBreaks

Agreement price breaks are reductions in the price of an item depending on certain conditions such as purchasing in bulk or from a certain location. For example, for a laptop, price will be reduced by 100 dollars if your order exceeds 20 quantity or 30 dollars if you order for a specific location.

Columns

Name Type Description
PurchaseAgreementsAgreementHeaderId [KEY] Long Value that uniquely identifies the purchase agreement.
LinesAgreementLineId [KEY] Long Value that uniquely identifies the agreement line.
PriceBreakId [KEY] Long Value that uniquely identifies the price break referenced by this line.
PriceBreakNumber Decimal Number that uniquely identifies the price break on the purchase agreement line.
LineNumber Decimal Value that uniquely identifies the purchase order or agreement line.
ShipToOrganizationId Long Value that uniquely identifies the ship-to organization.
ShipToOrganizationCode String Abbreviation that identifies the ship-to organization.
ShipToOrganization String Name of the inventory organization that receives the item.
LocationId Long Value that uniquely identifies the location where the supplier ships the shipment item.
LocationCode String Abbreviation that identifies the location where the supplier ships the item.
Location String Name of the location where the supplier ships the item.
Quantity Decimal Value that identifies the price break quantity, when the price break is effective for blanket purchase orders.
UOMCode String Code that identifies the unit of measure.
UOM String Abbreviation that identifies the unit of measure on the agreement line price break.
Price Decimal Unit price for the line.
DiscountPercent Decimal Value that identifies the discount percentage for the price break.
StartDate Date Date on which the agreement becomes effective.
EndDate Date Date after which the purchase agreement is no longer valid.
CurrencyCode String Code that identifies the currency on the agreement line price break.
Currency String Currency on the agreement line price break.
CreatedBy String User who created the price breaks for a purchase agreement line.
CreationDate Datetime Date and time when the buyer or application created the price breaks for a purchase agreement line.
LastUpdatedBy String User who last updated the price breaks on a purchase agreement line.
LastUpdateDate Datetime Date when the price break was last updated.
AgreementHeaderId Long agreementheaderid
Finder String finder
EffectiveDate Date This query parameter is used to fetch resources which are effective dated as of the specified start date.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111