- update shipment set tax =7.19 saleprice =81 where shipmentid ='18108697617180830';
- update shipment set tax =0.8 saleprice =9 where shipmentid ='18109941494449720';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18128072547231500';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18128563686286050';
- update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18128586188200180';
- update shipment set tax =31.15 saleprice =351 where shipmentid ='18128589788442690';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18128596988991360';
- update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18128600889174540';
- update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18128614390331230';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18128636292115260';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18128637492224400';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18128640192442690';
- update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18128645892899700';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18128650393126630';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18128700497495910';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18128700797519120';
- update shipment set tax =40.58 saleprice =457.2 where shipmentid ='18128701397557450';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18128715198296640';
- update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18128726899246580';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18128751401332600';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18128755901638810';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18128800905297340';
- update shipment set tax =27.8 saleprice =313.2 where shipmentid ='18128803905561270';
- update shipment set tax =7.99 saleprice =90 where shipmentid ='18128828807784370';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18128831808041070';
- update shipment set tax =23 saleprice =259.2 where shipmentid ='18128833308121390';
- update shipment set tax =11.98 saleprice =135 where shipmentid ='18128866311223870';
- update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18128882212649270';
- update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18128886112908050';
- update shipment set tax =59.11 saleprice =666 where shipmentid ='18128963518545690';
- update shipment set tax =19.01 saleprice =214.2 where shipmentid ='18129039725047140';
- update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18129045125541110';
- update shipment set tax =15.98 saleprice =180 where shipmentid ='18129061926923870';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18129062526989910';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18129082028631630';
- update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18129087129270300';
- update shipment set tax =0 saleprice =52.2 where shipmentid ='18129089829481940';
- update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18129100630080860';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18129107830746380';
- update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18129121331671910';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129122531898920';
- update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18129126732196200';
- update shipment set tax =0 saleprice =79.2 where shipmentid ='18129130032481470';
- update shipment set tax =20.61 saleprice =232.2 where shipmentid ='18129133632806880';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18129139333435900';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18129190037585330';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18129243143196640';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18129273146223450';
- update shipment set tax =52.56 saleprice =592.2 where shipmentid ='18129274046234040';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129282447124280';
- update shipment set tax =44.01 saleprice =495.9 where shipmentid ='18129288447931920';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129292348438200';
- update shipment set tax =4.39 saleprice =49.5 where shipmentid ='18129333452056420';
- update shipment set tax =0 saleprice =22.5 where shipmentid ='18129355054367720';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129360755094790';
- update shipment set tax =0.96 saleprice =10.8 where shipmentid ='18129374556291670';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18129380556799010';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18129384157171060';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18129385657351970';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18129388357562760';
- update shipment set tax =0 saleprice =67.5 where shipmentid ='18129467865189380';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129568973964820';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18129597476345780';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129598976436070';
- update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18129653281052010';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18129680883012960';
- update shipment set tax =15.98 saleprice =180 where shipmentid ='18129681783047450';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129682983145440';
- update shipment set tax =5.43 saleprice =61.2 where shipmentid ='18129731587541910';
- update shipment set tax =17.17 saleprice =193.5 where shipmentid ='18129732187609110';
- update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18129740288428630';
- update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18129756489751300';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18129760390048110';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18129764290313440';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18129837195969110';
- update shipment set tax =0 saleprice =48.6 where shipmentid ='18129846496876760';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18129851297375930';
- update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18129865398402540';
- update shipment set tax =39.78 saleprice =448.2 where shipmentid ='18129986809858100';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129996710945090';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18135302515377410';
- update shipment set tax =0 saleprice =43.2 where shipmentid ='18135319316600090';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18135327717169160';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18135342118286090';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18135345418472000';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18135349318807200';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18135350818900990';
- update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18135384421627440';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18135442325717810';
- update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18135441125705130';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18135466626977330';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135479527846200';
- update shipment set tax =0 saleprice =79.2 where shipmentid ='18135483728205990';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18135490928680320';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18135547933296710';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135563234408360';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18135576135335950';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18135580335782650';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18135591736968700';
- update shipment set tax =0 saleprice =97.2 where shipmentid ='18135605537897730';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18135612438287810';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18135627139349280';
- update shipment set tax =10.14 saleprice =114.3 where shipmentid ='18135675742207180';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18135694343462870';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18135697643799920';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135759747843070';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18135797850870180';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18135804151504330';
- update shipment set tax =19.57 saleprice =220.5 where shipmentid ='18135835653414520';
- update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18135870155675190';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18135874956033280';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135883356729370';
- update shipment set tax =0 saleprice =32.4 where shipmentid ='18135889657191070';
- update shipment set tax =27.8 saleprice =313.2 where shipmentid ='18135890557238440';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135897458053830';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135904058329170';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18135909758822390';
- update shipment set tax =15.98 saleprice =180 where shipmentid ='18135931060851950';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135939161670820';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18135963763709910';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136005167041560';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18136009667441650';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18136041470282070';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18136041770297890';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18136045370664810';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18136047470938120';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18136071772887550';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18136258084718160';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18136272185783230';
- update shipment set tax =0 saleprice =106.2 where shipmentid ='18136320189270280';
- update shipment set tax =11.98 saleprice =134.99 where shipmentid ='18136379594348210';
- update shipment set tax =0 saleprice =58.5 where shipmentid ='18136392795108510';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18136402995903820';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18136441098494950';
- update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18136473700393170';
- update shipment set tax =0 saleprice =58.5 where shipmentid ='18136495602142090';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136500702408240';
- update shipment set tax =15.98 saleprice =180 where shipmentid ='18136509702932040';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136515103242330';
- update shipment set tax =0 saleprice =43.2 where shipmentid ='18136570307390810';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18136580208249030';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18136676216308050';
- update shipment set tax =0 saleprice =97.2 where shipmentid ='18136699318177830';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18136700818243120';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18136710119284750';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18136720020051620';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18136722720379200';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18136728720729920';
- update shipment set tax =11.98 saleprice =135 where shipmentid ='18136730820859080';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18136740121525580';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136745521945880';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18136751222417740';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18136761123463710';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18136763223526750';
- update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18136782725118340';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18136783325169740';
- update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18136828929083160';
- update shipment set tax =0 saleprice =59.4 where shipmentid ='18136834929498180';
- update shipment set tax =0 saleprice =87.3 where shipmentid ='18136836429668400';
- update shipment set tax =33.39 saleprice =376.2 where shipmentid ='18136843930225020';
- update shipment set tax =36.58 saleprice =412.2 where shipmentid ='18136845730624020';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18136848730917200';
- update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18136857131920310';
- update shipment set tax =19.17 saleprice =216 where shipmentid ='18136862232411240';
- update shipment set tax =0 saleprice =43.2 where shipmentid ='18136862532425360';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18136865832619190';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18136911136285360';
- update shipment set tax =0 saleprice =52.2 where shipmentid ='18136916836723690';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18136924637518020';
- update shipment set tax =13.1 saleprice =147.6 where shipmentid ='18137001442765690';
- update shipment set tax =4.63 saleprice =52.2 where shipmentid ='18137102848543790';
- update shipment set tax =1.2 saleprice =13.5 where shipmentid ='18137106448741150';
- update shipment set tax =2 saleprice =22.5 where shipmentid ='18137109148892630';
- update shipment set tax =0 saleprice =67.5 where shipmentid ='18137241459997910';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18137246260462560';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18137261262008120';
- update shipment set tax =0 saleprice =36 where shipmentid ='18137359370031820';
- update shipment set tax =11.58 saleprice =130.5 where shipmentid ='18137421474654790';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18137506380767690';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18137519582114770';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18137592487453150';
- update shipment set tax =0 saleprice =106.2 where shipmentid ='18137602388048500';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18137612588753420';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18137650690957500';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18137650991002560';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18137668392417730';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18137693294106690';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18137713095361230';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18137817403534980';
- update shipment set tax =11.18 saleprice =126 where shipmentid ='18137832404609840';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18137890309257190';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18137917611222090';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18137924511832450';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18137927512165390';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18137929612378470';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18137933512567570';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138012719523260';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18138028020209140';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18138037020738300';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18138087125765540';
- update shipment set tax =0 saleprice =43.2 where shipmentid ='18138237440413750';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18138240740727030';
- update shipment set tax =1.6 saleprice =18 where shipmentid ='18138245541167500';
- update shipment set tax =1.6 saleprice =18 where shipmentid ='18138247341365180';
- update shipment set tax =23 saleprice =259.2 where shipmentid ='18138287545609350';
- update shipment set tax =0 saleprice =67.5 where shipmentid ='18138293846013160';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18138297446321070';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138333450309340';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138334050334190';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138337350568440';
- update shipment set tax =10.3 saleprice =116.1 where shipmentid ='18138373954589340';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18138376354830420';
- update shipment set tax =7.19 saleprice =81 where shipmentid ='18138377254915080';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18138381155169010';
- update shipment set tax =33.39 saleprice =376.2 where shipmentid ='18138393756710310';
- update shipment set tax =10.3 saleprice =116.1 where shipmentid ='18138404858011390';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18138406058081820';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18138427060173480';
- update shipment set tax =34.19 saleprice =385.2 where shipmentid ='18138433060778070';
- update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18138447762520290';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18138473865428830';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18138479566122750';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18138480766279850';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18138482266356960';
- update shipment set tax =12.62 saleprice =142.2 where shipmentid ='18138482566370780';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18138484966708090';
- update shipment set tax =23.56 saleprice =265.5 where shipmentid ='18138527271036190';
- update shipment set tax =0 saleprice =89.1 where shipmentid ='18138628081825580';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18138631982041520';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18138632582165930';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18138635282291970';
- update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18138636782416560';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18138646083222230';
- update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18142659160683560';
- update shipment set tax =7.99 saleprice =90 where shipmentid ='18142774370105520';
- update shipment set tax =0 saleprice =72 where shipmentid ='18142857477094170';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18142895880465170';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18143074696137040';
- update shipment set tax =19.01 saleprice =214.2 where shipmentid ='18143102898258520';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18143122999895580';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18143124199927780';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18143130100245410';
- update shipment set tax =0 saleprice =103.5 where shipmentid ='18143137000926460';
- update shipment set tax =9.98 saleprice =112.5 where shipmentid ='18143138201144790';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18143143601561920';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18143152002062300';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18143154102182190';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18143192205272930';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18143194605508140';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143196705726300';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143197005771020';
- update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18143253110966260';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143262712039600';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18143311616432860';
- update shipment set tax =0 saleprice =52.2 where shipmentid ='18143314916810210';
- update shipment set tax =0 saleprice =87.3 where shipmentid ='18143318817128740';
- update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18143332318009880';
- update shipment set tax =14.7 saleprice =165.6 where shipmentid ='18143351219465880';
- update shipment set tax =0 saleprice =87.3 where shipmentid ='18143357820068510';
- update shipment set tax =0 saleprice =52.2 where shipmentid ='18143359920218290';
- update shipment set tax =0 saleprice =87.3 where shipmentid ='18143360820322610';
- update shipment set tax =0 saleprice =59.4 where shipmentid ='18143361420419180';
- update shipment set tax =0 saleprice =59.4 where shipmentid ='18143362920731040';
- update shipment set tax =17.89 saleprice =201.6 where shipmentid ='18143367420983860';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18143388422257890';
- update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18143391422394560';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143416924541140';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18143421424908010';
- update shipment set tax =3.04 saleprice =34.2 where shipmentid ='18143424725198440';
- update shipment set tax =3.04 saleprice =34.2 where shipmentid ='18143425625249180';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18143440626501650';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18143445126788690';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18143459528118750';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18143462528417840';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143472129112730';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18143489530346420';
- update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18143490730469300';
- update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18143498831141100';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143529133215410';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18143532733434590';
- update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18143544134618900';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18143564836436920';
- update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18143578937605930';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18143591538787880';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143614940689800';
- update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18143616740877710';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18143623041236070';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18143623941300120';
- update shipment set tax =0 saleprice =106.2 where shipmentid ='18143633841827830';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143637742204510';
- update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18143642242499200';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18143642842524060';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18143646742823770';
- update shipment set tax =14.7 saleprice =165.6 where shipmentid ='18143663244128980';
- update shipment set tax =28.6 saleprice =322.2 where shipmentid ='18143666844693370';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18143668944884870';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18143685746285480';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18143689946503110';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18143695346786480';
- update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18143702547490600';
- update shipment set tax =20.61 saleprice =232.2 where shipmentid ='18143710947840980';
- update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18143718448331290';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18143741850379760';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18143744550727260';
- update shipment set tax =0 saleprice =106.2 where shipmentid ='18143749050924160';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143756551533590';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18143764952229460';
- update shipment set tax =2 saleprice =22.5 where shipmentid ='18143779353392900';
- update shipment set tax =3.91 saleprice =44.1 where shipmentid ='18143814456336550';
- update shipment set tax =15.18 saleprice =171 where shipmentid ='18143877162040400';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143891563290750';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18143894863411410';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18143901164146670';
- update shipment set tax =23.16 saleprice =261 where shipmentid ='18143937166670650';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143948867780160';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143952468108290';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143965969343060';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143981570682180';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18143991171372750';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18144020573732760';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18144066177427220';
- update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18144073677898220';
- update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18144104280622900';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18144122582079820';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18144170586145520';
- update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18144195488287440';
- update shipment set tax =39.78 saleprice =448.2 where shipmentid ='18144199688694810';
- update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18144207789330630';
- update shipment set tax =35.78 saleprice =403.2 where shipmentid ='18144210789525830';
- update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18144223690704830';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18144226991007040';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18144328699592030';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18144331099900010';
- update shipment set tax =42.89 saleprice =483.3 where shipmentid ='18144348701294190';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18144364302184980';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18144369402412470';
- update shipment set tax =0 saleprice =54 where shipmentid ='18144428507837470';
- update shipment set tax =0 saleprice =48.6 where shipmentid ='18144429107855660';
- update shipment set tax =0 saleprice =72 where shipmentid ='18144432708113730';
- update shipment set tax =0 saleprice =43.2 where shipmentid ='18144435108218890';
- update shipment set tax =0 saleprice =54 where shipmentid ='18144437808539540';
- update shipment set tax =40.58 saleprice =457.2 where shipmentid ='18144619624248790';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18144646626932720';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18144655927695140';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18144675729001490';
- update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18144678129281020';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18144681129557820';
- update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18144686830013660';
- update shipment set tax =3.04 saleprice =34.2 where shipmentid ='18144703331462790';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18144719232484540';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18144723132761260';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18144724332931510';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18144787037844000';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18144964352932480';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18144967953250700';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18144977854029690';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18145168072792590';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18145183974186900';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18145262282079510';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18145353488843340';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18145417394789750';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18145475200612560';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18145478500951120';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18145484201640890';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18145486601844110';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18145521405020670';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18145614413940210';
- update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18145652217693610';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18145754828344060';
- update shipment set tax =0 saleprice =36 where shipmentid ='18145761728907060';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18145828635618860';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18145833736001950';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18145863139511860';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18145894942607700';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18145900042896360';
- update shipment set tax =5.43 saleprice =61.2 where shipmentid ='18145916244040610';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18145929445181000';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18145930645247130';
- update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18145930945332730';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18145933945624390';
- update shipment set tax =0 saleprice =87.3 where shipmentid ='18145935746008250';
- update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18145936946154170';
- update shipment set tax =0 saleprice =52.2 where shipmentid ='18145938446250400';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18145942046817350';
- update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18145947147119280';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18145967249627680';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18146006853600630';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18146026655863540';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18146031156247120';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18146033256466450';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18146034456558640';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18146039557127670';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18146059959224980';
- update shipment set tax =0 saleprice =52.2 where shipmentid ='18146104062757870';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18146728623246450';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18147042756210700';
- update shipment set tax =12.78 saleprice =144 where shipmentid ='18147079060689340';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18147125865733480';
- update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18147264781190360';
- update shipment set tax =19.01 saleprice =214.2 where shipmentid ='18147269281470560';
- update shipment set tax =13.74 saleprice =154.8 where shipmentid ='18147304385414390';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18150053818819470';
- update shipment set tax =0 saleprice =99 where shipmentid ='18150478652966590';
- update shipment set tax =27.8 saleprice =313.2 where shipmentid ='18150499354707720';
- update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18150505955102820';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18150582461045560';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18150585161222360';
- update shipment set tax =0 saleprice =43.2 where shipmentid ='18150631664841500';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18150647565939480';
- update shipment set tax =5.43 saleprice =61.2 where shipmentid ='18150662267305840';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18150711470967700';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18150715071244070';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18150720771596690';
- update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18150734272587990';
- update shipment set tax =2 saleprice =22.5 where shipmentid ='18150743873426790';
- update shipment set tax =0 saleprice =106.2 where shipmentid ='18150747473840520';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18150777476360670';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18150890885122910';
- update shipment set tax =3.91 saleprice =44.1 where shipmentid ='18150891485211590';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18150893885382300';
- update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18150894485437190';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18150910686501230';
- update shipment set tax =17.97 saleprice =202.5 where shipmentid ='18150914886901610';
- update shipment set tax =20.61 saleprice =232.2 where shipmentid ='18150936188226920';
- update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18150939188474800';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18150940088546260';
- update shipment set tax =0 saleprice =87.3 where shipmentid ='18150952089250750';
- update shipment set tax =0 saleprice =54 where shipmentid ='18150960789854420';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18150975191004560';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18151006393382050';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18151046296633280';
- update shipment set tax =15.58 saleprice =175.5 where shipmentid ='18151051397042870';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18151057697626580';
- update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18151087699898400';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18151105001375870';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18151107401581980';
- update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18151110101751820';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18151146404331050';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18151148504545450';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18151187807342610';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18151191707623220';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18151195007923610';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18151276914279200';
- update shipment set tax =3.51 saleprice =39.6 where shipmentid ='18151338118368390';
- update shipment set tax =3.67 saleprice =41.4 where shipmentid ='18151361820243100';
- update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18151366920697480';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18151372621062470';
- update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18151380421503080';
- update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18151475229006830';
- update shipment set tax =27.16 saleprice =306 where shipmentid ='18151543333594690';
- update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18151554134287260';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18151556834456620';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18151561634695140';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18151564334883660';
- update shipment set tax =4.79 saleprice =54 where shipmentid ='18151572435478840';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18151613238386300';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18151681943119320';
- update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18151683443250980';
- update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18151686743499070';
- update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18151691243725240';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18151692143762610';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18151693943858970';
- update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18151708344577290';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18151743147397490';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18151808852781910';
- update shipment set tax =0 saleprice =34.2 where shipmentid ='18151850855547940';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18151896458340340';
- update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18151898258464980';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18152004466008520';
- update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18152006866123690';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18152068670073020';
- update shipment set tax =2 saleprice =22.5 where shipmentid ='18152079170773760';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18152092371606700';
- update shipment set tax =1.6 saleprice =18 where shipmentid ='18152125674001770';
- update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18152372591018740';
- update shipment set tax =0 saleprice =74.7 where shipmentid ='18152380991625270';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18152394192612940';
- update shipment set tax =10.14 saleprice =114.3 where shipmentid ='18152397192809040';
- update shipment set tax =4.23 saleprice =47.7 where shipmentid ='18152405893889800';
- update shipment set tax =3.91 saleprice =44.1 where shipmentid ='18152414594891510';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18152486599517200';
- update shipment set tax =11.18 saleprice =126 where shipmentid ='18152586407330050';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18152633210817860';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18152646111831100';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18152652712126020';
- update shipment set tax =19.57 saleprice =220.5 where shipmentid ='18152701015518540';
- update shipment set tax =11.98 saleprice =134.99 where shipmentid ='18152749618499170';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18152768819839730';
- update shipment set tax =0 saleprice =52.2 where shipmentid ='18152781720719750';
- update shipment set tax =0 saleprice =103.5 where shipmentid ='18152785020960690';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18152786221202780';
- update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18152809022875330';
- update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18152824323898090';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18152830624254720';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18152855225890180';
- update shipment set tax =11.58 saleprice =130.5 where shipmentid ='18152864226411290';
- update shipment set tax =11.58 saleprice =130.5 where shipmentid ='18152896328687890';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18152902028960010';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18152908629492570';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18152911629784460';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18152917630116120';
- update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18152921230445460';
- update shipment set tax =0 saleprice =43.2 where shipmentid ='18152925730617690';
- update shipment set tax =2.64 saleprice =29.7 where shipmentid ='18152927830763590';
- update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18152937731449860';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18152948832214960';
- update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18152989034844280';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18153006436124010';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18153011836501470';
- update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18153015436792570';
- update shipment set tax =44.01 saleprice =495.9 where shipmentid ='18153054439551010';
- update shipment set tax =4.79 saleprice =54 where shipmentid ='18153060439966110';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18153096742075680';
- update shipment set tax =0 saleprice =88.2 where shipmentid ='18153100042334010';
- update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18153114443196320';
- update shipment set tax =12.62 saleprice =142.2 where shipmentid ='18153116843352780';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18153120743568020';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18153135144669620';
- update shipment set tax =2.4 saleprice =27 where shipmentid ='18153136644776090';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18153149245517180';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18153178347745360';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18153305856618880';
- update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18153307956886930';
- update shipment set tax =3.67 saleprice =41.4 where shipmentid ='18153336758620480';
- update shipment set tax =11.02 saleprice =124.2 where shipmentid ='18153338558766370';
- update shipment set tax =0 saleprice =48.6 where shipmentid ='18153350859579150';
- update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18153453466298010';
- update shipment set tax =2 saleprice =22.5 where shipmentid ='18153500569695130';
- update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18153519471361060';
- update shipment set tax =0 saleprice =106.2 where shipmentid ='18153551274141450';
- update shipment set tax =42.89 saleprice =483.3 where shipmentid ='18153564475045720';
- update shipment set tax =41.93 saleprice =472.5 where shipmentid ='18153741487741540';
- update shipment set tax =1.2 saleprice =13.5 where shipmentid ='18153774790497640';
- update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18153788591450620';
- update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18153804192548560';
- update shipment set tax =16.37 saleprice =184.5 where shipmentid ='18153845895537650';
- update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18153873798330220';
- update shipment set tax =3.2 saleprice =36 where shipmentid ='18153874398344320';
- update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18153939403487920';
- update shipment set tax =0 saleprice =61.2 where shipmentid ='18153968205763750';
- update shipment set tax =0 saleprice =70.2 where shipmentid ='18153972105991650';
- update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18153989807607100';
- update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18154001808604540';
- update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18154003608784400';
- update shipment set tax =2.64 saleprice =29.7 where shipmentid ='18154080414006130';
- update shipment set tax =119.41 saleprice =1345.5 where shipmentid ='18154103216004780';
[text] BOLT update queries
Viewer
Editor
You can edit this paste and save as new:
File Description
- BOLT update queries
- Paste Code
- 30 Sep-2022
- 45.75 Kb
You can Share it: