[ROOT] dt FactInternetSale < WHERE OrderDate EQ 27DaysAgo >
53 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO74253_1 | 100 | 11051 | 535 | 9 | 2025-08-08 | 0.62 | 2025-07-27 | 24.99 | 1 | SO74253 | 2025-08-03 | 2.00 | 9.35 |
SO74253_2 | 100 | 11051 | 528 | 9 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 2 | SO74253 | 2025-08-03 | 0.40 | 1.87 |
SO74253_3 | 100 | 11051 | 222 | 9 | 2025-08-08 | 0.87 | 2025-07-27 | 34.99 | 3 | SO74253 | 2025-08-03 | 2.80 | 13.09 |
SO74254_1 | 100 | 11079 | 535 | 9 | 2025-08-08 | 0.62 | 2025-07-27 | 24.99 | 1 | SO74254 | 2025-08-03 | 2.00 | 9.35 |
SO74255_1 | 100 | 15154 | 539 | 9 | 2025-08-08 | 0.62 | 2025-07-27 | 24.99 | 1 | SO74255 | 2025-08-03 | 2.00 | 9.35 |
SO74256_1 | 100 | 17250 | 536 | 9 | 2025-08-08 | 0.75 | 2025-07-27 | 29.99 | 1 | SO74256 | 2025-08-03 | 2.40 | 11.22 |
SO74256_2 | 100 | 17250 | 528 | 9 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 2 | SO74256 | 2025-08-03 | 0.40 | 1.87 |
SO74257_1 | 100 | 19091 | 485 | 9 | 2025-08-08 | 0.55 | 2025-07-27 | 21.98 | 1 | SO74257 | 2025-08-03 | 1.76 | 8.22 |
SO74258_1 | 100 | 18304 | 485 | 9 | 2025-08-08 | 0.55 | 2025-07-27 | 21.98 | 1 | SO74258 | 2025-08-03 | 1.76 | 8.22 |
SO74258_2 | 100 | 18304 | 480 | 9 | 2025-08-08 | 0.06 | 2025-07-27 | 2.29 | 2 | SO74258 | 2025-08-03 | 0.18 | 0.86 |
SO74259_1 | 100 | 26772 | 476 | 9 | 2025-08-08 | 1.75 | 2025-07-27 | 69.99 | 1 | SO74259 | 2025-08-03 | 5.60 | 26.18 |
SO74259_2 | 100 | 26772 | 489 | 9 | 2025-08-08 | 1.35 | 2025-07-27 | 53.99 | 2 | SO74259 | 2025-08-03 | 4.32 | 41.57 |
SO74260_1 | 100 | 16486 | 541 | 9 | 2025-08-08 | 0.72 | 2025-07-27 | 28.99 | 1 | SO74260 | 2025-08-03 | 2.32 | 10.84 |
SO74260_2 | 100 | 16486 | 530 | 9 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 2 | SO74260 | 2025-08-03 | 0.40 | 1.87 |
SO74260_3 | 100 | 16486 | 480 | 9 | 2025-08-08 | 0.06 | 2025-07-27 | 2.29 | 3 | SO74260 | 2025-08-03 | 0.18 | 0.86 |
SO74261_1 | 100 | 11733 | 222 | 4 | 2025-08-08 | 0.87 | 2025-07-27 | 34.99 | 1 | SO74261 | 2025-08-03 | 2.80 | 13.09 |
SO74262_1 | 100 | 28258 | 530 | 4 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74262 | 2025-08-03 | 0.40 | 1.87 |
SO74262_2 | 100 | 28258 | 480 | 4 | 2025-08-08 | 0.06 | 2025-07-27 | 2.29 | 2 | SO74262 | 2025-08-03 | 0.18 | 0.86 |
SO74263_1 | 100 | 25189 | 540 | 1 | 2025-08-08 | 0.82 | 2025-07-27 | 32.60 | 1 | SO74263 | 2025-08-03 | 2.61 | 12.19 |
SO74263_2 | 100 | 25189 | 483 | 1 | 2025-08-08 | 3.00 | 2025-07-27 | 120.00 | 2 | SO74263 | 2025-08-03 | 9.60 | 44.88 |
SO74264_1 | 100 | 22187 | 536 | 1 | 2025-08-08 | 0.75 | 2025-07-27 | 29.99 | 1 | SO74264 | 2025-08-03 | 2.40 | 11.22 |
SO74264_2 | 100 | 22187 | 480 | 1 | 2025-08-08 | 0.06 | 2025-07-27 | 2.29 | 2 | SO74264 | 2025-08-03 | 0.18 | 0.86 |
SO74265_1 | 100 | 22105 | 528 | 4 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74265 | 2025-08-03 | 0.40 | 1.87 |
SO74265_2 | 100 | 22105 | 536 | 4 | 2025-08-08 | 0.75 | 2025-07-27 | 29.99 | 2 | SO74265 | 2025-08-03 | 2.40 | 11.22 |
SO74265_3 | 100 | 22105 | 480 | 4 | 2025-08-08 | 0.06 | 2025-07-27 | 2.29 | 3 | SO74265 | 2025-08-03 | 0.18 | 0.86 |
SO74265_4 | 100 | 22105 | 484 | 4 | 2025-08-08 | 0.20 | 2025-07-27 | 7.95 | 4 | SO74265 | 2025-08-03 | 0.64 | 2.97 |
SO74266_1 | 100 | 20757 | 475 | 1 | 2025-08-08 | 1.75 | 2025-07-27 | 69.99 | 1 | SO74266 | 2025-08-03 | 5.60 | 26.18 |
SO74267_1 | 100 | 16368 | 477 | 1 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74267 | 2025-08-03 | 0.40 | 1.87 |
SO74267_2 | 100 | 16368 | 217 | 1 | 2025-08-08 | 0.87 | 2025-07-27 | 34.99 | 2 | SO74267 | 2025-08-03 | 2.80 | 13.09 |
SO74267_3 | 100 | 16368 | 228 | 1 | 2025-08-08 | 1.25 | 2025-07-27 | 49.99 | 3 | SO74267 | 2025-08-03 | 4.00 | 38.49 |
SO74267_4 | 100 | 16368 | 225 | 1 | 2025-08-08 | 0.22 | 2025-07-27 | 8.99 | 4 | SO74267 | 2025-08-03 | 0.72 | 6.92 |
SO74268_1 | 100 | 21925 | 528 | 6 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74268 | 2025-08-03 | 0.40 | 1.87 |
SO74268_2 | 100 | 21925 | 480 | 6 | 2025-08-08 | 0.06 | 2025-07-27 | 2.29 | 2 | SO74268 | 2025-08-03 | 0.18 | 0.86 |
SO74269_1 | 100 | 14546 | 475 | 10 | 2025-08-08 | 1.75 | 2025-07-27 | 69.99 | 1 | SO74269 | 2025-08-03 | 5.60 | 26.18 |
SO74269_2 | 100 | 14546 | 491 | 10 | 2025-08-08 | 1.35 | 2025-07-27 | 53.99 | 2 | SO74269 | 2025-08-03 | 4.32 | 41.57 |
SO74270_1 | 100 | 23768 | 477 | 10 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74270 | 2025-08-03 | 0.40 | 1.87 |
SO74270_2 | 100 | 23768 | 465 | 10 | 2025-08-08 | 0.61 | 2025-07-27 | 24.49 | 2 | SO74270 | 2025-08-03 | 1.96 | 9.16 |
SO74271_1 | 100 | 12606 | 529 | 7 | 2025-08-08 | 0.10 | 2025-07-27 | 3.99 | 1 | SO74271 | 2025-08-03 | 0.32 | 1.49 |
SO74271_2 | 100 | 12606 | 217 | 7 | 2025-08-08 | 0.87 | 2025-07-27 | 34.99 | 2 | SO74271 | 2025-08-03 | 2.80 | 13.09 |
SO74271_3 | 100 | 12606 | 225 | 7 | 2025-08-08 | 0.22 | 2025-07-27 | 8.99 | 3 | SO74271 | 2025-08-03 | 0.72 | 6.92 |
SO74272_1 | 100 | 11142 | 537 | 6 | 2025-08-08 | 0.88 | 2025-07-27 | 35.00 | 1 | SO74272 | 2025-08-03 | 2.80 | 13.09 |
SO74272_2 | 100 | 11142 | 528 | 6 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 2 | SO74272 | 2025-08-03 | 0.40 | 1.87 |
SO74272_3 | 100 | 11142 | 214 | 6 | 2025-08-08 | 0.87 | 2025-07-27 | 34.99 | 3 | SO74272 | 2025-08-03 | 2.80 | 13.09 |
SO74273_1 | 100 | 25570 | 530 | 7 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74273 | 2025-08-03 | 0.40 | 1.87 |
SO74273_2 | 100 | 25570 | 465 | 7 | 2025-08-08 | 0.61 | 2025-07-27 | 24.49 | 2 | SO74273 | 2025-08-03 | 1.96 | 9.16 |
SO74274_1 | 100 | 28917 | 530 | 7 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74274 | 2025-08-03 | 0.40 | 1.87 |
SO74274_2 | 100 | 28917 | 487 | 7 | 2025-08-08 | 1.37 | 2025-07-27 | 54.99 | 2 | SO74274 | 2025-08-03 | 4.40 | 20.57 |
SO74274_3 | 100 | 28917 | 463 | 7 | 2025-08-08 | 0.61 | 2025-07-27 | 24.49 | 3 | SO74274 | 2025-08-03 | 1.96 | 9.16 |
SO74275_1 | 100 | 11383 | 477 | 7 | 2025-08-08 | 0.12 | 2025-07-27 | 4.99 | 1 | SO74275 | 2025-08-03 | 0.40 | 1.87 |
SO74275_2 | 100 | 11383 | 479 | 7 | 2025-08-08 | 0.22 | 2025-07-27 | 8.99 | 2 | SO74275 | 2025-08-03 | 0.72 | 3.36 |
SO74275_3 | 100 | 11383 | 214 | 7 | 2025-08-08 | 0.87 | 2025-07-27 | 34.99 | 3 | SO74275 | 2025-08-03 | 2.80 | 13.09 |
SO74276_1 | 100 | 17491 | 485 | 6 | 2025-08-08 | 0.55 | 2025-07-27 | 21.98 | 1 | SO74276 | 2025-08-03 | 1.76 | 8.22 |
SO74276_2 | 100 | 17491 | 222 | 6 | 2025-08-08 | 0.87 | 2025-07-27 | 34.99 | 2 | SO74276 | 2025-08-03 | 2.80 | 13.09 |
Generated 2025-08-23 19:58:58.406 UTC