Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

DraftSupplierNegotiationResponseslinespriceBreaks

The Price Breaks resource captures a supplier's price breaks for the line based on location, quantity, or date.

Columns

Name Type Description
DraftSupplierNegotiationResponsesResponseNumber [KEY] Long Value that uniquely identifies the negotiation response in a line.
LinesLineId [KEY] Long Value that uniquely identifies the negotiation response line.
LinesResponseNumber [KEY] Long Value that uniquely identifies the negotiation response in a line.
ResponseNumber [KEY] Long Value that identifies the supplier response.
LineId [KEY] Long Value that identifies the negotiation line.
Line String Number that identifies the negotiation line.
PriceBreakId [KEY] Long Date when the price break goes into effect.
ShipToOrganizationId Long Value that uniquely identifies the inventory organization to which the supplier ships the item.
ShipToOrganization String Name of the inventory organization to which the supplier ships the item.
ShipToLocationId Long Value that uniquely identifies the location to which the supplier ships the item.
ShipToLocation String Name of the location to which the supplier ships the item.
Quantity Decimal Quantity for the price break.
ResponseValue Decimal Response value of the price break.
TargetPrice Decimal Target price for the price break.
PriceBreakStartDate Date Date when the price break goes into effect.
PriceBreakEndDate Date Date when the price break expires.
PricingBasisCode String Abbreviation that identifies the basis that the application uses to calculate the response line price break. A list of accepted values is defined in the lookup type PON_SHIPMENT_PRICING_BASIS.
PricingBasis String Basis that the application uses to calculate the price break. A list of accepted values is defined in the lookup type PON_SHIPMENT_PRICING_BASIS.
CreatedBy String Identifies the user who created the row.
CreationDate Datetime Timestamp of the creation of the row.
LastUpdatedBy String User who most recently updated the line.
LastUpdateDate Datetime Date and time when the user most recently updated the line.
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