[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 < SKIP 874 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46881_1 | 6 | 12572 | 354 | 9 | 2022-09-25 | 51.79 | 2022-09-13 | 2071.42 | 1 | SO46881 | 2022-09-20 | 165.71 | 1117.86 | |
SO56537_1 | 100 | 22760 | 605 | 1 | 2023-12-23 | 13.50 | 2023-12-11 | 539.99 | 1 | SO56537 | 2023-12-18 | 43.20 | 343.65 | |
SO46882_1 | 6 | 25960 | 343 | 9 | 2022-09-25 | 19.57 | 2022-09-13 | 782.99 | 1 | SO46882 | 2022-09-20 | 62.64 | 486.71 | |
SO56537_2 | 100 | 22760 | 479 | 1 | 2023-12-23 | 0.22 | 2023-12-11 | 8.99 | 2 | SO56537 | 2023-12-18 | 0.72 | 3.36 | |
SO46883_1 | 100 | 26241 | 352 | 4 | 2022-09-25 | 51.79 | 2022-09-13 | 2071.42 | 1 | SO46883 | 2022-09-20 | 165.71 | 1117.86 | |
SO56538_1 | 100 | 21671 | 605 | 7 | 2023-12-23 | 13.50 | 2023-12-11 | 539.99 | 1 | SO56538 | 2023-12-18 | 43.20 | 343.65 | |
SO46884_1 | 100 | 13565 | 368 | 7 | 2022-09-26 | 61.08 | 2022-09-14 | 2443.35 | 1 | SO46884 | 2022-09-21 | 195.47 | 1518.79 | |
SO56538_2 | 100 | 21671 | 529 | 7 | 2023-12-23 | 0.10 | 2023-12-11 | 3.99 | 2 | SO56538 | 2023-12-18 | 0.32 | 1.49 | |
SO46885_1 | 98 | 15933 | 373 | 10 | 2022-09-26 | 54.54 | 2022-09-14 | 2181.56 | 1 | SO46885 | 2022-09-21 | 174.53 | 1320.68 | |
SO56538_3 | 100 | 21671 | 472 | 7 | 2023-12-23 | 1.59 | 2023-12-11 | 63.50 | 3 | SO56538 | 2023-12-18 | 5.08 | 23.75 | |
SO46886_1 | 100 | 28669 | 377 | 6 | 2022-09-26 | 54.54 | 2022-09-14 | 2181.56 | 1 | SO46886 | 2022-09-21 | 174.53 | 1320.68 | |
SO56538_4 | 100 | 21671 | 538 | 7 | 2023-12-23 | 0.54 | 2023-12-11 | 21.49 | 4 | SO56538 | 2023-12-18 | 1.72 | 8.04 | |
SO46887_1 | 6 | 12340 | 362 | 2 | 9 | 2022-09-26 | 51.23 | 2022-09-14 | 2049.10 | 1 | SO46887 | 2022-09-21 | 163.93 | 1105.81 |
SO56539_1 | 100 | 15684 | 561 | 8 | 2023-12-23 | 59.60 | 2023-12-11 | 2384.07 | 1 | SO56539 | 2023-12-18 | 190.73 | 1481.94 | |
SO46888_1 | 6 | 26021 | 325 | 9 | 2022-09-26 | 19.57 | 2022-09-14 | 782.99 | 1 | SO46888 | 2022-09-21 | 62.64 | 486.71 | |
SO56539_2 | 100 | 15684 | 541 | 8 | 2023-12-23 | 0.72 | 2023-12-11 | 28.99 | 2 | SO56539 | 2023-12-18 | 2.32 | 10.84 | |
SO46889_1 | 98 | 19173 | 383 | 10 | 2022-09-27 | 25.01 | 2022-09-15 | 1000.44 | 1 | SO46889 | 2022-09-22 | 80.04 | 605.65 | |
SO56539_3 | 100 | 15684 | 530 | 8 | 2023-12-23 | 0.12 | 2023-12-11 | 4.99 | 3 | SO56539 | 2023-12-18 | 0.40 | 1.87 | |
SO46890_1 | 100 | 12921 | 368 | 4 | 2022-09-27 | 61.08 | 2022-09-15 | 2443.35 | 1 | SO46890 | 2022-09-22 | 195.47 | 1518.79 | |
SO56539_4 | 100 | 15684 | 467 | 8 | 2023-12-23 | 0.61 | 2023-12-11 | 24.49 | 4 | SO56539 | 2023-12-18 | 1.96 | 9.16 | |
SO46891_1 | 98 | 20592 | 325 | 10 | 2022-09-27 | 19.57 | 2022-09-15 | 782.99 | 1 | SO46891 | 2022-09-22 | 62.64 | 486.71 | |
SO56540_1 | 98 | 12222 | 357 | 10 | 2023-12-24 | 58.00 | 2023-12-12 | 2319.99 | 1 | SO56540 | 2023-12-19 | 185.60 | 1265.62 | |
SO46892_1 | 100 | 13086 | 370 | 1 | 2022-09-27 | 61.08 | 2022-09-15 | 2443.35 | 1 | SO46892 | 2022-09-22 | 195.47 | 1518.79 | |
SO56540_2 | 98 | 12222 | 485 | 10 | 2023-12-24 | 0.55 | 2023-12-12 | 21.98 | 2 | SO56540 | 2023-12-19 | 1.76 | 8.22 | |
SO46893_1 | 100 | 28659 | 369 | 2 | 6 | 2022-09-27 | 61.08 | 2022-09-15 | 2443.35 | 1 | SO46893 | 2022-09-22 | 195.47 | 1518.79 |
SO56540_3 | 98 | 12222 | 487 | 10 | 2023-12-24 | 1.37 | 2023-12-12 | 54.99 | 3 | SO56540 | 2023-12-19 | 4.40 | 20.57 | |
SO46894_1 | 100 | 26120 | 356 | 4 | 2022-09-27 | 51.79 | 2022-09-15 | 2071.42 | 1 | SO46894 | 2022-09-22 | 165.71 | 1117.86 | |
SO56540_4 | 98 | 12222 | 214 | 10 | 2023-12-24 | 0.87 | 2023-12-12 | 34.99 | 4 | SO56540 | 2023-12-19 | 2.80 | 13.09 | |
SO46895_1 | 100 | 26183 | 354 | 4 | 2022-09-27 | 51.79 | 2022-09-15 | 2071.42 | 1 | SO46895 | 2022-09-22 | 165.71 | 1117.86 | |
SO56541_1 | 6 | 14071 | 577 | 2 | 9 | 2023-12-24 | 30.37 | 2023-12-12 | 1214.85 | 1 | SO56541 | 2023-12-19 | 97.19 | 755.15 |
SO46896_1 | 100 | 15189 | 333 | 1 | 2022-09-27 | 19.57 | 2022-09-15 | 782.99 | 1 | SO46896 | 2022-09-22 | 62.64 | 486.71 | |
SO56541_2 | 6 | 14071 | 541 | 9 | 2023-12-24 | 0.72 | 2023-12-12 | 28.99 | 2 | SO56541 | 2023-12-19 | 2.32 | 10.84 | |
SO46897_1 | 6 | 21179 | 368 | 9 | 2022-09-27 | 61.08 | 2022-09-15 | 2443.35 | 1 | SO46897 | 2022-09-22 | 195.47 | 1518.79 | |
SO56541_3 | 6 | 14071 | 530 | 9 | 2023-12-24 | 0.12 | 2023-12-12 | 4.99 | 3 | SO56541 | 2023-12-19 | 0.40 | 1.87 | |
SO46898_1 | 6 | 21205 | 369 | 2 | 9 | 2022-09-27 | 61.08 | 2022-09-15 | 2443.35 | 1 | SO46898 | 2022-09-22 | 195.47 | 1518.79 |
SO56542_1 | 100 | 13556 | 361 | 7 | 2023-12-24 | 57.37 | 2023-12-12 | 2294.99 | 1 | SO56542 | 2023-12-19 | 183.60 | 1251.98 | |
SO46899_1 | 100 | 13999 | 381 | 4 | 2022-09-28 | 25.01 | 2022-09-16 | 1000.44 | 1 | SO46899 | 2022-09-23 | 80.04 | 605.65 | |
SO56542_2 | 100 | 13556 | 217 | 7 | 2023-12-24 | 0.87 | 2023-12-12 | 34.99 | 2 | SO56542 | 2023-12-19 | 2.80 | 13.09 | |
SO46900_1 | 6 | 21194 | 375 | 9 | 2022-09-28 | 54.54 | 2022-09-16 | 2181.56 | 1 | SO46900 | 2022-09-23 | 174.53 | 1320.68 | |
SO56543_1 | 100 | 11785 | 217 | 1 | 2023-12-24 | 0.87 | 2023-12-12 | 34.99 | 1 | SO56543 | 2023-12-19 | 2.80 | 13.09 | |
SO46901_1 | 6 | 21203 | 375 | 9 | 2022-09-28 | 54.54 | 2022-09-16 | 2181.56 | 1 | SO46901 | 2022-09-23 | 174.53 | 1320.68 | |
SO56544_1 | 6 | 18295 | 485 | 9 | 2023-12-24 | 0.55 | 2023-12-12 | 21.98 | 1 | SO56544 | 2023-12-19 | 1.76 | 8.22 | |
SO56544_2 | 6 | 18295 | 483 | 9 | 2023-12-24 | 3.00 | 2023-12-12 | 120.00 | 2 | SO56544 | 2023-12-19 | 9.60 | 44.88 | |
SO56545_1 | 6 | 21953 | 537 | 9 | 2023-12-24 | 0.88 | 2023-12-12 | 35.00 | 1 | SO56545 | 2023-12-19 | 2.80 | 13.09 | |
SO56546_1 | 6 | 17244 | 491 | 9 | 2023-12-24 | 1.35 | 2023-12-12 | 53.99 | 1 | SO56546 | 2023-12-19 | 4.32 | 41.57 | |
SO56547_1 | 6 | 11113 | 484 | 9 | 2023-12-24 | 0.20 | 2023-12-12 | 7.95 | 1 | SO56547 | 2023-12-19 | 0.64 | 2.97 | |
SO56548_1 | 6 | 18195 | 225 | 9 | 2023-12-24 | 0.22 | 2023-12-12 | 8.99 | 1 | SO56548 | 2023-12-19 | 0.72 | 6.92 | |
SO56549_1 | 6 | 18304 | 480 | 9 | 2023-12-24 | 0.06 | 2023-12-12 | 2.29 | 1 | SO56549 | 2023-12-19 | 0.18 | 0.86 | |
SO56550_1 | 6 | 17484 | 487 | 9 | 2023-12-24 | 1.37 | 2023-12-12 | 54.99 | 1 | SO56550 | 2023-12-19 | 4.40 | 20.57 | |
SO56550_2 | 6 | 17484 | 234 | 9 | 2023-12-24 | 1.25 | 2023-12-12 | 49.99 | 2 | SO56550 | 2023-12-19 | 4.00 | 38.49 | |
SO56551_1 | 6 | 16625 | 540 | 9 | 2023-12-24 | 0.82 | 2023-12-12 | 32.60 | 1 | SO56551 | 2023-12-19 | 2.61 | 12.19 | |
SO56551_2 | 6 | 16625 | 529 | 9 | 2023-12-24 | 0.10 | 2023-12-12 | 3.99 | 2 | SO56551 | 2023-12-19 | 0.32 | 1.49 | |
SO56552_1 | 100 | 22621 | 600 | 8 | 2023-12-24 | 13.50 | 2023-12-12 | 539.99 | 1 | SO56552 | 2023-12-19 | 43.20 | 294.58 | |
SO56552_2 | 100 | 22621 | 478 | 8 | 2023-12-24 | 0.25 | 2023-12-12 | 9.99 | 2 | SO56552 | 2023-12-19 | 0.80 | 3.74 | |
SO46902_1 | 6 | 21000 | 375 | 9 | 2022-09-28 | 54.54 | 2022-09-16 | 2181.56 | 1 | SO46902 | 2022-09-23 | 174.53 | 1320.68 | |
SO46903_1 | 6 | 12353 | 354 | 9 | 2022-09-28 | 51.79 | 2022-09-16 | 2071.42 | 1 | SO46903 | 2022-09-23 | 165.71 | 1117.86 | |
SO46904_1 | 100 | 17080 | 387 | 7 | 2022-09-29 | 25.01 | 2022-09-17 | 1000.44 | 1 | SO46904 | 2022-09-24 | 80.04 | 605.65 | |
SO46905_1 | 98 | 16053 | 375 | 10 | 2022-09-29 | 54.54 | 2022-09-17 | 2181.56 | 1 | SO46905 | 2022-09-24 | 174.53 | 1320.68 | |
SO46906_1 | 100 | 12950 | 368 | 1 | 2022-09-29 | 61.08 | 2022-09-17 | 2443.35 | 1 | SO46906 | 2022-09-24 | 195.47 | 1518.79 | |
SO46907_1 | 100 | 13087 | 368 | 1 | 2022-09-29 | 61.08 | 2022-09-17 | 2443.35 | 1 | SO46907 | 2022-09-24 | 195.47 | 1518.79 | |
SO46908_1 | 6 | 21189 | 370 | 9 | 2022-09-29 | 61.08 | 2022-09-17 | 2443.35 | 1 | SO46908 | 2022-09-24 | 195.47 | 1518.79 | |
SO46909_1 | 6 | 20998 | 379 | 9 | 2022-09-29 | 54.54 | 2022-09-17 | 2181.56 | 1 | SO46909 | 2022-09-24 | 174.53 | 1320.68 |
Generated 2024-09-20 00:45:43.003 UTC