Coflyr · Backend model field catalog

PurchaseOrder

public.PurchaseOrders.

23 mapped fieldsUnder development7 field groupsGenerated 2026-10-06

Model class: coflyr.features.materialmanagement.orders.models.PurchaseOrder
Source: Features/MaterialManagement/Orders/Models/PurchaseOrder.cs
Table: public.PurchaseOrders
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	`OrderNumber`	`string`	Required	Records order number for this purchase order.

Relationships and references

3 fields

#	Field	EF type	Storage	Business purpose
1	`CurrencyId`	`Guid`	Required	Selects the related currency record.
2	`ExternalReference`	`string`	Nullable	Records external reference for this purchase order.
3	`VendorId`	`Guid`	Required	Selects the related vendor record.

Status and controls

3 fields

#	Field	EF type	Storage	Business purpose
1	`IsApproved`	`bool`	Required	Indicates whether approved applies to this purchase order.
2	`OrderStatus`	`int`	Required	Tracks the order status of this purchase order.
3	`RequiresApproval`	`bool`	Required	Indicates whether approval applies to this purchase order.

Dates and timing

4 fields

#	Field	EF type	Storage	Business purpose
1	`ActualDeliveryDate`	`DateTime?`	Nullable	Records the actual delivery date for this purchase order.
2	`ApprovedDate`	`DateTime?`	Nullable	Records the approved date for this purchase order.
3	`ExpectedDeliveryDate`	`DateTime?`	Nullable	Records the expected delivery date for this purchase order.
4	`OrderDate`	`DateTime`	Required	Records the order date for this purchase order.

Amounts and measurements

5 fields

#	Field	EF type	Storage	Business purpose
1	`ExchangeRate`	`decimal`	Required	Records exchange rate for this purchase order.
2	`ShippingCost`	`decimal`	Required	Stores the shipping cost used by this purchase order.
3	`SubTotal`	`decimal`	Required	Stores the sub total used by this purchase order.
4	`TaxAmount`	`decimal`	Required	Stores the tax amount used by this purchase order.
5	`TotalAmount`	`decimal`	Required	Stores the total amount used by this purchase order.

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

4 fields

#	Field	EF type	Storage	Business purpose
1	`ApprovedBy`	`string`	Nullable	Records approved by for this purchase order.
2	`Incoterms`	`string`	Nullable	Records incoterms for this purchase order.
3	`PaymentTerms`	`string`	Nullable	Records payment terms for this purchase order.
4	`Type`	`int`	Required	Records type for this purchase order.