ShipmentLinesreservations
Handles reservation details for shipment lines, especially for supplies beyond on-hand inventory.
Columns
| Name | Type | Description |
| ShipmentLinesShipmentLine [KEY] | Long | The unique identifier for the shipment line associated with the reservation in the ShipmentLinesreservations table. This links the reservation to a specific shipment line. |
| ReservationId [KEY] | Long | The unique identifier for the reservation in the system. This ID is used to track and manage reserved quantities in relation to shipment lines. |
| SupplyDocumentType | String | The type of the supply document related to the reservation. This could represent different document types, such as purchase orders, work orders, or transfer requests, that require reservations of goods. |
| SupplyDocumentNumber | String | The unique number of the supply document associated with the reservation. This number identifies the specific document, allowing it to be referenced in relation to the reserved quantities. |
| SupplyDocumentLine | Decimal | The line number of the supply document associated with the reservation. This is used when the supply document contains multiple line items, allowing for precise tracking of which item is being reserved. |
| SupplyDocumentSchedule | Decimal | The schedule line number of the supply document. This field tracks the specific schedule within the document, indicating when the reserved item is expected to be needed or delivered. |
| PrimaryReservedQuantity | Decimal | The quantity of the item reserved in the primary unit of measure (UOM). This tracks the amount of the product that is held for the specified shipment line. |
| PrimaryUOMCode | String | The code representing the primary UOM for the reserved quantity. This ensures that the reservation is accurately tracked in the correct measurement unit, such as pieces, kilograms, or liters. |
| PrimaryUOM | String | The primary UOM used for the reservation. This is used to define how the reserved quantity is measured (for example, units, boxes, pallets). |
| SecondaryReservedQuantity | Decimal | The quantity of the item reserved in a secondary UOM. This tracks the reserved quantity in a different measurement unit, often used for dual UOM systems. |
| SecondaryUOMCode | String | The code representing the secondary UOM for the reserved quantity. This field is used when tracking items in both primary and secondary measurement units. |
| SecondaryUOM | String | The secondary UOM used for the reservation. This is typically used for items that require multiple UOMs (for example, both weight and count). |
| ProjectId | Long | The unique identifier for the project associated with the reservation. This links the reservation to a specific project, allowing for cost and resource management in the context of project-based inventory. |
| ProjectNumber | String | The number assigned to the project related to the reservation. This helps identify the project in systems that manage multiple projects and resources. |
| ProjectName | String | The name of the project associated with the reservation. This provides a descriptive label for the project, making it easier to identify when managing multiple reservations and projects. |
| TaskId | Long | The unique identifier for the task within the project that requires the reserved quantity. This allows users to track specific tasks that are tied to the reservation. |
| TaskNumber | String | The number assigned to the task within the project that is associated with the reservation. This helps with managing multiple tasks within a project. |
| TaskName | String | The name of the task associated with the reservation. This is used for easier identification of the task within the larger project structure. |
| Finder | String | A search identifier used to quickly locate the reservation within the system. This is useful for filtering and retrieving specific reservations based on different criteria. |
| ShipmentLine | Long | The unique identifier for the shipment line associated with the reservation. This helps connect the reservation to the specific shipment line, ensuring that the reserved quantities are properly allocated and tracked. |