[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1440 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45392_1 | 6 | 11762 | 344 | 9 | 2022-04-11 | 85.00 | 2022-03-30 | 3399.99 | 1 | SO45392 | 2022-04-06 | 272.00 | 1912.15 | |
SO45393_1 | 100 | 14171 | 312 | 8 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO45393 | 2022-04-07 | 286.26 | 2171.29 | |
SO45394_1 | 98 | 11468 | 348 | 10 | 2022-04-12 | 84.37 | 2022-03-31 | 3374.99 | 1 | SO45394 | 2022-04-07 | 270.00 | 1898.09 | |
SO45395_1 | 100 | 29352 | 313 | 4 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO45395 | 2022-04-07 | 286.26 | 2171.29 | |
SO45396_1 | 6 | 19594 | 312 | 9 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO45396 | 2022-04-07 | 286.26 | 2171.29 | |
SO45397_1 | 98 | 15051 | 313 | 10 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO45397 | 2022-04-08 | 286.26 | 2171.29 | |
SO45398_1 | 98 | 15059 | 312 | 10 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO45398 | 2022-04-08 | 286.26 | 2171.29 | |
SO45399_1 | 6 | 19598 | 311 | 9 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO45399 | 2022-04-08 | 286.26 | 2171.29 | |
SO45400_1 | 100 | 14162 | 313 | 8 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45400 | 2022-04-09 | 286.26 | 2171.29 | |
SO45401_1 | 98 | 15058 | 310 | 10 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45401 | 2022-04-09 | 286.26 | 2171.29 | |
SO45402_1 | 98 | 11413 | 344 | 10 | 2022-04-14 | 85.00 | 2022-04-02 | 3399.99 | 1 | SO45402 | 2022-04-09 | 272.00 | 1912.15 | |
SO45403_1 | 19 | 23114 | 314 | 6 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45403 | 2022-04-09 | 286.26 | 2171.29 | |
SO45404_1 | 100 | 11217 | 310 | 1 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45404 | 2022-04-09 | 286.26 | 2171.29 | |
SO45405_1 | 19 | 23209 | 312 | 6 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45405 | 2022-04-09 | 286.26 | 2171.29 | |
SO45406_1 | 100 | 25987 | 351 | 4 | 2022-04-14 | 84.37 | 2022-04-02 | 3374.99 | 1 | SO45406 | 2022-04-09 | 270.00 | 1898.09 | |
SO45407_1 | 100 | 29285 | 314 | 4 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45407 | 2022-04-09 | 286.26 | 2171.29 | |
SO45408_1 | 100 | 29326 | 314 | 4 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45408 | 2022-04-09 | 286.26 | 2171.29 | |
SO45409_1 | 6 | 19612 | 312 | 9 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45409 | 2022-04-09 | 286.26 | 2171.29 | |
SO45410_1 | 100 | 14149 | 310 | 8 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45410 | 2022-04-10 | 286.26 | 2171.29 | |
SO45411_1 | 100 | 28197 | 313 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45411 | 2022-04-10 | 286.26 | 2171.29 | |
SO45412_1 | 19 | 23137 | 310 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45412 | 2022-04-10 | 286.26 | 2171.29 | |
SO45413_1 | 100 | 11191 | 312 | 4 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45413 | 2022-04-10 | 286.26 | 2171.29 | |
SO45414_1 | 100 | 18038 | 330 | 7 | 2022-04-15 | 17.48 | 2022-04-03 | 699.10 | 1 | SO45414 | 2022-04-10 | 55.93 | 413.15 | |
SO45415_1 | 100 | 28092 | 312 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45415 | 2022-04-10 | 286.26 | 2171.29 | |
SO45416_1 | 100 | 28161 | 310 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45416 | 2022-04-10 | 286.26 | 2171.29 | |
SO45417_1 | 100 | 28620 | 310 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45417 | 2022-04-10 | 286.26 | 2171.29 | |
SO45418_1 | 6 | 19264 | 311 | 9 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45418 | 2022-04-10 | 286.26 | 2171.29 | |
SO45419_1 | 6 | 19555 | 314 | 9 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45419 | 2022-04-10 | 286.26 | 2171.29 | |
SO45420_1 | 6 | 19561 | 313 | 9 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45420 | 2022-04-10 | 286.26 | 2171.29 | |
SO45421_1 | 6 | 19576 | 313 | 9 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45421 | 2022-04-10 | 286.26 | 2171.29 | |
SO45422_1 | 100 | 28198 | 310 | 6 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO45422 | 2022-04-11 | 286.26 | 2171.29 | |
SO45423_1 | 19 | 19997 | 348 | 6 | 2022-04-16 | 84.37 | 2022-04-04 | 3374.99 | 1 | SO45423 | 2022-04-11 | 270.00 | 1898.09 | |
SO55634_2 | 100 | 18799 | 231 | 4 | 2023-12-08 | 1.25 | 2023-11-26 | 49.99 | 2 | SO55634 | 2023-12-03 | 4.00 | 38.49 | |
SO55635_1 | 100 | 15883 | 528 | 4 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55635 | 2023-12-03 | 0.40 | 1.87 | |
SO55635_2 | 100 | 15883 | 485 | 4 | 2023-12-08 | 0.55 | 2023-11-26 | 21.98 | 2 | SO55635 | 2023-12-03 | 1.76 | 8.22 | |
SO55635_3 | 100 | 15883 | 489 | 4 | 2023-12-08 | 1.35 | 2023-11-26 | 53.99 | 3 | SO55635 | 2023-12-03 | 4.32 | 41.57 | |
SO55635_4 | 100 | 15883 | 225 | 4 | 2023-12-08 | 0.22 | 2023-11-26 | 8.99 | 4 | SO55635 | 2023-12-03 | 0.72 | 6.92 | |
SO55636_1 | 100 | 15384 | 528 | 1 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55636 | 2023-12-03 | 0.40 | 1.87 | |
SO55636_2 | 100 | 15384 | 480 | 2 | 1 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 2 | SO55636 | 2023-12-03 | 0.18 | 0.86 |
SO55637_1 | 100 | 17342 | 528 | 1 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55637 | 2023-12-03 | 0.40 | 1.87 | |
SO55637_2 | 100 | 17342 | 222 | 1 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 2 | SO55637 | 2023-12-03 | 2.80 | 13.09 | |
SO55638_1 | 19 | 23498 | 528 | 6 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55638 | 2023-12-03 | 0.40 | 1.87 | |
SO55639_1 | 19 | 19645 | 528 | 6 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55639 | 2023-12-03 | 0.40 | 1.87 | |
SO55639_2 | 19 | 19645 | 217 | 6 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 2 | SO55639 | 2023-12-03 | 2.80 | 13.09 | |
SO55640_1 | 100 | 15260 | 485 | 4 | 2023-12-08 | 0.55 | 2023-11-26 | 21.98 | 1 | SO55640 | 2023-12-03 | 1.76 | 8.22 | |
SO55640_2 | 100 | 15260 | 478 | 4 | 2023-12-08 | 0.25 | 2023-11-26 | 9.99 | 2 | SO55640 | 2023-12-03 | 0.80 | 3.74 | |
SO55640_3 | 100 | 15260 | 477 | 4 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 3 | SO55640 | 2023-12-03 | 0.40 | 1.87 | |
SO55640_4 | 100 | 15260 | 225 | 4 | 2023-12-08 | 0.22 | 2023-11-26 | 8.99 | 4 | SO55640 | 2023-12-03 | 0.72 | 6.92 | |
SO55641_1 | 100 | 16396 | 535 | 8 | 2023-12-08 | 0.62 | 2023-11-26 | 24.99 | 1 | SO55641 | 2023-12-03 | 2.00 | 9.35 | |
SO55641_2 | 100 | 16396 | 528 | 8 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO55641 | 2023-12-03 | 0.40 | 1.87 | |
SO55641_3 | 100 | 16396 | 480 | 2 | 8 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 3 | SO55641 | 2023-12-03 | 0.18 | 0.86 |
SO55642_1 | 98 | 16459 | 528 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55642 | 2023-12-03 | 0.40 | 1.87 | |
SO55642_2 | 98 | 16459 | 222 | 10 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 2 | SO55642 | 2023-12-03 | 2.80 | 13.09 | |
SO55643_1 | 19 | 21471 | 485 | 6 | 2023-12-08 | 0.55 | 2023-11-26 | 21.98 | 1 | SO55643 | 2023-12-03 | 1.76 | 8.22 | |
SO55643_2 | 19 | 21471 | 478 | 6 | 2023-12-08 | 0.25 | 2023-11-26 | 9.99 | 2 | SO55643 | 2023-12-03 | 0.80 | 3.74 | |
SO55644_1 | 98 | 20868 | 536 | 10 | 2023-12-08 | 0.75 | 2023-11-26 | 29.99 | 1 | SO55644 | 2023-12-03 | 2.40 | 11.22 | |
SO55644_2 | 98 | 20868 | 528 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO55644 | 2023-12-03 | 0.40 | 1.87 | |
SO55644_3 | 98 | 20868 | 480 | 10 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 3 | SO55644 | 2023-12-03 | 0.18 | 0.86 | |
SO55645_1 | 100 | 11490 | 488 | 7 | 2023-12-08 | 1.35 | 2023-11-26 | 53.99 | 1 | SO55645 | 2023-12-03 | 4.32 | 41.57 | |
SO55646_1 | 100 | 17704 | 535 | 8 | 2023-12-08 | 0.62 | 2023-11-26 | 24.99 | 1 | SO55646 | 2023-12-03 | 2.00 | 9.35 | |
SO55646_2 | 100 | 17704 | 528 | 8 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO55646 | 2023-12-03 | 0.40 | 1.87 | |
SO55646_3 | 100 | 17704 | 480 | 2 | 8 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 3 | SO55646 | 2023-12-03 | 0.18 | 0.86 |
SO45424_1 | 100 | 28165 | 311 | 6 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO45424 | 2022-04-11 | 286.26 | 2171.29 | |
SO55647_1 | 100 | 19490 | 529 | 7 | 2023-12-08 | 0.10 | 2023-11-26 | 3.99 | 1 | SO55647 | 2023-12-03 | 0.32 | 1.49 | |
SO45425_1 | 98 | 15056 | 310 | 10 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45425 | 2022-04-12 | 286.26 | 2171.29 | |
SO55647_2 | 100 | 19490 | 237 | 7 | 2023-12-08 | 1.25 | 2023-11-26 | 49.99 | 2 | SO55647 | 2023-12-03 | 4.00 | 38.49 | |
SO45426_1 | 100 | 14164 | 312 | 8 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45426 | 2022-04-12 | 286.26 | 2171.29 | |
SO55647_3 | 100 | 19490 | 481 | 7 | 2023-12-08 | 0.22 | 2023-11-26 | 8.99 | 3 | SO55647 | 2023-12-03 | 0.72 | 3.36 | |
SO45427_1 | 100 | 29481 | 349 | 8 | 2022-04-17 | 84.37 | 2022-04-05 | 3374.99 | 1 | SO45427 | 2022-04-12 | 270.00 | 1898.09 | |
SO55648_1 | 98 | 24703 | 477 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55648 | 2023-12-03 | 0.40 | 1.87 | |
SO45428_1 | 98 | 11414 | 346 | 10 | 2022-04-17 | 85.00 | 2022-04-05 | 3399.99 | 1 | SO45428 | 2022-04-12 | 272.00 | 1912.15 | |
SO55649_1 | 98 | 21739 | 536 | 10 | 2023-12-08 | 0.75 | 2023-11-26 | 29.99 | 1 | SO55649 | 2023-12-03 | 2.40 | 11.22 | |
SO45429_1 | 100 | 28129 | 310 | 6 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45429 | 2022-04-12 | 286.26 | 2171.29 | |
SO55649_2 | 98 | 21739 | 528 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO55649 | 2023-12-03 | 0.40 | 1.87 | |
SO45430_1 | 100 | 28176 | 312 | 6 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45430 | 2022-04-12 | 286.26 | 2171.29 | |
SO55649_3 | 98 | 21739 | 480 | 10 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 3 | SO55649 | 2023-12-03 | 0.18 | 0.86 | |
SO45431_1 | 100 | 28013 | 311 | 6 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45431 | 2022-04-12 | 286.26 | 2171.29 | |
SO55650_1 | 98 | 14184 | 541 | 10 | 2023-12-08 | 0.72 | 2023-11-26 | 28.99 | 1 | SO55650 | 2023-12-03 | 2.32 | 10.84 | |
SO45432_1 | 100 | 14167 | 312 | 8 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45432 | 2022-04-13 | 286.26 | 2171.29 | |
SO55650_2 | 98 | 14184 | 530 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO55650 | 2023-12-03 | 0.40 | 1.87 | |
SO45433_1 | 100 | 12547 | 310 | 7 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45433 | 2022-04-13 | 286.26 | 2171.29 | |
SO55650_3 | 98 | 14184 | 480 | 2 | 10 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 3 | SO55650 | 2023-12-03 | 0.18 | 0.86 |
SO45434_1 | 100 | 11252 | 311 | 4 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45434 | 2022-04-13 | 286.26 | 2171.29 | |
SO55651_1 | 98 | 14423 | 541 | 10 | 2023-12-08 | 0.72 | 2023-11-26 | 28.99 | 1 | SO55651 | 2023-12-03 | 2.32 | 10.84 | |
SO45435_1 | 98 | 20562 | 336 | 10 | 2022-04-18 | 17.48 | 2022-04-06 | 699.10 | 1 | SO45435 | 2022-04-13 | 55.93 | 413.15 | |
SO55651_2 | 98 | 14423 | 530 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO55651 | 2023-12-03 | 0.40 | 1.87 | |
SO45436_1 | 100 | 28130 | 312 | 6 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45436 | 2022-04-13 | 286.26 | 2171.29 | |
SO55651_3 | 98 | 14423 | 479 | 10 | 2023-12-08 | 0.22 | 2023-11-26 | 8.99 | 3 | SO55651 | 2023-12-03 | 0.72 | 3.36 | |
SO45437_1 | 100 | 28169 | 312 | 6 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45437 | 2022-04-13 | 286.26 | 2171.29 | |
SO55651_4 | 98 | 14423 | 477 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 4 | SO55651 | 2023-12-03 | 0.40 | 1.87 | |
SO45438_1 | 100 | 29334 | 310 | 1 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45438 | 2022-04-13 | 286.26 | 2171.29 | |
SO55651_5 | 98 | 14423 | 217 | 10 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 5 | SO55651 | 2023-12-03 | 2.80 | 13.09 | |
SO45439_1 | 6 | 25823 | 326 | 9 | 2022-04-18 | 17.48 | 2022-04-06 | 699.10 | 1 | SO45439 | 2022-04-13 | 55.93 | 413.15 | |
SO55651_6 | 98 | 14423 | 225 | 10 | 2023-12-08 | 0.22 | 2023-11-26 | 8.99 | 6 | SO55651 | 2023-12-03 | 0.72 | 6.92 | |
SO45440_1 | 100 | 14198 | 312 | 8 | 2022-04-19 | 89.46 | 2022-04-07 | 3578.27 | 1 | SO45440 | 2022-04-14 | 286.26 | 2171.29 | |
SO55652_1 | 98 | 18149 | 530 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55652 | 2023-12-03 | 0.40 | 1.87 |
Generated 2024-09-21 00:01:36.587 UTC