[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 1316 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56442_3 | 98 | 17750 | 483 | 10 | 2024-02-13 | 3.00 | 2024-02-01 | 120.00 | 3 | SO56442 | 2024-02-08 | 9.60 | 44.88 | |
SO56446_1 | 98 | 15657 | 590 | 2 | 10 | 2024-02-13 | 19.24 | 2024-02-01 | 769.49 | 1 | SO56446 | 2024-02-08 | 61.56 | 419.78 |
SO56446_2 | 98 | 15657 | 536 | 10 | 2024-02-13 | 0.75 | 2024-02-01 | 29.99 | 2 | SO56446 | 2024-02-08 | 2.40 | 11.22 | |
SO56446_3 | 98 | 15657 | 528 | 10 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 3 | SO56446 | 2024-02-08 | 0.40 | 1.87 | |
SO56446_4 | 98 | 15657 | 217 | 10 | 2024-02-13 | 0.87 | 2024-02-01 | 34.99 | 4 | SO56446 | 2024-02-08 | 2.80 | 13.09 | |
SO56462_1 | 98 | 13503 | 541 | 10 | 2024-02-13 | 0.72 | 2024-02-01 | 28.99 | 1 | SO56462 | 2024-02-08 | 2.32 | 10.84 | |
SO56462_2 | 98 | 13503 | 530 | 10 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 2 | SO56462 | 2024-02-08 | 0.40 | 1.87 | |
SO56462_3 | 98 | 13503 | 480 | 2 | 10 | 2024-02-13 | 0.06 | 2024-02-01 | 2.29 | 3 | SO56462 | 2024-02-08 | 0.18 | 0.86 |
SO56464_1 | 98 | 13507 | 541 | 10 | 2024-02-13 | 0.72 | 2024-02-01 | 28.99 | 1 | SO56464 | 2024-02-08 | 2.32 | 10.84 | |
SO56468_1 | 98 | 13544 | 478 | 10 | 2024-02-13 | 0.25 | 2024-02-01 | 9.99 | 1 | SO56468 | 2024-02-08 | 0.80 | 3.74 | |
SO56468_2 | 98 | 13544 | 477 | 10 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 2 | SO56468 | 2024-02-08 | 0.40 | 1.87 | |
SO56468_3 | 98 | 13544 | 465 | 10 | 2024-02-13 | 0.61 | 2024-02-01 | 24.49 | 3 | SO56468 | 2024-02-08 | 1.96 | 9.16 | |
SO56479_1 | 98 | 23904 | 390 | 10 | 2024-02-13 | 28.01 | 2024-02-01 | 1120.49 | 1 | SO56479 | 2024-02-08 | 89.64 | 713.08 | |
SO56479_2 | 98 | 23904 | 491 | 10 | 2024-02-13 | 1.35 | 2024-02-01 | 53.99 | 2 | SO56479 | 2024-02-08 | 4.32 | 41.57 | |
SO56479_3 | 98 | 23904 | 463 | 10 | 2024-02-13 | 0.61 | 2024-02-01 | 24.49 | 3 | SO56479 | 2024-02-08 | 1.96 | 9.16 | |
SO56482_1 | 98 | 27901 | 575 | 10 | 2024-02-13 | 59.60 | 2024-02-01 | 2384.07 | 1 | SO56482 | 2024-02-08 | 190.73 | 1481.94 | |
SO56482_2 | 98 | 27901 | 479 | 10 | 2024-02-13 | 0.22 | 2024-02-01 | 8.99 | 2 | SO56482 | 2024-02-08 | 0.72 | 3.36 | |
SO56482_3 | 98 | 27901 | 477 | 10 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 3 | SO56482 | 2024-02-08 | 0.40 | 1.87 | |
SO56482_4 | 98 | 27901 | 214 | 10 | 2024-02-13 | 0.87 | 2024-02-01 | 34.99 | 4 | SO56482 | 2024-02-08 | 2.80 | 13.09 | |
SO56483_1 | 98 | 12644 | 353 | 10 | 2024-02-14 | 58.00 | 2024-02-02 | 2319.99 | 1 | SO56483 | 2024-02-09 | 185.60 | 1265.62 | |
SO56483_2 | 98 | 12644 | 478 | 10 | 2024-02-14 | 0.25 | 2024-02-02 | 9.99 | 2 | SO56483 | 2024-02-09 | 0.80 | 3.74 | |
SO56483_3 | 98 | 12644 | 477 | 10 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 3 | SO56483 | 2024-02-09 | 0.40 | 1.87 | |
SO56483_4 | 98 | 12644 | 217 | 10 | 2024-02-14 | 0.87 | 2024-02-02 | 34.99 | 4 | SO56483 | 2024-02-09 | 2.80 | 13.09 | |
SO56484_1 | 98 | 12647 | 353 | 10 | 2024-02-14 | 58.00 | 2024-02-02 | 2319.99 | 1 | SO56484 | 2024-02-09 | 185.60 | 1265.62 | |
SO56484_2 | 98 | 12647 | 478 | 10 | 2024-02-14 | 0.25 | 2024-02-02 | 9.99 | 2 | SO56484 | 2024-02-09 | 0.80 | 3.74 | |
SO56484_3 | 98 | 12647 | 477 | 10 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 3 | SO56484 | 2024-02-09 | 0.40 | 1.87 | |
SO56484_4 | 98 | 12647 | 465 | 10 | 2024-02-14 | 0.61 | 2024-02-02 | 24.49 | 4 | SO56484 | 2024-02-09 | 1.96 | 9.16 | |
SO56513_1 | 98 | 17226 | 537 | 10 | 2024-02-14 | 0.88 | 2024-02-02 | 35.00 | 1 | SO56513 | 2024-02-09 | 2.80 | 13.09 | |
SO52755_1 | 98 | 16459 | 530 | 10 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO52755 | 2023-12-06 | 0.40 | 1.87 | |
SO52755_2 | 98 | 16459 | 480 | 2 | 10 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 2 | SO52755 | 2023-12-06 | 0.18 | 0.86 |
SO52771_1 | 98 | 22642 | 382 | 10 | 2023-12-11 | 28.01 | 2023-11-29 | 1120.49 | 1 | SO52771 | 2023-12-06 | 89.64 | 713.08 | |
SO52771_2 | 98 | 22642 | 488 | 10 | 2023-12-11 | 1.35 | 2023-11-29 | 53.99 | 2 | SO52771 | 2023-12-06 | 4.32 | 41.57 | |
SO52771_3 | 98 | 22642 | 463 | 10 | 2023-12-11 | 0.61 | 2023-11-29 | 24.49 | 3 | SO52771 | 2023-12-06 | 1.96 | 9.16 | |
SO52775_1 | 98 | 29411 | 578 | 10 | 2023-12-11 | 30.37 | 2023-11-29 | 1214.85 | 1 | SO52775 | 2023-12-06 | 97.19 | 755.15 | |
SO52775_2 | 98 | 29411 | 225 | 10 | 2023-12-11 | 0.22 | 2023-11-29 | 8.99 | 2 | SO52775 | 2023-12-06 | 0.72 | 6.92 | |
SO52784_1 | 98 | 11398 | 359 | 10 | 2023-12-12 | 57.37 | 2023-11-30 | 2294.99 | 1 | SO52784 | 2023-12-07 | 183.60 | 1251.98 | |
SO52785_1 | 98 | 19448 | 376 | 10 | 2023-12-12 | 61.08 | 2023-11-30 | 2443.35 | 1 | SO52785 | 2023-12-07 | 195.47 | 1554.95 | |
SO52785_2 | 98 | 19448 | 540 | 10 | 2023-12-12 | 0.82 | 2023-11-30 | 32.60 | 2 | SO52785 | 2023-12-07 | 2.61 | 12.19 | |
SO52785_3 | 98 | 19448 | 529 | 10 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 3 | SO52785 | 2023-12-07 | 0.32 | 1.49 | |
SO52785_4 | 98 | 19448 | 471 | 10 | 2023-12-12 | 1.59 | 2023-11-30 | 63.50 | 4 | SO52785 | 2023-12-07 | 5.08 | 23.75 | |
SO52813_1 | 98 | 27815 | 529 | 10 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 1 | SO52813 | 2023-12-07 | 0.32 | 1.49 | |
SO52813_2 | 98 | 27815 | 538 | 10 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 2 | SO52813 | 2023-12-07 | 1.72 | 8.04 | |
SO52813_3 | 98 | 27815 | 222 | 10 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 3 | SO52813 | 2023-12-07 | 2.80 | 13.09 | |
SO52813_4 | 98 | 27815 | 228 | 10 | 2023-12-12 | 1.25 | 2023-11-30 | 49.99 | 4 | SO52813 | 2023-12-07 | 4.00 | 38.49 | |
SO52814_1 | 98 | 27837 | 538 | 10 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 1 | SO52814 | 2023-12-07 | 1.72 | 8.04 | |
SO52814_2 | 98 | 27837 | 529 | 10 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 2 | SO52814 | 2023-12-07 | 0.32 | 1.49 | |
SO52814_3 | 98 | 27837 | 222 | 10 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 3 | SO52814 | 2023-12-07 | 2.80 | 13.09 | |
SO52819_1 | 98 | 12503 | 538 | 10 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 1 | SO52819 | 2023-12-07 | 1.72 | 8.04 | |
SO52819_2 | 98 | 12503 | 529 | 10 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 2 | SO52819 | 2023-12-07 | 0.32 | 1.49 | |
SO52821_1 | 98 | 16593 | 530 | 10 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 1 | SO52821 | 2023-12-07 | 0.40 | 1.87 | |
SO52821_2 | 98 | 16593 | 480 | 2 | 10 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 2 | SO52821 | 2023-12-07 | 0.18 | 0.86 |
SO52837_1 | 98 | 23223 | 386 | 10 | 2023-12-12 | 28.01 | 2023-11-30 | 1120.49 | 1 | SO52837 | 2023-12-07 | 89.64 | 713.08 | |
SO52837_2 | 98 | 23223 | 217 | 10 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 2 | SO52837 | 2023-12-07 | 2.80 | 13.09 | |
SO52839_1 | 98 | 25675 | 584 | 10 | 2023-12-12 | 13.50 | 2023-11-30 | 539.99 | 1 | SO52839 | 2023-12-07 | 43.20 | 343.65 | |
SO52839_2 | 98 | 25675 | 225 | 10 | 2023-12-12 | 0.22 | 2023-11-30 | 8.99 | 2 | SO52839 | 2023-12-07 | 0.72 | 6.92 | |
SO52869_1 | 98 | 21525 | 528 | 10 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 1 | SO52869 | 2023-12-08 | 0.40 | 1.87 | |
SO52869_2 | 98 | 21525 | 535 | 10 | 2023-12-13 | 0.62 | 2023-12-01 | 24.99 | 2 | SO52869 | 2023-12-08 | 2.00 | 9.35 | |
SO52869_3 | 98 | 21525 | 480 | 2 | 10 | 2023-12-13 | 0.06 | 2023-12-01 | 2.29 | 3 | SO52869 | 2023-12-08 | 0.18 | 0.86 |
SO52871_1 | 98 | 19392 | 539 | 10 | 2023-12-13 | 0.62 | 2023-12-01 | 24.99 | 1 | SO52871 | 2023-12-08 | 2.00 | 9.35 | |
SO52871_2 | 98 | 19392 | 480 | 10 | 2023-12-13 | 0.06 | 2023-12-01 | 2.29 | 2 | SO52871 | 2023-12-08 | 0.18 | 0.86 | |
SO52872_1 | 98 | 15922 | 530 | 10 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 1 | SO52872 | 2023-12-08 | 0.40 | 1.87 | |
SO52872_2 | 98 | 15922 | 480 | 10 | 2023-12-13 | 0.06 | 2023-12-01 | 2.29 | 2 | SO52872 | 2023-12-08 | 0.18 | 0.86 | |
SO52872_3 | 98 | 15922 | 484 | 10 | 2023-12-13 | 0.20 | 2023-12-01 | 7.95 | 3 | SO52872 | 2023-12-08 | 0.64 | 2.97 | |
SO52880_1 | 98 | 22646 | 384 | 10 | 2023-12-13 | 28.01 | 2023-12-01 | 1120.49 | 1 | SO52880 | 2023-12-08 | 89.64 | 713.08 | |
SO52880_2 | 98 | 22646 | 214 | 10 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 2 | SO52880 | 2023-12-08 | 2.80 | 13.09 | |
SO52881_1 | 98 | 25615 | 605 | 10 | 2023-12-13 | 13.50 | 2023-12-01 | 539.99 | 1 | SO52881 | 2023-12-08 | 43.20 | 343.65 | |
SO52881_2 | 98 | 25615 | 214 | 10 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 2 | SO52881 | 2023-12-08 | 2.80 | 13.09 | |
SO52927_1 | 98 | 25646 | 606 | 10 | 2023-12-14 | 13.50 | 2023-12-02 | 539.99 | 1 | SO52927 | 2023-12-09 | 43.20 | 343.65 | |
SO52947_1 | 98 | 24064 | 477 | 10 | 2023-12-15 | 0.12 | 2023-12-03 | 4.99 | 1 | SO52947 | 2023-12-10 | 0.40 | 1.87 | |
SO52949_1 | 98 | 14799 | 541 | 10 | 2023-12-15 | 0.72 | 2023-12-03 | 28.99 | 1 | SO52949 | 2023-12-10 | 2.32 | 10.84 | |
SO52949_2 | 98 | 14799 | 530 | 10 | 2023-12-15 | 0.12 | 2023-12-03 | 4.99 | 2 | SO52949 | 2023-12-10 | 0.40 | 1.87 | |
SO52949_3 | 98 | 14799 | 225 | 10 | 2023-12-15 | 0.22 | 2023-12-03 | 8.99 | 3 | SO52949 | 2023-12-10 | 0.72 | 6.92 | |
SO52949_4 | 98 | 14799 | 234 | 10 | 2023-12-15 | 1.25 | 2023-12-03 | 49.99 | 4 | SO52949 | 2023-12-10 | 4.00 | 38.49 | |
SO52953_1 | 98 | 12593 | 225 | 10 | 2023-12-15 | 0.22 | 2023-12-03 | 8.99 | 1 | SO52953 | 2023-12-10 | 0.72 | 6.92 | |
SO52966_1 | 98 | 11351 | 363 | 2 | 10 | 2023-12-16 | 57.37 | 2023-12-04 | 2294.99 | 1 | SO52966 | 2023-12-11 | 183.60 | 1251.98 |
SO52967_1 | 98 | 11353 | 363 | 10 | 2023-12-16 | 57.37 | 2023-12-04 | 2294.99 | 1 | SO52967 | 2023-12-11 | 183.60 | 1251.98 | |
SO52967_2 | 98 | 11353 | 477 | 10 | 2023-12-16 | 0.12 | 2023-12-04 | 4.99 | 2 | SO52967 | 2023-12-11 | 0.40 | 1.87 | |
SO52967_3 | 98 | 11353 | 478 | 10 | 2023-12-16 | 0.25 | 2023-12-04 | 9.99 | 3 | SO52967 | 2023-12-11 | 0.80 | 3.74 | |
SO52986_1 | 98 | 17705 | 528 | 10 | 2023-12-16 | 0.12 | 2023-12-04 | 4.99 | 1 | SO52986 | 2023-12-11 | 0.40 | 1.87 | |
SO52986_2 | 98 | 17705 | 535 | 10 | 2023-12-16 | 0.62 | 2023-12-04 | 24.99 | 2 | SO52986 | 2023-12-11 | 2.00 | 9.35 | |
SO52990_1 | 98 | 20588 | 535 | 10 | 2023-12-16 | 0.62 | 2023-12-04 | 24.99 | 1 | SO52990 | 2023-12-11 | 2.00 | 9.35 | |
SO52990_2 | 98 | 20588 | 480 | 10 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 2 | SO52990 | 2023-12-11 | 0.18 | 0.86 | |
SO52992_1 | 98 | 27806 | 529 | 10 | 2023-12-16 | 0.10 | 2023-12-04 | 3.99 | 1 | SO52992 | 2023-12-11 | 0.32 | 1.49 | |
SO52993_1 | 98 | 26865 | 529 | 10 | 2023-12-16 | 0.10 | 2023-12-04 | 3.99 | 1 | SO52993 | 2023-12-11 | 0.32 | 1.49 | |
SO52993_2 | 98 | 26865 | 483 | 10 | 2023-12-16 | 3.00 | 2023-12-04 | 120.00 | 2 | SO52993 | 2023-12-11 | 9.60 | 44.88 | |
SO52994_1 | 98 | 16193 | 530 | 10 | 2023-12-16 | 0.12 | 2023-12-04 | 4.99 | 1 | SO52994 | 2023-12-11 | 0.40 | 1.87 | |
SO53005_1 | 98 | 11493 | 363 | 10 | 2023-12-17 | 57.37 | 2023-12-05 | 2294.99 | 1 | SO53005 | 2023-12-12 | 183.60 | 1251.98 | |
SO53005_2 | 98 | 11493 | 222 | 10 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 2 | SO53005 | 2023-12-12 | 2.80 | 13.09 | |
SO53037_1 | 98 | 18632 | 528 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO53037 | 2023-12-12 | 0.40 | 1.87 | |
SO53037_2 | 98 | 18632 | 535 | 10 | 2023-12-17 | 0.62 | 2023-12-05 | 24.99 | 2 | SO53037 | 2023-12-12 | 2.00 | 9.35 | |
SO53037_3 | 98 | 18632 | 480 | 2 | 10 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 3 | SO53037 | 2023-12-12 | 0.18 | 0.86 |
SO53040_1 | 98 | 28410 | 538 | 10 | 2023-12-17 | 0.54 | 2023-12-05 | 21.49 | 1 | SO53040 | 2023-12-12 | 1.72 | 8.04 | |
SO56513_2 | 98 | 17226 | 222 | 10 | 2024-02-14 | 0.87 | 2024-02-02 | 34.99 | 2 | SO56513 | 2024-02-09 | 2.80 | 13.09 | |
SO56516_1 | 98 | 21135 | 528 | 10 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 1 | SO56516 | 2024-02-09 | 0.40 | 1.87 | |
SO56516_2 | 98 | 21135 | 536 | 10 | 2024-02-14 | 0.75 | 2024-02-02 | 29.99 | 2 | SO56516 | 2024-02-09 | 2.40 | 11.22 | |
SO56516_3 | 98 | 21135 | 478 | 10 | 2024-02-14 | 0.25 | 2024-02-02 | 9.99 | 3 | SO56516 | 2024-02-09 | 0.80 | 3.74 |
Generated 2024-11-11 04:55:03.924 UTC