JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftPurchaseOrdersDFF

Captures descriptive flexfields specific to draft purchase orders, accommodating custom procurement data.

Columns

Name Type Description
DraftPurchaseOrdersPOHeaderId [KEY] Long The unique identifier for a draft purchase order header in the DraftPurchaseOrdersDFF table.
PoHeaderId [KEY] Long A unique identifier for the purchase order, used to associate the details of the order with the corresponding header.
ContractType String Specifies the type of contract associated with the purchase order in the DraftPurchaseOrdersDFF table.
Contractnumber String The contract number that corresponds to the purchase order, used for linking to the specific agreement or contract.
_FLEX_Context String The context name for the descriptive flexfield (DFF) related to purchase order distributions, enabling flexible data capture for the order.
Finder String A search identifier used to locate specific records in the context of the purchase order data.
Intent String Describes the intended action or purpose of the transaction, such as creating, updating, or reviewing a purchase order.
SysEffectiveDate String The system's effective date, indicating when the purchase order record was created or last modified in the system.
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 specified resources, such as the purchase order details, are considered effective and valid.

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