View Name:case_display
View Number:5338
Group:Clear Sales
Description:Displays cases in Account Manager. Used by form Account Manager (11650)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcaseobjidCase internal record number 3 (UNIQUE)
id_numbercaseid_numberUnique case number assigned based on auto-numbering definition 4
conditionconditiontitleCondition of the case 7
statusgse_status(gbst_elm)titleStatus of the case 8
titlecasetitleCase or service call title; summary of case details 2
creation_timecasecreation_timeThe date and time the case was created 
first_namecontactfirst_nameContact first name 
last_namecontactlast_nameContact last name 
phonecontactphoneContact phone number 
severitygse_severity(gbst_elm)titleSeverity of the case 36
typegse_type(gbst_elm)titleType of case 37
is_supercasecaseis_supercaseIndicates whether the case is a super or a victim case; i.e., 0=normal or victim case, 1=supercase 
cond_objidconditionobjidCondition internal record number 
status_objidgse_status(gbst_elm)objidStatus internal record number 
type_objidgse_type(gbst_elm)objidType internal record number 
severity_objidgse_severity(gbst_elm)objidSeverity internal record number 
site_objidsiteobjidSite internal record number 
site_namesitenameName of the reporting site 
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
condition_codeconditionconditionCode number for condition type 
contact_objidcontactobjidContact internal record number 

Joins:

Join FromJoin To
(case).case_state2condition(condition).case_condition2case
(case).calltype2gbst_elmgse_type(gbst_elm).call_type2case
(case).respsvrty2gbst_elmgse_severity(gbst_elm).resp_severity2case
(case).case_reporter2contact(contact).caller2case
(case).casests2gbst_elmgse_status(gbst_elm).case_status2case
(case).case_reporter2site(site).cust_loc2case
My Recent Objects
case_display