AllocatedById | Allocated By | Lookup | | |
AllocatedByResourceId | Allocated By | Lookup → Resource | | Only picking captures who did the work, through PickedByResourceId on the picking line. |
AllocatedQuantity | Allocated Quantity | Calculated (calculated) | | Calculated as Quantity minus ReturnedQuantity, so it is what is still reserved after cancellations; the raw reservation booked to the ledger is Quantity. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DeliveredInvoicedQuantity | Delivered Invoiced Quantity | Decimal | | |
DeliveryQuantity | Delivery Quantity | Decimal | | |
DeliveryReturnQuantity | Delivery Return Quantity | Decimal | | Declared and stored but written by no code path — the delivery roll-ups maintain DeliveryQuantity and PickedDeliveredQuantity instead. It only ever appears in the never-negative validation list. |
DocumentDate | Document Date | Date | | |
EligibleReturnQuantity | Eligible Return Quantity | Calculated (calculated) | | |
ExternalId | External | Text | | |
FulfillmentNumber | Fulfillment Number | Number, unique | | Note also the American double-l spelling, which differs from the 'Fulfilment' used across the rest of the module. |
Id | Id | Guid | Yes | |
InventoryFulfilmentId | Inventory Fulfilment | Lookup → InventoryFulfilment | | |
InventoryFulfilmentOrderLineId | Fulfillment Order Line | Lookup → InventoryFulfilmentOrderLine | | Link back to the demand line this reservation consumes. One demand line commonly has several of these, because allocation keeps taking the next eligible lot or stock row until the pending demand is used up. |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | Stamped by the ledger engine with the immutable Allocation row it wrote. Its presence is what tells the platform the quantity has already been added to the InventoryStock Allocation bucket. |
InventoryStockId | Stock | Lookup → InventoryStock | | The stock bucket a non-lot reservation is booked against — the seeded Allocation rule increments the Allocation column of exactly this row. |
InvoiceQuantity | Invoice Quantity | Decimal | | The directly invoiced portion: invoice-line quantity less its delivered and picked parts, so it counts only what was invoiced without a delivery or a pick in between. |
IsClosed | Closed | Boolean | | |
IsILPosted | IL Posted | Boolean | | |
IsILPostingApproved | IL Posting Approved | Boolean | | Set true on every line the engine creates, cancellation reversals included, so the Allocation ledger rule fires on save. |
ItemId | Item | Lookup → Item | | |
ItemLotId | Item Lot | Lookup → ItemLot | | The concrete lot the reservation is drawn from for lot-tracked items; when it is empty the reservation is against the InventoryStock bucket instead. It is locked once the line has transacted. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | |
LastModifiedById | LastModifiedBy | Guid | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | |
OrderId | Order | Lookup → Order | | |
OrderLineId | Sale Order Line | Lookup → OrderLine | | The sales demand this reservation answers. After allocation runs, a link that is missing or points at a deleted line is automatically repaired to the single matching order line for the same item and SKU (preferring a scheme-generated one); a link that is already valid is left untouched. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
ParentFulfillmentAllocationLineId | Parent Inventory Fulfillment Allocation Line | Lookup → InventoryFulfilmentAllocationLine | | Self-reference used by allocation cancellation: the reversal row created by a cancel points back at the allocation line it undoes, keeping the original row intact. |
PendingDeliveryQuantity | Pending Delivery Quantity | Calculated (calculated) | | What allocation-based delivery can still deliver from this line; the AllocationDelivery actions require it above zero. |
PendingInvoiceQuantity | Pending Invoice Quantity | Calculated (calculated) | | Calculated as AllocatedQuantity minus all three invoiced buckets (direct, delivered-invoiced, picked-invoiced). |
PendingPickingQuantity | Pending Picking Quantity | Calculated (calculated) | | Allocated quantity not yet moved to picking. Gates PerformPicking/SelectivePicking, and an allocation line at zero here must be delivered through the picked-delivery path - allocation delivery refuses it. |
PickedDeliveredQuantity | Picked Delivered Quantity | Number | | Roll-up of delivery-order lines that were raised from a picking line. Delivery raised straight off this reservation lands in DeliveryQuantity instead, and both are subtracted in PendingDeliveryQuantity. |
PickedInvoiceQuantity | Picked Invoice Quantity | Number | | |
PickedQuantity | Picked Quantity | Decimal | | Roll-up of the child picking lines' Quantity, not this line's own reservation; it feeds both EligibleReturnQuantity and PendingPickingQuantity. |
PickingCancelQuantity | Picking Cancel Quantity | Number | | Roll-up of the picking lines' CancelQuantity — the shortfall recorded when a pick was confirmed for less than was requested. It is added back into PendingPickingQuantity so the difference can be picked again. |
PickingRequestedQuantity | Picking Requested Quantity | Number | | Aggregate of the child picking lines' requested quantities, maintained alongside pickingCancelQuantity by the picking-line rollup. |
PickingReturnQuantity | Picking Return Quantity | Number | | Recomputed aggregate: the sum of quantities returned by this allocation's cancelled child picking lines, refreshed whenever picking cancellations post. |
Quantity | Quantity | Number | | |
RecordTypeId | Record Type | Guid, hidden | | |
RequestedQuantity | Requested Quantity | Number | | Carried only in a selective action's payload, never stored demand: it is the amount that call wants to pick or cancel on this line, validated against PendingPickingQuantity or EligibleReturnQuantity depending on the action. |
ReturnedQuantity | Returned Quantity | Number | | Maintained as the negated sum of the child cancellation lines' Quantity, so it grows as reversals are booked against this reservation. |
ServiceOrderId | Service Order | Lookup → ServiceOrder | | |
ServiceOrderLineId | Service Order Line | Lookup → ServiceOrderLine | | |
SKUId | SKU | Lookup → SKU | | |
SoftCommittedQuantity | Soft Committed Quantity | Calculated (calculated) | | Calculated: equal to Quantity when the line is tied to an order or service-order line and zero otherwise, so it marks reservations that answer real customer demand rather than speculative ones. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | Taken from the chosen ItemLot when allocating a lot, but from the demand line's UnitPrice when allocating from an InventoryStock bucket — so for non-lot items it carries a selling price rather than a cost. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |