Coflyr · Backend model field catalog

CommercialPriceCondition

public.CommercialPriceConditions.

27 mapped fieldsUnder development6 field groupsGenerated 2026-10-06

Model class: coflyr.features.comm.billing.models.CommercialPriceCondition
Source: Features/Comm/Billing/Models/CommercialBillingDetails.cs
Table: public.CommercialPriceConditions
Review: Under development as of 2026-10-07. Field review remains open.

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

3 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`Name`	`string`	Required	Records name for this commercial price condition.
3	`PartNumber`	`string`	Required	Records part number for this commercial price condition.

Relationships and references

1 fields

#	Field	EF type	Storage	Business purpose
1	`CommercialPriceListId`	`Guid`	Required	Selects the related commercial price list record.

Status and controls

1 fields

#	Field	EF type	Storage	Business purpose
1	`IsShop`	`bool`	Required	Indicates whether shop applies to this commercial price condition.

Amounts and measurements

4 fields

#	Field	EF type	Storage	Business purpose
1	`MaximumAmount`	`decimal?`	Nullable	Stores the maximum amount used by this commercial price condition.
2	`MinimumAmount`	`decimal?`	Nullable	Stores the minimum amount used by this commercial price condition.
3	`Price`	`decimal`	Required	Stores the price used by this commercial price condition.
4	`PriceSource`	`string`	Required	Records price source for this commercial price condition.

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

16 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftTypeModelSubtype`	`string`	Required	Records aircraft type model subtype for this commercial price condition.
2	`Applicability`	`string`	Required	Records applicability for this commercial price condition.
3	`ConditionType`	`string`	Required	Records condition type for this commercial price condition.
4	`Discount`	`decimal`	Required	Records discount for this commercial price condition.
5	`DiscountUnit`	`string`	Required	Records discount unit for this commercial price condition.
6	`MaterialClass`	`string`	Required	Records material class for this commercial price condition.
7	`MaterialSupply`	`string`	Required	Records material supply for this commercial price condition.
8	`MaterialType`	`string`	Required	Records material type for this commercial price condition.
9	`OrderPriority`	`string`	Required	Records order priority for this commercial price condition.
10	`OrderType`	`string`	Required	Records order type for this commercial price condition.
11	`PartSpecial`	`string`	Required	Records part special for this commercial price condition.
12	`Station`	`string`	Required	Records station for this commercial price condition.
13	`Surcharge`	`decimal`	Required	Records surcharge for this commercial price condition.
14	`SurchargeUnit`	`string`	Required	Records surcharge unit for this commercial price condition.
15	`TypeOfWork`	`string`	Required	Records type of work for this commercial price condition.
16	`WorkTemplate`	`string`	Required	Records work template for this commercial price condition.