View Name:sales_quote_v
View Number:5478
Group:Sales Mgr
Description:Used by iClient to display quote information. Used in quote_list.jsp
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcontractobjidContract internal record number 3 (UNIQUE)
user_objiduserobjidUser owner internal record number 
acct_objidbus_orgobjidAccount internal record number 
status_objidgbst_elmobjidQuote status internal record number 
contact_objidcontactobjidContact internal record number 
currency_objidcurrencyobjidCurrency internal record number 
quote_idcontractidSystem-generated quote ID number 
quote_titlecontracttitleTitle of the quote 
quote_amountcontracttotal_netTotal net amount of the quote 
quote_owneruserlogin_nameOwner's login name 
quote_statusgbst_elmtitleTitle of the quote status 
q_start_datecontractq_start_dateQuote start date 
q_end_datecontractq_end_dateQuote end date 
acct_namebus_orgnameName of the prospect Account 
contact_fnamecontactfirst_nameContact's first name 
contact_lnamecontactlast_nameContact's last name 
contact_phonecontactphoneContact's phone 
quote_currencycurrencynameName of the quote's currency 
sub_scalecurrencysub_scaleGives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 
q_issue_datecontractq_issue_dtQuote issue date 
create_datecontractcreate_dtDate the quote/order was created 
submit_datecontractord_submit_dtDate the quote/order was submitted 
con_titlecontacttitleContact's professional title 
con_salutationcontactsalutationContact's form of address; e.g., Mr., Miss, Mrs 
quote_conditionconditiontitleThe quote's code number for its condition type  
condition_objidconditionobjidCondition internal record number 
opp_objidopportunityobjidOpportunity internal record number 
opp_nameopportunitynameName given to the opportunity 
struct_typecontractstruct_typeThe record type of the object; i.e., 0=service contract, 1=sales item, 2=eOrder, 3=shopping list 

Joins:

Join FromJoin To
(contract).owner2user(user).owner2contract
(contract).status2gbst_elm(gbst_elm).status2contract
(contract).primary2contactOUTER (contact).primary2contract
(contract).sell_to2bus_orgOUTER (bus_org).buyer2contract
(contract).contract2currency(currency).currency2contract
(contract).contract2condition(condition).condition2contract
(contract).contr_quote2opportunityOUTER (opportunity).opp_quote2contract
My Recent Objects
sales_quote_v