[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 2425 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53414_2 | 19 | 11262 | 231 | 6 | 2023-12-27 | 1.25 | 2023-12-15 | 49.99 | 2 | SO53414 | 2023-12-22 | 4.00 | 38.49 | |
SO53418_1 | 19 | 15874 | 474 | 6 | 2023-12-27 | 1.75 | 2023-12-15 | 69.99 | 1 | SO53418 | 2023-12-22 | 5.60 | 26.18 | |
SO53419_1 | 19 | 16243 | 474 | 6 | 2023-12-27 | 1.75 | 2023-12-15 | 69.99 | 1 | SO53419 | 2023-12-22 | 5.60 | 26.18 | |
SO53420_1 | 19 | 25256 | 477 | 6 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 1 | SO53420 | 2023-12-22 | 0.40 | 1.87 | |
SO53420_2 | 19 | 25256 | 487 | 6 | 2023-12-27 | 1.37 | 2023-12-15 | 54.99 | 2 | SO53420 | 2023-12-22 | 4.40 | 20.57 | |
SO53420_3 | 19 | 25256 | 484 | 6 | 2023-12-27 | 0.20 | 2023-12-15 | 7.95 | 3 | SO53420 | 2023-12-22 | 0.64 | 2.97 | |
SO53423_1 | 19 | 29230 | 477 | 6 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 1 | SO53423 | 2023-12-22 | 0.40 | 1.87 | |
SO60200_1 | 19 | 11330 | 541 | 6 | 2024-04-13 | 0.72 | 2024-04-01 | 28.99 | 1 | SO60200 | 2024-04-08 | 2.32 | 10.84 | |
SO60200_2 | 19 | 11330 | 530 | 6 | 2024-04-13 | 0.12 | 2024-04-01 | 4.99 | 2 | SO60200 | 2024-04-08 | 0.40 | 1.87 | |
SO60200_3 | 19 | 11330 | 463 | 6 | 2024-04-13 | 0.61 | 2024-04-01 | 24.49 | 3 | SO60200 | 2024-04-08 | 1.96 | 9.16 | |
SO60201_1 | 19 | 11287 | 538 | 6 | 2024-04-13 | 0.54 | 2024-04-01 | 21.49 | 1 | SO60201 | 2024-04-08 | 1.72 | 8.04 | |
SO60201_2 | 19 | 11287 | 480 | 6 | 2024-04-13 | 0.06 | 2024-04-01 | 2.29 | 2 | SO60201 | 2024-04-08 | 0.18 | 0.86 | |
SO60205_1 | 19 | 19729 | 536 | 6 | 2024-04-13 | 0.75 | 2024-04-01 | 29.99 | 1 | SO60205 | 2024-04-08 | 2.40 | 11.22 | |
SO60205_2 | 19 | 19729 | 480 | 2 | 6 | 2024-04-13 | 0.06 | 2024-04-01 | 2.29 | 2 | SO60205 | 2024-04-08 | 0.18 | 0.86 |
SO60225_1 | 19 | 13760 | 537 | 6 | 2024-04-13 | 0.88 | 2024-04-01 | 35.00 | 1 | SO60225 | 2024-04-08 | 2.80 | 13.09 | |
SO60225_2 | 19 | 13760 | 528 | 6 | 2024-04-13 | 0.12 | 2024-04-01 | 4.99 | 2 | SO60225 | 2024-04-08 | 0.40 | 1.87 | |
SO60225_3 | 19 | 13760 | 217 | 6 | 2024-04-13 | 0.87 | 2024-04-01 | 34.99 | 3 | SO60225 | 2024-04-08 | 2.80 | 13.09 | |
SO60232_1 | 19 | 15175 | 363 | 6 | 2024-04-13 | 57.37 | 2024-04-01 | 2294.99 | 1 | SO60232 | 2024-04-08 | 183.60 | 1251.98 | |
SO60232_2 | 19 | 15175 | 528 | 6 | 2024-04-13 | 0.12 | 2024-04-01 | 4.99 | 2 | SO60232 | 2024-04-08 | 0.40 | 1.87 | |
SO60232_3 | 19 | 15175 | 537 | 6 | 2024-04-13 | 0.88 | 2024-04-01 | 35.00 | 3 | SO60232 | 2024-04-08 | 2.80 | 13.09 | |
SO60232_4 | 19 | 15175 | 480 | 6 | 2024-04-13 | 0.06 | 2024-04-01 | 2.29 | 4 | SO60232 | 2024-04-08 | 0.18 | 0.86 | |
SO60232_5 | 19 | 15175 | 225 | 6 | 2024-04-13 | 0.22 | 2024-04-01 | 8.99 | 5 | SO60232 | 2024-04-08 | 0.72 | 6.92 | |
SO60232_6 | 19 | 15175 | 483 | 6 | 2024-04-13 | 3.00 | 2024-04-01 | 120.00 | 6 | SO60232 | 2024-04-08 | 9.60 | 44.88 | |
SO60246_1 | 19 | 16996 | 581 | 6 | 2024-04-13 | 42.52 | 2024-04-01 | 1700.99 | 1 | SO60246 | 2024-04-08 | 136.08 | 1082.51 | |
SO60246_2 | 19 | 16996 | 489 | 6 | 2024-04-13 | 1.35 | 2024-04-01 | 53.99 | 2 | SO60246 | 2024-04-08 | 4.32 | 41.57 | |
SO60266_1 | 19 | 11331 | 541 | 6 | 2024-04-14 | 0.72 | 2024-04-02 | 28.99 | 1 | SO60266 | 2024-04-09 | 2.32 | 10.84 | |
SO60268_1 | 19 | 19642 | 530 | 6 | 2024-04-14 | 0.12 | 2024-04-02 | 4.99 | 1 | SO60268 | 2024-04-09 | 0.40 | 1.87 | |
SO60268_2 | 19 | 19642 | 217 | 6 | 2024-04-14 | 0.87 | 2024-04-02 | 34.99 | 2 | SO60268 | 2024-04-09 | 2.80 | 13.09 | |
SO60272_1 | 19 | 14119 | 478 | 6 | 2024-04-14 | 0.25 | 2024-04-02 | 9.99 | 1 | SO60272 | 2024-04-09 | 0.80 | 3.74 | |
SO60272_2 | 19 | 14119 | 477 | 6 | 2024-04-14 | 0.12 | 2024-04-02 | 4.99 | 2 | SO60272 | 2024-04-09 | 0.40 | 1.87 | |
SO60272_3 | 19 | 14119 | 488 | 6 | 2024-04-14 | 1.35 | 2024-04-02 | 53.99 | 3 | SO60272 | 2024-04-09 | 4.32 | 41.57 | |
SO60273_1 | 19 | 14291 | 475 | 6 | 2024-04-14 | 1.75 | 2024-04-02 | 69.99 | 1 | SO60273 | 2024-04-09 | 5.60 | 26.18 | |
SO60278_1 | 19 | 22332 | 528 | 6 | 2024-04-14 | 0.12 | 2024-04-02 | 4.99 | 1 | SO60278 | 2024-04-09 | 0.40 | 1.87 | |
SO60278_2 | 19 | 22332 | 222 | 6 | 2024-04-14 | 0.87 | 2024-04-02 | 34.99 | 2 | SO60278 | 2024-04-09 | 2.80 | 13.09 | |
SO60289_1 | 19 | 22050 | 592 | 6 | 2024-04-14 | 14.12 | 2024-04-02 | 564.99 | 1 | SO60289 | 2024-04-09 | 45.20 | 308.22 | |
SO60289_2 | 19 | 22050 | 478 | 6 | 2024-04-14 | 0.25 | 2024-04-02 | 9.99 | 2 | SO60289 | 2024-04-09 | 0.80 | 3.74 | |
SO60289_3 | 19 | 22050 | 477 | 6 | 2024-04-14 | 0.12 | 2024-04-02 | 4.99 | 3 | SO60289 | 2024-04-09 | 0.40 | 1.87 | |
SO60289_4 | 19 | 22050 | 480 | 6 | 2024-04-14 | 0.06 | 2024-04-02 | 2.29 | 4 | SO60289 | 2024-04-09 | 0.18 | 0.86 | |
SO60300_1 | 19 | 23397 | 578 | 6 | 2024-04-14 | 30.37 | 2024-04-02 | 1214.85 | 1 | SO60300 | 2024-04-09 | 97.19 | 755.15 | |
SO60300_2 | 19 | 23397 | 217 | 6 | 2024-04-14 | 0.87 | 2024-04-02 | 34.99 | 2 | SO60300 | 2024-04-09 | 2.80 | 13.09 | |
SO60304_1 | 19 | 22232 | 576 | 6 | 2024-04-14 | 59.60 | 2024-04-02 | 2384.07 | 1 | SO60304 | 2024-04-09 | 190.73 | 1481.94 | |
SO60304_2 | 19 | 22232 | 479 | 6 | 2024-04-14 | 0.22 | 2024-04-02 | 8.99 | 2 | SO60304 | 2024-04-09 | 0.72 | 3.36 | |
SO60304_3 | 19 | 22232 | 225 | 6 | 2024-04-14 | 0.22 | 2024-04-02 | 8.99 | 3 | SO60304 | 2024-04-09 | 0.72 | 6.92 | |
SO60304_4 | 19 | 22232 | 477 | 6 | 2024-04-14 | 0.12 | 2024-04-02 | 4.99 | 4 | SO60304 | 2024-04-09 | 0.40 | 1.87 | |
SO60309_1 | 19 | 19400 | 386 | 6 | 2024-04-14 | 28.01 | 2024-04-02 | 1120.49 | 1 | SO60309 | 2024-04-09 | 89.64 | 713.08 | |
SO60309_2 | 19 | 19400 | 237 | 6 | 2024-04-14 | 1.25 | 2024-04-02 | 49.99 | 2 | SO60309 | 2024-04-09 | 4.00 | 38.49 | |
SO60309_3 | 19 | 19400 | 482 | 6 | 2024-04-14 | 0.22 | 2024-04-02 | 8.99 | 3 | SO60309 | 2024-04-09 | 0.72 | 3.36 | |
SO60337_1 | 19 | 11330 | 480 | 6 | 2024-04-15 | 0.06 | 2024-04-03 | 2.29 | 1 | SO60337 | 2024-04-10 | 0.18 | 0.86 | |
SO60341_1 | 19 | 11223 | 538 | 6 | 2024-04-15 | 0.54 | 2024-04-03 | 21.49 | 1 | SO60341 | 2024-04-10 | 1.72 | 8.04 | |
SO60341_2 | 19 | 11223 | 480 | 6 | 2024-04-15 | 0.06 | 2024-04-03 | 2.29 | 2 | SO60341 | 2024-04-10 | 0.18 | 0.86 | |
SO60342_1 | 19 | 13758 | 529 | 6 | 2024-04-15 | 0.10 | 2024-04-03 | 3.99 | 1 | SO60342 | 2024-04-10 | 0.32 | 1.49 | |
SO60342_2 | 19 | 13758 | 540 | 6 | 2024-04-15 | 0.82 | 2024-04-03 | 32.60 | 2 | SO60342 | 2024-04-10 | 2.61 | 12.19 | |
SO60342_3 | 19 | 13758 | 486 | 6 | 2024-04-15 | 3.98 | 2024-04-03 | 159.00 | 3 | SO60342 | 2024-04-10 | 12.72 | 59.47 | |
SO60343_1 | 19 | 16800 | 478 | 6 | 2024-04-15 | 0.25 | 2024-04-03 | 9.99 | 1 | SO60343 | 2024-04-10 | 0.80 | 3.74 | |
SO60343_2 | 19 | 16800 | 477 | 6 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 2 | SO60343 | 2024-04-10 | 0.40 | 1.87 | |
SO60345_1 | 19 | 23893 | 477 | 6 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 1 | SO60345 | 2024-04-10 | 0.40 | 1.87 |
Generated 2024-11-14 16:57:53.307 UTC