[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > < SKIP 406 > < TAKE 31 >
31 items
| FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO51986_3 | 19 | 15478 | 480 | 6 | 2024-11-17 | 0.06 | 2024-11-05 | 2.29 | 3 | SO51986 | 2024-11-12 | 0.18 | 0.86 | |
| SO51987_1 | 19 | 16097 | 478 | 6 | 2024-11-17 | 0.25 | 2024-11-05 | 9.99 | 1 | SO51987 | 2024-11-12 | 0.80 | 3.74 | |
| SO51988_1 | 19 | 13491 | 478 | 6 | 2024-11-17 | 0.25 | 2024-11-05 | 9.99 | 1 | SO51988 | 2024-11-12 | 0.80 | 3.74 | |
| SO51988_2 | 19 | 13491 | 477 | 6 | 2024-11-17 | 0.12 | 2024-11-05 | 4.99 | 2 | SO51988 | 2024-11-12 | 0.40 | 1.87 | |
| SO51990_1 | 19 | 12165 | 478 | 6 | 2024-11-17 | 0.25 | 2024-11-05 | 9.99 | 1 | SO51990 | 2024-11-12 | 0.80 | 3.74 | |
| SO51990_2 | 19 | 12165 | 477 | 6 | 2024-11-17 | 0.12 | 2024-11-05 | 4.99 | 2 | SO51990 | 2024-11-12 | 0.40 | 1.87 | |
| SO51990_3 | 19 | 12165 | 483 | 6 | 2024-11-17 | 3.00 | 2024-11-05 | 120.00 | 3 | SO51990 | 2024-11-12 | 9.60 | 44.88 | |
| SO51990_4 | 19 | 12165 | 467 | 2 | 6 | 2024-11-17 | 0.61 | 2024-11-05 | 24.49 | 4 | SO51990 | 2024-11-12 | 1.96 | 9.16 |
| SO51991_1 | 19 | 11212 | 476 | 6 | 2024-11-17 | 1.75 | 2024-11-05 | 69.99 | 1 | SO51991 | 2024-11-12 | 5.60 | 26.18 | |
| SO51991_2 | 19 | 11212 | 231 | 6 | 2024-11-17 | 1.25 | 2024-11-05 | 49.99 | 2 | SO51991 | 2024-11-12 | 4.00 | 38.49 | |
| SO51993_1 | 19 | 27502 | 474 | 6 | 2024-11-17 | 1.75 | 2024-11-05 | 69.99 | 1 | SO51993 | 2024-11-12 | 5.60 | 26.18 | |
| SO52002_1 | 19 | 11632 | 537 | 6 | 2024-11-17 | 0.88 | 2024-11-05 | 35.00 | 1 | SO52002 | 2024-11-12 | 2.80 | 13.09 | |
| SO52002_2 | 19 | 11632 | 528 | 6 | 2024-11-17 | 0.12 | 2024-11-05 | 4.99 | 2 | SO52002 | 2024-11-12 | 0.40 | 1.87 | |
| SO52002_3 | 19 | 11632 | 485 | 6 | 2024-11-17 | 0.55 | 2024-11-05 | 21.98 | 3 | SO52002 | 2024-11-12 | 1.76 | 8.22 | |
| SO52002_4 | 19 | 11632 | 478 | 6 | 2024-11-17 | 0.25 | 2024-11-05 | 9.99 | 4 | SO52002 | 2024-11-12 | 0.80 | 3.74 | |
| SO52002_5 | 19 | 11632 | 477 | 6 | 2024-11-17 | 0.12 | 2024-11-05 | 4.99 | 5 | SO52002 | 2024-11-12 | 0.40 | 1.87 | |
| SO52003_1 | 19 | 15507 | 537 | 6 | 2024-11-17 | 0.88 | 2024-11-05 | 35.00 | 1 | SO52003 | 2024-11-12 | 2.80 | 13.09 | |
| SO52003_2 | 19 | 15507 | 528 | 6 | 2024-11-17 | 0.12 | 2024-11-05 | 4.99 | 2 | SO52003 | 2024-11-12 | 0.40 | 1.87 | |
| SO52003_3 | 19 | 15507 | 483 | 6 | 2024-11-17 | 3.00 | 2024-11-05 | 120.00 | 3 | SO52003 | 2024-11-12 | 9.60 | 44.88 | |
| SO52005_1 | 19 | 21652 | 598 | 6 | 2024-11-17 | 13.50 | 2024-11-05 | 539.99 | 1 | SO52005 | 2024-11-12 | 43.20 | 294.58 | |
| SO52005_2 | 19 | 21652 | 485 | 6 | 2024-11-17 | 0.55 | 2024-11-05 | 21.98 | 2 | SO52005 | 2024-11-12 | 1.76 | 8.22 | |
| SO52005_3 | 19 | 21652 | 222 | 6 | 2024-11-17 | 0.87 | 2024-11-05 | 34.99 | 3 | SO52005 | 2024-11-12 | 2.80 | 13.09 | |
| SO52023_1 | 19 | 11500 | 222 | 6 | 2024-11-18 | 0.87 | 2024-11-06 | 34.99 | 1 | SO52023 | 2024-11-13 | 2.80 | 13.09 | |
| SO52034_1 | 19 | 14091 | 488 | 6 | 2024-11-18 | 1.35 | 2024-11-06 | 53.99 | 1 | SO52034 | 2024-11-13 | 4.32 | 41.57 | |
| SO52035_1 | 19 | 11300 | 225 | 6 | 2024-11-18 | 0.22 | 2024-11-06 | 8.99 | 1 | SO52035 | 2024-11-13 | 0.72 | 6.92 | |
| SO52035_2 | 19 | 11300 | 540 | 6 | 2024-11-18 | 0.82 | 2024-11-06 | 32.60 | 2 | SO52035 | 2024-11-13 | 2.61 | 12.19 | |
| SO52040_1 | 19 | 16848 | 475 | 6 | 2024-11-18 | 1.75 | 2024-11-06 | 69.99 | 1 | SO52040 | 2024-11-13 | 5.60 | 26.18 | |
| SO52040_2 | 19 | 16848 | 467 | 2 | 6 | 2024-11-18 | 0.61 | 2024-11-06 | 24.49 | 2 | SO52040 | 2024-11-13 | 1.96 | 9.16 |
| SO52041_1 | 19 | 15413 | 476 | 6 | 2024-11-18 | 1.75 | 2024-11-06 | 69.99 | 1 | SO52041 | 2024-11-13 | 5.60 | 26.18 | |
| SO52041_2 | 19 | 15413 | 488 | 6 | 2024-11-18 | 1.35 | 2024-11-06 | 53.99 | 2 | SO52041 | 2024-11-13 | 4.32 | 41.57 | |
| SO52042_1 | 19 | 23559 | 528 | 6 | 2024-11-18 | 0.12 | 2024-11-06 | 4.99 | 1 | SO52042 | 2024-11-13 | 0.40 | 1.87 |
Generated 2025-11-03 19:45:09.911 UTC