Coflyr · Backend model field catalog

PickingListOrder

public.PickingListOrders.

15 mapped fields7 field groupsGenerated 2026-10-06

Model class: coflyr.features.materialmanagement.stores.models.PickingListOrder
Source: Features/MaterialManagement/Stores/Models/PickingListOrder.cs
Table: public.PickingListOrders
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

5 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`DocumentReferenceNumber`	`string`	Required	Records document reference number for this picking list order.
3	`DrawingSheetNumber`	`string`	Required	Records drawing sheet number for this picking list order.
4	`LineNumber`	`int`	Required	Records line number for this picking list order.
5	`PickslipNumber`	`string`	Required	Records pickslip number for this picking list order.

Relationships and references

2 fields

#	Field	EF type	Storage	Business purpose
1	`PartId`	`Guid`	Required	Selects the related part record.
2	`TargetWorkorderId`	`Guid?`	Nullable	Selects the related target workorder record.

Status and controls

2 fields

#	Field	EF type	Storage	Business purpose
1	`PickStatus`	`int`	Required	Tracks the pick status of this picking list order.
2	`PickslipItemStatus`	`string`	Required	Tracks the pickslip item status of this picking list order.

Dates and timing

1 fields

#	Field	EF type	Storage	Business purpose
1	`PickslipDate`	`DateTime`	Required	Records the pickslip date for this picking list order.

Amounts and measurements

2 fields

#	Field	EF type	Storage	Business purpose
1	`PickedQuantity`	`decimal`	Required	Stores the picked quantity used by this picking list order.
2	`RequestedQuantity`	`decimal`	Required	Stores the requested quantity used by this picking list 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

1 fields

#	Field	EF type	Storage	Business purpose
1	`AssignedStoreBinLocation`	`string`	Required	Records assigned store bin location for this picking list order.