Coflyr · Backend model field catalog

PurchaseOrderItem

public.PurchaseOrderItems.

16 mapped fieldsUnder development6 field groupsGenerated 2026-10-06

Model class: coflyr.features.materialmanagement.orders.models.PurchaseOrderItem
Source: Features/MaterialManagement/Orders/Models/PurchaseOrderItem.cs
Table: public.PurchaseOrderItems
Review: Under development as of 2026-10-07. Field review remains open.

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

2 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`LineNumber`	`int`	Required	Records line number for this purchase order item.

Relationships and references

3 fields

#	Field	EF type	Storage	Business purpose
1	`DestinationFacilityId`	`Guid?`	Nullable	Selects the related destination facility record.
2	`PartId`	`Guid`	Required	Selects the related part record.
3	`PurchaseOrderId`	`Guid`	Required	Selects the related purchase order record.

Status and controls

1 fields

#	Field	EF type	Storage	Business purpose
1	`LineStatus`	`string`	Required	Tracks the line status of this purchase order item.

Dates and timing

2 fields

#	Field	EF type	Storage	Business purpose
1	`PromisedDeliveryDate`	`DateTime?`	Nullable	Records the promised delivery date for this purchase order item.
2	`RequestedDeliveryDate`	`DateTime?`	Nullable	Records the requested delivery date for this purchase order item.

Amounts and measurements

6 fields

#	Field	EF type	Storage	Business purpose
1	`DiscountPercent`	`decimal`	Required	Stores the discount percent used by this purchase order item.
2	`LineTotal`	`decimal`	Required	Stores the line total used by this purchase order item.
3	`QuantityCancelled`	`decimal`	Required	Records quantity cancelled for this purchase order item.
4	`QuantityOrdered`	`decimal`	Required	Records quantity ordered for this purchase order item.
5	`QuantityReceived`	`decimal`	Required	Records quantity received for this purchase order item.
6	`UnitPrice`	`decimal`	Required	Stores the unit price used by this purchase order 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.