Customers

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Long	True	A unique numeric identifier for the customer.
LastOrderId	Long	True	The id of the customer's last order.
LastOrderName	String	True	The name of the customer's last order.
FirstName	String	False	The customer's first name.
LastName	String	False	The customer's last name.
Email	String	False	The unique email address of the customer.
Phone	String	False	The unique phone number for this customer.
TaxExempt	Boolean	False	Indicates whether the customer should be charged taxes when placing orders.
TotalSpent	Decimal	True	The total amount of money that the customer has spent at the shop.
OrdersCount	Integer	True	The number of orders associated with this customer.
AcceptsMarketing	Boolean	True	Indicates whether the customer has consented to be sent marketing material via email.
MultipassIdentifier	String	True	The customer's identifier used with Multipass login.
Note	String	False	A note about the customer.
State	String	True	The state of the customer's account in a shop.
Tags	String	False	The tags for this customer. Separate with comma for multiple tags.
VerifiedEmail	Boolean	True	States whether or not the email address has been verified.
CreatedAt	Datetime	True	The date and time when the customer was created.
UpdatedAt	Datetime	True	The date and time when the customer information was updated.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Password	String	Password of the customer
PasswordConfirmation	String	Password confirmation of the customer.
SendEmailWelcome	Boolean	Whether to send a welcome email to the customer or not.
SendEmailInvite	Boolean	Whether to send an invite email to the customer or not.