[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1222 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46485_1 | 100 | 12755 | 313 | 4 | 2022-10-07 | 89.46 | 2022-09-25 | 3578.27 | 1 | SO46485 | 2022-10-02 | 286.26 | 2171.29 | |
SO56370_2 | 100 | 26486 | 479 | 4 | 2024-02-10 | 0.22 | 2024-01-29 | 8.99 | 2 | SO56370 | 2024-02-05 | 0.72 | 3.36 | |
SO46487_1 | 100 | 14913 | 338 | 4 | 2022-10-07 | 17.48 | 2022-09-25 | 699.10 | 1 | SO46487 | 2022-10-02 | 55.93 | 413.15 | |
SO56379_1 | 100 | 28597 | 484 | 4 | 2024-02-11 | 0.20 | 2024-01-30 | 7.95 | 1 | SO56379 | 2024-02-06 | 0.64 | 2.97 | |
SO46490_1 | 100 | 12189 | 313 | 4 | 2022-10-08 | 89.46 | 2022-09-26 | 3578.27 | 1 | SO46490 | 2022-10-03 | 286.26 | 2171.29 | |
SO56389_1 | 100 | 29206 | 539 | 4 | 2024-02-11 | 0.62 | 2024-01-30 | 24.99 | 1 | SO56389 | 2024-02-06 | 2.00 | 9.35 | |
SO46498_1 | 100 | 12881 | 313 | 4 | 2022-10-10 | 89.46 | 2022-09-28 | 3578.27 | 1 | SO46498 | 2022-10-05 | 286.26 | 2171.29 | |
SO56389_2 | 100 | 29206 | 529 | 4 | 2024-02-11 | 0.10 | 2024-01-30 | 3.99 | 2 | SO56389 | 2024-02-06 | 0.32 | 1.49 | |
SO46504_1 | 100 | 15005 | 342 | 4 | 2022-10-10 | 17.48 | 2022-09-28 | 699.10 | 1 | SO46504 | 2022-10-05 | 55.93 | 413.15 | |
SO56389_3 | 100 | 29206 | 483 | 4 | 2024-02-11 | 3.00 | 2024-01-30 | 120.00 | 3 | SO56389 | 2024-02-06 | 9.60 | 44.88 | |
SO46509_1 | 100 | 12886 | 310 | 4 | 2022-10-11 | 89.46 | 2022-09-29 | 3578.27 | 1 | SO46509 | 2022-10-06 | 286.26 | 2171.29 | |
SO56393_1 | 100 | 25441 | 529 | 4 | 2024-02-11 | 0.10 | 2024-01-30 | 3.99 | 1 | SO56393 | 2024-02-06 | 0.32 | 1.49 | |
SO46512_1 | 100 | 12209 | 311 | 4 | 2022-10-11 | 89.46 | 2022-09-29 | 3578.27 | 1 | SO46512 | 2022-10-06 | 286.26 | 2171.29 | |
SO56393_2 | 100 | 25441 | 540 | 4 | 2024-02-11 | 0.82 | 2024-01-30 | 32.60 | 2 | SO56393 | 2024-02-06 | 2.61 | 12.19 | |
SO46521_1 | 100 | 12770 | 310 | 4 | 2022-10-12 | 89.46 | 2022-09-30 | 3578.27 | 1 | SO46521 | 2022-10-07 | 286.26 | 2171.29 | |
SO56393_3 | 100 | 25441 | 222 | 4 | 2024-02-11 | 0.87 | 2024-01-30 | 34.99 | 3 | SO56393 | 2024-02-06 | 2.80 | 13.09 | |
SO46522_1 | 100 | 12882 | 312 | 4 | 2022-10-12 | 89.46 | 2022-09-30 | 3578.27 | 1 | SO46522 | 2022-10-07 | 286.26 | 2171.29 | |
SO56394_1 | 100 | 24398 | 540 | 4 | 2024-02-11 | 0.82 | 2024-01-30 | 32.60 | 1 | SO56394 | 2024-02-06 | 2.61 | 12.19 | |
SO46523_1 | 100 | 12756 | 313 | 4 | 2022-10-12 | 89.46 | 2022-09-30 | 3578.27 | 1 | SO46523 | 2022-10-07 | 286.26 | 2171.29 | |
SO56394_2 | 100 | 24398 | 480 | 4 | 2024-02-11 | 0.06 | 2024-01-30 | 2.29 | 2 | SO56394 | 2024-02-06 | 0.18 | 0.86 | |
SO46524_1 | 100 | 26111 | 351 | 4 | 2022-10-12 | 84.37 | 2022-09-30 | 3374.99 | 1 | SO46524 | 2022-10-07 | 270.00 | 1898.09 | |
SO56394_3 | 100 | 24398 | 484 | 4 | 2024-02-11 | 0.20 | 2024-01-30 | 7.95 | 3 | SO56394 | 2024-02-06 | 0.64 | 2.97 | |
SO46533_1 | 100 | 26106 | 348 | 4 | 2022-10-13 | 84.37 | 2022-10-01 | 3374.99 | 1 | SO46533 | 2022-10-08 | 270.00 | 1898.09 | |
SO56398_1 | 100 | 22108 | 536 | 4 | 2024-02-11 | 0.75 | 2024-01-30 | 29.99 | 1 | SO56398 | 2024-02-06 | 2.40 | 11.22 | |
SO46538_1 | 100 | 12774 | 310 | 4 | 2022-10-14 | 89.46 | 2022-10-02 | 3578.27 | 1 | SO46538 | 2022-10-09 | 286.26 | 2171.29 | |
SO56398_2 | 100 | 22108 | 477 | 4 | 2024-02-11 | 0.12 | 2024-01-30 | 4.99 | 2 | SO56398 | 2024-02-06 | 0.40 | 1.87 | |
SO46539_1 | 100 | 12200 | 314 | 4 | 2022-10-14 | 89.46 | 2022-10-02 | 3578.27 | 1 | SO46539 | 2022-10-09 | 286.26 | 2171.29 | |
SO56398_3 | 100 | 22108 | 228 | 4 | 2024-02-11 | 1.25 | 2024-01-30 | 49.99 | 3 | SO56398 | 2024-02-06 | 4.00 | 38.49 | |
SO46550_1 | 100 | 26097 | 350 | 4 | 2022-10-15 | 84.37 | 2022-10-03 | 3374.99 | 1 | SO46550 | 2022-10-10 | 270.00 | 1898.09 | |
SO56400_1 | 100 | 17605 | 477 | 4 | 2024-02-11 | 0.12 | 2024-01-30 | 4.99 | 1 | SO56400 | 2024-02-06 | 0.40 | 1.87 | |
SO46551_1 | 100 | 14914 | 330 | 4 | 2022-10-15 | 17.48 | 2022-10-03 | 699.10 | 1 | SO46551 | 2022-10-10 | 55.93 | 413.15 | |
SO56400_2 | 100 | 17605 | 222 | 4 | 2024-02-11 | 0.87 | 2024-01-30 | 34.99 | 2 | SO56400 | 2024-02-06 | 2.80 | 13.09 | |
SO46552_1 | 100 | 15017 | 328 | 4 | 2022-10-15 | 17.48 | 2022-10-03 | 699.10 | 1 | SO46552 | 2022-10-10 | 55.93 | 413.15 | |
SO56416_1 | 100 | 12046 | 537 | 4 | 2024-02-11 | 0.88 | 2024-01-30 | 35.00 | 1 | SO56416 | 2024-02-06 | 2.80 | 13.09 | |
SO46557_1 | 100 | 12904 | 310 | 4 | 2022-10-16 | 89.46 | 2022-10-04 | 3578.27 | 1 | SO46557 | 2022-10-11 | 286.26 | 2171.29 | |
SO56417_1 | 100 | 12194 | 537 | 4 | 2024-02-11 | 0.88 | 2024-01-30 | 35.00 | 1 | SO56417 | 2024-02-06 | 2.80 | 13.09 | |
SO46559_1 | 100 | 12762 | 310 | 4 | 2022-10-16 | 89.46 | 2022-10-04 | 3578.27 | 1 | SO46559 | 2022-10-11 | 286.26 | 2171.29 | |
SO56417_2 | 100 | 12194 | 528 | 4 | 2024-02-11 | 0.12 | 2024-01-30 | 4.99 | 2 | SO56417 | 2024-02-06 | 0.40 | 1.87 | |
SO46560_1 | 100 | 26096 | 344 | 4 | 2022-10-16 | 85.00 | 2022-10-04 | 3399.99 | 1 | SO46560 | 2022-10-11 | 272.00 | 1912.15 | |
SO56417_3 | 100 | 12194 | 214 | 4 | 2024-02-11 | 0.87 | 2024-01-30 | 34.99 | 3 | SO56417 | 2024-02-06 | 2.80 | 13.09 | |
SO46566_1 | 100 | 12789 | 311 | 4 | 2022-10-17 | 89.46 | 2022-10-05 | 3578.27 | 1 | SO46566 | 2022-10-12 | 286.26 | 2171.29 | |
SO56421_1 | 100 | 16362 | 380 | 4 | 2024-02-11 | 61.08 | 2024-01-30 | 2443.35 | 1 | SO56421 | 2024-02-06 | 195.47 | 1554.95 | |
SO46569_1 | 100 | 12450 | 312 | 4 | 2022-10-18 | 89.46 | 2022-10-06 | 3578.27 | 1 | SO46569 | 2022-10-13 | 286.26 | 2171.29 | |
SO56421_2 | 100 | 16362 | 540 | 4 | 2024-02-11 | 0.82 | 2024-01-30 | 32.60 | 2 | SO56421 | 2024-02-06 | 2.61 | 12.19 | |
SO46579_1 | 100 | 12186 | 311 | 4 | 2022-10-19 | 89.46 | 2022-10-07 | 3578.27 | 1 | SO46579 | 2022-10-14 | 286.26 | 2171.29 | |
SO56421_3 | 100 | 16362 | 529 | 4 | 2024-02-11 | 0.10 | 2024-01-30 | 3.99 | 3 | SO56421 | 2024-02-06 | 0.32 | 1.49 | |
SO46580_1 | 100 | 12187 | 310 | 4 | 2022-10-19 | 89.46 | 2022-10-07 | 3578.27 | 1 | SO46580 | 2022-10-14 | 286.26 | 2171.29 | |
SO56421_4 | 100 | 16362 | 480 | 4 | 2024-02-11 | 0.06 | 2024-01-30 | 2.29 | 4 | SO56421 | 2024-02-06 | 0.18 | 0.86 | |
SO46581_1 | 100 | 12188 | 314 | 4 | 2022-10-19 | 89.46 | 2022-10-07 | 3578.27 | 1 | SO46581 | 2022-10-14 | 286.26 | 2171.29 | |
SO56422_1 | 100 | 11629 | 359 | 4 | 2024-02-11 | 57.37 | 2024-01-30 | 2294.99 | 1 | SO56422 | 2024-02-06 | 183.60 | 1251.98 | |
SO46599_1 | 100 | 12206 | 310 | 4 | 2022-10-22 | 89.46 | 2022-10-10 | 3578.27 | 1 | SO46599 | 2022-10-17 | 286.26 | 2171.29 | |
SO56422_2 | 100 | 11629 | 485 | 4 | 2024-02-11 | 0.55 | 2024-01-30 | 21.98 | 2 | SO56422 | 2024-02-06 | 1.76 | 8.22 | |
SO46601_1 | 100 | 26098 | 345 | 4 | 2022-10-22 | 85.00 | 2022-10-10 | 3399.99 | 1 | SO46601 | 2022-10-17 | 272.00 | 1912.15 | |
SO56422_3 | 100 | 11629 | 214 | 4 | 2024-02-11 | 0.87 | 2024-01-30 | 34.99 | 3 | SO56422 | 2024-02-06 | 2.80 | 13.09 | |
SO46685_1 | 100 | 12947 | 377 | 4 | 2022-10-24 | 54.54 | 2022-10-12 | 2181.56 | 1 | SO46685 | 2022-10-19 | 174.53 | 1320.68 | |
SO56423_1 | 100 | 11135 | 355 | 4 | 2024-02-11 | 58.00 | 2024-01-30 | 2319.99 | 1 | SO56423 | 2024-02-06 | 185.60 | 1265.62 | |
SO46689_1 | 100 | 13032 | 369 | 2 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46689 | 2022-10-20 | 195.47 | 1518.79 |
SO56423_2 | 100 | 11135 | 478 | 4 | 2024-02-11 | 0.25 | 2024-01-30 | 9.99 | 2 | SO56423 | 2024-02-06 | 0.80 | 3.74 | |
SO46690_1 | 100 | 13039 | 368 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46690 | 2022-10-20 | 195.47 | 1518.79 | |
SO56423_3 | 100 | 11135 | 477 | 4 | 2024-02-11 | 0.12 | 2024-01-30 | 4.99 | 3 | SO56423 | 2024-02-06 | 0.40 | 1.87 | |
SO46691_1 | 100 | 13142 | 368 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46691 | 2022-10-20 | 195.47 | 1518.79 | |
SO56426_1 | 100 | 22876 | 604 | 4 | 2024-02-11 | 13.50 | 2024-01-30 | 539.99 | 1 | SO56426 | 2024-02-06 | 43.20 | 343.65 | |
SO46692_1 | 100 | 13208 | 369 | 2 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46692 | 2022-10-20 | 195.47 | 1518.79 |
SO56426_2 | 100 | 22876 | 217 | 4 | 2024-02-11 | 0.87 | 2024-01-30 | 34.99 | 2 | SO56426 | 2024-02-06 | 2.80 | 13.09 | |
SO46693_1 | 100 | 13210 | 373 | 4 | 2022-10-25 | 54.54 | 2022-10-13 | 2181.56 | 1 | SO46693 | 2022-10-20 | 174.53 | 1320.68 | |
SO56447_1 | 100 | 29107 | 529 | 4 | 2024-02-12 | 0.10 | 2024-01-31 | 3.99 | 1 | SO56447 | 2024-02-07 | 0.32 | 1.49 | |
SO46694_1 | 100 | 13220 | 373 | 4 | 2022-10-25 | 54.54 | 2022-10-13 | 2181.56 | 1 | SO46694 | 2022-10-20 | 174.53 | 1320.68 | |
SO56447_2 | 100 | 29107 | 486 | 4 | 2024-02-12 | 3.98 | 2024-01-31 | 159.00 | 2 | SO56447 | 2024-02-07 | 12.72 | 59.47 | |
SO46704_1 | 100 | 13059 | 370 | 4 | 2022-10-26 | 61.08 | 2022-10-14 | 2443.35 | 1 | SO46704 | 2022-10-21 | 195.47 | 1518.79 | |
SO56452_1 | 100 | 21261 | 478 | 4 | 2024-02-12 | 0.25 | 2024-01-31 | 9.99 | 1 | SO56452 | 2024-02-07 | 0.80 | 3.74 | |
SO46707_1 | 100 | 15199 | 337 | 4 | 2022-10-26 | 19.57 | 2022-10-14 | 782.99 | 1 | SO46707 | 2022-10-21 | 62.64 | 486.71 | |
SO56452_2 | 100 | 21261 | 477 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 2 | SO56452 | 2024-02-07 | 0.40 | 1.87 | |
SO46723_1 | 100 | 12918 | 368 | 4 | 2022-10-28 | 61.08 | 2022-10-16 | 2443.35 | 1 | SO46723 | 2022-10-23 | 195.47 | 1518.79 | |
SO56452_3 | 100 | 21261 | 487 | 4 | 2024-02-12 | 1.37 | 2024-01-31 | 54.99 | 3 | SO56452 | 2024-02-07 | 4.40 | 20.57 | |
SO46732_1 | 100 | 13992 | 385 | 4 | 2022-10-29 | 25.01 | 2022-10-17 | 1000.44 | 1 | SO46732 | 2022-10-24 | 80.04 | 605.65 | |
SO56453_1 | 100 | 20353 | 475 | 4 | 2024-02-12 | 1.75 | 2024-01-31 | 69.99 | 1 | SO56453 | 2024-02-07 | 5.60 | 26.18 | |
SO46734_1 | 100 | 13060 | 375 | 4 | 2022-10-29 | 54.54 | 2022-10-17 | 2181.56 | 1 | SO46734 | 2022-10-24 | 174.53 | 1320.68 | |
SO56453_2 | 100 | 20353 | 481 | 4 | 2024-02-12 | 0.22 | 2024-01-31 | 8.99 | 2 | SO56453 | 2024-02-07 | 0.72 | 3.36 | |
SO46746_1 | 100 | 13057 | 368 | 4 | 2022-10-31 | 61.08 | 2022-10-19 | 2443.35 | 1 | SO46746 | 2022-10-26 | 195.47 | 1518.79 | |
SO56455_1 | 100 | 19019 | 476 | 4 | 2024-02-12 | 1.75 | 2024-01-31 | 69.99 | 1 | SO56455 | 2024-02-07 | 5.60 | 26.18 | |
SO46748_1 | 100 | 26252 | 360 | 4 | 2022-10-31 | 51.23 | 2022-10-19 | 2049.10 | 1 | SO46748 | 2022-10-26 | 163.93 | 1105.81 | |
SO56455_2 | 100 | 19019 | 482 | 4 | 2024-02-12 | 0.22 | 2024-01-31 | 8.99 | 2 | SO56455 | 2024-02-07 | 0.72 | 3.36 | |
SO46751_1 | 100 | 12934 | 377 | 4 | 2022-11-01 | 54.54 | 2022-10-20 | 2181.56 | 1 | SO46751 | 2022-10-27 | 174.53 | 1320.68 | |
SO56456_1 | 100 | 17694 | 477 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 1 | SO56456 | 2024-02-07 | 0.40 | 1.87 | |
SO46756_1 | 100 | 13993 | 383 | 4 | 2022-11-01 | 25.01 | 2022-10-20 | 1000.44 | 1 | SO46756 | 2022-10-27 | 80.04 | 605.65 | |
SO56458_1 | 100 | 14920 | 528 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 1 | SO56458 | 2024-02-07 | 0.40 | 1.87 | |
SO46760_1 | 100 | 13986 | 387 | 4 | 2022-11-02 | 25.01 | 2022-10-21 | 1000.44 | 1 | SO46760 | 2022-10-28 | 80.04 | 605.65 | |
SO56469_1 | 100 | 13309 | 485 | 4 | 2024-02-12 | 0.55 | 2024-01-31 | 21.98 | 1 | SO56469 | 2024-02-07 | 1.76 | 8.22 | |
SO46763_1 | 100 | 13202 | 375 | 4 | 2022-11-02 | 54.54 | 2022-10-21 | 2181.56 | 1 | SO46763 | 2022-10-28 | 174.53 | 1320.68 | |
SO56470_1 | 100 | 20671 | 580 | 4 | 2024-02-12 | 42.52 | 2024-01-31 | 1700.99 | 1 | SO56470 | 2024-02-07 | 136.08 | 1082.51 | |
SO46764_1 | 100 | 26238 | 360 | 4 | 2022-11-02 | 51.23 | 2022-10-21 | 2049.10 | 1 | SO46764 | 2022-10-28 | 163.93 | 1105.81 | |
SO56470_2 | 100 | 20671 | 222 | 4 | 2024-02-12 | 0.87 | 2024-01-31 | 34.99 | 2 | SO56470 | 2024-02-07 | 2.80 | 13.09 | |
SO46765_1 | 100 | 15191 | 333 | 4 | 2022-11-02 | 19.57 | 2022-10-21 | 782.99 | 1 | SO46765 | 2022-10-28 | 62.64 | 486.71 | |
SO56477_1 | 100 | 22768 | 606 | 2 | 4 | 2024-02-12 | 13.50 | 2024-01-31 | 539.99 | 1 | SO56477 | 2024-02-07 | 43.20 | 343.65 |
SO46771_1 | 100 | 13068 | 377 | 4 | 2022-11-03 | 54.54 | 2022-10-22 | 2181.56 | 1 | SO46771 | 2022-10-29 | 174.53 | 1320.68 | |
SO56477_2 | 100 | 22768 | 529 | 4 | 2024-02-12 | 0.10 | 2024-01-31 | 3.99 | 2 | SO56477 | 2024-02-07 | 0.32 | 1.49 | |
SO46774_1 | 100 | 13225 | 375 | 4 | 2022-11-03 | 54.54 | 2022-10-22 | 2181.56 | 1 | SO46774 | 2022-10-29 | 174.53 | 1320.68 | |
SO56477_3 | 100 | 22768 | 538 | 4 | 2024-02-12 | 0.54 | 2024-01-31 | 21.49 | 3 | SO56477 | 2024-02-07 | 1.72 | 8.04 | |
SO46780_1 | 100 | 12942 | 379 | 4 | 2022-11-04 | 54.54 | 2022-10-23 | 2181.56 | 1 | SO46780 | 2022-10-30 | 174.53 | 1320.68 | |
SO56477_4 | 100 | 22768 | 217 | 4 | 2024-02-12 | 0.87 | 2024-01-31 | 34.99 | 4 | SO56477 | 2024-02-07 | 2.80 | 13.09 | |
SO46782_1 | 100 | 12975 | 371 | 4 | 2022-11-04 | 54.54 | 2022-10-23 | 2181.56 | 1 | SO46782 | 2022-10-30 | 174.53 | 1320.68 | |
SO56478_1 | 100 | 19820 | 390 | 4 | 2024-02-12 | 28.01 | 2024-01-31 | 1120.49 | 1 | SO56478 | 2024-02-07 | 89.64 | 713.08 | |
SO46785_1 | 100 | 13190 | 373 | 4 | 2022-11-04 | 54.54 | 2022-10-23 | 2181.56 | 1 | SO46785 | 2022-10-30 | 174.53 | 1320.68 | |
SO56478_2 | 100 | 19820 | 217 | 4 | 2024-02-12 | 0.87 | 2024-01-31 | 34.99 | 2 | SO56478 | 2024-02-07 | 2.80 | 13.09 | |
SO46786_1 | 100 | 26201 | 354 | 4 | 2022-11-04 | 51.79 | 2022-10-23 | 2071.42 | 1 | SO46786 | 2022-10-30 | 165.71 | 1117.86 | |
SO56501_1 | 100 | 26044 | 535 | 4 | 2024-02-13 | 0.62 | 2024-02-01 | 24.99 | 1 | SO56501 | 2024-02-08 | 2.00 | 9.35 | |
SO46787_1 | 100 | 15195 | 333 | 4 | 2022-11-04 | 19.57 | 2022-10-23 | 782.99 | 1 | SO46787 | 2022-10-30 | 62.64 | 486.71 | |
SO56501_2 | 100 | 26044 | 528 | 4 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 2 | SO56501 | 2024-02-08 | 0.40 | 1.87 | |
SO46795_1 | 100 | 26234 | 362 | 2 | 4 | 2022-11-05 | 51.23 | 2022-10-24 | 2049.10 | 1 | SO46795 | 2022-10-31 | 163.93 | 1105.81 |
SO56501_3 | 100 | 26044 | 485 | 4 | 2024-02-13 | 0.55 | 2024-02-01 | 21.98 | 3 | SO56501 | 2024-02-08 | 1.76 | 8.22 | |
SO46796_1 | 100 | 26247 | 360 | 4 | 2022-11-05 | 51.23 | 2022-10-24 | 2049.10 | 1 | SO46796 | 2022-10-31 | 163.93 | 1105.81 | |
SO56501_4 | 100 | 26044 | 222 | 4 | 2024-02-13 | 0.87 | 2024-02-01 | 34.99 | 4 | SO56501 | 2024-02-08 | 2.80 | 13.09 |
Generated 2024-11-10 16:54:07.010 UTC