[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 251 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55920_4 | 98 | 23954 | 225 | 10 | 2023-12-12 | 0.22 | 2023-11-30 | 8.99 | 4 | SO55920 | 2023-12-07 | 0.72 | 6.92 | |
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 | |
SO55920_5 | 98 | 23954 | 214 | 10 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 5 | SO55920 | 2023-12-07 | 2.80 | 13.09 | |
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 | |
SO55921_1 | 98 | 28880 | 604 | 10 | 2023-12-12 | 13.50 | 2023-11-30 | 539.99 | 1 | SO55921 | 2023-12-07 | 43.20 | 343.65 | |
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 | |
SO55921_2 | 98 | 28880 | 217 | 10 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 2 | SO55921 | 2023-12-07 | 2.80 | 13.09 | |
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 | |
SO55921_3 | 98 | 28880 | 489 | 10 | 2023-12-12 | 1.35 | 2023-11-30 | 53.99 | 3 | SO55921 | 2023-12-07 | 4.32 | 41.57 | |
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 | |
SO55921_4 | 98 | 28880 | 225 | 10 | 2023-12-12 | 0.22 | 2023-11-30 | 8.99 | 4 | SO55921 | 2023-12-07 | 0.72 | 6.92 | |
SO45467_1 | 98 | 11422 | 345 | 10 | 2022-04-26 | 85.00 | 2022-04-14 | 3399.99 | 1 | SO45467 | 2022-04-21 | 272.00 | 1912.15 | |
SO55923_1 | 98 | 12216 | 355 | 10 | 2023-12-13 | 58.00 | 2023-12-01 | 2319.99 | 1 | SO55923 | 2023-12-08 | 185.60 | 1265.62 | |
SO45593_1 | 98 | 15118 | 310 | 10 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45593 | 2022-04-30 | 286.26 | 2171.29 | |
SO55923_2 | 98 | 12216 | 485 | 10 | 2023-12-13 | 0.55 | 2023-12-01 | 21.98 | 2 | SO55923 | 2023-12-08 | 1.76 | 8.22 | |
SO45596_1 | 98 | 20564 | 332 | 10 | 2022-05-05 | 17.48 | 2022-04-23 | 699.10 | 1 | SO45596 | 2022-04-30 | 55.93 | 413.15 | |
SO55923_3 | 98 | 12216 | 487 | 10 | 2023-12-13 | 1.37 | 2023-12-01 | 54.99 | 3 | SO55923 | 2023-12-08 | 4.40 | 20.57 | |
SO45617_1 | 98 | 15354 | 311 | 10 | 2022-05-08 | 89.46 | 2022-04-26 | 3578.27 | 1 | SO45617 | 2022-05-03 | 286.26 | 2171.29 | |
SO55923_4 | 98 | 12216 | 222 | 10 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 4 | SO55923 | 2023-12-08 | 2.80 | 13.09 | |
SO45645_1 | 98 | 11482 | 351 | 10 | 2022-05-13 | 84.37 | 2022-05-01 | 3374.99 | 1 | SO45645 | 2022-05-08 | 270.00 | 1898.09 | |
SO55933_1 | 98 | 15638 | 590 | 10 | 2023-12-13 | 19.24 | 2023-12-01 | 769.49 | 1 | SO55933 | 2023-12-08 | 61.56 | 419.78 | |
SO45684_1 | 98 | 11485 | 345 | 10 | 2022-05-19 | 85.00 | 2022-05-07 | 3399.99 | 1 | SO45684 | 2022-05-14 | 272.00 | 1912.15 | |
SO55933_2 | 98 | 15638 | 528 | 10 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 2 | SO55933 | 2023-12-08 | 0.40 | 1.87 | |
SO45693_1 | 98 | 15083 | 313 | 10 | 2022-05-20 | 89.46 | 2022-05-08 | 3578.27 | 1 | SO45693 | 2022-05-15 | 286.26 | 2171.29 | |
SO55933_3 | 98 | 15638 | 536 | 10 | 2023-12-13 | 0.75 | 2023-12-01 | 29.99 | 3 | SO55933 | 2023-12-08 | 2.40 | 11.22 | |
SO45694_1 | 98 | 15097 | 312 | 10 | 2022-05-20 | 89.46 | 2022-05-08 | 3578.27 | 1 | SO45694 | 2022-05-15 | 286.26 | 2171.29 | |
SO55933_4 | 98 | 15638 | 480 | 10 | 2023-12-13 | 0.06 | 2023-12-01 | 2.29 | 4 | SO55933 | 2023-12-08 | 0.18 | 0.86 | |
SO45713_1 | 98 | 15088 | 314 | 10 | 2022-05-23 | 89.46 | 2022-05-11 | 3578.27 | 1 | SO45713 | 2022-05-18 | 286.26 | 2171.29 | |
SO55947_1 | 98 | 14172 | 541 | 10 | 2023-12-13 | 0.72 | 2023-12-01 | 28.99 | 1 | SO55947 | 2023-12-08 | 2.32 | 10.84 | |
SO45729_1 | 98 | 15087 | 313 | 10 | 2022-05-26 | 89.46 | 2022-05-14 | 3578.27 | 1 | SO45729 | 2022-05-21 | 286.26 | 2171.29 | |
SO55947_2 | 98 | 14172 | 530 | 10 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 2 | SO55947 | 2023-12-08 | 0.40 | 1.87 | |
SO45745_1 | 98 | 15089 | 312 | 10 | 2022-05-28 | 89.46 | 2022-05-16 | 3578.27 | 1 | SO45745 | 2022-05-23 | 286.26 | 2171.29 | |
SO55947_3 | 98 | 14172 | 480 | 2 | 10 | 2023-12-13 | 0.06 | 2023-12-01 | 2.29 | 3 | SO55947 | 2023-12-08 | 0.18 | 0.86 |
SO45758_1 | 98 | 15106 | 312 | 10 | 2022-05-30 | 89.46 | 2022-05-18 | 3578.27 | 1 | SO45758 | 2022-05-25 | 286.26 | 2171.29 | |
SO55949_1 | 98 | 13533 | 478 | 10 | 2023-12-13 | 0.25 | 2023-12-01 | 9.99 | 1 | SO55949 | 2023-12-08 | 0.80 | 3.74 | |
SO45827_1 | 98 | 15440 | 312 | 10 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45827 | 2022-05-31 | 286.26 | 2171.29 | |
SO55949_2 | 98 | 13533 | 477 | 10 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 2 | SO55949 | 2023-12-08 | 0.40 | 1.87 | |
SO45853_1 | 98 | 15453 | 313 | 10 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45853 | 2022-06-04 | 286.26 | 2171.29 | |
SO55949_3 | 98 | 13533 | 488 | 10 | 2023-12-13 | 1.35 | 2023-12-01 | 53.99 | 3 | SO55949 | 2023-12-08 | 4.32 | 41.57 | |
SO45854_1 | 98 | 15620 | 312 | 10 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45854 | 2022-06-04 | 286.26 | 2171.29 | |
SO55968_1 | 98 | 12215 | 357 | 10 | 2023-12-14 | 58.00 | 2023-12-02 | 2319.99 | 1 | SO55968 | 2023-12-09 | 185.60 | 1265.62 | |
SO45866_1 | 98 | 15621 | 310 | 10 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45866 | 2022-06-06 | 286.26 | 2171.29 | |
SO55968_2 | 98 | 12215 | 537 | 10 | 2023-12-14 | 0.88 | 2023-12-02 | 35.00 | 2 | SO55968 | 2023-12-09 | 2.80 | 13.09 | |
SO45902_1 | 98 | 15614 | 314 | 10 | 2022-06-17 | 89.46 | 2022-06-05 | 3578.27 | 1 | SO45902 | 2022-06-12 | 286.26 | 2171.29 | |
SO55968_3 | 98 | 12215 | 480 | 10 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 3 | SO55968 | 2023-12-09 | 0.18 | 0.86 | |
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_1 | 98 | 11610 | 361 | 10 | 2023-12-14 | 57.37 | 2023-12-02 | 2294.99 | 1 | SO55970 | 2023-12-09 | 183.60 | 1251.98 | |
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 | |
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 | |
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_1 | 98 | 19512 | 539 | 10 | 2023-12-14 | 0.62 | 2023-12-02 | 24.99 | 1 | SO55998 | 2023-12-09 | 2.00 | 9.35 | |
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_2 | 98 | 19512 | 529 | 10 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 2 | SO55998 | 2023-12-09 | 0.32 | 1.49 | |
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_3 | 98 | 19512 | 487 | 10 | 2023-12-14 | 1.37 | 2023-12-02 | 54.99 | 3 | SO55998 | 2023-12-09 | 4.40 | 20.57 | |
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 | |
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 | |
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_1 | 98 | 20909 | 536 | 10 | 2023-12-14 | 0.75 | 2023-12-02 | 29.99 | 1 | SO55999 | 2023-12-09 | 2.40 | 11.22 | |
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_2 | 98 | 20909 | 528 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 2 | SO55999 | 2023-12-09 | 0.40 | 1.87 | |
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 | |
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 | |
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_1 | 98 | 22475 | 477 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO56000 | 2023-12-09 | 0.40 | 1.87 | |
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_2 | 98 | 22475 | 222 | 10 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 2 | SO56000 | 2023-12-09 | 2.80 | 13.09 | |
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_3 | 98 | 22475 | 237 | 10 | 2023-12-14 | 1.25 | 2023-12-02 | 49.99 | 3 | SO56000 | 2023-12-09 | 4.00 | 38.49 | |
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 | |
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 | |
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_1 | 98 | 27939 | 529 | 10 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 1 | SO56001 | 2023-12-09 | 0.32 | 1.49 | |
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_2 | 98 | 27939 | 214 | 10 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 2 | SO56001 | 2023-12-09 | 2.80 | 13.09 | |
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 | |
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 | |
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_1 | 98 | 12733 | 541 | 10 | 2023-12-14 | 0.72 | 2023-12-02 | 28.99 | 1 | SO56002 | 2023-12-09 | 2.32 | 10.84 | |
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 | |
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 | |
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_1 | 98 | 16453 | 530 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO56003 | 2023-12-09 | 0.40 | 1.87 | |
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 | |
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 |
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_1 | 98 | 26211 | 584 | 10 | 2023-12-14 | 13.50 | 2023-12-02 | 539.99 | 1 | SO56018 | 2023-12-09 | 43.20 | 343.65 | |
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_2 | 98 | 26211 | 538 | 10 | 2023-12-14 | 0.54 | 2023-12-02 | 21.49 | 2 | SO56018 | 2023-12-09 | 1.72 | 8.04 | |
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 | |
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 | |
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_1 | 98 | 20054 | 372 | 10 | 2023-12-15 | 61.08 | 2023-12-03 | 2443.35 | 1 | SO56027 | 2023-12-10 | 195.47 | 1554.95 | |
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_2 | 98 | 20054 | 529 | 10 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 2 | SO56027 | 2023-12-10 | 0.32 | 1.49 | |
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 |
Generated 2024-09-20 07:40:04.685 UTC