Customers

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the customer.
AccountBalance	Integer	False		The current balance of the customer.
AddressAggregate	String	False		The customer's address.
Created	Datetime	True		The time of creation.
Currency	String	False		The currency the customer can be charged in for recurring billing purposes.
DefaultSource	String	False		The Id of the default source attached to this customer.
Delinquent	Boolean	True		Whether or not the latest charge for the latest invoice of the customer has failed.
DiscountId	String	False	CustomerDiscounts.CouponId	The id of the discount.
Description	String	False		The customer description.
Email	String	False		The email of the customer.
Livemode	Boolean	True		If the customer is in live mode.
MetadataAggregate	String	False		The set of key/value pairs that you can attach to a customer object.
Name	String	False		The customer's full name or business name.
Phone	String	False		The customer's phone number.
ShippingAggregate	String	False		The shipping information associated with the customer.
SourcesdataAggregate	String	False		The payment sources of the customer, if any.
SubscriptionsDataAggregate	String	False		The current subscriptions of the customer, if any.

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
AccountId	String	The Id of the connected account to get customers for.