[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 1000 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46166_1 | 98 | 15657 | 313 | 10 | 2022-04-26 | 89.46 | 2022-04-14 | 3578.27 | 1 | SO46166 | 2022-04-21 | 286.26 | 2171.29 | |
SO55999_1 | 98 | 20909 | 536 | 10 | 2023-09-30 | 0.75 | 2023-09-18 | 29.99 | 1 | SO55999 | 2023-09-25 | 2.40 | 11.22 | |
SO63600_3 | 98 | 15059 | 477 | 10 | 2024-01-24 | 0.12 | 2024-01-12 | 4.99 | 3 | SO63600 | 2024-01-19 | 0.40 | 1.87 | |
SO70194_2 | 98 | 16058 | 481 | 10 | 2024-04-27 | 0.22 | 2024-04-15 | 8.99 | 2 | SO70194 | 2024-04-22 | 0.72 | 3.36 | |
SO46176_1 | 98 | 11491 | 349 | 10 | 2022-04-28 | 84.37 | 2022-04-16 | 3374.99 | 1 | SO46176 | 2022-04-23 | 270.00 | 1898.09 | |
SO55999_2 | 98 | 20909 | 528 | 10 | 2023-09-30 | 0.12 | 2023-09-18 | 4.99 | 2 | SO55999 | 2023-09-25 | 0.40 | 1.87 | |
SO63600_4 | 98 | 15059 | 222 | 10 | 2024-01-24 | 0.87 | 2024-01-12 | 34.99 | 4 | SO63600 | 2024-01-19 | 2.80 | 13.09 | |
SO70222_1 | 98 | 13690 | 579 | 10 | 2024-04-27 | 30.37 | 2024-04-15 | 1214.85 | 1 | SO70222 | 2024-04-22 | 97.19 | 755.15 | |
SO46185_1 | 98 | 15632 | 314 | 10 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO46185 | 2022-04-25 | 286.26 | 2171.29 | |
SO55999_3 | 98 | 20909 | 217 | 10 | 2023-09-30 | 0.87 | 2023-09-18 | 34.99 | 3 | SO55999 | 2023-09-25 | 2.80 | 13.09 | |
SO63600_5 | 98 | 15059 | 237 | 10 | 2024-01-24 | 1.25 | 2024-01-12 | 49.99 | 5 | SO63600 | 2024-01-19 | 4.00 | 38.49 | |
SO70222_2 | 98 | 13690 | 479 | 10 | 2024-04-27 | 0.22 | 2024-04-15 | 8.99 | 2 | SO70222 | 2024-04-22 | 0.72 | 3.36 | |
SO46190_1 | 98 | 15653 | 312 | 10 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO46190 | 2022-04-25 | 286.26 | 2171.29 | |
SO56000_1 | 98 | 22475 | 477 | 10 | 2023-09-30 | 0.12 | 2023-09-18 | 4.99 | 1 | SO56000 | 2023-09-25 | 0.40 | 1.87 | |
SO63601_1 | 98 | 14195 | 575 | 10 | 2024-01-24 | 59.60 | 2024-01-12 | 2384.07 | 1 | SO63601 | 2024-01-19 | 190.73 | 1481.94 | |
SO70222_3 | 98 | 13690 | 477 | 10 | 2024-04-27 | 0.12 | 2024-04-15 | 4.99 | 3 | SO70222 | 2024-04-22 | 0.40 | 1.87 | |
SO46230_1 | 98 | 11493 | 344 | 10 | 2022-05-05 | 85.00 | 2022-04-23 | 3399.99 | 1 | SO46230 | 2022-04-30 | 272.00 | 1912.15 | |
SO56000_2 | 98 | 22475 | 222 | 10 | 2023-09-30 | 0.87 | 2023-09-18 | 34.99 | 2 | SO56000 | 2023-09-25 | 2.80 | 13.09 | |
SO63601_2 | 98 | 14195 | 479 | 10 | 2024-01-24 | 0.22 | 2024-01-12 | 8.99 | 2 | SO63601 | 2024-01-19 | 0.72 | 3.36 | |
SO70222_4 | 98 | 13690 | 217 | 10 | 2024-04-27 | 0.87 | 2024-04-15 | 34.99 | 4 | SO70222 | 2024-04-22 | 2.80 | 13.09 | |
SO46256_1 | 98 | 15652 | 314 | 10 | 2022-05-08 | 89.46 | 2022-04-26 | 3578.27 | 1 | SO46256 | 2022-05-03 | 286.26 | 2171.29 | |
SO56000_3 | 98 | 22475 | 237 | 10 | 2023-09-30 | 1.25 | 2023-09-18 | 49.99 | 3 | SO56000 | 2023-09-25 | 4.00 | 38.49 | |
SO63630_1 | 98 | 17937 | 600 | 10 | 2024-01-25 | 13.50 | 2024-01-13 | 539.99 | 1 | SO63630 | 2024-01-20 | 43.20 | 294.58 | |
SO70223_1 | 98 | 29368 | 561 | 10 | 2024-04-27 | 59.60 | 2024-04-15 | 2384.07 | 1 | SO70223 | 2024-04-22 | 190.73 | 1481.94 | |
SO46269_1 | 98 | 15638 | 312 | 10 | 2022-05-10 | 89.46 | 2022-04-28 | 3578.27 | 1 | SO46269 | 2022-05-05 | 286.26 | 2171.29 | |
SO56000_4 | 98 | 22475 | 482 | 10 | 2023-09-30 | 0.22 | 2023-09-18 | 8.99 | 4 | SO56000 | 2023-09-25 | 0.72 | 3.36 | |
SO63630_2 | 98 | 17937 | 485 | 10 | 2024-01-25 | 0.55 | 2024-01-13 | 21.98 | 2 | SO63630 | 2024-01-20 | 1.76 | 8.22 | |
SO70223_2 | 98 | 29368 | 479 | 10 | 2024-04-27 | 0.22 | 2024-04-15 | 8.99 | 2 | SO70223 | 2024-04-22 | 0.72 | 3.36 | |
SO46295_1 | 98 | 20567 | 330 | 10 | 2022-05-14 | 17.48 | 2022-05-02 | 699.10 | 1 | SO46295 | 2022-05-09 | 55.93 | 413.15 | |
SO56001_1 | 98 | 27939 | 529 | 10 | 2023-09-30 | 0.10 | 2023-09-18 | 3.99 | 1 | SO56001 | 2023-09-25 | 0.32 | 1.49 | |
SO63630_3 | 98 | 17937 | 471 | 10 | 2024-01-25 | 1.59 | 2024-01-13 | 63.50 | 3 | SO63630 | 2024-01-20 | 5.08 | 23.75 | |
SO70223_3 | 98 | 29368 | 477 | 10 | 2024-04-27 | 0.12 | 2024-04-15 | 4.99 | 3 | SO70223 | 2024-04-22 | 0.40 | 1.87 | |
SO46393_1 | 98 | 15695 | 314 | 10 | 2022-05-20 | 89.46 | 2022-05-08 | 3578.27 | 1 | SO46393 | 2022-05-15 | 286.26 | 2171.29 | |
SO56001_2 | 98 | 27939 | 214 | 10 | 2023-09-30 | 0.87 | 2023-09-18 | 34.99 | 2 | SO56001 | 2023-09-25 | 2.80 | 13.09 | |
SO63631_1 | 98 | 16594 | 353 | 10 | 2024-01-25 | 58.00 | 2024-01-13 | 2319.99 | 1 | SO63631 | 2024-01-20 | 185.60 | 1265.62 | |
SO70223_4 | 98 | 29368 | 465 | 10 | 2024-04-27 | 0.61 | 2024-04-15 | 24.49 | 4 | SO70223 | 2024-04-22 | 1.96 | 9.16 | |
SO46395_1 | 98 | 11496 | 346 | 10 | 2022-05-21 | 85.00 | 2022-05-09 | 3399.99 | 1 | SO46395 | 2022-05-16 | 272.00 | 1912.15 | |
SO56001_3 | 98 | 27939 | 489 | 10 | 2023-09-30 | 1.35 | 2023-09-18 | 53.99 | 3 | SO56001 | 2023-09-25 | 4.32 | 41.57 | |
SO63631_2 | 98 | 16594 | 217 | 10 | 2024-01-25 | 0.87 | 2024-01-13 | 34.99 | 2 | SO63631 | 2024-01-20 | 2.80 | 13.09 | |
SO70244_1 | 98 | 25488 | 386 | 10 | 2024-04-27 | 28.01 | 2024-04-15 | 1120.49 | 1 | SO70244 | 2024-04-22 | 89.64 | 713.08 | |
SO46404_1 | 98 | 15692 | 312 | 10 | 2022-05-21 | 89.46 | 2022-05-09 | 3578.27 | 1 | SO46404 | 2022-05-16 | 286.26 | 2171.29 | |
SO56002_1 | 98 | 12733 | 541 | 10 | 2023-09-30 | 0.72 | 2023-09-18 | 28.99 | 1 | SO56002 | 2023-09-25 | 2.32 | 10.84 | |
SO63660_1 | 98 | 12325 | 541 | 10 | 2024-01-25 | 0.72 | 2024-01-13 | 28.99 | 1 | SO63660 | 2024-01-20 | 2.32 | 10.84 | |
SO70245_1 | 98 | 27762 | 604 | 10 | 2024-04-27 | 13.50 | 2024-04-15 | 539.99 | 1 | SO70245 | 2024-04-22 | 43.20 | 343.65 | |
SO46410_1 | 98 | 11548 | 348 | 10 | 2022-05-23 | 84.37 | 2022-05-11 | 3374.99 | 1 | SO46410 | 2022-05-18 | 270.00 | 1898.09 | |
SO56002_2 | 98 | 12733 | 530 | 10 | 2023-09-30 | 0.12 | 2023-09-18 | 4.99 | 2 | SO56002 | 2023-09-25 | 0.40 | 1.87 | |
SO63660_2 | 98 | 12325 | 530 | 10 | 2024-01-25 | 0.12 | 2024-01-13 | 4.99 | 2 | SO63660 | 2024-01-20 | 0.40 | 1.87 | |
SO70245_2 | 98 | 27762 | 222 | 10 | 2024-04-27 | 0.87 | 2024-04-15 | 34.99 | 2 | SO70245 | 2024-04-22 | 2.80 | 13.09 | |
SO46441_1 | 98 | 15661 | 312 | 10 | 2022-05-27 | 89.46 | 2022-05-15 | 3578.27 | 1 | SO46441 | 2022-05-22 | 286.26 | 2171.29 | |
SO56003_1 | 98 | 16453 | 530 | 10 | 2023-09-30 | 0.12 | 2023-09-18 | 4.99 | 1 | SO56003 | 2023-09-25 | 0.40 | 1.87 | |
SO63660_3 | 98 | 12325 | 225 | 10 | 2024-01-25 | 0.22 | 2024-01-13 | 8.99 | 3 | SO63660 | 2024-01-20 | 0.72 | 6.92 | |
SO70255_1 | 98 | 16445 | 590 | 10 | 2024-04-28 | 19.24 | 2024-04-16 | 769.49 | 1 | SO70255 | 2024-04-23 | 61.56 | 419.78 | |
SO46443_1 | 98 | 15662 | 314 | 10 | 2022-05-27 | 89.46 | 2022-05-15 | 3578.27 | 1 | SO46443 | 2022-05-22 | 286.26 | 2171.29 | |
SO56003_2 | 98 | 16453 | 480 | 2 | 10 | 2023-09-30 | 0.06 | 2023-09-18 | 2.29 | 2 | SO56003 | 2023-09-25 | 0.18 | 0.86 |
SO63660_4 | 98 | 12325 | 487 | 10 | 2024-01-25 | 1.37 | 2024-01-13 | 54.99 | 4 | SO63660 | 2024-01-20 | 4.40 | 20.57 | |
SO70255_2 | 98 | 16445 | 536 | 10 | 2024-04-28 | 0.75 | 2024-04-16 | 29.99 | 2 | SO70255 | 2024-04-23 | 2.40 | 11.22 | |
SO46455_1 | 98 | 15669 | 314 | 10 | 2022-05-29 | 89.46 | 2022-05-17 | 3578.27 | 1 | SO46455 | 2022-05-24 | 286.26 | 2171.29 | |
SO56018_1 | 98 | 26211 | 584 | 10 | 2023-09-30 | 13.50 | 2023-09-18 | 539.99 | 1 | SO56018 | 2023-09-25 | 43.20 | 343.65 | |
SO63664_1 | 98 | 13539 | 478 | 10 | 2024-01-25 | 0.25 | 2024-01-13 | 9.99 | 1 | SO63664 | 2024-01-20 | 0.80 | 3.74 | |
SO70256_1 | 98 | 16509 | 590 | 10 | 2024-04-28 | 19.24 | 2024-04-16 | 769.49 | 1 | SO70256 | 2024-04-23 | 61.56 | 419.78 | |
SO46475_1 | 98 | 20575 | 322 | 10 | 2022-06-01 | 17.48 | 2022-05-20 | 699.10 | 1 | SO46475 | 2022-05-27 | 55.93 | 413.15 | |
SO56018_2 | 98 | 26211 | 538 | 10 | 2023-09-30 | 0.54 | 2023-09-18 | 21.49 | 2 | SO56018 | 2023-09-25 | 1.72 | 8.04 |
Generated 2024-07-07 09:56:29.505 UTC