[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 433 > < TAKE 48 >
48 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45101_1 | 19 | 22748 | 313 | 6 | 2022-04-29 | 89.46 | 2022-04-17 | 3578.27 | 1 | SO45101 | 2022-04-24 | 286.26 | 2171.29 | |
SO45105_1 | 19 | 22765 | 312 | 6 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45105 | 2022-04-25 | 286.26 | 2171.29 | |
SO45106_1 | 19 | 19987 | 348 | 6 | 2022-04-30 | 84.37 | 2022-04-18 | 3374.99 | 1 | SO45106 | 2022-04-25 | 270.00 | 1898.09 | |
SO45108_1 | 19 | 22975 | 310 | 6 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45108 | 2022-04-25 | 286.26 | 2171.29 | |
SO45123_1 | 19 | 22971 | 311 | 6 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45123 | 2022-04-28 | 286.26 | 2171.29 | |
SO45134_1 | 19 | 22895 | 314 | 6 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45134 | 2022-04-30 | 286.26 | 2171.29 | |
SO45142_1 | 19 | 22901 | 311 | 6 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45142 | 2022-05-01 | 286.26 | 2171.29 | |
SO45165_1 | 19 | 22881 | 313 | 6 | 2022-05-10 | 89.46 | 2022-04-28 | 3578.27 | 1 | SO45165 | 2022-05-05 | 286.26 | 2171.29 | |
SO45193_1 | 19 | 22889 | 310 | 6 | 2022-05-14 | 89.46 | 2022-05-02 | 3578.27 | 1 | SO45193 | 2022-05-09 | 286.26 | 2171.29 | |
SO45208_1 | 19 | 19884 | 344 | 6 | 2022-05-16 | 85.00 | 2022-05-04 | 3399.99 | 1 | SO45208 | 2022-05-11 | 272.00 | 1912.15 | |
SO45219_1 | 19 | 22893 | 313 | 6 | 2022-05-18 | 89.46 | 2022-05-06 | 3578.27 | 1 | SO45219 | 2022-05-13 | 286.26 | 2171.29 | |
SO45221_1 | 19 | 22903 | 314 | 6 | 2022-05-18 | 89.46 | 2022-05-06 | 3578.27 | 1 | SO45221 | 2022-05-13 | 286.26 | 2171.29 | |
SO45252_1 | 19 | 22877 | 312 | 6 | 2022-05-24 | 89.46 | 2022-05-12 | 3578.27 | 1 | SO45252 | 2022-05-19 | 286.26 | 2171.29 | |
SO45346_1 | 100 | 28648 | 312 | 6 | 2022-05-26 | 89.46 | 2022-05-14 | 3578.27 | 1 | SO45346 | 2022-05-21 | 286.26 | 2171.29 | |
SO45353_1 | 100 | 28630 | 310 | 6 | 2022-05-27 | 89.46 | 2022-05-15 | 3578.27 | 1 | SO45353 | 2022-05-22 | 286.26 | 2171.29 | |
SO62494_1 | 19 | 18685 | 485 | 6 | 2024-05-14 | 0.55 | 2024-05-02 | 21.98 | 1 | SO62494 | 2024-05-09 | 1.76 | 8.22 | |
SO62494_2 | 19 | 18685 | 471 | 6 | 2024-05-14 | 1.59 | 2024-05-02 | 63.50 | 2 | SO62494 | 2024-05-09 | 5.08 | 23.75 | |
SO62495_1 | 19 | 20082 | 485 | 6 | 2024-05-14 | 0.55 | 2024-05-02 | 21.98 | 1 | SO62495 | 2024-05-09 | 1.76 | 8.22 | |
SO62495_2 | 19 | 20082 | 222 | 6 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 2 | SO62495 | 2024-05-09 | 2.80 | 13.09 | |
SO62507_1 | 19 | 12945 | 537 | 6 | 2024-05-14 | 0.88 | 2024-05-02 | 35.00 | 1 | SO62507 | 2024-05-09 | 2.80 | 13.09 | |
SO62507_2 | 19 | 12945 | 528 | 6 | 2024-05-14 | 0.12 | 2024-05-02 | 4.99 | 2 | SO62507 | 2024-05-09 | 0.40 | 1.87 | |
SO62507_3 | 19 | 12945 | 472 | 6 | 2024-05-14 | 1.59 | 2024-05-02 | 63.50 | 3 | SO62507 | 2024-05-09 | 5.08 | 23.75 | |
SO62507_4 | 19 | 12945 | 217 | 6 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 4 | SO62507 | 2024-05-09 | 2.80 | 13.09 | |
SO62525_1 | 19 | 26113 | 604 | 6 | 2024-05-14 | 13.50 | 2024-05-02 | 539.99 | 1 | SO62525 | 2024-05-09 | 43.20 | 343.65 | |
SO62525_2 | 19 | 26113 | 479 | 6 | 2024-05-14 | 0.22 | 2024-05-02 | 8.99 | 2 | SO62525 | 2024-05-09 | 0.72 | 3.36 | |
SO62542_1 | 19 | 11330 | 214 | 6 | 2024-05-15 | 0.87 | 2024-05-03 | 34.99 | 1 | SO62542 | 2024-05-10 | 2.80 | 13.09 | |
SO62543_1 | 19 | 11185 | 529 | 6 | 2024-05-15 | 0.10 | 2024-05-03 | 3.99 | 1 | SO62543 | 2024-05-10 | 0.32 | 1.49 | |
SO62543_2 | 19 | 11185 | 222 | 6 | 2024-05-15 | 0.87 | 2024-05-03 | 34.99 | 2 | SO62543 | 2024-05-10 | 2.80 | 13.09 | |
SO62544_1 | 19 | 11287 | 539 | 6 | 2024-05-15 | 0.62 | 2024-05-03 | 24.99 | 1 | SO62544 | 2024-05-10 | 2.00 | 9.35 | |
SO62544_2 | 19 | 11287 | 529 | 6 | 2024-05-15 | 0.10 | 2024-05-03 | 3.99 | 2 | SO62544 | 2024-05-10 | 0.32 | 1.49 | |
SO62544_3 | 19 | 11287 | 480 | 6 | 2024-05-15 | 0.06 | 2024-05-03 | 2.29 | 3 | SO62544 | 2024-05-10 | 0.18 | 0.86 | |
SO62545_1 | 19 | 19220 | 538 | 6 | 2024-05-15 | 0.54 | 2024-05-03 | 21.49 | 1 | SO62545 | 2024-05-10 | 1.72 | 8.04 | |
SO62545_2 | 19 | 19220 | 529 | 6 | 2024-05-15 | 0.10 | 2024-05-03 | 3.99 | 2 | SO62545 | 2024-05-10 | 0.32 | 1.49 | |
SO62545_3 | 19 | 19220 | 480 | 6 | 2024-05-15 | 0.06 | 2024-05-03 | 2.29 | 3 | SO62545 | 2024-05-10 | 0.18 | 0.86 | |
SO62546_1 | 19 | 11276 | 541 | 6 | 2024-05-15 | 0.72 | 2024-05-03 | 28.99 | 1 | SO62546 | 2024-05-10 | 2.32 | 10.84 | |
SO62547_1 | 19 | 11808 | 535 | 6 | 2024-05-15 | 0.62 | 2024-05-03 | 24.99 | 1 | SO62547 | 2024-05-10 | 2.00 | 9.35 | |
SO62547_2 | 19 | 11808 | 222 | 6 | 2024-05-15 | 0.87 | 2024-05-03 | 34.99 | 2 | SO62547 | 2024-05-10 | 2.80 | 13.09 | |
SO62549_1 | 19 | 17348 | 528 | 6 | 2024-05-15 | 0.12 | 2024-05-03 | 4.99 | 1 | SO62549 | 2024-05-10 | 0.40 | 1.87 | |
SO62549_2 | 19 | 17348 | 536 | 6 | 2024-05-15 | 0.75 | 2024-05-03 | 29.99 | 2 | SO62549 | 2024-05-10 | 2.40 | 11.22 | |
SO62550_1 | 19 | 12054 | 540 | 6 | 2024-05-15 | 0.82 | 2024-05-03 | 32.60 | 1 | SO62550 | 2024-05-10 | 2.61 | 12.19 | |
SO62550_2 | 19 | 12054 | 483 | 6 | 2024-05-15 | 3.00 | 2024-05-03 | 120.00 | 2 | SO62550 | 2024-05-10 | 9.60 | 44.88 | |
SO62551_1 | 19 | 13185 | 540 | 6 | 2024-05-15 | 0.82 | 2024-05-03 | 32.60 | 1 | SO62551 | 2024-05-10 | 2.61 | 12.19 | |
SO62552_1 | 19 | 11724 | 536 | 6 | 2024-05-15 | 0.75 | 2024-05-03 | 29.99 | 1 | SO62552 | 2024-05-10 | 2.40 | 11.22 | |
SO62552_2 | 19 | 11724 | 480 | 2 | 6 | 2024-05-15 | 0.06 | 2024-05-03 | 2.29 | 2 | SO62552 | 2024-05-10 | 0.18 | 0.86 |
SO62554_1 | 19 | 22983 | 528 | 6 | 2024-05-15 | 0.12 | 2024-05-03 | 4.99 | 1 | SO62554 | 2024-05-10 | 0.40 | 1.87 | |
SO62554_2 | 19 | 22983 | 480 | 2 | 6 | 2024-05-15 | 0.06 | 2024-05-03 | 2.29 | 2 | SO62554 | 2024-05-10 | 0.18 | 0.86 |
SO62560_1 | 19 | 11330 | 528 | 6 | 2024-05-15 | 0.12 | 2024-05-03 | 4.99 | 1 | SO62560 | 2024-05-10 | 0.40 | 1.87 | |
SO62560_2 | 19 | 11330 | 537 | 6 | 2024-05-15 | 0.88 | 2024-05-03 | 35.00 | 2 | SO62560 | 2024-05-10 | 2.80 | 13.09 |
Generated 2024-11-10 14:06:07.809 UTC