Customer

Table:
customer
Model Version:
16035569b8c26f21
JSON Schema:
Customer
address1
Nullable
string
address2
Nullable
string
appointmentCount
integer
city
Nullable
string
coalescedFirstNameOrCompanyName
Nullable
string
companyId
string
companyName
Nullable
string
country
Nullable
US, CA, MX, AF, AX, AL, DZ, AS, AD, AO, AI, AQ, AG, AR, AM, AW, AU, AT, AZ, BS, BH, BD, BB, BY, BE, BZ, BJ, BM, BT, BO, BQ, BA, BW, BV, BR, IO, VG, BN, BG, BF, BI, CV, KH, CM, KY, CF, TD, CL, CN, HK, MO, CX, CC, CO, KM, CG, CK, CR, HR, CU, CW, CY, CZ, CI, KP, CD, DK, DJ, DM, DO, EC, EG, SV, GQ, ER, EE, SZ, ET, FK, FO, FJ, FI, FR, GF, PF, TF, GA, GM, GE, DE, GH, GI, GR, GL, GD, GP, GU, GT, GG, GN, GW, GY, HT, HM, VA, HN, HU, IS, IN, ID, IR, IQ, IE, IM, IL, IT, JM, JP, JE, JO, KZ, KE, KI, KW, KG, LA, LV, LB, LS, LR, LY, LI, LT, LU, MG, MW, MY, MV, ML, MT, MH, MQ, MR, MU, YT, FM, MC, MN, ME, MS, MA, MZ, MM, NA, NR, NP, NL, NC, NZ, NI, NE, NG, NU, NF, MP, NO, OM, PK, PW, PA, PG, PY, PE, PH, PN, PL, PT, PR, QA, KR, MD, RO, RU, RW, RE, BL, SH, KN, LC, MF, PM, VC, WS, SM, ST, SA, SN, RS, SC, SL, SG, SX, SK, SI, SB, SO, ZA, GS, SS, ES, LK, PS, SD, SR, SJ, SE, CH, SY, TW, TJ, TH, MK, TL, TG, TK, TO, TT, TN, TR, TM, TC, TV, UG, UA, AE, GB, TZ, UM, VI, UY, UZ, VU, VE, VN, WF, EH, YE, ZM, ZW
createdDate
date-time
customFields
Nullable
object
customerType
Customer, Fleet
deferredServiceCount
integer
deleted
boolean
deletedDate
Nullable
date-time
deletedReason
Nullable
string
deletedUserId
Nullable
string
discountPercent
number
dotNumber
Nullable
string
externalId
Nullable
string
finixIdentityId
Nullable
string
firstName
Nullable
string
fleetId
Nullable
string
gstExempt
boolean
hstExempt
boolean
id
Primary Key
string
imported
boolean
labels
object
laborMatrixId
Nullable
string
laborRateId
Nullable
string
lastName
Nullable
string
lastTimeOrderWorked
Nullable
date-time
locationIds
string[]
marketingOptIn
Deprecated
boolean
messageCount
integer
metadata
Nullable
object
normalizedFirstName
Nullable
string
normalizedLastName
Nullable
string
normalizedName
Nullable
string
note
string
orderCount
integer
originLocationId
Nullable
string
paymentTermId
Nullable
string
postalCode
Nullable
string
preferredContactMethod
Nullable
SMS, Email, All
preferredLanguage
en, en_US, fr_CA, es_MX
pricingMatrixId
Nullable
string
pstExempt
boolean
publicId
string
referralSourceId
Nullable
string
state
Nullable
string
statementCount
integer
taxExempt
boolean
transactionCount
integer
updatedDate
Nullable
date-time
vehicleCount
integer
website
Nullable
string