Coflyr · Backend model field catalog
RotableMaster
Parts.RotableMasters.
102 mapped fields8 field groupsGenerated 2026-10-06
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.
Identity and naming
18 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | BatchNumber | string | Nullable | Records batch number for this rotable master. |
| 3 | CertificateNumber | string | Nullable | Records certificate number for this rotable master. |
| 4 | InstallationEventNumber | string | Nullable | Records installation event number for this rotable master. |
| 5 | LabelNo | string | Nullable | Records label no for this rotable master. |
| 6 | LotNumber | string | Nullable | Records lot number for this rotable master. |
| 7 | OrderNumber | string | Nullable | Records order number for this rotable master. |
| 8 | OriginPartNumber | string | Nullable | Records origin part number for this rotable master. |
| 9 | OriginSerialNumber | string | Nullable | Records origin serial number for this rotable master. |
| 10 | PlateNumber | string | Nullable | Records plate number for this rotable master. |
| 11 | PoolReferenceNumber | string | Nullable | Records pool reference number for this rotable master. |
| 12 | ProjectNumber | string | Nullable | Records project number for this rotable master. |
| 13 | ReleaseNumber | string | Nullable | Records release number for this rotable master. |
| 14 | RemovalEventNumber | string | Nullable | Records removal event number for this rotable master. |
| 15 | SerialNumber | string | Required | Records serial number for this rotable master. |
| 16 | ShipmentNumber | string | Nullable | Records shipment number for this rotable master. |
| 17 | WorkOrderNumber | string | Nullable | Records work order number for this rotable master. |
| 18 | WorkPackageNumber | string | Nullable | Records work package number for this rotable master. |
Relationships and references
15 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CertificateIssuerBusinessPartnerId | Guid? | Nullable | Selects the related certificate issuer business partner record. |
| 2 | ConfigurationId | Guid? | Nullable | Selects the related configuration record. |
| 3 | ConfigurationMasterId | Guid? | Nullable | Selects the related configuration master record. |
| 4 | CounterReferenceDate | DateTime? | Nullable | Records the counter reference date for this rotable master. |
| 5 | InventoryMeasureUnitId | Guid? | Nullable | Selects the related inventory measure unit record. |
| 6 | LocationReferenceId | Guid? | Nullable | Selects the related location reference record. |
| 7 | OwnerBusinessPartnerId | Guid? | Nullable | Selects the related owner business partner record. |
| 8 | ParentRotableMasterId | Guid? | Nullable | Selects the related parent rotable master record. |
| 9 | PartId | Guid | Required | Selects the related part record. |
| 10 | PoolProviderBusinessPartnerId | Guid? | Nullable | Selects the related pool provider business partner record. |
| 11 | ReferenceTreeType | string | Nullable | Records reference tree type for this rotable master. |
| 12 | RepairStatusId | Guid? | Nullable | Selects the related repair status record. |
| 13 | RotableConditionId | Guid? | Nullable | Selects the related rotable condition record. |
| 14 | StationLocationId | Guid? | Nullable | Selects the related station location record. |
| 15 | StoreLocationId | Guid? | Nullable | Selects the related store location record. |
Status and controls
9 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ComponentStatus | int? | Nullable | Tracks the component status of this rotable master. |
| 2 | InspectionStatus | string | Nullable | Tracks the inspection status of this rotable master. |
| 3 | IsCombinationRotable | bool | Required | Indicates whether combination rotable applies to this rotable master. |
| 4 | IsExternalRotable | bool | Required | Indicates whether external rotable applies to this rotable master. |
| 5 | IsFinancialQuantity | bool | Required | Indicates whether financial quantity applies to this rotable master. |
| 6 | IsInStock | bool | Required | Indicates whether in stock applies to this rotable master. |
| 7 | IsInspected | bool | Required | Indicates whether inspected applies to this rotable master. |
| 8 | IsManaged | bool | Required | Indicates whether managed applies to this rotable master. |
| 9 | IsPoolRotable | bool | Required | Indicates whether pool rotable applies to this rotable master. |
Dates and timing
12 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CertificateExpiryDate | DateTime? | Nullable | Records the certificate expiry date for this rotable master. |
| 2 | CertificateIssueDate | DateTime? | Nullable | Records the certificate issue date for this rotable master. |
| 3 | DeliveryDate | DateTime? | Nullable | Records the delivery date for this rotable master. |
| 4 | InstDate | DateTime? | Nullable | Records the inst date for this rotable master. |
| 5 | LastInspectionDate | DateTime? | Nullable | Records the last inspection date for this rotable master. |
| 6 | LastRepairDate | DateTime? | Nullable | Records the last repair date for this rotable master. |
| 7 | LastShopVisitDate | DateTime? | Nullable | Records the last shop visit date for this rotable master. |
| 8 | ManufactureDate | DateTime | Required | Records the manufacture date for this rotable master. |
| 9 | OnWingDate | DateTime? | Nullable | Records the on wing date for this rotable master. |
| 10 | ShelfExpiryDate | DateTime? | Nullable | Records the shelf expiry date for this rotable master. |
| 11 | StockInDate | DateTime? | Nullable | Records the stock in date for this rotable master. |
| 12 | StockOutDate | DateTime? | Nullable | Records the stock out date for this rotable master. |
Amounts and measurements
6 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | FinancialQuantity | decimal? | Nullable | Stores the financial quantity used by this rotable master. |
| 2 | OriginFinancialQuantity | decimal? | Nullable | Stores the origin financial quantity used by this rotable master. |
| 3 | QuantityOnHand | decimal? | Nullable | Records quantity on hand for this rotable master. |
| 4 | QuantityReserved | decimal? | Nullable | Records quantity reserved for this rotable master. |
| 5 | TotalAircraftCycles | long? | Nullable | Records total aircraft cycles for this rotable master. |
| 6 | TotalAircraftHours | decimal? | Nullable | Records total aircraft hours for this rotable master. |
Descriptions and details
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | FunctionalPositionDescription | string | Nullable | Records functional position description for this rotable master. |
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
39 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AircraftPosition | string | Nullable | Records aircraft position for this rotable master. |
| 2 | AircraftPositionConfig | string | Nullable | Records aircraft position config for this rotable master. |
| 3 | AircraftRegistration | string | Nullable | Records aircraft registration for this rotable master. |
| 4 | AssemblyPosition | string | Nullable | Records assembly position for this rotable master. |
| 5 | AssignedConfig | string | Nullable | Records assigned config for this rotable master. |
| 6 | CertificateType | int? | Nullable | Records certificate type for this rotable master. |
| 7 | CombinationRotableCode | string | Nullable | Records combination rotable code for this rotable master. |
| 8 | ContractRef | string | Nullable | Records contract ref for this rotable master. |
| 9 | Csn | float | Required | Records csn for this rotable master. |
| 10 | Cso | float? | Nullable | Records cso for this rotable master. |
| 11 | DeliveredWithAircraft | string | Nullable | Records delivered with aircraft for this rotable master. |
| 12 | FinancialCase | string | Nullable | Records financial case for this rotable master. |
| 13 | FinancialEntity | string | Nullable | Records financial entity for this rotable master. |
| 14 | HigherRotableConfig | string | Nullable | Records higher rotable config for this rotable master. |
| 15 | InternalShopCode | string | Nullable | Records internal shop code for this rotable master. |
| 16 | InventoryType | int | Required | Records inventory type for this rotable master. |
| 17 | OriginEntity | string | Nullable | Records origin entity for this rotable master. |
| 18 | OriginFinancialCase | string | Nullable | Records origin financial case for this rotable master. |
| 19 | OriginOwner | string | Nullable | Records origin owner for this rotable master. |
| 20 | Owner | string | Nullable | Records owner for this rotable master. |
| 21 | PMARepaired | string | Nullable | Records pma repaired for this rotable master. |
| 22 | PoolProvider | string | Nullable | Records pool provider for this rotable master. |
| 23 | Psn | string | Nullable | Records psn for this rotable master. |
| 24 | Remark | string | Nullable | Records remark for this rotable master. |
| 25 | ReorderLevel | decimal? | Nullable | Records reorder level for this rotable master. |
| 26 | RotableType | int? | Nullable | Records rotable type for this rotable master. |
| 27 | SafetyStock | decimal? | Nullable | Records safety stock for this rotable master. |
| 28 | SerialRangeFrom | string | Nullable | Records serial range from for this rotable master. |
| 29 | SerialRangePrefix | string | Nullable | Records serial range prefix for this rotable master. |
| 30 | SerialRangeTo | string | Nullable | Records serial range to for this rotable master. |
| 31 | ShopVisitCount | int? | Nullable | Records shop visit count for this rotable master. |
| 32 | Station | string | Nullable | Records station for this rotable master. |
| 33 | Store | string | Nullable | Records store for this rotable master. |
| 34 | ThirdPartyShop | string | Nullable | Records third party shop for this rotable master. |
| 35 | TrackingMode | int | Required | Records tracking mode for this rotable master. |
| 36 | TransferredViaTransaction | string | Nullable | Records transferred via transaction for this rotable master. |
| 37 | Tsn | TimeSpan | Required | Records tsn for this rotable master. |
| 38 | Tso | TimeSpan? | Nullable | Records tso for this rotable master. |
| 39 | UniqueRotableCode | string | Nullable | Records unique rotable code for this rotable master. |