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. | |
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. |
Last updated