[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 187 < SKIP 1114 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69888_3 | 100 | 22021 | 225 | 1 | 2024-08-27 | 0.22 | 2024-08-15 | 8.99 | 3 | SO69888 | 2024-08-22 | 0.72 | 6.92 | |
SO46922_1 | 100 | 13088 | 368 | 1 | 2022-11-22 | 61.08 | 2022-11-10 | 2443.35 | 1 | SO46922 | 2022-11-17 | 195.47 | 1518.79 | |
SO63042_2 | 100 | 12120 | 537 | 1 | 2024-05-23 | 0.88 | 2024-05-11 | 35.00 | 2 | SO63042 | 2024-05-18 | 2.80 | 13.09 | |
SO69891_1 | 100 | 16376 | 528 | 1 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69891 | 2024-08-22 | 0.40 | 1.87 | |
SO46924_1 | 100 | 13203 | 375 | 1 | 2022-11-22 | 54.54 | 2022-11-10 | 2181.56 | 1 | SO46924 | 2022-11-17 | 174.53 | 1320.68 | |
SO63043_1 | 100 | 12121 | 355 | 1 | 2024-05-23 | 58.00 | 2024-05-11 | 2319.99 | 1 | SO63043 | 2024-05-18 | 185.60 | 1265.62 | |
SO69891_2 | 100 | 16376 | 480 | 2 | 1 | 2024-08-27 | 0.06 | 2024-08-15 | 2.29 | 2 | SO69891 | 2024-08-22 | 0.18 | 0.86 |
SO47070_1 | 100 | 14025 | 387 | 1 | 2022-11-23 | 25.01 | 2022-11-11 | 1000.44 | 1 | SO47070 | 2022-11-18 | 80.04 | 605.65 | |
SO63043_2 | 100 | 12121 | 528 | 1 | 2024-05-23 | 0.12 | 2024-05-11 | 4.99 | 2 | SO63043 | 2024-05-18 | 0.40 | 1.87 | |
SO69892_1 | 100 | 16669 | 477 | 1 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69892 | 2024-08-22 | 0.40 | 1.87 | |
SO47074_1 | 100 | 26293 | 362 | 2 | 1 | 2022-11-23 | 51.23 | 2022-11-11 | 2049.10 | 1 | SO47074 | 2022-11-18 | 163.93 | 1105.81 |
SO63043_3 | 100 | 12121 | 537 | 1 | 2024-05-23 | 0.88 | 2024-05-11 | 35.00 | 3 | SO63043 | 2024-05-18 | 2.80 | 13.09 | |
SO69894_1 | 100 | 13991 | 485 | 1 | 2024-08-27 | 0.55 | 2024-08-15 | 21.98 | 1 | SO69894 | 2024-08-22 | 1.76 | 8.22 | |
SO47078_1 | 100 | 13248 | 375 | 1 | 2022-11-24 | 54.54 | 2022-11-12 | 2181.56 | 1 | SO47078 | 2022-11-19 | 174.53 | 1320.68 | |
SO63043_4 | 100 | 12121 | 484 | 1 | 2024-05-23 | 0.20 | 2024-05-11 | 7.95 | 4 | SO63043 | 2024-05-18 | 0.64 | 2.97 | |
SO69894_2 | 100 | 13991 | 471 | 1 | 2024-08-27 | 1.59 | 2024-08-15 | 63.50 | 2 | SO69894 | 2024-08-22 | 5.08 | 23.75 | |
SO47087_1 | 100 | 13383 | 377 | 1 | 2022-11-25 | 54.54 | 2022-11-13 | 2181.56 | 1 | SO47087 | 2022-11-20 | 174.53 | 1320.68 | |
SO63046_1 | 100 | 14392 | 359 | 1 | 2024-05-23 | 57.37 | 2024-05-11 | 2294.99 | 1 | SO63046 | 2024-05-18 | 183.60 | 1251.98 | |
SO69907_1 | 100 | 11879 | 537 | 1 | 2024-08-27 | 0.88 | 2024-08-15 | 35.00 | 1 | SO69907 | 2024-08-22 | 2.80 | 13.09 | |
SO47088_1 | 100 | 13274 | 369 | 2 | 1 | 2022-11-25 | 61.08 | 2022-11-13 | 2443.35 | 1 | SO47088 | 2022-11-20 | 195.47 | 1518.79 |
SO63049_1 | 100 | 29167 | 565 | 1 | 2024-05-23 | 18.56 | 2024-05-11 | 742.35 | 1 | SO63049 | 2024-05-18 | 59.39 | 461.44 | |
SO69907_2 | 100 | 11879 | 528 | 1 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69907 | 2024-08-22 | 0.40 | 1.87 | |
SO47102_1 | 100 | 13424 | 370 | 1 | 2022-11-27 | 61.08 | 2022-11-15 | 2443.35 | 1 | SO47102 | 2022-11-22 | 195.47 | 1518.79 | |
SO63049_2 | 100 | 29167 | 541 | 1 | 2024-05-23 | 0.72 | 2024-05-11 | 28.99 | 2 | SO63049 | 2024-05-18 | 2.32 | 10.84 | |
SO69907_3 | 100 | 11879 | 222 | 1 | 2024-08-27 | 0.87 | 2024-08-15 | 34.99 | 3 | SO69907 | 2024-08-22 | 2.80 | 13.09 | |
SO47103_1 | 100 | 13369 | 368 | 1 | 2022-11-27 | 61.08 | 2022-11-15 | 2443.35 | 1 | SO47103 | 2022-11-22 | 195.47 | 1518.79 | |
SO63049_3 | 100 | 29167 | 530 | 1 | 2024-05-23 | 0.12 | 2024-05-11 | 4.99 | 3 | SO63049 | 2024-05-18 | 0.40 | 1.87 | |
SO69907_4 | 100 | 11879 | 463 | 1 | 2024-08-27 | 0.61 | 2024-08-15 | 24.49 | 4 | SO69907 | 2024-08-22 | 1.96 | 9.16 | |
SO47105_1 | 100 | 13319 | 371 | 1 | 2022-11-27 | 54.54 | 2022-11-15 | 2181.56 | 1 | SO47105 | 2022-11-22 | 174.53 | 1320.68 | |
SO63049_4 | 100 | 29167 | 480 | 1 | 2024-05-23 | 0.06 | 2024-05-11 | 2.29 | 4 | SO63049 | 2024-05-18 | 0.18 | 0.86 | |
SO69914_1 | 100 | 17133 | 353 | 1 | 2024-08-27 | 58.00 | 2024-08-15 | 2319.99 | 1 | SO69914 | 2024-08-22 | 185.60 | 1265.62 | |
SO47124_1 | 100 | 13384 | 371 | 1 | 2022-11-29 | 54.54 | 2022-11-17 | 2181.56 | 1 | SO47124 | 2022-11-24 | 174.53 | 1320.68 | |
SO63049_5 | 100 | 29167 | 484 | 1 | 2024-05-23 | 0.20 | 2024-05-11 | 7.95 | 5 | SO63049 | 2024-05-18 | 0.64 | 2.97 | |
SO69914_2 | 100 | 17133 | 537 | 1 | 2024-08-27 | 0.88 | 2024-08-15 | 35.00 | 2 | SO69914 | 2024-08-22 | 2.80 | 13.09 | |
SO47131_1 | 100 | 13243 | 371 | 1 | 2022-11-30 | 54.54 | 2022-11-18 | 2181.56 | 1 | SO47131 | 2022-11-25 | 174.53 | 1320.68 | |
SO63053_1 | 100 | 24653 | 563 | 1 | 2024-05-23 | 59.60 | 2024-05-11 | 2384.07 | 1 | SO63053 | 2024-05-18 | 190.73 | 1481.94 | |
SO69914_3 | 100 | 17133 | 480 | 1 | 2024-08-27 | 0.06 | 2024-08-15 | 2.29 | 3 | SO69914 | 2024-08-22 | 0.18 | 0.86 | |
SO47132_1 | 100 | 13283 | 375 | 1 | 2022-11-30 | 54.54 | 2022-11-18 | 2181.56 | 1 | SO47132 | 2022-11-25 | 174.53 | 1320.68 | |
SO63053_2 | 100 | 24653 | 479 | 1 | 2024-05-23 | 0.22 | 2024-05-11 | 8.99 | 2 | SO63053 | 2024-05-18 | 0.72 | 3.36 | |
SO69931_1 | 100 | 25998 | 578 | 1 | 2024-08-27 | 30.37 | 2024-08-15 | 1214.85 | 1 | SO69931 | 2024-08-22 | 97.19 | 755.15 | |
SO47134_1 | 100 | 26296 | 354 | 1 | 2022-11-30 | 51.79 | 2022-11-18 | 2071.42 | 1 | SO47134 | 2022-11-25 | 165.71 | 1117.86 | |
SO63054_1 | 100 | 22753 | 606 | 1 | 2024-05-23 | 13.50 | 2024-05-11 | 539.99 | 1 | SO63054 | 2024-05-18 | 43.20 | 343.65 | |
SO69931_2 | 100 | 25998 | 222 | 1 | 2024-08-27 | 0.87 | 2024-08-15 | 34.99 | 2 | SO69931 | 2024-08-22 | 2.80 | 13.09 | |
SO47167_1 | 100 | 13419 | 375 | 1 | 2022-12-05 | 54.54 | 2022-11-23 | 2181.56 | 1 | SO47167 | 2022-11-30 | 174.53 | 1320.68 | |
SO63054_2 | 100 | 22753 | 529 | 1 | 2024-05-23 | 0.10 | 2024-05-11 | 3.99 | 2 | SO63054 | 2024-05-18 | 0.32 | 1.49 | |
SO69933_1 | 100 | 23847 | 606 | 1 | 2024-08-27 | 13.50 | 2024-08-15 | 539.99 | 1 | SO69933 | 2024-08-22 | 43.20 | 343.65 | |
SO47168_1 | 100 | 13286 | 377 | 1 | 2022-12-05 | 54.54 | 2022-11-23 | 2181.56 | 1 | SO47168 | 2022-11-30 | 174.53 | 1320.68 | |
SO63054_3 | 100 | 22753 | 538 | 1 | 2024-05-23 | 0.54 | 2024-05-11 | 21.49 | 3 | SO63054 | 2024-05-18 | 1.72 | 8.04 | |
SO69933_2 | 100 | 23847 | 538 | 1 | 2024-08-27 | 0.54 | 2024-08-15 | 21.49 | 2 | SO69933 | 2024-08-22 | 1.72 | 8.04 | |
SO47177_1 | 100 | 14022 | 381 | 1 | 2022-12-06 | 25.01 | 2022-11-24 | 1000.44 | 1 | SO47177 | 2022-12-01 | 80.04 | 605.65 | |
SO63054_4 | 100 | 22753 | 486 | 1 | 2024-05-23 | 3.98 | 2024-05-11 | 159.00 | 4 | SO63054 | 2024-05-18 | 12.72 | 59.47 | |
SO69933_3 | 100 | 23847 | 480 | 1 | 2024-08-27 | 0.06 | 2024-08-15 | 2.29 | 3 | SO69933 | 2024-08-22 | 0.18 | 0.86 | |
SO47178_1 | 100 | 14026 | 383 | 1 | 2022-12-06 | 25.01 | 2022-11-24 | 1000.44 | 1 | SO47178 | 2022-12-01 | 80.04 | 605.65 | |
SO63056_1 | 100 | 17565 | 581 | 1 | 2024-05-23 | 42.52 | 2024-05-11 | 1700.99 | 1 | SO63056 | 2024-05-18 | 136.08 | 1082.51 | |
SO69933_4 | 100 | 23847 | 486 | 1 | 2024-08-27 | 3.98 | 2024-08-15 | 159.00 | 4 | SO69933 | 2024-08-22 | 12.72 | 59.47 | |
SO47182_1 | 100 | 26298 | 354 | 1 | 2022-12-06 | 51.79 | 2022-11-24 | 2071.42 | 1 | SO47182 | 2022-12-01 | 165.71 | 1117.86 | |
SO63056_2 | 100 | 17565 | 231 | 1 | 2024-05-23 | 1.25 | 2024-05-11 | 49.99 | 2 | SO63056 | 2024-05-18 | 4.00 | 38.49 | |
SO69934_1 | 100 | 23832 | 604 | 1 | 2024-08-27 | 13.50 | 2024-08-15 | 539.99 | 1 | SO69934 | 2024-08-22 | 43.20 | 343.65 | |
SO47194_1 | 100 | 13269 | 377 | 1 | 2022-12-07 | 54.54 | 2022-11-25 | 2181.56 | 1 | SO47194 | 2022-12-02 | 174.53 | 1320.68 | |
SO63071_1 | 100 | 11722 | 489 | 1 | 2024-05-24 | 1.35 | 2024-05-12 | 53.99 | 1 | SO63071 | 2024-05-19 | 4.32 | 41.57 |
Generated 2024-11-10 16:42:00.045 UTC