Ledgers & derived

Stock ledgers & derived — 3 entities with their key fields and relationships.

Append-only tables written by transactions rather than entered by a user. Never edited directly — they are rebuilt by reposting.

3 entities in Stock.

Bin

Maintains the current quantity, reservations, projected availability, valuation, and stock value for one Item-Warehouse pair.

Ledger / derived

Naming: hash · 26 fields · 0 inbound refs

Key fields

Field	Type	Label
`reserved_qty`	Float	Reserved Qty
`actual_qty`	Float	Actual Qty
`ordered_qty`	Float	Ordered Qty

Relationships

Field	Type	References	Req
`company`	Link	Company
`item_code`	Link	Item	yes
`stock_uom`	Link	UOM
`warehouse`	Link	Warehouse	yes

Stores an Item’s buying or selling rate for a Price List, currency, unit, quantity range, and validity period.

Ledger / derived

Naming: hash · 27 fields · 0 inbound refs

Key fields

Field	Type	Req	Label
`item_name`	Data		Item Name
`price_list_rate`	Currency	yes	Rate
`reference`	Data		Reference

Relationships

Field	Type	References	Req
`batch_no`	Link	Batch
`brand`	Link	Brand
`currency`	Link	Currency (fw)
`customer`	Link	Customer
`item_code`	Link	Item	yes
`price_list`	Link	Price List	yes
`supplier`	Link	Supplier
`uom`	Link	UOM	yes

Records one stock quantity and valuation movement for an item, warehouse, and source voucher.

Ledger / derived

Naming: Expression · 36 fields · 0 inbound refs

Key fields

Field	Type	Label
`posting_date`	Date	Posting Date
`actual_qty`	Float	Qty Change
`incoming_rate`	Currency	Incoming Rate

Relationships

Field	Type	References
`company`	Link	Company
`item_code`	Link	Item
`project`	Link	Project
`serial_and_batch_bundle`	Link	Serial and Batch Bundle
`stock_uom`	Link	UOM
`voucher_type`	Link	DocType (fw)
`warehouse`	Link	Warehouse
`voucher_no`	Dynamic Link	resolved via `voucher_type`