[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 338 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44872_1 | 100 | 29111 | 312 | 4 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44872 | 2022-02-06 | 286.26 | 2171.29 | |
SO55770_1 | 100 | 15273 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55770 | 2023-12-05 | 0.40 | 1.87 | |
SO44873_1 | 100 | 28828 | 312 | 4 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44873 | 2022-02-06 | 286.26 | 2171.29 | |
SO55770_2 | 100 | 15273 | 222 | 4 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO55770 | 2023-12-05 | 2.80 | 13.09 | |
SO44875_1 | 100 | 29048 | 313 | 4 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44875 | 2022-02-07 | 286.26 | 2171.29 | |
SO55770_3 | 100 | 15273 | 471 | 4 | 2023-12-10 | 1.59 | 2023-11-28 | 63.50 | 3 | SO55770 | 2023-12-05 | 5.08 | 23.75 | |
SO44876_1 | 100 | 29056 | 312 | 4 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44876 | 2022-02-07 | 286.26 | 2171.29 | |
SO55782_1 | 100 | 11499 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55782 | 2023-12-05 | 0.40 | 1.87 | |
SO44877_1 | 100 | 29136 | 311 | 4 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44877 | 2022-02-07 | 286.26 | 2171.29 | |
SO55782_2 | 100 | 11499 | 537 | 4 | 2023-12-10 | 0.88 | 2023-11-28 | 35.00 | 2 | SO55782 | 2023-12-05 | 2.80 | 13.09 | |
SO44886_1 | 100 | 29108 | 314 | 4 | 2022-02-13 | 89.46 | 2022-02-01 | 3578.27 | 1 | SO44886 | 2022-02-08 | 286.26 | 2171.29 | |
SO55782_3 | 100 | 11499 | 485 | 4 | 2023-12-10 | 0.55 | 2023-11-28 | 21.98 | 3 | SO55782 | 2023-12-05 | 1.76 | 8.22 | |
SO44891_1 | 100 | 28847 | 310 | 4 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44891 | 2022-02-09 | 286.26 | 2171.29 | |
SO55782_4 | 100 | 11499 | 484 | 4 | 2023-12-10 | 0.20 | 2023-11-28 | 7.95 | 4 | SO55782 | 2023-12-05 | 0.64 | 2.97 | |
SO44894_1 | 100 | 25943 | 348 | 4 | 2022-02-14 | 84.37 | 2022-02-02 | 3374.99 | 1 | SO44894 | 2022-02-09 | 270.00 | 1898.09 | |
SO55786_1 | 100 | 12960 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55786 | 2023-12-05 | 0.40 | 1.87 | |
SO44895_1 | 100 | 25951 | 351 | 4 | 2022-02-14 | 84.37 | 2022-02-02 | 3374.99 | 1 | SO44895 | 2022-02-09 | 270.00 | 1898.09 | |
SO55786_2 | 100 | 12960 | 537 | 4 | 2023-12-10 | 0.88 | 2023-11-28 | 35.00 | 2 | SO55786 | 2023-12-05 | 2.80 | 13.09 | |
SO44908_1 | 100 | 29032 | 314 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44908 | 2022-02-11 | 286.26 | 2171.29 | |
SO55786_3 | 100 | 12960 | 480 | 4 | 2023-12-10 | 0.06 | 2023-11-28 | 2.29 | 3 | SO55786 | 2023-12-05 | 0.18 | 0.86 | |
SO44909_1 | 100 | 28840 | 310 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44909 | 2022-02-11 | 286.26 | 2171.29 | |
SO55790_1 | 100 | 19111 | 594 | 4 | 2023-12-10 | 14.12 | 2023-11-28 | 564.99 | 1 | SO55790 | 2023-12-05 | 45.20 | 308.22 | |
SO44910_1 | 100 | 25969 | 344 | 4 | 2022-02-16 | 85.00 | 2022-02-04 | 3399.99 | 1 | SO44910 | 2022-02-11 | 272.00 | 1912.15 | |
SO55790_2 | 100 | 19111 | 535 | 4 | 2023-12-10 | 0.62 | 2023-11-28 | 24.99 | 2 | SO55790 | 2023-12-05 | 2.00 | 9.35 | |
SO44911_1 | 100 | 25976 | 349 | 4 | 2022-02-16 | 84.37 | 2022-02-04 | 3374.99 | 1 | SO44911 | 2022-02-11 | 270.00 | 1898.09 | |
SO55790_3 | 100 | 19111 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 3 | SO55790 | 2023-12-05 | 0.40 | 1.87 | |
SO44912_1 | 100 | 28966 | 310 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44912 | 2022-02-11 | 286.26 | 2171.29 | |
SO55790_4 | 100 | 19111 | 478 | 4 | 2023-12-10 | 0.25 | 2023-11-28 | 9.99 | 4 | SO55790 | 2023-12-05 | 0.80 | 3.74 | |
SO44920_1 | 100 | 14648 | 338 | 4 | 2022-02-17 | 17.48 | 2022-02-05 | 699.10 | 1 | SO44920 | 2022-02-12 | 55.93 | 413.15 | |
SO55790_5 | 100 | 19111 | 477 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 5 | SO55790 | 2023-12-05 | 0.40 | 1.87 | |
SO44930_1 | 100 | 29110 | 312 | 4 | 2022-02-19 | 89.46 | 2022-02-07 | 3578.27 | 1 | SO44930 | 2022-02-14 | 286.26 | 2171.29 | |
SO55791_1 | 100 | 13068 | 595 | 4 | 2023-12-10 | 14.12 | 2023-11-28 | 564.99 | 1 | SO55791 | 2023-12-05 | 45.20 | 308.22 | |
SO44950_1 | 100 | 28835 | 313 | 4 | 2022-02-21 | 89.46 | 2022-02-09 | 3578.27 | 1 | SO44950 | 2022-02-16 | 286.26 | 2171.29 | |
SO55791_2 | 100 | 13068 | 477 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 2 | SO55791 | 2023-12-05 | 0.40 | 1.87 | |
SO44951_1 | 100 | 28843 | 311 | 4 | 2022-02-21 | 89.46 | 2022-02-09 | 3578.27 | 1 | SO44951 | 2022-02-16 | 286.26 | 2171.29 | |
SO55791_3 | 100 | 13068 | 478 | 4 | 2023-12-10 | 0.25 | 2023-11-28 | 9.99 | 3 | SO55791 | 2023-12-05 | 0.80 | 3.74 | |
SO44952_1 | 100 | 25955 | 349 | 4 | 2022-02-21 | 84.37 | 2022-02-09 | 3374.99 | 1 | SO44952 | 2022-02-16 | 270.00 | 1898.09 | |
SO55791_4 | 100 | 13068 | 489 | 4 | 2023-12-10 | 1.35 | 2023-11-28 | 53.99 | 4 | SO55791 | 2023-12-05 | 4.32 | 41.57 | |
SO44954_1 | 100 | 28990 | 310 | 4 | 2022-02-21 | 89.46 | 2022-02-09 | 3578.27 | 1 | SO44954 | 2022-02-16 | 286.26 | 2171.29 | |
SO55792_1 | 100 | 13993 | 587 | 4 | 2023-12-10 | 19.24 | 2023-11-28 | 769.49 | 1 | SO55792 | 2023-12-05 | 61.56 | 419.78 | |
SO55792_2 | 100 | 13993 | 214 | 4 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO55792 | 2023-12-05 | 2.80 | 13.09 | |
SO55795_1 | 100 | 12438 | 357 | 2 | 4 | 2023-12-10 | 58.00 | 2023-11-28 | 2319.99 | 1 | SO55795 | 2023-12-05 | 185.60 | 1265.62 |
SO55803_1 | 100 | 24347 | 573 | 4 | 2023-12-10 | 59.60 | 2023-11-28 | 2384.07 | 1 | SO55803 | 2023-12-05 | 190.73 | 1481.94 | |
SO55803_2 | 100 | 24347 | 214 | 4 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO55803 | 2023-12-05 | 2.80 | 13.09 | |
SO55804_1 | 100 | 24351 | 564 | 4 | 2023-12-10 | 59.60 | 2023-11-28 | 2384.07 | 1 | SO55804 | 2023-12-05 | 190.73 | 1481.94 | |
SO55804_2 | 100 | 24351 | 225 | 4 | 2023-12-10 | 0.22 | 2023-11-28 | 8.99 | 2 | SO55804 | 2023-12-05 | 0.72 | 6.92 | |
SO62224_4 | 100 | 26617 | 489 | 4 | 2024-03-19 | 1.35 | 2024-03-07 | 53.99 | 4 | SO62224 | 2024-03-14 | 4.32 | 41.57 | |
SO62225_1 | 100 | 26058 | 563 | 4 | 2024-03-19 | 59.60 | 2024-03-07 | 2384.07 | 1 | SO62225 | 2024-03-14 | 190.73 | 1481.94 | |
SO62225_2 | 100 | 26058 | 489 | 4 | 2024-03-19 | 1.35 | 2024-03-07 | 53.99 | 2 | SO62225 | 2024-03-14 | 4.32 | 41.57 | |
SO62233_1 | 100 | 11949 | 222 | 4 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 1 | SO62233 | 2024-03-15 | 2.80 | 13.09 | |
SO62246_1 | 100 | 11230 | 529 | 4 | 2024-03-20 | 0.10 | 2024-03-08 | 3.99 | 1 | SO62246 | 2024-03-15 | 0.32 | 1.49 | |
SO62246_2 | 100 | 11230 | 484 | 4 | 2024-03-20 | 0.20 | 2024-03-08 | 7.95 | 2 | SO62246 | 2024-03-15 | 0.64 | 2.97 | |
SO62254_1 | 100 | 21761 | 478 | 4 | 2024-03-20 | 0.25 | 2024-03-08 | 9.99 | 1 | SO62254 | 2024-03-15 | 0.80 | 3.74 | |
SO62254_2 | 100 | 21761 | 477 | 4 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 2 | SO62254 | 2024-03-15 | 0.40 | 1.87 | |
SO62254_3 | 100 | 21761 | 483 | 4 | 2024-03-20 | 3.00 | 2024-03-08 | 120.00 | 3 | SO62254 | 2024-03-15 | 9.60 | 44.88 | |
SO62257_1 | 100 | 20435 | 478 | 4 | 2024-03-20 | 0.25 | 2024-03-08 | 9.99 | 1 | SO62257 | 2024-03-15 | 0.80 | 3.74 | |
SO62257_2 | 100 | 20435 | 477 | 4 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 2 | SO62257 | 2024-03-15 | 0.40 | 1.87 | |
SO62257_3 | 100 | 20435 | 217 | 4 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 3 | SO62257 | 2024-03-15 | 2.80 | 13.09 | |
SO62259_1 | 100 | 17179 | 477 | 4 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 1 | SO62259 | 2024-03-15 | 0.40 | 1.87 | |
SO62259_2 | 100 | 17179 | 465 | 4 | 2024-03-20 | 0.61 | 2024-03-08 | 24.49 | 2 | SO62259 | 2024-03-15 | 1.96 | 9.16 | |
SO62260_1 | 100 | 15545 | 528 | 4 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 1 | SO62260 | 2024-03-15 | 0.40 | 1.87 | |
SO62260_2 | 100 | 15545 | 222 | 4 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 2 | SO62260 | 2024-03-15 | 2.80 | 13.09 | |
SO62269_1 | 100 | 13162 | 471 | 4 | 2024-03-20 | 1.59 | 2024-03-08 | 63.50 | 1 | SO62269 | 2024-03-15 | 5.08 | 23.75 | |
SO62269_2 | 100 | 13162 | 485 | 4 | 2024-03-20 | 0.55 | 2024-03-08 | 21.98 | 2 | SO62269 | 2024-03-15 | 1.76 | 8.22 | |
SO62278_1 | 100 | 25432 | 579 | 4 | 2024-03-20 | 30.37 | 2024-03-08 | 1214.85 | 1 | SO62278 | 2024-03-15 | 97.19 | 755.15 | |
SO62278_2 | 100 | 25432 | 222 | 4 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 2 | SO62278 | 2024-03-15 | 2.80 | 13.09 | |
SO62280_1 | 100 | 17566 | 580 | 4 | 2024-03-20 | 42.52 | 2024-03-08 | 1700.99 | 1 | SO62280 | 2024-03-15 | 136.08 | 1082.51 | |
SO62280_2 | 100 | 17566 | 214 | 4 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 2 | SO62280 | 2024-03-15 | 2.80 | 13.09 | |
SO62296_1 | 100 | 11704 | 488 | 4 | 2024-03-21 | 1.35 | 2024-03-09 | 53.99 | 1 | SO62296 | 2024-03-16 | 4.32 | 41.57 | |
SO62300_1 | 100 | 26478 | 535 | 4 | 2024-03-21 | 0.62 | 2024-03-09 | 24.99 | 1 | SO62300 | 2024-03-16 | 2.00 | 9.35 | |
SO62300_2 | 100 | 26478 | 465 | 4 | 2024-03-21 | 0.61 | 2024-03-09 | 24.49 | 2 | SO62300 | 2024-03-16 | 1.96 | 9.16 | |
SO62304_1 | 100 | 22746 | 536 | 4 | 2024-03-21 | 0.75 | 2024-03-09 | 29.99 | 1 | SO62304 | 2024-03-16 | 2.40 | 11.22 | |
SO62304_2 | 100 | 22746 | 480 | 2 | 4 | 2024-03-21 | 0.06 | 2024-03-09 | 2.29 | 2 | SO62304 | 2024-03-16 | 0.18 | 0.86 |
SO62304_3 | 100 | 22746 | 484 | 4 | 2024-03-21 | 0.20 | 2024-03-09 | 7.95 | 3 | SO62304 | 2024-03-16 | 0.64 | 2.97 | |
SO62305_1 | 100 | 23286 | 536 | 4 | 2024-03-21 | 0.75 | 2024-03-09 | 29.99 | 1 | SO62305 | 2024-03-16 | 2.40 | 11.22 | |
SO62309_1 | 100 | 19890 | 475 | 4 | 2024-03-21 | 1.75 | 2024-03-09 | 69.99 | 1 | SO62309 | 2024-03-16 | 5.60 | 26.18 | |
SO62309_2 | 100 | 19890 | 234 | 4 | 2024-03-21 | 1.25 | 2024-03-09 | 49.99 | 2 | SO62309 | 2024-03-16 | 4.00 | 38.49 | |
SO62311_1 | 100 | 18100 | 477 | 4 | 2024-03-21 | 0.12 | 2024-03-09 | 4.99 | 1 | SO62311 | 2024-03-16 | 0.40 | 1.87 | |
SO62311_2 | 100 | 18100 | 487 | 4 | 2024-03-21 | 1.37 | 2024-03-09 | 54.99 | 2 | SO62311 | 2024-03-16 | 4.40 | 20.57 | |
SO62312_1 | 100 | 20271 | 474 | 4 | 2024-03-21 | 1.75 | 2024-03-09 | 69.99 | 1 | SO62312 | 2024-03-16 | 5.60 | 26.18 | |
SO62312_2 | 100 | 20271 | 234 | 4 | 2024-03-21 | 1.25 | 2024-03-09 | 49.99 | 2 | SO62312 | 2024-03-16 | 4.00 | 38.49 | |
SO62327_1 | 100 | 11737 | 528 | 4 | 2024-03-21 | 0.12 | 2024-03-09 | 4.99 | 1 | SO62327 | 2024-03-16 | 0.40 | 1.87 | |
SO62327_2 | 100 | 11737 | 537 | 4 | 2024-03-21 | 0.88 | 2024-03-09 | 35.00 | 2 | SO62327 | 2024-03-16 | 2.80 | 13.09 | |
SO62327_3 | 100 | 11737 | 480 | 4 | 2024-03-21 | 0.06 | 2024-03-09 | 2.29 | 3 | SO62327 | 2024-03-16 | 0.18 | 0.86 | |
SO62328_1 | 100 | 11975 | 537 | 4 | 2024-03-21 | 0.88 | 2024-03-09 | 35.00 | 1 | SO62328 | 2024-03-16 | 2.80 | 13.09 | |
SO62328_2 | 100 | 11975 | 528 | 4 | 2024-03-21 | 0.12 | 2024-03-09 | 4.99 | 2 | SO62328 | 2024-03-16 | 0.40 | 1.87 | |
SO62328_3 | 100 | 11975 | 483 | 4 | 2024-03-21 | 3.00 | 2024-03-09 | 120.00 | 3 | SO62328 | 2024-03-16 | 9.60 | 44.88 | |
SO62330_1 | 100 | 19723 | 592 | 4 | 2024-03-21 | 14.12 | 2024-03-09 | 564.99 | 1 | SO62330 | 2024-03-16 | 45.20 | 308.22 | |
SO62330_2 | 100 | 19723 | 478 | 4 | 2024-03-21 | 0.25 | 2024-03-09 | 9.99 | 2 | SO62330 | 2024-03-16 | 0.80 | 3.74 | |
SO62331_1 | 100 | 14442 | 361 | 4 | 2024-03-21 | 57.37 | 2024-03-09 | 2294.99 | 1 | SO62331 | 2024-03-16 | 183.60 | 1251.98 | |
SO62331_2 | 100 | 14442 | 537 | 4 | 2024-03-21 | 0.88 | 2024-03-09 | 35.00 | 2 | SO62331 | 2024-03-16 | 2.80 | 13.09 | |
SO62331_3 | 100 | 14442 | 528 | 4 | 2024-03-21 | 0.12 | 2024-03-09 | 4.99 | 3 | SO62331 | 2024-03-16 | 0.40 | 1.87 | |
SO62331_4 | 100 | 14442 | 214 | 4 | 2024-03-21 | 0.87 | 2024-03-09 | 34.99 | 4 | SO62331 | 2024-03-16 | 2.80 | 13.09 | |
SO62335_1 | 100 | 22789 | 606 | 4 | 2024-03-21 | 13.50 | 2024-03-09 | 539.99 | 1 | SO62335 | 2024-03-16 | 43.20 | 343.65 | |
SO62335_2 | 100 | 22789 | 214 | 4 | 2024-03-21 | 0.87 | 2024-03-09 | 34.99 | 2 | SO62335 | 2024-03-16 | 2.80 | 13.09 | |
SO62355_1 | 100 | 26674 | 541 | 4 | 2024-03-22 | 0.72 | 2024-03-10 | 28.99 | 1 | SO62355 | 2024-03-17 | 2.32 | 10.84 |
Generated 2024-09-20 19:28:54.082 UTC