[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2409 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46824_1 | 6 | 24608 | 385 | 9 | 2022-11-11 | 25.01 | 2022-10-30 | 1000.44 | 1 | SO46824 | 2022-11-06 | 80.04 | 605.65 | |
SO57234_2 | 6 | 19789 | 540 | 9 | 2024-02-25 | 0.82 | 2024-02-13 | 32.60 | 2 | SO57234 | 2024-02-20 | 2.61 | 12.19 | |
SO46825_1 | 6 | 12574 | 354 | 9 | 2022-11-11 | 51.79 | 2022-10-30 | 2071.42 | 1 | SO46825 | 2022-11-06 | 165.71 | 1117.86 | |
SO57234_3 | 6 | 19789 | 529 | 9 | 2024-02-25 | 0.10 | 2024-02-13 | 3.99 | 3 | SO57234 | 2024-02-20 | 0.32 | 1.49 | |
SO46826_1 | 6 | 12575 | 360 | 9 | 2022-11-11 | 51.23 | 2022-10-30 | 2049.10 | 1 | SO46826 | 2022-11-06 | 163.93 | 1105.81 | |
SO57245_1 | 6 | 15640 | 536 | 9 | 2024-02-26 | 0.75 | 2024-02-14 | 29.99 | 1 | SO57245 | 2024-02-21 | 2.40 | 11.22 | |
SO46833_1 | 6 | 12360 | 354 | 9 | 2022-11-12 | 51.79 | 2022-10-31 | 2071.42 | 1 | SO46833 | 2022-11-07 | 165.71 | 1117.86 | |
SO57245_2 | 6 | 15640 | 480 | 2 | 9 | 2024-02-26 | 0.06 | 2024-02-14 | 2.29 | 2 | SO57245 | 2024-02-21 | 0.18 | 0.86 |
SO46843_1 | 6 | 21168 | 375 | 9 | 2022-11-13 | 54.54 | 2022-11-01 | 2181.56 | 1 | SO46843 | 2022-11-08 | 174.53 | 1320.68 | |
SO57246_1 | 6 | 15434 | 536 | 9 | 2024-02-26 | 0.75 | 2024-02-14 | 29.99 | 1 | SO57246 | 2024-02-21 | 2.40 | 11.22 | |
SO46844_1 | 6 | 12343 | 358 | 9 | 2022-11-13 | 51.23 | 2022-11-01 | 2049.10 | 1 | SO46844 | 2022-11-08 | 163.93 | 1105.81 | |
SO57247_1 | 6 | 24470 | 477 | 9 | 2024-02-26 | 0.12 | 2024-02-14 | 4.99 | 1 | SO57247 | 2024-02-21 | 0.40 | 1.87 | |
SO46853_1 | 6 | 21192 | 368 | 9 | 2022-11-14 | 61.08 | 2022-11-02 | 2443.35 | 1 | SO46853 | 2022-11-09 | 195.47 | 1518.79 | |
SO57247_2 | 6 | 24470 | 214 | 9 | 2024-02-26 | 0.87 | 2024-02-14 | 34.99 | 2 | SO57247 | 2024-02-21 | 2.80 | 13.09 | |
SO46854_1 | 6 | 20997 | 375 | 9 | 2022-11-14 | 54.54 | 2022-11-02 | 2181.56 | 1 | SO46854 | 2022-11-09 | 174.53 | 1320.68 | |
SO57248_1 | 6 | 22948 | 477 | 9 | 2024-02-26 | 0.12 | 2024-02-14 | 4.99 | 1 | SO57248 | 2024-02-21 | 0.40 | 1.87 | |
SO46860_1 | 6 | 21180 | 371 | 9 | 2022-11-15 | 54.54 | 2022-11-03 | 2181.56 | 1 | SO46860 | 2022-11-10 | 174.53 | 1320.68 | |
SO57248_2 | 6 | 22948 | 214 | 9 | 2024-02-26 | 0.87 | 2024-02-14 | 34.99 | 2 | SO57248 | 2024-02-21 | 2.80 | 13.09 | |
SO46861_1 | 6 | 21214 | 377 | 9 | 2022-11-15 | 54.54 | 2022-11-03 | 2181.56 | 1 | SO46861 | 2022-11-10 | 174.53 | 1320.68 | |
SO57249_1 | 6 | 13963 | 228 | 9 | 2024-02-26 | 1.25 | 2024-02-14 | 49.99 | 1 | SO57249 | 2024-02-21 | 4.00 | 38.49 | |
SO46873_1 | 6 | 21167 | 377 | 9 | 2022-11-17 | 54.54 | 2022-11-05 | 2181.56 | 1 | SO46873 | 2022-11-12 | 174.53 | 1320.68 | |
SO57249_2 | 6 | 13963 | 465 | 9 | 2024-02-26 | 0.61 | 2024-02-14 | 24.49 | 2 | SO57249 | 2024-02-21 | 1.96 | 9.16 | |
SO46874_1 | 6 | 24606 | 381 | 9 | 2022-11-17 | 25.01 | 2022-11-05 | 1000.44 | 1 | SO46874 | 2022-11-12 | 80.04 | 605.65 | |
SO63736_1 | 6 | 11995 | 353 | 9 | 2024-06-02 | 58.00 | 2024-05-21 | 2319.99 | 1 | SO63736 | 2024-05-28 | 185.60 | 1265.62 | |
SO63736_2 | 6 | 11995 | 485 | 9 | 2024-06-02 | 0.55 | 2024-05-21 | 21.98 | 2 | SO63736 | 2024-05-28 | 1.76 | 8.22 | |
SO63736_3 | 6 | 11995 | 472 | 9 | 2024-06-02 | 1.59 | 2024-05-21 | 63.50 | 3 | SO63736 | 2024-05-28 | 5.08 | 23.75 | |
SO63737_1 | 6 | 11034 | 361 | 9 | 2024-06-02 | 57.37 | 2024-05-21 | 2294.99 | 1 | SO63737 | 2024-05-28 | 183.60 | 1251.98 | |
SO63738_1 | 6 | 14030 | 361 | 9 | 2024-06-02 | 57.37 | 2024-05-21 | 2294.99 | 1 | SO63738 | 2024-05-28 | 183.60 | 1251.98 | |
SO63738_2 | 6 | 14030 | 483 | 9 | 2024-06-02 | 3.00 | 2024-05-21 | 120.00 | 2 | SO63738 | 2024-05-28 | 9.60 | 44.88 | |
SO63750_1 | 6 | 11988 | 563 | 9 | 2024-06-02 | 59.60 | 2024-05-21 | 2384.07 | 1 | SO63750 | 2024-05-28 | 190.73 | 1481.94 | |
SO63750_2 | 6 | 11988 | 225 | 9 | 2024-06-02 | 0.22 | 2024-05-21 | 8.99 | 2 | SO63750 | 2024-05-28 | 0.72 | 6.92 | |
SO63751_1 | 6 | 11989 | 575 | 9 | 2024-06-02 | 59.60 | 2024-05-21 | 2384.07 | 1 | SO63751 | 2024-05-28 | 190.73 | 1481.94 | |
SO63752_1 | 6 | 29088 | 567 | 9 | 2024-06-02 | 18.56 | 2024-05-21 | 742.35 | 1 | SO63752 | 2024-05-28 | 59.39 | 461.44 | |
SO63752_2 | 6 | 29088 | 477 | 9 | 2024-06-02 | 0.12 | 2024-05-21 | 4.99 | 2 | SO63752 | 2024-05-28 | 0.40 | 1.87 | |
SO63752_3 | 6 | 29088 | 479 | 9 | 2024-06-02 | 0.22 | 2024-05-21 | 8.99 | 3 | SO63752 | 2024-05-28 | 0.72 | 3.36 | |
SO63753_1 | 6 | 23993 | 605 | 9 | 2024-06-02 | 13.50 | 2024-05-21 | 539.99 | 1 | SO63753 | 2024-05-28 | 43.20 | 343.65 | |
SO63753_2 | 6 | 23993 | 214 | 9 | 2024-06-02 | 0.87 | 2024-05-21 | 34.99 | 2 | SO63753 | 2024-05-28 | 2.80 | 13.09 | |
SO63753_3 | 6 | 23993 | 488 | 9 | 2024-06-02 | 1.35 | 2024-05-21 | 53.99 | 3 | SO63753 | 2024-05-28 | 4.32 | 41.57 | |
SO63754_1 | 6 | 23998 | 605 | 9 | 2024-06-02 | 13.50 | 2024-05-21 | 539.99 | 1 | SO63754 | 2024-05-28 | 43.20 | 343.65 | |
SO63754_2 | 6 | 23998 | 217 | 9 | 2024-06-02 | 0.87 | 2024-05-21 | 34.99 | 2 | SO63754 | 2024-05-28 | 2.80 | 13.09 | |
SO63755_1 | 6 | 12010 | 563 | 9 | 2024-06-02 | 59.60 | 2024-05-21 | 2384.07 | 1 | SO63755 | 2024-05-28 | 190.73 | 1481.94 | |
SO63755_2 | 6 | 12010 | 222 | 9 | 2024-06-02 | 0.87 | 2024-05-21 | 34.99 | 2 | SO63755 | 2024-05-28 | 2.80 | 13.09 | |
SO63755_3 | 6 | 12010 | 465 | 9 | 2024-06-02 | 0.61 | 2024-05-21 | 24.49 | 3 | SO63755 | 2024-05-28 | 1.96 | 9.16 | |
SO63756_1 | 6 | 12039 | 575 | 9 | 2024-06-02 | 59.60 | 2024-05-21 | 2384.07 | 1 | SO63756 | 2024-05-28 | 190.73 | 1481.94 | |
SO63756_2 | 6 | 12039 | 217 | 9 | 2024-06-02 | 0.87 | 2024-05-21 | 34.99 | 2 | SO63756 | 2024-05-28 | 2.80 | 13.09 | |
SO63756_3 | 6 | 12039 | 463 | 9 | 2024-06-02 | 0.61 | 2024-05-21 | 24.49 | 3 | SO63756 | 2024-05-28 | 1.96 | 9.16 | |
SO63758_1 | 6 | 20621 | 378 | 9 | 2024-06-03 | 61.08 | 2024-05-22 | 2443.35 | 1 | SO63758 | 2024-05-29 | 195.47 | 1554.95 | |
SO63758_2 | 6 | 20621 | 540 | 9 | 2024-06-03 | 0.82 | 2024-05-22 | 32.60 | 2 | SO63758 | 2024-05-29 | 2.61 | 12.19 | |
SO63758_3 | 6 | 20621 | 529 | 9 | 2024-06-03 | 0.10 | 2024-05-22 | 3.99 | 3 | SO63758 | 2024-05-29 | 0.32 | 1.49 | |
SO63758_4 | 6 | 20621 | 217 | 9 | 2024-06-03 | 0.87 | 2024-05-22 | 34.99 | 4 | SO63758 | 2024-05-29 | 2.80 | 13.09 | |
SO63758_5 | 6 | 20621 | 465 | 9 | 2024-06-03 | 0.61 | 2024-05-22 | 24.49 | 5 | SO63758 | 2024-05-29 | 1.96 | 9.16 | |
SO63759_1 | 6 | 15025 | 539 | 9 | 2024-06-03 | 0.62 | 2024-05-22 | 24.99 | 1 | SO63759 | 2024-05-29 | 2.00 | 9.35 | |
SO63760_1 | 6 | 16606 | 536 | 9 | 2024-06-03 | 0.75 | 2024-05-22 | 29.99 | 1 | SO63760 | 2024-05-29 | 2.40 | 11.22 | |
SO63760_2 | 6 | 16606 | 480 | 2 | 9 | 2024-06-03 | 0.06 | 2024-05-22 | 2.29 | 2 | SO63760 | 2024-05-29 | 0.18 | 0.86 |
SO63761_1 | 6 | 24380 | 477 | 9 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 1 | SO63761 | 2024-05-29 | 0.40 | 1.87 | |
SO63762_1 | 6 | 12665 | 528 | 9 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 1 | SO63762 | 2024-05-29 | 0.40 | 1.87 | |
SO63762_2 | 6 | 12665 | 480 | 2 | 9 | 2024-06-03 | 0.06 | 2024-05-22 | 2.29 | 2 | SO63762 | 2024-05-29 | 0.18 | 0.86 |
SO63796_1 | 6 | 24004 | 584 | 9 | 2024-06-03 | 13.50 | 2024-05-22 | 539.99 | 1 | SO63796 | 2024-05-29 | 43.20 | 343.65 | |
SO63796_2 | 6 | 24004 | 479 | 9 | 2024-06-03 | 0.22 | 2024-05-22 | 8.99 | 2 | SO63796 | 2024-05-29 | 0.72 | 3.36 | |
SO63796_3 | 6 | 24004 | 477 | 9 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 3 | SO63796 | 2024-05-29 | 0.40 | 1.87 |
Generated 2024-11-13 00:51:37.071 UTC