select distinct LTDNO,SOURCENO,PARTNO,PARTNAME,PARTSERNO,PARTTYPE,PARTCODE,COLOR,SPECSIZE,P1,P2,P3,P4,P5,BILL,BILLRATE,CREATEDATE,NETRECEIPT,PACKAGE from D2001 where (CREATEDATE>'2015/08/31' or LAST_SDATE>='2016/01/01') and PARTNO is not null order by PARTNO,COLOR,SPECSIZE

