JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseOrdersglobalDFFs

Houses global descriptive flexfields used across purchase orders to accommodate standardized international or enterprise data.

Columns

Name Type Description
PurchaseOrdersPOHeaderId [KEY] Long The unique identifier for the purchase order header, linking the global descriptive flexfield (DFF) attributes to the corresponding purchase order.
PoHeaderId [KEY] Long The unique identifier for the purchase order header, used to associate the global DFF data with a specific purchase order.
_FLEX_Context String The context for the global descriptive flexfield, indicating the specific business context in which the data is entered or used (for example, 'Purchase Order,' 'Supplier Agreement').
_FLEX_Context_DisplayValue String The display value of the context for the global descriptive flexfield, providing a human-readable label for the context in which the DFF data applies.
Finder String The search function or query used to locate or filter global DFF records for purchase orders, enabling users to retrieve specific data based on criteria.
Intent String The purpose or intent of the purchase order, specifying whether it is for immediate purchase, contract fulfillment, or other procurement objectives.
SysEffectiveDate String The system effective date used to determine the active version of the global DFF data, ensuring that the correct data is retrieved based on the effective period.
EffectiveDate Date The date from which the global DFF data is considered effective, marking when the descriptive attributes of the purchase order are valid.

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