[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2547 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Generated 2024-11-10 14:20:45.150 UTC