InventoryReservations
Tracks reservation details for items, including location, supply documents, and demand in primary and secondary units.
Columns
| Name | Type | Description |
| ReservationId [KEY] | Long | The unique identifier for the inventory reservation. This identifier is essential for tracking and managing stock allocations, ensuring items are reserved correctly for sales orders, transfers, or other demand sources. |
| OrganizationId | Long | The unique identifier for the warehouse organization responsible for the inventory reservation. This identifier ensures inventory commitments are accurately associated with the correct business unit or location. |
| OrganizationCode | String | A code representing the warehouse organization that reserves inventory to fulfill demand. This code is used for easy identification of the responsible organization. |
| InventoryItemId | Long | The unique identifier for the inventory item that is reserved. This identifier links the reservation to a specific item in the inventory system, ensuring accurate allocation and tracking. |
| ItemNumber | String | The item number assigned to the inventory item, serving as a unique product identifier. This number is used for product tracking, stock verification, and order fulfillment. |
| DemandSourceTypeId | Long | The unique identifier for the type of document that requests the inventory reservation. This identifier links the reservation to a specific demand source, such as a sales order or transfer request. |
| DemandSourceType | String | The type of document that initiated the inventory reservation request. The accepted values are defined in the lookup type INV_RESERVATION_SOURCE_TYPES. Those values include 'User Defined', 'Transfer Order Return', 'Sales Order', 'Shipment Request', 'Account', 'Movement Request', 'Account Alias', 'Transfer Order', or 'Cycle Count'. |
| DemandSourceHeaderId | Long | The unique identifier for the demand document associated with the inventory reservation. This identifier helps track which document requested the inventory commitment. |
| DemandSourceHeaderNumber | String | The document number that specifies demand details for the inventory reservation. This number is used to reference the original request for inventory allocation. |
| DemandSourceName | String | The name of the source that requested the inventory reservation. This name helps track demand origin, such as a specific order or customer request. |
| DemandSourceLineId | Long | The unique identifier for the demand line within the source document. This identifier ensures accurate tracking of specific line items in a reservation request. |
| DemandSourceLineNumber | String | The line number in the demand document that specifies an individual inventory reservation request. This number ensures precise allocation for each requested item. |
| SourceFulfillmentLineId | Long | The unique identifier used by order orchestration to track the reservation. This identifier is essential for aligning reservation commitments with fulfillment execution. |
| SupplySourceTypeId | Long | The unique identifier for the type of supply document that provides inventory for the reservation. This identifier links the reservation to an inventory supply source, such as a purchase order or transfer order. |
| SupplySourceType | String | The type of supply document associated with the inventory reservation. The accepted values are defined in the lookup type INV_RESERVATION_SUPPLY_SRC_TYP. Those values include 'Purchase Order', 'On Hand', 'Requisition', 'Transfer Order Return', 'Work Order', or 'Transfer Order'. |
| SupplySourceHeaderId | Long | The unique identifier for the supply document that provides inventory for the reservation. This identifier ensures traceability of inventory commitments to their supply sources. |
| SupplySourceHeaderNumber | String | A document number that specifies supply details for the reserved inventory. This number is used to reference the supply-side transaction fulfilling the reservation. |
| SupplySourceLineId | Long | The unique identifier for the line in the supply document that provides inventory for the reservation. This identifier ensures accurate alignment between supply and demand allocations. |
| SupplySourceLineNumber | String | The line number in the supply document that details the inventory supply for the reservation. This number ensures precise tracking of specific stock commitments. |
| Revision | String | The revision code associated with the inventory item. This code applies when the warehouse places the item under revision control, ensuring the correct product version is reserved. |
| SubinventoryCode | String | The name of the subinventory from which inventory is reserved. This field ensures that stock is allocated from the correct warehouse or storage location. |
| SubinventoryId | Long | The unique identifier for the subinventory where the reserved item is stored. This identifier ensures accurate tracking of stock allocations within specific warehouse zones. |
| LotNumber | String | The lot number associated with the reserved inventory. This lot number applies when the warehouse places the item under lot control, ensuring traceability for quality control and regulatory compliance. |
| LocatorId | Long | The unique identifier for the locator within the warehouse where the inventory is reserved. This identifier ensures precise tracking of stock locations down to bin, shelf, or aisle levels. |
| Locator | String | A code representing the specific physical location within the subinventory where the reserved inventory is stored. This code can be an aisle, row, bin, or shelf that contains the item. |
| PrimaryReservationQuantity | Decimal | The reserved quantity of the item expressed in its primary unit of measure (UOM). This quantity ensures that stock commitments are accurately recorded based on standard measurement units. |
| PrimaryUOMCode | String | An abbreviation representing the primary UOM for the reserved inventory. This field standardizes inventory tracking and transaction processing. |
| PrimaryUnitOfMeasure | String | The full name of the primary UOM for the reserved inventory. This name defines how the item quantity is measured, such as in pieces, kilograms, or liters. |
| SecondaryReservationQuantity | Decimal | The reserved quantity of the item expressed in the secondary UOM. This quantity applies when an item has dual measurement units, ensuring accurate stock tracking. |
| SecondaryUOMCode | String | An abbreviation representing the secondary UOM for the reserved inventory. This UOM ensures consistency when tracking inventory that can be measured in multiple units. |
| SecondaryUnitOfMeasure | String | The secondary UOM for the reserved inventory item. This UOM is used when an item has dual measurement units, such as cases and individual units. |
| ReservationQuantity | Decimal | The total quantity of the item reserved, expressed in the primary UOM. This quantity ensures proper stock allocation for fulfilling demand requests. |
| ReservationUOMCode | String | An abbreviation representing the UOM that the user selects when placing the reservation. This UOM determines how the reserved quantity is measured. |
| ReservationUnitOfMeasure | String | The UOM that the user selects when placing a reservation. This UOM defines how the reservation quantity is recorded, such as in 'Pieces', 'Kilograms', or 'Liters'. |
| ShipToCustomer | String | The name or identifier of the customer receiving the reserved inventory. This identifier is used for tracking customer-specific inventory allocations in fulfillment operations. |
| ShipToPartyId | Long | The unique identifier for the party receiving the reserved inventory. This identifier links the reservation to a specific customer, business entity, or internal department. |
| RequirementDate | Date | The date when the customer or demand source requires the reserved item to be fulfilled. This date ensures timely stock allocation and order processing. |
| SupplyProjectId | Long | The unique identifier for the project associated with the supply document. This identifier helps track inventory allocated for specific projects, ensuring proper cost management and usage. |
| SupplyTaskId | Long | The unique identifier for the specific task within a project related to the supply document. This identifier ensures accurate tracking of inventory tied to project activities and budgets. |
| DemandProjectId | Long | The unique identifier for the project associated with the demand document. This identifier helps allocate inventory to specific projects, ensuring that stock commitments align with project needs. |
| DemandTaskId | Long | The unique identifier for the task corresponding to a project for the demand document. This identifier ensures inventory reservations are correctly linked to project-based requirements. |
| DemandProjectNumber | String | The project number associated with the demand document. This project number provides a reference for tracking inventory allocated to a specific project. |
| DemandTaskNumber | String | The task number corresponding to a project for the demand document. This task number links the reservation to specific project-related activities requiring inventory. |
| SupplyProjectNumber | String | The project number associated with the supply document. This number identifies the project that provides the inventory for the reservation. |
| SupplyTaskNumber | String | The task number corresponding to a project for the supply document. This task number links the inventory supply to a specific task within the project. |
| SourceFulfillmentLineNumber | String | The number identifying a line corresponding to a source fulfillment line. This number ensures alignment between inventory reservations and fulfillment processes. |
| OperationSequenceNumber | String | The sequence number of a specific operation as defined in a work order. This sequence number helps track the chronological execution of tasks in manufacturing or fulfillment workflows. |
| WorkOrderProductId | Long | The unique identifier for the product associated with the work order in inventory reservations. This identifier ensures proper stock allocation for manufacturing or assembly processes. |
| WorkOrderProductNumber | String | The product number of the item associated with the work order in inventory reservations. This product number helps link reserved inventory to specific work order requirements. |
| OrderInterfaceStatus | String | Indicates whether the sales order or transfer order demand has been interfaced to inventory or shipping. Possible values include 'Y' (interfaced) or 'N' (awaiting interface). This attribute is linked to a feature requiring opt-in. |
| Finder | String | A reference attribute used for searching and retrieving inventory reservation records based on predefined criteria. This attribute enhances system usability by allowing users to locate reservations efficiently. |