Coflyr · Backend model field catalog

CommercialPriceList

public.CommercialPriceLists.

15 mapped fieldsUnder development7 field groupsGenerated 2026-10-06

Model class: coflyr.features.comm.billing.models.CommercialPriceList
Source: Features/Comm/Billing/Models/CommercialPriceList.cs
Table: public.CommercialPriceLists
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

2 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`PriceListName`	`string`	Required	Records price list name for this commercial price list.

Relationships and references

2 fields

#	Field	EF type	Storage	Business purpose
1	`CurrencyId`	`Guid`	Required	Selects the related currency record.
2	`CustomerPartnerId`	`Guid?`	Nullable	Selects the related customer partner record.

Status and controls

1 fields

#	Field	EF type	Storage	Business purpose
1	`IsActive`	`bool`	Required	Indicates whether active applies to this commercial price list.

Dates and timing

2 fields

#	Field	EF type	Storage	Business purpose
1	`EffectiveEndDate`	`DateTime?`	Nullable	Records the effective end date for this commercial price list.
2	`EffectiveStartDate`	`DateTime`	Required	Records the effective start date for this commercial price list.

Amounts and measurements

3 fields

#	Field	EF type	Storage	Business purpose
1	`LaborRatePerHour`	`decimal`	Required	Records labor rate per hour for this commercial price list.
2	`MaterialMarkupPercent`	`decimal`	Required	Stores the material markup percent used by this commercial price list.
3	`PriceListCode`	`string`	Required	Records price list code for this commercial price list.

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

3 fields

#	Field	EF type	Storage	Business purpose
1	`EntityCode`	`string`	Required	Records entity code for this commercial price list.
2	`MaintenanceType`	`string`	Required	Records maintenance type for this commercial price list.
3	`Station`	`string`	Required	Records station for this commercial price list.