ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

PurchaseOrdersDFF

Captures additional descriptive flexfield data at the purchase order header level, allowing custom fields.

Columns

Name Type Description
PurchaseOrdersPOHeaderId [KEY] Long The unique identifier for the purchase order header, linking the descriptive flexfield (DFF) attributes to the purchase order header.
PoHeaderId [KEY] Long The unique identifier for the purchase order header, used to link the DFF data to a specific purchase order.
ContractType String The type of contract associated with the purchase order, specifying whether it is a fixed price, time and materials, or another type of contract.
Contractnumber String The contract number associated with the purchase order, providing a reference to the contract governing the terms of the purchase.
_FLEX_Context String The context for the descriptive flexfield, indicating the specific business context in which the data is entered or used (for example, 'Purchase Order,' 'Supplier Agreement').
Finder String The search function or query used to locate or filter purchase orders DFF records, helping users retrieve specific data based on defined criteria.
Intent String The intent behind the purchase order, specifying whether it is for immediate purchase, contract fulfillment, or another procurement purpose.
SysEffectiveDate String The system effective date used to determine the active version of the DFF record, ensuring that the data retrieved corresponds to the correct period.
EffectiveDate Date The date from which the DFF data is considered effective, determining when the descriptive attributes of the purchase order become valid.

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