[ROOT] dt FactInternetSale < WHERE OrderDate EQ ThreeDaysAgo >
82 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO74998_1 | 100 | 26031 | 538 | 9 | 2024-05-24 | 0.54 | 2024-05-12 | 21.49 | 1 | SO74998 | 2024-05-19 | 1.72 | 8.04 |
SO74998_2 | 100 | 26031 | 480 | 9 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 2 | SO74998 | 2024-05-19 | 0.18 | 0.86 |
SO74999_1 | 100 | 29288 | 477 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO74999 | 2024-05-19 | 0.40 | 1.87 |
SO74999_2 | 100 | 29288 | 237 | 9 | 2024-05-24 | 1.25 | 2024-05-12 | 49.99 | 2 | SO74999 | 2024-05-19 | 4.00 | 38.49 |
SO75000_1 | 100 | 28138 | 530 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75000 | 2024-05-19 | 0.40 | 1.87 |
SO75000_2 | 100 | 28138 | 480 | 9 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 2 | SO75000 | 2024-05-19 | 0.18 | 0.86 |
SO75001_1 | 100 | 11123 | 478 | 9 | 2024-05-24 | 0.25 | 2024-05-12 | 9.99 | 1 | SO75001 | 2024-05-19 | 0.80 | 3.74 |
SO75001_2 | 100 | 11123 | 477 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO75001 | 2024-05-19 | 0.40 | 1.87 |
SO75001_3 | 100 | 11123 | 217 | 9 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 3 | SO75001 | 2024-05-19 | 2.80 | 13.09 |
SO75001_4 | 100 | 11123 | 491 | 9 | 2024-05-24 | 1.35 | 2024-05-12 | 53.99 | 4 | SO75001 | 2024-05-19 | 4.32 | 41.57 |
SO75002_1 | 100 | 17305 | 214 | 9 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 1 | SO75002 | 2024-05-19 | 2.80 | 13.09 |
SO75003_1 | 100 | 14321 | 237 | 9 | 2024-05-24 | 1.25 | 2024-05-12 | 49.99 | 1 | SO75003 | 2024-05-19 | 4.00 | 38.49 |
SO75004_1 | 100 | 11229 | 529 | 4 | 2024-05-24 | 0.10 | 2024-05-12 | 3.99 | 1 | SO75004 | 2024-05-19 | 0.32 | 1.49 |
SO75004_2 | 100 | 11229 | 214 | 4 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 2 | SO75004 | 2024-05-19 | 2.80 | 13.09 |
SO75005_1 | 100 | 19640 | 529 | 6 | 2024-05-24 | 0.10 | 2024-05-12 | 3.99 | 1 | SO75005 | 2024-05-19 | 0.32 | 1.49 |
SO75005_2 | 100 | 19640 | 538 | 6 | 2024-05-24 | 0.54 | 2024-05-12 | 21.49 | 2 | SO75005 | 2024-05-19 | 1.72 | 8.04 |
SO75005_3 | 100 | 19640 | 480 | 6 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 3 | SO75005 | 2024-05-19 | 0.18 | 0.86 |
SO75006_1 | 100 | 12945 | 541 | 6 | 2024-05-24 | 0.72 | 2024-05-12 | 28.99 | 1 | SO75006 | 2024-05-19 | 2.32 | 10.84 |
SO75006_2 | 100 | 12945 | 530 | 6 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO75006 | 2024-05-19 | 0.40 | 1.87 |
SO75006_3 | 100 | 12945 | 479 | 6 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 3 | SO75006 | 2024-05-19 | 0.72 | 3.36 |
SO75006_4 | 100 | 12945 | 477 | 6 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 4 | SO75006 | 2024-05-19 | 0.40 | 1.87 |
SO75006_5 | 100 | 12945 | 487 | 6 | 2024-05-24 | 1.37 | 2024-05-12 | 54.99 | 5 | SO75006 | 2024-05-19 | 4.40 | 20.57 |
SO75007_1 | 100 | 26605 | 535 | 4 | 2024-05-24 | 0.62 | 2024-05-12 | 24.99 | 1 | SO75007 | 2024-05-19 | 2.00 | 9.35 |
SO75007_2 | 100 | 26605 | 480 | 4 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 2 | SO75007 | 2024-05-19 | 0.18 | 0.86 |
SO75008_1 | 100 | 12444 | 528 | 6 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75008 | 2024-05-19 | 0.40 | 1.87 |
SO75008_2 | 100 | 12444 | 535 | 6 | 2024-05-24 | 0.62 | 2024-05-12 | 24.99 | 2 | SO75008 | 2024-05-19 | 2.00 | 9.35 |
SO75008_3 | 100 | 12444 | 217 | 6 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 3 | SO75008 | 2024-05-19 | 2.80 | 13.09 |
SO75009_1 | 100 | 24635 | 529 | 4 | 2024-05-24 | 0.10 | 2024-05-12 | 3.99 | 1 | SO75009 | 2024-05-19 | 0.32 | 1.49 |
SO75009_2 | 100 | 24635 | 540 | 4 | 2024-05-24 | 0.82 | 2024-05-12 | 32.60 | 2 | SO75009 | 2024-05-19 | 2.61 | 12.19 |
SO75009_3 | 100 | 24635 | 214 | 4 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 3 | SO75009 | 2024-05-19 | 2.80 | 13.09 |
SO75010_1 | 100 | 22277 | 536 | 1 | 2024-05-24 | 0.75 | 2024-05-12 | 29.99 | 1 | SO75010 | 2024-05-19 | 2.40 | 11.22 |
SO75011_1 | 100 | 18535 | 536 | 6 | 2024-05-24 | 0.75 | 2024-05-12 | 29.99 | 1 | SO75011 | 2024-05-19 | 2.40 | 11.22 |
SO75012_1 | 100 | 17391 | 477 | 1 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75012 | 2024-05-19 | 0.40 | 1.87 |
SO75013_1 | 100 | 18503 | 475 | 4 | 2024-05-24 | 1.75 | 2024-05-12 | 69.99 | 1 | SO75013 | 2024-05-19 | 5.60 | 26.18 |
SO75013_2 | 100 | 18503 | 491 | 4 | 2024-05-24 | 1.35 | 2024-05-12 | 53.99 | 2 | SO75013 | 2024-05-19 | 4.32 | 41.57 |
SO75014_1 | 100 | 25177 | 528 | 6 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75014 | 2024-05-19 | 0.40 | 1.87 |
SO75014_2 | 100 | 25177 | 485 | 6 | 2024-05-24 | 0.55 | 2024-05-12 | 21.98 | 2 | SO75014 | 2024-05-19 | 1.76 | 8.22 |
SO75014_3 | 100 | 25177 | 478 | 6 | 2024-05-24 | 0.25 | 2024-05-12 | 9.99 | 3 | SO75014 | 2024-05-19 | 0.80 | 3.74 |
SO75015_1 | 100 | 14397 | 528 | 1 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75015 | 2024-05-19 | 0.40 | 1.87 |
SO75015_2 | 100 | 14397 | 217 | 1 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 2 | SO75015 | 2024-05-19 | 2.80 | 13.09 |
SO75016_1 | 100 | 17686 | 485 | 6 | 2024-05-24 | 0.55 | 2024-05-12 | 21.98 | 1 | SO75016 | 2024-05-19 | 1.76 | 8.22 |
SO75016_2 | 100 | 17686 | 478 | 6 | 2024-05-24 | 0.25 | 2024-05-12 | 9.99 | 2 | SO75016 | 2024-05-19 | 0.80 | 3.74 |
SO75016_3 | 100 | 17686 | 477 | 6 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 3 | SO75016 | 2024-05-19 | 0.40 | 1.87 |
SO75016_4 | 100 | 17686 | 214 | 6 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 4 | SO75016 | 2024-05-19 | 2.80 | 13.09 |
SO75017_1 | 100 | 20551 | 528 | 10 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75017 | 2024-05-19 | 0.40 | 1.87 |
SO75017_2 | 100 | 20551 | 535 | 10 | 2024-05-24 | 0.62 | 2024-05-12 | 24.99 | 2 | SO75017 | 2024-05-19 | 2.00 | 9.35 |
SO75017_3 | 100 | 20551 | 217 | 10 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 3 | SO75017 | 2024-05-19 | 2.80 | 13.09 |
SO75018_1 | 100 | 18172 | 537 | 10 | 2024-05-24 | 0.88 | 2024-05-12 | 35.00 | 1 | SO75018 | 2024-05-19 | 2.80 | 13.09 |
SO75018_2 | 100 | 18172 | 480 | 10 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 2 | SO75018 | 2024-05-19 | 0.18 | 0.86 |
SO75019_1 | 100 | 14168 | 485 | 7 | 2024-05-24 | 0.55 | 2024-05-12 | 21.98 | 1 | SO75019 | 2024-05-19 | 1.76 | 8.22 |
SO75019_2 | 100 | 14168 | 478 | 7 | 2024-05-24 | 0.25 | 2024-05-12 | 9.99 | 2 | SO75019 | 2024-05-19 | 0.80 | 3.74 |
SO75019_3 | 100 | 14168 | 477 | 7 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 3 | SO75019 | 2024-05-19 | 0.40 | 1.87 |
SO75019_4 | 100 | 14168 | 214 | 7 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 4 | SO75019 | 2024-05-19 | 2.80 | 13.09 |
SO75020_1 | 100 | 20169 | 536 | 8 | 2024-05-24 | 0.75 | 2024-05-12 | 29.99 | 1 | SO75020 | 2024-05-19 | 2.40 | 11.22 |
SO75020_2 | 100 | 20169 | 528 | 8 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO75020 | 2024-05-19 | 0.40 | 1.87 |
SO75020_3 | 100 | 20169 | 214 | 8 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 3 | SO75020 | 2024-05-19 | 2.80 | 13.09 |
SO75020_4 | 100 | 20169 | 225 | 8 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 4 | SO75020 | 2024-05-19 | 0.72 | 6.92 |
SO75021_1 | 100 | 24859 | 477 | 10 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75021 | 2024-05-19 | 0.40 | 1.87 |
SO75021_2 | 100 | 24859 | 222 | 10 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 2 | SO75021 | 2024-05-19 | 2.80 | 13.09 |
SO75022_1 | 100 | 12606 | 536 | 7 | 2024-05-24 | 0.75 | 2024-05-12 | 29.99 | 1 | SO75022 | 2024-05-19 | 2.40 | 11.22 |
SO75022_2 | 100 | 12606 | 485 | 7 | 2024-05-24 | 0.55 | 2024-05-12 | 21.98 | 2 | SO75022 | 2024-05-19 | 1.76 | 8.22 |
SO75022_3 | 100 | 12606 | 483 | 7 | 2024-05-24 | 3.00 | 2024-05-12 | 120.00 | 3 | SO75022 | 2024-05-19 | 9.60 | 44.88 |
SO75022_4 | 100 | 12606 | 234 | 7 | 2024-05-24 | 1.25 | 2024-05-12 | 49.99 | 4 | SO75022 | 2024-05-19 | 4.00 | 38.49 |
SO75022_5 | 100 | 12606 | 465 | 7 | 2024-05-24 | 0.61 | 2024-05-12 | 24.49 | 5 | SO75022 | 2024-05-19 | 1.96 | 9.16 |
SO75023_1 | 100 | 20947 | 528 | 10 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75023 | 2024-05-19 | 0.40 | 1.87 |
SO75023_2 | 100 | 20947 | 536 | 10 | 2024-05-24 | 0.75 | 2024-05-12 | 29.99 | 2 | SO75023 | 2024-05-19 | 2.40 | 11.22 |
SO75023_3 | 100 | 20947 | 480 | 10 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 3 | SO75023 | 2024-05-19 | 0.18 | 0.86 |
SO75024_1 | 100 | 22820 | 477 | 7 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75024 | 2024-05-19 | 0.40 | 1.87 |
SO75024_2 | 100 | 22820 | 463 | 7 | 2024-05-24 | 0.61 | 2024-05-12 | 24.49 | 2 | SO75024 | 2024-05-19 | 1.96 | 9.16 |
SO75025_1 | 100 | 24131 | 225 | 7 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 1 | SO75025 | 2024-05-19 | 0.72 | 6.92 |
SO75025_2 | 100 | 24131 | 530 | 7 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO75025 | 2024-05-19 | 0.40 | 1.87 |
SO75026_1 | 100 | 22394 | 529 | 7 | 2024-05-24 | 0.10 | 2024-05-12 | 3.99 | 1 | SO75026 | 2024-05-19 | 0.32 | 1.49 |
SO75026_2 | 100 | 22394 | 538 | 7 | 2024-05-24 | 0.54 | 2024-05-12 | 21.49 | 2 | SO75026 | 2024-05-19 | 1.72 | 8.04 |
SO75027_1 | 100 | 24118 | 530 | 7 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO75027 | 2024-05-19 | 0.40 | 1.87 |
SO75027_2 | 100 | 24118 | 480 | 7 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 2 | SO75027 | 2024-05-19 | 0.18 | 0.86 |
SO75028_1 | 100 | 23934 | 541 | 7 | 2024-05-24 | 0.72 | 2024-05-12 | 28.99 | 1 | SO75028 | 2024-05-19 | 2.32 | 10.84 |
SO75028_2 | 100 | 23934 | 530 | 7 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO75028 | 2024-05-19 | 0.40 | 1.87 |
SO75028_3 | 100 | 23934 | 480 | 7 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 3 | SO75028 | 2024-05-19 | 0.18 | 0.86 |
SO75029_1 | 100 | 12088 | 537 | 1 | 2024-05-24 | 0.88 | 2024-05-12 | 35.00 | 1 | SO75029 | 2024-05-19 | 2.80 | 13.09 |
SO75029_2 | 100 | 12088 | 528 | 1 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO75029 | 2024-05-19 | 0.40 | 1.87 |
SO75029_3 | 100 | 12088 | 485 | 1 | 2024-05-24 | 0.55 | 2024-05-12 | 21.98 | 3 | SO75029 | 2024-05-19 | 1.76 | 8.22 |
SO75029_4 | 100 | 12088 | 231 | 1 | 2024-05-24 | 1.25 | 2024-05-12 | 49.99 | 4 | SO75029 | 2024-05-19 | 4.00 | 38.49 |
Generated 2024-05-15 08:33:33.208 UTC