Fix Posted Retail Statment for april -june-feb 2020


update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052141'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052142'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052143'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052144'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052145'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052146'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052147'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052148'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052149'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052150'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052151'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052152'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052153'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052154'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052155'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052156'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052157'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052158'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052159'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052160'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052161'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052162'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052163'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052164'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052165'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052119'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052120'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052121'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052122'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052123'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052124'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052125'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052126'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052127'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052128'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052129'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052130'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052131'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052132'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052133'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052134'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052135'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052136'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052137'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052138'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052139'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102290420052140'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052099'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052100'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052101'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052102'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052103'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052104'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052105'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052106'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052107'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052108'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052109'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052110'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052111'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052112'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052113'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052114'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052115'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052116'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052117'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102280420052118'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052082'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052083'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052084'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052085'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052086'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052087'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052088'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052089'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052090'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052091'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052092'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052093'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052094'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052095'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052096'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052097'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102270420052098'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901012704202001231'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052071'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052072'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052073'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052074'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052075'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052076'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052077'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052078'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052079'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052080'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102260420052081'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052062'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052063'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052064'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052065'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052066'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052067'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052068'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052069'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102250420052070'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052048'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052049'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052050'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052051'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052052'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052053'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052054'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052055'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052056'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052057'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052058'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901012404202001230'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052059'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052060'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102240420052061'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052033'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052034'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052035'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052036'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052037'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052038'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052039'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052040'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052041'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052042'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052043'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052044'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052045'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052046'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102230420052047'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052017'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052018'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052019'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052020'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052021'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052022'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052023'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901012204202001229'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052024'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052025'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052026'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052027'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052028'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052029'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052030'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052031'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102220420052032'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052002'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052003'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052004'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052005'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052006'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052007'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052008'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052009'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052010'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052011'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052012'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052013'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052014'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052015'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102210420052016'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051983'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051984'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051985'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051986'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051987'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051988'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051989'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051990'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051991'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051992'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051993'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051994'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051995'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051996'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051997'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051998'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420051999'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420052000'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102200420052001'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051968'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051969'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051970'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051971'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051972'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051973'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901011904202001228'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051974'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051975'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051976'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051977'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051978'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051979'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051980'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051981'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102190420051982'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051956'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051957'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051958'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051959'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901011804202001227'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051960'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051961'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051962'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051963'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051964'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051965'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051966'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102180420051967'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051948'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051949'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051950'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051951'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051952'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051953'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051954'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102170420051955'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901011604202001225'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051932'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051933'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051934'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051935'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051936'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051937'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051938'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051939'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051940'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051941'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051942'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051943'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051944'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051945'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901011604202001226'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051946'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102160420051947'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051913'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051914'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051915'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051916'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051917'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051918'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051919'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051920'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051921'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051922'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051923'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051924'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051925'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051926'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051927'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051928'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051929'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051930'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102150420051931'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102130420051907'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102130420051908'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901011304202001224'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102130420051909'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102130420051910'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102130420051911'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102130420051912'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051895'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051896'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051897'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051898'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051899'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051900'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051901'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051902'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051903'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051904'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '901011204202001223'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051905'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102120420051906'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051885'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051886'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051887'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051888'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051889'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051890'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051891'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051892'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051893'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102110420051894'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102100420051879'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102100420051880'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102100420051881'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102100420051882'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102100420051883'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102100420051884'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051870'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051871'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051872'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051873'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051874'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051875'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051876'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051877'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102090420051878'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102080420051863'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102080420051864'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102080420051865'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102080420051866'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102080420051867'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102080420051868'
update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102080420051869'


------------

update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052141'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052142'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052143'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052144'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052145'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052146'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052147'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052148'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052149'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052150'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052151'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052152'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052153'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052154'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052155'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052156'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052157'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052158'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052159'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052160'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052161'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052162'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052163'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052164'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102300420052165'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052119'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052120'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052121'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052122'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052123'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052124'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052125'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052126'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052127'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052128'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052129'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052130'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052131'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052132'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052133'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052134'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052135'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052136'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052137'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052138'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052139'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102290420052140'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052099'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052100'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052101'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052102'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052103'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052104'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052105'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052106'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052107'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052108'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052109'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052110'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052111'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052112'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052113'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052114'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052115'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052116'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052117'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102280420052118'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052082'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052083'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052084'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052085'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052086'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052087'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052088'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052089'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052090'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052091'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052092'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052093'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052094'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052095'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052096'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052097'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102270420052098'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901012704202001231'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052071'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052072'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052073'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052074'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052075'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052076'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052077'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052078'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052079'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052080'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102260420052081'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052062'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052063'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052064'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052065'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052066'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052067'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052068'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052069'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102250420052070'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052048'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052049'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052050'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052051'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052052'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052053'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052054'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052055'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052056'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052057'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052058'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901012404202001230'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052059'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052060'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102240420052061'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052033'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052034'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052035'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052036'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052037'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052038'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052039'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052040'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052041'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052042'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052043'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052044'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052045'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052046'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102230420052047'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052017'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052018'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052019'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052020'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052021'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052022'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052023'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901012204202001229'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052024'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052025'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052026'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052027'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052028'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052029'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052030'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052031'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102220420052032'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052002'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052003'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052004'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052005'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052006'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052007'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052008'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052009'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052010'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052011'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052012'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052013'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052014'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052015'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102210420052016'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051983'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051984'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051985'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051986'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051987'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051988'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051989'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051990'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051991'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051992'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051993'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051994'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051995'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051996'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051997'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051998'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420051999'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420052000'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102200420052001'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051968'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051969'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051970'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051971'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051972'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051973'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901011904202001228'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051974'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051975'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051976'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051977'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051978'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051979'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051980'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051981'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102190420051982'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051956'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051957'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051958'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051959'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901011804202001227'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051960'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051961'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051962'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051963'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051964'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051965'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051966'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102180420051967'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051948'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051949'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051950'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051951'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051952'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051953'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051954'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102170420051955'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901011604202001225'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051932'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051933'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051934'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051935'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051936'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051937'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051938'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051939'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051940'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051941'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051942'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051943'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051944'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051945'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901011604202001226'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051946'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102160420051947'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051913'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051914'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051915'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051916'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051917'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051918'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051919'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051920'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051921'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051922'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051923'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051924'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051925'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051926'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051927'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051928'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051929'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051930'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102150420051931'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102130420051907'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102130420051908'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901011304202001224'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102130420051909'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102130420051910'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102130420051911'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102130420051912'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051895'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051896'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051897'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051898'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051899'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051900'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051901'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051902'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051903'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051904'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='901011204202001223'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051905'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102120420051906'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051885'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051886'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051887'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051888'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051889'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051890'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051891'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051892'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051893'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102110420051894'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102100420051879'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102100420051880'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102100420051881'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102100420051882'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102100420051883'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102100420051884'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051870'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051871'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051872'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051873'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051874'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051875'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051876'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051877'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102090420051878'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102080420051863'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102080420051864'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102080420051865'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102080420051866'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102080420051867'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102080420051868'
update RetailTransactionTable SET STATEMENTID= '' where RECEIPTID ='010102080420051869'


---------

UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052141'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052142'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052143'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052144'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052145'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052146'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052147'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052148'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052149'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052150'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052151'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052152'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052153'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052154'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052155'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052156'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052157'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052158'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052159'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052160'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052161'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052162'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052163'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052164'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102300420052165'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052119'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052120'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052121'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052122'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052123'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052124'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052125'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052126'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052127'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052128'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052129'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052130'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052131'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052132'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052133'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052134'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052135'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052136'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052137'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052138'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052139'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102290420052140'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052099'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052100'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052101'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052102'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052103'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052104'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052105'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052106'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052107'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052108'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052109'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052110'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052111'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052112'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052113'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052114'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052115'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052116'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052117'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102280420052118'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052082'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052083'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052084'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052085'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052086'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052087'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052088'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052089'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052090'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052091'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052092'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052093'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052094'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052095'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052096'
UPDATE RETAILTRANSACTIONSALESTRANS SET STATEMENTID ='' where RECEIPTID = '010102270420052097'
UPDATE RETAILTRANSA

Did you find this article useful?