JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

PurchaseOrders

PurchaseOrders

Columns

Name Type Description
POHeaderId [KEY] Long POHeaderId of PurchaseOrders
OrderNumber String OrderNumber of PurchaseOrders
SoldToLegalEntityId Long SoldToLegalEntityId of PurchaseOrders
SoldToLegalEntity String SoldToLegalEntity of PurchaseOrders
StatusCode String StatusCode of PurchaseOrders
Status String Status of PurchaseOrders
ProcurementBUId Long ProcurementBUId of PurchaseOrders
ProcurementBU String ProcurementBU of PurchaseOrders
RequisitioningBUId Long RequisitioningBUId of PurchaseOrders
RequisitioningBU String RequisitioningBU of PurchaseOrders
BillToBUId Long BillToBUId of PurchaseOrders
BillToBU String BillToBU of PurchaseOrders
Revision Decimal Revision of PurchaseOrders
BuyerId Long BuyerId of PurchaseOrders
Buyer String Buyer of PurchaseOrders
SupplierId Long SupplierId of PurchaseOrders
Supplier String Supplier of PurchaseOrders
SupplierSiteId Long SupplierSiteId of PurchaseOrders
SupplierSite String SupplierSite of PurchaseOrders
SupplierContactId Long SupplierContactId of PurchaseOrders
SupplierContact String SupplierContact of PurchaseOrders
BillToLocationId Long BillToLocationId of PurchaseOrders
BillToLocation String BillToLocation of PurchaseOrders
ConversionRateType String ConversionRateType of PurchaseOrders
Ordered Decimal Ordered of PurchaseOrders
OrderedAmountBeforeAdjustments Decimal OrderedAmountBeforeAdjustments of PurchaseOrders
CreditAmount Decimal CreditAmount of PurchaseOrders
DiscountAmount Decimal DiscountAmount of PurchaseOrders
CurrencyCode String CurrencyCode of PurchaseOrders
Currency String Currency of PurchaseOrders
TotalTax Decimal TotalTax of PurchaseOrders
Total Decimal Total of PurchaseOrders
Description String Description of PurchaseOrders
MasterContractId Long MasterContractId of PurchaseOrders
MasterContractNumber String MasterContractNumber of PurchaseOrders
MasterContractTypeId Long MasterContractTypeId of PurchaseOrders
MasterContractType String MasterContractType of PurchaseOrders
RequiredAcknowledgmentCode String RequiredAcknowledgmentCode of PurchaseOrders
RequiredAcknowledgment String RequiredAcknowledgment of PurchaseOrders
SupplierOrder String SupplierOrder of PurchaseOrders
ReferenceNumber String ReferenceNumber of PurchaseOrders
AcknowledgmentDueDate Date AcknowledgmentDueDate of PurchaseOrders
PaymentTermsId Long PaymentTermsId of PurchaseOrders
PaymentTerms String PaymentTerms of PurchaseOrders
CarrierId Long CarrierId of PurchaseOrders
Carrier String Carrier of PurchaseOrders
ModeOfTransportCode String ModeOfTransportCode of PurchaseOrders
ModeOfTransport String ModeOfTransport of PurchaseOrders
ServiceLevelCode String ServiceLevelCode of PurchaseOrders
ServiceLevel String ServiceLevel of PurchaseOrders
ShippingMethod String ShippingMethod of PurchaseOrders
FreightTermsCode String FreightTermsCode of PurchaseOrders
FreightTerms String FreightTerms of PurchaseOrders
FOBCode String FOBCode of PurchaseOrders
FOB String FOB of PurchaseOrders
RequiresSignatureFlag Bool RequiresSignatureFlag of PurchaseOrders
AcknowledgeWithinDays Decimal AcknowledgeWithinDays of PurchaseOrders
BuyerManagedTransportFlag Bool BuyerManagedTransportFlag of PurchaseOrders
PayOnReceiptFlag Bool PayOnReceiptFlag of PurchaseOrders
ConfirmingOrderFlag Bool ConfirmingOrderFlag of PurchaseOrders
NoteToSupplier String NoteToSupplier of PurchaseOrders
NoteToReceiver String NoteToReceiver of PurchaseOrders
CreationDate Datetime CreationDate of PurchaseOrders
CreatedBy String CreatedBy of PurchaseOrders
LastUpdateDate Datetime LastUpdateDate of PurchaseOrders
LastUpdatedBy String LastUpdatedBy of PurchaseOrders
ImportSourceCode String ImportSourceCode of PurchaseOrders
OverridingApproverId Long OverridingApproverId of PurchaseOrders
OverridingApprover String OverridingApprover of PurchaseOrders
SupplierCommunicationMethod String SupplierCommunicationMethod of PurchaseOrders
SupplierBccEmailAddress String SupplierBccEmailAddress of PurchaseOrders
SupplierEmailAddress String SupplierEmailAddress of PurchaseOrders
SupplierFax String SupplierFax of PurchaseOrders
SupplierCcEmailAddress String SupplierCcEmailAddress of PurchaseOrders
OverrideB2BCommunicationFlag Bool OverrideB2BCommunicationFlag of PurchaseOrders
AdditionalContactEmail String AdditionalContactEmail of PurchaseOrders
Finder String Finder of PurchaseOrders
Intent String Intent of PurchaseOrders
SysEffectiveDate String SysEffectiveDate of PurchaseOrders

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