[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1198 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45948_1 | 100 | 14879 | 342 | 4 | 2023-02-06 | 17.48 | 2023-01-25 | 699.10 | 1 | SO45948 | 2023-02-01 | 55.93 | 413.15 | |
SO56182_1 | 100 | 22875 | 605 | 4 | 2024-08-01 | 13.50 | 2024-07-20 | 539.99 | 1 | SO56182 | 2024-07-27 | 43.20 | 343.65 | |
SO45957_1 | 100 | 11809 | 312 | 4 | 2023-02-08 | 89.46 | 2023-01-27 | 3578.27 | 1 | SO45957 | 2023-02-03 | 286.26 | 2171.29 | |
SO56182_2 | 100 | 22875 | 477 | 4 | 2024-08-01 | 0.12 | 2024-07-20 | 4.99 | 2 | SO56182 | 2024-07-27 | 0.40 | 1.87 | |
SO45958_1 | 100 | 11818 | 311 | 4 | 2023-02-08 | 89.46 | 2023-01-27 | 3578.27 | 1 | SO45958 | 2023-02-03 | 286.26 | 2171.29 | |
SO56182_3 | 100 | 22875 | 479 | 4 | 2024-08-01 | 0.22 | 2024-07-20 | 8.99 | 3 | SO56182 | 2024-07-27 | 0.72 | 3.36 | |
SO45959_1 | 100 | 11872 | 311 | 4 | 2023-02-08 | 89.46 | 2023-01-27 | 3578.27 | 1 | SO45959 | 2023-02-03 | 286.26 | 2171.29 | |
SO56182_4 | 100 | 22875 | 480 | 4 | 2024-08-01 | 0.06 | 2024-07-20 | 2.29 | 4 | SO56182 | 2024-07-27 | 0.18 | 0.86 | |
SO45960_1 | 100 | 11671 | 314 | 4 | 2023-02-08 | 89.46 | 2023-01-27 | 3578.27 | 1 | SO45960 | 2023-02-03 | 286.26 | 2171.29 | |
SO56183_1 | 100 | 22082 | 584 | 4 | 2024-08-01 | 13.50 | 2024-07-20 | 539.99 | 1 | SO56183 | 2024-07-27 | 43.20 | 343.65 | |
SO45968_1 | 100 | 11834 | 311 | 4 | 2023-02-09 | 89.46 | 2023-01-28 | 3578.27 | 1 | SO45968 | 2023-02-04 | 286.26 | 2171.29 | |
SO56183_2 | 100 | 22082 | 214 | 4 | 2024-08-01 | 0.87 | 2024-07-20 | 34.99 | 2 | SO56183 | 2024-07-27 | 2.80 | 13.09 | |
SO45973_1 | 100 | 11773 | 313 | 4 | 2023-02-10 | 89.46 | 2023-01-29 | 3578.27 | 1 | SO45973 | 2023-02-05 | 286.26 | 2171.29 | |
SO56194_1 | 100 | 29105 | 529 | 4 | 2024-08-02 | 0.10 | 2024-07-21 | 3.99 | 1 | SO56194 | 2024-07-28 | 0.32 | 1.49 | |
SO45975_1 | 100 | 14755 | 324 | 4 | 2023-02-10 | 17.48 | 2023-01-29 | 699.10 | 1 | SO45975 | 2023-02-05 | 55.93 | 413.15 | |
SO56194_2 | 100 | 29105 | 480 | 4 | 2024-08-02 | 0.06 | 2024-07-21 | 2.29 | 2 | SO56194 | 2024-07-28 | 0.18 | 0.86 | |
SO45985_1 | 100 | 11708 | 314 | 4 | 2023-02-12 | 89.46 | 2023-01-31 | 3578.27 | 1 | SO45985 | 2023-02-07 | 286.26 | 2171.29 | |
SO56196_1 | 100 | 27210 | 530 | 4 | 2024-08-02 | 0.12 | 2024-07-21 | 4.99 | 1 | SO56196 | 2024-07-28 | 0.40 | 1.87 | |
SO45986_1 | 100 | 11743 | 314 | 4 | 2023-02-12 | 89.46 | 2023-01-31 | 3578.27 | 1 | SO45986 | 2023-02-07 | 286.26 | 2171.29 | |
SO56196_2 | 100 | 27210 | 480 | 2 | 4 | 2024-08-02 | 0.06 | 2024-07-21 | 2.29 | 2 | SO56196 | 2024-07-28 | 0.18 | 0.86 |
SO45987_1 | 100 | 11854 | 310 | 4 | 2023-02-12 | 89.46 | 2023-01-31 | 3578.27 | 1 | SO45987 | 2023-02-07 | 286.26 | 2171.29 | |
SO56200_1 | 100 | 22215 | 536 | 4 | 2024-08-02 | 0.75 | 2024-07-21 | 29.99 | 1 | SO56200 | 2024-07-28 | 2.40 | 11.22 | |
SO45993_1 | 100 | 11924 | 313 | 4 | 2023-02-13 | 89.46 | 2023-02-01 | 3578.27 | 1 | SO45993 | 2023-02-08 | 286.26 | 2171.29 | |
SO56200_2 | 100 | 22215 | 477 | 4 | 2024-08-02 | 0.12 | 2024-07-21 | 4.99 | 2 | SO56200 | 2024-07-28 | 0.40 | 1.87 | |
SO45994_1 | 100 | 11774 | 311 | 4 | 2023-02-13 | 89.46 | 2023-02-01 | 3578.27 | 1 | SO45994 | 2023-02-08 | 286.26 | 2171.29 | |
SO56200_3 | 100 | 22215 | 222 | 4 | 2024-08-02 | 0.87 | 2024-07-21 | 34.99 | 3 | SO56200 | 2024-07-28 | 2.80 | 13.09 | |
SO45996_1 | 100 | 11839 | 312 | 4 | 2023-02-13 | 89.46 | 2023-02-01 | 3578.27 | 1 | SO45996 | 2023-02-08 | 286.26 | 2171.29 | |
SO56200_4 | 100 | 22215 | 482 | 4 | 2024-08-02 | 0.22 | 2024-07-21 | 8.99 | 4 | SO56200 | 2024-07-28 | 0.72 | 3.36 | |
SO45997_1 | 100 | 14756 | 324 | 4 | 2023-02-13 | 17.48 | 2023-02-01 | 699.10 | 1 | SO45997 | 2023-02-08 | 55.93 | 413.15 | |
SO56201_1 | 100 | 18675 | 474 | 4 | 2024-08-02 | 1.75 | 2024-07-21 | 69.99 | 1 | SO56201 | 2024-07-28 | 5.60 | 26.18 | |
SO46002_1 | 100 | 11826 | 310 | 4 | 2023-02-14 | 89.46 | 2023-02-02 | 3578.27 | 1 | SO46002 | 2023-02-09 | 286.26 | 2171.29 | |
SO56201_2 | 100 | 18675 | 482 | 4 | 2024-08-02 | 0.22 | 2024-07-21 | 8.99 | 2 | SO56201 | 2024-07-28 | 0.72 | 3.36 | |
SO46003_1 | 100 | 11831 | 312 | 4 | 2023-02-14 | 89.46 | 2023-02-02 | 3578.27 | 1 | SO46003 | 2023-02-09 | 286.26 | 2171.29 | |
SO56201_3 | 100 | 18675 | 228 | 4 | 2024-08-02 | 1.25 | 2024-07-21 | 49.99 | 3 | SO56201 | 2024-07-28 | 4.00 | 38.49 | |
SO46004_1 | 100 | 11664 | 311 | 4 | 2023-02-14 | 89.46 | 2023-02-02 | 3578.27 | 1 | SO46004 | 2023-02-09 | 286.26 | 2171.29 | |
SO56203_1 | 100 | 17170 | 477 | 4 | 2024-08-02 | 0.12 | 2024-07-21 | 4.99 | 1 | SO56203 | 2024-07-28 | 0.40 | 1.87 | |
SO46013_1 | 100 | 11705 | 311 | 4 | 2023-02-15 | 89.46 | 2023-02-03 | 3578.27 | 1 | SO46013 | 2023-02-10 | 286.26 | 2171.29 | |
SO56203_2 | 100 | 17170 | 482 | 4 | 2024-08-02 | 0.22 | 2024-07-21 | 8.99 | 2 | SO56203 | 2024-07-28 | 0.72 | 3.36 | |
SO46016_1 | 100 | 11885 | 312 | 4 | 2023-02-15 | 89.46 | 2023-02-03 | 3578.27 | 1 | SO46016 | 2023-02-10 | 286.26 | 2171.29 | |
SO56205_1 | 100 | 14903 | 528 | 4 | 2024-08-02 | 0.12 | 2024-07-21 | 4.99 | 1 | SO56205 | 2024-07-28 | 0.40 | 1.87 | |
SO46017_1 | 100 | 11886 | 314 | 4 | 2023-02-15 | 89.46 | 2023-02-03 | 3578.27 | 1 | SO46017 | 2023-02-10 | 286.26 | 2171.29 | |
SO56205_2 | 100 | 14903 | 485 | 4 | 2024-08-02 | 0.55 | 2024-07-21 | 21.98 | 2 | SO56205 | 2024-07-28 | 1.76 | 8.22 | |
SO46019_1 | 100 | 14752 | 340 | 4 | 2023-02-15 | 17.48 | 2023-02-03 | 699.10 | 1 | SO46019 | 2023-02-10 | 55.93 | 413.15 | |
SO56205_3 | 100 | 14903 | 217 | 4 | 2024-08-02 | 0.87 | 2024-07-21 | 34.99 | 3 | SO56205 | 2024-07-28 | 2.80 | 13.09 | |
SO46108_1 | 100 | 12018 | 310 | 4 | 2023-02-16 | 89.46 | 2023-02-04 | 3578.27 | 1 | SO46108 | 2023-02-11 | 286.26 | 2171.29 | |
SO56211_1 | 100 | 13227 | 485 | 4 | 2024-08-02 | 0.55 | 2024-07-21 | 21.98 | 1 | SO56211 | 2024-07-28 | 1.76 | 8.22 | |
SO46110_1 | 100 | 12169 | 311 | 4 | 2023-02-16 | 89.46 | 2023-02-04 | 3578.27 | 1 | SO46110 | 2023-02-11 | 286.26 | 2171.29 | |
SO56211_2 | 100 | 13227 | 234 | 4 | 2024-08-02 | 1.25 | 2024-07-21 | 49.99 | 2 | SO56211 | 2024-07-28 | 4.00 | 38.49 | |
SO46112_1 | 100 | 11945 | 312 | 4 | 2023-02-16 | 89.46 | 2023-02-04 | 3578.27 | 1 | SO46112 | 2023-02-11 | 286.26 | 2171.29 | |
SO56213_1 | 100 | 15865 | 592 | 4 | 2024-08-02 | 14.12 | 2024-07-21 | 564.99 | 1 | SO56213 | 2024-07-28 | 45.20 | 308.22 | |
SO46113_1 | 100 | 11955 | 310 | 4 | 2023-02-16 | 89.46 | 2023-02-04 | 3578.27 | 1 | SO46113 | 2023-02-11 | 286.26 | 2171.29 | |
SO56213_2 | 100 | 15865 | 478 | 4 | 2024-08-02 | 0.25 | 2024-07-21 | 9.99 | 2 | SO56213 | 2024-07-28 | 0.80 | 3.74 | |
SO46114_1 | 100 | 12053 | 313 | 4 | 2023-02-16 | 89.46 | 2023-02-04 | 3578.27 | 1 | SO46114 | 2023-02-11 | 286.26 | 2171.29 | |
SO56213_3 | 100 | 15865 | 477 | 4 | 2024-08-02 | 0.12 | 2024-07-21 | 4.99 | 3 | SO56213 | 2024-07-28 | 0.40 | 1.87 | |
SO46115_1 | 100 | 12104 | 312 | 4 | 2023-02-16 | 89.46 | 2023-02-04 | 3578.27 | 1 | SO46115 | 2023-02-11 | 286.26 | 2171.29 | |
SO56213_4 | 100 | 15865 | 491 | 4 | 2024-08-02 | 1.35 | 2024-07-21 | 53.99 | 4 | SO56213 | 2024-07-28 | 4.32 | 41.57 |
Generated 2025-05-06 18:31:12.462 UTC