[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1499 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44206_1 | 98 | 11250 | 347 | 10 | 2022-01-09 | 85.00 | 2021-12-28 | 3399.99 | 1 | SO44206 | 2022-01-04 | 272.00 | 1912.15 |
SO55707_2 | 100 | 15894 | 217 | 1 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 2 | SO55707 | 2024-01-24 | 2.80 | 13.09 |
SO62266_1 | 100 | 25494 | 530 | 7 | 2024-05-10 | 0.12 | 2024-04-28 | 4.99 | 1 | SO62266 | 2024-05-05 | 0.40 | 1.87 |
SO68800_2 | 100 | 18350 | 222 | 4 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 2 | SO68800 | 2024-08-09 | 2.80 | 13.09 |
SO44207_1 | 100 | 28162 | 313 | 4 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44207 | 2022-01-04 | 286.26 | 2171.29 |
SO55707_3 | 100 | 15894 | 237 | 1 | 2024-01-29 | 1.25 | 2024-01-17 | 49.99 | 3 | SO55707 | 2024-01-24 | 4.00 | 38.49 |
SO62266_2 | 100 | 25494 | 214 | 7 | 2024-05-10 | 0.87 | 2024-04-28 | 34.99 | 2 | SO62266 | 2024-05-05 | 2.80 | 13.09 |
SO68801_1 | 100 | 18431 | 583 | 4 | 2024-08-14 | 42.52 | 2024-08-02 | 1700.99 | 1 | SO68801 | 2024-08-09 | 136.08 | 1082.51 |
SO44208_1 | 100 | 25879 | 347 | 4 | 2022-01-09 | 85.00 | 2021-12-28 | 3399.99 | 1 | SO44208 | 2022-01-04 | 272.00 | 1912.15 |
SO55708_1 | 19 | 29266 | 477 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 1 | SO55708 | 2024-01-24 | 0.40 | 1.87 |
SO62267_1 | 19 | 11331 | 537 | 6 | 2024-05-10 | 0.88 | 2024-04-28 | 35.00 | 1 | SO62267 | 2024-05-05 | 2.80 | 13.09 |
SO68801_2 | 100 | 18431 | 488 | 4 | 2024-08-14 | 1.35 | 2024-08-02 | 53.99 | 2 | SO68801 | 2024-08-09 | 4.32 | 41.57 |
SO44209_1 | 6 | 17257 | 311 | 9 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44209 | 2022-01-04 | 286.26 | 2171.29 |
SO55708_2 | 19 | 29266 | 217 | 6 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 2 | SO55708 | 2024-01-24 | 2.80 | 13.09 |
SO62267_2 | 19 | 11331 | 480 | 6 | 2024-05-10 | 0.06 | 2024-04-28 | 2.29 | 2 | SO62267 | 2024-05-05 | 0.18 | 0.86 |
SO68802_1 | 100 | 18226 | 581 | 1 | 2024-08-14 | 42.52 | 2024-08-02 | 1700.99 | 1 | SO68802 | 2024-08-09 | 136.08 | 1082.51 |
SO44210_1 | 98 | 13783 | 310 | 10 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44210 | 2022-01-05 | 286.26 | 2171.29 |
SO55709_1 | 100 | 14511 | 528 | 1 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 1 | SO55709 | 2024-01-24 | 0.40 | 1.87 |
SO62268_1 | 100 | 11393 | 477 | 7 | 2024-05-10 | 0.12 | 2024-04-28 | 4.99 | 1 | SO62268 | 2024-05-05 | 0.40 | 1.87 |
SO68802_2 | 100 | 18226 | 539 | 1 | 2024-08-14 | 0.62 | 2024-08-02 | 24.99 | 2 | SO68802 | 2024-08-09 | 2.00 | 9.35 |
SO44211_1 | 100 | 28154 | 313 | 4 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44211 | 2022-01-05 | 286.26 | 2171.29 |
SO55709_2 | 100 | 14511 | 214 | 1 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 2 | SO55709 | 2024-01-24 | 2.80 | 13.09 |
SO62268_2 | 100 | 11393 | 479 | 7 | 2024-05-10 | 0.22 | 2024-04-28 | 8.99 | 2 | SO62268 | 2024-05-05 | 0.72 | 3.36 |
SO68803_1 | 100 | 22712 | 606 | 7 | 2024-08-14 | 13.50 | 2024-08-02 | 539.99 | 1 | SO68803 | 2024-08-09 | 43.20 | 343.65 |
SO44212_1 | 100 | 28170 | 312 | 4 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44212 | 2022-01-05 | 286.26 | 2171.29 |
SO55709_3 | 100 | 14511 | 231 | 1 | 2024-01-29 | 1.25 | 2024-01-17 | 49.99 | 3 | SO55709 | 2024-01-24 | 4.00 | 38.49 |
SO62269_1 | 100 | 13162 | 471 | 4 | 2024-05-10 | 1.59 | 2024-04-28 | 63.50 | 1 | SO62269 | 2024-05-05 | 5.08 | 23.75 |
SO68803_2 | 100 | 22712 | 222 | 7 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 2 | SO68803 | 2024-08-09 | 2.80 | 13.09 |
SO44213_1 | 6 | 17351 | 310 | 9 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44213 | 2022-01-05 | 286.26 | 2171.29 |
SO55710_1 | 100 | 17556 | 528 | 1 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 1 | SO55710 | 2024-01-24 | 0.40 | 1.87 |
SO62269_2 | 100 | 13162 | 485 | 4 | 2024-05-10 | 0.55 | 2024-04-28 | 21.98 | 2 | SO62269 | 2024-05-05 | 1.76 | 8.22 |
SO68804_1 | 100 | 24121 | 584 | 8 | 2024-08-14 | 13.50 | 2024-08-02 | 539.99 | 1 | SO68804 | 2024-08-09 | 43.20 | 343.65 |
SO44214_1 | 6 | 17332 | 311 | 9 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44214 | 2022-01-05 | 286.26 | 2171.29 |
SO55711_1 | 98 | 19047 | 485 | 10 | 2024-01-29 | 0.55 | 2024-01-17 | 21.98 | 1 | SO55711 | 2024-01-24 | 1.76 | 8.22 |
SO62270_1 | 19 | 14631 | 588 | 6 | 2024-05-10 | 19.24 | 2024-04-28 | 769.49 | 1 | SO62270 | 2024-05-05 | 61.56 | 419.78 |
SO68805_1 | 100 | 11423 | 575 | 8 | 2024-08-14 | 59.60 | 2024-08-02 | 2384.07 | 1 | SO68805 | 2024-08-09 | 190.73 | 1481.94 |
SO44215_1 | 100 | 28180 | 312 | 1 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44215 | 2022-01-06 | 286.26 | 2171.29 |
SO55711_2 | 98 | 19047 | 478 | 10 | 2024-01-29 | 0.25 | 2024-01-17 | 9.99 | 2 | SO55711 | 2024-01-24 | 0.80 | 3.74 |
SO62270_2 | 19 | 14631 | 474 | 6 | 2024-05-10 | 1.75 | 2024-04-28 | 69.99 | 2 | SO62270 | 2024-05-05 | 5.60 | 26.18 |
SO68805_2 | 100 | 11423 | 225 | 8 | 2024-08-14 | 0.22 | 2024-08-02 | 8.99 | 2 | SO68805 | 2024-08-09 | 0.72 | 6.92 |
SO44216_1 | 29 | 13560 | 314 | 8 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44216 | 2022-01-06 | 286.26 | 2171.29 |
SO55711_3 | 98 | 19047 | 477 | 10 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 3 | SO55711 | 2024-01-24 | 0.40 | 1.87 |
SO62270_3 | 19 | 14631 | 225 | 6 | 2024-05-10 | 0.22 | 2024-04-28 | 8.99 | 3 | SO62270 | 2024-05-05 | 0.72 | 6.92 |
SO68806_1 | 100 | 11427 | 561 | 8 | 2024-08-14 | 59.60 | 2024-08-02 | 2384.07 | 1 | SO68806 | 2024-08-09 | 190.73 | 1481.94 |
SO44217_1 | 100 | 28148 | 310 | 1 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44217 | 2022-01-06 | 286.26 | 2171.29 |
SO55711_4 | 98 | 19047 | 214 | 10 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 4 | SO55711 | 2024-01-24 | 2.80 | 13.09 |
SO62271_1 | 100 | 14419 | 359 | 1 | 2024-05-10 | 57.37 | 2024-04-28 | 2294.99 | 1 | SO62271 | 2024-05-05 | 183.60 | 1251.98 |
SO68806_2 | 100 | 11427 | 541 | 8 | 2024-08-14 | 0.72 | 2024-08-02 | 28.99 | 2 | SO68806 | 2024-08-09 | 2.32 | 10.84 |
SO44218_1 | 19 | 22109 | 311 | 6 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44218 | 2022-01-06 | 286.26 | 2171.29 |
SO55712_1 | 98 | 21068 | 536 | 10 | 2024-01-29 | 0.75 | 2024-01-17 | 29.99 | 1 | SO55712 | 2024-01-24 | 2.40 | 11.22 |
SO62271_2 | 100 | 14419 | 485 | 1 | 2024-05-10 | 0.55 | 2024-04-28 | 21.98 | 2 | SO62271 | 2024-05-05 | 1.76 | 8.22 |
SO68806_3 | 100 | 11427 | 530 | 8 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 3 | SO68806 | 2024-08-09 | 0.40 | 1.87 |
SO44219_1 | 100 | 14590 | 338 | 4 | 2022-01-11 | 17.48 | 2021-12-30 | 699.10 | 1 | SO44219 | 2022-01-06 | 55.93 | 413.15 |
SO55712_2 | 98 | 21068 | 528 | 10 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 2 | SO55712 | 2024-01-24 | 0.40 | 1.87 |
SO62271_3 | 100 | 14419 | 491 | 1 | 2024-05-10 | 1.35 | 2024-04-28 | 53.99 | 3 | SO62271 | 2024-05-05 | 4.32 | 41.57 |
SO68807_1 | 100 | 11439 | 561 | 7 | 2024-08-14 | 59.60 | 2024-08-02 | 2384.07 | 1 | SO68807 | 2024-08-09 | 190.73 | 1481.94 |
Generated 2024-11-10 11:10:00.267 UTC