| Table Name: | e_addr |
| Table Number: | 427 |
| Group: | Customer Mgr |
| Description: | Electronic address object, contains addressing for phones, pagers, email, etc |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| access_num | CHAR | varchar | 20 | Used to store any additional number needed to complete an address after the initial connection is made; e.g., voice mail box number, telephone extension number, etc | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| e_num | CHAR | varchar | 255 | Full electonic address number; e.g., phone number including country code (if needed) and area code, email number, pager number. This is the addressable number | Search (4) | |||
| e_subtype | LONG | smallint | DIRECT | Subtype of electronic address within type; e.g., if type=1, subtypes are SMTP, Microsoft, Lotus Notes, Internet, and so on. Reserved; future | ||||
| e_type | LONG | smallint | DIRECT | Type of electronic address; i.e., 0=reserved, 1=e-mail, 2=phone, 3=fax, 4-9999 (Reserved) | Search (3) | |||
| modify_stmp | CLK_TIME | datetime | 46 | Date and time when object was last saved | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) | ||
| subtype | CHAR | varchar | 20 | Kind of electronic address within type; e.g., if type is email, subtypes are SMTP, Microsoft, Lotus Notes, Internet, and so on. This is a user-defined pop up. Reserved; not used | ||||
| type | CHAR | varchar | 20 | Customer-defined type of electronic address; e.g., email, pager, phone, fax, web, etc. This is a user-defined pop up. Reserved; not used | ||||
| useage | CHAR | varchar | 30 | Use of the electronic address; e.g., primary phone, alternate phone, primary fax, and so on |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| primary_e_addr2blg_argmnt | OTM | blg_argmnt | primary_blg_argmnt2e_addr | Primary billing arrangement for an email address | |||
| eaddr2bus_org | MTO | bus_org | bus_org2e_addr | Business organization which owns the address | Search (1) | ||
| eaddr2contact | MTO | contact | contact2e_addr | Contact who owns the address | Search (1) | ||
| e_addr2e_addr_ba_role | OTM | e_addr_ba_role | e_addr_ba_role2e_addr | Billing Arrangement roles for e-addr | |||
| eaddr2edr_com_role | OTM | edr_com_role | edr_role2e_addr | Electronic address which owns the address | |||
| eaddr2employee | MTO | employee | employee2e_addr | Employee who owns the address | |||
| eaddr2site | MTO | site | site2e_addr | Site which owns the address | |||
| eaddr2site_part | MTO | site_part | part2e_addr | Installed part which owns the address |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_eaddr2bus_org | eaddr2bus_org, objid | nonclustered, unique located on PRIMARY |
| ind_eaddr2contact | eaddr2contact, objid | nonclustered, unique located on PRIMARY |
| ind_eaddr2employee | eaddr2employee, objid | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5449 | eaddr_cmcn | communication, dialogue, e_addr, edr_com_role |
| 5827 | bar_busorg_fa_pm_eaddr_v | blg_argmnt, bus_org, e_addr, fin_accnt, pay_means |
| 5828 | bar_rel_prim_addr_v | address, blg_argmnt, bus_org, country, e_addr, fin_accnt, site, state_prov, time_zone |
| 5852 | edr_cntct_acct | bus_org, contact, e_addr |
| e_addr | |||