Coflyr · Backend model field catalog

CommercialQuotation

public.CommercialQuotations.

24 mapped fieldsUnder development7 field groupsGenerated 2026-10-06

Model class: coflyr.features.comm.quotation.models.CommercialQuotation
Source: Features/Comm/Quotation/Models/CommercialQuotation.cs
Table: public.CommercialQuotations
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	`QuotationNumber`	`string`	Required	Records quotation number for this commercial quotation.

Relationships and references

4 fields

#	Field	EF type	Storage	Business purpose
1	`CurrencyId`	`Guid`	Required	Selects the related currency record.
2	`CustomerPartnerId`	`Guid`	Required	Selects the related customer partner record.
3	`ExternalReference`	`string`	Required	Records external reference for this commercial quotation.
4	`TargetWorkorderId`	`Guid?`	Nullable	Selects the related target workorder record.

Status and controls

2 fields

#	Field	EF type	Storage	Business purpose
1	`IssuedBy`	`string`	Required	Indicates whether issued by applies to this commercial quotation.
2	`QuotationStatus`	`int`	Required	Tracks the quotation status of this commercial quotation.

Dates and timing

2 fields

#	Field	EF type	Storage	Business purpose
1	`QuotationDate`	`DateTime`	Required	Records the quotation date for this commercial quotation.
2	`ValidityDate`	`DateTime`	Required	Records the validity date for this commercial quotation.

Amounts and measurements

4 fields

#	Field	EF type	Storage	Business purpose
1	`HeaderDiscountPercent`	`decimal`	Required	Stores the header discount percent used by this commercial quotation.
2	`QuotationTotalAmount`	`decimal`	Required	Stores the quotation total amount used by this commercial quotation.
3	`TotalLaborAmount`	`decimal`	Required	Stores the total labor amount used by this commercial quotation.
4	`TotalMaterialAmount`	`decimal`	Required	Stores the total material amount used by this commercial quotation.

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

8 fields

#	Field	EF type	Storage	Business purpose
1	`AdditionalDiscounts`	`decimal`	Required	Records additional discounts for this commercial quotation.
2	`AdditionalSurcharges`	`decimal`	Required	Records additional surcharges for this commercial quotation.
3	`BillToAddress`	`string`	Required	Records bill to address for this commercial quotation.
4	`CustomerContact`	`string`	Required	Records customer contact for this commercial quotation.
5	`DeliveryAddress`	`string`	Required	Records delivery address for this commercial quotation.
6	`Incoterms`	`string`	Required	Records incoterms for this commercial quotation.
7	`PaymentCondition`	`string`	Required	Records payment condition for this commercial quotation.
8	`Responsible`	`string`	Required	Records responsible for this commercial quotation.