ODBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF

The Flexfields for Resources resource manages descriptive flexfields that contain details about the resources that the work order operations use.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkorderoperationWorkOrderOperationId [KEY] Long WorkorderoperationWorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkorderoperationresourceWorkOrderOperationResourceId [KEY] Long WorkorderoperationresourceWorkOrderOperationResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WoOperationResourceId [KEY] Long Value that uniquely identifies a resource of a work order operation. It is a primary key that the application generates when it creates the work order operation resource.
_FLEX_Context String Descriptive flexfield context name for work order operation resources.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for work order operation resources.
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
DueDays Int DueDays of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
Finder String Finder of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
ItemNumber String ItemNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
ResourceId Long ResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
SerialNumber String SerialNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
Tolerance Int Tolerance of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060