[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 70 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43786_1 | 39 | 11607 | 311 | 7 | 2021-09-24 | 89.46 | 2021-09-12 | 3578.27 | 1 | SO43786 | 2021-09-19 | 286.26 | 2171.29 |
SO43796_1 | 39 | 17956 | 342 | 7 | 2021-09-25 | 17.48 | 2021-09-13 | 699.10 | 1 | SO43796 | 2021-09-20 | 55.93 | 413.15 |
SO43802_1 | 39 | 11593 | 312 | 7 | 2021-09-26 | 89.46 | 2021-09-14 | 3578.27 | 1 | SO43802 | 2021-09-21 | 286.26 | 2171.29 |
SO43807_1 | 39 | 11611 | 312 | 7 | 2021-09-28 | 89.46 | 2021-09-16 | 3578.27 | 1 | SO43807 | 2021-09-23 | 286.26 | 2171.29 |
SO43813_1 | 39 | 28390 | 350 | 7 | 2021-09-29 | 84.37 | 2021-09-17 | 3374.99 | 1 | SO43813 | 2021-09-24 | 270.00 | 1898.09 |
SO43834_1 | 39 | 28393 | 348 | 7 | 2021-10-02 | 84.37 | 2021-09-20 | 3374.99 | 1 | SO43834 | 2021-09-27 | 270.00 | 1898.09 |
SO43840_1 | 39 | 17957 | 326 | 7 | 2021-10-03 | 17.48 | 2021-09-21 | 699.10 | 1 | SO43840 | 2021-09-28 | 55.93 | 413.15 |
SO43919_1 | 39 | 12124 | 314 | 7 | 2021-10-04 | 89.46 | 2021-09-22 | 3578.27 | 1 | SO43919 | 2021-09-29 | 286.26 | 2171.29 |
SO43924_1 | 39 | 12132 | 310 | 7 | 2021-10-05 | 89.46 | 2021-09-23 | 3578.27 | 1 | SO43924 | 2021-09-30 | 286.26 | 2171.29 |
SO44030_1 | 39 | 12131 | 311 | 7 | 2021-10-27 | 89.46 | 2021-10-15 | 3578.27 | 1 | SO44030 | 2021-10-22 | 286.26 | 2171.29 |
SO44039_1 | 39 | 17971 | 342 | 7 | 2021-10-28 | 17.48 | 2021-10-16 | 699.10 | 1 | SO44039 | 2021-10-23 | 55.93 | 413.15 |
SO44045_1 | 39 | 28394 | 344 | 7 | 2021-10-29 | 85.00 | 2021-10-17 | 3399.99 | 1 | SO44045 | 2021-10-24 | 272.00 | 1912.15 |
SO44069_1 | 39 | 28395 | 349 | 7 | 2021-11-03 | 84.37 | 2021-10-22 | 3374.99 | 1 | SO44069 | 2021-10-29 | 270.00 | 1898.09 |
SO44140_1 | 39 | 12221 | 311 | 7 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO44140 | 2021-10-31 | 286.26 | 2171.29 |
SO44168_1 | 39 | 12211 | 313 | 7 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO44168 | 2021-11-05 | 286.26 | 2171.29 |
SO44176_1 | 39 | 12220 | 314 | 7 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO44176 | 2021-11-07 | 286.26 | 2171.29 |
SO44201_1 | 39 | 12254 | 313 | 7 | 2021-11-19 | 89.46 | 2021-11-07 | 3578.27 | 1 | SO44201 | 2021-11-14 | 286.26 | 2171.29 |
SO44226_1 | 39 | 12255 | 313 | 7 | 2021-11-24 | 89.46 | 2021-11-12 | 3578.27 | 1 | SO44226 | 2021-11-19 | 286.26 | 2171.29 |
SO44227_1 | 39 | 28401 | 349 | 7 | 2021-11-24 | 84.37 | 2021-11-12 | 3374.99 | 1 | SO44227 | 2021-11-19 | 270.00 | 1898.09 |
SO44231_1 | 39 | 17973 | 334 | 7 | 2021-11-24 | 17.48 | 2021-11-12 | 699.10 | 1 | SO44231 | 2021-11-19 | 55.93 | 413.15 |
SO44239_1 | 39 | 12217 | 311 | 7 | 2021-11-26 | 89.46 | 2021-11-14 | 3578.27 | 1 | SO44239 | 2021-11-21 | 286.26 | 2171.29 |
SO44246_1 | 39 | 12219 | 312 | 7 | 2021-11-27 | 89.46 | 2021-11-15 | 3578.27 | 1 | SO44246 | 2021-11-22 | 286.26 | 2171.29 |
SO44257_1 | 39 | 12212 | 313 | 7 | 2021-11-30 | 89.46 | 2021-11-18 | 3578.27 | 1 | SO44257 | 2021-11-25 | 286.26 | 2171.29 |
SO44272_1 | 39 | 12256 | 311 | 7 | 2021-12-03 | 89.46 | 2021-11-21 | 3578.27 | 1 | SO44272 | 2021-11-28 | 286.26 | 2171.29 |
SO44322_1 | 39 | 17975 | 328 | 7 | 2021-12-04 | 17.48 | 2021-11-22 | 699.10 | 1 | SO44322 | 2021-11-29 | 55.93 | 413.15 |
SO44324_1 | 39 | 12267 | 311 | 7 | 2021-12-05 | 89.46 | 2021-11-23 | 3578.27 | 1 | SO44324 | 2021-11-30 | 286.26 | 2171.29 |
SO44440_1 | 39 | 12261 | 312 | 7 | 2021-12-26 | 89.46 | 2021-12-14 | 3578.27 | 1 | SO44440 | 2021-12-21 | 286.26 | 2171.29 |
SO44447_1 | 39 | 12265 | 312 | 7 | 2021-12-30 | 89.46 | 2021-12-18 | 3578.27 | 1 | SO44447 | 2021-12-25 | 286.26 | 2171.29 |
SO44591_1 | 39 | 17987 | 330 | 7 | 2022-01-08 | 17.48 | 2021-12-27 | 699.10 | 1 | SO44591 | 2022-01-03 | 55.93 | 413.15 |
SO44597_1 | 39 | 12290 | 310 | 7 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44597 | 2022-01-04 | 286.26 | 2171.29 |
SO44623_1 | 39 | 12301 | 312 | 7 | 2022-01-13 | 89.46 | 2022-01-01 | 3578.27 | 1 | SO44623 | 2022-01-08 | 286.26 | 2171.29 |
SO44643_1 | 39 | 12280 | 314 | 7 | 2022-01-16 | 89.46 | 2022-01-04 | 3578.27 | 1 | SO44643 | 2022-01-11 | 286.26 | 2171.29 |
SO44644_1 | 39 | 12279 | 311 | 7 | 2022-01-16 | 89.46 | 2022-01-04 | 3578.27 | 1 | SO44644 | 2022-01-11 | 286.26 | 2171.29 |
SO44652_1 | 39 | 28407 | 350 | 7 | 2022-01-17 | 84.37 | 2022-01-05 | 3374.99 | 1 | SO44652 | 2022-01-12 | 270.00 | 1898.09 |
SO44680_1 | 39 | 12296 | 312 | 7 | 2022-01-22 | 89.46 | 2022-01-10 | 3578.27 | 1 | SO44680 | 2022-01-17 | 286.26 | 2171.29 |
SO44681_1 | 39 | 17982 | 342 | 7 | 2022-01-22 | 17.48 | 2022-01-10 | 699.10 | 1 | SO44681 | 2022-01-17 | 55.93 | 413.15 |
SO44691_1 | 39 | 28414 | 346 | 7 | 2022-01-24 | 85.00 | 2022-01-12 | 3399.99 | 1 | SO44691 | 2022-01-19 | 272.00 | 1912.15 |
SO44703_1 | 39 | 12300 | 311 | 7 | 2022-01-27 | 89.46 | 2022-01-15 | 3578.27 | 1 | SO44703 | 2022-01-22 | 286.26 | 2171.29 |
SO44729_1 | 39 | 12307 | 310 | 7 | 2022-02-01 | 89.46 | 2022-01-20 | 3578.27 | 1 | SO44729 | 2022-01-27 | 286.26 | 2171.29 |
SO44734_1 | 39 | 12285 | 313 | 7 | 2022-02-02 | 89.46 | 2022-01-21 | 3578.27 | 1 | SO44734 | 2022-01-28 | 286.26 | 2171.29 |
SO44803_1 | 39 | 12383 | 310 | 7 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44803 | 2022-01-29 | 286.26 | 2171.29 |
SO44816_1 | 39 | 12321 | 312 | 7 | 2022-02-05 | 89.46 | 2022-01-24 | 3578.27 | 1 | SO44816 | 2022-01-31 | 286.26 | 2171.29 |
SO44826_1 | 39 | 12308 | 314 | 7 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44826 | 2022-02-01 | 286.26 | 2171.29 |
SO44848_1 | 39 | 28418 | 348 | 7 | 2022-02-10 | 84.37 | 2022-01-29 | 3374.99 | 1 | SO44848 | 2022-02-05 | 270.00 | 1898.09 |
SO44849_1 | 39 | 17996 | 322 | 7 | 2022-02-10 | 17.48 | 2022-01-29 | 699.10 | 1 | SO44849 | 2022-02-05 | 55.93 | 413.15 |
SO44874_1 | 39 | 18004 | 320 | 7 | 2022-02-13 | 17.48 | 2022-02-01 | 699.10 | 1 | SO44874 | 2022-02-08 | 55.93 | 413.15 |
SO44901_1 | 39 | 12332 | 313 | 7 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44901 | 2022-02-11 | 286.26 | 2171.29 |
SO44929_1 | 39 | 12398 | 312 | 7 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44929 | 2022-02-15 | 286.26 | 2171.29 |
SO44935_1 | 39 | 12333 | 312 | 7 | 2022-02-21 | 89.46 | 2022-02-09 | 3578.27 | 1 | SO44935 | 2022-02-16 | 286.26 | 2171.29 |
SO44948_1 | 39 | 12395 | 312 | 7 | 2022-02-22 | 89.46 | 2022-02-10 | 3578.27 | 1 | SO44948 | 2022-02-17 | 286.26 | 2171.29 |
SO44987_1 | 39 | 12323 | 314 | 7 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO44987 | 2022-02-22 | 286.26 | 2171.29 |
SO44988_1 | 39 | 17999 | 338 | 7 | 2022-02-27 | 17.48 | 2022-02-15 | 699.10 | 1 | SO44988 | 2022-02-22 | 55.93 | 413.15 |
SO45006_1 | 39 | 12373 | 312 | 7 | 2022-03-02 | 89.46 | 2022-02-18 | 3578.27 | 1 | SO45006 | 2022-02-25 | 286.26 | 2171.29 |
SO45078_1 | 100 | 12494 | 313 | 7 | 2022-03-06 | 89.46 | 2022-02-22 | 3578.27 | 1 | SO45078 | 2022-03-01 | 286.26 | 2171.29 |
SO45096_1 | 100 | 12483 | 312 | 7 | 2022-03-09 | 89.46 | 2022-02-25 | 3578.27 | 1 | SO45096 | 2022-03-04 | 286.26 | 2171.29 |
SO45126_1 | 100 | 12480 | 311 | 7 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45126 | 2022-03-10 | 286.26 | 2171.29 |
SO45139_1 | 100 | 12468 | 314 | 7 | 2022-03-17 | 89.46 | 2022-03-05 | 3578.27 | 1 | SO45139 | 2022-03-12 | 286.26 | 2171.29 |
SO45140_1 | 100 | 12485 | 312 | 7 | 2022-03-17 | 89.46 | 2022-03-05 | 3578.27 | 1 | SO45140 | 2022-03-12 | 286.26 | 2171.29 |
SO55903_2 | 100 | 27851 | 214 | 7 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 2 | SO55903 | 2023-12-08 | 2.80 | 13.09 |
SO45158_1 | 100 | 28419 | 344 | 7 | 2022-03-20 | 85.00 | 2022-03-08 | 3399.99 | 1 | SO45158 | 2022-03-15 | 272.00 | 1912.15 |
SO55904_1 | 100 | 22378 | 538 | 7 | 2023-12-13 | 0.54 | 2023-12-01 | 21.49 | 1 | SO55904 | 2023-12-08 | 1.72 | 8.04 |
SO45172_1 | 100 | 18008 | 334 | 7 | 2022-03-22 | 17.48 | 2022-03-10 | 699.10 | 1 | SO45172 | 2022-03-17 | 55.93 | 413.15 |
SO55904_2 | 100 | 22378 | 225 | 7 | 2023-12-13 | 0.22 | 2023-12-01 | 8.99 | 2 | SO55904 | 2023-12-08 | 0.72 | 6.92 |
SO45205_1 | 100 | 28420 | 344 | 7 | 2022-03-27 | 85.00 | 2022-03-15 | 3399.99 | 1 | SO45205 | 2022-03-22 | 272.00 | 1912.15 |
SO55924_1 | 100 | 11587 | 363 | 7 | 2023-12-14 | 57.37 | 2023-12-02 | 2294.99 | 1 | SO55924 | 2023-12-09 | 183.60 | 1251.98 |
SO45206_1 | 100 | 12474 | 313 | 7 | 2022-03-27 | 89.46 | 2022-03-15 | 3578.27 | 1 | SO45206 | 2022-03-22 | 286.26 | 2171.29 |
SO55924_2 | 100 | 11587 | 537 | 7 | 2023-12-14 | 0.88 | 2023-12-02 | 35.00 | 2 | SO55924 | 2023-12-09 | 2.80 | 13.09 |
SO45214_1 | 100 | 12464 | 310 | 7 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO45214 | 2022-03-23 | 286.26 | 2171.29 |
SO55924_3 | 100 | 11587 | 480 | 7 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 3 | SO55924 | 2023-12-09 | 0.18 | 0.86 |
SO45234_1 | 100 | 18009 | 328 | 7 | 2022-04-01 | 17.48 | 2022-03-20 | 699.10 | 1 | SO45234 | 2022-03-27 | 55.93 | 413.15 |
SO55924_4 | 100 | 11587 | 486 | 7 | 2023-12-14 | 3.98 | 2023-12-02 | 159.00 | 4 | SO55924 | 2023-12-09 | 12.72 | 59.47 |
SO45351_1 | 100 | 12520 | 313 | 7 | 2022-04-07 | 89.46 | 2022-03-26 | 3578.27 | 1 | SO45351 | 2022-04-02 | 286.26 | 2171.29 |
SO55951_1 | 100 | 11581 | 491 | 7 | 2023-12-14 | 1.35 | 2023-12-02 | 53.99 | 1 | SO55951 | 2023-12-09 | 4.32 | 41.57 |
SO45357_1 | 100 | 28443 | 351 | 7 | 2022-04-08 | 84.37 | 2022-03-27 | 3374.99 | 1 | SO45357 | 2022-04-03 | 270.00 | 1898.09 |
SO55980_1 | 100 | 12332 | 376 | 7 | 2023-12-15 | 61.08 | 2023-12-03 | 2443.35 | 1 | SO55980 | 2023-12-10 | 195.47 | 1554.95 |
SO45366_1 | 100 | 18011 | 330 | 7 | 2022-04-09 | 17.48 | 2022-03-28 | 699.10 | 1 | SO45366 | 2022-04-04 | 55.93 | 413.15 |
SO55980_2 | 100 | 12332 | 529 | 7 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 2 | SO55980 | 2023-12-10 | 0.32 | 1.49 |
SO45372_1 | 100 | 28449 | 348 | 7 | 2022-04-10 | 84.37 | 2022-03-29 | 3374.99 | 1 | SO45372 | 2022-04-05 | 270.00 | 1898.09 |
SO55980_3 | 100 | 12332 | 540 | 7 | 2023-12-15 | 0.82 | 2023-12-03 | 32.60 | 3 | SO55980 | 2023-12-10 | 2.61 | 12.19 |
SO45380_1 | 100 | 18010 | 324 | 7 | 2022-04-11 | 17.48 | 2022-03-30 | 699.10 | 1 | SO45380 | 2022-04-06 | 55.93 | 413.15 |
SO55980_4 | 100 | 12332 | 480 | 7 | 2023-12-15 | 0.06 | 2023-12-03 | 2.29 | 4 | SO55980 | 2023-12-10 | 0.18 | 0.86 |
SO45414_1 | 100 | 18038 | 330 | 7 | 2022-04-16 | 17.48 | 2022-04-04 | 699.10 | 1 | SO45414 | 2022-04-11 | 55.93 | 413.15 |
SO55996_1 | 100 | 28379 | 540 | 7 | 2023-12-15 | 0.82 | 2023-12-03 | 32.60 | 1 | SO55996 | 2023-12-10 | 2.61 | 12.19 |
SO45433_1 | 100 | 12547 | 310 | 7 | 2022-04-19 | 89.46 | 2022-04-07 | 3578.27 | 1 | SO45433 | 2022-04-14 | 286.26 | 2171.29 |
SO55996_2 | 100 | 28379 | 529 | 7 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 2 | SO55996 | 2023-12-10 | 0.32 | 1.49 |
SO45453_1 | 100 | 12549 | 311 | 7 | 2022-04-23 | 89.46 | 2022-04-11 | 3578.27 | 1 | SO45453 | 2022-04-18 | 286.26 | 2171.29 |
SO55996_3 | 100 | 28379 | 467 | 7 | 2023-12-15 | 0.61 | 2023-12-03 | 24.49 | 3 | SO55996 | 2023-12-10 | 1.96 | 9.16 |
SO45482_1 | 100 | 12522 | 310 | 7 | 2022-04-29 | 89.46 | 2022-04-17 | 3578.27 | 1 | SO45482 | 2022-04-24 | 286.26 | 2171.29 |
SO55997_1 | 100 | 15673 | 535 | 7 | 2023-12-15 | 0.62 | 2023-12-03 | 24.99 | 1 | SO55997 | 2023-12-10 | 2.00 | 9.35 |
SO45508_1 | 100 | 12510 | 310 | 7 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45508 | 2022-04-27 | 286.26 | 2171.29 |
SO55997_2 | 100 | 15673 | 528 | 7 | 2023-12-15 | 0.12 | 2023-12-03 | 4.99 | 2 | SO55997 | 2023-12-10 | 0.40 | 1.87 |
SO45511_1 | 100 | 12523 | 311 | 7 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45511 | 2022-04-28 | 286.26 | 2171.29 |
SO55997_3 | 100 | 15673 | 222 | 7 | 2023-12-15 | 0.87 | 2023-12-03 | 34.99 | 3 | SO55997 | 2023-12-10 | 2.80 | 13.09 |
SO45586_1 | 100 | 12613 | 311 | 7 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45586 | 2022-04-30 | 286.26 | 2171.29 |
SO56015_1 | 100 | 19426 | 382 | 7 | 2023-12-15 | 28.01 | 2023-12-03 | 1120.49 | 1 | SO56015 | 2023-12-10 | 89.64 | 713.08 |
SO45602_1 | 100 | 12607 | 312 | 7 | 2022-05-07 | 89.46 | 2022-04-25 | 3578.27 | 1 | SO45602 | 2022-05-02 | 286.26 | 2171.29 |
SO56015_2 | 100 | 19426 | 222 | 7 | 2023-12-15 | 0.87 | 2023-12-03 | 34.99 | 2 | SO56015 | 2023-12-10 | 2.80 | 13.09 |
SO45615_1 | 100 | 18137 | 342 | 7 | 2022-05-09 | 17.48 | 2022-04-27 | 699.10 | 1 | SO45615 | 2022-05-04 | 55.93 | 413.15 |
SO56047_1 | 100 | 21122 | 538 | 7 | 2023-12-16 | 0.54 | 2023-12-04 | 21.49 | 1 | SO56047 | 2023-12-11 | 1.72 | 8.04 |
SO45618_1 | 100 | 12618 | 311 | 7 | 2022-05-09 | 89.46 | 2022-04-27 | 3578.27 | 1 | SO45618 | 2022-05-04 | 286.26 | 2171.29 |
SO56047_2 | 100 | 21122 | 480 | 7 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 2 | SO56047 | 2023-12-11 | 0.18 | 0.86 |
SO45622_1 | 100 | 28470 | 344 | 7 | 2022-05-10 | 85.00 | 2022-04-28 | 3399.99 | 1 | SO45622 | 2022-05-05 | 272.00 | 1912.15 |
SO56047_3 | 100 | 21122 | 483 | 7 | 2023-12-16 | 3.00 | 2023-12-04 | 120.00 | 3 | SO56047 | 2023-12-11 | 9.60 | 44.88 |
SO45627_1 | 100 | 18039 | 324 | 7 | 2022-05-10 | 17.48 | 2022-04-28 | 699.10 | 1 | SO45627 | 2022-05-05 | 55.93 | 413.15 |
SO56092_1 | 100 | 28539 | 474 | 7 | 2023-12-17 | 1.75 | 2023-12-05 | 69.99 | 1 | SO56092 | 2023-12-12 | 5.60 | 26.18 |
SO45644_1 | 100 | 28458 | 350 | 7 | 2022-05-14 | 84.37 | 2022-05-02 | 3374.99 | 1 | SO45644 | 2022-05-09 | 270.00 | 1898.09 |
SO56092_2 | 100 | 28539 | 231 | 7 | 2023-12-17 | 1.25 | 2023-12-05 | 49.99 | 2 | SO56092 | 2023-12-12 | 4.00 | 38.49 |
SO45654_1 | 100 | 28478 | 348 | 7 | 2022-05-16 | 84.37 | 2022-05-04 | 3374.99 | 1 | SO45654 | 2022-05-11 | 270.00 | 1898.09 |
SO56096_1 | 100 | 20962 | 529 | 7 | 2023-12-17 | 0.10 | 2023-12-05 | 3.99 | 1 | SO56096 | 2023-12-12 | 0.32 | 1.49 |
SO45685_1 | 100 | 18132 | 322 | 7 | 2022-05-20 | 17.48 | 2022-05-08 | 699.10 | 1 | SO45685 | 2022-05-15 | 55.93 | 413.15 |
SO56096_2 | 100 | 20962 | 480 | 7 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 2 | SO56096 | 2023-12-12 | 0.18 | 0.86 |
SO45702_1 | 100 | 18131 | 320 | 7 | 2022-05-22 | 17.48 | 2022-05-10 | 699.10 | 1 | SO45702 | 2022-05-17 | 55.93 | 413.15 |
Generated 2024-09-21 08:35:27.850 UTC