[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 1604 > < TAKE 48 >
48 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63714_2 | 19 | 19541 | 222 | 6 | 2024-06-04 | 0.87 | 2024-05-23 | 34.99 | 2 | SO63714 | 2024-05-30 | 2.80 | 13.09 | |
SO70219_2 | 19 | 18950 | 485 | 6 | 2024-09-04 | 0.55 | 2024-08-23 | 21.98 | 2 | SO70219 | 2024-08-30 | 1.76 | 8.22 | |
SO47892_1 | 19 | 26373 | 389 | 6 | 2023-02-17 | 25.01 | 2023-02-05 | 1000.44 | 1 | SO47892 | 2023-02-12 | 80.04 | 605.65 | |
SO57206_1 | 19 | 12970 | 528 | 6 | 2024-02-27 | 0.12 | 2024-02-15 | 4.99 | 1 | SO57206 | 2024-02-22 | 0.40 | 1.87 | |
SO63714_3 | 19 | 19541 | 231 | 6 | 2024-06-04 | 1.25 | 2024-05-23 | 49.99 | 3 | SO63714 | 2024-05-30 | 4.00 | 38.49 | |
SO70219_3 | 19 | 18950 | 222 | 6 | 2024-09-04 | 0.87 | 2024-08-23 | 34.99 | 3 | SO70219 | 2024-08-30 | 2.80 | 13.09 | |
SO47893_1 | 19 | 25989 | 371 | 6 | 2023-02-17 | 54.54 | 2023-02-05 | 2181.56 | 1 | SO47893 | 2023-02-12 | 174.53 | 1320.68 | |
SO57206_2 | 19 | 12970 | 536 | 6 | 2024-02-27 | 0.75 | 2024-02-15 | 29.99 | 2 | SO57206 | 2024-02-22 | 2.40 | 11.22 | |
SO63714_4 | 19 | 19541 | 225 | 6 | 2024-06-04 | 0.22 | 2024-05-23 | 8.99 | 4 | SO63714 | 2024-05-30 | 0.72 | 6.92 | |
SO70236_1 | 19 | 22901 | 562 | 6 | 2024-09-04 | 59.60 | 2024-08-23 | 2384.07 | 1 | SO70236 | 2024-08-30 | 190.73 | 1481.94 | |
SO47905_1 | 100 | 29336 | 373 | 6 | 2023-02-19 | 54.54 | 2023-02-07 | 2181.56 | 1 | SO47905 | 2023-02-14 | 174.53 | 1320.68 | |
SO57206_3 | 19 | 12970 | 485 | 6 | 2024-02-27 | 0.55 | 2024-02-15 | 21.98 | 3 | SO57206 | 2024-02-22 | 1.76 | 8.22 | |
SO63715_1 | 19 | 22366 | 485 | 6 | 2024-06-04 | 0.55 | 2024-05-23 | 21.98 | 1 | SO63715 | 2024-05-30 | 1.76 | 8.22 | |
SO70236_2 | 19 | 22901 | 225 | 6 | 2024-09-04 | 0.22 | 2024-08-23 | 8.99 | 2 | SO70236 | 2024-08-30 | 0.72 | 6.92 | |
SO47906_1 | 19 | 27082 | 339 | 6 | 2023-02-19 | 19.57 | 2023-02-07 | 782.99 | 1 | SO47906 | 2023-02-14 | 62.64 | 486.71 | |
SO57207_1 | 19 | 15376 | 478 | 6 | 2024-02-27 | 0.25 | 2024-02-15 | 9.99 | 1 | SO57207 | 2024-02-22 | 0.80 | 3.74 | |
SO63715_2 | 19 | 22366 | 217 | 6 | 2024-06-04 | 0.87 | 2024-05-23 | 34.99 | 2 | SO63715 | 2024-05-30 | 2.80 | 13.09 | |
SO70239_1 | 19 | 20651 | 386 | 6 | 2024-09-04 | 28.01 | 2024-08-23 | 1120.49 | 1 | SO70239 | 2024-08-30 | 89.64 | 713.08 | |
SO47908_1 | 19 | 20468 | 362 | 2 | 6 | 2023-02-19 | 51.23 | 2023-02-07 | 2049.10 | 1 | SO47908 | 2023-02-14 | 163.93 | 1105.81 |
SO57207_2 | 19 | 15376 | 477 | 6 | 2024-02-27 | 0.12 | 2024-02-15 | 4.99 | 2 | SO57207 | 2024-02-22 | 0.40 | 1.87 | |
SO63726_1 | 19 | 15847 | 485 | 6 | 2024-06-04 | 0.55 | 2024-05-23 | 21.98 | 1 | SO63726 | 2024-05-30 | 1.76 | 8.22 | |
SO70239_2 | 19 | 20651 | 529 | 6 | 2024-09-04 | 0.10 | 2024-08-23 | 3.99 | 2 | SO70239 | 2024-08-30 | 0.32 | 1.49 | |
SO47913_1 | 100 | 29159 | 368 | 6 | 2023-02-20 | 61.08 | 2023-02-08 | 2443.35 | 1 | SO47913 | 2023-02-15 | 195.47 | 1518.79 | |
SO57209_1 | 19 | 16950 | 478 | 6 | 2024-02-27 | 0.25 | 2024-02-15 | 9.99 | 1 | SO57209 | 2024-02-22 | 0.80 | 3.74 | |
SO63726_2 | 19 | 15847 | 471 | 6 | 2024-06-04 | 1.59 | 2024-05-23 | 63.50 | 2 | SO63726 | 2024-05-30 | 5.08 | 23.75 | |
SO70239_3 | 19 | 20651 | 539 | 6 | 2024-09-04 | 0.62 | 2024-08-23 | 24.99 | 3 | SO70239 | 2024-08-30 | 2.00 | 9.35 | |
SO47928_1 | 100 | 29154 | 377 | 6 | 2023-02-22 | 54.54 | 2023-02-10 | 2181.56 | 1 | SO47928 | 2023-02-17 | 174.53 | 1320.68 | |
SO57209_2 | 19 | 16950 | 477 | 6 | 2024-02-27 | 0.12 | 2024-02-15 | 4.99 | 2 | SO57209 | 2024-02-22 | 0.40 | 1.87 | |
SO63740_1 | 19 | 13440 | 562 | 6 | 2024-06-04 | 59.60 | 2024-05-23 | 2384.07 | 1 | SO63740 | 2024-05-30 | 190.73 | 1481.94 | |
SO70264_1 | 19 | 11091 | 540 | 6 | 2024-09-05 | 0.82 | 2024-08-24 | 32.60 | 1 | SO70264 | 2024-08-31 | 2.61 | 12.19 | |
SO47929_1 | 100 | 29281 | 368 | 6 | 2023-02-22 | 61.08 | 2023-02-10 | 2443.35 | 1 | SO47929 | 2023-02-17 | 195.47 | 1518.79 | |
SO57209_3 | 19 | 16950 | 225 | 6 | 2024-02-27 | 0.22 | 2024-02-15 | 8.99 | 3 | SO57209 | 2024-02-22 | 0.72 | 6.92 | |
SO63740_2 | 19 | 13440 | 490 | 6 | 2024-06-04 | 1.35 | 2024-05-23 | 53.99 | 2 | SO63740 | 2024-05-30 | 4.32 | 41.57 | |
SO70264_2 | 19 | 11091 | 480 | 6 | 2024-09-05 | 0.06 | 2024-08-24 | 2.29 | 2 | SO70264 | 2024-08-31 | 0.18 | 0.86 | |
SO48106_1 | 19 | 20546 | 360 | 6 | 2023-03-01 | 51.23 | 2023-02-17 | 2049.10 | 1 | SO48106 | 2023-02-24 | 163.93 | 1105.81 | |
SO57211_1 | 19 | 27401 | 475 | 6 | 2024-02-27 | 1.75 | 2024-02-15 | 69.99 | 1 | SO57211 | 2024-02-22 | 5.60 | 26.18 | |
SO63770_1 | 19 | 11300 | 480 | 6 | 2024-06-05 | 0.06 | 2024-05-24 | 2.29 | 1 | SO63770 | 2024-05-31 | 0.18 | 0.86 | |
SO70266_1 | 19 | 12431 | 536 | 6 | 2024-09-05 | 0.75 | 2024-08-24 | 29.99 | 1 | SO70266 | 2024-08-31 | 2.40 | 11.22 | |
SO48131_1 | 19 | 20483 | 360 | 6 | 2023-03-06 | 51.23 | 2023-02-22 | 2049.10 | 1 | SO48131 | 2023-03-01 | 163.93 | 1105.81 | |
SO57212_1 | 19 | 27022 | 477 | 6 | 2024-02-27 | 0.12 | 2024-02-15 | 4.99 | 1 | SO57212 | 2024-02-22 | 0.40 | 1.87 | |
SO63771_1 | 19 | 11300 | 529 | 6 | 2024-06-05 | 0.10 | 2024-05-24 | 3.99 | 1 | SO63771 | 2024-05-31 | 0.32 | 1.49 | |
SO70266_2 | 19 | 12431 | 480 | 2 | 6 | 2024-09-05 | 0.06 | 2024-08-24 | 2.29 | 2 | SO70266 | 2024-08-31 | 0.18 | 0.86 |
SO48215_1 | 19 | 26482 | 387 | 6 | 2023-03-19 | 25.01 | 2023-03-07 | 1000.44 | 1 | SO48215 | 2023-03-14 | 80.04 | 605.65 | |
SO57213_1 | 19 | 26173 | 477 | 6 | 2024-02-27 | 0.12 | 2024-02-15 | 4.99 | 1 | SO57213 | 2024-02-22 | 0.40 | 1.87 | |
SO63771_2 | 19 | 11300 | 463 | 6 | 2024-06-05 | 0.61 | 2024-05-24 | 24.49 | 2 | SO63771 | 2024-05-31 | 1.96 | 9.16 | |
SO70269_1 | 19 | 12919 | 478 | 6 | 2024-09-05 | 0.25 | 2024-08-24 | 9.99 | 1 | SO70269 | 2024-08-31 | 0.80 | 3.74 | |
SO48255_1 | 19 | 26496 | 385 | 6 | 2023-03-25 | 25.01 | 2023-03-13 | 1000.44 | 1 | SO48255 | 2023-03-20 | 80.04 | 605.65 | |
SO57214_1 | 19 | 21691 | 528 | 6 | 2024-02-27 | 0.12 | 2024-02-15 | 4.99 | 1 | SO57214 | 2024-02-22 | 0.40 | 1.87 |
Generated 2024-11-14 17:50:30.296 UTC