Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderResource

Manages resources such as labor and machinery required to execute work orders effectively.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier for the work order associated with this resource. This identifier ensures proper tracking of resource allocations within the work order.
OrganizationId Long The identifier for the organization managing this work order resource. This identifier supports tracking and allocation of resources across multiple business units.
ResourceSequenceNumber Decimal The sequence number that determines the order in which resources are allocated for the work order operation. This number ensures correct scheduling of resources.
WorkOrderOperationResourceId [KEY] Long The unique identifier for the specific resource assigned to the work order operation. This identifier supports resource tracking and utilization monitoring.
ResourceId Long The unique identifier for the resource (for example, 'machine', 'tool', or 'labor') allocated to this work order. This identifier links the resource to specific production processes.
ResourceCode String The abbreviation or code assigned to the resource. This abbreviation helps in quick identification and reference within the production system.
ResourceDescription String A description of the resource, providing details about its function or purpose within the work order operation.
ResourceName String The name of the resource allocated to the work order. This name helps in resource planning and identification.
ResourceType String The classification of the resource (for example, 'labor', 'machine', 'tool'). This classification helps in categorizing resources for efficient planning and utilization.
WorkAreaId Long The unique identifier for the work area where this resource is used. This identifier ensures proper allocation of resources within specific production zones.
WorkAreaName String The name of the work area where this resource is assigned. This name helps in organizing and managing resources within different operational areas.
WorkAreaCode String The code that represents the work area where the resource is used. This code provides quick identification within the production environment.
WorkAreaDescription String A description of the work area associated with this resource. This description helps in understanding the specific location of resource usage.
WorkCenterId Long The unique identifier for the work center where this resource is used. This identifier supports accurate tracking of resource allocation within production facilities.
WorkCenterName String The name of the work center where this resource is used. This name helps in organizing and managing work centers efficiently.
WorkCenterCode String The code assigned to the work center. This code supports quick reference and identification of work centers within the system.
WorkCenterDescription String A description of the work center associated with this resource. This description helps provide context on its role in the production process.
WorkOrderId Long The unique identifier for the work order that requires this resource. This identifier ensures alignment of resources with specific work order requirements.
WorkOrderOperationId Long The unique identifier for the work order operation that requires this resource. This identifier links resources to specific steps in the production workflow.
OperationSequenceNumber Decimal The sequence number defining the order in which the work order operations are performed. This number ensures resource allocation follows the correct process flow.
OperationName String The name of the operation where this resource is used. This name provides clarity on the role of the resource in the work order process.
StandardOperationId Long The unique identifier for the standard operation referenced in the work order. This identifier links resources to predefined operation workflows.
StandardOperationCode String The abbreviation that identifies the standard operation. This abbreviation ensures consistency in resource allocation across similar operations.
PrincipalFlag Bool Indicates whether this resource is the principal resource for the operation. If this value is 'true', this is the main resource required for execution.
UsageRate Decimal The predefined rate at which the resource is used per unit of production. This rate supports cost tracking and resource planning.
BasisType String Indicates whether the resource usage is fixed (for example, 'per batch') or variable (for example, 'per unit produced'). This field helps define the allocation method.
RequiredUsage Decimal The total amount of resource usage required to complete the operation based on the planned production quantity.
InverseRequiredUsage Decimal The inverse of the usage rate, which can be useful when working with fractional usage measurements.
UOMCode String The unit of measure (UMC) code associated with the resource usage (for example, 'Hours' or 'Pieces'). This code ensures consistency in tracking and reporting.
UnitOfMeasure String The full name of the unit of measure assigned to this resource (for example, 'Hours' or 'Kilograms'). This name provides a clearer reference to resource consumption.
ChargeType String Indicates whether resource charges are automatically generated and at what stage. This field helps in tracking production costs accurately.
AssignedUnits Decimal The number of units of the resource assigned to the work order operation. This metric ensures appropriate resource allocation for production.
PlannedStartDate Datetime The planned date and time when this resource is scheduled to start work on the operation. These metrics help in scheduling and resource management.
PlannedCompletionDate Datetime The planned date and time for completing work with this resource. These metrics ensure proper alignment with work order timelines.
ResourceActivityCode String The code identifying the specific activity performed by this resource within the work order operation. This code supports detailed tracking of resource activities.
ScheduledIndicator String Indicates whether the resource is scheduled by the system. Possible values are 'Yes' (scheduled) or 'No' (not scheduled). This field ensures proper resource planning and allocation.
PhantomFlag Bool Indicates whether this resource is a phantom resource. If this value is 'true', the resource is used for reporting purposes but does not physically exist in the work order.
ActualResourceUsage Decimal The actual amount of the resource consumed during the work order execution. This metric helps track resource use against planned usage.
CreatedBy String The user who created this work order resource record. This field provides an audit trail for tracking changes and ownership.
CreationDate Datetime The date and time when this work order resource record was created. These metrics support historical tracking and audit compliance.
LastUpdateDate Datetime The date and time when this work order resource record was last updated. These metrics ensure visibility into recent changes.
LastUpdatedBy String The user who last modified this work order resource record. This field helps maintain accountability and traceability.
ProfileId Long The unique identifier for the job profile associated with the work order resource. This identifier helps in linking resources to specific job roles.
ProfileCode String The code representing the job profile associated with this resource. This code ensures standardized role assignments for work order resources.
EquipmentProfileId Long The unique identifier for the equipment profile associated with this resource. This identifier helps in linking specific equipment settings to the work order resource.
EquipmentProfileCode String The code representing the equipment profile assigned to this resource. This code supports tracking of specialized equipment usage.
BackToBackFlag String Indicates whether this resource is used in a back-to-back manufacturing process. This flag ensures direct linkage between supply and demand.
ContractMfgFlag String Indicates whether this resource is associated with a contract manufacturing process. This flag helps track outsourced production activities.
DueDays Int The number of days remaining until the planned completion of the work order operation involving this resource. This metric supports scheduling and timely execution.
Finder String A search key or identifier used to quickly locate specific work order resource records in the system.
FirmPlannedFlag String Indicates whether the resource requirement is firm-planned, meaning it is locked and not subject to modifications.
InventoryItemId Long The unique identifier for the inventory item associated with this resource. This identifier supports material tracking within work order execution.
ItemNumber String The specific item number associated with this resource. This number ensures proper traceability in inventory and production processes.
MaterialItemId Long The unique identifier for the material associated with this resource. This identifier helps in managing material flow within work orders.
ProductSerialId Long The unique identifier for the serialized product associated with this resource. This identifier supports tracking of serialized inventory.
SerialNumber String The serial number of the product or material associated with this work order resource. This serial number ensures precise tracking and compliance with serialized inventory requirements.
SourceHeaderReferenceId Long The reference identifier linking this resource to the source document's header (for example, 'purchase order' or 'production plan').
SourceHeaderRefId Long An alternate reference identifier for the source header, ensuring compatibility with external systems or legacy integrations.
SourceLineReferenceId Long The reference identifier linking this resource to a specific line item in the source document (for example, 'purchase order line' or 'bill of materials line').
SourceLineRefId Long An alternate reference identifier for the source line. This identifier supports integration with external systems and ensuring accurate tracking of resources.
SourceSystemId Long The identifier for the external system from which this work order resource data originates. This identifier ensures proper synchronization of data across platforms.
Tolerance Int The allowable tolerance for variations in resource usage or allocation. This metric helps maintain flexibility while ensuring production efficiency.
WoProjectNumber String The project number associated with this work order resource. This number links resource allocations to broader project tracking and reporting.
WorkOrderNumber String The user-friendly work-order number associated with this resource. This number ensures traceability and simplifies production reporting.
WorkOrderStatusId Long The unique identifier representing the current status of the work order (for example, 'Planned,' 'In Progress' or 'Completed'). This identifier helps track resource allocation in relation to work order execution.
WoTaskNumber String The task number within the work order associated with this resource. This number links resources to specific tasks within the overall production process.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175