SELECT NoOrder AS data_transaksi_id ,'106.16.05.05.0198' AS nopd ,
ROUND((jmlpenjualan+(jmlpenjualan*0.075)+((jmlpenjualan+(jmlpenjualan*0.075))*0.1)),-0) nilai_transaksi, ROUND(((jmlpenjualan+(jmlpenjualan*0.075))*0.1),-0) pajak_transaksi,ROUND((jmlpenjualan*0.075),-0) AS layanan_transaksi,TglPosting AS waktu_transaksi,'1' AS '@version',NoOrder AS private_key,TglPosting AS '@timestamp',CONCAT(    'NoOrder ',NoOrder    ,CHAR(13,10),'JmlPenjualan ',JmlPenjualan    ,CHAR(13,10),'jmlService ',jmlService ,CHAR(13,10),'jmlTax ',jmlTax ,CHAR(13,10),'TglPosting ',TglPosting ) AS keterangan FROM t_sales WHERE TglPosting >= CURDATE() -INTERVAL 60 DAY AND NoOrder ='CXJ04-20012000045513'