* 6/11/2012 3:51:36 PM, 1, KELVIN ONG CHEONG KEONG *
INSERT INTO POS_SALESDTL (SDTL_STORE, SDTL_CTRNO, SDTL_TRANSNO, SDTL_SEQNO, SDTL_STOCK_CODE, SDTL_BARCODE, SDTL_SHORTDESC, SDTL_QTY, SDTL_STATUS, SDTL_SELLPRICE, SDTL_DISCBYPCN, SDTL_DISCBYMNY, SDTL_DISCBYPCN2, SDTL_DISCBYMNY2, SDTL_DISCAMT, SDTL_PREMIUM, SDTL_NETPRICE, SDTL_DATETIME, SDTL_CLOSEDATE, SDTL_PROMOTERID, SDTL_COMMTYPE, SDTL_COMMISSION, SDTL_UOM, SDTL_CHANGEPRICE, SDTL_CHANGEPRC, SDTL_ITEMTYPE, SDTL_MIXMATCH, SDTL_UNITCOST, SDTL_MIN_PRICE, SDTL_DISCOUNTABLE, SDTL_UPDATE, SDTL_POINT, SDTL_TOTPOINT, SDTL_DISCSUBTOTAL, SDTL_DISCSUBTOTAL2, SDTL_DISCSUBMNY, SDTL_POINT_COLLECT, SDTL_TOT_POINT_COLLECT, SDTL_REMARK, SDTL_WITHPURCHASE, SDTL_SALES_OPERID, SDTL_SALES_DATETIME, SDTL_SALES_RCPTNO, SDTL_SALES_SUSPENDDATE, SDTL_SALES_SHIFT, SDTL_SALES_CUSTOMERID, SDTL_SALES_PRICELVL, SDTL_SALES_PRICE_SHIFT, SDTL_STK_CS, SDTL_STK_GROUP, SDTL_STK_DEPARTMENT, SDTL_STK_SUB_DEPARTMENT, SDTL_STK_CATEGORY, SDTL_STK_BRAND, SDTL_STK_COLOR, SDTL_STK_SIZE, SDTL_STK_SN, SDTL_DISCTYPE, SDTL_DISCCODE, SDTL_DISCDESC, SDTL_DISCTYPE2, SDTL_DISCCODE2, SDTL_DISCDESC2, SDTL_SALES_DISCCODE, SDTL_SALES_DISCDESC, SDTL_SALES_SUBDISCTYPE, SDTL_SALES_DISCCODE2, SDTL_SALES_DISCDESC2, SDTL_SALES_SUBDISCTYPE2, SDTL_FUNCSTATUS, SDTL_STK_STATUS, SDTL_DTLLINK, SDTL_ALTBARCODE, SDTL_LRDATE, SDTL_STATUSDESC, SDTL_TAXABLEAMT1, SDTL_TAXABLEAMT2, SDTL_TAXABLEAMT3, SDTL_TAXABLEAMT4, SDTL_TAX1PCN, SDTL_TAX2PCN, SDTL_TAX3PCN, SDTL_TAX4PCN, SDTL_TAXEXEMPT1, SDTL_TAXEXEMPT2, SDTL_TAXEXEMPT3, SDTL_TAXEXEMPT4, SDTL_TAXEXEMPT1TOT, SDTL_TAXEXEMPT2TOT, SDTL_TAXEXEMPT3TOT, SDTL_TAXEXEMPT4TOT, SDTL_TAX1STATUS, SDTL_TAX2STATUS, SDTL_TAX3STATUS, SDTL_TAX4STATUS, SDTL_TAXSYMBOL, SDTL_TAXONTAX1, SDTL_TAXONTAX2, SDTL_TAXONTAX3, SDTL_STK_SUPPLIER, SDTL_SURVEY1, SDTL_SURVEY2, SDTL_SURVEY3, SDTL_SURVEY4, SDTL_SURVEY5, SDTL_CONS_FLAG, SDTL_CONS_RATE, SDTL_STOCK_ID, SDTL_SALESPERSON, SDTL_SP_COMMTYPE, SDTL_SP_COMMISSION, SDTL_CLOSED, SDTL_IMPORT, SDTL_CONDMIN, SDTL_CONDMAX, SDTL_CONDLINK, SDTL_LINKDTL, SDTL_BATCH, SDTL_SHORTDESC2, SDTL_COMMISSION_AMT, SDTL_SP_COMMISSION_AMT, SDTL_OPERID, SDTL_SALES_MEMBERID, SDTL_SALES_MEMBERCARDID, SDTL_SEQNO_CANCEL, SDTL_STK_LABEL, SDTL_CONDIMENT) VALUES ('11', '1101', 6, 2, ':', ':', ' :BLACK PEPPER', 1, 'NS', 0, 0, 0, 0, 0, 0, 0, 0, '06/11/2012 15:51:36', '06/11/2012 00:00:00', '', 'P', 10, '', 'F', 0, 'CD', 'F', 0, 0, 'T', 'F', 0, 0, 0, 0, 0, 0, 0, '', '', '1', '06/11/2012 15:51:25', 6, '06/11/2012 15:51:36', '', '', 'P1', 'S1', '', '1', '11', '', '1', 'A', '', '', 'F', '', '', '', '', '', '', '', '', '', '', '', '', '0000001000100000000000000000000000000000', '', '11-1101-0000000006-000002', '', '06/11/2012 15:51:36', '', 0, 0, 0, 0, 5, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '3500200000', '3500200000', '0000', '0000', 'T12', 0, 0, 0, 'A0001', 0, 0, 0, 0, 0, 'F', 0, 'A2', '', 'P', 10, 'F', 'F', 1, 2, '1', '', 0, ' :BLACK PEPPER', 0, 0, '1', '', '', 0, 'T', '') 


