[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2413 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63800_3 | 6 | 13971 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 3 | SO63800 | 2024-04-06 | 0.40 | 1.87 | |
SO63801_1 | 6 | 14020 | 353 | 9 | 2024-04-11 | 58.00 | 2024-03-30 | 2319.99 | 1 | SO63801 | 2024-04-06 | 185.60 | 1265.62 | |
SO63801_2 | 6 | 14020 | 480 | 9 | 2024-04-11 | 0.06 | 2024-03-30 | 2.29 | 2 | SO63801 | 2024-04-06 | 0.18 | 0.86 | |
SO63817_1 | 6 | 11952 | 576 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63817 | 2024-04-06 | 190.73 | 1481.94 | |
SO63817_2 | 6 | 11952 | 479 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 2 | SO63817 | 2024-04-06 | 0.72 | 3.36 | |
SO63817_3 | 6 | 11952 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 3 | SO63817 | 2024-04-06 | 0.40 | 1.87 | |
SO63818_1 | 6 | 27867 | 573 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63818 | 2024-04-06 | 190.73 | 1481.94 | |
SO63818_2 | 6 | 27867 | 465 | 9 | 2024-04-11 | 0.61 | 2024-03-30 | 24.49 | 2 | SO63818 | 2024-04-06 | 1.96 | 9.16 | |
SO63818_3 | 6 | 27867 | 217 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 3 | SO63818 | 2024-04-06 | 2.80 | 13.09 | |
SO63819_1 | 6 | 11100 | 563 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63819 | 2024-04-06 | 190.73 | 1481.94 | |
SO63819_2 | 6 | 11100 | 479 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 2 | SO63819 | 2024-04-06 | 0.72 | 3.36 | |
SO63819_3 | 6 | 11100 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 3 | SO63819 | 2024-04-06 | 0.40 | 1.87 | |
SO63820_1 | 6 | 11967 | 574 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63820 | 2024-04-06 | 190.73 | 1481.94 | |
SO63820_2 | 6 | 11967 | 217 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63820 | 2024-04-06 | 2.80 | 13.09 | |
SO63821_1 | 6 | 29067 | 584 | 9 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63821 | 2024-04-06 | 43.20 | 343.65 | |
SO63822_1 | 6 | 29096 | 604 | 9 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63822 | 2024-04-06 | 43.20 | 343.65 | |
SO63822_2 | 6 | 29096 | 214 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63822 | 2024-04-06 | 2.80 | 13.09 | |
SO63825_1 | 6 | 12992 | 535 | 9 | 2024-04-12 | 0.62 | 2024-03-31 | 24.99 | 1 | SO63825 | 2024-04-07 | 2.00 | 9.35 | |
SO63825_2 | 6 | 12992 | 528 | 9 | 2024-04-12 | 0.12 | 2024-03-31 | 4.99 | 2 | SO63825 | 2024-04-07 | 0.40 | 1.87 | |
SO70358_1 | 6 | 15646 | 583 | 9 | 2024-07-13 | 42.52 | 2024-07-01 | 1700.99 | 1 | SO70358 | 2024-07-08 | 136.08 | 1082.51 | |
SO70358_2 | 6 | 15646 | 489 | 9 | 2024-07-13 | 1.35 | 2024-07-01 | 53.99 | 2 | SO70358 | 2024-07-08 | 4.32 | 41.57 | |
SO70359_1 | 6 | 12589 | 596 | 9 | 2024-07-13 | 13.50 | 2024-07-01 | 539.99 | 1 | SO70359 | 2024-07-08 | 43.20 | 294.58 | |
SO70359_2 | 6 | 12589 | 485 | 9 | 2024-07-13 | 0.55 | 2024-07-01 | 21.98 | 2 | SO70359 | 2024-07-08 | 1.76 | 8.22 | |
SO70359_3 | 6 | 12589 | 489 | 9 | 2024-07-13 | 1.35 | 2024-07-01 | 53.99 | 3 | SO70359 | 2024-07-08 | 4.32 | 41.57 | |
SO70360_1 | 6 | 15755 | 355 | 9 | 2024-07-13 | 58.00 | 2024-07-01 | 2319.99 | 1 | SO70360 | 2024-07-08 | 185.60 | 1265.62 | |
SO70360_2 | 6 | 15755 | 214 | 9 | 2024-07-13 | 0.87 | 2024-07-01 | 34.99 | 2 | SO70360 | 2024-07-08 | 2.80 | 13.09 | |
SO70361_1 | 6 | 15717 | 353 | 9 | 2024-07-13 | 58.00 | 2024-07-01 | 2319.99 | 1 | SO70361 | 2024-07-08 | 185.60 | 1265.62 | |
SO70361_2 | 6 | 15717 | 528 | 9 | 2024-07-13 | 0.12 | 2024-07-01 | 4.99 | 2 | SO70361 | 2024-07-08 | 0.40 | 1.87 | |
SO70361_3 | 6 | 15717 | 537 | 9 | 2024-07-13 | 0.88 | 2024-07-01 | 35.00 | 3 | SO70361 | 2024-07-08 | 2.80 | 13.09 | |
SO70361_4 | 6 | 15717 | 480 | 9 | 2024-07-13 | 0.06 | 2024-07-01 | 2.29 | 4 | SO70361 | 2024-07-08 | 0.18 | 0.86 | |
SO70373_1 | 6 | 11032 | 570 | 9 | 2024-07-13 | 18.56 | 2024-07-01 | 742.35 | 1 | SO70373 | 2024-07-08 | 59.39 | 461.44 | |
SO70373_2 | 6 | 11032 | 225 | 9 | 2024-07-13 | 0.22 | 2024-07-01 | 8.99 | 2 | SO70373 | 2024-07-08 | 0.72 | 6.92 | |
SO70374_1 | 6 | 11044 | 572 | 9 | 2024-07-13 | 18.56 | 2024-07-01 | 742.35 | 1 | SO70374 | 2024-07-08 | 59.39 | 461.44 | |
SO70374_2 | 6 | 11044 | 479 | 9 | 2024-07-13 | 0.22 | 2024-07-01 | 8.99 | 2 | SO70374 | 2024-07-08 | 0.72 | 3.36 | |
SO70374_3 | 6 | 11044 | 477 | 9 | 2024-07-13 | 0.12 | 2024-07-01 | 4.99 | 3 | SO70374 | 2024-07-08 | 0.40 | 1.87 | |
SO70374_4 | 6 | 11044 | 490 | 9 | 2024-07-13 | 1.35 | 2024-07-01 | 53.99 | 4 | SO70374 | 2024-07-08 | 4.32 | 41.57 | |
SO70375_1 | 6 | 25713 | 606 | 9 | 2024-07-13 | 13.50 | 2024-07-01 | 539.99 | 1 | SO70375 | 2024-07-08 | 43.20 | 343.65 | |
SO70375_2 | 6 | 25713 | 477 | 9 | 2024-07-13 | 0.12 | 2024-07-01 | 4.99 | 2 | SO70375 | 2024-07-08 | 0.40 | 1.87 | |
SO70375_3 | 6 | 25713 | 479 | 9 | 2024-07-13 | 0.22 | 2024-07-01 | 8.99 | 3 | SO70375 | 2024-07-08 | 0.72 | 3.36 | |
SO70375_4 | 6 | 25713 | 222 | 9 | 2024-07-13 | 0.87 | 2024-07-01 | 34.99 | 4 | SO70375 | 2024-07-08 | 2.80 | 13.09 | |
SO70376_1 | 6 | 21956 | 380 | 9 | 2024-07-14 | 61.08 | 2024-07-02 | 2443.35 | 1 | SO70376 | 2024-07-09 | 195.47 | 1554.95 | |
SO70376_2 | 6 | 21956 | 484 | 9 | 2024-07-14 | 0.20 | 2024-07-02 | 7.95 | 2 | SO70376 | 2024-07-09 | 0.64 | 2.97 | |
SO70377_1 | 6 | 21959 | 374 | 9 | 2024-07-14 | 61.08 | 2024-07-02 | 2443.35 | 1 | SO70377 | 2024-07-09 | 195.47 | 1554.95 | |
SO70377_2 | 6 | 21959 | 479 | 9 | 2024-07-14 | 0.22 | 2024-07-02 | 8.99 | 2 | SO70377 | 2024-07-09 | 0.72 | 3.36 | |
SO70377_3 | 6 | 21959 | 471 | 9 | 2024-07-14 | 1.59 | 2024-07-02 | 63.50 | 3 | SO70377 | 2024-07-09 | 5.08 | 23.75 | |
SO70377_4 | 6 | 21959 | 477 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 4 | SO70377 | 2024-07-09 | 0.40 | 1.87 | |
SO70379_1 | 6 | 16682 | 536 | 9 | 2024-07-14 | 0.75 | 2024-07-02 | 29.99 | 1 | SO70379 | 2024-07-09 | 2.40 | 11.22 | |
SO70380_1 | 6 | 17905 | 529 | 9 | 2024-07-14 | 0.10 | 2024-07-02 | 3.99 | 1 | SO70380 | 2024-07-09 | 0.32 | 1.49 | |
SO70380_2 | 6 | 17905 | 538 | 9 | 2024-07-14 | 0.54 | 2024-07-02 | 21.49 | 2 | SO70380 | 2024-07-09 | 1.72 | 8.04 | |
SO70381_1 | 6 | 25246 | 529 | 9 | 2024-07-14 | 0.10 | 2024-07-02 | 3.99 | 1 | SO70381 | 2024-07-09 | 0.32 | 1.49 | |
SO70381_2 | 6 | 25246 | 538 | 9 | 2024-07-14 | 0.54 | 2024-07-02 | 21.49 | 2 | SO70381 | 2024-07-09 | 1.72 | 8.04 | |
SO70381_3 | 6 | 25246 | 480 | 9 | 2024-07-14 | 0.06 | 2024-07-02 | 2.29 | 3 | SO70381 | 2024-07-09 | 0.18 | 0.86 | |
SO70382_1 | 6 | 13124 | 487 | 9 | 2024-07-14 | 1.37 | 2024-07-02 | 54.99 | 1 | SO70382 | 2024-07-09 | 4.40 | 20.57 | |
SO70382_2 | 6 | 13124 | 484 | 9 | 2024-07-14 | 0.20 | 2024-07-02 | 7.95 | 2 | SO70382 | 2024-07-09 | 0.64 | 2.97 | |
SO70383_1 | 6 | 14686 | 487 | 9 | 2024-07-14 | 1.37 | 2024-07-02 | 54.99 | 1 | SO70383 | 2024-07-09 | 4.40 | 20.57 | |
SO70383_2 | 6 | 14686 | 472 | 9 | 2024-07-14 | 1.59 | 2024-07-02 | 63.50 | 2 | SO70383 | 2024-07-09 | 5.08 | 23.75 | |
SO70433_1 | 6 | 26423 | 390 | 9 | 2024-07-14 | 28.01 | 2024-07-02 | 1120.49 | 1 | SO70433 | 2024-07-09 | 89.64 | 713.08 | |
SO70433_2 | 6 | 26423 | 217 | 9 | 2024-07-14 | 0.87 | 2024-07-02 | 34.99 | 2 | SO70433 | 2024-07-09 | 2.80 | 13.09 | |
SO70433_3 | 6 | 26423 | 473 | 9 | 2024-07-14 | 1.59 | 2024-07-02 | 63.50 | 3 | SO70433 | 2024-07-09 | 5.08 | 23.75 | |
SO70434_1 | 6 | 18452 | 388 | 9 | 2024-07-14 | 28.01 | 2024-07-02 | 1120.49 | 1 | SO70434 | 2024-07-09 | 89.64 | 713.08 | |
SO70434_2 | 6 | 18452 | 488 | 9 | 2024-07-14 | 1.35 | 2024-07-02 | 53.99 | 2 | SO70434 | 2024-07-09 | 4.32 | 41.57 | |
SO70435_1 | 6 | 13117 | 562 | 9 | 2024-07-14 | 59.60 | 2024-07-02 | 2384.07 | 1 | SO70435 | 2024-07-09 | 190.73 | 1481.94 | |
SO70435_2 | 6 | 13117 | 488 | 9 | 2024-07-14 | 1.35 | 2024-07-02 | 53.99 | 2 | SO70435 | 2024-07-09 | 4.32 | 41.57 | |
SO70436_1 | 6 | 15229 | 587 | 9 | 2024-07-14 | 19.24 | 2024-07-02 | 769.49 | 1 | SO70436 | 2024-07-09 | 61.56 | 419.78 | |
SO70436_2 | 6 | 15229 | 477 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 2 | SO70436 | 2024-07-09 | 0.40 | 1.87 | |
SO70436_3 | 6 | 15229 | 478 | 9 | 2024-07-14 | 0.25 | 2024-07-02 | 9.99 | 3 | SO70436 | 2024-07-09 | 0.80 | 3.74 | |
SO70437_1 | 6 | 15764 | 357 | 2 | 9 | 2024-07-14 | 58.00 | 2024-07-02 | 2319.99 | 1 | SO70437 | 2024-07-09 | 185.60 | 1265.62 |
SO70437_2 | 6 | 15764 | 485 | 9 | 2024-07-14 | 0.55 | 2024-07-02 | 21.98 | 2 | SO70437 | 2024-07-09 | 1.76 | 8.22 | |
SO70449_1 | 6 | 11030 | 566 | 9 | 2024-07-14 | 18.56 | 2024-07-02 | 742.35 | 1 | SO70449 | 2024-07-09 | 59.39 | 461.44 | |
SO70449_2 | 6 | 11030 | 225 | 9 | 2024-07-14 | 0.22 | 2024-07-02 | 8.99 | 2 | SO70449 | 2024-07-09 | 0.72 | 6.92 | |
SO70450_1 | 6 | 11901 | 573 | 9 | 2024-07-14 | 59.60 | 2024-07-02 | 2384.07 | 1 | SO70450 | 2024-07-09 | 190.73 | 1481.94 | |
SO70450_2 | 6 | 11901 | 541 | 9 | 2024-07-14 | 0.72 | 2024-07-02 | 28.99 | 2 | SO70450 | 2024-07-09 | 2.32 | 10.84 | |
SO70450_3 | 6 | 11901 | 530 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 3 | SO70450 | 2024-07-09 | 0.40 | 1.87 | |
SO70450_4 | 6 | 11901 | 487 | 9 | 2024-07-14 | 1.37 | 2024-07-02 | 54.99 | 4 | SO70450 | 2024-07-09 | 4.40 | 20.57 | |
SO70451_1 | 6 | 13132 | 561 | 9 | 2024-07-14 | 59.60 | 2024-07-02 | 2384.07 | 1 | SO70451 | 2024-07-09 | 190.73 | 1481.94 | |
SO70451_2 | 6 | 13132 | 477 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 2 | SO70451 | 2024-07-09 | 0.40 | 1.87 | |
SO70451_3 | 6 | 13132 | 479 | 9 | 2024-07-14 | 0.22 | 2024-07-02 | 8.99 | 3 | SO70451 | 2024-07-09 | 0.72 | 3.36 | |
SO70451_4 | 6 | 13132 | 471 | 9 | 2024-07-14 | 1.59 | 2024-07-02 | 63.50 | 4 | SO70451 | 2024-07-09 | 5.08 | 23.75 | |
SO70452_1 | 6 | 27977 | 605 | 9 | 2024-07-14 | 13.50 | 2024-07-02 | 539.99 | 1 | SO70452 | 2024-07-09 | 43.20 | 343.65 | |
SO70452_2 | 6 | 27977 | 479 | 9 | 2024-07-14 | 0.22 | 2024-07-02 | 8.99 | 2 | SO70452 | 2024-07-09 | 0.72 | 3.36 | |
SO70452_3 | 6 | 27977 | 477 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 3 | SO70452 | 2024-07-09 | 0.40 | 1.87 | |
SO70454_1 | 6 | 13037 | 535 | 9 | 2024-07-15 | 0.62 | 2024-07-03 | 24.99 | 1 | SO70454 | 2024-07-10 | 2.00 | 9.35 | |
SO70455_1 | 6 | 12361 | 535 | 9 | 2024-07-15 | 0.62 | 2024-07-03 | 24.99 | 1 | SO70455 | 2024-07-10 | 2.00 | 9.35 | |
SO45515_1 | 6 | 19557 | 310 | 9 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45515 | 2022-04-27 | 286.26 | 2171.29 | |
SO63825_3 | 6 | 12992 | 214 | 9 | 2024-04-12 | 0.87 | 2024-03-31 | 34.99 | 3 | SO63825 | 2024-04-07 | 2.80 | 13.09 | |
SO45584_1 | 6 | 25828 | 336 | 9 | 2022-05-03 | 17.48 | 2022-04-21 | 699.10 | 1 | SO45584 | 2022-04-28 | 55.93 | 413.15 | |
SO63825_4 | 6 | 12992 | 228 | 9 | 2024-04-12 | 1.25 | 2024-03-31 | 49.99 | 4 | SO63825 | 2024-04-07 | 4.00 | 38.49 | |
SO45585_1 | 6 | 11905 | 351 | 9 | 2022-05-03 | 84.37 | 2022-04-21 | 3374.99 | 1 | SO45585 | 2022-04-28 | 270.00 | 1898.09 | |
SO63826_1 | 6 | 23014 | 530 | 9 | 2024-04-12 | 0.12 | 2024-03-31 | 4.99 | 1 | SO63826 | 2024-04-07 | 0.40 | 1.87 | |
SO45589_1 | 6 | 19784 | 314 | 9 | 2022-05-04 | 89.46 | 2022-04-22 | 3578.27 | 1 | SO45589 | 2022-04-29 | 286.26 | 2171.29 | |
SO63826_2 | 6 | 23014 | 225 | 9 | 2024-04-12 | 0.22 | 2024-03-31 | 8.99 | 2 | SO63826 | 2024-04-07 | 0.72 | 6.92 | |
SO45590_1 | 6 | 19763 | 311 | 9 | 2022-05-04 | 89.46 | 2022-04-22 | 3578.27 | 1 | SO45590 | 2022-04-29 | 286.26 | 2171.29 | |
SO63827_1 | 6 | 27367 | 474 | 9 | 2024-04-12 | 1.75 | 2024-03-31 | 69.99 | 1 | SO63827 | 2024-04-07 | 5.60 | 26.18 | |
SO45591_1 | 6 | 25831 | 326 | 9 | 2022-05-04 | 17.48 | 2022-04-22 | 699.10 | 1 | SO45591 | 2022-04-29 | 55.93 | 413.15 | |
SO63828_1 | 6 | 12704 | 529 | 9 | 2024-04-12 | 0.10 | 2024-03-31 | 3.99 | 1 | SO63828 | 2024-04-07 | 0.32 | 1.49 | |
SO45592_1 | 6 | 11897 | 345 | 9 | 2022-05-04 | 85.00 | 2022-04-22 | 3399.99 | 1 | SO45592 | 2022-04-29 | 272.00 | 1912.15 | |
SO63828_2 | 6 | 12704 | 465 | 9 | 2024-04-12 | 0.61 | 2024-03-31 | 24.49 | 2 | SO63828 | 2024-04-07 | 1.96 | 9.16 | |
SO45599_1 | 6 | 19794 | 312 | 9 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45599 | 2022-04-30 | 286.26 | 2171.29 | |
SO63829_1 | 6 | 11146 | 489 | 9 | 2024-04-12 | 1.35 | 2024-03-31 | 53.99 | 1 | SO63829 | 2024-04-07 | 4.32 | 41.57 | |
SO45600_1 | 6 | 19628 | 313 | 9 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45600 | 2022-04-30 | 286.26 | 2171.29 | |
SO63864_1 | 6 | 23652 | 580 | 9 | 2024-04-12 | 42.52 | 2024-03-31 | 1700.99 | 1 | SO63864 | 2024-04-07 | 136.08 | 1082.51 | |
SO45601_1 | 6 | 11893 | 348 | 9 | 2022-05-05 | 84.37 | 2022-04-23 | 3374.99 | 1 | SO45601 | 2022-04-30 | 270.00 | 1898.09 | |
SO63864_2 | 6 | 23652 | 539 | 9 | 2024-04-12 | 0.62 | 2024-03-31 | 24.99 | 2 | SO63864 | 2024-04-07 | 2.00 | 9.35 | |
SO45606_1 | 6 | 19967 | 312 | 9 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45606 | 2022-05-01 | 286.26 | 2171.29 | |
SO63865_1 | 6 | 27582 | 584 | 9 | 2024-04-12 | 13.50 | 2024-03-31 | 539.99 | 1 | SO63865 | 2024-04-07 | 43.20 | 343.65 | |
SO45607_1 | 6 | 25830 | 330 | 9 | 2022-05-06 | 17.48 | 2022-04-24 | 699.10 | 1 | SO45607 | 2022-05-01 | 55.93 | 413.15 | |
SO63865_2 | 6 | 27582 | 479 | 9 | 2024-04-12 | 0.22 | 2024-03-31 | 8.99 | 2 | SO63865 | 2024-04-07 | 0.72 | 3.36 | |
SO45608_1 | 6 | 11896 | 349 | 9 | 2022-05-06 | 84.37 | 2022-04-24 | 3374.99 | 1 | SO45608 | 2022-05-01 | 270.00 | 1898.09 | |
SO63865_3 | 6 | 27582 | 477 | 9 | 2024-04-12 | 0.12 | 2024-03-31 | 4.99 | 3 | SO63865 | 2024-04-07 | 0.40 | 1.87 | |
SO45619_1 | 6 | 19787 | 311 | 9 | 2022-05-08 | 89.46 | 2022-04-26 | 3578.27 | 1 | SO45619 | 2022-05-03 | 286.26 | 2171.29 | |
SO63865_4 | 6 | 27582 | 484 | 9 | 2024-04-12 | 0.20 | 2024-03-31 | 7.95 | 4 | SO63865 | 2024-04-07 | 0.64 | 2.97 | |
SO45620_1 | 6 | 19951 | 314 | 9 | 2022-05-08 | 89.46 | 2022-04-26 | 3578.27 | 1 | SO45620 | 2022-05-03 | 286.26 | 2171.29 |
Generated 2024-09-21 00:48:19.554 UTC