select convert(varchar(20),po.[PurchasedOn],111) as PurchasedOn,cu.[CustomerCode],po.CustomerOrderNo,po.[OutTradeSN],

convert(varchar(20),co.[CreatedOn],111) as CreatedOn,shop.[ShopName],cate.[CategoryName],poi.PurchaseQuantity,(poi.PurchaseQuantity*poi.PurchasePrice) as PaymentForGoods,po.[Cn2CnFreightAmount],
((poi.PurchaseQuantity*poi.PurchasePrice)+po.[Cn2CnFreightAmount]) as TotalMoney,po.OutPaySN,po.[PurchaseByName],ca.[CompanyAlias],eo.[ExpressNo]
from [Erp].[trade].[PurchaseOrders] po
inner join [trade].[CustomerOrders] co on po.[CustomerOrderNo] = co.[OrderNo]
inner join [CRM].[Customers] cu on cu.[CustomerId]=co.[CustomerId]
inner join [trade].[PurchaseItems] poi on poi.[PurchaseOrderId]=po.PurchaseOrderId
inner join [goods].[Shops] shop on shop.[ShopId] = po.[ShopId]
inner join [goods].[Goods] good on good.[GoodsId] = poi.[GoodId]
inner join [goods].[Categories] cate on cate.[CategoryId] = good.[CategoryId]
inner join [trade].[ExpressOrders2PurchaseItems] eopi on eopi.[PurchaseItemId] = poi.[PurchaseItemId]
inner join [trade].[ExpressOrders] eo on eo.[ExpressOrderId] = eopi.[ExpressOrderId]
inner join [basic].[CompanyAlias] ca on ca.CompanyId = eo.ExpressCompanyId
where month(po.[PurchasedOn])=month(getdate()) and year(po.[PurchasedOn])=year(getdate())
order by po.[PurchasedOn] asc