Coflyr · Backend model field catalog

ComponentPlanningRecord

public.ComponentPlanningRecords.

61 mapped fields8 field groupsGenerated 2026-10-06

Model class: coflyr.features.components.shopmaintenance.models.ComponentPlanningRecord
Source: Features/Components/ShopMaintenance/Models/ComponentPlanningRecord.cs
Table: public.ComponentPlanningRecords
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

7 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`EventNumber`	`string`	Required	Records event number for this component planning record.
3	`OrderNumber`	`string`	Nullable	Records order number for this component planning record.
4	`RemovalWorkorderNumber`	`string`	Nullable	Records removal workorder number for this component planning record.
5	`SerialNumber`	`string`	Nullable	Records serial number for this component planning record.
6	`UnknownPartNumber`	`string`	Nullable	Records unknown part number for this component planning record.
7	`WorkorderNumber`	`string`	Nullable	Records workorder number for this component planning record.

Relationships and references

6 fields

#	Field	EF type	Storage	Business purpose
1	`AtaId`	`Guid?`	Nullable	Selects the related ata record.
2	`ComponentWorkpackageId`	`Guid?`	Nullable	Selects the related component workpackage record.
3	`MainShopFacilityId`	`Guid`	Required	Selects the related main shop facility record.
4	`OwnerPartnerId`	`Guid?`	Nullable	Selects the related owner partner record.
5	`PartId`	`Guid?`	Nullable	Selects the related part record.
6	`PlanningReference`	`string`	Required	Records planning reference for this component planning record.

Status and controls

13 fields

#	Field	EF type	Storage	Business purpose
1	`CalculationStatus`	`int`	Required	Tracks the calculation status of this component planning record.
2	`HasInternalCapability`	`bool`	Required	Indicates whether internal capability applies to this component planning record.
3	`HasValidWarranty`	`bool`	Required	Indicates whether valid warranty applies to this component planning record.
4	`IncludeUnlimitedEvents`	`bool`	Required	Indicates whether include unlimited events applies to this component planning record.
5	`IsAssigned`	`bool`	Required	Indicates whether assigned applies to this component planning record.
6	`IsClosedLoop`	`bool`	Required	Indicates whether closed loop applies to this component planning record.
7	`IsInstalled`	`bool`	Required	Indicates whether installed applies to this component planning record.
8	`IsKnownComponent`	`bool`	Required	Indicates whether known component applies to this component planning record.
9	`IsMandatory`	`bool`	Required	Indicates whether mandatory applies to this component planning record.
10	`IsScheduled`	`bool`	Required	Indicates whether scheduled applies to this component planning record.
11	`IsTool`	`bool`	Required	Indicates whether tool applies to this component planning record.
12	`IsTurnaround`	`bool`	Required	Indicates whether turnaround applies to this component planning record.
13	`OrderRequiredConditionCode`	`string`	Nullable	Records order required condition code for this component planning record.

Dates and timing

8 fields

#	Field	EF type	Storage	Business purpose
1	`DueAt`	`decimal?`	Nullable	Records the due at for this component planning record.
2	`ExpectedDate`	`DateTime?`	Nullable	Records the expected date for this component planning record.
3	`ExpectedTime`	`TimeSpan?`	Nullable	Records the expected time for this component planning record.
4	`FifoDate`	`DateTime?`	Nullable	Records the fifo date for this component planning record.
5	`OrderTargetDate`	`DateTime?`	Nullable	Records the order target date for this component planning record.
6	`PlannedDate`	`DateTime?`	Nullable	Records the planned date for this component planning record.
7	`PlannedTime`	`TimeSpan?`	Nullable	Records the planned time for this component planning record.
8	`TargetStartDate`	`DateTime?`	Nullable	Records the target start date for this component planning record.

Amounts and measurements

5 fields

#	Field	EF type	Storage	Business purpose
1	`EstimatedManHours`	`decimal`	Required	Records estimated man hours for this component planning record.
2	`Quantity`	`decimal`	Required	Stores the quantity used by this component planning record.
3	`StockQuantity`	`decimal`	Required	Stores the stock quantity used by this component planning record.
4	`TurnaroundHours`	`decimal?`	Nullable	Records turnaround hours for this component planning record.
5	`YieldPercentage`	`decimal?`	Nullable	Records yield percentage for this component planning record.

Descriptions and details

3 fields

#	Field	EF type	Storage	Business purpose
1	`EventDescription`	`string`	Required	Records event description for this component planning record.
2	`PlanningRemarks`	`string`	Nullable	Records planning remarks for this component planning record.
3	`RemovalReason`	`string`	Nullable	Records removal reason for this component planning record.

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

17 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftRegistration`	`string`	Nullable	Records aircraft registration for this component planning record.
2	`ComponentConditionCode`	`string`	Nullable	Records component condition code for this component planning record.
3	`CounterDimension`	`string`	Nullable	Records counter dimension for this component planning record.
4	`CurrentComponentLocation`	`string`	Nullable	Records current component location for this component planning record.
5	`Interval`	`decimal?`	Nullable	Records interval for this component planning record.
6	`LastCalculatedAt`	`DateTime?`	Nullable	Records the last calculated at for this component planning record.
7	`Limitation`	`string`	Nullable	Records limitation for this component planning record.
8	`MaterialClassCode`	`string`	Nullable	Records material class code for this component planning record.
9	`Origin`	`string`	Required	Records origin for this component planning record.
10	`PlannedStationCode`	`string`	Nullable	Records planned station code for this component planning record.
11	`PriorityCode`	`string`	Nullable	Records priority code for this component planning record.
12	`QualificationCodes`	`string`	Nullable	Records qualification codes for this component planning record.
13	`RequirementType`	`string`	Nullable	Records requirement type for this component planning record.
14	`ShowUntil`	`DateTime?`	Nullable	Records show until for this component planning record.
15	`SpecialCodes`	`string`	Nullable	Records special codes for this component planning record.
16	`ToGo`	`decimal?`	Nullable	Records to go for this component planning record.
17	`WorkpackageResponsible`	`string`	Nullable	Records workpackage responsible for this component planning record.