[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 1488 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63910_1 | 100 | 21550 | 477 | 8 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 1 | SO63910 | 2024-05-29 | 0.40 | 1.87 | |
SO69974_1 | 100 | 25794 | 538 | 8 | 2024-08-28 | 0.54 | 2024-08-16 | 21.49 | 1 | SO69974 | 2024-08-23 | 1.72 | 8.04 | |
SO50005_1 | 100 | 17848 | 371 | 8 | 2023-08-04 | 54.54 | 2023-07-23 | 2181.56 | 1 | SO50005 | 2023-07-30 | 174.53 | 1320.68 | |
SO57720_1 | 100 | 14180 | 540 | 8 | 2024-03-03 | 0.82 | 2024-02-20 | 32.60 | 1 | SO57720 | 2024-02-27 | 2.61 | 12.19 | |
SO63910_2 | 100 | 21550 | 490 | 8 | 2024-06-03 | 1.35 | 2024-05-22 | 53.99 | 2 | SO63910 | 2024-05-29 | 4.32 | 41.57 | |
SO69974_2 | 100 | 25794 | 480 | 8 | 2024-08-28 | 0.06 | 2024-08-16 | 2.29 | 2 | SO69974 | 2024-08-23 | 0.18 | 0.86 | |
SO50006_1 | 100 | 20896 | 333 | 8 | 2023-08-04 | 19.57 | 2023-07-23 | 782.99 | 1 | SO50006 | 2023-07-30 | 62.64 | 486.71 | |
SO57721_1 | 100 | 26878 | 538 | 8 | 2024-03-03 | 0.54 | 2024-02-20 | 21.49 | 1 | SO57721 | 2024-02-27 | 1.72 | 8.04 | |
SO63916_1 | 100 | 27932 | 530 | 8 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 1 | SO63916 | 2024-05-29 | 0.40 | 1.87 | |
SO70007_1 | 100 | 21047 | 386 | 8 | 2024-08-28 | 28.01 | 2024-08-16 | 1120.49 | 1 | SO70007 | 2024-08-23 | 89.64 | 713.08 | |
SO50014_1 | 100 | 17833 | 369 | 2 | 8 | 2023-08-05 | 61.08 | 2023-07-24 | 2443.35 | 1 | SO50014 | 2023-07-31 | 195.47 | 1518.79 |
SO57744_1 | 100 | 12462 | 606 | 8 | 2024-03-03 | 13.50 | 2024-02-20 | 539.99 | 1 | SO57744 | 2024-02-27 | 43.20 | 343.65 | |
SO63916_2 | 100 | 27932 | 487 | 8 | 2024-06-03 | 1.37 | 2024-05-22 | 54.99 | 2 | SO63916 | 2024-05-29 | 4.40 | 20.57 | |
SO70007_2 | 100 | 21047 | 222 | 8 | 2024-08-28 | 0.87 | 2024-08-16 | 34.99 | 2 | SO70007 | 2024-08-23 | 2.80 | 13.09 | |
SO50015_1 | 100 | 19254 | 381 | 8 | 2023-08-05 | 25.01 | 2023-07-24 | 1000.44 | 1 | SO50015 | 2023-07-31 | 80.04 | 605.65 | |
SO57744_2 | 100 | 12462 | 214 | 8 | 2024-03-03 | 0.87 | 2024-02-20 | 34.99 | 2 | SO57744 | 2024-02-27 | 2.80 | 13.09 | |
SO63916_3 | 100 | 27932 | 473 | 8 | 2024-06-03 | 1.59 | 2024-05-22 | 63.50 | 3 | SO63916 | 2024-05-29 | 5.08 | 23.75 | |
SO70008_1 | 100 | 21008 | 390 | 8 | 2024-08-28 | 28.01 | 2024-08-16 | 1120.49 | 1 | SO70008 | 2024-08-23 | 89.64 | 713.08 | |
SO50016_1 | 100 | 20870 | 333 | 8 | 2023-08-05 | 19.57 | 2023-07-24 | 782.99 | 1 | SO50016 | 2023-07-31 | 62.64 | 486.71 | |
SO57744_3 | 100 | 12462 | 231 | 8 | 2024-03-03 | 1.25 | 2024-02-20 | 49.99 | 3 | SO57744 | 2024-02-27 | 4.00 | 38.49 | |
SO63920_1 | 100 | 12400 | 478 | 8 | 2024-06-03 | 0.25 | 2024-05-22 | 9.99 | 1 | SO63920 | 2024-05-29 | 0.80 | 3.74 | |
SO70008_2 | 100 | 21008 | 491 | 8 | 2024-08-28 | 1.35 | 2024-08-16 | 53.99 | 2 | SO70008 | 2024-08-23 | 4.32 | 41.57 | |
SO50018_1 | 100 | 20876 | 321 | 8 | 2023-08-05 | 19.57 | 2023-07-24 | 782.99 | 1 | SO50018 | 2023-07-31 | 62.64 | 486.71 | |
SO57745_1 | 100 | 16587 | 576 | 8 | 2024-03-03 | 59.60 | 2024-02-20 | 2384.07 | 1 | SO57745 | 2024-02-27 | 190.73 | 1481.94 | |
SO63920_2 | 100 | 12400 | 477 | 8 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 2 | SO63920 | 2024-05-29 | 0.40 | 1.87 | |
SO70009_1 | 100 | 14161 | 606 | 8 | 2024-08-28 | 13.50 | 2024-08-16 | 539.99 | 1 | SO70009 | 2024-08-23 | 43.20 | 343.65 | |
SO50020_1 | 100 | 12738 | 362 | 2 | 8 | 2023-08-05 | 51.23 | 2023-07-24 | 2049.10 | 1 | SO50020 | 2023-07-31 | 163.93 | 1105.81 |
SO57745_2 | 100 | 16587 | 477 | 8 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 2 | SO57745 | 2024-02-27 | 0.40 | 1.87 | |
SO63920_3 | 100 | 12400 | 491 | 8 | 2024-06-03 | 1.35 | 2024-05-22 | 53.99 | 3 | SO63920 | 2024-05-29 | 4.32 | 41.57 | |
SO70011_1 | 100 | 25508 | 606 | 8 | 2024-08-28 | 13.50 | 2024-08-16 | 539.99 | 1 | SO70011 | 2024-08-23 | 43.20 | 343.65 | |
SO50022_1 | 100 | 12712 | 358 | 8 | 2023-08-05 | 51.23 | 2023-07-24 | 2049.10 | 1 | SO50022 | 2023-07-31 | 163.93 | 1105.81 | |
SO57745_3 | 100 | 16587 | 479 | 8 | 2024-03-03 | 0.22 | 2024-02-20 | 8.99 | 3 | SO57745 | 2024-02-27 | 0.72 | 3.36 | |
SO63943_1 | 100 | 23933 | 605 | 8 | 2024-06-03 | 13.50 | 2024-05-22 | 539.99 | 1 | SO63943 | 2024-05-29 | 43.20 | 343.65 | |
SO70019_1 | 100 | 19288 | 583 | 8 | 2024-08-29 | 42.52 | 2024-08-17 | 1700.99 | 1 | SO70019 | 2024-08-24 | 136.08 | 1082.51 | |
SO50033_1 | 100 | 12713 | 356 | 8 | 2023-08-06 | 51.79 | 2023-07-25 | 2071.42 | 1 | SO50033 | 2023-08-01 | 165.71 | 1117.86 | |
SO57745_4 | 100 | 16587 | 214 | 8 | 2024-03-03 | 0.87 | 2024-02-20 | 34.99 | 4 | SO57745 | 2024-02-27 | 2.80 | 13.09 | |
SO63943_2 | 100 | 23933 | 538 | 8 | 2024-06-03 | 0.54 | 2024-05-22 | 21.49 | 2 | SO63943 | 2024-05-29 | 1.72 | 8.04 | |
SO70019_2 | 100 | 19288 | 222 | 8 | 2024-08-29 | 0.87 | 2024-08-17 | 34.99 | 2 | SO70019 | 2024-08-24 | 2.80 | 13.09 | |
SO50038_1 | 100 | 17784 | 379 | 8 | 2023-08-07 | 54.54 | 2023-07-26 | 2181.56 | 1 | SO50038 | 2023-08-02 | 174.53 | 1320.68 | |
SO57745_5 | 100 | 16587 | 237 | 2 | 8 | 2024-03-03 | 1.25 | 2024-02-20 | 49.99 | 5 | SO57745 | 2024-02-27 | 4.00 | 38.49 |
SO63943_3 | 100 | 23933 | 480 | 8 | 2024-06-03 | 0.06 | 2024-05-22 | 2.29 | 3 | SO63943 | 2024-05-29 | 0.18 | 0.86 | |
SO70028_1 | 100 | 21057 | 357 | 8 | 2024-08-29 | 58.00 | 2024-08-17 | 2319.99 | 1 | SO70028 | 2024-08-24 | 185.60 | 1265.62 | |
SO50048_1 | 100 | 19197 | 389 | 8 | 2023-08-08 | 25.01 | 2023-07-27 | 1000.44 | 1 | SO50048 | 2023-08-03 | 80.04 | 605.65 | |
SO57768_1 | 100 | 18180 | 528 | 8 | 2024-03-04 | 0.12 | 2024-02-21 | 4.99 | 1 | SO57768 | 2024-02-28 | 0.40 | 1.87 | |
SO63955_1 | 100 | 15063 | 600 | 8 | 2024-06-04 | 13.50 | 2024-05-23 | 539.99 | 1 | SO63955 | 2024-05-30 | 43.20 | 294.58 | |
SO70028_2 | 100 | 21057 | 537 | 8 | 2024-08-29 | 0.88 | 2024-08-17 | 35.00 | 2 | SO70028 | 2024-08-24 | 2.80 | 13.09 | |
SO50053_1 | 100 | 17811 | 371 | 8 | 2023-08-09 | 54.54 | 2023-07-28 | 2181.56 | 1 | SO50053 | 2023-08-04 | 174.53 | 1320.68 | |
SO57768_2 | 100 | 18180 | 484 | 8 | 2024-03-04 | 0.20 | 2024-02-21 | 7.95 | 2 | SO57768 | 2024-02-28 | 0.64 | 2.97 | |
SO63955_2 | 100 | 15063 | 477 | 8 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63955 | 2024-05-30 | 0.40 | 1.87 | |
SO70028_3 | 100 | 21057 | 528 | 8 | 2024-08-29 | 0.12 | 2024-08-17 | 4.99 | 3 | SO70028 | 2024-08-24 | 0.40 | 1.87 | |
SO50070_1 | 100 | 12624 | 358 | 8 | 2023-08-10 | 51.23 | 2023-07-29 | 2049.10 | 1 | SO50070 | 2023-08-05 | 163.93 | 1105.81 | |
SO57787_1 | 100 | 26988 | 386 | 8 | 2024-03-04 | 28.01 | 2024-02-21 | 1120.49 | 1 | SO57787 | 2024-02-28 | 89.64 | 713.08 | |
SO63955_3 | 100 | 15063 | 478 | 8 | 2024-06-04 | 0.25 | 2024-05-23 | 9.99 | 3 | SO63955 | 2024-05-30 | 0.80 | 3.74 | |
SO70028_4 | 100 | 21057 | 217 | 8 | 2024-08-29 | 0.87 | 2024-08-17 | 34.99 | 4 | SO70028 | 2024-08-24 | 2.80 | 13.09 | |
SO50082_1 | 100 | 20874 | 325 | 8 | 2023-08-11 | 19.57 | 2023-07-30 | 782.99 | 1 | SO50082 | 2023-08-06 | 62.64 | 486.71 | |
SO57787_2 | 100 | 26988 | 234 | 8 | 2024-03-04 | 1.25 | 2024-02-21 | 49.99 | 2 | SO57787 | 2024-02-28 | 4.00 | 38.49 | |
SO64027_1 | 100 | 14786 | 485 | 8 | 2024-06-05 | 0.55 | 2024-05-24 | 21.98 | 1 | SO64027 | 2024-05-31 | 1.76 | 8.22 | |
SO70029_1 | 100 | 12852 | 357 | 8 | 2024-08-29 | 58.00 | 2024-08-17 | 2319.99 | 1 | SO70029 | 2024-08-24 | 185.60 | 1265.62 | |
SO50084_1 | 100 | 12548 | 362 | 2 | 8 | 2023-08-11 | 51.23 | 2023-07-30 | 2049.10 | 1 | SO50084 | 2023-08-06 | 163.93 | 1105.81 |
SO57787_3 | 100 | 26988 | 225 | 8 | 2024-03-04 | 0.22 | 2024-02-21 | 8.99 | 3 | SO57787 | 2024-02-28 | 0.72 | 6.92 | |
SO64027_2 | 100 | 14786 | 478 | 8 | 2024-06-05 | 0.25 | 2024-05-24 | 9.99 | 2 | SO64027 | 2024-05-31 | 0.80 | 3.74 | |
SO70029_2 | 100 | 12852 | 528 | 8 | 2024-08-29 | 0.12 | 2024-08-17 | 4.99 | 2 | SO70029 | 2024-08-24 | 0.40 | 1.87 | |
SO50115_1 | 100 | 17764 | 373 | 8 | 2023-08-16 | 54.54 | 2023-08-04 | 2181.56 | 1 | SO50115 | 2023-08-11 | 174.53 | 1320.68 | |
SO57803_1 | 100 | 16409 | 376 | 8 | 2024-03-05 | 61.08 | 2024-02-22 | 2443.35 | 1 | SO57803 | 2024-02-29 | 195.47 | 1554.95 | |
SO64027_3 | 100 | 14786 | 222 | 8 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 3 | SO64027 | 2024-05-31 | 2.80 | 13.09 | |
SO70029_3 | 100 | 12852 | 537 | 8 | 2024-08-29 | 0.88 | 2024-08-17 | 35.00 | 3 | SO70029 | 2024-08-24 | 2.80 | 13.09 | |
SO50116_1 | 100 | 17825 | 377 | 8 | 2023-08-16 | 54.54 | 2023-08-04 | 2181.56 | 1 | SO50116 | 2023-08-11 | 174.53 | 1320.68 | |
SO57803_2 | 100 | 16409 | 477 | 8 | 2024-03-05 | 0.12 | 2024-02-22 | 4.99 | 2 | SO57803 | 2024-02-29 | 0.40 | 1.87 | |
SO64031_1 | 100 | 22707 | 529 | 8 | 2024-06-05 | 0.10 | 2024-05-24 | 3.99 | 1 | SO64031 | 2024-05-31 | 0.32 | 1.49 | |
SO70029_4 | 100 | 12852 | 480 | 8 | 2024-08-29 | 0.06 | 2024-08-17 | 2.29 | 4 | SO70029 | 2024-08-24 | 0.18 | 0.86 | |
SO50117_1 | 100 | 17893 | 375 | 8 | 2023-08-16 | 54.54 | 2023-08-04 | 2181.56 | 1 | SO50117 | 2023-08-11 | 174.53 | 1320.68 | |
SO57803_3 | 100 | 16409 | 463 | 8 | 2024-03-05 | 0.61 | 2024-02-22 | 24.49 | 3 | SO57803 | 2024-02-29 | 1.96 | 9.16 | |
SO64031_2 | 100 | 22707 | 225 | 8 | 2024-06-05 | 0.22 | 2024-05-24 | 8.99 | 2 | SO64031 | 2024-05-31 | 0.72 | 6.92 | |
SO70052_1 | 100 | 16280 | 528 | 8 | 2024-08-29 | 0.12 | 2024-08-17 | 4.99 | 1 | SO70052 | 2024-08-24 | 0.40 | 1.87 | |
SO50130_1 | 100 | 19284 | 383 | 8 | 2023-08-17 | 25.01 | 2023-08-05 | 1000.44 | 1 | SO50130 | 2023-08-12 | 80.04 | 605.65 | |
SO57803_4 | 100 | 16409 | 479 | 8 | 2024-03-05 | 0.22 | 2024-02-22 | 8.99 | 4 | SO57803 | 2024-02-29 | 0.72 | 3.36 | |
SO64031_3 | 100 | 22707 | 231 | 8 | 2024-06-05 | 1.25 | 2024-05-24 | 49.99 | 3 | SO64031 | 2024-05-31 | 4.00 | 38.49 | |
SO70052_2 | 100 | 16280 | 484 | 8 | 2024-08-29 | 0.20 | 2024-08-17 | 7.95 | 2 | SO70052 | 2024-08-24 | 0.64 | 2.97 | |
SO50145_1 | 100 | 19283 | 387 | 8 | 2023-08-18 | 25.01 | 2023-08-06 | 1000.44 | 1 | SO50145 | 2023-08-13 | 80.04 | 605.65 | |
SO57818_1 | 100 | 29438 | 541 | 8 | 2024-03-05 | 0.72 | 2024-02-22 | 28.99 | 1 | SO57818 | 2024-02-29 | 2.32 | 10.84 | |
SO64033_1 | 100 | 27832 | 538 | 8 | 2024-06-05 | 0.54 | 2024-05-24 | 21.49 | 1 | SO64033 | 2024-05-31 | 1.72 | 8.04 | |
SO70066_1 | 100 | 19438 | 579 | 8 | 2024-08-29 | 30.37 | 2024-08-17 | 1214.85 | 1 | SO70066 | 2024-08-24 | 97.19 | 755.15 | |
SO50152_1 | 100 | 17768 | 371 | 8 | 2023-08-19 | 54.54 | 2023-08-07 | 2181.56 | 1 | SO50152 | 2023-08-14 | 174.53 | 1320.68 | |
SO57818_2 | 100 | 29438 | 530 | 8 | 2024-03-05 | 0.12 | 2024-02-22 | 4.99 | 2 | SO57818 | 2024-02-29 | 0.40 | 1.87 | |
SO64066_1 | 100 | 11428 | 581 | 8 | 2024-06-06 | 42.52 | 2024-05-25 | 1700.99 | 1 | SO64066 | 2024-06-01 | 136.08 | 1082.51 | |
SO70066_2 | 100 | 19438 | 488 | 8 | 2024-08-29 | 1.35 | 2024-08-17 | 53.99 | 2 | SO70066 | 2024-08-24 | 4.32 | 41.57 | |
SO50164_1 | 100 | 17765 | 377 | 8 | 2023-08-20 | 54.54 | 2023-08-08 | 2181.56 | 1 | SO50164 | 2023-08-15 | 174.53 | 1320.68 | |
SO57820_1 | 100 | 14153 | 530 | 8 | 2024-03-05 | 0.12 | 2024-02-22 | 4.99 | 1 | SO57820 | 2024-02-29 | 0.40 | 1.87 | |
SO64066_2 | 100 | 11428 | 488 | 8 | 2024-06-06 | 1.35 | 2024-05-25 | 53.99 | 2 | SO64066 | 2024-06-01 | 4.32 | 41.57 | |
SO70067_1 | 100 | 29363 | 570 | 8 | 2024-08-29 | 18.56 | 2024-08-17 | 742.35 | 1 | SO70067 | 2024-08-24 | 59.39 | 461.44 | |
SO50179_1 | 100 | 17769 | 377 | 8 | 2023-08-22 | 54.54 | 2023-08-10 | 2181.56 | 1 | SO50179 | 2023-08-17 | 174.53 | 1320.68 | |
SO57820_2 | 100 | 14153 | 217 | 8 | 2024-03-05 | 0.87 | 2024-02-22 | 34.99 | 2 | SO57820 | 2024-02-29 | 2.80 | 13.09 | |
SO64072_1 | 100 | 16603 | 353 | 2 | 8 | 2024-06-06 | 58.00 | 2024-05-25 | 2319.99 | 1 | SO64072 | 2024-06-01 | 185.60 | 1265.62 |
SO70067_2 | 100 | 29363 | 214 | 8 | 2024-08-29 | 0.87 | 2024-08-17 | 34.99 | 2 | SO70067 | 2024-08-24 | 2.80 | 13.09 | |
SO50180_1 | 100 | 17777 | 369 | 2 | 8 | 2023-08-22 | 61.08 | 2023-08-10 | 2443.35 | 1 | SO50180 | 2023-08-17 | 195.47 | 1518.79 |
SO57820_3 | 100 | 14153 | 225 | 8 | 2024-03-05 | 0.22 | 2024-02-22 | 8.99 | 3 | SO57820 | 2024-02-29 | 0.72 | 6.92 |
Generated 2024-11-11 00:15:24.499 UTC