Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

DraftPurchaseOrderslinesschedulesDFF

Provides descriptive flexfields for schedules on a draft purchase order, supporting custom scheduling details.

Columns

Name Type Description
DraftPurchaseOrdersPOHeaderId [KEY] Long The unique identifier for a draft purchase order header, linking it to the corresponding purchase order line schedule in the DraftPurchaseOrderslinesschedulesDFF table.
LinesPOLineId [KEY] Long The unique identifier for the specific purchase order line, linking this descriptive flexfield data to the relevant purchase order line.
SchedulesLineLocationId [KEY] Long The identifier for the location associated with the purchase order schedule line, used to track where the schedule is to be fulfilled.
LineLocationId [KEY] Long The identifier for the purchase order schedule, which links the schedule to the purchase order line.
_FLEX_Context String The context name for the descriptive flexfield, used to define the specific data context for purchase order distributions, enabling flexible data entry.
_FLEX_Context_DisplayValue String The display value for the descriptive flexfield context, providing a human-readable 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 line schedules.
Intent String Indicates the purpose or intended action related to the descriptive flexfield, such as creating, reviewing, or updating purchase order schedule details.
POHeaderId Long The purchase order header ID, linking the descriptive flexfield data for the purchase order schedule to the corresponding purchase order header.
SysEffectiveDate String The system’s effective date, representing when the descriptive flexfield record for the purchase order schedule was created or last updated.
CUReferenceNumber Int An identifier used to link child aggregate records with their corresponding parent tables, ensuring data consistency in hierarchical structures.
EffectiveDate Date The effective date of the descriptive flexfield data, indicating when the schedule information becomes valid or active in relation to the purchase order.

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