JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseOrdersLOV

Provides a quick search interface for existing purchase orders, aiding users in referencing or reusing prior orders.

Columns

Name Type Description
OrderNumber String The unique identifier for the purchase order in the PurchaseOrdersLOV table, representing the order number assigned to the purchase order.
POHeaderId [KEY] Long The unique identifier for the purchase order header in the PurchaseOrdersLOV table, linking to the overall purchase order record.
Supplier String The name or description of the supplier associated with the purchase order in the PurchaseOrdersLOV table.
SupplierId Long The unique identifier for the supplier in the PurchaseOrdersLOV table, used to reference the specific supplier providing goods or services.
SupplierSite String The name or code representing the specific site of the supplier from which goods or services are provided for the purchase order.
SupplierSiteId Long The unique identifier for the supplier site, used to link the purchase order to a specific supplier location.
BillToBU String The business unit responsible for receiving the invoice related to the purchase order in the PurchaseOrdersLOV table.
BillToBUId Long The unique identifier for the business unit that will receive the invoice for the purchase order.
Buyer String The name or identifier of the individual or role responsible for managing the purchase order within the organization.
BuyerId Long The unique identifier for the buyer responsible for the purchase order in the PurchaseOrdersLOV table.
Currency String The name or type of currency (for example, USD, EUR) used in the financial transactions of the purchase order.
CurrencyCode String The currency code (for example, USD, EUR) used for the purchase order, representing the type of currency in which the order is processed.
SoldToLegalEntity String The name of the legal entity to which the purchase order is billed or sold.
SoldToLegalEntityId Long The unique identifier for the legal entity associated with the sold-to entity of the purchase order.
Description String A description or additional information about the purchase order, often providing more context on the order’s purpose or content.
PaymentTerms String The payment terms associated with the purchase order, such as 'Net 30', indicating when payment for the order is due.
PaymentTermsId Long The unique identifier for the payment terms, used to link the purchase order to specific payment terms in the system.
Status String The current status of the purchase order, such as 'Open', 'Closed', or 'Pending', representing the state of the order.
StatusCode String A code representing the status of the purchase order for internal processing and tracking.
Finder String A placeholder or reference for the search functionality within the system, allowing for easy lookup of purchase orders based on specified criteria.
Intent String A placeholder or reference defining the action or purpose of the purchase order data, such as 'Create', 'Update', or 'Delete'.
SysEffectiveDate String The system-effective date indicating when the purchase order data became active or valid in the system.
EffectiveDate Date The date from which the purchase order data is considered effective, typically used as a filter to retrieve records within a valid date range.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434