[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 1500 SKIP 1000 SKIP 0 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO54546_3 | 100 | 23132 | 484 | 4 | 2023-11-20 | 0.20 | 2023-11-08 | 7.95 | 3 | SO54546 | 2023-11-15 | 0.64 | 2.97 | |
SO54546_4 | 100 | 23132 | 483 | 4 | 2023-11-20 | 3.00 | 2023-11-08 | 120.00 | 4 | SO54546 | 2023-11-15 | 9.60 | 44.88 | |
SO54553_1 | 100 | 21698 | 478 | 4 | 2023-11-20 | 0.25 | 2023-11-08 | 9.99 | 1 | SO54553 | 2023-11-15 | 0.80 | 3.74 | |
SO54553_2 | 100 | 21698 | 477 | 4 | 2023-11-20 | 0.12 | 2023-11-08 | 4.99 | 2 | SO54553 | 2023-11-15 | 0.40 | 1.87 | |
SO54556_1 | 100 | 18552 | 477 | 4 | 2023-11-20 | 0.12 | 2023-11-08 | 4.99 | 1 | SO54556 | 2023-11-15 | 0.40 | 1.87 | |
SO54572_1 | 100 | 13938 | 588 | 4 | 2023-11-20 | 19.24 | 2023-11-08 | 769.49 | 1 | SO54572 | 2023-11-15 | 61.56 | 419.78 | |
SO54572_2 | 100 | 13938 | 536 | 4 | 2023-11-20 | 0.75 | 2023-11-08 | 29.99 | 2 | SO54572 | 2023-11-15 | 2.40 | 11.22 | |
SO54572_3 | 100 | 13938 | 528 | 4 | 2023-11-20 | 0.12 | 2023-11-08 | 4.99 | 3 | SO54572 | 2023-11-15 | 0.40 | 1.87 | |
SO54572_4 | 100 | 13938 | 214 | 4 | 2023-11-20 | 0.87 | 2023-11-08 | 34.99 | 4 | SO54572 | 2023-11-15 | 2.80 | 13.09 | |
SO54572_5 | 100 | 13938 | 228 | 4 | 2023-11-20 | 1.25 | 2023-11-08 | 49.99 | 5 | SO54572 | 2023-11-15 | 4.00 | 38.49 | |
SO54573_1 | 100 | 12189 | 359 | 4 | 2023-11-20 | 57.37 | 2023-11-08 | 2294.99 | 1 | SO54573 | 2023-11-15 | 183.60 | 1251.98 | |
SO54573_2 | 100 | 12189 | 485 | 4 | 2023-11-20 | 0.55 | 2023-11-08 | 21.98 | 2 | SO54573 | 2023-11-15 | 1.76 | 8.22 | |
SO54573_3 | 100 | 12189 | 487 | 4 | 2023-11-20 | 1.37 | 2023-11-08 | 54.99 | 3 | SO54573 | 2023-11-15 | 4.40 | 20.57 | |
SO54580_1 | 100 | 28841 | 568 | 13 | 4 | 2023-11-20 | 18.56 | 2023-11-08 | 742.35 | 1 | SO54580 | 2023-11-15 | 59.39 | 461.44 |
SO54580_2 | 100 | 28841 | 479 | 4 | 2023-11-20 | 0.22 | 2023-11-08 | 8.99 | 2 | SO54580 | 2023-11-15 | 0.72 | 3.36 | |
SO54580_3 | 100 | 28841 | 477 | 4 | 2023-11-20 | 0.12 | 2023-11-08 | 4.99 | 3 | SO54580 | 2023-11-15 | 0.40 | 1.87 | |
SO54584_1 | 100 | 21903 | 606 | 4 | 2023-11-20 | 13.50 | 2023-11-08 | 539.99 | 1 | SO54584 | 2023-11-15 | 43.20 | 343.65 | |
SO54584_2 | 100 | 21903 | 225 | 4 | 2023-11-20 | 0.22 | 2023-11-08 | 8.99 | 2 | SO54584 | 2023-11-15 | 0.72 | 6.92 | |
SO54605_1 | 100 | 11199 | 529 | 4 | 2023-11-21 | 0.10 | 2023-11-09 | 3.99 | 1 | SO54605 | 2023-11-16 | 0.32 | 1.49 | |
SO54605_2 | 100 | 11199 | 480 | 4 | 2023-11-21 | 0.06 | 2023-11-09 | 2.29 | 2 | SO54605 | 2023-11-16 | 0.18 | 0.86 | |
SO54608_1 | 100 | 28981 | 539 | 4 | 2023-11-21 | 0.62 | 2023-11-09 | 24.99 | 1 | SO54608 | 2023-11-16 | 2.00 | 9.35 | |
SO54608_2 | 100 | 28981 | 480 | 4 | 2023-11-21 | 0.06 | 2023-11-09 | 2.29 | 2 | SO54608 | 2023-11-16 | 0.18 | 0.86 | |
SO54613_1 | 100 | 22009 | 478 | 4 | 2023-11-21 | 0.25 | 2023-11-09 | 9.99 | 1 | SO54613 | 2023-11-16 | 0.80 | 3.74 | |
SO54615_1 | 100 | 22226 | 528 | 4 | 2023-11-21 | 0.12 | 2023-11-09 | 4.99 | 1 | SO54615 | 2023-11-16 | 0.40 | 1.87 | |
SO54615_2 | 100 | 22226 | 536 | 4 | 2023-11-21 | 0.75 | 2023-11-09 | 29.99 | 2 | SO54615 | 2023-11-16 | 2.40 | 11.22 | |
SO54619_1 | 100 | 20308 | 474 | 4 | 2023-11-21 | 1.75 | 2023-11-09 | 69.99 | 1 | SO54619 | 2023-11-16 | 5.60 | 26.18 | |
SO54621_1 | 100 | 18521 | 475 | 4 | 2023-11-21 | 1.75 | 2023-11-09 | 69.99 | 1 | SO54621 | 2023-11-16 | 5.60 | 26.18 | |
SO54621_2 | 100 | 18521 | 228 | 4 | 2023-11-21 | 1.25 | 2023-11-09 | 49.99 | 2 | SO54621 | 2023-11-16 | 4.00 | 38.49 | |
SO54622_1 | 100 | 18601 | 475 | 4 | 2023-11-21 | 1.75 | 2023-11-09 | 69.99 | 1 | SO54622 | 2023-11-16 | 5.60 | 26.18 | |
SO54624_1 | 100 | 16965 | 477 | 4 | 2023-11-21 | 0.12 | 2023-11-09 | 4.99 | 1 | SO54624 | 2023-11-16 | 0.40 | 1.87 | |
SO54624_2 | 100 | 16965 | 222 | 4 | 2023-11-21 | 0.87 | 2023-11-09 | 34.99 | 2 | SO54624 | 2023-11-16 | 2.80 | 13.09 | |
SO54644_1 | 100 | 12169 | 359 | 4 | 2023-11-21 | 57.37 | 2023-11-09 | 2294.99 | 1 | SO54644 | 2023-11-16 | 183.60 | 1251.98 | |
SO54644_2 | 100 | 12169 | 537 | 4 | 2023-11-21 | 0.88 | 2023-11-09 | 35.00 | 2 | SO54644 | 2023-11-16 | 2.80 | 13.09 | |
SO54644_3 | 100 | 12169 | 528 | 4 | 2023-11-21 | 0.12 | 2023-11-09 | 4.99 | 3 | SO54644 | 2023-11-16 | 0.40 | 1.87 | |
SO54644_4 | 100 | 12169 | 217 | 4 | 2023-11-21 | 0.87 | 2023-11-09 | 34.99 | 4 | SO54644 | 2023-11-16 | 2.80 | 13.09 | |
SO54645_1 | 100 | 12172 | 363 | 4 | 2023-11-21 | 57.37 | 2023-11-09 | 2294.99 | 1 | SO54645 | 2023-11-16 | 183.60 | 1251.98 | |
SO54645_2 | 100 | 12172 | 485 | 4 | 2023-11-21 | 0.55 | 2023-11-09 | 21.98 | 2 | SO54645 | 2023-11-16 | 1.76 | 8.22 | |
SO54645_3 | 100 | 12172 | 217 | 4 | 2023-11-21 | 0.87 | 2023-11-09 | 34.99 | 3 | SO54645 | 2023-11-16 | 2.80 | 13.09 | |
SO54647_1 | 100 | 12112 | 363 | 4 | 2023-11-21 | 57.37 | 2023-11-09 | 2294.99 | 1 | SO54647 | 2023-11-16 | 183.60 | 1251.98 | |
SO54647_2 | 100 | 12112 | 485 | 4 | 2023-11-21 | 0.55 | 2023-11-09 | 21.98 | 2 | SO54647 | 2023-11-16 | 1.76 | 8.22 | |
SO54647_3 | 100 | 12112 | 214 | 4 | 2023-11-21 | 0.87 | 2023-11-09 | 34.99 | 3 | SO54647 | 2023-11-16 | 2.80 | 13.09 | |
SO54651_1 | 100 | 25204 | 577 | 4 | 2023-11-21 | 30.37 | 2023-11-09 | 1214.85 | 1 | SO54651 | 2023-11-16 | 97.19 | 755.15 | |
SO54651_2 | 100 | 25204 | 217 | 4 | 2023-11-21 | 0.87 | 2023-11-09 | 34.99 | 2 | SO54651 | 2023-11-16 | 2.80 | 13.09 | |
SO54652_1 | 100 | 22042 | 604 | 4 | 2023-11-21 | 13.50 | 2023-11-09 | 539.99 | 1 | SO54652 | 2023-11-16 | 43.20 | 343.65 | |
SO54680_1 | 100 | 23795 | 529 | 4 | 2023-11-22 | 0.10 | 2023-11-10 | 3.99 | 1 | SO54680 | 2023-11-17 | 0.32 | 1.49 | |
SO54680_2 | 100 | 23795 | 540 | 4 | 2023-11-22 | 0.82 | 2023-11-10 | 32.60 | 2 | SO54680 | 2023-11-17 | 2.61 | 12.19 | |
SO54680_3 | 100 | 23795 | 217 | 4 | 2023-11-22 | 0.87 | 2023-11-10 | 34.99 | 3 | SO54680 | 2023-11-17 | 2.80 | 13.09 | |
SO54681_1 | 100 | 23722 | 536 | 4 | 2023-11-22 | 0.75 | 2023-11-10 | 29.99 | 1 | SO54681 | 2023-11-17 | 2.40 | 11.22 | |
SO54681_2 | 100 | 23722 | 480 | 2 | 4 | 2023-11-22 | 0.06 | 2023-11-10 | 2.29 | 2 | SO54681 | 2023-11-17 | 0.18 | 0.86 |
SO54684_1 | 100 | 17169 | 477 | 4 | 2023-11-22 | 0.12 | 2023-11-10 | 4.99 | 1 | SO54684 | 2023-11-17 | 0.40 | 1.87 | |
SO54694_1 | 100 | 11140 | 528 | 4 | 2023-11-22 | 0.12 | 2023-11-10 | 4.99 | 1 | SO54694 | 2023-11-17 | 0.40 | 1.87 | |
SO54694_2 | 100 | 11140 | 537 | 4 | 2023-11-22 | 0.88 | 2023-11-10 | 35.00 | 2 | SO54694 | 2023-11-17 | 2.80 | 13.09 | |
SO54696_1 | 100 | 12137 | 537 | 4 | 2023-11-22 | 0.88 | 2023-11-10 | 35.00 | 1 | SO54696 | 2023-11-17 | 2.80 | 13.09 | |
SO54696_2 | 100 | 12137 | 528 | 4 | 2023-11-22 | 0.12 | 2023-11-10 | 4.99 | 2 | SO54696 | 2023-11-17 | 0.40 | 1.87 | |
SO54696_3 | 100 | 12137 | 480 | 4 | 2023-11-22 | 0.06 | 2023-11-10 | 2.29 | 3 | SO54696 | 2023-11-17 | 0.18 | 0.86 | |
SO54700_1 | 100 | 16895 | 580 | 4 | 2023-11-22 | 42.52 | 2023-11-10 | 1700.99 | 1 | SO54700 | 2023-11-17 | 136.08 | 1082.51 | |
SO54700_2 | 100 | 16895 | 222 | 4 | 2023-11-22 | 0.87 | 2023-11-10 | 34.99 | 2 | SO54700 | 2023-11-17 | 2.80 | 13.09 | |
SO54700_3 | 100 | 16895 | 467 | 4 | 2023-11-22 | 0.61 | 2023-11-10 | 24.49 | 3 | SO54700 | 2023-11-17 | 1.96 | 9.16 | |
SO54708_1 | 100 | 25339 | 225 | 4 | 2023-11-22 | 0.22 | 2023-11-10 | 8.99 | 1 | SO54708 | 2023-11-17 | 0.72 | 6.92 | |
SO54708_2 | 100 | 25339 | 560 | 2 | 4 | 2023-11-22 | 30.37 | 2023-11-10 | 1214.85 | 2 | SO54708 | 2023-11-17 | 97.19 | 755.15 |
Generated 2024-09-20 20:34:07.290 UTC