[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 1000 < SKIP 2301 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58207_1 | 100 | 24313 | 540 | 1 | 2024-01-21 | 0.82 | 2024-01-09 | 32.60 | 1 | SO58207 | 2024-01-16 | 2.61 | 12.19 | |
SO58207_2 | 100 | 24313 | 529 | 1 | 2024-01-21 | 0.10 | 2024-01-09 | 3.99 | 2 | SO58207 | 2024-01-16 | 0.32 | 1.49 | |
SO58207_3 | 100 | 24313 | 481 | 1 | 2024-01-21 | 0.22 | 2024-01-09 | 8.99 | 3 | SO58207 | 2024-01-16 | 0.72 | 3.36 | |
SO58209_1 | 100 | 25900 | 540 | 1 | 2024-01-21 | 0.82 | 2024-01-09 | 32.60 | 1 | SO58209 | 2024-01-16 | 2.61 | 12.19 | |
SO58209_2 | 100 | 25900 | 225 | 1 | 2024-01-21 | 0.22 | 2024-01-09 | 8.99 | 2 | SO58209 | 2024-01-16 | 0.72 | 6.92 | |
SO58212_1 | 100 | 22752 | 536 | 1 | 2024-01-21 | 0.75 | 2024-01-09 | 29.99 | 1 | SO58212 | 2024-01-16 | 2.40 | 11.22 | |
SO58212_2 | 100 | 22752 | 480 | 2 | 1 | 2024-01-21 | 0.06 | 2024-01-09 | 2.29 | 2 | SO58212 | 2024-01-16 | 0.18 | 0.86 |
SO58214_1 | 100 | 20776 | 478 | 1 | 2024-01-21 | 0.25 | 2024-01-09 | 9.99 | 1 | SO58214 | 2024-01-16 | 0.80 | 3.74 | |
SO58214_2 | 100 | 20776 | 477 | 1 | 2024-01-21 | 0.12 | 2024-01-09 | 4.99 | 2 | SO58214 | 2024-01-16 | 0.40 | 1.87 | |
SO58214_3 | 100 | 20776 | 484 | 1 | 2024-01-21 | 0.20 | 2024-01-09 | 7.95 | 3 | SO58214 | 2024-01-16 | 0.64 | 2.97 | |
SO58217_1 | 100 | 17611 | 477 | 1 | 2024-01-21 | 0.12 | 2024-01-09 | 4.99 | 1 | SO58217 | 2024-01-16 | 0.40 | 1.87 | |
SO58217_2 | 100 | 17611 | 217 | 1 | 2024-01-21 | 0.87 | 2024-01-09 | 34.99 | 2 | SO58217 | 2024-01-16 | 2.80 | 13.09 | |
SO58218_1 | 100 | 14503 | 528 | 1 | 2024-01-21 | 0.12 | 2024-01-09 | 4.99 | 1 | SO58218 | 2024-01-16 | 0.40 | 1.87 | |
SO58218_2 | 100 | 14503 | 217 | 1 | 2024-01-21 | 0.87 | 2024-01-09 | 34.99 | 2 | SO58218 | 2024-01-16 | 2.80 | 13.09 | |
SO58219_1 | 100 | 15870 | 528 | 1 | 2024-01-21 | 0.12 | 2024-01-09 | 4.99 | 1 | SO58219 | 2024-01-16 | 0.40 | 1.87 | |
SO58219_2 | 100 | 15870 | 480 | 2 | 1 | 2024-01-21 | 0.06 | 2024-01-09 | 2.29 | 2 | SO58219 | 2024-01-16 | 0.18 | 0.86 |
SO58231_1 | 100 | 12954 | 528 | 1 | 2024-01-21 | 0.12 | 2024-01-09 | 4.99 | 1 | SO58231 | 2024-01-16 | 0.40 | 1.87 | |
SO58231_2 | 100 | 12954 | 537 | 1 | 2024-01-21 | 0.88 | 2024-01-09 | 35.00 | 2 | SO58231 | 2024-01-16 | 2.80 | 13.09 | |
SO58231_3 | 100 | 12954 | 480 | 1 | 2024-01-21 | 0.06 | 2024-01-09 | 2.29 | 3 | SO58231 | 2024-01-16 | 0.18 | 0.86 | |
SO58233_1 | 100 | 13146 | 225 | 1 | 2024-01-21 | 0.22 | 2024-01-09 | 8.99 | 1 | SO58233 | 2024-01-16 | 0.72 | 6.92 | |
SO58233_2 | 100 | 13146 | 485 | 1 | 2024-01-21 | 0.55 | 2024-01-09 | 21.98 | 2 | SO58233 | 2024-01-16 | 1.76 | 8.22 | |
SO58235_1 | 100 | 16998 | 581 | 1 | 2024-01-21 | 42.52 | 2024-01-09 | 1700.99 | 1 | SO58235 | 2024-01-16 | 136.08 | 1082.51 | |
SO58235_2 | 100 | 16998 | 217 | 1 | 2024-01-21 | 0.87 | 2024-01-09 | 34.99 | 2 | SO58235 | 2024-01-16 | 2.80 | 13.09 | |
SO58258_1 | 100 | 26052 | 535 | 1 | 2024-01-22 | 0.62 | 2024-01-10 | 24.99 | 1 | SO58258 | 2024-01-17 | 2.00 | 9.35 | |
SO58267_1 | 100 | 15504 | 528 | 1 | 2024-01-22 | 0.12 | 2024-01-10 | 4.99 | 1 | SO58267 | 2024-01-17 | 0.40 | 1.87 | |
SO58267_2 | 100 | 15504 | 222 | 1 | 2024-01-22 | 0.87 | 2024-01-10 | 34.99 | 2 | SO58267 | 2024-01-17 | 2.80 | 13.09 | |
SO58276_1 | 100 | 19412 | 599 | 1 | 2024-01-22 | 13.50 | 2024-01-10 | 539.99 | 1 | SO58276 | 2024-01-17 | 43.20 | 294.58 | |
SO64782_3 | 100 | 23018 | 477 | 1 | 2024-04-26 | 0.12 | 2024-04-14 | 4.99 | 3 | SO64782 | 2024-04-21 | 0.40 | 1.87 | |
SO64782_4 | 100 | 23018 | 491 | 1 | 2024-04-26 | 1.35 | 2024-04-14 | 53.99 | 4 | SO64782 | 2024-04-21 | 4.32 | 41.57 | |
SO64806_1 | 100 | 29348 | 529 | 1 | 2024-04-27 | 0.10 | 2024-04-15 | 3.99 | 1 | SO64806 | 2024-04-22 | 0.32 | 1.49 | |
SO64806_2 | 100 | 29348 | 222 | 1 | 2024-04-27 | 0.87 | 2024-04-15 | 34.99 | 2 | SO64806 | 2024-04-22 | 2.80 | 13.09 | |
SO64807_1 | 100 | 28012 | 530 | 1 | 2024-04-27 | 0.12 | 2024-04-15 | 4.99 | 1 | SO64807 | 2024-04-22 | 0.40 | 1.87 | |
SO64807_2 | 100 | 28012 | 480 | 2 | 1 | 2024-04-27 | 0.06 | 2024-04-15 | 2.29 | 2 | SO64807 | 2024-04-22 | 0.18 | 0.86 |
SO64808_1 | 100 | 27994 | 530 | 1 | 2024-04-27 | 0.12 | 2024-04-15 | 4.99 | 1 | SO64808 | 2024-04-22 | 0.40 | 1.87 | |
SO64808_2 | 100 | 27994 | 480 | 2 | 1 | 2024-04-27 | 0.06 | 2024-04-15 | 2.29 | 2 | SO64808 | 2024-04-22 | 0.18 | 0.86 |
SO64815_1 | 100 | 21706 | 478 | 1 | 2024-04-27 | 0.25 | 2024-04-15 | 9.99 | 1 | SO64815 | 2024-04-22 | 0.80 | 3.74 | |
SO64815_2 | 100 | 21706 | 477 | 1 | 2024-04-27 | 0.12 | 2024-04-15 | 4.99 | 2 | SO64815 | 2024-04-22 | 0.40 | 1.87 | |
SO64815_3 | 100 | 21706 | 214 | 1 | 2024-04-27 | 0.87 | 2024-04-15 | 34.99 | 3 | SO64815 | 2024-04-22 | 2.80 | 13.09 | |
SO64815_4 | 100 | 21706 | 234 | 1 | 2024-04-27 | 1.25 | 2024-04-15 | 49.99 | 4 | SO64815 | 2024-04-22 | 4.00 | 38.49 | |
SO64816_1 | 100 | 19637 | 474 | 1 | 2024-04-27 | 1.75 | 2024-04-15 | 69.99 | 1 | SO64816 | 2024-04-22 | 5.60 | 26.18 | |
SO64816_2 | 100 | 19637 | 225 | 1 | 2024-04-27 | 0.22 | 2024-04-15 | 8.99 | 2 | SO64816 | 2024-04-22 | 0.72 | 6.92 | |
SO64820_1 | 100 | 16913 | 477 | 1 | 2024-04-27 | 0.12 | 2024-04-15 | 4.99 | 1 | SO64820 | 2024-04-22 | 0.40 | 1.87 | |
SO64820_2 | 100 | 16913 | 225 | 1 | 2024-04-27 | 0.22 | 2024-04-15 | 8.99 | 2 | SO64820 | 2024-04-22 | 0.72 | 6.92 | |
SO64830_1 | 100 | 12168 | 537 | 1 | 2024-04-27 | 0.88 | 2024-04-15 | 35.00 | 1 | SO64830 | 2024-04-22 | 2.80 | 13.09 | |
SO64830_2 | 100 | 12168 | 485 | 1 | 2024-04-27 | 0.55 | 2024-04-15 | 21.98 | 2 | SO64830 | 2024-04-22 | 1.76 | 8.22 | |
SO64830_3 | 100 | 12168 | 484 | 1 | 2024-04-27 | 0.20 | 2024-04-15 | 7.95 | 3 | SO64830 | 2024-04-22 | 0.64 | 2.97 | |
SO64831_1 | 100 | 12767 | 537 | 1 | 2024-04-27 | 0.88 | 2024-04-15 | 35.00 | 1 | SO64831 | 2024-04-22 | 2.80 | 13.09 | |
SO64834_1 | 100 | 14728 | 590 | 1 | 2024-04-27 | 19.24 | 2024-04-15 | 769.49 | 1 | SO64834 | 2024-04-22 | 61.56 | 419.78 | |
SO64834_2 | 100 | 14728 | 474 | 1 | 2024-04-27 | 1.75 | 2024-04-15 | 69.99 | 2 | SO64834 | 2024-04-22 | 5.60 | 26.18 | |
SO64834_3 | 100 | 14728 | 465 | 1 | 2024-04-27 | 0.61 | 2024-04-15 | 24.49 | 3 | SO64834 | 2024-04-22 | 1.96 | 9.16 | |
SO64837_1 | 100 | 13705 | 591 | 1 | 2024-04-27 | 14.12 | 2024-04-15 | 564.99 | 1 | SO64837 | 2024-04-22 | 45.20 | 308.22 | |
SO64837_2 | 100 | 13705 | 478 | 1 | 2024-04-27 | 0.25 | 2024-04-15 | 9.99 | 2 | SO64837 | 2024-04-22 | 0.80 | 3.74 | |
SO64838_1 | 100 | 15350 | 353 | 1 | 2024-04-27 | 58.00 | 2024-04-15 | 2319.99 | 1 | SO64838 | 2024-04-22 | 185.60 | 1265.62 | |
SO64838_2 | 100 | 15350 | 528 | 1 | 2024-04-27 | 0.12 | 2024-04-15 | 4.99 | 2 | SO64838 | 2024-04-22 | 0.40 | 1.87 | |
SO64838_3 | 100 | 15350 | 537 | 1 | 2024-04-27 | 0.88 | 2024-04-15 | 35.00 | 3 | SO64838 | 2024-04-22 | 2.80 | 13.09 | |
SO64838_4 | 100 | 15350 | 480 | 1 | 2024-04-27 | 0.06 | 2024-04-15 | 2.29 | 4 | SO64838 | 2024-04-22 | 0.18 | 0.86 | |
SO64866_1 | 100 | 29210 | 539 | 1 | 2024-04-28 | 0.62 | 2024-04-16 | 24.99 | 1 | SO64866 | 2024-04-23 | 2.00 | 9.35 | |
SO64866_2 | 100 | 29210 | 480 | 1 | 2024-04-28 | 0.06 | 2024-04-16 | 2.29 | 2 | SO64866 | 2024-04-23 | 0.18 | 0.86 | |
SO64870_1 | 100 | 22967 | 478 | 1 | 2024-04-28 | 0.25 | 2024-04-16 | 9.99 | 1 | SO64870 | 2024-04-23 | 0.80 | 3.74 | |
SO64870_2 | 100 | 22967 | 477 | 1 | 2024-04-28 | 0.12 | 2024-04-16 | 4.99 | 2 | SO64870 | 2024-04-23 | 0.40 | 1.87 | |
SO64870_3 | 100 | 22967 | 487 | 1 | 2024-04-28 | 1.37 | 2024-04-16 | 54.99 | 3 | SO64870 | 2024-04-23 | 4.40 | 20.57 | |
SO64873_1 | 100 | 17688 | 477 | 1 | 2024-04-28 | 0.12 | 2024-04-16 | 4.99 | 1 | SO64873 | 2024-04-23 | 0.40 | 1.87 | |
SO64876_1 | 100 | 17487 | 528 | 1 | 2024-04-28 | 0.12 | 2024-04-16 | 4.99 | 1 | SO64876 | 2024-04-23 | 0.40 | 1.87 | |
SO64876_2 | 100 | 17487 | 480 | 2 | 1 | 2024-04-28 | 0.06 | 2024-04-16 | 2.29 | 2 | SO64876 | 2024-04-23 | 0.18 | 0.86 |
SO64878_1 | 100 | 13739 | 485 | 1 | 2024-04-28 | 0.55 | 2024-04-16 | 21.98 | 1 | SO64878 | 2024-04-23 | 1.76 | 8.22 | |
SO64878_2 | 100 | 13739 | 228 | 1 | 2024-04-28 | 1.25 | 2024-04-16 | 49.99 | 2 | SO64878 | 2024-04-23 | 4.00 | 38.49 | |
SO64883_1 | 100 | 12085 | 528 | 1 | 2024-04-28 | 0.12 | 2024-04-16 | 4.99 | 1 | SO64883 | 2024-04-23 | 0.40 | 1.87 | |
SO64883_2 | 100 | 12085 | 537 | 1 | 2024-04-28 | 0.88 | 2024-04-16 | 35.00 | 2 | SO64883 | 2024-04-23 | 2.80 | 13.09 | |
SO64883_3 | 100 | 12085 | 214 | 1 | 2024-04-28 | 0.87 | 2024-04-16 | 34.99 | 3 | SO64883 | 2024-04-23 | 2.80 | 13.09 | |
SO64883_4 | 100 | 12085 | 467 | 1 | 2024-04-28 | 0.61 | 2024-04-16 | 24.49 | 4 | SO64883 | 2024-04-23 | 1.96 | 9.16 | |
SO64885_1 | 100 | 19813 | 599 | 1 | 2024-04-28 | 13.50 | 2024-04-16 | 539.99 | 1 | SO64885 | 2024-04-23 | 43.20 | 294.58 | |
SO64886_1 | 100 | 15987 | 594 | 1 | 2024-04-28 | 14.12 | 2024-04-16 | 564.99 | 1 | SO64886 | 2024-04-23 | 45.20 | 308.22 | |
SO64886_2 | 100 | 15987 | 485 | 1 | 2024-04-28 | 0.55 | 2024-04-16 | 21.98 | 2 | SO64886 | 2024-04-23 | 1.76 | 8.22 | |
SO64886_3 | 100 | 15987 | 214 | 1 | 2024-04-28 | 0.87 | 2024-04-16 | 34.99 | 3 | SO64886 | 2024-04-23 | 2.80 | 13.09 | |
SO64890_1 | 100 | 26325 | 575 | 1 | 2024-04-28 | 59.60 | 2024-04-16 | 2384.07 | 1 | SO64890 | 2024-04-23 | 190.73 | 1481.94 | |
SO64890_2 | 100 | 26325 | 477 | 1 | 2024-04-28 | 0.12 | 2024-04-16 | 4.99 | 2 | SO64890 | 2024-04-23 | 0.40 | 1.87 | |
SO64890_3 | 100 | 26325 | 479 | 1 | 2024-04-28 | 0.22 | 2024-04-16 | 8.99 | 3 | SO64890 | 2024-04-23 | 0.72 | 3.36 | |
SO64890_4 | 100 | 26325 | 225 | 1 | 2024-04-28 | 0.22 | 2024-04-16 | 8.99 | 4 | SO64890 | 2024-04-23 | 0.72 | 6.92 | |
SO64892_1 | 100 | 20646 | 384 | 2 | 1 | 2024-04-28 | 28.01 | 2024-04-16 | 1120.49 | 1 | SO64892 | 2024-04-23 | 89.64 | 713.08 |
SO64892_2 | 100 | 20646 | 477 | 1 | 2024-04-28 | 0.12 | 2024-04-16 | 4.99 | 2 | SO64892 | 2024-04-23 | 0.40 | 1.87 | |
SO64892_3 | 100 | 20646 | 479 | 1 | 2024-04-28 | 0.22 | 2024-04-16 | 8.99 | 3 | SO64892 | 2024-04-23 | 0.72 | 3.36 | |
SO64892_4 | 100 | 20646 | 473 | 1 | 2024-04-28 | 1.59 | 2024-04-16 | 63.50 | 4 | SO64892 | 2024-04-23 | 5.08 | 23.75 | |
SO64907_1 | 100 | 29270 | 529 | 1 | 2024-04-29 | 0.10 | 2024-04-17 | 3.99 | 1 | SO64907 | 2024-04-24 | 0.32 | 1.49 | |
SO64907_2 | 100 | 29270 | 484 | 1 | 2024-04-29 | 0.20 | 2024-04-17 | 7.95 | 2 | SO64907 | 2024-04-24 | 0.64 | 2.97 | |
SO64908_1 | 100 | 28972 | 529 | 1 | 2024-04-29 | 0.10 | 2024-04-17 | 3.99 | 1 | SO64908 | 2024-04-24 | 0.32 | 1.49 | |
SO64908_2 | 100 | 28972 | 539 | 1 | 2024-04-29 | 0.62 | 2024-04-17 | 24.99 | 2 | SO64908 | 2024-04-24 | 2.00 | 9.35 | |
SO64908_3 | 100 | 28972 | 217 | 1 | 2024-04-29 | 0.87 | 2024-04-17 | 34.99 | 3 | SO64908 | 2024-04-24 | 2.80 | 13.09 | |
SO64913_1 | 100 | 21236 | 477 | 1 | 2024-04-29 | 0.12 | 2024-04-17 | 4.99 | 1 | SO64913 | 2024-04-24 | 0.40 | 1.87 | |
SO64913_2 | 100 | 21236 | 478 | 1 | 2024-04-29 | 0.25 | 2024-04-17 | 9.99 | 2 | SO64913 | 2024-04-24 | 0.80 | 3.74 | |
SO64913_3 | 100 | 21236 | 487 | 1 | 2024-04-29 | 1.37 | 2024-04-17 | 54.99 | 3 | SO64913 | 2024-04-24 | 4.40 | 20.57 | |
SO64913_4 | 100 | 21236 | 484 | 1 | 2024-04-29 | 0.20 | 2024-04-17 | 7.95 | 4 | SO64913 | 2024-04-24 | 0.64 | 2.97 | |
SO71167_1 | 100 | 18843 | 476 | 1 | 2024-07-25 | 1.75 | 2024-07-13 | 69.99 | 1 | SO71167 | 2024-07-20 | 5.60 | 26.18 | |
SO71169_1 | 100 | 15479 | 528 | 1 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 1 | SO71169 | 2024-07-20 | 0.40 | 1.87 | |
SO71169_2 | 100 | 15479 | 485 | 1 | 2024-07-25 | 0.55 | 2024-07-13 | 21.98 | 2 | SO71169 | 2024-07-20 | 1.76 | 8.22 | |
SO71169_3 | 100 | 15479 | 225 | 1 | 2024-07-25 | 0.22 | 2024-07-13 | 8.99 | 3 | SO71169 | 2024-07-20 | 0.72 | 6.92 | |
SO71169_4 | 100 | 15479 | 231 | 1 | 2024-07-25 | 1.25 | 2024-07-13 | 49.99 | 4 | SO71169 | 2024-07-20 | 4.00 | 38.49 | |
SO71171_1 | 100 | 15298 | 528 | 1 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 1 | SO71171 | 2024-07-20 | 0.40 | 1.87 | |
SO71171_2 | 100 | 15298 | 480 | 2 | 1 | 2024-07-25 | 0.06 | 2024-07-13 | 2.29 | 2 | SO71171 | 2024-07-20 | 0.18 | 0.86 |
SO71180_1 | 100 | 12434 | 537 | 1 | 2024-07-25 | 0.88 | 2024-07-13 | 35.00 | 1 | SO71180 | 2024-07-20 | 2.80 | 13.09 | |
SO71180_2 | 100 | 12434 | 528 | 1 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 2 | SO71180 | 2024-07-20 | 0.40 | 1.87 | |
SO71180_3 | 100 | 12434 | 217 | 1 | 2024-07-25 | 0.87 | 2024-07-13 | 34.99 | 3 | SO71180 | 2024-07-20 | 2.80 | 13.09 | |
SO71183_1 | 100 | 13384 | 355 | 1 | 2024-07-25 | 58.00 | 2024-07-13 | 2319.99 | 1 | SO71183 | 2024-07-20 | 185.60 | 1265.62 | |
SO71183_2 | 100 | 13384 | 485 | 1 | 2024-07-25 | 0.55 | 2024-07-13 | 21.98 | 2 | SO71183 | 2024-07-20 | 1.76 | 8.22 | |
SO71183_3 | 100 | 13384 | 231 | 1 | 2024-07-25 | 1.25 | 2024-07-13 | 49.99 | 3 | SO71183 | 2024-07-20 | 4.00 | 38.49 | |
SO71184_1 | 100 | 15409 | 588 | 1 | 2024-07-25 | 19.24 | 2024-07-13 | 769.49 | 1 | SO71184 | 2024-07-20 | 61.56 | 419.78 | |
SO71184_2 | 100 | 15409 | 478 | 1 | 2024-07-25 | 0.25 | 2024-07-13 | 9.99 | 2 | SO71184 | 2024-07-20 | 0.80 | 3.74 | |
SO71184_3 | 100 | 15409 | 477 | 1 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 3 | SO71184 | 2024-07-20 | 0.40 | 1.87 | |
SO71185_1 | 100 | 17135 | 355 | 1 | 2024-07-25 | 58.00 | 2024-07-13 | 2319.99 | 1 | SO71185 | 2024-07-20 | 185.60 | 1265.62 | |
SO71185_2 | 100 | 17135 | 222 | 1 | 2024-07-25 | 0.87 | 2024-07-13 | 34.99 | 2 | SO71185 | 2024-07-20 | 2.80 | 13.09 | |
SO71185_3 | 100 | 17135 | 463 | 1 | 2024-07-25 | 0.61 | 2024-07-13 | 24.49 | 3 | SO71185 | 2024-07-20 | 1.96 | 9.16 | |
SO71186_1 | 100 | 13161 | 353 | 2 | 1 | 2024-07-25 | 58.00 | 2024-07-13 | 2319.99 | 1 | SO71186 | 2024-07-20 | 185.60 | 1265.62 |
SO71186_2 | 100 | 13161 | 485 | 1 | 2024-07-25 | 0.55 | 2024-07-13 | 21.98 | 2 | SO71186 | 2024-07-20 | 1.76 | 8.22 |
Generated 2024-09-20 16:40:42.605 UTC