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