[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 877 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44416_1 | 6 | 11069 | 345 | 9 | 2022-02-09 | 85.00 | 2022-01-28 | 3399.99 | 1 | SO44416 | 2022-02-04 | 272.00 | 1912.15 | |
SO56020_2 | 6 | 24910 | 488 | 9 | 2024-02-04 | 1.35 | 2024-01-23 | 53.99 | 2 | SO56020 | 2024-01-30 | 4.32 | 41.57 | |
SO62516_2 | 6 | 20241 | 479 | 9 | 2024-05-14 | 0.22 | 2024-05-02 | 8.99 | 2 | SO62516 | 2024-05-09 | 0.72 | 3.36 | |
SO68959_1 | 6 | 20268 | 538 | 9 | 2024-08-17 | 0.54 | 2024-08-05 | 21.49 | 1 | SO68959 | 2024-08-12 | 1.72 | 8.04 | |
SO44417_1 | 6 | 17917 | 311 | 9 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44417 | 2022-02-04 | 286.26 | 2171.29 | |
SO56020_3 | 6 | 24910 | 225 | 9 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 3 | SO56020 | 2024-01-30 | 0.72 | 6.92 | |
SO62516_3 | 6 | 20241 | 477 | 9 | 2024-05-14 | 0.12 | 2024-05-02 | 4.99 | 3 | SO62516 | 2024-05-09 | 0.40 | 1.87 | |
SO68960_1 | 6 | 26421 | 538 | 9 | 2024-08-17 | 0.54 | 2024-08-05 | 21.49 | 1 | SO68960 | 2024-08-12 | 1.72 | 8.04 | |
SO44418_1 | 6 | 17919 | 311 | 9 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44418 | 2022-02-04 | 286.26 | 2171.29 | |
SO56023_1 | 6 | 23522 | 485 | 9 | 2024-02-04 | 0.55 | 2024-01-23 | 21.98 | 1 | SO56023 | 2024-01-30 | 1.76 | 8.22 | |
SO62516_4 | 6 | 20241 | 489 | 9 | 2024-05-14 | 1.35 | 2024-05-02 | 53.99 | 4 | SO62516 | 2024-05-09 | 4.32 | 41.57 | |
SO68960_2 | 6 | 26421 | 529 | 9 | 2024-08-17 | 0.10 | 2024-08-05 | 3.99 | 2 | SO68960 | 2024-08-12 | 0.32 | 1.49 | |
SO44419_1 | 6 | 17352 | 310 | 9 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44419 | 2022-02-04 | 286.26 | 2171.29 | |
SO56023_2 | 6 | 23522 | 222 | 9 | 2024-02-04 | 0.87 | 2024-01-23 | 34.99 | 2 | SO56023 | 2024-01-30 | 2.80 | 13.09 | |
SO62517_1 | 6 | 23533 | 583 | 9 | 2024-05-14 | 42.52 | 2024-05-02 | 1700.99 | 1 | SO62517 | 2024-05-09 | 136.08 | 1082.51 | |
SO68960_3 | 6 | 26421 | 214 | 9 | 2024-08-17 | 0.87 | 2024-08-05 | 34.99 | 3 | SO68960 | 2024-08-12 | 2.80 | 13.09 | |
SO44420_1 | 6 | 17512 | 311 | 9 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44420 | 2022-02-04 | 286.26 | 2171.29 | |
SO56023_3 | 6 | 23522 | 471 | 9 | 2024-02-04 | 1.59 | 2024-01-23 | 63.50 | 3 | SO56023 | 2024-01-30 | 5.08 | 23.75 | |
SO62517_2 | 6 | 23533 | 214 | 9 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 2 | SO62517 | 2024-05-09 | 2.80 | 13.09 | |
SO68961_1 | 6 | 27721 | 530 | 9 | 2024-08-17 | 0.12 | 2024-08-05 | 4.99 | 1 | SO68961 | 2024-08-12 | 0.40 | 1.87 | |
SO44424_1 | 6 | 17916 | 312 | 9 | 2022-02-10 | 89.46 | 2022-01-29 | 3578.27 | 1 | SO44424 | 2022-02-05 | 286.26 | 2171.29 | |
SO56024_1 | 6 | 13043 | 214 | 9 | 2024-02-04 | 0.87 | 2024-01-23 | 34.99 | 1 | SO56024 | 2024-01-30 | 2.80 | 13.09 | |
SO62518_1 | 6 | 25226 | 386 | 9 | 2024-05-14 | 28.01 | 2024-05-02 | 1120.49 | 1 | SO62518 | 2024-05-09 | 89.64 | 713.08 | |
SO68961_2 | 6 | 27721 | 480 | 2 | 9 | 2024-08-17 | 0.06 | 2024-08-05 | 2.29 | 2 | SO68961 | 2024-08-12 | 0.18 | 0.86 |
SO44425_1 | 6 | 17504 | 311 | 9 | 2022-02-10 | 89.46 | 2022-01-29 | 3578.27 | 1 | SO44425 | 2022-02-05 | 286.26 | 2171.29 | |
SO56024_2 | 6 | 13043 | 488 | 9 | 2024-02-04 | 1.35 | 2024-01-23 | 53.99 | 2 | SO56024 | 2024-01-30 | 4.32 | 41.57 | |
SO62518_2 | 6 | 25226 | 539 | 9 | 2024-05-14 | 0.62 | 2024-05-02 | 24.99 | 2 | SO62518 | 2024-05-09 | 2.00 | 9.35 | |
SO68961_3 | 6 | 27721 | 486 | 9 | 2024-08-17 | 3.98 | 2024-08-05 | 159.00 | 3 | SO68961 | 2024-08-12 | 12.72 | 59.47 | |
SO44430_1 | 6 | 17927 | 313 | 9 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44430 | 2022-02-06 | 286.26 | 2171.29 | |
SO56025_1 | 6 | 14067 | 237 | 9 | 2024-02-04 | 1.25 | 2024-01-23 | 49.99 | 1 | SO56025 | 2024-01-30 | 4.00 | 38.49 | |
SO62518_3 | 6 | 25226 | 529 | 9 | 2024-05-14 | 0.10 | 2024-05-02 | 3.99 | 3 | SO62518 | 2024-05-09 | 0.32 | 1.49 | |
SO68962_1 | 6 | 14015 | 217 | 9 | 2024-08-17 | 0.87 | 2024-08-05 | 34.99 | 1 | SO68962 | 2024-08-12 | 2.80 | 13.09 | |
SO44431_1 | 6 | 17725 | 312 | 9 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44431 | 2022-02-06 | 286.26 | 2171.29 | |
SO56026_1 | 6 | 19589 | 489 | 9 | 2024-02-04 | 1.35 | 2024-01-23 | 53.99 | 1 | SO56026 | 2024-01-30 | 4.32 | 41.57 | |
SO62518_4 | 6 | 25226 | 482 | 9 | 2024-05-14 | 0.22 | 2024-05-02 | 8.99 | 4 | SO62518 | 2024-05-09 | 0.72 | 3.36 | |
SO68963_1 | 6 | 16172 | 540 | 9 | 2024-08-17 | 0.82 | 2024-08-05 | 32.60 | 1 | SO68963 | 2024-08-12 | 2.61 | 12.19 | |
SO44437_1 | 6 | 11076 | 344 | 9 | 2022-02-13 | 85.00 | 2022-02-01 | 3399.99 | 1 | SO44437 | 2022-02-08 | 272.00 | 1912.15 | |
SO56026_2 | 6 | 19589 | 225 | 9 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 2 | SO56026 | 2024-01-30 | 0.72 | 6.92 | |
SO62519_1 | 6 | 17733 | 386 | 9 | 2024-05-14 | 28.01 | 2024-05-02 | 1120.49 | 1 | SO62519 | 2024-05-09 | 89.64 | 713.08 | |
SO68963_2 | 6 | 16172 | 529 | 9 | 2024-08-17 | 0.10 | 2024-08-05 | 3.99 | 2 | SO68963 | 2024-08-12 | 0.32 | 1.49 | |
SO44438_1 | 6 | 17909 | 312 | 9 | 2022-02-13 | 89.46 | 2022-02-01 | 3578.27 | 1 | SO44438 | 2022-02-08 | 286.26 | 2171.29 | |
SO56060_1 | 6 | 28211 | 605 | 9 | 2024-02-04 | 13.50 | 2024-01-23 | 539.99 | 1 | SO56060 | 2024-01-30 | 43.20 | 343.65 | |
SO62519_2 | 6 | 17733 | 463 | 9 | 2024-05-14 | 0.61 | 2024-05-02 | 24.49 | 2 | SO62519 | 2024-05-09 | 1.96 | 9.16 | |
SO68963_3 | 6 | 16172 | 487 | 9 | 2024-08-17 | 1.37 | 2024-08-05 | 54.99 | 3 | SO68963 | 2024-08-12 | 4.40 | 20.57 | |
SO44443_1 | 6 | 17370 | 310 | 9 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44443 | 2022-02-09 | 286.26 | 2171.29 | |
SO56061_1 | 6 | 20990 | 604 | 9 | 2024-02-04 | 13.50 | 2024-01-23 | 539.99 | 1 | SO56061 | 2024-01-30 | 43.20 | 343.65 | |
SO62519_3 | 6 | 17733 | 217 | 9 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 3 | SO62519 | 2024-05-09 | 2.80 | 13.09 | |
SO68964_1 | 6 | 17054 | 489 | 9 | 2024-08-17 | 1.35 | 2024-08-05 | 53.99 | 1 | SO68964 | 2024-08-12 | 4.32 | 41.57 | |
SO44445_1 | 6 | 17478 | 314 | 9 | 2022-02-17 | 89.46 | 2022-02-05 | 3578.27 | 1 | SO44445 | 2022-02-12 | 286.26 | 2171.29 | |
SO56061_2 | 6 | 20990 | 479 | 9 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 2 | SO56061 | 2024-01-30 | 0.72 | 3.36 | |
SO62520_1 | 6 | 13119 | 355 | 9 | 2024-05-14 | 58.00 | 2024-05-02 | 2319.99 | 1 | SO62520 | 2024-05-09 | 185.60 | 1265.62 | |
SO68998_1 | 6 | 17925 | 386 | 9 | 2024-08-17 | 28.01 | 2024-08-05 | 1120.49 | 1 | SO68998 | 2024-08-12 | 89.64 | 713.08 | |
SO44446_1 | 6 | 17914 | 313 | 9 | 2022-02-17 | 89.46 | 2022-02-05 | 3578.27 | 1 | SO44446 | 2022-02-12 | 286.26 | 2171.29 | |
SO56061_3 | 6 | 20990 | 477 | 9 | 2024-02-04 | 0.12 | 2024-01-23 | 4.99 | 3 | SO56061 | 2024-01-30 | 0.40 | 1.87 | |
SO62520_2 | 6 | 13119 | 478 | 9 | 2024-05-14 | 0.25 | 2024-05-02 | 9.99 | 2 | SO62520 | 2024-05-09 | 0.80 | 3.74 | |
SO68999_1 | 6 | 26028 | 388 | 9 | 2024-08-17 | 28.01 | 2024-08-05 | 1120.49 | 1 | SO68999 | 2024-08-12 | 89.64 | 713.08 |
Generated 2024-11-10 23:17:19.033 UTC