ProcessWorkOrdersProcessWorkOrderResource
Tracks resources utilized during work order operations, including labor and equipment.
Columns
Name | Type | Description |
ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order to its resource details, enabling tracking of resources used in production. |
OrganizationId | Long | The unique identifier for the organization where the resource is used, representing a specific manufacturing plant or facility. |
ResourceSequenceNumber | Decimal | Specifies the sequence number of the resource in the operation, determining the order in which resources are used. |
WorkOrderOperationResourceId [KEY] | Long | The unique identifier for the specific resource assigned to the work order operation. This identifier ensures accurate tracking of resource usage. |
ResourceId | Long | The unique identifier for the resource, such as equipment or personnel, used in the operation. This identifier tracks resource allocation and utilization. |
ResourceCode | String | The code assigned to the resource, enabling quick identification and reference in production processes. |
ResourceDescription | String | A detailed description of the resource, including its function or role in the operation. |
ResourceName | String | The name of the resource, such as the name of a machine or the designation of a worker assigned to the operation. |
ResourceType | String | Specifies the type of resource, such as 'Labor,' 'Machine,' or 'Tool,' categorizing the resource for planning and reporting. |
WorkAreaId | Long | The unique identifier for the work area where the resource is used. This identifier helps in organizing resources by production zones. |
WorkAreaName | String | The name of the work area where the resource is located, such as 'Welding Station' or 'Assembly Line 1.' |
WorkAreaCode | String | A shorthand code representing the work area where the resource is used. |
WorkAreaDescription | String | A detailed description of the work area, including its resources and production capabilities. |
WorkCenterId | Long | The unique identifier for the work center where the resource is assigned. A work center groups resources dedicated to specific tasks. |
WorkCenterName | String | The name of the work center where the resource is used (for example, 'CNC Machining Center'). |
WorkCenterCode | String | The code assigned to the work center, enabling quick identification and reference. |
WorkCenterDescription | String | A detailed description of the work center, including the types of resources available and their functions. |
WorkOrderId | Long | The unique identifier for the work order associated with the resource. Links the resource to the specific production job. |
WorkOrderOperationId | Long | The unique identifier for the operation within the work order to which the resource is assigned. This identifier tracks resources at the operation level. |
OperationSequenceNumber | Decimal | The sequence number of the operation within the work order, determining the order in which operations are performed. |
OperationName | String | The name of the operation associated with the resource (for example, 'Assembly,' 'Testing,' or 'Painting'). |
StandardOperationId | Long | The unique identifier for the standard operation template associated with the resource. This identifier enables reuse of common operation setups. |
StandardOperationCode | String | A shorthand code representing the standard operation associated with the resource. |
PrincipalFlag | Bool | Indicates whether the resource is the primary resource for the operation. A value of 'true' designates it as the main resource. |
BasisType | String | Specifies the basis for resource allocation (for example, 'Fixed' or 'Variable'), determining how resource usage is calculated. |
RequiredUsage | Decimal | The amount of resource usage required for the operation. This value helps in planning and allocating resources efficiently. |
UOMCode | String | The unit of measure (UOM) code for the resource usage, such as 'HRS' (Hours) or 'EA' (Each). |
UnitOfMeasure | String | The full name of the unit of measure for the resource usage (for example, 'Hours' or 'Each'), providing additional clarity for the UOM code. |
ChargeType | String | Specifies the type of charge associated with the resource (for example, 'Direct' or 'Indirect') for costing purposes. |
AssignedUnits | Decimal | The number of units of the resource assigned to the operation. This number helps in tracking and managing resource allocation. |
PlannedStartDate | Datetime | The planned date and time for starting the use of the resource in the operation. These metrics align resource allocation with the production schedule. |
PlannedCompletionDate | Datetime | The planned date and time for completing the use of the resource in the operation. |
ResourceActivityCode | String | The code representing the specific activity performed by the resource (for example, 'Grinding' or 'Welding'). |
ScheduledIndicator | String | Indicates whether the resource usage is scheduled. This value helps in tracking planned versus unscheduled resource usage. |
PhantomFlag | Bool | Indicates whether the resource is a phantom resource. A phantom resource is not tracked physically but is used for planning purposes. |
ActualResourceUsage | Decimal | The actual amount of the resource consumed during the operation. This value helps in comparing planned versus actual usage for reporting and optimization. |
CreatedBy | String | The name or identifier of the user who created the resource record. This identifier provides an audit trail for accountability. |
CreationDate | Datetime | The date and time when the resource record was created. These metrics help track when the resource was assigned to the operation. |
LastUpdateDate | Datetime | The date and time when the resource record was last updated. These metrics ensure changes are traceable for accuracy and auditing. |
LastUpdatedBy | String | The name or identifier of the user who last updated the resource record. This identifier provides traceability for modifications. |
ProfileId | Long | The unique identifier for the profile associated with the resource. This identifier links the resource to a predefined profile for standardization. |
ProfileCode | String | The code for the profile associated with the resource. This code provides a shorthand reference for the resource profile. |
EquipmentProfileId | Long | The unique identifier for the equipment profile linked to the resource. This identifier tracks equipment-specific configurations and attributes. |
EquipmentProfileCode | String | The code for the equipment profile associated with the resource. This code helps identify equipment setups or specifications. |
BackToBackFlag | String | Indicates whether the resource is part of a back-to-back process, where resource usage is directly linked to specific customer demand. |
ContractMfgFlag | String | Indicates whether the resource is associated with contract manufacturing, where operations are outsourced to external suppliers or partners. |
DueDays | Int | The number of days remaining until the resource is required for the operation. This number helps in planning and scheduling resource usage. |
Finder | String | Represents the search mechanism or criteria used to locate the resource record within the system for quick access. |
FirmPlannedFlag | String | Indicates whether the resource is firm planned, meaning its allocation cannot be modified by planning or scheduling tools. |
InventoryItemId | Long | The unique identifier for the inventory item linked to the resource. This identifier tracks materials or components related to resource usage. |
ItemNumber | String | The unique number assigned to the inventory item associated with the resource. This number aids in tracking and identification. |
MaterialItemId | Long | The unique identifier for the material item related to the resource. This identifier links the material to the resource for detailed tracking. |
ProductSerialId | Long | The unique identifier for the product serial number associated with the resource. This identifier enables serialized tracking for resource usage. |
SerialNumber | String | The serial number of the resource or equipment. This serial number provides precise identification and traceability. |
SourceHeaderReferenceId | Long | The unique identifier for the source header linking the resource record to its originating transaction, such as a purchase order or project. |
SourceHeaderRefId | Long | An alternate unique identifier for the source header associated with the resource. This identifier provides additional linkage to the source system. |
SourceLineReferenceId | Long | The unique identifier for the source line linking the resource record to a specific line item in the originating transaction. |
SourceLineRefId | Long | An alternate unique identifier for the source line associated with the resource record. This identifier provides additional traceability. |
SourceSystemId | Long | The unique identifier for the source system that provided the data related to the resource. This identifier is useful for integrations with external systems. |
Tolerance | Int | The allowable tolerance level for the resource usage. This value ensures flexibility in operations while maintaining accuracy. |
WoProjectNumber | String | The project number associated with the work order resource. This number links the resource to specific project-related activities. |
WorkOrderNumber | String | The unique number assigned to the work order associated with the resource. This number helps track resource usage within the broader production process. |
WorkOrderStatusId | Long | The unique identifier for the current status of the work order linked to the resource. This identifier indicates whether the work order is 'Open,' 'In Progress,' or 'Completed.' |
WoTaskNumber | String | The task number within the work order associated with the resource. This attribute enables tracking of resource usage at the task level. |