View Name:sp_orders_v
View Number:6031
Group:Morder
Description:Gets orders assigned to site part through order_line table. Used in site_part_orders_search.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidorder_lineobjidSite_part internal record number 3 (UNIQUE)
sp_objidsite_partobjidSite_part internal record number 
order_act_objidorder_actionobjidOrder_action internal record number 
order_line_objidorder_lineobjidOrder_line internal record number 
order_objidcontractobjidOrder internal record number 
order_idcontractidOrder ID number 
order_datecontractstart_dateOrder start date 
order_actionorder_actionnameName of action for presentation of order 
expire_datecontractexpire_dateThe date the object ends. Where line items are involved, this is the ending service date of the latest line item 
accountbus_orgnameName of the organization 
statusgbst_elmtitleName of the item/element 
conditionconditiontitleTitle of condition 
first_namecontactfirst_nameContact's first name 
last_namecontactlast_nameContact's last name 
account_objidbus_orgobjidInternal record number 
contact_objidcontactobjidInternal record number 

Joins:

Join FromJoin To
(order_line).affected2site_part(site_part).affected_order_line2site_part
(order_line).order_line2order_action(order_action).order_action2order_line
(order_action).order_action2contract(contract).contract2order_action
(contract).sell_to2bus_org(bus_org).buyer2contract
(contract).contract2condition(condition).condition2contract
(contract).primary2contact(contact).primary2contract
(contract).status2gbst_elm(gbst_elm).status2contract
My Recent Objects
sp_orders_v