View Name:order_shipping_vw
View Number:6055
Group:Morder
Description:Provides shipping address details of order actions. Used in fulfillment.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidorder_shippingobjidOrder shipping internal record number 
shipping_methodorder_shippingshipping_methodMethod of shipping - Fedex etc.  
add_objidaddressobjidAddress internal record number 
addressaddressaddressLine 1 of address which includes street number, street name, office, building, or suite number, etc 
address_2addressaddress_2Line 2 of address which typically includes office, building, or suite number, etc 
cityaddresscityThe city for the specified address 
zipcodeaddresszipcodeThe zip code or other postal code for the address 
stateaddressstateThe state for the specified address 
country_namecountrynameThe country name for the specified address 
country_objidcountryobjidCountry internal record number 
action_objidorder_actionobjidOrder_action internal record number 3 (UNIQUE)
cntr_objidcontractobjidOrder internal record number 
shipping_reforder_shippingshipping_refShipping reference number generated by the number scheme 
site_objidsiteobjidSite internal record number 
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
site_namesitenameName of the site 

Joins:

Join FromJoin To
(order_action).order_action2contract(contract).contract2order_action
(order_action).order_action2order_shipping(order_shipping).order_shipping2order_action
(order_shipping).order_shipping2site(site).site2order_shipping
(site).cust_primaddr2address(address).primary_addr2site
(address).address2country(country).country2address
My Recent Objects
order_shipping_vw