JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

PurchaseAgreementLines

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

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