Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2020
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.35 KB | None | 0 0
  1. --- 1002745100001 ---
  2.  
  3. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '90' WHERE ID_DPOLIMPO IN (1323562);
  4. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '90' WHERE ID_DRECIBOS IN (298690);
  5. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '90' WHERE ID_DRECMEDI IN (348879);
  6. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '90' WHERE ID_DRECCOMI IN (388290);
  7. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '90' WHERE ID_DRECIMPO IN (372498);
  8.  
  9. --- 1002332120002 ---
  10.  
  11. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '4,63' WHERE ID_DPOLIMPO IN (1359051,1323133);
  12. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '4,63' WHERE ID_DRECIBOS IN (298694);
  13. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '4,63' WHERE ID_DRECMEDI IN (348883);
  14. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '4,63' WHERE ID_DRECCOMI IN (388294);
  15. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '4,63' WHERE ID_DRECIMPO IN (372502);
  16.  
  17. --- 1000021130089 ---
  18.  
  19. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '1,75' WHERE ID_DPOLIMPO IN (1313606);
  20. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '1,75' WHERE ID_DRECIBOS IN (298367);
  21. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '1,75' WHERE ID_DRECMEDI IN (348323);
  22. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '1,75' WHERE ID_DRECCOMI IN (385878);
  23. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '1,75' WHERE ID_DRECIMPO IN (372140);
  24.  
  25. --- 100033430002 ---
  26.  
  27. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '27,28' WHERE ID_DPOLIMPO IN (1358849,1314922);
  28. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '27,28' WHERE ID_DRECIBOS IN (298495);
  29. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '27,28' WHERE ID_DRECMEDI IN (348578);
  30. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '27,28' WHERE ID_DRECCOMI IN (387180);
  31. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '27,28' WHERE ID_DRECIMPO IN (372284);
  32.  
  33. --- 100116220002 ---
  34.  
  35. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '81,75' WHERE ID_DPOLIMPO IN (1358873,1320347);
  36. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '81,75' WHERE ID_DRECIBOS IN (298519);
  37. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '81,75' WHERE ID_DRECMEDI IN (348602);
  38. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '81,75' WHERE ID_DRECCOMI IN (387204);
  39. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '81,75' WHERE ID_DRECIMPO IN (372308);
  40.  
  41. --- 1002131110003 ---
  42.  
  43. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '13,17' WHERE ID_DPOLIMPO IN (1358862,1322692);
  44. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '13,17' WHERE ID_DRECIBOS IN (298508);
  45. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '13,17' WHERE ID_DRECMEDI IN (348591);
  46. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '13,17' WHERE ID_DRECCOMI IN (387193);
  47. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '13,17' WHERE ID_DRECIMPO IN (372297);
  48.  
  49. --- 1000092120001 ---
  50.  
  51. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '487,52' WHERE ID_DPOLIMPO IN (1358844,1314501);
  52. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '487,52' WHERE ID_DRECIBOS IN (298487);
  53. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '487,52' WHERE ID_DRECMEDI IN (348570);
  54. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '487,52' WHERE ID_DRECCOMI IN (387172);
  55. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '487,52' WHERE ID_DRECIMPO IN (372276);
  56.  
  57. --- 100221080001 ---
  58.  
  59. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '35,19' WHERE ID_DPOLIMPO IN (1358691,1322974);
  60. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '35,19' WHERE ID_DRECIBOS IN (298306);
  61. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '35,19' WHERE ID_DRECMEDI IN (348262);
  62. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '35,19' WHERE ID_DRECCOMI IN (385737);
  63. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '35,19' WHERE ID_DRECIMPO IN (372079);
  64.  
  65. --- 100009230035 ---
  66.  
  67. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '1,8' WHERE ID_DPOLIMPO IN (1358659,1314471);
  68. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '1,8' WHERE ID_DRECIBOS IN (298269);
  69. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '1,8' WHERE ID_DRECMEDI IN (348225);
  70. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '1,8' WHERE ID_DRECCOMI IN (385700);
  71. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '1,8' WHERE ID_DRECIMPO IN (372042);
  72.  
  73. --- 100071230002 ---
  74.  
  75. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '23,23' WHERE ID_DPOLIMPO IN (1358666,1317468);
  76. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '23,23' WHERE ID_DRECIBOS IN (298276);
  77. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '23,23' WHERE ID_DRECMEDI IN (348232);
  78. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '23,23' WHERE ID_DRECCOMI IN (385707);
  79. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '23,23' WHERE ID_DRECIMPO IN (372049);
  80.  
  81. --- 100071230001 ---
  82.  
  83. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '18,48' WHERE ID_DPOLIMPO IN (1358665,1317467);
  84. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '18,48' WHERE ID_DRECIBOS IN (298275);
  85. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '18,48' WHERE ID_DRECMEDI IN (348231);
  86. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '18,48' WHERE ID_DRECCOMI IN (385706);
  87. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '18,48' WHERE ID_DRECIMPO IN (372048);
  88.  
  89. --- 100009230028 ---
  90.  
  91. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '2,83' WHERE ID_DPOLIMPO IN (1358518,1314470);
  92. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '2,83' WHERE ID_DRECIBOS IN (298123);
  93. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '2,83' WHERE ID_DRECMEDI IN (347999);
  94. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '2,83' WHERE ID_DRECCOMI IN (385163);
  95. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '2,83' WHERE ID_DRECIMPO IN (371873);
  96.  
  97. --- 100009230027 ---
  98.  
  99. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '3,56' WHERE ID_DPOLIMPO IN (1358517,1314469);
  100. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '3,56' WHERE ID_DRECIBOS IN (298122);
  101. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '3,56' WHERE ID_DRECMEDI IN (347998);
  102. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '3,56' WHERE ID_DRECCOMI IN (385162);
  103. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '3,56' WHERE ID_DRECIMPO IN (371872);
  104.  
  105. --- 100009230026 ---
  106.  
  107. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '1,80' WHERE ID_DPOLIMPO IN (1358369,1314468);
  108. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '1,80' WHERE ID_DRECIBOS IN (298024);
  109. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '1,80' WHERE ID_DRECMEDI IN (347803);
  110. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '1,80' WHERE ID_DRECCOMI IN (383961);
  111. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '1,80' WHERE ID_DRECIMPO IN (371738);
  112.  
  113. --- 100124630005 ---
  114.  
  115. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '25,32' WHERE ID_DPOLIMPO IN (1358380,1320620);
  116. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '25,32' WHERE ID_DRECIBOS IN (298035);
  117. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '25,32' WHERE ID_DRECMEDI IN (347814);
  118. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '25,32' WHERE ID_DRECCOMI IN (383972);
  119. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '25,32' WHERE ID_DRECIMPO IN (371749);
  120.  
  121. --- 100104060001 ---
  122.  
  123. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = 57 WHERE ID_DPOLIMPO IN (1318760);
  124. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = 57 WHERE ID_DRECIBOS IN (297848);
  125. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = 57 WHERE ID_DRECMEDI IN (347498);
  126. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = 57 WHERE ID_DRECCOMI IN (382487);
  127. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = 57 WHERE ID_DRECIMPO IN (371520);
  128.  
  129. --- 100059440001 ---
  130.  
  131. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '5,89' WHERE ID_DPOLIMPO IN (1358060,1317141);
  132. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '5,89' WHERE ID_DRECIBOS IN (297824);
  133. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '5,89' WHERE ID_DRECMEDI IN (347474);
  134. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '5,89' WHERE ID_DRECCOMI IN (382463);
  135. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '5,89' WHERE ID_DRECIMPO IN (371496);
  136.  
  137. --- 100094150002 ---
  138.  
  139. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '4,20' WHERE ID_DPOLIMPO IN (1358061,1318200);
  140. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '4,20' WHERE ID_DRECIBOS IN (297825);
  141. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '4,20' WHERE ID_DRECMEDI IN (347475);
  142. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '4,20' WHERE ID_DRECCOMI IN (382464);
  143. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '4,20' WHERE ID_DRECIMPO IN (371497);
  144.  
  145. --- 100182660001 ---
  146.  
  147. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = 480‬ WHERE ID_DPOLIMPO IN (1322159);
  148. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = 480‬ WHERE ID_DRECIBOS IN (297847);
  149. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = 480‬ WHERE ID_DRECMEDI IN (347497);
  150. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = 480‬ WHERE ID_DRECCOMI IN (382486);
  151. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = 480‬ WHERE ID_DRECIMPO IN (371519);
  152.  
  153. --- 1002131100001 ---
  154.  
  155. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '108,99‬' WHERE ID_DPOLIMPO IN (1358032,1322691);
  156. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '108,99‬' WHERE ID_DRECIBOS IN (297790);
  157. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '108,99‬' WHERE ID_DRECMEDI IN (347439);
  158. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '108,99‬' WHERE ID_DRECCOMI IN (382384);
  159. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '108,99‬' WHERE ID_DRECIMPO IN (371462);
  160.  
  161. --- 1002332110003 ---
  162.  
  163. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '‬4,63' WHERE ID_DPOLIMPO IN (1358035,1323122);
  164. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '4,63' WHERE ID_DRECIBOS IN (297794);
  165. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '4,63' WHERE ID_DRECMEDI IN (347443);
  166. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '4,63' WHERE ID_DRECCOMI IN (382388);
  167. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '4,63' WHERE ID_DRECIMPO IN (371466);
  168.  
  169. --- 100109570003 ---
  170.  
  171. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '‬22,47' WHERE ID_DPOLIMPO IN (1358046,1319704);
  172. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '22,47' WHERE ID_DRECIBOS IN (297809);
  173. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '22,47' WHERE ID_DRECMEDI IN (347458);
  174. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '22,47' WHERE ID_DRECCOMI IN (382403);
  175. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '22,47' WHERE ID_DRECIMPO IN (371481);
  176.  
  177. --- 100115960002 ---
  178.  
  179. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '‬4,2' WHERE ID_DPOLIMPO IN (1357158,1320345);
  180. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '4,2' WHERE ID_DRECIBOS IN (297180);
  181. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '4,2' WHERE ID_DRECMEDI IN (346506);
  182. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '4,2' WHERE ID_DRECCOMI IN (376888);
  183. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '4,2' WHERE ID_DRECIMPO IN (370742);
  184.  
  185. --- 1000172980001 ---
  186.  
  187. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '9,98‬' WHERE ID_DPOLIMPO IN (1357810,1314679);
  188. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '9,98' WHERE ID_DRECIBOS IN (297595);
  189. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '9,98' WHERE ID_DRECMEDI IN (347093);
  190. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '9,98' WHERE ID_DRECCOMI IN (381065);
  191. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '9,98' WHERE ID_DRECIMPO IN (371243);
  192.  
  193. --- 1000172980002 ---
  194.  
  195. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '‬4,2' WHERE ID_DPOLIMPO IN (1357811,1314680);
  196. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '4,2' WHERE ID_DRECIBOS IN (297596);
  197. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '4,2' WHERE ID_DRECMEDI IN (347094);
  198. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '4,2' WHERE ID_DRECCOMI IN (381066);
  199. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '4,2' WHERE ID_DRECIMPO IN (371244);
  200.  
  201. --- 100106960001 ---
  202.  
  203. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '‬69,21' WHERE ID_DPOLIMPO IN (1357324,1319182);
  204. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '69,21' WHERE ID_DRECIBOS IN (297313);
  205. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '69,21' WHERE ID_DRECMEDI IN (346673);
  206. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '69,21' WHERE ID_DRECCOMI IN (378389);
  207. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '69,21' WHERE ID_DRECIMPO IN (370898);
  208.  
  209. --- 100053950002 ---
  210.  
  211. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '4,2‬' WHERE ID_DPOLIMPO IN (1357275,1315862);
  212. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '4,2' WHERE ID_DRECIBOS IN (297255);
  213. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '4,2' WHERE ID_DRECMEDI IN (346614);
  214. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '4,2' WHERE ID_DRECCOMI IN (378270);
  215. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '4,2' WHERE ID_DRECIMPO IN (370840);
  216.  
  217. --- 100045620001 ---
  218.  
  219. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '33,15' WHERE ID_DPOLIMPO IN (1357272,1327840);
  220. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '33,15' WHERE ID_DRECIBOS IN (297252);
  221. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '33,15' WHERE ID_DRECMEDI IN (346611);
  222. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '33,15' WHERE ID_DRECCOMI IN (378267);
  223. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '33,15' WHERE ID_DRECIMPO IN (370837);
  224.  
  225. --- 1000598980016 ---
  226.  
  227. UPDATE NTJDATCES.DPOLIMPO SET IMPCOMIS = '8,91' WHERE ID_DPOLIMPO IN (1357139,1317189);
  228. UPDATE NTJDATCES.DRECIBOS SET RECICOMI = '8,91' WHERE ID_DRECIBOS IN (297158);
  229. UPDATE NTJDATCES.DRECMEDI SET RECICOMI = '8,91' WHERE ID_DRECMEDI IN (346484);
  230. UPDATE NTJDATCES.DRECCOMI SET IMPCOMIS = '8,91' WHERE ID_DRECCOMI IN (376866);
  231. UPDATE NTJDATCES.DRECIMPO SET IMPCOMIS = '8,91' WHERE ID_DRECIMPO IN (370720);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement