[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 500 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45462_1 | 100 | 28647 | 310 | 6 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO45462 | 2022-02-01 | 286.26 | 2171.29 | |
SO56033_3 | 19 | 16717 | 480 | 6 | 2023-09-29 | 0.06 | 2023-09-17 | 2.29 | 3 | SO56033 | 2023-09-24 | 0.18 | 0.86 | |
SO62554_1 | 19 | 22983 | 528 | 6 | 2024-01-08 | 0.12 | 2023-12-27 | 4.99 | 1 | SO62554 | 2024-01-03 | 0.40 | 1.87 | |
SO68993_4 | 19 | 14626 | 231 | 6 | 2024-04-11 | 1.25 | 2024-03-30 | 49.99 | 4 | SO68993 | 2024-04-06 | 4.00 | 38.49 | |
SO45468_1 | 19 | 23164 | 311 | 6 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO45468 | 2022-02-03 | 286.26 | 2171.29 | |
SO56036_1 | 19 | 11808 | 528 | 6 | 2023-09-29 | 0.12 | 2023-09-17 | 4.99 | 1 | SO56036 | 2023-09-24 | 0.40 | 1.87 | |
SO62554_2 | 19 | 22983 | 480 | 2 | 6 | 2024-01-08 | 0.06 | 2023-12-27 | 2.29 | 2 | SO62554 | 2024-01-03 | 0.18 | 0.86 |
SO68993_5 | 19 | 14626 | 465 | 6 | 2024-04-11 | 0.61 | 2024-03-30 | 24.49 | 5 | SO68993 | 2024-04-06 | 1.96 | 9.16 | |
SO45469_1 | 19 | 19989 | 350 | 6 | 2022-02-08 | 84.37 | 2022-01-27 | 3374.99 | 1 | SO45469 | 2022-02-03 | 270.00 | 1898.09 | |
SO56036_2 | 19 | 11808 | 536 | 6 | 2023-09-29 | 0.75 | 2023-09-17 | 29.99 | 2 | SO56036 | 2023-09-24 | 2.40 | 11.22 | |
SO62560_1 | 19 | 11330 | 528 | 6 | 2024-01-08 | 0.12 | 2023-12-27 | 4.99 | 1 | SO62560 | 2024-01-03 | 0.40 | 1.87 | |
SO69009_1 | 19 | 15176 | 563 | 6 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO69009 | 2024-04-06 | 190.73 | 1481.94 | |
SO45470_1 | 100 | 28177 | 312 | 6 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO45470 | 2022-02-03 | 286.26 | 2171.29 | |
SO56036_3 | 19 | 11808 | 214 | 6 | 2023-09-29 | 0.87 | 2023-09-17 | 34.99 | 3 | SO56036 | 2023-09-24 | 2.80 | 13.09 | |
SO62560_2 | 19 | 11330 | 537 | 6 | 2024-01-08 | 0.88 | 2023-12-27 | 35.00 | 2 | SO62560 | 2024-01-03 | 2.80 | 13.09 | |
SO69009_2 | 19 | 15176 | 479 | 6 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 2 | SO69009 | 2024-04-06 | 0.72 | 3.36 | |
SO45484_1 | 19 | 23267 | 313 | 6 | 2022-02-10 | 89.46 | 2022-01-29 | 3578.27 | 1 | SO45484 | 2022-02-05 | 286.26 | 2171.29 | |
SO56037_1 | 19 | 11203 | 528 | 6 | 2023-09-29 | 0.12 | 2023-09-17 | 4.99 | 1 | SO56037 | 2023-09-24 | 0.40 | 1.87 | |
SO62568_1 | 19 | 13249 | 563 | 6 | 2024-01-08 | 59.60 | 2023-12-27 | 2384.07 | 1 | SO62568 | 2024-01-03 | 190.73 | 1481.94 | |
SO69011_1 | 19 | 23868 | 560 | 6 | 2024-04-11 | 30.37 | 2024-03-30 | 1214.85 | 1 | SO69011 | 2024-04-06 | 97.19 | 755.15 | |
SO45490_1 | 19 | 22976 | 313 | 6 | 2022-02-10 | 89.46 | 2022-01-29 | 3578.27 | 1 | SO45490 | 2022-02-05 | 286.26 | 2171.29 | |
SO56037_2 | 19 | 11203 | 536 | 6 | 2023-09-29 | 0.75 | 2023-09-17 | 29.99 | 2 | SO56037 | 2023-09-24 | 2.40 | 11.22 | |
SO62568_2 | 19 | 13249 | 488 | 6 | 2024-01-08 | 1.35 | 2023-12-27 | 53.99 | 2 | SO62568 | 2024-01-03 | 4.32 | 41.57 | |
SO69011_2 | 19 | 23868 | 530 | 6 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 2 | SO69011 | 2024-04-06 | 0.40 | 1.87 | |
SO45491_1 | 100 | 27672 | 311 | 6 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO45491 | 2022-02-06 | 286.26 | 2171.29 | |
SO56037_3 | 19 | 11203 | 480 | 6 | 2023-09-29 | 0.06 | 2023-09-17 | 2.29 | 3 | SO56037 | 2023-09-24 | 0.18 | 0.86 | |
SO62593_1 | 19 | 11200 | 538 | 6 | 2024-01-09 | 0.54 | 2023-12-28 | 21.49 | 1 | SO62593 | 2024-01-04 | 1.72 | 8.04 | |
SO69011_3 | 19 | 23868 | 541 | 6 | 2024-04-11 | 0.72 | 2024-03-30 | 28.99 | 3 | SO69011 | 2024-04-06 | 2.32 | 10.84 | |
SO45496_1 | 100 | 29340 | 314 | 6 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO45496 | 2022-02-07 | 286.26 | 2171.29 | |
SO56039_1 | 19 | 11651 | 528 | 6 | 2023-09-29 | 0.12 | 2023-09-17 | 4.99 | 1 | SO56039 | 2023-09-24 | 0.40 | 1.87 | |
SO62597_1 | 19 | 11091 | 529 | 6 | 2024-01-09 | 0.10 | 2023-12-28 | 3.99 | 1 | SO62597 | 2024-01-04 | 0.32 | 1.49 | |
SO69011_4 | 19 | 23868 | 480 | 6 | 2024-04-11 | 0.06 | 2024-03-30 | 2.29 | 4 | SO69011 | 2024-04-06 | 0.18 | 0.86 | |
SO45497_1 | 100 | 28354 | 311 | 6 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO45497 | 2022-02-07 | 286.26 | 2171.29 | |
SO56039_2 | 19 | 11651 | 536 | 6 | 2023-09-29 | 0.75 | 2023-09-17 | 29.99 | 2 | SO56039 | 2023-09-24 | 2.40 | 11.22 | |
SO62597_2 | 19 | 11091 | 540 | 6 | 2024-01-09 | 0.82 | 2023-12-28 | 32.60 | 2 | SO62597 | 2024-01-04 | 2.61 | 12.19 | |
SO69033_1 | 19 | 11262 | 529 | 6 | 2024-04-12 | 0.10 | 2024-03-31 | 3.99 | 1 | SO69033 | 2024-04-07 | 0.32 | 1.49 | |
SO45498_1 | 100 | 28574 | 312 | 6 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO45498 | 2022-02-07 | 286.26 | 2171.29 | |
SO56040_1 | 19 | 17481 | 536 | 6 | 2023-09-29 | 0.75 | 2023-09-17 | 29.99 | 1 | SO56040 | 2023-09-24 | 2.40 | 11.22 | |
SO62597_3 | 19 | 11091 | 225 | 6 | 2024-01-09 | 0.22 | 2023-12-28 | 8.99 | 3 | SO62597 | 2024-01-04 | 0.72 | 6.92 | |
SO69033_2 | 19 | 11262 | 214 | 6 | 2024-04-12 | 0.87 | 2024-03-31 | 34.99 | 2 | SO69033 | 2024-04-07 | 2.80 | 13.09 | |
SO45499_1 | 100 | 28626 | 314 | 6 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO45499 | 2022-02-07 | 286.26 | 2171.29 | |
SO56040_2 | 19 | 17481 | 528 | 6 | 2023-09-29 | 0.12 | 2023-09-17 | 4.99 | 2 | SO56040 | 2023-09-24 | 0.40 | 1.87 | |
SO62597_4 | 19 | 11091 | 488 | 6 | 2024-01-09 | 1.35 | 2023-12-28 | 53.99 | 4 | SO62597 | 2024-01-04 | 4.32 | 41.57 | |
SO69035_1 | 19 | 13095 | 541 | 6 | 2024-04-12 | 0.72 | 2024-03-31 | 28.99 | 1 | SO69035 | 2024-04-07 | 2.32 | 10.84 | |
SO45502_1 | 100 | 28173 | 314 | 6 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO45502 | 2022-02-07 | 286.26 | 2171.29 | |
SO56040_3 | 19 | 17481 | 217 | 6 | 2023-09-29 | 0.87 | 2023-09-17 | 34.99 | 3 | SO56040 | 2023-09-24 | 2.80 | 13.09 | |
SO62602_1 | 19 | 20070 | 528 | 6 | 2024-01-09 | 0.12 | 2023-12-28 | 4.99 | 1 | SO62602 | 2024-01-04 | 0.40 | 1.87 | |
SO69035_2 | 19 | 13095 | 530 | 6 | 2024-04-12 | 0.12 | 2024-03-31 | 4.99 | 2 | SO69035 | 2024-04-07 | 0.40 | 1.87 | |
SO45503_1 | 19 | 22995 | 314 | 6 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO45503 | 2022-02-07 | 286.26 | 2171.29 | |
SO56042_1 | 19 | 14633 | 477 | 6 | 2023-09-29 | 0.12 | 2023-09-17 | 4.99 | 1 | SO56042 | 2023-09-24 | 0.40 | 1.87 | |
SO62602_2 | 19 | 20070 | 214 | 6 | 2024-01-09 | 0.87 | 2023-12-28 | 34.99 | 2 | SO62602 | 2024-01-04 | 2.80 | 13.09 | |
SO69035_3 | 19 | 13095 | 487 | 6 | 2024-04-12 | 1.37 | 2024-03-31 | 54.99 | 3 | SO69035 | 2024-04-07 | 4.40 | 20.57 | |
SO45510_1 | 19 | 22998 | 310 | 6 | 2022-02-13 | 89.46 | 2022-02-01 | 3578.27 | 1 | SO45510 | 2022-02-08 | 286.26 | 2171.29 | |
SO56042_2 | 19 | 14633 | 478 | 6 | 2023-09-29 | 0.25 | 2023-09-17 | 9.99 | 2 | SO56042 | 2023-09-24 | 0.80 | 3.74 | |
SO62604_1 | 19 | 18411 | 485 | 6 | 2024-01-09 | 0.55 | 2023-12-28 | 21.98 | 1 | SO62604 | 2024-01-04 | 1.76 | 8.22 | |
SO69039_1 | 19 | 12166 | 528 | 6 | 2024-04-12 | 0.12 | 2024-03-31 | 4.99 | 1 | SO69039 | 2024-04-07 | 0.40 | 1.87 | |
SO45514_1 | 100 | 28051 | 314 | 6 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO45514 | 2022-02-09 | 286.26 | 2171.29 | |
SO56042_3 | 19 | 14633 | 481 | 6 | 2023-09-29 | 0.22 | 2023-09-17 | 8.99 | 3 | SO56042 | 2023-09-24 | 0.72 | 3.36 | |
SO62609_1 | 19 | 16247 | 485 | 6 | 2024-01-09 | 0.55 | 2023-12-28 | 21.98 | 1 | SO62609 | 2024-01-04 | 1.76 | 8.22 | |
SO69039_2 | 19 | 12166 | 536 | 6 | 2024-04-12 | 0.75 | 2024-03-31 | 29.99 | 2 | SO69039 | 2024-04-07 | 2.40 | 11.22 | |
SO45582_1 | 100 | 28656 | 312 | 6 | 2022-02-15 | 89.46 | 2022-02-03 | 3578.27 | 1 | SO45582 | 2022-02-10 | 286.26 | 2171.29 | |
SO56044_1 | 19 | 11200 | 478 | 6 | 2023-09-29 | 0.25 | 2023-09-17 | 9.99 | 1 | SO56044 | 2023-09-24 | 0.80 | 3.74 |
Generated 2024-07-05 14:51:13.183 UTC