[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1385 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46462_1 | 6 | 12013 | 345 | 9 | 2022-08-14 | 85.00 | 2022-08-02 | 3399.99 | 1 | SO46462 | 2022-08-09 | 272.00 | 1912.15 |
SO46472_1 | 6 | 12248 | 344 | 9 | 2022-08-15 | 85.00 | 2022-08-03 | 3399.99 | 1 | SO46472 | 2022-08-10 | 272.00 | 1912.15 |
SO46474_1 | 6 | 25944 | 342 | 9 | 2022-08-15 | 17.48 | 2022-08-03 | 699.10 | 1 | SO46474 | 2022-08-10 | 55.93 | 413.15 |
SO46477_1 | 6 | 12009 | 346 | 9 | 2022-08-16 | 85.00 | 2022-08-04 | 3399.99 | 1 | SO46477 | 2022-08-11 | 272.00 | 1912.15 |
SO46478_1 | 6 | 25939 | 326 | 9 | 2022-08-16 | 17.48 | 2022-08-04 | 699.10 | 1 | SO46478 | 2022-08-11 | 55.93 | 413.15 |
SO46481_1 | 6 | 20623 | 313 | 9 | 2022-08-17 | 89.46 | 2022-08-05 | 3578.27 | 1 | SO46481 | 2022-08-12 | 286.26 | 2171.29 |
SO46482_1 | 6 | 12245 | 346 | 9 | 2022-08-17 | 85.00 | 2022-08-05 | 3399.99 | 1 | SO46482 | 2022-08-12 | 272.00 | 1912.15 |
SO46488_1 | 6 | 20628 | 312 | 9 | 2022-08-18 | 89.46 | 2022-08-06 | 3578.27 | 1 | SO46488 | 2022-08-13 | 286.26 | 2171.29 |
SO46494_1 | 6 | 20983 | 313 | 9 | 2022-08-20 | 89.46 | 2022-08-08 | 3578.27 | 1 | SO46494 | 2022-08-15 | 286.26 | 2171.29 |
SO46495_1 | 6 | 20989 | 311 | 9 | 2022-08-20 | 89.46 | 2022-08-08 | 3578.27 | 1 | SO46495 | 2022-08-15 | 286.26 | 2171.29 |
SO46496_1 | 6 | 20627 | 312 | 9 | 2022-08-20 | 89.46 | 2022-08-08 | 3578.27 | 1 | SO46496 | 2022-08-15 | 286.26 | 2171.29 |
SO46505_1 | 6 | 12241 | 347 | 9 | 2022-08-21 | 85.00 | 2022-08-09 | 3399.99 | 1 | SO46505 | 2022-08-16 | 272.00 | 1912.15 |
SO46506_1 | 6 | 12242 | 349 | 9 | 2022-08-21 | 84.37 | 2022-08-09 | 3374.99 | 1 | SO46506 | 2022-08-16 | 270.00 | 1898.09 |
SO46507_1 | 6 | 25941 | 320 | 9 | 2022-08-21 | 17.48 | 2022-08-09 | 699.10 | 1 | SO46507 | 2022-08-16 | 55.93 | 413.15 |
SO46517_1 | 6 | 20624 | 313 | 9 | 2022-08-22 | 89.46 | 2022-08-10 | 3578.27 | 1 | SO46517 | 2022-08-17 | 286.26 | 2171.29 |
SO46518_1 | 6 | 20814 | 314 | 9 | 2022-08-22 | 89.46 | 2022-08-10 | 3578.27 | 1 | SO46518 | 2022-08-17 | 286.26 | 2171.29 |
SO46525_1 | 6 | 20816 | 314 | 9 | 2022-08-23 | 89.46 | 2022-08-11 | 3578.27 | 1 | SO46525 | 2022-08-18 | 286.26 | 2171.29 |
SO46526_1 | 6 | 12253 | 347 | 9 | 2022-08-23 | 85.00 | 2022-08-11 | 3399.99 | 1 | SO46526 | 2022-08-18 | 272.00 | 1912.15 |
SO46527_1 | 6 | 25940 | 334 | 9 | 2022-08-23 | 17.48 | 2022-08-11 | 699.10 | 1 | SO46527 | 2022-08-18 | 55.93 | 413.15 |
SO46534_1 | 6 | 20620 | 312 | 9 | 2022-08-24 | 89.46 | 2022-08-12 | 3578.27 | 1 | SO46534 | 2022-08-19 | 286.26 | 2171.29 |
SO46535_1 | 6 | 20815 | 310 | 9 | 2022-08-24 | 89.46 | 2022-08-12 | 3578.27 | 1 | SO46535 | 2022-08-19 | 286.26 | 2171.29 |
SO46540_1 | 6 | 20822 | 314 | 9 | 2022-08-25 | 89.46 | 2022-08-13 | 3578.27 | 1 | SO46540 | 2022-08-20 | 286.26 | 2171.29 |
SO46541_1 | 6 | 20617 | 310 | 9 | 2022-08-25 | 89.46 | 2022-08-13 | 3578.27 | 1 | SO46541 | 2022-08-20 | 286.26 | 2171.29 |
SO56750_1 | 6 | 18928 | 378 | 9 | 2023-12-29 | 61.08 | 2023-12-17 | 2443.35 | 1 | SO56750 | 2023-12-24 | 195.47 | 1554.95 |
SO56750_2 | 6 | 18928 | 479 | 9 | 2023-12-29 | 0.22 | 2023-12-17 | 8.99 | 2 | SO56750 | 2023-12-24 | 0.72 | 3.36 |
SO56750_3 | 6 | 18928 | 477 | 9 | 2023-12-29 | 0.12 | 2023-12-17 | 4.99 | 3 | SO56750 | 2023-12-24 | 0.40 | 1.87 |
SO56750_4 | 6 | 18928 | 214 | 9 | 2023-12-29 | 0.87 | 2023-12-17 | 34.99 | 4 | SO56750 | 2023-12-24 | 2.80 | 13.09 |
SO56750_5 | 6 | 18928 | 463 | 9 | 2023-12-29 | 0.61 | 2023-12-17 | 24.49 | 5 | SO56750 | 2023-12-24 | 1.96 | 9.16 |
SO56751_1 | 6 | 12677 | 361 | 9 | 2023-12-29 | 57.37 | 2023-12-17 | 2294.99 | 1 | SO56751 | 2023-12-24 | 183.60 | 1251.98 |
SO56752_1 | 6 | 11994 | 355 | 9 | 2023-12-29 | 58.00 | 2023-12-17 | 2319.99 | 1 | SO56752 | 2023-12-24 | 185.60 | 1265.62 |
SO56752_2 | 6 | 11994 | 487 | 9 | 2023-12-29 | 1.37 | 2023-12-17 | 54.99 | 2 | SO56752 | 2023-12-24 | 4.40 | 20.57 |
SO56757_1 | 6 | 24909 | 388 | 9 | 2023-12-30 | 28.01 | 2023-12-18 | 1120.49 | 1 | SO56757 | 2023-12-25 | 89.64 | 713.08 |
SO56757_2 | 6 | 24909 | 539 | 9 | 2023-12-30 | 0.62 | 2023-12-18 | 24.99 | 2 | SO56757 | 2023-12-25 | 2.00 | 9.35 |
SO56757_3 | 6 | 24909 | 529 | 9 | 2023-12-30 | 0.10 | 2023-12-18 | 3.99 | 3 | SO56757 | 2023-12-25 | 0.32 | 1.49 |
SO56760_1 | 6 | 20605 | 529 | 9 | 2023-12-30 | 0.10 | 2023-12-18 | 3.99 | 1 | SO56760 | 2023-12-25 | 0.32 | 1.49 |
SO56760_2 | 6 | 20605 | 538 | 9 | 2023-12-30 | 0.54 | 2023-12-18 | 21.49 | 2 | SO56760 | 2023-12-25 | 1.72 | 8.04 |
SO56760_3 | 6 | 20605 | 217 | 9 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 3 | SO56760 | 2023-12-25 | 2.80 | 13.09 |
SO56760_4 | 6 | 20605 | 463 | 9 | 2023-12-30 | 0.61 | 2023-12-18 | 24.49 | 4 | SO56760 | 2023-12-25 | 1.96 | 9.16 |
SO56761_1 | 6 | 25217 | 528 | 9 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 1 | SO56761 | 2023-12-25 | 0.40 | 1.87 |
SO56761_2 | 6 | 25217 | 222 | 9 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 2 | SO56761 | 2023-12-25 | 2.80 | 13.09 |
SO56762_1 | 6 | 29301 | 478 | 9 | 2023-12-30 | 0.25 | 2023-12-18 | 9.99 | 1 | SO56762 | 2023-12-25 | 0.80 | 3.74 |
SO56762_2 | 6 | 29301 | 477 | 9 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 2 | SO56762 | 2023-12-25 | 0.40 | 1.87 |
SO56762_3 | 6 | 29301 | 483 | 9 | 2023-12-30 | 3.00 | 2023-12-18 | 120.00 | 3 | SO56762 | 2023-12-25 | 9.60 | 44.88 |
SO56785_1 | 6 | 16708 | 587 | 9 | 2023-12-30 | 19.24 | 2023-12-18 | 769.49 | 1 | SO56785 | 2023-12-25 | 61.56 | 419.78 |
SO56785_2 | 6 | 16708 | 477 | 9 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 2 | SO56785 | 2023-12-25 | 0.40 | 1.87 |
SO56785_3 | 6 | 16708 | 489 | 9 | 2023-12-30 | 1.35 | 2023-12-18 | 53.99 | 3 | SO56785 | 2023-12-25 | 4.32 | 41.57 |
SO56786_1 | 6 | 19596 | 374 | 9 | 2023-12-30 | 61.08 | 2023-12-18 | 2443.35 | 1 | SO56786 | 2023-12-25 | 195.47 | 1554.95 |
SO56786_2 | 6 | 19596 | 217 | 9 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 2 | SO56786 | 2023-12-25 | 2.80 | 13.09 |
SO56787_1 | 6 | 19096 | 378 | 9 | 2023-12-30 | 61.08 | 2023-12-18 | 2443.35 | 1 | SO56787 | 2023-12-25 | 195.47 | 1554.95 |
SO56787_2 | 6 | 19096 | 479 | 9 | 2023-12-30 | 0.22 | 2023-12-18 | 8.99 | 2 | SO56787 | 2023-12-25 | 0.72 | 3.36 |
SO56787_3 | 6 | 19096 | 477 | 9 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 3 | SO56787 | 2023-12-25 | 0.40 | 1.87 |
SO56787_4 | 6 | 19096 | 487 | 9 | 2023-12-30 | 1.37 | 2023-12-18 | 54.99 | 4 | SO56787 | 2023-12-25 | 4.40 | 20.57 |
SO56788_1 | 6 | 12009 | 363 | 9 | 2023-12-30 | 57.37 | 2023-12-18 | 2294.99 | 1 | SO56788 | 2023-12-25 | 183.60 | 1251.98 |
SO56788_2 | 6 | 12009 | 485 | 9 | 2023-12-30 | 0.55 | 2023-12-18 | 21.98 | 2 | SO56788 | 2023-12-25 | 1.76 | 8.22 |
SO56788_3 | 6 | 12009 | 217 | 9 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 3 | SO56788 | 2023-12-25 | 2.80 | 13.09 |
SO56788_4 | 6 | 12009 | 463 | 9 | 2023-12-30 | 0.61 | 2023-12-18 | 24.49 | 4 | SO56788 | 2023-12-25 | 1.96 | 9.16 |
SO56789_1 | 6 | 12338 | 363 | 9 | 2023-12-30 | 57.37 | 2023-12-18 | 2294.99 | 1 | SO56789 | 2023-12-25 | 183.60 | 1251.98 |
SO56789_2 | 6 | 12338 | 485 | 9 | 2023-12-30 | 0.55 | 2023-12-18 | 21.98 | 2 | SO56789 | 2023-12-25 | 1.76 | 8.22 |
SO56789_3 | 6 | 12338 | 483 | 9 | 2023-12-30 | 3.00 | 2023-12-18 | 120.00 | 3 | SO56789 | 2023-12-25 | 9.60 | 44.88 |
SO56796_1 | 6 | 23541 | 382 | 9 | 2023-12-31 | 28.01 | 2023-12-19 | 1120.49 | 1 | SO56796 | 2023-12-26 | 89.64 | 713.08 |
SO56796_2 | 6 | 23541 | 222 | 9 | 2023-12-31 | 0.87 | 2023-12-19 | 34.99 | 2 | SO56796 | 2023-12-26 | 2.80 | 13.09 |
SO56799_1 | 6 | 16674 | 536 | 9 | 2023-12-31 | 0.75 | 2023-12-19 | 29.99 | 1 | SO56799 | 2023-12-26 | 2.40 | 11.22 |
SO56799_2 | 6 | 16674 | 528 | 9 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56799 | 2023-12-26 | 0.40 | 1.87 |
SO56799_3 | 6 | 16674 | 480 | 9 | 2023-12-31 | 0.06 | 2023-12-19 | 2.29 | 3 | SO56799 | 2023-12-26 | 0.18 | 0.86 |
SO56800_1 | 6 | 21186 | 537 | 9 | 2023-12-31 | 0.88 | 2023-12-19 | 35.00 | 1 | SO56800 | 2023-12-26 | 2.80 | 13.09 |
SO56801_1 | 6 | 17318 | 536 | 9 | 2023-12-31 | 0.75 | 2023-12-19 | 29.99 | 1 | SO56801 | 2023-12-26 | 2.40 | 11.22 |
SO56801_2 | 6 | 17318 | 528 | 9 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56801 | 2023-12-26 | 0.40 | 1.87 |
SO56802_1 | 6 | 13614 | 474 | 9 | 2023-12-31 | 1.75 | 2023-12-19 | 69.99 | 1 | SO56802 | 2023-12-26 | 5.60 | 26.18 |
SO56802_2 | 6 | 13614 | 482 | 9 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 2 | SO56802 | 2023-12-26 | 0.72 | 3.36 |
SO56803_1 | 6 | 26432 | 475 | 9 | 2023-12-31 | 1.75 | 2023-12-19 | 69.99 | 1 | SO56803 | 2023-12-26 | 5.60 | 26.18 |
SO56803_2 | 6 | 26432 | 490 | 9 | 2023-12-31 | 1.35 | 2023-12-19 | 53.99 | 2 | SO56803 | 2023-12-26 | 4.32 | 41.57 |
SO56804_1 | 6 | 15787 | 478 | 9 | 2023-12-31 | 0.25 | 2023-12-19 | 9.99 | 1 | SO56804 | 2023-12-26 | 0.80 | 3.74 |
SO56804_2 | 6 | 15787 | 477 | 9 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56804 | 2023-12-26 | 0.40 | 1.87 |
SO56804_3 | 6 | 15787 | 222 | 9 | 2023-12-31 | 0.87 | 2023-12-19 | 34.99 | 3 | SO56804 | 2023-12-26 | 2.80 | 13.09 |
SO56804_4 | 6 | 15787 | 491 | 9 | 2023-12-31 | 1.35 | 2023-12-19 | 53.99 | 4 | SO56804 | 2023-12-26 | 4.32 | 41.57 |
SO56805_1 | 6 | 19627 | 479 | 9 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 1 | SO56805 | 2023-12-26 | 0.72 | 3.36 |
SO56805_2 | 6 | 19627 | 477 | 9 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56805 | 2023-12-26 | 0.40 | 1.87 |
SO56839_1 | 6 | 23116 | 583 | 9 | 2023-12-31 | 42.52 | 2023-12-19 | 1700.99 | 1 | SO56839 | 2023-12-26 | 136.08 | 1082.51 |
SO56839_2 | 6 | 23116 | 489 | 9 | 2023-12-31 | 1.35 | 2023-12-19 | 53.99 | 2 | SO56839 | 2023-12-26 | 4.32 | 41.57 |
SO56840_1 | 6 | 20983 | 605 | 9 | 2023-12-31 | 13.50 | 2023-12-19 | 539.99 | 1 | SO56840 | 2023-12-26 | 43.20 | 343.65 |
SO56840_2 | 6 | 20983 | 538 | 9 | 2023-12-31 | 0.54 | 2023-12-19 | 21.49 | 2 | SO56840 | 2023-12-26 | 1.72 | 8.04 |
SO56840_3 | 6 | 20983 | 529 | 9 | 2023-12-31 | 0.10 | 2023-12-19 | 3.99 | 3 | SO56840 | 2023-12-26 | 0.32 | 1.49 |
SO56840_4 | 6 | 20983 | 214 | 9 | 2023-12-31 | 0.87 | 2023-12-19 | 34.99 | 4 | SO56840 | 2023-12-26 | 2.80 | 13.09 |
SO56841_1 | 6 | 28205 | 584 | 9 | 2023-12-31 | 13.50 | 2023-12-19 | 539.99 | 1 | SO56841 | 2023-12-26 | 43.20 | 343.65 |
SO56841_2 | 6 | 28205 | 473 | 9 | 2023-12-31 | 1.59 | 2023-12-19 | 63.50 | 2 | SO56841 | 2023-12-26 | 5.08 | 23.75 |
SO56842_1 | 6 | 19105 | 380 | 9 | 2023-12-31 | 61.08 | 2023-12-19 | 2443.35 | 1 | SO56842 | 2023-12-26 | 195.47 | 1554.95 |
SO56842_2 | 6 | 19105 | 214 | 9 | 2023-12-31 | 0.87 | 2023-12-19 | 34.99 | 2 | SO56842 | 2023-12-26 | 2.80 | 13.09 |
SO56843_1 | 6 | 19568 | 372 | 9 | 2023-12-31 | 61.08 | 2023-12-19 | 2443.35 | 1 | SO56843 | 2023-12-26 | 195.47 | 1554.95 |
SO56843_2 | 6 | 19568 | 540 | 9 | 2023-12-31 | 0.82 | 2023-12-19 | 32.60 | 2 | SO56843 | 2023-12-26 | 2.61 | 12.19 |
SO56843_3 | 6 | 19568 | 529 | 9 | 2023-12-31 | 0.10 | 2023-12-19 | 3.99 | 3 | SO56843 | 2023-12-26 | 0.32 | 1.49 |
SO56843_4 | 6 | 19568 | 480 | 9 | 2023-12-31 | 0.06 | 2023-12-19 | 2.29 | 4 | SO56843 | 2023-12-26 | 0.18 | 0.86 |
SO56844_1 | 6 | 19577 | 376 | 9 | 2023-12-31 | 61.08 | 2023-12-19 | 2443.35 | 1 | SO56844 | 2023-12-26 | 195.47 | 1554.95 |
SO56844_2 | 6 | 19577 | 477 | 9 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56844 | 2023-12-26 | 0.40 | 1.87 |
SO56844_3 | 6 | 19577 | 479 | 9 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 3 | SO56844 | 2023-12-26 | 0.72 | 3.36 |
SO56844_4 | 6 | 19577 | 480 | 9 | 2023-12-31 | 0.06 | 2023-12-19 | 2.29 | 4 | SO56844 | 2023-12-26 | 0.18 | 0.86 |
SO56851_1 | 6 | 21363 | 528 | 9 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56851 | 2023-12-27 | 0.40 | 1.87 |
Generated 2024-09-21 05:21:32.352 UTC