[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2410 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55999_1 | 98 | 20909 | 536 | 10 | 2024-02-03 | 0.75 | 2024-01-22 | 29.99 | 1 | SO55999 | 2024-01-29 | 2.40 | 11.22 | |
SO45445_1 | 6 | 19105 | 310 | 9 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45445 | 2022-06-04 | 286.26 | 2171.29 | |
SO55999_2 | 98 | 20909 | 528 | 10 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 2 | SO55999 | 2024-01-29 | 0.40 | 1.87 | |
SO45446_1 | 100 | 25990 | 345 | 1 | 2022-06-10 | 85.00 | 2022-05-29 | 3399.99 | 1 | SO45446 | 2022-06-05 | 272.00 | 1912.15 | |
SO55999_3 | 98 | 20909 | 217 | 10 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 3 | SO55999 | 2024-01-29 | 2.80 | 13.09 | |
SO45447_1 | 6 | 19558 | 313 | 9 | 2022-06-10 | 89.46 | 2022-05-29 | 3578.27 | 1 | SO45447 | 2022-06-05 | 286.26 | 2171.29 | |
SO56000_1 | 98 | 22475 | 477 | 10 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 1 | SO56000 | 2024-01-29 | 0.40 | 1.87 | |
SO45448_1 | 6 | 25718 | 324 | 9 | 2022-06-10 | 17.48 | 2022-05-29 | 699.10 | 1 | SO45448 | 2022-06-05 | 55.93 | 413.15 | |
SO56000_2 | 98 | 22475 | 222 | 10 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 2 | SO56000 | 2024-01-29 | 2.80 | 13.09 | |
SO45449_1 | 100 | 14189 | 310 | 8 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45449 | 2022-06-06 | 286.26 | 2171.29 | |
SO56000_3 | 98 | 22475 | 237 | 10 | 2024-02-03 | 1.25 | 2024-01-22 | 49.99 | 3 | SO56000 | 2024-01-29 | 4.00 | 38.49 | |
SO45450_1 | 100 | 28624 | 312 | 6 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45450 | 2022-06-06 | 286.26 | 2171.29 | |
SO56000_4 | 98 | 22475 | 482 | 10 | 2024-02-03 | 0.22 | 2024-01-22 | 8.99 | 4 | SO56000 | 2024-01-29 | 0.72 | 3.36 | |
SO45451_1 | 100 | 29279 | 311 | 4 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45451 | 2022-06-06 | 286.26 | 2171.29 | |
SO56001_1 | 98 | 27939 | 529 | 10 | 2024-02-03 | 0.10 | 2024-01-22 | 3.99 | 1 | SO56001 | 2024-01-29 | 0.32 | 1.49 | |
SO45452_1 | 6 | 19559 | 314 | 9 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45452 | 2022-06-06 | 286.26 | 2171.29 | |
SO56001_2 | 98 | 27939 | 214 | 10 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 2 | SO56001 | 2024-01-29 | 2.80 | 13.09 | |
SO45453_1 | 100 | 12549 | 311 | 7 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45453 | 2022-06-07 | 286.26 | 2171.29 | |
SO56001_3 | 98 | 27939 | 489 | 10 | 2024-02-03 | 1.35 | 2024-01-22 | 53.99 | 3 | SO56001 | 2024-01-29 | 4.32 | 41.57 | |
SO45454_1 | 19 | 23074 | 312 | 6 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45454 | 2022-06-07 | 286.26 | 2171.29 | |
SO56002_1 | 98 | 12733 | 541 | 10 | 2024-02-03 | 0.72 | 2024-01-22 | 28.99 | 1 | SO56002 | 2024-01-29 | 2.32 | 10.84 | |
SO45455_1 | 100 | 14163 | 310 | 8 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45455 | 2022-06-08 | 286.26 | 2171.29 | |
SO56002_2 | 98 | 12733 | 530 | 10 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 2 | SO56002 | 2024-01-29 | 0.40 | 1.87 | |
SO45456_1 | 19 | 23113 | 312 | 6 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45456 | 2022-06-08 | 286.26 | 2171.29 | |
SO56003_1 | 98 | 16453 | 530 | 10 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 1 | SO56003 | 2024-01-29 | 0.40 | 1.87 | |
SO45457_1 | 100 | 27752 | 313 | 6 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45457 | 2022-06-08 | 286.26 | 2171.29 | |
SO56003_2 | 98 | 16453 | 480 | 2 | 10 | 2024-02-03 | 0.06 | 2024-01-22 | 2.29 | 2 | SO56003 | 2024-01-29 | 0.18 | 0.86 |
SO45458_1 | 6 | 19599 | 311 | 9 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45458 | 2022-06-08 | 286.26 | 2171.29 | |
SO56004_1 | 100 | 12741 | 530 | 8 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 1 | SO56004 | 2024-01-29 | 0.40 | 1.87 | |
SO45459_1 | 6 | 19605 | 310 | 9 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45459 | 2022-06-08 | 286.26 | 2171.29 | |
SO56004_2 | 100 | 12741 | 217 | 8 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 2 | SO56004 | 2024-01-29 | 2.80 | 13.09 | |
SO45460_1 | 6 | 25822 | 334 | 9 | 2022-06-13 | 17.48 | 2022-06-01 | 699.10 | 1 | SO45460 | 2022-06-08 | 55.93 | 413.15 | |
SO56005_1 | 100 | 12319 | 234 | 8 | 2024-02-03 | 1.25 | 2024-01-22 | 49.99 | 1 | SO56005 | 2024-01-29 | 4.00 | 38.49 | |
SO45461_1 | 100 | 28646 | 311 | 6 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45461 | 2022-06-09 | 286.26 | 2171.29 | |
SO56005_2 | 100 | 12319 | 465 | 8 | 2024-02-03 | 0.61 | 2024-01-22 | 24.49 | 2 | SO56005 | 2024-01-29 | 1.96 | 9.16 | |
SO45462_1 | 100 | 28647 | 310 | 6 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45462 | 2022-06-09 | 286.26 | 2171.29 | |
SO56006_1 | 19 | 13249 | 353 | 6 | 2024-02-03 | 58.00 | 2024-01-22 | 2319.99 | 1 | SO56006 | 2024-01-29 | 185.60 | 1265.62 | |
SO45463_1 | 100 | 11171 | 312 | 4 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45463 | 2022-06-09 | 286.26 | 2171.29 | |
SO56006_2 | 19 | 13249 | 537 | 6 | 2024-02-03 | 0.88 | 2024-01-22 | 35.00 | 2 | SO56006 | 2024-01-29 | 2.80 | 13.09 | |
SO45464_1 | 6 | 19586 | 314 | 9 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45464 | 2022-06-09 | 286.26 | 2171.29 | |
SO56006_3 | 19 | 13249 | 480 | 6 | 2024-02-03 | 0.06 | 2024-01-22 | 2.29 | 3 | SO56006 | 2024-01-29 | 0.18 | 0.86 | |
SO45465_1 | 6 | 25819 | 342 | 9 | 2022-06-14 | 17.48 | 2022-06-02 | 699.10 | 1 | SO45465 | 2022-06-09 | 55.93 | 413.15 | |
SO56007_1 | 100 | 12934 | 363 | 4 | 2024-02-03 | 57.37 | 2024-01-22 | 2294.99 | 1 | SO56007 | 2024-01-29 | 183.60 | 1251.98 | |
SO45466_1 | 6 | 19611 | 311 | 9 | 2022-06-15 | 89.46 | 2022-06-03 | 3578.27 | 1 | SO45466 | 2022-06-10 | 286.26 | 2171.29 | |
SO56007_2 | 100 | 12934 | 537 | 4 | 2024-02-03 | 0.88 | 2024-01-22 | 35.00 | 2 | SO56007 | 2024-01-29 | 2.80 | 13.09 | |
SO45467_1 | 98 | 11422 | 345 | 10 | 2022-06-16 | 85.00 | 2022-06-04 | 3399.99 | 1 | SO45467 | 2022-06-11 | 272.00 | 1912.15 | |
SO56007_3 | 100 | 12934 | 528 | 4 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 3 | SO56007 | 2024-01-29 | 0.40 | 1.87 | |
SO45468_1 | 19 | 23164 | 311 | 6 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45468 | 2022-06-11 | 286.26 | 2171.29 | |
SO56007_4 | 100 | 12934 | 214 | 4 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 4 | SO56007 | 2024-01-29 | 2.80 | 13.09 | |
SO45469_1 | 19 | 19989 | 350 | 6 | 2022-06-16 | 84.37 | 2022-06-04 | 3374.99 | 1 | SO45469 | 2022-06-11 | 270.00 | 1898.09 | |
SO56008_1 | 6 | 17279 | 376 | 9 | 2024-02-03 | 61.08 | 2024-01-22 | 2443.35 | 1 | SO56008 | 2024-01-29 | 195.47 | 1554.95 | |
SO45470_1 | 100 | 28177 | 312 | 6 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45470 | 2022-06-11 | 286.26 | 2171.29 | |
SO56009_1 | 6 | 19561 | 372 | 9 | 2024-02-03 | 61.08 | 2024-01-22 | 2443.35 | 1 | SO56009 | 2024-01-29 | 195.47 | 1554.95 | |
SO45471_1 | 100 | 29280 | 313 | 1 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45471 | 2022-06-11 | 286.26 | 2171.29 | |
SO56010_1 | 6 | 11989 | 361 | 9 | 2024-02-03 | 57.37 | 2024-01-22 | 2294.99 | 1 | SO56010 | 2024-01-29 | 183.60 | 1251.98 | |
SO45472_1 | 6 | 19095 | 313 | 9 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45472 | 2022-06-11 | 286.26 | 2171.29 | |
SO56010_2 | 6 | 11989 | 485 | 9 | 2024-02-03 | 0.55 | 2024-01-22 | 21.98 | 2 | SO56010 | 2024-01-29 | 1.76 | 8.22 | |
SO45473_1 | 6 | 19592 | 310 | 9 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45473 | 2022-06-11 | 286.26 | 2171.29 | |
SO56010_3 | 6 | 11989 | 473 | 9 | 2024-02-03 | 1.59 | 2024-01-22 | 63.50 | 3 | SO56010 | 2024-01-29 | 5.08 | 23.75 | |
SO45474_1 | 6 | 19595 | 310 | 9 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45474 | 2022-06-11 | 286.26 | 2171.29 | |
SO56011_1 | 19 | 23306 | 579 | 6 | 2024-02-03 | 30.37 | 2024-01-22 | 1214.85 | 1 | SO56011 | 2024-01-29 | 97.19 | 755.15 | |
SO45475_1 | 6 | 19601 | 313 | 9 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45475 | 2022-06-11 | 286.26 | 2171.29 | |
SO56011_2 | 19 | 23306 | 217 | 6 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 2 | SO56011 | 2024-01-29 | 2.80 | 13.09 | |
SO45476_1 | 6 | 19614 | 314 | 9 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45476 | 2022-06-11 | 286.26 | 2171.29 | |
SO56012_1 | 100 | 25383 | 579 | 1 | 2024-02-03 | 30.37 | 2024-01-22 | 1214.85 | 1 | SO56012 | 2024-01-29 | 97.19 | 755.15 | |
SO45477_1 | 100 | 14160 | 313 | 8 | 2022-06-17 | 89.46 | 2022-06-05 | 3578.27 | 1 | SO45477 | 2022-06-12 | 286.26 | 2171.29 | |
SO56012_2 | 100 | 25383 | 479 | 1 | 2024-02-03 | 0.22 | 2024-01-22 | 8.99 | 2 | SO56012 | 2024-01-29 | 0.72 | 3.36 | |
SO45478_1 | 100 | 29354 | 313 | 1 | 2022-06-17 | 89.46 | 2022-06-05 | 3578.27 | 1 | SO45478 | 2022-06-12 | 286.26 | 2171.29 | |
SO56012_3 | 100 | 25383 | 477 | 1 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 3 | SO56012 | 2024-01-29 | 0.40 | 1.87 | |
SO45479_1 | 6 | 19099 | 313 | 9 | 2022-06-17 | 89.46 | 2022-06-05 | 3578.27 | 1 | SO45479 | 2022-06-12 | 286.26 | 2171.29 | |
SO56013_1 | 100 | 19743 | 388 | 1 | 2024-02-03 | 28.01 | 2024-01-22 | 1120.49 | 1 | SO56013 | 2024-01-29 | 89.64 | 713.08 | |
SO45480_1 | 6 | 19564 | 313 | 9 | 2022-06-17 | 89.46 | 2022-06-05 | 3578.27 | 1 | SO45480 | 2022-06-12 | 286.26 | 2171.29 | |
SO56013_2 | 100 | 19743 | 231 | 1 | 2024-02-03 | 1.25 | 2024-01-22 | 49.99 | 2 | SO56013 | 2024-01-29 | 4.00 | 38.49 | |
SO45481_1 | 6 | 19563 | 313 | 9 | 2022-06-17 | 89.46 | 2022-06-05 | 3578.27 | 1 | SO45481 | 2022-06-12 | 286.26 | 2171.29 | |
SO56013_3 | 100 | 19743 | 467 | 2 | 1 | 2024-02-03 | 0.61 | 2024-01-22 | 24.49 | 3 | SO56013 | 2024-01-29 | 1.96 | 9.16 |
SO45482_1 | 100 | 12522 | 310 | 7 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45482 | 2022-06-13 | 286.26 | 2171.29 | |
SO56014_1 | 100 | 20162 | 384 | 2 | 8 | 2024-02-03 | 28.01 | 2024-01-22 | 1120.49 | 1 | SO56014 | 2024-01-29 | 89.64 | 713.08 |
SO45483_1 | 100 | 14181 | 314 | 8 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45483 | 2022-06-13 | 286.26 | 2171.29 | |
SO56014_2 | 100 | 20162 | 225 | 8 | 2024-02-03 | 0.22 | 2024-01-22 | 8.99 | 2 | SO56014 | 2024-01-29 | 0.72 | 6.92 | |
SO45484_1 | 19 | 23267 | 313 | 6 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45484 | 2022-06-13 | 286.26 | 2171.29 | |
SO56014_3 | 100 | 20162 | 490 | 8 | 2024-02-03 | 1.35 | 2024-01-22 | 53.99 | 3 | SO56014 | 2024-01-29 | 4.32 | 41.57 | |
SO45485_1 | 100 | 11257 | 312 | 4 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45485 | 2022-06-13 | 286.26 | 2171.29 | |
SO56015_1 | 100 | 19426 | 382 | 7 | 2024-02-03 | 28.01 | 2024-01-22 | 1120.49 | 1 | SO56015 | 2024-01-29 | 89.64 | 713.08 | |
SO45486_1 | 100 | 14737 | 324 | 1 | 2022-06-18 | 17.48 | 2022-06-06 | 699.10 | 1 | SO45486 | 2022-06-13 | 55.93 | 413.15 | |
SO56015_2 | 100 | 19426 | 222 | 7 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 2 | SO56015 | 2024-01-29 | 2.80 | 13.09 | |
SO45487_1 | 6 | 19556 | 313 | 9 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45487 | 2022-06-13 | 286.26 | 2171.29 | |
SO56016_1 | 100 | 12384 | 605 | 8 | 2024-02-03 | 13.50 | 2024-01-22 | 539.99 | 1 | SO56016 | 2024-01-29 | 43.20 | 343.65 | |
SO56016_2 | 100 | 12384 | 477 | 8 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 2 | SO56016 | 2024-01-29 | 0.40 | 1.87 | |
SO45488_1 | 6 | 19577 | 311 | 9 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45488 | 2022-06-13 | 286.26 | 2171.29 | |
SO56016_3 | 100 | 12384 | 479 | 8 | 2024-02-03 | 0.22 | 2024-01-22 | 8.99 | 3 | SO56016 | 2024-01-29 | 0.72 | 3.36 | |
SO45489_1 | 6 | 19602 | 310 | 9 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45489 | 2022-06-13 | 286.26 | 2171.29 | |
SO56016_4 | 100 | 12384 | 463 | 8 | 2024-02-03 | 0.61 | 2024-01-22 | 24.49 | 4 | SO56016 | 2024-01-29 | 1.96 | 9.16 | |
SO45490_1 | 19 | 22976 | 313 | 6 | 2022-06-18 | 89.46 | 2022-06-06 | 3578.27 | 1 | SO45490 | 2022-06-13 | 286.26 | 2171.29 | |
SO56017_1 | 100 | 22522 | 606 | 8 | 2024-02-03 | 13.50 | 2024-01-22 | 539.99 | 1 | SO56017 | 2024-01-29 | 43.20 | 343.65 | |
SO45491_1 | 100 | 27672 | 311 | 6 | 2022-06-19 | 89.46 | 2022-06-07 | 3578.27 | 1 | SO45491 | 2022-06-14 | 286.26 | 2171.29 | |
SO56018_1 | 98 | 26211 | 584 | 10 | 2024-02-03 | 13.50 | 2024-01-22 | 539.99 | 1 | SO56018 | 2024-01-29 | 43.20 | 343.65 |
Generated 2024-11-11 01:40:28.289 UTC