[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 187 < SKIP 1095 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56196_2 | 100 | 27210 | 480 | 2 | 4 | 2023-12-19 | 0.06 | 2023-12-07 | 2.29 | 2 | SO56196 | 2023-12-14 | 0.18 | 0.86 |
SO62687_1 | 100 | 17561 | 581 | 4 | 2024-03-28 | 42.52 | 2024-03-16 | 1700.99 | 1 | SO62687 | 2024-03-23 | 136.08 | 1082.51 | |
SO69231_1 | 100 | 25997 | 577 | 2 | 4 | 2024-07-01 | 30.37 | 2024-06-19 | 1214.85 | 1 | SO69231 | 2024-06-26 | 97.19 | 755.15 |
SO45987_1 | 100 | 11854 | 310 | 4 | 2022-06-30 | 89.46 | 2022-06-18 | 3578.27 | 1 | SO45987 | 2022-06-25 | 286.26 | 2171.29 | |
SO56200_1 | 100 | 22215 | 536 | 4 | 2023-12-19 | 0.75 | 2023-12-07 | 29.99 | 1 | SO56200 | 2023-12-14 | 2.40 | 11.22 | |
SO62687_2 | 100 | 17561 | 214 | 4 | 2024-03-28 | 0.87 | 2024-03-16 | 34.99 | 2 | SO62687 | 2024-03-23 | 2.80 | 13.09 | |
SO69231_2 | 100 | 25997 | 225 | 4 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 2 | SO69231 | 2024-06-26 | 0.72 | 6.92 | |
SO45993_1 | 100 | 11924 | 313 | 4 | 2022-07-01 | 89.46 | 2022-06-19 | 3578.27 | 1 | SO45993 | 2022-06-26 | 286.26 | 2171.29 | |
SO56200_2 | 100 | 22215 | 477 | 4 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 2 | SO56200 | 2023-12-14 | 0.40 | 1.87 | |
SO62704_1 | 100 | 11720 | 488 | 4 | 2024-03-29 | 1.35 | 2024-03-17 | 53.99 | 1 | SO62704 | 2024-03-24 | 4.32 | 41.57 | |
SO69232_1 | 100 | 23807 | 605 | 4 | 2024-07-01 | 13.50 | 2024-06-19 | 539.99 | 1 | SO69232 | 2024-06-26 | 43.20 | 343.65 | |
SO45994_1 | 100 | 11774 | 311 | 4 | 2022-07-01 | 89.46 | 2022-06-19 | 3578.27 | 1 | SO45994 | 2022-06-26 | 286.26 | 2171.29 | |
SO56200_3 | 100 | 22215 | 222 | 4 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 3 | SO56200 | 2023-12-14 | 2.80 | 13.09 | |
SO62713_1 | 100 | 19888 | 476 | 4 | 2024-03-29 | 1.75 | 2024-03-17 | 69.99 | 1 | SO62713 | 2024-03-24 | 5.60 | 26.18 | |
SO69232_2 | 100 | 23807 | 477 | 4 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 2 | SO69232 | 2024-06-26 | 0.40 | 1.87 | |
SO45996_1 | 100 | 11839 | 312 | 4 | 2022-07-01 | 89.46 | 2022-06-19 | 3578.27 | 1 | SO45996 | 2022-06-26 | 286.26 | 2171.29 | |
SO56200_4 | 100 | 22215 | 482 | 4 | 2023-12-19 | 0.22 | 2023-12-07 | 8.99 | 4 | SO56200 | 2023-12-14 | 0.72 | 3.36 | |
SO62713_2 | 100 | 19888 | 231 | 4 | 2024-03-29 | 1.25 | 2024-03-17 | 49.99 | 2 | SO62713 | 2024-03-24 | 4.00 | 38.49 | |
SO69232_3 | 100 | 23807 | 479 | 4 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 3 | SO69232 | 2024-06-26 | 0.72 | 3.36 | |
SO45997_1 | 100 | 14756 | 324 | 4 | 2022-07-01 | 17.48 | 2022-06-19 | 699.10 | 1 | SO45997 | 2022-06-26 | 55.93 | 413.15 | |
SO56201_1 | 100 | 18675 | 474 | 4 | 2023-12-19 | 1.75 | 2023-12-07 | 69.99 | 1 | SO56201 | 2023-12-14 | 5.60 | 26.18 | |
SO62716_1 | 100 | 18663 | 225 | 4 | 2024-03-29 | 0.22 | 2024-03-17 | 8.99 | 1 | SO62716 | 2024-03-24 | 0.72 | 6.92 | |
SO69232_4 | 100 | 23807 | 491 | 4 | 2024-07-01 | 1.35 | 2024-06-19 | 53.99 | 4 | SO69232 | 2024-06-26 | 4.32 | 41.57 | |
SO46002_1 | 100 | 11826 | 310 | 4 | 2022-07-02 | 89.46 | 2022-06-20 | 3578.27 | 1 | SO46002 | 2022-06-27 | 286.26 | 2171.29 | |
SO56201_2 | 100 | 18675 | 482 | 4 | 2023-12-19 | 0.22 | 2023-12-07 | 8.99 | 2 | SO56201 | 2023-12-14 | 0.72 | 3.36 | |
SO62716_2 | 100 | 18663 | 477 | 4 | 2024-03-29 | 0.12 | 2024-03-17 | 4.99 | 2 | SO62716 | 2024-03-24 | 0.40 | 1.87 | |
SO69236_1 | 100 | 18229 | 583 | 4 | 2024-07-01 | 42.52 | 2024-06-19 | 1700.99 | 1 | SO69236 | 2024-06-26 | 136.08 | 1082.51 | |
SO46003_1 | 100 | 11831 | 312 | 4 | 2022-07-02 | 89.46 | 2022-06-20 | 3578.27 | 1 | SO46003 | 2022-06-27 | 286.26 | 2171.29 | |
SO56201_3 | 100 | 18675 | 228 | 4 | 2023-12-19 | 1.25 | 2023-12-07 | 49.99 | 3 | SO56201 | 2023-12-14 | 4.00 | 38.49 | |
SO62718_1 | 100 | 16652 | 528 | 4 | 2024-03-29 | 0.12 | 2024-03-17 | 4.99 | 1 | SO62718 | 2024-03-24 | 0.40 | 1.87 | |
SO69245_1 | 100 | 12932 | 225 | 4 | 2024-07-02 | 0.22 | 2024-06-20 | 8.99 | 1 | SO69245 | 2024-06-27 | 0.72 | 6.92 | |
SO46004_1 | 100 | 11664 | 311 | 4 | 2022-07-02 | 89.46 | 2022-06-20 | 3578.27 | 1 | SO46004 | 2022-06-27 | 286.26 | 2171.29 | |
SO56203_1 | 100 | 17170 | 477 | 4 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 1 | SO56203 | 2023-12-14 | 0.40 | 1.87 | |
SO62718_2 | 100 | 16652 | 214 | 4 | 2024-03-29 | 0.87 | 2024-03-17 | 34.99 | 2 | SO62718 | 2024-03-24 | 2.80 | 13.09 | |
SO69260_1 | 100 | 27510 | 538 | 4 | 2024-07-02 | 0.54 | 2024-06-20 | 21.49 | 1 | SO69260 | 2024-06-27 | 1.72 | 8.04 | |
SO46013_1 | 100 | 11705 | 311 | 4 | 2022-07-03 | 89.46 | 2022-06-21 | 3578.27 | 1 | SO46013 | 2022-06-28 | 286.26 | 2171.29 | |
SO56203_2 | 100 | 17170 | 482 | 4 | 2023-12-19 | 0.22 | 2023-12-07 | 8.99 | 2 | SO56203 | 2023-12-14 | 0.72 | 3.36 | |
SO62718_3 | 100 | 16652 | 482 | 4 | 2024-03-29 | 0.22 | 2024-03-17 | 8.99 | 3 | SO62718 | 2024-03-24 | 0.72 | 3.36 | |
SO69260_2 | 100 | 27510 | 480 | 4 | 2024-07-02 | 0.06 | 2024-06-20 | 2.29 | 2 | SO69260 | 2024-06-27 | 0.18 | 0.86 | |
SO46016_1 | 100 | 11885 | 312 | 4 | 2022-07-03 | 89.46 | 2022-06-21 | 3578.27 | 1 | SO46016 | 2022-06-28 | 286.26 | 2171.29 | |
SO56205_1 | 100 | 14903 | 528 | 4 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 1 | SO56205 | 2023-12-14 | 0.40 | 1.87 | |
SO62720_1 | 100 | 13874 | 485 | 4 | 2024-03-29 | 0.55 | 2024-03-17 | 21.98 | 1 | SO62720 | 2024-03-24 | 1.76 | 8.22 | |
SO69260_3 | 100 | 27510 | 484 | 4 | 2024-07-02 | 0.20 | 2024-06-20 | 7.95 | 3 | SO69260 | 2024-06-27 | 0.64 | 2.97 | |
SO46017_1 | 100 | 11886 | 314 | 4 | 2022-07-03 | 89.46 | 2022-06-21 | 3578.27 | 1 | SO46017 | 2022-06-28 | 286.26 | 2171.29 | |
SO56205_2 | 100 | 14903 | 485 | 4 | 2023-12-19 | 0.55 | 2023-12-07 | 21.98 | 2 | SO56205 | 2023-12-14 | 1.76 | 8.22 | |
SO62720_2 | 100 | 13874 | 487 | 4 | 2024-03-29 | 1.37 | 2024-03-17 | 54.99 | 2 | SO62720 | 2024-03-24 | 4.40 | 20.57 | |
SO69263_1 | 100 | 24620 | 540 | 4 | 2024-07-02 | 0.82 | 2024-06-20 | 32.60 | 1 | SO69263 | 2024-06-27 | 2.61 | 12.19 | |
SO46019_1 | 100 | 14752 | 340 | 4 | 2022-07-03 | 17.48 | 2022-06-21 | 699.10 | 1 | SO46019 | 2022-06-28 | 55.93 | 413.15 | |
SO56205_3 | 100 | 14903 | 217 | 4 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 3 | SO56205 | 2023-12-14 | 2.80 | 13.09 | |
SO62721_1 | 100 | 13381 | 485 | 4 | 2024-03-29 | 0.55 | 2024-03-17 | 21.98 | 1 | SO62721 | 2024-03-24 | 1.76 | 8.22 | |
SO69263_2 | 100 | 24620 | 529 | 4 | 2024-07-02 | 0.10 | 2024-06-20 | 3.99 | 2 | SO69263 | 2024-06-27 | 0.32 | 1.49 | |
SO46108_1 | 100 | 12018 | 310 | 4 | 2022-07-04 | 89.46 | 2022-06-22 | 3578.27 | 1 | SO46108 | 2022-06-29 | 286.26 | 2171.29 | |
SO56211_1 | 100 | 13227 | 485 | 4 | 2023-12-19 | 0.55 | 2023-12-07 | 21.98 | 1 | SO56211 | 2023-12-14 | 1.76 | 8.22 | |
SO62721_2 | 100 | 13381 | 234 | 4 | 2024-03-29 | 1.25 | 2024-03-17 | 49.99 | 2 | SO62721 | 2024-03-24 | 4.00 | 38.49 | |
SO69263_3 | 100 | 24620 | 486 | 4 | 2024-07-02 | 3.98 | 2024-06-20 | 159.00 | 3 | SO69263 | 2024-06-27 | 12.72 | 59.47 | |
SO46110_1 | 100 | 12169 | 311 | 4 | 2022-07-04 | 89.46 | 2022-06-22 | 3578.27 | 1 | SO46110 | 2022-06-29 | 286.26 | 2171.29 | |
SO56211_2 | 100 | 13227 | 234 | 4 | 2023-12-19 | 1.25 | 2023-12-07 | 49.99 | 2 | SO56211 | 2023-12-14 | 4.00 | 38.49 | |
SO62731_1 | 100 | 11658 | 537 | 4 | 2024-03-29 | 0.88 | 2024-03-17 | 35.00 | 1 | SO62731 | 2024-03-24 | 2.80 | 13.09 | |
SO69264_1 | 100 | 22296 | 536 | 4 | 2024-07-02 | 0.75 | 2024-06-20 | 29.99 | 1 | SO69264 | 2024-06-27 | 2.40 | 11.22 | |
SO46112_1 | 100 | 11945 | 312 | 4 | 2022-07-04 | 89.46 | 2022-06-22 | 3578.27 | 1 | SO46112 | 2022-06-29 | 286.26 | 2171.29 |
Generated 2024-09-21 04:40:05.324 UTC