[ROOT] dt FactInternetSale < WHERE DimProductId EQ ALL < SKIP 4169 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45107_1 | 100 | 29275 | 312 | 4 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45107 | 2022-04-25 | 286.26 | 2171.29 |
SO55969_2 | 100 | 13256 | 478 | 8 | 2024-02-03 | 0.25 | 2024-01-22 | 9.99 | 2 | SO55969 | 2024-01-29 | 0.80 | 3.74 |
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 |
SO69072_2 | 6 | 15596 | 485 | 9 | 2024-08-18 | 0.55 | 2024-08-06 | 21.98 | 2 | SO69072 | 2024-08-13 | 1.76 | 8.22 |
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 |
SO55969_3 | 100 | 13256 | 477 | 8 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 3 | SO55969 | 2024-01-29 | 0.40 | 1.87 |
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 |
SO69072_3 | 6 | 15596 | 478 | 9 | 2024-08-18 | 0.25 | 2024-08-06 | 9.99 | 3 | SO69072 | 2024-08-13 | 0.80 | 3.74 |
SO45109_1 | 98 | 14937 | 311 | 10 | 2022-05-01 | 89.46 | 2022-04-19 | 3578.27 | 1 | SO45109 | 2022-04-26 | 286.26 | 2171.29 |
SO55969_4 | 100 | 13256 | 217 | 8 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 4 | SO55969 | 2024-01-29 | 2.80 | 13.09 |
SO62526_1 | 100 | 22770 | 604 | 4 | 2024-05-14 | 13.50 | 2024-05-02 | 539.99 | 1 | SO62526 | 2024-05-09 | 43.20 | 343.65 |
SO69072_4 | 6 | 15596 | 477 | 9 | 2024-08-18 | 0.12 | 2024-08-06 | 4.99 | 4 | SO69072 | 2024-08-13 | 0.40 | 1.87 |
SO45110_1 | 6 | 18710 | 311 | 9 | 2022-05-01 | 89.46 | 2022-04-19 | 3578.27 | 1 | SO45110 | 2022-04-26 | 286.26 | 2171.29 |
SO55970_1 | 98 | 11610 | 361 | 10 | 2024-02-03 | 57.37 | 2024-01-22 | 2294.99 | 1 | SO55970 | 2024-01-29 | 183.60 | 1251.98 |
SO62527_1 | 100 | 20702 | 583 | 4 | 2024-05-14 | 42.52 | 2024-05-02 | 1700.99 | 1 | SO62527 | 2024-05-09 | 136.08 | 1082.51 |
SO69072_5 | 6 | 15596 | 488 | 9 | 2024-08-18 | 1.35 | 2024-08-06 | 53.99 | 5 | SO69072 | 2024-08-13 | 4.32 | 41.57 |
SO45111_1 | 6 | 25713 | 326 | 9 | 2022-05-01 | 17.48 | 2022-04-19 | 699.10 | 1 | SO45111 | 2022-04-26 | 55.93 | 413.15 |
SO55970_2 | 98 | 11610 | 485 | 10 | 2024-02-03 | 0.55 | 2024-01-22 | 21.98 | 2 | SO55970 | 2024-01-29 | 1.76 | 8.22 |
SO62527_2 | 100 | 20702 | 237 | 4 | 2024-05-14 | 1.25 | 2024-05-02 | 49.99 | 2 | SO62527 | 2024-05-09 | 4.00 | 38.49 |
SO69073_1 | 6 | 18198 | 597 | 9 | 2024-08-18 | 13.50 | 2024-08-06 | 539.99 | 1 | SO69073 | 2024-08-13 | 43.20 | 294.58 |
SO45112_1 | 98 | 20558 | 324 | 10 | 2022-05-01 | 17.48 | 2022-04-19 | 699.10 | 1 | SO45112 | 2022-04-26 | 55.93 | 413.15 |
SO55971_1 | 100 | 11880 | 484 | 1 | 2024-02-03 | 0.20 | 2024-01-22 | 7.95 | 1 | SO55971 | 2024-01-29 | 0.64 | 2.97 |
SO62528_1 | 98 | 24048 | 384 | 10 | 2024-05-14 | 28.01 | 2024-05-02 | 1120.49 | 1 | SO62528 | 2024-05-09 | 89.64 | 713.08 |
SO69073_2 | 6 | 18198 | 535 | 9 | 2024-08-18 | 0.62 | 2024-08-06 | 24.99 | 2 | SO69073 | 2024-08-13 | 2.00 | 9.35 |
SO45113_1 | 100 | 29141 | 313 | 4 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45113 | 2022-04-27 | 286.26 | 2171.29 |
SO55972_1 | 6 | 13639 | 528 | 9 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 1 | SO55972 | 2024-01-29 | 0.40 | 1.87 |
SO62528_2 | 98 | 24048 | 489 | 10 | 2024-05-14 | 1.35 | 2024-05-02 | 53.99 | 2 | SO62528 | 2024-05-09 | 4.32 | 41.57 |
SO69074_1 | 100 | 27117 | 574 | 1 | 2024-08-18 | 59.60 | 2024-08-06 | 2384.07 | 1 | SO69074 | 2024-08-13 | 190.73 | 1481.94 |
SO45114_1 | 100 | 29146 | 310 | 1 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45114 | 2022-04-27 | 286.26 | 2171.29 |
SO55972_2 | 6 | 13639 | 535 | 9 | 2024-02-03 | 0.62 | 2024-01-22 | 24.99 | 2 | SO55972 | 2024-01-29 | 2.00 | 9.35 |
SO62529_1 | 100 | 27811 | 384 | 8 | 2024-05-14 | 28.01 | 2024-05-02 | 1120.49 | 1 | SO62529 | 2024-05-09 | 89.64 | 713.08 |
SO69074_2 | 100 | 27117 | 222 | 1 | 2024-08-18 | 0.87 | 2024-08-06 | 34.99 | 2 | SO69074 | 2024-08-13 | 2.80 | 13.09 |
SO45115_1 | 100 | 25984 | 348 | 4 | 2022-05-02 | 84.37 | 2022-04-20 | 3374.99 | 1 | SO45115 | 2022-04-27 | 270.00 | 1898.09 |
SO55972_3 | 6 | 13639 | 214 | 9 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 3 | SO55972 | 2024-01-29 | 2.80 | 13.09 |
SO62529_2 | 100 | 27811 | 222 | 8 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 2 | SO62529 | 2024-05-09 | 2.80 | 13.09 |
SO69075_1 | 100 | 27287 | 561 | 4 | 2024-08-18 | 59.60 | 2024-08-06 | 2384.07 | 1 | SO69075 | 2024-08-13 | 190.73 | 1481.94 |
SO45116_1 | 100 | 29204 | 311 | 1 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45116 | 2022-04-27 | 286.26 | 2171.29 |
SO55973_1 | 6 | 11045 | 528 | 9 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 1 | SO55973 | 2024-01-29 | 0.40 | 1.87 |
SO62530_1 | 6 | 11907 | 573 | 9 | 2024-05-14 | 59.60 | 2024-05-02 | 2384.07 | 1 | SO62530 | 2024-05-09 | 190.73 | 1481.94 |
SO69075_2 | 100 | 27287 | 541 | 4 | 2024-08-18 | 0.72 | 2024-08-06 | 28.99 | 2 | SO69075 | 2024-08-13 | 2.32 | 10.84 |
SO45117_1 | 100 | 14727 | 342 | 1 | 2022-05-02 | 17.48 | 2022-04-20 | 699.10 | 1 | SO45117 | 2022-04-27 | 55.93 | 413.15 |
SO55973_2 | 6 | 11045 | 535 | 9 | 2024-02-03 | 0.62 | 2024-01-22 | 24.99 | 2 | SO55973 | 2024-01-29 | 2.00 | 9.35 |
SO62530_2 | 6 | 11907 | 489 | 9 | 2024-05-14 | 1.35 | 2024-05-02 | 53.99 | 2 | SO62530 | 2024-05-09 | 4.32 | 41.57 |
SO69076_1 | 100 | 25970 | 560 | 1 | 2024-08-18 | 30.37 | 2024-08-06 | 1214.85 | 1 | SO69076 | 2024-08-13 | 97.19 | 755.15 |
SO45118_1 | 6 | 18722 | 314 | 9 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45118 | 2022-04-27 | 286.26 | 2171.29 |
SO55973_3 | 6 | 11045 | 222 | 9 | 2024-02-03 | 0.87 | 2024-01-22 | 34.99 | 3 | SO55973 | 2024-01-29 | 2.80 | 13.09 |
SO62531_1 | 100 | 12893 | 479 | 4 | 2024-05-15 | 0.22 | 2024-05-03 | 8.99 | 1 | SO62531 | 2024-05-10 | 0.72 | 3.36 |
SO69076_2 | 100 | 25970 | 479 | 1 | 2024-08-18 | 0.22 | 2024-08-06 | 8.99 | 2 | SO69076 | 2024-08-13 | 0.72 | 3.36 |
SO45119_1 | 6 | 18740 | 314 | 9 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45119 | 2022-04-27 | 286.26 | 2171.29 |
SO55974_1 | 6 | 16692 | 539 | 9 | 2024-02-03 | 0.62 | 2024-01-22 | 24.99 | 1 | SO55974 | 2024-01-29 | 2.00 | 9.35 |
SO62531_2 | 100 | 12893 | 477 | 4 | 2024-05-15 | 0.12 | 2024-05-03 | 4.99 | 2 | SO62531 | 2024-05-10 | 0.40 | 1.87 |
SO69076_3 | 100 | 25970 | 477 | 1 | 2024-08-18 | 0.12 | 2024-08-06 | 4.99 | 3 | SO69076 | 2024-08-13 | 0.40 | 1.87 |
SO45120_1 | 6 | 11751 | 344 | 9 | 2022-05-02 | 85.00 | 2022-04-20 | 3399.99 | 1 | SO45120 | 2022-04-27 | 272.00 | 1912.15 |
SO55975_1 | 6 | 20602 | 538 | 9 | 2024-02-03 | 0.54 | 2024-01-22 | 21.49 | 1 | SO55975 | 2024-01-29 | 1.72 | 8.04 |
SO62532_1 | 6 | 16619 | 536 | 9 | 2024-05-15 | 0.75 | 2024-05-03 | 29.99 | 1 | SO62532 | 2024-05-10 | 2.40 | 11.22 |
SO69077_1 | 100 | 25985 | 577 | 4 | 2024-08-18 | 30.37 | 2024-08-06 | 1214.85 | 1 | SO69077 | 2024-08-13 | 97.19 | 755.15 |
SO45121_1 | 100 | 29169 | 310 | 1 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45121 | 2022-04-28 | 286.26 | 2171.29 |
SO55975_2 | 6 | 20602 | 529 | 9 | 2024-02-03 | 0.10 | 2024-01-22 | 3.99 | 2 | SO55975 | 2024-01-29 | 0.32 | 1.49 |
SO62533_1 | 6 | 21175 | 537 | 9 | 2024-05-15 | 0.88 | 2024-05-03 | 35.00 | 1 | SO62533 | 2024-05-10 | 2.80 | 13.09 |
SO69077_2 | 100 | 25985 | 541 | 4 | 2024-08-18 | 0.72 | 2024-08-06 | 28.99 | 2 | SO69077 | 2024-08-13 | 2.32 | 10.84 |
SO45122_1 | 100 | 29236 | 314 | 4 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45122 | 2022-04-28 | 286.26 | 2171.29 |
SO55975_3 | 6 | 20602 | 487 | 9 | 2024-02-03 | 1.37 | 2024-01-22 | 54.99 | 3 | SO55975 | 2024-01-29 | 4.40 | 20.57 |
Generated 2024-11-10 19:58:04.604 UTC