Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

DraftPurchaseOrderslinesDFF

Holds descriptive flexfields for draft purchase order lines, capturing additional user-defined data points.

Columns

Name Type Description
DraftPurchaseOrdersPOHeaderId [KEY] Long The unique identifier for a draft purchase order header, linking it to the corresponding line distribution flexfield.
LinesPOLineId [KEY] Long The identifier for the specific line item in the purchase order that corresponds to this descriptive flexfield (DFF) record.
PoLineId [KEY] Long A unique identifier for the purchase order line within the DraftPurchaseOrderslinesDFF table, used to link the line to its associated details.
_FLEX_Context String The context name for the descriptive flexfield, which defines the specific data context for purchase order distributions.
_FLEX_Context_DisplayValue String The display value for the descriptive flexfield context, providing a user-friendly name or description of the context for purchase order distributions.
Finder String A search identifier used to locate specific descriptive flexfield records for purchase order lines.
Intent String Indicates the purpose or intended action related to the descriptive flexfield, such as creating, reviewing, or updating purchase order line details.
POHeaderId Long The purchase order header ID, linking the descriptive flexfield data to the corresponding purchase order header record.
SysEffectiveDate String The system’s effective date, indicating when the descriptive flexfield record for the purchase order line was created or last updated.
CUReferenceNumber Int An identifier used to link child aggregate records with their corresponding parent tables, ensuring consistency in hierarchical data.
EffectiveDate Date The date from which the descriptive flexfield data for the purchase order line is considered effective and valid.

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