JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance

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 WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkorderresourceWorkOrderOperationResourceId [KEY] Long WorkorderresourceWorkOrderOperationResourceId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
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 WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
OrganizationId Long OrganizationId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
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 WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
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 WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
ChargedQuantity Decimal ChargedQuantity of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
ResourceType String ResourceType of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
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 WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
EquipmentParameterFileContent String EquipmentParameterFileContent of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
DueDays Int DueDays of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
Finder String Finder of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
ItemNumber String ItemNumber of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
ResourceId Long ResourceId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
SerialNumber String SerialNumber of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
Tolerance Int Tolerance of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance

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