[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1709 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69679_2 | 100 | 21420 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 2 | SO69679 | 2024-08-19 | 0.40 | 1.87 | |
SO46317_1 | 100 | 14884 | 334 | 4 | 2022-09-21 | 17.48 | 2022-09-09 | 699.10 | 1 | SO46317 | 2022-09-16 | 55.93 | 413.15 | |
SO56313_5 | 100 | 16973 | 483 | 4 | 2024-02-09 | 3.00 | 2024-01-28 | 120.00 | 5 | SO56313 | 2024-02-04 | 9.60 | 44.88 | |
SO62984_7 | 100 | 12118 | 481 | 4 | 2024-05-22 | 0.22 | 2024-05-10 | 8.99 | 7 | SO62984 | 2024-05-17 | 0.72 | 3.36 | |
SO69679_3 | 100 | 21420 | 472 | 4 | 2024-08-24 | 1.59 | 2024-08-12 | 63.50 | 3 | SO69679 | 2024-08-19 | 5.08 | 23.75 | |
SO46319_1 | 100 | 12103 | 311 | 4 | 2022-09-22 | 89.46 | 2022-09-10 | 3578.27 | 1 | SO46319 | 2022-09-17 | 286.26 | 2171.29 | |
SO56325_1 | 100 | 26484 | 566 | 4 | 2024-02-09 | 18.56 | 2024-01-28 | 742.35 | 1 | SO56325 | 2024-02-04 | 59.39 | 461.44 | |
SO62993_1 | 100 | 22862 | 606 | 4 | 2024-05-22 | 13.50 | 2024-05-10 | 539.99 | 1 | SO62993 | 2024-05-17 | 43.20 | 343.65 | |
SO69680_1 | 100 | 23006 | 478 | 4 | 2024-08-24 | 0.25 | 2024-08-12 | 9.99 | 1 | SO69680 | 2024-08-19 | 0.80 | 3.74 | |
SO46320_1 | 100 | 26084 | 351 | 4 | 2022-09-22 | 84.37 | 2022-09-10 | 3374.99 | 1 | SO46320 | 2022-09-17 | 270.00 | 1898.09 | |
SO56328_1 | 100 | 24959 | 564 | 4 | 2024-02-09 | 59.60 | 2024-01-28 | 2384.07 | 1 | SO56328 | 2024-02-04 | 190.73 | 1481.94 | |
SO62994_1 | 100 | 23216 | 606 | 4 | 2024-05-22 | 13.50 | 2024-05-10 | 539.99 | 1 | SO62994 | 2024-05-17 | 43.20 | 343.65 | |
SO69680_2 | 100 | 23006 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 2 | SO69680 | 2024-08-19 | 0.40 | 1.87 | |
SO46390_1 | 100 | 12440 | 313 | 4 | 2022-09-23 | 89.46 | 2022-09-11 | 3578.27 | 1 | SO46390 | 2022-09-18 | 286.26 | 2171.29 | |
SO56328_2 | 100 | 24959 | 214 | 4 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 2 | SO56328 | 2024-02-04 | 2.80 | 13.09 | |
SO62994_2 | 100 | 23216 | 477 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 2 | SO62994 | 2024-05-17 | 0.40 | 1.87 | |
SO69680_3 | 100 | 23006 | 463 | 4 | 2024-08-24 | 0.61 | 2024-08-12 | 24.49 | 3 | SO69680 | 2024-08-19 | 1.96 | 9.16 | |
SO46396_1 | 100 | 12442 | 311 | 4 | 2022-09-24 | 89.46 | 2022-09-12 | 3578.27 | 1 | SO46396 | 2022-09-19 | 286.26 | 2171.29 | |
SO56330_1 | 100 | 22886 | 606 | 4 | 2024-02-09 | 13.50 | 2024-01-28 | 539.99 | 1 | SO56330 | 2024-02-04 | 43.20 | 343.65 | |
SO62994_3 | 100 | 23216 | 479 | 4 | 2024-05-22 | 0.22 | 2024-05-10 | 8.99 | 3 | SO62994 | 2024-05-17 | 0.72 | 3.36 | |
SO69682_1 | 100 | 20292 | 475 | 4 | 2024-08-24 | 1.75 | 2024-08-12 | 69.99 | 1 | SO69682 | 2024-08-19 | 5.60 | 26.18 | |
SO46414_1 | 100 | 15006 | 338 | 4 | 2022-09-26 | 17.48 | 2022-09-14 | 699.10 | 1 | SO46414 | 2022-09-21 | 55.93 | 413.15 | |
SO56330_2 | 100 | 22886 | 217 | 4 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 2 | SO56330 | 2024-02-04 | 2.80 | 13.09 | |
SO62994_4 | 100 | 23216 | 217 | 4 | 2024-05-22 | 0.87 | 2024-05-10 | 34.99 | 4 | SO62994 | 2024-05-17 | 2.80 | 13.09 | |
SO69682_2 | 100 | 20292 | 231 | 4 | 2024-08-24 | 1.25 | 2024-08-12 | 49.99 | 2 | SO69682 | 2024-08-19 | 4.00 | 38.49 | |
SO46416_1 | 100 | 12181 | 313 | 4 | 2022-09-27 | 89.46 | 2022-09-15 | 3578.27 | 1 | SO46416 | 2022-09-22 | 286.26 | 2171.29 | |
SO56330_3 | 100 | 22886 | 467 | 4 | 2024-02-09 | 0.61 | 2024-01-28 | 24.49 | 3 | SO56330 | 2024-02-04 | 1.96 | 9.16 | |
SO62994_5 | 100 | 23216 | 465 | 4 | 2024-05-22 | 0.61 | 2024-05-10 | 24.49 | 5 | SO62994 | 2024-05-17 | 1.96 | 9.16 | |
SO69686_1 | 100 | 16120 | 528 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 1 | SO69686 | 2024-08-19 | 0.40 | 1.87 | |
SO46417_1 | 100 | 12441 | 314 | 4 | 2022-09-27 | 89.46 | 2022-09-15 | 3578.27 | 1 | SO46417 | 2022-09-22 | 286.26 | 2171.29 | |
SO56346_1 | 100 | 23469 | 536 | 4 | 2024-02-10 | 0.75 | 2024-01-29 | 29.99 | 1 | SO56346 | 2024-02-05 | 2.40 | 11.22 | |
SO62995_1 | 100 | 22718 | 584 | 4 | 2024-05-22 | 13.50 | 2024-05-10 | 539.99 | 1 | SO62995 | 2024-05-17 | 43.20 | 343.65 | |
SO69686_2 | 100 | 16120 | 480 | 2 | 4 | 2024-08-24 | 0.06 | 2024-08-12 | 2.29 | 2 | SO69686 | 2024-08-19 | 0.18 | 0.86 |
SO46422_1 | 100 | 12884 | 311 | 4 | 2022-09-28 | 89.46 | 2022-09-16 | 3578.27 | 1 | SO46422 | 2022-09-23 | 286.26 | 2171.29 | |
SO56348_1 | 100 | 25023 | 540 | 4 | 2024-02-10 | 0.82 | 2024-01-29 | 32.60 | 1 | SO56348 | 2024-02-05 | 2.61 | 12.19 | |
SO62995_2 | 100 | 22718 | 538 | 4 | 2024-05-22 | 0.54 | 2024-05-10 | 21.49 | 2 | SO62995 | 2024-05-17 | 1.72 | 8.04 | |
SO69687_1 | 100 | 15316 | 528 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 1 | SO69687 | 2024-08-19 | 0.40 | 1.87 | |
SO46423_1 | 100 | 12362 | 313 | 4 | 2022-09-28 | 89.46 | 2022-09-16 | 3578.27 | 1 | SO46423 | 2022-09-23 | 286.26 | 2171.29 | |
SO56348_2 | 100 | 25023 | 529 | 4 | 2024-02-10 | 0.10 | 2024-01-29 | 3.99 | 2 | SO56348 | 2024-02-05 | 0.32 | 1.49 | |
SO62995_3 | 100 | 22718 | 529 | 4 | 2024-05-22 | 0.10 | 2024-05-10 | 3.99 | 3 | SO62995 | 2024-05-17 | 0.32 | 1.49 | |
SO69687_2 | 100 | 15316 | 480 | 2 | 4 | 2024-08-24 | 0.06 | 2024-08-12 | 2.29 | 2 | SO69687 | 2024-08-19 | 0.18 | 0.86 |
SO46424_1 | 100 | 12435 | 312 | 4 | 2022-09-28 | 89.46 | 2022-09-16 | 3578.27 | 1 | SO46424 | 2022-09-23 | 286.26 | 2171.29 | |
SO56348_3 | 100 | 25023 | 480 | 4 | 2024-02-10 | 0.06 | 2024-01-29 | 2.29 | 3 | SO56348 | 2024-02-05 | 0.18 | 0.86 | |
SO62995_4 | 100 | 22718 | 214 | 4 | 2024-05-22 | 0.87 | 2024-05-10 | 34.99 | 4 | SO62995 | 2024-05-17 | 2.80 | 13.09 | |
SO69688_1 | 100 | 14615 | 528 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 1 | SO69688 | 2024-08-19 | 0.40 | 1.87 | |
SO46426_1 | 100 | 26107 | 344 | 4 | 2022-09-28 | 85.00 | 2022-09-16 | 3399.99 | 1 | SO46426 | 2022-09-23 | 272.00 | 1912.15 | |
SO56350_1 | 100 | 22138 | 536 | 4 | 2024-02-10 | 0.75 | 2024-01-29 | 29.99 | 1 | SO56350 | 2024-02-05 | 2.40 | 11.22 | |
SO62996_1 | 100 | 17497 | 581 | 4 | 2024-05-22 | 42.52 | 2024-05-10 | 1700.99 | 1 | SO62996 | 2024-05-17 | 136.08 | 1082.51 | |
SO69688_2 | 100 | 14615 | 478 | 4 | 2024-08-24 | 0.25 | 2024-08-12 | 9.99 | 2 | SO69688 | 2024-08-19 | 0.80 | 3.74 | |
SO46432_1 | 100 | 15016 | 342 | 4 | 2022-09-29 | 17.48 | 2022-09-17 | 699.10 | 1 | SO46432 | 2022-09-24 | 55.93 | 413.15 | |
SO56350_2 | 100 | 22138 | 528 | 4 | 2024-02-10 | 0.12 | 2024-01-29 | 4.99 | 2 | SO56350 | 2024-02-05 | 0.40 | 1.87 | |
SO62996_2 | 100 | 17497 | 479 | 4 | 2024-05-22 | 0.22 | 2024-05-10 | 8.99 | 2 | SO62996 | 2024-05-17 | 0.72 | 3.36 | |
SO69688_3 | 100 | 14615 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 3 | SO69688 | 2024-08-19 | 0.40 | 1.87 | |
SO46438_1 | 100 | 12174 | 313 | 4 | 2022-09-30 | 89.46 | 2022-09-18 | 3578.27 | 1 | SO46438 | 2022-09-25 | 286.26 | 2171.29 | |
SO56350_3 | 100 | 22138 | 480 | 4 | 2024-02-10 | 0.06 | 2024-01-29 | 2.29 | 3 | SO56350 | 2024-02-05 | 0.18 | 0.86 | |
SO62996_3 | 100 | 17497 | 477 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 3 | SO62996 | 2024-05-17 | 0.40 | 1.87 | |
SO69688_4 | 100 | 14615 | 225 | 4 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 4 | SO69688 | 2024-08-19 | 0.72 | 6.92 | |
SO46450_1 | 100 | 12446 | 314 | 4 | 2022-10-02 | 89.46 | 2022-09-20 | 3578.27 | 1 | SO46450 | 2022-09-27 | 286.26 | 2171.29 | |
SO56352_1 | 100 | 20503 | 478 | 4 | 2024-02-10 | 0.25 | 2024-01-29 | 9.99 | 1 | SO56352 | 2024-02-05 | 0.80 | 3.74 | |
SO62996_4 | 100 | 17497 | 480 | 4 | 2024-05-22 | 0.06 | 2024-05-10 | 2.29 | 4 | SO62996 | 2024-05-17 | 0.18 | 0.86 |
Generated 2024-11-11 02:15:41.295 UTC