120Water Import Template Documentation

Column Header	Data Type & Restrictions
120WATER LOCATION ID	Whole Number
EXTERNAL LOCATION ID	Text field
120WATER CONTACT ID	Whole Number
CONTACT TYPE	Any option from the ContactType reference table (available from the left menu).
FIRST NAME	Text field fewer than 100 characters long
LAST NAME	Text field fewer than 100 characters long
TITLE ORGANIZATION	Text field fewer than 100 characters long
SALUTATION	Text field fewer than 50 characters long
PRIMARY LANGUAGE	Any option from the ContactLanguage reference table (available from the left menu).
PREFERRED CONTACT METHOD	One of: Do Not Contact Call Email Letter SMS
PRIMARY PHONE	Text field fewer than 50 characters long A 7- or 10-digit phone number
PRIMARY PHONE EXT	Text field fewer than 10 characters long
IS PRIMARY PHONE MOBILE	True or False
ALTERNATIVE PHONE	Text field fewer than 20 characters long A 7- or 10-digit phone number
ALTERNATIVE PHONE EXT	Text field fewer than 10 characters long
IS ALTERNATIVE PHONE MOBILE	True or False
FAX	Text field fewer than 50 characters long A 7- or 10-digit phone number
EMAIL	Text field fewer than 150 characters long
ADDRESS LINE 1	Text field fewer than 100 characters long
ADDRESS LINE 2	Text field fewer than 100 characters long
CITY	Text field fewer than 50 characters long
STATE	Text field
POSTAL CODE	Text field A zip code in 5 or 5-4 format
COUNTRY	Text field fewer than 200 characters long
CUSTOMER BILLING NUMBER	Text field fewer than 50 characters long
DESIGNATION	Any option from the ContactDesignation reference table (available from the left menu).
STATUS	One of: A Active I Inactive
NOTES	Text field fewer than 200 characters long

Contacts Import Template