[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1969 > < TAKE 31 >
31 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45494_1 | 6 | 19609 | 310 | 9 | 2022-06-19 | 89.46 | 2022-06-07 | 3578.27 | 1 | SO45494 | 2022-06-14 | 286.26 | 2171.29 | |
SO56528_1 | 6 | 23117 | 581 | 9 | 2024-02-13 | 42.52 | 2024-02-01 | 1700.99 | 1 | SO56528 | 2024-02-08 | 136.08 | 1082.51 | |
SO63063_2 | 6 | 23122 | 225 | 9 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 2 | SO63063 | 2024-05-19 | 0.72 | 6.92 | |
SO45495_1 | 6 | 25821 | 342 | 9 | 2022-06-19 | 17.48 | 2022-06-07 | 699.10 | 1 | SO45495 | 2022-06-14 | 55.93 | 413.15 | |
SO56528_2 | 6 | 23117 | 477 | 9 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 2 | SO56528 | 2024-02-08 | 0.40 | 1.87 | |
SO63064_1 | 6 | 28306 | 477 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO63064 | 2024-05-19 | 0.40 | 1.87 | |
SO45505_1 | 6 | 19593 | 313 | 9 | 2022-06-20 | 89.46 | 2022-06-08 | 3578.27 | 1 | SO45505 | 2022-06-15 | 286.26 | 2171.29 | |
SO56528_3 | 6 | 23117 | 479 | 9 | 2024-02-13 | 0.22 | 2024-02-01 | 8.99 | 3 | SO56528 | 2024-02-08 | 0.72 | 3.36 | |
SO63065_1 | 6 | 20153 | 477 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO63065 | 2024-05-19 | 0.40 | 1.87 | |
SO45506_1 | 6 | 19615 | 311 | 9 | 2022-06-20 | 89.46 | 2022-06-08 | 3578.27 | 1 | SO45506 | 2022-06-15 | 286.26 | 2171.29 | |
SO56528_4 | 6 | 23117 | 217 | 9 | 2024-02-13 | 0.87 | 2024-02-01 | 34.99 | 4 | SO56528 | 2024-02-08 | 2.80 | 13.09 | |
SO63065_2 | 6 | 20153 | 225 | 9 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 2 | SO63065 | 2024-05-19 | 0.72 | 6.92 | |
SO45507_1 | 6 | 19616 | 314 | 9 | 2022-06-20 | 89.46 | 2022-06-08 | 3578.27 | 1 | SO45507 | 2022-06-15 | 286.26 | 2171.29 | |
SO56529_1 | 6 | 28962 | 563 | 9 | 2024-02-13 | 59.60 | 2024-02-01 | 2384.07 | 1 | SO56529 | 2024-02-08 | 190.73 | 1481.94 | |
SO63066_1 | 6 | 25816 | 528 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO63066 | 2024-05-19 | 0.40 | 1.87 | |
SO45515_1 | 6 | 19557 | 310 | 9 | 2022-06-22 | 89.46 | 2022-06-10 | 3578.27 | 1 | SO45515 | 2022-06-17 | 286.26 | 2171.29 | |
SO56529_2 | 6 | 28962 | 477 | 9 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 2 | SO56529 | 2024-02-08 | 0.40 | 1.87 | |
SO63066_2 | 6 | 25816 | 480 | 2 | 9 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 2 | SO63066 | 2024-05-19 | 0.18 | 0.86 |
SO45584_1 | 6 | 25828 | 336 | 9 | 2022-06-23 | 17.48 | 2022-06-11 | 699.10 | 1 | SO45584 | 2022-06-18 | 55.93 | 413.15 | |
SO56529_3 | 6 | 28962 | 479 | 9 | 2024-02-13 | 0.22 | 2024-02-01 | 8.99 | 3 | SO56529 | 2024-02-08 | 0.72 | 3.36 | |
SO63067_1 | 6 | 29122 | 478 | 9 | 2024-05-24 | 0.25 | 2024-05-12 | 9.99 | 1 | SO63067 | 2024-05-19 | 0.80 | 3.74 | |
SO45585_1 | 6 | 11905 | 351 | 9 | 2022-06-23 | 84.37 | 2022-06-11 | 3374.99 | 1 | SO45585 | 2022-06-18 | 270.00 | 1898.09 | |
SO56529_4 | 6 | 28962 | 463 | 9 | 2024-02-13 | 0.61 | 2024-02-01 | 24.49 | 4 | SO56529 | 2024-02-08 | 1.96 | 9.16 | |
SO63067_2 | 6 | 29122 | 477 | 9 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO63067 | 2024-05-19 | 0.40 | 1.87 | |
SO45589_1 | 6 | 19784 | 314 | 9 | 2022-06-24 | 89.46 | 2022-06-12 | 3578.27 | 1 | SO45589 | 2022-06-19 | 286.26 | 2171.29 | |
SO56529_5 | 6 | 28962 | 487 | 9 | 2024-02-13 | 1.37 | 2024-02-01 | 54.99 | 5 | SO56529 | 2024-02-08 | 4.40 | 20.57 | |
SO63067_3 | 6 | 29122 | 217 | 9 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 3 | SO63067 | 2024-05-19 | 2.80 | 13.09 | |
SO45590_1 | 6 | 19763 | 311 | 9 | 2022-06-24 | 89.46 | 2022-06-12 | 3578.27 | 1 | SO45590 | 2022-06-19 | 286.26 | 2171.29 | |
SO56530_1 | 6 | 12675 | 355 | 9 | 2024-02-13 | 58.00 | 2024-02-01 | 2319.99 | 1 | SO56530 | 2024-02-08 | 185.60 | 1265.62 | |
SO63068_1 | 6 | 19618 | 541 | 9 | 2024-05-24 | 0.72 | 2024-05-12 | 28.99 | 1 | SO63068 | 2024-05-19 | 2.32 | 10.84 | |
SO45591_1 | 6 | 25831 | 326 | 9 | 2022-06-24 | 17.48 | 2022-06-12 | 699.10 | 1 | SO45591 | 2022-06-19 | 55.93 | 413.15 |
Generated 2024-11-10 20:05:46.098 UTC