JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance

The Work Order Operation Resource Instances resource manages the instances of a work order operation. Each instance supports an equipment resource or labor resource.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkorderoperationWorkOrderOperationId [KEY] Long WorkorderoperationWorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkorderoperationresourceWorkOrderOperationResourceId [KEY] Long WorkorderoperationresourceWorkOrderOperationResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkOrderOperationResourceInstanceId [KEY] Long Value that uniquely identifies the resource instance of a work order operation resource. It is a primary key that the application generates when it creates the resource instance for the work order operation resource.
WorkOrderOperationResourceId Long Value that uniquely identifies the resource of a work order operation. It is a primary key that the application generates when it creates the resource for the work order operation.
WorkOrderOperationId Long WorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
LaborInstanceId Long Value that uniquely identifies the labor resource instance. It is a primary key that the application generates when it creates a labor instance.
LaborInstanceCode String Abbreviation that identifies the labor resource instance.
LaborInstanceName String LaborInstanceName of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
EquipmentInstanceId Long Value that uniquely identifies the equipment resource instance. It is a primary key that the application generates when it creates a equipment instance.
EquipmentInstanceCode String Abbreviation that identifies the equipment resource instance.
EquipmentInstanceName String EquipmentInstanceName of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ChargedQuantity Decimal ChargedQuantity of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ResourceType String ResourceType of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ProgramFileId Long Value that uniquely identifies the document item assigned to the master organization that represents the name of the program file used by the equipment.
ProgramFileName String Name of the program file associated with the automation equipment resource and used by the work order resource instance.
CurrentRevision String Value that uniquely identifies the current revision of the document item, which represents the current revision of the program file.
EquipmentParameterFileName String EquipmentParameterFileName of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
EquipmentParameterFileContent String EquipmentParameterFileContent of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WOOperationResourceInstanceDFF String WOOperationResourceInstanceDFF of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
DueDays Int DueDays of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
Finder String Finder of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ItemNumber String ItemNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ResourceId Long ResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
SerialNumber String SerialNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
Tolerance Int Tolerance of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance

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