JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

PurchaseAgreementImportRequestslinespriceBreaks

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
PurchaseAgreementImportRequestsInterfaceHeaderId [KEY] Long PurchaseAgreementImportRequestsInterfaceHeaderId of PurchaseAgreementImportRequestslinespriceBreaks
LinesInterfaceLineId [KEY] Long LinesInterfaceLineId of PurchaseAgreementImportRequestslinespriceBreaks
InterfaceLineLocationId [KEY] Long Value that uniquely identifies the agreement line interface price break.
InterfaceLineKey String Value that uniquely identifies the agreement line interface price break.
InterfaceLineLocationKey String Value that uniquely identifies the price break record and is unique for the load request.
PriceBreakNumber Decimal Value that uniquely identifies the price break referenced by this line.
ShipToLocation String Name of the location where the supplier ships the item.
ShipToLocationId Long Value that uniquely identifies the location where the supplier ships the shipment item.
ShipToOrganizationCode String Name of the inventory organization that receives the item.
ShipToOrganizationId Long Value that uniquely identifies the ship-to organization.
Quantity Decimal Value that identifies the price break quantity, when the price break is effective for blanket purchase orders.
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.
Attribute1 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute10 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute11 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute12 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute13 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute14 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute15 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute16 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute17 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute18 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute19 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute2 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute20 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute3 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute4 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute5 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute6 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute7 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute8 String Segment for the purchase agreement line price breaks descriptive flexfield.
Attribute9 String Segment for the purchase agreement line price breaks descriptive flexfield.
AttributeCategory String Category segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate1 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate10 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate2 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate3 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate4 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate5 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate6 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate7 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate8 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeDate9 Date Date segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber1 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber10 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber2 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber3 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber4 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber5 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber6 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber7 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber8 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeNumber9 Decimal Number segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp1 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp10 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp2 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp3 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp4 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp5 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp6 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp7 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp8 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
AttributeTimestamp9 Datetime Date and time segment for the purchase agreement line price breaks descriptive flexfield.
InterfaceHeaderId Long Value that uniquely identifies the interface header.
InterfaceLineId Long Value that uniquely identifies the interface line.
CreatedBy String CreatedBy of PurchaseAgreementImportRequestslinespriceBreaks
CreationDate Datetime CreationDate of PurchaseAgreementImportRequestslinespriceBreaks
LastUpdatedBy String LastUpdatedBy of PurchaseAgreementImportRequestslinespriceBreaks
LastUpdateDate Datetime LastUpdateDate of PurchaseAgreementImportRequestslinespriceBreaks
ProcessCode String ProcessCode of PurchaseAgreementImportRequestslinespriceBreaks
Finder String Finder of PurchaseAgreementImportRequestslinespriceBreaks

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