SHARE
TWEET

Untitled

a guest Apr 26th, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*
  2.  * ALTERAÇÃO NA ASSINATURA, 84 REGISTROS
  3.  */
  4. UPDATE PLANOS_CLIENTES SET ID_SACADO_SAC = 46471
  5. WHERE ID_PLANOCLIENTE_PLC IN (64435, 67627, 70391, 70398, 70399, 70400, 70402,
  6. 70403, 70404, 70408, 70409, 70410, 70412, 70413, 70414, 70415, 70416, 70417, 70418,
  7. 70419, 70420, 70421, 70422, 70423, 70424, 70425, 70426, 70427, 70428, 70429, 70589,
  8. 70591, 70884, 70921, 70926, 70943, 70947, 71073, 71694, 71738, 71833, 72036, 72294,
  9. 72920, 72981, 73116, 73168, 73424, 73477, 73478, 73479, 73480, 73481, 73482, 73483,
  10. 73486, 73487, 73491, 73492, 73493, 73494, 73495, 73496, 73497, 73498, 73500, 73501,
  11. 73503, 73504, 73506, 73507, 73508, 73509, 73510, 73511, 73512, 75043, 75183, 77292,
  12. 77633, 80002, 81073, 83785, 85017);
  13.  
  14. /*
  15.  * ALTERAÇÃO NA MENSALIDADE, 347 REGISTROS
  16.  */
  17.  
  18. UPDATE MENSALIDADE SET ID_CLIENTE_MENS = 46471
  19. WHERE ID_MENSALIDADE_MENS IN (136775, 136776, 136777, 141616, 146725, 146726, 146727, 146728, 146729, 146730, 146731, 146763, 146764, 146765, 146766, 146767, 146768, 146769,
  20. 146796, 146797, 146798, 146799, 146800, 146801, 146802, 146822, 146823, 146824, 146825, 146826, 146827, 146828, 146910, 146911, 146912, 146913, 146914, 146915, 146916, 146979,
  21. 146980, 146981, 146982, 146983, 146984, 146985, 147055, 147056, 147057, 147058, 147059, 147060, 147061, 147065, 147066, 147067, 147068, 147069, 147070, 147071, 147072, 147073,
  22. 147074, 147075, 147076, 147077, 147078, 147081, 147082, 147083, 147084, 147085, 147086, 147087, 147115, 147116, 147117, 147118, 147119, 147120, 147121, 147122, 147123, 147124,
  23. 147125, 147126, 147127, 147128, 147131, 147132, 147133, 147134, 147135, 147136, 147137, 147138, 147139, 147140, 147141, 147142, 147143, 147144, 147151, 147152, 147153, 147154,
  24. 147155, 147156, 147157, 147158, 147159, 147161, 147162, 147163, 147164, 147171, 147172, 147173, 147174, 147175, 147176, 147177, 147178, 147179, 147180, 147181, 147182, 147183,
  25. 147184, 147192, 147193, 147194, 147195, 147196, 147197, 147198, 147206, 147207, 147208, 147209, 147210, 147211, 147212, 147213, 147214, 147215, 147216, 147217, 147218, 147219,
  26. 147220, 147221, 147222, 147223, 147224, 147225, 147226, 147227, 147228, 147229, 147230, 147231, 147232, 147233, 147256, 147257, 147258, 147259, 147260, 147261, 147262, 147263,
  27. 147264, 147265, 147266, 147267, 147268, 147269, 147270, 147271, 147272, 147273, 147274, 147275, 147276, 147450, 147451, 147452, 147453, 147454, 147455, 147456, 147457, 147458,
  28. 147459, 147460, 147461, 147462, 147463, 147681, 147682, 147683, 147684, 147685, 147686, 147687, 148146, 148147, 148148, 148149, 148150, 148151, 148152, 148153, 148154, 148155,
  29. 148156, 148157, 148158, 148159, 148169, 148170, 148171, 148172, 148173, 148174, 148175, 148580, 149347, 149348, 149349, 149350, 149351, 149352, 149353, 149376, 149377, 149378,
  30. 149379, 149380, 149381, 149382, 149477, 149478, 149479, 149480, 149481, 149482, 149483, 149508, 149509, 149510, 149511, 149512, 149513, 149514, 149687, 149688, 149689, 149690,
  31. 149691, 149692, 149693, 150142, 150143, 150144, 150145, 150146, 150147, 150148, 150158, 150159, 150667, 151931, 151932, 152072, 152073, 152074, 152075, 152076, 152077, 152078,
  32. 152079, 152400, 152490, 153105, 153227, 153230, 153231, 153232, 153233, 153234, 153235, 153238, 153239, 153247, 153248, 153249, 153250, 153251, 153252, 153253, 153254, 153256,
  33. 153257, 153259, 153260, 153262, 153263, 153264, 153265, 153266, 153267, 153268, 153762, 156705, 157041, 157042, 157043, 157044, 157045, 157046, 157513, 157631, 162095, 162830,
  34. 162831, 162832, 162833, 162834, 162835, 162836, 168778, 171448, 178304, 178305, 178306, 178307, 178308, 178309, 178310, 181382, 181383, 181384, 181385, 181386, 181387);
  35.  
  36. /*
  37.  * ALTERAÇÃO NO RECEBIMENTO, 331 REGISTROS
  38.  */
  39.  
  40. UPDATE RECEBIMENTO SET ID_SACADO_SAC = 46471
  41. WHERE ID_RECEBIMENTO_RECB IN (211130, 212370, 214015, 225638, 232225, 232640, 232644, 232647, 232648, 232650, 232652, 232670, 232672, 232673, 232674, 232679,
  42. 232680, 232681, 232682, 232684, 232687, 232688, 232689, 232690, 232691, 232692, 232693, 232694, 232704, 232705, 232706, 232741, 232742, 232783, 233008, 233009,
  43. 233011, 233094, 235228, 235243, 235251, 235256, 235257, 235258, 235259, 235260, 235261, 235264, 235265, 235266, 235269, 235271, 235273, 235274, 235276, 235277,
  44. 235292, 235296, 235298, 235300, 235303, 235308, 235310, 235313, 235315, 235318, 235326, 235329, 235332, 235333, 235387, 235394, 235410, 235413, 235438, 235516,
  45. 235520, 236935, 236939, 236940, 236941, 236942, 237493, 237542, 240347, 240445, 240541, 240573, 240605, 240606, 240607, 240609, 240610, 240611, 240614, 240615,
  46. 240616, 240619, 240621, 240623, 240624, 240626, 240627, 240644, 240649, 240651, 240653, 240656, 240661, 240663, 240667, 240669, 240672, 240680, 240683, 240686,
  47. 240687, 240819, 240851, 242266, 242422, 242448, 242449, 242450, 242451, 242452, 242453, 242454, 242457, 242458, 242461, 242462, 242463, 242464, 242465, 242466,
  48. 242467, 242468, 242470, 242471, 242473, 242474, 242476, 242477, 242478, 242479, 242480, 242481, 242482, 243960, 244055, 244074, 244077, 244084, 244088, 244090,
  49. 244095, 244097, 244102, 244107, 244108, 244116, 244118, 244119, 244120, 244121, 244122, 244124, 244125, 244131, 244133, 244134, 244135, 244136, 246060, 246063,
  50. 246065, 246066, 247454, 247563, 247591, 247952, 249793, 249794, 249795, 249862, 251543, 251597, 251605, 251607, 251612, 251614, 251617, 251619, 251621, 251622,
  51. 251625, 251626, 251628, 251630, 251631, 251632, 251633, 251634, 251635, 251636, 251637, 251638, 251639, 251643, 251645, 251646, 251647, 251648, 253000, 254660,
  52. 254684, 256228, 257567, 258824, 258916, 258928, 258931, 258941, 258943, 258946, 258948, 258950, 258951, 258954, 258955, 258959, 258962, 258963, 258964, 258965,
  53. 258966, 258967, 258968, 258969, 258970, 258973, 258977, 258979, 258980, 258981, 258982, 261492, 261518, 263906, 263994, 264013, 264016, 264022, 264025, 264027,
  54. 264031, 264033, 264036, 264038, 264042, 264043, 264050, 264052, 264053, 264054, 264056, 264057, 264058, 264059, 264060, 264061, 264062, 264068, 264070, 264071,
  55. 264072, 264073, 264878, 264879, 267096, 267143, 268723, 271055, 271108, 271115, 271117, 271122, 271124, 271127, 271129, 271131, 271132, 271135, 271136, 271138,
  56. 271140, 271141, 271142, 271144, 271145, 271146, 271147, 271148, 271149, 271150, 271154, 271156, 271157, 271158, 271159, 272116, 274801, 274846, 276000, 282996,
  57. 286472, 289682, 291937, 299092, 300518, 303829, 308241, 317343, 321379, 322181, 322379, 322380, 322746, 328445, 329125);
  58.  
  59. /*
  60.  * ALTERAÇÃO NA COMPOSIÇÃO, 3.858 REGISTROS
  61.  */
  62.  
  63. UPDATE COMPO_RECEBIMENTO SET ID_SACADO_COMP = 46471
  64. WHERE ID_BOLETO_COMP IN (211130, 212370, 214015, 225638, 232225, 232640, 232644, 232647, 232648, 232650, 232652, 232670, 232672, 232673, 232674, 232679,
  65. 232680, 232681, 232682, 232684, 232687, 232688, 232689, 232690, 232691, 232692, 232693, 232694, 232704, 232705, 232706, 232741, 232742, 232783, 233008, 233009,
  66. 233011, 233094, 235228, 235243, 235251, 235256, 235257, 235258, 235259, 235260, 235261, 235264, 235265, 235266, 235269, 235271, 235273, 235274, 235276, 235277,
  67. 235292, 235296, 235298, 235300, 235303, 235308, 235310, 235313, 235315, 235318, 235326, 235329, 235332, 235333, 235387, 235394, 235410, 235413, 235438, 235516,
  68. 235520, 236935, 236939, 236940, 236941, 236942, 237493, 237542, 240347, 240445, 240541, 240573, 240605, 240606, 240607, 240609, 240610, 240611, 240614, 240615,
  69. 240616, 240619, 240621, 240623, 240624, 240626, 240627, 240644, 240649, 240651, 240653, 240656, 240661, 240663, 240667, 240669, 240672, 240680, 240683, 240686,
  70. 240687, 240819, 240851, 242266, 242422, 242448, 242449, 242450, 242451, 242452, 242453, 242454, 242457, 242458, 242461, 242462, 242463, 242464, 242465, 242466,
  71. 242467, 242468, 242470, 242471, 242473, 242474, 242476, 242477, 242478, 242479, 242480, 242481, 242482, 243960, 244055, 244074, 244077, 244084, 244088, 244090,
  72. 244095, 244097, 244102, 244107, 244108, 244116, 244118, 244119, 244120, 244121, 244122, 244124, 244125, 244131, 244133, 244134, 244135, 244136, 246060, 246063,
  73. 246065, 246066, 247454, 247563, 247591, 247952, 249793, 249794, 249795, 249862, 251543, 251597, 251605, 251607, 251612, 251614, 251617, 251619, 251621, 251622,
  74. 251625, 251626, 251628, 251630, 251631, 251632, 251633, 251634, 251635, 251636, 251637, 251638, 251639, 251643, 251645, 251646, 251647, 251648, 253000, 254660,
  75. 254684, 256228, 257567, 258824, 258916, 258928, 258931, 258941, 258943, 258946, 258948, 258950, 258951, 258954, 258955, 258959, 258962, 258963, 258964, 258965,
  76. 258966, 258967, 258968, 258969, 258970, 258973, 258977, 258979, 258980, 258981, 258982, 261492, 261518, 263906, 263994, 264013, 264016, 264022, 264025, 264027,
  77. 264031, 264033, 264036, 264038, 264042, 264043, 264050, 264052, 264053, 264054, 264056, 264057, 264058, 264059, 264060, 264061, 264062, 264068, 264070, 264071,
  78. 264072, 264073, 264878, 264879, 267096, 267143, 268723, 271055, 271108, 271115, 271117, 271122, 271124, 271127, 271129, 271131, 271132, 271135, 271136, 271138,
  79. 271140, 271141, 271142, 271144, 271145, 271146, 271147, 271148, 271149, 271150, 271154, 271156, 271157, 271158, 271159, 272116, 274801, 274846, 276000, 282996,
  80. 286472, 289682, 291937, 299092, 300518, 303829, 308241, 317343, 321379, 322181, 322379, 322380, 322746, 328445, 329125);
  81.  
  82. /*
  83.  * ALTERAÇÃO NO TICKET, 21 REGISTROS
  84.  */
  85.  
  86. UPDATE TICKET SET ID_SOLICITANTE_TIC = 46471
  87. WHERE ID_TICKET_TIC IN (12710, 12719, 12871, 13006, 13433, 13462, 13594, 13734, 13735, 13868, 13894, 14221, 14295, 14405, 15064, 15118, 15146, 16066, 16300, 16470, 16472);
  88.  
  89. /*
  90.  * ALTERAÇÃO NA NOTA, 27 REGISTROS
  91.  */
  92.  
  93. UPDATE NOTA SET ID_CLIENTE_NOT = 46471
  94. WHERE ID_NOTA_NOT IN (243296, 246941, 246984, 251199, 255887, 259318, 271497, 271509, 271510, 290532, 290778, 297053, 297395,
  95. 297396, 297397, 297398, 305768, 308506, 308677, 308678, 312101, 312102, 312103, 313978, 313979, 313980, 315463);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top