[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 1255 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49698_1 | 19 | 21336 | 354 | 6 | 2023-05-20 | 51.79 | 2023-05-08 | 2071.42 | 1 | SO49698 | 2023-05-15 | 165.71 | 1117.86 | |
SO56271_1 | 19 | 21336 | 605 | 6 | 2023-12-20 | 13.50 | 2023-12-08 | 539.99 | 1 | SO56271 | 2023-12-15 | 43.20 | 343.65 | |
SO63706_1 | 19 | 11500 | 529 | 6 | 2024-04-11 | 0.10 | 2024-03-30 | 3.99 | 1 | SO63706 | 2024-04-06 | 0.32 | 1.49 | |
SO69359_2 | 19 | 14906 | 528 | 6 | 2024-07-03 | 0.12 | 2024-06-21 | 4.99 | 2 | SO69359 | 2024-06-28 | 0.40 | 1.87 | |
SO49713_1 | 19 | 21400 | 354 | 6 | 2023-05-21 | 51.79 | 2023-05-09 | 2071.42 | 1 | SO49713 | 2023-05-16 | 165.71 | 1117.86 | |
SO56271_2 | 19 | 21336 | 479 | 6 | 2023-12-20 | 0.22 | 2023-12-08 | 8.99 | 2 | SO56271 | 2023-12-15 | 0.72 | 3.36 | |
SO63706_2 | 19 | 11500 | 214 | 6 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63706 | 2024-04-06 | 2.80 | 13.09 | |
SO69359_3 | 19 | 14906 | 214 | 6 | 2024-07-03 | 0.87 | 2024-06-21 | 34.99 | 3 | SO69359 | 2024-06-28 | 2.80 | 13.09 | |
SO49742_1 | 19 | 27285 | 331 | 6 | 2023-05-24 | 19.57 | 2023-05-12 | 782.99 | 1 | SO49742 | 2023-05-19 | 62.64 | 486.71 | |
SO56271_3 | 19 | 21336 | 484 | 6 | 2023-12-20 | 0.20 | 2023-12-08 | 7.95 | 3 | SO56271 | 2023-12-15 | 0.64 | 2.97 | |
SO63709_1 | 19 | 14566 | 478 | 6 | 2024-04-11 | 0.25 | 2024-03-30 | 9.99 | 1 | SO63709 | 2024-04-06 | 0.80 | 3.74 | |
SO69365_1 | 19 | 22299 | 599 | 6 | 2024-07-03 | 13.50 | 2024-06-21 | 539.99 | 1 | SO69365 | 2024-06-28 | 43.20 | 294.58 | |
SO49760_1 | 19 | 21423 | 358 | 6 | 2023-05-27 | 51.23 | 2023-05-15 | 2049.10 | 1 | SO49760 | 2023-05-22 | 163.93 | 1105.81 | |
SO56281_1 | 19 | 11277 | 530 | 6 | 2023-12-21 | 0.12 | 2023-12-09 | 4.99 | 1 | SO56281 | 2023-12-16 | 0.40 | 1.87 | |
SO63709_2 | 19 | 14566 | 477 | 6 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 2 | SO63709 | 2024-04-06 | 0.40 | 1.87 | |
SO69365_2 | 19 | 22299 | 535 | 6 | 2024-07-03 | 0.62 | 2024-06-21 | 24.99 | 2 | SO69365 | 2024-06-28 | 2.00 | 9.35 | |
SO49761_1 | 19 | 27270 | 339 | 6 | 2023-05-27 | 19.57 | 2023-05-15 | 782.99 | 1 | SO49761 | 2023-05-22 | 62.64 | 486.71 | |
SO56281_2 | 19 | 11277 | 487 | 6 | 2023-12-21 | 1.37 | 2023-12-09 | 54.99 | 2 | SO56281 | 2023-12-16 | 4.40 | 20.57 | |
SO63709_3 | 19 | 14566 | 225 | 6 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 3 | SO63709 | 2024-04-06 | 0.72 | 6.92 | |
SO69365_3 | 19 | 22299 | 480 | 6 | 2024-07-03 | 0.06 | 2024-06-21 | 2.29 | 3 | SO69365 | 2024-06-28 | 0.18 | 0.86 | |
SO49770_1 | 19 | 27298 | 343 | 6 | 2023-05-29 | 19.57 | 2023-05-17 | 782.99 | 1 | SO49770 | 2023-05-24 | 62.64 | 486.71 | |
SO56281_3 | 19 | 11277 | 484 | 6 | 2023-12-21 | 0.20 | 2023-12-09 | 7.95 | 3 | SO56281 | 2023-12-16 | 0.64 | 2.97 | |
SO63709_4 | 19 | 14566 | 487 | 6 | 2024-04-11 | 1.37 | 2024-03-30 | 54.99 | 4 | SO63709 | 2024-04-06 | 4.40 | 20.57 | |
SO69380_1 | 19 | 23867 | 225 | 6 | 2024-07-03 | 0.22 | 2024-06-21 | 8.99 | 1 | SO69380 | 2024-06-28 | 0.72 | 6.92 | |
SO49776_1 | 19 | 27297 | 331 | 6 | 2023-05-30 | 19.57 | 2023-05-18 | 782.99 | 1 | SO49776 | 2023-05-25 | 62.64 | 486.71 | |
SO56282_1 | 19 | 11520 | 529 | 6 | 2023-12-21 | 0.10 | 2023-12-09 | 3.99 | 1 | SO56282 | 2023-12-16 | 0.32 | 1.49 | |
SO63714_1 | 19 | 19541 | 528 | 6 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 1 | SO63714 | 2024-04-06 | 0.40 | 1.87 | |
SO69380_2 | 19 | 23867 | 560 | 2 | 6 | 2024-07-03 | 30.37 | 2024-06-21 | 1214.85 | 2 | SO69380 | 2024-06-28 | 97.19 | 755.15 |
SO49777_1 | 19 | 27404 | 335 | 6 | 2023-05-30 | 19.57 | 2023-05-18 | 782.99 | 1 | SO49777 | 2023-05-25 | 62.64 | 486.71 | |
SO56282_2 | 19 | 11520 | 217 | 6 | 2023-12-21 | 0.87 | 2023-12-09 | 34.99 | 2 | SO56282 | 2023-12-16 | 2.80 | 13.09 | |
SO63714_2 | 19 | 19541 | 222 | 6 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63714 | 2024-04-06 | 2.80 | 13.09 | |
SO69587_1 | 19 | 11176 | 530 | 6 | 2024-07-04 | 0.12 | 2024-06-22 | 4.99 | 1 | SO69587 | 2024-06-29 | 0.40 | 1.87 | |
SO49794_1 | 19 | 21349 | 352 | 6 | 2023-06-01 | 51.79 | 2023-05-20 | 2071.42 | 1 | SO49794 | 2023-05-27 | 165.71 | 1117.86 | |
SO56282_3 | 19 | 11520 | 465 | 6 | 2023-12-21 | 0.61 | 2023-12-09 | 24.49 | 3 | SO56282 | 2023-12-16 | 1.96 | 9.16 | |
SO63714_3 | 19 | 19541 | 231 | 6 | 2024-04-11 | 1.25 | 2024-03-30 | 49.99 | 3 | SO63714 | 2024-04-06 | 4.00 | 38.49 | |
SO69587_2 | 19 | 11176 | 222 | 6 | 2024-07-04 | 0.87 | 2024-06-22 | 34.99 | 2 | SO69587 | 2024-06-29 | 2.80 | 13.09 | |
SO49804_1 | 19 | 26200 | 377 | 6 | 2023-06-02 | 54.54 | 2023-05-21 | 2181.56 | 1 | SO49804 | 2023-05-28 | 174.53 | 1320.68 | |
SO56283_1 | 19 | 11530 | 529 | 6 | 2023-12-21 | 0.10 | 2023-12-09 | 3.99 | 1 | SO56283 | 2023-12-16 | 0.32 | 1.49 | |
SO63714_4 | 19 | 19541 | 225 | 6 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 4 | SO63714 | 2024-04-06 | 0.72 | 6.92 | |
SO69588_1 | 19 | 12984 | 530 | 6 | 2024-07-04 | 0.12 | 2024-06-22 | 4.99 | 1 | SO69588 | 2024-06-29 | 0.40 | 1.87 | |
SO49907_1 | 19 | 21589 | 360 | 6 | 2023-06-05 | 51.23 | 2023-05-24 | 2049.10 | 1 | SO49907 | 2023-05-31 | 163.93 | 1105.81 | |
SO56283_2 | 19 | 11530 | 214 | 6 | 2023-12-21 | 0.87 | 2023-12-09 | 34.99 | 2 | SO56283 | 2023-12-16 | 2.80 | 13.09 | |
SO63715_1 | 19 | 22366 | 485 | 6 | 2024-04-11 | 0.55 | 2024-03-30 | 21.98 | 1 | SO63715 | 2024-04-06 | 1.76 | 8.22 | |
SO69588_2 | 19 | 12984 | 541 | 6 | 2024-07-04 | 0.72 | 2024-06-22 | 28.99 | 2 | SO69588 | 2024-06-29 | 2.32 | 10.84 | |
SO49924_1 | 19 | 21595 | 362 | 2 | 6 | 2023-06-07 | 51.23 | 2023-05-26 | 2049.10 | 1 | SO49924 | 2023-06-02 | 163.93 | 1105.81 |
SO56284_1 | 19 | 11507 | 529 | 6 | 2023-12-21 | 0.10 | 2023-12-09 | 3.99 | 1 | SO56284 | 2023-12-16 | 0.32 | 1.49 | |
SO63715_2 | 19 | 22366 | 217 | 6 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63715 | 2024-04-06 | 2.80 | 13.09 | |
SO69588_3 | 19 | 12984 | 217 | 6 | 2024-07-04 | 0.87 | 2024-06-22 | 34.99 | 3 | SO69588 | 2024-06-29 | 2.80 | 13.09 | |
SO49986_1 | 19 | 21582 | 362 | 2 | 6 | 2023-06-13 | 51.23 | 2023-06-01 | 2049.10 | 1 | SO49986 | 2023-06-08 | 163.93 | 1105.81 |
SO56284_2 | 19 | 11507 | 539 | 6 | 2023-12-21 | 0.62 | 2023-12-09 | 24.99 | 2 | SO56284 | 2023-12-16 | 2.00 | 9.35 | |
SO63726_1 | 19 | 15847 | 485 | 6 | 2024-04-11 | 0.55 | 2024-03-30 | 21.98 | 1 | SO63726 | 2024-04-06 | 1.76 | 8.22 | |
SO69589_1 | 19 | 11211 | 538 | 6 | 2024-07-04 | 0.54 | 2024-06-22 | 21.49 | 1 | SO69589 | 2024-06-29 | 1.72 | 8.04 | |
SO50019_1 | 19 | 26235 | 375 | 6 | 2023-06-16 | 54.54 | 2023-06-04 | 2181.56 | 1 | SO50019 | 2023-06-11 | 174.53 | 1320.68 | |
SO56284_3 | 19 | 11507 | 222 | 6 | 2023-12-21 | 0.87 | 2023-12-09 | 34.99 | 3 | SO56284 | 2023-12-16 | 2.80 | 13.09 | |
SO63726_2 | 19 | 15847 | 471 | 6 | 2024-04-11 | 1.59 | 2024-03-30 | 63.50 | 2 | SO63726 | 2024-04-06 | 5.08 | 23.75 | |
SO69589_2 | 19 | 11211 | 480 | 6 | 2024-07-04 | 0.06 | 2024-06-22 | 2.29 | 2 | SO69589 | 2024-06-29 | 0.18 | 0.86 | |
SO50024_1 | 19 | 27406 | 329 | 6 | 2023-06-16 | 19.57 | 2023-06-04 | 782.99 | 1 | SO50024 | 2023-06-11 | 62.64 | 486.71 | |
SO56286_1 | 19 | 11698 | 535 | 6 | 2023-12-21 | 0.62 | 2023-12-09 | 24.99 | 1 | SO56286 | 2023-12-16 | 2.00 | 9.35 | |
SO63740_1 | 19 | 13440 | 562 | 6 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63740 | 2024-04-06 | 190.73 | 1481.94 | |
SO69590_1 | 19 | 13920 | 541 | 6 | 2024-07-04 | 0.72 | 2024-06-22 | 28.99 | 1 | SO69590 | 2024-06-29 | 2.32 | 10.84 | |
SO50087_1 | 19 | 21613 | 358 | 6 | 2023-06-23 | 51.23 | 2023-06-11 | 2049.10 | 1 | SO50087 | 2023-06-18 | 163.93 | 1105.81 | |
SO56286_2 | 19 | 11698 | 463 | 6 | 2023-12-21 | 0.61 | 2023-12-09 | 24.49 | 2 | SO56286 | 2023-12-16 | 1.96 | 9.16 | |
SO63740_2 | 19 | 13440 | 490 | 6 | 2024-04-11 | 1.35 | 2024-03-30 | 53.99 | 2 | SO63740 | 2024-04-06 | 4.32 | 41.57 | |
SO69590_2 | 19 | 13920 | 530 | 6 | 2024-07-04 | 0.12 | 2024-06-22 | 4.99 | 2 | SO69590 | 2024-06-29 | 0.40 | 1.87 | |
SO50147_1 | 19 | 27429 | 321 | 6 | 2023-06-29 | 19.57 | 2023-06-17 | 782.99 | 1 | SO50147 | 2023-06-24 | 62.64 | 486.71 | |
SO56290_1 | 19 | 19839 | 536 | 6 | 2023-12-21 | 0.75 | 2023-12-09 | 29.99 | 1 | SO56290 | 2023-12-16 | 2.40 | 11.22 | |
SO63770_1 | 19 | 11300 | 480 | 6 | 2024-04-12 | 0.06 | 2024-03-31 | 2.29 | 1 | SO63770 | 2024-04-07 | 0.18 | 0.86 | |
SO69590_3 | 19 | 13920 | 214 | 6 | 2024-07-04 | 0.87 | 2024-06-22 | 34.99 | 3 | SO69590 | 2024-06-29 | 2.80 | 13.09 | |
SO50326_1 | 19 | 21620 | 354 | 6 | 2023-07-04 | 51.79 | 2023-06-22 | 2071.42 | 1 | SO50326 | 2023-06-29 | 165.71 | 1117.86 | |
SO56290_2 | 19 | 19839 | 528 | 6 | 2023-12-21 | 0.12 | 2023-12-09 | 4.99 | 2 | SO56290 | 2023-12-16 | 0.40 | 1.87 | |
SO63771_1 | 19 | 11300 | 529 | 6 | 2024-04-12 | 0.10 | 2024-03-31 | 3.99 | 1 | SO63771 | 2024-04-07 | 0.32 | 1.49 | |
SO69595_1 | 19 | 11712 | 536 | 6 | 2024-07-04 | 0.75 | 2024-06-22 | 29.99 | 1 | SO69595 | 2024-06-29 | 2.40 | 11.22 | |
SO50337_1 | 19 | 21652 | 358 | 6 | 2023-07-05 | 51.23 | 2023-06-23 | 2049.10 | 1 | SO50337 | 2023-06-30 | 163.93 | 1105.81 | |
SO56290_3 | 19 | 19839 | 217 | 6 | 2023-12-21 | 0.87 | 2023-12-09 | 34.99 | 3 | SO56290 | 2023-12-16 | 2.80 | 13.09 | |
SO63771_2 | 19 | 11300 | 463 | 6 | 2024-04-12 | 0.61 | 2024-03-31 | 24.49 | 2 | SO63771 | 2024-04-07 | 1.96 | 9.16 | |
SO69597_1 | 19 | 12959 | 478 | 6 | 2024-07-04 | 0.25 | 2024-06-22 | 9.99 | 1 | SO69597 | 2024-06-29 | 0.80 | 3.74 | |
SO50343_1 | 19 | 26310 | 377 | 6 | 2023-07-05 | 54.54 | 2023-06-23 | 2181.56 | 1 | SO50343 | 2023-06-30 | 174.53 | 1320.68 | |
SO56291_1 | 19 | 15856 | 476 | 6 | 2023-12-21 | 1.75 | 2023-12-09 | 69.99 | 1 | SO56291 | 2023-12-16 | 5.60 | 26.18 | |
SO63780_1 | 19 | 18382 | 476 | 6 | 2024-04-12 | 1.75 | 2024-03-31 | 69.99 | 1 | SO63780 | 2024-04-07 | 5.60 | 26.18 | |
SO69597_2 | 19 | 12959 | 477 | 6 | 2024-07-04 | 0.12 | 2024-06-22 | 4.99 | 2 | SO69597 | 2024-06-29 | 0.40 | 1.87 | |
SO50366_1 | 19 | 26294 | 369 | 2 | 6 | 2023-07-07 | 61.08 | 2023-06-25 | 2443.35 | 1 | SO50366 | 2023-07-02 | 195.47 | 1518.79 |
SO56291_2 | 19 | 15856 | 225 | 6 | 2023-12-21 | 0.22 | 2023-12-09 | 8.99 | 2 | SO56291 | 2023-12-16 | 0.72 | 6.92 | |
SO63780_2 | 19 | 18382 | 489 | 6 | 2024-04-12 | 1.35 | 2024-03-31 | 53.99 | 2 | SO63780 | 2024-04-07 | 4.32 | 41.57 | |
SO69597_3 | 19 | 12959 | 487 | 6 | 2024-07-04 | 1.37 | 2024-06-22 | 54.99 | 3 | SO69597 | 2024-06-29 | 4.40 | 20.57 | |
SO50367_1 | 19 | 26572 | 381 | 6 | 2023-07-07 | 25.01 | 2023-06-25 | 1000.44 | 1 | SO50367 | 2023-07-02 | 80.04 | 605.65 | |
SO56293_1 | 19 | 11808 | 476 | 6 | 2023-12-21 | 1.75 | 2023-12-09 | 69.99 | 1 | SO56293 | 2023-12-16 | 5.60 | 26.18 | |
SO63780_3 | 19 | 18382 | 225 | 6 | 2024-04-12 | 0.22 | 2024-03-31 | 8.99 | 3 | SO63780 | 2024-04-07 | 0.72 | 6.92 | |
SO69599_1 | 19 | 12140 | 477 | 6 | 2024-07-04 | 0.12 | 2024-06-22 | 4.99 | 1 | SO69599 | 2024-06-29 | 0.40 | 1.87 | |
SO50394_1 | 19 | 27557 | 333 | 6 | 2023-07-09 | 19.57 | 2023-06-27 | 782.99 | 1 | SO50394 | 2023-07-04 | 62.64 | 486.71 | |
SO63793_1 | 19 | 16654 | 361 | 6 | 2024-04-12 | 57.37 | 2024-03-31 | 2294.99 | 1 | SO63793 | 2024-04-07 | 183.60 | 1251.98 | |
SO63793_2 | 19 | 16654 | 478 | 6 | 2024-04-12 | 0.25 | 2024-03-31 | 9.99 | 2 | SO63793 | 2024-04-07 | 0.80 | 3.74 | |
SO63834_1 | 19 | 11277 | 480 | 6 | 2024-04-13 | 0.06 | 2024-04-01 | 2.29 | 1 | SO63834 | 2024-04-08 | 0.18 | 0.86 | |
SO63835_1 | 19 | 15244 | 529 | 6 | 2024-04-13 | 0.10 | 2024-04-01 | 3.99 | 1 | SO63835 | 2024-04-08 | 0.32 | 1.49 | |
SO63836_1 | 19 | 11262 | 529 | 6 | 2024-04-13 | 0.10 | 2024-04-01 | 3.99 | 1 | SO63836 | 2024-04-08 | 0.32 | 1.49 | |
SO63836_2 | 19 | 11262 | 539 | 6 | 2024-04-13 | 0.62 | 2024-04-01 | 24.99 | 2 | SO63836 | 2024-04-08 | 2.00 | 9.35 | |
SO63836_3 | 19 | 11262 | 480 | 6 | 2024-04-13 | 0.06 | 2024-04-01 | 2.29 | 3 | SO63836 | 2024-04-08 | 0.18 | 0.86 |
Generated 2024-09-21 06:33:29.432 UTC