[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2099 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63818_1 | 6 | 27867 | 573 | 9 | 2024-06-05 | 59.60 | 2024-05-24 | 2384.07 | 1 | SO63818 | 2024-05-31 | 190.73 | 1481.94 | |
SO63818_2 | 6 | 27867 | 465 | 9 | 2024-06-05 | 0.61 | 2024-05-24 | 24.49 | 2 | SO63818 | 2024-05-31 | 1.96 | 9.16 | |
SO63818_3 | 6 | 27867 | 217 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 3 | SO63818 | 2024-05-31 | 2.80 | 13.09 | |
SO63819_1 | 6 | 11100 | 563 | 9 | 2024-06-05 | 59.60 | 2024-05-24 | 2384.07 | 1 | SO63819 | 2024-05-31 | 190.73 | 1481.94 | |
SO63819_2 | 6 | 11100 | 479 | 9 | 2024-06-05 | 0.22 | 2024-05-24 | 8.99 | 2 | SO63819 | 2024-05-31 | 0.72 | 3.36 | |
SO63819_3 | 6 | 11100 | 477 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 3 | SO63819 | 2024-05-31 | 0.40 | 1.87 | |
SO63820_1 | 6 | 11967 | 574 | 9 | 2024-06-05 | 59.60 | 2024-05-24 | 2384.07 | 1 | SO63820 | 2024-05-31 | 190.73 | 1481.94 | |
SO63820_2 | 6 | 11967 | 217 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO63820 | 2024-05-31 | 2.80 | 13.09 | |
SO63821_1 | 6 | 29067 | 584 | 9 | 2024-06-05 | 13.50 | 2024-05-24 | 539.99 | 1 | SO63821 | 2024-05-31 | 43.20 | 343.65 | |
SO63822_1 | 6 | 29096 | 604 | 9 | 2024-06-05 | 13.50 | 2024-05-24 | 539.99 | 1 | SO63822 | 2024-05-31 | 43.20 | 343.65 | |
SO63822_2 | 6 | 29096 | 214 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO63822 | 2024-05-31 | 2.80 | 13.09 | |
SO63825_1 | 6 | 12992 | 535 | 9 | 2024-06-06 | 0.62 | 2024-05-25 | 24.99 | 1 | SO63825 | 2024-06-01 | 2.00 | 9.35 | |
SO63825_2 | 6 | 12992 | 528 | 9 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 2 | SO63825 | 2024-06-01 | 0.40 | 1.87 | |
SO56431_3 | 6 | 14344 | 222 | 9 | 2024-02-16 | 0.87 | 2024-02-04 | 34.99 | 3 | SO56431 | 2024-02-11 | 2.80 | 13.09 | |
SO56432_1 | 6 | 15147 | 529 | 9 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 1 | SO56432 | 2024-02-11 | 0.32 | 1.49 | |
SO56432_2 | 6 | 15147 | 481 | 9 | 2024-02-16 | 0.22 | 2024-02-04 | 8.99 | 2 | SO56432 | 2024-02-11 | 0.72 | 3.36 | |
SO56432_3 | 6 | 15147 | 539 | 9 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 3 | SO56432 | 2024-02-11 | 2.00 | 9.35 | |
SO56433_1 | 6 | 15026 | 539 | 9 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 1 | SO56433 | 2024-02-11 | 2.00 | 9.35 | |
SO56434_1 | 6 | 17291 | 536 | 9 | 2024-02-16 | 0.75 | 2024-02-04 | 29.99 | 1 | SO56434 | 2024-02-11 | 2.40 | 11.22 | |
SO56434_2 | 6 | 17291 | 480 | 2 | 9 | 2024-02-16 | 0.06 | 2024-02-04 | 2.29 | 2 | SO56434 | 2024-02-11 | 0.18 | 0.86 |
SO56435_1 | 6 | 18896 | 537 | 9 | 2024-02-16 | 0.88 | 2024-02-04 | 35.00 | 1 | SO56435 | 2024-02-11 | 2.80 | 13.09 | |
SO56435_2 | 6 | 18896 | 528 | 9 | 2024-02-16 | 0.12 | 2024-02-04 | 4.99 | 2 | SO56435 | 2024-02-11 | 0.40 | 1.87 | |
SO56435_3 | 6 | 18896 | 214 | 9 | 2024-02-16 | 0.87 | 2024-02-04 | 34.99 | 3 | SO56435 | 2024-02-11 | 2.80 | 13.09 | |
SO56436_1 | 6 | 12035 | 528 | 9 | 2024-02-16 | 0.12 | 2024-02-04 | 4.99 | 1 | SO56436 | 2024-02-11 | 0.40 | 1.87 | |
SO56436_2 | 6 | 12035 | 481 | 9 | 2024-02-16 | 0.22 | 2024-02-04 | 8.99 | 2 | SO56436 | 2024-02-11 | 0.72 | 3.36 | |
SO56437_1 | 6 | 19677 | 477 | 9 | 2024-02-16 | 0.12 | 2024-02-04 | 4.99 | 1 | SO56437 | 2024-02-11 | 0.40 | 1.87 | |
SO56437_2 | 6 | 19677 | 488 | 9 | 2024-02-16 | 1.35 | 2024-02-04 | 53.99 | 2 | SO56437 | 2024-02-11 | 4.32 | 41.57 | |
SO56438_1 | 6 | 15599 | 478 | 9 | 2024-02-16 | 0.25 | 2024-02-04 | 9.99 | 1 | SO56438 | 2024-02-11 | 0.80 | 3.74 | |
SO56438_2 | 6 | 15599 | 477 | 9 | 2024-02-16 | 0.12 | 2024-02-04 | 4.99 | 2 | SO56438 | 2024-02-11 | 0.40 | 1.87 | |
SO56438_3 | 6 | 15599 | 217 | 9 | 2024-02-16 | 0.87 | 2024-02-04 | 34.99 | 3 | SO56438 | 2024-02-11 | 2.80 | 13.09 | |
SO56439_1 | 6 | 16178 | 529 | 9 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 1 | SO56439 | 2024-02-11 | 0.32 | 1.49 | |
SO56439_2 | 6 | 16178 | 540 | 9 | 2024-02-16 | 0.82 | 2024-02-04 | 32.60 | 2 | SO56439 | 2024-02-11 | 2.61 | 12.19 | |
SO56439_3 | 6 | 16178 | 480 | 9 | 2024-02-16 | 0.06 | 2024-02-04 | 2.29 | 3 | SO56439 | 2024-02-11 | 0.18 | 0.86 | |
SO56440_1 | 6 | 11753 | 484 | 9 | 2024-02-16 | 0.20 | 2024-02-04 | 7.95 | 1 | SO56440 | 2024-02-11 | 0.64 | 2.97 | |
SO56473_1 | 6 | 28212 | 604 | 9 | 2024-02-16 | 13.50 | 2024-02-04 | 539.99 | 1 | SO56473 | 2024-02-11 | 43.20 | 343.65 | |
SO56473_2 | 6 | 28212 | 529 | 9 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 2 | SO56473 | 2024-02-11 | 0.32 | 1.49 | |
SO56473_3 | 6 | 28212 | 538 | 9 | 2024-02-16 | 0.54 | 2024-02-04 | 21.49 | 3 | SO56473 | 2024-02-11 | 1.72 | 8.04 | |
SO56473_4 | 6 | 28212 | 491 | 9 | 2024-02-16 | 1.35 | 2024-02-04 | 53.99 | 4 | SO56473 | 2024-02-11 | 4.32 | 41.57 | |
SO56474_1 | 6 | 28954 | 225 | 9 | 2024-02-16 | 0.22 | 2024-02-04 | 8.99 | 1 | SO56474 | 2024-02-11 | 0.72 | 6.92 | |
SO56474_2 | 6 | 28954 | 563 | 9 | 2024-02-16 | 59.60 | 2024-02-04 | 2384.07 | 2 | SO56474 | 2024-02-11 | 190.73 | 1481.94 | |
SO56475_1 | 6 | 19558 | 378 | 9 | 2024-02-16 | 61.08 | 2024-02-04 | 2443.35 | 1 | SO56475 | 2024-02-11 | 195.47 | 1554.95 | |
SO56475_2 | 6 | 19558 | 484 | 9 | 2024-02-16 | 0.20 | 2024-02-04 | 7.95 | 2 | SO56475 | 2024-02-11 | 0.64 | 2.97 | |
SO56476_1 | 6 | 12358 | 359 | 9 | 2024-02-16 | 57.37 | 2024-02-04 | 2294.99 | 1 | SO56476 | 2024-02-11 | 183.60 | 1251.98 | |
SO56476_2 | 6 | 12358 | 480 | 9 | 2024-02-16 | 0.06 | 2024-02-04 | 2.29 | 2 | SO56476 | 2024-02-11 | 0.18 | 0.86 | |
SO56489_1 | 6 | 17052 | 528 | 9 | 2024-02-17 | 0.12 | 2024-02-05 | 4.99 | 1 | SO56489 | 2024-02-12 | 0.40 | 1.87 | |
SO56489_2 | 6 | 17052 | 536 | 9 | 2024-02-17 | 0.75 | 2024-02-05 | 29.99 | 2 | SO56489 | 2024-02-12 | 2.40 | 11.22 | |
SO56489_3 | 6 | 17052 | 484 | 9 | 2024-02-17 | 0.20 | 2024-02-05 | 7.95 | 3 | SO56489 | 2024-02-12 | 0.64 | 2.97 | |
SO56490_1 | 6 | 19600 | 528 | 9 | 2024-02-17 | 0.12 | 2024-02-05 | 4.99 | 1 | SO56490 | 2024-02-12 | 0.40 | 1.87 | |
SO56490_2 | 6 | 19600 | 536 | 9 | 2024-02-17 | 0.75 | 2024-02-05 | 29.99 | 2 | SO56490 | 2024-02-12 | 2.40 | 11.22 | |
SO56490_3 | 6 | 19600 | 222 | 9 | 2024-02-17 | 0.87 | 2024-02-05 | 34.99 | 3 | SO56490 | 2024-02-12 | 2.80 | 13.09 | |
SO56490_4 | 6 | 19600 | 465 | 9 | 2024-02-17 | 0.61 | 2024-02-05 | 24.49 | 4 | SO56490 | 2024-02-12 | 1.96 | 9.16 | |
SO56491_1 | 6 | 19574 | 529 | 9 | 2024-02-17 | 0.10 | 2024-02-05 | 3.99 | 1 | SO56491 | 2024-02-12 | 0.32 | 1.49 | |
SO56491_2 | 6 | 19574 | 538 | 9 | 2024-02-17 | 0.54 | 2024-02-05 | 21.49 | 2 | SO56491 | 2024-02-12 | 1.72 | 8.04 | |
SO56491_3 | 6 | 19574 | 214 | 9 | 2024-02-17 | 0.87 | 2024-02-05 | 34.99 | 3 | SO56491 | 2024-02-12 | 2.80 | 13.09 | |
SO56492_1 | 6 | 20266 | 529 | 9 | 2024-02-17 | 0.10 | 2024-02-05 | 3.99 | 1 | SO56492 | 2024-02-12 | 0.32 | 1.49 | |
SO56492_2 | 6 | 20266 | 538 | 9 | 2024-02-17 | 0.54 | 2024-02-05 | 21.49 | 2 | SO56492 | 2024-02-12 | 1.72 | 8.04 | |
SO56492_3 | 6 | 20266 | 214 | 9 | 2024-02-17 | 0.87 | 2024-02-05 | 34.99 | 3 | SO56492 | 2024-02-12 | 2.80 | 13.09 | |
SO56493_1 | 6 | 23346 | 477 | 9 | 2024-02-17 | 0.12 | 2024-02-05 | 4.99 | 1 | SO56493 | 2024-02-12 | 0.40 | 1.87 | |
SO56494_1 | 6 | 27596 | 530 | 9 | 2024-02-17 | 0.12 | 2024-02-05 | 4.99 | 1 | SO56494 | 2024-02-12 | 0.40 | 1.87 | |
SO56494_2 | 6 | 27596 | 222 | 9 | 2024-02-17 | 0.87 | 2024-02-05 | 34.99 | 2 | SO56494 | 2024-02-12 | 2.80 | 13.09 |
Generated 2024-11-14 05:41:09.989 UTC