Coflyr · Backend model field catalog

PurchaseRequisition

public.PurchaseRequisitions.

15 mapped fields8 field groupsGenerated 2026-10-06

Model class: coflyr.features.materialmanagement.orders.models.PurchaseRequisition
Source: Features/MaterialManagement/Orders/Models/PurchaseRequisition.cs
Table: public.PurchaseRequisitions
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

2 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`RequisitionNumber`	`string`	Required	Records requisition number for this purchase requisition.

Relationships and references

2 fields

#	Field	EF type	Storage	Business purpose
1	`DepartmentId`	`Guid`	Required	Selects the related department record.
2	`RequestedByStaffId`	`Guid?`	Nullable	Selects the related requested by staff record.

Status and controls

3 fields

#	Field	EF type	Storage	Business purpose
1	`IsApproved`	`bool`	Required	Indicates whether approved applies to this purchase requisition.
2	`RequiredDate`	`DateTime?`	Nullable	Records the required date for this purchase requisition.
3	`RequisitionStatus`	`int`	Required	Tracks the requisition status of this purchase requisition.

Dates and timing

2 fields

#	Field	EF type	Storage	Business purpose
1	`ApprovedDate`	`DateTime?`	Nullable	Records the approved date for this purchase requisition.
2	`RequisitionDate`	`DateTime`	Required	Records the requisition date for this purchase requisition.

Amounts and measurements

1 fields

#	Field	EF type	Storage	Business purpose
1	`TotalEstimatedCost`	`decimal`	Required	Stores the total estimated cost used by this purchase requisition.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`ReasonForRequisition`	`string`	Nullable	Records reason for requisition for this purchase requisition.

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

2 fields

#	Field	EF type	Storage	Business purpose
1	`ApprovedBy`	`string`	Nullable	Records approved by for this purchase requisition.
2	`Priority`	`int`	Required	Records priority for this purchase requisition.