'1_14_3121', '1_14_3460', '1_15_230823', '1_15_240301', '1_15_240302', '1_15_240457', '1_15_240458', '1_15_240459', '1_15_240835', '1_15_240840', '1_15_240841', '1_15_240842', '1_15_250072', '1_15_250235', '1_15_250236', '1_15_250237', '1_15_250245', '1_15_250265', '1_15_250266', '1_15_250274', '1_15_250275', '1_15_250276', '1_15_250326', '1_15_250327', '1_15_250330', '1_18_3515', '1_18_4230', '1_19_#4080', '1_19_3498', '1_19_3516', '1_1_240445', '1_1_240446', '1_1_240448', '1_1_240449', '1_20_#4068', '1_20_3384', '1_20_3517', '1_20_4015', '1_21_230590', '1_21_230789', '1_21_240323', '1_21_240324', '1_21_240325', '1_21_240326', '1_21_240327', '1_21_240361', '1_21_240362'
3400: 240445 - 2005-01-12, 3400 - update trans set balance=3400, needsrebal=0 where id=1
3398: 240445 - 2005-01-12, -2 - update trans set balance=3398, needsrebal=0 where id=253
3395: 240445 - 2005-01-12, -3 - update trans set balance=3395, needsrebal=0 where id=254
3391: 240445 - 2005-01-12, -4 - update trans set balance=3391, needsrebal=0 where id=255
3389: 240445 - 2005-01-12, -2 - update trans set balance=3389, needsrebal=0 where id=256
3385: 240445 - 2005-01-12, -4 - update trans set balance=3385, needsrebal=0 where id=257
3381: 240445 - 2005-01-12, -4 - update trans set balance=3381, needsrebal=0 where id=258
3380: 240445 - 2005-01-12, -1 - update trans set balance=3380, needsrebal=0 where id=259
3375: 240445 - 2005-01-13, -5 - update trans set balance=3375, needsrebal=0 where id=233
3055: 240445 - 2005-01-13, -320 - update trans set balance=3055, needsrebal=0 where id=238
3053: 240445 - 2005-01-13, -2 - update trans set balance=3053, needsrebal=0 where id=241
2893: 240445 - 2005-01-13, -160 - update trans set balance=2893, needsrebal=0 where id=245
2733: 240445 - 2005-01-17, -160 - update trans set balance=2733, needsrebal=0 where id=201
2693: 240445 - 2005-01-17, -40 - update trans set balance=2693, needsrebal=0 where id=199
2691: 240445 - 2005-01-18, -2 - update trans set balance=2691, needsrebal=0 where id=175
2671: 240445 - 2005-01-20, -20 - update trans set balance=2671, needsrebal=0 where id=143
2351: 240445 - 2005-01-20, -320 - update trans set balance=2351, needsrebal=0 where id=152
2346: 240445 - 2005-01-20, -5 - update trans set balance=2346, needsrebal=0 where id=156
2026: 240445 - 2005-01-24, -320 - update trans set balance=2026, needsrebal=0 where id=132
2022: 240445 - 2005-01-31, -4 - update trans set balance=2022, needsrebal=0 where id=38
2016: 240445 - 2005-01-31, -6 - update trans set balance=2016, needsrebal=0 where id=56
2014: 240445 - 2005-01-31, -2 - update trans set balance=2014, needsrebal=0 where id=58
2009: 240445 - 2005-02-23, -5 - update trans set balance=2009, needsrebal=0 where id=489
1974: 240445 - 2005-02-25, -35 - update trans set balance=1974, needsrebal=0 where id=480
1970: 240445 - 2005-03-09, -4 - update trans set balance=1970, needsrebal=0 where id=836
1955: 240445 - 2005-03-11, -15 - update trans set balance=1955, needsrebal=0 where id=861
1635: 240445 - 2005-03-22, -320 - update trans set balance=1635, needsrebal=0 where id=1002
1629: 240445 - 2005-03-22, -6 - update trans set balance=1629, needsrebal=0 where id=995
1469: 240445 - 2005-03-31, -160 - update trans set balance=1469, needsrebal=0 where id=1084
1468: 240445 - 2005-04-05, -1 - update trans set balance=1468, needsrebal=0 where id=1298
988: 240445 - 2005-04-14, -480 - update trans set balance=988, needsrebal=0 where id=2018
983: 240445 - 2005-04-19, -5 - update trans set balance=983, needsrebal=0 where id=1258
823: 240445 - 2005-04-25, -160 - update trans set balance=823, needsrebal=0 where id=1347
807: 240445 - 2005-04-27, -16 - update trans set balance=807, needsrebal=0 where id=1355
782: 240445 - 2005-04-28, -25 - update trans set balance=782, needsrebal=0 where id=1363
781: 240445 - 2005-05-09, -1 - update trans set balance=781, needsrebal=0 where id=1487
766: 240445 - 2005-05-17, -15 - update trans set balance=766, needsrebal=0 where id=1604
761: 240445 - 2005-05-18, -5 - update trans set balance=761, needsrebal=0 where id=1669
757: 240445 - 2005-05-23, -4 - update trans set balance=757, needsrebal=0 where id=1788
747: 240445 - 2005-05-31, -10 - update trans set balance=747, needsrebal=0 where id=1735
612: 240445 - 2005-05-31, -135 - update trans set balance=612, needsrebal=0 where id=1726
452: 240445 - 2005-06-08, -160 - update trans set balance=452, needsrebal=0 where id=2022
132: 240445 - 2005-06-13, -320 - update trans set balance=132, needsrebal=0 where id=2034
0: 240445 - 2005-06-13, -132 - update trans set balance=0, needsrebal=0 where id=1823
160: 240445 - 2005-07-01, 160 - update trans set balance=160, needsrebal=0 where id=2019
480: 240445 - 2005-07-01, 320 - update trans set balance=480, needsrebal=0 where id=2033
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 1, 'M14BFDMPLG', '240445', 480, '2005-01-12','2005-07-01');
3400: 240446 - 2005-01-01, 3400 - update trans set balance=3400, needsrebal=0 where id=765
3212: 240446 - 2005-06-13, -188 - update trans set balance=3212, needsrebal=0 where id=1824
3202: 240446 - 2005-06-29, -10 - update trans set balance=3202, needsrebal=0 where id=1946
3198: 240446 - 2005-06-30, -4 - update trans set balance=3198, needsrebal=0 where id=1985
3182: 240446 - 2005-07-14, -16 - update trans set balance=3182, needsrebal=0 where id=2157
3022: 240446 - 2005-07-20, -160 - update trans set balance=3022, needsrebal=0 where id=2222
2702: 240446 - 2005-07-21, -320 - update trans set balance=2702, needsrebal=0 where id=2183
2699: 240446 - 2005-07-29, -3 - update trans set balance=2699, needsrebal=0 where id=2318
2672: 240446 - 2005-08-09, -27 - update trans set balance=2672, needsrebal=0 where id=2407
2657: 240446 - 2005-08-12, -15 - update trans set balance=2657, needsrebal=0 where id=2415
2647: 240446 - 2005-08-19, -10 - update trans set balance=2647, needsrebal=0 where id=2494
2637: 240446 - 2005-08-23, -10 - update trans set balance=2637, needsrebal=0 where id=2525
2317: 240446 - 2005-08-25, -320 - update trans set balance=2317, needsrebal=0 where id=2533
2312: 240446 - 2005-09-07, -5 - update trans set balance=2312, needsrebal=0 where id=2610
1832: 240446 - 2005-09-12, -480 - update trans set balance=1832, needsrebal=0 where id=2620
1802: 240446 - 2005-09-13, -30 - update trans set balance=1802, needsrebal=0 where id=2649
1767: 240446 - 2005-09-14, -35 - update trans set balance=1767, needsrebal=0 where id=2654
1751: 240446 - 2005-09-14, -16 - update trans set balance=1751, needsrebal=0 where id=2663
1206: 240446 - 2005-09-26, -545 - update trans set balance=1206, needsrebal=0 where id=2707
1046: 240446 - 2005-09-28, -160 - update trans set balance=1046, needsrebal=0 where id=2769
1016: 240446 - 2005-10-07, -30 - update trans set balance=1016, needsrebal=0 where id=2904
696: 240446 - 2005-10-20, -320 - update trans set balance=696, needsrebal=0 where id=3121
0: 240446 - 2005-11-14, -696 - update trans set balance=0, needsrebal=0 where id=3392
3399: 240448 - 2005-04-15, 3399 - update trans set balance=3399, needsrebal=0 where id=945
705: 240448 - 2006-02-16, -2694 - update trans set balance=705, needsrebal=0 where id=4209
700: 240448 - 2006-02-28, -5 - update trans set balance=700, needsrebal=0 where id=4316
540: 240448 - 2006-03-03, -160 - update trans set balance=540, needsrebal=0 where id=4355
530: 240448 - 2006-03-06, -10 - update trans set balance=530, needsrebal=0 where id=4360
112: 240448 - 2006-03-13, -418 - update trans set balance=112, needsrebal=0 where id=4402
102: 240448 - 2006-03-24, -10 - update trans set balance=102, needsrebal=0 where id=4467
98: 240448 - 2006-04-24, -4 - update trans set balance=98, needsrebal=0 where id=4921
35: 240448 - 2006-04-26, -63 - update trans set balance=35, needsrebal=0 where id=4738
0: 240448 - 2006-05-09, -35 - update trans set balance=0, needsrebal=0 where id=4798
3399: 240449 - 2005-04-15, 3399 - update trans set balance=3399, needsrebal=0 where id=946
3231: 240449 - 2005-11-14, -168 - update trans set balance=3231, needsrebal=0 where id=3393
3206: 240449 - 2005-11-17, -25 - update trans set balance=3206, needsrebal=0 where id=3408
3046: 240449 - 2005-11-18, -160 - update trans set balance=3046, needsrebal=0 where id=3418
2182: 240449 - 2005-11-22, -864 - update trans set balance=2182, needsrebal=0 where id=3483
1766: 240449 - 2005-11-28, -416 - update trans set balance=1766, needsrebal=0 where id=3484
1606: 240449 - 2005-12-02, -160 - update trans set balance=1606, needsrebal=0 where id=3582
1556: 240449 - 2005-12-05, -50 - update trans set balance=1556, needsrebal=0 where id=3576
1076: 240449 - 2005-12-16, -480 - update trans set balance=1076, needsrebal=0 where id=3714
756: 240449 - 2006-01-23, -320 - update trans set balance=756, needsrebal=0 where id=4023
741: 240449 - 2006-01-30, -15 - update trans set balance=741, needsrebal=0 where id=4059
581: 240449 - 2006-01-30, -160 - update trans set balance=581, needsrebal=0 where id=4066
521: 240449 - 2006-01-30, -60 - update trans set balance=521, needsrebal=0 where id=4068
506: 240449 - 2006-02-10, -15 - update trans set balance=506, needsrebal=0 where id=4170
0: 240449 - 2006-02-16, -506 - update trans set balance=0, needsrebal=0 where id=4208
132: 3121 - 2005-01-01, 132 - update trans set balance=132, needsrebal=0 where id=724
0: 3121 - 2005-08-09, -132 - update trans set balance=0, needsrebal=0 where id=2510
986: 3460 - 2004-11-18, 986 - update trans set balance=986, needsrebal=0 where id=737
1138: 3460 - 2006-02-22, 152 - update trans set balance=1138, needsrebal=0 where id=4312
504: 3460 - 2006-02-22, -634 - update trans set balance=504, needsrebal=0 where id=3048
152: 3460 - 2006-02-27, -352 - update trans set balance=152, needsrebal=0 where id=4296
0: 3460 - 2006-03-01, -152 - update trans set balance=0, needsrebal=0 where id=4339
152: 230823 - 2005-01-01, 152 - update trans set balance=152, needsrebal=0 where id=755
0: 230823 - 2005-01-03, -152 - update trans set balance=0, needsrebal=0 where id=354
2000: 240301 - 2005-01-01, 2000 - update trans set balance=2000, needsrebal=0 where id=751
1981: 240301 - 2005-04-06, -19 - update trans set balance=1981, needsrebal=0 where id=1255
1886: 240301 - 2005-04-07, -95 - update trans set balance=1886, needsrebal=0 where id=1259
1861: 240301 - 2005-04-07, -25 - update trans set balance=1861, needsrebal=0 where id=1180
1766: 240301 - 2005-04-14, -95 - update trans set balance=1766, needsrebal=0 where id=1547
1736: 240301 - 2005-04-15, -30 - update trans set balance=1736, needsrebal=0 where id=1238
1641: 240301 - 2005-04-19, -95 - update trans set balance=1641, needsrebal=0 where id=1256
1546: 240301 - 2005-04-21, -95 - update trans set balance=1546, needsrebal=0 where id=1372
1486: 240301 - 2005-04-25, -60 - update trans set balance=1486, needsrebal=0 where id=1179
1391: 240301 - 2005-04-25, -95 - update trans set balance=1391, needsrebal=0 where id=1383
1372: 240301 - 2005-04-27, -19 - update trans set balance=1372, needsrebal=0 where id=1350
1182: 240301 - 2005-04-29, -190 - update trans set balance=1182, needsrebal=0 where id=1391
1152: 240301 - 2005-05-03, -30 - update trans set balance=1152, needsrebal=0 where id=1452
1132: 240301 - 2005-05-06, -20 - update trans set balance=1132, needsrebal=0 where id=1518
1037: 240301 - 2005-05-09, -95 - update trans set balance=1037, needsrebal=0 where id=1522
847: 240301 - 2005-05-09, -190 - update trans set balance=847, needsrebal=0 where id=1520
804: 240301 - 2005-05-11, -43 - update trans set balance=804, needsrebal=0 where id=1806
709: 240301 - 2005-05-12, -95 - update trans set balance=709, needsrebal=0 where id=1629
689: 240301 - 2005-05-12, -20 - update trans set balance=689, needsrebal=0 where id=1637
659: 240301 - 2005-05-16, -30 - update trans set balance=659, needsrebal=0 where id=1643
184: 240301 - 2005-05-16, -475 - update trans set balance=184, needsrebal=0 where id=1627
154: 240301 - 2005-05-16, -30 - update trans set balance=154, needsrebal=0 where id=1612
0: 240301 - 2005-05-19, -154 - update trans set balance=0, needsrebal=0 where id=1648
1998: 240302 - 2005-01-01, 1998 - update trans set balance=1998, needsrebal=0 where id=752
1968: 240302 - 2005-05-18, -30 - update trans set balance=1968, needsrebal=0 where id=1665
1837: 240302 - 2005-05-19, -131 - update trans set balance=1837, needsrebal=0 where id=1649
1802: 240302 - 2005-05-20, -35 - update trans set balance=1802, needsrebal=0 where id=1680
1707: 240302 - 2005-05-24, -95 - update trans set balance=1707, needsrebal=0 where id=1656
1697: 240302 - 2005-05-24, -10 - update trans set balance=1697, needsrebal=0 where id=1713
1412: 240302 - 2005-05-25, -285 - update trans set balance=1412, needsrebal=0 where id=1658
1392: 240302 - 2005-05-31, -20 - update trans set balance=1392, needsrebal=0 where id=1731
1202: 240302 - 2005-06-01, -190 - update trans set balance=1202, needsrebal=0 where id=2023
1186: 240302 - 2005-06-06, -16 - update trans set balance=1186, needsrebal=0 where id=1757
1156: 240302 - 2005-06-06, -30 - update trans set balance=1156, needsrebal=0 where id=1759
871: 240302 - 2005-06-07, -285 - update trans set balance=871, needsrebal=0 where id=2028
665: 240302 - 2005-06-09, -206 - update trans set balance=665, needsrebal=0 where id=2030
380: 240302 - 2005-06-09, -285 - update trans set balance=380, needsrebal=0 where id=2026
285: 240302 - 2005-06-09, -95 - update trans set balance=285, needsrebal=0 where id=2027
0: 240302 - 2005-06-09, -285 - update trans set balance=0, needsrebal=0 where id=2025
2000: 240457 - 2004-11-17, 2000 - update trans set balance=2000, needsrebal=0 where id=754
1970: 240457 - 2005-01-13, -30 - update trans set balance=1970, needsrebal=0 where id=225
1912: 240457 - 2005-01-13, -58 - update trans set balance=1912, needsrebal=0 where id=413
1817: 240457 - 2005-01-17, -95 - update trans set balance=1817, needsrebal=0 where id=196
1532: 240457 - 2005-01-17, -285 - update trans set balance=1532, needsrebal=0 where id=198
1342: 240457 - 2005-01-17, -190 - update trans set balance=1342, needsrebal=0 where id=186
1310: 240457 - 2005-01-20, -32 - update trans set balance=1310, needsrebal=0 where id=162
1280: 240457 - 2005-01-20, -30 - update trans set balance=1280, needsrebal=0 where id=145
995: 240457 - 2005-01-20, -285 - update trans set balance=995, needsrebal=0 where id=153
975: 240457 - 2005-01-20, -20 - update trans set balance=975, needsrebal=0 where id=158
690: 240457 - 2005-01-26, -285 - update trans set balance=690, needsrebal=0 where id=113
595: 240457 - 2005-01-26, -95 - update trans set balance=595, needsrebal=0 where id=105
592: 240457 - 2005-01-31, -3 - update trans set balance=592, needsrebal=0 where id=40
402: 240457 - 2005-02-02, -190 - update trans set balance=402, needsrebal=0 where id=681
382: 240457 - 2005-02-02, -20 - update trans set balance=382, needsrebal=0 where id=683
352: 240457 - 2005-02-02, -30 - update trans set balance=352, needsrebal=0 where id=673
320: 240457 - 2005-02-07, -32 - update trans set balance=320, needsrebal=0 where id=622
0: 240457 - 2005-02-07, -320 - update trans set balance=0, needsrebal=0 where id=635
1853: 240458 - 2004-12-21, 1853 - update trans set balance=1853, needsrebal=0 where id=770
1720: 240458 - 2005-01-03, -133 - update trans set balance=1720, needsrebal=0 where id=412
1700: 240458 - 2005-01-03, -20 - update trans set balance=1700, needsrebal=0 where id=355
1320: 240458 - 2005-01-03, -380 - update trans set balance=1320, needsrebal=0 where id=347
1310: 240458 - 2005-01-03, -10 - update trans set balance=1310, needsrebal=0 where id=338
1215: 240458 - 2005-01-05, -95 - update trans set balance=1215, needsrebal=0 where id=313
1025: 240458 - 2005-01-05, -190 - update trans set balance=1025, needsrebal=0 where id=315
987: 240458 - 2005-01-06, -38 - update trans set balance=987, needsrebal=0 where id=310
607: 240458 - 2005-01-10, -380 - update trans set balance=607, needsrebal=0 where id=290
567: 240458 - 2005-01-11, -40 - update trans set balance=567, needsrebal=0 where id=283
472: 240458 - 2005-01-11, -95 - update trans set balance=472, needsrebal=0 where id=272
447: 240458 - 2005-01-11, -25 - update trans set balance=447, needsrebal=0 where id=269
352: 240458 - 2005-01-11, -95 - update trans set balance=352, needsrebal=0 where id=276
332: 240458 - 2005-01-13, -20 - update trans set balance=332, needsrebal=0 where id=235
47: 240458 - 2005-01-13, -285 - update trans set balance=47, needsrebal=0 where id=240
37: 240458 - 2005-01-13, -10 - update trans set balance=37, needsrebal=0 where id=243
0: 240458 - 2005-01-13, -37 - update trans set balance=0, needsrebal=0 where id=226
2000: 240459 - 2005-01-01, 2000 - update trans set balance=2000, needsrebal=0 where id=766
1905: 240459 - 2005-02-07, -95 - update trans set balance=1905, needsrebal=0 where id=640
1845: 240459 - 2005-02-07, -60 - update trans set balance=1845, needsrebal=0 where id=636
1841: 240459 - 2005-02-10, -4 - update trans set balance=1841, needsrebal=0 where id=583
1811: 240459 - 2005-02-21, -30 - update trans set balance=1811, needsrebal=0 where id=525
1776: 240459 - 2005-02-21, -35 - update trans set balance=1776, needsrebal=0 where id=527
1726: 240459 - 2005-02-21, -50 - update trans set balance=1726, needsrebal=0 where id=529
1701: 240459 - 2005-02-23, -25 - update trans set balance=1701, needsrebal=0 where id=484
1671: 240459 - 2005-02-23, -30 - update trans set balance=1671, needsrebal=0 where id=486
1636: 240459 - 2005-02-25, -35 - update trans set balance=1636, needsrebal=0 where id=449
1541: 240459 - 2005-02-25, -95 - update trans set balance=1541, needsrebal=0 where id=447
1351: 240459 - 2005-03-04, -190 - update trans set balance=1351, needsrebal=0 where id=813
1256: 240459 - 2005-03-07, -95 - update trans set balance=1256, needsrebal=0 where id=1157
1066: 240459 - 2005-03-08, -190 - update trans set balance=1066, needsrebal=0 where id=850
1064: 240459 - 2005-03-09, -2 - update trans set balance=1064, needsrebal=0 where id=835
1044: 240459 - 2005-03-11, -20 - update trans set balance=1044, needsrebal=0 where id=860
972: 240459 - 2005-03-17, -72 - update trans set balance=972, needsrebal=0 where id=901
956: 240459 - 2005-03-21, -16 - update trans set balance=956, needsrebal=0 where id=1010
931: 240459 - 2005-03-22, -25 - update trans set balance=931, needsrebal=0 where id=1004
896: 240459 - 2005-03-22, -35 - update trans set balance=896, needsrebal=0 where id=1006
801: 240459 - 2005-03-24, -95 - update trans set balance=801, needsrebal=0 where id=1073
776: 240459 - 2005-03-28, -25 - update trans set balance=776, needsrebal=0 where id=978
681: 240459 - 2005-03-29, -95 - update trans set balance=681, needsrebal=0 where id=974
656: 240459 - 2005-03-29, -25 - update trans set balance=656, needsrebal=0 where id=969
561: 240459 - 2005-03-30, -95 - update trans set balance=561, needsrebal=0 where id=1109
466: 240459 - 2005-03-30, -95 - update trans set balance=466, needsrebal=0 where id=1081
456: 240459 - 2005-04-01, -10 - update trans set balance=456, needsrebal=0 where id=956
380: 240459 - 2005-04-06, -76 - update trans set balance=380, needsrebal=0 where id=1254
0: 240459 - 2005-04-20, -380 - update trans set balance=0, needsrebal=0 where id=1170
2000: 240835 - 2005-07-11, 2000 - update trans set balance=2000, needsrebal=0 where id=2060
1905: 240835 - 2005-08-16, -95 - update trans set balance=1905, needsrebal=0 where id=2464
1240: 240835 - 2005-08-18, -665 - update trans set balance=1240, needsrebal=0 where id=2475
1200: 240835 - 2005-08-19, -40 - update trans set balance=1200, needsrebal=0 where id=2491
1180: 240835 - 2005-08-23, -20 - update trans set balance=1180, needsrebal=0 where id=2523
990: 240835 - 2005-08-24, -190 - update trans set balance=990, needsrebal=0 where id=2463
955: 240835 - 2005-08-25, -35 - update trans set balance=955, needsrebal=0 where id=2538
860: 240835 - 2005-08-26, -95 - update trans set balance=860, needsrebal=0 where id=2532
840: 240835 - 2005-09-02, -20 - update trans set balance=840, needsrebal=0 where id=2576
810: 240835 - 2005-09-07, -30 - update trans set balance=810, needsrebal=0 where id=2607
525: 240835 - 2005-09-12, -285 - update trans set balance=525, needsrebal=0 where id=2617
475: 240835 - 2005-09-12, -50 - update trans set balance=475, needsrebal=0 where id=2638
455: 240835 - 2005-09-13, -20 - update trans set balance=455, needsrebal=0 where id=2647
423: 240835 - 2005-09-14, -32 - update trans set balance=423, needsrebal=0 where id=2806
366: 240835 - 2005-09-14, -57 - update trans set balance=366, needsrebal=0 where id=2662
312: 240835 - 2005-09-15, -54 - update trans set balance=312, needsrebal=0 where id=2661
277: 240835 - 2005-09-15, -35 - update trans set balance=277, needsrebal=0 where id=2657
247: 240835 - 2005-09-20, -30 - update trans set balance=247, needsrebal=0 where id=2812
222: 240835 - 2005-09-20, -25 - update trans set balance=222, needsrebal=0 where id=2815
127: 240835 - 2005-09-20, -95 - update trans set balance=127, needsrebal=0 where id=2709
50: 240835 - 2005-09-22, -77 - update trans set balance=50, needsrebal=0 where id=2710
0: 240835 - 2005-09-26, -50 - update trans set balance=0, needsrebal=0 where id=2817
1999: 240840 - 2005-04-11, 1999 - update trans set balance=1999, needsrebal=0 where id=952
1524: 240840 - 2005-09-27, -475 - update trans set balance=1524, needsrebal=0 where id=2770
954: 240840 - 2005-11-29, -570 - update trans set balance=954, needsrebal=0 where id=3499
500: 240840 - 2006-01-18, -454 - update trans set balance=500, needsrebal=0 where id=3928
0: 240840 - 2006-01-26, -500 - update trans set balance=0, needsrebal=0 where id=3926
1999: 240841 - 2005-04-13, 1999 - update trans set balance=1999, needsrebal=0 where id=941
1049: 240841 - 2005-06-09, -950 - update trans set balance=1049, needsrebal=0 where id=2032
669: 240841 - 2005-06-09, -380 - update trans set balance=669, needsrebal=0 where id=2029
400: 240841 - 2005-06-09, -269 - update trans set balance=400, needsrebal=0 where id=2031
210: 240841 - 2005-06-13, -190 - update trans set balance=210, needsrebal=0 where id=2035
185: 240841 - 2005-06-14, -25 - update trans set balance=185, needsrebal=0 where id=1804
0: 240841 - 2005-06-15, -185 - update trans set balance=0, needsrebal=0 where id=1860
1999: 240842 - 2005-04-26, 1999 - update trans set balance=1999, needsrebal=0 where id=942
1994: 240842 - 2005-06-15, -5 - update trans set balance=1994, needsrebal=0 where id=1861
1519: 240842 - 2005-06-16, -475 - update trans set balance=1519, needsrebal=0 where id=1856
1489: 240842 - 2005-06-21, -30 - update trans set balance=1489, needsrebal=0 where id=1916
1485: 240842 - 2005-06-30, -4 - update trans set balance=1485, needsrebal=0 where id=1982
1470: 240842 - 2005-06-30, -15 - update trans set balance=1470, needsrebal=0 where id=2002
1420: 240842 - 2005-06-30, -50 - update trans set balance=1420, needsrebal=0 where id=2001
1395: 240842 - 2005-06-30, -25 - update trans set balance=1395, needsrebal=0 where id=2004
1323: 240842 - 2005-07-05, -72 - update trans set balance=1323, needsrebal=0 where id=2059
1228: 240842 - 2005-07-07, -95 - update trans set balance=1228, needsrebal=0 where id=2087
950: 240842 - 2005-07-08, -278 - update trans set balance=950, needsrebal=0 where id=2108
570: 240842 - 2005-07-14, -380 - update trans set balance=570, needsrebal=0 where id=2104
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 15, 'M24CBWJ', '240842', 570, '2005-04-26','2005-07-14');
1813: 250072 - 2005-10-31, 1813 - update trans set balance=1813, needsrebal=0 where id=4196
1718: 250072 - 2006-02-14, -95 - update trans set balance=1718, needsrebal=0 where id=4206
1668: 250072 - 2006-02-14, -50 - update trans set balance=1668, needsrebal=0 where id=4203
1383: 250072 - 2006-02-14, -285 - update trans set balance=1383, needsrebal=0 where id=4204
1353: 250072 - 2006-02-14, -30 - update trans set balance=1353, needsrebal=0 where id=4201
688: 250072 - 2006-02-15, -665 - update trans set balance=688, needsrebal=0 where id=4205
403: 250072 - 2006-02-15, -285 - update trans set balance=403, needsrebal=0 where id=4197
23: 250072 - 2006-02-16, -380 - update trans set balance=23, needsrebal=0 where id=4198
0: 250072 - 2006-02-23, -23 - update trans set balance=0, needsrebal=0 where id=4279
2000: 250235 - 2005-07-07, 2000 - update trans set balance=2000, needsrebal=0 where id=2062
1847: 250235 - 2005-08-08, -153 - update trans set balance=1847, needsrebal=0 where id=2383
1826: 250235 - 2005-08-12, -21 - update trans set balance=1826, needsrebal=0 where id=2411
1801: 250235 - 2005-08-12, -25 - update trans set balance=1801, needsrebal=0 where id=2443
1421: 250235 - 2005-09-20, -380 - update trans set balance=1421, needsrebal=0 where id=2712
1231: 250235 - 2005-09-21, -190 - update trans set balance=1231, needsrebal=0 where id=2714
1118: 250235 - 2005-09-22, -113 - update trans set balance=1118, needsrebal=0 where id=2711
1023: 250235 - 2005-09-22, -95 - update trans set balance=1023, needsrebal=0 where id=2713
928: 250235 - 2005-09-22, -95 - update trans set balance=928, needsrebal=0 where id=2715
903: 250235 - 2005-09-26, -25 - update trans set balance=903, needsrebal=0 where id=2716
618: 250235 - 2005-09-26, -285 - update trans set balance=618, needsrebal=0 where id=2718
598: 250235 - 2005-09-28, -20 - update trans set balance=598, needsrebal=0 where id=2818
503: 250235 - 2005-09-28, -95 - update trans set balance=503, needsrebal=0 where id=2768
408: 250235 - 2005-09-29, -95 - update trans set balance=408, needsrebal=0 where id=2820
98: 250235 - 2005-10-03, -310 - update trans set balance=98, needsrebal=0 where id=2908
95: 250235 - 2005-10-03, -3 - update trans set balance=95, needsrebal=0 where id=2880
0: 250235 - 2005-10-05, -95 - update trans set balance=0, needsrebal=0 where id=2760
2000: 250236 - 2005-06-30, 2000 - update trans set balance=2000, needsrebal=0 where id=2049
1518: 250236 - 2005-07-08, -482 - update trans set balance=1518, needsrebal=0 where id=2109
853: 250236 - 2005-07-12, -665 - update trans set balance=853, needsrebal=0 where id=2106
833: 250236 - 2005-07-13, -20 - update trans set balance=833, needsrebal=0 where id=2154
795: 250236 - 2005-07-14, -38 - update trans set balance=795, needsrebal=0 where id=2160
130: 250236 - 2005-07-15, -665 - update trans set balance=130, needsrebal=0 where id=2107
0: 250236 - 2005-07-15, -130 - update trans set balance=0, needsrebal=0 where id=2181
2000: 250237 - 2005-06-30, 2000 - update trans set balance=2000, needsrebal=0 where id=2050
1940: 250237 - 2005-07-15, -60 - update trans set balance=1940, needsrebal=0 where id=2182
1915: 250237 - 2005-07-15, -25 - update trans set balance=1915, needsrebal=0 where id=2175
1820: 250237 - 2005-07-19, -95 - update trans set balance=1820, needsrebal=0 where id=2207
1535: 250237 - 2005-07-19, -285 - update trans set balance=1535, needsrebal=0 where id=2203
1440: 250237 - 2005-07-22, -95 - update trans set balance=1440, needsrebal=0 where id=2259
1390: 250237 - 2005-07-25, -50 - update trans set balance=1390, needsrebal=0 where id=2465
1340: 250237 - 2005-07-29, -50 - update trans set balance=1340, needsrebal=0 where id=2304
1320: 250237 - 2005-07-29, -20 - update trans set balance=1320, needsrebal=0 where id=2301
1130: 250237 - 2005-07-29, -190 - update trans set balance=1130, needsrebal=0 where id=2291
1035: 250237 - 2005-07-29, -95 - update trans set balance=1035, needsrebal=0 where id=2319
1005: 250237 - 2005-07-29, -30 - update trans set balance=1005, needsrebal=0 where id=2287
1001: 250237 - 2005-07-29, -4 - update trans set balance=1001, needsrebal=0 where id=2316
981: 250237 - 2005-08-03, -20 - update trans set balance=981, needsrebal=0 where id=2331
1001: 250237 - 2005-08-04, 20 - update trans set balance=1001, needsrebal=0 where id=2385
976: 250237 - 2005-08-05, -25 - update trans set balance=976, needsrebal=0 where id=2343
881: 250237 - 2005-08-05, -95 - update trans set balance=881, needsrebal=0 where id=2366
400: 250237 - 2005-08-08, -481 - update trans set balance=400, needsrebal=0 where id=2382
399: 250237 - 2005-08-09, -1 - update trans set balance=399, needsrebal=0 where id=2917
380: 250237 - 2005-08-12, -19 - update trans set balance=380, needsrebal=0 where id=2410
0: 250237 - 2005-08-26, -380 - update trans set balance=0, needsrebal=0 where id=2370
1999: 250245 - 2005-07-11, 1999 - update trans set balance=1999, needsrebal=0 where id=2165
1998: 250245 - 2005-08-09, -1 - update trans set balance=1998, needsrebal=0 where id=2918
1642: 250245 - 2005-10-03, -356 - update trans set balance=1642, needsrebal=0 where id=2909
1632: 250245 - 2005-10-06, -10 - update trans set balance=1632, needsrebal=0 where id=2895
1157: 250245 - 2005-10-06, -475 - update trans set balance=1157, needsrebal=0 where id=2890
1127: 250245 - 2005-10-07, -30 - update trans set balance=1127, needsrebal=0 where id=2901
842: 250245 - 2005-10-11, -285 - update trans set balance=842, needsrebal=0 where id=2997
788: 250245 - 2005-10-13, -54 - update trans set balance=788, needsrebal=0 where id=2907
1073: 250245 - 2005-10-19, 285 - update trans set balance=1073, needsrebal=0 where id=3920
883: 250245 - 2005-10-19, -190 - update trans set balance=883, needsrebal=0 where id=3126
788: 250245 - 2005-10-20, -95 - update trans set balance=788, needsrebal=0 where id=3135
763: 250245 - 2005-10-31, -25 - update trans set balance=763, needsrebal=0 where id=3323
663: 250245 - 2005-11-03, -100 - update trans set balance=663, needsrebal=0 where id=3324
570: 250245 - 2005-11-04, -93 - update trans set balance=570, needsrebal=0 where id=3328
483: 250245 - 2006-01-13, -87 - update trans set balance=483, needsrebal=0 where id=3935
388: 250245 - 2006-01-18, -95 - update trans set balance=388, needsrebal=0 where id=3966
293: 250245 - 2006-01-24, -95 - update trans set balance=293, needsrebal=0 where id=4027
285: 250245 - 2006-02-02, -8 - update trans set balance=285, needsrebal=0 where id=4128
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 15, 'M24CBWJ', '250245', 285, '2005-07-11','2006-02-02');
1999: 250265 - 2005-07-18, 1999 - update trans set balance=1999, needsrebal=0 where id=2238
1897: 250265 - 2005-11-22, -102 - update trans set balance=1897, needsrebal=0 where id=3469
1877: 250265 - 2005-11-29, -20 - update trans set balance=1877, needsrebal=0 where id=3465
1782: 250265 - 2005-11-29, -95 - update trans set balance=1782, needsrebal=0 where id=3498
1497: 250265 - 2005-11-30, -285 - update trans set balance=1497, needsrebal=0 where id=3537
1481: 250265 - 2005-12-01, -16 - update trans set balance=1481, needsrebal=0 where id=3541
1461: 250265 - 2005-12-05, -20 - update trans set balance=1461, needsrebal=0 where id=3585
1176: 250265 - 2005-12-09, -285 - update trans set balance=1176, needsrebal=0 where id=3657
796: 250265 - 2005-12-09, -380 - update trans set balance=796, needsrebal=0 where id=3655
746: 250265 - 2005-12-12, -50 - update trans set balance=746, needsrebal=0 where id=3656
721: 250265 - 2005-12-12, -25 - update trans set balance=721, needsrebal=0 where id=3669
649: 250265 - 2005-12-13, -72 - update trans set balance=649, needsrebal=0 where id=3649
599: 250265 - 2005-12-14, -50 - update trans set balance=599, needsrebal=0 where id=3703
549: 250265 - 2005-12-15, -50 - update trans set balance=549, needsrebal=0 where id=3685
499: 250265 - 2005-12-16, -50 - update trans set balance=499, needsrebal=0 where id=3708
404: 250265 - 2005-12-16, -95 - update trans set balance=404, needsrebal=0 where id=3705
95: 250265 - 2005-12-20, -309 - update trans set balance=95, needsrebal=0 where id=3741
111: 250265 - 2005-12-21, 16 - update trans set balance=111, needsrebal=0 where id=3746
16: 250265 - 2005-12-21, -95 - update trans set balance=16, needsrebal=0 where id=3716
0: 250265 - 2005-12-22, -16 - update trans set balance=0, needsrebal=0 where id=3866
16: 250265 - 2006-01-31, 16 - update trans set balance=16, needsrebal=0 where id=4167
0: 250265 - 2006-02-09, -16 - update trans set balance=0, needsrebal=0 where id=4179
2000: 250266 - 2005-07-15, 2000 - update trans set balance=2000, needsrebal=0 where id=2202
1808: 250266 - 2005-11-04, -192 - update trans set balance=1808, needsrebal=0 where id=3329
1758: 250266 - 2005-11-11, -50 - update trans set balance=1758, needsrebal=0 where id=3365
1742: 250266 - 2005-11-14, -16 - update trans set balance=1742, needsrebal=0 where id=3334
1378: 250266 - 2005-11-14, -364 - update trans set balance=1378, needsrebal=0 where id=3367
1283: 250266 - 2005-11-15, -95 - update trans set balance=1283, needsrebal=0 where id=3381
903: 250266 - 2005-11-16, -380 - update trans set balance=903, needsrebal=0 where id=3371
873: 250266 - 2005-11-17, -30 - update trans set balance=873, needsrebal=0 where id=3409
848: 250266 - 2005-11-17, -25 - update trans set balance=848, needsrebal=0 where id=3406
0: 250266 - 2005-11-22, -848 - update trans set balance=0, needsrebal=0 where id=3468
2000: 250274 - 2005-08-15, 2000 - update trans set balance=2000, needsrebal=0 where id=2682
1810: 250274 - 2005-08-25, -190 - update trans set balance=1810, needsrebal=0 where id=2910
1430: 250274 - 2005-11-30, -380 - update trans set balance=1430, needsrebal=0 where id=3539
1240: 250274 - 2005-12-27, -190 - update trans set balance=1240, needsrebal=0 where id=3777
1173: 250274 - 2005-12-27, -67 - update trans set balance=1173, needsrebal=0 where id=3776
1078: 250274 - 2005-12-28, -95 - update trans set balance=1078, needsrebal=0 where id=3791
888: 250274 - 2005-12-29, -190 - update trans set balance=888, needsrebal=0 where id=3790
698: 250274 - 2005-12-29, -190 - update trans set balance=698, needsrebal=0 where id=3806
508: 250274 - 2005-12-29, -190 - update trans set balance=508, needsrebal=0 where id=3804
318: 250274 - 2005-12-29, -190 - update trans set balance=318, needsrebal=0 where id=3814
33: 250274 - 2006-01-03, -285 - update trans set balance=33, needsrebal=0 where id=3789
0: 250274 - 2006-01-03, -33 - update trans set balance=0, needsrebal=0 where id=3836
2000: 250275 - 2005-09-06, 2000 - update trans set balance=2000, needsrebal=0 where id=2680
1938: 250275 - 2006-01-03, -62 - update trans set balance=1938, needsrebal=0 where id=3837
1748: 250275 - 2006-01-03, -190 - update trans set balance=1748, needsrebal=0 where id=3838
1463: 250275 - 2006-01-03, -285 - update trans set balance=1463, needsrebal=0 where id=3839
1368: 250275 - 2006-01-04, -95 - update trans set balance=1368, needsrebal=0 where id=3853
228: 250275 - 2006-01-04, -1140 - update trans set balance=228, needsrebal=0 where id=3850
133: 250275 - 2006-01-05, -95 - update trans set balance=133, needsrebal=0 where id=3851
0: 250275 - 2006-01-10, -133 - update trans set balance=0, needsrebal=0 where id=3875
2000: 250276 - 2005-09-06, 2000 - update trans set balance=2000, needsrebal=0 where id=2681
1715: 250276 - 2006-01-05, -285 - update trans set balance=1715, needsrebal=0 where id=3877
1620: 250276 - 2006-01-05, -95 - update trans set balance=1620, needsrebal=0 where id=3878
1525: 250276 - 2006-01-09, -95 - update trans set balance=1525, needsrebal=0 where id=3873
1335: 250276 - 2006-01-09, -190 - update trans set balance=1335, needsrebal=0 where id=3874
1315: 250276 - 2006-01-09, -20 - update trans set balance=1315, needsrebal=0 where id=3895
1068: 250276 - 2006-01-10, -247 - update trans set balance=1068, needsrebal=0 where id=3876
973: 250276 - 2006-01-10, -95 - update trans set balance=973, needsrebal=0 where id=3906
958: 250276 - 2006-01-10, -15 - update trans set balance=958, needsrebal=0 where id=3914
578: 250276 - 2006-01-11, -380 - update trans set balance=578, needsrebal=0 where id=3911
388: 250276 - 2006-01-11, -190 - update trans set balance=388, needsrebal=0 where id=3912
198: 250276 - 2006-01-12, -190 - update trans set balance=198, needsrebal=0 where id=3907
103: 250276 - 2006-01-12, -95 - update trans set balance=103, needsrebal=0 where id=3908
0: 250276 - 2006-01-13, -103 - update trans set balance=0, needsrebal=0 where id=3934
2000: 250326 - 2005-08-05, 2000 - update trans set balance=2000, needsrebal=0 where id=2394
56: 250326 - 2005-11-14, -1944 - update trans set balance=56, needsrebal=0 where id=3388
0: 250326 - 2005-11-14, -56 - update trans set balance=0, needsrebal=0 where id=3389
1999: 250327 - 2005-08-05, 1999 - update trans set balance=1999, needsrebal=0 where id=2393
1833: 250327 - 2005-12-20, -166 - update trans set balance=1833, needsrebal=0 where id=3742
1643: 250327 - 2005-12-20, -190 - update trans set balance=1643, needsrebal=0 where id=3743
1073: 250327 - 2005-12-27, -570 - update trans set balance=1073, needsrebal=0 where id=3778
978: 250327 - 2005-12-27, -95 - update trans set balance=978, needsrebal=0 where id=3788
598: 250327 - 2005-12-27, -380 - update trans set balance=598, needsrebal=0 where id=3774
475: 250327 - 2005-12-27, -123 - update trans set balance=475, needsrebal=0 where id=3775
0: 250327 - 2005-12-29, -475 - update trans set balance=0, needsrebal=0 where id=3759
2000: 250330 - 2005-08-29, 2000 - update trans set balance=2000, needsrebal=0 where id=2585
1810: 250330 - 2006-01-27, -190 - update trans set balance=1810, needsrebal=0 where id=4051
1620: 250330 - 2006-01-27, -190 - update trans set balance=1620, needsrebal=0 where id=4044
1525: 250330 - 2006-01-27, -95 - update trans set balance=1525, needsrebal=0 where id=4060
1495: 250330 - 2006-01-30, -30 - update trans set balance=1495, needsrebal=0 where id=4056
1465: 250330 - 2006-01-30, -30 - update trans set balance=1465, needsrebal=0 where id=4054
1440: 250330 - 2006-01-30, -25 - update trans set balance=1440, needsrebal=0 where id=4053
1345: 250330 - 2006-01-30, -95 - update trans set balance=1345, needsrebal=0 where id=4062
1255: 250330 - 2006-01-30, -90 - update trans set balance=1255, needsrebal=0 where id=4046
970: 250330 - 2006-01-31, -285 - update trans set balance=970, needsrebal=0 where id=4084
875: 250330 - 2006-01-31, -95 - update trans set balance=875, needsrebal=0 where id=4085
685: 250330 - 2006-01-31, -190 - update trans set balance=685, needsrebal=0 where id=4083
400: 250330 - 2006-01-31, -285 - update trans set balance=400, needsrebal=0 where id=4082
115: 250330 - 2006-01-31, -285 - update trans set balance=115, needsrebal=0 where id=4081
28: 250330 - 2006-02-02, -87 - update trans set balance=28, needsrebal=0 where id=4129
5: 250330 - 2006-02-09, -23 - update trans set balance=5, needsrebal=0 where id=4180
2: 250330 - 2006-04-24, -3 - update trans set balance=2, needsrebal=0 where id=4578
193: 250330 - 2006-04-26, 191 - update trans set balance=193, needsrebal=0 where id=4729
61: 250330 - 2006-05-04, -132 - update trans set balance=61, needsrebal=0 where id=4794
36: 250330 - 2006-05-09, -25 - update trans set balance=36, needsrebal=0 where id=4800
0: 250330 - 2006-05-22, -36 - update trans set balance=0, needsrebal=0 where id=4860
1793: 3515 - 2005-01-19, 1793 - update trans set balance=1793, needsrebal=0 where id=34
1788: 3515 - 2005-01-31, -5 - update trans set balance=1788, needsrebal=0 where id=72
1787: 3515 - 2005-01-31, -1 - update trans set balance=1787, needsrebal=0 where id=46
1767: 3515 - 2005-02-10, -20 - update trans set balance=1767, needsrebal=0 where id=591
1762: 3515 - 2005-02-25, -5 - update trans set balance=1762, needsrebal=0 where id=474
1761: 3515 - 2005-02-25, -1 - update trans set balance=1761, needsrebal=0 where id=466
1741: 3515 - 2005-03-11, -20 - update trans set balance=1741, needsrebal=0 where id=831
1740: 3515 - 2005-03-11, -1 - update trans set balance=1740, needsrebal=0 where id=1135
1738: 3515 - 2005-03-11, -2 - update trans set balance=1738, needsrebal=0 where id=870
1733: 3515 - 2005-03-22, -5 - update trans set balance=1733, needsrebal=0 where id=993
1732: 3515 - 2005-03-31, -1 - update trans set balance=1732, needsrebal=0 where id=1116
1807: 3515 - 2005-04-08, 75 - update trans set balance=1807, needsrebal=0 where id=1546
1707: 3515 - 2005-04-12, -100 - update trans set balance=1707, needsrebal=0 where id=1287
1632: 3515 - 2005-04-19, -75 - update trans set balance=1632, needsrebal=0 where id=1316
1612: 3515 - 2005-04-20, -20 - update trans set balance=1612, needsrebal=0 where id=1175
1312: 3515 - 2005-04-27, -300 - update trans set balance=1312, needsrebal=0 where id=1340
1311: 3515 - 2005-05-09, -1 - update trans set balance=1311, needsrebal=0 where id=1501
1308: 3515 - 2005-05-09, -3 - update trans set balance=1308, needsrebal=0 where id=1510
1305: 3515 - 2005-05-23, -3 - update trans set balance=1305, needsrebal=0 where id=1785
1298: 3515 - 2005-05-27, -7 - update trans set balance=1298, needsrebal=0 where id=1711
1283: 3515 - 2005-06-02, -15 - update trans set balance=1283, needsrebal=0 where id=1677
1253: 3515 - 2005-06-29, -30 - update trans set balance=1253, needsrebal=0 where id=1945
1238: 3515 - 2005-06-30, -15 - update trans set balance=1238, needsrebal=0 where id=1994
1237: 3515 - 2005-07-01, -1 - update trans set balance=1237, needsrebal=0 where id=2010
1222: 3515 - 2005-08-04, -15 - update trans set balance=1222, needsrebal=0 where id=2244
1220: 3515 - 2005-08-08, -2 - update trans set balance=1220, needsrebal=0 where id=2401
1217: 3515 - 2005-09-08, -3 - update trans set balance=1217, needsrebal=0 where id=2605
1202: 3515 - 2005-09-26, -15 - update trans set balance=1202, needsrebal=0 where id=2737
1182: 3515 - 2005-10-13, -20 - update trans set balance=1182, needsrebal=0 where id=3081
1180: 3515 - 2005-10-28, -2 - update trans set balance=1180, needsrebal=0 where id=3300
708: 3515 - 2005-11-28, -472 - update trans set balance=708, needsrebal=0 where id=3507
76: 3515 - 2005-12-02, -632 - update trans set balance=76, needsrebal=0 where id=3553
75: 3515 - 2005-12-02, -1 - update trans set balance=75, needsrebal=0 where id=3756
0: 3515 - 2005-12-15, -75 - update trans set balance=0, needsrebal=0 where id=3341
84: 4230 - 2006-04-25, 84 - update trans set balance=84, needsrebal=0 where id=4922
80: 4230 - 2006-05-17, -4 - update trans set balance=80, needsrebal=0 where id=4923
45: 4230 - 2006-08-24, -35 - update trans set balance=45, needsrebal=0 where id=5059
0: 4230 - 2006-10-04, -45 - update trans set balance=0, needsrebal=0 where id=5120
1275: #4080 - 2005-09-12, 1275 - update trans set balance=1275, needsrebal=0 where id=2686
482: #4080 - 2005-12-02, -793 - update trans set balance=482, needsrebal=0 where id=3555
431: #4080 - 2005-12-02, -51 - update trans set balance=431, needsrebal=0 where id=3757
409: #4080 - 2006-01-04, -22 - update trans set balance=409, needsrebal=0 where id=3844
334: #4080 - 2006-01-13, -75 - update trans set balance=334, needsrebal=0 where id=3959
333: #4080 - 2006-01-30, -1 - update trans set balance=333, needsrebal=0 where id=4078
332: #4080 - 2006-02-13, -1 - update trans set balance=332, needsrebal=0 where id=4248
329: #4080 - 2006-02-28, -3 - update trans set balance=329, needsrebal=0 where id=4320
327: #4080 - 2006-03-22, -2 - update trans set balance=327, needsrebal=0 where id=4464
324: #4080 - 2006-03-22, -3 - update trans set balance=324, needsrebal=0 where id=4474
307: #4080 - 2006-04-25, -17 - update trans set balance=307, needsrebal=0 where id=4726
287: #4080 - 2006-04-25, -20 - update trans set balance=287, needsrebal=0 where id=4572
283: #4080 - 2006-05-19, -4 - update trans set balance=283, needsrebal=0 where id=4846
183: #4080 - 2006-08-01, -100 - update trans set balance=183, needsrebal=0 where id=5021
148: #4080 - 2006-08-24, -35 - update trans set balance=148, needsrebal=0 where id=5060
135: #4080 - 2007-10-15, -13 - update trans set balance=135, needsrebal=0 where id=5719
0: #4080 - 2007-10-15, -135 - update trans set balance=0, needsrebal=0 where id=5644
1025: 3498 - 2005-01-19, 1025 - update trans set balance=1025, needsrebal=0 where id=35
1024: 3498 - 2005-01-31, -1 - update trans set balance=1024, needsrebal=0 where id=51
1019: 3498 - 2005-01-31, -5 - update trans set balance=1019, needsrebal=0 where id=73
1018: 3498 - 2005-01-31, -1 - update trans set balance=1018, needsrebal=0 where id=47
1003: 3498 - 2005-02-25, -15 - update trans set balance=1003, needsrebal=0 where id=471
1002: 3498 - 2005-02-25, -1 - update trans set balance=1002, needsrebal=0 where id=467
1000: 3498 - 2005-03-09, -2 - update trans set balance=1000, needsrebal=0 where id=840
1065: 3498 - 2005-03-11, 65 - update trans set balance=1065, needsrebal=0 where id=1133
1063: 3498 - 2005-03-11, -2 - update trans set balance=1063, needsrebal=0 where id=869
1062: 3498 - 2005-03-28, -1 - update trans set balance=1062, needsrebal=0 where id=987
1061: 3498 - 2005-03-31, -1 - update trans set balance=1061, needsrebal=0 where id=1117
1046: 3498 - 2005-04-13, -15 - update trans set balance=1046, needsrebal=0 where id=1279
1045: 3498 - 2005-05-09, -1 - update trans set balance=1045, needsrebal=0 where id=1502
1043: 3498 - 2005-05-12, -2 - update trans set balance=1043, needsrebal=0 where id=1553
1042: 3498 - 2005-05-20, -1 - update trans set balance=1042, needsrebal=0 where id=1691
1039: 3498 - 2005-05-23, -3 - update trans set balance=1039, needsrebal=0 where id=1784
1032: 3498 - 2005-05-27, -7 - update trans set balance=1032, needsrebal=0 where id=1710
507: 3498 - 2005-06-22, -525 - update trans set balance=507, needsrebal=0 where id=1912
492: 3498 - 2005-06-30, -15 - update trans set balance=492, needsrebal=0 where id=1995
491: 3498 - 2005-07-01, -1 - update trans set balance=491, needsrebal=0 where id=2011
479: 3498 - 2005-07-05, -12 - update trans set balance=479, needsrebal=0 where id=2466
477: 3498 - 2005-07-14, -2 - update trans set balance=477, needsrebal=0 where id=2187
258: 3498 - 2005-07-15, -219 - update trans set balance=258, needsrebal=0 where id=2132
183: 3498 - 2005-08-08, -75 - update trans set balance=183, needsrebal=0 where id=2356
181: 3498 - 2005-08-08, -2 - update trans set balance=181, needsrebal=0 where id=2402
171: 3498 - 2005-09-26, -10 - update trans set balance=171, needsrebal=0 where id=2738
170: 3498 - 2005-09-30, -1 - update trans set balance=170, needsrebal=0 where id=2873
160: 3498 - 2005-10-12, -10 - update trans set balance=160, needsrebal=0 where id=3054
159: 3498 - 2005-10-12, -1 - update trans set balance=159, needsrebal=0 where id=3086
158: 3498 - 2005-10-24, -1 - update trans set balance=158, needsrebal=0 where id=3181
156: 3498 - 2005-10-28, -2 - update trans set balance=156, needsrebal=0 where id=3299
0: 3498 - 2005-11-28, -156 - update trans set balance=0, needsrebal=0 where id=3508
219: 3516 - 2005-01-01, 219 - update trans set balance=219, needsrebal=0 where id=743
75: 3516 - 2005-11-28, -144 - update trans set balance=75, needsrebal=0 where id=3509
51: 3516 - 2005-12-02, -24 - update trans set balance=51, needsrebal=0 where id=3554
31: 3516 - 2006-01-03, -20 - update trans set balance=31, needsrebal=0 where id=3812
0: 3516 - 2006-01-04, -31 - update trans set balance=0, needsrebal=0 where id=3843
480: #4068 - 2005-09-27, 480 - update trans set balance=480, needsrebal=0 where id=2690
400: #4068 - 2005-10-19, -80 - update trans set balance=400, needsrebal=0 where id=3039
22: #4068 - 2005-10-27, -378 - update trans set balance=22, needsrebal=0 where id=3134
14: #4068 - 2005-11-01, -8 - update trans set balance=14, needsrebal=0 where id=3304
5: #4068 - 2005-12-22, -9 - update trans set balance=5, needsrebal=0 where id=3936
0: #4068 - 2005-12-27, -5 - update trans set balance=0, needsrebal=0 where id=3785
264: 3384 - 2005-01-01, 264 - update trans set balance=264, needsrebal=0 where id=787
263: 3384 - 2005-01-03, -1 - update trans set balance=263, needsrebal=0 where id=357
283: 3384 - 2005-01-13, 20 - update trans set balance=283, needsrebal=0 where id=797
268: 3384 - 2005-01-14, -15 - update trans set balance=268, needsrebal=0 where id=202
5: 3384 - 2005-01-14, -263 - update trans set balance=5, needsrebal=0 where id=203
0: 3384 - 2005-01-28, -5 - update trans set balance=0, needsrebal=0 where id=88
160: 3517 - 2005-01-19, 160 - update trans set balance=160, needsrebal=0 where id=36
145: 3517 - 2005-01-28, -15 - update trans set balance=145, needsrebal=0 where id=422
125: 3517 - 2005-04-29, -20 - update trans set balance=125, needsrebal=0 where id=1406
124: 3517 - 2005-05-09, -1 - update trans set balance=124, needsrebal=0 where id=1504
109: 3517 - 2005-05-19, -15 - update trans set balance=109, needsrebal=0 where id=1638
107: 3517 - 2005-05-23, -2 - update trans set balance=107, needsrebal=0 where id=1779
0: 3517 - 2005-05-31, -107 - update trans set balance=0, needsrebal=0 where id=1748
430: 4015 - 2005-04-07, 430 - update trans set balance=430, needsrebal=0 where id=1132
530: 4015 - 2005-04-08, 100 - update trans set balance=530, needsrebal=0 where id=1539
397: 4015 - 2005-05-31, -133 - update trans set balance=397, needsrebal=0 where id=1749
384: 4015 - 2005-06-24, -13 - update trans set balance=384, needsrebal=0 where id=1936
364: 4015 - 2005-07-29, -20 - update trans set balance=364, needsrebal=0 where id=2325
362: 4015 - 2005-07-29, -2 - update trans set balance=362, needsrebal=0 where id=2313
332: 4015 - 2005-08-16, -30 - update trans set balance=332, needsrebal=0 where id=2462
324: 4015 - 2005-10-03, -8 - update trans set balance=324, needsrebal=0 where id=2871
321: 4015 - 2005-10-03, -3 - update trans set balance=321, needsrebal=0 where id=2884
301: 4015 - 2005-10-06, -20 - update trans set balance=301, needsrebal=0 where id=2887
226: 4015 - 2005-10-11, -75 - update trans set balance=226, needsrebal=0 where id=3131
222: 4015 - 2005-10-19, -4 - update trans set balance=222, needsrebal=0 where id=3132
0: 4015 - 2005-10-27, -222 - update trans set balance=0, needsrebal=0 where id=3133
3211: 230590 - 2004-11-10, 3211 - update trans set balance=3211, needsrebal=0 where id=758
3191: 230590 - 2005-01-13, -20 - update trans set balance=3191, needsrebal=0 where id=234
2987: 230590 - 2005-01-13, -204 - update trans set balance=2987, needsrebal=0 where id=411
2827: 230590 - 2005-01-17, -160 - update trans set balance=2827, needsrebal=0 where id=200
2822: 230590 - 2005-01-20, -5 - update trans set balance=2822, needsrebal=0 where id=157
2742: 230590 - 2005-01-20, -80 - update trans set balance=2742, needsrebal=0 where id=144
2582: 230590 - 2005-01-25, -160 - update trans set balance=2582, needsrebal=0 where id=127
2532: 230590 - 2005-01-25, -50 - update trans set balance=2532, needsrebal=0 where id=119
2452: 230590 - 2005-01-27, -80 - update trans set balance=2452, needsrebal=0 where id=94
2448: 230590 - 2005-01-31, -4 - update trans set balance=2448, needsrebal=0 where id=39
1968: 230590 - 2005-02-02, -480 - update trans set balance=1968, needsrebal=0 where id=676
1808: 230590 - 2005-02-07, -160 - update trans set balance=1808, needsrebal=0 where id=639
1488: 230590 - 2005-02-07, -320 - update trans set balance=1488, needsrebal=0 where id=641
1478: 230590 - 2005-02-10, -10 - update trans set balance=1478, needsrebal=0 where id=582
1228: 230590 - 2005-02-10, -250 - update trans set balance=1228, needsrebal=0 where id=589
908: 230590 - 2005-02-17, -320 - update trans set balance=908, needsrebal=0 where id=553
0: 230590 - 2005-02-22, -908 - update trans set balance=0, needsrebal=0 where id=497
683: 230789 - 2005-01-01, 683 - update trans set balance=683, needsrebal=0 where id=795
523: 230789 - 2005-01-03, -160 - update trans set balance=523, needsrebal=0 where id=352
203: 230789 - 2005-01-04, -320 - update trans set balance=203, needsrebal=0 where id=330
171: 230789 - 2005-01-06, -32 - update trans set balance=171, needsrebal=0 where id=309
151: 230789 - 2005-01-11, -20 - update trans set balance=151, needsrebal=0 where id=282
35: 230789 - 2005-01-13, -116 - update trans set balance=35, needsrebal=0 where id=239
0: 230789 - 2005-01-13, -35 - update trans set balance=0, needsrebal=0 where id=242
3211: 240323 - 2005-01-01, 3211 - update trans set balance=3211, needsrebal=0 where id=756
3131: 240323 - 2005-04-12, -80 - update trans set balance=3131, needsrebal=0 where id=1288
2971: 240323 - 2005-04-12, -160 - update trans set balance=2971, needsrebal=0 where id=1291
2651: 240323 - 2005-04-14, -320 - update trans set balance=2651, needsrebal=0 where id=1277
2551: 240323 - 2005-04-20, -100 - update trans set balance=2551, needsrebal=0 where id=1173
2391: 240323 - 2005-04-21, -160 - update trans set balance=2391, needsrebal=0 where id=1371
2051: 240323 - 2005-04-22, -340 - update trans set balance=2051, needsrebal=0 where id=1378
2035: 240323 - 2005-04-27, -16 - update trans set balance=2035, needsrebal=0 where id=1353
1414: 240323 - 2005-04-27, -621 - update trans set balance=1414, needsrebal=0 where id=1321
1389: 240323 - 2005-04-28, -25 - update trans set balance=1389, needsrebal=0 where id=1359
1386: 240323 - 2005-05-09, -3 - update trans set balance=1386, needsrebal=0 where id=1485
1226: 240323 - 2005-05-11, -160 - update trans set balance=1226, needsrebal=0 where id=1569
1076: 240323 - 2005-05-11, -150 - update trans set balance=1076, needsrebal=0 where id=1558
1041: 240323 - 2005-05-12, -35 - update trans set balance=1041, needsrebal=0 where id=1796
1031: 240323 - 2005-05-16, -10 - update trans set balance=1031, needsrebal=0 where id=1642
991: 240323 - 2005-05-17, -40 - update trans set balance=991, needsrebal=0 where id=1603
971: 240323 - 2005-05-17, -20 - update trans set balance=971, needsrebal=0 where id=1606
651: 240323 - 2005-05-17, -320 - update trans set balance=651, needsrebal=0 where id=1601
320: 240323 - 2005-05-19, -331 - update trans set balance=320, needsrebal=0 where id=1650
Non-zero - write -insert into marknumbals(shipperid, shippercode, skuid, sku, marknum, balance, firsttransdate, lasttransdate) values (1, 'AST007', 21, 'M15MBALLS', '240323', 320, '2005-01-01','2005-05-19');
3210: 240324 - 2005-02-15, 3210 - update trans set balance=3210, needsrebal=0 where id=381
3195: 240324 - 2005-05-18, -15 - update trans set balance=3195, needsrebal=0 where id=1659
3185: 240324 - 2005-05-18, -10 - update trans set balance=3185, needsrebal=0 where id=1667
3036: 240324 - 2005-05-19, -149 - update trans set balance=3036, needsrebal=0 where id=1651
3032: 240324 - 2005-05-23, -4 - update trans set balance=3032, needsrebal=0 where id=1786
2872: 240324 - 2005-05-26, -160 - update trans set balance=2872, needsrebal=0 where id=1701
2822: 240324 - 2005-05-27, -50 - update trans set balance=2822, needsrebal=0 where id=1753
2502: 240324 - 2005-05-31, -320 - update trans set balance=2502, needsrebal=0 where id=1730
2492: 240324 - 2005-05-31, -10 - update trans set balance=2492, needsrebal=0 where id=1733
2332: 240324 - 2005-05-31, -160 - update trans set balance=2332, needsrebal=0 where id=1725
2172: 240324 - 2005-06-01, -160 - update trans set balance=2172, needsrebal=0 where id=2024
2022: 240324 - 2005-06-02, -150 - update trans set balance=2022, needsrebal=0 where id=1847
1222: 240324 - 2005-06-07, -800 - update trans set balance=1222, needsrebal=0 where id=2017
902: 240324 - 2005-06-08, -320 - update trans set balance=902, needsrebal=0 where id=2020
0: 240324 - 2005-06-16, -902 - update trans set balance=0, needsrebal=0 where id=1881
3211: 240325 - 2005-02-15, 3211 - update trans set balance=3211, needsrebal=0 where id=380
2003: 240325 - 2005-06-16, -1208 - update trans set balance=2003, needsrebal=0 where id=1882
1903: 240325 - 2005-06-24, -100 - update trans set balance=1903, needsrebal=0 where id=1927
1897: 240325 - 2005-06-30, -6 - update trans set balance=1897, needsrebal=0 where id=1983
1802: 240325 - 2005-07-14, -95 - update trans set balance=1802, needsrebal=0 where id=2144
1786: 240325 - 2005-07-14, -16 - update trans set balance=1786, needsrebal=0 where id=2158
1306: 240325 - 2005-07-19, -480 - update trans set balance=1306, needsrebal=0 where id=2204
1146: 240325 - 2005-07-20, -160 - update trans set balance=1146, needsrebal=0 where id=2221
826: 240325 - 2005-07-29, -320 - update trans set balance=826, needsrebal=0 where id=2289
822: 240325 - 2005-07-29, -4 - update trans set balance=822, needsrebal=0 where id=2317
632: 240325 - 2005-08-04, -190 - update trans set balance=632, needsrebal=0 where id=2243
612: 240325 - 2005-08-12, -20 - update trans set balance=612, needsrebal=0 where id=2414
452: 240325 - 2005-08-12, -160 - update trans set balance=452, needsrebal=0 where id=2436
432: 240325 - 2005-08-19, -20 - update trans set balance=432, needsrebal=0 where id=2493
0: 240325 - 2005-08-22, -432 - update trans set balance=0, needsrebal=0 where id=2514
3210: 240326 - 2005-02-16, 3210 - update trans set balance=3210, needsrebal=0 where id=383
2803: 240326 - 2005-08-29, -407 - update trans set balance=2803, needsrebal=0 where id=2547
2793: 240326 - 2005-09-07, -10 - update trans set balance=2793, needsrebal=0 where id=2608
2313: 240326 - 2005-09-12, -480 - update trans set balance=2313, needsrebal=0 where id=2618
2233: 240326 - 2005-09-13, -80 - update trans set balance=2233, needsrebal=0 where id=2646
2208: 240326 - 2005-09-14, -25 - update trans set balance=2208, needsrebal=0 where id=2655
2192: 240326 - 2005-09-14, -16 - update trans set balance=2192, needsrebal=0 where id=2664
2191: 240326 - 2005-09-14, -1 - update trans set balance=2191, needsrebal=0 where id=2673
2001: 240326 - 2005-09-15, -190 - update trans set balance=2001, needsrebal=0 where id=2669
1991: 240326 - 2005-09-20, -10 - update trans set balance=1991, needsrebal=0 where id=2816
551: 240326 - 2005-09-28, -1440 - update trans set balance=551, needsrebal=0 where id=2847
391: 240326 - 2005-09-29, -160 - update trans set balance=391, needsrebal=0 where id=2849
80: 240326 - 2005-09-30, -311 - update trans set balance=80, needsrebal=0 where id=2861
0: 240326 - 2005-10-05, -80 - update trans set balance=0, needsrebal=0 where id=2762
3210: 240327 - 2005-04-14, 3210 - update trans set balance=3210, needsrebal=0 where id=944
2448: 240327 - 2005-12-19, -762 - update trans set balance=2448, needsrebal=0 where id=3711
2446: 240327 - 2005-12-19, -2 - update trans set balance=2446, needsrebal=0 where id=3748
2366: 240327 - 2005-12-27, -80 - update trans set balance=2366, needsrebal=0 where id=3772
2141: 240327 - 2006-01-05, -225 - update trans set balance=2141, needsrebal=0 where id=3884
2138: 240327 - 2006-01-09, -3 - update trans set balance=2138, needsrebal=0 where id=3899
1338: 240327 - 2006-01-10, -800 - update trans set balance=1338, needsrebal=0 where id=3916
1328: 240327 - 2006-01-10, -10 - update trans set balance=1328, needsrebal=0 where id=3915
1553: 240327 - 2006-01-17, 225 - update trans set balance=1553, needsrebal=0 where id=3982
1538: 240327 - 2006-01-30, -15 - update trans set balance=1538, needsrebal=0 where id=4058
1218: 240327 - 2006-01-30, -320 - update trans set balance=1218, needsrebal=0 where id=4064
1058: 240327 - 2006-01-30, -160 - update trans set balance=1058, needsrebal=0 where id=4067
1018: 240327 - 2006-02-10, -40 - update trans set balance=1018, needsrebal=0 where id=4168
698: 240327 - 2006-02-14, -320 - update trans set balance=698, needsrebal=0 where id=4184
538: 240327 - 2006-02-17, -160 - update trans set balance=538, needsrebal=0 where id=4229
218: 240327 - 2006-02-20, -320 - update trans set balance=218, needsrebal=0 where id=4219
188: 240327 - 2006-02-28, -30 - update trans set balance=188, needsrebal=0 where id=4336
183: 240327 - 2006-02-28, -5 - update trans set balance=183, needsrebal=0 where id=4315
23: 240327 - 2006-03-03, -160 - update trans set balance=23, needsrebal=0 where id=4354
13: 240327 - 2006-03-06, -10 - update trans set balance=13, needsrebal=0 where id=4359
0: 240327 - 2006-03-06, -13 - update trans set balance=0, needsrebal=0 where id=4357
3211: 240361 - 2005-03-02, 3211 - update trans set balance=3211, needsrebal=0 where id=390
3161: 240361 - 2005-09-30, -50 - update trans set balance=3161, needsrebal=0 where id=2863
3152: 240361 - 2005-09-30, -9 - update trans set balance=3152, needsrebal=0 where id=2862
3147: 240361 - 2005-10-03, -5 - update trans set balance=3147, needsrebal=0 where id=2879
2987: 240361 - 2005-10-07, -160 - update trans set balance=2987, needsrebal=0 where id=2903
1707: 240361 - 2005-10-11, -1280 - update trans set balance=1707, needsrebal=0 where id=2995
1387: 240361 - 2005-10-18, -320 - update trans set balance=1387, needsrebal=0 where id=3109
1067: 240361 - 2005-10-19, -320 - update trans set balance=1067, needsrebal=0 where id=3128
587: 240361 - 2005-10-25, -480 - update trans set balance=587, needsrebal=0 where id=3208
267: 240361 - 2005-10-26, -320 - update trans set balance=267, needsrebal=0 where id=3215
0: 240361 - 2005-10-27, -267 - update trans set balance=0, needsrebal=0 where id=3271
3211: 240362 - 2005-02-16, 3211 - update trans set balance=3211, needsrebal=0 where id=384
3201: 240362 - 2005-08-22, -10 - update trans set balance=3201, needsrebal=0 where id=2639
753: 240362 - 2005-08-22, -2448 - update trans set balance=753, needsrebal=0 where id=2515
748: 240362 - 2005-08-23, -5 - update trans set balance=748, needsrebal=0 where id=2526
553: 240362 - 2005-08-25, -195 - update trans set balance=553, needsrebal=0 where id=2534
393: 240362 - 2005-08-26, -160 - update trans set balance=393, needsrebal=0 where id=2531
0: 240362 - 2005-08-29, -393 - update trans set balance=0, needsrebal=0 where id=2546
Go