'1_10_230747B', '1_10_240693', '1_10_240696', '1_10_240811', '1_10_240982', '1_10_240985', '1_10_250050', '1_10_250103', '1_10_250104', '1_10_250482', '1_10_250588', '1_10_250590', '1_11_230750B', '1_11_240694', '1_11_240697', '1_11_240812', '1_11_240983', '1_11_240986', '1_11_250051', '1_11_250104', '1_11_250585', '1_11_25103', '1_12_--Select Marknum--', '1_12_230744F', '1_12_240695', '1_12_240698', '1_12_240813', '1_12_240984', '1_12_240987', '1_12_250052', '1_12_250104', '1_12_250105', '1_12_250487', '1_12_250582', '1_12_3458', '1_12_Select Marknum', '1_13_240420BM', '1_13_240421BM', '1_13_240580BM', '1_13_240600', '1_13_250335', '1_13_250639-2', '1_13_250682', '1_13_250684', '1_13_250684BM', '1_14_#3460', '1_14_3076'
16: 230747B - 2005-01-01, 16 - update trans set balance=16, needsrebal=0 where id=781
0: 230747B - 2005-01-13, -16 - update trans set balance=0, needsrebal=0 where id=252
1530: 240693 - 2005-01-13, 1530 - update trans set balance=1530, needsrebal=0 where id=13
1130: 240693 - 2005-01-13, -400 - update trans set balance=1130, needsrebal=0 where id=249
596: 240693 - 2005-01-13, -534 - update trans set balance=596, needsrebal=0 where id=421
296: 240693 - 2005-01-13, -300 - update trans set balance=296, needsrebal=0 where id=231
86: 240693 - 2005-01-20, -210 - update trans set balance=86, needsrebal=0 where id=150
26: 240693 - 2005-01-25, -60 - update trans set balance=26, needsrebal=0 where id=117
0: 240693 - 2005-02-18, -26 - update trans set balance=0, needsrebal=0 where id=534
1530: 240696 - 2005-02-14, 1530 - update trans set balance=1530, needsrebal=0 where id=379
536: 240696 - 2005-02-18, -994 - update trans set balance=536, needsrebal=0 where id=533
26: 240696 - 2005-02-18, -510 - update trans set balance=26, needsrebal=0 where id=532
0: 240696 - 2005-03-23, -26 - update trans set balance=0, needsrebal=0 where id=984
1530: 240811 - 2005-03-15, 1530 - update trans set balance=1530, needsrebal=0 where id=719
536: 240811 - 2005-03-23, -994 - update trans set balance=536, needsrebal=0 where id=985
36: 240811 - 2005-04-04, -500 - update trans set balance=36, needsrebal=0 where id=1368
0: 240811 - 2005-06-15, -36 - update trans set balance=0, needsrebal=0 where id=1885
1528: 240982 - 2005-05-09, 1528 - update trans set balance=1528, needsrebal=0 where id=1334
1018: 240982 - 2005-06-15, -510 - update trans set balance=1018, needsrebal=0 where id=3172
385: 240982 - 2005-06-15, -633 - update trans set balance=385, needsrebal=0 where id=1886
35: 240982 - 2005-06-16, -350 - update trans set balance=35, needsrebal=0 where id=1880
0: 240982 - 2005-07-14, -35 - update trans set balance=0, needsrebal=0 where id=3171
33: 240982 - 2005-07-17, 33 - update trans set balance=33, needsrebal=0 where id=2262
0: 240982 - 2005-07-25, -33 - update trans set balance=0, needsrebal=0 where id=2275
1529: 240985 - 2005-06-15, 1529 - update trans set balance=1529, needsrebal=0 where id=1862
924: 240985 - 2005-07-14, -605 - update trans set balance=924, needsrebal=0 where id=2145
565: 240985 - 2005-07-15, -359 - update trans set balance=565, needsrebal=0 where id=2133
0: 240985 - 2005-07-19, -565 - update trans set balance=0, needsrebal=0 where id=2146
1525: 250050 - 2005-06-28, 1525 - update trans set balance=1525, needsrebal=0 where id=1902
995: 250050 - 2005-07-19, -530 - update trans set balance=995, needsrebal=0 where id=2223
678: 250050 - 2005-07-25, -317 - update trans set balance=678, needsrebal=0 where id=2276
28: 250050 - 2005-08-04, -650 - update trans set balance=28, needsrebal=0 where id=2241
26: 250050 - 2005-08-08, -2 - update trans set balance=26, needsrebal=0 where id=2405
676: 250050 - 2005-08-09, 650 - update trans set balance=676, needsrebal=0 where id=2451
650: 250050 - 2005-08-09, -26 - update trans set balance=650, needsrebal=0 where id=3141
0: 250050 - 2005-09-01, -650 - update trans set balance=0, needsrebal=0 where id=2938
1526: 250103 - 2005-11-08, 1526 - update trans set balance=1526, needsrebal=0 where id=3320
3032: 250103 - 2005-11-08, 1506 - update trans set balance=3032, needsrebal=0 where id=4255
2973: 250103 - 2005-11-09, -59 - update trans set balance=2973, needsrebal=0 where id=3891
1873: 250103 - 2005-11-23, -1100 - update trans set balance=1873, needsrebal=0 where id=3890
1506: 250103 - 2005-11-29, -367 - update trans set balance=1506, needsrebal=0 where id=3889
1106: 250103 - 2006-02-06, -400 - update trans set balance=1106, needsrebal=0 where id=4257
0: 250103 - 2006-02-16, -1106 - update trans set balance=0, needsrebal=0 where id=4258
370: 250104 - 2005-07-22, 370 - update trans set balance=370, needsrebal=0 where id=2979
337: 250104 - 2005-08-31, -33 - update trans set balance=337, needsrebal=0 where id=3143
0: 250104 - 2005-09-01, -337 - update trans set balance=0, needsrebal=0 where id=3142
1429: 250482 - 2006-02-21, 1429 - update trans set balance=1429, needsrebal=0 where id=3345
29: 250482 - 2006-02-23, -1400 - update trans set balance=29, needsrebal=0 where id=4297
0: 250482 - 2006-04-28, -29 - update trans set balance=0, needsrebal=0 where id=4787
1530: 250588 - 2006-01-30, 1530 - update trans set balance=1530, needsrebal=0 where id=4006
630: 250588 - 2006-02-01, -900 - update trans set balance=630, needsrebal=0 where id=4260
628: 250588 - 2006-02-15, -2 - update trans set balance=628, needsrebal=0 where id=4251
625: 250588 - 2006-02-15, -3 - update trans set balance=625, needsrebal=0 where id=4254
331: 250588 - 2006-02-16, -294 - update trans set balance=331, needsrebal=0 where id=4259
131: 250588 - 2006-03-02, -200 - update trans set balance=131, needsrebal=0 where id=4348
113: 250588 - 2006-04-25, -18 - update trans set balance=113, needsrebal=0 where id=4723
0: 250588 - 2006-04-28, -113 - update trans set balance=0, needsrebal=0 where id=4786
1473: 250590 - 2006-01-23, 1473 - update trans set balance=1473, needsrebal=0 where id=4785
215: 250590 - 2006-04-28, -1258 - update trans set balance=215, needsrebal=0 where id=4788
212: 250590 - 2006-05-19, -3 - update trans set balance=212, needsrebal=0 where id=4848
210: 250590 - 2006-05-30, -2 - update trans set balance=210, needsrebal=0 where id=4895
78: 250590 - 2006-06-13, -132 - update trans set balance=78, needsrebal=0 where id=4937
0: 250590 - 2006-06-28, -78 - update trans set balance=0, needsrebal=0 where id=4974
14: 230750B - 2005-01-01, 14 - update trans set balance=14, needsrebal=0 where id=784
0: 230750B - 2005-01-13, -14 - update trans set balance=0, needsrebal=0 where id=251
1530: 240694 - 2005-01-10, 1530 - update trans set balance=1530, needsrebal=0 where id=14
1230: 240694 - 2005-01-13, -300 - update trans set balance=1230, needsrebal=0 where id=248
754: 240694 - 2005-01-13, -476 - update trans set balance=754, needsrebal=0 where id=420
354: 240694 - 2005-01-13, -400 - update trans set balance=354, needsrebal=0 where id=230
234: 240694 - 2005-01-25, -120 - update trans set balance=234, needsrebal=0 where id=116
0: 240694 - 2005-02-09, -234 - update trans set balance=0, needsrebal=0 where id=598
1530: 240697 - 2005-02-03, 1530 - update trans set balance=1530, needsrebal=0 where id=778
447: 240697 - 2005-02-09, -1083 - update trans set balance=447, needsrebal=0 where id=597
446: 240697 - 2005-03-28, -1 - update trans set balance=446, needsrebal=0 where id=1535
445: 240697 - 2005-03-30, -1 - update trans set balance=445, needsrebal=0 where id=971
313: 240697 - 2005-04-13, -132 - update trans set balance=313, needsrebal=0 where id=1271
181: 240697 - 2005-04-13, -132 - update trans set balance=181, needsrebal=0 where id=1225
49: 240697 - 2005-04-18, -132 - update trans set balance=49, needsrebal=0 where id=1232
48: 240697 - 2005-04-21, -1 - update trans set balance=48, needsrebal=0 where id=1536
0: 240697 - 2005-06-28, -48 - update trans set balance=0, needsrebal=0 where id=1967
1530: 240812 - 2005-03-16, 1530 - update trans set balance=1530, needsrebal=0 where id=716
1398: 240812 - 2005-06-14, -132 - update trans set balance=1398, needsrebal=0 where id=1816
1380: 240812 - 2005-06-28, -18 - update trans set balance=1380, needsrebal=0 where id=1968
1379: 240812 - 2005-07-01, -1 - update trans set balance=1379, needsrebal=0 where id=2014
839: 240812 - 2005-07-11, -540 - update trans set balance=839, needsrebal=0 where id=2140
773: 240812 - 2005-07-13, -66 - update trans set balance=773, needsrebal=0 where id=2121
623: 240812 - 2005-07-15, -150 - update trans set balance=623, needsrebal=0 where id=2171
323: 240812 - 2005-07-15, -300 - update trans set balance=323, needsrebal=0 where id=2134
321: 240812 - 2005-08-08, -2 - update trans set balance=321, needsrebal=0 where id=2404
246: 240812 - 2005-08-11, -75 - update trans set balance=246, needsrebal=0 where id=2432
180: 240812 - 2005-09-27, -66 - update trans set balance=180, needsrebal=0 where id=2771
114: 240812 - 2005-10-21, -66 - update trans set balance=114, needsrebal=0 where id=3123
0: 240812 - 2005-11-21, -114 - update trans set balance=0, needsrebal=0 where id=3472
1505: 240983 - 2005-04-11, 1505 - update trans set balance=1505, needsrebal=0 where id=938
1487: 240983 - 2005-11-21, -18 - update trans set balance=1487, needsrebal=0 where id=3473
1286: 240983 - 2005-11-28, -201 - update trans set balance=1286, needsrebal=0 where id=3513
269: 240983 - 2005-12-02, -1017 - update trans set balance=269, needsrebal=0 where id=3557
29: 240983 - 2005-12-09, -240 - update trans set balance=29, needsrebal=0 where id=3579
0: 240983 - 2005-12-15, -29 - update trans set balance=0, needsrebal=0 where id=3660
1529: 240986 - 2005-05-26, 1529 - update trans set balance=1529, needsrebal=0 where id=1863
1379: 240986 - 2005-12-14, -150 - update trans set balance=1379, needsrebal=0 where id=3678
1329: 240986 - 2005-12-14, -50 - update trans set balance=1329, needsrebal=0 where id=3673
1118: 240986 - 2005-12-15, -211 - update trans set balance=1118, needsrebal=0 where id=3661
878: 240986 - 2006-01-04, -240 - update trans set balance=878, needsrebal=0 where id=3796
853: 240986 - 2006-01-04, -25 - update trans set balance=853, needsrebal=0 where id=3845
628: 240986 - 2006-01-12, -225 - update trans set balance=628, needsrebal=0 where id=3945
508: 240986 - 2006-01-16, -120 - update trans set balance=508, needsrebal=0 where id=3950
358: 240986 - 2006-02-06, -150 - update trans set balance=358, needsrebal=0 where id=4148
292: 240986 - 2006-02-13, -66 - update trans set balance=292, needsrebal=0 where id=4176
232: 240986 - 2006-02-14, -60 - update trans set balance=232, needsrebal=0 where id=4172
231: 240986 - 2006-02-15, -1 - update trans set balance=231, needsrebal=0 where id=4253
219: 240986 - 2006-03-16, -12 - update trans set balance=219, needsrebal=0 where id=4433
214: 240986 - 2006-03-21, -5 - update trans set balance=214, needsrebal=0 where id=4295
34: 240986 - 2006-04-05, -180 - update trans set balance=34, needsrebal=0 where id=4530
33: 240986 - 2006-04-25, -1 - update trans set balance=33, needsrebal=0 where id=4705
30: 240986 - 2006-05-19, -3 - update trans set balance=30, needsrebal=0 where id=4849
28: 240986 - 2006-05-30, -2 - update trans set balance=28, needsrebal=0 where id=4896
0: 240986 - 2006-06-29, -28 - update trans set balance=0, needsrebal=0 where id=4963
1529: 250051 - 2005-07-11, 1529 - update trans set balance=1529, needsrebal=0 where id=2063
1407: 250051 - 2006-04-25, -122 - update trans set balance=1407, needsrebal=0 where id=4721
1385: 250051 - 2006-06-29, -22 - update trans set balance=1385, needsrebal=0 where id=4964
1235: 250051 - 2006-07-03, -150 - update trans set balance=1235, needsrebal=0 where id=4975
1211: 250051 - 2006-07-14, -24 - update trans set balance=1211, needsrebal=0 where id=4999
1209: 250051 - 2006-08-24, -2 - update trans set balance=1209, needsrebal=0 where id=5063
921: 250051 - 2006-08-30, -288 - update trans set balance=921, needsrebal=0 where id=5072
846: 250051 - 2006-09-19, -75 - update trans set balance=846, needsrebal=0 where id=5094
771: 250051 - 2006-09-26, -75 - update trans set balance=771, needsrebal=0 where id=5110
591: 250051 - 2006-09-27, -180 - update trans set balance=591, needsrebal=0 where id=5099
541: 250051 - 2006-10-24, -50 - update trans set balance=541, needsrebal=0 where id=5145
441: 250051 - 2006-10-26, -100 - update trans set balance=441, needsrebal=0 where id=5147
241: 250051 - 2006-11-14, -200 - update trans set balance=241, needsrebal=0 where id=5167
193: 250051 - 2006-11-15, -48 - update trans set balance=193, needsrebal=0 where id=5171
67: 250051 - 2007-01-09, -126 - update trans set balance=67, needsrebal=0 where id=5202
0: 250051 - 2007-02-01, -67 - update trans set balance=0, needsrebal=0 where id=5213
499: 250104 - 2005-07-22, 499 - update trans set balance=499, needsrebal=0 where id=2191
37: 250104 - 2006-11-15, -462 - update trans set balance=37, needsrebal=0 where id=5172
0: 250104 - 2006-11-22, -37 - update trans set balance=0, needsrebal=0 where id=5178
1529: 250585 - 2005-12-20, 1529 - update trans set balance=1529, needsrebal=0 where id=3832
1516: 250585 - 2006-11-22, -13 - update trans set balance=1516, needsrebal=0 where id=5179
1433: 250585 - 2007-02-01, -83 - update trans set balance=1433, needsrebal=0 where id=5214
1333: 250585 - 2007-03-08, -100 - update trans set balance=1333, needsrebal=0 where id=5235
1243: 250585 - 2007-03-12, -90 - update trans set balance=1243, needsrebal=0 where id=5240
990: 250585 - 2007-03-26, -253 - update trans set balance=990, needsrebal=0 where id=5258
450: 250585 - 2007-03-30, -540 - update trans set balance=450, needsrebal=0 where id=5257
0: 250585 - 2007-03-30, -450 - update trans set balance=0, needsrebal=0 where id=5247
510: 230744F - 2005-01-04, 510 - update trans set balance=510, needsrebal=0 where id=28
486: 230744F - 2005-01-13, -24 - update trans set balance=486, needsrebal=0 where id=247
120: 230744F - 2005-01-13, -366 - update trans set balance=120, needsrebal=0 where id=419
0: 230744F - 2005-01-25, -120 - update trans set balance=0, needsrebal=0 where id=115
1530: 240695 - 2005-01-03, 1530 - update trans set balance=1530, needsrebal=0 where id=388
1244: 240695 - 2005-01-13, -286 - update trans set balance=1244, needsrebal=0 where id=783
544: 240695 - 2005-01-13, -700 - update trans set balance=544, needsrebal=0 where id=229
494: 240695 - 2005-01-20, -50 - update trans set balance=494, needsrebal=0 where id=148
0: 240695 - 2005-02-09, -494 - update trans set balance=0, needsrebal=0 where id=596
1530: 240698 - 2005-02-07, 1530 - update trans set balance=1530, needsrebal=0 where id=779
714: 240698 - 2005-02-09, -816 - update trans set balance=714, needsrebal=0 where id=595
582: 240698 - 2005-04-13, -132 - update trans set balance=582, needsrebal=0 where id=1272
450: 240698 - 2005-04-13, -132 - update trans set balance=450, needsrebal=0 where id=1226
318: 240698 - 2005-04-18, -132 - update trans set balance=318, needsrebal=0 where id=1233
317: 240698 - 2005-04-21, -1 - update trans set balance=317, needsrebal=0 where id=1537
231: 240698 - 2005-04-27, -86 - update trans set balance=231, needsrebal=0 where id=1339
99: 240698 - 2005-06-14, -132 - update trans set balance=99, needsrebal=0 where id=1817
0: 240698 - 2005-06-22, -99 - update trans set balance=0, needsrebal=0 where id=1913
1504: 240813 - 2005-03-03, 1504 - update trans set balance=1504, needsrebal=0 where id=1163
1471: 240813 - 2005-06-16, -33 - update trans set balance=1471, needsrebal=0 where id=2758
1407: 240813 - 2005-06-22, -64 - update trans set balance=1407, needsrebal=0 where id=1914
1347: 240813 - 2005-06-28, -60 - update trans set balance=1347, needsrebal=0 where id=1969
1346: 240813 - 2005-07-01, -1 - update trans set balance=1346, needsrebal=0 where id=2013
806: 240813 - 2005-07-11, -540 - update trans set balance=806, needsrebal=0 where id=2141
746: 240813 - 2005-07-13, -60 - update trans set balance=746, needsrebal=0 where id=2122
671: 240813 - 2005-07-15, -75 - update trans set balance=671, needsrebal=0 where id=2172
371: 240813 - 2005-07-15, -300 - update trans set balance=371, needsrebal=0 where id=2135
221: 240813 - 2005-08-04, -150 - update trans set balance=221, needsrebal=0 where id=2349
219: 240813 - 2005-08-08, -2 - update trans set balance=219, needsrebal=0 where id=2403
94: 240813 - 2005-08-11, -125 - update trans set balance=94, needsrebal=0 where id=2431
0: 240813 - 2005-09-22, -94 - update trans set balance=0, needsrebal=0 where id=2739
1522: 240984 - 2005-03-28, 1522 - update trans set balance=1522, needsrebal=0 where id=936
1466: 240984 - 2005-09-22, -56 - update trans set balance=1466, needsrebal=0 where id=2740
1400: 240984 - 2005-10-21, -66 - update trans set balance=1400, needsrebal=0 where id=3122
1250: 240984 - 2005-11-23, -150 - update trans set balance=1250, needsrebal=0 where id=3492
718: 240984 - 2005-11-28, -532 - update trans set balance=718, needsrebal=0 where id=3512
658: 240984 - 2005-12-02, -60 - update trans set balance=658, needsrebal=0 where id=3758
478: 240984 - 2005-12-09, -180 - update trans set balance=478, needsrebal=0 where id=3578
418: 240984 - 2005-12-15, -60 - update trans set balance=418, needsrebal=0 where id=3662
368: 240984 - 2005-12-27, -50 - update trans set balance=368, needsrebal=0 where id=3771
218: 240984 - 2006-01-03, -150 - update trans set balance=218, needsrebal=0 where id=3822
150: 240984 - 2006-01-04, -68 - update trans set balance=150, needsrebal=0 where id=3795
0: 240984 - 2006-01-05, -150 - update trans set balance=0, needsrebal=0 where id=3885
1529: 240987 - 2005-05-09, 1529 - update trans set balance=1529, needsrebal=0 where id=1717
1492: 240987 - 2006-01-04, -37 - update trans set balance=1492, needsrebal=0 where id=3855
1372: 240987 - 2006-01-16, -120 - update trans set balance=1372, needsrebal=0 where id=3949
1371: 240987 - 2006-02-15, -1 - update trans set balance=1371, needsrebal=0 where id=4252
1221: 240987 - 2006-02-28, -150 - update trans set balance=1221, needsrebal=0 where id=4329
1071: 240987 - 2006-03-15, -150 - update trans set balance=1071, needsrebal=0 where id=4419
1066: 240987 - 2006-03-21, -5 - update trans set balance=1066, needsrebal=0 where id=4294
1006: 240987 - 2006-04-05, -60 - update trans set balance=1006, needsrebal=0 where id=4529
735: 240987 - 2006-04-25, -271 - update trans set balance=735, needsrebal=0 where id=4722
585: 240987 - 2006-04-25, -150 - update trans set balance=585, needsrebal=0 where id=4701
584: 240987 - 2006-04-25, -1 - update trans set balance=584, needsrebal=0 where id=4704
386: 240987 - 2006-05-12, -198 - update trans set balance=386, needsrebal=0 where id=4804
383: 240987 - 2006-05-19, -3 - update trans set balance=383, needsrebal=0 where id=4847
119: 240987 - 2006-05-30, -264 - update trans set balance=119, needsrebal=0 where id=4887
0: 240987 - 2006-06-05, -119 - update trans set balance=0, needsrebal=0 where id=4934
1529: 250052 - 2005-06-10, 1529 - update trans set balance=1529, needsrebal=0 where id=1899
1516: 250052 - 2006-06-05, -13 - update trans set balance=1516, needsrebal=0 where id=4935
1514: 250052 - 2006-08-24, -2 - update trans set balance=1514, needsrebal=0 where id=5062
1370: 250052 - 2006-08-30, -144 - update trans set balance=1370, needsrebal=0 where id=5073
1220: 250052 - 2006-09-19, -150 - update trans set balance=1220, needsrebal=0 where id=5096
1145: 250052 - 2006-09-26, -75 - update trans set balance=1145, needsrebal=0 where id=5109
1085: 250052 - 2006-09-27, -60 - update trans set balance=1085, needsrebal=0 where id=5098
985: 250052 - 2006-10-24, -100 - update trans set balance=985, needsrebal=0 where id=5144
785: 250052 - 2006-10-26, -200 - update trans set balance=785, needsrebal=0 where id=5146
580: 250052 - 2006-11-15, -205 - update trans set balance=580, needsrebal=0 where id=5176
114: 250052 - 2006-11-15, -466 - update trans set balance=114, needsrebal=0 where id=5173
14: 250052 - 2006-11-22, -100 - update trans set balance=14, needsrebal=0 where id=5180
0: 250052 - 2006-11-29, -14 - update trans set balance=0, needsrebal=0 where id=5187
659: 250104 - 2005-07-22, 659 - update trans set balance=659, needsrebal=0 where id=2978
579: 250104 - 2007-01-25, -80 - update trans set balance=579, needsrebal=0 where id=5210
0: 250104 - 2007-01-30, -579 - update trans set balance=0, needsrebal=0 where id=5211
1529: 250105 - 2005-07-01, 1529 - update trans set balance=1529, needsrebal=0 where id=1901
1348: 250105 - 2006-11-10, -181 - update trans set balance=1348, needsrebal=0 where id=5193
1242: 250105 - 2006-11-29, -106 - update trans set balance=1242, needsrebal=0 where id=5188
1422: 250105 - 2006-12-04, 180 - update trans set balance=1422, needsrebal=0 where id=5195
1372: 250105 - 2006-12-04, -50 - update trans set balance=1372, needsrebal=0 where id=5190
1272: 250105 - 2006-12-26, -100 - update trans set balance=1272, needsrebal=0 where id=5200
1146: 250105 - 2007-01-09, -126 - update trans set balance=1146, needsrebal=0 where id=5204
1020: 250105 - 2007-01-09, -126 - update trans set balance=1020, needsrebal=0 where id=5203
0: 250105 - 2007-01-25, -1020 - update trans set balance=0, needsrebal=0 where id=5209
1529: 250487 - 2005-10-10, 1529 - update trans set balance=1529, needsrebal=0 where id=3114
968: 250487 - 2007-01-30, -561 - update trans set balance=968, needsrebal=0 where id=5212
818: 250487 - 2007-01-31, -150 - update trans set balance=818, needsrebal=0 where id=5215
768: 250487 - 2007-03-08, -50 - update trans set balance=768, needsrebal=0 where id=5234
668: 250487 - 2007-03-13, -100 - update trans set balance=668, needsrebal=0 where id=5242
518: 250487 - 2007-03-27, -150 - update trans set balance=518, needsrebal=0 where id=5241
0: 250487 - 2007-03-30, -518 - update trans set balance=0, needsrebal=0 where id=5255
1529: 250582 - 2005-12-21, 1529 - update trans set balance=1529, needsrebal=0 where id=3888
1497: 250582 - 2007-03-30, -32 - update trans set balance=1497, needsrebal=0 where id=5256
1207: 250582 - 2007-03-30, -290 - update trans set balance=1207, needsrebal=0 where id=5246
1107: 250582 - 2007-04-03, -100 - update trans set balance=1107, needsrebal=0 where id=5248
1007: 250582 - 2007-04-16, -100 - update trans set balance=1007, needsrebal=0 where id=5252
857: 250582 - 2007-04-24, -150 - update trans set balance=857, needsrebal=0 where id=5267
657: 250582 - 2007-04-30, -200 - update trans set balance=657, needsrebal=0 where id=5266
557: 250582 - 2007-04-30, -100 - update trans set balance=557, needsrebal=0 where id=5268
600: 250582 - 2007-05-25, 43 - update trans set balance=600, needsrebal=0 where id=5295
0: 250582 - 2007-05-25, -600 - update trans set balance=0, needsrebal=0 where id=5296
14: 3458 - 2005-01-01, 14 - update trans set balance=14, needsrebal=0 where id=796
0: 3458 - 2005-01-13, -14 - update trans set balance=0, needsrebal=0 where id=250
953: 240420BM - 2005-01-01, 953 - update trans set balance=953, needsrebal=0 where id=19
897: 240420BM - 2005-01-04, -56 - update trans set balance=897, needsrebal=0 where id=327
841: 240420BM - 2005-01-10, -56 - update trans set balance=841, needsrebal=0 where id=288
833: 240420BM - 2005-01-11, -8 - update trans set balance=833, needsrebal=0 where id=275
773: 240420BM - 2005-01-11, -60 - update trans set balance=773, needsrebal=0 where id=278
717: 240420BM - 2005-01-11, -56 - update trans set balance=717, needsrebal=0 where id=277
417: 240420BM - 2005-01-12, -300 - update trans set balance=417, needsrebal=0 where id=262
357: 240420BM - 2005-01-12, -60 - update trans set balance=357, needsrebal=0 where id=268
301: 240420BM - 2005-01-13, -56 - update trans set balance=301, needsrebal=0 where id=221
245: 240420BM - 2005-01-14, -56 - update trans set balance=245, needsrebal=0 where id=205
89: 240420BM - 2005-01-18, -156 - update trans set balance=89, needsrebal=0 where id=179
79: 240420BM - 2005-01-20, -10 - update trans set balance=79, needsrebal=0 where id=159
77: 240420BM - 2005-01-31, -2 - update trans set balance=77, needsrebal=0 where id=59
17: 240420BM - 2005-02-02, -60 - update trans set balance=17, needsrebal=0 where id=667
9: 240420BM - 2005-02-02, -8 - update trans set balance=9, needsrebal=0 where id=672
7: 240420BM - 2005-02-02, -2 - update trans set balance=7, needsrebal=0 where id=678
6: 240420BM - 2005-02-02, -1 - update trans set balance=6, needsrebal=0 where id=679
0: 240420BM - 2005-02-07, -6 - update trans set balance=0, needsrebal=0 where id=644
539: 240421BM - 2004-12-07, 539 - update trans set balance=539, needsrebal=0 where id=1161
533: 240421BM - 2005-05-04, -6 - update trans set balance=533, needsrebal=0 where id=1454
532: 240421BM - 2005-05-09, -1 - update trans set balance=532, needsrebal=0 where id=1492
476: 240421BM - 2005-05-10, -56 - update trans set balance=476, needsrebal=0 where id=1531
447: 240421BM - 2005-05-25, -29 - update trans set balance=447, needsrebal=0 where id=1791
391: 240421BM - 2005-05-26, -56 - update trans set balance=391, needsrebal=0 where id=1740
271: 240421BM - 2005-05-31, -120 - update trans set balance=271, needsrebal=0 where id=1737
211: 240421BM - 2005-06-02, -60 - update trans set balance=211, needsrebal=0 where id=1764
91: 240421BM - 2005-06-02, -120 - update trans set balance=91, needsrebal=0 where id=1770
211: 240421BM - 2005-06-08, 120 - update trans set balance=211, needsrebal=0 where id=2103
120: 240421BM - 2005-06-22, -91 - update trans set balance=120, needsrebal=0 where id=1868
0: 240421BM - 2005-07-11, -120 - update trans set balance=0, needsrebal=0 where id=2138
1078: 240580BM - 2005-01-05, 1078 - update trans set balance=1078, needsrebal=0 where id=774
2156: 240580BM - 2005-01-07, 1078 - update trans set balance=2156, needsrebal=0 where id=18
1078: 240580BM - 2005-01-07, -1078 - update trans set balance=1078, needsrebal=0 where id=22
1024: 240580BM - 2005-02-07, -54 - update trans set balance=1024, needsrebal=0 where id=643
1016: 240580BM - 2005-02-08, -8 - update trans set balance=1016, needsrebal=0 where id=607
956: 240580BM - 2005-02-18, -60 - update trans set balance=956, needsrebal=0 where id=530
896: 240580BM - 2005-02-25, -60 - update trans set balance=896, needsrebal=0 where id=442
868: 240580BM - 2005-03-02, -28 - update trans set balance=868, needsrebal=0 where id=1159
808: 240580BM - 2005-03-03, -60 - update trans set balance=808, needsrebal=0 where id=1158
800: 240580BM - 2005-03-22, -8 - update trans set balance=800, needsrebal=0 where id=1072
744: 240580BM - 2005-03-22, -56 - update trans set balance=744, needsrebal=0 where id=1058
736: 240580BM - 2005-03-23, -8 - update trans set balance=736, needsrebal=0 where id=981
676: 240580BM - 2005-03-28, -60 - update trans set balance=676, needsrebal=0 where id=1077
556: 240580BM - 2005-03-28, -120 - update trans set balance=556, needsrebal=0 where id=1079
500: 240580BM - 2005-03-28, -56 - update trans set balance=500, needsrebal=0 where id=1087
356: 240580BM - 2005-03-28, -144 - update trans set balance=356, needsrebal=0 where id=1086
296: 240580BM - 2005-03-30, -60 - update trans set balance=296, needsrebal=0 where id=1080
286: 240580BM - 2005-04-01, -10 - update trans set balance=286, needsrebal=0 where id=954
230: 240580BM - 2005-04-06, -56 - update trans set balance=230, needsrebal=0 where id=1313
190: 240580BM - 2005-04-08, -40 - update trans set balance=190, needsrebal=0 where id=1534
182: 240580BM - 2005-04-21, -8 - update trans set balance=182, needsrebal=0 where id=1224
174: 240580BM - 2005-04-25, -8 - update trans set balance=174, needsrebal=0 where id=1375
54: 240580BM - 2005-04-29, -120 - update trans set balance=54, needsrebal=0 where id=1410
0: 240580BM - 2005-05-04, -54 - update trans set balance=0, needsrebal=0 where id=1453
1078: 240600 - 2005-03-03, 1078 - update trans set balance=1078, needsrebal=0 where id=399
1049: 240600 - 2005-06-22, -29 - update trans set balance=1049, needsrebal=0 where id=1869
1009: 240600 - 2005-06-23, -40 - update trans set balance=1009, needsrebal=0 where id=1926
505: 240600 - 2005-06-27, -504 - update trans set balance=505, needsrebal=0 where id=1966
497: 240600 - 2005-06-29, -8 - update trans set balance=497, needsrebal=0 where id=1918
437: 240600 - 2005-06-30, -60 - update trans set balance=437, needsrebal=0 where id=1908
436: 240600 - 2005-06-30, -1 - update trans set balance=436, needsrebal=0 where id=1981
220: 240600 - 2005-07-11, -216 - update trans set balance=220, needsrebal=0 where id=2139
212: 240600 - 2005-07-13, -8 - update trans set balance=212, needsrebal=0 where id=2137
184: 240600 - 2005-07-13, -28 - update trans set balance=184, needsrebal=0 where id=2164
64: 240600 - 2005-07-28, -120 - update trans set balance=64, needsrebal=0 where id=2186
56: 240600 - 2005-08-11, -8 - update trans set balance=56, needsrebal=0 where id=2346
16: 240600 - 2005-08-15, -40 - update trans set balance=16, needsrebal=0 where id=2641
8: 240600 - 2005-08-15, -8 - update trans set balance=8, needsrebal=0 where id=2747
0: 240600 - 2005-08-17, -8 - update trans set balance=0, needsrebal=0 where id=2433
1078: 250335 - 2005-09-15, 1078 - update trans set balance=1078, needsrebal=0 where id=2708
958: 250335 - 2005-09-19, -120 - update trans set balance=958, needsrebal=0 where id=2753
818: 250335 - 2005-09-19, -140 - update trans set balance=818, needsrebal=0 where id=2748
802: 250335 - 2005-09-19, -16 - update trans set balance=802, needsrebal=0 where id=2925
774: 250335 - 2005-09-20, -28 - update trans set balance=774, needsrebal=0 where id=2755
749: 250335 - 2005-09-20, -25 - update trans set balance=749, needsrebal=0 where id=2754
739: 250335 - 2005-09-20, -10 - update trans set balance=739, needsrebal=0 where id=2811
729: 250335 - 2005-09-20, -10 - update trans set balance=729, needsrebal=0 where id=2814
150: 250335 - 2005-09-20, -579 - update trans set balance=150, needsrebal=0 where id=2749
140: 250335 - 2005-09-21, -10 - update trans set balance=140, needsrebal=0 where id=2927
130: 250335 - 2005-09-21, -10 - update trans set balance=130, needsrebal=0 where id=2756
122: 250335 - 2005-09-21, -8 - update trans set balance=122, needsrebal=0 where id=2923
30: 250335 - 2005-09-22, -92 - update trans set balance=30, needsrebal=0 where id=2752
0: 250335 - 2005-09-23, -30 - update trans set balance=0, needsrebal=0 where id=2757
233: 250639-2 - 2006-01-12, 233 - update trans set balance=233, needsrebal=0 where id=3983
113: 250639-2 - 2006-01-18, -120 - update trans set balance=113, needsrebal=0 where id=4000
85: 250639-2 - 2006-01-19, -28 - update trans set balance=85, needsrebal=0 where id=4001
145: 250639-2 - 2006-03-13, 60 - update trans set balance=145, needsrebal=0 where id=4434
85: 250639-2 - 2006-03-13, -60 - update trans set balance=85, needsrebal=0 where id=4344
60: 250639-2 - 2006-03-16, -25 - update trans set balance=60, needsrebal=0 where id=4415
0: 250639-2 - 2006-03-30, -60 - update trans set balance=0, needsrebal=0 where id=4491
1078: 250682 - 2006-01-27, 1078 - update trans set balance=1078, needsrebal=0 where id=3904
1031: 250682 - 2006-08-28, -47 - update trans set balance=1031, needsrebal=0 where id=5054
975: 250682 - 2006-08-29, -56 - update trans set balance=975, needsrebal=0 where id=5068
915: 250682 - 2006-08-30, -60 - update trans set balance=915, needsrebal=0 where id=5061
854: 250682 - 2006-09-05, -61 - update trans set balance=854, needsrebal=0 where id=5091
554: 250682 - 2006-09-13, -300 - update trans set balance=554, needsrebal=0 where id=5081
494: 250682 - 2006-09-13, -60 - update trans set balance=494, needsrebal=0 where id=5080
454: 250682 - 2006-09-13, -40 - update trans set balance=454, needsrebal=0 where id=5086
394: 250682 - 2006-09-28, -60 - update trans set balance=394, needsrebal=0 where id=5125
334: 250682 - 2006-10-02, -60 - update trans set balance=334, needsrebal=0 where id=5126
254: 250682 - 2006-10-13, -80 - update trans set balance=254, needsrebal=0 where id=5133
194: 250682 - 2006-10-25, -60 - update trans set balance=194, needsrebal=0 where id=5143
56: 250682 - 2006-11-22, -138 - update trans set balance=56, needsrebal=0 where id=5177
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 13, 'M6CUBE', '250682', 56, '2006-01-27','2006-11-22');
1078: 250684BM - 2006-01-19, 1078 - update trans set balance=1078, needsrebal=0 where id=4256
1018: 250684BM - 2006-03-16, -60 - update trans set balance=1018, needsrebal=0 where id=4428
903: 250684BM - 2006-03-16, -115 - update trans set balance=903, needsrebal=0 where id=4416
847: 250684BM - 2006-03-30, -56 - update trans set balance=847, needsrebal=0 where id=4525
908: 250684BM - 2006-04-26, 61 - update trans set balance=908, needsrebal=0 where id=4737
848: 250684BM - 2006-04-28, -60 - update trans set balance=848, needsrebal=0 where id=4699
818: 250684BM - 2006-05-16, -30 - update trans set balance=818, needsrebal=0 where id=4827
816: 250684BM - 2006-05-22, -2 - update trans set balance=816, needsrebal=0 where id=4863
756: 250684BM - 2006-05-30, -60 - update trans set balance=756, needsrebal=0 where id=4901
696: 250684BM - 2006-06-02, -60 - update trans set balance=696, needsrebal=0 where id=4911
636: 250684BM - 2006-06-19, -60 - update trans set balance=636, needsrebal=0 where id=4939
580: 250684BM - 2006-06-28, -56 - update trans set balance=580, needsrebal=0 where id=4971
565: 250684BM - 2006-07-13, -15 - update trans set balance=565, needsrebal=0 where id=4993
505: 250684BM - 2006-07-14, -60 - update trans set balance=505, needsrebal=0 where id=4994
465: 250684BM - 2006-07-25, -40 - update trans set balance=465, needsrebal=0 where id=5004
405: 250684BM - 2006-07-26, -60 - update trans set balance=405, needsrebal=0 where id=5011
349: 250684BM - 2006-07-27, -56 - update trans set balance=349, needsrebal=0 where id=5015
289: 250684BM - 2006-08-18, -60 - update trans set balance=289, needsrebal=0 where id=5038
177: 250684BM - 2006-08-18, -112 - update trans set balance=177, needsrebal=0 where id=5040
65: 250684BM - 2006-08-23, -112 - update trans set balance=65, needsrebal=0 where id=5044
9: 250684BM - 2006-08-24, -56 - update trans set balance=9, needsrebal=0 where id=5055
0: 250684BM - 2006-08-28, -9 - update trans set balance=0, needsrebal=0 where id=5053
290: 3076 - 2005-01-01, 290 - update trans set balance=290, needsrebal=0 where id=722
289: 3076 - 2005-01-03, -1 - update trans set balance=289, needsrebal=0 where id=362
219: 3076 - 2005-01-07, -70 - update trans set balance=219, needsrebal=0 where id=304
209: 3076 - 2005-01-21, -10 - update trans set balance=209, needsrebal=0 where id=138
219: 3076 - 2005-01-24, 10 - update trans set balance=219, needsrebal=0 where id=20
209: 3076 - 2005-01-24, -10 - update trans set balance=209, needsrebal=0 where id=137
207: 3076 - 2005-05-09, -2 - update trans set balance=207, needsrebal=0 where id=1497
205: 3076 - 2005-05-23, -2 - update trans set balance=205, needsrebal=0 where id=1777
204: 3076 - 2005-06-30, -1 - update trans set balance=204, needsrebal=0 where id=1979
200: 3076 - 2005-09-13, -4 - update trans set balance=200, needsrebal=0 where id=2631
206: 3076 - 2005-10-14, 6 - update trans set balance=206, needsrebal=0 where id=3043
0: 3076 - 2006-02-22, -206 - update trans set balance=0, needsrebal=0 where id=3047
Go