[text] BOLT update queries

Viewer

copydownloadembedprintName: BOLT update queries
  1.  
  2. update shipment set tax =7.19 saleprice =81 where shipmentid ='18108697617180830';
  3. update shipment set tax =0.8 saleprice =9 where shipmentid ='18109941494449720';
  4. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18128072547231500';
  5. update shipment set tax =0 saleprice =61.2 where shipmentid ='18128563686286050';
  6. update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18128586188200180';
  7. update shipment set tax =31.15 saleprice =351 where shipmentid ='18128589788442690';
  8. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18128596988991360';
  9. update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18128600889174540';
  10. update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18128614390331230';
  11. update shipment set tax =12.78 saleprice =144 where shipmentid ='18128636292115260';
  12. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18128637492224400';
  13. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18128640192442690';
  14. update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18128645892899700';
  15. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18128650393126630';
  16. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18128700497495910';
  17. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18128700797519120';
  18. update shipment set tax =40.58 saleprice =457.2 where shipmentid ='18128701397557450';
  19. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18128715198296640';
  20. update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18128726899246580';
  21. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18128751401332600';
  22. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18128755901638810';
  23. update shipment set tax =0 saleprice =88.2 where shipmentid ='18128800905297340';
  24. update shipment set tax =27.8 saleprice =313.2 where shipmentid ='18128803905561270';
  25. update shipment set tax =7.99 saleprice =90 where shipmentid ='18128828807784370';
  26. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18128831808041070';
  27. update shipment set tax =23 saleprice =259.2 where shipmentid ='18128833308121390';
  28. update shipment set tax =11.98 saleprice =135 where shipmentid ='18128866311223870';
  29. update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18128882212649270';
  30. update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18128886112908050';
  31. update shipment set tax =59.11 saleprice =666 where shipmentid ='18128963518545690';
  32. update shipment set tax =19.01 saleprice =214.2 where shipmentid ='18129039725047140';
  33. update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18129045125541110';
  34. update shipment set tax =15.98 saleprice =180 where shipmentid ='18129061926923870';
  35. update shipment set tax =2.4 saleprice =27 where shipmentid ='18129062526989910';
  36. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18129082028631630';
  37. update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18129087129270300';
  38. update shipment set tax =0 saleprice =52.2 where shipmentid ='18129089829481940';
  39. update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18129100630080860';
  40. update shipment set tax =12.78 saleprice =144 where shipmentid ='18129107830746380';
  41. update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18129121331671910';
  42. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129122531898920';
  43. update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18129126732196200';
  44. update shipment set tax =0 saleprice =79.2 where shipmentid ='18129130032481470';
  45. update shipment set tax =20.61 saleprice =232.2 where shipmentid ='18129133632806880';
  46. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18129139333435900';
  47. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18129190037585330';
  48. update shipment set tax =12.78 saleprice =144 where shipmentid ='18129243143196640';
  49. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18129273146223450';
  50. update shipment set tax =52.56 saleprice =592.2 where shipmentid ='18129274046234040';
  51. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129282447124280';
  52. update shipment set tax =44.01 saleprice =495.9 where shipmentid ='18129288447931920';
  53. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129292348438200';
  54. update shipment set tax =4.39 saleprice =49.5 where shipmentid ='18129333452056420';
  55. update shipment set tax =0 saleprice =22.5 where shipmentid ='18129355054367720';
  56. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129360755094790';
  57. update shipment set tax =0.96 saleprice =10.8 where shipmentid ='18129374556291670';
  58. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18129380556799010';
  59. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18129384157171060';
  60. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18129385657351970';
  61. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18129388357562760';
  62. update shipment set tax =0 saleprice =67.5 where shipmentid ='18129467865189380';
  63. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129568973964820';
  64. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18129597476345780';
  65. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129598976436070';
  66. update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18129653281052010';
  67. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18129680883012960';
  68. update shipment set tax =15.98 saleprice =180 where shipmentid ='18129681783047450';
  69. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18129682983145440';
  70. update shipment set tax =5.43 saleprice =61.2 where shipmentid ='18129731587541910';
  71. update shipment set tax =17.17 saleprice =193.5 where shipmentid ='18129732187609110';
  72. update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18129740288428630';
  73. update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18129756489751300';
  74. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18129760390048110';
  75. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18129764290313440';
  76. update shipment set tax =0 saleprice =88.2 where shipmentid ='18129837195969110';
  77. update shipment set tax =0 saleprice =48.6 where shipmentid ='18129846496876760';
  78. update shipment set tax =12.78 saleprice =144 where shipmentid ='18129851297375930';
  79. update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18129865398402540';
  80. update shipment set tax =39.78 saleprice =448.2 where shipmentid ='18129986809858100';
  81. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18129996710945090';
  82. update shipment set tax =3.2 saleprice =36 where shipmentid ='18135302515377410';
  83. update shipment set tax =0 saleprice =43.2 where shipmentid ='18135319316600090';
  84. update shipment set tax =3.2 saleprice =36 where shipmentid ='18135327717169160';
  85. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18135342118286090';
  86. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18135345418472000';
  87. update shipment set tax =0 saleprice =88.2 where shipmentid ='18135349318807200';
  88. update shipment set tax =0 saleprice =34.2 where shipmentid ='18135350818900990';
  89. update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18135384421627440';
  90. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18135442325717810';
  91. update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18135441125705130';
  92. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18135466626977330';
  93. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135479527846200';
  94. update shipment set tax =0 saleprice =79.2 where shipmentid ='18135483728205990';
  95. update shipment set tax =0 saleprice =88.2 where shipmentid ='18135490928680320';
  96. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18135547933296710';
  97. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135563234408360';
  98. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18135576135335950';
  99. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18135580335782650';
  100. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18135591736968700';
  101. update shipment set tax =0 saleprice =97.2 where shipmentid ='18135605537897730';
  102. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18135612438287810';
  103. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18135627139349280';
  104. update shipment set tax =10.14 saleprice =114.3 where shipmentid ='18135675742207180';
  105. update shipment set tax =0 saleprice =34.2 where shipmentid ='18135694343462870';
  106. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18135697643799920';
  107. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135759747843070';
  108. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18135797850870180';
  109. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18135804151504330';
  110. update shipment set tax =19.57 saleprice =220.5 where shipmentid ='18135835653414520';
  111. update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18135870155675190';
  112. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18135874956033280';
  113. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135883356729370';
  114. update shipment set tax =0 saleprice =32.4 where shipmentid ='18135889657191070';
  115. update shipment set tax =27.8 saleprice =313.2 where shipmentid ='18135890557238440';
  116. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135897458053830';
  117. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135904058329170';
  118. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18135909758822390';
  119. update shipment set tax =15.98 saleprice =180 where shipmentid ='18135931060851950';
  120. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18135939161670820';
  121. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18135963763709910';
  122. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136005167041560';
  123. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18136009667441650';
  124. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18136041470282070';
  125. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18136041770297890';
  126. update shipment set tax =0 saleprice =34.2 where shipmentid ='18136045370664810';
  127. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18136047470938120';
  128. update shipment set tax =3.2 saleprice =36 where shipmentid ='18136071772887550';
  129. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18136258084718160';
  130. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18136272185783230';
  131. update shipment set tax =0 saleprice =106.2 where shipmentid ='18136320189270280';
  132. update shipment set tax =11.98 saleprice =134.99 where shipmentid ='18136379594348210';
  133. update shipment set tax =0 saleprice =58.5 where shipmentid ='18136392795108510';
  134. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18136402995903820';
  135. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18136441098494950';
  136. update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18136473700393170';
  137. update shipment set tax =0 saleprice =58.5 where shipmentid ='18136495602142090';
  138. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136500702408240';
  139. update shipment set tax =15.98 saleprice =180 where shipmentid ='18136509702932040';
  140. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136515103242330';
  141. update shipment set tax =0 saleprice =43.2 where shipmentid ='18136570307390810';
  142. update shipment set tax =0 saleprice =70.2 where shipmentid ='18136580208249030';
  143. update shipment set tax =12.78 saleprice =144 where shipmentid ='18136676216308050';
  144. update shipment set tax =0 saleprice =97.2 where shipmentid ='18136699318177830';
  145. update shipment set tax =12.78 saleprice =144 where shipmentid ='18136700818243120';
  146. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18136710119284750';
  147. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18136720020051620';
  148. update shipment set tax =0 saleprice =61.2 where shipmentid ='18136722720379200';
  149. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18136728720729920';
  150. update shipment set tax =11.98 saleprice =135 where shipmentid ='18136730820859080';
  151. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18136740121525580';
  152. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18136745521945880';
  153. update shipment set tax =3.2 saleprice =36 where shipmentid ='18136751222417740';
  154. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18136761123463710';
  155. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18136763223526750';
  156. update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18136782725118340';
  157. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18136783325169740';
  158. update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18136828929083160';
  159. update shipment set tax =0 saleprice =59.4 where shipmentid ='18136834929498180';
  160. update shipment set tax =0 saleprice =87.3 where shipmentid ='18136836429668400';
  161. update shipment set tax =33.39 saleprice =376.2 where shipmentid ='18136843930225020';
  162. update shipment set tax =36.58 saleprice =412.2 where shipmentid ='18136845730624020';
  163. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18136848730917200';
  164. update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18136857131920310';
  165. update shipment set tax =19.17 saleprice =216 where shipmentid ='18136862232411240';
  166. update shipment set tax =0 saleprice =43.2 where shipmentid ='18136862532425360';
  167. update shipment set tax =3.2 saleprice =36 where shipmentid ='18136865832619190';
  168. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18136911136285360';
  169. update shipment set tax =0 saleprice =52.2 where shipmentid ='18136916836723690';
  170. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18136924637518020';
  171. update shipment set tax =13.1 saleprice =147.6 where shipmentid ='18137001442765690';
  172. update shipment set tax =4.63 saleprice =52.2 where shipmentid ='18137102848543790';
  173. update shipment set tax =1.2 saleprice =13.5 where shipmentid ='18137106448741150';
  174. update shipment set tax =2 saleprice =22.5 where shipmentid ='18137109148892630';
  175. update shipment set tax =0 saleprice =67.5 where shipmentid ='18137241459997910';
  176. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18137246260462560';
  177. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18137261262008120';
  178. update shipment set tax =0 saleprice =36 where shipmentid ='18137359370031820';
  179. update shipment set tax =11.58 saleprice =130.5 where shipmentid ='18137421474654790';
  180. update shipment set tax =12.78 saleprice =144 where shipmentid ='18137506380767690';
  181. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18137519582114770';
  182. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18137592487453150';
  183. update shipment set tax =0 saleprice =106.2 where shipmentid ='18137602388048500';
  184. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18137612588753420';
  185. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18137650690957500';
  186. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18137650991002560';
  187. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18137668392417730';
  188. update shipment set tax =0 saleprice =88.2 where shipmentid ='18137693294106690';
  189. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18137713095361230';
  190. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18137817403534980';
  191. update shipment set tax =11.18 saleprice =126 where shipmentid ='18137832404609840';
  192. update shipment set tax =0 saleprice =88.2 where shipmentid ='18137890309257190';
  193. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18137917611222090';
  194. update shipment set tax =2.4 saleprice =27 where shipmentid ='18137924511832450';
  195. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18137927512165390';
  196. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18137929612378470';
  197. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18137933512567570';
  198. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138012719523260';
  199. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18138028020209140';
  200. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18138037020738300';
  201. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18138087125765540';
  202. update shipment set tax =0 saleprice =43.2 where shipmentid ='18138237440413750';
  203. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18138240740727030';
  204. update shipment set tax =1.6 saleprice =18 where shipmentid ='18138245541167500';
  205. update shipment set tax =1.6 saleprice =18 where shipmentid ='18138247341365180';
  206. update shipment set tax =23 saleprice =259.2 where shipmentid ='18138287545609350';
  207. update shipment set tax =0 saleprice =67.5 where shipmentid ='18138293846013160';
  208. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18138297446321070';
  209. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138333450309340';
  210. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138334050334190';
  211. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18138337350568440';
  212. update shipment set tax =10.3 saleprice =116.1 where shipmentid ='18138373954589340';
  213. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18138376354830420';
  214. update shipment set tax =7.19 saleprice =81 where shipmentid ='18138377254915080';
  215. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18138381155169010';
  216. update shipment set tax =33.39 saleprice =376.2 where shipmentid ='18138393756710310';
  217. update shipment set tax =10.3 saleprice =116.1 where shipmentid ='18138404858011390';
  218. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18138406058081820';
  219. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18138427060173480';
  220. update shipment set tax =34.19 saleprice =385.2 where shipmentid ='18138433060778070';
  221. update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18138447762520290';
  222. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18138473865428830';
  223. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18138479566122750';
  224. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18138480766279850';
  225. update shipment set tax =0 saleprice =34.2 where shipmentid ='18138482266356960';
  226. update shipment set tax =12.62 saleprice =142.2 where shipmentid ='18138482566370780';
  227. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18138484966708090';
  228. update shipment set tax =23.56 saleprice =265.5 where shipmentid ='18138527271036190';
  229. update shipment set tax =0 saleprice =89.1 where shipmentid ='18138628081825580';
  230. update shipment set tax =0 saleprice =61.2 where shipmentid ='18138631982041520';
  231. update shipment set tax =3.2 saleprice =36 where shipmentid ='18138632582165930';
  232. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18138635282291970';
  233. update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18138636782416560';
  234. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18138646083222230';
  235. update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18142659160683560';
  236. update shipment set tax =7.99 saleprice =90 where shipmentid ='18142774370105520';
  237. update shipment set tax =0 saleprice =72 where shipmentid ='18142857477094170';
  238. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18142895880465170';
  239. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18143074696137040';
  240. update shipment set tax =19.01 saleprice =214.2 where shipmentid ='18143102898258520';
  241. update shipment set tax =3.2 saleprice =36 where shipmentid ='18143122999895580';
  242. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18143124199927780';
  243. update shipment set tax =0 saleprice =34.2 where shipmentid ='18143130100245410';
  244. update shipment set tax =0 saleprice =103.5 where shipmentid ='18143137000926460';
  245. update shipment set tax =9.98 saleprice =112.5 where shipmentid ='18143138201144790';
  246. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18143143601561920';
  247. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18143152002062300';
  248. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18143154102182190';
  249. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18143192205272930';
  250. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18143194605508140';
  251. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143196705726300';
  252. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143197005771020';
  253. update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18143253110966260';
  254. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143262712039600';
  255. update shipment set tax =0 saleprice =61.2 where shipmentid ='18143311616432860';
  256. update shipment set tax =0 saleprice =52.2 where shipmentid ='18143314916810210';
  257. update shipment set tax =0 saleprice =87.3 where shipmentid ='18143318817128740';
  258. update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18143332318009880';
  259. update shipment set tax =14.7 saleprice =165.6 where shipmentid ='18143351219465880';
  260. update shipment set tax =0 saleprice =87.3 where shipmentid ='18143357820068510';
  261. update shipment set tax =0 saleprice =52.2 where shipmentid ='18143359920218290';
  262. update shipment set tax =0 saleprice =87.3 where shipmentid ='18143360820322610';
  263. update shipment set tax =0 saleprice =59.4 where shipmentid ='18143361420419180';
  264. update shipment set tax =0 saleprice =59.4 where shipmentid ='18143362920731040';
  265. update shipment set tax =17.89 saleprice =201.6 where shipmentid ='18143367420983860';
  266. update shipment set tax =2.4 saleprice =27 where shipmentid ='18143388422257890';
  267. update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18143391422394560';
  268. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143416924541140';
  269. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18143421424908010';
  270. update shipment set tax =3.04 saleprice =34.2 where shipmentid ='18143424725198440';
  271. update shipment set tax =3.04 saleprice =34.2 where shipmentid ='18143425625249180';
  272. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18143440626501650';
  273. update shipment set tax =0 saleprice =88.2 where shipmentid ='18143445126788690';
  274. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18143459528118750';
  275. update shipment set tax =3.2 saleprice =36 where shipmentid ='18143462528417840';
  276. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143472129112730';
  277. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18143489530346420';
  278. update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18143490730469300';
  279. update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18143498831141100';
  280. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143529133215410';
  281. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18143532733434590';
  282. update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18143544134618900';
  283. update shipment set tax =12.78 saleprice =144 where shipmentid ='18143564836436920';
  284. update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18143578937605930';
  285. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18143591538787880';
  286. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143614940689800';
  287. update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18143616740877710';
  288. update shipment set tax =3.2 saleprice =36 where shipmentid ='18143623041236070';
  289. update shipment set tax =2.4 saleprice =27 where shipmentid ='18143623941300120';
  290. update shipment set tax =0 saleprice =106.2 where shipmentid ='18143633841827830';
  291. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18143637742204510';
  292. update shipment set tax =35.54 saleprice =400.5 where shipmentid ='18143642242499200';
  293. update shipment set tax =0 saleprice =88.2 where shipmentid ='18143642842524060';
  294. update shipment set tax =0 saleprice =88.2 where shipmentid ='18143646742823770';
  295. update shipment set tax =14.7 saleprice =165.6 where shipmentid ='18143663244128980';
  296. update shipment set tax =28.6 saleprice =322.2 where shipmentid ='18143666844693370';
  297. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18143668944884870';
  298. update shipment set tax =0 saleprice =70.2 where shipmentid ='18143685746285480';
  299. update shipment set tax =0 saleprice =61.2 where shipmentid ='18143689946503110';
  300. update shipment set tax =0 saleprice =88.2 where shipmentid ='18143695346786480';
  301. update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18143702547490600';
  302. update shipment set tax =20.61 saleprice =232.2 where shipmentid ='18143710947840980';
  303. update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18143718448331290';
  304. update shipment set tax =0 saleprice =34.2 where shipmentid ='18143741850379760';
  305. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18143744550727260';
  306. update shipment set tax =0 saleprice =106.2 where shipmentid ='18143749050924160';
  307. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143756551533590';
  308. update shipment set tax =2.4 saleprice =27 where shipmentid ='18143764952229460';
  309. update shipment set tax =2 saleprice =22.5 where shipmentid ='18143779353392900';
  310. update shipment set tax =3.91 saleprice =44.1 where shipmentid ='18143814456336550';
  311. update shipment set tax =15.18 saleprice =171 where shipmentid ='18143877162040400';
  312. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143891563290750';
  313. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18143894863411410';
  314. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18143901164146670';
  315. update shipment set tax =23.16 saleprice =261 where shipmentid ='18143937166670650';
  316. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143948867780160';
  317. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143952468108290';
  318. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18143965969343060';
  319. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18143981570682180';
  320. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18143991171372750';
  321. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18144020573732760';
  322. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18144066177427220';
  323. update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18144073677898220';
  324. update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18144104280622900';
  325. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18144122582079820';
  326. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18144170586145520';
  327. update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18144195488287440';
  328. update shipment set tax =39.78 saleprice =448.2 where shipmentid ='18144199688694810';
  329. update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18144207789330630';
  330. update shipment set tax =35.78 saleprice =403.2 where shipmentid ='18144210789525830';
  331. update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18144223690704830';
  332. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18144226991007040';
  333. update shipment set tax =0 saleprice =61.2 where shipmentid ='18144328699592030';
  334. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18144331099900010';
  335. update shipment set tax =42.89 saleprice =483.3 where shipmentid ='18144348701294190';
  336. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18144364302184980';
  337. update shipment set tax =0 saleprice =34.2 where shipmentid ='18144369402412470';
  338. update shipment set tax =0 saleprice =54 where shipmentid ='18144428507837470';
  339. update shipment set tax =0 saleprice =48.6 where shipmentid ='18144429107855660';
  340. update shipment set tax =0 saleprice =72 where shipmentid ='18144432708113730';
  341. update shipment set tax =0 saleprice =43.2 where shipmentid ='18144435108218890';
  342. update shipment set tax =0 saleprice =54 where shipmentid ='18144437808539540';
  343. update shipment set tax =40.58 saleprice =457.2 where shipmentid ='18144619624248790';
  344. update shipment set tax =0 saleprice =88.2 where shipmentid ='18144646626932720';
  345. update shipment set tax =0 saleprice =88.2 where shipmentid ='18144655927695140';
  346. update shipment set tax =2.4 saleprice =27 where shipmentid ='18144675729001490';
  347. update shipment set tax =1.76 saleprice =19.8 where shipmentid ='18144678129281020';
  348. update shipment set tax =3.2 saleprice =36 where shipmentid ='18144681129557820';
  349. update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18144686830013660';
  350. update shipment set tax =3.04 saleprice =34.2 where shipmentid ='18144703331462790';
  351. update shipment set tax =3.2 saleprice =36 where shipmentid ='18144719232484540';
  352. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18144723132761260';
  353. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18144724332931510';
  354. update shipment set tax =0 saleprice =70.2 where shipmentid ='18144787037844000';
  355. update shipment set tax =2.4 saleprice =27 where shipmentid ='18144964352932480';
  356. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18144967953250700';
  357. update shipment set tax =2.4 saleprice =27 where shipmentid ='18144977854029690';
  358. update shipment set tax =3.2 saleprice =36 where shipmentid ='18145168072792590';
  359. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18145183974186900';
  360. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18145262282079510';
  361. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18145353488843340';
  362. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18145417394789750';
  363. update shipment set tax =3.2 saleprice =36 where shipmentid ='18145475200612560';
  364. update shipment set tax =0 saleprice =61.2 where shipmentid ='18145478500951120';
  365. update shipment set tax =0 saleprice =70.2 where shipmentid ='18145484201640890';
  366. update shipment set tax =0 saleprice =70.2 where shipmentid ='18145486601844110';
  367. update shipment set tax =0 saleprice =61.2 where shipmentid ='18145521405020670';
  368. update shipment set tax =0 saleprice =34.2 where shipmentid ='18145614413940210';
  369. update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18145652217693610';
  370. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18145754828344060';
  371. update shipment set tax =0 saleprice =36 where shipmentid ='18145761728907060';
  372. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18145828635618860';
  373. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18145833736001950';
  374. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18145863139511860';
  375. update shipment set tax =0 saleprice =70.2 where shipmentid ='18145894942607700';
  376. update shipment set tax =0 saleprice =70.2 where shipmentid ='18145900042896360';
  377. update shipment set tax =5.43 saleprice =61.2 where shipmentid ='18145916244040610';
  378. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18145929445181000';
  379. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18145930645247130';
  380. update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18145930945332730';
  381. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18145933945624390';
  382. update shipment set tax =0 saleprice =87.3 where shipmentid ='18145935746008250';
  383. update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18145936946154170';
  384. update shipment set tax =0 saleprice =52.2 where shipmentid ='18145938446250400';
  385. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18145942046817350';
  386. update shipment set tax =17.41 saleprice =196.2 where shipmentid ='18145947147119280';
  387. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18145967249627680';
  388. update shipment set tax =0 saleprice =34.2 where shipmentid ='18146006853600630';
  389. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18146026655863540';
  390. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18146031156247120';
  391. update shipment set tax =0 saleprice =34.2 where shipmentid ='18146033256466450';
  392. update shipment set tax =0 saleprice =70.2 where shipmentid ='18146034456558640';
  393. update shipment set tax =0 saleprice =34.2 where shipmentid ='18146039557127670';
  394. update shipment set tax =0 saleprice =34.2 where shipmentid ='18146059959224980';
  395. update shipment set tax =0 saleprice =52.2 where shipmentid ='18146104062757870';
  396. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18146728623246450';
  397. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18147042756210700';
  398. update shipment set tax =12.78 saleprice =144 where shipmentid ='18147079060689340';
  399. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18147125865733480';
  400. update shipment set tax =2.32 saleprice =26.1 where shipmentid ='18147264781190360';
  401. update shipment set tax =19.01 saleprice =214.2 where shipmentid ='18147269281470560';
  402. update shipment set tax =13.74 saleprice =154.8 where shipmentid ='18147304385414390';
  403. update shipment set tax =2.4 saleprice =27 where shipmentid ='18150053818819470';
  404. update shipment set tax =0 saleprice =99 where shipmentid ='18150478652966590';
  405. update shipment set tax =27.8 saleprice =313.2 where shipmentid ='18150499354707720';
  406. update shipment set tax =23.8 saleprice =268.2 where shipmentid ='18150505955102820';
  407. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18150582461045560';
  408. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18150585161222360';
  409. update shipment set tax =0 saleprice =43.2 where shipmentid ='18150631664841500';
  410. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18150647565939480';
  411. update shipment set tax =5.43 saleprice =61.2 where shipmentid ='18150662267305840';
  412. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18150711470967700';
  413. update shipment set tax =0 saleprice =61.2 where shipmentid ='18150715071244070';
  414. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18150720771596690';
  415. update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18150734272587990';
  416. update shipment set tax =2 saleprice =22.5 where shipmentid ='18150743873426790';
  417. update shipment set tax =0 saleprice =106.2 where shipmentid ='18150747473840520';
  418. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18150777476360670';
  419. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18150890885122910';
  420. update shipment set tax =3.91 saleprice =44.1 where shipmentid ='18150891485211590';
  421. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18150893885382300';
  422. update shipment set tax =2.24 saleprice =25.2 where shipmentid ='18150894485437190';
  423. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18150910686501230';
  424. update shipment set tax =17.97 saleprice =202.5 where shipmentid ='18150914886901610';
  425. update shipment set tax =20.61 saleprice =232.2 where shipmentid ='18150936188226920';
  426. update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18150939188474800';
  427. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18150940088546260';
  428. update shipment set tax =0 saleprice =87.3 where shipmentid ='18150952089250750';
  429. update shipment set tax =0 saleprice =54 where shipmentid ='18150960789854420';
  430. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18150975191004560';
  431. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18151006393382050';
  432. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18151046296633280';
  433. update shipment set tax =15.58 saleprice =175.5 where shipmentid ='18151051397042870';
  434. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18151057697626580';
  435. update shipment set tax =19.81 saleprice =223.2 where shipmentid ='18151087699898400';
  436. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18151105001375870';
  437. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18151107401581980';
  438. update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18151110101751820';
  439. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18151146404331050';
  440. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18151148504545450';
  441. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18151187807342610';
  442. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18151191707623220';
  443. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18151195007923610';
  444. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18151276914279200';
  445. update shipment set tax =3.51 saleprice =39.6 where shipmentid ='18151338118368390';
  446. update shipment set tax =3.67 saleprice =41.4 where shipmentid ='18151361820243100';
  447. update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18151366920697480';
  448. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18151372621062470';
  449. update shipment set tax =6.31 saleprice =71.1 where shipmentid ='18151380421503080';
  450. update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18151475229006830';
  451. update shipment set tax =27.16 saleprice =306 where shipmentid ='18151543333594690';
  452. update shipment set tax =9.19 saleprice =103.5 where shipmentid ='18151554134287260';
  453. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18151556834456620';
  454. update shipment set tax =0 saleprice =70.2 where shipmentid ='18151561634695140';
  455. update shipment set tax =0 saleprice =34.2 where shipmentid ='18151564334883660';
  456. update shipment set tax =4.79 saleprice =54 where shipmentid ='18151572435478840';
  457. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18151613238386300';
  458. update shipment set tax =0 saleprice =34.2 where shipmentid ='18151681943119320';
  459. update shipment set tax =2.72 saleprice =30.6 where shipmentid ='18151683443250980';
  460. update shipment set tax =15.02 saleprice =169.2 where shipmentid ='18151686743499070';
  461. update shipment set tax =2.8 saleprice =31.5 where shipmentid ='18151691243725240';
  462. update shipment set tax =0 saleprice =88.2 where shipmentid ='18151692143762610';
  463. update shipment set tax =0 saleprice =34.2 where shipmentid ='18151693943858970';
  464. update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18151708344577290';
  465. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18151743147397490';
  466. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18151808852781910';
  467. update shipment set tax =0 saleprice =34.2 where shipmentid ='18151850855547940';
  468. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18151896458340340';
  469. update shipment set tax =2.08 saleprice =23.4 where shipmentid ='18151898258464980';
  470. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18152004466008520';
  471. update shipment set tax =2.56 saleprice =28.8 where shipmentid ='18152006866123690';
  472. update shipment set tax =0 saleprice =70.2 where shipmentid ='18152068670073020';
  473. update shipment set tax =2 saleprice =22.5 where shipmentid ='18152079170773760';
  474. update shipment set tax =3.2 saleprice =36 where shipmentid ='18152092371606700';
  475. update shipment set tax =1.6 saleprice =18 where shipmentid ='18152125674001770';
  476. update shipment set tax =13.42 saleprice =151.2 where shipmentid ='18152372591018740';
  477. update shipment set tax =0 saleprice =74.7 where shipmentid ='18152380991625270';
  478. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18152394192612940';
  479. update shipment set tax =10.14 saleprice =114.3 where shipmentid ='18152397192809040';
  480. update shipment set tax =4.23 saleprice =47.7 where shipmentid ='18152405893889800';
  481. update shipment set tax =3.91 saleprice =44.1 where shipmentid ='18152414594891510';
  482. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18152486599517200';
  483. update shipment set tax =11.18 saleprice =126 where shipmentid ='18152586407330050';
  484. update shipment set tax =0 saleprice =70.2 where shipmentid ='18152633210817860';
  485. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18152646111831100';
  486. update shipment set tax =0 saleprice =88.2 where shipmentid ='18152652712126020';
  487. update shipment set tax =19.57 saleprice =220.5 where shipmentid ='18152701015518540';
  488. update shipment set tax =11.98 saleprice =134.99 where shipmentid ='18152749618499170';
  489. update shipment set tax =2.4 saleprice =27 where shipmentid ='18152768819839730';
  490. update shipment set tax =0 saleprice =52.2 where shipmentid ='18152781720719750';
  491. update shipment set tax =0 saleprice =103.5 where shipmentid ='18152785020960690';
  492. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18152786221202780';
  493. update shipment set tax =6.23 saleprice =70.2 where shipmentid ='18152809022875330';
  494. update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18152824323898090';
  495. update shipment set tax =3.2 saleprice =36 where shipmentid ='18152830624254720';
  496. update shipment set tax =0 saleprice =70.2 where shipmentid ='18152855225890180';
  497. update shipment set tax =11.58 saleprice =130.5 where shipmentid ='18152864226411290';
  498. update shipment set tax =11.58 saleprice =130.5 where shipmentid ='18152896328687890';
  499. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18152902028960010';
  500. update shipment set tax =0 saleprice =88.2 where shipmentid ='18152908629492570';
  501. update shipment set tax =0 saleprice =88.2 where shipmentid ='18152911629784460';
  502. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18152917630116120';
  503. update shipment set tax =1.44 saleprice =16.2 where shipmentid ='18152921230445460';
  504. update shipment set tax =0 saleprice =43.2 where shipmentid ='18152925730617690';
  505. update shipment set tax =2.64 saleprice =29.7 where shipmentid ='18152927830763590';
  506. update shipment set tax =10.22 saleprice =115.2 where shipmentid ='18152937731449860';
  507. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18152948832214960';
  508. update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18152989034844280';
  509. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18153006436124010';
  510. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18153011836501470';
  511. update shipment set tax =11.82 saleprice =133.2 where shipmentid ='18153015436792570';
  512. update shipment set tax =44.01 saleprice =495.9 where shipmentid ='18153054439551010';
  513. update shipment set tax =4.79 saleprice =54 where shipmentid ='18153060439966110';
  514. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18153096742075680';
  515. update shipment set tax =0 saleprice =88.2 where shipmentid ='18153100042334010';
  516. update shipment set tax =2.88 saleprice =32.4 where shipmentid ='18153114443196320';
  517. update shipment set tax =12.62 saleprice =142.2 where shipmentid ='18153116843352780';
  518. update shipment set tax =2.4 saleprice =27 where shipmentid ='18153120743568020';
  519. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18153135144669620';
  520. update shipment set tax =2.4 saleprice =27 where shipmentid ='18153136644776090';
  521. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18153149245517180';
  522. update shipment set tax =0 saleprice =70.2 where shipmentid ='18153178347745360';
  523. update shipment set tax =0 saleprice =70.2 where shipmentid ='18153305856618880';
  524. update shipment set tax =21.41 saleprice =241.2 where shipmentid ='18153307956886930';
  525. update shipment set tax =3.67 saleprice =41.4 where shipmentid ='18153336758620480';
  526. update shipment set tax =11.02 saleprice =124.2 where shipmentid ='18153338558766370';
  527. update shipment set tax =0 saleprice =48.6 where shipmentid ='18153350859579150';
  528. update shipment set tax =14.22 saleprice =160.2 where shipmentid ='18153453466298010';
  529. update shipment set tax =2 saleprice =22.5 where shipmentid ='18153500569695130';
  530. update shipment set tax =1.84 saleprice =20.7 where shipmentid ='18153519471361060';
  531. update shipment set tax =0 saleprice =106.2 where shipmentid ='18153551274141450';
  532. update shipment set tax =42.89 saleprice =483.3 where shipmentid ='18153564475045720';
  533. update shipment set tax =41.93 saleprice =472.5 where shipmentid ='18153741487741540';
  534. update shipment set tax =1.2 saleprice =13.5 where shipmentid ='18153774790497640';
  535. update shipment set tax =1.92 saleprice =21.6 where shipmentid ='18153788591450620';
  536. update shipment set tax =1.28 saleprice =14.4 where shipmentid ='18153804192548560';
  537. update shipment set tax =16.37 saleprice =184.5 where shipmentid ='18153845895537650';
  538. update shipment set tax =15.82 saleprice =178.2 where shipmentid ='18153873798330220';
  539. update shipment set tax =3.2 saleprice =36 where shipmentid ='18153874398344320';
  540. update shipment set tax =31.79 saleprice =358.2 where shipmentid ='18153939403487920';
  541. update shipment set tax =0 saleprice =61.2 where shipmentid ='18153968205763750';
  542. update shipment set tax =0 saleprice =70.2 where shipmentid ='18153972105991650';
  543. update shipment set tax =18.21 saleprice =205.2 where shipmentid ='18153989807607100';
  544. update shipment set tax =17.25 saleprice =194.4 where shipmentid ='18154001808604540';
  545. update shipment set tax =3.83 saleprice =43.2 where shipmentid ='18154003608784400';
  546. update shipment set tax =2.64 saleprice =29.7 where shipmentid ='18154080414006130';
  547. update shipment set tax =119.41 saleprice =1345.5 where shipmentid ='18154103216004780';

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: