'1_21_240363', '1_21_240364', '1_21_240750', '1_21_240751', '1_21_250044', '1_21_250047', '1_21_250048', '1_22_230827', '1_22_230830', '1_22_230832', '1_22_240380', '1_22_240383', '1_22_240385', '1_22_240386', '1_22_240388', '1_23_3385', '1_23_3410', '1_23_4024', '1_23_4055', '1_23_4114', '1_24_3407', '1_24_3409', '1_24_3441', '1_24_3449', '1_24_4022', '1_24_4025', '1_24_4106', '1_24_4136', '1_25_3433', '1_25_3440', '1_25_4023', '1_25_4046', '1_25_4107', '1_25_4138', '1_25_4153', '1_26_#4079', '1_26_3476', '1_26_3491', '1_26_3497', '1_26_4021', '1_26_4097', '1_26_4137', '1_26_4156', '1_27_#4043', '1_27_3434', '1_27_3442', '1_27_3451'
3142: 240363 - 2005-03-13, 3142 - update trans set balance=3142, needsrebal=0 where id=715
97: 240363 - 2005-10-27, -3045 - update trans set balance=97, needsrebal=0 where id=3272
0: 240363 - 2005-11-22, -97 - update trans set balance=0, needsrebal=0 where id=3481
3211: 240364 - 2005-03-18, 3211 - update trans set balance=3211, needsrebal=0 where id=717
908: 240364 - 2005-11-22, -2303 - update trans set balance=908, needsrebal=0 where id=3482
858: 240364 - 2005-11-28, -50 - update trans set balance=858, needsrebal=0 where id=3478
0: 240364 - 2005-12-19, -858 - update trans set balance=0, needsrebal=0 where id=3709
3597: 240750 - 2005-01-01, 3597 - update trans set balance=3597, needsrebal=0 where id=757
2905: 240750 - 2005-02-22, -692 - update trans set balance=2905, needsrebal=0 where id=498
2865: 240750 - 2005-02-23, -40 - update trans set balance=2865, needsrebal=0 where id=491
2855: 240750 - 2005-02-23, -10 - update trans set balance=2855, needsrebal=0 where id=488
2840: 240750 - 2005-02-25, -15 - update trans set balance=2840, needsrebal=0 where id=481
2834: 240750 - 2005-03-09, -6 - update trans set balance=2834, needsrebal=0 where id=834
2819: 240750 - 2005-03-11, -15 - update trans set balance=2819, needsrebal=0 where id=862
2499: 240750 - 2005-03-14, -320 - update trans set balance=2499, needsrebal=0 where id=872
2498: 240750 - 2005-03-18, -1 - update trans set balance=2498, needsrebal=0 where id=1147
2497: 240750 - 2005-03-18, -1 - update trans set balance=2497, needsrebal=0 where id=1154
2017: 240750 - 2005-03-22, -480 - update trans set balance=2017, needsrebal=0 where id=1001
1982: 240750 - 2005-03-22, -35 - update trans set balance=1982, needsrebal=0 where id=1005
1822: 240750 - 2005-03-22, -160 - update trans set balance=1822, needsrebal=0 where id=1074
1816: 240750 - 2005-03-22, -6 - update trans set balance=1816, needsrebal=0 where id=996
1496: 240750 - 2005-03-24, -320 - update trans set balance=1496, needsrebal=0 where id=983
1476: 240750 - 2005-03-29, -20 - update trans set balance=1476, needsrebal=0 where id=976
1446: 240750 - 2005-03-29, -30 - update trans set balance=1446, needsrebal=0 where id=967
1366: 240750 - 2005-03-30, -80 - update trans set balance=1366, needsrebal=0 where id=1110
1350: 240750 - 2005-04-01, -16 - update trans set balance=1350, needsrebal=0 where id=957
1300: 240750 - 2005-04-04, -50 - update trans set balance=1300, needsrebal=0 where id=1366
1299: 240750 - 2005-04-05, -1 - update trans set balance=1299, needsrebal=0 where id=1297
0: 240750 - 2005-04-27, -1299 - update trans set balance=0, needsrebal=0 where id=1320
3599: 240751 - 2005-03-03, 3599 - update trans set balance=3599, needsrebal=0 where id=389
3449: 240751 - 2005-11-08, -150 - update trans set balance=3449, needsrebal=0 where id=3339
2505: 240751 - 2005-11-14, -944 - update trans set balance=2505, needsrebal=0 where id=3391
2480: 240751 - 2005-11-17, -25 - update trans set balance=2480, needsrebal=0 where id=3407
2000: 240751 - 2005-11-28, -480 - update trans set balance=2000, needsrebal=0 where id=3500
1980: 240751 - 2005-11-29, -20 - update trans set balance=1980, needsrebal=0 where id=3464
1880: 240751 - 2005-12-01, -100 - update trans set balance=1880, needsrebal=0 where id=3538
1720: 240751 - 2005-12-02, -160 - update trans set balance=1720, needsrebal=0 where id=3583
1670: 240751 - 2005-12-05, -50 - update trans set balance=1670, needsrebal=0 where id=3575
1510: 240751 - 2005-12-07, -160 - update trans set balance=1510, needsrebal=0 where id=3618
1320: 240751 - 2005-12-15, -190 - update trans set balance=1320, needsrebal=0 where id=3340
1260: 240751 - 2005-12-15, -60 - update trans set balance=1260, needsrebal=0 where id=3699
0: 240751 - 2005-12-19, -1260 - update trans set balance=0, needsrebal=0 where id=3710
1068: 240751 - 2007-04-04, 1068 - update trans set balance=1068, needsrebal=0 where id=5259
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 21, 'M15MBALLS', '240751', 1068, '2005-03-03','2007-04-04');
1584: 250044 - 2006-01-10, 1584 - update trans set balance=1584, needsrebal=0 where id=3929
973: 250044 - 2006-05-31, -611 - update trans set balance=973, needsrebal=0 where id=4907
722: 250044 - 2006-06-23, -251 - update trans set balance=722, needsrebal=0 where id=4962
114: 250044 - 2006-07-11, -608 - update trans set balance=114, needsrebal=0 where id=4990
0: 250044 - 2007-04-04, -114 - update trans set balance=0, needsrebal=0 where id=5253
3599: 250047 - 2005-11-29, 3599 - update trans set balance=3599, needsrebal=0 where id=3488
199: 250047 - 2005-12-30, -3400 - update trans set balance=199, needsrebal=0 where id=3786
114: 250047 - 2006-01-04, -85 - update trans set balance=114, needsrebal=0 where id=3794
89: 250047 - 2006-05-09, -25 - update trans set balance=89, needsrebal=0 where id=4799
29: 250047 - 2006-05-10, -60 - update trans set balance=29, needsrebal=0 where id=4816
0: 250047 - 2006-05-31, -29 - update trans set balance=0, needsrebal=0 where id=4906
3421: 250048 - 2005-11-29, 3421 - update trans set balance=3421, needsrebal=0 where id=3485
3114: 250048 - 2006-03-06, -307 - update trans set balance=3114, needsrebal=0 where id=4358
3034: 250048 - 2006-03-21, -80 - update trans set balance=3034, needsrebal=0 where id=4476
2746: 250048 - 2006-03-22, -288 - update trans set balance=2746, needsrebal=0 where id=4456
2266: 250048 - 2006-03-24, -480 - update trans set balance=2266, needsrebal=0 where id=4485
2106: 250048 - 2006-03-30, -160 - update trans set balance=2106, needsrebal=0 where id=4518
2102: 250048 - 2006-04-24, -4 - update trans set balance=2102, needsrebal=0 where id=4580
1814: 250048 - 2006-06-14, -288 - update trans set balance=1814, needsrebal=0 where id=4938
1334: 250048 - 2006-06-14, -480 - update trans set balance=1334, needsrebal=0 where id=4941
1009: 250048 - 2006-06-23, -325 - update trans set balance=1009, needsrebal=0 where id=4961
0: 250048 - 2007-04-04, -1009 - update trans set balance=0, needsrebal=0 where id=5254
404: 230827 - 2005-01-01, 404 - update trans set balance=404, needsrebal=0 where id=791
1: 230827 - 2005-01-27, -403 - update trans set balance=1, needsrebal=0 where id=416
0: 230827 - 2005-05-12, -1 - update trans set balance=0, needsrebal=0 where id=1814
3400: 230830 - 2004-05-17, 3400 - update trans set balance=3400, needsrebal=0 where id=760
2760: 230830 - 2005-01-27, -640 - update trans set balance=2760, needsrebal=0 where id=91
2085: 230830 - 2005-01-31, -675 - update trans set balance=2085, needsrebal=0 where id=79
2082: 230830 - 2005-01-31, -3 - update trans set balance=2082, needsrebal=0 where id=41
2080: 230830 - 2005-01-31, -2 - update trans set balance=2080, needsrebal=0 where id=60
1600: 230830 - 2005-02-02, -480 - update trans set balance=1600, needsrebal=0 where id=677
1036: 230830 - 2005-02-02, -564 - update trans set balance=1036, needsrebal=0 where id=675
876: 230830 - 2005-02-17, -160 - update trans set balance=876, needsrebal=0 where id=555
871: 230830 - 2005-02-23, -5 - update trans set balance=871, needsrebal=0 where id=490
865: 230830 - 2005-03-09, -6 - update trans set balance=865, needsrebal=0 where id=837
12: 230830 - 2005-03-11, -853 - update trans set balance=12, needsrebal=0 where id=916
0: 230830 - 2005-03-11, -12 - update trans set balance=0, needsrebal=0 where id=863
683: 230830 - 2005-08-04, 683 - update trans set balance=683, needsrebal=0 where id=2387
671: 230830 - 2005-08-12, -12 - update trans set balance=671, needsrebal=0 where id=2413
651: 230830 - 2005-08-19, -20 - update trans set balance=651, needsrebal=0 where id=2492
641: 230830 - 2005-08-23, -10 - update trans set balance=641, needsrebal=0 where id=2524
636: 230830 - 2005-08-25, -5 - update trans set balance=636, needsrebal=0 where id=2539
631: 230830 - 2005-09-07, -5 - update trans set balance=631, needsrebal=0 where id=2609
151: 230830 - 2005-09-12, -480 - update trans set balance=151, needsrebal=0 where id=2619
121: 230830 - 2005-09-13, -30 - update trans set balance=121, needsrebal=0 where id=2648
71: 230830 - 2005-09-14, -50 - update trans set balance=71, needsrebal=0 where id=2653
55: 230830 - 2005-09-14, -16 - update trans set balance=55, needsrebal=0 where id=2665
0: 230830 - 2005-10-05, -55 - update trans set balance=0, needsrebal=0 where id=2763
484: 230832 - 2005-01-01, 484 - update trans set balance=484, needsrebal=0 where id=792
452: 230832 - 2005-01-06, -32 - update trans set balance=452, needsrebal=0 where id=311
422: 230832 - 2005-01-11, -30 - update trans set balance=422, needsrebal=0 where id=284
407: 230832 - 2005-01-13, -15 - update trans set balance=407, needsrebal=0 where id=236
402: 230832 - 2005-01-13, -5 - update trans set balance=402, needsrebal=0 where id=244
382: 230832 - 2005-01-20, -20 - update trans set balance=382, needsrebal=0 where id=146
377: 230832 - 2005-01-20, -5 - update trans set balance=377, needsrebal=0 where id=160
0: 230832 - 2005-01-27, -377 - update trans set balance=0, needsrebal=0 where id=92
3400: 240380 - 2004-06-21, 3400 - update trans set balance=3400, needsrebal=0 where id=761
3263: 240380 - 2005-03-11, -137 - update trans set balance=3263, needsrebal=0 where id=917
3253: 240380 - 2005-03-22, -10 - update trans set balance=3253, needsrebal=0 where id=1007
3247: 240380 - 2005-03-22, -6 - update trans set balance=3247, needsrebal=0 where id=994
1647: 240380 - 2005-03-28, -1600 - update trans set balance=1647, needsrebal=0 where id=1078
1627: 240380 - 2005-03-29, -20 - update trans set balance=1627, needsrebal=0 where id=975
1607: 240380 - 2005-03-29, -20 - update trans set balance=1607, needsrebal=0 where id=968
1527: 240380 - 2005-03-30, -80 - update trans set balance=1527, needsrebal=0 where id=1112
1526: 240380 - 2005-04-05, -1 - update trans set balance=1526, needsrebal=0 where id=1296
566: 240380 - 2005-04-14, -960 - update trans set balance=566, needsrebal=0 where id=1276
486: 240380 - 2005-04-27, -80 - update trans set balance=486, needsrebal=0 where id=1354
480: 240380 - 2005-04-28, -6 - update trans set balance=480, needsrebal=0 where id=1361
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 22, 'MHASHFLIP', '240380', 480, '2004-06-21','2005-04-28');
3397: 240383 - 2004-06-24, 3397 - update trans set balance=3397, needsrebal=0 where id=759
2757: 240383 - 2005-04-27, -640 - update trans set balance=2757, needsrebal=0 where id=1369
2748: 240383 - 2005-04-28, -9 - update trans set balance=2748, needsrebal=0 where id=1362
2747: 240383 - 2005-05-09, -1 - update trans set balance=2747, needsrebal=0 where id=1486
2571: 240383 - 2005-05-12, -176 - update trans set balance=2571, needsrebal=0 where id=1809
2561: 240383 - 2005-05-16, -10 - update trans set balance=2561, needsrebal=0 where id=1641
15: 240383 - 2005-05-16, -2546 - update trans set balance=15, needsrebal=0 where id=1624
0: 240383 - 2005-05-17, -15 - update trans set balance=0, needsrebal=0 where id=1607
3383: 240385 - 2004-07-26, 3383 - update trans set balance=3383, needsrebal=0 where id=762
2783: 240385 - 2005-08-01, -600 - update trans set balance=2783, needsrebal=0 where id=2314
3383: 240385 - 2005-08-22, 600 - update trans set balance=3383, needsrebal=0 where id=2642
3278: 240385 - 2005-10-05, -105 - update trans set balance=3278, needsrebal=0 where id=2764
2158: 240385 - 2006-01-25, -1120 - update trans set balance=2158, needsrebal=0 where id=4038
166: 240385 - 2006-04-26, -1992 - update trans set balance=166, needsrebal=0 where id=4730
0: 240385 - 2006-05-09, -166 - update trans set balance=0, needsrebal=0 where id=4797
3400: 240386 - 2004-07-21, 3400 - update trans set balance=3400, needsrebal=0 where id=763
2746: 240386 - 2005-05-16, -654 - update trans set balance=2746, needsrebal=0 where id=1625
2741: 240386 - 2005-05-18, -5 - update trans set balance=2741, needsrebal=0 where id=1668
2101: 240386 - 2005-05-19, -640 - update trans set balance=2101, needsrebal=0 where id=1652
2095: 240386 - 2005-05-23, -6 - update trans set balance=2095, needsrebal=0 where id=1787
1775: 240386 - 2005-05-27, -320 - update trans set balance=1775, needsrebal=0 where id=1750
1765: 240386 - 2005-05-31, -10 - update trans set balance=1765, needsrebal=0 where id=1734
1445: 240386 - 2005-06-08, -320 - update trans set balance=1445, needsrebal=0 where id=2021
1125: 240386 - 2005-06-13, -320 - update trans set balance=1125, needsrebal=0 where id=1822
1025: 240386 - 2005-06-24, -100 - update trans set balance=1025, needsrebal=0 where id=1928
1015: 240386 - 2005-06-29, -10 - update trans set balance=1015, needsrebal=0 where id=1947
1011: 240386 - 2005-06-30, -4 - update trans set balance=1011, needsrebal=0 where id=1984
995: 240386 - 2005-07-14, -16 - update trans set balance=995, needsrebal=0 where id=2159
355: 240386 - 2005-07-19, -640 - update trans set balance=355, needsrebal=0 where id=2205
35: 240386 - 2005-07-29, -320 - update trans set balance=35, needsrebal=0 where id=2290
18: 240386 - 2005-08-09, -17 - update trans set balance=18, needsrebal=0 where id=2408
0: 240386 - 2005-08-12, -18 - update trans set balance=0, needsrebal=0 where id=2412
640: 240386 - 2005-09-29, 640 - update trans set balance=640, needsrebal=0 where id=2911
0: 240386 - 2006-04-26, -640 - update trans set balance=0, needsrebal=0 where id=4735
3400: 240388 - 2004-08-17, 3400 - update trans set balance=3400, needsrebal=0 where id=764
2120: 240388 - 2005-10-11, -1280 - update trans set balance=2120, needsrebal=0 where id=2996
1640: 240388 - 2005-10-19, -480 - update trans set balance=1640, needsrebal=0 where id=3127
1424: 240388 - 2005-10-24, -216 - update trans set balance=1424, needsrebal=0 where id=3173
19: 240388 - 2005-11-14, -1405 - update trans set balance=19, needsrebal=0 where id=3390
16: 240388 - 2006-01-09, -3 - update trans set balance=16, needsrebal=0 where id=3898
0: 240388 - 2006-04-26, -16 - update trans set balance=0, needsrebal=0 where id=4734
196: 3385 - 2005-01-01, 196 - update trans set balance=196, needsrebal=0 where id=726
126: 3385 - 2005-01-17, -70 - update trans set balance=126, needsrebal=0 where id=188
125: 3385 - 2005-01-31, -1 - update trans set balance=125, needsrebal=0 where id=42
121: 3385 - 2005-01-31, -4 - update trans set balance=121, needsrebal=0 where id=61
21: 3385 - 2005-02-17, -100 - update trans set balance=21, needsrebal=0 where id=547
20: 3385 - 2005-02-25, -1 - update trans set balance=20, needsrebal=0 where id=462
0: 3385 - 2005-04-13, -20 - update trans set balance=0, needsrebal=0 where id=1188
375: 3410 - 2004-10-08, 375 - update trans set balance=375, needsrebal=0 where id=725
356: 3410 - 2005-04-13, -19 - update trans set balance=356, needsrebal=0 where id=1270
226: 3410 - 2005-04-13, -130 - update trans set balance=226, needsrebal=0 where id=1189
151: 3410 - 2005-04-18, -75 - update trans set balance=151, needsrebal=0 where id=1231
95: 3410 - 2005-04-27, -56 - update trans set balance=95, needsrebal=0 where id=1387
94: 3410 - 2005-05-09, -1 - update trans set balance=94, needsrebal=0 where id=1507
92: 3410 - 2005-05-12, -2 - update trans set balance=92, needsrebal=0 where id=1554
76: 3410 - 2005-05-23, -16 - update trans set balance=76, needsrebal=0 where id=1696
75: 3410 - 2005-06-06, -1 - update trans set balance=75, needsrebal=0 where id=2039
0: 3410 - 2005-06-13, -75 - update trans set balance=0, needsrebal=0 where id=1825
375: 4024 - 2005-05-17, 375 - update trans set balance=375, needsrebal=0 where id=1721
300: 4024 - 2005-06-13, -75 - update trans set balance=300, needsrebal=0 where id=1826
299: 4024 - 2005-07-01, -1 - update trans set balance=299, needsrebal=0 where id=2007
149: 4024 - 2005-07-06, -150 - update trans set balance=149, needsrebal=0 where id=2055
74: 4024 - 2005-07-11, -75 - update trans set balance=74, needsrebal=0 where id=2120
73: 4024 - 2005-07-14, -1 - update trans set balance=73, needsrebal=0 where id=2188
145: 4024 - 2005-07-25, 72 - update trans set balance=145, needsrebal=0 where id=2279
0: 4024 - 2005-08-12, -145 - update trans set balance=0, needsrebal=0 where id=2326
145: 4024 - 2005-08-23, 145 - update trans set balance=145, needsrebal=0 where id=2643
0: 4024 - 2005-09-13, -145 - update trans set balance=0, needsrebal=0 where id=2650
1306: 4055 - 2005-07-22, 1306 - update trans set balance=1306, needsrebal=0 where id=2267
1381: 4055 - 2005-08-03, 75 - update trans set balance=1381, needsrebal=0 where id=2449
1236: 4055 - 2005-08-04, -145 - update trans set balance=1236, needsrebal=0 where id=2348
1233: 4055 - 2005-08-08, -3 - update trans set balance=1233, needsrebal=0 where id=2399
1078: 4055 - 2005-08-12, -155 - update trans set balance=1078, needsrebal=0 where id=2327
1233: 4055 - 2005-08-23, 155 - update trans set balance=1233, needsrebal=0 where id=2644
1008: 4055 - 2005-08-25, -225 - update trans set balance=1008, needsrebal=0 where id=2537
1003: 4055 - 2005-09-13, -5 - update trans set balance=1003, needsrebal=0 where id=2651
778: 4055 - 2005-09-30, -225 - update trans set balance=778, needsrebal=0 where id=2868
777: 4055 - 2005-10-24, -1 - update trans set balance=777, needsrebal=0 where id=3182
677: 4055 - 2005-10-24, -100 - update trans set balance=677, needsrebal=0 where id=3178
452: 4055 - 2005-10-27, -225 - update trans set balance=452, needsrebal=0 where id=3278
377: 4055 - 2005-11-23, -75 - update trans set balance=377, needsrebal=0 where id=3491
357: 4055 - 2006-01-03, -20 - update trans set balance=357, needsrebal=0 where id=3811
300: 4055 - 2006-01-05, -57 - update trans set balance=300, needsrebal=0 where id=3882
600: 4055 - 2006-01-20, 300 - update trans set balance=600, needsrebal=0 where id=4029
300: 4055 - 2006-01-26, -300 - update trans set balance=300, needsrebal=0 where id=4037
600: 4055 - 2006-02-03, 300 - update trans set balance=600, needsrebal=0 where id=4166
525: 4055 - 2006-02-28, -75 - update trans set balance=525, needsrebal=0 where id=4328
395: 4055 - 2006-02-28, -130 - update trans set balance=395, needsrebal=0 where id=4335
393: 4055 - 2006-03-22, -2 - update trans set balance=393, needsrebal=0 where id=4465
360: 4055 - 2006-04-10, -33 - update trans set balance=360, needsrebal=0 where id=4654
300: 4055 - 2006-04-13, -60 - update trans set balance=300, needsrebal=0 where id=4538
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 23, 'RR12BFBROT', '4055', 300, '2005-07-22','2006-04-13');
519: 4114 - 2005-11-14, 519 - update trans set balance=519, needsrebal=0 where id=3749
69: 4114 - 2005-11-28, -450 - update trans set balance=69, needsrebal=0 where id=3867
282: 4114 - 2005-12-23, 213 - update trans set balance=282, needsrebal=0 where id=3868
114: 4114 - 2006-01-05, -168 - update trans set balance=114, needsrebal=0 where id=3883
112: 4114 - 2006-01-26, -2 - update trans set balance=112, needsrebal=0 where id=4036
111: 4114 - 2006-01-30, -1 - update trans set balance=111, needsrebal=0 where id=4076
0: 4114 - 2006-02-28, -111 - update trans set balance=0, needsrebal=0 where id=4334
458: 3407 - 2005-01-01, 458 - update trans set balance=458, needsrebal=0 where id=734
457: 3407 - 2005-01-03, -1 - update trans set balance=457, needsrebal=0 where id=343
433: 3407 - 2005-01-03, -24 - update trans set balance=433, needsrebal=0 where id=348
421: 3407 - 2005-01-03, -12 - update trans set balance=421, needsrebal=0 where id=340
271: 3407 - 2005-01-04, -150 - update trans set balance=271, needsrebal=0 where id=321
241: 3407 - 2005-01-04, -30 - update trans set balance=241, needsrebal=0 where id=317
233: 3407 - 2005-01-17, -8 - update trans set balance=233, needsrebal=0 where id=191
231: 3407 - 2005-01-18, -2 - update trans set balance=231, needsrebal=0 where id=176
200: 3407 - 2005-01-20, -31 - update trans set balance=200, needsrebal=0 where id=165
199: 3407 - 2005-02-25, -1 - update trans set balance=199, needsrebal=0 where id=463
197: 3407 - 2005-03-11, -2 - update trans set balance=197, needsrebal=0 where id=866
196: 3407 - 2005-03-18, -1 - update trans set balance=196, needsrebal=0 where id=1143
195: 3407 - 2005-03-18, -1 - update trans set balance=195, needsrebal=0 where id=1151
120: 3407 - 2005-03-21, -75 - update trans set balance=120, needsrebal=0 where id=925
115: 3407 - 2005-03-22, -5 - update trans set balance=115, needsrebal=0 where id=991
90: 3407 - 2005-03-24, -25 - update trans set balance=90, needsrebal=0 where id=881
80: 3407 - 2005-03-29, -10 - update trans set balance=80, needsrebal=0 where id=965
79: 3407 - 2005-03-31, -1 - update trans set balance=79, needsrebal=0 where id=1114
64: 3407 - 2005-04-04, -15 - update trans set balance=64, needsrebal=0 where id=1300
38: 3407 - 2005-04-06, -26 - update trans set balance=38, needsrebal=0 where id=1295
0: 3407 - 2005-04-15, -38 - update trans set balance=0, needsrebal=0 where id=1217
2025: 3409 - 2004-10-08, 2025 - update trans set balance=2025, needsrebal=0 where id=735
2013: 3409 - 2005-01-19, -12 - update trans set balance=2013, needsrebal=0 where id=171
1984: 3409 - 2005-01-20, -29 - update trans set balance=1984, needsrebal=0 where id=417
1955: 3409 - 2005-01-25, -29 - update trans set balance=1955, needsrebal=0 where id=128
1952: 3409 - 2005-01-26, -3 - update trans set balance=1952, needsrebal=0 where id=106
1877: 3409 - 2005-01-27, -75 - update trans set balance=1877, needsrebal=0 where id=95
1848: 3409 - 2005-01-31, -29 - update trans set balance=1848, needsrebal=0 where id=76
1843: 3409 - 2005-01-31, -5 - update trans set balance=1843, needsrebal=0 where id=69
1842: 3409 - 2005-01-31, -1 - update trans set balance=1842, needsrebal=0 where id=49
1838: 3409 - 2005-01-31, -4 - update trans set balance=1838, needsrebal=0 where id=43
1832: 3409 - 2005-01-31, -6 - update trans set balance=1832, needsrebal=0 where id=62
1822: 3409 - 2005-02-01, -10 - update trans set balance=1822, needsrebal=0 where id=685
1806: 3409 - 2005-02-02, -16 - update trans set balance=1806, needsrebal=0 where id=670
1656: 3409 - 2005-02-03, -150 - update trans set balance=1656, needsrebal=0 where id=656
1654: 3409 - 2005-02-03, -2 - update trans set balance=1654, needsrebal=0 where id=659
1652: 3409 - 2005-02-07, -2 - update trans set balance=1652, needsrebal=0 where id=638
1646: 3409 - 2005-02-08, -6 - update trans set balance=1646, needsrebal=0 where id=610
1645: 3409 - 2005-02-10, -1 - update trans set balance=1645, needsrebal=0 where id=585
1629: 3409 - 2005-02-17, -16 - update trans set balance=1629, needsrebal=0 where id=549
1539: 3409 - 2005-02-25, -90 - update trans set balance=1539, needsrebal=0 where id=453
1538: 3409 - 2005-02-25, -1 - update trans set balance=1538, needsrebal=0 where id=475
1528: 3409 - 2005-02-25, -10 - update trans set balance=1528, needsrebal=0 where id=473
1484: 3409 - 2005-02-25, -44 - update trans set balance=1484, needsrebal=0 where id=445
1482: 3409 - 2005-03-09, -2 - update trans set balance=1482, needsrebal=0 where id=1139
1479: 3409 - 2005-03-09, -3 - update trans set balance=1479, needsrebal=0 where id=838
1478: 3409 - 2005-03-11, -1 - update trans set balance=1478, needsrebal=0 where id=1137
1463: 3409 - 2005-04-13, -15 - update trans set balance=1463, needsrebal=0 where id=1280
1411: 3409 - 2005-04-15, -52 - update trans set balance=1411, needsrebal=0 where id=1218
1321: 3409 - 2005-04-15, -90 - update trans set balance=1321, needsrebal=0 where id=1206
1231: 3409 - 2005-04-18, -90 - update trans set balance=1231, needsrebal=0 where id=1212
1227: 3409 - 2005-04-21, -4 - update trans set balance=1227, needsrebal=0 where id=1356
1212: 3409 - 2005-04-22, -15 - update trans set balance=1212, needsrebal=0 where id=1251
1182: 3409 - 2005-04-22, -30 - update trans set balance=1182, needsrebal=0 where id=1381
1170: 3409 - 2005-04-22, -12 - update trans set balance=1170, needsrebal=0 where id=1548
1168: 3409 - 2005-04-22, -2 - update trans set balance=1168, needsrebal=0 where id=1550
1167: 3409 - 2005-04-28, -1 - update trans set balance=1167, needsrebal=0 where id=1399
987: 3409 - 2005-05-03, -180 - update trans set balance=987, needsrebal=0 where id=1426
986: 3409 - 2005-05-09, -1 - update trans set balance=986, needsrebal=0 where id=1499
985: 3409 - 2005-05-09, -1 - update trans set balance=985, needsrebal=0 where id=1512
954: 3409 - 2005-05-11, -31 - update trans set balance=954, needsrebal=0 where id=1482
917: 3409 - 2005-05-13, -37 - update trans set balance=917, needsrebal=0 where id=1528
912: 3409 - 2005-05-16, -5 - update trans set balance=912, needsrebal=0 where id=1621
762: 3409 - 2005-05-20, -150 - update trans set balance=762, needsrebal=0 where id=1596
672: 3409 - 2005-05-20, -90 - update trans set balance=672, needsrebal=0 where id=1686
666: 3409 - 2005-05-23, -6 - update trans set balance=666, needsrebal=0 where id=1781
648: 3409 - 2005-05-27, -18 - update trans set balance=648, needsrebal=0 where id=1714
637: 3409 - 2005-05-27, -11 - update trans set balance=637, needsrebal=0 where id=1707
607: 3409 - 2005-06-08, -30 - update trans set balance=607, needsrebal=0 where id=2070
597: 3409 - 2005-06-13, -10 - update trans set balance=597, needsrebal=0 where id=1828
522: 3409 - 2005-06-21, -75 - update trans set balance=522, needsrebal=0 where id=1894
507: 3409 - 2005-06-30, -15 - update trans set balance=507, needsrebal=0 where id=1990
506: 3409 - 2005-07-01, -1 - update trans set balance=506, needsrebal=0 where id=2008
466: 3409 - 2005-07-06, -40 - update trans set balance=466, needsrebal=0 where id=2057
442: 3409 - 2005-07-07, -24 - update trans set balance=442, needsrebal=0 where id=2052
262: 3409 - 2005-07-28, -180 - update trans set balance=262, needsrebal=0 where id=2246
90: 3409 - 2005-07-28, -172 - update trans set balance=90, needsrebal=0 where id=2248
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 24, 'RR12BFCHIL', '3409', 90, '2004-10-08','2005-07-28');
267: 3441 - 2005-01-01, 267 - update trans set balance=267, needsrebal=0 where id=728
265: 3441 - 2005-07-21, -2 - update trans set balance=265, needsrebal=0 where id=2263
284: 3441 - 2005-07-22, 19 - update trans set balance=284, needsrebal=0 where id=2274
276: 3441 - 2005-07-28, -8 - update trans set balance=276, needsrebal=0 where id=2249
270: 3441 - 2005-08-02, -6 - update trans set balance=270, needsrebal=0 where id=2322
90: 3441 - 2005-08-03, -180 - update trans set balance=90, needsrebal=0 where id=2328
0: 3441 - 2005-09-01, -90 - update trans set balance=0, needsrebal=0 where id=2551
280: 3449 - 2005-01-01, 280 - update trans set balance=280, needsrebal=0 where id=731
269: 3449 - 2005-08-05, -11 - update trans set balance=269, needsrebal=0 where id=2375
266: 3449 - 2005-08-08, -3 - update trans set balance=266, needsrebal=0 where id=2397
260: 3449 - 2005-08-22, -6 - update trans set balance=260, needsrebal=0 where id=2512
229: 3449 - 2005-08-24, -31 - update trans set balance=229, needsrebal=0 where id=2472
139: 3449 - 2005-08-25, -90 - update trans set balance=139, needsrebal=0 where id=2505
90: 3449 - 2005-08-31, -49 - update trans set balance=90, needsrebal=0 where id=2556
0: 3449 - 2005-09-01, -90 - update trans set balance=0, needsrebal=0 where id=2552
427: 4022 - 2005-05-25, 427 - update trans set balance=427, needsrebal=0 where id=1718
418: 4022 - 2005-08-29, -9 - update trans set balance=418, needsrebal=0 where id=2543
377: 4022 - 2005-08-31, -41 - update trans set balance=377, needsrebal=0 where id=2557
362: 4022 - 2005-09-07, -15 - update trans set balance=362, needsrebal=0 where id=2595
257: 4022 - 2005-09-08, -105 - update trans set balance=257, needsrebal=0 where id=2628
77: 4022 - 2005-09-08, -180 - update trans set balance=77, needsrebal=0 where id=2621
75: 4022 - 2005-09-13, -2 - update trans set balance=75, needsrebal=0 where id=2635
0: 4022 - 2005-09-15, -75 - update trans set balance=0, needsrebal=0 where id=2727
929: 4025 - 2005-05-17, 929 - update trans set balance=929, needsrebal=0 where id=1722
925: 4025 - 2005-09-13, -4 - update trans set balance=925, needsrebal=0 where id=2636
918: 4025 - 2005-09-20, -7 - update trans set balance=918, needsrebal=0 where id=2729
896: 4025 - 2005-09-26, -22 - update trans set balance=896, needsrebal=0 where id=2866
671: 4025 - 2005-09-28, -225 - update trans set balance=671, needsrebal=0 where id=2846
670: 4025 - 2005-09-30, -1 - update trans set balance=670, needsrebal=0 where id=2872
635: 4025 - 2005-09-30, -35 - update trans set balance=635, needsrebal=0 where id=2870
632: 4025 - 2005-10-03, -3 - update trans set balance=632, needsrebal=0 where id=2882
603: 4025 - 2005-10-12, -29 - update trans set balance=603, needsrebal=0 where id=3030
598: 4025 - 2005-10-12, -5 - update trans set balance=598, needsrebal=0 where id=3056
569: 4025 - 2005-10-12, -29 - update trans set balance=569, needsrebal=0 where id=3059
567: 4025 - 2005-10-12, -2 - update trans set balance=567, needsrebal=0 where id=3083
550: 4025 - 2005-10-12, -17 - update trans set balance=550, needsrebal=0 where id=3021
547: 4025 - 2005-10-14, -3 - update trans set balance=547, needsrebal=0 where id=3139
472: 4025 - 2005-10-19, -75 - update trans set balance=472, needsrebal=0 where id=3077
457: 4025 - 2005-10-20, -15 - update trans set balance=457, needsrebal=0 where id=3087
449: 4025 - 2005-10-25, -8 - update trans set balance=449, needsrebal=0 where id=3211
374: 4025 - 2005-10-27, -75 - update trans set balance=374, needsrebal=0 where id=3279
368: 4025 - 2005-10-28, -6 - update trans set balance=368, needsrebal=0 where id=3296
143: 4025 - 2005-11-08, -225 - update trans set balance=143, needsrebal=0 where id=3338
106: 4025 - 2005-11-11, -37 - update trans set balance=106, needsrebal=0 where id=3375
72: 4025 - 2005-11-17, -34 - update trans set balance=72, needsrebal=0 where id=3377
71: 4025 - 2005-11-18, -1 - update trans set balance=71, needsrebal=0 where id=3454
0: 4025 - 2005-11-28, -71 - update trans set balance=0, needsrebal=0 where id=3510
1411: 4106 - 2005-11-02, 1411 - update trans set balance=1411, needsrebal=0 where id=3336
1294: 4106 - 2005-11-28, -117 - update trans set balance=1294, needsrebal=0 where id=3511
1206: 4106 - 2005-12-02, -88 - update trans set balance=1206, needsrebal=0 where id=3556
1131: 4106 - 2005-12-08, -75 - update trans set balance=1131, needsrebal=0 where id=3634
1127: 4106 - 2005-12-19, -4 - update trans set balance=1127, needsrebal=0 where id=3724
1081: 4106 - 2005-12-21, -46 - update trans set balance=1081, needsrebal=0 where id=3717
1036: 4106 - 2005-12-27, -45 - update trans set balance=1036, needsrebal=0 where id=3764
1028: 4106 - 2005-12-27, -8 - update trans set balance=1028, needsrebal=0 where id=3761
1025: 4106 - 2006-01-04, -3 - update trans set balance=1025, needsrebal=0 where id=3856
1023: 4106 - 2006-01-30, -2 - update trans set balance=1023, needsrebal=0 where id=4079
948: 4106 - 2006-01-30, -75 - update trans set balance=948, needsrebal=0 where id=4070
938: 4106 - 2006-01-30, -10 - update trans set balance=938, needsrebal=0 where id=4048
937: 4106 - 2006-01-30, -1 - update trans set balance=937, needsrebal=0 where id=4074
912: 4106 - 2006-02-03, -25 - update trans set balance=912, needsrebal=0 where id=4130
902: 4106 - 2006-02-20, -10 - update trans set balance=902, needsrebal=0 where id=4241
752: 4106 - 2006-02-24, -150 - update trans set balance=752, needsrebal=0 where id=4305
748: 4106 - 2006-02-28, -4 - update trans set balance=748, needsrebal=0 where id=4319
673: 4106 - 2006-03-02, -75 - update trans set balance=673, needsrebal=0 where id=4393
638: 4106 - 2006-03-06, -35 - update trans set balance=638, needsrebal=0 where id=4341
636: 4106 - 2006-03-10, -2 - update trans set balance=636, needsrebal=0 where id=4405
591: 4106 - 2006-03-16, -45 - update trans set balance=591, needsrebal=0 where id=4408
492: 4106 - 2006-03-21, -99 - update trans set balance=492, needsrebal=0 where id=4477
489: 4106 - 2006-03-22, -3 - update trans set balance=489, needsrebal=0 where id=4473
451: 4106 - 2006-03-24, -38 - update trans set balance=451, needsrebal=0 where id=4479
450: 4106 - 2006-03-28, -1 - update trans set balance=450, needsrebal=0 where id=4492
447: 4106 - 2006-03-30, -3 - update trans set balance=447, needsrebal=0 where id=4521
437: 4106 - 2006-04-05, -10 - update trans set balance=437, needsrebal=0 where id=4528
407: 4106 - 2006-04-05, -30 - update trans set balance=407, needsrebal=0 where id=4615
382: 4106 - 2006-04-20, -25 - update trans set balance=382, needsrebal=0 where id=4570
353: 4106 - 2006-04-21, -29 - update trans set balance=353, needsrebal=0 where id=4581
90: 4106 - 2006-04-25, -263 - update trans set balance=90, needsrebal=0 where id=4720
75: 4106 - 2006-04-25, -15 - update trans set balance=75, needsrebal=0 where id=4574
66: 4106 - 2006-05-01, -9 - update trans set balance=66, needsrebal=0 where id=4779
62: 4106 - 2006-05-19, -4 - update trans set balance=62, needsrebal=0 where id=4844
0: 4106 - 2006-05-30, -62 - update trans set balance=0, needsrebal=0 where id=4881
2146: 4136 - 2005-12-09, 2146 - update trans set balance=2146, needsrebal=0 where id=3665
2106: 4136 - 2006-05-30, -40 - update trans set balance=2106, needsrebal=0 where id=4890
2104: 4136 - 2006-05-30, -2 - update trans set balance=2104, needsrebal=0 where id=4898
2091: 4136 - 2006-05-30, -13 - update trans set balance=2091, needsrebal=0 where id=4882
2016: 4136 - 2006-07-05, -75 - update trans set balance=2016, needsrebal=0 where id=4988
1866: 4136 - 2006-07-25, -150 - update trans set balance=1866, needsrebal=0 where id=5005
1846: 4136 - 2006-07-31, -20 - update trans set balance=1846, needsrebal=0 where id=5012
1827: 4136 - 2006-07-31, -19 - update trans set balance=1827, needsrebal=0 where id=5008
1825: 4136 - 2006-08-08, -2 - update trans set balance=1825, needsrebal=0 where id=5034
1777: 4136 - 2006-08-23, -48 - update trans set balance=1777, needsrebal=0 where id=5041
1742: 4136 - 2006-08-24, -35 - update trans set balance=1742, needsrebal=0 where id=5058
1732: 4136 - 2006-09-07, -10 - update trans set balance=1732, needsrebal=0 where id=5083
1715: 4136 - 2006-09-11, -17 - update trans set balance=1715, needsrebal=0 where id=5078
1675: 4136 - 2006-09-26, -40 - update trans set balance=1675, needsrebal=0 where id=5101
1660: 4136 - 2006-09-27, -15 - update trans set balance=1660, needsrebal=0 where id=5097
1585: 4136 - 2006-09-28, -75 - update trans set balance=1585, needsrebal=0 where id=5123
1435: 4136 - 2006-10-04, -150 - update trans set balance=1435, needsrebal=0 where id=5117
1360: 4136 - 2006-10-06, -75 - update trans set balance=1360, needsrebal=0 where id=5127
1320: 4136 - 2006-10-10, -40 - update trans set balance=1320, needsrebal=0 where id=5130
1298: 4136 - 2006-10-10, -22 - update trans set balance=1298, needsrebal=0 where id=5128
1245: 4136 - 2006-10-31, -53 - update trans set balance=1245, needsrebal=0 where id=5149
1200: 4136 - 2006-11-07, -45 - update trans set balance=1200, needsrebal=0 where id=5155
1050: 4136 - 2006-11-14, -150 - update trans set balance=1050, needsrebal=0 where id=5166
917: 4136 - 2006-11-15, -133 - update trans set balance=917, needsrebal=0 where id=5170
898: 4136 - 2006-11-15, -19 - update trans set balance=898, needsrebal=0 where id=5175
880: 4136 - 2006-12-01, -18 - update trans set balance=880, needsrebal=0 where id=5185
840: 4136 - 2006-12-05, -40 - update trans set balance=840, needsrebal=0 where id=5183
815: 4136 - 2006-12-15, -25 - update trans set balance=815, needsrebal=0 where id=5197
776: 4136 - 2007-01-24, -39 - update trans set balance=776, needsrebal=0 where id=5207
758: 4136 - 2007-02-12, -18 - update trans set balance=758, needsrebal=0 where id=5229
721: 4136 - 2007-03-13, -37 - update trans set balance=721, needsrebal=0 where id=5236
713: 4136 - 2007-03-20, -8 - update trans set balance=713, needsrebal=0 where id=5244
684: 4136 - 2007-04-10, -29 - update trans set balance=684, needsrebal=0 where id=5250
534: 4136 - 2007-04-10, -150 - update trans set balance=534, needsrebal=0 where id=5249
514: 4136 - 2007-04-23, -20 - update trans set balance=514, needsrebal=0 where id=5260
439: 4136 - 2007-05-29, -75 - update trans set balance=439, needsrebal=0 where id=5285
403: 4136 - 2007-06-29, -36 - update trans set balance=403, needsrebal=0 where id=5287
383: 4136 - 2007-07-16, -20 - update trans set balance=383, needsrebal=0 where id=5289
349: 4136 - 2007-07-30, -34 - update trans set balance=349, needsrebal=0 where id=5293
274: 4136 - 2007-08-16, -75 - update trans set balance=274, needsrebal=0 where id=5301
244: 4136 - 2007-08-28, -30 - update trans set balance=244, needsrebal=0 where id=5440
214: 4136 - 2007-10-01, -30 - update trans set balance=214, needsrebal=0 where id=5720
0: 4136 - 2007-10-01, -214 - update trans set balance=0, needsrebal=0 where id=5508
1638: 3433 - 2005-01-01, 1638 - update trans set balance=1638, needsrebal=0 where id=747
1631: 3433 - 2005-01-03, -7 - update trans set balance=1631, needsrebal=0 where id=344
1592: 3433 - 2005-01-03, -39 - update trans set balance=1592, needsrebal=0 where id=349
1589: 3433 - 2005-01-03, -3 - update trans set balance=1589, needsrebal=0 where id=341
1559: 3433 - 2005-01-04, -30 - update trans set balance=1559, needsrebal=0 where id=322
1544: 3433 - 2005-01-04, -15 - update trans set balance=1544, needsrebal=0 where id=318
1529: 3433 - 2005-01-12, -15 - update trans set balance=1529, needsrebal=0 where id=265
1526: 3433 - 2005-01-17, -3 - update trans set balance=1526, needsrebal=0 where id=192
1514: 3433 - 2005-01-19, -12 - update trans set balance=1514, needsrebal=0 where id=172
1454: 3433 - 2005-01-20, -60 - update trans set balance=1454, needsrebal=0 where id=166
1404: 3433 - 2005-01-25, -50 - update trans set balance=1404, needsrebal=0 where id=129
1403: 3433 - 2005-01-28, -1 - update trans set balance=1403, needsrebal=0 where id=89
1355: 3433 - 2005-01-31, -48 - update trans set balance=1355, needsrebal=0 where id=77
1345: 3433 - 2005-01-31, -10 - update trans set balance=1345, needsrebal=0 where id=70
1341: 3433 - 2005-01-31, -4 - update trans set balance=1341, needsrebal=0 where id=44
1335: 3433 - 2005-01-31, -6 - update trans set balance=1335, needsrebal=0 where id=63
1325: 3433 - 2005-02-01, -10 - update trans set balance=1325, needsrebal=0 where id=686
1296: 3433 - 2005-02-02, -29 - update trans set balance=1296, needsrebal=0 where id=566
1221: 3433 - 2005-02-03, -75 - update trans set balance=1221, needsrebal=0 where id=658
1219: 3433 - 2005-02-03, -2 - update trans set balance=1219, needsrebal=0 where id=660
1214: 3433 - 2005-02-07, -5 - update trans set balance=1214, needsrebal=0 where id=637
1205: 3433 - 2005-02-08, -9 - update trans set balance=1205, needsrebal=0 where id=608
1190: 3433 - 2005-02-17, -15 - update trans set balance=1190, needsrebal=0 where id=550
1100: 3433 - 2005-02-25, -90 - update trans set balance=1100, needsrebal=0 where id=454
1099: 3433 - 2005-02-25, -1 - update trans set balance=1099, needsrebal=0 where id=476
1069: 3433 - 2005-02-25, -30 - update trans set balance=1069, needsrebal=0 where id=469
1068: 3433 - 2005-02-25, -1 - update trans set balance=1068, needsrebal=0 where id=464
1007: 3433 - 2005-02-25, -61 - update trans set balance=1007, needsrebal=0 where id=443
1005: 3433 - 2005-03-03, -2 - update trans set balance=1005, needsrebal=0 where id=1155
1001: 3433 - 2005-03-09, -4 - update trans set balance=1001, needsrebal=0 where id=1142
995: 3433 - 2005-03-09, -6 - update trans set balance=995, needsrebal=0 where id=839
1000: 3433 - 2005-03-11, 5 - update trans set balance=1000, needsrebal=0 where id=1131
745: 3433 - 2005-03-11, -255 - update trans set balance=745, needsrebal=0 where id=919
744: 3433 - 2005-03-11, -1 - update trans set balance=744, needsrebal=0 where id=1136
742: 3433 - 2005-03-11, -2 - update trans set balance=742, needsrebal=0 where id=865
727: 3433 - 2005-03-16, -15 - update trans set balance=727, needsrebal=0 where id=879
726: 3433 - 2005-03-18, -1 - update trans set balance=726, needsrebal=0 where id=1144
725: 3433 - 2005-03-18, -1 - update trans set balance=725, needsrebal=0 where id=1152
575: 3433 - 2005-03-21, -150 - update trans set balance=575, needsrebal=0 where id=924
570: 3433 - 2005-03-22, -5 - update trans set balance=570, needsrebal=0 where id=992
531: 3433 - 2005-03-24, -39 - update trans set balance=531, needsrebal=0 where id=882
530: 3433 - 2005-03-28, -1 - update trans set balance=530, needsrebal=0 where id=986
529: 3433 - 2005-03-31, -1 - update trans set balance=529, needsrebal=0 where id=931
528: 3433 - 2005-03-31, -1 - update trans set balance=528, needsrebal=0 where id=1113
513: 3433 - 2005-04-04, -15 - update trans set balance=513, needsrebal=0 where id=1299
486: 3433 - 2005-04-06, -27 - update trans set balance=486, needsrebal=0 where id=1293
471: 3433 - 2005-04-13, -15 - update trans set balance=471, needsrebal=0 where id=1278
396: 3433 - 2005-04-13, -75 - update trans set balance=396, needsrebal=0 where id=1268
306: 3433 - 2005-04-15, -90 - update trans set balance=306, needsrebal=0 where id=1219
216: 3433 - 2005-04-15, -90 - update trans set balance=216, needsrebal=0 where id=1207
126: 3433 - 2005-04-18, -90 - update trans set balance=126, needsrebal=0 where id=1201
36: 3433 - 2005-04-18, -90 - update trans set balance=36, needsrebal=0 where id=1213
0: 3433 - 2005-04-18, -36 - update trans set balance=0, needsrebal=0 where id=1227
1349: 3440 - 2004-11-08, 1349 - update trans set balance=1349, needsrebal=0 where id=727
1310: 3440 - 2005-04-18, -39 - update trans set balance=1310, needsrebal=0 where id=1228
1308: 3440 - 2005-04-21, -2 - update trans set balance=1308, needsrebal=0 where id=1358
1272: 3440 - 2005-04-22, -36 - update trans set balance=1272, needsrebal=0 where id=1252
1242: 3440 - 2005-04-22, -30 - update trans set balance=1242, needsrebal=0 where id=1380
1240: 3440 - 2005-04-22, -2 - update trans set balance=1240, needsrebal=0 where id=1549
1240: 3440 - 2005-04-22, 0 - update trans set balance=1240, needsrebal=0 where id=1866
882: 3440 - 2005-04-27, -358 - update trans set balance=882, needsrebal=0 where id=1345
881: 3440 - 2005-04-28, -1 - update trans set balance=881, needsrebal=0 where id=1400
879: 3440 - 2005-05-03, -2 - update trans set balance=879, needsrebal=0 where id=1437
878: 3440 - 2005-05-09, -1 - update trans set balance=878, needsrebal=0 where id=1498
875: 3440 - 2005-05-09, -3 - update trans set balance=875, needsrebal=0 where id=1509
853: 3440 - 2005-05-11, -22 - update trans set balance=853, needsrebal=0 where id=1483
822: 3440 - 2005-05-13, -31 - update trans set balance=822, needsrebal=0 where id=1529
792: 3440 - 2005-05-13, -30 - update trans set balance=792, needsrebal=0 where id=1572
791: 3440 - 2005-05-13, -1 - update trans set balance=791, needsrebal=0 where id=1586
788: 3440 - 2005-05-16, -3 - update trans set balance=788, needsrebal=0 where id=1623
713: 3440 - 2005-05-20, -75 - update trans set balance=713, needsrebal=0 where id=1595
712: 3440 - 2005-05-20, -1 - update trans set balance=712, needsrebal=0 where id=1690
696: 3440 - 2005-05-23, -16 - update trans set balance=696, needsrebal=0 where id=1695
690: 3440 - 2005-05-23, -6 - update trans set balance=690, needsrebal=0 where id=1782
665: 3440 - 2005-05-27, -25 - update trans set balance=665, needsrebal=0 where id=1715
650: 3440 - 2005-05-27, -15 - update trans set balance=650, needsrebal=0 where id=1709
400: 3440 - 2005-06-02, -250 - update trans set balance=400, needsrebal=0 where id=1676
310: 3440 - 2005-06-07, -90 - update trans set balance=310, needsrebal=0 where id=2045
280: 3440 - 2005-06-08, -30 - update trans set balance=280, needsrebal=0 where id=2040
270: 3440 - 2005-06-13, -10 - update trans set balance=270, needsrebal=0 where id=1827
195: 3440 - 2005-06-21, -75 - update trans set balance=195, needsrebal=0 where id=1893
90: 3440 - 2005-06-22, -105 - update trans set balance=90, needsrebal=0 where id=1909
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 25, 'RR12BFST12', '3440', 90, '2004-11-08','2005-06-22');
1997: 4023 - 2005-05-17, 1997 - update trans set balance=1997, needsrebal=0 where id=1720
1805: 4023 - 2005-06-22, -192 - update trans set balance=1805, needsrebal=0 where id=1910
1790: 4023 - 2005-06-30, -15 - update trans set balance=1790, needsrebal=0 where id=1991
1789: 4023 - 2005-07-01, -1 - update trans set balance=1789, needsrebal=0 where id=2006
1788: 4023 - 2005-07-05, -1 - update trans set balance=1788, needsrebal=0 where id=2930
1748: 4023 - 2005-07-06, -40 - update trans set balance=1748, needsrebal=0 where id=2056
1728: 4023 - 2005-07-07, -20 - update trans set balance=1728, needsrebal=0 where id=2053
1653: 4023 - 2005-07-11, -75 - update trans set balance=1653, needsrebal=0 where id=2117
1578: 4023 - 2005-07-15, -75 - update trans set balance=1578, needsrebal=0 where id=2169
1398: 4023 - 2005-07-21, -180 - update trans set balance=1398, needsrebal=0 where id=2200
1397: 4023 - 2005-07-21, -1 - update trans set balance=1397, needsrebal=0 where id=2237
1414: 4023 - 2005-07-22, 17 - update trans set balance=1414, needsrebal=0 where id=2273
1324: 4023 - 2005-07-27, -90 - update trans set balance=1324, needsrebal=0 where id=2254
1144: 4023 - 2005-07-28, -180 - update trans set balance=1144, needsrebal=0 where id=2250
1139: 4023 - 2005-08-02, -5 - update trans set balance=1139, needsrebal=0 where id=2324
959: 4023 - 2005-08-03, -180 - update trans set balance=959, needsrebal=0 where id=2329
940: 4023 - 2005-08-05, -19 - update trans set balance=940, needsrebal=0 where id=2338
902: 4023 - 2005-08-05, -38 - update trans set balance=902, needsrebal=0 where id=2376
899: 4023 - 2005-08-08, -3 - update trans set balance=899, needsrebal=0 where id=2396
918: 4023 - 2005-08-09, 19 - update trans set balance=918, needsrebal=0 where id=2395
888: 4023 - 2005-08-19, -30 - update trans set balance=888, needsrebal=0 where id=2489
884: 4023 - 2005-08-22, -4 - update trans set balance=884, needsrebal=0 where id=2513
822: 4023 - 2005-08-24, -62 - update trans set balance=822, needsrebal=0 where id=2473
732: 4023 - 2005-08-25, -90 - update trans set balance=732, needsrebal=0 where id=2506
657: 4023 - 2005-08-25, -75 - update trans set balance=657, needsrebal=0 where id=2535
653: 4023 - 2005-08-29, -4 - update trans set balance=653, needsrebal=0 where id=2545
563: 4023 - 2005-08-31, -90 - update trans set balance=563, needsrebal=0 where id=2558
533: 4023 - 2005-09-01, -30 - update trans set balance=533, needsrebal=0 where id=2553
513: 4023 - 2005-09-07, -20 - update trans set balance=513, needsrebal=0 where id=2594
408: 4023 - 2005-09-08, -105 - update trans set balance=408, needsrebal=0 where id=2629
228: 4023 - 2005-09-08, -180 - update trans set balance=228, needsrebal=0 where id=2622
224: 4023 - 2005-09-13, -4 - update trans set balance=224, needsrebal=0 where id=2637
149: 4023 - 2005-09-15, -75 - update trans set balance=149, needsrebal=0 where id=2726
0: 4023 - 2005-09-21, -149 - update trans set balance=0, needsrebal=0 where id=2733
1939: 4046 - 2005-07-22, 1939 - update trans set balance=1939, needsrebal=0 where id=2266
1930: 4046 - 2005-09-20, -9 - update trans set balance=1930, needsrebal=0 where id=2731
1824: 4046 - 2005-09-21, -106 - update trans set balance=1824, needsrebal=0 where id=2734
1794: 4046 - 2005-09-22, -30 - update trans set balance=1794, needsrebal=0 where id=2933
1772: 4046 - 2005-09-26, -22 - update trans set balance=1772, needsrebal=0 where id=2867
1747: 4046 - 2005-09-26, -25 - update trans set balance=1747, needsrebal=0 where id=2735
997: 4046 - 2005-09-28, -750 - update trans set balance=997, needsrebal=0 where id=2931
957: 4046 - 2005-09-30, -40 - update trans set balance=957, needsrebal=0 where id=2869
954: 4046 - 2005-10-03, -3 - update trans set balance=954, needsrebal=0 where id=2883
930: 4046 - 2005-10-12, -24 - update trans set balance=930, needsrebal=0 where id=3031
920: 4046 - 2005-10-12, -10 - update trans set balance=920, needsrebal=0 where id=3058
899: 4046 - 2005-10-12, -21 - update trans set balance=899, needsrebal=0 where id=3060
898: 4046 - 2005-10-12, -1 - update trans set balance=898, needsrebal=0 where id=3085
893: 4046 - 2005-10-12, -5 - update trans set balance=893, needsrebal=0 where id=3023
713: 4046 - 2005-10-13, -180 - update trans set balance=713, needsrebal=0 where id=3052
708: 4046 - 2005-10-14, -5 - update trans set balance=708, needsrebal=0 where id=3138
633: 4046 - 2005-10-19, -75 - update trans set balance=633, needsrebal=0 where id=3076
597: 4046 - 2005-10-20, -36 - update trans set balance=597, needsrebal=0 where id=3088
593: 4046 - 2005-10-25, -4 - update trans set balance=593, needsrebal=0 where id=3213
413: 4046 - 2005-10-26, -180 - update trans set balance=413, needsrebal=0 where id=3203
68: 4046 - 2005-10-27, -345 - update trans set balance=68, needsrebal=0 where id=3205
53: 4046 - 2005-10-27, -15 - update trans set balance=53, needsrebal=0 where id=3217
47: 4046 - 2005-10-28, -6 - update trans set balance=47, needsrebal=0 where id=3295
46: 4046 - 2005-10-31, -1 - update trans set balance=46, needsrebal=0 where id=3306
16: 4046 - 2005-11-18, -30 - update trans set balance=16, needsrebal=0 where id=3433
2: 4046 - 2005-11-18, -14 - update trans set balance=2, needsrebal=0 where id=3431
0: 4046 - 2005-11-18, -2 - update trans set balance=0, needsrebal=0 where id=3453
1800: 4107 - 2005-11-02, 1800 - update trans set balance=1800, needsrebal=0 where id=3335
1575: 4107 - 2005-11-08, -225 - update trans set balance=1575, needsrebal=0 where id=3337
1570: 4107 - 2005-11-10, -5 - update trans set balance=1570, needsrebal=0 where id=3362
1501: 4107 - 2005-11-17, -69 - update trans set balance=1501, needsrebal=0 where id=3378
1485: 4107 - 2005-11-18, -16 - update trans set balance=1485, needsrebal=0 where id=3432
746: 4107 - 2005-11-28, -739 - update trans set balance=746, needsrebal=0 where id=3504
671: 4107 - 2005-12-01, -75 - update trans set balance=671, needsrebal=0 where id=3558
669: 4107 - 2005-12-02, -2 - update trans set balance=669, needsrebal=0 where id=3754
519: 4107 - 2005-12-08, -150 - update trans set balance=519, needsrebal=0 where id=3633
474: 4107 - 2005-12-15, -45 - update trans set balance=474, needsrebal=0 where id=3688
466: 4107 - 2005-12-19, -8 - update trans set balance=466, needsrebal=0 where id=3723
406: 4107 - 2005-12-21, -60 - update trans set balance=406, needsrebal=0 where id=3739
401: 4107 - 2005-12-21, -5 - update trans set balance=401, needsrebal=0 where id=3751
367: 4107 - 2005-12-21, -34 - update trans set balance=367, needsrebal=0 where id=3718
323: 4107 - 2005-12-27, -44 - update trans set balance=323, needsrebal=0 where id=3765
304: 4107 - 2005-12-27, -19 - update trans set balance=304, needsrebal=0 where id=3762
284: 4107 - 2006-01-03, -20 - update trans set balance=284, needsrebal=0 where id=3809
272: 4107 - 2006-01-04, -12 - update trans set balance=272, needsrebal=0 where id=3858
197: 4107 - 2006-01-05, -75 - update trans set balance=197, needsrebal=0 where id=3879
152: 4107 - 2006-01-06, -45 - update trans set balance=152, needsrebal=0 where id=3872
176: 4107 - 2006-01-13, 24 - update trans set balance=176, needsrebal=0 where id=3981
171: 4107 - 2006-01-16, -5 - update trans set balance=171, needsrebal=0 where id=3971
170: 4107 - 2006-01-30, -1 - update trans set balance=170, needsrebal=0 where id=4080
145: 4107 - 2006-01-30, -25 - update trans set balance=145, needsrebal=0 where id=4050
144: 4107 - 2006-01-30, -1 - update trans set balance=144, needsrebal=0 where id=4073
119: 4107 - 2006-02-03, -25 - update trans set balance=119, needsrebal=0 where id=4131
118: 4107 - 2006-02-13, -1 - update trans set balance=118, needsrebal=0 where id=4249
106: 4107 - 2006-02-20, -12 - update trans set balance=106, needsrebal=0 where id=4243
60: 4107 - 2006-02-24, -46 - update trans set balance=60, needsrebal=0 where id=4303
0: 4107 - 2006-02-24, -60 - update trans set balance=0, needsrebal=0 where id=4285
1500: 4138 - 2005-12-12, 1500 - update trans set balance=1500, needsrebal=0 where id=3663
1471: 4138 - 2006-02-24, -29 - update trans set balance=1471, needsrebal=0 where id=4304
1412: 4138 - 2006-03-06, -59 - update trans set balance=1412, needsrebal=0 where id=4342
1367: 4138 - 2006-03-16, -45 - update trans set balance=1367, needsrebal=0 where id=4413
1322: 4138 - 2006-03-16, -45 - update trans set balance=1322, needsrebal=0 where id=4409
1320: 4138 - 2006-03-22, -2 - update trans set balance=1320, needsrebal=0 where id=4463
1314: 4138 - 2006-03-22, -6 - update trans set balance=1314, needsrebal=0 where id=4472
1277: 4138 - 2006-03-24, -37 - update trans set balance=1277, needsrebal=0 where id=4480
1276: 4138 - 2006-03-29, -1 - update trans set balance=1276, needsrebal=0 where id=4504
1268: 4138 - 2006-03-30, -8 - update trans set balance=1268, needsrebal=0 where id=4522
1208: 4138 - 2006-03-31, -60 - update trans set balance=1208, needsrebal=0 where id=4510
1178: 4138 - 2006-04-05, -30 - update trans set balance=1178, needsrebal=0 where id=4623
1148: 4138 - 2006-04-05, -30 - update trans set balance=1148, needsrebal=0 where id=4616
1088: 4138 - 2006-04-06, -60 - update trans set balance=1088, needsrebal=0 where id=4629
1058: 4138 - 2006-04-07, -30 - update trans set balance=1058, needsrebal=0 where id=4611
1013: 4138 - 2006-04-10, -45 - update trans set balance=1013, needsrebal=0 where id=4607
983: 4138 - 2006-04-20, -30 - update trans set balance=983, needsrebal=0 where id=4569
908: 4138 - 2006-04-20, -75 - update trans set balance=908, needsrebal=0 where id=4686
862: 4138 - 2006-04-21, -46 - update trans set balance=862, needsrebal=0 where id=4582
1253: 4138 - 2006-04-25, 391 - update trans set balance=1253, needsrebal=0 where id=4718
1238: 4138 - 2006-04-25, -15 - update trans set balance=1238, needsrebal=0 where id=4576
1163: 4138 - 2006-04-25, -75 - update trans set balance=1163, needsrebal=0 where id=4700
1148: 4138 - 2006-05-01, -15 - update trans set balance=1148, needsrebal=0 where id=4781
1103: 4138 - 2006-05-04, -45 - update trans set balance=1103, needsrebal=0 where id=4793
1088: 4138 - 2006-05-09, -15 - update trans set balance=1088, needsrebal=0 where id=4808
1013: 4138 - 2006-05-18, -75 - update trans set balance=1013, needsrebal=0 where id=4823
938: 4138 - 2006-05-18, -75 - update trans set balance=938, needsrebal=0 where id=4822
934: 4138 - 2006-05-19, -4 - update trans set balance=934, needsrebal=0 where id=4843
874: 4138 - 2006-05-25, -60 - update trans set balance=874, needsrebal=0 where id=4859
824: 4138 - 2006-05-30, -50 - update trans set balance=824, needsrebal=0 where id=4891
822: 4138 - 2006-05-30, -2 - update trans set balance=822, needsrebal=0 where id=4899
747: 4138 - 2006-05-30, -75 - update trans set balance=747, needsrebal=0 where id=4880
672: 4138 - 2006-07-05, -75 - update trans set balance=672, needsrebal=0 where id=4987
522: 4138 - 2006-07-25, -150 - update trans set balance=522, needsrebal=0 where id=5006
519: 4138 - 2006-07-25, -3 - update trans set balance=519, needsrebal=0 where id=5010
461: 4138 - 2006-07-31, -58 - update trans set balance=461, needsrebal=0 where id=5013
435: 4138 - 2006-07-31, -26 - update trans set balance=435, needsrebal=0 where id=5009
360: 4138 - 2006-08-09, -75 - update trans set balance=360, needsrebal=0 where id=5031
331: 4138 - 2006-08-23, -29 - update trans set balance=331, needsrebal=0 where id=5042
296: 4138 - 2006-08-24, -35 - update trans set balance=296, needsrebal=0 where id=5056
286: 4138 - 2006-09-07, -10 - update trans set balance=286, needsrebal=0 where id=5082
214: 4138 - 2006-09-11, -72 - update trans set balance=214, needsrebal=0 where id=5079
149: 4138 - 2006-09-26, -65 - update trans set balance=149, needsrebal=0 where id=5102
74: 4138 - 2006-09-28, -75 - update trans set balance=74, needsrebal=0 where id=5124
0: 4138 - 2006-10-04, -74 - update trans set balance=0, needsrebal=0 where id=5118
1350: 4153 - 2005-12-28, 1350 - update trans set balance=1350, needsrebal=0 where id=3827
1349: 4153 - 2006-10-04, -1 - update trans set balance=1349, needsrebal=0 where id=5119
1274: 4153 - 2006-10-10, -75 - update trans set balance=1274, needsrebal=0 where id=5131
1239: 4153 - 2006-10-10, -35 - update trans set balance=1239, needsrebal=0 where id=5129
1216: 4153 - 2006-10-31, -23 - update trans set balance=1216, needsrebal=0 where id=5150
1166: 4153 - 2006-11-07, -50 - update trans set balance=1166, needsrebal=0 where id=5156
1016: 4153 - 2006-11-14, -150 - update trans set balance=1016, needsrebal=0 where id=5165
694: 4153 - 2006-11-15, -322 - update trans set balance=694, needsrebal=0 where id=5169
664: 4153 - 2006-11-15, -30 - update trans set balance=664, needsrebal=0 where id=5174
634: 4153 - 2006-12-01, -30 - update trans set balance=634, needsrebal=0 where id=5186
599: 4153 - 2006-12-05, -35 - update trans set balance=599, needsrebal=0 where id=5184
549: 4153 - 2006-12-15, -50 - update trans set balance=549, needsrebal=0 where id=5198
513: 4153 - 2007-01-24, -36 - update trans set balance=513, needsrebal=0 where id=5208
483: 4153 - 2007-02-12, -30 - update trans set balance=483, needsrebal=0 where id=5230
431: 4153 - 2007-03-13, -52 - update trans set balance=431, needsrebal=0 where id=5237
423: 4153 - 2007-03-20, -8 - update trans set balance=423, needsrebal=0 where id=5243
422: 4153 - 2007-03-21, -1 - update trans set balance=422, needsrebal=0 where id=5245
365: 4153 - 2007-04-10, -57 - update trans set balance=365, needsrebal=0 where id=5251
335: 4153 - 2007-04-23, -30 - update trans set balance=335, needsrebal=0 where id=5261
260: 4153 - 2007-05-29, -75 - update trans set balance=260, needsrebal=0 where id=5284
211: 4153 - 2007-06-29, -49 - update trans set balance=211, needsrebal=0 where id=5288
136: 4153 - 2007-07-13, -75 - update trans set balance=136, needsrebal=0 where id=5292
106: 4153 - 2007-07-16, -30 - update trans set balance=106, needsrebal=0 where id=5290
59: 4153 - 2007-07-30, -47 - update trans set balance=59, needsrebal=0 where id=5294
7: 4153 - 2007-08-28, -52 - update trans set balance=7, needsrebal=0 where id=5441
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 25, 'RR12BFST12', '4153', 7, '2005-12-28','2007-08-28');
893: #4079 - 2005-09-12, 893 - update trans set balance=893, needsrebal=0 where id=2685
831: #4079 - 2005-09-28, -62 - update trans set balance=831, needsrebal=0 where id=2794
825: #4079 - 2005-10-03, -6 - update trans set balance=825, needsrebal=0 where id=2881
600: #4079 - 2005-10-10, -225 - update trans set balance=600, needsrebal=0 where id=2891
575: #4079 - 2005-10-12, -25 - update trans set balance=575, needsrebal=0 where id=3055
569: #4079 - 2005-10-12, -6 - update trans set balance=569, needsrebal=0 where id=3022
549: #4079 - 2005-10-13, -20 - update trans set balance=549, needsrebal=0 where id=3080
548: #4079 - 2005-10-14, -1 - update trans set balance=548, needsrebal=0 where id=3140
248: #4079 - 2005-10-24, -300 - update trans set balance=248, needsrebal=0 where id=3095
238: #4079 - 2005-10-25, -10 - update trans set balance=238, needsrebal=0 where id=3212
193: #4079 - 2005-10-27, -45 - update trans set balance=193, needsrebal=0 where id=3216
0: #4079 - 2005-10-28, -193 - update trans set balance=0, needsrebal=0 where id=3275
1213: 3476 - 2004-12-08, 1213 - update trans set balance=1213, needsrebal=0 where id=742
1208: 3476 - 2005-01-03, -5 - update trans set balance=1208, needsrebal=0 where id=345
1193: 3476 - 2005-01-04, -15 - update trans set balance=1193, needsrebal=0 where id=319
1043: 3476 - 2005-01-11, -150 - update trans set balance=1043, needsrebal=0 where id=273
998: 3476 - 2005-01-12, -45 - update trans set balance=998, needsrebal=0 where id=266
958: 3476 - 2005-01-13, -40 - update trans set balance=958, needsrebal=0 where id=222
758: 3476 - 2005-01-17, -200 - update trans set balance=758, needsrebal=0 where id=189
683: 3476 - 2005-01-17, -75 - update trans set balance=683, needsrebal=0 where id=190
681: 3476 - 2005-01-17, -2 - update trans set balance=681, needsrebal=0 where id=193
531: 3476 - 2005-01-25, -150 - update trans set balance=531, needsrebal=0 where id=120
521: 3476 - 2005-01-26, -10 - update trans set balance=521, needsrebal=0 where id=107
296: 3476 - 2005-01-27, -225 - update trans set balance=296, needsrebal=0 where id=96
71: 3476 - 2005-01-27, -225 - update trans set balance=71, needsrebal=0 where id=98
61: 3476 - 2005-01-31, -10 - update trans set balance=61, needsrebal=0 where id=71
60: 3476 - 2005-01-31, -1 - update trans set balance=60, needsrebal=0 where id=50
58: 3476 - 2005-01-31, -2 - update trans set balance=58, needsrebal=0 where id=45
53: 3476 - 2005-01-31, -5 - update trans set balance=53, needsrebal=0 where id=64
23: 3476 - 2005-02-02, -30 - update trans set balance=23, needsrebal=0 where id=668
16: 3476 - 2005-02-08, -7 - update trans set balance=16, needsrebal=0 where id=609
15: 3476 - 2005-02-25, -1 - update trans set balance=15, needsrebal=0 where id=465
14: 3476 - 2005-03-03, -1 - update trans set balance=14, needsrebal=0 where id=824
13: 3476 - 2005-03-09, -1 - update trans set balance=13, needsrebal=0 where id=1140
11: 3476 - 2005-03-11, -2 - update trans set balance=11, needsrebal=0 where id=867
0: 3476 - 2005-03-16, -11 - update trans set balance=0, needsrebal=0 where id=877
1972: 3491 - 2005-01-01, 1972 - update trans set balance=1972, needsrebal=0 where id=741
1747: 3491 - 2005-02-10, -225 - update trans set balance=1747, needsrebal=0 where id=580
1729: 3491 - 2005-02-17, -18 - update trans set balance=1729, needsrebal=0 where id=548
1728: 3491 - 2005-02-25, -1 - update trans set balance=1728, needsrebal=0 where id=477
1698: 3491 - 2005-02-25, -30 - update trans set balance=1698, needsrebal=0 where id=470
1473: 3491 - 2005-03-11, -225 - update trans set balance=1473, needsrebal=0 where id=871
1398: 3491 - 2005-03-15, -75 - update trans set balance=1398, needsrebal=0 where id=884
1364: 3491 - 2005-03-16, -34 - update trans set balance=1364, needsrebal=0 where id=878
1363: 3491 - 2005-03-18, -1 - update trans set balance=1363, needsrebal=0 where id=1145
1213: 3491 - 2005-03-25, -150 - update trans set balance=1213, needsrebal=0 where id=1000
1212: 3491 - 2005-03-28, -1 - update trans set balance=1212, needsrebal=0 where id=988
1211: 3491 - 2005-03-31, -1 - update trans set balance=1211, needsrebal=0 where id=1115
1151: 3491 - 2005-04-04, -60 - update trans set balance=1151, needsrebal=0 where id=1365
926: 3491 - 2005-04-05, -225 - update trans set balance=926, needsrebal=0 where id=1308
904: 3491 - 2005-04-06, -22 - update trans set balance=904, needsrebal=0 where id=1294
901: 3491 - 2005-04-11, -3 - update trans set balance=901, needsrebal=0 where id=1540
676: 3491 - 2005-04-12, -225 - update trans set balance=676, needsrebal=0 where id=1285
661: 3491 - 2005-04-13, -15 - update trans set balance=661, needsrebal=0 where id=1282
586: 3491 - 2005-04-13, -75 - update trans set balance=586, needsrebal=0 where id=1269
511: 3491 - 2005-04-18, -75 - update trans set balance=511, needsrebal=0 where id=1229
509: 3491 - 2005-04-21, -2 - update trans set balance=509, needsrebal=0 where id=1357
209: 3491 - 2005-04-25, -300 - update trans set balance=209, needsrebal=0 where id=1384
0: 3491 - 2005-04-27, -209 - update trans set balance=0, needsrebal=0 where id=1343
2201: 3497 - 2004-12-28, 2201 - update trans set balance=2201, needsrebal=0 where id=740
1910: 3497 - 2005-04-27, -291 - update trans set balance=1910, needsrebal=0 where id=1344
1909: 3497 - 2005-04-28, -1 - update trans set balance=1909, needsrebal=0 where id=1401
1908: 3497 - 2005-05-09, -1 - update trans set balance=1908, needsrebal=0 where id=1500
1905: 3497 - 2005-05-09, -3 - update trans set balance=1905, needsrebal=0 where id=1508
1805: 3497 - 2005-05-11, -100 - update trans set balance=1805, needsrebal=0 where id=1557
1790: 3497 - 2005-05-13, -15 - update trans set balance=1790, needsrebal=0 where id=1571
1789: 3497 - 2005-05-13, -1 - update trans set balance=1789, needsrebal=0 where id=1585
1778: 3497 - 2005-05-16, -11 - update trans set balance=1778, needsrebal=0 where id=1622
1714: 3497 - 2005-05-18, -64 - update trans set balance=1714, needsrebal=0 where id=1670
1564: 3497 - 2005-05-23, -150 - update trans set balance=1564, needsrebal=0 where id=1598
1548: 3497 - 2005-05-23, -16 - update trans set balance=1548, needsrebal=0 where id=1694
1542: 3497 - 2005-05-23, -6 - update trans set balance=1542, needsrebal=0 where id=1780
1317: 3497 - 2005-05-24, -225 - update trans set balance=1317, needsrebal=0 where id=1568
1312: 3497 - 2005-05-27, -5 - update trans set balance=1312, needsrebal=0 where id=1708
1192: 3497 - 2005-06-06, -120 - update trans set balance=1192, needsrebal=0 where id=1760
1188: 3497 - 2005-06-06, -4 - update trans set balance=1188, needsrebal=0 where id=1762
1138: 3497 - 2005-06-13, -50 - update trans set balance=1138, needsrebal=0 where id=2041
838: 3497 - 2005-06-21, -300 - update trans set balance=838, needsrebal=0 where id=1807
309: 3497 - 2005-06-22, -529 - update trans set balance=309, needsrebal=0 where id=1911
259: 3497 - 2005-06-29, -50 - update trans set balance=259, needsrebal=0 where id=1944
229: 3497 - 2005-06-30, -30 - update trans set balance=229, needsrebal=0 where id=1992
228: 3497 - 2005-07-01, -1 - update trans set balance=228, needsrebal=0 where id=2009
276: 3497 - 2005-07-08, 48 - update trans set balance=276, needsrebal=0 where id=2113
201: 3497 - 2005-07-11, -75 - update trans set balance=201, needsrebal=0 where id=2118
126: 3497 - 2005-07-15, -75 - update trans set balance=126, needsrebal=0 where id=2105
0: 3497 - 2005-07-15, -126 - update trans set balance=0, needsrebal=0 where id=2130
2573: 4021 - 2005-05-17, 2573 - update trans set balance=2573, needsrebal=0 where id=1719
2324: 4021 - 2005-07-15, -249 - update trans set balance=2324, needsrebal=0 where id=2131
2279: 4021 - 2005-07-15, -45 - update trans set balance=2279, needsrebal=0 where id=2152
2278: 4021 - 2005-07-18, -1 - update trans set balance=2278, needsrebal=0 where id=2201
2128: 4021 - 2005-07-19, -150 - update trans set balance=2128, needsrebal=0 where id=2206
1903: 4021 - 2005-07-20, -225 - update trans set balance=1903, needsrebal=0 where id=2228
1603: 4021 - 2005-07-21, -300 - update trans set balance=1603, needsrebal=0 where id=2179
1618: 4021 - 2005-07-22, 15 - update trans set balance=1618, needsrebal=0 where id=2272
1613: 4021 - 2005-08-02, -5 - update trans set balance=1613, needsrebal=0 where id=2323
1388: 4021 - 2005-08-04, -225 - update trans set balance=1388, needsrebal=0 where id=2347
1163: 4021 - 2005-08-08, -225 - update trans set balance=1163, needsrebal=0 where id=2379
1160: 4021 - 2005-08-08, -3 - update trans set balance=1160, needsrebal=0 where id=2398
1158: 4021 - 2005-08-18, -2 - update trans set balance=1158, needsrebal=0 where id=2484
858: 4021 - 2005-08-19, -300 - update trans set balance=858, needsrebal=0 where id=2477
828: 4021 - 2005-08-19, -30 - update trans set balance=828, needsrebal=0 where id=2488
753: 4021 - 2005-08-25, -75 - update trans set balance=753, needsrebal=0 where id=2934
743: 4021 - 2005-08-29, -10 - update trans set balance=743, needsrebal=0 where id=2544
668: 4021 - 2005-08-31, -75 - update trans set balance=668, needsrebal=0 where id=2744
653: 4021 - 2005-09-07, -15 - update trans set balance=653, needsrebal=0 where id=2593
650: 4021 - 2005-09-08, -3 - update trans set balance=650, needsrebal=0 where id=2606
590: 4021 - 2005-09-15, -60 - update trans set balance=590, needsrebal=0 where id=2670
583: 4021 - 2005-09-20, -7 - update trans set balance=583, needsrebal=0 where id=2730
553: 4021 - 2005-09-22, -30 - update trans set balance=553, needsrebal=0 where id=2932
478: 4021 - 2005-09-22, -75 - update trans set balance=478, needsrebal=0 where id=2741
463: 4021 - 2005-09-26, -15 - update trans set balance=463, needsrebal=0 where id=2736
163: 4021 - 2005-09-27, -300 - update trans set balance=163, needsrebal=0 where id=2772
0: 4021 - 2005-09-28, -163 - update trans set balance=0, needsrebal=0 where id=2793
1800: 4097 - 2005-10-11, 1800 - update trans set balance=1800, needsrebal=0 where id=3050
1768: 4097 - 2005-10-28, -32 - update trans set balance=1768, needsrebal=0 where id=3276
1765: 4097 - 2005-10-28, -3 - update trans set balance=1765, needsrebal=0 where id=3298
1764: 4097 - 2005-10-31, -1 - update trans set balance=1764, needsrebal=0 where id=3305
1464: 4097 - 2005-11-17, -300 - update trans set balance=1464, needsrebal=0 where id=3332
1314: 4097 - 2005-11-23, -150 - update trans set balance=1314, needsrebal=0 where id=3490
464: 4097 - 2005-11-28, -850 - update trans set balance=464, needsrebal=0 where id=3505
314: 4097 - 2005-11-29, -150 - update trans set balance=314, needsrebal=0 where id=3515
239: 4097 - 2005-11-30, -75 - update trans set balance=239, needsrebal=0 where id=3527
164: 4097 - 2005-12-09, -75 - update trans set balance=164, needsrebal=0 where id=3577
5: 4097 - 2005-12-14, -159 - update trans set balance=5, needsrebal=0 where id=3700
0: 4097 - 2005-12-21, -5 - update trans set balance=0, needsrebal=0 where id=3753
1800: 4137 - 2005-12-12, 1800 - update trans set balance=1800, needsrebal=0 where id=3664
1659: 4137 - 2005-12-14, -141 - update trans set balance=1659, needsrebal=0 where id=3701
741: 4137 - 2005-12-14, -918 - update trans set balance=741, needsrebal=0 where id=3702
738: 4137 - 2005-12-19, -3 - update trans set balance=738, needsrebal=0 where id=3725
513: 4137 - 2005-12-27, -225 - update trans set balance=513, needsrebal=0 where id=3773
493: 4137 - 2006-01-03, -20 - update trans set balance=493, needsrebal=0 where id=3813
418: 4137 - 2006-01-03, -75 - update trans set balance=418, needsrebal=0 where id=3821
343: 4137 - 2006-01-04, -75 - update trans set balance=343, needsrebal=0 where id=3793
319: 4137 - 2006-01-04, -24 - update trans set balance=319, needsrebal=0 where id=3840
318: 4137 - 2006-01-04, -1 - update trans set balance=318, needsrebal=0 where id=3857
180: 4137 - 2006-01-05, -138 - update trans set balance=180, needsrebal=0 where id=3880
30: 4137 - 2006-01-05, -150 - update trans set balance=30, needsrebal=0 where id=3870
0: 4137 - 2006-01-06, -30 - update trans set balance=0, needsrebal=0 where id=3871
150: 4137 - 2006-01-20, 150 - update trans set balance=150, needsrebal=0 where id=4028
135: 4137 - 2006-01-30, -15 - update trans set balance=135, needsrebal=0 where id=4047
0: 4137 - 2006-01-31, -135 - update trans set balance=0, needsrebal=0 where id=4094
3273: 4156 - 2005-12-29, 3273 - update trans set balance=3273, needsrebal=0 where id=3830
3198: 4156 - 2006-01-04, -75 - update trans set balance=3198, needsrebal=0 where id=3854
3036: 4156 - 2006-01-05, -162 - update trans set balance=3036, needsrebal=0 where id=3881
2811: 4156 - 2006-01-13, -225 - update trans set balance=2811, needsrebal=0 where id=3957
2511: 4156 - 2006-01-16, -300 - update trans set balance=2511, needsrebal=0 where id=3952
2361: 4156 - 2006-01-16, -150 - update trans set balance=2361, needsrebal=0 where id=3951
2356: 4156 - 2006-01-16, -5 - update trans set balance=2356, needsrebal=0 where id=3973
2355: 4156 - 2006-01-30, -1 - update trans set balance=2355, needsrebal=0 where id=4075
2340: 4156 - 2006-01-31, -15 - update trans set balance=2340, needsrebal=0 where id=4095
2265: 4156 - 2006-01-31, -75 - update trans set balance=2265, needsrebal=0 where id=4022
1965: 4156 - 2006-02-01, -300 - update trans set balance=1965, needsrebal=0 where id=4112
1950: 4156 - 2006-02-06, -15 - update trans set balance=1950, needsrebal=0 where id=4149
1650: 4156 - 2006-02-16, -300 - update trans set balance=1650, needsrebal=0 where id=4207
1605: 4156 - 2006-02-16, -45 - update trans set balance=1605, needsrebal=0 where id=4211
1603: 4156 - 2006-02-20, -2 - update trans set balance=1603, needsrebal=0 where id=4240
1528: 4156 - 2006-02-21, -75 - update trans set balance=1528, needsrebal=0 where id=4200
1453: 4156 - 2006-02-28, -75 - update trans set balance=1453, needsrebal=0 where id=4327
1153: 4156 - 2006-03-06, -300 - update trans set balance=1153, needsrebal=0 where id=4353
1003: 4156 - 2006-03-09, -150 - update trans set balance=1003, needsrebal=0 where id=4384
928: 4156 - 2006-03-21, -75 - update trans set balance=928, needsrebal=0 where id=4292
918: 4156 - 2006-03-30, -10 - update trans set balance=918, needsrebal=0 where id=4520
618: 4156 - 2006-04-05, -300 - update trans set balance=618, needsrebal=0 where id=4648
543: 4156 - 2006-04-05, -75 - update trans set balance=543, needsrebal=0 where id=4527
468: 4156 - 2006-04-10, -75 - update trans set balance=468, needsrebal=0 where id=4650
393: 4156 - 2006-04-10, -75 - update trans set balance=393, needsrebal=0 where id=4651
243: 4156 - 2006-04-13, -150 - update trans set balance=243, needsrebal=0 where id=4537
175: 4156 - 2006-04-25, -68 - update trans set balance=175, needsrebal=0 where id=4725
165: 4156 - 2006-04-25, -10 - update trans set balance=165, needsrebal=0 where id=4573
90: 4156 - 2006-05-01, -75 - update trans set balance=90, needsrebal=0 where id=4783
78: 4156 - 2006-05-01, -12 - update trans set balance=78, needsrebal=0 where id=4778
33: 4156 - 2006-05-09, -45 - update trans set balance=33, needsrebal=0 where id=4807
0: 4156 - 2006-05-11, -33 - update trans set balance=0, needsrebal=0 where id=4818
2550: #4043 - 2005-06-28, 2550 - update trans set balance=2550, needsrebal=0 where id=2064
0: #4043 - 2005-09-07, -2550 - update trans set balance=0, needsrebal=0 where id=2602
217: 3434 - 2005-01-01, 217 - update trans set balance=217, needsrebal=0 where id=790
171: 3434 - 2005-01-03, -46 - update trans set balance=171, needsrebal=0 where id=350
163: 3434 - 2005-01-03, -8 - update trans set balance=163, needsrebal=0 where id=342
73: 3434 - 2005-01-04, -90 - update trans set balance=73, needsrebal=0 where id=323
58: 3434 - 2005-01-04, -15 - update trans set balance=58, needsrebal=0 where id=320
0: 3434 - 2005-01-07, -58 - update trans set balance=0, needsrebal=0 where id=299
1650: 3442 - 2004-11-08, 1650 - update trans set balance=1650, needsrebal=0 where id=730
1308: 3442 - 2005-01-07, -342 - update trans set balance=1308, needsrebal=0 where id=418
1293: 3442 - 2005-01-12, -15 - update trans set balance=1293, needsrebal=0 where id=267
1291: 3442 - 2005-01-18, -2 - update trans set balance=1291, needsrebal=0 where id=177
1279: 3442 - 2005-01-19, -12 - update trans set balance=1279, needsrebal=0 where id=173
1219: 3442 - 2005-01-20, -60 - update trans set balance=1219, needsrebal=0 where id=167
1189: 3442 - 2005-01-25, -30 - update trans set balance=1189, needsrebal=0 where id=130
1114: 3442 - 2005-01-27, -75 - update trans set balance=1114, needsrebal=0 where id=97
1082: 3442 - 2005-01-31, -32 - update trans set balance=1082, needsrebal=0 where id=78
1077: 3442 - 2005-01-31, -5 - update trans set balance=1077, needsrebal=0 where id=74
1076: 3442 - 2005-01-31, -1 - update trans set balance=1076, needsrebal=0 where id=52
1074: 3442 - 2005-01-31, -2 - update trans set balance=1074, needsrebal=0 where id=48
1066: 3442 - 2005-01-31, -8 - update trans set balance=1066, needsrebal=0 where id=65
1056: 3442 - 2005-02-01, -10 - update trans set balance=1056, needsrebal=0 where id=687
1054: 3442 - 2005-02-03, -2 - update trans set balance=1054, needsrebal=0 where id=661
964: 3442 - 2005-02-25, -90 - update trans set balance=964, needsrebal=0 where id=455
949: 3442 - 2005-02-25, -15 - update trans set balance=949, needsrebal=0 where id=472
948: 3442 - 2005-02-25, -1 - update trans set balance=948, needsrebal=0 where id=468
873: 3442 - 2005-02-25, -75 - update trans set balance=873, needsrebal=0 where id=446
819: 3442 - 2005-02-25, -54 - update trans set balance=819, needsrebal=0 where id=444
807: 3442 - 2005-02-25, -12 - update trans set balance=807, needsrebal=0 where id=482
795: 3442 - 2005-03-03, -12 - update trans set balance=795, needsrebal=0 where id=1156
794: 3442 - 2005-03-03, -1 - update trans set balance=794, needsrebal=0 where id=823
788: 3442 - 2005-03-09, -6 - update trans set balance=788, needsrebal=0 where id=841
786: 3442 - 2005-03-11, -2 - update trans set balance=786, needsrebal=0 where id=868
771: 3442 - 2005-03-16, -15 - update trans set balance=771, needsrebal=0 where id=880
770: 3442 - 2005-03-18, -1 - update trans set balance=770, needsrebal=0 where id=1146
769: 3442 - 2005-03-18, -1 - update trans set balance=769, needsrebal=0 where id=1153
724: 3442 - 2005-03-24, -45 - update trans set balance=724, needsrebal=0 where id=883
722: 3442 - 2005-03-31, -2 - update trans set balance=722, needsrebal=0 where id=930
702: 3442 - 2005-04-04, -20 - update trans set balance=702, needsrebal=0 where id=1367
552: 3442 - 2005-04-12, -150 - update trans set balance=552, needsrebal=0 where id=1286
537: 3442 - 2005-04-13, -15 - update trans set balance=537, needsrebal=0 where id=1281
462: 3442 - 2005-04-13, -75 - update trans set balance=462, needsrebal=0 where id=1273
387: 3442 - 2005-04-18, -75 - update trans set balance=387, needsrebal=0 where id=1230
367: 3442 - 2005-04-20, -20 - update trans set balance=367, needsrebal=0 where id=1174
329: 3442 - 2005-04-22, -38 - update trans set balance=329, needsrebal=0 where id=1253
284: 3442 - 2005-04-22, -45 - update trans set balance=284, needsrebal=0 where id=1382
0: 3442 - 2005-04-27, -284 - update trans set balance=0, needsrebal=0 where id=1341
2775: 3451 - 2005-01-01, 2775 - update trans set balance=2775, needsrebal=0 where id=736
2616: 3451 - 2005-04-27, -159 - update trans set balance=2616, needsrebal=0 where id=1342
2541: 3451 - 2005-04-28, -75 - update trans set balance=2541, needsrebal=0 where id=1364
2540: 3451 - 2005-04-28, -1 - update trans set balance=2540, needsrebal=0 where id=1402
2360: 3451 - 2005-05-03, -180 - update trans set balance=2360, needsrebal=0 where id=1427
2359: 3451 - 2005-05-09, -1 - update trans set balance=2359, needsrebal=0 where id=1503
2332: 3451 - 2005-05-11, -27 - update trans set balance=2332, needsrebal=0 where id=1484
2292: 3451 - 2005-05-13, -40 - update trans set balance=2292, needsrebal=0 where id=1530
2262: 3451 - 2005-05-13, -30 - update trans set balance=2262, needsrebal=0 where id=1573
2157: 3451 - 2005-05-17, -105 - update trans set balance=2157, needsrebal=0 where id=1611
1837: 3451 - 2005-05-20, -320 - update trans set balance=1837, needsrebal=0 where id=1597
1762: 3451 - 2005-05-23, -75 - update trans set balance=1762, needsrebal=0 where id=1599
1732: 3451 - 2005-06-07, -30 - update trans set balance=1732, needsrebal=0 where id=2046
1692: 3451 - 2005-06-08, -40 - update trans set balance=1692, needsrebal=0 where id=2071
1617: 3451 - 2005-06-09, -75 - update trans set balance=1617, needsrebal=0 where id=2042
1602: 3451 - 2005-06-30, -15 - update trans set balance=1602, needsrebal=0 where id=1993
1601: 3451 - 2005-07-01, -1 - update trans set balance=1601, needsrebal=0 where id=2012
1526: 3451 - 2005-07-11, -75 - update trans set balance=1526, needsrebal=0 where id=2119
1496: 3451 - 2005-07-15, -30 - update trans set balance=1496, needsrebal=0 where id=2153
1421: 3451 - 2005-07-15, -75 - update trans set balance=1421, needsrebal=0 where id=2170
1346: 3451 - 2005-07-25, -75 - update trans set balance=1346, needsrebal=0 where id=2508
1256: 3451 - 2005-07-27, -90 - update trans set balance=1256, needsrebal=0 where id=2255
1076: 3451 - 2005-07-28, -180 - update trans set balance=1076, needsrebal=0 where id=2247
896: 3451 - 2005-07-28, -180 - update trans set balance=896, needsrebal=0 where id=2251
716: 3451 - 2005-08-03, -180 - update trans set balance=716, needsrebal=0 where id=2330
690: 3451 - 2005-08-05, -26 - update trans set balance=690, needsrebal=0 where id=2377
669: 3451 - 2005-09-07, -21 - update trans set balance=669, needsrebal=0 where id=2645
204: 3451 - 2005-09-07, -465 - update trans set balance=204, needsrebal=0 where id=2601
90: 3451 - 2005-09-08, -114 - update trans set balance=90, needsrebal=0 where id=2624
insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 27, 'RR12CKRICE', '3451', 90, '2005-01-01','2005-09-08');
Go