JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseOrderslinesDFF

Offers descriptive flexfields for purchase order lines, capturing extra information beyond the standard line fields.

Columns

Name Type Description
PurchaseOrdersPOHeaderId [KEY] Long The unique identifier for the purchase order header, linking the corresponding purchase order line DFF (Descriptive Flexfield) record to the main purchase order.
LinesPOLineId [KEY] Long The unique identifier for the purchase order line, which associates the descriptive flexfield data with a specific item or service in the purchase order.
PoLineId [KEY] Long The identifier for the purchase order line, linking the descriptive flexfield data to a particular line item within the purchase order.
_FLEX_Context String A system-generated context code that defines the context or the environment in which the flexfield data is being used or displayed in the application.
_FLEX_Context_DisplayValue String A human-readable version of the _FLEX_Context value, providing a descriptive label or name to indicate the specific context for the flexfield data.
Finder String A search or filter function used to locate specific flexfield records based on criteria defined in the finder field.
Intent String The purpose or intent behind the flexfield entry, used to clarify the objective or use of the data in relation to the purchase order line.
POHeaderId Long The unique identifier for the purchase order header, ensuring that the descriptive flexfield data is correctly associated with the right purchase order.
SysEffectiveDate String The system's effective date for the descriptive flexfield record, determining which version of the data is active and applicable during a given time period.
EffectiveDate Date The date from which the descriptive flexfield data is considered effective, marking when the data should be used in the system.

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