Data model

Inspect the stock identities, movement history and controls behind the specification.

37 tables · 203 relationships

How the model is organized

Products and locations

Products, ProductCategories, Warehouses, Bins, UnitsOfMeasure, ProductConversions and Suppliers establish the controlled masters. Transaction conversions retain the product-specific stocking-unit basis used at the time.

Products
ProductCategories
Warehouses
Bins
UnitsOfMeasure
ProductConversions
Suppliers establish the controlled masters

Identity and access

Users identifies actual people; UserWarehouses retains effective site assignments. Child records, reports and service actions inherit the appropriate scope and protected cost restrictions.

Users identifies actual people; UserWarehouses retains effective site assignments

Stock and value

Inventory stores the controlled position. StockEvents groups the business effect and StockMovements records its signed position legs. Reservations owns the exact demand claim. CostLayers and CostAllocations preserve remaining carrying value, source lineage and effective consumption or relocation.

Inventory stores the controlled position

Operational work

GoodsReceipts retains the external delivery and original arrival. Issues retains demand and actual consumption, Transfers separates departure from arrival and remaining transit, and ReturnAuthorizations links bounded return work to its original movement.

GoodsReceipts retains the external delivery
original arrival

Counting

CycleCounts and CycleCountLines, PhysicalInventories and PhysicalInventoryLines define assigned work. CountLocks preserves the controlled scope and versions; CountObservations retains first and recount evidence. StockAdjustments records the accepted correction and its posting outcome.

CycleCounts
CycleCountLines
PhysicalInventories
PhysicalInventoryLines define assigned work

Governance

InventoryPolicies and StockAdjustmentReasons define applicable conditions. MasterChanges retains proposed sensitive edits; ApprovalDecisions binds the actual reviewer, source version, policy and authority to the decision.

InventoryPolicies
StockAdjustmentReasons define applicable conditions

Replenishment

ReorderRules supplies product/site settings. StockSummaries includes configured stocked products even at zero quantity; ReorderAlerts retains each active attention episode through acknowledgment and recovery.

ReorderRules supplies product/site settings

History and handoff

StockSnapshots retains report cutoffs and populations. AccountingExports tracks approved incremental financial handoff, IntegrationEvents tracks source/action delivery and outcomes, and MigrationBatches preserves reviewed opening positions and historical source mappings.

StockSnapshots retains report cutoffs
populations

Keys and references

A stock identity includes product, site, bin, applicable lot and serial, owner, custody and any transit transfer. The bin belongs to its warehouse. A serial-controlled product has one positive position and one base unit for that serial; moving or splitting work cannot clone it.

Each movement row affects one position. Paired internal legs preserve total quantity and owned value. Reservations do not create another movement, and a pick does not consume the final issue twice. Cost-layer splits reduce the parent’s remaining quantity as the child receives it, preserving lineage without valuing both for the same units.

Review-time cost proposals do not affect layer balances. Effective allocations belong to a posted stock event, with the approved source version, exact quantities and deterministic value remainder. Supplier currency is descriptive; owned values use the installation valuation currency and retain reviewed external conversion evidence where needed.

Count locks validate the whole affected population, including new identities and cost-pool changes that reach a locked position. Authorized corrections bridge the original count to current versions without posting the same difference again. Other unexplained changes require recovery and fresh evidence.

Migration order

Record source namespaces, cutoff, file digests and stable identities in the migration batch. Agree the external accounting opening balance and how later incremental movements will reconcile to it.
Load product categories, stocking units, products and reviewed conversions; establish warehouses, shallow bins, suppliers and active product/site assortment. Load users and effective warehouse assignments with cost visibility checked.
Activate reviewed policies, adjustment reasons, cost methods and reorder settings through the required independent decisions. Unknown costs or missing conversion evidence remain exceptions.
Load current quantity positions and remaining cost layers once, preserving owner, lot, serial, expiry, holds, picked custody and transit. Do not replay all historic movements and also load the resulting current balance.
Reconcile active reservations and partial receipt, issue, transfer and return documents. Preserve gross historical counters and outstanding source requests as the baseline; later native actions add once without reopening already consumed demand.
Compare full quantity, ownership, serial, value, claim and transit totals with the source. Review representative partial and reversal cases, resolve provider uncertainty, and have a different eligible Inventory Manager approve activation before new work begins.

Tables

Find a table 37 tables

ProductsSKU master — finished goods, components, consumables, spares.master

Field	Type	Required	Details
`SKU`	text	yes	Stock-keeping unit code
`Description`	text	yes
`Category`	reference	yes	→ ProductCategories
`ItemType`	select	yes	FinishedGood, Component, Raw, Consumable, Spare
`UOM`	reference	yes	→ UnitsOfMeasure
`StandardCost`	currency		Reviewed current standard in InventoryPolicies.ValuationCurrency per stocking UOM; null until known; mandatory before a Standard-cost posting
`CostMethod`	select	yes	Standard, WeightedAverage, FIFO
`UnitPrice`	currency		Info only
`PrimarySupplier`	reference		→ Suppliers
`LeadTimeDays`	number
`ReorderPoint`	number		Fallback when no ReorderRule exists
`SafetyStock`	number
`LotControlled`	toggle	yes	Forces LotNumber on movements
`SerialControlled`	toggle	yes	Forces SerialNumber
`ShelfLifeDays`	number		Fallback only for a genuinely new lot with evidenced manufacture/origin date; later receipts/returns never reset established expiry
`Barcode`	text		UPC / EAN
`ABCClass`	select		A, B, C (count cadence)
`Active`	toggle	yes
`CostKnown`	toggle	yes	Whether the reviewed applicable cost basis exists; a real zero cost requires explicit evidence
`ReorderQuantity`	number		Fallback fixed order quantity in stocking units
`MinimumOrderQuantity`	number		Fallback supplier minimum in stocking units
`OrderMultiple`	number		Positive order multiple in stocking units
`CostVersion`	number	yes	Effective reviewed cost/method version; referenced history never recalculated
`MergedInto`	reference		→ Products. Approved surviving identity; immutable historic SKU snapshots remain
`MasterChange`	reference		→ MasterChanges

ProductCategoriesHierarchical SKU categories (Electronics → Cables → USB-C).master

Field	Type	Required	Details
`CategoryCode`	text	yes
`CategoryName`	text	yes
`ParentCategory`	reference		→ ProductCategories (self)
`Active`	toggle	yes
`MasterChange`	reference		→ MasterChanges

WarehousesPhysical warehouse / store / stockroom master.master

Field	Type	Required	Details
`WarehouseCode`	text	yes
`Name`	text	yes
`Address`	text	yes
`WarehouseType`	select	yes	Main, Branch, Store, Stockroom, Consignment, Quarantine
`Manager`	reference		→ Users
`TimeZone`	text
`Active`	toggle	yes
`MasterChange`	reference		→ MasterChanges

BinsNamed storage locations within a warehouse. Flat bin grid — enoughmaster

Field	Type	Required	Details
`BinCode`	text	yes
`Warehouse`	reference	yes	→ Warehouses
`Zone`	select		Receiving, Storage, Pick, Ship, Quarantine, Returns
`BinType`	select		Shelf, Pallet, Bulk, Bench, Other
`Active`	toggle	yes
`MasterChange`	reference		→ MasterChanges

UnitsOfMeasureUoM master with conversion factors — items buy in cases, stock inmaster

Field	Type	Required	Details
`UOMCode`	text	yes	EA, KG, L, M, Box, Case, Pallet
`Description`	text	yes
`BaseUOM`	reference		→ UnitsOfMeasure (canonical stocking UoM)
`ConversionFactor`	number		Positive product-independent dimensional factor only; packaging factors require ProductConversions
`Active`	toggle	yes
`Dimension`	select	yes	Count, Mass, Volume, Length, Other
`Precision`	number	yes	Nonnegative allowed decimal places; serial stock is integral
`MasterChange`	reference		→ MasterChanges

SuppliersLight supplier master — name, contact, terms. No contracts, nomaster

Field	Type	Required	Details
`SupplierCode`	text	yes
`CompanyName`	text	yes
`PrimaryContact`	text
`Email`	text
`Phone`	text
`Currency`	select		USD, EUR, GBP, CAD, AUD, JPY, CHF, SGD, Other. Supplier information only; does not set inventory valuation currency
`PaymentTerms`	select		Net 15, Net 30, Net 45, Prepaid
`Active`	toggle	yes
`MasterChange`	reference		→ MasterChanges

ReorderRulesEffective product/warehouse replenishment rule using eligible owned availability. Produces advice for an external Buyer; no local purchasing order or approval.master

Field	Type	Required	Details
`Product`	reference	yes	→ Products
`Warehouse`	reference	yes	→ Warehouses
`ReorderPoint`	number	yes	Eligible current owned available stocking quantity trigger; equality fires
`ReorderQuantity`	number	yes	Suggested order size
`MinimumOrderQuantity`	number		Supplier MOQ
`LeadTimeDays`	number		Overrides Products.LeadTimeDays
`Method`	select	yes	FixedReorderPoint, MinMax, Manual
`LastFiredAt`	date
`Active`	toggle	yes
`TargetQuantity`	number		Required for MinMax; greater than or equal to ReorderPoint
`OrderMultiple`	number		Positive stocking-unit rounding multiple
`Supplier`	reference		→ Suppliers. Optional override of product primary supplier
`Policy`	reference	yes	→ InventoryPolicies
`MasterChange`	reference		→ MasterChanges

StockAdjustmentReasonsReason-code master for adjustments — damage, shrinkage, found stock,master

Field	Type	Required	Details
`ReasonCode`	text	yes
`Name`	text	yes
`Direction`	select	yes	Increase, Decrease, Either
`RequiresApproval`	toggle	yes	True always requires independent Inventory Manager approval; false permits only eligible policy-qualified automatic execution
`GLAccount`	text		Reviewed external accounting offset mapping; local app does not operate the GL
`Active`	toggle	yes
`Policy`	reference	yes	→ InventoryPolicies
`MasterChange`	reference		→ MasterChanges

InventoryCurrent controlled stock position; derived from committed StockMovements, never directly edited. Unique product, warehouse, normalised bin, lot, serial, owner, custody state and transit-transfer identity.transaction

Field	Type	Required	Details
`Product`	reference	yes	→ Products
`Warehouse`	reference	yes	→ Warehouses
`Bin`	reference		→ Bins
`LotNumber`	text		Required when Product.LotControlled
`SerialNumber`	text		Required when Product.SerialControlled
`QuantityOnHand`	number	yes	Nonnegative stocking-unit quantity, including held/picked/transit custody; serial position 0 or 1
`QuantityAllocated`	number	yes	Read-only sum of active Reserved or Picked Reservations still attached to this position; exclude consumed/released portions
`QuantityAvailable`	formula	yes	fx: max(0, QuantityOnHand - QuantityAllocated) only for active owned Stored stock with Status Available, valid expiry and no blocking lock; otherwise 0
`UnitCost`	currency		Current valuation summary per stocking unit from remaining CostLayers; nullable for third-party custody; not a FIFO layer selector
`ExpiryDate`	date		Established lot/serial expiry; immutable source identity unless independently corrected with evidence; actual expiry checked on every availability/issue action
`Status`	select	yes	Available, Quarantine, Hold, Expired, Damaged
`LastMovementDate`	date
`LastUpdated`	date	yes
`PositionNumber`	text	yes	Stable internal position identity
`OwnerType`	select	yes	Owned, ThirdParty
`OwnerReference`	text	yes	Installation owner key for Owned; external legal owner key for ThirdParty
`CustodyState`	select	yes	Stored, Picked, InTransit
`TransitTransfer`	reference		→ Transfers. Required exactly when InTransit; Warehouse is carrying/source site until arrival
`PositionVersion`	number	yes	Incremented atomically by every quantity/status/identity/value effect
`ValueOnHand`	currency		Sum remaining owned layer values; third-party custody excluded from owned valuation
`UpdatedAt`	datetime	yes	Actual last position update with timezone
`LastConsumptionAt`	datetime		Last effective SalesPick/InternalUsage final issue; never refreshed by relocation
`DaysToExpiry`	formula		fx: whole calendar days from warehouse-local today to ExpiryDate; null when no expiry
`MigrationBatch`	reference		→ MigrationBatches

StockMovementsAppend-only signed leg for one exact Inventory position inside a StockEvent. Internal relocation has paired legs; external receipt/issue has one signed stock side. Value-only legs support cost revaluation without changing quantity.transaction

Field	Type	Required	Details
`Product`	reference	yes	→ Products
`FromWarehouse`	reference		→ Warehouses
`FromBin`	reference		→ Bins
`ToWarehouse`	reference		→ Warehouses
`ToBin`	reference		→ Bins
`LotNumber`	text
`SerialNumber`	text
`MovementType`	select	yes	Receipt, Putaway, Issue, Transfer, Pick, Adjustment, ReturnIn, ReturnOut
`Quantity`	number	yes	Signed stocking-unit delta for Position; +in or -out; zero allowed for evidenced value-only action or StockStatusChange audit leg
`UnitCost`	currency		Frozen carrying cost per stocking unit for this leg; owned value also recorded explicitly for rounding
`ReferenceType`	select		GoodsReceipt, Issue, Transfer, CycleCount, PhysicalInventory, Adjustment, Return, Manual
`ReferenceID`	text		Display projection of the validated StockEvents source document; never the deduplication key
`MovementDate`	date	yes
`Operator`	reference		→ Users
`MovementNumber`	text	yes	Unique Event plus LegNumber
`Event`	reference	yes	→ StockEvents
`Position`	reference	yes	→ Inventory
`LegNumber`	number	yes	Unique sequence within Event
`ValueDelta`	currency		Signed owned carrying-value effect, in the installation valuation currency
`OccurredAt`	datetime	yes	Physical/economic evidence timestamp
`PostedAt`	datetime	yes	Atomic local posting time
`Status`	select	yes	Posted. Compensation is another immutable row, never deletion
`ReversalOf`	reference		→ StockMovements. Bounded compensation of this original leg; downstream tracing remains mandatory
`Reason`	reference		→ StockAdjustmentReasons
`BeforeVersion`	number	yes	Expected current position version
`AfterVersion`	number	yes	Committed resulting position version
`SourceMode`	select	yes	Native, MigrationBaseline

GoodsReceiptsOne partial delivery for one external PO line and one controlled product identity. Posted arrival quantity, location, cost and source key are immutable; putaway is a separate bounded operation.transaction

Field	Type	Required	Details
`ReceiptNumber`	text	yes
`ExternalPOReference`	text		PO number from the external procurement system
`Supplier`	reference		→ Suppliers
`Product`	reference	yes	→ Products
`ReceiptDate`	date		Warehouse-local date derived from actual ReceivedAt; null before arrival
`Warehouse`	reference	yes	→ Warehouses
`Bin`	reference		→ Bins. Immutable arrival/receiving bin, belongs to Warehouse; putaway does not overwrite it
`QuantityReceived`	number	yes	Positive receipt quantity in UOM; frozen on Receipt posting; base quantity derived once
`UOM`	reference	yes	→ UnitsOfMeasure
`UnitCost`	currency		Reviewed valuation-currency cost per receipt UOM; null while unresolved; protected from Operator editing
`LotNumber`	text		Required when Product.LotControlled
`SerialNumber`	text		Required when Product.SerialControlled
`ExpiryDate`	date		Established source lot/serial expiry; approved original-date fallback only for new identity, never receipt-date renewal
`ReceivedBy`	reference		→ Users. Actual confirmed receiving actor; null before confirmation
`Status`	select	yes	Draft, Received, PutAway, Closed, Cancelled
`SourceNamespace`	text	yes	External/manual source namespace
`SourceLineID`	text	yes	PO line identity, or reviewed non-PO source line
`DeliveryID`	text	yes	Separate physical partial-delivery identity
`SourceVersion`	text	yes	Source revision/content key; duplicate identity with changed content blocks
`BaseQuantity`	number	yes	QuantityReceived times frozen ConversionFactor
`Conversion`	reference		→ ProductConversions
`ConversionFactor`	number	yes	Positive stocking units per receipt UOM, 1 for same UOM
`SourceCurrency`	text		Original supplier cost currency when externally converted
`SourceUnitCost`	currency		Original cost per receipt UOM before approved external conversion
`ConversionEvidence`	longtext		External conversion pair, rate, date and calculation supporting UnitCost; missing conversion blocks owned posting
`CostKnown`	toggle	yes	Explicit reviewed cost readiness, including evidenced true zero
`CostReviewedBy`	reference		→ Users. Buyer or Inventory Manager
`CostReviewedAt`	datetime		Cost evidence confirmation time
`OwnerType`	select	yes	Owned, ThirdParty
`OwnerReference`	text	yes	Actual title owner; warehouse label cannot determine title
`OriginDate`	date		Manufacture/original lot date used only by approved expiry fallback
`ReceivedAt`	datetime		Actual confirmed arrival; not mere import time
`PutAwayQuantity`	formula	yes	fx: cumulative effective StockEvents Putaway base quantity for this receipt, bounded by received remaining lineage
`ReturnedQuantity`	formula	yes	fx: effective vendor-return/receipt-compensation base quantity with original receipt lineage
`ContentVersion`	number	yes	Material source revision; posted version immutable
`PostedEvent`	reference		→ StockEvents
`MigrationBatch`	reference		→ MigrationBatches
`BaselineQuantities`	longtext		Immutable migrated gross document and effective historic quantity/cost counters at cutoff; current projections equal these plus Native deltas, never replayed baseline history

IssuesOutbound consumption — a pick for a sales order, usage for a worktransaction

Field	Type	Required	Details
`IssueNumber`	text	yes
`IssueType`	select	yes	SalesPick, InternalUsage, Sample, Scrap, Other
`ExternalDemandReference`	text		Sales / work order number
`Product`	reference	yes	→ Products
`Warehouse`	reference	yes	→ Warehouses
`Bin`	reference		→ Bins
`Quantity`	number	yes
`UOM`	reference	yes	→ UnitsOfMeasure
`LotNumber`	text
`IssueDate`	date		Warehouse-local date of first actual IssuedAt; null while only requested/picked
`IssuedBy`	reference		→ Users. Actual first final issue actor; null before confirmation
`Status`	select	yes	Draft, Picked, Issued, Cancelled
`SerialNumber`	text		Required for serial-controlled line; one base unit per serial issue
`BaseQuantity`	number	yes	Requested stocking quantity; frozen conversion from Quantity and UOM
`Conversion`	reference		→ ProductConversions
`ConversionFactor`	number	yes	Positive frozen stocking units per transaction UOM
`IssuedQuantity`	formula	yes	fx: migrated gross confirmed issue quantity plus native actual final issues; returns are separately reported and never reopen request authority
`ReturnedQuantity`	formula	yes	fx: migrated returns plus native evidenced customer returns from original dispatch; does not reduce historical IssuedQuantity
`PickedQuantity`	formula	yes	fx: current picked claim quantity, never another stock issue
`CancelledQuantity`	number	yes	Only unissued remaining request released after physical unpick
`IssuedAt`	datetime		Actual first final issue; individual partial events retain their own times
`CompletedAt`	datetime		All requested quantity issued or explicitly cancelled
`SourceNamespace`	text	yes	Demand source namespace, including Manual
`SourceLineID`	text	yes	External order/usage line identity
`ContentVersion`	number	yes	Material source revision
`MigrationBatch`	reference		→ MigrationBatches
`BaselineQuantities`	longtext		Immutable migrated gross document and effective historic quantity/cost counters at cutoff; current projections equal these plus Native deltas, never replayed baseline history

TransfersInter-warehouse / inter-bin transfers. Two-step — `ShipDate` recordstransaction

Field	Type	Required	Details
`TransferNumber`	text	yes
`FromWarehouse`	reference	yes	→ Warehouses
`FromBin`	reference		→ Bins
`ToWarehouse`	reference	yes	→ Warehouses
`ToBin`	reference		→ Bins (set on arrival)
`Product`	reference	yes	→ Products
`Quantity`	number	yes
`UOM`	reference	yes	→ UnitsOfMeasure
`LotNumber`	text
`RequestedBy`	reference	yes	→ Users
`ApprovedBy`	reference		→ Users
`ShipDate`	date
`ArrivalDate`	date
`Status`	select	yes	Draft, Approved, InTransit, Received, Cancelled
`SerialNumber`	text		Required on serial-controlled transfer line
`BaseQuantity`	number	yes	Requested stocking units, positive
`Conversion`	reference		→ ProductConversions
`ConversionFactor`	number	yes	Frozen positive base units per UOM
`ShippedQuantity`	formula	yes	fx: effective transfer-departure quantity; retained after arrival
`ReceivedQuantity`	formula	yes	fx: received at destination, including separately held/damaged arrival quantity
`ReturnedQuantity`	formula	yes	fx: dispatched transit quantity physically returned to source
`LostQuantity`	formula	yes	fx: separately approved transit write-off quantity
`RemainingInTransit`	formula	yes	fx: ShippedQuantity - ReceivedQuantity - ReturnedQuantity - LostQuantity; nonnegative
`CancelledQuantity`	number	yes	Approved unshipped remainder only
`CarryingValue`	currency		Reviewed owned value of proposed transfer from source layers
`Policy`	reference	yes	→ InventoryPolicies
`Decision`	reference		→ ApprovalDecisions
`ContentVersion`	number	yes	Reviewed source revision; destinations, identity, amount or cost changes invalidate review
`ShippedAt`	datetime		First confirmed departure
`ReceivedAt`	datetime		Last confirmed destination receipt; completion only when all shipped scope resolved
`CompletedAt`	datetime		No transit or unshipped unresolved scope
`MigrationBatch`	reference		→ MigrationBatches
`BaselineQuantities`	longtext		Immutable migrated gross document and effective historic quantity/cost counters at cutoff; current projections equal these plus Native deltas, never replayed baseline history

CycleCountsScheduled partial counts — ABC cadence, zone sweeps, or exception-transaction

Field	Type	Required	Details
`CountNumber`	text	yes
`Warehouse`	reference	yes	→ Warehouses
`Zone`	select		Receiving, Storage, Pick, Ship, Quarantine, Returns
`ScheduledDate`	date	yes
`Coordinator`	reference	yes	→ Users
`CountType`	select	yes	ABCCadence, Random, ZoneSweep, Exception
`Status`	select	yes	Scheduled, InProgress, PendingReview, Adjusted, Closed, Cancelled
`LinesTotal`	number		Read-only count of frozen eligible count lines, including newly discovered identities explicitly added under the lock
`LinesWithVariance`	number		Read-only number with nonzero first submitted variance; later correction does not rewrite accuracy history
`PlannedStart`	datetime	yes	Planned count window start
`PlannedEnd`	datetime	yes	Planned count window end
`StartedAt`	datetime		Actual lock acquisition/start
`ClosedAt`	datetime		Final closure after all lines resolved
`Lock`	reference		→ CountLocks
`Policy`	reference	yes	→ InventoryPolicies
`TransitReconciliation`	longtext		Separate evidence reconciliation for any protected away transit; never part of blind floor counts or LinesTotal

CycleCountLinesPer-bin / per-SKU lines of a CycleCount. Line item of CycleCounts.line item

Field	Type	Required	Details
`Product`	reference	yes	→ Products
`Bin`	reference		→ Bins
`LotNumber`	text
`SerialNumber`	text
`BookQuantity`	number		Frozen at valid count-lock boundary for physically present Stored/Picked stock; blind until first submission; away transit excluded
`CountedQuantity`	number		First submitted stocking quantity, immutable even after recount; accepted correction comes from AcceptedObservation
`Variance`	formula		fx: CountedQuantity − BookQuantity
`VariancePercent`	formula		fx: abs(CountedQuantity - BookQuantity) / abs(BookQuantity) times 100; zero if both zero, null plus ReviewRequired if book zero and found positive
`CountedBy`	reference		→ Users
`CountedAt`	date
`AdjustmentReason`	reference		→ StockAdjustmentReasons
`Status`	select	yes	Assigned, Counted, Recount, Adjusted, Closed
`CycleCount`	reference	yes	→ CycleCounts
`Position`	reference		→ Inventory. Existing position; null only for newly discovered complete identity
`AssignedTo`	reference	yes	→ Users. Actual assigned first counter
`AssignedAt`	datetime	yes	Work assignment time
`Lock`	reference		→ CountLocks
`SnapshotVersion`	number		Version of existing position under the locked scope
`OwnerType`	select	yes	Owned, ThirdParty
`OwnerReference`	text	yes	Explicit title/custody owner
`CustodyState`	select	yes	Stored, Picked, InTransit. Physical-floor lines allow Stored/Picked only; retained InTransit value is separately reconciled, never a zero floor count
`UnitCost`	currency		Reviewed stocking-unit valuation summary; actual layer allocation controls variance value
`CostKnown`	toggle	yes	True after protected owned source-cost review, or explicit ThirdParty/no-owned-value review with UnitCost null
`FirstObservation`	reference		→ CountObservations
`AcceptedObservation`	reference		→ CountObservations. Preserves first count while selecting reviewed recount
`ReviewRequired`	toggle	yes	Materialised policy decision including absolute tolerances, zero-book, controlled identity, status and claims
`Decision`	reference		→ ApprovalDecisions
`Adjustment`	reference		→ StockAdjustments
`SubmittedAt`	datetime		First actual submission
`VarianceValue`	formula		fx: exact first-count signed layer value difference using frozen count cost basis; null until known; accepted correction value is separate
`CostSnapshot`	longtext		Frozen book layer IDs, quantities/values and proposed first-count variance valuation; accepted correction separately retained on StockAdjustments

PhysicalInventoriesWall-to-wall warehouse counts with controlled movement freeze, reviewed local corrections and a separate external accounting reconciliation.transaction

Field	Type	Required	Details
`InventoryNumber`	text	yes
`Warehouse`	reference	yes	→ Warehouses
`StartDate`	date	yes
`EndDate`	date
`Coordinator`	reference	yes	→ Users
`FreezeMovements`	toggle	yes	Must be true during a physical count; CountLocks blocks all stock-changing paths in scope, not only Issues/Transfers
`Status`	select	yes	Planning, Counting, Reconciling, Posted, Closed
`TotalAdjustmentValue`	currency		Net local posted adjustment value in valuation currency; accounting export/acceptance is separate
`Lock`	reference		→ CountLocks
`Policy`	reference	yes	→ InventoryPolicies
`StartedAt`	datetime		Actual freeze start
`PostedAt`	datetime		Local approved count adjustments complete
`ClosedAt`	datetime		Every frozen line resolved and lock closed
`Decision`	reference		→ ApprovalDecisions. Independent Inventory Manager physical-inventory close review
`TransitReconciliation`	longtext		Separate transfer IDs, dispatched/received/returned/lost/remaining quantity and carrying-value proof for away stock; excluded from floor count/accuracy

PhysicalInventoryLinesPer-bin / per-SKU lines of a PhysicalInventory. Line item of PhysicalInventories.line item

Field	Type	Required	Details
`Product`	reference	yes	→ Products
`Bin`	reference		→ Bins
`LotNumber`	text
`BookQuantity`	number		Frozen at valid count-lock boundary for physically present Stored/Picked stock; blind until first submission; away transit excluded
`CountedQuantity`	number		First submitted stocking quantity, immutable even after recount; accepted correction comes from AcceptedObservation
`Variance`	formula		fx: CountedQuantity − BookQuantity
`VarianceValue`	formula		fx: exact first-count signed layer value difference using frozen cost basis; accepted recount/correction does not overwrite it
`CountedBy`	reference		→ Users
`AdjustmentReason`	reference		→ StockAdjustmentReasons
`Status`	select	yes	Assigned, Counted, Recount, Adjusted
`PhysicalInventory`	reference	yes	→ PhysicalInventories
`Position`	reference		→ Inventory. Existing position; null only for newly discovered complete identity
`AssignedTo`	reference	yes	→ Users. Actual assigned first counter
`AssignedAt`	datetime	yes	Work assignment time
`Lock`	reference		→ CountLocks
`SnapshotVersion`	number		Version of existing position under the locked scope
`OwnerType`	select	yes	Owned, ThirdParty
`OwnerReference`	text	yes	Explicit title/custody owner
`CustodyState`	select	yes	Stored, Picked, InTransit. Physical-floor lines allow Stored/Picked only; retained InTransit value is separately reconciled, never a zero floor count
`UnitCost`	currency		Reviewed stocking-unit valuation summary; actual layer allocation controls variance value
`CostKnown`	toggle	yes	True after protected owned source-cost review, or explicit ThirdParty/no-owned-value review with UnitCost null
`FirstObservation`	reference		→ CountObservations
`AcceptedObservation`	reference		→ CountObservations. Preserves first count while selecting reviewed recount
`ReviewRequired`	toggle	yes	Materialised policy decision including absolute tolerances, zero-book, controlled identity, status and claims
`Decision`	reference		→ ApprovalDecisions
`Adjustment`	reference		→ StockAdjustments
`SubmittedAt`	datetime		First actual submission
`SerialNumber`	text		Required for serial-controlled identity
`VariancePercent`	formula		fx: absolute quantity variance / absolute book quantity times 100; zero/zero 0; found positive on zero book null and review
`CostSnapshot`	longtext		Frozen book layer IDs, quantities/values and proposed first-count variance valuation; accepted correction separately retained on StockAdjustments

StockAdjustmentsControlled inventory corrections with explicit cost and quantity evidence; approved policy determines eligible automatic execution or independent Inventory Manager review.transaction

Field	Type	Required	Details
`AdjustmentNumber`	text	yes
`Product`	reference	yes	→ Products
`Warehouse`	reference	yes	→ Warehouses
`Bin`	reference		→ Bins
`LotNumber`	text
`QuantityBefore`	number	yes	Current locked exact-position stocking quantity; checked again atomically at posting
`QuantityAfter`	number	yes
`QuantityDelta`	formula	yes	fx: QuantityAfter − QuantityBefore
`UnitCost`	currency		Reviewed stocking-unit summary of exact layer value delta; null until usable cost is known
`ValueDelta`	formula	yes	fx: exact proposed owned layer-value sum from CostAllocationProposal before posting, reconciled to posted CostAllocations afterwards; not quantity times current Product cost
`Reason`	reference	yes	→ StockAdjustmentReasons
`SourceDocument`	select		CycleCount, PhysicalInventory, Manual, Return, Expiry
`RequestedBy`	reference	yes	→ Users
`ApprovedBy`	reference		→ Users
`Status`	select	yes	Draft, PendingApproval, Approved, Posted, Rejected, Cancelled
`AdjustedAt`	date		Warehouse-local date of actual PostedAt; null until posted
`Notes`	text
`SerialNumber`	text		Required for serial-controlled identity
`Position`	reference		→ Inventory. Existing source position; found stock creates a separately reviewed identity
`OwnerType`	select	yes	Owned, ThirdParty
`OwnerReference`	text	yes	Explicit owner identity
`CustodyState`	select	yes	Stored, Picked, InTransit
`Transfer`	reference		→ Transfers. Required for transit discrepancy
`CycleCountLine`	reference		→ CycleCountLines
`PhysicalInventoryLine`	reference		→ PhysicalInventoryLines
`CostKnown`	toggle	yes	Known reviewed owned cost, or explicitly reviewed ThirdParty/no-owned-value basis; unknown owned cost blocks execution
`CostEvidence`	longtext		Layer selection, source valuation and nonzero/true-zero evidence
`Policy`	reference	yes	→ InventoryPolicies
`Decision`	reference		→ ApprovalDecisions
`ExecutionMode`	select	yes	Unresolved, PolicyAutomatic, HumanApproved
`ContentVersion`	number	yes	Quantity/cost/reason/identity/source revision; freezes at submission
`SubmittedAt`	datetime		Actual request for review
`PostedAt`	datetime		Actual stock event commit time
`PostedEvent`	reference		→ StockEvents
`ExpectedVersion`	number		Current exact position revision; new identity checks locked population
`MigrationBatch`	reference		→ MigrationBatches
`CostAllocationProposal`	longtext		Frozen layer/quantity/value proposal and rounding residual before approval; not an effective posting
`OriginSupplier`	reference		→ Suppliers. Known source of found/expiry quantity where documented, otherwise null

ReturnAuthorizationsReturn Merchandise Authorizations — customer returns (stock in) ortransaction

Field	Type	Required	Details
`RMANumber`	text	yes
`ReturnType`	select	yes	CustomerReturn, VendorReturn
`Supplier`	reference		→ Suppliers (for VendorReturn)
`CustomerReference`	text		External customer / order number
`OriginalReceipt`	reference		→ GoodsReceipts
`Product`	reference	yes	→ Products
`QuantityAuthorized`	number	yes	Positive stocking-unit cap; cumulative effective returned identity cannot exceed original eligible dispatch/receipt quantity
`QuantityReceived`	number	yes	Read-only actual customer returned stocking quantity; not vendor QuantityDispatched
`Warehouse`	reference	yes	→ Warehouses
`LotNumber`	text
`Reason`	select	yes	Damaged, Defective, WrongItem, Overshipment, Warranty, Other
`Disposition`	select	yes	Restock, Scrap, ReturnToVendor, Refund, Pending
`IssuedAt`	date		Date of actual AuthorizedAt/issued return authorization; null in preparation
`Status`	select	yes	Draft, PendingApproval, Issued, InTransit, Received, Inspected, Closed, Cancelled, Rejected
`OriginalIssue`	reference		→ Issues. Required customer dispatch lineage, including approved imported historic issue
`OriginalMovement`	reference		→ StockMovements. Exact original dispatch/receipt lineage; customer return uses eligible original issue cost, vendor return removes current descendant carrying value
`Bin`	reference		→ Bins. Actual return custody or vendor-dispatch bin
`SerialNumber`	text		Exact returned serial; cannot substitute another identity
`UOM`	reference	yes	→ UnitsOfMeasure
`ConversionFactor`	number	yes	Frozen positive stocking units per UOM; all cumulative quantity fields use base units
`OwnerType`	select	yes	Owned, ThirdParty
`OwnerReference`	text	yes	Actual title owner; customer-arrival custody is unavailable until decision
`QuantityDispatched`	number	yes	Read-only cumulative effective vendor ReturnOut stocking quantity
`QuantityRestocked`	number	yes	Read-only accepted customer return stocking quantity moved from held to eligible stock
`QuantityScrapped`	number	yes	Read-only evidenced disposition out of held stock, once
`QuantityReturnedToCustomer`	number	yes	Read-only unaccepted physical return out, preserving external customer ownership
`AuthorizedBy`	reference		→ Users. Inventory Manager; independent of requester/material editor
`RequestedBy`	reference	yes	→ Users. Buyer for vendor return, Inventory Manager for customer return
`Decision`	reference		→ ApprovalDecisions
`DispositionDecision`	reference		→ ApprovalDecisions. Inventory Manager title/status/simple condition decision; no formal QMS claim
`RequestedAt`	datetime	yes	Actual preparation time
`AuthorizedAt`	datetime		Actual authority decision
`ClosedAt`	datetime		All authorized/effected inventory scope resolved, including explicitly unused cancelled remainder
`ExternalRefundReference`	text		External financial follow-up only; never proves payment
`FinancialFollowup`	select	yes	NotRequired, Requested, Acknowledged, ConfirmedExternal, Disputed
`ContentVersion`	number	yes	Frozen authorized identity and quantity revision
`MigrationBatch`	reference		→ MigrationBatches
`BaselineQuantities`	longtext		Immutable migrated gross document and effective historic quantity/cost counters at cutoff; current projections equal these plus Native deltas, never replayed baseline history
`CommercialReturnValue`	currency		Reviewed expected vendor settlement/credit for actual cumulative dispatched scope in valuation currency, with external conversion evidence; not cash or posted GL value
`CarryingValueReturned`	formula		fx: cumulative current carrying value actually removed by native/migrated vendor ReturnOut allocations; no double count of original receipt
`ReturnSettlementVariance`	formula		fx: known CommercialReturnValue for dispatched scope minus CarryingValueReturned; informational external finance difference, null while unknown
`SettlementEvidence`	longtext		Original commercial receipt basis, agreed vendor credit scope, currency/rate/date and actual external settlement references; separate from inventory value

UsersAuthenticated actual people with the five declared roles; identities remain stable when roles or employment change.master

Field	Type	Required	Details
`UserID`	text	yes	Authenticated stable person identifier; same person with multiple roles remains one actor
`Name`	text	yes	Display name
`Role`	select	yes	Admin, Inventory Manager, Warehouse Operator, Buyer, Viewer
`Roles`	longtext	yes	Approved set of these same five roles; no extra approval role
`Active`	toggle	yes	Deactivated actors cannot perform new actions
`ApprovalLimit`	currency		Explicit finite Inventory Manager adjustment/transfer value limit in valuation currency; missing means no authority

UserWarehousesEffective role-to-site assignment and scope evidence.master

Field	Type	Required	Details
`User`	reference	yes	→ Users
`Warehouse`	reference	yes	→ Warehouses
`Roles`	longtext	yes	Subset of declared user roles allowed at this warehouse
`EffectiveFrom`	datetime	yes	Inclusive
`EffectiveTo`	datetime		Exclusive
`Active`	toggle	yes	Only current approved assignments grant action scope
`MasterChange`	reference	yes	→ MasterChanges

ProductConversionsApproved product-specific conversion into the stocking UOM; packaging is never assumed universal.master

Field	Type	Required	Details
`Product`	reference	yes	→ Products
`FromUOM`	reference	yes	→ UnitsOfMeasure
`ToUOM`	reference	yes	→ UnitsOfMeasure. Must equal Products.UOM for this version
`Factor`	number	yes	Positive stocking units per input unit
`EffectiveFrom`	datetime	yes	Inclusive version validity
`EffectiveTo`	datetime		Exclusive
`MasterChange`	reference	yes	→ MasterChanges
`Active`	toggle	yes	Only reviewed nonoverlapping version used by new documents

InventoryPoliciesImmutable approved installation/site control version, in one explicit inventory valuation currency.master

Field	Type	Required	Details
`PolicyNumber`	text	yes	Versioned policy identifier
`Warehouse`	reference		→ Warehouses. Null means installation default
`ValuationCurrency`	text	yes	One ISO currency per installation; all owned inventory costs/limits/exports use it
`CurrencyPrecision`	number	yes	Decimal rounding precision, with deterministic final-line residual
`QuantityTolerance`	number	yes	Nonnegative absolute stocking-unit tolerance
`PercentTolerance`	number	yes	Nonnegative absolute percentage tolerance; default may be 2 only if approved
`AutomaticValueLimit`	currency	yes	Nonnegative maximum absolute owned adjustment value; equality eligible only if every other condition passes
`AutomaticTransfers`	toggle	yes	Whether eligible within-limit standard transfers can be policy-authorised
`TransferValueLimit`	currency	yes	Finite maximum for automatic transfer; equality eligible; missing cost blocks
`AutomaticAdjustments`	toggle	yes	Allows eligible low-risk execution, never a human approval
`PolicyDetails`	longtext	yes	Eligible reasons, ownership, status, standard-cost basis, return controls, expiry cutoffs, accounting mappings and rounding
`ReorderCooldownHours`	number	yes	Minimum reminder interval; outstanding alert identity is reused
`ABCCutoffs`	longtext	yes	Reviewed cumulative positive issue-value cutoffs and deterministic ties; zero-history class treatment
`EffectiveFrom`	datetime	yes	Inclusive activation time
`EffectiveTo`	datetime		Exclusive supersession
`PreparedBy`	reference	yes	→ Users
`ApprovedBy`	reference		→ Users. Independent Admin, not preparer/material editor
`ApprovedAt`	datetime		Actual reviewed activation
`Status`	select	yes	Draft, Submitted, Active, Superseded, Rejected
`MasterChange`	reference		→ MasterChanges

ApprovalDecisionsImmutable review or explicit policy-execution evidence bound to exact content and actual actors.transaction

Field	Type	Required	Details
`DecisionNumber`	text	yes	Unique target/revision/decision identifier
`Kind`	select	yes	Adjustment, CountReview, Transfer, ReturnAuthorization, ReturnDisposition, PhysicalClose, Migration, AccountingExport, MasterActivation, StockStatusChange, TitleChange
`TargetTable`	text	yes	Validated declared target table appropriate to Kind
`TargetID`	text	yes	Existing stable target identity, never an unvalidated display number
`ContentVersion`	number	yes	Reviewed revision
`ContentHash`	text	yes	Exact quantities, cost layers, identity, reason, destinations and relevant limits
`RequestedBy`	reference	yes	→ Users
`MaterialEditors`	longtext	yes	Authenticated actual person IDs excluded from independent human approval
`CounterIDs`	longtext		First and recount actors excluded from approval of their own count
`DecidedBy`	reference		→ Users. Null only for PolicyAutomatic; human kinds require eligible independent declared role
`Mode`	select	yes	Human, PolicyAutomatic
`Policy`	reference	yes	→ InventoryPolicies
`ReviewedValue`	currency		Absolute reviewed owned value in valuation currency; third-party quantity-only custody has reviewed zero owned effect, not a made-up unit cost
`LimitSnapshot`	currency		Finite eligible actor/policy limit used
`DecisionAt`	datetime	yes	Actual decision/execution qualification timestamp
`Status`	select	yes	Approved, Rejected, RecountRequired, Invalidated
`Rationale`	longtext	yes	Evidence and checks; no reused approval after material revision

MasterChangesControlled master/configuration/identity change with immutable old/new evidence.transaction

Field	Type	Required	Details
`ChangeNumber`	text	yes	Stable change identifier
`TargetTable`	text	yes	Validated master table
`TargetID`	text	yes	Stable record identity
`OldValues`	longtext	yes	Exact prior values/version
`NewValues`	longtext	yes	Exact proposed values/version
`PreparedBy`	reference	yes	→ Users
`MaterialEditors`	longtext	yes	Actual person IDs
`ApprovedBy`	reference		→ Users. Independent Admin; cannot be preparer or material editor
`RequestedAt`	datetime	yes	Actual request
`EffectiveAt`	datetime		Reviewed activation time; never retroactive repricing
`Status`	select	yes	Draft, Submitted, Approved, Applied, Rejected, Superseded
`Reason`	longtext	yes	Business reason; merges preserve original IDs/history and compatible stock identity
`Decision`	reference		→ ApprovalDecisions

StockEventsAtomic inventory business action containing signed position legs and cost allocations.transaction

Field	Type	Required	Details
`EventNumber`	text	yes	Unique economic/action identity
`Action`	select	yes	Receipt, Putaway, Reserve, Pick, Unpick, Issue, TransferShip, TransferReceive, TransferReturn, TransitLoss, CountAdjustment, ManualAdjustment, CustomerReturnReceive, ReturnDisposition, VendorReturnShip, ReceiptCompensation, IssueCompensation, CostRevalue, WeightedAverageRebalance, OpeningBaseline, StockStatusChange, TitleChange
`GoodsReceipt`	reference		→ GoodsReceipts
`Issue`	reference		→ Issues
`Transfer`	reference		→ Transfers
`Adjustment`	reference		→ StockAdjustments
`ReturnAuthorization`	reference		→ ReturnAuthorizations
`MigrationBatch`	reference		→ MigrationBatches
`SourceNamespace`	text	yes	Manual or authenticated external source
`SourceActionID`	text	yes	Unique namespace/document-line/action/partial-operation identity
`ContentVersion`	number	yes	Expected source revision
`PayloadHash`	text	yes	Changed payload under the same identity requires review
`BaseQuantity`	number	yes	Positive operated stocking quantity; zero only for value-only actions or a whole-position StockStatusChange with no quantity/value effect
`OccurredAt`	datetime	yes	Actual physical/economic evidence time
`RequestedAt`	datetime	yes	Action preparation time
`PostedAt`	datetime		Actual atomic local effect time
`PerformedBy`	reference	yes	→ Users. Accountable eligible actor for physical/prepared action; PolicyAutomatic retains proposer plus null human DecidedBy, not a fictional signer
`Decision`	reference		→ ApprovalDecisions
`ReversalOf`	reference		→ StockEvents. Bounded compensation, never erasure of original physical history
`Evidence`	longtext	yes	Actual scan/physical confirmation, source-line identity and before/after versions
`Status`	select	yes	Prepared, Posted, Rejected, Cancelled
`SourceMode`	select	yes	Native, MigrationBaseline
`IntegrationEvent`	reference		→ IntegrationEvents
`CostPolicy`	reference	yes	→ InventoryPolicies. Frozen cost/rounding/limit/account mapping used
`StockedProduct`	reference	yes	→ Products. Common product must agree with every source, position and layer
`CostProposal`	longtext	yes	Frozen planned layer/quantity/value effects and external variance; posting writes only the approved/current proposal
`SourcePositionManifest`	longtext	yes	Expected exact source/destination and layer IDs/versions, with lock scope and controlled identity checks
`PreparedBy`	reference	yes	→ Users. Actual request preparer; must differ from required independent DecidedBy
`ChangeBefore`	longtext		StockStatusChange/TitleChange exact source-position quantity, status, owner, custody, version and carrying layers
`ChangeAfter`	longtext		Reviewed resulting status or title identity, affected quantity and known owned-cost basis; changes no physical arrival history

ReservationsQuantity claim by one Issue, Transfer or vendor return against one exact eligible stock position.transaction

Field	Type	Required	Details
`ReservationNumber`	text	yes	Unique demand-line/position/claim identity
`Position`	reference	yes	→ Inventory
`Issue`	reference		→ Issues
`Transfer`	reference		→ Transfers
`ReturnAuthorization`	reference		→ ReturnAuthorizations
`Quantity`	number	yes	Positive stocking quantity initially claimed
`ConsumedQuantity`	number	yes	Cumulative final dispatch/issue consumption, bounded by claim
`ReleasedQuantity`	number	yes	Cumulative physically reconciled released remainder
`RemainingQuantity`	formula	yes	fx: Quantity - ConsumedQuantity - ReleasedQuantity; nonnegative
`State`	select	yes	Reserved, Picked, Consumed, Released
`CreatedAt`	datetime	yes	Actual atomic reservation time
`UpdatedAt`	datetime	yes	Actual latest claim state change
`ClaimKey`	text	yes	Replay-safe demand/position/action identity
`PositionVersion`	number	yes	Expected position version before claim/update
`SourceMode`	select	yes	Native, MigrationBaseline
`MigrationBatch`	reference		→ MigrationBatches
`PickedAt`	datetime		Actual hard-pick confirmation
`ReleasedAt`	datetime		Last physical reconciliation/release
`ClaimEvent`	reference	yes	→ StockEvents. Unique reservation/update business effect
`LayerClaims`	longtext		Validated layer IDs and quantities when exact receipt/serial provenance is required; atomically bounded across active claims

CostLayersRemaining stocking quantity and carrying value by receipt/origin and current position; FIFO lineage also supports pooled and standard valuation.transaction

Field	Type	Required	Details
`LayerNumber`	text	yes	Stable origin/split layer identifier
`Product`	reference	yes	→ Products
`Position`	reference	yes	→ Inventory
`OriginalReceipt`	reference		→ GoodsReceipts
`OriginalIssue`	reference		→ Issues. Returned issued-cost lineage
`Supplier`	reference		→ Suppliers. Original receipt supplier for provenance, never guessed from current primary supplier
`ParentLayer`	reference		→ CostLayers. Split/move/return lineage
`CreatedEvent`	reference	yes	→ StockEvents
`OriginalQuantity`	number	yes	Initial positive quantity for this layer/split; history immutable
`OriginalValue`	currency	yes	Initial owned carrying value; zero only with reviewed true-zero basis
`RemainingQuantity`	number	yes	Derived effective layer quantity, nonnegative
`RemainingValue`	currency	yes	Derived carrying value from effective cost allocations excluding PurchaseVariance; nonnegative, final residual preserved
`OriginalUnitCost`	currency	yes	Frozen initial value per stocking unit
`Method`	select	yes	Standard, WeightedAverage, FIFO
`CostVersion`	number	yes	Reviewed method/standard basis at action
`ReceivedAt`	datetime	yes	Original FIFO age preserved on transfer and return
`Currency`	text	yes	Installation valuation currency
`SourceMode`	select	yes	Native, MigrationBaseline
`MigrationBatch`	reference		→ MigrationBatches

CostAllocationsImmutable signed effect on a cost layer belonging to one atomic stock action.transaction

Field	Type	Required	Details
`AllocationNumber`	text	yes	Unique event/leg/layer/allocation identity
`Event`	reference	yes	→ StockEvents
`Movement`	reference		→ StockMovements. Matching exact position leg, absent only for classified external variance
`Layer`	reference	yes	→ CostLayers
`QuantityDelta`	number	yes	Signed stocking quantity; value-only rebalancing has zero quantity
`ValueDelta`	currency	yes	Signed carrying-value change in valuation currency
`AllocationKind`	select	yes	Create, Consume, Move, Return, Compensation, PoolRebalance, StandardRevalue, PurchaseVariance
`ReversalOf`	reference		→ CostAllocations. Bounded corresponding original cost effect
`CreatedAt`	datetime	yes	Atomic posting time
`SourceMode`	select	yes	Native, MigrationBaseline
`Status`	select	yes	Posted. Proposed allocations live in reviewed source evidence, not effective layer balances

CountLocksExclusive versioned stock-change lock for a warehouse or explicit bin population.transaction

Field	Type	Required	Details
`LockNumber`	text	yes	Stable controlled count boundary
`Warehouse`	reference	yes	→ Warehouses
`Bins`	longtext	yes	Validated bin IDs, or explicit WholeWarehouse; null-bin population explicitly included
`CycleCount`	reference		→ CycleCounts
`PhysicalInventory`	reference		→ PhysicalInventories
`ScopeHash`	text	yes	Frozen physically counted identity population and versions plus separately identified protected transit/value scope; new physical identities detected
`AcquiredAt`	datetime	yes	Actual boundary after in-flight actions resolve
`ExpiresAt`	datetime	yes	Recovery deadline; expiry does not authorise stale adjustment
`ReleasedAt`	datetime		Actual closure/recovery release
`Coordinator`	reference	yes	→ Users. Inventory Manager
`Status`	select	yes	Requested, Active, RecoveryRequired, Released, Cancelled
`RecoveryEvidence`	longtext		Movement reconciliation and fresh observation requirements before replacement lock

CountObservationsImmutable first/recount evidence, kept separately from accepted count projections.transaction

Field	Type	Required	Details
`ObservationNumber`	text	yes	Unique line/attempt identity
`CycleCountLine`	reference		→ CycleCountLines
`PhysicalInventoryLine`	reference		→ PhysicalInventoryLines
`Lock`	reference	yes	→ CountLocks
`Attempt`	number	yes	1 first count, positive successive recount number
`AssignedTo`	reference	yes	→ Users
`CountedBy`	reference		→ Users. Actual person; recount independent of first counter when requested by reviewer
`CountedQuantity`	number		Nonnegative stocking quantity; a specific serial is 0 or 1 only, duplicate/mismatched serials require identity investigation; null before submission
`CountedAt`	datetime		Actual observation time
`SubmittedAt`	datetime		Actual completion time
`PopulationHash`	text	yes	Locked scope and expected identity/version hash
`Status`	select	yes	Assigned, Submitted, Accepted, Superseded, Rejected
`Evidence`	longtext		Scan/count details without disclosing blind book quantity before submission

StockSummariesCurrent product/warehouse projection generated from the configured stocked population, including never-received and zero stock.master

Field	Type	Required	Details
`SummaryNumber`	text	yes	Unique Product plus Warehouse
`Product`	reference	yes	→ Products
`Warehouse`	reference	yes	→ Warehouses
`Stocked`	toggle	yes	Reviewed product-site assortment; active eligible zero rows retained
`QuantityOnHand`	number	yes	Owned physical stored/picked quantity at site, excluding transit (shown separately)
`QuantityAllocated`	number	yes	Owned active claims on site stock
`QuantityAvailable`	number	yes	Sum eligible owned current position availability
`TransitQuantity`	number	yes	Owned inbound transfer outstanding to this site; disclosed separately, excluded from reorder trigger
`ThirdPartyQuantity`	number	yes	Custody only, excluded from owned valuation and replenishment
`ValueOnHand`	currency	yes	Current owned nontransit layer value at site
`UnitCost`	currency		ValueOnHand / owned on-hand, null at zero quantity
`ReorderPoint`	number		Effective active rule then product fallback
`ReorderQuantity`	number		Effective configured fixed order quantity
`SuggestedQuantity`	number		Policy method result in stocking units; advice, not PO creation
`PrimarySupplier`	reference		→ Suppliers
`LeadTimeDays`	number		Rule then product fallback; unknown stays unknown
`ReorderState`	select	yes	Normal, Low, OutOfStock, Manual, Unconfigured
`LastMovementDate`	date		Latest physical movement for operational reference
`LastConsumptionAt`	datetime		Latest eligible final consumption only
`DaysSinceConsumption`	number		Days since last demand consumption; null if never consumed
`NeverConsumed`	toggle	yes	No eligible observed consumption history
`AsOf`	datetime	yes	Projection cutoff, version and timezone
`Policy`	reference	yes	→ InventoryPolicies
`ReorderRule`	reference		→ ReorderRules

StockSnapshotsImmutable dated product/warehouse observation for stockout, valuation and turnover reporting.transaction

Field	Type	Required	Details
`SnapshotNumber`	text	yes	Unique scope/cutoff/version
`Summary`	reference	yes	→ StockSummaries
`AsOf`	datetime	yes	Exact accounting/operating cutoff
`LocalDate`	date	yes	Warehouse-local reporting day
`Stocked`	toggle	yes	Frozen eligible assortment flag
`QuantityAvailable`	number	yes	Current eligible owned available at cutoff
`OwnedQuantity`	number	yes	Owned stored/picked plus separately identified transit quantity
`OwnedValue`	currency	yes	Owned layer carrying value, including transit once
`TransitValue`	currency	yes	Subset carried at source until arrival; never also destination valued
`Currency`	text	yes	Installation valuation currency
`LayerManifest`	longtext	yes	Exact layer IDs, quantities, values and versions, with hash
`Policy`	reference	yes	→ InventoryPolicies
`Status`	select	yes	Draft, Frozen, Superseded
`Coverage`	select	yes	Complete, Incomplete
`CapturedAt`	datetime	yes	Actual capture time

ReorderAlertsOne ongoing low/out-of-stock episode per product and warehouse, with acknowledgment and bounded reminders.transaction

Field	Type	Required	Details
`AlertNumber`	text	yes	Unique summary/episode identity
`Summary`	reference	yes	→ StockSummaries
`OpenedAt`	datetime	yes	First threshold crossing or first eligible observation
`LastEvaluatedAt`	datetime	yes	Latest current quantity evaluation
`AcknowledgedBy`	reference		→ Users. Buyer or Inventory Manager
`AcknowledgedAt`	datetime		Actual acknowledgment
`ResolvedAt`	datetime		Recovery above threshold; future crossing starts new episode
`Status`	select	yes	Open, Acknowledged, Resolved, Suppressed
`SuggestedQuantity`	number		Latest proposal with policy basis, not approved procurement
`ExternalPOReference`	text		Buyer's external follow-up, not local ordering authority
`LastNotifiedAt`	datetime		Actual verified delivery time
`Policy`	reference	yes	→ InventoryPolicies

AccountingExportsExternal accounting handoff of unique unexported stock value deltas; snapshots reconcile control balances and never repost full inventory.transaction

Field	Type	Required	Details
`ExportNumber`	text	yes	Unique installation/period/batch identity
`Period`	text	yes	Reviewed external accounting period
`Currency`	text	yes	Installation valuation currency
`Policy`	reference	yes	→ InventoryPolicies
`MovementManifest`	longtext	yes	Unique movement/cost-variance IDs, mapped accounts and signed amounts, source hashes; no ID accepted twice
`ControlSnapshotManifest`	longtext	yes	Exact StockSnapshots IDs and previous/current inventory control reconciliation
`Amount`	currency	yes	Net inventory-account delta, not full closing inventory value
`PreparedBy`	reference	yes	→ Users. Inventory Manager
`Decision`	reference		→ ApprovalDecisions. Independent Inventory Manager release, not preparer/editor
`PreparedAt`	datetime	yes	Actual preparation
`RequestedAt`	datetime		Outbound request timestamp
`AcceptedAt`	datetime		Authoritative accounting acceptance only
`ExternalJournalID`	text		Verified destination journal identity
`DeliveryKey`	text	yes	Stable same-payload destination action key
`Status`	select	yes	Draft, Submitted, Approved, Sent, Uncertain, Accepted, Rejected, Corrected
`Corrects`	reference		→ AccountingExports. Referenced bounded corrective delta, not duplicate original journal
`IntegrationEvent`	reference		→ IntegrationEvents

IntegrationEventsAuthenticated inbound identity and outbound intent/acknowledgment, separate from stock evidence.transaction

Field	Type	Required	Details
`IntegrationNumber`	text	yes	Stable source/destination event identity
`Direction`	select	yes	Inbound, Outbound
`System`	text	yes	Configured authenticated source/destination
`Action`	text	yes	Reviewed operation contract; no implied universal endpoint
`ExternalID`	text	yes	External event/idempotency identity
`PayloadHash`	text	yes	Same key changed content is a conflict, not another effect
`ReceivedAt`	datetime	yes	Actual ingress or prepared intent time
`Authenticated`	toggle	yes	Inbound verified before effect processing
`Status`	select	yes	Prepared, Verified, Applied, Sent, Acknowledged, Uncertain, Rejected, Conflict
`StockEvent`	reference		→ StockEvents
`AccountingExport`	reference		→ AccountingExports
`ExternalResultID`	text		Authoritative accepted object/effect identity
`AcknowledgedAt`	datetime		Actual provider acknowledgment
`ReconciledBy`	reference		→ Users. Eligible domain owner after uncertainty lookup
`Evidence`	longtext	yes	Contract version, source watermarks, actual result and repeat-effect reconciliation

MigrationBatchesIndependently approved opening cutover with explicit source identity and no ordinary-reason approval exemption.transaction

Field	Type	Required	Details
`BatchNumber`	text	yes	Unique source/cutoff/install migration identity
`SourceNamespace`	text	yes	Retained original source and stable item IDs
`Cutoff`	datetime	yes	Agreed effect cutoff; old/new system boundary
`Manifest`	longtext	yes	Versioned source rows and hashes for positions, layers, owners, serials, holds, claims, transit and partial documents
`ControlTotals`	longtext	yes	Quantity/value by product/site/owner/status/currency; external GL opening agreement
`SourceWatermarks`	longtext	yes	Already processed source actions and unresolved external requests
`PreparedBy`	reference	yes	→ Users. Inventory Manager
`Decision`	reference		→ ApprovalDecisions. Different Inventory Manager, not preparer/editor/counter
`PreparedAt`	datetime	yes	Actual preparation time
`ActivatedAt`	datetime		After all controls and representative partial operations checked
`Status`	select	yes	Draft, Validated, Submitted, Approved, Activated, Rejected
`Reconciliation`	longtext	yes	No duplicate historic stock/accounting/outreach effects; opening details agree with one external GL baseline

ERP•AI workspace

Start now Inventory Management

Create your ERP.AI account and get started with Proto.

Start now Download agent

Previous · reference 2 of 6Reports and analytics Next · reference 4 of 6Integrations

Inventory Management

Modules

Inventory Management

Processes

Inventory Management

Industries

Inventory Management

Reference

Inventory Management

Data model

How the model is organized

Products and locations

Identity and access

Stock and value

Operational work

Counting

Governance

Replenishment

History and handoff

Keys and references

Migration order

Tables

Start now Inventory Management

Inventory Management

Modules

Inventory Management

Processes

Inventory Management

Industries

Inventory Management

Reference

Data model

How the model is organized

Products and locations

Identity and access

Stock and value

Operational work

Counting

Governance

Replenishment

History and handoff

Keys and references

Migration order

Tables

Start now Inventory Management

Your Privacy, Your Choice

Manage Your Cookie Preferences