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. |