View Name:lit_req_view
View Number:5229
Group:Sales Mgr
Description:Literature request details. Used by form My Clarify (12000), Opportunity (13000), Account (11650), Lead (11610) and Generic Query (20000)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidlit_reqobjidLit_req internal record number 3 (UNIQUE)
lit_req_idlit_reqlit_req_idUnique ID number of the template; assigned acording to auto-numbering definition 
titlelit_reqtitleTitle of the literature request 
commentslit_reqcommentsComments about the literature request 
ship_vialit_reqship_viaRequested means of shipment. This is from a Clarify-defined popup list with default name SHIP_VIA 
create_datelit_reqcreate_dateDate the template was created 
required_datelit_reqrequired_dateDate that shipment to the addressees is required(lit_ship_req) 
fulfilled_datelit_reqfulfilled_dateDate that shipment to the addressees was completed 
statusgse_status(gbst_elm)titleThe status of the template 
send_typegse_sendtype(gbst_elm)titleThe sending method for the template 
owneruserlogin_nameLogin_name of the user owning the template 
owner_objiduserobjidUser internal record number of the user owning the template 

Joins:

Join FromJoin To
(lit_req).lit_owner2user(user).lit_owner2lit_req
(lit_req).lit_status2gbst_elmgse_status(gbst_elm).status2lit_req
(lit_req).lit_send2gbst_elmgse_sendtype(gbst_elm).send_type2lit_req
My Recent Objects
lit_req_view