[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1819 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55866_1 | 100 | 15685 | 564 | 8 | 2023-12-11 | 59.60 | 2023-11-29 | 2384.07 | 1 | SO55866 | 2023-12-06 | 190.73 | 1481.94 | |
SO62216_1 | 100 | 26963 | 578 | 8 | 2024-03-19 | 30.37 | 2024-03-07 | 1214.85 | 1 | SO62216 | 2024-03-14 | 97.19 | 755.15 | |
SO44805_1 | 100 | 29011 | 314 | 4 | 2022-02-02 | 89.46 | 2022-01-21 | 3578.27 | 1 | SO44805 | 2022-01-28 | 286.26 | 2171.29 | |
SO55866_2 | 100 | 15685 | 214 | 8 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 2 | SO55866 | 2023-12-06 | 2.80 | 13.09 | |
SO62216_2 | 100 | 26963 | 479 | 8 | 2024-03-19 | 0.22 | 2024-03-07 | 8.99 | 2 | SO62216 | 2024-03-14 | 0.72 | 3.36 | |
SO44806_1 | 6 | 18452 | 311 | 9 | 2022-02-02 | 89.46 | 2022-01-21 | 3578.27 | 1 | SO44806 | 2022-01-28 | 286.26 | 2171.29 | |
SO55866_3 | 100 | 15685 | 225 | 8 | 2023-12-11 | 0.22 | 2023-11-29 | 8.99 | 3 | SO55866 | 2023-12-06 | 0.72 | 6.92 | |
SO62216_3 | 100 | 26963 | 477 | 8 | 2024-03-19 | 0.12 | 2024-03-07 | 4.99 | 3 | SO62216 | 2024-03-14 | 0.40 | 1.87 | |
SO44807_1 | 6 | 11365 | 350 | 9 | 2022-02-02 | 84.37 | 2022-01-21 | 3374.99 | 1 | SO44807 | 2022-01-28 | 270.00 | 1898.09 | |
SO55867_1 | 6 | 16522 | 384 | 9 | 2023-12-12 | 28.01 | 2023-11-30 | 1120.49 | 1 | SO55867 | 2023-12-07 | 89.64 | 713.08 | |
SO62216_4 | 100 | 26963 | 225 | 8 | 2024-03-19 | 0.22 | 2024-03-07 | 8.99 | 4 | SO62216 | 2024-03-14 | 0.72 | 6.92 | |
SO44808_1 | 29 | 13836 | 311 | 8 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44808 | 2022-01-29 | 286.26 | 2171.29 | |
SO55868_1 | 100 | 11583 | 359 | 7 | 2023-12-12 | 57.37 | 2023-11-30 | 2294.99 | 1 | SO55868 | 2023-12-07 | 183.60 | 1251.98 | |
SO62217_1 | 6 | 23432 | 583 | 9 | 2024-03-19 | 42.52 | 2024-03-07 | 1700.99 | 1 | SO62217 | 2024-03-14 | 136.08 | 1082.51 | |
SO44809_1 | 98 | 20552 | 342 | 10 | 2022-02-03 | 17.48 | 2022-01-22 | 699.10 | 1 | SO44809 | 2022-01-29 | 55.93 | 413.15 | |
SO55868_2 | 100 | 11583 | 478 | 7 | 2023-12-12 | 0.25 | 2023-11-30 | 9.99 | 2 | SO55868 | 2023-12-07 | 0.80 | 3.74 | |
SO62217_2 | 6 | 23432 | 214 | 9 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 2 | SO62217 | 2024-03-14 | 2.80 | 13.09 | |
SO44810_1 | 100 | 29126 | 311 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44810 | 2022-01-29 | 286.26 | 2171.29 | |
SO55868_3 | 100 | 11583 | 477 | 7 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 3 | SO55868 | 2023-12-07 | 0.40 | 1.87 | |
SO62218_1 | 6 | 20613 | 378 | 9 | 2024-03-19 | 61.08 | 2024-03-07 | 2443.35 | 1 | SO62218 | 2024-03-14 | 195.47 | 1554.95 | |
SO44811_1 | 19 | 22732 | 311 | 6 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44811 | 2022-01-29 | 286.26 | 2171.29 | |
SO55869_1 | 98 | 12272 | 361 | 10 | 2023-12-12 | 57.37 | 2023-11-30 | 2294.99 | 1 | SO55869 | 2023-12-07 | 183.60 | 1251.98 | |
SO62218_2 | 6 | 20613 | 214 | 9 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 2 | SO62218 | 2024-03-14 | 2.80 | 13.09 | |
SO44812_1 | 100 | 28988 | 314 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44812 | 2022-01-29 | 286.26 | 2171.29 | |
SO55869_2 | 98 | 12272 | 485 | 10 | 2023-12-12 | 0.55 | 2023-11-30 | 21.98 | 2 | SO55869 | 2023-12-07 | 1.76 | 8.22 | |
SO62219_1 | 6 | 25234 | 390 | 9 | 2024-03-19 | 28.01 | 2024-03-07 | 1120.49 | 1 | SO62219 | 2024-03-14 | 89.64 | 713.08 | |
SO44813_1 | 6 | 18695 | 312 | 9 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44813 | 2022-01-29 | 286.26 | 2171.29 | |
SO55870_1 | 98 | 12210 | 357 | 2 | 10 | 2023-12-12 | 58.00 | 2023-11-30 | 2319.99 | 1 | SO55870 | 2023-12-07 | 185.60 | 1265.62 |
SO62219_2 | 6 | 25234 | 491 | 9 | 2024-03-19 | 1.35 | 2024-03-07 | 53.99 | 2 | SO62219 | 2024-03-14 | 4.32 | 41.57 | |
SO44814_1 | 6 | 18281 | 313 | 9 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44814 | 2022-01-29 | 286.26 | 2171.29 | |
SO55870_2 | 98 | 12210 | 478 | 10 | 2023-12-12 | 0.25 | 2023-11-30 | 9.99 | 2 | SO55870 | 2023-12-07 | 0.80 | 3.74 | |
SO62220_1 | 6 | 13115 | 359 | 9 | 2024-03-19 | 57.37 | 2024-03-07 | 2294.99 | 1 | SO62220 | 2024-03-14 | 183.60 | 1251.98 | |
SO44815_1 | 6 | 11444 | 351 | 9 | 2022-02-03 | 84.37 | 2022-01-22 | 3374.99 | 1 | SO44815 | 2022-01-29 | 270.00 | 1898.09 | |
SO55870_3 | 98 | 12210 | 477 | 10 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 3 | SO55870 | 2023-12-07 | 0.40 | 1.87 | |
SO62220_2 | 6 | 13115 | 480 | 9 | 2024-03-19 | 0.06 | 2024-03-07 | 2.29 | 2 | SO62220 | 2024-03-14 | 0.18 | 0.86 | |
SO44816_1 | 39 | 12321 | 312 | 7 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44816 | 2022-01-30 | 286.26 | 2171.29 | |
SO55871_1 | 6 | 15261 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 1 | SO55871 | 2023-12-07 | 0.32 | 1.49 | |
SO62221_1 | 6 | 13131 | 363 | 2 | 9 | 2024-03-19 | 57.37 | 2024-03-07 | 2294.99 | 1 | SO62221 | 2024-03-14 | 183.60 | 1251.98 |
SO44817_1 | 98 | 14777 | 312 | 10 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44817 | 2022-01-30 | 286.26 | 2171.29 | |
SO55871_2 | 6 | 15261 | 539 | 9 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 2 | SO55871 | 2023-12-07 | 2.00 | 9.35 | |
SO62222_1 | 6 | 11031 | 357 | 9 | 2024-03-19 | 58.00 | 2024-03-07 | 2319.99 | 1 | SO62222 | 2024-03-14 | 185.60 | 1265.62 | |
SO44818_1 | 100 | 28827 | 313 | 4 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44818 | 2022-01-30 | 286.26 | 2171.29 | |
SO55871_3 | 6 | 15261 | 465 | 9 | 2023-12-12 | 0.61 | 2023-11-30 | 24.49 | 3 | SO55871 | 2023-12-07 | 1.96 | 9.16 | |
SO62222_2 | 6 | 11031 | 480 | 9 | 2024-03-19 | 0.06 | 2024-03-07 | 2.29 | 2 | SO62222 | 2024-03-14 | 0.18 | 0.86 | |
SO44819_1 | 100 | 28853 | 313 | 1 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44819 | 2022-01-30 | 286.26 | 2171.29 | |
SO55872_1 | 6 | 24375 | 538 | 9 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 1 | SO55872 | 2023-12-07 | 1.72 | 8.04 | |
SO62223_1 | 100 | 25421 | 577 | 1 | 2024-03-19 | 30.37 | 2024-03-07 | 1214.85 | 1 | SO62223 | 2024-03-14 | 97.19 | 755.15 | |
SO44820_1 | 100 | 25972 | 350 | 1 | 2022-02-04 | 84.37 | 2022-01-23 | 3374.99 | 1 | SO44820 | 2022-01-30 | 270.00 | 1898.09 | |
SO55872_2 | 6 | 24375 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 2 | SO55872 | 2023-12-07 | 0.18 | 0.86 | |
SO62223_2 | 100 | 25421 | 222 | 1 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 2 | SO62223 | 2024-03-14 | 2.80 | 13.09 | |
SO44821_1 | 100 | 25975 | 345 | 1 | 2022-02-04 | 85.00 | 2022-01-23 | 3399.99 | 1 | SO44821 | 2022-01-30 | 272.00 | 1912.15 | |
SO55872_3 | 6 | 24375 | 484 | 9 | 2023-12-12 | 0.20 | 2023-11-30 | 7.95 | 3 | SO55872 | 2023-12-07 | 0.64 | 2.97 | |
SO62224_1 | 100 | 26617 | 586 | 4 | 2024-03-19 | 18.56 | 2024-03-07 | 742.35 | 1 | SO62224 | 2024-03-14 | 59.39 | 461.44 | |
SO44822_1 | 6 | 18486 | 311 | 9 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44822 | 2022-01-30 | 286.26 | 2171.29 | |
SO55873_1 | 6 | 29116 | 478 | 9 | 2023-12-12 | 0.25 | 2023-11-30 | 9.99 | 1 | SO55873 | 2023-12-07 | 0.80 | 3.74 | |
SO62224_2 | 100 | 26617 | 477 | 4 | 2024-03-19 | 0.12 | 2024-03-07 | 4.99 | 2 | SO62224 | 2024-03-14 | 0.40 | 1.87 | |
SO44823_1 | 6 | 18488 | 313 | 9 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44823 | 2022-01-30 | 286.26 | 2171.29 | |
SO55873_2 | 6 | 29116 | 477 | 9 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 2 | SO55873 | 2023-12-07 | 0.40 | 1.87 | |
SO62224_3 | 100 | 26617 | 479 | 4 | 2024-03-19 | 0.22 | 2024-03-07 | 8.99 | 3 | SO62224 | 2024-03-14 | 0.72 | 3.36 | |
SO44824_1 | 6 | 18694 | 312 | 9 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44824 | 2022-01-30 | 286.26 | 2171.29 | |
SO55873_3 | 6 | 29116 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 3 | SO55873 | 2023-12-07 | 0.18 | 0.86 | |
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 | |
SO44825_1 | 6 | 18309 | 312 | 9 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44825 | 2022-01-30 | 286.26 | 2171.29 | |
SO55874_1 | 6 | 16615 | 540 | 9 | 2023-12-12 | 0.82 | 2023-11-30 | 32.60 | 1 | SO55874 | 2023-12-07 | 2.61 | 12.19 | |
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 | |
SO44826_1 | 39 | 12308 | 314 | 7 | 2022-02-05 | 89.46 | 2022-01-24 | 3578.27 | 1 | SO44826 | 2022-01-31 | 286.26 | 2171.29 | |
SO55874_2 | 6 | 16615 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 2 | SO55874 | 2023-12-07 | 0.32 | 1.49 | |
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 | |
SO44827_1 | 100 | 25973 | 344 | 1 | 2022-02-05 | 85.00 | 2022-01-24 | 3399.99 | 1 | SO44827 | 2022-01-31 | 272.00 | 1912.15 | |
SO55874_3 | 6 | 16615 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 3 | SO55874 | 2023-12-07 | 0.18 | 0.86 | |
SO62226_1 | 19 | 19681 | 388 | 6 | 2024-03-19 | 28.01 | 2024-03-07 | 1120.49 | 1 | SO62226 | 2024-03-14 | 89.64 | 713.08 | |
SO44828_1 | 100 | 28997 | 312 | 4 | 2022-02-05 | 89.46 | 2022-01-24 | 3578.27 | 1 | SO44828 | 2022-01-31 | 286.26 | 2171.29 | |
SO55875_1 | 6 | 18271 | 225 | 9 | 2023-12-12 | 0.22 | 2023-11-30 | 8.99 | 1 | SO55875 | 2023-12-07 | 0.72 | 6.92 | |
SO62226_2 | 19 | 19681 | 214 | 6 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 2 | SO62226 | 2024-03-14 | 2.80 | 13.09 | |
SO44829_1 | 100 | 14643 | 334 | 1 | 2022-02-05 | 17.48 | 2022-01-24 | 699.10 | 1 | SO44829 | 2022-01-31 | 55.93 | 413.15 | |
SO55876_1 | 6 | 14683 | 487 | 9 | 2023-12-12 | 1.37 | 2023-11-30 | 54.99 | 1 | SO55876 | 2023-12-07 | 4.40 | 20.57 | |
SO62226_3 | 19 | 19681 | 467 | 2 | 6 | 2024-03-19 | 0.61 | 2024-03-07 | 24.49 | 3 | SO62226 | 2024-03-14 | 1.96 | 9.16 |
SO44830_1 | 6 | 18337 | 314 | 9 | 2022-02-05 | 89.46 | 2022-01-24 | 3578.27 | 1 | SO44830 | 2022-01-31 | 286.26 | 2171.29 | |
SO55877_1 | 19 | 11619 | 488 | 6 | 2023-12-12 | 1.35 | 2023-11-30 | 53.99 | 1 | SO55877 | 2023-12-07 | 4.32 | 41.57 | |
SO62227_1 | 19 | 17025 | 225 | 6 | 2024-03-19 | 0.22 | 2024-03-07 | 8.99 | 1 | SO62227 | 2024-03-14 | 0.72 | 6.92 | |
SO44831_1 | 29 | 29467 | 350 | 8 | 2022-02-06 | 84.37 | 2022-01-25 | 3374.99 | 1 | SO44831 | 2022-02-01 | 270.00 | 1898.09 | |
SO55877_2 | 19 | 11619 | 465 | 6 | 2023-12-12 | 0.61 | 2023-11-30 | 24.49 | 2 | SO55877 | 2023-12-07 | 1.96 | 9.16 | |
SO62227_2 | 19 | 17025 | 583 | 6 | 2024-03-19 | 42.52 | 2024-03-07 | 1700.99 | 2 | SO62227 | 2024-03-14 | 136.08 | 1082.51 | |
SO44832_1 | 100 | 28804 | 311 | 4 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44832 | 2022-02-01 | 286.26 | 2171.29 | |
SO55878_1 | 100 | 11622 | 480 | 1 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 1 | SO55878 | 2023-12-07 | 0.18 | 0.86 | |
SO62228_1 | 100 | 20059 | 390 | 7 | 2024-03-19 | 28.01 | 2024-03-07 | 1120.49 | 1 | SO62228 | 2024-03-14 | 89.64 | 713.08 | |
SO44833_1 | 100 | 28842 | 310 | 4 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44833 | 2022-02-01 | 286.26 | 2171.29 | |
SO55879_1 | 6 | 11749 | 535 | 9 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 1 | SO55879 | 2023-12-07 | 2.00 | 9.35 | |
SO62228_2 | 100 | 20059 | 237 | 7 | 2024-03-19 | 1.25 | 2024-03-07 | 49.99 | 2 | SO62228 | 2024-03-14 | 4.00 | 38.49 | |
SO44834_1 | 100 | 25952 | 350 | 4 | 2022-02-06 | 84.37 | 2022-01-25 | 3374.99 | 1 | SO44834 | 2022-02-01 | 270.00 | 1898.09 | |
SO55880_1 | 19 | 11277 | 529 | 6 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 1 | SO55880 | 2023-12-07 | 0.32 | 1.49 | |
SO62229_1 | 100 | 23226 | 605 | 8 | 2024-03-19 | 13.50 | 2024-03-07 | 539.99 | 1 | SO62229 | 2024-03-14 | 43.20 | 343.65 | |
SO44835_1 | 6 | 18338 | 311 | 9 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44835 | 2022-02-01 | 286.26 | 2171.29 | |
SO55880_2 | 19 | 11277 | 222 | 6 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 2 | SO55880 | 2023-12-07 | 2.80 | 13.09 | |
SO62229_2 | 100 | 23226 | 479 | 8 | 2024-03-19 | 0.22 | 2024-03-07 | 8.99 | 2 | SO62229 | 2024-03-14 | 0.72 | 3.36 | |
SO44836_1 | 6 | 18465 | 314 | 9 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44836 | 2022-02-01 | 286.26 | 2171.29 |
Generated 2024-09-20 19:25:45.528 UTC