BranchId | Branch | Lookup → Branch | | The branch whose stock moved, taken from the source document's header. In the ledger report a branch filter compares against both this and the related branch, and transfer rows only count towards a branch's running totals when this field matches it. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DocumentDate | Posting Date | Date | | The time the entry was posted, not the source document's own date. Reversals carry the time they were written. The item ledger's period filter and opening stock use this date. |
ExternalId | External | Text | | |
HashCode | HashCode | Guid | | An identifier column that posting never assigns, so it stays null on every generated row. Do not use it to correlate or deduplicate movements - use the source record and parent record references instead. |
Id | Id | Guid | Yes | |
In | In | Number | | Not stored. The field exists in metadata only and is never filled; use the ledger type and quantity instead. |
InventoryLedgerType | Ledger Type | PickList | | The kind of movement, stored without spaces (for example Inward, Sold, TransferOutward, SoftCommit). It decides how the entry counts towards available and in-hand quantity; the stored quantity itself is a positive magnitude. Values: Adjustment, Transfer Outward, Transfer Inward, Outward, Fulfilment, Sold, On Loan, Inspection Adjustment, Allocation, Picked, Sale Return, Purchase Return, Pipeline, Soft Commit. |
IsInventoryStockPosted | Inventory Stock Posted | Boolean | Yes | Whether this row's quantity was actually applied to an InventoryStock counter; false means the ledger row exists but no stock bucket field was updated (for example no increment field matched the configured names). |
ItemId | Item | Lookup → Item | | The item that moved, copied from the source line. Lines whose item does not have inventory tracking enabled are skipped entirely by posting, so no row is ever written for them. |
ItemLotId | Item Lot | Lookup → ItemLot | | The batch this movement consumed or produced, copied from the source line. Posting fails with a validation error when the item has lot tracking enabled and the line carries no lot. On a single-step transfer's inward row the destination lot is swapped in here and the original lot moves to the related lot field. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The stock grade or variant carried through from the source line. It is recorded on the movement for reporting but is not part of the key used to find or create the matching stock balance. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Ledger Name | Text | | The entry's reference, numbered automatically in the IL series by the Inventory Ledger Name Setting. |
OpeningStock | Opening Stock | Number | | Not stored. The field exists in metadata only and is never filled; opening stock is computed by the item ledger from the entries posted before the period. |
Out | Out | Number | | Not stored. The field exists in metadata only and is never filled; use the ledger type and quantity instead. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
ParentEntityName | Parent Entity Name | Text | | The type of the source line's document, taken from the posting setting. Transfer lines, whose settings name no parent, record the line itself. |
ParentRecordId | Parent Record Id | Lookup → @parentEntityName | | The document the source line belongs to (or the line itself for transfer lines). |
PartnerAccountId | Partner Account | Lookup → Account | | The owning company of the movement, taken from the source document's header rather than the line. On transfers it is resolved per leg, so an outward and an inward row of the same transfer can name different companies. |
PendingDeliveriesQuantity | Pending Deliveries Quantity | Number | | A pending-deliveries quantity carried on some movements. Current posting does not fill it on new entries (reversals negate whatever the original held). A SaleReturn entry holding a value here does not count towards availability in the item ledger. |
Quantity | Quantity | Number | Yes | How much moved: the posting setting's quantity field less the source line's Cancelled Quantity. Stored as a positive magnitude on ordinary entries and negated on reversals; the ledger type gives the direction. |
RecordTypeId | Record Type | Guid, hidden | | |
RelatedBranchId | Related Branch | Lookup → Branch | | On transfer entries, the branch on the other side of the transfer. Empty on all other movements. |
RelatedItemLotId | Related Item Lot | Lookup → ItemLot | | The lot on the other side of a transfer movement. On single-step inward rows the engine swaps itemLotId to the destination lot and parks the source lot here. |
RelatedPartnerAccountId | Related Partner Account | Lookup → Account | | The counterpart owning company on cross-company transfer rows; company-scoped ledger reads match it as well as partnerAccountId. |
ReversalOfLedgerId | Reverse Inventory Ledger | Lookup → InventoryLedger | | On a reversal entry, the original entry it neutralizes. Empty on ordinary entries. |
SKUId | SKU | Lookup → SKU | | The SKU variant from the source line; together with partner, branch, item and storage location it selects the stock balance this movement is applied to. |
SourceDocument | Source Document | Text | | The human-readable name of the source document/line, stamped at posting time so ledger rows read meaningfully without joins. |
SourceEntityName | Source Entity Name | Text | | The type of the document line that posted the entry. |
SourceRecordId | Source Record | Lookup → @sourceEntityName | | The document line that posted the entry. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The location whose balance was moved, after transfer resolution rather than as typed on the line - an inward leg is rewritten to the destination location. Goods in transit are not recorded as ledger entries; the transit quantity is kept on the destination branch's stock balance. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The cost on the movement: the source line's unit price, or its unit cost when it has no price. Reversals copy the original's cost. The item ledger's running value multiplies available quantity by this cost. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
