AdjustedOut | Negative Adjusted | Number | | Stock written off by adjustment lines that carry a negative quantity and no adjustment type. The engine applies it as a decrement of a negative number, so the bucket accumulates a positive magnitude of the quantity removed, and it is subtracted by the available, in-hand and projected balances alike. |
Adjustment | Positive Adjusted | LargeNumber | | Net signed quantity accumulated from adjustment postings against this bucket; in the availability math adjustments count fully into both available and in-hand. |
Allocation | Allocation Quantity | LargeNumber | | |
Assemble | Assembled In | Number | | Quantity produced by assembly, incremented by adjustment lines whose type is Assemble and added to the available, in-hand and projected balances. It is also incremented by adjustment lines whose type is Disassemble, because the seeded Disassemble rule names this field as its incremental target - a disassembly therefore currently increases assembled quantity. |
Available | Available | Calculated (calculated) | | |
AverageCost | Average Cost | Currency | | Inventory valuation lives in the Finance cost-lot entities driven by the posting cost hook, not on this row. |
BranchId | Branch | Lookup → Branch | | The branch the balance belongs to, part of the stock row key and read from the source document's header rather than the line. Transfer postings resolve it per leg, so an outward and an inward movement of the same transfer touch two different stock rows. |
ClosingStock | Closing Stock | Number | | Closing figures come from the ledger action's running totals or from the calculated Available and InHand fields on this row. |
CostofGoods | CostofGoods | Currency | | Cost of goods sold is produced by the Finance inventory costing engine from ledger movements, not accumulated here. |
CostPrice | Cost Price | Currency | | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Damaged | Damaged Quantity | LargeNumber | | Cumulative damaged quantity, fed by damaged quantities on goods receipt lines, transfer lines and credit note returns, and by adjustment lines whose type is Damaged. Subtracted from the available balance; absent from the in-hand formula. |
DeAllocation | DeAllocation | Number | | De-allocation is expressed as a negated reversal row that reduces the Allocation bucket instead. |
Disassemble | Assembled Out | Number | | In practice it stays at zero. |
Excess | Excess Quantity | LargeNumber | | Cumulative over-received or over-counted quantity, fed by excess quantities on goods receipt, transfer and credit note lines and by adjustment lines whose type is Excess. Adds to both the available and in-hand balances. |
Expired | Expired Quantity | LargeNumber | | Cumulative expired quantity, written off by adjustment lines whose type is Expired and by expiry-type credit note returns. Subtracted from the available balance; absent from the in-hand formula. |
External | Quantity External | Number | | |
ExternalId | External | Lookup | | |
FinancialYear | Financial Year | Number | | Stock rows are perpetual running balances with no period dimension, so do not use this to scope a balance to a year - use the ledger with a date window instead. |
Fulfilment | Fulfilment | LargeNumber | | |
HashCode | Hash Code | Number | | A numeric column left at its zero default: unlike the lot equivalent, nothing in the platform assigns or reads it on stock rows. |
Id | Id | Guid | Yes | |
InHand | In Hand | Calculated (calculated) | | |
Inspection | Inspection | LargeNumber | | Quantity held for incoming inspection, incremented from inspection lines raised against a goods receipt. Subtracted from the available balance but absent from the in-hand formula - inspected goods are physically present but not sellable. |
InspectionAdjustment | Inspection Adjustment | LargeNumber | | |
InTransit | Transit | Number | | |
InventoryTurnover | Inventory Turnover | Currency | | |
Inward | Unbilled Receipts | LargeNumber | | Received-but-unbilled quantity: goods receipt lines increment it, and it is drained again when the supplier bill posts Purchased against the same receipt line. Counts positively into both the available and in-hand balances. |
IsTransactionLocked | Is Transaction Locked | Boolean | Yes | |
ItemId | Item | Lookup → Item | | |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | InventoryStockService.SetInventoryStock searches with a key that does include it, so that lookup can only ever match rows where both sides are unset. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | | |
OnHold | Quantity On Hold | LargeNumber | | Quantity blocked by an adjustment line whose adjustment type is OnHold. Subtracted from the available balance and ignored by the in-hand formula, so putting stock on hold makes it unsellable without pretending it left the building. |
OnLoan | Quantity On Loan | LargeNumber | | Quantity lent out via an adjustment line whose adjustment type is OnLoan. Subtracted from the available balance and ignored by the in-hand formula. |
OpeningStock | Opening Stock | Number | | Opening figures come from the ledger action, which computes them from movements dated before the window start. |
Outward | Unbilled Dispatches | LargeNumber | | Dispatched-but-uninvoiced quantity: delivery order lines increment it and the invoice drains it when it posts Sold against the delivery line. It is subtracted by the available balance but is absent from the in-hand formula, because the goods have left even though the sale is not yet booked. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The owning company for this balance, part of the stock row key. Posting takes it from the source document's header (the rule's parent entity), not from the line, so a line whose header has no partner cannot resolve or create a stock row. |
PendingDeliveries | Pending Deliveries | Number | | Counter for sold-but-undelivered stock; its ledger rows carry a matching pendingDeliveriesQuantity, and sale returns tied to a pending delivery stay out of availability until delivered. |
Picked | Picked Quantity | LargeNumber | | Quantity sitting on picked fulfilment lines. Neutral in the availability math, because allocation already removed it from available. |
Pipeline | Quantity On Pipeline | LargeNumber | | Inbound quantity on shipments not yet received; informational - it contributes to neither available nor in-hand until receipt posts an inward movement. |
ProfitPrice | Profit Price | Currency | | |
Purchased | Purchased Quantity | LargeNumber | | Quantity on order with suppliers; affects neither available nor in-hand until the goods are received. |
PurchaseReturn | Purchase Return Quantity | LargeNumber | | Cumulative quantity returned to suppliers, posted from credit note lines that are not classified as an excess, damage, shortage or expiry return. Subtracts from both the available and in-hand balances. |
QuantityProjected | Quantity Projected | Calculated (calculated) | | |
RecordTypeId | Record Type | Guid, hidden | | |
SalePrice | Sale Price | Currency | | |
SaleReturn | Sale Return Quantity | LargeNumber | | Cumulative customer-return quantity; adds to available and in-hand, except returns still tied to a pending delivery, which stay neutral until delivered. |
Shortage | Shortage | Number | | Cumulative short-received or short-counted quantity, fed by shortage quantities on goods receipt and transfer lines and by adjustment lines whose type is Shortage. Subtracted from the available balance only. |
SKUId | SKU | Lookup → SKU | | |
SoftCommit | SoftCommit | LargeNumber | | Quantity committed by order lines ahead of fulfilment. Deliberately neutral in the availability math - it moves neither available nor in-hand. |
Sold | Sold Quantity | LargeNumber | | Accumulated invoiced quantity, incremented when an invoice line posts; the same rules simultaneously drain whichever upstream reservation the sale consumed (Picked, Allocation or Outward). Subtracts from both the available and in-hand balances. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | Part of the stock row key, so the same item at two bins keeps two balances. A null value is meaningful rather than missing: the transfer transit balance is deliberately held on a row with no location. |
TransferInward | Transfer Inward | LargeNumber | | Cumulative quantity transferred into this bucket; counts positively into available and in-hand at the receiving branch. |
TransferOutward | Transfer Outward | LargeNumber | | Cumulative quantity transferred out of this bucket; subtracts from available and in-hand at the sending branch. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
Value | Value | Currency | | Stock value is computed on demand by the ledger action as movement quantity times the ledger row's unit cost, and properly by the Finance costing engine. |
