WorkOrdersWorkOrderReservation
Handles demand reservations for work order output, ensuring proper allocation and fulfillment.
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier for the work order associated with this reservation. This identifier ensures that reserved inventory is linked to the correct work order execution. |
| OrganizationId | Long | The identifier for the organization managing this work order reservation. This identifiersupports tracking and fulfillment of reservations across multiple business units. |
| InventoryItemId | Long | The unique identifier for the inventory item that is reserved for the work order. This identifier ensures accurate allocation of materials for production. |
| CustomerName | String | The name of the customer associated with this reservation. This name helps track reservations linked to customer-specific orders. |
| DemandSourceHeaderNumber | String | The unique identifier for the demand source document header (for example, 'sales order' or 'work order'). This identifier ensures alignment between demand and reserved supply. |
| DemandSourceLineNumber | String | The unique identifier for the specific line item within the demand source document. This identifierenables tracking of reservations at the line-item level. |
| DemandSourceTypeName | String | The type of demand source document (for, 'sales order', 'work order'). This type helps categorize reservations based on their origin. |
| DueDate | Date | The date by which the reserved inventory must be available for the work order. This metric supports scheduling and material planning. |
| ReservationId [KEY] | Long | The unique identifier for the reservation. This identifier ensures traceability of reserved inventory within the system. |
| ReservationQuantity | Decimal | The quantity of the inventory item that has been reserved for this work order. This metric ensures proper allocation of materials. |
| ReservationUnitOfMeasure | String | The unit of measure associated with the reserved quantity (for example, 'Each', 'Kilogram'). This metric supports consistency in inventory tracking. |
| SupplySourceHeaderId | Long | The unique identifier for the supply source document header (for example, 'purchase order' or 'transfer order'). This identifier links reservations to available supply. |
| BackToBackFlag | String | Indicates whether this reservation is part of a back-to-back fulfillment process, ensuring that demand is directly linked to supply. |
| ContractMfgFlag | String | Indicates whether this reservation is associated with a contract manufacturing process. This flag helps track reservations for outsourced production. |
| DueDays | Int | The number of days remaining until the planned due date for the reservation. This metric helps monitor reservation timelines. |
| Finder | String | A search key or identifier used to quickly locate specific reservation records in the system. |
| FirmPlannedFlag | String | Indicates whether this reservation is firm-planned, meaning it is locked and not subject to changes. |
| ItemNumber | String | The specific item number associated with the reserved inventory. This number helps ensure proper material tracking. |
| LastUpdateDate | Datetime | The date and time when this reservation record was last updated. These metrics support audit tracking and ensures data accuracy. |
| MaterialItemId | Long | The unique identifier for the material that has been reserved. This identifier helps track material usage within the work order process. |
| PlannedCompletionDate | Datetime | The planned date and time for completing the operation using this reserved material. These metrics help ensure timely resource allocation. |
| PlannedStartDate | Datetime | The planned date and time for starting the operation using this reserved material. These metrics support scheduling of production activities. |
| ProductSerialId | Long | The unique identifier for the serialized product associated with this reservation. This identifier supports traceability of serialized inventory. |
| ResourceId | Long | The unique identifier for the resource (for example, 'machine', 'tool', or 'labor') allocated for this reservation. This identifier links reservations to specific resources. |
| SerialNumber | String | The serial number of the reserved product or material. This serial number ensures precise tracking and compliance with serialized inventory requirements. |
| SourceHeaderReferenceId | Long | The reference identifier linking this reservation to the source document's header (for example, 'purchase order' or 'transfer order'). |
| SourceHeaderRefId | Long | An alternate reference identifier for the source header. This identifier, ensuring compatibility with external systems or legacy integrations. |
| SourceLineReferenceId | Long | The reference identifier linking this reservation to a specific line item in the source document (for example, a purchase order line or transfer order line). |
| SourceLineRefId | Long | An alternate reference identifier for the source line. This identifier supports integration with external systems and ensuring accurate tracking of reserved inventory. |
| SourceSystemId | Long | The identifier for the external system from which this reservation data originates. This identifier ensures proper synchronization of data across platforms. |
| Tolerance | Int | The allowable tolerance for variations in reservation quantity or material usage. This metric helps maintain flexibility while ensuring production efficiency. |
| WoProjectNumber | String | The project number associated with this reservation. This number links reservations to broader project tracking and reporting. |
| WorkAreaId | Long | The unique identifier for the work area where the reserved material will be used. This identifier ensures proper tracking of reservations within specific production zones. |
| WorkCenterId | Long | The unique identifier for the work center responsible for processing this reservation. This identifier supports accurate allocation of reserved materials within production. |
| WorkOrderId | Long | The unique identifier for the work order that is consuming this reservation. This identifier ensures all reserved inventory is allocated correctly within the production process. |
| WorkOrderNumber | String | The unique number assigned to the work order associated with this reservation. This identifier ensures easy identification and tracking of reservations within production workflows. |
| WorkOrderStatusId | Long | The unique identifier representing the current status of the work order (for example, 'Planned,' 'In Progress,' 'Completed'). This identifierhelps track reservation status in relation to work order execution. |
| WoTaskNumber | String | The task number within the work order that is associated with this reservation. This number links reservations to specific tasks within the overall production process. |