| CRM |
Schema Name (CRM) |
Archtics Field |
| Salutation |
salutation |
|
| First Name |
firstname |
name_first |
| Last Name |
lastname |
name_last |
| Work Phone |
telephone1 |
custphone.phone_number_formatted where phone_type in (‘d’,’w’) |
| Fax |
fax |
custphone.phone_number_formatted where phone_type in (‘f’) |
| Home Phone |
telephone2 |
custphone.phone_number_formatted where phone_type in (‘e’,’h’) |
| Cell Phone |
mobilephone |
custphone.phone_number_formatted where phone_type in (‘c’) |
| Ticketing Type |
kore_ticketingcontacttype |
name_type |
| Miles From Facility |
kore_address1milesfromfacility |
(KORE calculated) |
| Primary Account Number |
kore_primaryaccountnumber |
acct_id |
| Account Numbers |
kore_accountnumbers |
acct_id (short list of commaseparated IDs form ticketing system) |
| Postal Code |
address1_postalcode |
zip |
| Street 1 |
address1_line1 |
street_addr_1 |
| Street 2 |
address1_line2 |
street_addr_2 |
| City |
address1_city |
city |
| State/Province |
address1_stateorprovince |
state |
| Country |
address1_country |
country |
| Job Title |
jobtitle |
name_title |
| Email |
emailaddress1 |
cust_email.email_addr (first email, primary_ind, cust_name_primary_code, email_sort, etc) |
| (visible via KORE grids) |
(visible via KORE grids) |
cust_email.email_addr (first other email listed) |
| Account |
parentcustomerid |
company_name |
| Ticketing Service Rep |
kore_ticketingservicerep |
(data from custrep) |
| Ticketing Sales Rep |
kore_ticketingsalesrep |
(data from custrep) |
| Group Sales Rep |
kore_groupsalesrep |
(data from custrep) |
| Suites Sales Rep |
kore_suitesalesrep |
(data from custrep) |
