[ROOT] dt FactInternetSale < WHERE OrderDate EQ 20DaysAgo >
63 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO74470_1 | 100 | 13172 | 483 | 1 | 2025-08-10 | 3.00 | 2025-07-29 | 120.00 | 1 | SO74470 | 2025-08-05 | 9.60 | 44.88 |
SO74471_1 | 100 | 12149 | 484 | 1 | 2025-08-10 | 0.20 | 2025-07-29 | 7.95 | 1 | SO74471 | 2025-08-05 | 0.64 | 2.97 |
SO74472_1 | 100 | 14228 | 535 | 9 | 2025-08-10 | 0.62 | 2025-07-29 | 24.99 | 1 | SO74472 | 2025-08-05 | 2.00 | 9.35 |
SO74473_1 | 100 | 17068 | 536 | 9 | 2025-08-10 | 0.75 | 2025-07-29 | 29.99 | 1 | SO74473 | 2025-08-05 | 2.40 | 11.22 |
SO74473_2 | 100 | 17068 | 481 | 9 | 2025-08-10 | 0.22 | 2025-07-29 | 8.99 | 2 | SO74473 | 2025-08-05 | 0.72 | 3.36 |
SO74474_1 | 100 | 15607 | 214 | 9 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 1 | SO74474 | 2025-08-05 | 2.80 | 13.09 |
SO74474_2 | 100 | 15607 | 465 | 9 | 2025-08-10 | 0.61 | 2025-07-29 | 24.49 | 2 | SO74474 | 2025-08-05 | 1.96 | 9.16 |
SO74475_1 | 100 | 13624 | 529 | 9 | 2025-08-10 | 0.10 | 2025-07-29 | 3.99 | 1 | SO74475 | 2025-08-05 | 0.32 | 1.49 |
SO74476_1 | 100 | 19603 | 541 | 9 | 2025-08-10 | 0.72 | 2025-07-29 | 28.99 | 1 | SO74476 | 2025-08-05 | 2.32 | 10.84 |
SO74476_2 | 100 | 19603 | 530 | 9 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 2 | SO74476 | 2025-08-05 | 0.40 | 1.87 |
SO74477_1 | 100 | 11730 | 214 | 1 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 1 | SO74477 | 2025-08-05 | 2.80 | 13.09 |
SO74478_1 | 100 | 11639 | 480 | 4 | 2025-08-10 | 0.06 | 2025-07-29 | 2.29 | 1 | SO74478 | 2025-08-05 | 0.18 | 0.86 |
SO74479_1 | 100 | 11085 | 529 | 4 | 2025-08-10 | 0.10 | 2025-07-29 | 3.99 | 1 | SO74479 | 2025-08-05 | 0.32 | 1.49 |
SO74479_2 | 100 | 11085 | 228 | 4 | 2025-08-10 | 1.25 | 2025-07-29 | 49.99 | 2 | SO74479 | 2025-08-05 | 4.00 | 38.49 |
SO74480_1 | 100 | 11091 | 539 | 6 | 2025-08-10 | 0.62 | 2025-07-29 | 24.99 | 1 | SO74480 | 2025-08-05 | 2.00 | 9.35 |
SO74480_2 | 100 | 11091 | 529 | 6 | 2025-08-10 | 0.10 | 2025-07-29 | 3.99 | 2 | SO74480 | 2025-08-05 | 0.32 | 1.49 |
SO74481_1 | 100 | 20082 | 540 | 6 | 2025-08-10 | 0.82 | 2025-07-29 | 32.60 | 1 | SO74481 | 2025-08-05 | 2.61 | 12.19 |
SO74481_2 | 100 | 20082 | 529 | 6 | 2025-08-10 | 0.10 | 2025-07-29 | 3.99 | 2 | SO74481 | 2025-08-05 | 0.32 | 1.49 |
SO74481_3 | 100 | 20082 | 214 | 6 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 3 | SO74481 | 2025-08-05 | 2.80 | 13.09 |
SO74481_4 | 100 | 20082 | 481 | 6 | 2025-08-10 | 0.22 | 2025-07-29 | 8.99 | 4 | SO74481 | 2025-08-05 | 0.72 | 3.36 |
SO74482_1 | 100 | 25282 | 540 | 4 | 2025-08-10 | 0.82 | 2025-07-29 | 32.60 | 1 | SO74482 | 2025-08-05 | 2.61 | 12.19 |
SO74483_1 | 100 | 22014 | 535 | 6 | 2025-08-10 | 0.62 | 2025-07-29 | 24.99 | 1 | SO74483 | 2025-08-05 | 2.00 | 9.35 |
SO74483_2 | 100 | 22014 | 528 | 6 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 2 | SO74483 | 2025-08-05 | 0.40 | 1.87 |
SO74483_3 | 100 | 22014 | 480 | 6 | 2025-08-10 | 0.06 | 2025-07-29 | 2.29 | 3 | SO74483 | 2025-08-05 | 0.18 | 0.86 |
SO74483_4 | 100 | 22014 | 484 | 6 | 2025-08-10 | 0.20 | 2025-07-29 | 7.95 | 4 | SO74483 | 2025-08-05 | 0.64 | 2.97 |
SO74484_1 | 100 | 24667 | 529 | 1 | 2025-08-10 | 0.10 | 2025-07-29 | 3.99 | 1 | SO74484 | 2025-08-05 | 0.32 | 1.49 |
SO74484_2 | 100 | 24667 | 540 | 1 | 2025-08-10 | 0.82 | 2025-07-29 | 32.60 | 2 | SO74484 | 2025-08-05 | 2.61 | 12.19 |
SO74485_1 | 100 | 18317 | 536 | 6 | 2025-08-10 | 0.75 | 2025-07-29 | 29.99 | 1 | SO74485 | 2025-08-05 | 2.40 | 11.22 |
SO74485_2 | 100 | 18317 | 482 | 6 | 2025-08-10 | 0.22 | 2025-07-29 | 8.99 | 2 | SO74485 | 2025-08-05 | 0.72 | 3.36 |
SO74486_1 | 100 | 24259 | 536 | 1 | 2025-08-10 | 0.75 | 2025-07-29 | 29.99 | 1 | SO74486 | 2025-08-05 | 2.40 | 11.22 |
SO74487_1 | 100 | 13096 | 536 | 6 | 2025-08-10 | 0.75 | 2025-07-29 | 29.99 | 1 | SO74487 | 2025-08-05 | 2.40 | 11.22 |
SO74488_1 | 100 | 12431 | 476 | 6 | 2025-08-10 | 1.75 | 2025-07-29 | 69.99 | 1 | SO74488 | 2025-08-05 | 5.60 | 26.18 |
SO74489_1 | 100 | 18555 | 477 | 4 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74489 | 2025-08-05 | 0.40 | 1.87 |
SO74490_1 | 100 | 22969 | 528 | 6 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74490 | 2025-08-05 | 0.40 | 1.87 |
SO74490_2 | 100 | 22969 | 217 | 6 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 2 | SO74490 | 2025-08-05 | 2.80 | 13.09 |
SO74491_1 | 100 | 22771 | 528 | 6 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74491 | 2025-08-05 | 0.40 | 1.87 |
SO74491_2 | 100 | 22771 | 485 | 6 | 2025-08-10 | 0.55 | 2025-07-29 | 21.98 | 2 | SO74491 | 2025-08-05 | 1.76 | 8.22 |
SO74491_3 | 100 | 22771 | 234 | 6 | 2025-08-10 | 1.25 | 2025-07-29 | 49.99 | 3 | SO74491 | 2025-08-05 | 4.00 | 38.49 |
SO74492_1 | 100 | 15381 | 528 | 1 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74492 | 2025-08-05 | 0.40 | 1.87 |
SO74493_1 | 100 | 19411 | 528 | 6 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74493 | 2025-08-05 | 0.40 | 1.87 |
SO74493_2 | 100 | 19411 | 222 | 6 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 2 | SO74493 | 2025-08-05 | 2.80 | 13.09 |
SO74494_1 | 100 | 28466 | 474 | 7 | 2025-08-10 | 1.75 | 2025-07-29 | 69.99 | 1 | SO74494 | 2025-08-05 | 5.60 | 26.18 |
SO74494_2 | 100 | 28466 | 228 | 7 | 2025-08-10 | 1.25 | 2025-07-29 | 49.99 | 2 | SO74494 | 2025-08-05 | 4.00 | 38.49 |
SO74495_1 | 100 | 16583 | 528 | 8 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74495 | 2025-08-05 | 0.40 | 1.87 |
SO74495_2 | 100 | 16583 | 537 | 8 | 2025-08-10 | 0.88 | 2025-07-29 | 35.00 | 2 | SO74495 | 2025-08-05 | 2.80 | 13.09 |
SO74495_3 | 100 | 16583 | 480 | 8 | 2025-08-10 | 0.06 | 2025-07-29 | 2.29 | 3 | SO74495 | 2025-08-05 | 0.18 | 0.86 |
SO74496_1 | 100 | 22482 | 477 | 8 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74496 | 2025-08-05 | 0.40 | 1.87 |
SO74496_2 | 100 | 22482 | 217 | 8 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 2 | SO74496 | 2025-08-05 | 2.80 | 13.09 |
SO74497_1 | 100 | 20938 | 536 | 10 | 2025-08-10 | 0.75 | 2025-07-29 | 29.99 | 1 | SO74497 | 2025-08-05 | 2.40 | 11.22 |
SO74497_2 | 100 | 20938 | 528 | 10 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 2 | SO74497 | 2025-08-05 | 0.40 | 1.87 |
SO74497_3 | 100 | 20938 | 228 | 10 | 2025-08-10 | 1.25 | 2025-07-29 | 49.99 | 3 | SO74497 | 2025-08-05 | 4.00 | 38.49 |
SO74498_1 | 100 | 20919 | 529 | 7 | 2025-08-10 | 0.10 | 2025-07-29 | 3.99 | 1 | SO74498 | 2025-08-05 | 0.32 | 1.49 |
SO74498_2 | 100 | 20919 | 480 | 7 | 2025-08-10 | 0.06 | 2025-07-29 | 2.29 | 2 | SO74498 | 2025-08-05 | 0.18 | 0.86 |
SO74499_1 | 100 | 14196 | 541 | 10 | 2025-08-10 | 0.72 | 2025-07-29 | 28.99 | 1 | SO74499 | 2025-08-05 | 2.32 | 10.84 |
SO74499_2 | 100 | 14196 | 530 | 10 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 2 | SO74499 | 2025-08-05 | 0.40 | 1.87 |
SO74499_3 | 100 | 14196 | 222 | 10 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 3 | SO74499 | 2025-08-05 | 2.80 | 13.09 |
SO74500_1 | 100 | 19469 | 529 | 7 | 2025-08-10 | 0.10 | 2025-07-29 | 3.99 | 1 | SO74500 | 2025-08-05 | 0.32 | 1.49 |
SO74500_2 | 100 | 19469 | 217 | 7 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 2 | SO74500 | 2025-08-05 | 2.80 | 13.09 |
SO74501_1 | 100 | 11957 | 528 | 1 | 2025-08-10 | 0.12 | 2025-07-29 | 4.99 | 1 | SO74501 | 2025-08-05 | 0.40 | 1.87 |
SO74501_2 | 100 | 11957 | 537 | 1 | 2025-08-10 | 0.88 | 2025-07-29 | 35.00 | 2 | SO74501 | 2025-08-05 | 2.80 | 13.09 |
SO74501_3 | 100 | 11957 | 480 | 1 | 2025-08-10 | 0.06 | 2025-07-29 | 2.29 | 3 | SO74501 | 2025-08-05 | 0.18 | 0.86 |
SO74502_1 | 100 | 11441 | 225 | 7 | 2025-08-10 | 0.22 | 2025-07-29 | 8.99 | 1 | SO74502 | 2025-08-05 | 0.72 | 6.92 |
SO74502_2 | 100 | 11441 | 222 | 7 | 2025-08-10 | 0.87 | 2025-07-29 | 34.99 | 2 | SO74502 | 2025-08-05 | 2.80 | 13.09 |
Generated 2025-08-18 05:31:00.297 UTC