JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseAgreementImportRequestslinespriceBreaks

Handles bulk or location-based pricing discounts in imported agreements, detailing cost variations for different purchase conditions.

Columns

Name Type Description
PurchaseAgreementImportRequestsInterfaceHeaderId [KEY] Long The unique identifier for the interface header related to the purchase agreement import request price breaks.
LinesInterfaceLineId [KEY] Long The unique identifier for the interface line associated with the price break of the purchase agreement.
InterfaceLineLocationId [KEY] Long The unique identifier for the agreement line's interface price break, linking it to the specific location of the price break.
InterfaceLineKey String The key that uniquely identifies the agreement line's interface price break, providing a reference for processing the price break data.
InterfaceLineLocationKey String A unique identifier for the price break record, used to track and manage the specific price break for the load request.
PriceBreakNumber Decimal The number that uniquely identifies the price break for the line item, helping to distinguish between multiple price breaks on the same line.
ShipToLocation String The name of the location where the supplier ships the item, providing context for logistics and shipping.
ShipToLocationId Long The unique identifier for the location where the supplier is instructed to ship the item specified on the purchase agreement.
ShipToOrganizationCode String The name of the inventory organization that receives the item, specifying where the goods should be sent within the organization.
ShipToOrganizationId Long The unique identifier for the organization responsible for receiving the shipment, distinguishing between different locations or entities.
Quantity Decimal The quantity of items that triggers the price break, indicating when the price reduction becomes applicable for the agreement line.
Price Decimal The unit price for the item or service on the purchase agreement line, after applying the price break discount.
DiscountPercent Decimal The discount percentage applied to the price, reducing the cost of the item or service based on the price break.
StartDate Date The date when the price break becomes effective, marking the start of the discount for the agreement line.
EndDate Date The date when the price break expires, after which the discount is no longer applicable for the agreement line.
Attribute1 String Custom segment for the price break's descriptive flexfield, used to store additional attribute data specific to the agreement line.
Attribute10 String Custom segment for the price break's descriptive flexfield, used to store additional attribute data specific to the agreement line.
Attribute11 String Custom segment for the price break's descriptive flexfield.
Attribute12 String Custom segment for the price break's descriptive flexfield.
Attribute13 String Custom segment for the price break's descriptive flexfield.
Attribute14 String Custom segment for the price break's descriptive flexfield.
Attribute15 String Custom segment for the price break's descriptive flexfield.
Attribute16 String Custom segment for the price break's descriptive flexfield.
Attribute17 String Custom segment for the price break's descriptive flexfield.
Attribute18 String Custom segment for the price break's descriptive flexfield.
Attribute19 String Custom segment for the price break's descriptive flexfield.
Attribute2 String Custom segment for the price break's descriptive flexfield.
Attribute20 String Custom segment for the price break's descriptive flexfield.
Attribute3 String Custom segment for the price break's descriptive flexfield.
Attribute4 String Custom segment for the price break's descriptive flexfield.
Attribute5 String Custom segment for the price break's descriptive flexfield.
Attribute6 String Custom segment for the price break's descriptive flexfield.
Attribute7 String Custom segment for the price break's descriptive flexfield.
Attribute8 String Custom segment for the price break's descriptive flexfield.
Attribute9 String Custom segment for the price break's descriptive flexfield.
AttributeCategory String The category segment for the purchase agreement line price breaks descriptive flexfield, allowing for classification of additional attributes.
AttributeDate1 Date Date segment for the price break's descriptive flexfield, allowing date-based attributes to be added.
AttributeDate10 Date Date segment for the price break's descriptive flexfield.
AttributeDate2 Date Date segment for the price break's descriptive flexfield.
AttributeDate3 Date Date segment for the price break's descriptive flexfield.
AttributeDate4 Date Date segment for the price break's descriptive flexfield.
AttributeDate5 Date Date segment for the price break's descriptive flexfield.
AttributeDate6 Date Date segment for the price break's descriptive flexfield.
AttributeDate7 Date Date segment for the price break's descriptive flexfield.
AttributeDate8 Date Date segment for the price break's descriptive flexfield.
AttributeDate9 Date Date segment for the price break's descriptive flexfield.
AttributeNumber1 Decimal Number segment for the price break's descriptive flexfield, allowing numeric attributes to be added for further classification.
AttributeNumber10 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber2 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber3 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber4 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber5 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber6 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber7 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber8 Decimal Number segment for the price break's descriptive flexfield.
AttributeNumber9 Decimal Number segment for the price break's descriptive flexfield.
AttributeTimestamp1 Datetime Timestamp segment for the price break's descriptive flexfield, allowing for date and time-based attributes to be added.
AttributeTimestamp10 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp2 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp3 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp4 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp5 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp6 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp7 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp8 Datetime Timestamp segment for the price break's descriptive flexfield.
AttributeTimestamp9 Datetime Timestamp segment for the price break's descriptive flexfield.
InterfaceHeaderId Long The unique identifier for the interface header, linking the price break data to the overall purchase agreement import request.
InterfaceLineId Long The unique identifier for the interface line, connecting the price break to a specific line item in the purchase agreement.
CreatedBy String The name of the person or system that created the price break record for the purchase agreement import request.
CreationDate Datetime The date and time when the price break record for the purchase agreement import request was created.
LastUpdatedBy String The name of the person or system that last updated the price break record for the purchase agreement import request.
LastUpdateDate Datetime The date and time when the price break record for the purchase agreement import request was last updated.
ProcessCode String The code identifying the process or action being executed for the purchase agreement import request price breaks.
Finder String The search function used to retrieve or filter the price break records for purchase agreement import requests.

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