Unique customer identifier or account number assigned by the business

Example: "CUST-2024-00123"

Type of customer - 'individual' for B2C (person), 'business' for B2B (organization)

Values: individual, business

Example: "individual"

Reference to Person entity for B2C customers (when customerType is 'individual')

Reference to Organization entity for B2B customers (when customerType is 'business')

Current customer account status (active, inactive, suspended, pending, blacklisted)

Values: active, inactive, suspended, pending, blacklisted

Example: "active"

Date when the customer account was created

Example: "2024-01-15"

Date and time when the customer record was last modified

Example: "2024-11-10T14:30:00Z"

Whether this is a guest checkout customer (no account registration required for purchase). Found in 30-60% of e-commerce transactions

Date and time when a guest customer was converted to a registered customer account

Date of the customer's first purchase

Example: "2024-01-20"

Date of the customer's most recent purchase

Example: "2024-10-15"

Total number of orders placed by the customer

Example: 47

Total lifetime revenue from this customer

Average value per order

Customer's preferred currency for pricing and invoices

Customer's timezone in IANA format (e.g., 'America/New_York', 'Europe/Paris') for scheduling and time-sensitive communications

Example: "America/New_York"

Maximum credit allowed for B2B customers (null for B2C or unlimited credit)

Current outstanding balance owed by the customer

Default payment terms for B2B customers (Net 30, Net 60, COD, etc.)

Whether the customer is exempt from sales tax

Tax exemption certificate number if applicable

Example: "TAX-EXEMPT-12345"

Customer loyalty program tier (Bronze, Silver, Gold, Platinum, VIP)

Values: Bronze, Silver, Gold, Platinum, VIP

Example: "Gold"

Current loyalty points balance

Example: 2450

Date when customer joined the loyalty program

Example: "2024-01-15"

Marketing or business segment classification (VIP, Regular, New, Dormant, At-Risk, High-Value, etc.)

Values: VIP, Regular, New, Dormant, At-Risk, High-Value, Enterprise

Example: "High-Value"

Unique referral code for this customer to share with others

Example: "REF-SMITH-2024"

Reference to the customer who referred this customer

Marketing communication consent tracking per channel (email, sms, phone, mail, push) with timestamps and IP addresses for GDPR compliance

Newsletter subscription tracking (separate from general marketing consent)

Example: {"subscribed":true,"subscribedAt":"2024-01-15T10:30:00Z","subscribedIp":"192.168.1.100","unsubscribeToken":"a1b2c3d4e5f6g7h8"}

GDPR data processing consent and rights tracking with version history for privacy policy, terms of service, and data processing agreements

Preferred communication channels and frequency

Example: {"channel":"email","frequency":"weekly","timezone":"America/New_York"}

Assigned sales representative for B2B customers

Assigned account manager for B2B customers

Pricing tier for special customer pricing (Standard, Volume, Wholesale, Partner)

Values: Standard, Volume, Wholesale, Partner

Example: "Volume"

Default discount percentage applied to orders (0-100)

Example: 15

Annual revenue tier for B2B segmentation (0-1M, 1M-10M, 10M-100M, 100M+)

Values: 0-1M, 1M-10M, 10M-100M, 100M+

Example: "1M-10M"

Internal notes about the customer, preferences, or special requirements

Example: "Prefers morning deliveries. Requires invoice by email only."

Freeform tags for customer categorization and filtering

Example: ["wholesale","priority","tech-industry"]

Reference to parent customer in corporate hierarchy for B2B subsidiary relationships

Depth level in customer hierarchy (0 = root/top-level customer, 1 = direct subsidiary, 2+ = nested subsidiaries)

Example: 2

Comprehensive change log tracking all field-level modifications with before/after values for audit trail and regulatory compliance

References to customer records in external systems (Salesforce, SAP, etc.) for integration purposes

Example: [{"system":"Salesforce","externalId":"0031234567890ABC","syncedAt":"2024-11-10T10:00:00Z"},{"system":"SAP","externalId":"1000123","syncedAt":"2024-11-10T10:05:00Z"}]

Data quality metrics and duplicate management

Example: {"qualityScore":95,"lastVerifiedAt":"2024-11-01T00:00:00Z","isDuplicate":false}

Additional metadata for extensibility and custom fields