'1_27_3477', '1_27_4096', '1_27_4113', '1_27_4154', '1_29_3459', '1_29_3535', '1_29_4004', '1_30_#4067', '1_30_3168', '1_30_3457', '1_30_3534', '1_30_4005', '1_32_240295', '1_32_240807', '1_32_240809', '1_32_250538', '1_33_#4044', '1_33_#4066', '1_33_3306', '1_33_4003', '1_39_3478', '1_3_230322', '1_3_230323', '1_3_230324', '1_3_240271', '1_3_240272', '1_3_240744', '1_3_240745', '1_3_240746', '1_3_240747', '1_3_250019', '1_3_250020', '1_3_250021', '1_3_250022', '1_3_250470', '1_3_250471', '1_3_250638', '1_3_250639-1', '1_43_3071', '1_43_3106', '1_43_3461', '1_44_#4069', '1_44_#4087', '1_44_3475', '1_44_4155', '1_47_240260', '1_47_240261'
796: 230322 - 2005-01-01, 796 - update trans set balance=796, needsrebal=0 where id=748
724: 230322 - 2005-03-31, -72 - update trans set balance=724, needsrebal=0 where id=973
612: 230322 - 2005-03-31, -112 - update trans set balance=612, needsrebal=0 where id=1083
556: 230322 - 2005-03-31, -56 - update trans set balance=556, needsrebal=0 where id=1082
548: 230322 - 2005-04-01, -8 - update trans set balance=548, needsrebal=0 where id=955
492: 230322 - 2005-04-01, -56 - update trans set balance=492, needsrebal=0 where id=1085
436: 230322 - 2005-04-01, -56 - update trans set balance=436, needsrebal=0 where id=1088
424: 230322 - 2005-04-06, -12 - update trans set balance=424, needsrebal=0 where id=1309
304: 230322 - 2005-04-08, -120 - update trans set balance=304, needsrebal=0 where id=1312
248: 230322 - 2005-04-11, -56 - update trans set balance=248, needsrebal=0 where id=1314
180: 230322 - 2005-04-14, -68 - update trans set balance=180, needsrebal=0 where id=1240
12: 230322 - 2005-04-15, -168 - update trans set balance=12, needsrebal=0 where id=1315
0: 230322 - 2005-04-21, -12 - update trans set balance=0, needsrebal=0 where id=1223
1022: 230323 - 2005-01-01, 1022 - update trans set balance=1022, needsrebal=0 where id=749
954: 230323 - 2005-01-31, -68 - update trans set balance=954, needsrebal=0 where id=415
394: 230323 - 2005-01-31, -560 - update trans set balance=394, needsrebal=0 where id=68
364: 230323 - 2005-02-01, -30 - update trans set balance=364, needsrebal=0 where id=684
308: 230323 - 2005-02-02, -56 - update trans set balance=308, needsrebal=0 where id=674
252: 230323 - 2005-02-02, -56 - update trans set balance=252, needsrebal=0 where id=680
196: 230323 - 2005-02-07, -56 - update trans set balance=196, needsrebal=0 where id=642
184: 230323 - 2005-02-08, -12 - update trans set balance=184, needsrebal=0 where id=606
124: 230323 - 2005-02-08, -60 - update trans set balance=124, needsrebal=0 where id=612
99: 230323 - 2005-02-08, -25 - update trans set balance=99, needsrebal=0 where id=613
96: 230323 - 2005-02-10, -3 - update trans set balance=96, needsrebal=0 where id=584
0: 230323 - 2005-02-10, -96 - update trans set balance=0, needsrebal=0 where id=587
1078: 230324 - 2005-01-01, 1078 - update trans set balance=1078, needsrebal=0 where id=771
1054: 230324 - 2005-02-10, -24 - update trans set balance=1054, needsrebal=0 where id=588
998: 230324 - 2005-02-10, -56 - update trans set balance=998, needsrebal=0 where id=586
933: 230324 - 2005-02-14, -65 - update trans set balance=933, needsrebal=0 where id=571
813: 230324 - 2005-02-14, -120 - update trans set balance=813, needsrebal=0 where id=572
801: 230324 - 2005-02-17, -12 - update trans set balance=801, needsrebal=0 where id=556
681: 230324 - 2005-02-17, -120 - update trans set balance=681, needsrebal=0 where id=552
671: 230324 - 2005-02-18, -10 - update trans set balance=671, needsrebal=0 where id=531
646: 230324 - 2005-02-21, -25 - update trans set balance=646, needsrebal=0 where id=526
586: 230324 - 2005-03-04, -60 - update trans set balance=586, needsrebal=0 where id=1160
466: 230324 - 2005-03-08, -120 - update trans set balance=466, needsrebal=0 where id=851
441: 230324 - 2005-03-16, -25 - update trans set balance=441, needsrebal=0 where id=908
385: 230324 - 2005-03-17, -56 - update trans set balance=385, needsrebal=0 where id=876
329: 230324 - 2005-03-21, -56 - update trans set balance=329, needsrebal=0 where id=953
273: 230324 - 2005-03-21, -56 - update trans set balance=273, needsrebal=0 where id=1069
243: 230324 - 2005-03-21, -30 - update trans set balance=243, needsrebal=0 where id=1070
123: 230324 - 2005-03-22, -120 - update trans set balance=123, needsrebal=0 where id=1056
111: 230324 - 2005-03-23, -12 - update trans set balance=111, needsrebal=0 where id=980
96: 230324 - 2005-03-29, -15 - update trans set balance=96, needsrebal=0 where id=1049
0: 230324 - 2005-03-31, -96 - update trans set balance=0, needsrebal=0 where id=972
92: 240271 - 2005-01-01, 92 - update trans set balance=92, needsrebal=0 where id=794
62: 240271 - 2005-01-10, -30 - update trans set balance=62, needsrebal=0 where id=287
50: 240271 - 2005-01-11, -12 - update trans set balance=50, needsrebal=0 where id=274
0: 240271 - 2005-01-12, -50 - update trans set balance=0, needsrebal=0 where id=264
1200: 240272 - 2004-07-14, 1200 - update trans set balance=1200, needsrebal=0 where id=793
1194: 240272 - 2005-01-12, -6 - update trans set balance=1194, needsrebal=0 where id=414
1074: 240272 - 2005-01-12, -120 - update trans set balance=1074, needsrebal=0 where id=263
1044: 240272 - 2005-01-12, -30 - update trans set balance=1044, needsrebal=0 where id=261
988: 240272 - 2005-01-13, -56 - update trans set balance=988, needsrebal=0 where id=223
876: 240272 - 2005-01-13, -112 - update trans set balance=876, needsrebal=0 where id=220
764: 240272 - 2005-01-14, -112 - update trans set balance=764, needsrebal=0 where id=204
752: 240272 - 2005-01-17, -12 - update trans set balance=752, needsrebal=0 where id=187
632: 240272 - 2005-01-18, -120 - update trans set balance=632, needsrebal=0 where id=178
576: 240272 - 2005-01-20, -56 - update trans set balance=576, needsrebal=0 where id=151
464: 240272 - 2005-01-25, -112 - update trans set balance=464, needsrebal=0 where id=131
408: 240272 - 2005-01-25, -56 - update trans set balance=408, needsrebal=0 where id=121
108: 240272 - 2005-01-26, -300 - update trans set balance=108, needsrebal=0 where id=110
52: 240272 - 2005-01-28, -56 - update trans set balance=52, needsrebal=0 where id=90
0: 240272 - 2005-01-31, -52 - update trans set balance=0, needsrebal=0 where id=75
1078: 240744 - 2005-02-02, 1078 - update trans set balance=1078, needsrebal=0 where id=772
922: 240744 - 2005-04-14, -156 - update trans set balance=922, needsrebal=0 where id=1241
802: 240744 - 2005-04-15, -120 - update trans set balance=802, needsrebal=0 where id=1178
1337: 240744 - 2005-04-21, 535 - update trans set balance=1337, needsrebal=0 where id=1533
1277: 240744 - 2005-04-22, -60 - update trans set balance=1277, needsrebal=0 where id=1379
1265: 240744 - 2005-04-25, -12 - update trans set balance=1265, needsrebal=0 where id=1374
1209: 240744 - 2005-04-26, -56 - update trans set balance=1209, needsrebal=0 where id=1370
1089: 240744 - 2005-04-29, -120 - update trans set balance=1089, needsrebal=0 where id=1390
1054: 240744 - 2005-05-03, -35 - update trans set balance=1054, needsrebal=0 where id=1430
942: 240744 - 2005-05-06, -112 - update trans set balance=942, needsrebal=0 where id=1519
917: 240744 - 2005-05-09, -25 - update trans set balance=917, needsrebal=0 where id=1523
916: 240744 - 2005-05-09, -1 - update trans set balance=916, needsrebal=0 where id=1491
901: 240744 - 2005-05-10, -15 - update trans set balance=901, needsrebal=0 where id=1514
889: 240744 - 2005-05-11, -12 - update trans set balance=889, needsrebal=0 where id=1481
769: 240744 - 2005-05-13, -120 - update trans set balance=769, needsrebal=0 where id=1565
713: 240744 - 2005-05-19, -56 - update trans set balance=713, needsrebal=0 where id=1564
545: 240744 - 2005-05-25, -168 - update trans set balance=545, needsrebal=0 where id=1705
209: 240744 - 2005-05-25, -336 - update trans set balance=209, needsrebal=0 where id=1703
153: 240744 - 2005-05-27, -56 - update trans set balance=153, needsrebal=0 where id=1700
33: 240744 - 2005-05-27, -120 - update trans set balance=33, needsrebal=0 where id=1702
0: 240744 - 2005-05-31, -33 - update trans set balance=0, needsrebal=0 where id=1751
917: 240745 - 2005-01-01, 917 - update trans set balance=917, needsrebal=0 where id=773
797: 240745 - 2005-05-26, -120 - update trans set balance=797, needsrebal=0 where id=1739
774: 240745 - 2005-05-31, -23 - update trans set balance=774, needsrebal=0 where id=1752
718: 240745 - 2005-05-31, -56 - update trans set balance=718, needsrebal=0 where id=1736
598: 240745 - 2005-05-31, -120 - update trans set balance=598, needsrebal=0 where id=1738
538: 240745 - 2005-06-02, -60 - update trans set balance=538, needsrebal=0 where id=1768
482: 240745 - 2005-06-03, -56 - update trans set balance=482, needsrebal=0 where id=1769
444: 240745 - 2005-06-06, -38 - update trans set balance=444, needsrebal=0 where id=1756
324: 240745 - 2005-06-08, -120 - update trans set balance=324, needsrebal=0 where id=2037
300: 240745 - 2005-06-08, -24 - update trans set balance=300, needsrebal=0 where id=2038
180: 240745 - 2005-06-09, -120 - update trans set balance=180, needsrebal=0 where id=2036
144: 240745 - 2005-06-15, -36 - update trans set balance=144, needsrebal=0 where id=1887
132: 240745 - 2005-06-24, -12 - update trans set balance=132, needsrebal=0 where id=1937
170: 240745 - 2005-06-29, 38 - update trans set balance=170, needsrebal=0 where id=1974
158: 240745 - 2005-06-29, -12 - update trans set balance=158, needsrebal=0 where id=1917
120: 240745 - 2005-07-11, -38 - update trans set balance=120, needsrebal=0 where id=2115
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 3, 'M6CB', '240745', 120, '2005-01-01','2005-07-11');
1077: 240746 - 2005-04-07, 1077 - update trans set balance=1077, needsrebal=0 where id=940
1033: 240746 - 2005-06-24, -44 - update trans set balance=1033, needsrebal=0 where id=1938
1018: 240746 - 2005-06-29, -15 - update trans set balance=1018, needsrebal=0 where id=1989
1016: 240746 - 2005-06-30, -2 - update trans set balance=1016, needsrebal=0 where id=1980
992: 240746 - 2005-07-06, -24 - update trans set balance=992, needsrebal=0 where id=2000
932: 240746 - 2005-07-06, -60 - update trans set balance=932, needsrebal=0 where id=2051
764: 240746 - 2005-07-06, -168 - update trans set balance=764, needsrebal=0 where id=2066
746: 240746 - 2005-07-11, -18 - update trans set balance=746, needsrebal=0 where id=2116
734: 240746 - 2005-07-13, -12 - update trans set balance=734, needsrebal=0 where id=2136
614: 240746 - 2005-07-14, -120 - update trans set balance=614, needsrebal=0 where id=2156
558: 240746 - 2005-07-14, -56 - update trans set balance=558, needsrebal=0 where id=2162
438: 240746 - 2005-07-18, -120 - update trans set balance=438, needsrebal=0 where id=2168
382: 240746 - 2005-07-19, -56 - update trans set balance=382, needsrebal=0 where id=2220
262: 240746 - 2005-07-20, -120 - update trans set balance=262, needsrebal=0 where id=2219
240: 240746 - 2005-07-20, -22 - update trans set balance=240, needsrebal=0 where id=2224
0: 240746 - 2005-07-21, -240 - update trans set balance=0, needsrebal=0 where id=2163
1077: 240747 - 2005-04-14, 1077 - update trans set balance=1077, needsrebal=0 where id=943
707: 240747 - 2005-07-20, -370 - update trans set balance=707, needsrebal=0 where id=2225
539: 240747 - 2005-07-27, -168 - update trans set balance=539, needsrebal=0 where id=2280
483: 240747 - 2005-07-27, -56 - update trans set balance=483, needsrebal=0 where id=2284
458: 240747 - 2005-07-28, -25 - update trans set balance=458, needsrebal=0 where id=2285
346: 240747 - 2005-07-29, -112 - update trans set balance=346, needsrebal=0 where id=2300
290: 240747 - 2005-07-29, -56 - update trans set balance=290, needsrebal=0 where id=2303
282: 240747 - 2005-07-29, -8 - update trans set balance=282, needsrebal=0 where id=2315
253: 240747 - 2005-08-03, -29 - update trans set balance=253, needsrebal=0 where id=2333
197: 240747 - 2005-08-04, -56 - update trans set balance=197, needsrebal=0 where id=2353
141: 240747 - 2005-08-05, -56 - update trans set balance=141, needsrebal=0 where id=2367
117: 240747 - 2005-08-11, -24 - update trans set balance=117, needsrebal=0 where id=2345
0: 240747 - 2005-08-15, -117 - update trans set balance=0, needsrebal=0 where id=2416
1077: 250019 - 2005-06-15, 1077 - update trans set balance=1077, needsrebal=0 where id=1663
965: 250019 - 2005-08-12, -112 - update trans set balance=965, needsrebal=0 where id=2496
858: 250019 - 2005-08-15, -107 - update trans set balance=858, needsrebal=0 where id=2417
738: 250019 - 2005-08-16, -120 - update trans set balance=738, needsrebal=0 where id=2497
678: 250019 - 2005-08-19, -60 - update trans set balance=678, needsrebal=0 where id=2498
653: 250019 - 2005-08-22, -25 - update trans set balance=653, needsrebal=0 where id=2511
485: 250019 - 2005-08-22, -168 - update trans set balance=485, needsrebal=0 where id=2519
465: 250019 - 2005-08-24, -20 - update trans set balance=465, needsrebal=0 where id=2500
409: 250019 - 2005-08-25, -56 - update trans set balance=409, needsrebal=0 where id=2527
353: 250019 - 2005-08-29, -56 - update trans set balance=353, needsrebal=0 where id=2499
323: 250019 - 2005-08-30, -30 - update trans set balance=323, needsrebal=0 where id=2570
211: 250019 - 2005-08-31, -112 - update trans set balance=211, needsrebal=0 where id=2574
155: 250019 - 2005-09-06, -56 - update trans set balance=155, needsrebal=0 where id=2588
95: 250019 - 2005-09-12, -60 - update trans set balance=95, needsrebal=0 where id=2615
0: 250019 - 2005-09-16, -95 - update trans set balance=0, needsrebal=0 where id=2666
1077: 250020 - 2005-06-02, 1077 - update trans set balance=1077, needsrebal=0 where id=1900
957: 250020 - 2005-09-01, -120 - update trans set balance=957, needsrebal=0 where id=2575
932: 250020 - 2005-09-16, -25 - update trans set balance=932, needsrebal=0 where id=2667
920: 250020 - 2005-09-19, -12 - update trans set balance=920, needsrebal=0 where id=2924
864: 250020 - 2005-09-20, -56 - update trans set balance=864, needsrebal=0 where id=2929
859: 250020 - 2005-09-20, -5 - update trans set balance=859, needsrebal=0 where id=2810
857: 250020 - 2005-09-20, -2 - update trans set balance=857, needsrebal=0 where id=2813
801: 250020 - 2005-09-21, -56 - update trans set balance=801, needsrebal=0 where id=2926
777: 250020 - 2005-09-21, -24 - update trans set balance=777, needsrebal=0 where id=2928
765: 250020 - 2005-09-21, -12 - update trans set balance=765, needsrebal=0 where id=2922
709: 250020 - 2005-09-28, -56 - update trans set balance=709, needsrebal=0 where id=2835
649: 250020 - 2005-09-29, -60 - update trans set balance=649, needsrebal=0 where id=2841
529: 250020 - 2005-09-30, -120 - update trans set balance=529, needsrebal=0 where id=2921
289: 250020 - 2005-09-30, -240 - update trans set balance=289, needsrebal=0 where id=2840
189: 250020 - 2005-10-04, -100 - update trans set balance=189, needsrebal=0 where id=2886
174: 250020 - 2005-10-06, -15 - update trans set balance=174, needsrebal=0 where id=2888
162: 250020 - 2005-10-12, -12 - update trans set balance=162, needsrebal=0 where id=2897
112: 250020 - 2005-10-31, -50 - update trans set balance=112, needsrebal=0 where id=3301
80: 250020 - 2005-12-01, -32 - update trans set balance=80, needsrebal=0 where id=3544
12: 250020 - 2005-12-01, -68 - update trans set balance=12, needsrebal=0 where id=3543
0: 250020 - 2006-04-27, -12 - update trans set balance=0, needsrebal=0 where id=4924
1077: 250021 - 2005-10-11, 1077 - update trans set balance=1077, needsrebal=0 where id=3886
1065: 250021 - 2006-01-16, -12 - update trans set balance=1065, needsrebal=0 where id=3948
965: 250021 - 2006-01-19, -100 - update trans set balance=965, needsrebal=0 where id=4008
909: 250021 - 2006-01-24, -56 - update trans set balance=909, needsrebal=0 where id=4030
789: 250021 - 2006-01-25, -120 - update trans set balance=789, needsrebal=0 where id=4016
764: 250021 - 2006-01-26, -25 - update trans set balance=764, needsrebal=0 where id=4042
708: 250021 - 2006-01-30, -56 - update trans set balance=708, needsrebal=0 where id=4033
652: 250021 - 2006-01-30, -56 - update trans set balance=652, needsrebal=0 where id=4063
627: 250021 - 2006-02-01, -25 - update trans set balance=627, needsrebal=0 where id=4117
571: 250021 - 2006-02-07, -56 - update trans set balance=571, needsrebal=0 where id=4137
451: 250021 - 2006-02-07, -120 - update trans set balance=451, needsrebal=0 where id=4155
441: 250021 - 2006-02-07, -10 - update trans set balance=441, needsrebal=0 where id=4156
412: 250021 - 2006-02-07, -29 - update trans set balance=412, needsrebal=0 where id=4143
356: 250021 - 2006-02-09, -56 - update trans set balance=356, needsrebal=0 where id=4162
244: 250021 - 2006-02-09, -112 - update trans set balance=244, needsrebal=0 where id=4177
188: 250021 - 2006-02-14, -56 - update trans set balance=188, needsrebal=0 where id=4187
20: 250021 - 2006-02-23, -168 - update trans set balance=20, needsrebal=0 where id=4220
0: 250021 - 2006-02-23, -20 - update trans set balance=0, needsrebal=0 where id=4225
1077: 250022 - 2005-11-17, 1077 - update trans set balance=1077, needsrebal=0 where id=3344
1021: 250022 - 2005-12-22, -56 - update trans set balance=1021, needsrebal=0 where id=3767
965: 250022 - 2005-12-22, -56 - update trans set balance=965, needsrebal=0 where id=3760
797: 250022 - 2005-12-27, -168 - update trans set balance=797, needsrebal=0 where id=3784
690: 250022 - 2005-12-29, -107 - update trans set balance=690, needsrebal=0 where id=3713
634: 250022 - 2005-12-29, -56 - update trans set balance=634, needsrebal=0 where id=3815
522: 250022 - 2006-01-03, -112 - update trans set balance=522, needsrebal=0 where id=3824
298: 250022 - 2006-01-05, -224 - update trans set balance=298, needsrebal=0 where id=3820
294: 250022 - 2006-01-09, -4 - update trans set balance=294, needsrebal=0 where id=3894
238: 250022 - 2006-01-09, -56 - update trans set balance=238, needsrebal=0 where id=3893
178: 250022 - 2006-01-11, -60 - update trans set balance=178, needsrebal=0 where id=3927
58: 250022 - 2006-01-16, -120 - update trans set balance=58, needsrebal=0 where id=3946
10: 250022 - 2006-01-16, -48 - update trans set balance=10, needsrebal=0 where id=3947
0: 250022 - 2006-01-19, -10 - update trans set balance=0, needsrebal=0 where id=3910
1077: 250470 - 2005-10-21, 1077 - update trans set balance=1077, needsrebal=0 where id=3117
977: 250470 - 2005-10-25, -100 - update trans set balance=977, needsrebal=0 where id=3183
921: 250470 - 2005-10-25, -56 - update trans set balance=921, needsrebal=0 where id=3186
697: 250470 - 2005-10-25, -224 - update trans set balance=697, needsrebal=0 where id=3185
641: 250470 - 2005-10-25, -56 - update trans set balance=641, needsrebal=0 where id=3184
585: 250470 - 2005-10-25, -56 - update trans set balance=585, needsrebal=0 where id=3188
529: 250470 - 2005-10-25, -56 - update trans set balance=529, needsrebal=0 where id=3209
473: 250470 - 2005-10-26, -56 - update trans set balance=473, needsrebal=0 where id=3219
193: 250470 - 2005-10-26, -280 - update trans set balance=193, needsrebal=0 where id=3207
105: 250470 - 2005-10-27, -88 - update trans set balance=105, needsrebal=0 where id=3267
205: 250470 - 2005-11-28, 100 - update trans set balance=205, needsrebal=0 where id=3501
149: 250470 - 2005-11-30, -56 - update trans set balance=149, needsrebal=0 where id=3536
105: 250470 - 2005-12-01, -44 - update trans set balance=105, needsrebal=0 where id=3542
80: 250470 - 2005-12-06, -25 - update trans set balance=80, needsrebal=0 where id=3189
56: 250470 - 2006-05-17, -24 - update trans set balance=56, needsrebal=0 where id=4925
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 3, 'M6CB', '250470', 56, '2005-10-21','2006-05-17');
1077: 250471 - 2005-10-19, 1077 - update trans set balance=1077, needsrebal=0 where id=3191
1053: 250471 - 2005-10-27, -24 - update trans set balance=1053, needsrebal=0 where id=3268
933: 250471 - 2005-11-07, -120 - update trans set balance=933, needsrebal=0 where id=3331
908: 250471 - 2005-11-11, -25 - update trans set balance=908, needsrebal=0 where id=3330
848: 250471 - 2005-11-11, -60 - update trans set balance=848, needsrebal=0 where id=3369
823: 250471 - 2005-11-11, -25 - update trans set balance=823, needsrebal=0 where id=3368
767: 250471 - 2005-11-15, -56 - update trans set balance=767, needsrebal=0 where id=3364
599: 250471 - 2005-11-16, -168 - update trans set balance=599, needsrebal=0 where id=3366
584: 250471 - 2005-11-17, -15 - update trans set balance=584, needsrebal=0 where id=3411
464: 250471 - 2005-11-28, -120 - update trans set balance=464, needsrebal=0 where id=3463
344: 250471 - 2005-11-28, -120 - update trans set balance=344, needsrebal=0 where id=3462
328: 250471 - 2005-12-01, -16 - update trans set balance=328, needsrebal=0 where id=3864
304: 250471 - 2005-12-01, -24 - update trans set balance=304, needsrebal=0 where id=3545
192: 250471 - 2005-12-01, -112 - update trans set balance=192, needsrebal=0 where id=3546
177: 250471 - 2005-12-06, -15 - update trans set balance=177, needsrebal=0 where id=3610
57: 250471 - 2005-12-09, -120 - update trans set balance=57, needsrebal=0 where id=3658
73: 250471 - 2005-12-21, 16 - update trans set balance=73, needsrebal=0 where id=3865
0: 250471 - 2005-12-29, -73 - update trans set balance=0, needsrebal=0 where id=3712
1077: 250638 - 2006-01-09, 1077 - update trans set balance=1077, needsrebal=0 where id=3831
897: 250638 - 2006-02-17, -180 - update trans set balance=897, needsrebal=0 where id=4228
896: 250638 - 2006-02-17, -1 - update trans set balance=896, needsrebal=0 where id=4247
656: 250638 - 2006-02-20, -240 - update trans set balance=656, needsrebal=0 where id=4227
600: 250638 - 2006-02-20, -56 - update trans set balance=600, needsrebal=0 where id=4238
500: 250638 - 2006-02-23, -100 - update trans set balance=500, needsrebal=0 where id=4226
388: 250638 - 2006-02-24, -112 - update trans set balance=388, needsrebal=0 where id=4244
363: 250638 - 2006-02-28, -25 - update trans set balance=363, needsrebal=0 where id=4325
346: 250638 - 2006-02-28, -17 - update trans set balance=346, needsrebal=0 where id=4321
286: 250638 - 2006-03-13, -60 - update trans set balance=286, needsrebal=0 where id=4481
346: 250638 - 2006-03-20, 60 - update trans set balance=346, needsrebal=0 where id=4600
226: 250638 - 2006-03-20, -120 - update trans set balance=226, needsrebal=0 where id=4418
170: 250638 - 2006-03-22, -56 - update trans set balance=170, needsrebal=0 where id=4435
60: 250638 - 2006-03-24, -110 - update trans set balance=60, needsrebal=0 where id=4459
0: 250638 - 2006-05-12, -60 - update trans set balance=0, needsrebal=0 where id=4805
845: 250639-1 - 2006-01-12, 845 - update trans set balance=845, needsrebal=0 where id=3984
844: 250639-1 - 2006-01-17, -1 - update trans set balance=844, needsrebal=0 where id=4165
788: 250639-1 - 2006-03-21, -56 - update trans set balance=788, needsrebal=0 where id=4442
728: 250639-1 - 2006-03-21, -60 - update trans set balance=728, needsrebal=0 where id=4443
672: 250639-1 - 2006-03-21, -56 - update trans set balance=672, needsrebal=0 where id=4445
504: 250639-1 - 2006-03-22, -168 - update trans set balance=504, needsrebal=0 where id=4469
494: 250639-1 - 2006-03-24, -10 - update trans set balance=494, needsrebal=0 where id=4460
438: 250639-1 - 2006-03-24, -56 - update trans set balance=438, needsrebal=0 where id=4490
382: 250639-1 - 2006-03-24, -56 - update trans set balance=382, needsrebal=0 where id=4486
202: 250639-1 - 2006-03-28, -180 - update trans set balance=202, needsrebal=0 where id=4496
146: 250639-1 - 2006-03-30, -56 - update trans set balance=146, needsrebal=0 where id=4515
90: 250639-1 - 2006-03-30, -56 - update trans set balance=90, needsrebal=0 where id=4516
142: 250639-1 - 2006-04-03, 52 - update trans set balance=142, needsrebal=0 where id=4549
126: 250639-1 - 2006-04-17, -16 - update trans set balance=126, needsrebal=0 where id=4552
118: 250639-1 - 2006-04-24, -8 - update trans set balance=118, needsrebal=0 where id=4579
49: 250639-1 - 2006-04-26, -69 - update trans set balance=49, needsrebal=0 where id=4741
0: 250639-1 - 2006-05-12, -49 - update trans set balance=0, needsrebal=0 where id=4806
1071: 3477 - 2005-01-01, 1071 - update trans set balance=1071, needsrebal=0 where id=729
1070: 3477 - 2005-03-31, -1 - update trans set balance=1070, needsrebal=0 where id=1118
1057: 3477 - 2005-04-04, -13 - update trans set balance=1057, needsrebal=0 where id=1301
967: 3477 - 2005-04-15, -90 - update trans set balance=967, needsrebal=0 where id=1220
877: 3477 - 2005-04-15, -90 - update trans set balance=877, needsrebal=0 where id=1208
787: 3477 - 2005-04-18, -90 - update trans set balance=787, needsrebal=0 where id=1202
697: 3477 - 2005-04-18, -90 - update trans set balance=697, needsrebal=0 where id=1214
695: 3477 - 2005-04-22, -2 - update trans set balance=695, needsrebal=0 where id=1865
693: 3477 - 2005-05-03, -2 - update trans set balance=693, needsrebal=0 where id=1436
603: 3477 - 2005-05-20, -90 - update trans set balance=603, needsrebal=0 where id=1687
587: 3477 - 2005-05-23, -16 - update trans set balance=587, needsrebal=0 where id=1697
583: 3477 - 2005-05-23, -4 - update trans set balance=583, needsrebal=0 where id=1783
550: 3477 - 2005-05-27, -33 - update trans set balance=550, needsrebal=0 where id=1716
545: 3477 - 2005-05-27, -5 - update trans set balance=545, needsrebal=0 where id=1706
514: 3477 - 2005-07-07, -31 - update trans set balance=514, needsrebal=0 where id=2054
513: 3477 - 2005-07-21, -1 - update trans set balance=513, needsrebal=0 where id=2236
511: 3477 - 2005-07-21, -2 - update trans set balance=511, needsrebal=0 where id=2264
508: 3477 - 2005-08-08, -3 - update trans set balance=508, needsrebal=0 where id=2400
493: 3477 - 2005-08-19, -15 - update trans set balance=493, needsrebal=0 where id=2490
444: 3477 - 2005-08-24, -49 - update trans set balance=444, needsrebal=0 where id=2474
354: 3477 - 2005-08-25, -90 - update trans set balance=354, needsrebal=0 where id=2507
279: 3477 - 2005-08-25, -75 - update trans set balance=279, needsrebal=0 where id=2536
189: 3477 - 2005-08-31, -90 - update trans set balance=189, needsrebal=0 where id=2559
174: 3477 - 2005-09-01, -15 - update trans set balance=174, needsrebal=0 where id=2554
69: 3477 - 2005-09-08, -105 - update trans set balance=69, needsrebal=0 where id=2630
3: 3477 - 2005-09-08, -66 - update trans set balance=3, needsrebal=0 where id=2623
0: 3477 - 2005-09-08, -3 - update trans set balance=0, needsrebal=0 where id=2604
780: 4096 - 2005-10-11, 780 - update trans set balance=780, needsrebal=0 where id=3049
758: 4096 - 2005-10-12, -22 - update trans set balance=758, needsrebal=0 where id=3062
733: 4096 - 2005-10-12, -25 - update trans set balance=733, needsrebal=0 where id=3057
708: 4096 - 2005-10-12, -25 - update trans set balance=708, needsrebal=0 where id=3061
707: 4096 - 2005-10-12, -1 - update trans set balance=707, needsrebal=0 where id=3084
527: 4096 - 2005-10-13, -180 - update trans set balance=527, needsrebal=0 where id=3053
507: 4096 - 2005-10-13, -20 - update trans set balance=507, needsrebal=0 where id=3082
357: 4096 - 2005-10-19, -150 - update trans set balance=357, needsrebal=0 where id=3078
284: 4096 - 2005-10-20, -73 - update trans set balance=284, needsrebal=0 where id=3089
194: 4096 - 2005-10-27, -90 - update trans set balance=194, needsrebal=0 where id=3206
164: 4096 - 2005-10-27, -30 - update trans set balance=164, needsrebal=0 where id=3218
156: 4096 - 2005-10-28, -8 - update trans set balance=156, needsrebal=0 where id=3297
155: 4096 - 2005-10-31, -1 - update trans set balance=155, needsrebal=0 where id=3307
80: 4096 - 2005-11-10, -75 - update trans set balance=80, needsrebal=0 where id=3325
42: 4096 - 2005-11-11, -38 - update trans set balance=42, needsrebal=0 where id=3376
39: 4096 - 2005-11-17, -3 - update trans set balance=39, needsrebal=0 where id=3379
37: 4096 - 2005-11-18, -2 - update trans set balance=37, needsrebal=0 where id=3452
0: 4096 - 2005-11-29, -37 - update trans set balance=0, needsrebal=0 where id=3516
1755: 4113 - 2005-11-14, 1755 - update trans set balance=1755, needsrebal=0 where id=3503
3510: 4113 - 2005-11-14, 1755 - update trans set balance=3510, needsrebal=0 where id=3750
3241: 4113 - 2005-11-28, -269 - update trans set balance=3241, needsrebal=0 where id=3506
3203: 4113 - 2005-11-29, -38 - update trans set balance=3203, needsrebal=0 where id=3517
2863: 4113 - 2005-11-30, -340 - update trans set balance=2863, needsrebal=0 where id=3540
2788: 4113 - 2005-12-01, -75 - update trans set balance=2788, needsrebal=0 where id=3559
2638: 4113 - 2005-12-01, -150 - update trans set balance=2638, needsrebal=0 where id=3560
2188: 4113 - 2005-12-02, -450 - update trans set balance=2188, needsrebal=0 where id=3755
2113: 4113 - 2005-12-08, -75 - update trans set balance=2113, needsrebal=0 where id=3635
2038: 4113 - 2005-12-09, -75 - update trans set balance=2038, needsrebal=0 where id=3574
2034: 4113 - 2005-12-19, -4 - update trans set balance=2034, needsrebal=0 where id=3726
1974: 4113 - 2005-12-21, -60 - update trans set balance=1974, needsrebal=0 where id=3740
1969: 4113 - 2005-12-21, -5 - update trans set balance=1969, needsrebal=0 where id=3752
1819: 4113 - 2005-12-27, -150 - update trans set balance=1819, needsrebal=0 where id=3770
1797: 4113 - 2005-12-27, -22 - update trans set balance=1797, needsrebal=0 where id=3766
1769: 4113 - 2005-12-27, -28 - update trans set balance=1769, needsrebal=0 where id=3763
1759: 4113 - 2006-01-03, -10 - update trans set balance=1759, needsrebal=0 where id=3810
1755: 4113 - 2006-01-04, -4 - update trans set balance=1755, needsrebal=0 where id=3841
0: 4113 - 2006-01-06, -1755 - update trans set balance=0, needsrebal=0 where id=3887
1500: 4154 - 2005-12-28, 1500 - update trans set balance=1500, needsrebal=0 where id=3828
1400: 4154 - 2006-01-04, -100 - update trans set balance=1400, needsrebal=0 where id=3842
1399: 4154 - 2006-01-04, -1 - update trans set balance=1399, needsrebal=0 where id=3861
1324: 4154 - 2006-01-13, -75 - update trans set balance=1324, needsrebal=0 where id=3958
1319: 4154 - 2006-01-16, -5 - update trans set balance=1319, needsrebal=0 where id=3972
1244: 4154 - 2006-01-30, -75 - update trans set balance=1244, needsrebal=0 where id=4071
1229: 4154 - 2006-01-30, -15 - update trans set balance=1229, needsrebal=0 where id=4049
1228: 4154 - 2006-01-30, -1 - update trans set balance=1228, needsrebal=0 where id=4077
1203: 4154 - 2006-02-03, -25 - update trans set balance=1203, needsrebal=0 where id=4132
1173: 4154 - 2006-02-10, -30 - update trans set balance=1173, needsrebal=0 where id=4169
1098: 4154 - 2006-02-16, -75 - update trans set balance=1098, needsrebal=0 where id=4178
1068: 4154 - 2006-02-16, -30 - update trans set balance=1068, needsrebal=0 where id=4212
993: 4154 - 2006-02-24, -75 - update trans set balance=993, needsrebal=0 where id=4306
991: 4154 - 2006-03-10, -2 - update trans set balance=991, needsrebal=0 where id=4406
976: 4154 - 2006-03-21, -15 - update trans set balance=976, needsrebal=0 where id=4293
926: 4154 - 2006-03-21, -50 - update trans set balance=926, needsrebal=0 where id=4478
851: 4154 - 2006-03-21, -75 - update trans set balance=851, needsrebal=0 where id=4417
846: 4154 - 2006-03-22, -5 - update trans set balance=846, needsrebal=0 where id=4475
801: 4154 - 2006-03-24, -45 - update trans set balance=801, needsrebal=0 where id=4489
800: 4154 - 2006-03-28, -1 - update trans set balance=800, needsrebal=0 where id=4493
798: 4154 - 2006-03-29, -2 - update trans set balance=798, needsrebal=0 where id=4505
768: 4154 - 2006-04-05, -30 - update trans set balance=768, needsrebal=0 where id=4624
738: 4154 - 2006-04-05, -30 - update trans set balance=738, needsrebal=0 where id=4617
723: 4154 - 2006-04-05, -15 - update trans set balance=723, needsrebal=0 where id=4619
648: 4154 - 2006-04-07, -75 - update trans set balance=648, needsrebal=0 where id=4656
618: 4154 - 2006-04-07, -30 - update trans set balance=618, needsrebal=0 where id=4612
588: 4154 - 2006-04-20, -30 - update trans set balance=588, needsrebal=0 where id=4571
616: 4154 - 2006-04-25, 28 - update trans set balance=616, needsrebal=0 where id=4727
601: 4154 - 2006-04-25, -15 - update trans set balance=601, needsrebal=0 where id=4575
586: 4154 - 2006-05-09, -15 - update trans set balance=586, needsrebal=0 where id=4809
511: 4154 - 2006-05-18, -75 - update trans set balance=511, needsrebal=0 where id=4824
436: 4154 - 2006-05-19, -75 - update trans set balance=436, needsrebal=0 where id=4825
432: 4154 - 2006-05-19, -4 - update trans set balance=432, needsrebal=0 where id=4845
430: 4154 - 2006-05-30, -2 - update trans set balance=430, needsrebal=0 where id=4897
355: 4154 - 2006-05-30, -75 - update trans set balance=355, needsrebal=0 where id=4886
325: 4154 - 2006-06-02, -30 - update trans set balance=325, needsrebal=0 where id=4904
323: 4154 - 2006-06-27, -2 - update trans set balance=323, needsrebal=0 where id=4970
248: 4154 - 2006-06-29, -75 - update trans set balance=248, needsrebal=0 where id=4960
247: 4154 - 2006-07-13, -1 - update trans set balance=247, needsrebal=0 where id=4995
97: 4154 - 2006-07-25, -150 - update trans set balance=97, needsrebal=0 where id=5007
95: 4154 - 2006-08-08, -2 - update trans set balance=95, needsrebal=0 where id=5033
20: 4154 - 2006-08-09, -75 - update trans set balance=20, needsrebal=0 where id=5032
18: 4154 - 2006-08-23, -2 - update trans set balance=18, needsrebal=0 where id=5076
2: 4154 - 2006-08-24, -16 - update trans set balance=2, needsrebal=0 where id=5057
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 27, 'RR12CKRICE', '4154', 2, '2005-12-28','2006-08-24');
236: 3459 - 2005-01-01, 236 - update trans set balance=236, needsrebal=0 where id=732
235: 3459 - 2005-01-03, -1 - update trans set balance=235, needsrebal=0 where id=358
165: 3459 - 2005-01-07, -70 - update trans set balance=165, needsrebal=0 where id=300
163: 3459 - 2005-01-26, -2 - update trans set balance=163, needsrebal=0 where id=108
160: 3459 - 2005-01-31, -3 - update trans set balance=160, needsrebal=0 where id=66
159: 3459 - 2005-02-01, -1 - update trans set balance=159, needsrebal=0 where id=1538
158: 3459 - 2005-02-08, -1 - update trans set balance=158, needsrebal=0 where id=611
78: 3459 - 2005-02-15, -80 - update trans set balance=78, needsrebal=0 where id=569
77: 3459 - 2005-02-17, -1 - update trans set balance=77, needsrebal=0 where id=551
76: 3459 - 2005-02-25, -1 - update trans set balance=76, needsrebal=0 where id=478
71: 3459 - 2005-03-09, -5 - update trans set balance=71, needsrebal=0 where id=1141
69: 3459 - 2005-03-22, -2 - update trans set balance=69, needsrebal=0 where id=989
67: 3459 - 2005-05-09, -2 - update trans set balance=67, needsrebal=0 where id=1494
0: 3459 - 2005-05-20, -67 - update trans set balance=0, needsrebal=0 where id=1688
280: 3535 - 2005-02-21, 280 - update trans set balance=280, needsrebal=0 where id=733
267: 3535 - 2005-05-20, -13 - update trans set balance=267, needsrebal=0 where id=1689
262: 3535 - 2005-05-23, -5 - update trans set balance=262, needsrebal=0 where id=1776
258: 3535 - 2005-06-06, -4 - update trans set balance=258, needsrebal=0 where id=1761
256: 3535 - 2005-06-30, -2 - update trans set balance=256, needsrebal=0 where id=1976
176: 3535 - 2005-07-28, -80 - update trans set balance=176, needsrebal=0 where id=2180
170: 3535 - 2005-09-13, -6 - update trans set balance=170, needsrebal=0 where id=2633
169: 3535 - 2005-10-28, -1 - update trans set balance=169, needsrebal=0 where id=3294
149: 3535 - 2005-11-14, -20 - update trans set balance=149, needsrebal=0 where id=3384
145: 3535 - 2005-12-19, -4 - update trans set balance=145, needsrebal=0 where id=3720
65: 3535 - 2005-12-29, -80 - update trans set balance=65, needsrebal=0 where id=3816
55: 3535 - 2006-01-04, -10 - update trans set balance=55, needsrebal=0 where id=3860
0: 3535 - 2006-02-22, -55 - update trans set balance=0, needsrebal=0 where id=4235
211: 4004 - 2005-03-21, 211 - update trans set balance=211, needsrebal=0 where id=1162
201: 4004 - 2005-11-10, -10 - update trans set balance=201, needsrebal=0 where id=3363
199: 4004 - 2006-02-20, -2 - update trans set balance=199, needsrebal=0 where id=4242
154: 4004 - 2006-02-22, -45 - update trans set balance=154, needsrebal=0 where id=4236
151: 4004 - 2006-03-22, -3 - update trans set balance=151, needsrebal=0 where id=4470
149: 4004 - 2006-03-30, -2 - update trans set balance=149, needsrebal=0 where id=4523
89: 4004 - 2006-04-25, -60 - update trans set balance=89, needsrebal=0 where id=4719
88: 4004 - 2006-05-01, -1 - update trans set balance=88, needsrebal=0 where id=4780
84: 4004 - 2006-06-28, -4 - update trans set balance=84, needsrebal=0 where id=4977
79: 4004 - 2006-09-18, -5 - update trans set balance=79, needsrebal=0 where id=5092
85: 4004 - 2006-10-19, 6 - update trans set balance=85, needsrebal=0 where id=5139
55: 4004 - 2006-10-19, -30 - update trans set balance=55, needsrebal=0 where id=5140
2: 4004 - 2006-10-20, -53 - update trans set balance=2, needsrebal=0 where id=5141
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 29, 'RR5BFCHIL4', '4004', 2, '2005-03-21','2006-10-20');
140: #4067 - 2005-09-27, 140 - update trans set balance=140, needsrebal=0 where id=2689
102: #4067 - 2006-10-23, -38 - update trans set balance=102, needsrebal=0 where id=5148
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 30, 'RR5BFSTEW', '#4067', 102, '2005-09-27','2006-10-23');
74: 3168 - 2005-01-01, 74 - update trans set balance=74, needsrebal=0 where id=798
73: 3168 - 2005-01-03, -1 - update trans set balance=73, needsrebal=0 where id=359
70: 3168 - 2005-01-03, -3 - update trans set balance=70, needsrebal=0 where id=346
0: 3168 - 2005-01-07, -70 - update trans set balance=0, needsrebal=0 where id=301
139: 3457 - 2004-11-18, 139 - update trans set balance=139, needsrebal=0 where id=746
91: 3457 - 2005-01-07, -48 - update trans set balance=91, needsrebal=0 where id=423
79: 3457 - 2005-01-17, -12 - update trans set balance=79, needsrebal=0 where id=194
75: 3457 - 2005-01-26, -4 - update trans set balance=75, needsrebal=0 where id=109
72: 3457 - 2005-01-31, -3 - update trans set balance=72, needsrebal=0 where id=67
71: 3457 - 2005-02-25, -1 - update trans set balance=71, needsrebal=0 where id=479
63: 3457 - 2005-03-09, -8 - update trans set balance=63, needsrebal=0 where id=1138
61: 3457 - 2005-03-22, -2 - update trans set balance=61, needsrebal=0 where id=990
58: 3457 - 2005-04-28, -3 - update trans set balance=58, needsrebal=0 where id=1403
56: 3457 - 2005-05-09, -2 - update trans set balance=56, needsrebal=0 where id=1493
55: 3457 - 2005-05-09, -1 - update trans set balance=55, needsrebal=0 where id=1506
54: 3457 - 2005-05-16, -1 - update trans set balance=54, needsrebal=0 where id=1620
49: 3457 - 2005-05-23, -5 - update trans set balance=49, needsrebal=0 where id=1775
42: 3457 - 2005-06-06, -7 - update trans set balance=42, needsrebal=0 where id=1763
40: 3457 - 2005-06-30, -2 - update trans set balance=40, needsrebal=0 where id=1975
38: 3457 - 2005-08-29, -2 - update trans set balance=38, needsrebal=0 where id=2542
34: 3457 - 2005-09-13, -4 - update trans set balance=34, needsrebal=0 where id=2634
33: 3457 - 2005-09-20, -1 - update trans set balance=33, needsrebal=0 where id=2728
29: 3457 - 2005-10-25, -4 - update trans set balance=29, needsrebal=0 where id=3210
27: 3457 - 2005-10-28, -2 - update trans set balance=27, needsrebal=0 where id=3293
14: 3457 - 2005-11-10, -13 - update trans set balance=14, needsrebal=0 where id=3361
11: 3457 - 2005-12-19, -3 - update trans set balance=11, needsrebal=0 where id=3721
3: 3457 - 2006-01-04, -8 - update trans set balance=3, needsrebal=0 where id=3859
0: 3457 - 2006-02-22, -3 - update trans set balance=0, needsrebal=0 where id=4232
280: 3534 - 2005-01-01, 280 - update trans set balance=280, needsrebal=0 where id=745
260: 3534 - 2005-11-14, -20 - update trans set balance=260, needsrebal=0 where id=3383
132: 3534 - 2006-02-22, -128 - update trans set balance=132, needsrebal=0 where id=4233
82: 3534 - 2006-03-21, -50 - update trans set balance=82, needsrebal=0 where id=4440
80: 3534 - 2006-03-22, -2 - update trans set balance=80, needsrebal=0 where id=4471
78: 3534 - 2006-03-30, -2 - update trans set balance=78, needsrebal=0 where id=4524
73: 3534 - 2006-04-25, -5 - update trans set balance=73, needsrebal=0 where id=4717
71: 3534 - 2006-05-30, -2 - update trans set balance=71, needsrebal=0 where id=4893
66: 3534 - 2006-09-18, -5 - update trans set balance=66, needsrebal=0 where id=5093
0: 3534 - 2006-10-20, -66 - update trans set balance=0, needsrebal=0 where id=5142
49: 4005 - 2005-03-21, 49 - update trans set balance=49, needsrebal=0 where id=1130
0: 4005 - 2006-02-22, -49 - update trans set balance=0, needsrebal=0 where id=4234
3120: 240295 - 2004-10-21, 3120 - update trans set balance=3120, needsrebal=0 where id=768
2520: 240295 - 2005-01-13, -600 - update trans set balance=2520, needsrebal=0 where id=246
1760: 240295 - 2005-01-25, -760 - update trans set balance=1760, needsrebal=0 where id=118
1640: 240295 - 2005-01-27, -120 - update trans set balance=1640, needsrebal=0 where id=93
1450: 240295 - 2005-02-10, -190 - update trans set balance=1450, needsrebal=0 where id=590
1070: 240295 - 2005-03-11, -380 - update trans set balance=1070, needsrebal=0 where id=830
700: 240295 - 2005-04-04, -370 - update trans set balance=700, needsrebal=0 where id=1349
480: 240295 - 2005-04-12, -220 - update trans set balance=480, needsrebal=0 where id=1289
0: 240295 - 2005-04-20, -480 - update trans set balance=0, needsrebal=0 where id=1171
4000: 240807 - 2005-03-28, 4000 - update trans set balance=4000, needsrebal=0 where id=935
3720: 240807 - 2005-04-20, -280 - update trans set balance=3720, needsrebal=0 where id=1172
3150: 240807 - 2005-05-11, -570 - update trans set balance=3150, needsrebal=0 where id=1556
3152: 240807 - 2005-05-12, 2 - update trans set balance=3152, needsrebal=0 where id=1795
3042: 240807 - 2005-05-23, -110 - update trans set balance=3042, needsrebal=0 where id=1600
2092: 240807 - 2005-06-02, -950 - update trans set balance=2092, needsrebal=0 where id=1675
1092: 240807 - 2005-06-06, -1000 - update trans set balance=1092, needsrebal=0 where id=1758
332: 240807 - 2005-06-29, -760 - update trans set balance=332, needsrebal=0 where id=1943
0: 240807 - 2005-07-14, -332 - update trans set balance=0, needsrebal=0 where id=2142
3998: 240809 - 2005-05-09, 3998 - update trans set balance=3998, needsrebal=0 where id=1168
3570: 240809 - 2005-07-14, -428 - update trans set balance=3570, needsrebal=0 where id=2143
3190: 240809 - 2005-07-15, -380 - update trans set balance=3190, needsrebal=0 where id=2129
2620: 240809 - 2005-08-04, -570 - update trans set balance=2620, needsrebal=0 where id=2242
2400: 240809 - 2005-08-08, -220 - update trans set balance=2400, needsrebal=0 where id=2357
2390: 240809 - 2005-08-19, -10 - update trans set balance=2390, needsrebal=0 where id=2495
1440: 240809 - 2005-08-25, -950 - update trans set balance=1440, needsrebal=0 where id=2471
490: 240809 - 2005-09-15, -950 - update trans set balance=490, needsrebal=0 where id=2668
444: 240809 - 2005-10-13, -46 - update trans set balance=444, needsrebal=0 where id=3195
0: 240809 - 2005-10-13, -444 - update trans set balance=0, needsrebal=0 where id=3079
4000: 250538 - 2006-01-13, 4000 - update trans set balance=4000, needsrebal=0 where id=3999
2860: 250538 - 2006-01-19, -1140 - update trans set balance=2860, needsrebal=0 where id=4007
1910: 250538 - 2006-01-30, -950 - update trans set balance=1910, needsrebal=0 where id=4069
1720: 250538 - 2006-02-14, -190 - update trans set balance=1720, needsrebal=0 where id=4171
1340: 250538 - 2006-02-14, -380 - update trans set balance=1340, needsrebal=0 where id=4202
960: 250538 - 2006-03-21, -380 - update trans set balance=960, needsrebal=0 where id=4214
580: 250538 - 2006-03-21, -380 - update trans set balance=580, needsrebal=0 where id=4311
120: 250538 - 2006-03-21, -460 - update trans set balance=120, needsrebal=0 where id=4310
0: 250538 - 2006-06-29, -120 - update trans set balance=0, needsrebal=0 where id=4978
483: #4044 - 2005-06-28, 483 - update trans set balance=483, needsrebal=0 where id=2065
430: #4044 - 2006-01-12, -53 - update trans set balance=430, needsrebal=0 where id=3944
355: #4044 - 2006-02-16, -75 - update trans set balance=355, needsrebal=0 where id=4215
280: #4044 - 2006-03-15, -75 - update trans set balance=280, needsrebal=0 where id=4421
220: #4044 - 2006-03-21, -60 - update trans set balance=220, needsrebal=0 where id=4441
193: #4044 - 2006-04-25, -27 - update trans set balance=193, needsrebal=0 where id=4724
83: #4044 - 2006-04-25, -110 - update trans set balance=83, needsrebal=0 where id=4702
82: #4044 - 2006-05-01, -1 - update trans set balance=82, needsrebal=0 where id=4782
80: #4044 - 2006-05-30, -2 - update trans set balance=80, needsrebal=0 where id=4894
40: #4044 - 2006-09-12, -40 - update trans set balance=40, needsrebal=0 where id=5089
0: #4044 - 2006-09-14, -40 - update trans set balance=0, needsrebal=0 where id=5075
89: #4066 - 2005-09-27, 89 - update trans set balance=89, needsrebal=0 where id=2688
154: #4066 - 2005-10-11, 65 - update trans set balance=154, needsrebal=0 where id=3130
89: #4066 - 2005-10-11, -65 - update trans set balance=89, needsrebal=0 where id=2936
0: #4066 - 2006-01-12, -89 - update trans set balance=0, needsrebal=0 where id=3943
98: 3306 - 2005-01-01, 98 - update trans set balance=98, needsrebal=0 where id=786
97: 3306 - 2005-01-03, -1 - update trans set balance=97, needsrebal=0 where id=360
27: 3306 - 2005-01-07, -70 - update trans set balance=27, needsrebal=0 where id=302
25: 3306 - 2005-01-17, -2 - update trans set balance=25, needsrebal=0 where id=195
0: 3306 - 2005-01-25, -25 - update trans set balance=0, needsrebal=0 where id=114
385: 4003 - 2005-03-21, 385 - update trans set balance=385, needsrebal=0 where id=1091
380: 4003 - 2005-03-22, -5 - update trans set balance=380, needsrebal=0 where id=1095
235: 4003 - 2005-03-30, -145 - update trans set balance=235, needsrebal=0 where id=1094
230: 4003 - 2005-04-11, -5 - update trans set balance=230, needsrebal=0 where id=1541
227: 4003 - 2005-04-28, -3 - update trans set balance=227, needsrebal=0 where id=1404
225: 4003 - 2005-05-09, -2 - update trans set balance=225, needsrebal=0 where id=1495
224: 4003 - 2005-05-09, -1 - update trans set balance=224, needsrebal=0 where id=1505
221: 4003 - 2005-05-23, -3 - update trans set balance=221, needsrebal=0 where id=1774
171: 4003 - 2005-06-27, -50 - update trans set balance=171, needsrebal=0 where id=1973
121: 4003 - 2005-06-29, -50 - update trans set balance=121, needsrebal=0 where id=1988
171: 4003 - 2005-06-30, 50 - update trans set balance=171, needsrebal=0 where id=2047
169: 4003 - 2005-06-30, -2 - update trans set balance=169, needsrebal=0 where id=1977
162: 4003 - 2005-07-29, -7 - update trans set balance=162, needsrebal=0 where id=2509
112: 4003 - 2005-08-05, -50 - update trans set balance=112, needsrebal=0 where id=2123
110: 4003 - 2005-09-13, -2 - update trans set balance=110, needsrebal=0 where id=2632
60: 4003 - 2005-09-13, -50 - update trans set balance=60, needsrebal=0 where id=2652
70: 4003 - 2005-10-11, 10 - update trans set balance=70, needsrebal=0 where id=3129
60: 4003 - 2005-10-11, -10 - update trans set balance=60, needsrebal=0 where id=2935
58: 4003 - 2005-12-19, -2 - update trans set balance=58, needsrebal=0 where id=3722
50: 4003 - 2006-01-12, -8 - update trans set balance=50, needsrebal=0 where id=3942
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 33, 'RR5BFTIP', '4003', 50, '2005-03-21','2006-01-12');
186: 3478 - 2005-01-01, 186 - update trans set balance=186, needsrebal=0 where id=739
185: 3478 - 2005-01-20, -1 - update trans set balance=185, needsrebal=0 where id=154
183: 3478 - 2005-08-08, -2 - update trans set balance=183, needsrebal=0 where id=2406
0: 3478 - 2006-02-16, -183 - update trans set balance=0, needsrebal=0 where id=4213
122: 3071 - 2005-01-01, 122 - update trans set balance=122, needsrebal=0 where id=720
121: 3071 - 2005-01-03, -1 - update trans set balance=121, needsrebal=0 where id=361
51: 3071 - 2005-01-07, -70 - update trans set balance=51, needsrebal=0 where id=303
49: 3071 - 2005-05-09, -2 - update trans set balance=49, needsrebal=0 where id=1496
48: 3071 - 2005-05-09, -1 - update trans set balance=48, needsrebal=0 where id=1511
46: 3071 - 2005-05-23, -2 - update trans set balance=46, needsrebal=0 where id=1778
45: 3071 - 2005-06-30, -1 - update trans set balance=45, needsrebal=0 where id=1978
47: 3071 - 2005-10-14, 2 - update trans set balance=47, needsrebal=0 where id=3042
0: 3071 - 2006-02-22, -47 - update trans set balance=0, needsrebal=0 where id=3044
243: 3106 - 2005-01-01, 243 - update trans set balance=243, needsrebal=0 where id=723
0: 3106 - 2006-02-22, -243 - update trans set balance=0, needsrebal=0 where id=3045
450: 3461 - 2004-11-18, 450 - update trans set balance=450, needsrebal=0 where id=738
0: 3461 - 2006-02-22, -450 - update trans set balance=0, needsrebal=0 where id=3046
60: #4069 - 2005-09-27, 60 - update trans set balance=60, needsrebal=0 where id=2691
0: #4069 - 2005-11-21, -60 - update trans set balance=0, needsrebal=0 where id=3373
513: #4087 - 2005-09-21, 513 - update trans set balance=513, needsrebal=0 where id=2684
373: #4087 - 2005-11-21, -140 - update trans set balance=373, needsrebal=0 where id=3374
173: #4087 - 2006-01-13, -200 - update trans set balance=173, needsrebal=0 where id=3817
153: #4087 - 2006-02-02, -20 - update trans set balance=153, needsrebal=0 where id=4173
0: #4087 - 2006-02-15, -153 - update trans set balance=0, needsrebal=0 where id=4174
80: 3475 - 2004-12-08, 80 - update trans set balance=80, needsrebal=0 where id=785
0: 3475 - 2005-01-04, -80 - update trans set balance=0, needsrebal=0 where id=328
36: 4155 - 2005-12-28, 36 - update trans set balance=36, needsrebal=0 where id=3829
0: 4155 - 2006-02-15, -36 - update trans set balance=0, needsrebal=0 where id=4175
287: 240260 - 2005-01-01, 287 - update trans set balance=287, needsrebal=0 where id=753
97: 240260 - 2005-01-03, -190 - update trans set balance=97, needsrebal=0 where id=351
0: 240260 - 2005-04-25, -97 - update trans set balance=0, needsrebal=0 where id=1235
4200: 240261 - 2005-01-01, 4200 - update trans set balance=4200, needsrebal=0 where id=750
700: 240261 - 2005-01-04, -3500 - update trans set balance=700, needsrebal=0 where id=336
417: 240261 - 2005-04-25, -283 - update trans set balance=417, needsrebal=0 where id=1236
416: 240261 - 2005-05-09, -1 - update trans set balance=416, needsrebal=0 where id=1489
383: 240261 - 2005-05-12, -33 - update trans set balance=383, needsrebal=0 where id=1792
193: 240261 - 2005-05-25, -190 - update trans set balance=193, needsrebal=0 where id=1646
0: 240261 - 2005-07-23, -193 - update trans set balance=0, needsrebal=0 where id=2260
Go