[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 140 < SKIP 2000 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59719_3 | 19 | 11841 | 222 | 6 | 2024-04-02 | 0.87 | 2024-03-21 | 34.99 | 3 | SO59719 | 2024-03-28 | 2.80 | 13.09 | |
SO59723_1 | 19 | 11502 | 536 | 6 | 2024-04-02 | 0.75 | 2024-03-21 | 29.99 | 1 | SO59723 | 2024-03-28 | 2.40 | 11.22 | |
SO59723_2 | 19 | 11502 | 528 | 6 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 2 | SO59723 | 2024-03-28 | 0.40 | 1.87 | |
SO59723_3 | 19 | 11502 | 217 | 6 | 2024-04-02 | 0.87 | 2024-03-21 | 34.99 | 3 | SO59723 | 2024-03-28 | 2.80 | 13.09 | |
SO59724_1 | 19 | 19757 | 536 | 6 | 2024-04-02 | 0.75 | 2024-03-21 | 29.99 | 1 | SO59724 | 2024-03-28 | 2.40 | 11.22 | |
SO59724_2 | 19 | 19757 | 480 | 2 | 6 | 2024-04-02 | 0.06 | 2024-03-21 | 2.29 | 2 | SO59724 | 2024-03-28 | 0.18 | 0.86 |
SO59725_1 | 19 | 18314 | 536 | 6 | 2024-04-02 | 0.75 | 2024-03-21 | 29.99 | 1 | SO59725 | 2024-03-28 | 2.40 | 11.22 | |
SO59725_2 | 19 | 18314 | 528 | 6 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 2 | SO59725 | 2024-03-28 | 0.40 | 1.87 | |
SO59726_1 | 19 | 12972 | 478 | 6 | 2024-04-02 | 0.25 | 2024-03-21 | 9.99 | 1 | SO59726 | 2024-03-28 | 0.80 | 3.74 | |
SO59726_2 | 19 | 12972 | 477 | 6 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 2 | SO59726 | 2024-03-28 | 0.40 | 1.87 | |
SO59726_3 | 19 | 12972 | 488 | 6 | 2024-04-02 | 1.35 | 2024-03-21 | 53.99 | 3 | SO59726 | 2024-03-28 | 4.32 | 41.57 | |
SO59731_1 | 19 | 27111 | 477 | 6 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 1 | SO59731 | 2024-03-28 | 0.40 | 1.87 | |
SO59731_2 | 19 | 27111 | 480 | 2 | 6 | 2024-04-02 | 0.06 | 2024-03-21 | 2.29 | 2 | SO59731 | 2024-03-28 | 0.18 | 0.86 |
SO59732_1 | 19 | 27419 | 476 | 6 | 2024-04-02 | 1.75 | 2024-03-21 | 69.99 | 1 | SO59732 | 2024-03-28 | 5.60 | 26.18 | |
SO59733_1 | 19 | 11861 | 477 | 6 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 1 | SO59733 | 2024-03-28 | 0.40 | 1.87 | |
SO59733_2 | 19 | 11861 | 488 | 6 | 2024-04-02 | 1.35 | 2024-03-21 | 53.99 | 2 | SO59733 | 2024-03-28 | 4.32 | 41.57 | |
SO59745_1 | 19 | 15310 | 537 | 6 | 2024-04-02 | 0.88 | 2024-03-21 | 35.00 | 1 | SO59745 | 2024-03-28 | 2.80 | 13.09 | |
SO59745_2 | 19 | 15310 | 528 | 6 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 2 | SO59745 | 2024-03-28 | 0.40 | 1.87 | |
SO59745_3 | 19 | 15310 | 480 | 6 | 2024-04-02 | 0.06 | 2024-03-21 | 2.29 | 3 | SO59745 | 2024-03-28 | 0.18 | 0.86 | |
SO59747_1 | 19 | 11513 | 590 | 6 | 2024-04-02 | 19.24 | 2024-03-21 | 769.49 | 1 | SO59747 | 2024-03-28 | 61.56 | 419.78 | |
SO59747_2 | 19 | 11513 | 528 | 6 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 2 | SO59747 | 2024-03-28 | 0.40 | 1.87 | |
SO59747_3 | 19 | 11513 | 536 | 6 | 2024-04-02 | 0.75 | 2024-03-21 | 29.99 | 3 | SO59747 | 2024-03-28 | 2.40 | 11.22 | |
SO59747_4 | 19 | 11513 | 465 | 6 | 2024-04-02 | 0.61 | 2024-03-21 | 24.49 | 4 | SO59747 | 2024-03-28 | 1.96 | 9.16 | |
SO59747_5 | 19 | 11513 | 222 | 6 | 2024-04-02 | 0.87 | 2024-03-21 | 34.99 | 5 | SO59747 | 2024-03-28 | 2.80 | 13.09 | |
SO59780_1 | 19 | 12202 | 477 | 6 | 2024-04-03 | 0.12 | 2024-03-22 | 4.99 | 1 | SO59780 | 2024-03-29 | 0.40 | 1.87 | |
SO59780_2 | 19 | 12202 | 480 | 2 | 6 | 2024-04-03 | 0.06 | 2024-03-22 | 2.29 | 2 | SO59780 | 2024-03-29 | 0.18 | 0.86 |
SO59785_1 | 19 | 20106 | 485 | 6 | 2024-04-03 | 0.55 | 2024-03-22 | 21.98 | 1 | SO59785 | 2024-03-29 | 1.76 | 8.22 | |
SO59785_2 | 19 | 20106 | 217 | 6 | 2024-04-03 | 0.87 | 2024-03-22 | 34.99 | 2 | SO59785 | 2024-03-29 | 2.80 | 13.09 | |
SO59785_3 | 19 | 20106 | 237 | 6 | 2024-04-03 | 1.25 | 2024-03-22 | 49.99 | 3 | SO59785 | 2024-03-29 | 4.00 | 38.49 | |
SO59808_1 | 19 | 14478 | 353 | 2 | 6 | 2024-04-03 | 58.00 | 2024-03-22 | 2319.99 | 1 | SO59808 | 2024-03-29 | 185.60 | 1265.62 |
SO59808_2 | 19 | 14478 | 485 | 6 | 2024-04-03 | 0.55 | 2024-03-22 | 21.98 | 2 | SO59808 | 2024-03-29 | 1.76 | 8.22 | |
SO59825_1 | 19 | 16219 | 606 | 2 | 6 | 2024-04-03 | 13.50 | 2024-03-22 | 539.99 | 1 | SO59825 | 2024-03-29 | 43.20 | 343.65 |
SO59825_2 | 19 | 16219 | 479 | 6 | 2024-04-03 | 0.22 | 2024-03-22 | 8.99 | 2 | SO59825 | 2024-03-29 | 0.72 | 3.36 | |
SO59825_3 | 19 | 16219 | 477 | 6 | 2024-04-03 | 0.12 | 2024-03-22 | 4.99 | 3 | SO59825 | 2024-03-29 | 0.40 | 1.87 | |
SO59826_1 | 19 | 23486 | 581 | 6 | 2024-04-03 | 42.52 | 2024-03-22 | 1700.99 | 1 | SO59826 | 2024-03-29 | 136.08 | 1082.51 | |
SO59826_2 | 19 | 23486 | 539 | 6 | 2024-04-03 | 0.62 | 2024-03-22 | 24.99 | 2 | SO59826 | 2024-03-29 | 2.00 | 9.35 | |
SO53097_3 | 19 | 15974 | 485 | 6 | 2023-12-17 | 0.55 | 2023-12-05 | 21.98 | 3 | SO53097 | 2023-12-12 | 1.76 | 8.22 | |
SO53097_4 | 19 | 15974 | 214 | 6 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 4 | SO53097 | 2023-12-12 | 2.80 | 13.09 | |
SO53098_1 | 19 | 28817 | 476 | 6 | 2023-12-17 | 1.75 | 2023-12-05 | 69.99 | 1 | SO53098 | 2023-12-12 | 5.60 | 26.18 | |
SO53099_1 | 19 | 16846 | 475 | 6 | 2023-12-17 | 1.75 | 2023-12-05 | 69.99 | 1 | SO53099 | 2023-12-12 | 5.60 | 26.18 | |
SO53099_2 | 19 | 16846 | 491 | 6 | 2023-12-17 | 1.35 | 2023-12-05 | 53.99 | 2 | SO53099 | 2023-12-12 | 4.32 | 41.57 | |
SO53101_1 | 19 | 28248 | 528 | 6 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO53101 | 2023-12-12 | 0.40 | 1.87 | |
SO53102_1 | 19 | 12077 | 477 | 6 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO53102 | 2023-12-12 | 0.40 | 1.87 | |
SO53117_1 | 19 | 15816 | 485 | 6 | 2023-12-17 | 0.55 | 2023-12-05 | 21.98 | 1 | SO53117 | 2023-12-12 | 1.76 | 8.22 | |
SO53117_2 | 19 | 15816 | 222 | 6 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 2 | SO53117 | 2023-12-12 | 2.80 | 13.09 | |
SO53117_3 | 19 | 15816 | 465 | 6 | 2023-12-17 | 0.61 | 2023-12-05 | 24.49 | 3 | SO53117 | 2023-12-12 | 1.96 | 9.16 | |
SO53118_1 | 19 | 17387 | 485 | 6 | 2023-12-17 | 0.55 | 2023-12-05 | 21.98 | 1 | SO53118 | 2023-12-12 | 1.76 | 8.22 | |
SO53118_2 | 19 | 17387 | 214 | 6 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 2 | SO53118 | 2023-12-12 | 2.80 | 13.09 | |
SO53128_1 | 19 | 24778 | 584 | 6 | 2023-12-17 | 13.50 | 2023-12-05 | 539.99 | 1 | SO53128 | 2023-12-12 | 43.20 | 343.65 | |
SO53128_2 | 19 | 24778 | 479 | 6 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 2 | SO53128 | 2023-12-12 | 0.72 | 3.36 | |
SO53128_3 | 19 | 24778 | 484 | 6 | 2023-12-17 | 0.20 | 2023-12-05 | 7.95 | 3 | SO53128 | 2023-12-12 | 0.64 | 2.97 | |
SO53128_4 | 19 | 24778 | 483 | 6 | 2023-12-17 | 3.00 | 2023-12-05 | 120.00 | 4 | SO53128 | 2023-12-12 | 9.60 | 44.88 | |
SO53129_1 | 19 | 23858 | 382 | 6 | 2023-12-17 | 28.01 | 2023-12-05 | 1120.49 | 1 | SO53129 | 2023-12-12 | 89.64 | 713.08 | |
SO53129_2 | 19 | 23858 | 479 | 6 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 2 | SO53129 | 2023-12-12 | 0.72 | 3.36 | |
SO53129_3 | 19 | 23858 | 477 | 6 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 3 | SO53129 | 2023-12-12 | 0.40 | 1.87 | |
SO53142_1 | 19 | 11505 | 491 | 6 | 2023-12-18 | 1.35 | 2023-12-06 | 53.99 | 1 | SO53142 | 2023-12-13 | 4.32 | 41.57 | |
SO53143_1 | 19 | 11520 | 529 | 6 | 2023-12-18 | 0.10 | 2023-12-06 | 3.99 | 1 | SO53143 | 2023-12-13 | 0.32 | 1.49 | |
SO53143_2 | 19 | 11520 | 234 | 6 | 2023-12-18 | 1.25 | 2023-12-06 | 49.99 | 2 | SO53143 | 2023-12-13 | 4.00 | 38.49 | |
SO53143_3 | 19 | 11520 | 482 | 6 | 2023-12-18 | 0.22 | 2023-12-06 | 8.99 | 3 | SO53143 | 2023-12-13 | 0.72 | 3.36 | |
SO53148_1 | 19 | 11631 | 528 | 6 | 2023-12-18 | 0.12 | 2023-12-06 | 4.99 | 1 | SO53148 | 2023-12-13 | 0.40 | 1.87 | |
SO53148_2 | 19 | 11631 | 536 | 6 | 2023-12-18 | 0.75 | 2023-12-06 | 29.99 | 2 | SO53148 | 2023-12-13 | 2.40 | 11.22 | |
SO53148_3 | 19 | 11631 | 485 | 6 | 2023-12-18 | 0.55 | 2023-12-06 | 21.98 | 3 | SO53148 | 2023-12-13 | 1.76 | 8.22 |
Generated 2024-11-10 23:46:54.174 UTC