Coflyr · Backend model field catalog

MaterialSalesPriceList

public.MaterialSalesPriceLists.

21 mapped fields6 field groupsGenerated 2026-10-06

Model class: coflyr.features.comm.sales.models.MaterialSalesPriceList
Source: Features/Comm/Sales/Models/MaterialSalesPriceList.cs
Table: public.MaterialSalesPriceLists
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

2 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`ProjectNumber`	`string`	Required	Records project number for this material sales price list.

Relationships and references

3 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.
3	`PartId`	`Guid`	Required	Selects the related part record.

Status and controls

3 fields

#	Field	EF type	Storage	Business purpose
1	`ExcludeCustomerSuppliedMaterial`	`bool`	Required	Indicates whether exclude customer supplied material applies to this material sales price list.
2	`IncludeSubProjects`	`bool`	Required	Indicates whether include sub projects applies to this material sales price list.
3	`IsActive`	`bool`	Required	Indicates whether active applies to this material sales price list.

Amounts and measurements

5 fields

#	Field	EF type	Storage	Business purpose
1	`BaseSalesPrice`	`decimal`	Required	Stores the base sales price used by this material sales price list.
2	`DefaultPrice`	`decimal`	Required	Stores the default price used by this material sales price list.
3	`DiscountPercent`	`decimal`	Required	Stores the discount percent used by this material sales price list.
4	`MinimumOrderQuantity`	`decimal`	Required	Stores the minimum order quantity used by this material sales price list.
5	`PriceAdjustmentPercent`	`decimal`	Required	Stores the price adjustment percent used by this material sales 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

6 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftRegistration`	`string`	Required	Records aircraft registration for this material sales price list.
2	`BookingsFrom`	`DateTime?`	Nullable	Records bookings from for this material sales price list.
3	`BookingsTo`	`DateTime?`	Nullable	Records bookings to for this material sales price list.
4	`EntityCode`	`string`	Required	Records entity code for this material sales price list.
5	`ValidFrom`	`DateTime?`	Nullable	Records valid from for this material sales price list.
6	`ValidTo`	`DateTime?`	Nullable	Records valid to for this material sales price list.