[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 1000 < SKIP 3306 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55515_1 | 100 | 29075 | 529 | 1 | 2023-12-06 | 0.10 | 2023-11-24 | 3.99 | 1 | SO55515 | 2023-12-01 | 0.32 | 1.49 | |
SO55515_2 | 100 | 29075 | 472 | 1 | 2023-12-06 | 1.59 | 2023-11-24 | 63.50 | 2 | SO55515 | 2023-12-01 | 5.08 | 23.75 | |
SO55517_1 | 100 | 28266 | 530 | 1 | 2023-12-06 | 0.12 | 2023-11-24 | 4.99 | 1 | SO55517 | 2023-12-01 | 0.40 | 1.87 | |
SO55518_1 | 100 | 26349 | 535 | 1 | 2023-12-06 | 0.62 | 2023-11-24 | 24.99 | 1 | SO55518 | 2023-12-01 | 2.00 | 9.35 | |
SO55518_2 | 100 | 26349 | 480 | 1 | 2023-12-06 | 0.06 | 2023-11-24 | 2.29 | 2 | SO55518 | 2023-12-01 | 0.18 | 0.86 | |
SO55520_1 | 100 | 24737 | 540 | 1 | 2023-12-06 | 0.82 | 2023-11-24 | 32.60 | 1 | SO55520 | 2023-12-01 | 2.61 | 12.19 | |
SO55520_2 | 100 | 24737 | 529 | 1 | 2023-12-06 | 0.10 | 2023-11-24 | 3.99 | 2 | SO55520 | 2023-12-01 | 0.32 | 1.49 | |
SO55520_3 | 100 | 24737 | 480 | 2 | 1 | 2023-12-06 | 0.06 | 2023-11-24 | 2.29 | 3 | SO55520 | 2023-12-01 | 0.18 | 0.86 |
SO55520_4 | 100 | 24737 | 484 | 1 | 2023-12-06 | 0.20 | 2023-11-24 | 7.95 | 4 | SO55520 | 2023-12-01 | 0.64 | 2.97 | |
SO55525_1 | 100 | 17526 | 477 | 1 | 2023-12-06 | 0.12 | 2023-11-24 | 4.99 | 1 | SO55525 | 2023-12-01 | 0.40 | 1.87 | |
SO55528_1 | 100 | 18104 | 477 | 1 | 2023-12-06 | 0.12 | 2023-11-24 | 4.99 | 1 | SO55528 | 2023-12-01 | 0.40 | 1.87 | |
SO55528_2 | 100 | 18104 | 225 | 1 | 2023-12-06 | 0.22 | 2023-11-24 | 8.99 | 2 | SO55528 | 2023-12-01 | 0.72 | 6.92 | |
SO55537_1 | 100 | 14036 | 587 | 1 | 2023-12-06 | 19.24 | 2023-11-24 | 769.49 | 1 | SO55537 | 2023-12-01 | 61.56 | 419.78 | |
SO55537_2 | 100 | 14036 | 474 | 1 | 2023-12-06 | 1.75 | 2023-11-24 | 69.99 | 2 | SO55537 | 2023-12-01 | 5.60 | 26.18 | |
SO69261_2 | 100 | 25915 | 225 | 1 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 2 | SO69261 | 2024-06-26 | 0.72 | 6.92 | |
SO69261_3 | 100 | 25915 | 530 | 1 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 3 | SO69261 | 2024-06-26 | 0.40 | 1.87 | |
SO69268_1 | 100 | 21592 | 477 | 1 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 1 | SO69268 | 2024-06-26 | 0.40 | 1.87 | |
SO69268_2 | 100 | 21592 | 478 | 1 | 2024-07-01 | 0.25 | 2024-06-19 | 9.99 | 2 | SO69268 | 2024-06-26 | 0.80 | 3.74 | |
SO69268_3 | 100 | 21592 | 225 | 1 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 3 | SO69268 | 2024-06-26 | 0.72 | 6.92 | |
SO69269_1 | 100 | 20113 | 476 | 1 | 2024-07-01 | 1.75 | 2024-06-19 | 69.99 | 1 | SO69269 | 2024-06-26 | 5.60 | 26.18 | |
SO69275_1 | 100 | 17675 | 528 | 1 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 1 | SO69275 | 2024-06-26 | 0.40 | 1.87 | |
SO69275_2 | 100 | 17675 | 483 | 1 | 2024-07-01 | 3.00 | 2024-06-19 | 120.00 | 2 | SO69275 | 2024-06-26 | 9.60 | 44.88 | |
SO69288_1 | 100 | 13063 | 363 | 1 | 2024-07-01 | 57.37 | 2024-06-19 | 2294.99 | 1 | SO69288 | 2024-06-26 | 183.60 | 1251.98 | |
SO69288_2 | 100 | 13063 | 214 | 1 | 2024-07-01 | 0.87 | 2024-06-19 | 34.99 | 2 | SO69288 | 2024-06-26 | 2.80 | 13.09 | |
SO69292_1 | 100 | 15252 | 590 | 1 | 2024-07-01 | 19.24 | 2024-06-19 | 769.49 | 1 | SO69292 | 2024-06-26 | 61.56 | 419.78 | |
SO69329_1 | 100 | 26464 | 535 | 1 | 2024-07-02 | 0.62 | 2024-06-20 | 24.99 | 1 | SO69329 | 2024-06-27 | 2.00 | 9.35 | |
SO69329_2 | 100 | 26464 | 222 | 1 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 2 | SO69329 | 2024-06-27 | 2.80 | 13.09 | |
SO69331_1 | 100 | 23053 | 536 | 1 | 2024-07-02 | 0.75 | 2024-06-20 | 29.99 | 1 | SO69331 | 2024-06-27 | 2.40 | 11.22 | |
SO69331_2 | 100 | 23053 | 528 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 2 | SO69331 | 2024-06-27 | 0.40 | 1.87 | |
SO69331_3 | 100 | 23053 | 222 | 1 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 3 | SO69331 | 2024-06-27 | 2.80 | 13.09 | |
SO69336_1 | 100 | 18579 | 474 | 1 | 2024-07-02 | 1.75 | 2024-06-20 | 69.99 | 1 | SO69336 | 2024-06-27 | 5.60 | 26.18 | |
SO69338_1 | 100 | 15977 | 528 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69338 | 2024-06-27 | 0.40 | 1.87 | |
SO69338_2 | 100 | 15977 | 217 | 1 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 2 | SO69338 | 2024-06-27 | 2.80 | 13.09 | |
SO69341_1 | 100 | 15421 | 528 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69341 | 2024-06-27 | 0.40 | 1.87 | |
SO69342_1 | 100 | 16367 | 477 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69342 | 2024-06-27 | 0.40 | 1.87 | |
SO69342_2 | 100 | 16367 | 222 | 1 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 2 | SO69342 | 2024-06-27 | 2.80 | 13.09 | |
SO69343_1 | 100 | 14624 | 528 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69343 | 2024-06-27 | 0.40 | 1.87 | |
SO69343_2 | 100 | 14624 | 217 | 1 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 2 | SO69343 | 2024-06-27 | 2.80 | 13.09 | |
SO69344_1 | 100 | 13930 | 485 | 1 | 2024-07-02 | 0.55 | 2024-06-20 | 21.98 | 1 | SO69344 | 2024-06-27 | 1.76 | 8.22 | |
SO69344_2 | 100 | 13930 | 472 | 1 | 2024-07-02 | 1.59 | 2024-06-20 | 63.50 | 2 | SO69344 | 2024-06-27 | 5.08 | 23.75 | |
SO69344_3 | 100 | 13930 | 487 | 1 | 2024-07-02 | 1.37 | 2024-06-20 | 54.99 | 3 | SO69344 | 2024-06-27 | 4.40 | 20.57 | |
SO69345_1 | 100 | 15243 | 485 | 1 | 2024-07-02 | 0.55 | 2024-06-20 | 21.98 | 1 | SO69345 | 2024-06-27 | 1.76 | 8.22 | |
SO69345_2 | 100 | 15243 | 478 | 1 | 2024-07-02 | 0.25 | 2024-06-20 | 9.99 | 2 | SO69345 | 2024-06-27 | 0.80 | 3.74 | |
SO69345_3 | 100 | 15243 | 477 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 3 | SO69345 | 2024-06-27 | 0.40 | 1.87 | |
SO69364_1 | 100 | 19842 | 600 | 1 | 2024-07-02 | 13.50 | 2024-06-20 | 539.99 | 1 | SO69364 | 2024-06-27 | 43.20 | 294.58 | |
SO69364_2 | 100 | 19842 | 485 | 1 | 2024-07-02 | 0.55 | 2024-06-20 | 21.98 | 2 | SO69364 | 2024-06-27 | 1.76 | 8.22 | |
SO69364_3 | 100 | 19842 | 480 | 2 | 1 | 2024-07-02 | 0.06 | 2024-06-20 | 2.29 | 3 | SO69364 | 2024-06-27 | 0.18 | 0.86 |
SO69366_1 | 100 | 14915 | 589 | 1 | 2024-07-02 | 19.24 | 2024-06-20 | 769.49 | 1 | SO69366 | 2024-06-27 | 61.56 | 419.78 | |
SO69366_2 | 100 | 14915 | 474 | 1 | 2024-07-02 | 1.75 | 2024-06-20 | 69.99 | 2 | SO69366 | 2024-06-27 | 5.60 | 26.18 | |
SO69370_1 | 100 | 16104 | 355 | 1 | 2024-07-02 | 58.00 | 2024-06-20 | 2319.99 | 1 | SO69370 | 2024-06-27 | 185.60 | 1265.62 | |
SO69370_2 | 100 | 16104 | 528 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 2 | SO69370 | 2024-06-27 | 0.40 | 1.87 | |
SO69370_3 | 100 | 16104 | 537 | 1 | 2024-07-02 | 0.88 | 2024-06-20 | 35.00 | 3 | SO69370 | 2024-06-27 | 2.80 | 13.09 | |
SO69370_4 | 100 | 16104 | 487 | 1 | 2024-07-02 | 1.37 | 2024-06-20 | 54.99 | 4 | SO69370 | 2024-06-27 | 4.40 | 20.57 | |
SO69585_1 | 100 | 29039 | 530 | 1 | 2024-07-03 | 0.12 | 2024-06-21 | 4.99 | 1 | SO69585 | 2024-06-28 | 0.40 | 1.87 | |
SO69586_1 | 100 | 28576 | 530 | 1 | 2024-07-03 | 0.12 | 2024-06-21 | 4.99 | 1 | SO69586 | 2024-06-28 | 0.40 | 1.87 | |
SO69586_2 | 100 | 28576 | 222 | 1 | 2024-07-03 | 0.87 | 2024-06-21 | 34.99 | 2 | SO69586 | 2024-06-28 | 2.80 | 13.09 | |
SO69591_1 | 100 | 26063 | 535 | 1 | 2024-07-03 | 0.62 | 2024-06-21 | 24.99 | 1 | SO69591 | 2024-06-28 | 2.00 | 9.35 | |
SO69591_2 | 100 | 26063 | 528 | 1 | 2024-07-03 | 0.12 | 2024-06-21 | 4.99 | 2 | SO69591 | 2024-06-28 | 0.40 | 1.87 | |
SO69592_1 | 100 | 25424 | 529 | 1 | 2024-07-03 | 0.10 | 2024-06-21 | 3.99 | 1 | SO69592 | 2024-06-28 | 0.32 | 1.49 | |
SO69592_2 | 100 | 25424 | 540 | 1 | 2024-07-03 | 0.82 | 2024-06-21 | 32.60 | 2 | SO69592 | 2024-06-28 | 2.61 | 12.19 | |
SO69592_3 | 100 | 25424 | 214 | 1 | 2024-07-03 | 0.87 | 2024-06-21 | 34.99 | 3 | SO69592 | 2024-06-28 | 2.80 | 13.09 | |
SO69593_1 | 100 | 24949 | 540 | 1 | 2024-07-03 | 0.82 | 2024-06-21 | 32.60 | 1 | SO69593 | 2024-06-28 | 2.61 | 12.19 |
Generated 2024-09-20 06:30:05.647 UTC