Adjustment | Adjustment | Number | | Net signed quantity from untyped adjustment lines against this batch - this, not the adjusted-in counter, is where positive adjustments land. Counts fully into both the lot's available and in-hand balances. |
BatchNo | Batch No | Text | | Free-text batch identifier. It is not populated when a lot is created from a goods receipt line - only the transfer and field-sales paths set it, by copying it from the lot being cloned - so receipt-created lots carry it only if a user types one. |
BranchId | Branch | Lookup → Branch | | |
ComponentNumber | Component Number | Text | | Manufacturer or component reference captured on the goods receipt line and carried onto the lot; transfer cloning copies it to the destination lot so traceability survives a move. |
Cost | Cost | Currency | | A separate cost field that goods receipt does not populate - it is only carried across when transfer posting clones a lot. For the receipted cost use the unit cost field. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | | |
DateOfDispatch | Date Of Dispatch | Date | | |
DateOfExpiry | Date Of Expiry | Date | | Expiry date of the batch. Not populated by goods receipt lot creation - only carried across when a transfer clones a lot - so it must be captured manually or by an integration on the originating lot. |
DateOfInward | Date Of Inward | Date | | |
DateOfMfg | Date Of Mfg | Date | | Manufacturing date of the batch. Not populated by goods receipt lot creation; it is only copied forward when a transfer clones a lot. |
DateOfReceipt | Date Of Receipt | Date | | Set from the goods receipt document's date when the lot is created, so it reflects the receipt, not the line's own timestamp. |
DateOfRegistration | Date Of Registration | Date | | |
DateOfSupplierDispatch | Date Of Supplier Dispatch | Date | | Copied from the goods receipt header's supplier dispatch date at lot creation and carried onto cloned lots by transfer posting. |
DateOfSupplierInvoice | Date Of Supplier Invoice | Date | | Copied from the goods receipt header's supplier invoice date at lot creation and carried onto cloned lots by transfer posting. |
Disassemble | Disassemble | Number | | |
ExternalId | External | Text | | |
ExternalName | External Name | Text | | |
HashCode | Hash Code | Number | | An opaque token assigned once at insert from the current millisecond clock plus a random component. It is not a checksum of the record and nothing in the platform matches, deduplicates or orders on it. |
HoldCode | Hold Code | Text | | Any non-null value quarantines the lot: invoicing and fulfilment allocation only ever consider lots where this is null, so setting it removes the lot from automatic selection without changing its quantities. The value itself is not interpreted - only its presence. |
Id | Id | Guid | Yes | |
IsClosed | Is Closed | Boolean | | No code path reads or writes it, so it has no effect on lot selection, posting or valuation today. |
IsClosedForSale | Is Closed For Sale | Boolean | | No code path reads or writes it. To stop a lot being sold, set a hold code instead - that is the flag the selection queries actually honour. |
IsTransactionLocked | Is Transaction Locked | Boolean | | Set while a cycle count with inventory locking is underway on this lot - start counting locks, finish counting unlocks - to freeze movements during the count. |
ItemId | Item | Lookup → Item | | |
ItemLotCode | Lot Code | Text | | It is only read back for display in the allocation and manual-picking screens, so it stays blank unless captured manually. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | |
LandedCost | Landed Cost | Currency | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
MRP | MRP | Currency | | Maximum retail price copied from the goods receipt line when the lot is created, and copied again onto the destination lot when a transfer clones it. |
Name | Name | Text | | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | |
PurchaseDate | Purchase Date | Date | | |
QuantityAdjustedIn | Postitive Adjusted | Number | | Use the adjustment counter for adjusted-in quantity. |
QuantityAdjustedOut | Negative Adjusted | Number | | Batch quantity written off by negative untyped adjustment lines, accumulated as a positive magnitude because the engine applies it as a decrement of a negative quantity. |
QuantityAssembledIn | Quantity Assembled In (Future Use) | Number | | Batch quantity produced by assembly adjustments; despite the label marking it for future use it is actively written, because the seeded assemble rule's field name resolves to this property. It also absorbs disassembly adjustments, since the seeded disassemble rule points at the same assemble field. |
QuantityAssembledOut | Quantity Assembled Out (Future Use) | Number | | |
QuantityAvailable | Available | Calculated (calculated) | | |
QuantityDamaged | Damaged | Number | | |
QuantityExcess | Quantity Excess | Number | | |
QuantityExpired | Expired | Number | | |
QuantityInHand | In Hand | Calculated (calculated) | | |
QuantityInPendingDeliveries | Pending Deliveries | Number | | Batch quantity invoiced but not yet delivered, incremented alongside the sold counter and released again when the delivery posts. |
QuantityInTransit | Transit | Number | | The lot-level in-transit balance for two-step transfers: outward release adds the moving quantity on the destination clone, and inward receipt removes it. |
QuantityOnAllocation | Allocated | Number | | Quantity of this batch reserved by fulfilment allocation lines; picking drains it as it fills the picked counter. Subtracted from the lot's available balance and ignored by its in-hand balance. |
QuantityOnFulfillment | Quantity On Fulfillment (Future Use) | Number | | Reserved quantity is tracked on the allocation and picked counters instead. |
QuantityOnHold | Quantity On Hold (Future Use) | Number | | Batch quantity blocked by OnHold adjustment lines; despite the label marking it for future use it is actively maintained by posting, and is subtracted from the lot's available balance. |
QuantityOnInspection | Inspection | Number | | Batch quantity held for incoming inspection, posted from inspection lines on a goods receipt. Subtracted from the lot's available balance and ignored by its in-hand balance. |
QuantityOnInward | Unbilled Receipts | Number | | Per-lot mirror of the received-but-unbilled stock bucket, moved by the same posting call that moves the stock row. Adds to the lot's calculated available and in-hand balances. |
QuantityOnLoan | Quantity On Loan (Future Use) | Number | | Batch quantity lent out by OnLoan adjustment lines; despite the label marking it for future use it is actively maintained by posting, and is subtracted from the lot's available balance. |
QuantityOnOutward | Unbilled Dispatches | Number | | Per-lot mirror of the dispatched-but-uninvoiced bucket. Subtracted by the lot's available balance and absent from its in-hand balance. |
QuantityPicked | Picked | Number | | Quantity of this batch on picked fulfilment lines, incremented as allocation is drained. Subtracted from the lot's available balance only. |
QuantityPurchased | Purchased | Number | | |
QuantityPurchaseReturned | Purchase Returned | Number | | |
QuantitySaleReturned | Sale Returned | Number | | |
QuantityShortage | Shortage | Number | | |
QuantitySold | Sold | Number | | |
QuantityTransferIn | Transfer In | Number | | |
QuantityTransferOut | Quantity Transfer Out | Decimal | | |
RecordTypeId | Record Type | Guid, hidden | | |
RegistrationNumber | Registration Number | Text | | Registration identity for registrable goods; not set at goods receipt, only copied forward when transfer posting clones a lot, and read when a receipt produces an asset record. |
RelatedItemLotId | Related Item Lot | Lookup → ItemLot | | |
SaleDate | Sale Date | Date | | |
SerialNumber | Serial Number | Text | | Serial identity of a single-unit lot, taken from the goods receipt line and copied onto the destination lot when a transfer clones it. |
SKUId | SKU | Lookup → SKU | | |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The bin/location the lot currently sits in. Receiving a transfer inward line rewrites it to the receiving line's location, which is how put-away moves a lot. |
SupplierInvoiceNumber | Supplier Invoice Number | Text | | Copied from the goods receipt header at lot creation and carried onto cloned lots by transfer posting, giving each batch its purchase paperwork reference. |
TotalCost | Total Cost | Currency | | |
TransferInward | Transfer Inward | Decimal | | Cumulative quantity transferred into this batch's location, incremented by the inward leg of a transfer posting. Counts positively into the lot's available and in-hand balances. |
TransferOut | TransferOut | Decimal | Yes | |
TransferOutward | Transfer Outward | Decimal | | Cumulative quantity transferred out of this batch, incremented by the outward leg of a transfer posting. Subtracted by the lot's available and in-hand balances. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | Per-unit cost copied from the goods receipt line when the lot is created, and copied again onto ledger rows as the movement's unit cost when this lot posts. |
UpdatedDateTime | Modified Date | DateAndTime | | |
