Select Sdtl_Store, Sdtl_CtrNo, Sdtl_TransNo, Sdtl_CloseDate, Sdtl_SeqNo, Sdtl_Stock_Code, Sdtl_Barcode,  Sdtl_Stock_Id,  Sdtl_ShortDesc, Sdtl_Uom, Sdtl_Sales_OperId,  Sdtl_Sales_RcptNo, Sdtl_Sales_Shift, Sdtl_Sales_PriceLvl,  Sdtl_Sales_Price_Shift, Sdtl_Stk_Group, Sdtl_Stk_Department, Sdtl_Stk_Sub_Department, Sdtl_Stk_Category, Sdtl_Stk_Brand, Sdtl_Stk_Color, Sdtl_Stk_Size, Sdtl_Qty, Sdtl_SellPrice, Sdtl_DiscAmt, Sdtl_Premium, Sdtl_NetPrice, Sdtl_UnitCost, (Sdtl_Qty*Sdtl_UnitCost) Sdtl_Tot_Cost, Sdtl_Status, Sdtl_DiscSubTotal, Sdtl_SalesPerson From Pos_SalesDtl Where Sdtl_Status='NS'

 And Sdtl_Sp_CommType='S' And Sdtl_CloseDate>='05/01/2017' And Sdtl_CloseDate<='05/15/2017'



Order by Sdtl_Store,Sdtl_SalesPerson,Sdtl_CtrNo,Sdtl_CloseDate,Sdtl_TransNo, Sdtl_SeqNo 

