[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2998 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63690_1 | 6 | 21177 | 537 | 9 | 2024-06-04 | 0.88 | 2024-05-23 | 35.00 | 1 | SO63690 | 2024-05-30 | 2.80 | 13.09 | |
SO70149_3 | 6 | 22909 | 489 | 9 | 2024-09-03 | 1.35 | 2024-08-22 | 53.99 | 3 | SO70149 | 2024-08-29 | 4.32 | 41.57 | |
SO46481_1 | 6 | 20623 | 313 | 9 | 2022-10-10 | 89.46 | 2022-09-28 | 3578.27 | 1 | SO46481 | 2022-10-05 | 286.26 | 2171.29 | |
SO56943_2 | 6 | 18768 | 214 | 9 | 2024-02-25 | 0.87 | 2024-02-13 | 34.99 | 2 | SO56943 | 2024-02-20 | 2.80 | 13.09 | |
SO63690_2 | 6 | 21177 | 528 | 9 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63690 | 2024-05-30 | 0.40 | 1.87 | |
SO70149_4 | 6 | 22909 | 225 | 9 | 2024-09-03 | 0.22 | 2024-08-22 | 8.99 | 4 | SO70149 | 2024-08-29 | 0.72 | 6.92 | |
SO46482_1 | 6 | 12245 | 346 | 9 | 2022-10-10 | 85.00 | 2022-09-28 | 3399.99 | 1 | SO46482 | 2022-10-05 | 272.00 | 1912.15 | |
SO56944_1 | 6 | 14130 | 583 | 9 | 2024-02-25 | 42.52 | 2024-02-13 | 1700.99 | 1 | SO56944 | 2024-02-20 | 136.08 | 1082.51 | |
SO63691_1 | 6 | 15241 | 478 | 9 | 2024-06-04 | 0.25 | 2024-05-23 | 9.99 | 1 | SO63691 | 2024-05-30 | 0.80 | 3.74 | |
SO70150_1 | 6 | 25918 | 605 | 9 | 2024-09-03 | 13.50 | 2024-08-22 | 539.99 | 1 | SO70150 | 2024-08-29 | 43.20 | 343.65 | |
SO46488_1 | 6 | 20628 | 312 | 9 | 2022-10-11 | 89.46 | 2022-09-29 | 3578.27 | 1 | SO46488 | 2022-10-06 | 286.26 | 2171.29 | |
SO56944_2 | 6 | 14130 | 529 | 9 | 2024-02-25 | 0.10 | 2024-02-13 | 3.99 | 2 | SO56944 | 2024-02-20 | 0.32 | 1.49 | |
SO63691_2 | 6 | 15241 | 477 | 9 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63691 | 2024-05-30 | 0.40 | 1.87 | |
SO70150_2 | 6 | 25918 | 538 | 9 | 2024-09-03 | 0.54 | 2024-08-22 | 21.49 | 2 | SO70150 | 2024-08-29 | 1.72 | 8.04 | |
SO46494_1 | 6 | 20983 | 313 | 9 | 2022-10-13 | 89.46 | 2022-10-01 | 3578.27 | 1 | SO46494 | 2022-10-08 | 286.26 | 2171.29 | |
SO56944_3 | 6 | 14130 | 539 | 9 | 2024-02-25 | 0.62 | 2024-02-13 | 24.99 | 3 | SO56944 | 2024-02-20 | 2.00 | 9.35 | |
SO63691_3 | 6 | 15241 | 484 | 9 | 2024-06-04 | 0.20 | 2024-05-23 | 7.95 | 3 | SO63691 | 2024-05-30 | 0.64 | 2.97 | |
SO70151_1 | 6 | 17294 | 589 | 9 | 2024-09-03 | 19.24 | 2024-08-22 | 769.49 | 1 | SO70151 | 2024-08-29 | 61.56 | 419.78 | |
SO46495_1 | 6 | 20989 | 311 | 9 | 2022-10-13 | 89.46 | 2022-10-01 | 3578.27 | 1 | SO46495 | 2022-10-08 | 286.26 | 2171.29 | |
SO56944_4 | 6 | 14130 | 214 | 9 | 2024-02-25 | 0.87 | 2024-02-13 | 34.99 | 4 | SO56944 | 2024-02-20 | 2.80 | 13.09 | |
SO63692_1 | 6 | 15147 | 217 | 9 | 2024-06-04 | 0.87 | 2024-05-23 | 34.99 | 1 | SO63692 | 2024-05-30 | 2.80 | 13.09 | |
SO70151_2 | 6 | 17294 | 484 | 9 | 2024-09-03 | 0.20 | 2024-08-22 | 7.95 | 2 | SO70151 | 2024-08-29 | 0.64 | 2.97 | |
SO46496_1 | 6 | 20627 | 312 | 9 | 2022-10-13 | 89.46 | 2022-10-01 | 3578.27 | 1 | SO46496 | 2022-10-08 | 286.26 | 2171.29 | |
SO56945_1 | 6 | 29180 | 562 | 9 | 2024-02-25 | 59.60 | 2024-02-13 | 2384.07 | 1 | SO56945 | 2024-02-20 | 190.73 | 1481.94 | |
SO63692_2 | 6 | 15147 | 467 | 9 | 2024-06-04 | 0.61 | 2024-05-23 | 24.49 | 2 | SO63692 | 2024-05-30 | 1.96 | 9.16 | |
SO70152_1 | 6 | 16158 | 353 | 2 | 9 | 2024-09-03 | 58.00 | 2024-08-22 | 2319.99 | 1 | SO70152 | 2024-08-29 | 185.60 | 1265.62 |
SO46505_1 | 6 | 12241 | 347 | 9 | 2022-10-14 | 85.00 | 2022-10-02 | 3399.99 | 1 | SO46505 | 2022-10-09 | 272.00 | 1912.15 | |
SO56945_2 | 6 | 29180 | 479 | 9 | 2024-02-25 | 0.22 | 2024-02-13 | 8.99 | 2 | SO56945 | 2024-02-20 | 0.72 | 3.36 | |
SO63693_1 | 6 | 16733 | 529 | 9 | 2024-06-04 | 0.10 | 2024-05-23 | 3.99 | 1 | SO63693 | 2024-05-30 | 0.32 | 1.49 | |
SO70153_1 | 6 | 15722 | 357 | 9 | 2024-09-03 | 58.00 | 2024-08-22 | 2319.99 | 1 | SO70153 | 2024-08-29 | 185.60 | 1265.62 | |
SO46506_1 | 6 | 12242 | 349 | 9 | 2022-10-14 | 84.37 | 2022-10-02 | 3374.99 | 1 | SO46506 | 2022-10-09 | 270.00 | 1898.09 | |
SO56945_3 | 6 | 29180 | 477 | 9 | 2024-02-25 | 0.12 | 2024-02-13 | 4.99 | 3 | SO56945 | 2024-02-20 | 0.40 | 1.87 | |
SO63694_1 | 6 | 13004 | 486 | 9 | 2024-06-04 | 3.98 | 2024-05-23 | 159.00 | 1 | SO63694 | 2024-05-30 | 12.72 | 59.47 | |
SO70153_2 | 6 | 15722 | 465 | 9 | 2024-09-03 | 0.61 | 2024-08-22 | 24.49 | 2 | SO70153 | 2024-08-29 | 1.96 | 9.16 | |
SO46507_1 | 6 | 25941 | 320 | 9 | 2022-10-14 | 17.48 | 2022-10-02 | 699.10 | 1 | SO46507 | 2022-10-09 | 55.93 | 413.15 | |
SO56945_4 | 6 | 29180 | 490 | 9 | 2024-02-25 | 1.35 | 2024-02-13 | 53.99 | 4 | SO56945 | 2024-02-20 | 4.32 | 41.57 | |
SO63732_1 | 6 | 15041 | 583 | 9 | 2024-06-04 | 42.52 | 2024-05-23 | 1700.99 | 1 | SO63732 | 2024-05-30 | 136.08 | 1082.51 | |
SO70153_3 | 6 | 15722 | 487 | 9 | 2024-09-03 | 1.37 | 2024-08-22 | 54.99 | 3 | SO70153 | 2024-08-29 | 4.40 | 20.57 | |
SO46517_1 | 6 | 20624 | 313 | 9 | 2022-10-15 | 89.46 | 2022-10-03 | 3578.27 | 1 | SO46517 | 2022-10-10 | 286.26 | 2171.29 | |
SO56946_1 | 6 | 19102 | 380 | 9 | 2024-02-25 | 61.08 | 2024-02-13 | 2443.35 | 1 | SO56946 | 2024-02-20 | 195.47 | 1554.95 | |
SO63732_2 | 6 | 15041 | 491 | 9 | 2024-06-04 | 1.35 | 2024-05-23 | 53.99 | 2 | SO63732 | 2024-05-30 | 4.32 | 41.57 | |
SO70163_1 | 6 | 11033 | 585 | 9 | 2024-09-03 | 18.56 | 2024-08-22 | 742.35 | 1 | SO70163 | 2024-08-29 | 59.39 | 461.44 | |
SO46518_1 | 6 | 20814 | 314 | 9 | 2022-10-15 | 89.46 | 2022-10-03 | 3578.27 | 1 | SO46518 | 2022-10-10 | 286.26 | 2171.29 | |
SO56946_2 | 6 | 19102 | 484 | 9 | 2024-02-25 | 0.20 | 2024-02-13 | 7.95 | 2 | SO56946 | 2024-02-20 | 0.64 | 2.97 | |
SO63733_1 | 6 | 17909 | 384 | 2 | 9 | 2024-06-04 | 28.01 | 2024-05-23 | 1120.49 | 1 | SO63733 | 2024-05-30 | 89.64 | 713.08 |
SO70163_2 | 6 | 11033 | 479 | 9 | 2024-09-03 | 0.22 | 2024-08-22 | 8.99 | 2 | SO70163 | 2024-08-29 | 0.72 | 3.36 | |
SO46525_1 | 6 | 20816 | 314 | 9 | 2022-10-16 | 89.46 | 2022-10-04 | 3578.27 | 1 | SO46525 | 2022-10-11 | 286.26 | 2171.29 | |
SO56947_1 | 6 | 17515 | 595 | 9 | 2024-02-25 | 14.12 | 2024-02-13 | 564.99 | 1 | SO56947 | 2024-02-20 | 45.20 | 308.22 | |
SO63733_2 | 6 | 17909 | 489 | 9 | 2024-06-04 | 1.35 | 2024-05-23 | 53.99 | 2 | SO63733 | 2024-05-30 | 4.32 | 41.57 | |
SO70163_3 | 6 | 11033 | 225 | 9 | 2024-09-03 | 0.22 | 2024-08-22 | 8.99 | 3 | SO70163 | 2024-08-29 | 0.72 | 6.92 | |
SO46526_1 | 6 | 12253 | 347 | 9 | 2022-10-16 | 85.00 | 2022-10-04 | 3399.99 | 1 | SO46526 | 2022-10-11 | 272.00 | 1912.15 | |
SO56948_1 | 6 | 12354 | 363 | 9 | 2024-02-25 | 57.37 | 2024-02-13 | 2294.99 | 1 | SO56948 | 2024-02-20 | 183.60 | 1251.98 | |
SO63733_3 | 6 | 17909 | 225 | 9 | 2024-06-04 | 0.22 | 2024-05-23 | 8.99 | 3 | SO63733 | 2024-05-30 | 0.72 | 6.92 | |
SO70163_4 | 6 | 11033 | 477 | 9 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 4 | SO70163 | 2024-08-29 | 0.40 | 1.87 | |
SO46527_1 | 6 | 25940 | 334 | 9 | 2022-10-16 | 17.48 | 2022-10-04 | 699.10 | 1 | SO46527 | 2022-10-11 | 55.93 | 413.15 | |
SO56948_2 | 6 | 12354 | 477 | 9 | 2024-02-25 | 0.12 | 2024-02-13 | 4.99 | 2 | SO56948 | 2024-02-20 | 0.40 | 1.87 | |
SO63734_1 | 6 | 24162 | 605 | 9 | 2024-06-04 | 13.50 | 2024-05-23 | 539.99 | 1 | SO63734 | 2024-05-30 | 43.20 | 343.65 | |
SO70164_1 | 6 | 14681 | 586 | 9 | 2024-09-03 | 18.56 | 2024-08-22 | 742.35 | 1 | SO70164 | 2024-08-29 | 59.39 | 461.44 | |
SO46534_1 | 6 | 20620 | 312 | 9 | 2022-10-17 | 89.46 | 2022-10-05 | 3578.27 | 1 | SO46534 | 2022-10-12 | 286.26 | 2171.29 | |
SO56948_3 | 6 | 12354 | 478 | 9 | 2024-02-25 | 0.25 | 2024-02-13 | 9.99 | 3 | SO56948 | 2024-02-20 | 0.80 | 3.74 | |
SO63734_2 | 6 | 24162 | 538 | 9 | 2024-06-04 | 0.54 | 2024-05-23 | 21.49 | 2 | SO63734 | 2024-05-30 | 1.72 | 8.04 | |
SO70164_2 | 6 | 14681 | 214 | 9 | 2024-09-03 | 0.87 | 2024-08-22 | 34.99 | 2 | SO70164 | 2024-08-29 | 2.80 | 13.09 |
Generated 2024-11-14 07:42:03.124 UTC