JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF

The Flexfields for Resource Instances resource manages descriptive flexfields that contain details about the resource instance.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long ProcessWorkOrdersWorkOrderId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
ProcessworkorderresourceWorkOrderOperationResourceId [KEY] Long ProcessworkorderresourceWorkOrderOperationResourceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
ResourceinstanceWorkOrderOperationResourceInstanceId [KEY] Long ResourceinstanceWorkOrderOperationResourceInstanceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WoOpResourceInstanceId [KEY] Long Value that uniquely identifies an output of a work order operation resource instance. It's a primary key that the application generates when it creates the work order operation resource instance.
_FLEX_Context String Descriptive flexfield context name for work order operation resource instance.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for work order operation resource instance.
BackToBackFlag String BackToBackFlag of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
ContractMfgFlag String ContractMfgFlag of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
DueDays Int DueDays of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
Finder String Finder of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
FirmPlannedFlag String FirmPlannedFlag of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
InventoryItemId Long InventoryItemId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
ItemNumber String ItemNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
LastUpdateDate Datetime LastUpdateDate of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
MaterialItemId Long MaterialItemId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
OrganizationId Long OrganizationId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
PlannedCompletionDate Datetime PlannedCompletionDate of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
PlannedStartDate Datetime PlannedStartDate of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
ProductSerialId Long ProductSerialId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
ResourceId Long ResourceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
SerialNumber String SerialNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
SourceHeaderReferenceId Long SourceHeaderReferenceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
SourceHeaderRefId Long SourceHeaderRefId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
SourceLineReferenceId Long SourceLineReferenceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
SourceLineRefId Long SourceLineRefId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
SourceSystemId Long SourceSystemId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
Tolerance Int Tolerance of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WoProjectNumber String WoProjectNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WorkAreaId Long WorkAreaId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WorkCenterId Long WorkCenterId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WorkOrderId Long WorkOrderId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WorkOrderNumber String WorkOrderNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WorkOrderStatusId Long WorkOrderStatusId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
WoTaskNumber String WoTaskNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF

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