Coflyr · AMOS workpackage model

Workpackage field map

Latest field decision: AircraftPosition is replaced by nullable UUID lookups ConfigurationMasterId and ConfigurationId. The selected functional position must belong to the selected master. These are HTML proposals; backend/database adoption is pending. Current WorkorderMaster review.

A workpackage plans and groups maintenance. Aircraft and component packages share a header; workorders and work steps carry individual jobs and execution details.

74 package-facing fields and link attributes108 other stored fields for review38 removed or replaced fields180 current workpackage columnsGenerated 2026-10-05

How to use this page

The main sections follow the AMOS aircraft and component Workpackage guides.
Other stored fields are listed in a collapsed section at the end so the complete table remains auditable.
Component authority selections also use the linked Maintenance.WorkpackageAuthorities table.
Required and nullable labels describe database storage, not every AMOS workflow rule.
Review decision: every package-facing field without a separate change comment is marked Keep. The “Other stored fields for review” section remains Review.
Review decision: omit the duplicate free-text Responsible field from the package header and keep ResponsibleStaffId as the Human Resources lookup. The text column has been removed from the local development database.
Review decision: replace the package AccessGroup text field with a nullable DepartmentId Human Resources lookup. This is implemented in the model and local development database.
Review decision: replace the five aircraft header fields with AirframeRotableId; resolve aircraft details through the linked records. Implemented in the model and local development database.
Review decision: omit the duplicate AircraftOperator text field and use OperatorBusinessPartnerId for the selected operator. Implemented in the model and local development database.
Review decision: omit MaintenanceProgramRevisionNumber and MaintenanceProgramRevisionDate from the package header; retain MaintenanceProgramId as the program link. Implemented in the model and local development database.
Review decision: omit the inbound and outbound gate text fields from the package header. Implemented in the model and local development database.
Review decision: omit DockOfficeReference and DropOffLocationId from the package header. Implemented in the model and local development database.
Review decision: replace the package FinancialProjectId lookup with optional FinancialProjectReference text. Implemented in the model and local development database.
Review decision: omit CommercialQuotationId from the package header and retain CommercialQuotationReference. Implemented in the model and local development database.
Review decision: replace MainShopFacilityId and CurrentShopFacilityId with FacilityType, FacilityId, and FacilityReference. Replace StationCode with StationReference and reuse the existing StationId lookup. Implemented in the model and local development database.
Review decision: omit WorkpackageConfigurationCode from the package header; the separate ConfigurationMasterId lookup remains listed under other stored fields. Implemented in the model and local development database.
Review decision: replace ComponentOwnerPartnerId and CustomerPartnerId with repeatable workpackage partner links containing BusinessPartnerType and BusinessPartnerId. Implemented in the model and local development database.

AMOS workpackage · 1

Package identity and control

16 fields

The header that identifies and controls a package of planned maintenance.

#	Field	Model type	Business purpose	Status
1	`Id`	Guid Required	Stable identifier for this record.	Inherit
2	`WorkpackageNumber`	string? Nullable	Coflyr business number for the workpackage.	Keep
3	`CustomerWorkpackageNumber`	string? Nullable	Customer supplied workpackage number.	Keep
4	`ExternalWorkpackageNumber`	string? Nullable	Number assigned to the package by an external party; classified by ExternalWorkpackageNumberType.	Keep
5	`ExternalWorkpackageNumberType`	ExternalWorkpackageNumberType? Nullable	Identifies who supplied the external workpackage number.	Keep
6	`WorkpackageDescription`	string? Nullable	Stores the workpackage description for this header.	Keep
7	`WorkpackageTitle`	string? Nullable	Stores the workpackage title for this header.	Keep
8	`WorkpackageType`	enum WorkpackageCategory Required · Maintenance \| Repair	HTML recommendation: use a required enum with `Maintenance` for an aircraft maintenance package and `Repair` for a component shop repair package. For example, a scheduled aircraft check is Maintenance; a damaged actuator sent through the component repair workflow is Repair. AMOS documents work packages for maintenance events and a distinct component repair/shop workflow; these two enum labels are the proposed Coflyr mapping, not a published AMOS code list. AMOS Planning · AMOS Component Maintenance.	Keep enum
9	`WorkorderAssetType`	WorkpackageAssetType Required	Selects Aircraft or Component maintenance context.	Keep
10	`WorkpackageStatus`	ComponentWorkpackageStatus Required	Tracks the component workpackage production and release lifecycle.	Keep
11	`Classification` Keep	string? Nullable	Optional local label for grouping and finding workpackages within a category, such as Line maintenance or Base maintenance under `WorkpackageType = Maintenance`. Example: a planner labels an overnight line check “Line maintenance” so it can be distinguished from a hangar visit. This is a proposed business use: Coflyr currently stores the text but does not use it for validation, routing, or release. AMOS describes different maintenance events and line/base production workflows, but its public documentation does not define values for this Coflyr field. AMOS Planning · AMOS Production.	Keep
12	`PriorityCode`	ComponentWorkpackagePriority? Nullable	Selected component workpackage priority: Very Urgent, Urgent, Normal, Not Urgent, or Nice to Have.	Keep
13	`ResponsibleStaffId` Keep · HR lookup	Guid? Nullable	Use this existing foreign key to select the responsible `StaffMember` in Human Resources; show the staff member’s current name through the relationship.	Keep
14	`Restricted`	bool Required	Stores the restricted for this header.	Keep
15	`DepartmentId` Replace AccessGroup · HR lookup	Guid? Nullable · implemented	Select the responsible department from the existing Human Resources `Department` records. Example: choose “Line Maintenance” from the department directory instead of entering an access-group label. This is a proposed replacement for the package’s free-text `AccessGroup`; `DepartmentId` is not yet present on the Workpackage model.	Replace
16	`AutoGenerated`	bool Required	Records whether the header was generated by a system workflow.	Keep

AMOS workpackage · 2

Aircraft and maintenance program

6 fields

Aircraft selection, program revision, and the planning context described on the AMOS Workpackage Main tab.

#	Field	Model type	Business purpose	Status
1	`UnknownAircraft`	bool Required	Explicitly marks an aircraft workpackage whose registration is not yet known.	Keep
2	`AirframeRotableId` Replace five aircraft fields	Guid? Nullable · implemented	Select the aircraft airframe from `RotableMaster`. Obtain registration, type, subtype, and model through the associated aircraft record instead of storing five values on the workpackage. Leave this lookup empty when `UnknownAircraft` is true. This field is implemented on WorkpackageMaster.	Replace
3	`OperatorBusinessPartnerId`	Guid? Nullable	Selects the aircraft operator business partner.	Keep
4	`StationId`	Guid? Nullable	Selects the station from the station lookup.	Keep
5	`MaintenanceProgramId`	Guid? Nullable	Links to the maintenance program used for this package.	Keep
6	`WorkLevel`	string? Nullable	Stores the work level for this header.	Keep

AMOS workpackage · 3

Planning, flights, and facilities

16 fields

Dates, station logistics, flights, reservations, and commercial planning for the package.

#	Field	Model type	Business purpose	Status
1	`PlannedStartDate`	DateTime? Nullable	Records the planned start date.	Keep
2	`WorkpackagePlannedEndDate`	DateTime? Nullable	Planned date and time for completing the workorder.	Keep
3	`TargetStartDate`	DateTime? Nullable	Target start supplied by component repair planning.	Keep
4	`TargetEndDate`	DateTime? Nullable	Target end supplied by component repair planning.	Keep
5	`EstimatedStartDate`	DateTime? Nullable	Estimated workpackage start date and time.	Keep
6	`EstimatedEndDate`	DateTime? Nullable	Estimated workpackage end date and time.	Keep
7	`EstimatedGroundTimeHours`	decimal? Nullable	Stores the estimated ground time hours for this header.	Keep
8	`InboundFlightNumber`	string? Nullable	Inbound flight associated with the aircraft workpackage.	Keep
9	`OutboundFlightNumber`	string? Nullable	Outbound flight associated with the aircraft workpackage.	Keep
10	`ReservedFacilityId`	Guid? Nullable	Selects a facility reserved for the package.	Keep
11	`Department`	string? Nullable	Stores the department for this header.	Keep
12	`MaintenanceProviderBusinessPartnerId`	Guid? Nullable	Selects the maintenance provider or repair station business partner.	Keep
13	`MaintenanceProvider`	string? Nullable	Stores the maintenance provider for this header.	Keep
14	`FinancialProjectReference` Replace FinancialProjectId	string? Nullable · implemented	Optional reference supplied by Finance or the customer for cost tracking. Example: a hangar package records finance reference “FY26-HGR-042” without selecting a FinancialProject record. This replaces the package lookup `FinancialProjectId` in the header; `ProjectNo` remains a separate project reference.	Replace
15	`ProjectNo`	string? Nullable	Stores the project no for this header.	Keep
16	`CommercialQuotationReference`	string? Nullable	Quotation reference captured as text while quotation integration is under development.	Keep

AMOS workpackage · 4

Component and shop workpackage

29 fields

Main component, condition, shop, authority, return routing, and repair planning from AMOS Component Workpackage.

#	Field	Model type	Business purpose	Status
1	`PartId`	Guid? Nullable	Selects the part record.	Keep
2	`UnknownPartNumber`	string? Nullable	Stores the unknown part number for this header.	Keep
3	`RotableId`	Guid? Nullable	Selects the rotable record.	Keep
4	`IsRotable`	bool Required	Indicates that the component is a rotable item.	Keep
5	`Quantity`	decimal Required	Quantity of parts or units covered by the record.	Keep
6	`SerialOrBatchNumber`	string Required	Stores the serial or batch number for this header.	Keep
7	`SerialNumberUnknown`	bool Required	Indicates that the component serial or batch number is unknown.	Keep
8	`RequiredConditionId`	Guid? Nullable	Selects the required component condition from the condition catalog.	Keep
9	`FacilityType` Proposed	FacilityType? Nullable	Classifies the selected facility, such as a hangar or workshop, using the existing facility type enum.	Add
10	`FacilityId` Proposed · internal lookup	Guid? Nullable	Selects an internal facility from the facility directory. This replaces the separate main-shop and current-shop facility IDs on the package header.	Add
11	`FacilityReference` Proposed	string? Nullable	Records an external facility reference when the selected facility is not in the internal directory.	Add
12	`StationReference` Replace StationCode	string? Nullable	Human-readable station reference, paired with the existing `StationId` lookup listed under aircraft and maintenance program.	Replace
13	`BusinessPartnerType` Partner link role	BusinessPartnerType Required · linked record	Role of each partner linked to the workpackage, using the existing business partner type values such as `Owner` and `Customer`. Store one link per partner role; do not put one pair of scalar fields on the package header.	Replace
14	`BusinessPartnerId` Partner link lookup	Guid Required · linked record	Selects the `BusinessPartner` for that role. Example: one link identifies the component owner and another identifies the customer. The pair can repeat when more partners participate.	Replace
15	`RegulatoryAuthorityBusinessPartnerId`	Guid? Nullable	Business Partner record selected as the regulatory authority.	Keep
16	`ReturnType`	ComponentReturnType Required	Component return workflow: Open Loop, Closed Loop, or Turnaround.	Keep
17	`RoutingStatus`	ComponentRoutingStatus Required	Current movement state as the component travels between shops.	Keep
18	`WorkScope`	ShopWorkScope Required	Stores the work scope for this header.	Keep
19	`ShopArrivalDate`	DateTime? Nullable	Records the shop arrival date.	Keep
20	`PlannedTurnaroundHours`	decimal? Nullable	Stores the planned turnaround hours for this header.	Keep
21	`ActualTurnaroundHours`	decimal? Nullable	Stores the actual turnaround hours for this header.	Keep
22	`ShopStatus`	ShopWorkOrderStatus Required	Tracks the shop status.	Keep
23	`ComponentProductionGroupName`	string? Nullable	Descriptive production group name for the component package.	Keep
24	`FailureConfirmed`	bool Required	Records whether the reported component failure was confirmed.	Keep
25	`FailureDescription`	string? Nullable	Stores the failure description for this header.	Keep
26	`FailureConfirmedAt`	DateTime? Nullable	Records the failure confirmed at.	Keep
27	`FailureConfirmedByStaffId`	Guid? Nullable	Staff member who confirmed the reported failure.	Keep
28	`ShopcardCollectionNeeded`	bool Required	Indicates that shopcards must be collected before package completion.	Keep
29	`ShopcardCollectionComplete`	bool Required	Indicates that required shopcards have been collected.	Keep

AMOS workpackage · 5

Production, paperwork, and release

7 fields

Package handover and delivery indicators; related work steps, events, and authorities live in linked tables.

#	Field	Model type	Business purpose	Status
1	`HandedOverToProduction`	bool Required	Records whether handed over to production applies.	Keep
2	`ReleasedToService`	bool Required	Records whether released to service applies.	Keep
3	`PaperworkStatus` Merge three fields	enum PaperworkStatus Required · implemented	One package-level state for paperwork delivery: `NotTracked`, `Pending`, or `Received`. Example: a package awaiting signed paperwork is Pending and becomes Received when paperwork arrives. The separate receipt date is not retained on the header; record a receipt event separately if its timestamp is needed.	Replace
4	`ActualStartDate`	DateTime? Nullable	Records the actual start date.	Keep
5	`ActualEndDate`	DateTime? Nullable	Records the actual end date.	Keep
6	`ActualCompletionDate`	DateTime? Nullable	Records the actual completion date.	Keep
7	`DeliveryDate`	DateTime? Nullable	Records the delivery date.	Keep

Confirmed review decisions

Removed and replaced fields

38 fields

These fields were removed or replaced in the workpackage model and local development database. The database migration refuses to drop legacy columns from a populated workpackage table until its data is mapped.

Current field	Status	Replacement or retained source
`Responsible`	Replace	ResponsibleStaffId
`AccessGroup`	Replace	DepartmentId
`AircraftTailId`	Replace	AirframeRotableId
`AircraftRegistration`	Replace	AirframeRotableId
`AircraftType`	Replace	AirframeRotableId
`AircraftSubtype`	Replace	AirframeRotableId
`AircraftModel`	Replace	AirframeRotableId
`AircraftOperator`	Replace	OperatorBusinessPartnerId
`MaintenanceProgramRevisionNumber`	Remove	—
`MaintenanceProgramRevisionDate`	Remove	—
`InboundGate`	Remove	—
`OutboundGate`	Remove	—
`DockOfficeReference`	Remove	—
`DropOffLocationId`	Remove	—
`FinancialProjectId`	Replace	FinancialProjectReference
`CommercialQuotationId`	Replace	CommercialQuotationReference
`ComponentOwnerPartnerId`	Replace	BusinessPartnerType = Owner + BusinessPartnerId link
`CustomerPartnerId`	Replace	BusinessPartnerType = Customer + BusinessPartnerId link
`Facility`	Replace	FacilityType / FacilityId / FacilityReference
`MainShopFacilityId`	Replace	FacilityType / FacilityId / FacilityReference
`CurrentShopFacilityId`	Replace	FacilityType / FacilityId / FacilityReference
`StationCode`	Replace	StationReference + existing StationId
`WorkpackageConfigurationCode`	Remove	Existing ConfigurationMasterId remains
`WorkTemplateId`	Remove	No header replacement specified
`IsSequenced`	Remove	No replacement specified
`PaperworkTracked`	Replace	PaperworkStatus
`PaperworkPending`	Replace	PaperworkStatus
`PaperworkReceivedDate`	Replace	PaperworkStatus
`TaskRemarks`	Remove	—
`TechAssistanceRequested`	Remove	—
`TemporaryCorrosionLevel`	Remove	—
`TreePosition`	Remove	—
`UpdateId`	Remove	Inherited audit property; no workpackage column
`VendorRepairOrderId`	Remove	—
`WorkPerformedAtIssue`	Remove	—
`WorkorderDescription`	Remove	—
`WorkorderSequence`	Remove	—
`WorkorderStatus`	Remove	—

Other stored fields for review

These columns remain in Maintenance.WorkpackageMaster. Several originated in the older Workorder-shaped header; this inventory does not imply that each belongs on an AMOS Workpackage. Review service use and migration impact before removing any of them.

#	Field	Model type	Business purpose	Status
1	`ActManHours`	float? Nullable	Stores the act man hours for this header.	Review
2	`AdministrativeCloseDate`	DateTime? Nullable	Records the administrative close date.	Review
3	`ConfigurationId`	Guid? Nullable · UUID lookup	Selects a Configuration functional position within ConfigurationMasterId; replaces free-text AircraftPosition. HTML proposal, backend/database adoption pending.	Replacement agreed · implementation pending
4	`ApprovalNo`	string? Nullable	Stores the approval no for this header.	Review
5	`ApprovalRequestedBy`	string? Nullable	Stores the approval requested by for this header.	Review
6	`ApprovalRequestedDate`	DateTime? Nullable	Records the approval requested date.	Review
7	`WorkpackageApprovalStatus`	string? Nullable	Tracks the approval status.	Review
8	`ArrivalAirport`	string? Nullable	Stores the arrival airport for this header.	Review
9	`AssignedTechnicianStaffId`	Guid? Nullable	Selects the assigned technician staff record.	Review
10	`AtaChapterStd`	string? Nullable	Stores the ata chapter std for this header.	Review
11	`AtaId`	Guid? Nullable	Selects the ata record.	Review
12	`ClosingDate`	DateTime? Nullable	Records the closing date.	Review
13	`ClosingStation`	string? Nullable	Stores the closing station for this header.	Review
14	`ClosingTAC`	float? Nullable	Stores the closing tac for this header.	Review
15	`ClosingTAH`	TimeSpan? Nullable	Stores the closing tah for this header.	Review
16	`ComponentPartNumber`	string? Nullable	Stores the component part number for this header.	Review
17	`ComponentSerialNumber`	string? Nullable	Stores the component serial number for this header.	Review
18	`ConfigurationMasterId`	Guid? Nullable	Selects the configuration master record.	Review
19	`CorrosionLevel`	int? Nullable	Stores the corrosion level for this header.	Review
20	`CriticalEventId`	Guid? Nullable	Associated critical maintenance event.	Review
21	`CrsApprovalNumber`	string? Nullable	Stores the crs approval number for this header.	Review
22	`CrsName`	string? Nullable	Stores the crs name for this header.	Review
23	`CrsNumber`	string? Nullable	Stores the crs number for this header.	Review
24	`CrsReleaseDate`	DateTime? Nullable	Records the crs release date.	Review
25	`CrsSignature`	string? Nullable	Stores the crs signature for this header.	Review
26	`DefectClassification`	string? Nullable	Stores the defect classification for this header.	Review
27	`DepartureAirport`	string? Nullable	Stores the departure airport for this header.	Review
28	`DueDate`	DateTime Required	Records the due date.	Review
29	`DueTAC`	float? Nullable	Stores the due tac for this header.	Review
30	`DueTAH`	TimeSpan? Nullable	Stores the due tah for this header.	Review
31	`ElbReference`	string? Nullable	Electronic logbook or tech-log reference required for Electronic Logbook issue and associated with the TL link.	Review
32	`EstManHours`	float? Nullable	Stores the est man hours for this header.	Review
33	`ExternalWorkorderNo`	string? Nullable	Number assigned by an external workorder owner; classified by ExternalWorkorderNoType.	Review
34	`ExternalWorkorderNoType`	ExternalWorkorderNumberType? Nullable	Identifies who supplied the external workorder number.	Review
35	`FeedbackRequest`	bool Required	Records whether feedback request applies.	Review
36	`FlightArrivalDate`	DateTime? Nullable	Records the flight arrival date.	Review
37	`FlightDateTime`	DateTime? Nullable	Records the flight date time.	Review
38	`FlightLogId`	Guid? Nullable	Selected flight log for the workorder flight context.	Review
39	`FlightNumber`	string? Nullable	Stores the flight number for this header.	Review
40	`HasOperationalConsequence`	bool Required	Records whether operational consequence applies.	Review
41	`HeaderAreaCode`	string? Nullable	Stores the header area code for this header.	Review
42	`HeaderPanelCode`	string? Nullable	Stores the header panel code for this header.	Review
43	`HeaderReference`	string? Nullable	Stores the header reference for this header.	Review
44	`HeaderSpecialCode`	string? Nullable	Stores the header special code for this header.	Review
45	`HeaderZoneCode`	string? Nullable	Stores the header zone code for this header.	Review
46	`InactivatedDate`	DateTime? Nullable	Records the inactivated date.	Review
47	`InitialDueAircraftType`	string? Nullable	Stores the initial due aircraft type for this header.	Review
48	`InitialDueCheckOnlyActive`	bool Required	Stores the initial due check only active for this header.	Review
49	`InitialDueCheckType`	string? Nullable	Stores the initial due check type for this header.	Review
50	`IsAccidentRelated`	bool Required	Records whether accident related applies.	Review
51	`IsAdministrativeServiceTask`	bool Required	Records whether administrative service task applies.	Review
52	`IsAdministrativelyClosed`	bool Required	Records whether administratively closed applies.	Review
53	`IsCorrosion`	bool Required	Records whether corrosion applies.	Review
54	`IsCrsReleased`	bool Required	Records whether crs released applies.	Review
55	`IsCustomerComponent`	bool Required	Records whether customer component applies.	Review
56	`IsElbLeading`	bool Required	Records whether elb leading applies.	Review
57	`IsElbWorkorder`	bool Required	Records whether elb workorder applies.	Review
58	`IsInactiveWorkorder`	bool Required	Records whether inactive workorder applies.	Review
59	`IsIncidentRelated`	bool Required	Records whether incident related applies.	Review
60	`IsLiveBookingActive`	bool Required	Records whether live booking active applies.	Review
61	`IsNotContracted`	bool Required	Records whether not contracted applies.	Review
62	`IsNotPerformed`	bool Required	Records whether not performed applies.	Review
63	`IsOccurrenceReport`	bool Required	Records whether occurrence report applies.	Review
64	`IsStructuralDamage`	bool Required	Records whether structural damage applies.	Review
65	`IsStructuralRepairItem`	bool Required	Records whether structural repair item applies.	Review
66	`IsWatchItem`	bool Required	Records whether watch item applies.	Review
67	`IssueDateTime`	DateTime? Nullable	Records whether issue date time applies.	Review
68	`WorkpackageIssueMethod`	string? Nullable	Records whether issue method applies.	Review
69	`IssueSource`	string? Nullable	Names the primary source or workflow that issued the record.	Review
70	`IssueSourceRecordId`	Guid? Nullable	Identifies a single issuing source record; the model still retains this link.	Review
71	`IssueSourceReference`	string? Nullable	Human-readable reference for the issuing source.	Review
72	`IssueStation`	string? Nullable	Records whether issue station applies.	Review
73	`IssuerFamilyName`	string? Nullable	Records whether issuer family name applies.	Review
74	`IssuerFirstName`	string? Nullable	Records whether issuer first name applies.	Review
75	`IssuerSignature`	string? Nullable	Records whether issuer signature applies.	Review
76	`LastTransferDate`	DateTime? Nullable	Records the last transfer date.	Review
77	`LastTransferReason`	string? Nullable	Stores the last transfer reason for this header.	Review
78	`LiveBookingStartedAt`	DateTime? Nullable	Records the live booking started at.	Review
79	`LiveBookingStoppedAt`	DateTime? Nullable	Records the live booking stopped at.	Review
80	`NotPerformedDate`	DateTime? Nullable	Records the not performed date.	Review
81	`NotPerformedReason`	string? Nullable	Stores the not performed reason for this header.	Review
82	`OpenedDate`	DateTime? Nullable	Records the opened date.	Review
83	`OtherDue`	float? Nullable	Stores the other due for this header.	Review
84	`ParentWorkorderId`	Guid? Nullable	Links a workorder to its parent workorder when one exists.	Review
85	`PlannedDate`	DateTime Required	Records the planned date.	Review
86	`PlannedOtherDue`	float Required	Stores the planned other due for this header.	Review
87	`PlannedStation`	string? Nullable	Stores the planned station for this header.	Review
88	`PlannedTAC`	float Required	Stores the planned tac for this header.	Review
89	`PlannedTAH`	TimeSpan Required	Stores the planned tah for this header.	Review
90	`PlanningEndDate`	DateTime? Nullable	Planning end date for the workpackage.	Review
91	`ReleaseSign`	string? Nullable	Stores the release sign for this header.	Review
92	`RemovedInServiceableCondition`	bool Required	Stores the removed in serviceable condition for this header.	Review
93	`RequiresEngineChange`	bool Required	Records whether engine change applies.	Review
94	`RequiresRampActivity`	bool Required	Records whether ramp activity applies.	Review
95	`RequiresTaxi`	bool Required	Records whether taxi applies.	Review
96	`RequiresWeightAndBalance`	bool Required	Records whether weight and balance applies.	Review
97	`WorkpackageRoutineCheckType`	string? Nullable	Stores the routine check type for this header.	Review
98	`ShopFacilityId`	Guid? Nullable	Facility responsible for the shop workorder.	Review
99	`ShopWorkOrderNumber`	string? Nullable	Shop workorder number used by component maintenance.	Review
100	`SpecialEquipmentRequest`	string? Nullable	Stores the special equipment request for this header.	Review
101	`SpecialEquipmentRequest2`	string? Nullable	Stores the special equipment request2 for this header.	Review
102	`StandardDepartureTime`	DateTime? Nullable	Records the standard departure time.	Review
103	`StationFrom`	string? Nullable	Stores the station from for this header.	Review
104	`StationTo`	string? Nullable	Stores the station to for this header.	Review
105	`StockItemId`	Guid? Nullable	Selects the stock item record.	Review
106	`SystemAuditId`	Guid? Nullable	Reference to shared audit history.	Review
107	`TargetCompletionDate`	DateTime? Nullable	Records the target completion date.	Review
108	`TaskReferenceRemarks`	string? Nullable	Free-text notes about the task reference supplied when issuing the workorder; currently stored but not used by execution rules.	Review