Customers
Retrieves a list of customers.
Columns
Name | Type | References | |
Id [KEY] | Integer | ||
ParentCustomerId | String | ||
Token | String | ||
SuperuserId | Integer | ||
SuperuserFirstName | String | ||
SuperuserLastName | String | ||
SuperuserName | String | ||
SuperuserPhone | String | ||
SuperuserToken | String | ||
SuperuserUsername | String | ||
SuperuserEmail | String | ||
ExternalKey | String | ||
Company | String | ||
Total | Double | ||
Balance | Double | ||
Paid | Double | ||
CreatedAt | Datetime | ||
UpdatedAt | Datetime | ||
AdminEmail | String | ||
AdminId | Integer | ||
AdminName | String | ||
BillAddr1 | String | ||
BillAddr2 | String | ||
BillAddr3 | String | ||
BillBlock | String | ||
BillCity | String | ||
BillCountry | String | ||
BillNotes | String | ||
BillPostcode | String | ||
BillState | String | ||
BrandId | Integer | ||
CampaignId | String | ||
ClassId | String | ||
ClassName | String | ||
CurrencyId | Integer | ||
CurrencyIso4217 | String | ||
CurrencySymbol | String | ||
Custom1 | String | ||
Custom2 | String | ||
Custom3 | String | ||
Custom4 | String | ||
Custom5 | String | ||
Custom6 | String | ||
Custom7 | String | ||
Custom8 | String | ||
Custom9 | String | ||
Custom10 | String | ||
Custom11 | String | ||
Custom12 | String | ||
Custom13 | String | ||
Custom14 | String | ||
Custom15 | String | ||
Custom16 | String | ||
Custom17 | String | ||
Custom18 | String | ||
Custom19 | String | ||
Custom20 | String | ||
CustomerStatusId | Integer | ||
CustomerStatusName | String | ||
CustomerStatusState | String | ||
CustomerStatusStr | String | ||
CusttypeId | String | ||
CusttypeName | String | ||
DefaultAchId | String | ||
DefaultCreditcardId | String | ||
DefaultPaymethod | String | ||
DisplayAs | String | ||
DunningDelivery | String | ||
InvoiceDelivery | String | ||
LanguageId | Integer | ||
ModIpaddr | String | ||
NoDunning | Boolean | ||
NoTaxes | Boolean | ||
ShipAddr1 | String | ||
ShipAddr2 | String | ||
ShipAddr3 | String | ||
ShipBlock | String | ||
ShipCity | String | ||
ShipCountry | String | ||
ShipNotes | String | ||
ShipPostcode | String | ||
ShipState | String | ||
TaxIdent | String | ||
TermsDays | Integer | ||
TermsId | Integer | ||
TermsName | String | ||
UrlPaymethodlink | String | ||
UrlSelf | String | ||
UrlStatementlink | String | ||
WriteIpaddr | String |