[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2528 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45411_1 | 100 | 28197 | 313 | 6 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45411 | 2022-05-31 | 286.26 | 2171.29 | |
SO56059_2 | 100 | 12207 | 480 | 1 | 2024-02-04 | 0.06 | 2024-01-23 | 2.29 | 2 | SO56059 | 2024-01-30 | 0.18 | 0.86 | |
SO45412_1 | 19 | 23137 | 310 | 6 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45412 | 2022-05-31 | 286.26 | 2171.29 | |
SO56060_1 | 6 | 28211 | 605 | 9 | 2024-02-04 | 13.50 | 2024-01-23 | 539.99 | 1 | SO56060 | 2024-01-30 | 43.20 | 343.65 | |
SO45413_1 | 100 | 11191 | 312 | 4 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45413 | 2022-05-31 | 286.26 | 2171.29 | |
SO56061_1 | 6 | 20990 | 604 | 9 | 2024-02-04 | 13.50 | 2024-01-23 | 539.99 | 1 | SO56061 | 2024-01-30 | 43.20 | 343.65 | |
SO45414_1 | 100 | 18038 | 330 | 7 | 2022-06-05 | 17.48 | 2022-05-24 | 699.10 | 1 | SO45414 | 2022-05-31 | 55.93 | 413.15 | |
SO56061_2 | 6 | 20990 | 479 | 9 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 2 | SO56061 | 2024-01-30 | 0.72 | 3.36 | |
SO45415_1 | 100 | 28092 | 312 | 6 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45415 | 2022-05-31 | 286.26 | 2171.29 | |
SO56061_3 | 6 | 20990 | 477 | 9 | 2024-02-04 | 0.12 | 2024-01-23 | 4.99 | 3 | SO56061 | 2024-01-30 | 0.40 | 1.87 | |
SO45416_1 | 100 | 28161 | 310 | 6 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45416 | 2022-05-31 | 286.26 | 2171.29 | |
SO56061_4 | 6 | 20990 | 487 | 9 | 2024-02-04 | 1.37 | 2024-01-23 | 54.99 | 4 | SO56061 | 2024-01-30 | 4.40 | 20.57 | |
SO45417_1 | 100 | 28620 | 310 | 6 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45417 | 2022-05-31 | 286.26 | 2171.29 | |
SO56061_5 | 6 | 20990 | 482 | 9 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 5 | SO56061 | 2024-01-30 | 0.72 | 3.36 | |
SO45418_1 | 6 | 19264 | 311 | 9 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45418 | 2022-05-31 | 286.26 | 2171.29 | |
SO56062_1 | 6 | 19083 | 376 | 9 | 2024-02-04 | 61.08 | 2024-01-23 | 2443.35 | 1 | SO56062 | 2024-01-30 | 195.47 | 1554.95 | |
SO45419_1 | 6 | 19555 | 314 | 9 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45419 | 2022-05-31 | 286.26 | 2171.29 | |
SO56063_1 | 100 | 26351 | 568 | 4 | 2024-02-04 | 18.56 | 2024-01-23 | 742.35 | 1 | SO56063 | 2024-01-30 | 59.39 | 461.44 | |
SO45420_1 | 6 | 19561 | 313 | 9 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45420 | 2022-05-31 | 286.26 | 2171.29 | |
SO56063_2 | 100 | 26351 | 479 | 4 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 2 | SO56063 | 2024-01-30 | 0.72 | 3.36 | |
SO45421_1 | 6 | 19576 | 313 | 9 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45421 | 2022-05-31 | 286.26 | 2171.29 | |
SO56064_1 | 6 | 12339 | 357 | 2 | 9 | 2024-02-04 | 58.00 | 2024-01-23 | 2319.99 | 1 | SO56064 | 2024-01-30 | 185.60 | 1265.62 |
SO45422_1 | 100 | 28198 | 310 | 6 | 2022-06-06 | 89.46 | 2022-05-25 | 3578.27 | 1 | SO45422 | 2022-06-01 | 286.26 | 2171.29 | |
SO56064_2 | 6 | 12339 | 487 | 9 | 2024-02-04 | 1.37 | 2024-01-23 | 54.99 | 2 | SO56064 | 2024-01-30 | 4.40 | 20.57 | |
SO45423_1 | 19 | 19997 | 348 | 6 | 2022-06-06 | 84.37 | 2022-05-25 | 3374.99 | 1 | SO45423 | 2022-06-01 | 270.00 | 1898.09 | |
SO56065_1 | 100 | 22044 | 584 | 4 | 2024-02-04 | 13.50 | 2024-01-23 | 539.99 | 1 | SO56065 | 2024-01-30 | 43.20 | 343.65 | |
SO56065_2 | 100 | 22044 | 479 | 4 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 2 | SO56065 | 2024-01-30 | 0.72 | 3.36 | |
SO56065_3 | 100 | 22044 | 477 | 4 | 2024-02-04 | 0.12 | 2024-01-23 | 4.99 | 3 | SO56065 | 2024-01-30 | 0.40 | 1.87 | |
SO56065_4 | 100 | 22044 | 489 | 4 | 2024-02-04 | 1.35 | 2024-01-23 | 53.99 | 4 | SO56065 | 2024-01-30 | 4.32 | 41.57 | |
SO56066_1 | 98 | 27880 | 575 | 10 | 2024-02-04 | 59.60 | 2024-01-23 | 2384.07 | 1 | SO56066 | 2024-01-30 | 190.73 | 1481.94 | |
SO56066_2 | 98 | 27880 | 225 | 10 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 2 | SO56066 | 2024-01-30 | 0.72 | 6.92 | |
SO56067_1 | 100 | 15625 | 574 | 8 | 2024-02-04 | 59.60 | 2024-01-23 | 2384.07 | 1 | SO56067 | 2024-01-30 | 190.73 | 1481.94 | |
SO45424_1 | 100 | 28165 | 311 | 6 | 2022-06-06 | 89.46 | 2022-05-25 | 3578.27 | 1 | SO45424 | 2022-06-01 | 286.26 | 2171.29 | |
SO45425_1 | 98 | 15056 | 310 | 10 | 2022-06-07 | 89.46 | 2022-05-26 | 3578.27 | 1 | SO45425 | 2022-06-02 | 286.26 | 2171.29 | |
SO45426_1 | 100 | 14164 | 312 | 8 | 2022-06-07 | 89.46 | 2022-05-26 | 3578.27 | 1 | SO45426 | 2022-06-02 | 286.26 | 2171.29 | |
SO45427_1 | 100 | 29481 | 349 | 8 | 2022-06-07 | 84.37 | 2022-05-26 | 3374.99 | 1 | SO45427 | 2022-06-02 | 270.00 | 1898.09 | |
SO45428_1 | 98 | 11414 | 346 | 10 | 2022-06-07 | 85.00 | 2022-05-26 | 3399.99 | 1 | SO45428 | 2022-06-02 | 272.00 | 1912.15 | |
SO45429_1 | 100 | 28129 | 310 | 6 | 2022-06-07 | 89.46 | 2022-05-26 | 3578.27 | 1 | SO45429 | 2022-06-02 | 286.26 | 2171.29 | |
SO45430_1 | 100 | 28176 | 312 | 6 | 2022-06-07 | 89.46 | 2022-05-26 | 3578.27 | 1 | SO45430 | 2022-06-02 | 286.26 | 2171.29 | |
SO45431_1 | 100 | 28013 | 311 | 6 | 2022-06-07 | 89.46 | 2022-05-26 | 3578.27 | 1 | SO45431 | 2022-06-02 | 286.26 | 2171.29 | |
SO45432_1 | 100 | 14167 | 312 | 8 | 2022-06-08 | 89.46 | 2022-05-27 | 3578.27 | 1 | SO45432 | 2022-06-03 | 286.26 | 2171.29 | |
SO45433_1 | 100 | 12547 | 310 | 7 | 2022-06-08 | 89.46 | 2022-05-27 | 3578.27 | 1 | SO45433 | 2022-06-03 | 286.26 | 2171.29 | |
SO45434_1 | 100 | 11252 | 311 | 4 | 2022-06-08 | 89.46 | 2022-05-27 | 3578.27 | 1 | SO45434 | 2022-06-03 | 286.26 | 2171.29 | |
SO45435_1 | 98 | 20562 | 336 | 10 | 2022-06-08 | 17.48 | 2022-05-27 | 699.10 | 1 | SO45435 | 2022-06-03 | 55.93 | 413.15 | |
SO45436_1 | 100 | 28130 | 312 | 6 | 2022-06-08 | 89.46 | 2022-05-27 | 3578.27 | 1 | SO45436 | 2022-06-03 | 286.26 | 2171.29 | |
SO45437_1 | 100 | 28169 | 312 | 6 | 2022-06-08 | 89.46 | 2022-05-27 | 3578.27 | 1 | SO45437 | 2022-06-03 | 286.26 | 2171.29 | |
SO45438_1 | 100 | 29334 | 310 | 1 | 2022-06-08 | 89.46 | 2022-05-27 | 3578.27 | 1 | SO45438 | 2022-06-03 | 286.26 | 2171.29 | |
SO45439_1 | 6 | 25823 | 326 | 9 | 2022-06-08 | 17.48 | 2022-05-27 | 699.10 | 1 | SO45439 | 2022-06-03 | 55.93 | 413.15 | |
SO45440_1 | 100 | 14198 | 312 | 8 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45440 | 2022-06-04 | 286.26 | 2171.29 | |
SO56068_1 | 100 | 12192 | 483 | 1 | 2024-02-05 | 3.00 | 2024-01-24 | 120.00 | 1 | SO56068 | 2024-01-31 | 9.60 | 44.88 | |
SO45441_1 | 100 | 11216 | 312 | 1 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45441 | 2022-06-04 | 286.26 | 2171.29 | |
SO56069_1 | 6 | 18733 | 485 | 9 | 2024-02-05 | 0.55 | 2024-01-24 | 21.98 | 1 | SO56069 | 2024-01-31 | 1.76 | 8.22 | |
SO45442_1 | 100 | 29335 | 314 | 1 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45442 | 2022-06-04 | 286.26 | 2171.29 | |
SO56070_1 | 6 | 22843 | 537 | 9 | 2024-02-05 | 0.88 | 2024-01-24 | 35.00 | 1 | SO56070 | 2024-01-31 | 2.80 | 13.09 | |
SO45443_1 | 100 | 29350 | 313 | 4 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45443 | 2022-06-04 | 286.26 | 2171.29 | |
SO56070_2 | 6 | 22843 | 481 | 9 | 2024-02-05 | 0.22 | 2024-01-24 | 8.99 | 2 | SO56070 | 2024-01-31 | 0.72 | 3.36 | |
SO45444_1 | 6 | 19102 | 310 | 9 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45444 | 2022-06-04 | 286.26 | 2171.29 | |
SO56070_3 | 6 | 22843 | 528 | 9 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 3 | SO56070 | 2024-01-31 | 0.40 | 1.87 | |
SO45445_1 | 6 | 19105 | 310 | 9 | 2022-06-09 | 89.46 | 2022-05-28 | 3578.27 | 1 | SO45445 | 2022-06-04 | 286.26 | 2171.29 | |
SO56071_1 | 6 | 14307 | 530 | 9 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56071 | 2024-01-31 | 0.40 | 1.87 | |
SO45446_1 | 100 | 25990 | 345 | 1 | 2022-06-10 | 85.00 | 2022-05-29 | 3399.99 | 1 | SO45446 | 2022-06-05 | 272.00 | 1912.15 | |
SO56072_1 | 6 | 15798 | 222 | 9 | 2024-02-05 | 0.87 | 2024-01-24 | 34.99 | 1 | SO56072 | 2024-01-31 | 2.80 | 13.09 | |
SO45447_1 | 6 | 19558 | 313 | 9 | 2022-06-10 | 89.46 | 2022-05-29 | 3578.27 | 1 | SO45447 | 2022-06-05 | 286.26 | 2171.29 | |
SO56073_1 | 6 | 16023 | 541 | 9 | 2024-02-05 | 0.72 | 2024-01-24 | 28.99 | 1 | SO56073 | 2024-01-31 | 2.32 | 10.84 | |
SO45448_1 | 6 | 25718 | 324 | 9 | 2022-06-10 | 17.48 | 2022-05-29 | 699.10 | 1 | SO45448 | 2022-06-05 | 55.93 | 413.15 | |
SO56073_2 | 6 | 16023 | 530 | 9 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 2 | SO56073 | 2024-01-31 | 0.40 | 1.87 | |
SO45449_1 | 100 | 14189 | 310 | 8 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45449 | 2022-06-06 | 286.26 | 2171.29 | |
SO56073_3 | 6 | 16023 | 487 | 9 | 2024-02-05 | 1.37 | 2024-01-24 | 54.99 | 3 | SO56073 | 2024-01-31 | 4.40 | 20.57 | |
SO45450_1 | 100 | 28624 | 312 | 6 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45450 | 2022-06-06 | 286.26 | 2171.29 | |
SO56073_4 | 6 | 16023 | 484 | 9 | 2024-02-05 | 0.20 | 2024-01-24 | 7.95 | 4 | SO56073 | 2024-01-31 | 0.64 | 2.97 | |
SO45451_1 | 100 | 29279 | 311 | 4 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45451 | 2022-06-06 | 286.26 | 2171.29 | |
SO56074_1 | 100 | 27388 | 541 | 1 | 2024-02-05 | 0.72 | 2024-01-24 | 28.99 | 1 | SO56074 | 2024-01-31 | 2.32 | 10.84 | |
SO45452_1 | 6 | 19559 | 314 | 9 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45452 | 2022-06-06 | 286.26 | 2171.29 | |
SO56074_2 | 100 | 27388 | 530 | 1 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 2 | SO56074 | 2024-01-31 | 0.40 | 1.87 | |
SO45453_1 | 100 | 12549 | 311 | 7 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45453 | 2022-06-07 | 286.26 | 2171.29 | |
SO56074_3 | 100 | 27388 | 237 | 1 | 2024-02-05 | 1.25 | 2024-01-24 | 49.99 | 3 | SO56074 | 2024-01-31 | 4.00 | 38.49 | |
SO45454_1 | 19 | 23074 | 312 | 6 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45454 | 2022-06-07 | 286.26 | 2171.29 | |
SO56075_1 | 100 | 27914 | 530 | 4 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56075 | 2024-01-31 | 0.40 | 1.87 | |
SO45455_1 | 100 | 14163 | 310 | 8 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45455 | 2022-06-08 | 286.26 | 2171.29 | |
SO56075_2 | 100 | 27914 | 222 | 4 | 2024-02-05 | 0.87 | 2024-01-24 | 34.99 | 2 | SO56075 | 2024-01-31 | 2.80 | 13.09 | |
SO45456_1 | 19 | 23113 | 312 | 6 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45456 | 2022-06-08 | 286.26 | 2171.29 | |
SO56076_1 | 100 | 26335 | 528 | 4 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56076 | 2024-01-31 | 0.40 | 1.87 | |
SO45457_1 | 100 | 27752 | 313 | 6 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45457 | 2022-06-08 | 286.26 | 2171.29 | |
SO56076_2 | 100 | 26335 | 535 | 4 | 2024-02-05 | 0.62 | 2024-01-24 | 24.99 | 2 | SO56076 | 2024-01-31 | 2.00 | 9.35 | |
SO45458_1 | 6 | 19599 | 311 | 9 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45458 | 2022-06-08 | 286.26 | 2171.29 | |
SO56076_3 | 100 | 26335 | 463 | 4 | 2024-02-05 | 0.61 | 2024-01-24 | 24.49 | 3 | SO56076 | 2024-01-31 | 1.96 | 9.16 | |
SO45459_1 | 6 | 19605 | 310 | 9 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45459 | 2022-06-08 | 286.26 | 2171.29 | |
SO56076_4 | 100 | 26335 | 222 | 4 | 2024-02-05 | 0.87 | 2024-01-24 | 34.99 | 4 | SO56076 | 2024-01-31 | 2.80 | 13.09 | |
SO45460_1 | 6 | 25822 | 334 | 9 | 2022-06-13 | 17.48 | 2022-06-01 | 699.10 | 1 | SO45460 | 2022-06-08 | 55.93 | 413.15 | |
SO56077_1 | 19 | 11641 | 528 | 6 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56077 | 2024-01-31 | 0.40 | 1.87 | |
SO45461_1 | 100 | 28646 | 311 | 6 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45461 | 2022-06-09 | 286.26 | 2171.29 | |
SO56077_2 | 19 | 11641 | 536 | 6 | 2024-02-05 | 0.75 | 2024-01-24 | 29.99 | 2 | SO56077 | 2024-01-31 | 2.40 | 11.22 | |
SO45462_1 | 100 | 28647 | 310 | 6 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45462 | 2022-06-09 | 286.26 | 2171.29 | |
SO56077_3 | 19 | 11641 | 217 | 6 | 2024-02-05 | 0.87 | 2024-01-24 | 34.99 | 3 | SO56077 | 2024-01-31 | 2.80 | 13.09 | |
SO45463_1 | 100 | 11171 | 312 | 4 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45463 | 2022-06-09 | 286.26 | 2171.29 | |
SO56078_1 | 100 | 23797 | 540 | 4 | 2024-02-05 | 0.82 | 2024-01-24 | 32.60 | 1 | SO56078 | 2024-01-31 | 2.61 | 12.19 | |
SO45464_1 | 6 | 19586 | 314 | 9 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45464 | 2022-06-09 | 286.26 | 2171.29 | |
SO56078_2 | 100 | 23797 | 214 | 4 | 2024-02-05 | 0.87 | 2024-01-24 | 34.99 | 2 | SO56078 | 2024-01-31 | 2.80 | 13.09 | |
SO45465_1 | 6 | 25819 | 342 | 9 | 2022-06-14 | 17.48 | 2022-06-02 | 699.10 | 1 | SO45465 | 2022-06-09 | 55.93 | 413.15 | |
SO56079_1 | 100 | 22068 | 478 | 4 | 2024-02-05 | 0.25 | 2024-01-24 | 9.99 | 1 | SO56079 | 2024-01-31 | 0.80 | 3.74 | |
SO45466_1 | 6 | 19611 | 311 | 9 | 2022-06-15 | 89.46 | 2022-06-03 | 3578.27 | 1 | SO45466 | 2022-06-10 | 286.26 | 2171.29 | |
SO56079_2 | 100 | 22068 | 477 | 4 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 2 | SO56079 | 2024-01-31 | 0.40 | 1.87 | |
SO45467_1 | 98 | 11422 | 345 | 10 | 2022-06-16 | 85.00 | 2022-06-04 | 3399.99 | 1 | SO45467 | 2022-06-11 | 272.00 | 1912.15 | |
SO56079_3 | 100 | 22068 | 225 | 4 | 2024-02-05 | 0.22 | 2024-01-24 | 8.99 | 3 | SO56079 | 2024-01-31 | 0.72 | 6.92 | |
SO45468_1 | 19 | 23164 | 311 | 6 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45468 | 2022-06-11 | 286.26 | 2171.29 | |
SO56080_1 | 100 | 23002 | 528 | 1 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56080 | 2024-01-31 | 0.40 | 1.87 | |
SO45469_1 | 19 | 19989 | 350 | 6 | 2022-06-16 | 84.37 | 2022-06-04 | 3374.99 | 1 | SO45469 | 2022-06-11 | 270.00 | 1898.09 | |
SO56080_2 | 100 | 23002 | 536 | 1 | 2024-02-05 | 0.75 | 2024-01-24 | 29.99 | 2 | SO56080 | 2024-01-31 | 2.40 | 11.22 | |
SO45470_1 | 100 | 28177 | 312 | 6 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45470 | 2022-06-11 | 286.26 | 2171.29 | |
SO56080_3 | 100 | 23002 | 485 | 1 | 2024-02-05 | 0.55 | 2024-01-24 | 21.98 | 3 | SO56080 | 2024-01-31 | 1.76 | 8.22 | |
SO45471_1 | 100 | 29280 | 313 | 1 | 2022-06-16 | 89.46 | 2022-06-04 | 3578.27 | 1 | SO45471 | 2022-06-11 | 286.26 | 2171.29 | |
SO56080_4 | 100 | 23002 | 480 | 1 | 2024-02-05 | 0.06 | 2024-01-24 | 2.29 | 4 | SO56080 | 2024-01-31 | 0.18 | 0.86 |
Generated 2024-11-10 11:09:15.077 UTC