* 6/11/2012 3:51:38 PM, 1, KELVIN ONG CHEONG KEONG *
Select Count(*), Sum(SDTL_DISCAMT) SDTL_DISCAMT, Sum(SDTL_NETPRICE) SDTL_NETPRICE, Sum(SDTL_QTY) SDTL_QTY, Sum(SDTL_TAXABLEAMT1) SDTL_TAXABLEAMT1, Sum(SDTL_TAXABLEAMT2) SDTL_TAXABLEAMT2, Sum(SDTL_TAXABLEAMT3) SDTL_TAXABLEAMT3, Sum(SDTL_TAXABLEAMT4) SDTL_TAXABLEAMT4, Sum(SDTL_TAXEXEMPT1TOT) SDTL_TAXEXEMPT1TOT, Sum(SDTL_TAXEXEMPT2TOT) SDTL_TAXEXEMPT2TOT, Sum(SDTL_TAXEXEMPT3TOT) SDTL_TAXEXEMPT3TOT, Sum(SDTL_TAXEXEMPT4TOT) SDTL_TAXEXEMPT4TOT, Sum(SDTL_TAXONTAX1) SDTL_TAXONTAX1, Sum(SDTL_TAXONTAX2) SDTL_TAXONTAX2, Sum(SDTL_TAXONTAX3) SDTL_TAXONTAX3, Sum(SDTL_QTY * SDTL_UNITCOST) SDTL_TOTALCOST From POS_SALESDTL Where SDTL_STORE = '11' and SDTL_CTRNO = '1101' and SDTL_TRANSNO = 6