* 6/11/2012 3:51:37 PM, 1, KELVIN ONG CHEONG KEONG *
Update Or Insert Into POS_SALES (SALES_STORE, SALES_CTRNO, SALES_TRANSNO, SALES_OPERID, SALES_DATETIME, SALES_RCPTNO, SALES_LABELNO, SALES_CLOSEDATE, SALES_QTY, SALES_GROSS, SALES_SUMDISCBYPCN, SALES_SUMDISCBYMNY, SALES_NETSALES, SALES_STATUS, SALES_TAXAMT, SALES_SUBTOTALDISCPCN, SALES_SUBTOTALDISCMNY, SALES_SUBTOTALDISCPCN2, SALES_SUBTOTALDISCMNY2, SALES_TOTALDISCMNY, SALES_PAID, SALES_EXPORT, SALES_SUSPENDDATE, SALES_BILLDATE, SALES_PAIDDATE, SALES_DEPAMT, SALES_DEPCHANGE, SALES_COMPLETE, SALES_PRINTED, SALES_SHIFT, SALES_REMARK1, SALES_REMARK2, SALES_REMARK3, SALES_RCPT, SALES_TAX1, SALES_TAX2, SALES_TAX3, SALES_TAX4, SALES_CUSTOMERID, SALES_PRICELVL, SALES_PRICE_SHIFT, SALES_DISCOUNTABLEAMT, SALES_STR_STORE, SALES_STR_CTRNO, SALES_STR_TRANSNO, SALES_STR_OPERID, SALES_STR_DATETIME, SALES_STR_RCPTNO, SALES_DISCCODE, SALES_DISCDESC, SALES_SUBDISCTYPE, SALES_DISCCODE2, SALES_DISCDESC2, SALES_SUBDISCTYPE2, SALES_UPDATE, SALES_ONLINEBUFF, SALES_ROUND_ADJ, SALES_FUNCSTATUS, SALES_TAXABLEAMT1, SALES_TAXABLEAMT2, SALES_TAXABLEAMT3, SALES_TAXABLEAMT4, SALES_TAX1PCN, SALES_TAX2PCN, SALES_TAX3PCN, SALES_TAX4PCN, SALES_TAXEXEMPT1, SALES_TAXEXEMPT2, SALES_TAXEXEMPT3, SALES_TAXEXEMPT4, SALES_TAXEXEMPT1TOT, SALES_TAXEXEMPT2TOT, SALES_TAXEXEMPT3TOT, SALES_TAXEXEMPT4TOT, SALES_TAX1STATUS, SALES_TAX2STATUS, SALES_TAX3STATUS, SALES_TAX4STATUS, SALES_TAXABLE1CTOT, SALES_TAXABLE2CTOT, SALES_TAXABLE3CTOT, SALES_TAXABLE4CTOT, SALES_TAXONTAX1, SALES_TAXONTAX2, SALES_TAXONTAX3, SALES_SURVEY1, SALES_SURVEY2, SALES_SURVEY3, SALES_SURVEY4, SALES_SURVEY5, SALES_SALESPERSON, SALES_PREMCODE, SALES_PREMDESC, SALES_PREMTYPE, SALES_PREMCODE2, SALES_PREMDESC2, SALES_PREMTYPE2, SALES_TOT_COST, SALES_CLOSED, SALES_IMPORT, SALES_SP_COMMISSION, SALES_MYEG_TRANSID, SALES_MYEG_SALES_REGID, SALES_MYEG_TVOID_REGID, SALES_MEMBERID, SALES_MEMBERCARDID, SALES_TABLE, SALES_PAX, SALES_TABLE_TYPE) Values ('11', '1101', 6, '1', '06/11/2012 15:51:25', 6, 6, '06/11/2012 00:00:00', 2 , 13, 0, 0, 14.95, 'NS', 1.95, 0, 0, 0, 0, 0, 0, 'F', '06/11/2012 15:51:25', '06/11/2012 15:51:25', '06/11/2012 15:51:25', 0, 0, 'F', 'F', '', '', '', '', '', 0.65, 1.3, 0, 0, '', 'P1', 'S1', 13, '', '', 0, '1', '06/11/2012 15:51:25', 0, '', '', '', '', '', '', 'F', '', -1.77635683940025E-15, '', 13, 13, 0, 0, 5, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '3500200000', '3500200000', '0000', '0000', 13, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', 6.5, 'F', 'F', 0, '', '', '', '', '', '8', 1, '')


