[ROOT] dt FactInternetSale < WHERE DimProductId EQ ALL < SKIP 435 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43805_1 | 100 | 14510 | 328 | 1 | 2021-11-16 | 17.48 | 2021-11-04 | 699.10 | 1 | SO43805 | 2021-11-11 | 55.93 | 413.15 | |
SO55603_3 | 6 | 27339 | 479 | 9 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 3 | SO55603 | 2024-01-22 | 0.72 | 3.36 | |
SO62149_1 | 100 | 23239 | 605 | 4 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62149 | 2024-05-03 | 43.20 | 343.65 | |
SO68687_3 | 98 | 13794 | 528 | 10 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 3 | SO68687 | 2024-08-08 | 0.40 | 1.87 | |
SO43806_1 | 6 | 16523 | 312 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43806 | 2021-11-11 | 286.26 | 2171.29 | |
SO55604_1 | 6 | 29289 | 573 | 9 | 2024-01-27 | 59.60 | 2024-01-15 | 2384.07 | 1 | SO55604 | 2024-01-22 | 190.73 | 1481.94 | |
SO62150_1 | 100 | 23195 | 584 | 1 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62150 | 2024-05-03 | 43.20 | 343.65 | |
SO68687_4 | 98 | 13794 | 222 | 10 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 4 | SO68687 | 2024-08-08 | 2.80 | 13.09 | |
SO43807_1 | 39 | 11611 | 312 | 7 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43807 | 2021-11-12 | 286.26 | 2171.29 | |
SO55604_2 | 6 | 29289 | 479 | 9 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55604 | 2024-01-22 | 0.72 | 3.36 | |
SO62150_2 | 100 | 23195 | 477 | 1 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 2 | SO62150 | 2024-05-03 | 0.40 | 1.87 | |
SO68688_1 | 98 | 18625 | 600 | 10 | 2024-08-13 | 13.50 | 2024-08-01 | 539.99 | 1 | SO68688 | 2024-08-08 | 43.20 | 294.58 | |
SO43808_1 | 29 | 13259 | 313 | 8 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43808 | 2021-11-12 | 286.26 | 2171.29 | |
SO55604_3 | 6 | 29289 | 477 | 9 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55604 | 2024-01-22 | 0.40 | 1.87 | |
SO62150_3 | 100 | 23195 | 479 | 1 | 2024-05-08 | 0.22 | 2024-04-26 | 8.99 | 3 | SO62150 | 2024-05-03 | 0.72 | 3.36 | |
SO68688_2 | 98 | 18625 | 535 | 10 | 2024-08-13 | 0.62 | 2024-08-01 | 24.99 | 2 | SO68688 | 2024-08-08 | 2.00 | 9.35 | |
SO43809_1 | 6 | 16350 | 310 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43809 | 2021-11-12 | 286.26 | 2171.29 | |
SO55604_4 | 6 | 29289 | 222 | 9 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 4 | SO55604 | 2024-01-22 | 2.80 | 13.09 | |
SO62150_4 | 100 | 23195 | 222 | 1 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 4 | SO62150 | 2024-05-03 | 2.80 | 13.09 | |
SO68688_3 | 98 | 18625 | 528 | 10 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 3 | SO68688 | 2024-08-08 | 0.40 | 1.87 | |
SO43810_1 | 6 | 11004 | 345 | 9 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43810 | 2021-11-12 | 272.00 | 1912.15 | |
SO55605_1 | 6 | 19094 | 378 | 9 | 2024-01-27 | 61.08 | 2024-01-15 | 2443.35 | 1 | SO55605 | 2024-01-22 | 195.47 | 1554.95 | |
SO62150_5 | 100 | 23195 | 234 | 1 | 2024-05-08 | 1.25 | 2024-04-26 | 49.99 | 5 | SO62150 | 2024-05-03 | 4.00 | 38.49 | |
SO68688_4 | 98 | 18625 | 480 | 2 | 10 | 2024-08-13 | 0.06 | 2024-08-01 | 2.29 | 4 | SO68688 | 2024-08-08 | 0.18 | 0.86 |
SO43811_1 | 6 | 11026 | 346 | 9 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43811 | 2021-11-12 | 272.00 | 1912.15 | |
SO55606_1 | 6 | 17280 | 380 | 9 | 2024-01-27 | 61.08 | 2024-01-15 | 2443.35 | 1 | SO55606 | 2024-01-22 | 195.47 | 1554.95 | |
SO62151_1 | 100 | 20395 | 388 | 4 | 2024-05-08 | 28.01 | 2024-04-26 | 1120.49 | 1 | SO62151 | 2024-05-03 | 89.64 | 713.08 | |
SO68689_1 | 100 | 11638 | 480 | 4 | 2024-08-13 | 0.06 | 2024-08-01 | 2.29 | 1 | SO68689 | 2024-08-08 | 0.18 | 0.86 | |
SO43812_1 | 100 | 27662 | 312 | 4 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO43812 | 2021-11-13 | 286.26 | 2171.29 | |
SO55606_2 | 6 | 17280 | 479 | 9 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55606 | 2024-01-22 | 0.72 | 3.36 | |
SO62151_2 | 100 | 20395 | 214 | 4 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62151 | 2024-05-03 | 2.80 | 13.09 | |
SO68690_1 | 100 | 29257 | 529 | 4 | 2024-08-13 | 0.10 | 2024-08-01 | 3.99 | 1 | SO68690 | 2024-08-08 | 0.32 | 1.49 | |
SO43813_1 | 39 | 28390 | 350 | 7 | 2021-11-18 | 84.37 | 2021-11-06 | 3374.99 | 1 | SO43813 | 2021-11-13 | 270.00 | 1898.09 | |
SO55606_3 | 6 | 17280 | 477 | 9 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55606 | 2024-01-22 | 0.40 | 1.87 | |
SO62151_3 | 100 | 20395 | 467 | 2 | 4 | 2024-05-08 | 0.61 | 2024-04-26 | 24.49 | 3 | SO62151 | 2024-05-03 | 1.96 | 9.16 |
SO68690_2 | 100 | 29257 | 480 | 4 | 2024-08-13 | 0.06 | 2024-08-01 | 2.29 | 2 | SO68690 | 2024-08-08 | 0.18 | 0.86 | |
SO43814_1 | 100 | 25866 | 350 | 1 | 2021-11-18 | 84.37 | 2021-11-06 | 3374.99 | 1 | SO43814 | 2021-11-13 | 270.00 | 1898.09 | |
SO55606_4 | 6 | 17280 | 491 | 9 | 2024-01-27 | 1.35 | 2024-01-15 | 53.99 | 4 | SO55606 | 2024-01-22 | 4.32 | 41.57 | |
SO62152_1 | 98 | 27121 | 604 | 10 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62152 | 2024-05-03 | 43.20 | 343.65 | |
SO68690_3 | 100 | 29257 | 486 | 4 | 2024-08-13 | 3.98 | 2024-08-01 | 159.00 | 3 | SO68690 | 2024-08-08 | 12.72 | 59.47 | |
SO43815_1 | 6 | 16494 | 311 | 9 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO43815 | 2021-11-13 | 286.26 | 2171.29 | |
SO55607_1 | 6 | 11977 | 353 | 9 | 2024-01-27 | 58.00 | 2024-01-15 | 2319.99 | 1 | SO55607 | 2024-01-22 | 185.60 | 1265.62 | |
SO62153_1 | 100 | 23898 | 605 | 8 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62153 | 2024-05-03 | 43.20 | 343.65 | |
SO68691_1 | 19 | 14077 | 535 | 6 | 2024-08-13 | 0.62 | 2024-08-01 | 24.99 | 1 | SO68691 | 2024-08-08 | 2.00 | 9.35 | |
SO43816_1 | 6 | 16496 | 314 | 9 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO43816 | 2021-11-13 | 286.26 | 2171.29 | |
SO55607_2 | 6 | 11977 | 485 | 9 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 2 | SO55607 | 2024-01-22 | 1.76 | 8.22 | |
SO62153_2 | 100 | 23898 | 473 | 8 | 2024-05-08 | 1.59 | 2024-04-26 | 63.50 | 2 | SO62153 | 2024-05-03 | 5.08 | 23.75 | |
SO68691_2 | 19 | 14077 | 463 | 6 | 2024-08-13 | 0.61 | 2024-08-01 | 24.49 | 2 | SO68691 | 2024-08-08 | 1.96 | 9.16 | |
SO43817_1 | 6 | 16519 | 310 | 9 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO43817 | 2021-11-13 | 286.26 | 2171.29 | |
SO55607_3 | 6 | 11977 | 481 | 9 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 3 | SO55607 | 2024-01-22 | 0.72 | 3.36 | |
SO62154_1 | 6 | 17229 | 590 | 9 | 2024-05-08 | 19.24 | 2024-04-26 | 769.49 | 1 | SO62154 | 2024-05-03 | 61.56 | 419.78 | |
SO68692_1 | 100 | 27988 | 530 | 4 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 1 | SO68692 | 2024-08-08 | 0.40 | 1.87 | |
SO43818_1 | 6 | 16528 | 312 | 9 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO43818 | 2021-11-13 | 286.26 | 2171.29 | |
SO55608_1 | 100 | 24784 | 564 | 4 | 2024-01-27 | 59.60 | 2024-01-15 | 2384.07 | 1 | SO55608 | 2024-01-22 | 190.73 | 1481.94 | |
SO62154_2 | 6 | 17229 | 476 | 9 | 2024-05-08 | 1.75 | 2024-04-26 | 69.99 | 2 | SO62154 | 2024-05-03 | 5.60 | 26.18 | |
SO68692_2 | 100 | 27988 | 480 | 2 | 4 | 2024-08-13 | 0.06 | 2024-08-01 | 2.29 | 2 | SO68692 | 2024-08-08 | 0.18 | 0.86 |
SO43819_1 | 6 | 11006 | 346 | 9 | 2021-11-18 | 85.00 | 2021-11-06 | 3399.99 | 1 | SO43819 | 2021-11-13 | 272.00 | 1912.15 | |
SO55608_2 | 100 | 24784 | 225 | 4 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55608 | 2024-01-22 | 0.72 | 6.92 | |
SO62154_3 | 6 | 17229 | 488 | 9 | 2024-05-08 | 1.35 | 2024-04-26 | 53.99 | 3 | SO62154 | 2024-05-03 | 4.32 | 41.57 | |
SO68693_1 | 100 | 28252 | 530 | 4 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 1 | SO68693 | 2024-08-08 | 0.40 | 1.87 |
Generated 2024-11-10 20:54:07.251 UTC