[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > < SKIP 1250 > < TAKE 62 >
62 items
| FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO54447_3 | 19 | 14371 | 217 | 6 | 2024-12-29 | 0.87 | 2024-12-17 | 34.99 | 3 | SO54447 | 2024-12-24 | 2.80 | 13.09 | |
| SO54462_1 | 19 | 17442 | 485 | 6 | 2024-12-29 | 0.55 | 2024-12-17 | 21.98 | 1 | SO54462 | 2024-12-24 | 1.76 | 8.22 | |
| SO54462_2 | 19 | 17442 | 490 | 6 | 2024-12-29 | 1.35 | 2024-12-17 | 53.99 | 2 | SO54462 | 2024-12-24 | 4.32 | 41.57 | |
| SO54488_1 | 19 | 15340 | 478 | 6 | 2024-12-30 | 0.25 | 2024-12-18 | 9.99 | 1 | SO54488 | 2024-12-25 | 0.80 | 3.74 | |
| SO54488_2 | 19 | 15340 | 477 | 6 | 2024-12-30 | 0.12 | 2024-12-18 | 4.99 | 2 | SO54488 | 2024-12-25 | 0.40 | 1.87 | |
| SO54488_3 | 19 | 15340 | 465 | 6 | 2024-12-30 | 0.61 | 2024-12-18 | 24.49 | 3 | SO54488 | 2024-12-25 | 1.96 | 9.16 | |
| SO54488_4 | 19 | 15340 | 222 | 6 | 2024-12-30 | 0.87 | 2024-12-18 | 34.99 | 4 | SO54488 | 2024-12-25 | 2.80 | 13.09 | |
| SO54491_1 | 19 | 12165 | 477 | 6 | 2024-12-30 | 0.12 | 2024-12-18 | 4.99 | 1 | SO54491 | 2024-12-25 | 0.40 | 1.87 | |
| SO54491_2 | 19 | 12165 | 484 | 6 | 2024-12-30 | 0.20 | 2024-12-18 | 7.95 | 2 | SO54491 | 2024-12-25 | 0.64 | 2.97 | |
| SO54494_1 | 19 | 22278 | 528 | 6 | 2024-12-30 | 0.12 | 2024-12-18 | 4.99 | 1 | SO54494 | 2024-12-25 | 0.40 | 1.87 | |
| SO54494_2 | 19 | 22278 | 480 | 2 | 6 | 2024-12-30 | 0.06 | 2024-12-18 | 2.29 | 2 | SO54494 | 2024-12-25 | 0.18 | 0.86 |
| SO54497_1 | 19 | 20280 | 485 | 6 | 2024-12-30 | 0.55 | 2024-12-18 | 21.98 | 1 | SO54497 | 2024-12-25 | 1.76 | 8.22 | |
| SO54497_2 | 19 | 20280 | 481 | 6 | 2024-12-30 | 0.22 | 2024-12-18 | 8.99 | 2 | SO54497 | 2024-12-25 | 0.72 | 3.36 | |
| SO54510_1 | 19 | 14353 | 537 | 6 | 2024-12-30 | 0.88 | 2024-12-18 | 35.00 | 1 | SO54510 | 2024-12-25 | 2.80 | 13.09 | |
| SO54510_2 | 19 | 14353 | 528 | 6 | 2024-12-30 | 0.12 | 2024-12-18 | 4.99 | 2 | SO54510 | 2024-12-25 | 0.40 | 1.87 | |
| SO54510_3 | 19 | 14353 | 214 | 6 | 2024-12-30 | 0.87 | 2024-12-18 | 34.99 | 3 | SO54510 | 2024-12-25 | 2.80 | 13.09 | |
| SO54548_1 | 19 | 11740 | 528 | 6 | 2024-12-31 | 0.12 | 2024-12-19 | 4.99 | 1 | SO54548 | 2024-12-26 | 0.40 | 1.87 | |
| SO54548_2 | 19 | 11740 | 536 | 6 | 2024-12-31 | 0.75 | 2024-12-19 | 29.99 | 2 | SO54548 | 2024-12-26 | 2.40 | 11.22 | |
| SO54548_3 | 19 | 11740 | 480 | 6 | 2024-12-31 | 0.06 | 2024-12-19 | 2.29 | 3 | SO54548 | 2024-12-26 | 0.18 | 0.86 | |
| SO54549_1 | 19 | 18554 | 536 | 6 | 2024-12-31 | 0.75 | 2024-12-19 | 29.99 | 1 | SO54549 | 2024-12-26 | 2.40 | 11.22 | |
| SO54549_2 | 19 | 18554 | 528 | 6 | 2024-12-31 | 0.12 | 2024-12-19 | 4.99 | 2 | SO54549 | 2024-12-26 | 0.40 | 1.87 | |
| SO54549_3 | 19 | 18554 | 214 | 6 | 2024-12-31 | 0.87 | 2024-12-19 | 34.99 | 3 | SO54549 | 2024-12-26 | 2.80 | 13.09 | |
| SO54550_1 | 19 | 11185 | 536 | 6 | 2024-12-31 | 0.75 | 2024-12-19 | 29.99 | 1 | SO54550 | 2024-12-26 | 2.40 | 11.22 | |
| SO54550_2 | 19 | 11185 | 528 | 6 | 2024-12-31 | 0.12 | 2024-12-19 | 4.99 | 2 | SO54550 | 2024-12-26 | 0.40 | 1.87 | |
| SO54550_3 | 19 | 11185 | 214 | 6 | 2024-12-31 | 0.87 | 2024-12-19 | 34.99 | 3 | SO54550 | 2024-12-26 | 2.80 | 13.09 | |
| SO54552_1 | 19 | 13185 | 478 | 6 | 2024-12-31 | 0.25 | 2024-12-19 | 9.99 | 1 | SO54552 | 2024-12-26 | 0.80 | 3.74 | |
| SO54552_2 | 19 | 13185 | 477 | 6 | 2024-12-31 | 0.12 | 2024-12-19 | 4.99 | 2 | SO54552 | 2024-12-26 | 0.40 | 1.87 | |
| SO54552_3 | 19 | 13185 | 487 | 6 | 2024-12-31 | 1.37 | 2024-12-19 | 54.99 | 3 | SO54552 | 2024-12-26 | 4.40 | 20.57 | |
| SO54555_1 | 19 | 18523 | 476 | 6 | 2024-12-31 | 1.75 | 2024-12-19 | 69.99 | 1 | SO54555 | 2024-12-26 | 5.60 | 26.18 | |
| SO54555_2 | 19 | 18523 | 228 | 6 | 2024-12-31 | 1.25 | 2024-12-19 | 49.99 | 2 | SO54555 | 2024-12-26 | 4.00 | 38.49 | |
| SO54555_3 | 19 | 18523 | 225 | 6 | 2024-12-31 | 0.22 | 2024-12-19 | 8.99 | 3 | SO54555 | 2024-12-26 | 0.72 | 6.92 | |
| SO54574_1 | 19 | 12710 | 357 | 6 | 2024-12-31 | 58.00 | 2024-12-19 | 2319.99 | 1 | SO54574 | 2024-12-26 | 185.60 | 1265.62 | |
| SO54574_2 | 19 | 12710 | 222 | 6 | 2024-12-31 | 0.87 | 2024-12-19 | 34.99 | 2 | SO54574 | 2024-12-26 | 2.80 | 13.09 | |
| SO54581_1 | 19 | 16754 | 569 | 13 | 6 | 2024-12-31 | 18.56 | 2024-12-19 | 742.35 | 1 | SO54581 | 2024-12-26 | 59.39 | 461.44 |
| SO54581_2 | 19 | 16754 | 479 | 6 | 2024-12-31 | 0.22 | 2024-12-19 | 8.99 | 2 | SO54581 | 2024-12-26 | 0.72 | 3.36 | |
| SO54581_3 | 19 | 16754 | 477 | 6 | 2024-12-31 | 0.12 | 2024-12-19 | 4.99 | 3 | SO54581 | 2024-12-26 | 0.40 | 1.87 | |
| SO54609_1 | 19 | 19223 | 538 | 6 | 2025-01-01 | 0.54 | 2024-12-20 | 21.49 | 1 | SO54609 | 2024-12-27 | 1.72 | 8.04 | |
| SO54610_1 | 19 | 11502 | 529 | 6 | 2025-01-01 | 0.10 | 2024-12-20 | 3.99 | 1 | SO54610 | 2024-12-27 | 0.32 | 1.49 | |
| SO54610_2 | 19 | 11502 | 539 | 6 | 2025-01-01 | 0.62 | 2024-12-20 | 24.99 | 2 | SO54610 | 2024-12-27 | 2.00 | 9.35 | |
| SO54610_3 | 19 | 11502 | 217 | 6 | 2025-01-01 | 0.87 | 2024-12-20 | 34.99 | 3 | SO54610 | 2024-12-27 | 2.80 | 13.09 | |
| SO54610_4 | 19 | 11502 | 488 | 6 | 2025-01-01 | 1.35 | 2024-12-20 | 53.99 | 4 | SO54610 | 2024-12-27 | 4.32 | 41.57 | |
| SO54611_1 | 19 | 19836 | 536 | 6 | 2025-01-01 | 0.75 | 2024-12-20 | 29.99 | 1 | SO54611 | 2024-12-27 | 2.40 | 11.22 | |
| SO54611_2 | 19 | 19836 | 482 | 6 | 2025-01-01 | 0.22 | 2024-12-20 | 8.99 | 2 | SO54611 | 2024-12-27 | 0.72 | 3.36 | |
| SO54612_1 | 19 | 11824 | 528 | 6 | 2025-01-01 | 0.12 | 2024-12-20 | 4.99 | 1 | SO54612 | 2024-12-27 | 0.40 | 1.87 | |
| SO54612_2 | 19 | 11824 | 536 | 6 | 2025-01-01 | 0.75 | 2024-12-20 | 29.99 | 2 | SO54612 | 2024-12-27 | 2.40 | 11.22 | |
| SO54612_3 | 19 | 11824 | 217 | 6 | 2025-01-01 | 0.87 | 2024-12-20 | 34.99 | 3 | SO54612 | 2024-12-27 | 2.80 | 13.09 | |
| SO54614_1 | 19 | 19015 | 528 | 6 | 2025-01-01 | 0.12 | 2024-12-20 | 4.99 | 1 | SO54614 | 2024-12-27 | 0.40 | 1.87 | |
| SO54614_2 | 19 | 19015 | 536 | 6 | 2025-01-01 | 0.75 | 2024-12-20 | 29.99 | 2 | SO54614 | 2024-12-27 | 2.40 | 11.22 | |
| SO54614_3 | 19 | 19015 | 222 | 6 | 2025-01-01 | 0.87 | 2024-12-20 | 34.99 | 3 | SO54614 | 2024-12-27 | 2.80 | 13.09 | |
| SO54614_4 | 19 | 19015 | 463 | 6 | 2025-01-01 | 0.61 | 2024-12-20 | 24.49 | 4 | SO54614 | 2024-12-27 | 1.96 | 9.16 | |
| SO54617_1 | 19 | 14502 | 477 | 6 | 2025-01-01 | 0.12 | 2024-12-20 | 4.99 | 1 | SO54617 | 2024-12-27 | 0.40 | 1.87 | |
| SO54617_2 | 19 | 14502 | 478 | 6 | 2025-01-01 | 0.25 | 2024-12-20 | 9.99 | 2 | SO54617 | 2024-12-27 | 0.80 | 3.74 | |
| SO54618_1 | 19 | 14725 | 478 | 6 | 2025-01-01 | 0.25 | 2024-12-20 | 9.99 | 1 | SO54618 | 2024-12-27 | 0.80 | 3.74 | |
| SO54618_2 | 19 | 14725 | 477 | 6 | 2025-01-01 | 0.12 | 2024-12-20 | 4.99 | 2 | SO54618 | 2024-12-27 | 0.40 | 1.87 | |
| SO54618_3 | 19 | 14725 | 487 | 6 | 2025-01-01 | 1.37 | 2024-12-20 | 54.99 | 3 | SO54618 | 2024-12-27 | 4.40 | 20.57 | |
| SO54623_1 | 19 | 23798 | 477 | 6 | 2025-01-01 | 0.12 | 2024-12-20 | 4.99 | 1 | SO54623 | 2024-12-27 | 0.40 | 1.87 | |
| SO54623_2 | 19 | 23798 | 487 | 6 | 2025-01-01 | 1.37 | 2024-12-20 | 54.99 | 2 | SO54623 | 2024-12-27 | 4.40 | 20.57 | |
| SO54623_3 | 19 | 23798 | 484 | 6 | 2025-01-01 | 0.20 | 2024-12-20 | 7.95 | 3 | SO54623 | 2024-12-27 | 0.64 | 2.97 | |
| SO54626_1 | 19 | 27300 | 528 | 6 | 2025-01-01 | 0.12 | 2024-12-20 | 4.99 | 1 | SO54626 | 2024-12-27 | 0.40 | 1.87 | |
| SO54626_2 | 19 | 27300 | 480 | 2 | 6 | 2025-01-01 | 0.06 | 2024-12-20 | 2.29 | 2 | SO54626 | 2024-12-27 | 0.18 | 0.86 |
| SO54627_1 | 19 | 18919 | 485 | 6 | 2025-01-01 | 0.55 | 2024-12-20 | 21.98 | 1 | SO54627 | 2024-12-27 | 1.76 | 8.22 | |
| SO54627_2 | 19 | 18919 | 217 | 6 | 2025-01-01 | 0.87 | 2024-12-20 | 34.99 | 2 | SO54627 | 2024-12-27 | 2.80 | 13.09 |
Generated 2025-11-02 03:49:24.778 UTC