[ROOT] dt FactInternetSale < WHERE OrderDate EQ 29DaysAgo >
83 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO74185_1 | 100 | 12148 | 484 | 1 | 2025-08-07 | 0.20 | 2025-07-26 | 7.95 | 1 | SO74185 | 2025-08-02 | 0.64 | 2.97 |
SO74186_1 | 100 | 13023 | 528 | 9 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74186 | 2025-08-02 | 0.40 | 1.87 |
SO74186_2 | 100 | 13023 | 535 | 9 | 2025-08-07 | 0.62 | 2025-07-26 | 24.99 | 2 | SO74186 | 2025-08-02 | 2.00 | 9.35 |
SO74187_1 | 100 | 19597 | 538 | 9 | 2025-08-07 | 0.54 | 2025-07-26 | 21.49 | 1 | SO74187 | 2025-08-02 | 1.72 | 8.04 |
SO74187_2 | 100 | 19597 | 529 | 9 | 2025-08-07 | 0.10 | 2025-07-26 | 3.99 | 2 | SO74187 | 2025-08-02 | 0.32 | 1.49 |
SO74188_1 | 100 | 25117 | 528 | 9 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74188 | 2025-08-02 | 0.40 | 1.87 |
SO74188_2 | 100 | 25117 | 480 | 9 | 2025-08-07 | 0.06 | 2025-07-26 | 2.29 | 2 | SO74188 | 2025-08-02 | 0.18 | 0.86 |
SO74189_1 | 100 | 22149 | 475 | 9 | 2025-08-07 | 1.75 | 2025-07-26 | 69.99 | 1 | SO74189 | 2025-08-02 | 5.60 | 26.18 |
SO74189_2 | 100 | 22149 | 491 | 9 | 2025-08-07 | 1.35 | 2025-07-26 | 53.99 | 2 | SO74189 | 2025-08-02 | 4.32 | 41.57 |
SO74190_1 | 100 | 16342 | 541 | 9 | 2025-08-07 | 0.72 | 2025-07-26 | 28.99 | 1 | SO74190 | 2025-08-02 | 2.32 | 10.84 |
SO74190_2 | 100 | 16342 | 530 | 9 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74190 | 2025-08-02 | 0.40 | 1.87 |
SO74190_3 | 100 | 16342 | 487 | 9 | 2025-08-07 | 1.37 | 2025-07-26 | 54.99 | 3 | SO74190 | 2025-08-02 | 4.40 | 20.57 |
SO74190_4 | 100 | 16342 | 484 | 9 | 2025-08-07 | 0.20 | 2025-07-26 | 7.95 | 4 | SO74190 | 2025-08-02 | 0.64 | 2.97 |
SO74191_1 | 100 | 11715 | 490 | 4 | 2025-08-07 | 1.35 | 2025-07-26 | 53.99 | 1 | SO74191 | 2025-08-02 | 4.32 | 41.57 |
SO74192_1 | 100 | 11276 | 529 | 6 | 2025-08-07 | 0.10 | 2025-07-26 | 3.99 | 1 | SO74192 | 2025-08-02 | 0.32 | 1.49 |
SO74192_2 | 100 | 11276 | 480 | 6 | 2025-08-07 | 0.06 | 2025-07-26 | 2.29 | 2 | SO74192 | 2025-08-02 | 0.18 | 0.86 |
SO74193_1 | 100 | 27372 | 529 | 5 | 2025-08-07 | 0.10 | 2025-07-26 | 3.99 | 1 | SO74193 | 2025-08-02 | 0.32 | 1.49 |
SO74193_2 | 100 | 27372 | 214 | 5 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 2 | SO74193 | 2025-08-02 | 2.80 | 13.09 |
SO74194_1 | 100 | 11530 | 237 | 6 | 2025-08-07 | 1.25 | 2025-07-26 | 49.99 | 1 | SO74194 | 2025-08-02 | 4.00 | 38.49 |
SO74195_1 | 100 | 27629 | 541 | 1 | 2025-08-07 | 0.72 | 2025-07-26 | 28.99 | 1 | SO74195 | 2025-08-02 | 2.32 | 10.84 |
SO74195_2 | 100 | 27629 | 530 | 1 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74195 | 2025-08-02 | 0.40 | 1.87 |
SO74195_3 | 100 | 27629 | 480 | 1 | 2025-08-07 | 0.06 | 2025-07-26 | 2.29 | 3 | SO74195 | 2025-08-02 | 0.18 | 0.86 |
SO74196_1 | 100 | 11276 | 528 | 6 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74196 | 2025-08-02 | 0.40 | 1.87 |
SO74196_2 | 100 | 11276 | 535 | 6 | 2025-08-07 | 0.62 | 2025-07-26 | 24.99 | 2 | SO74196 | 2025-08-02 | 2.00 | 9.35 |
SO74196_3 | 100 | 11276 | 214 | 6 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 3 | SO74196 | 2025-08-02 | 2.80 | 13.09 |
SO74197_1 | 100 | 25838 | 535 | 4 | 2025-08-07 | 0.62 | 2025-07-26 | 24.99 | 1 | SO74197 | 2025-08-02 | 2.00 | 9.35 |
SO74197_2 | 100 | 25838 | 528 | 4 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74197 | 2025-08-02 | 0.40 | 1.87 |
SO74197_3 | 100 | 25838 | 217 | 4 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 3 | SO74197 | 2025-08-02 | 2.80 | 13.09 |
SO74198_1 | 100 | 25934 | 535 | 4 | 2025-08-07 | 0.62 | 2025-07-26 | 24.99 | 1 | SO74198 | 2025-08-02 | 2.00 | 9.35 |
SO74198_2 | 100 | 25934 | 528 | 4 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74198 | 2025-08-02 | 0.40 | 1.87 |
SO74198_3 | 100 | 25934 | 222 | 4 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 3 | SO74198 | 2025-08-02 | 2.80 | 13.09 |
SO74199_1 | 100 | 18320 | 536 | 6 | 2025-08-07 | 0.75 | 2025-07-26 | 29.99 | 1 | SO74199 | 2025-08-02 | 2.40 | 11.22 |
SO74199_2 | 100 | 18320 | 528 | 6 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74199 | 2025-08-02 | 0.40 | 1.87 |
SO74199_3 | 100 | 18320 | 480 | 6 | 2025-08-07 | 0.06 | 2025-07-26 | 2.29 | 3 | SO74199 | 2025-08-02 | 0.18 | 0.86 |
SO74200_1 | 100 | 12055 | 478 | 6 | 2025-08-07 | 0.25 | 2025-07-26 | 9.99 | 1 | SO74200 | 2025-08-02 | 0.80 | 3.74 |
SO74200_2 | 100 | 12055 | 225 | 6 | 2025-08-07 | 0.22 | 2025-07-26 | 8.99 | 2 | SO74200 | 2025-08-02 | 0.72 | 6.92 |
SO74200_3 | 100 | 12055 | 477 | 6 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 3 | SO74200 | 2025-08-02 | 0.40 | 1.87 |
SO74201_1 | 100 | 29282 | 478 | 6 | 2025-08-07 | 0.25 | 2025-07-26 | 9.99 | 1 | SO74201 | 2025-08-02 | 0.80 | 3.74 |
SO74201_2 | 100 | 29282 | 225 | 6 | 2025-08-07 | 0.22 | 2025-07-26 | 8.99 | 2 | SO74201 | 2025-08-02 | 0.72 | 6.92 |
SO74201_3 | 100 | 29282 | 477 | 6 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 3 | SO74201 | 2025-08-02 | 0.40 | 1.87 |
SO74202_1 | 100 | 21278 | 478 | 1 | 2025-08-07 | 0.25 | 2025-07-26 | 9.99 | 1 | SO74202 | 2025-08-02 | 0.80 | 3.74 |
SO74202_2 | 100 | 21278 | 477 | 1 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74202 | 2025-08-02 | 0.40 | 1.87 |
SO74203_1 | 100 | 20490 | 478 | 4 | 2025-08-07 | 0.25 | 2025-07-26 | 9.99 | 1 | SO74203 | 2025-08-02 | 0.80 | 3.74 |
SO74203_2 | 100 | 20490 | 477 | 4 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74203 | 2025-08-02 | 0.40 | 1.87 |
SO74203_3 | 100 | 20490 | 217 | 4 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 3 | SO74203 | 2025-08-02 | 2.80 | 13.09 |
SO74204_1 | 100 | 24255 | 477 | 6 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74204 | 2025-08-02 | 0.40 | 1.87 |
SO74204_2 | 100 | 24255 | 225 | 6 | 2025-08-07 | 0.22 | 2025-07-26 | 8.99 | 2 | SO74204 | 2025-08-02 | 0.72 | 6.92 |
SO74205_1 | 100 | 24967 | 477 | 6 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74205 | 2025-08-02 | 0.40 | 1.87 |
SO74206_1 | 100 | 23485 | 528 | 6 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74206 | 2025-08-02 | 0.40 | 1.87 |
SO74206_2 | 100 | 23485 | 217 | 6 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 2 | SO74206 | 2025-08-02 | 2.80 | 13.09 |
SO74206_3 | 100 | 23485 | 237 | 6 | 2025-08-07 | 1.25 | 2025-07-26 | 49.99 | 3 | SO74206 | 2025-08-02 | 4.00 | 38.49 |
SO74207_1 | 100 | 14533 | 529 | 10 | 2025-08-07 | 0.10 | 2025-07-26 | 3.99 | 1 | SO74207 | 2025-08-02 | 0.32 | 1.49 |
SO74207_2 | 100 | 14533 | 540 | 10 | 2025-08-07 | 0.82 | 2025-07-26 | 32.60 | 2 | SO74207 | 2025-08-02 | 2.61 | 12.19 |
SO74207_3 | 100 | 14533 | 487 | 10 | 2025-08-07 | 1.37 | 2025-07-26 | 54.99 | 3 | SO74207 | 2025-08-02 | 4.40 | 20.57 |
SO74208_1 | 100 | 24533 | 536 | 10 | 2025-08-07 | 0.75 | 2025-07-26 | 29.99 | 1 | SO74208 | 2025-08-02 | 2.40 | 11.22 |
SO74208_2 | 100 | 24533 | 480 | 10 | 2025-08-07 | 0.06 | 2025-07-26 | 2.29 | 2 | SO74208 | 2025-08-02 | 0.18 | 0.86 |
SO74209_1 | 100 | 22809 | 529 | 8 | 2025-08-07 | 0.10 | 2025-07-26 | 3.99 | 1 | SO74209 | 2025-08-02 | 0.32 | 1.49 |
SO74209_2 | 100 | 22809 | 214 | 8 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 2 | SO74209 | 2025-08-02 | 2.80 | 13.09 |
SO74210_1 | 100 | 23913 | 541 | 7 | 2025-08-07 | 0.72 | 2025-07-26 | 28.99 | 1 | SO74210 | 2025-08-02 | 2.32 | 10.84 |
SO74210_2 | 100 | 23913 | 530 | 7 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74210 | 2025-08-02 | 0.40 | 1.87 |
SO74210_3 | 100 | 23913 | 479 | 7 | 2025-08-07 | 0.22 | 2025-07-26 | 8.99 | 3 | SO74210 | 2025-08-02 | 0.72 | 3.36 |
SO74210_4 | 100 | 23913 | 477 | 7 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 4 | SO74210 | 2025-08-02 | 0.40 | 1.87 |
SO74211_1 | 100 | 17706 | 530 | 10 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74211 | 2025-08-02 | 0.40 | 1.87 |
SO74211_2 | 100 | 17706 | 222 | 10 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 2 | SO74211 | 2025-08-02 | 2.80 | 13.09 |
SO74212_1 | 100 | 11133 | 537 | 1 | 2025-08-07 | 0.88 | 2025-07-26 | 35.00 | 1 | SO74212 | 2025-08-02 | 2.80 | 13.09 |
SO74212_2 | 100 | 11133 | 485 | 1 | 2025-08-07 | 0.55 | 2025-07-26 | 21.98 | 2 | SO74212 | 2025-08-02 | 1.76 | 8.22 |
SO74212_3 | 100 | 11133 | 478 | 1 | 2025-08-07 | 0.25 | 2025-07-26 | 9.99 | 3 | SO74212 | 2025-08-02 | 0.80 | 3.74 |
SO74212_4 | 100 | 11133 | 477 | 1 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 4 | SO74212 | 2025-08-02 | 0.40 | 1.87 |
SO74213_1 | 100 | 13797 | 530 | 8 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 1 | SO74213 | 2025-08-02 | 0.40 | 1.87 |
SO74213_2 | 100 | 13797 | 480 | 8 | 2025-08-07 | 0.06 | 2025-07-26 | 2.29 | 2 | SO74213 | 2025-08-02 | 0.18 | 0.86 |
SO74214_1 | 100 | 12205 | 537 | 4 | 2025-08-07 | 0.88 | 2025-07-26 | 35.00 | 1 | SO74214 | 2025-08-02 | 2.80 | 13.09 |
SO74214_2 | 100 | 12205 | 480 | 4 | 2025-08-07 | 0.06 | 2025-07-26 | 2.29 | 2 | SO74214 | 2025-08-02 | 0.18 | 0.86 |
SO74215_1 | 100 | 13390 | 485 | 4 | 2025-08-07 | 0.55 | 2025-07-26 | 21.98 | 1 | SO74215 | 2025-08-02 | 1.76 | 8.22 |
SO74215_2 | 100 | 13390 | 477 | 4 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 2 | SO74215 | 2025-08-02 | 0.40 | 1.87 |
SO74215_3 | 100 | 13390 | 478 | 4 | 2025-08-07 | 0.25 | 2025-07-26 | 9.99 | 3 | SO74215 | 2025-08-02 | 0.80 | 3.74 |
SO74215_4 | 100 | 13390 | 225 | 4 | 2025-08-07 | 0.22 | 2025-07-26 | 8.99 | 4 | SO74215 | 2025-08-02 | 0.72 | 6.92 |
SO74215_5 | 100 | 13390 | 490 | 4 | 2025-08-07 | 1.35 | 2025-07-26 | 53.99 | 5 | SO74215 | 2025-08-02 | 4.32 | 41.57 |
SO74216_1 | 100 | 13321 | 485 | 1 | 2025-08-07 | 0.55 | 2025-07-26 | 21.98 | 1 | SO74216 | 2025-08-02 | 1.76 | 8.22 |
SO74216_2 | 100 | 13321 | 478 | 1 | 2025-08-07 | 0.25 | 2025-07-26 | 9.99 | 2 | SO74216 | 2025-08-02 | 0.80 | 3.74 |
SO74216_3 | 100 | 13321 | 477 | 1 | 2025-08-07 | 0.12 | 2025-07-26 | 4.99 | 3 | SO74216 | 2025-08-02 | 0.40 | 1.87 |
SO74216_4 | 100 | 13321 | 222 | 1 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 4 | SO74216 | 2025-08-02 | 2.80 | 13.09 |
SO74217_1 | 100 | 12478 | 225 | 8 | 2025-08-07 | 0.22 | 2025-07-26 | 8.99 | 1 | SO74217 | 2025-08-02 | 0.72 | 6.92 |
SO74218_1 | 100 | 11595 | 222 | 8 | 2025-08-07 | 0.87 | 2025-07-26 | 34.99 | 1 | SO74218 | 2025-08-02 | 2.80 | 13.09 |
Generated 2025-08-24 07:31:06.956 UTC