[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 638 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43984_1 | 29 | 13545 | 311 | 8 | 2021-12-06 | 89.46 | 2021-11-24 | 3578.27 | 1 | SO43984 | 2021-12-01 | 286.26 | 2171.29 | |
SO62198_4 | 19 | 19801 | 481 | 6 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 4 | SO62198 | 2024-05-04 | 0.72 | 3.36 | |
SO68731_1 | 100 | 23214 | 604 | 4 | 2024-08-13 | 13.50 | 2024-08-01 | 539.99 | 1 | SO68731 | 2024-08-08 | 43.20 | 343.65 | |
SO43985_1 | 29 | 13515 | 313 | 8 | 2021-12-06 | 89.46 | 2021-11-24 | 3578.27 | 1 | SO43985 | 2021-12-01 | 286.26 | 2171.29 | |
SO62199_1 | 100 | 12752 | 476 | 7 | 2024-05-09 | 1.75 | 2024-04-27 | 69.99 | 1 | SO62199 | 2024-05-04 | 5.60 | 26.18 | |
SO68731_2 | 100 | 23214 | 222 | 4 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 2 | SO68731 | 2024-08-08 | 2.80 | 13.09 | |
SO43986_1 | 100 | 28070 | 310 | 4 | 2021-12-06 | 89.46 | 2021-11-24 | 3578.27 | 1 | SO43986 | 2021-12-01 | 286.26 | 2171.29 | |
SO62199_2 | 100 | 12752 | 237 | 7 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 2 | SO62199 | 2024-05-04 | 4.00 | 38.49 | |
SO68731_3 | 100 | 23214 | 490 | 4 | 2024-08-13 | 1.35 | 2024-08-01 | 53.99 | 3 | SO68731 | 2024-08-08 | 4.32 | 41.57 | |
SO43987_1 | 100 | 28042 | 310 | 4 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO43987 | 2021-12-02 | 286.26 | 2171.29 | |
SO62200_1 | 98 | 26216 | 529 | 10 | 2024-05-09 | 0.10 | 2024-04-27 | 3.99 | 1 | SO62200 | 2024-05-04 | 0.32 | 1.49 | |
SO68732_1 | 100 | 18344 | 580 | 4 | 2024-08-13 | 42.52 | 2024-08-01 | 1700.99 | 1 | SO68732 | 2024-08-08 | 136.08 | 1082.51 | |
SO43988_1 | 98 | 11244 | 344 | 10 | 2021-12-07 | 85.00 | 2021-11-25 | 3399.99 | 1 | SO43988 | 2021-12-02 | 272.00 | 1912.15 | |
SO62200_2 | 98 | 26216 | 222 | 10 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 2 | SO62200 | 2024-05-04 | 2.80 | 13.09 | |
SO68732_2 | 100 | 18344 | 237 | 4 | 2024-08-13 | 1.25 | 2024-08-01 | 49.99 | 2 | SO68732 | 2024-08-08 | 4.00 | 38.49 | |
SO43989_1 | 100 | 28083 | 312 | 4 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO43989 | 2021-12-02 | 286.26 | 2171.29 | |
SO62200_3 | 98 | 26216 | 491 | 10 | 2024-05-09 | 1.35 | 2024-04-27 | 53.99 | 3 | SO62200 | 2024-05-04 | 4.32 | 41.57 | |
SO68732_3 | 100 | 18344 | 225 | 4 | 2024-08-13 | 0.22 | 2024-08-01 | 8.99 | 3 | SO68732 | 2024-08-08 | 0.72 | 6.92 | |
SO43990_1 | 100 | 25872 | 344 | 1 | 2021-12-07 | 85.00 | 2021-11-25 | 3399.99 | 1 | SO43990 | 2021-12-02 | 272.00 | 1912.15 | |
SO62201_1 | 100 | 23772 | 529 | 8 | 2024-05-09 | 0.10 | 2024-04-27 | 3.99 | 1 | SO62201 | 2024-05-04 | 0.32 | 1.49 | |
SO68733_1 | 100 | 20878 | 390 | 7 | 2024-08-13 | 28.01 | 2024-08-01 | 1120.49 | 1 | SO68733 | 2024-08-08 | 89.64 | 713.08 | |
SO43991_1 | 6 | 16660 | 310 | 9 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO43991 | 2021-12-02 | 286.26 | 2171.29 | |
SO62201_2 | 100 | 23772 | 214 | 8 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 2 | SO62201 | 2024-05-04 | 2.80 | 13.09 | |
SO68733_2 | 100 | 20878 | 217 | 7 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 2 | SO68733 | 2024-08-08 | 2.80 | 13.09 | |
SO43992_1 | 6 | 16638 | 311 | 9 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO43992 | 2021-12-02 | 286.26 | 2171.29 | |
SO62202_1 | 98 | 11434 | 538 | 10 | 2024-05-09 | 0.54 | 2024-04-27 | 21.49 | 1 | SO62202 | 2024-05-04 | 1.72 | 8.04 | |
SO68734_1 | 6 | 29461 | 566 | 9 | 2024-08-13 | 18.56 | 2024-08-01 | 742.35 | 1 | SO68734 | 2024-08-08 | 59.39 | 461.44 | |
SO43993_1 | 6 | 16929 | 314 | 9 | 2021-12-09 | 89.46 | 2021-11-27 | 3578.27 | 1 | SO43993 | 2021-12-04 | 286.26 | 2171.29 | |
SO62203_1 | 98 | 12633 | 541 | 10 | 2024-05-09 | 0.72 | 2024-04-27 | 28.99 | 1 | SO62203 | 2024-05-04 | 2.32 | 10.84 | |
SO68734_2 | 6 | 29461 | 217 | 9 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 2 | SO68734 | 2024-08-08 | 2.80 | 13.09 | |
SO43994_1 | 100 | 27681 | 314 | 4 | 2021-12-10 | 89.46 | 2021-11-28 | 3578.27 | 1 | SO43994 | 2021-12-05 | 286.26 | 2171.29 | |
SO62203_2 | 98 | 12633 | 530 | 10 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62203 | 2024-05-04 | 0.40 | 1.87 | |
SO68735_1 | 6 | 14667 | 585 | 9 | 2024-08-13 | 18.56 | 2024-08-01 | 742.35 | 1 | SO68735 | 2024-08-08 | 59.39 | 461.44 | |
SO43995_1 | 19 | 21813 | 312 | 6 | 2021-12-10 | 89.46 | 2021-11-28 | 3578.27 | 1 | SO43995 | 2021-12-05 | 286.26 | 2171.29 | |
SO62203_3 | 98 | 12633 | 480 | 2 | 10 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 3 | SO62203 | 2024-05-04 | 0.18 | 0.86 |
SO68735_2 | 6 | 14667 | 477 | 9 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 2 | SO68735 | 2024-08-08 | 0.40 | 1.87 | |
SO43996_1 | 100 | 27920 | 310 | 4 | 2021-12-10 | 89.46 | 2021-11-28 | 3578.27 | 1 | SO43996 | 2021-12-05 | 286.26 | 2171.29 | |
SO62204_1 | 98 | 28748 | 538 | 10 | 2024-05-09 | 0.54 | 2024-04-27 | 21.49 | 1 | SO62204 | 2024-05-04 | 1.72 | 8.04 | |
SO68735_3 | 6 | 14667 | 479 | 9 | 2024-08-13 | 0.22 | 2024-08-01 | 8.99 | 3 | SO68735 | 2024-08-08 | 0.72 | 3.36 | |
SO43997_1 | 100 | 28022 | 310 | 4 | 2021-12-10 | 89.46 | 2021-11-28 | 3578.27 | 1 | SO43997 | 2021-12-05 | 286.26 | 2171.29 | |
SO62204_2 | 98 | 28748 | 480 | 10 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 2 | SO62204 | 2024-05-04 | 0.18 | 0.86 | |
SO68735_4 | 6 | 14667 | 237 | 9 | 2024-08-13 | 1.25 | 2024-08-01 | 49.99 | 4 | SO68735 | 2024-08-08 | 4.00 | 38.49 | |
SO43998_1 | 6 | 11033 | 348 | 9 | 2021-12-10 | 84.37 | 2021-11-28 | 3374.99 | 1 | SO43998 | 2021-12-05 | 270.00 | 1898.09 | |
SO62205_1 | 98 | 16511 | 530 | 10 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62205 | 2024-05-04 | 0.40 | 1.87 | |
SO68736_1 | 6 | 12684 | 575 | 9 | 2024-08-13 | 59.60 | 2024-08-01 | 2384.07 | 1 | SO68736 | 2024-08-08 | 190.73 | 1481.94 | |
SO43999_1 | 100 | 28047 | 311 | 1 | 2021-12-10 | 89.46 | 2021-11-28 | 3578.27 | 1 | SO43999 | 2021-12-05 | 286.26 | 2171.29 | |
SO62205_2 | 98 | 16511 | 480 | 2 | 10 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 2 | SO62205 | 2024-05-04 | 0.18 | 0.86 |
SO68736_2 | 6 | 12684 | 479 | 9 | 2024-08-13 | 0.22 | 2024-08-01 | 8.99 | 2 | SO68736 | 2024-08-08 | 0.72 | 3.36 | |
SO44000_1 | 100 | 27918 | 311 | 4 | 2021-12-11 | 89.46 | 2021-11-29 | 3578.27 | 1 | SO44000 | 2021-12-06 | 286.26 | 2171.29 | |
SO62206_1 | 100 | 11258 | 537 | 4 | 2024-05-09 | 0.88 | 2024-04-27 | 35.00 | 1 | SO62206 | 2024-05-04 | 2.80 | 13.09 | |
SO68736_3 | 6 | 12684 | 477 | 9 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 3 | SO68736 | 2024-08-08 | 0.40 | 1.87 | |
SO44001_1 | 100 | 28044 | 313 | 4 | 2021-12-11 | 89.46 | 2021-11-29 | 3578.27 | 1 | SO44001 | 2021-12-06 | 286.26 | 2171.29 | |
SO62207_1 | 19 | 14904 | 537 | 6 | 2024-05-09 | 0.88 | 2024-04-27 | 35.00 | 1 | SO62207 | 2024-05-04 | 2.80 | 13.09 | |
SO68736_4 | 6 | 12684 | 222 | 9 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 4 | SO68736 | 2024-08-08 | 2.80 | 13.09 | |
SO44002_1 | 100 | 14572 | 336 | 4 | 2021-12-11 | 17.48 | 2021-11-29 | 699.10 | 1 | SO44002 | 2021-12-06 | 55.93 | 413.15 | |
SO62207_2 | 19 | 14904 | 480 | 6 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 2 | SO62207 | 2024-05-04 | 0.18 | 0.86 |
Generated 2024-11-10 15:34:18.490 UTC