Fields – ReservationCustomer

Field Name	Data Type	Description, Example
DealerId	string	Internal Dealer Identifier (intentionally left blank)
reservationcustid (key)	bigint	ID off the reservation customer record
reservationid (key)	bigint	ID of the reservation the customer record belongs too
customerid (key)	bigint	ID of the customer record
isprimaryrenter	string	Indicates if the customer is the primary renter
custprefixname	string	Prefix of the customer
custfirstname	string	First name of the customer
custmiddlename	string	Middle name of the customer
custlastname	string	Last name of the customer
custsuffixname	string	Suffix of the customer
custcompanyname	string	Customer company name
custsearchname	string	Combination of first and last name
custaddress1	string	Address line 1 of the customer
custaddress2	string	Address line 2 of the customer
custcounty	string	Address county
custcity	string	Address city
custzipcode	string	Address zip code
custstateprovince	string	Address state or providence
custcountry	string	Address country
custhomephone	string	Customer home phone number
custpagerphone	string	Customer pager number
custmobilephone	string	Customer mobile phone number
custfaxphone	string	Customer fax number
dtstamp	datetime	Time stamp of the record
custbirthdate	datetime	Birthdate of the customer
hasdriverslicensenumber	string	Indicates if the customer has a drivers license