[ROOT] dt FactInternetSale < WHERE OrderDate EQ 30DaysAgo >
79 items
| FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO74148_1 | 100 | 11786 | 222 | 1 | 2025-08-06 | 0.87 | 2025-07-25 | 34.99 | 1 | SO74148 | 2025-08-01 | 2.80 | 13.09 |
| SO74149_1 | 6 | 17304 | 539 | 9 | 2025-08-06 | 0.62 | 2025-07-25 | 24.99 | 1 | SO74149 | 2025-08-01 | 2.00 | 9.35 |
| SO74149_2 | 6 | 17304 | 480 | 9 | 2025-08-06 | 0.06 | 2025-07-25 | 2.29 | 2 | SO74149 | 2025-08-01 | 0.18 | 0.86 |
| SO74150_1 | 6 | 15599 | 529 | 9 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 1 | SO74150 | 2025-08-01 | 0.32 | 1.49 |
| SO74150_2 | 6 | 15599 | 539 | 9 | 2025-08-06 | 0.62 | 2025-07-25 | 24.99 | 2 | SO74150 | 2025-08-01 | 2.00 | 9.35 |
| SO74150_3 | 6 | 15599 | 480 | 9 | 2025-08-06 | 0.06 | 2025-07-25 | 2.29 | 3 | SO74150 | 2025-08-01 | 0.18 | 0.86 |
| SO74151_1 | 6 | 17500 | 485 | 9 | 2025-08-06 | 0.55 | 2025-07-25 | 21.98 | 1 | SO74151 | 2025-08-01 | 1.76 | 8.22 |
| SO74151_2 | 6 | 17500 | 478 | 9 | 2025-08-06 | 0.25 | 2025-07-25 | 9.99 | 2 | SO74151 | 2025-08-01 | 0.80 | 3.74 |
| SO74151_3 | 6 | 17500 | 477 | 9 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 3 | SO74151 | 2025-08-01 | 0.40 | 1.87 |
| SO74152_1 | 6 | 18444 | 538 | 9 | 2025-08-06 | 0.54 | 2025-07-25 | 21.49 | 1 | SO74152 | 2025-08-01 | 1.72 | 8.04 |
| SO74152_2 | 6 | 18444 | 529 | 9 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 2 | SO74152 | 2025-08-01 | 0.32 | 1.49 |
| SO74153_1 | 6 | 29305 | 478 | 9 | 2025-08-06 | 0.25 | 2025-07-25 | 9.99 | 1 | SO74153 | 2025-08-01 | 0.80 | 3.74 |
| SO74153_2 | 6 | 29305 | 477 | 9 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 2 | SO74153 | 2025-08-01 | 0.40 | 1.87 |
| SO74154_1 | 6 | 11902 | 465 | 9 | 2025-08-06 | 0.61 | 2025-07-25 | 24.49 | 1 | SO74154 | 2025-08-01 | 1.96 | 9.16 |
| SO74155_1 | 6 | 11051 | 225 | 9 | 2025-08-06 | 0.22 | 2025-07-25 | 8.99 | 1 | SO74155 | 2025-08-01 | 0.72 | 6.92 |
| SO74155_2 | 6 | 11051 | 228 | 9 | 2025-08-06 | 1.25 | 2025-07-25 | 49.99 | 2 | SO74155 | 2025-08-01 | 4.00 | 38.49 |
| SO74156_1 | 6 | 12666 | 480 | 9 | 2025-08-06 | 0.06 | 2025-07-25 | 2.29 | 1 | SO74156 | 2025-08-01 | 0.18 | 0.86 |
| SO74157_1 | 100 | 11884 | 214 | 1 | 2025-08-06 | 0.87 | 2025-07-25 | 34.99 | 1 | SO74157 | 2025-08-01 | 2.80 | 13.09 |
| SO74158_1 | 100 | 11170 | 529 | 1 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 1 | SO74158 | 2025-08-01 | 0.32 | 1.49 |
| SO74158_2 | 100 | 11170 | 214 | 1 | 2025-08-06 | 0.87 | 2025-07-25 | 34.99 | 2 | SO74158 | 2025-08-01 | 2.80 | 13.09 |
| SO74158_3 | 100 | 11170 | 228 | 1 | 2025-08-06 | 1.25 | 2025-07-25 | 49.99 | 3 | SO74158 | 2025-08-01 | 4.00 | 38.49 |
| SO74158_4 | 100 | 11170 | 225 | 1 | 2025-08-06 | 0.22 | 2025-07-25 | 8.99 | 4 | SO74158 | 2025-08-01 | 0.72 | 6.92 |
| SO74159_1 | 100 | 27532 | 538 | 1 | 2025-08-06 | 0.54 | 2025-07-25 | 21.49 | 1 | SO74159 | 2025-08-01 | 1.72 | 8.04 |
| SO74159_2 | 100 | 27532 | 480 | 1 | 2025-08-06 | 0.06 | 2025-07-25 | 2.29 | 2 | SO74159 | 2025-08-01 | 0.18 | 0.86 |
| SO74160_1 | 100 | 28238 | 538 | 4 | 2025-08-06 | 0.54 | 2025-07-25 | 21.49 | 1 | SO74160 | 2025-08-01 | 1.72 | 8.04 |
| SO74161_1 | 19 | 11502 | 538 | 6 | 2025-08-06 | 0.54 | 2025-07-25 | 21.49 | 1 | SO74161 | 2025-08-01 | 1.72 | 8.04 |
| SO74161_2 | 19 | 11502 | 529 | 6 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 2 | SO74161 | 2025-08-01 | 0.32 | 1.49 |
| SO74161_3 | 19 | 11502 | 484 | 6 | 2025-08-06 | 0.20 | 2025-07-25 | 7.95 | 3 | SO74161 | 2025-08-01 | 0.64 | 2.97 |
| SO74162_1 | 100 | 25330 | 529 | 4 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 1 | SO74162 | 2025-08-01 | 0.32 | 1.49 |
| SO74162_2 | 100 | 25330 | 471 | 4 | 2025-08-06 | 1.59 | 2025-07-25 | 63.50 | 2 | SO74162 | 2025-08-01 | 5.08 | 23.75 |
| SO74162_3 | 100 | 25330 | 540 | 4 | 2025-08-06 | 0.82 | 2025-07-25 | 32.60 | 3 | SO74162 | 2025-08-01 | 2.61 | 12.19 |
| SO74163_1 | 100 | 26528 | 535 | 1 | 2025-08-06 | 0.62 | 2025-07-25 | 24.99 | 1 | SO74163 | 2025-08-01 | 2.00 | 9.35 |
| SO74163_2 | 100 | 26528 | 528 | 1 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 2 | SO74163 | 2025-08-01 | 0.40 | 1.87 |
| SO74163_3 | 100 | 26528 | 473 | 1 | 2025-08-06 | 1.59 | 2025-07-25 | 63.50 | 3 | SO74163 | 2025-08-01 | 5.08 | 23.75 |
| SO74163_4 | 100 | 26528 | 217 | 1 | 2025-08-06 | 0.87 | 2025-07-25 | 34.99 | 4 | SO74163 | 2025-08-01 | 2.80 | 13.09 |
| SO74164_1 | 19 | 14274 | 540 | 6 | 2025-08-06 | 0.82 | 2025-07-25 | 32.60 | 1 | SO74164 | 2025-08-01 | 2.61 | 12.19 |
| SO74164_2 | 19 | 14274 | 529 | 6 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 2 | SO74164 | 2025-08-01 | 0.32 | 1.49 |
| SO74165_1 | 100 | 24517 | 529 | 4 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 1 | SO74165 | 2025-08-01 | 0.32 | 1.49 |
| SO74165_2 | 100 | 24517 | 540 | 4 | 2025-08-06 | 0.82 | 2025-07-25 | 32.60 | 2 | SO74165 | 2025-08-01 | 2.61 | 12.19 |
| SO74165_3 | 100 | 24517 | 237 | 4 | 2025-08-06 | 1.25 | 2025-07-25 | 49.99 | 3 | SO74165 | 2025-08-01 | 4.00 | 38.49 |
| SO74166_1 | 19 | 16721 | 478 | 6 | 2025-08-06 | 0.25 | 2025-07-25 | 9.99 | 1 | SO74166 | 2025-08-01 | 0.80 | 3.74 |
| SO74166_2 | 19 | 16721 | 477 | 6 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 2 | SO74166 | 2025-08-01 | 0.40 | 1.87 |
| SO74166_3 | 19 | 16721 | 217 | 6 | 2025-08-06 | 0.87 | 2025-07-25 | 34.99 | 3 | SO74166 | 2025-08-01 | 2.80 | 13.09 |
| SO74167_1 | 100 | 21696 | 478 | 1 | 2025-08-06 | 0.25 | 2025-07-25 | 9.99 | 1 | SO74167 | 2025-08-01 | 0.80 | 3.74 |
| SO74167_2 | 100 | 21696 | 477 | 1 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 2 | SO74167 | 2025-08-01 | 0.40 | 1.87 |
| SO74167_3 | 100 | 21696 | 488 | 1 | 2025-08-06 | 1.35 | 2025-07-25 | 53.99 | 3 | SO74167 | 2025-08-01 | 4.32 | 41.57 |
| SO74168_1 | 100 | 19885 | 475 | 1 | 2025-08-06 | 1.75 | 2025-07-25 | 69.99 | 1 | SO74168 | 2025-08-01 | 5.60 | 26.18 |
| SO74168_2 | 100 | 19885 | 488 | 1 | 2025-08-06 | 1.35 | 2025-07-25 | 53.99 | 2 | SO74168 | 2025-08-01 | 4.32 | 41.57 |
| SO74169_1 | 19 | 18356 | 476 | 6 | 2025-08-06 | 1.75 | 2025-07-25 | 69.99 | 1 | SO74169 | 2025-08-01 | 5.60 | 26.18 |
| SO74169_2 | 19 | 18356 | 228 | 6 | 2025-08-06 | 1.25 | 2025-07-25 | 49.99 | 2 | SO74169 | 2025-08-01 | 4.00 | 38.49 |
| SO74170_1 | 19 | 25367 | 477 | 6 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 1 | SO74170 | 2025-08-01 | 0.40 | 1.87 |
| SO74171_1 | 100 | 15495 | 528 | 4 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 1 | SO74171 | 2025-08-01 | 0.40 | 1.87 |
| SO74171_2 | 100 | 15495 | 214 | 4 | 2025-08-06 | 0.87 | 2025-07-25 | 34.99 | 2 | SO74171 | 2025-08-01 | 2.80 | 13.09 |
| SO74172_1 | 19 | 19200 | 485 | 6 | 2025-08-06 | 0.55 | 2025-07-25 | 21.98 | 1 | SO74172 | 2025-08-01 | 1.76 | 8.22 |
| SO74172_2 | 19 | 19200 | 234 | 6 | 2025-08-06 | 1.25 | 2025-07-25 | 49.99 | 2 | SO74172 | 2025-08-01 | 4.00 | 38.49 |
| SO74173_1 | 100 | 14689 | 528 | 7 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 1 | SO74173 | 2025-08-01 | 0.40 | 1.87 |
| SO74174_1 | 100 | 15060 | 535 | 7 | 2025-08-06 | 0.62 | 2025-07-25 | 24.99 | 1 | SO74174 | 2025-08-01 | 2.00 | 9.35 |
| SO74175_1 | 98 | 16191 | 485 | 10 | 2025-08-06 | 0.55 | 2025-07-25 | 21.98 | 1 | SO74175 | 2025-08-01 | 1.76 | 8.22 |
| SO74176_1 | 100 | 20144 | 528 | 8 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 1 | SO74176 | 2025-08-01 | 0.40 | 1.87 |
| SO74176_2 | 100 | 20144 | 536 | 8 | 2025-08-06 | 0.75 | 2025-07-25 | 29.99 | 2 | SO74176 | 2025-08-01 | 2.40 | 11.22 |
| SO74176_3 | 100 | 20144 | 485 | 8 | 2025-08-06 | 0.55 | 2025-07-25 | 21.98 | 3 | SO74176 | 2025-08-01 | 1.76 | 8.22 |
| SO74176_4 | 100 | 20144 | 473 | 8 | 2025-08-06 | 1.59 | 2025-07-25 | 63.50 | 4 | SO74176 | 2025-08-01 | 5.08 | 23.75 |
| SO74177_1 | 98 | 14958 | 477 | 10 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 1 | SO74177 | 2025-08-01 | 0.40 | 1.87 |
| SO74177_2 | 98 | 14958 | 465 | 10 | 2025-08-06 | 0.61 | 2025-07-25 | 24.49 | 2 | SO74177 | 2025-08-01 | 1.96 | 9.16 |
| SO74178_1 | 100 | 21825 | 477 | 8 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 1 | SO74178 | 2025-08-01 | 0.40 | 1.87 |
| SO74179_1 | 100 | 26980 | 538 | 8 | 2025-08-06 | 0.54 | 2025-07-25 | 21.49 | 1 | SO74179 | 2025-08-01 | 1.72 | 8.04 |
| SO74179_2 | 100 | 26980 | 480 | 8 | 2025-08-06 | 0.06 | 2025-07-25 | 2.29 | 2 | SO74179 | 2025-08-01 | 0.18 | 0.86 |
| SO74180_1 | 100 | 24124 | 530 | 7 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 1 | SO74180 | 2025-08-01 | 0.40 | 1.87 |
| SO74180_2 | 100 | 24124 | 487 | 7 | 2025-08-06 | 1.37 | 2025-07-25 | 54.99 | 2 | SO74180 | 2025-08-01 | 4.40 | 20.57 |
| SO74181_1 | 100 | 25807 | 538 | 7 | 2025-08-06 | 0.54 | 2025-07-25 | 21.49 | 1 | SO74181 | 2025-08-01 | 1.72 | 8.04 |
| SO74181_2 | 100 | 25807 | 529 | 7 | 2025-08-06 | 0.10 | 2025-07-25 | 3.99 | 2 | SO74181 | 2025-08-01 | 0.32 | 1.49 |
| SO74181_3 | 100 | 25807 | 473 | 7 | 2025-08-06 | 1.59 | 2025-07-25 | 63.50 | 3 | SO74181 | 2025-08-01 | 5.08 | 23.75 |
| SO74182_1 | 19 | 11640 | 537 | 6 | 2025-08-06 | 0.88 | 2025-07-25 | 35.00 | 1 | SO74182 | 2025-08-01 | 2.80 | 13.09 |
| SO74182_2 | 19 | 11640 | 480 | 6 | 2025-08-06 | 0.06 | 2025-07-25 | 2.29 | 2 | SO74182 | 2025-08-01 | 0.18 | 0.86 |
| SO74182_3 | 19 | 11640 | 484 | 6 | 2025-08-06 | 0.20 | 2025-07-25 | 7.95 | 3 | SO74182 | 2025-08-01 | 0.64 | 2.97 |
| SO74183_1 | 19 | 12959 | 537 | 6 | 2025-08-06 | 0.88 | 2025-07-25 | 35.00 | 1 | SO74183 | 2025-08-01 | 2.80 | 13.09 |
| SO74184_1 | 19 | 15536 | 537 | 6 | 2025-08-06 | 0.88 | 2025-07-25 | 35.00 | 1 | SO74184 | 2025-08-01 | 2.80 | 13.09 |
| SO74184_2 | 19 | 15536 | 528 | 6 | 2025-08-06 | 0.12 | 2025-07-25 | 4.99 | 2 | SO74184 | 2025-08-01 | 0.40 | 1.87 |
| SO74184_3 | 19 | 15536 | 222 | 6 | 2025-08-06 | 0.87 | 2025-07-25 | 34.99 | 3 | SO74184 | 2025-08-01 | 2.80 | 13.09 |
Generated 2025-08-24 12:28:36.260 UTC