JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

PurchaseAgreementslines

Details of the goods or services to be purchased from the supplier. The line doesn't contain delivery dates or individual delivery quantities or amounts. For example, an agreement line can be service-based for installing a television or a goods item to negotiate the price for 50 laptops.

Columns

Name Type Description
PurchaseAgreementsAgreementHeaderId [KEY] Long PurchaseAgreementsAgreementHeaderId of PurchaseAgreementslines
AgreementLineId [KEY] Long AgreementLineId of PurchaseAgreementslines
LineNumber Decimal LineNumber of PurchaseAgreementslines
AgreementHeaderId Long AgreementHeaderId of PurchaseAgreementslines
AgreementNumber String AgreementNumber of PurchaseAgreementslines
ProcurementBUId Long ProcurementBUId of PurchaseAgreementslines
ProcurementBU String ProcurementBU of PurchaseAgreementslines
SupplierId Long SupplierId of PurchaseAgreementslines
Supplier String Supplier of PurchaseAgreementslines
SupplierSiteId Long SupplierSiteId of PurchaseAgreementslines
SupplierSite String SupplierSite of PurchaseAgreementslines
LineTypeId Long LineTypeId of PurchaseAgreementslines
LineType String LineType of PurchaseAgreementslines
ItemId Long ItemId of PurchaseAgreementslines
Item String Item of PurchaseAgreementslines
ItemRevision String ItemRevision of PurchaseAgreementslines
Description String Description of PurchaseAgreementslines
SupplierItem String SupplierItem of PurchaseAgreementslines
CategoryId Long CategoryId of PurchaseAgreementslines
CategoryCode String CategoryCode of PurchaseAgreementslines
Category String Category of PurchaseAgreementslines
StatusCode String StatusCode of PurchaseAgreementslines
Status String Status of PurchaseAgreementslines
UOMCode String UOMCode of PurchaseAgreementslines
UOM String UOM of PurchaseAgreementslines
Price Decimal Price of PurchaseAgreementslines
Amount Decimal Amount of PurchaseAgreementslines
CurrencyCode String CurrencyCode of PurchaseAgreementslines
Currency String Currency of PurchaseAgreementslines
ConsignmentLineFlag Bool ConsignmentLineFlag of PurchaseAgreementslines
NoteToSupplier String NoteToSupplier of PurchaseAgreementslines
AllowItemDescriptionUpdateFlag Bool AllowItemDescriptionUpdateFlag of PurchaseAgreementslines
PriceLimit Decimal PriceLimit of PurchaseAgreementslines
AllowPriceOverrideFlag Bool AllowPriceOverrideFlag of PurchaseAgreementslines
NegotiatedFlag Bool NegotiatedFlag of PurchaseAgreementslines
ExpirationDate Date ExpirationDate of PurchaseAgreementslines
MinimumReleaseAmount Decimal MinimumReleaseAmount of PurchaseAgreementslines
AgreementAmount Decimal AgreementAmount of PurchaseAgreementslines
AgreementQuantity Decimal AgreementQuantity of PurchaseAgreementslines
ReleasedAmount Decimal ReleasedAmount of PurchaseAgreementslines
PriceBreakTypeCode String PriceBreakTypeCode of PurchaseAgreementslines
SupplierItemAuxiliaryIdentifier String SupplierItemAuxiliaryIdentifier of PurchaseAgreementslines
ParentItemId Long ParentItemId of PurchaseAgreementslines
SupplierParentItem String SupplierParentItem of PurchaseAgreementslines
TopModelId Long TopModelId of PurchaseAgreementslines
SupplierTopModel String SupplierTopModel of PurchaseAgreementslines
UnNumberId Long UnNumberId of PurchaseAgreementslines
UnNumber String UnNumber of PurchaseAgreementslines
UNNumberDescription String UNNumberDescription of PurchaseAgreementslines
HazardClassId Long HazardClassId of PurchaseAgreementslines
HazardClassCode String HazardClassCode of PurchaseAgreementslines
HazardClass String HazardClass of PurchaseAgreementslines
AgingPeriodDays Int AgingPeriodDays of PurchaseAgreementslines
CreatedBy String CreatedBy of PurchaseAgreementslines
CreationDate Datetime CreationDate of PurchaseAgreementslines
LastUpdatedBy String LastUpdatedBy of PurchaseAgreementslines
LastUpdateDate Datetime LastUpdateDate of PurchaseAgreementslines
Finder String Finder of PurchaseAgreementslines

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