JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftPurchaseOrderslinesschedulesglobalDFFs

Houses global descriptive flexfields on draft PO schedules, meeting organizational or geographic compliance needs.

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 global descriptive flexfield (DFF).
LinesPOLineId [KEY] Long The unique identifier for the purchase order line, linking the DFF data to the relevant purchase order line schedule.
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 specific purchase order line schedule, linking the schedule to the relevant line item.
_FLEX_Context String The context for the DFF data, which defines the specific data context for purchase order distributions in the global scope.
_FLEX_Context_DisplayValue String The display value for the DFF context, providing a human-readable name or description of the context for the purchase order distribution.
Finder String A search identifier used to locate specific DFF records for purchase order line schedules within the global context.
Intent String Describes the intended action or purpose related to the DFF, such as creating, reviewing, or updating purchase order schedule details.
POHeaderId Long The purchase order header ID that links the DFF data for the purchase order line schedule to the corresponding purchase order header.
SysEffectiveDate String The system’s effective date, indicating when the DFF record for the purchase order line schedule was created or last updated.
CUReferenceNumber Int An identifier used to map child aggregate records to their corresponding parent tables, ensuring consistency in hierarchical data.
EffectiveDate Date The effective date of the DFF data, marking 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.9434