JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

PurchaseOrderslines

PurchaseOrderslines

Columns

Name Type Description
PurchaseOrdersPOHeaderId [KEY] Long PurchaseOrdersPOHeaderId of PurchaseOrderslines
POLineId [KEY] Long POLineId of PurchaseOrderslines
POHeaderId Long POHeaderId of PurchaseOrderslines
LineNumber Decimal LineNumber of PurchaseOrderslines
OrderNumber String OrderNumber of PurchaseOrderslines
LineTypeId Long LineTypeId of PurchaseOrderslines
LineType String LineType of PurchaseOrderslines
ItemId Long ItemId of PurchaseOrderslines
Item String Item of PurchaseOrderslines
ConsignmentLineFlag Bool ConsignmentLineFlag of PurchaseOrderslines
ItemRevision String ItemRevision of PurchaseOrderslines
Description String Description of PurchaseOrderslines
SupplierItem String SupplierItem of PurchaseOrderslines
SupplierConfigurationId String SupplierConfigurationId of PurchaseOrderslines
CategoryId Long CategoryId of PurchaseOrderslines
CategoryCode String CategoryCode of PurchaseOrderslines
Category String Category of PurchaseOrderslines
StatusCode String StatusCode of PurchaseOrderslines
Status String Status of PurchaseOrderslines
UOMCode String UOMCode of PurchaseOrderslines
UOM String UOM of PurchaseOrderslines
Quantity Decimal Quantity of PurchaseOrderslines
BasePrice Decimal BasePrice of PurchaseOrderslines
DiscountType String DiscountType of PurchaseOrderslines
Discount Decimal Discount of PurchaseOrderslines
DiscountReason String DiscountReason of PurchaseOrderslines
Price Decimal Price of PurchaseOrderslines
NegotiatedFlag Bool NegotiatedFlag of PurchaseOrderslines
CurrencyCode String CurrencyCode of PurchaseOrderslines
Currency String Currency of PurchaseOrderslines
WorkOrderProduct String WorkOrderProduct of PurchaseOrderslines
NoteToSupplier String NoteToSupplier of PurchaseOrderslines
UNNumberId Long UNNumberId of PurchaseOrderslines
UNNumber String UNNumber of PurchaseOrderslines
UNNumberDescription String UNNumberDescription of PurchaseOrderslines
HazardClassCode String HazardClassCode of PurchaseOrderslines
HazardClassId Long HazardClassId of PurchaseOrderslines
HazardClass String HazardClass of PurchaseOrderslines
Ordered Decimal Ordered of PurchaseOrderslines
TotalTax Decimal TotalTax of PurchaseOrderslines
Total Decimal Total of PurchaseOrderslines
SourceAgreementId Long SourceAgreementId of PurchaseOrderslines
SourceAgreementNumber String SourceAgreementNumber of PurchaseOrderslines
SourceAgreementLineId Long SourceAgreementLineId of PurchaseOrderslines
SourceAgreementLine Decimal SourceAgreementLine of PurchaseOrderslines
SourceAgreementTypeCode String SourceAgreementTypeCode of PurchaseOrderslines
SourceAgreementType String SourceAgreementType of PurchaseOrderslines
SourceAgreementProcurementBUId Long SourceAgreementProcurementBUId of PurchaseOrderslines
SourceAgreementProcurementBU String SourceAgreementProcurementBU of PurchaseOrderslines
MaximumRetainageAmount Decimal MaximumRetainageAmount of PurchaseOrderslines
Manufacturer String Manufacturer of PurchaseOrderslines
ManufacturerPartNumber String ManufacturerPartNumber of PurchaseOrderslines
CreationDate Datetime CreationDate of PurchaseOrderslines
CreatedBy String CreatedBy of PurchaseOrderslines
LastUpdateDate Datetime LastUpdateDate of PurchaseOrderslines
LastUpdatedBy String LastUpdatedBy of PurchaseOrderslines
PricingUOM String PricingUOM of PurchaseOrderslines
PricingUOMCode String PricingUOMCode of PurchaseOrderslines
SecondaryUOM String SecondaryUOM of PurchaseOrderslines
SecondaryUOMCode String SecondaryUOMCode of PurchaseOrderslines
SecondaryQuantity String SecondaryQuantity of PurchaseOrderslines
Finder String Finder of PurchaseOrderslines
Intent String Intent of PurchaseOrderslines
SysEffectiveDate String SysEffectiveDate of PurchaseOrderslines

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