CancelQuantity | Cancel Quantity | Number | | Requested quantity that was not confirmed. Confirm Picking sets it to 0 on the standard screens; a cancelled pick shows in Returned Quantity instead. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DeliveryQuantity | Delivery Quantity | Decimal | | Total quantity of the delivery order lines raised from this pick. |
DocumentDate | Document Date | Date | | The date the line was created. |
ExternalId | External | Text, unique | | |
Id | Id | Guid | Yes | |
InventoryFulfilmentAllocationLineId | Fulfillment Allocation Line | Lookup → InventoryFulfilmentAllocationLine | | The allocation line this pick draws from. Required: a picking line without one is refused with 'Picking can only be created from an Allocation Line!'. |
InventoryFulfilmentId | Inventory Fulfilment | Lookup → InventoryFulfilment | | The fulfilment the line belongs to. |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | The inventory ledger entry the line posted, filled when the line is created. |
InventoryStockId | Stock | Lookup → InventoryStock | | The stock record the posting moved quantity in, filled by the posting. |
IsILPosted | IL Posted | Boolean | Yes | Not set by the picking actions; use Inventory Ledger to see whether the line posted. |
IsILPostingApproved | IL Posting Approved | Boolean | Yes | |
IsPickingConfirmed | Picking Confirmed | Boolean | Yes | Turned on by Confirm Picking. Picked Delivery refuses a fulfilment with any unconfirmed line, and Cancel Picking refuses unconfirmed positive lines. Cancellation rows never have it. Switching it by hand posts nothing. |
ItemId | Item | Lookup → Item | | |
ItemLotId | Item Lot | Lookup → ItemLot | | The lot to pick from, copied from the allocation line. Locked once the line has a positive quantity. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The lot's type, copied from the allocation line. |
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 order line the picked stock answers, copied from the allocation line. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
ParentInventoryFulfilmentPickingLineId | Inventory Fulfillment Picking Line | Lookup → InventoryFulfilmentPickingLine | | On a cancellation row, the picking line it reverses. The original's Returned Quantity is the total of the rows that point to it. |
PendingDeliveryQuantity | Pending Delivery Quantity | Calculated (calculated) | | Picked quantity not yet delivered: Quantity less Delivery Quantity and Returned Quantity, and 0 on a cancellation row. What Picked Delivery would deliver. |
PickedByResourceId | Picked By | Lookup → Resource | | Meant to name the picker, but no standard screen sets it. |
PickedQuantity | Picked Quantity | Calculated (calculated) | | Quantity still counted as picked: Quantity less Returned Quantity. Cancel Picking cancels it whole, even the part already delivered. |
Quantity | Quantity | Decimal | | The quantity picked, posted from the Allocation bucket to Picked. Equal to Requested Quantity on the standard screens; negative on a cancellation row. Editing it reverses and re-posts the ledger entry without comparing it with what is reserved or delivered. |
RecordTypeId | Record Type | Guid, hidden | | |
RequestedQuantity | Requested Quantity | Decimal | | The quantity the pick was raised for: the allocation line's pending picking quantity, or the quantity entered in Selective Picking. |
ReturnedQuantity | Returned Quantity | Decimal | | Quantity cancelled from this pick: the total of its cancellation rows. Creating or deleting a delivery order line from the pick, or changing that line's Quantity or Unit Price, recounts it from the delivery lines' returned quantities instead, which drops an earlier cancellation. |
ServiceOrderId | Service Order | Lookup → ServiceOrder | | |
ServiceOrderLineId | Service Order Line | Lookup → ServiceOrderLine | | The service order line the picked stock answers, copied from the allocation line. Its Picked Quantity is the total of these picking lines. |
SKUId | SKU | Lookup → SKU | | |
StorageLocationId | Storage Location | Lookup → StorageLocation | | Where to pick from, copied from the allocation line and carried to the delivery order line. Changing it by hand does not re-post the ledger. |
UIProps | UI Props | Text | | |
UnitPrice | Unit Price | Currency | | Copied from the allocation line's Unit Cost: a lot's cost, or the order line's selling price for stock that is not lot-tracked. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |