Coflyr · Backend model field catalog

StockItem

public.StockItems.

18 mapped fields8 field groupsGenerated 2026-10-06

Model class: coflyr.features.materialmanagement.stores.models.StockItem
Source: Features/MaterialManagement/Stores/Models/StockItem.cs
Table: public.StockItems
Review: Not marked

Every mapped scalar field appears once. Types and nullability come from the current EF model snapshot. Navigation properties and unmapped DTO fields are outside this page. Purpose text is inferred from names and should be checked against the feature workflow.

← All model classes · AMOS Workpackage example

Identity and naming

4 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`BatchNumber`	`string`	Required	Records batch number for this stock item.
3	`SerialNumber`	`string`	Required	Records serial number for this stock item.
4	`TagNumber`	`string`	Required	Records tag number for this stock item.

Relationships and references

3 fields

#	Field	EF type	Storage	Business purpose
1	`ConditionId`	`Guid?`	Nullable	Selects the related condition record.
2	`FacilityId`	`Guid`	Required	Selects the related facility record.
3	`PartId`	`Guid`	Required	Selects the related part record.

Status and controls

2 fields

#	Field	EF type	Storage	Business purpose
1	`IsQuarantined`	`bool`	Required	Indicates whether quarantined applies to this stock item.
2	`ItemStatus`	`int`	Required	Tracks the item status of this stock item.

Dates and timing

3 fields

#	Field	EF type	Storage	Business purpose
1	`ExpiryDate`	`DateTime?`	Nullable	Records the expiry date for this stock item.
2	`ManufactureDate`	`DateTime?`	Nullable	Records the manufacture date for this stock item.
3	`TagDate`	`DateTime?`	Nullable	Records the tag date for this stock item.

Amounts and measurements

2 fields

#	Field	EF type	Storage	Business purpose
1	`QuantityOnHand`	`decimal`	Required	Records quantity on hand for this stock item.
2	`QuantityReserved`	`decimal`	Required	Records quantity reserved for this stock item.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`QuarantineReason`	`string`	Nullable	Records quarantine reason for this stock item.

Audit and revision

2 fields

#	Field	EF type	Storage	Business purpose
1	`SystemAuditId`	`Guid?`	Nullable	Links to system audit history when this model stores the reference.
2	`UpdateId`	`Guid?`	Nullable	Links to the preceding revision or update record.

Other fields

1 fields

#	Field	EF type	Storage	Business purpose
1	`BinLocation`	`string`	Required	Records bin location for this stock item.