📊 HOMESAAZ Database Viewer
← Back to TablesTable: dbo.SalesNonAE
| SalesID | ItemNumber | Sold | Cost | Sales | Profit | SalesDate | PYear | TaxAmount |
|---|
| 1 | A1535 | -1.00 | -250.0000 | -444.4447 | -194.4447 | 8 | 2016 | -55.5602 |
| 2 | A1607 | -96.25 | -26974.0625 | -55258.7035 | -28284.6410 | 12 | 2015 | -2762.9317 |
| 3 | A1959 | 19.50 | 1657.5000 | 1060.2072 | -597.2928 | 3 | 2016 | .0000 |
| 4 | A1959 | 19.00 | 1615.0000 | 8173.8000 | 6558.8000 | 4 | 2015 | .0000 |
| 5 | A1959 | 64.80 | 9720.0000 | 19980.0000 | 10260.0000 | 6 | 2016 | .0000 |
| 6 | A1959 | 11.00 | 935.0000 | 11727.9100 | 10792.9100 | 10 | 2015 | .0000 |
| 7 | A2389 | -1.00 | -1993.0000 | -2855.3176 | -862.3176 | 9 | 2015 | -142.7688 |
| 8 | A4389 | -1.00 | -1110.9300 | -2662.2222 | -1551.2922 | 9 | 2016 | -332.7800 |
| 9 | A4530 | -1.00 | -3822.0000 | -6755.5520 | -2933.5520 | 8 | 2015 | -844.4480 |
| 10 | A4770 | -19.00 | -811.1917 | -1357.1700 | -545.9783 | 11 | 2015 | -67.8600 |
| 11 | A4780 | -12.00 | -444.0204 | -666.7152 | -222.6948 | 7 | 2015 | -33.3332 |
| 12 | A971 | 2.00 | 393.3332 | 452.3150 | 58.9818 | 4 | 2015 | 22.6129 |
| 13 | B123 | -1.00 | -200.0000 | -310.0000 | -110.0000 | 10 | 2016 | -15.5000 |
| 14 | B3855 | -1.00 | -999.5000 | -1379.4000 | -379.9000 | 9 | 2016 | -68.9700 |
| 15 | B4035 | -1.00 | -1463.0000 | -2385.7125 | -922.7125 | 10 | 2016 | -119.2875 |
| 16 | B4687 | -6.10 | -1098.0000 | -2088.6400 | -990.6400 | 9 | 2016 | .0000 |
| 17 | B4785 | -1.00 | -736.2500 | -1347.5000 | -611.2500 | 8 | 2015 | -67.3800 |
| 18 | B5813 | -1.00 | -2042.5000 | -3870.0000 | -1827.5000 | 10 | 2015 | -193.5000 |
| 19 | B6226 | -2.00 | -2550.0000 | -3804.7620 | -1254.7620 | 5 | 2015 | -190.2400 |
| 20 | B6959 | -1.00 | -5177.5000 | -9062.8889 | -3885.3889 | 6 | 2016 | -1132.8630 |
| 21 | B7090 | -1.00 | -217.6000 | -308.2695 | -90.6695 | 7 | 2016 | -38.5305 |
| 22 | B7384 | -1.00 | -451.2500 | -777.0000 | -325.7500 | 8 | 2016 | -38.8500 |
| 23 | C2785 | -1.00 | -868.8300 | -1773.3300 | -904.5000 | 1 | 2016 | -221.6700 |
| 24 | C2931 | -67.50 | -11863.1250 | -19189.3860 | -7326.2610 | 12 | 2015 | -959.4705 |
| 25 | C2984 | -2.00 | -1600.0000 | -2775.0928 | -1175.0928 | 2 | 2016 | -138.7555 |
| 26 | D1366 | 2.00 | 1500.0000 | 1428.5800 | -71.4200 | 9 | 2016 | 71.4300 |
| 27 | D326 | 453.95 | 22930.0220 | 38233.4140 | 15303.3920 | 5 | 2016 | 4779.1800 |
| 28 | D326 | 203.68 | 14338.6678 | 22575.6402 | 8236.9724 | 6 | 2015 | 2821.9497 |
| 29 | D326 | 144.65 | 9836.2000 | 11933.6250 | 2097.4250 | 8 | 2016 | 1491.7000 |
| 30 | D326 | 156.00 | 4506.6684 | 9013.6800 | 4507.0116 | 9 | 2015 | 1126.7100 |
| 31 | D327 | 969.00 | 24054.0000 | 57743.2800 | 33689.2800 | 6 | 2016 | 7217.9100 |
| 32 | D327 | 285.00 | 11400.0114 | 18674.3400 | 7274.3286 | 7 | 2015 | 2334.3000 |
| 33 | D327 | 456.00 | 13110.0000 | 24829.2000 | 11719.2000 | 9 | 2016 | 3103.6500 |
| 34 | D327 | 748.00 | 36923.1157 | 63749.5400 | 26826.4243 | 10 | 2015 | 7968.6900 |
| 35 | D4570 | -1.00 | -375.0000 | -702.8311 | -327.8311 | 6 | 2016 | -87.8576 |
| 36 | D502 | 3.00 | 12986.6667 | 19668.0356 | 6681.3689 | 6 | 2015 | 983.4055 |
| 37 | D5192 | -8.00 | -2960.0000 | -5451.4288 | -2491.4288 | 7 | 2015 | -272.5700 |
| 38 | D5967 | -1.00 | -395.0000 | -650.0025 | -255.0025 | 6 | 2016 | -81.2475 |
| 39 | D8916 | -2.00 | -1300.0000 | -1926.6600 | -626.6600 | 10 | 2016 | -240.8300 |
| 40 | D9148 | -1.00 | -2590.0000 | -3870.0000 | -1280.0000 | 8 | 2016 | -483.7500 |
| 41 | E3069 | -1.00 | -1065.6600 | -1434.2720 | -368.6120 | 12 | 2015 | -71.7155 |
| 42 | E3382 | -2.00 | -52.0000 | -84.0000 | -32.0000 | 8 | 2016 | -10.5000 |
| 43 | E3400 | -1.00 | -2254.0000 | -3538.2000 | -1284.2000 | 7 | 2016 | -442.2800 |
| 44 | F4365 | -1.00 | -337.5000 | -584.0000 | -246.5000 | 5 | 2015 | -73.0020 |
| 45 | F4828 | -1.00 | -2052.6800 | -2207.1450 | -154.4650 | 6 | 2016 | -110.3550 |
| 46 | F4977 | -1.00 | -921.7200 | -1185.6347 | -263.9147 | 7 | 2016 | -148.2034 |
| 47 | F5755 | -1.00 | -3742.1959 | -7989.3333 | -4247.1374 | 7 | 2015 | -998.6700 |
| 48 | F5768 | -1.00 | -6236.1000 | -13188.0000 | -6951.9000 | 11 | 2015 | -1648.5000 |
| 49 | F5808 | -1.00 | -2582.0000 | -4788.0000 | -2206.0000 | 9 | 2016 | -598.5000 |
| 50 | F6641 | -1.00 | -3385.8000 | -5928.0000 | -2542.2000 | 6 | 2016 | -741.0000 |