[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 89 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44334_1 | 100 | 28273 | 311 | 4 | 2022-01-27 | 89.46 | 2022-01-15 | 3578.27 | 1 | SO44334 | 2022-01-22 | 286.26 | 2171.29 | |
SO44341_1 | 100 | 25905 | 348 | 4 | 2022-01-28 | 84.37 | 2022-01-16 | 3374.99 | 1 | SO44341 | 2022-01-23 | 270.00 | 1898.09 | |
SO44345_1 | 100 | 28200 | 313 | 4 | 2022-01-29 | 89.46 | 2022-01-17 | 3578.27 | 1 | SO44345 | 2022-01-24 | 286.26 | 2171.29 | |
SO44346_1 | 100 | 14602 | 336 | 4 | 2022-01-29 | 17.48 | 2022-01-17 | 699.10 | 1 | SO44346 | 2022-01-24 | 55.93 | 413.15 | |
SO44349_1 | 100 | 28243 | 311 | 4 | 2022-01-30 | 89.46 | 2022-01-18 | 3578.27 | 1 | SO44349 | 2022-01-25 | 286.26 | 2171.29 | |
SO44350_1 | 100 | 28244 | 312 | 4 | 2022-01-30 | 89.46 | 2022-01-18 | 3578.27 | 1 | SO44350 | 2022-01-25 | 286.26 | 2171.29 | |
SO44351_1 | 100 | 28271 | 314 | 4 | 2022-01-30 | 89.46 | 2022-01-18 | 3578.27 | 1 | SO44351 | 2022-01-25 | 286.26 | 2171.29 | |
SO44353_1 | 100 | 14591 | 326 | 4 | 2022-01-30 | 17.48 | 2022-01-18 | 699.10 | 1 | SO44353 | 2022-01-25 | 55.93 | 413.15 | |
SO44354_1 | 100 | 14603 | 336 | 4 | 2022-01-30 | 17.48 | 2022-01-18 | 699.10 | 1 | SO44354 | 2022-01-25 | 55.93 | 413.15 | |
SO44362_1 | 100 | 28259 | 310 | 4 | 2022-01-31 | 89.46 | 2022-01-19 | 3578.27 | 1 | SO44362 | 2022-01-26 | 286.26 | 2171.29 | |
SO44369_1 | 100 | 28250 | 310 | 4 | 2022-02-01 | 89.46 | 2022-01-20 | 3578.27 | 1 | SO44369 | 2022-01-27 | 286.26 | 2171.29 | |
SO44377_1 | 100 | 28234 | 310 | 4 | 2022-02-02 | 89.46 | 2022-01-21 | 3578.27 | 1 | SO44377 | 2022-01-28 | 286.26 | 2171.29 | |
SO44383_1 | 100 | 28268 | 310 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44383 | 2022-01-29 | 286.26 | 2171.29 | |
SO44384_1 | 100 | 28296 | 311 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44384 | 2022-01-29 | 286.26 | 2171.29 | |
SO44385_1 | 100 | 28298 | 314 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44385 | 2022-01-29 | 286.26 | 2171.29 | |
SO44386_1 | 100 | 28587 | 312 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44386 | 2022-01-29 | 286.26 | 2171.29 | |
SO44396_1 | 100 | 25901 | 345 | 4 | 2022-02-04 | 85.00 | 2022-01-23 | 3399.99 | 1 | SO44396 | 2022-01-30 | 272.00 | 1912.15 | |
SO44397_1 | 100 | 14596 | 330 | 4 | 2022-02-04 | 17.48 | 2022-01-23 | 699.10 | 1 | SO44397 | 2022-01-30 | 55.93 | 413.15 | |
SO44400_1 | 100 | 28588 | 312 | 4 | 2022-02-05 | 89.46 | 2022-01-24 | 3578.27 | 1 | SO44400 | 2022-01-31 | 286.26 | 2171.29 | |
SO44404_1 | 100 | 28221 | 314 | 4 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44404 | 2022-02-02 | 286.26 | 2171.29 | |
SO44405_1 | 100 | 28224 | 310 | 4 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44405 | 2022-02-02 | 286.26 | 2171.29 | |
SO44406_1 | 100 | 28299 | 313 | 4 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44406 | 2022-02-02 | 286.26 | 2171.29 | |
SO44410_1 | 100 | 28223 | 310 | 4 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44410 | 2022-02-03 | 286.26 | 2171.29 | |
SO44411_1 | 100 | 28584 | 312 | 4 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44411 | 2022-02-03 | 286.26 | 2171.29 | |
SO44414_1 | 100 | 28340 | 311 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44414 | 2022-02-04 | 286.26 | 2171.29 | |
SO44415_1 | 100 | 28355 | 312 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44415 | 2022-02-04 | 286.26 | 2171.29 | |
SO44423_1 | 100 | 28586 | 313 | 4 | 2022-02-10 | 89.46 | 2022-01-29 | 3578.27 | 1 | SO44423 | 2022-02-05 | 286.26 | 2171.29 | |
SO44428_1 | 100 | 28362 | 313 | 4 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44428 | 2022-02-06 | 286.26 | 2171.29 | |
SO44434_1 | 100 | 28580 | 310 | 4 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44434 | 2022-02-07 | 286.26 | 2171.29 | |
SO44449_1 | 100 | 28293 | 312 | 4 | 2022-02-18 | 89.46 | 2022-02-06 | 3578.27 | 1 | SO44449 | 2022-02-13 | 286.26 | 2171.29 | |
SO44450_1 | 100 | 28294 | 310 | 4 | 2022-02-18 | 89.46 | 2022-02-06 | 3578.27 | 1 | SO44450 | 2022-02-13 | 286.26 | 2171.29 | |
SO44459_1 | 100 | 28288 | 314 | 4 | 2022-02-19 | 89.46 | 2022-02-07 | 3578.27 | 1 | SO44459 | 2022-02-14 | 286.26 | 2171.29 | |
SO44474_1 | 100 | 14601 | 330 | 4 | 2022-02-21 | 17.48 | 2022-02-09 | 699.10 | 1 | SO44474 | 2022-02-16 | 55.93 | 413.15 | |
SO44480_1 | 100 | 25891 | 350 | 4 | 2022-02-22 | 84.37 | 2022-02-10 | 3374.99 | 1 | SO44480 | 2022-02-17 | 270.00 | 1898.09 | |
SO44573_1 | 100 | 25917 | 347 | 4 | 2022-02-23 | 85.00 | 2022-02-11 | 3399.99 | 1 | SO44573 | 2022-02-18 | 272.00 | 1912.15 | |
SO44578_1 | 100 | 28653 | 314 | 4 | 2022-02-24 | 89.46 | 2022-02-12 | 3578.27 | 1 | SO44578 | 2022-02-19 | 286.26 | 2171.29 | |
SO44579_1 | 100 | 28662 | 312 | 4 | 2022-02-24 | 89.46 | 2022-02-12 | 3578.27 | 1 | SO44579 | 2022-02-19 | 286.26 | 2171.29 | |
SO44587_1 | 100 | 28627 | 311 | 4 | 2022-02-26 | 89.46 | 2022-02-14 | 3578.27 | 1 | SO44587 | 2022-02-21 | 286.26 | 2171.29 | |
SO44592_1 | 100 | 28761 | 314 | 4 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO44592 | 2022-02-22 | 286.26 | 2171.29 | |
SO55565_1 | 100 | 29251 | 529 | 4 | 2024-01-27 | 0.10 | 2024-01-15 | 3.99 | 1 | SO55565 | 2024-01-22 | 0.32 | 1.49 | |
SO55565_2 | 100 | 29251 | 225 | 4 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55565 | 2024-01-22 | 0.72 | 6.92 | |
SO55570_1 | 100 | 25372 | 540 | 4 | 2024-01-27 | 0.82 | 2024-01-15 | 32.60 | 1 | SO55570 | 2024-01-22 | 2.61 | 12.19 | |
SO55575_1 | 100 | 18786 | 476 | 4 | 2024-01-27 | 1.75 | 2024-01-15 | 69.99 | 1 | SO55575 | 2024-01-22 | 5.60 | 26.18 | |
SO55575_2 | 100 | 18786 | 234 | 4 | 2024-01-27 | 1.25 | 2024-01-15 | 49.99 | 2 | SO55575 | 2024-01-22 | 4.00 | 38.49 | |
SO55576_1 | 100 | 18387 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 1 | SO55576 | 2024-01-22 | 0.40 | 1.87 | |
SO55578_1 | 100 | 16003 | 528 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 1 | SO55578 | 2024-01-22 | 0.40 | 1.87 | |
SO55581_1 | 100 | 13759 | 485 | 4 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 1 | SO55581 | 2024-01-22 | 1.76 | 8.22 | |
SO55581_2 | 100 | 13759 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 2 | SO55581 | 2024-01-22 | 0.40 | 1.87 | |
SO55581_3 | 100 | 13759 | 473 | 4 | 2024-01-27 | 1.59 | 2024-01-15 | 63.50 | 3 | SO55581 | 2024-01-22 | 5.08 | 23.75 | |
SO55581_4 | 100 | 13759 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 4 | SO55581 | 2024-01-22 | 0.80 | 3.74 | |
SO55593_1 | 100 | 19129 | 593 | 4 | 2024-01-27 | 14.12 | 2024-01-15 | 564.99 | 1 | SO55593 | 2024-01-22 | 45.20 | 308.22 | |
SO55593_2 | 100 | 19129 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 2 | SO55593 | 2024-01-22 | 0.80 | 3.74 | |
SO55593_3 | 100 | 19129 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55593 | 2024-01-22 | 0.40 | 1.87 | |
SO55593_4 | 100 | 19129 | 467 | 4 | 2024-01-27 | 0.61 | 2024-01-15 | 24.49 | 4 | SO55593 | 2024-01-22 | 1.96 | 9.16 | |
SO55593_5 | 100 | 19129 | 222 | 4 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 5 | SO55593 | 2024-01-22 | 2.80 | 13.09 | |
SO55595_1 | 100 | 19121 | 594 | 4 | 2024-01-27 | 14.12 | 2024-01-15 | 564.99 | 1 | SO55595 | 2024-01-22 | 45.20 | 308.22 | |
SO55595_2 | 100 | 19121 | 485 | 4 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 2 | SO55595 | 2024-01-22 | 1.76 | 8.22 | |
SO55595_3 | 100 | 19121 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 3 | SO55595 | 2024-01-22 | 0.80 | 3.74 | |
SO55595_4 | 100 | 19121 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 4 | SO55595 | 2024-01-22 | 0.40 | 1.87 | |
SO55595_5 | 100 | 19121 | 487 | 4 | 2024-01-27 | 1.37 | 2024-01-15 | 54.99 | 5 | SO55595 | 2024-01-22 | 4.40 | 20.57 | |
SO55596_1 | 100 | 19122 | 594 | 4 | 2024-01-27 | 14.12 | 2024-01-15 | 564.99 | 1 | SO55596 | 2024-01-22 | 45.20 | 308.22 | |
SO55596_2 | 100 | 19122 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 2 | SO55596 | 2024-01-22 | 0.80 | 3.74 | |
SO55596_3 | 100 | 19122 | 225 | 4 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 3 | SO55596 | 2024-01-22 | 0.72 | 6.92 | |
SO55596_4 | 100 | 19122 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 4 | SO55596 | 2024-01-22 | 0.40 | 1.87 | |
SO55608_1 | 100 | 24784 | 564 | 4 | 2024-01-27 | 59.60 | 2024-01-15 | 2384.07 | 1 | SO55608 | 2024-01-22 | 190.73 | 1481.94 | |
SO55608_2 | 100 | 24784 | 225 | 4 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55608 | 2024-01-22 | 0.72 | 6.92 | |
SO55609_1 | 100 | 24349 | 576 | 4 | 2024-01-27 | 59.60 | 2024-01-15 | 2384.07 | 1 | SO55609 | 2024-01-22 | 190.73 | 1481.94 | |
SO55609_2 | 100 | 24349 | 217 | 4 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 2 | SO55609 | 2024-01-22 | 2.80 | 13.09 | |
SO55610_1 | 100 | 19745 | 388 | 4 | 2024-01-27 | 28.01 | 2024-01-15 | 1120.49 | 1 | SO55610 | 2024-01-22 | 89.64 | 713.08 | |
SO55610_2 | 100 | 19745 | 491 | 4 | 2024-01-27 | 1.35 | 2024-01-15 | 53.99 | 2 | SO55610 | 2024-01-22 | 4.32 | 41.57 | |
SO55628_1 | 100 | 24289 | 540 | 4 | 2024-01-28 | 0.82 | 2024-01-16 | 32.60 | 1 | SO55628 | 2024-01-23 | 2.61 | 12.19 | |
SO55630_1 | 100 | 21233 | 475 | 4 | 2024-01-28 | 1.75 | 2024-01-16 | 69.99 | 1 | SO55630 | 2024-01-23 | 5.60 | 26.18 | |
SO55630_2 | 100 | 21233 | 237 | 4 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 2 | SO55630 | 2024-01-23 | 4.00 | 38.49 | |
SO55631_1 | 100 | 20505 | 477 | 4 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55631 | 2024-01-23 | 0.40 | 1.87 | |
SO55631_2 | 100 | 20505 | 478 | 4 | 2024-01-28 | 0.25 | 2024-01-16 | 9.99 | 2 | SO55631 | 2024-01-23 | 0.80 | 3.74 | |
SO55631_3 | 100 | 20505 | 231 | 4 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 3 | SO55631 | 2024-01-23 | 4.00 | 38.49 | |
SO55634_1 | 100 | 18799 | 475 | 4 | 2024-01-28 | 1.75 | 2024-01-16 | 69.99 | 1 | SO55634 | 2024-01-23 | 5.60 | 26.18 | |
SO55634_2 | 100 | 18799 | 231 | 4 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 2 | SO55634 | 2024-01-23 | 4.00 | 38.49 | |
SO55635_1 | 100 | 15883 | 528 | 4 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55635 | 2024-01-23 | 0.40 | 1.87 | |
SO55635_2 | 100 | 15883 | 485 | 4 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 2 | SO55635 | 2024-01-23 | 1.76 | 8.22 | |
SO55635_3 | 100 | 15883 | 489 | 4 | 2024-01-28 | 1.35 | 2024-01-16 | 53.99 | 3 | SO55635 | 2024-01-23 | 4.32 | 41.57 | |
SO55635_4 | 100 | 15883 | 225 | 4 | 2024-01-28 | 0.22 | 2024-01-16 | 8.99 | 4 | SO55635 | 2024-01-23 | 0.72 | 6.92 | |
SO55640_1 | 100 | 15260 | 485 | 4 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 1 | SO55640 | 2024-01-23 | 1.76 | 8.22 | |
SO55640_2 | 100 | 15260 | 478 | 4 | 2024-01-28 | 0.25 | 2024-01-16 | 9.99 | 2 | SO55640 | 2024-01-23 | 0.80 | 3.74 | |
SO55640_3 | 100 | 15260 | 477 | 4 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 3 | SO55640 | 2024-01-23 | 0.40 | 1.87 | |
SO55640_4 | 100 | 15260 | 225 | 4 | 2024-01-28 | 0.22 | 2024-01-16 | 8.99 | 4 | SO55640 | 2024-01-23 | 0.72 | 6.92 | |
SO55659_1 | 100 | 16372 | 374 | 4 | 2024-01-28 | 61.08 | 2024-01-16 | 2443.35 | 1 | SO55659 | 2024-01-23 | 195.47 | 1554.95 | |
SO55659_2 | 100 | 16372 | 529 | 4 | 2024-01-28 | 0.10 | 2024-01-16 | 3.99 | 2 | SO55659 | 2024-01-23 | 0.32 | 1.49 | |
SO55659_3 | 100 | 16372 | 540 | 4 | 2024-01-28 | 0.82 | 2024-01-16 | 32.60 | 3 | SO55659 | 2024-01-23 | 2.61 | 12.19 | |
SO55659_4 | 100 | 16372 | 480 | 4 | 2024-01-28 | 0.06 | 2024-01-16 | 2.29 | 4 | SO55659 | 2024-01-23 | 0.18 | 0.86 | |
SO55662_1 | 100 | 12926 | 353 | 4 | 2024-01-28 | 58.00 | 2024-01-16 | 2319.99 | 1 | SO55662 | 2024-01-23 | 185.60 | 1265.62 | |
SO55662_2 | 100 | 12926 | 485 | 4 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 2 | SO55662 | 2024-01-23 | 1.76 | 8.22 | |
SO55662_3 | 100 | 12926 | 478 | 4 | 2024-01-28 | 0.25 | 2024-01-16 | 9.99 | 3 | SO55662 | 2024-01-23 | 0.80 | 3.74 | |
SO55673_1 | 100 | 25025 | 562 | 4 | 2024-01-28 | 59.60 | 2024-01-16 | 2384.07 | 1 | SO55673 | 2024-01-23 | 190.73 | 1481.94 | |
SO55673_2 | 100 | 25025 | 214 | 4 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 2 | SO55673 | 2024-01-23 | 2.80 | 13.09 | |
SO55673_3 | 100 | 25025 | 237 | 2 | 4 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 3 | SO55673 | 2024-01-23 | 4.00 | 38.49 |
Generated 2024-11-10 17:16:20.355 UTC