[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 887 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63767_2 | 100 | 14167 | 228 | 8 | 2024-06-01 | 1.25 | 2024-05-20 | 49.99 | 2 | SO63767 | 2024-05-27 | 4.00 | 38.49 |
SO63767_3 | 100 | 14167 | 225 | 8 | 2024-06-01 | 0.22 | 2024-05-20 | 8.99 | 3 | SO63767 | 2024-05-27 | 0.72 | 6.92 |
SO63768_1 | 100 | 17199 | 357 | 8 | 2024-06-01 | 58.00 | 2024-05-20 | 2319.99 | 1 | SO63768 | 2024-05-27 | 185.60 | 1265.62 |
SO63768_2 | 100 | 17199 | 478 | 8 | 2024-06-01 | 0.25 | 2024-05-20 | 9.99 | 2 | SO63768 | 2024-05-27 | 0.80 | 3.74 |
SO63768_3 | 100 | 17199 | 477 | 8 | 2024-06-01 | 0.12 | 2024-05-20 | 4.99 | 3 | SO63768 | 2024-05-27 | 0.40 | 1.87 |
SO63768_4 | 100 | 17199 | 491 | 8 | 2024-06-01 | 1.35 | 2024-05-20 | 53.99 | 4 | SO63768 | 2024-05-27 | 4.32 | 41.57 |
SO63768_5 | 100 | 17199 | 225 | 8 | 2024-06-01 | 0.22 | 2024-05-20 | 8.99 | 5 | SO63768 | 2024-05-27 | 0.72 | 6.92 |
SO63814_1 | 100 | 28405 | 390 | 8 | 2024-06-01 | 28.01 | 2024-05-20 | 1120.49 | 1 | SO63814 | 2024-05-27 | 89.64 | 713.08 |
SO63814_2 | 100 | 28405 | 217 | 8 | 2024-06-01 | 0.87 | 2024-05-20 | 34.99 | 2 | SO63814 | 2024-05-27 | 2.80 | 13.09 |
SO69221_4 | 100 | 27139 | 488 | 8 | 2024-08-20 | 1.35 | 2024-08-08 | 53.99 | 4 | SO69221 | 2024-08-15 | 4.32 | 41.57 |
SO44905_1 | 29 | 13822 | 312 | 8 | 2022-04-08 | 89.46 | 2022-03-27 | 3578.27 | 1 | SO44905 | 2022-04-03 | 286.26 | 2171.29 |
SO57010_3 | 100 | 13259 | 529 | 8 | 2024-02-22 | 0.10 | 2024-02-10 | 3.99 | 3 | SO57010 | 2024-02-17 | 0.32 | 1.49 |
SO63830_1 | 100 | 17929 | 580 | 8 | 2024-06-02 | 42.52 | 2024-05-21 | 1700.99 | 1 | SO63830 | 2024-05-28 | 136.08 | 1082.51 |
SO69238_1 | 100 | 24717 | 606 | 8 | 2024-08-20 | 13.50 | 2024-08-08 | 539.99 | 1 | SO69238 | 2024-08-15 | 43.20 | 343.65 |
SO44907_1 | 29 | 19415 | 324 | 8 | 2022-04-08 | 17.48 | 2022-03-27 | 699.10 | 1 | SO44907 | 2022-04-03 | 55.93 | 413.15 |
SO57010_4 | 100 | 13259 | 222 | 8 | 2024-02-22 | 0.87 | 2024-02-10 | 34.99 | 4 | SO57010 | 2024-02-17 | 2.80 | 13.09 |
SO63830_2 | 100 | 17929 | 479 | 8 | 2024-06-02 | 0.22 | 2024-05-21 | 8.99 | 2 | SO63830 | 2024-05-28 | 0.72 | 3.36 |
SO69240_1 | 100 | 26229 | 564 | 8 | 2024-08-20 | 59.60 | 2024-08-08 | 2384.07 | 1 | SO69240 | 2024-08-15 | 190.73 | 1481.94 |
SO44917_1 | 29 | 13842 | 310 | 8 | 2022-04-09 | 89.46 | 2022-03-28 | 3578.27 | 1 | SO44917 | 2022-04-04 | 286.26 | 2171.29 |
SO57010_5 | 100 | 13259 | 225 | 8 | 2024-02-22 | 0.22 | 2024-02-10 | 8.99 | 5 | SO57010 | 2024-02-17 | 0.72 | 6.92 |
SO63830_3 | 100 | 17929 | 477 | 8 | 2024-06-02 | 0.12 | 2024-05-21 | 4.99 | 3 | SO63830 | 2024-05-28 | 0.40 | 1.87 |
SO69240_2 | 100 | 26229 | 222 | 8 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 2 | SO69240 | 2024-08-15 | 2.80 | 13.09 |
SO44918_1 | 29 | 29466 | 350 | 8 | 2022-04-09 | 84.37 | 2022-03-28 | 3374.99 | 1 | SO44918 | 2022-04-04 | 270.00 | 1898.09 |
SO57010_6 | 100 | 13259 | 234 | 8 | 2024-02-22 | 1.25 | 2024-02-10 | 49.99 | 6 | SO57010 | 2024-02-17 | 4.00 | 38.49 |
SO63832_1 | 100 | 14148 | 588 | 8 | 2024-06-02 | 19.24 | 2024-05-21 | 769.49 | 1 | SO63832 | 2024-05-28 | 61.56 | 419.78 |
SO69255_1 | 100 | 17811 | 359 | 8 | 2024-08-21 | 57.37 | 2024-08-09 | 2294.99 | 1 | SO69255 | 2024-08-16 | 183.60 | 1251.98 |
SO44949_1 | 29 | 29474 | 349 | 8 | 2022-04-13 | 84.37 | 2022-04-01 | 3374.99 | 1 | SO44949 | 2022-04-08 | 270.00 | 1898.09 |
SO57217_1 | 100 | 16304 | 535 | 8 | 2024-02-23 | 0.62 | 2024-02-11 | 24.99 | 1 | SO57217 | 2024-02-18 | 2.00 | 9.35 |
SO63832_2 | 100 | 14148 | 228 | 8 | 2024-06-02 | 1.25 | 2024-05-21 | 49.99 | 2 | SO63832 | 2024-05-28 | 4.00 | 38.49 |
SO69255_2 | 100 | 17811 | 217 | 8 | 2024-08-21 | 0.87 | 2024-08-09 | 34.99 | 2 | SO69255 | 2024-08-16 | 2.80 | 13.09 |
SO44968_1 | 29 | 19365 | 342 | 8 | 2022-04-15 | 17.48 | 2022-04-03 | 699.10 | 1 | SO44968 | 2022-04-10 | 55.93 | 413.15 |
SO57217_2 | 100 | 16304 | 465 | 8 | 2024-02-23 | 0.61 | 2024-02-11 | 24.49 | 2 | SO57217 | 2024-02-18 | 1.96 | 9.16 |
SO63832_3 | 100 | 14148 | 225 | 8 | 2024-06-02 | 0.22 | 2024-05-21 | 8.99 | 3 | SO63832 | 2024-05-28 | 0.72 | 6.92 |
SO69255_3 | 100 | 17811 | 237 | 8 | 2024-08-21 | 1.25 | 2024-08-09 | 49.99 | 3 | SO69255 | 2024-08-16 | 4.00 | 38.49 |
SO45002_1 | 29 | 13844 | 312 | 8 | 2022-04-20 | 89.46 | 2022-04-08 | 3578.27 | 1 | SO45002 | 2022-04-15 | 286.26 | 2171.29 |
SO57219_1 | 100 | 23965 | 529 | 8 | 2024-02-23 | 0.10 | 2024-02-11 | 3.99 | 1 | SO57219 | 2024-02-18 | 0.32 | 1.49 |
SO63854_1 | 100 | 20715 | 528 | 8 | 2024-06-02 | 0.12 | 2024-05-21 | 4.99 | 1 | SO63854 | 2024-05-28 | 0.40 | 1.87 |
SO69285_1 | 100 | 23957 | 529 | 8 | 2024-08-21 | 0.10 | 2024-08-09 | 3.99 | 1 | SO69285 | 2024-08-16 | 0.32 | 1.49 |
SO45007_1 | 29 | 14137 | 310 | 8 | 2022-04-21 | 89.46 | 2022-04-09 | 3578.27 | 1 | SO45007 | 2022-04-16 | 286.26 | 2171.29 |
SO57219_2 | 100 | 23965 | 222 | 8 | 2024-02-23 | 0.87 | 2024-02-11 | 34.99 | 2 | SO57219 | 2024-02-18 | 2.80 | 13.09 |
SO63854_2 | 100 | 20715 | 536 | 8 | 2024-06-02 | 0.75 | 2024-05-21 | 29.99 | 2 | SO63854 | 2024-05-28 | 2.40 | 11.22 |
SO69285_2 | 100 | 23957 | 217 | 8 | 2024-08-21 | 0.87 | 2024-08-09 | 34.99 | 2 | SO69285 | 2024-08-16 | 2.80 | 13.09 |
SO45009_1 | 29 | 19387 | 338 | 8 | 2022-04-21 | 17.48 | 2022-04-09 | 699.10 | 1 | SO45009 | 2022-04-16 | 55.93 | 413.15 |
SO57221_1 | 100 | 29436 | 541 | 8 | 2024-02-23 | 0.72 | 2024-02-11 | 28.99 | 1 | SO57221 | 2024-02-18 | 2.32 | 10.84 |
SO63854_3 | 100 | 20715 | 480 | 8 | 2024-06-02 | 0.06 | 2024-05-21 | 2.29 | 3 | SO63854 | 2024-05-28 | 0.18 | 0.86 |
SO69319_1 | 100 | 17964 | 361 | 8 | 2024-08-22 | 57.37 | 2024-08-10 | 2294.99 | 1 | SO69319 | 2024-08-17 | 183.60 | 1251.98 |
SO45023_1 | 29 | 13807 | 310 | 8 | 2022-04-22 | 89.46 | 2022-04-10 | 3578.27 | 1 | SO45023 | 2022-04-17 | 286.26 | 2171.29 |
SO57276_1 | 100 | 18006 | 529 | 8 | 2024-02-24 | 0.10 | 2024-02-12 | 3.99 | 1 | SO57276 | 2024-02-19 | 0.32 | 1.49 |
SO63854_4 | 100 | 20715 | 486 | 8 | 2024-06-02 | 3.98 | 2024-05-21 | 159.00 | 4 | SO63854 | 2024-05-28 | 12.72 | 59.47 |
SO69319_2 | 100 | 17964 | 478 | 8 | 2024-08-22 | 0.25 | 2024-08-10 | 9.99 | 2 | SO69319 | 2024-08-17 | 0.80 | 3.74 |
SO45024_1 | 29 | 29475 | 344 | 8 | 2022-04-23 | 85.00 | 2022-04-11 | 3399.99 | 1 | SO45024 | 2022-04-18 | 272.00 | 1912.15 |
SO57276_2 | 100 | 18006 | 222 | 8 | 2024-02-24 | 0.87 | 2024-02-12 | 34.99 | 2 | SO57276 | 2024-02-19 | 2.80 | 13.09 |
SO63860_1 | 100 | 12223 | 214 | 8 | 2024-06-02 | 0.87 | 2024-05-21 | 34.99 | 1 | SO63860 | 2024-05-28 | 2.80 | 13.09 |
SO69319_3 | 100 | 17964 | 477 | 8 | 2024-08-22 | 0.12 | 2024-08-10 | 4.99 | 3 | SO69319 | 2024-08-17 | 0.40 | 1.87 |
SO45032_1 | 29 | 14139 | 311 | 8 | 2022-04-24 | 89.46 | 2022-04-12 | 3578.27 | 1 | SO45032 | 2022-04-19 | 286.26 | 2171.29 |
SO57277_1 | 100 | 26874 | 538 | 8 | 2024-02-24 | 0.54 | 2024-02-12 | 21.49 | 1 | SO57277 | 2024-02-19 | 1.72 | 8.04 |
SO63874_1 | 100 | 20841 | 382 | 8 | 2024-06-02 | 28.01 | 2024-05-21 | 1120.49 | 1 | SO63874 | 2024-05-28 | 89.64 | 713.08 |
SO69319_4 | 100 | 17964 | 217 | 8 | 2024-08-22 | 0.87 | 2024-08-10 | 34.99 | 4 | SO69319 | 2024-08-17 | 2.80 | 13.09 |
SO45100_1 | 100 | 19428 | 326 | 8 | 2022-04-29 | 17.48 | 2022-04-17 | 699.10 | 1 | SO45100 | 2022-04-24 | 55.93 | 413.15 |
SO57277_2 | 100 | 26874 | 480 | 8 | 2024-02-24 | 0.06 | 2024-02-12 | 2.29 | 2 | SO57277 | 2024-02-19 | 0.18 | 0.86 |
Generated 2024-11-10 15:09:13.208 UTC