[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1622 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69711_1 | 100 | 23739 | 606 | 4 | 2024-08-24 | 13.50 | 2024-08-12 | 539.99 | 1 | SO69711 | 2024-08-19 | 43.20 | 343.65 | |
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 | |
SO69711_2 | 100 | 23739 | 529 | 4 | 2024-08-24 | 0.10 | 2024-08-12 | 3.99 | 2 | SO69711 | 2024-08-19 | 0.32 | 1.49 | |
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 | |
SO69711_3 | 100 | 23739 | 538 | 4 | 2024-08-24 | 0.54 | 2024-08-12 | 21.49 | 3 | SO69711 | 2024-08-19 | 1.72 | 8.04 | |
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 | |
SO69711_4 | 100 | 23739 | 484 | 4 | 2024-08-24 | 0.20 | 2024-08-12 | 7.95 | 4 | SO69711 | 2024-08-19 | 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 | |
SO69713_1 | 100 | 21699 | 382 | 4 | 2024-08-24 | 28.01 | 2024-08-12 | 1120.49 | 1 | SO69713 | 2024-08-19 | 89.64 | 713.08 | |
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 | |
SO69713_2 | 100 | 21699 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 2 | SO69713 | 2024-08-19 | 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 | |
SO69713_3 | 100 | 21699 | 479 | 4 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 3 | SO69713 | 2024-08-19 | 0.72 | 3.36 | |
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 | |
SO69713_4 | 100 | 21699 | 465 | 4 | 2024-08-24 | 0.61 | 2024-08-12 | 24.49 | 4 | SO69713 | 2024-08-19 | 1.96 | 9.16 | |
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 | |
SO69714_1 | 100 | 21700 | 386 | 4 | 2024-08-24 | 28.01 | 2024-08-12 | 1120.49 | 1 | SO69714 | 2024-08-19 | 89.64 | 713.08 | |
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 | |
SO69714_2 | 100 | 21700 | 489 | 4 | 2024-08-24 | 1.35 | 2024-08-12 | 53.99 | 2 | SO69714 | 2024-08-19 | 4.32 | 41.57 | |
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 | |
SO69715_1 | 100 | 18801 | 583 | 4 | 2024-08-24 | 42.52 | 2024-08-12 | 1700.99 | 1 | SO69715 | 2024-08-19 | 136.08 | 1082.51 | |
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 | |
SO69715_2 | 100 | 18801 | 214 | 4 | 2024-08-24 | 0.87 | 2024-08-12 | 34.99 | 2 | SO69715 | 2024-08-19 | 2.80 | 13.09 | |
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 | |
SO69715_3 | 100 | 18801 | 471 | 4 | 2024-08-24 | 1.59 | 2024-08-12 | 63.50 | 3 | SO69715 | 2024-08-19 | 5.08 | 23.75 | |
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 | |
SO69716_1 | 100 | 14354 | 581 | 4 | 2024-08-24 | 42.52 | 2024-08-12 | 1700.99 | 1 | SO69716 | 2024-08-19 | 136.08 | 1082.51 | |
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 | |
SO69716_2 | 100 | 14354 | 488 | 4 | 2024-08-24 | 1.35 | 2024-08-12 | 53.99 | 2 | SO69716 | 2024-08-19 | 4.32 | 41.57 | |
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 | |
SO69741_1 | 100 | 27245 | 541 | 4 | 2024-08-25 | 0.72 | 2024-08-13 | 28.99 | 1 | SO69741 | 2024-08-20 | 2.32 | 10.84 | |
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 | |
SO69741_2 | 100 | 27245 | 530 | 4 | 2024-08-25 | 0.12 | 2024-08-13 | 4.99 | 2 | SO69741 | 2024-08-20 | 0.40 | 1.87 | |
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 | |
SO69742_1 | 100 | 25205 | 535 | 4 | 2024-08-25 | 0.62 | 2024-08-13 | 24.99 | 1 | SO69742 | 2024-08-20 | 2.00 | 9.35 | |
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 | |
SO69742_2 | 100 | 25205 | 528 | 4 | 2024-08-25 | 0.12 | 2024-08-13 | 4.99 | 2 | SO69742 | 2024-08-20 | 0.40 | 1.87 | |
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 | |
SO69742_3 | 100 | 25205 | 480 | 2 | 4 | 2024-08-25 | 0.06 | 2024-08-13 | 2.29 | 3 | SO69742 | 2024-08-20 | 0.18 | 0.86 |
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 | |
SO69743_1 | 100 | 28048 | 538 | 4 | 2024-08-25 | 0.54 | 2024-08-13 | 21.49 | 1 | SO69743 | 2024-08-20 | 1.72 | 8.04 | |
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 |
SO69743_2 | 100 | 28048 | 225 | 4 | 2024-08-25 | 0.22 | 2024-08-13 | 8.99 | 2 | SO69743 | 2024-08-20 | 0.72 | 6.92 | |
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 | |
SO69743_3 | 100 | 28048 | 489 | 4 | 2024-08-25 | 1.35 | 2024-08-13 | 53.99 | 3 | SO69743 | 2024-08-20 | 4.32 | 41.57 | |
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 | |
SO69744_1 | 100 | 24971 | 540 | 4 | 2024-08-25 | 0.82 | 2024-08-13 | 32.60 | 1 | SO69744 | 2024-08-20 | 2.61 | 12.19 | |
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 |
SO69744_2 | 100 | 24971 | 483 | 4 | 2024-08-25 | 3.00 | 2024-08-13 | 120.00 | 2 | SO69744 | 2024-08-20 | 9.60 | 44.88 | |
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 | |
SO69748_1 | 100 | 21145 | 478 | 4 | 2024-08-25 | 0.25 | 2024-08-13 | 9.99 | 1 | SO69748 | 2024-08-20 | 0.80 | 3.74 | |
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 | |
SO69748_2 | 100 | 21145 | 477 | 4 | 2024-08-25 | 0.12 | 2024-08-13 | 4.99 | 2 | SO69748 | 2024-08-20 | 0.40 | 1.87 | |
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 | |
SO69748_3 | 100 | 21145 | 487 | 4 | 2024-08-25 | 1.37 | 2024-08-13 | 54.99 | 3 | SO69748 | 2024-08-20 | 4.40 | 20.57 | |
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 | |
SO69749_1 | 100 | 20325 | 225 | 4 | 2024-08-25 | 0.22 | 2024-08-13 | 8.99 | 1 | SO69749 | 2024-08-20 | 0.72 | 6.92 | |
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 | |
SO69749_2 | 100 | 20325 | 474 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 2 | SO69749 | 2024-08-20 | 5.60 | 26.18 | |
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 | |
SO69761_1 | 100 | 18068 | 353 | 2 | 4 | 2024-08-25 | 58.00 | 2024-08-13 | 2319.99 | 1 | SO69761 | 2024-08-20 | 185.60 | 1265.62 |
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 | |
SO69761_2 | 100 | 18068 | 483 | 4 | 2024-08-25 | 3.00 | 2024-08-13 | 120.00 | 2 | SO69761 | 2024-08-20 | 9.60 | 44.88 | |
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 | |
SO69762_1 | 100 | 15309 | 588 | 2 | 4 | 2024-08-25 | 19.24 | 2024-08-13 | 769.49 | 1 | SO69762 | 2024-08-20 | 61.56 | 419.78 |
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 | |
SO69762_2 | 100 | 15309 | 476 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 2 | SO69762 | 2024-08-20 | 5.60 | 26.18 | |
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 | |
SO69763_1 | 100 | 15312 | 588 | 4 | 2024-08-25 | 19.24 | 2024-08-13 | 769.49 | 1 | SO69763 | 2024-08-20 | 61.56 | 419.78 | |
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 | |
SO69763_2 | 100 | 15312 | 476 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 2 | SO69763 | 2024-08-20 | 5.60 | 26.18 | |
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 | |
SO69763_3 | 100 | 15312 | 225 | 4 | 2024-08-25 | 0.22 | 2024-08-13 | 8.99 | 3 | SO69763 | 2024-08-20 | 0.72 | 6.92 | |
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 | |
SO69764_1 | 100 | 15333 | 587 | 4 | 2024-08-25 | 19.24 | 2024-08-13 | 769.49 | 1 | SO69764 | 2024-08-20 | 61.56 | 419.78 | |
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 | |
SO69764_2 | 100 | 15333 | 225 | 4 | 2024-08-25 | 0.22 | 2024-08-13 | 8.99 | 2 | SO69764 | 2024-08-20 | 0.72 | 6.92 | |
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 | |
SO69764_3 | 100 | 15333 | 474 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 3 | SO69764 | 2024-08-20 | 5.60 | 26.18 | |
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 | |
SO69765_1 | 100 | 15308 | 587 | 4 | 2024-08-25 | 19.24 | 2024-08-13 | 769.49 | 1 | SO69765 | 2024-08-20 | 61.56 | 419.78 | |
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 | |
SO69765_2 | 100 | 15308 | 476 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 2 | SO69765 | 2024-08-20 | 5.60 | 26.18 | |
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 | |
SO69768_1 | 100 | 17399 | 361 | 4 | 2024-08-25 | 57.37 | 2024-08-13 | 2294.99 | 1 | SO69768 | 2024-08-20 | 183.60 | 1251.98 | |
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 | |
SO69768_2 | 100 | 17399 | 485 | 4 | 2024-08-25 | 0.55 | 2024-08-13 | 21.98 | 2 | SO69768 | 2024-08-20 | 1.76 | 8.22 | |
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 | |
SO69768_3 | 100 | 17399 | 228 | 4 | 2024-08-25 | 1.25 | 2024-08-13 | 49.99 | 3 | SO69768 | 2024-08-20 | 4.00 | 38.49 | |
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 | |
SO69782_1 | 100 | 24996 | 574 | 4 | 2024-08-25 | 59.60 | 2024-08-13 | 2384.07 | 1 | SO69782 | 2024-08-20 | 190.73 | 1481.94 | |
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 | |
SO69782_2 | 100 | 24996 | 530 | 4 | 2024-08-25 | 0.12 | 2024-08-13 | 4.99 | 2 | SO69782 | 2024-08-20 | 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 |
SO69782_3 | 100 | 24996 | 541 | 4 | 2024-08-25 | 0.72 | 2024-08-13 | 28.99 | 3 | SO69782 | 2024-08-20 | 2.32 | 10.84 | |
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 | |
SO69784_1 | 100 | 23507 | 606 | 4 | 2024-08-25 | 13.50 | 2024-08-13 | 539.99 | 1 | SO69784 | 2024-08-20 | 43.20 | 343.65 | |
SO46800_1 | 100 | 13019 | 370 | 4 | 2022-11-06 | 61.08 | 2022-10-25 | 2443.35 | 1 | SO46800 | 2022-11-01 | 195.47 | 1518.79 | |
SO69784_2 | 100 | 23507 | 217 | 4 | 2024-08-25 | 0.87 | 2024-08-13 | 34.99 | 2 | SO69784 | 2024-08-20 | 2.80 | 13.09 | |
SO46813_1 | 100 | 13152 | 379 | 4 | 2022-11-08 | 54.54 | 2022-10-27 | 2181.56 | 1 | SO46813 | 2022-11-03 | 174.53 | 1320.68 | |
SO69786_1 | 100 | 14884 | 386 | 4 | 2024-08-25 | 28.01 | 2024-08-13 | 1120.49 | 1 | SO69786 | 2024-08-20 | 89.64 | 713.08 | |
SO46814_1 | 100 | 13165 | 371 | 4 | 2022-11-08 | 54.54 | 2022-10-27 | 2181.56 | 1 | SO46814 | 2022-11-03 | 174.53 | 1320.68 | |
SO69786_2 | 100 | 14884 | 539 | 4 | 2024-08-25 | 0.62 | 2024-08-13 | 24.99 | 2 | SO69786 | 2024-08-20 | 2.00 | 9.35 | |
SO46817_1 | 100 | 26121 | 356 | 4 | 2022-11-08 | 51.79 | 2022-10-27 | 2071.42 | 1 | SO46817 | 2022-11-03 | 165.71 | 1117.86 | |
SO69786_3 | 100 | 14884 | 529 | 4 | 2024-08-25 | 0.10 | 2024-08-13 | 3.99 | 3 | SO69786 | 2024-08-20 | 0.32 | 1.49 | |
SO46822_1 | 100 | 15155 | 325 | 4 | 2022-11-09 | 19.57 | 2022-10-28 | 782.99 | 1 | SO46822 | 2022-11-04 | 62.64 | 486.71 | |
SO69786_4 | 100 | 14884 | 222 | 4 | 2024-08-25 | 0.87 | 2024-08-13 | 34.99 | 4 | SO69786 | 2024-08-20 | 2.80 | 13.09 | |
SO46823_1 | 100 | 15193 | 323 | 4 | 2022-11-09 | 19.57 | 2022-10-28 | 782.99 | 1 | SO46823 | 2022-11-04 | 62.64 | 486.71 | |
SO69788_1 | 100 | 18798 | 580 | 4 | 2024-08-25 | 42.52 | 2024-08-13 | 1700.99 | 1 | SO69788 | 2024-08-20 | 136.08 | 1082.51 | |
SO46834_1 | 100 | 12923 | 379 | 4 | 2022-11-10 | 54.54 | 2022-10-29 | 2181.56 | 1 | SO46834 | 2022-11-05 | 174.53 | 1320.68 | |
SO69788_2 | 100 | 18798 | 539 | 4 | 2024-08-25 | 0.62 | 2024-08-13 | 24.99 | 2 | SO69788 | 2024-08-20 | 2.00 | 9.35 | |
SO46838_1 | 100 | 12922 | 375 | 4 | 2022-11-11 | 54.54 | 2022-10-30 | 2181.56 | 1 | SO46838 | 2022-11-06 | 174.53 | 1320.68 |
Generated 2024-11-11 01:42:00.173 UTC