Coflyr · Backend model field catalog

MaterialPartRequest

public.MaterialPartRequests.

28 mapped fields7 field groupsGenerated 2026-10-08

Model class: coflyr.features.materialmanagement.partrequests.models.MaterialPartRequest
Source: Features/MaterialManagement/PartRequests/Models/MaterialPartRequest.cs
Table: public.MaterialPartRequests
Review: Under development · marked 2026-10-08 · Material fulfillment links the planned WorkStepMaterialDemand by ID. Planned quantity/part/reference baseline cannot be rewritten through fulfillment CRUD. Migration is deferred.

Every mapped scalar field appears once. Types and nullability come from current backend EF metadata; migration is deferred. 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

Backend updated · DB pending. Common maintenance reporting and adoption status.

Identity and naming

4 fields

#	Field	Model / EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`EventNumber`	`string`	Nullable	Records event number for this material part request.
3	`EventPerformanceNumber`	`string`	Nullable	Records event performance number for this material part request.
4	`PartRequestNumber`	`string`	Required	Records part request number for this material part request.

Relationships and references

8 fields

#	Field	Model / EF type	Storage	Business purpose
1	`ComponentMaintenancePartitionId`	`Guid?`	Nullable	Selects the related component maintenance partition record.
2	`ComponentMaintenanceWorkScopeId`	`Guid?`	Nullable	Selects the related component maintenance work scope record.
3	`ExternalServiceDefinitionId`	`Guid?`	Nullable	Selects the related external service definition record.
4	`IpcReference`	`string`	Nullable	Records ipc reference for this material part request.
5	`PartId`	`Guid`	Required	Selects the related part record.
6	`WorkStepId`	`Guid?`	Nullable	Selects the related work step record.
7	`WorkStepMaterialDemandId`	`Guid?`	Nullable	Original planned spare/consumable demand stored as a child in Maintenance.WorkStep. This row manages fulfillment.
8	`WorkorderId`	`Guid?`	Nullable	Selects the related workorder record.

Status and controls

5 fields

#	Field	Model / EF type	Storage	Business purpose
1	`ExternallyProvisioned`	`bool`	Required	Indicates whether externally provisioned applies to this material part request.
2	`IsTool`	`bool`	Required	Indicates whether tool applies to this material part request.
3	`PartRequestStatus`	`MaterialPartRequestStatus { Open, Allocated, Ordered, Serviced, Closed, Cancelled }` EF: MaterialPartRequestStatus	Required	Tracks the part request status of this material part request.
4	`PreStepCloseStatus`	`MaterialPartRequestStatus? { Open, Allocated, Ordered, Serviced, Closed, Cancelled }` EF: MaterialPartRequestStatus?	Nullable	Tracks the pre step close status of this material part request.
5	`RequiredProbabilityPercent`	`decimal`	Required	Stores the required probability percent used by this material part request.

Amounts and measurements

2 fields

#	Field	Model / EF type	Storage	Business purpose
1	`PriceBookCode`	`string`	Nullable	Records price book code for this material part request.
2	`Quantity`	`decimal`	Required	Stores the quantity used by this material part request.

Descriptions and details

2 fields

#	Field	Model / EF type	Storage	Business purpose
1	`EventDescription`	`string`	Nullable	Records event description for this material part request.
2	`RequestRemarks`	`string`	Nullable	Records request remarks for this material part request.

Audit and revision

2 fields

#	Field	Model / 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

5 fields

#	Field	Model / EF type	Storage	Business purpose
1	`AdditionalInfo`	`string`	Nullable	Records additional info for this material part request.
2	`AircraftLocationCode`	`string`	Nullable	Records aircraft location code for this material part request.
3	`ClosedAt`	`DateTime?`	Nullable	Records the closed at for this material part request.
4	`CreatedAt`	`DateTime`	Required	Records the created at for this material part request.
5	`EventTypeCode`	`string`	Nullable	Records event type code for this material part request.