Coflyr · Backend model field catalog
CrmCustomerLead
public.CrmCustomerLeads.
18 mapped fieldsUnder development5 field groupsGenerated 2026-10-06
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.
Identity and naming
4 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | ContactPersonName | string | Required | Records contact person name for this crm customer lead. |
| 3 | CustomerName | string | Required | Records customer name for this crm customer lead. |
| 4 | LeadNumber | string | Required | Records lead number for this crm customer lead. |
Relationships and references
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CustomerPartnerId | Guid? | Nullable | Selects the related customer partner record. |
Dates and timing
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | TargetClosingDate | DateTime | Required | Records the target closing date for this crm customer lead. |
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
10 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Category | string | Required | Records category for this crm customer lead. |
| 2 | Classification | string | Required | Records classification for this crm customer lead. |
| 3 | ContactEmail | string | Required | Records contact email for this crm customer lead. |
| 4 | ContactPhone | string | Required | Records contact phone for this crm customer lead. |
| 5 | CustomerCode | string | Required | Records customer code for this crm customer lead. |
| 6 | EstimatedOpportunityValue | decimal | Required | Records estimated opportunity value for this crm customer lead. |
| 7 | LeadSource | string | Required | Records lead source for this crm customer lead. |
| 8 | Negotiator | string | Required | Records negotiator for this crm customer lead. |
| 9 | ResponsiblePerson | string | Required | Records responsible person for this crm customer lead. |
| 10 | Stage | int | Required | Records stage for this crm customer lead. |