Customer

Table:
customer
Model Version:
774910e5132e27b6
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
custom field values
customerType
Customer, Fleet
deferredServiceCount
integer
deleted
boolean
if the record has been deleted
deletedDate
Nullable
date-time
the date that the record was deleted or null if not deleted
deletedReason
Nullable
string
the reason that the record was deleted
deletedUserId
Nullable
string
the user that deleted the record or null if not deleted
discountPercent
number
dotNumber
Nullable
string
externalId
Nullable
string
an id that can be used to reference the customer in an external system
finixIdentityId
Nullable
string
firstName
Nullable
string
fleetId
Nullable
string
gstExempt
boolean
CA specific
hstExempt
boolean
CA specific
id
Primary Key
string
imported
boolean
labels
object
laborMatrixId
Nullable
string
laborRateId
Nullable
string
lastName
Nullable
string
lastTimeOrderWorked
Nullable
date-time
locationIds
string[]
the locations that the customer is associated with
marketingOptIn
boolean
messageCount
integer
metadata
Nullable
object
metadata reserved for customers to control
normalizedFirstName
Nullable
string
normalizedLastName
Nullable
string
normalizedName
Nullable
string
if fleet, contains the normalized companyName, else normalized firstName lastName
note
string
orderCount
integer
originLocationId
Nullable
string
the location that created the customer
paymentTermId
Nullable
string
postalCode
Nullable
string
preferredContactMethod
Nullable
SMS, Email, All
preferredLanguage
en, en_US, fr_CA
pricingMatrixId
Nullable
string
pstExempt
boolean
CA specific
publicId
string
referralSourceId
Nullable
string
state
Nullable
string
statementCount
integer
taxExempt
boolean
US specific
transactionCount
integer
updatedDate
Nullable
date-time
vehicleCount
integer
website
Nullable
string