Open Orders

×
select
--Order Header Info
H.Ord_Type, H.Ord_No, Status, Bill_to_addr_1,Bill_to_addr_2,Bill_to_addr_3,Bill_to_addr_4, Ship_to_addr_1,Ship_to_addr_2,Ship_to_addr_3,Ship_to_addr_4
--Order Line Info
,l.Item_No,isnull(bdi.shortdescription,l.item_desc_1 + isnull(l.item_desc_2,'')) Description,l.qty_ordered ,l.qty_to_ship ,l.unit_price,l.discount_pct
from oeordhdr_sql H (nolock)
join oeordlin_sql L (nolock) on h.ord_type=l.ord_type and h.ord_no=l.ord_no
left join BDItems25 BDI (nolock) on l.item_no = bdi.item_no