[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1565 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45203_1 | 6 | 18907 | 314 | 9 | 2022-05-19 | 89.46 | 2022-05-07 | 3578.27 | 1 | SO45203 | 2022-05-14 | 286.26 | 2171.29 |
SO56324_2 | 6 | 12673 | 478 | 9 | 2024-02-13 | 0.25 | 2024-02-01 | 9.99 | 2 | SO56324 | 2024-02-08 | 0.80 | 3.74 |
SO62821_2 | 6 | 25110 | 222 | 9 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 2 | SO62821 | 2024-05-19 | 2.80 | 13.09 |
SO69222_1 | 6 | 15145 | 359 | 9 | 2024-08-24 | 57.37 | 2024-08-12 | 2294.99 | 1 | SO69222 | 2024-08-19 | 183.60 | 1251.98 |
SO45204_1 | 6 | 11460 | 345 | 9 | 2022-05-19 | 85.00 | 2022-05-07 | 3399.99 | 1 | SO45204 | 2022-05-14 | 272.00 | 1912.15 |
SO56324_3 | 6 | 12673 | 477 | 9 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 3 | SO56324 | 2024-02-08 | 0.40 | 1.87 |
SO62822_1 | 6 | 11753 | 478 | 9 | 2024-05-24 | 0.25 | 2024-05-12 | 9.99 | 1 | SO62822 | 2024-05-19 | 0.80 | 3.74 |
SO69222_2 | 6 | 15145 | 480 | 9 | 2024-08-24 | 0.06 | 2024-08-12 | 2.29 | 2 | SO69222 | 2024-08-19 | 0.18 | 0.86 |
SO45211_1 | 6 | 18724 | 311 | 9 | 2022-05-20 | 89.46 | 2022-05-08 | 3578.27 | 1 | SO45211 | 2022-05-15 | 286.26 | 2171.29 |
SO56327_1 | 6 | 12001 | 361 | 9 | 2024-02-13 | 57.37 | 2024-02-01 | 2294.99 | 1 | SO56327 | 2024-02-08 | 183.60 | 1251.98 |
SO62823_1 | 6 | 13983 | 217 | 9 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 1 | SO62823 | 2024-05-19 | 2.80 | 13.09 |
SO69223_1 | 6 | 26663 | 388 | 9 | 2024-08-24 | 28.01 | 2024-08-12 | 1120.49 | 1 | SO69223 | 2024-08-19 | 89.64 | 713.08 |
SO45212_1 | 6 | 18729 | 314 | 9 | 2022-05-20 | 89.46 | 2022-05-08 | 3578.27 | 1 | SO45212 | 2022-05-15 | 286.26 | 2171.29 |
SO56327_2 | 6 | 12001 | 478 | 9 | 2024-02-13 | 0.25 | 2024-02-01 | 9.99 | 2 | SO56327 | 2024-02-08 | 0.80 | 3.74 |
SO62824_1 | 6 | 14233 | 237 | 9 | 2024-05-24 | 1.25 | 2024-05-12 | 49.99 | 1 | SO62824 | 2024-05-19 | 4.00 | 38.49 |
SO69223_2 | 6 | 26663 | 479 | 9 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 2 | SO69223 | 2024-08-19 | 0.72 | 3.36 |
SO45213_1 | 6 | 11464 | 349 | 9 | 2022-05-20 | 84.37 | 2022-05-08 | 3374.99 | 1 | SO45213 | 2022-05-15 | 270.00 | 1898.09 |
SO56327_3 | 6 | 12001 | 477 | 9 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 3 | SO56327 | 2024-02-08 | 0.40 | 1.87 |
SO62859_1 | 6 | 20430 | 376 | 9 | 2024-05-24 | 61.08 | 2024-05-12 | 2443.35 | 1 | SO62859 | 2024-05-19 | 195.47 | 1554.95 |
SO69223_3 | 6 | 26663 | 477 | 9 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 3 | SO69223 | 2024-08-19 | 0.40 | 1.87 |
SO45223_1 | 6 | 18930 | 312 | 9 | 2022-05-22 | 89.46 | 2022-05-10 | 3578.27 | 1 | SO45223 | 2022-05-17 | 286.26 | 2171.29 |
SO56327_4 | 6 | 12001 | 225 | 9 | 2024-02-13 | 0.22 | 2024-02-01 | 8.99 | 4 | SO56327 | 2024-02-08 | 0.72 | 6.92 |
SO62859_2 | 6 | 20430 | 222 | 9 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 2 | SO62859 | 2024-05-19 | 2.80 | 13.09 |
SO69223_4 | 6 | 26663 | 222 | 9 | 2024-08-24 | 0.87 | 2024-08-12 | 34.99 | 4 | SO69223 | 2024-08-19 | 2.80 | 13.09 |
SO45224_1 | 6 | 18723 | 311 | 9 | 2022-05-22 | 89.46 | 2022-05-10 | 3578.27 | 1 | SO45224 | 2022-05-17 | 286.26 | 2171.29 |
SO56332_1 | 6 | 24908 | 388 | 9 | 2024-02-14 | 28.01 | 2024-02-02 | 1120.49 | 1 | SO56332 | 2024-02-09 | 89.64 | 713.08 |
SO62860_1 | 6 | 20447 | 380 | 9 | 2024-05-24 | 61.08 | 2024-05-12 | 2443.35 | 1 | SO62860 | 2024-05-19 | 195.47 | 1554.95 |
SO69223_5 | 6 | 26663 | 467 | 9 | 2024-08-24 | 0.61 | 2024-08-12 | 24.49 | 5 | SO69223 | 2024-08-19 | 1.96 | 9.16 |
SO45228_1 | 6 | 18768 | 314 | 9 | 2022-05-23 | 89.46 | 2022-05-11 | 3578.27 | 1 | SO45228 | 2022-05-18 | 286.26 | 2171.29 |
SO56332_2 | 6 | 24908 | 217 | 9 | 2024-02-14 | 0.87 | 2024-02-02 | 34.99 | 2 | SO56332 | 2024-02-09 | 2.80 | 13.09 |
SO62860_2 | 6 | 20447 | 479 | 9 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 2 | SO62860 | 2024-05-19 | 0.72 | 3.36 |
SO69224_1 | 6 | 24282 | 581 | 9 | 2024-08-24 | 42.52 | 2024-08-12 | 1700.99 | 1 | SO69224 | 2024-08-19 | 136.08 | 1082.51 |
SO45231_1 | 6 | 18908 | 314 | 9 | 2022-05-24 | 89.46 | 2022-05-12 | 3578.27 | 1 | SO45231 | 2022-05-19 | 286.26 | 2171.29 |
SO56333_1 | 6 | 23542 | 386 | 9 | 2024-02-14 | 28.01 | 2024-02-02 | 1120.49 | 1 | SO56333 | 2024-02-09 | 89.64 | 713.08 |
SO62860_3 | 6 | 20447 | 477 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 3 | SO62860 | 2024-05-19 | 0.40 | 1.87 |
SO69224_2 | 6 | 24282 | 222 | 9 | 2024-08-24 | 0.87 | 2024-08-12 | 34.99 | 2 | SO69224 | 2024-08-19 | 2.80 | 13.09 |
SO45232_1 | 6 | 18736 | 310 | 9 | 2022-05-24 | 89.46 | 2022-05-12 | 3578.27 | 1 | SO45232 | 2022-05-19 | 286.26 | 2171.29 |
SO56333_2 | 6 | 23542 | 214 | 9 | 2024-02-14 | 0.87 | 2024-02-02 | 34.99 | 2 | SO56333 | 2024-02-09 | 2.80 | 13.09 |
SO62861_1 | 6 | 20253 | 376 | 9 | 2024-05-24 | 61.08 | 2024-05-12 | 2443.35 | 1 | SO62861 | 2024-05-19 | 195.47 | 1554.95 |
SO69225_1 | 6 | 25562 | 604 | 9 | 2024-08-24 | 13.50 | 2024-08-12 | 539.99 | 1 | SO69225 | 2024-08-19 | 43.20 | 343.65 |
SO45233_1 | 6 | 11472 | 344 | 9 | 2022-05-24 | 85.00 | 2022-05-12 | 3399.99 | 1 | SO45233 | 2022-05-19 | 272.00 | 1912.15 |
SO56338_1 | 6 | 12005 | 577 | 9 | 2024-02-14 | 30.37 | 2024-02-02 | 1214.85 | 1 | SO56338 | 2024-02-09 | 97.19 | 755.15 |
SO62861_2 | 6 | 20253 | 477 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO62861 | 2024-05-19 | 0.40 | 1.87 |
SO69226_1 | 6 | 21567 | 378 | 9 | 2024-08-24 | 61.08 | 2024-08-12 | 2443.35 | 1 | SO69226 | 2024-08-19 | 195.47 | 1554.95 |
SO45236_1 | 6 | 18731 | 312 | 9 | 2022-05-25 | 89.46 | 2022-05-13 | 3578.27 | 1 | SO45236 | 2022-05-20 | 286.26 | 2171.29 |
SO56339_1 | 6 | 15128 | 539 | 9 | 2024-02-14 | 0.62 | 2024-02-02 | 24.99 | 1 | SO56339 | 2024-02-09 | 2.00 | 9.35 |
SO62861_3 | 6 | 20253 | 479 | 9 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 3 | SO62861 | 2024-05-19 | 0.72 | 3.36 |
SO69226_2 | 6 | 21567 | 529 | 9 | 2024-08-24 | 0.10 | 2024-08-12 | 3.99 | 2 | SO69226 | 2024-08-19 | 0.32 | 1.49 |
SO45237_1 | 6 | 18737 | 314 | 9 | 2022-05-25 | 89.46 | 2022-05-13 | 3578.27 | 1 | SO45237 | 2022-05-20 | 286.26 | 2171.29 |
SO56339_2 | 6 | 15128 | 480 | 9 | 2024-02-14 | 0.06 | 2024-02-02 | 2.29 | 2 | SO56339 | 2024-02-09 | 0.18 | 0.86 |
SO62862_1 | 6 | 24478 | 388 | 9 | 2024-05-24 | 28.01 | 2024-05-12 | 1120.49 | 1 | SO62862 | 2024-05-19 | 89.64 | 713.08 |
SO69226_3 | 6 | 21567 | 540 | 9 | 2024-08-24 | 0.82 | 2024-08-12 | 32.60 | 3 | SO69226 | 2024-08-19 | 2.61 | 12.19 |
SO45238_1 | 6 | 11459 | 346 | 9 | 2022-05-25 | 85.00 | 2022-05-13 | 3399.99 | 1 | SO45238 | 2022-05-20 | 272.00 | 1912.15 |
SO56340_1 | 6 | 17057 | 536 | 9 | 2024-02-14 | 0.75 | 2024-02-02 | 29.99 | 1 | SO56340 | 2024-02-09 | 2.40 | 11.22 |
SO62862_2 | 6 | 24478 | 222 | 9 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 2 | SO62862 | 2024-05-19 | 2.80 | 13.09 |
SO69226_4 | 6 | 21567 | 234 | 9 | 2024-08-24 | 1.25 | 2024-08-12 | 49.99 | 4 | SO69226 | 2024-08-19 | 4.00 | 38.49 |
Generated 2024-11-14 16:52:12.938 UTC