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 |
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) |