📊 HOMESAAZ Database Viewer
← Back to TablesTable: dbo.AllLocationStockBal
| AllLocStockID | AccountID | StockAmt | WH | LJP | FBD | RGN | LS | j4 | ggn | rjc | whrjc |
|---|
| 1 | 4091 | 10235786.6700 | 132963.8500 | 3554851.4800 | 976408.9200 | 323292.7000 | 2249236.2000 | .0000 | 1161717.2100 | 1817954.3300 | 19361.9800 |
| 2 | 4202 | 3043331.3400 | .0000 | 1037997.4000 | 256719.7800 | 88538.8200 | 459507.5000 | .0000 | 395976.4200 | 804591.4200 | .0000 |
| 3 | 6471 | 696395.1300 | 3357.3000 | 293121.7300 | 67193.3700 | 95352.1200 | 146728.7800 | .0000 | 9974.5000 | 80667.3300 | .0000 |
| 4 | 9731 | 437325.9800 | 143357.2900 | 87804.2000 | 65182.7900 | 22280.0400 | 36911.9300 | .0000 | 44420.3600 | 37369.3700 | .0000 |
| 5 | 9843 | 26138675.0300 | 1911991.0300 | 2879161.1500 | 2164138.1100 | 1407425.8100 | 2498872.1100 | .0000 | 5146426.4900 | 13956250.6300 | -3825590.3000 |
| 6 | 26849 | 451170.0000 | .0000 | 30830.0000 | 10865.0000 | 244350.0000 | 66640.0000 | .0000 | 17220.0000 | 77465.0000 | 3800.0000 |
| 7 | 42487 | 204062.2600 | .0000 | 36813.1500 | 22061.9300 | 9981.2200 | 19266.6400 | .0000 | 32452.4300 | 69411.8900 | 14075.0000 |
| 8 | 49662 | 504172.0000 | 35700.0000 | 209345.0000 | 108727.0000 | 3100.0000 | 34300.0000 | .0000 | 41800.0000 | 71200.0000 | .0000 |
| 9 | 54188 | 76835.0000 | 2700.0000 | 6080.0000 | 24295.0000 | 31110.0000 | .0000 | .0000 | 5000.0000 | 7650.0000 | .0000 |
| 10 | 57180 | -50.0000 | .0000 | -50.0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 11 | 60071 | 562737.9200 | 522.0000 | 149495.2600 | 95360.6200 | 67884.6900 | 215612.5000 | .0000 | 69472.8500 | 100843.5000 | -136453.5000 |
| 12 | 60563 | 847559.3200 | .0000 | 364360.0000 | 204126.0000 | 13450.0000 | 58988.3200 | .0000 | 62630.0000 | 144005.0000 | .0000 |
| 13 | 61060 | 1034289.1400 | 7650.0000 | 164885.8300 | 167625.5700 | 124440.2800 | 69706.2900 | .0000 | 421956.4400 | 73080.2300 | 4944.5000 |
| 14 | 61553 | 3370581.4500 | 384285.4700 | 853712.2500 | 940779.0300 | 685407.3100 | 17130.6500 | .0000 | 491600.1800 | -2333.4400 | .0000 |
| 15 | 65340 | 732442.4300 | 160875.4200 | 137342.1000 | 141674.9800 | 29488.3100 | 28305.6900 | .0000 | 93709.7900 | 141046.1400 | .0000 |
| 16 | 68983 | 701344.7800 | 34149.9400 | 62131.4300 | 96001.1900 | 102552.9500 | 114914.6600 | .0000 | 224507.3500 | 67087.2600 | .0000 |
| 17 | 73634 | 508449.2700 | .0000 | .0000 | 9606.8700 | 373873.7500 | 16295.2000 | .0000 | 80565.4900 | 28107.9600 | .0000 |
| 18 | 77388 | 1659695.4400 | 295848.3400 | 321489.2800 | 424183.7600 | 128327.9100 | 117875.6100 | .0000 | 141501.7400 | 230468.8000 | .0000 |
| 19 | 79351 | 96018.4000 | .0000 | 3271.1200 | 6622.3000 | 56529.0800 | 24400.3000 | .0000 | 5195.6000 | .0000 | .0000 |
| 20 | 80181 | 1490777.1500 | .0000 | 489499.2100 | 309008.7300 | 125964.3100 | 163909.6000 | .0000 | 258569.8400 | 135508.9000 | 8316.5600 |
| 21 | 81258 | 321848.1100 | .0000 | 156942.7200 | 5452.8500 | 13514.7900 | 28988.8800 | .0000 | 70966.3800 | 45982.4900 | .0000 |
| 22 | 81260 | 21710.5800 | 6342.8300 | 4765.1500 | 2164.7500 | 1873.0800 | 229.7100 | .0000 | 5358.6900 | 976.3700 | .0000 |
| 23 | 81328 | 21360.0000 | .0000 | 230.0000 | 3185.0000 | .0000 | 11945.0000 | .0000 | 3695.0000 | 2305.0000 | .0000 |
| 24 | 82634 | 10305.0000 | .0000 | .0000 | .0000 | 9090.0000 | .0000 | .0000 | 1215.0000 | .0000 | .0000 |
| 25 | 83904 | 106890.1500 | .0000 | 14404.9300 | 4320.0000 | 62182.1100 | 20684.1700 | .0000 | 2649.4700 | 2649.4700 | .0000 |
| 26 | 84002 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 27 | 84086 | 9485.1700 | .0000 | .0000 | .0000 | 9485.1700 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 28 | 84353 | 352.0000 | .0000 | .0000 | .0000 | 352.0000 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 29 | 85146 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 30 | 85425 | 14787.0900 | .0000 | 4665.7800 | 216.4200 | 11846.8200 | .0000 | .0000 | .0000 | -1941.9300 | .0000 |
| 31 | 86850 | 4558.6400 | 5643.8600 | 560.8800 | 560.8800 | -2767.8600 | .0000 | .0000 | 560.8800 | .0000 | .0000 |
| 32 | 86854 | 588350.6900 | 69964.8800 | 102043.6100 | 84692.0200 | 28133.9900 | 26103.8800 | .0000 | 28827.5000 | 225194.8300 | 23389.9800 |
| 33 | 86856 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 34 | 86876 | 3149190.6200 | 1094665.6200 | 719597.5800 | 670014.9000 | 50331.9100 | 37590.6100 | .0000 | 336733.3400 | 240256.6600 | .0000 |
| 35 | 86920 | 81964.6200 | .0000 | 44191.6200 | 6750.0000 | 9625.0000 | 1725.0000 | .0000 | 8773.0000 | 10900.0000 | .0000 |
| 36 | 4055 | 2719907.5900 | 277894.9100 | 580499.4700 | 581703.2400 | 197827.4300 | 273712.4900 | .0000 | 391187.0000 | 417083.0500 | .0000 |
| 37 | 4078 | 10420739.1200 | 1809098.8900 | 1178353.5400 | 1563026.3700 | 1322365.2300 | 2321151.6000 | .0000 | 1065047.9200 | 1161695.5700 | .0000 |
| 38 | 4165 | 300152.4400 | .0000 | 150841.7700 | 19422.4300 | 14641.4700 | 25801.2200 | .0000 | 50119.2300 | 39326.3200 | .0000 |
| 39 | 4244 | 204874.6300 | 24083.7000 | 26062.5300 | 34080.0000 | 2717.8000 | 33660.0000 | .0000 | 27908.8000 | 56361.8000 | .0000 |
| 40 | 6243 | 1100073.9600 | 13530.4000 | 309191.7500 | 163833.5900 | 151397.1500 | 219363.7100 | .0000 | 367005.8800 | 145451.4800 | -269700.0000 |
| 41 | 6770 | 846991.0400 | 183830.5300 | 136103.0900 | 182167.0100 | 121014.8500 | 56736.3600 | .0000 | 127717.5700 | 39421.6300 | .0000 |
| 42 | 7577 | 2805370.0500 | .0000 | 765566.4200 | 359949.4400 | 633756.2700 | 203258.5600 | .0000 | 686573.5000 | 156265.8600 | .0000 |
| 43 | 19845 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 44 | 32649 | 4481391.6700 | 856744.8600 | 699479.9600 | 741222.2600 | 549774.5700 | 990873.6300 | .0000 | 327615.3500 | 313996.0400 | 1685.0000 |
| 45 | 33473 | 61272.9400 | .0000 | 11967.5200 | 9001.5600 | 20006.5700 | .0000 | .0000 | 15356.3600 | 4940.9300 | .0000 |
| 46 | 36250 | 526324.1900 | 68380.6600 | 105137.4700 | 112187.3000 | 106260.5400 | 30013.0300 | .0000 | 63159.7100 | 41185.4800 | .0000 |
| 47 | 51880 | 297391.6800 | 116815.6900 | 50652.4500 | 44521.7300 | 34816.4800 | 2758.3300 | .0000 | 25026.4800 | 22800.5200 | .0000 |
| 48 | 55022 | 1564350.6800 | 27234.4600 | 292356.5300 | 218972.9000 | 168304.7300 | 326826.8900 | .0000 | 403822.2900 | 126832.8800 | .0000 |
| 49 | 56909 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 | .0000 |
| 50 | 63679 | 1063666.8300 | 279933.3900 | 219101.4700 | 199757.3700 | 99191.3800 | 54917.7600 | .0000 | 132935.0200 | 77830.4400 | .0000 |