Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

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 PurchaseAgreementsAgreementHeaderId of PurchaseAgreementslinespriceBreaks
LinesAgreementLineId [KEY] Long LinesAgreementLineId of PurchaseAgreementslinespriceBreaks
PriceBreakId [KEY] Long PriceBreakId of PurchaseAgreementslinespriceBreaks
PriceBreakNumber Decimal PriceBreakNumber of PurchaseAgreementslinespriceBreaks
LineNumber Decimal LineNumber of PurchaseAgreementslinespriceBreaks
ShipToOrganizationId Long ShipToOrganizationId of PurchaseAgreementslinespriceBreaks
ShipToOrganizationCode String ShipToOrganizationCode of PurchaseAgreementslinespriceBreaks
ShipToOrganization String ShipToOrganization of PurchaseAgreementslinespriceBreaks
LocationId Long LocationId of PurchaseAgreementslinespriceBreaks
LocationCode String LocationCode of PurchaseAgreementslinespriceBreaks
Location String Location of PurchaseAgreementslinespriceBreaks
Quantity Decimal Quantity of PurchaseAgreementslinespriceBreaks
UOMCode String UOMCode of PurchaseAgreementslinespriceBreaks
UOM String UOM of PurchaseAgreementslinespriceBreaks
Price Decimal Price of PurchaseAgreementslinespriceBreaks
DiscountPercent Decimal DiscountPercent of PurchaseAgreementslinespriceBreaks
StartDate Date StartDate of PurchaseAgreementslinespriceBreaks
EndDate Date EndDate of PurchaseAgreementslinespriceBreaks
CurrencyCode String CurrencyCode of PurchaseAgreementslinespriceBreaks
Currency String Currency of PurchaseAgreementslinespriceBreaks
CreatedBy String CreatedBy of PurchaseAgreementslinespriceBreaks
CreationDate Datetime CreationDate of PurchaseAgreementslinespriceBreaks
LastUpdatedBy String LastUpdatedBy of PurchaseAgreementslinespriceBreaks
LastUpdateDate Datetime LastUpdateDate of PurchaseAgreementslinespriceBreaks
AgreementHeaderId Long AgreementHeaderId of PurchaseAgreementslinespriceBreaks
Finder String Finder of PurchaseAgreementslinespriceBreaks

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