[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 < SKIP 1091 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO62763_2 | 100 | 17830 | 231 | 7 | 2024-05-19 | 1.25 | 2024-05-07 | 49.99 | 2 | SO62763 | 2024-05-14 | 4.00 | 38.49 | |
SO68737_1 | 6 | 12687 | 562 | 9 | 2024-08-13 | 59.60 | 2024-08-01 | 2384.07 | 1 | SO68737 | 2024-08-08 | 190.73 | 1481.94 | |
SO45865_1 | 6 | 20157 | 312 | 9 | 2022-08-01 | 89.46 | 2022-07-20 | 3578.27 | 1 | SO45865 | 2022-07-27 | 286.26 | 2171.29 | |
SO56201_2 | 100 | 18675 | 482 | 4 | 2024-02-07 | 0.22 | 2024-01-26 | 8.99 | 2 | SO56201 | 2024-02-02 | 0.72 | 3.36 | |
SO62764_1 | 100 | 17928 | 582 | 8 | 2024-05-19 | 42.52 | 2024-05-07 | 1700.99 | 1 | SO62764 | 2024-05-14 | 136.08 | 1082.51 | |
SO68738_1 | 6 | 12999 | 561 | 9 | 2024-08-13 | 59.60 | 2024-08-01 | 2384.07 | 1 | SO68738 | 2024-08-08 | 190.73 | 1481.94 | |
SO45866_1 | 98 | 15621 | 310 | 10 | 2022-08-01 | 89.46 | 2022-07-20 | 3578.27 | 1 | SO45866 | 2022-07-27 | 286.26 | 2171.29 | |
SO56201_3 | 100 | 18675 | 228 | 4 | 2024-02-07 | 1.25 | 2024-01-26 | 49.99 | 3 | SO56201 | 2024-02-02 | 4.00 | 38.49 | |
SO62764_2 | 100 | 17928 | 222 | 8 | 2024-05-19 | 0.87 | 2024-05-07 | 34.99 | 2 | SO62764 | 2024-05-14 | 2.80 | 13.09 | |
SO68738_2 | 6 | 12999 | 214 | 9 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 2 | SO68738 | 2024-08-08 | 2.80 | 13.09 | |
SO45867_1 | 100 | 11772 | 312 | 1 | 2022-08-02 | 89.46 | 2022-07-21 | 3578.27 | 1 | SO45867 | 2022-07-28 | 286.26 | 2171.29 | |
SO56202_1 | 19 | 25347 | 477 | 6 | 2024-02-07 | 0.12 | 2024-01-26 | 4.99 | 1 | SO56202 | 2024-02-02 | 0.40 | 1.87 | |
SO62765_1 | 98 | 24865 | 372 | 10 | 2024-05-19 | 61.08 | 2024-05-07 | 2443.35 | 1 | SO62765 | 2024-05-14 | 195.47 | 1554.95 | |
SO68739_1 | 6 | 14517 | 539 | 9 | 2024-08-14 | 0.62 | 2024-08-02 | 24.99 | 1 | SO68739 | 2024-08-09 | 2.00 | 9.35 | |
SO45868_1 | 100 | 14819 | 310 | 8 | 2022-08-02 | 89.46 | 2022-07-21 | 3578.27 | 1 | SO45868 | 2022-07-28 | 286.26 | 2171.29 | |
SO56202_2 | 19 | 25347 | 487 | 6 | 2024-02-07 | 1.37 | 2024-01-26 | 54.99 | 2 | SO56202 | 2024-02-02 | 4.40 | 20.57 | |
SO62765_2 | 98 | 24865 | 214 | 10 | 2024-05-19 | 0.87 | 2024-05-07 | 34.99 | 2 | SO62765 | 2024-05-14 | 2.80 | 13.09 | |
SO68739_2 | 6 | 14517 | 529 | 9 | 2024-08-14 | 0.10 | 2024-08-02 | 3.99 | 2 | SO68739 | 2024-08-09 | 0.32 | 1.49 | |
SO45869_1 | 100 | 14822 | 310 | 8 | 2022-08-02 | 89.46 | 2022-07-21 | 3578.27 | 1 | SO45869 | 2022-07-28 | 286.26 | 2171.29 | |
SO56203_1 | 100 | 17170 | 477 | 4 | 2024-02-07 | 0.12 | 2024-01-26 | 4.99 | 1 | SO56203 | 2024-02-02 | 0.40 | 1.87 | |
SO62766_1 | 100 | 14141 | 587 | 7 | 2024-05-19 | 19.24 | 2024-05-07 | 769.49 | 1 | SO62766 | 2024-05-14 | 61.56 | 419.78 | |
SO68740_1 | 6 | 15237 | 529 | 9 | 2024-08-14 | 0.10 | 2024-08-02 | 3.99 | 1 | SO68740 | 2024-08-09 | 0.32 | 1.49 | |
SO45870_1 | 100 | 26012 | 349 | 4 | 2022-08-02 | 84.37 | 2022-07-21 | 3374.99 | 1 | SO45870 | 2022-07-28 | 270.00 | 1898.09 | |
SO56203_2 | 100 | 17170 | 482 | 4 | 2024-02-07 | 0.22 | 2024-01-26 | 8.99 | 2 | SO56203 | 2024-02-02 | 0.72 | 3.36 | |
SO62766_2 | 100 | 14141 | 536 | 7 | 2024-05-19 | 0.75 | 2024-05-07 | 29.99 | 2 | SO62766 | 2024-05-14 | 2.40 | 11.22 | |
SO68740_2 | 6 | 15237 | 539 | 9 | 2024-08-14 | 0.62 | 2024-08-02 | 24.99 | 2 | SO68740 | 2024-08-09 | 2.00 | 9.35 | |
SO45871_1 | 6 | 25919 | 326 | 9 | 2022-08-02 | 17.48 | 2022-07-21 | 699.10 | 1 | SO45871 | 2022-07-28 | 55.93 | 413.15 | |
SO56204_1 | 100 | 15385 | 528 | 1 | 2024-02-07 | 0.12 | 2024-01-26 | 4.99 | 1 | SO56204 | 2024-02-02 | 0.40 | 1.87 | |
SO62766_3 | 100 | 14141 | 528 | 7 | 2024-05-19 | 0.12 | 2024-05-07 | 4.99 | 3 | SO62766 | 2024-05-14 | 0.40 | 1.87 | |
SO68740_3 | 6 | 15237 | 480 | 9 | 2024-08-14 | 0.06 | 2024-08-02 | 2.29 | 3 | SO68740 | 2024-08-09 | 0.18 | 0.86 | |
SO45872_1 | 100 | 11249 | 347 | 8 | 2022-08-03 | 85.00 | 2022-07-22 | 3399.99 | 1 | SO45872 | 2022-07-29 | 272.00 | 1912.15 | |
SO56204_2 | 100 | 15385 | 480 | 2 | 1 | 2024-02-07 | 0.06 | 2024-01-26 | 2.29 | 2 | SO56204 | 2024-02-02 | 0.18 | 0.86 |
SO62766_4 | 100 | 14141 | 222 | 7 | 2024-05-19 | 0.87 | 2024-05-07 | 34.99 | 4 | SO62766 | 2024-05-14 | 2.80 | 13.09 | |
SO68741_1 | 6 | 11921 | 528 | 9 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 1 | SO68741 | 2024-08-09 | 0.40 | 1.87 | |
SO45873_1 | 100 | 11925 | 314 | 1 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO45873 | 2022-07-29 | 286.26 | 2171.29 | |
SO56205_1 | 100 | 14903 | 528 | 4 | 2024-02-07 | 0.12 | 2024-01-26 | 4.99 | 1 | SO56205 | 2024-02-02 | 0.40 | 1.87 | |
SO62767_1 | 98 | 12873 | 355 | 10 | 2024-05-19 | 58.00 | 2024-05-07 | 2319.99 | 1 | SO62767 | 2024-05-14 | 185.60 | 1265.62 | |
SO68741_2 | 6 | 11921 | 485 | 9 | 2024-08-14 | 0.55 | 2024-08-02 | 21.98 | 2 | SO68741 | 2024-08-09 | 1.76 | 8.22 | |
SO45874_1 | 19 | 20007 | 351 | 6 | 2022-08-03 | 84.37 | 2022-07-22 | 3374.99 | 1 | SO45874 | 2022-07-29 | 270.00 | 1898.09 | |
SO56205_2 | 100 | 14903 | 485 | 4 | 2024-02-07 | 0.55 | 2024-01-26 | 21.98 | 2 | SO56205 | 2024-02-02 | 1.76 | 8.22 | |
SO62767_2 | 98 | 12873 | 217 | 10 | 2024-05-19 | 0.87 | 2024-05-07 | 34.99 | 2 | SO62767 | 2024-05-14 | 2.80 | 13.09 | |
SO68742_1 | 6 | 22956 | 477 | 9 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 1 | SO68742 | 2024-08-09 | 0.40 | 1.87 | |
SO45875_1 | 6 | 20242 | 310 | 9 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO45875 | 2022-07-29 | 286.26 | 2171.29 | |
SO56205_3 | 100 | 14903 | 217 | 4 | 2024-02-07 | 0.87 | 2024-01-26 | 34.99 | 3 | SO56205 | 2024-02-02 | 2.80 | 13.09 | |
SO62768_1 | 100 | 12378 | 359 | 8 | 2024-05-19 | 57.37 | 2024-05-07 | 2294.99 | 1 | SO62768 | 2024-05-14 | 183.60 | 1251.98 | |
SO68742_2 | 6 | 22956 | 465 | 9 | 2024-08-14 | 0.61 | 2024-08-02 | 24.49 | 2 | SO68742 | 2024-08-09 | 1.96 | 9.16 | |
SO45876_1 | 6 | 19975 | 314 | 9 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO45876 | 2022-07-29 | 286.26 | 2171.29 | |
SO56206_1 | 100 | 14828 | 485 | 8 | 2024-02-07 | 0.55 | 2024-01-26 | 21.98 | 1 | SO56206 | 2024-02-02 | 1.76 | 8.22 | |
SO62769_1 | 98 | 12860 | 361 | 10 | 2024-05-19 | 57.37 | 2024-05-07 | 2294.99 | 1 | SO62769 | 2024-05-14 | 183.60 | 1251.98 | |
SO68742_3 | 6 | 22956 | 217 | 9 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 3 | SO68742 | 2024-08-09 | 2.80 | 13.09 | |
SO45877_1 | 6 | 11910 | 351 | 9 | 2022-08-03 | 84.37 | 2022-07-22 | 3374.99 | 1 | SO45877 | 2022-07-29 | 270.00 | 1898.09 | |
SO56206_2 | 100 | 14828 | 488 | 8 | 2024-02-07 | 1.35 | 2024-01-26 | 53.99 | 2 | SO56206 | 2024-02-02 | 4.32 | 41.57 | |
SO62769_2 | 98 | 12860 | 483 | 10 | 2024-05-19 | 3.00 | 2024-05-07 | 120.00 | 2 | SO62769 | 2024-05-14 | 9.60 | 44.88 | |
SO68743_1 | 6 | 11467 | 478 | 9 | 2024-08-14 | 0.25 | 2024-08-02 | 9.99 | 1 | SO68743 | 2024-08-09 | 0.80 | 3.74 | |
SO45878_1 | 100 | 12750 | 310 | 7 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO45878 | 2022-07-30 | 286.26 | 2171.29 | |
SO56207_1 | 98 | 17895 | 535 | 10 | 2024-02-07 | 0.62 | 2024-01-26 | 24.99 | 1 | SO56207 | 2024-02-02 | 2.00 | 9.35 | |
SO62770_1 | 100 | 11174 | 529 | 4 | 2024-05-19 | 0.10 | 2024-05-07 | 3.99 | 1 | SO62770 | 2024-05-14 | 0.32 | 1.49 | |
SO68743_2 | 6 | 11467 | 477 | 9 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 2 | SO68743 | 2024-08-09 | 0.40 | 1.87 | |
SO45879_1 | 100 | 19443 | 338 | 8 | 2022-08-04 | 17.48 | 2022-07-23 | 699.10 | 1 | SO45879 | 2022-07-30 | 55.93 | 413.15 | |
SO56207_2 | 98 | 17895 | 528 | 10 | 2024-02-07 | 0.12 | 2024-01-26 | 4.99 | 2 | SO56207 | 2024-02-02 | 0.40 | 1.87 |
Generated 2024-11-10 14:37:46.289 UTC