[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 187 < SKIP 1005 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50587_1 | 100 | 27262 | 360 | 1 | 2023-07-28 | 51.23 | 2023-07-16 | 2049.10 | 1 | SO50587 | 2023-07-23 | 163.93 | 1105.81 | |
SO50596_1 | 100 | 27416 | 362 | 2 | 1 | 2023-07-29 | 51.23 | 2023-07-17 | 2049.10 | 1 | SO50596 | 2023-07-24 | 163.93 | 1105.81 |
SO50598_1 | 100 | 27271 | 354 | 1 | 2023-07-29 | 51.79 | 2023-07-17 | 2071.42 | 1 | SO50598 | 2023-07-24 | 165.71 | 1117.86 | |
SO50605_1 | 100 | 27450 | 354 | 1 | 2023-07-30 | 51.79 | 2023-07-18 | 2071.42 | 1 | SO50605 | 2023-07-25 | 165.71 | 1117.86 | |
SO50618_1 | 100 | 27431 | 360 | 1 | 2023-07-31 | 51.23 | 2023-07-19 | 2049.10 | 1 | SO50618 | 2023-07-26 | 163.93 | 1105.81 | |
SO50633_1 | 100 | 14420 | 387 | 1 | 2023-08-01 | 25.01 | 2023-07-20 | 1000.44 | 1 | SO50633 | 2023-07-27 | 80.04 | 605.65 | |
SO50641_1 | 100 | 27455 | 354 | 1 | 2023-08-02 | 51.79 | 2023-07-21 | 2071.42 | 1 | SO50641 | 2023-07-28 | 165.71 | 1117.86 | |
SO50651_1 | 100 | 15888 | 335 | 1 | 2023-08-02 | 19.57 | 2023-07-21 | 782.99 | 1 | SO50651 | 2023-07-28 | 62.64 | 486.71 | |
SO50760_1 | 100 | 27549 | 354 | 1 | 2023-08-03 | 51.79 | 2023-07-22 | 2071.42 | 1 | SO50760 | 2023-07-29 | 165.71 | 1117.86 | |
SO50766_1 | 100 | 13977 | 369 | 2 | 1 | 2023-08-03 | 61.08 | 2023-07-22 | 2443.35 | 1 | SO50766 | 2023-07-29 | 195.47 | 1518.79 |
SO50791_1 | 100 | 15969 | 341 | 1 | 2023-08-05 | 19.57 | 2023-07-24 | 782.99 | 1 | SO50791 | 2023-07-31 | 62.64 | 486.71 | |
SO50802_1 | 100 | 14494 | 385 | 1 | 2023-08-06 | 25.01 | 2023-07-25 | 1000.44 | 1 | SO50802 | 2023-08-01 | 80.04 | 605.65 | |
SO50825_1 | 100 | 27570 | 352 | 1 | 2023-08-09 | 51.79 | 2023-07-28 | 2071.42 | 1 | SO50825 | 2023-08-04 | 165.71 | 1117.86 | |
SO50845_1 | 100 | 13947 | 375 | 1 | 2023-08-10 | 54.54 | 2023-07-29 | 2181.56 | 1 | SO50845 | 2023-08-05 | 174.53 | 1320.68 | |
SO50846_1 | 100 | 13979 | 368 | 1 | 2023-08-10 | 61.08 | 2023-07-29 | 2443.35 | 1 | SO50846 | 2023-08-05 | 195.47 | 1518.79 | |
SO50853_1 | 100 | 27542 | 356 | 1 | 2023-08-11 | 51.79 | 2023-07-30 | 2071.42 | 1 | SO50853 | 2023-08-06 | 165.71 | 1117.86 | |
SO50854_1 | 100 | 27551 | 358 | 1 | 2023-08-11 | 51.23 | 2023-07-30 | 2049.10 | 1 | SO50854 | 2023-08-06 | 163.93 | 1105.81 | |
SO50855_1 | 100 | 27558 | 358 | 1 | 2023-08-11 | 51.23 | 2023-07-30 | 2049.10 | 1 | SO50855 | 2023-08-06 | 163.93 | 1105.81 | |
SO50860_1 | 100 | 27504 | 352 | 1 | 2023-08-12 | 51.79 | 2023-07-31 | 2071.42 | 1 | SO50860 | 2023-08-07 | 165.71 | 1117.86 | |
SO50866_1 | 100 | 15991 | 333 | 1 | 2023-08-12 | 19.57 | 2023-07-31 | 782.99 | 1 | SO50866 | 2023-08-07 | 62.64 | 486.71 | |
SO50891_1 | 100 | 15976 | 339 | 1 | 2023-08-14 | 19.57 | 2023-08-02 | 782.99 | 1 | SO50891 | 2023-08-09 | 62.64 | 486.71 | |
SO50905_1 | 100 | 27576 | 352 | 1 | 2023-08-16 | 51.79 | 2023-08-04 | 2071.42 | 1 | SO50905 | 2023-08-11 | 165.71 | 1117.86 | |
SO50916_1 | 100 | 27531 | 354 | 1 | 2023-08-17 | 51.79 | 2023-08-05 | 2071.42 | 1 | SO50916 | 2023-08-12 | 165.71 | 1117.86 | |
SO50935_1 | 100 | 15980 | 321 | 1 | 2023-08-18 | 19.57 | 2023-08-06 | 782.99 | 1 | SO50935 | 2023-08-13 | 62.64 | 486.71 | |
SO56952_3 | 100 | 22074 | 477 | 1 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 3 | SO56952 | 2023-12-27 | 0.40 | 1.87 | |
SO56970_1 | 100 | 27221 | 529 | 1 | 2024-01-02 | 0.10 | 2023-12-21 | 3.99 | 1 | SO56970 | 2023-12-28 | 0.32 | 1.49 | |
SO56974_1 | 100 | 23389 | 536 | 1 | 2024-01-02 | 0.75 | 2023-12-21 | 29.99 | 1 | SO56974 | 2023-12-28 | 2.40 | 11.22 | |
SO56974_2 | 100 | 23389 | 528 | 1 | 2024-01-02 | 0.12 | 2023-12-21 | 4.99 | 2 | SO56974 | 2023-12-28 | 0.40 | 1.87 | |
SO56974_3 | 100 | 23389 | 480 | 1 | 2024-01-02 | 0.06 | 2023-12-21 | 2.29 | 3 | SO56974 | 2023-12-28 | 0.18 | 0.86 | |
SO56982_1 | 100 | 17486 | 528 | 1 | 2024-01-02 | 0.12 | 2023-12-21 | 4.99 | 1 | SO56982 | 2023-12-28 | 0.40 | 1.87 | |
SO56982_2 | 100 | 17486 | 217 | 1 | 2024-01-02 | 0.87 | 2023-12-21 | 34.99 | 2 | SO56982 | 2023-12-28 | 2.80 | 13.09 | |
SO56982_3 | 100 | 17486 | 228 | 1 | 2024-01-02 | 1.25 | 2023-12-21 | 49.99 | 3 | SO56982 | 2023-12-28 | 4.00 | 38.49 | |
SO56995_1 | 100 | 13067 | 596 | 1 | 2024-01-02 | 13.50 | 2023-12-21 | 539.99 | 1 | SO56995 | 2023-12-28 | 43.20 | 294.58 | |
SO56995_2 | 100 | 13067 | 485 | 1 | 2024-01-02 | 0.55 | 2023-12-21 | 21.98 | 2 | SO56995 | 2023-12-28 | 1.76 | 8.22 | |
SO56995_3 | 100 | 13067 | 488 | 1 | 2024-01-02 | 1.35 | 2023-12-21 | 53.99 | 3 | SO56995 | 2023-12-28 | 4.32 | 41.57 | |
SO56997_1 | 100 | 11696 | 363 | 2 | 1 | 2024-01-02 | 57.37 | 2023-12-21 | 2294.99 | 1 | SO56997 | 2023-12-28 | 183.60 | 1251.98 |
SO57005_1 | 100 | 25379 | 577 | 1 | 2024-01-02 | 30.37 | 2023-12-21 | 1214.85 | 1 | SO57005 | 2023-12-28 | 97.19 | 755.15 | |
SO57200_1 | 100 | 29073 | 529 | 1 | 2024-01-03 | 0.10 | 2023-12-22 | 3.99 | 1 | SO57200 | 2023-12-29 | 0.32 | 1.49 | |
SO57200_2 | 100 | 29073 | 214 | 1 | 2024-01-03 | 0.87 | 2023-12-22 | 34.99 | 2 | SO57200 | 2023-12-29 | 2.80 | 13.09 | |
SO57204_1 | 100 | 26680 | 535 | 1 | 2024-01-03 | 0.62 | 2023-12-22 | 24.99 | 1 | SO57204 | 2023-12-29 | 2.00 | 9.35 | |
SO57204_2 | 100 | 26680 | 528 | 1 | 2024-01-03 | 0.12 | 2023-12-22 | 4.99 | 2 | SO57204 | 2023-12-29 | 0.40 | 1.87 | |
SO57204_3 | 100 | 26680 | 480 | 2 | 1 | 2024-01-03 | 0.06 | 2023-12-22 | 2.29 | 3 | SO57204 | 2023-12-29 | 0.18 | 0.86 |
SO57208_1 | 100 | 21753 | 478 | 1 | 2024-01-03 | 0.25 | 2023-12-22 | 9.99 | 1 | SO57208 | 2023-12-29 | 0.80 | 3.74 | |
SO57208_2 | 100 | 21753 | 472 | 1 | 2024-01-03 | 1.59 | 2023-12-22 | 63.50 | 2 | SO57208 | 2023-12-29 | 5.08 | 23.75 | |
SO57208_3 | 100 | 21753 | 477 | 1 | 2024-01-03 | 0.12 | 2023-12-22 | 4.99 | 3 | SO57208 | 2023-12-29 | 0.40 | 1.87 | |
SO57210_1 | 100 | 20530 | 478 | 1 | 2024-01-03 | 0.25 | 2023-12-22 | 9.99 | 1 | SO57210 | 2023-12-29 | 0.80 | 3.74 | |
SO57210_2 | 100 | 20530 | 477 | 1 | 2024-01-03 | 0.12 | 2023-12-22 | 4.99 | 2 | SO57210 | 2023-12-29 | 0.40 | 1.87 | |
SO57210_3 | 100 | 20530 | 214 | 1 | 2024-01-03 | 0.87 | 2023-12-22 | 34.99 | 3 | SO57210 | 2023-12-29 | 2.80 | 13.09 | |
SO57210_4 | 100 | 20530 | 489 | 1 | 2024-01-03 | 1.35 | 2023-12-22 | 53.99 | 4 | SO57210 | 2023-12-29 | 4.32 | 41.57 | |
SO57222_1 | 100 | 11014 | 537 | 1 | 2024-01-03 | 0.88 | 2023-12-22 | 35.00 | 1 | SO57222 | 2023-12-29 | 2.80 | 13.09 | |
SO57222_2 | 100 | 11014 | 528 | 1 | 2024-01-03 | 0.12 | 2023-12-22 | 4.99 | 2 | SO57222 | 2023-12-29 | 0.40 | 1.87 | |
SO57222_3 | 100 | 11014 | 217 | 1 | 2024-01-03 | 0.87 | 2023-12-22 | 34.99 | 3 | SO57222 | 2023-12-29 | 2.80 | 13.09 | |
SO57222_4 | 100 | 11014 | 465 | 1 | 2024-01-03 | 0.61 | 2023-12-22 | 24.49 | 4 | SO57222 | 2023-12-29 | 1.96 | 9.16 | |
SO57235_1 | 100 | 28871 | 569 | 1 | 2024-01-03 | 18.56 | 2023-12-22 | 742.35 | 1 | SO57235 | 2023-12-29 | 59.39 | 461.44 | |
SO57235_2 | 100 | 28871 | 222 | 1 | 2024-01-03 | 0.87 | 2023-12-22 | 34.99 | 2 | SO57235 | 2023-12-29 | 2.80 | 13.09 | |
SO57235_3 | 100 | 28871 | 225 | 1 | 2024-01-03 | 0.22 | 2023-12-22 | 8.99 | 3 | SO57235 | 2023-12-29 | 0.72 | 6.92 | |
SO57235_4 | 100 | 28871 | 231 | 1 | 2024-01-03 | 1.25 | 2023-12-22 | 49.99 | 4 | SO57235 | 2023-12-29 | 4.00 | 38.49 | |
SO57259_1 | 100 | 25338 | 535 | 1 | 2024-01-04 | 0.62 | 2023-12-23 | 24.99 | 1 | SO57259 | 2023-12-30 | 2.00 | 9.35 | |
SO57259_2 | 100 | 25338 | 480 | 1 | 2024-01-04 | 0.06 | 2023-12-23 | 2.29 | 2 | SO57259 | 2023-12-30 | 0.18 | 0.86 | |
SO57262_1 | 100 | 23282 | 536 | 1 | 2024-01-04 | 0.75 | 2023-12-23 | 29.99 | 1 | SO57262 | 2023-12-30 | 2.40 | 11.22 |
Generated 2024-09-20 09:40:13.937 UTC