| View Name: | case_more_info |
| View Number: | 5740 |
| Group: | Support |
| Description: | View of case more info tab. Used in case_overview.jsp |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| address_objid | address | objid | Address internal record number | |
| alt_phone_num | case | alt_phone_num | The alternate phone number for the contact | |
| case_id | case | id_number | Unique case number assigned based on auto-numbering definition | 4 |
| case_objid | case | objid | Case internal record number | 3 (UNIQUE) |
| case_status | gse_status(gbst_elm) | objid | Case status | 17 |
| cclist1 | case | cclist1 | Recipient on carbon copy list 1 | |
| cclist2 | case | cclist2 | Recipient on carbon copy list 2 | |
| con_objid | contact | objid | Contact internal record number | |
| condition | condition | title | Title of condition | 7 |
| condition_objid | condition | objid | Condition internal record number | |
| country_code | country | code | Country code used in telephone numbers for that country | |
| country_objid | country | objid | Country internal record number | |
| creation_time | case | creation_time | The date and time the case was created | 1 |
| e_mail | contact | e_mail | Contact e-mail address | |
| fax_number | contact | fax_number | Contact's fax number which includes area code, number, and extension | |
| first_name | contact | first_name | Contact first name | 15 |
| last_name | contact | last_name | Contact last name | 14 |
| login_name | user | login_name | User login name | |
| phone | contact | phone | Contact's phone number which includes area code, number, and extension | |
| queue_objid | queue | objid | Queue internal record number | 18 |
| queue_title | queue | title | Queue title | 2 |
| site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
| site_name | site | name | Site name | |
| site_objid | site | objid | Site internal record number | |
| title | contact | title | Contact's professional title | |
| user_objid | user | objid | Case owner's Internal record number | |
| wipbin_name | wipbin | title | Name of the wipbin | |
| wipbin_objid | wipbin | objid | WIPbin internal record number |
Join From | Join To |
|---|---|
| (case).casests2gbst_elm | gse_status(gbst_elm).case_status2case |
| (case).case_owner2user | (user).curr_owner2case |
| (case).case_state2condition | (condition).case_condition2case |
| (case).case_currq2queue | OUTER (queue).currq2case |
| (case).case_wip2wipbin | OUTER (wipbin).wipbin2case |
| (case).alt_contact2contact | OUTER (contact).case_alt_contact2case |
| (case).case_distr2site | OUTER (site).seller2case |
| (case).case2address | (address).address2case |
| (address).address2country | (country).country2address |
| case_more_info | |||