Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

ProcessWorkOrdersProcessWorkOrderResourceResourceInstance

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

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long ProcessWorkOrdersWorkOrderId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
ProcessworkorderresourceWorkOrderOperationResourceId [KEY] Long ProcessworkorderresourceWorkOrderOperationResourceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WorkOrderOperationResourceInstanceId [KEY] Long Value that uniquely identifies the resource instance of a work order operation resource. It's 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's a primary key that the application generates when it creates the resource for the work order operation.
WorkOrderOperationId Long WorkOrderOperationId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WorkOrderId Long WorkOrderId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
OrganizationId Long OrganizationId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
LaborInstanceId Long Value that uniquely identifies the labor resource instance. It's 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 ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
EquipmentInstanceId Long Value that uniquely identifies the equipment resource instance. It's 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 ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
ChargedQuantity Decimal ChargedQuantity of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
ResourceType String ResourceType of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
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 ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
EquipmentParameterFileContent String EquipmentParameterFileContent of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
BackToBackFlag String BackToBackFlag of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
ContractMfgFlag String ContractMfgFlag of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
DueDays Int DueDays of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
Finder String Finder of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
FirmPlannedFlag String FirmPlannedFlag of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
InventoryItemId Long InventoryItemId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
ItemNumber String ItemNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
LastUpdateDate Datetime LastUpdateDate of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
MaterialItemId Long MaterialItemId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
PlannedCompletionDate Datetime PlannedCompletionDate of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
PlannedStartDate Datetime PlannedStartDate of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
ProductSerialId Long ProductSerialId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
ResourceId Long ResourceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
SerialNumber String SerialNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
SourceHeaderReferenceId Long SourceHeaderReferenceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
SourceHeaderRefId Long SourceHeaderRefId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
SourceLineReferenceId Long SourceLineReferenceId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
SourceLineRefId Long SourceLineRefId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
SourceSystemId Long SourceSystemId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
Tolerance Int Tolerance of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WoProjectNumber String WoProjectNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WorkAreaId Long WorkAreaId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WorkCenterId Long WorkCenterId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WorkOrderNumber String WorkOrderNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WorkOrderStatusId Long WorkOrderStatusId of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance
WoTaskNumber String WoTaskNumber of ProcessWorkOrdersProcessWorkOrderResourceResourceInstance

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