[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE < SKIP 2954 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45397_1 | 98 | 15051 | 313 | 10 | 2022-06-03 | 89.46 | 2022-05-22 | 3578.27 | 1 | SO45397 | 2022-05-29 | 286.26 | 2171.29 | |
SO57563_2 | 98 | 16198 | 463 | 10 | 2024-02-29 | 0.61 | 2024-02-17 | 24.49 | 2 | SO57563 | 2024-02-24 | 1.96 | 9.16 | |
SO48130_1 | 98 | 16829 | 368 | 10 | 2023-03-02 | 61.08 | 2023-02-18 | 2443.35 | 1 | SO48130 | 2023-02-25 | 195.47 | 1518.79 | |
SO70031_2 | 98 | 14929 | 485 | 10 | 2024-08-29 | 0.55 | 2024-08-17 | 21.98 | 2 | SO70031 | 2024-08-24 | 1.76 | 8.22 | |
SO68281_2 | 98 | 14159 | 485 | 10 | 2024-08-07 | 0.55 | 2024-07-26 | 21.98 | 2 | SO68281 | 2024-08-02 | 1.76 | 8.22 | |
SO65329_2 | 98 | 17225 | 480 | 10 | 2024-06-23 | 0.06 | 2024-06-11 | 2.29 | 2 | SO65329 | 2024-06-18 | 0.18 | 0.86 | |
SO65452_5 | 98 | 22429 | 225 | 10 | 2024-06-25 | 0.22 | 2024-06-13 | 8.99 | 5 | SO65452 | 2024-06-20 | 0.72 | 6.92 | |
SO53268_1 | 98 | 27904 | 538 | 10 | 2023-12-20 | 0.54 | 2023-12-08 | 21.49 | 1 | SO53268 | 2023-12-15 | 1.72 | 8.04 | |
SO60455_1 | 98 | 12460 | 359 | 10 | 2024-04-13 | 57.37 | 2024-04-01 | 2294.99 | 1 | SO60455 | 2024-04-08 | 183.60 | 1251.98 | |
SO44889_1 | 98 | 11351 | 348 | 10 | 2022-04-06 | 84.37 | 2022-03-25 | 3374.99 | 1 | SO44889 | 2022-04-01 | 270.00 | 1898.09 | |
SO51674_4 | 98 | 23597 | 480 | 10 | 2023-11-22 | 0.06 | 2023-11-10 | 2.29 | 4 | SO51674 | 2023-11-17 | 0.18 | 0.86 | |
SO64447_1 | 98 | 27140 | 606 | 2 | 10 | 2024-06-11 | 13.50 | 2024-05-30 | 539.99 | 1 | SO64447 | 2024-06-06 | 43.20 | 343.65 |
SO58346_3 | 98 | 26359 | 529 | 10 | 2024-03-14 | 0.10 | 2024-03-02 | 3.99 | 3 | SO58346 | 2024-03-09 | 0.32 | 1.49 | |
SO68147_3 | 98 | 28367 | 538 | 10 | 2024-08-04 | 0.54 | 2024-07-23 | 21.49 | 3 | SO68147 | 2024-07-30 | 1.72 | 8.04 | |
SO73987_3 | 98 | 13612 | 222 | 10 | 2024-10-20 | 0.87 | 2024-10-08 | 34.99 | 3 | SO73987 | 2024-10-15 | 2.80 | 13.09 | |
SO74400_3 | 100 | 13798 | 471 | 10 | 2024-10-30 | 1.59 | 2024-10-18 | 63.50 | 3 | SO74400 | 2024-10-25 | 5.08 | 23.75 | |
SO73689_4 | 98 | 13792 | 490 | 10 | 2024-10-16 | 1.35 | 2024-10-04 | 53.99 | 4 | SO73689 | 2024-10-11 | 4.32 | 41.57 | |
SO60083_1 | 98 | 12550 | 538 | 10 | 2024-04-07 | 0.54 | 2024-03-26 | 21.49 | 1 | SO60083 | 2024-04-02 | 1.72 | 8.04 | |
SO64415_3 | 98 | 16590 | 225 | 10 | 2024-06-11 | 0.22 | 2024-05-30 | 8.99 | 3 | SO64415 | 2024-06-06 | 0.72 | 6.92 | |
SO55384_3 | 98 | 12637 | 214 | 10 | 2024-01-24 | 0.87 | 2024-01-12 | 34.99 | 3 | SO55384 | 2024-01-19 | 2.80 | 13.09 | |
SO71047_2 | 98 | 18048 | 528 | 10 | 2024-09-12 | 0.12 | 2024-08-31 | 4.99 | 2 | SO71047 | 2024-09-07 | 0.40 | 1.87 | |
SO64344_2 | 98 | 13547 | 530 | 10 | 2024-06-10 | 0.12 | 2024-05-29 | 4.99 | 2 | SO64344 | 2024-06-05 | 0.40 | 1.87 | |
SO50364_1 | 98 | 21106 | 325 | 10 | 2023-08-26 | 19.57 | 2023-08-14 | 782.99 | 1 | SO50364 | 2023-08-21 | 62.64 | 486.71 | |
SO57953_3 | 98 | 11240 | 479 | 10 | 2024-03-07 | 0.22 | 2024-02-24 | 8.99 | 3 | SO57953 | 2024-03-02 | 0.72 | 3.36 | |
SO56777_2 | 98 | 12504 | 540 | 10 | 2024-02-18 | 0.82 | 2024-02-06 | 32.60 | 2 | SO56777 | 2024-02-13 | 2.61 | 12.19 | |
SO58670_1 | 98 | 22539 | 477 | 10 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 1 | SO58670 | 2024-03-15 | 0.40 | 1.87 | |
SO59530_2 | 98 | 13791 | 529 | 10 | 2024-03-30 | 0.10 | 2024-03-18 | 3.99 | 2 | SO59530 | 2024-03-25 | 0.32 | 1.49 | |
SO67014_2 | 98 | 16823 | 541 | 10 | 2024-07-19 | 0.72 | 2024-07-07 | 28.99 | 2 | SO67014 | 2024-07-14 | 2.32 | 10.84 | |
SO51394_1 | 98 | 19416 | 380 | 10 | 2023-11-05 | 61.08 | 2023-10-24 | 2443.35 | 1 | SO51394 | 2023-10-31 | 195.47 | 1554.95 | |
SO61891_2 | 98 | 24568 | 225 | 10 | 2024-05-04 | 0.22 | 2024-04-22 | 8.99 | 2 | SO61891 | 2024-04-29 | 0.72 | 6.92 | |
SO54014_2 | 98 | 12564 | 541 | 10 | 2023-12-31 | 0.72 | 2023-12-19 | 28.99 | 2 | SO54014 | 2023-12-26 | 2.32 | 10.84 | |
SO52454_3 | 98 | 11243 | 477 | 10 | 2023-12-04 | 0.12 | 2023-11-22 | 4.99 | 3 | SO52454 | 2023-11-29 | 0.40 | 1.87 | |
SO49280_1 | 98 | 17815 | 368 | 10 | 2023-06-06 | 61.08 | 2023-05-25 | 2443.35 | 1 | SO49280 | 2023-06-01 | 195.47 | 1518.79 | |
SO74403_4 | 100 | 22305 | 234 | 10 | 2024-10-30 | 1.25 | 2024-10-18 | 49.99 | 4 | SO74403 | 2024-10-25 | 4.00 | 38.49 | |
SO54286_3 | 98 | 20714 | 486 | 10 | 2024-01-05 | 3.98 | 2023-12-24 | 159.00 | 3 | SO54286 | 2023-12-31 | 12.72 | 59.47 | |
SO74772_3 | 100 | 21066 | 485 | 10 | 2024-11-11 | 0.55 | 2024-10-30 | 21.98 | 3 | SO74772 | 2024-11-06 | 1.76 | 8.22 | |
SO52553_1 | 98 | 25547 | 529 | 10 | 2023-12-06 | 0.10 | 2023-11-24 | 3.99 | 1 | SO52553 | 2023-12-01 | 0.32 | 1.49 | |
SO61572_3 | 98 | 12134 | 482 | 10 | 2024-04-29 | 0.22 | 2024-04-17 | 8.99 | 3 | SO61572 | 2024-04-24 | 0.72 | 3.36 | |
SO53431_1 | 98 | 19348 | 538 | 10 | 2023-12-23 | 0.54 | 2023-12-11 | 21.49 | 1 | SO53431 | 2023-12-18 | 1.72 | 8.04 | |
SO66045_2 | 98 | 18037 | 465 | 10 | 2024-07-04 | 0.61 | 2024-06-22 | 24.49 | 2 | SO66045 | 2024-06-29 | 1.96 | 9.16 | |
SO54265_2 | 98 | 19471 | 214 | 10 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 2 | SO54265 | 2023-12-31 | 2.80 | 13.09 | |
SO61297_3 | 98 | 12627 | 479 | 10 | 2024-04-24 | 0.22 | 2024-04-12 | 8.99 | 3 | SO61297 | 2024-04-19 | 0.72 | 3.36 | |
SO63688_2 | 98 | 24186 | 539 | 10 | 2024-05-30 | 0.62 | 2024-05-18 | 24.99 | 2 | SO63688 | 2024-05-25 | 2.00 | 9.35 | |
SO64375_4 | 98 | 27137 | 473 | 10 | 2024-06-10 | 1.59 | 2024-05-29 | 63.50 | 4 | SO64375 | 2024-06-05 | 5.08 | 23.75 | |
SO74208_2 | 100 | 24533 | 480 | 10 | 2024-10-24 | 0.06 | 2024-10-12 | 2.29 | 2 | SO74208 | 2024-10-19 | 0.18 | 0.86 | |
SO68749_1 | 98 | 19253 | 598 | 10 | 2024-08-14 | 13.50 | 2024-08-02 | 539.99 | 1 | SO68749 | 2024-08-09 | 43.20 | 294.58 | |
SO58586_3 | 98 | 12277 | 480 | 10 | 2024-03-19 | 0.06 | 2024-03-07 | 2.29 | 3 | SO58586 | 2024-03-14 | 0.18 | 0.86 | |
SO53131_1 | 98 | 27956 | 606 | 2 | 10 | 2023-12-17 | 13.50 | 2023-12-05 | 539.99 | 1 | SO53131 | 2023-12-12 | 43.20 | 343.65 |
SO72970_1 | 98 | 20569 | 357 | 10 | 2024-10-07 | 58.00 | 2024-09-25 | 2319.99 | 1 | SO72970 | 2024-10-02 | 185.60 | 1265.62 | |
SO56375_4 | 98 | 25659 | 480 | 10 | 2024-02-10 | 0.06 | 2024-01-29 | 2.29 | 4 | SO56375 | 2024-02-05 | 0.18 | 0.86 | |
SO62364_1 | 100 | 27007 | 529 | 10 | 2024-05-12 | 0.10 | 2024-04-30 | 3.99 | 1 | SO62364 | 2024-05-07 | 0.32 | 1.49 | |
SO44687_1 | 98 | 20172 | 342 | 10 | 2022-03-14 | 17.48 | 2022-03-02 | 699.10 | 1 | SO44687 | 2022-03-09 | 55.93 | 413.15 | |
SO62846_3 | 98 | 17710 | 225 | 10 | 2024-05-20 | 0.22 | 2024-05-08 | 8.99 | 3 | SO62846 | 2024-05-15 | 0.72 | 6.92 | |
SO56479_1 | 98 | 23904 | 390 | 10 | 2024-02-12 | 28.01 | 2024-01-31 | 1120.49 | 1 | SO56479 | 2024-02-07 | 89.64 | 713.08 | |
SO66328_2 | 98 | 20864 | 484 | 10 | 2024-07-09 | 0.20 | 2024-06-27 | 7.95 | 2 | SO66328 | 2024-07-04 | 0.64 | 2.97 | |
SO66176_2 | 98 | 19261 | 539 | 10 | 2024-07-06 | 0.62 | 2024-06-24 | 24.99 | 2 | SO66176 | 2024-07-01 | 2.00 | 9.35 |
Generated 2024-11-10 14:40:37.479 UTC