WorkOrdersWorkOrderReservation
Handles demand reservations for work order output, ensuring proper allocation and fulfillment.
Columns
| Name | Type | SupportedFinders | 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 | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The identifier for the organization managing this work order reservation. This identifiersupports tracking and fulfillment of reservations across multiple business units. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether this reservation is part of a back-to-back fulfillment process, ensuring that demand is directly linked to supply. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether this reservation is associated with a contract manufacturing process. This flag helps track reservations for outsourced production. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether this reservation is firm-planned, meaning it is locked and not subject to changes. |
| ItemNumber | String | WorkOrderB2BCM | The specific item number associated with the reserved inventory. This number helps ensure proper material tracking. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The date and time when this reservation record was last updated. These metrics support audit tracking and ensures data accuracy. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material that has been reserved. This identifier helps track material usage within the work order process. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned date and time for completing the operation using this reserved material. These metrics help ensure timely resource allocation. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned date and time for starting the operation using this reserved material. These metrics support scheduling of production activities. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier for the serialized product associated with this reservation. This identifier supports traceability of serialized inventory. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | 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 | WorkOrderBySerialNumber | The serial number of the reserved product or material. This serial number ensures precise tracking and compliance with serialized inventory requirements. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier linking this reservation to the source document's header (for example, 'purchase order' or 'transfer order'). |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate reference identifier for the source header. This identifier, ensuring compatibility with external systems or legacy integrations. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | 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 | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate reference identifier for the source line. This identifier supports integration with external systems and ensuring accurate tracking of reserved inventory. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The identifier for the external system from which this reservation data originates. This identifier ensures proper synchronization of data across platforms. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable tolerance for variations in reservation quantity or material usage. This metric helps maintain flexibility while ensuring production efficiency. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with this reservation. This number links reservations to broader project tracking and reporting. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | 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 | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center responsible for processing this reservation. This identifier supports accurate allocation of reserved materials within production. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | 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 | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | 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 | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | 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 | FindByProjectNumberTaskNumber | 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. |