[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 296 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55970_1 | 98 | 11610 | 361 | 10 | 2023-12-14 | 57.37 | 2023-12-02 | 2294.99 | 1 | SO55970 | 2023-12-09 | 183.60 | 1251.98 | |
SO45903_1 | 98 | 15619 | 310 | 10 | 2022-06-17 | 89.46 | 2022-06-05 | 3578.27 | 1 | SO45903 | 2022-06-12 | 286.26 | 2171.29 | |
SO55970_2 | 98 | 11610 | 485 | 10 | 2023-12-14 | 0.55 | 2023-12-02 | 21.98 | 2 | SO55970 | 2023-12-09 | 1.76 | 8.22 | |
SO45979_1 | 98 | 15630 | 311 | 10 | 2022-06-28 | 89.46 | 2022-06-16 | 3578.27 | 1 | SO45979 | 2022-06-23 | 286.26 | 2171.29 | |
SO55998_1 | 98 | 19512 | 539 | 10 | 2023-12-14 | 0.62 | 2023-12-02 | 24.99 | 1 | SO55998 | 2023-12-09 | 2.00 | 9.35 | |
SO45980_1 | 98 | 15631 | 312 | 10 | 2022-06-28 | 89.46 | 2022-06-16 | 3578.27 | 1 | SO45980 | 2022-06-23 | 286.26 | 2171.29 | |
SO55998_2 | 98 | 19512 | 529 | 10 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 2 | SO55998 | 2023-12-09 | 0.32 | 1.49 | |
SO46010_1 | 98 | 11488 | 348 | 10 | 2022-07-02 | 84.37 | 2022-06-20 | 3374.99 | 1 | SO46010 | 2022-06-27 | 270.00 | 1898.09 | |
SO55998_3 | 98 | 19512 | 487 | 10 | 2023-12-14 | 1.37 | 2023-12-02 | 54.99 | 3 | SO55998 | 2023-12-09 | 4.40 | 20.57 | |
SO46011_1 | 98 | 11489 | 351 | 10 | 2022-07-02 | 84.37 | 2022-06-20 | 3374.99 | 1 | SO46011 | 2022-06-27 | 270.00 | 1898.09 | |
SO55998_4 | 98 | 19512 | 480 | 10 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 4 | SO55998 | 2023-12-09 | 0.18 | 0.86 | |
SO46150_1 | 98 | 20569 | 336 | 10 | 2022-07-08 | 17.48 | 2022-06-26 | 699.10 | 1 | SO46150 | 2022-07-03 | 55.93 | 413.15 | |
SO55999_1 | 98 | 20909 | 536 | 10 | 2023-12-14 | 0.75 | 2023-12-02 | 29.99 | 1 | SO55999 | 2023-12-09 | 2.40 | 11.22 | |
SO46166_1 | 98 | 15657 | 313 | 10 | 2022-07-10 | 89.46 | 2022-06-28 | 3578.27 | 1 | SO46166 | 2022-07-05 | 286.26 | 2171.29 | |
SO55999_2 | 98 | 20909 | 528 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 2 | SO55999 | 2023-12-09 | 0.40 | 1.87 | |
SO46176_1 | 98 | 11491 | 349 | 10 | 2022-07-12 | 84.37 | 2022-06-30 | 3374.99 | 1 | SO46176 | 2022-07-07 | 270.00 | 1898.09 | |
SO55999_3 | 98 | 20909 | 217 | 10 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 3 | SO55999 | 2023-12-09 | 2.80 | 13.09 | |
SO46185_1 | 98 | 15632 | 314 | 10 | 2022-07-14 | 89.46 | 2022-07-02 | 3578.27 | 1 | SO46185 | 2022-07-09 | 286.26 | 2171.29 | |
SO56000_1 | 98 | 22475 | 477 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO56000 | 2023-12-09 | 0.40 | 1.87 | |
SO46190_1 | 98 | 15653 | 312 | 10 | 2022-07-14 | 89.46 | 2022-07-02 | 3578.27 | 1 | SO46190 | 2022-07-09 | 286.26 | 2171.29 | |
SO56000_2 | 98 | 22475 | 222 | 10 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 2 | SO56000 | 2023-12-09 | 2.80 | 13.09 | |
SO46230_1 | 98 | 11493 | 344 | 10 | 2022-07-19 | 85.00 | 2022-07-07 | 3399.99 | 1 | SO46230 | 2022-07-14 | 272.00 | 1912.15 | |
SO56000_3 | 98 | 22475 | 237 | 10 | 2023-12-14 | 1.25 | 2023-12-02 | 49.99 | 3 | SO56000 | 2023-12-09 | 4.00 | 38.49 | |
SO46256_1 | 98 | 15652 | 314 | 10 | 2022-07-22 | 89.46 | 2022-07-10 | 3578.27 | 1 | SO46256 | 2022-07-17 | 286.26 | 2171.29 | |
SO56000_4 | 98 | 22475 | 482 | 10 | 2023-12-14 | 0.22 | 2023-12-02 | 8.99 | 4 | SO56000 | 2023-12-09 | 0.72 | 3.36 | |
SO46269_1 | 98 | 15638 | 312 | 10 | 2022-07-24 | 89.46 | 2022-07-12 | 3578.27 | 1 | SO46269 | 2022-07-19 | 286.26 | 2171.29 | |
SO56001_1 | 98 | 27939 | 529 | 10 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 1 | SO56001 | 2023-12-09 | 0.32 | 1.49 | |
SO46295_1 | 98 | 20567 | 330 | 10 | 2022-07-28 | 17.48 | 2022-07-16 | 699.10 | 1 | SO46295 | 2022-07-23 | 55.93 | 413.15 | |
SO56001_2 | 98 | 27939 | 214 | 10 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 2 | SO56001 | 2023-12-09 | 2.80 | 13.09 | |
SO46393_1 | 98 | 15695 | 314 | 10 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO46393 | 2022-07-29 | 286.26 | 2171.29 | |
SO56001_3 | 98 | 27939 | 489 | 10 | 2023-12-14 | 1.35 | 2023-12-02 | 53.99 | 3 | SO56001 | 2023-12-09 | 4.32 | 41.57 | |
SO46395_1 | 98 | 11496 | 346 | 10 | 2022-08-04 | 85.00 | 2022-07-23 | 3399.99 | 1 | SO46395 | 2022-07-30 | 272.00 | 1912.15 | |
SO56002_1 | 98 | 12733 | 541 | 10 | 2023-12-14 | 0.72 | 2023-12-02 | 28.99 | 1 | SO56002 | 2023-12-09 | 2.32 | 10.84 | |
SO46404_1 | 98 | 15692 | 312 | 10 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO46404 | 2022-07-30 | 286.26 | 2171.29 | |
SO56002_2 | 98 | 12733 | 530 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 2 | SO56002 | 2023-12-09 | 0.40 | 1.87 | |
SO46410_1 | 98 | 11548 | 348 | 10 | 2022-08-06 | 84.37 | 2022-07-25 | 3374.99 | 1 | SO46410 | 2022-08-01 | 270.00 | 1898.09 | |
SO56003_1 | 98 | 16453 | 530 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO56003 | 2023-12-09 | 0.40 | 1.87 | |
SO46441_1 | 98 | 15661 | 312 | 10 | 2022-08-10 | 89.46 | 2022-07-29 | 3578.27 | 1 | SO46441 | 2022-08-05 | 286.26 | 2171.29 | |
SO56003_2 | 98 | 16453 | 480 | 2 | 10 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 2 | SO56003 | 2023-12-09 | 0.18 | 0.86 |
SO46443_1 | 98 | 15662 | 314 | 10 | 2022-08-10 | 89.46 | 2022-07-29 | 3578.27 | 1 | SO46443 | 2022-08-05 | 286.26 | 2171.29 | |
SO56018_1 | 98 | 26211 | 584 | 10 | 2023-12-14 | 13.50 | 2023-12-02 | 539.99 | 1 | SO56018 | 2023-12-09 | 43.20 | 343.65 | |
SO46455_1 | 98 | 15669 | 314 | 10 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO46455 | 2022-08-07 | 286.26 | 2171.29 | |
SO56018_2 | 98 | 26211 | 538 | 10 | 2023-12-14 | 0.54 | 2023-12-02 | 21.49 | 2 | SO56018 | 2023-12-09 | 1.72 | 8.04 | |
SO46475_1 | 98 | 20575 | 322 | 10 | 2022-08-15 | 17.48 | 2022-08-03 | 699.10 | 1 | SO46475 | 2022-08-10 | 55.93 | 413.15 | |
SO56018_3 | 98 | 26211 | 529 | 10 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 3 | SO56018 | 2023-12-09 | 0.32 | 1.49 | |
SO46519_1 | 98 | 15660 | 310 | 10 | 2022-08-21 | 89.46 | 2022-08-09 | 3578.27 | 1 | SO46519 | 2022-08-16 | 286.26 | 2171.29 | |
SO56027_1 | 98 | 20054 | 372 | 10 | 2023-12-15 | 61.08 | 2023-12-03 | 2443.35 | 1 | SO56027 | 2023-12-10 | 195.47 | 1554.95 | |
SO46543_1 | 98 | 11549 | 345 | 10 | 2022-08-25 | 85.00 | 2022-08-13 | 3399.99 | 1 | SO46543 | 2022-08-20 | 272.00 | 1912.15 | |
SO56027_2 | 98 | 20054 | 529 | 10 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 2 | SO56027 | 2023-12-10 | 0.32 | 1.49 | |
SO46564_1 | 98 | 11494 | 347 | 10 | 2022-08-27 | 85.00 | 2022-08-15 | 3399.99 | 1 | SO46564 | 2022-08-22 | 272.00 | 1912.15 | |
SO56027_3 | 98 | 20054 | 540 | 10 | 2023-12-15 | 0.82 | 2023-12-03 | 32.60 | 3 | SO56027 | 2023-12-10 | 2.61 | 12.19 | |
SO46571_1 | 98 | 15668 | 313 | 10 | 2022-08-28 | 89.46 | 2022-08-16 | 3578.27 | 1 | SO46571 | 2022-08-23 | 286.26 | 2171.29 | |
SO56027_4 | 98 | 20054 | 486 | 10 | 2023-12-15 | 3.98 | 2023-12-03 | 159.00 | 4 | SO56027 | 2023-12-10 | 12.72 | 59.47 | |
SO46595_1 | 98 | 15691 | 312 | 10 | 2022-08-31 | 89.46 | 2022-08-19 | 3578.27 | 1 | SO46595 | 2022-08-26 | 286.26 | 2171.29 | |
SO56046_1 | 98 | 18165 | 537 | 10 | 2023-12-15 | 0.88 | 2023-12-03 | 35.00 | 1 | SO56046 | 2023-12-10 | 2.80 | 13.09 | |
SO46686_1 | 98 | 20577 | 325 | 10 | 2022-09-03 | 19.57 | 2022-08-22 | 782.99 | 1 | SO46686 | 2022-08-29 | 62.64 | 486.71 |
Generated 2024-09-20 04:04:24.121 UTC