[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 1246 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57336_1 | 19 | 18978 | 485 | 6 | 2024-01-05 | 0.55 | 2023-12-24 | 21.98 | 1 | SO57336 | 2023-12-31 | 1.76 | 8.22 | |
SO57336_2 | 19 | 18978 | 465 | 6 | 2024-01-05 | 0.61 | 2023-12-24 | 24.49 | 2 | SO57336 | 2023-12-31 | 1.96 | 9.16 | |
SO57336_3 | 19 | 18978 | 214 | 6 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 3 | SO57336 | 2023-12-31 | 2.80 | 13.09 | |
SO57342_1 | 19 | 14661 | 528 | 6 | 2024-01-05 | 0.12 | 2023-12-24 | 4.99 | 1 | SO57342 | 2023-12-31 | 0.40 | 1.87 | |
SO57342_2 | 19 | 14661 | 537 | 6 | 2024-01-05 | 0.88 | 2023-12-24 | 35.00 | 2 | SO57342 | 2023-12-31 | 2.80 | 13.09 | |
SO57342_3 | 19 | 14661 | 217 | 6 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 3 | SO57342 | 2023-12-31 | 2.80 | 13.09 | |
SO57350_1 | 19 | 16784 | 581 | 6 | 2024-01-05 | 42.52 | 2023-12-24 | 1700.99 | 1 | SO57350 | 2023-12-31 | 136.08 | 1082.51 | |
SO57350_2 | 19 | 16784 | 222 | 6 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 2 | SO57350 | 2023-12-31 | 2.80 | 13.09 | |
SO57352_1 | 19 | 14387 | 590 | 6 | 2024-01-05 | 19.24 | 2023-12-24 | 769.49 | 1 | SO57352 | 2023-12-31 | 61.56 | 419.78 | |
SO57352_2 | 19 | 14387 | 476 | 6 | 2024-01-05 | 1.75 | 2023-12-24 | 69.99 | 2 | SO57352 | 2023-12-31 | 5.60 | 26.18 | |
SO57352_3 | 19 | 14387 | 225 | 6 | 2024-01-05 | 0.22 | 2023-12-24 | 8.99 | 3 | SO57352 | 2023-12-31 | 0.72 | 6.92 | |
SO57352_4 | 19 | 14387 | 228 | 6 | 2024-01-05 | 1.25 | 2023-12-24 | 49.99 | 4 | SO57352 | 2023-12-31 | 4.00 | 38.49 | |
SO57366_1 | 19 | 21582 | 606 | 6 | 2024-01-05 | 13.50 | 2023-12-24 | 539.99 | 1 | SO57366 | 2023-12-31 | 43.20 | 343.65 | |
SO57366_2 | 19 | 21582 | 479 | 6 | 2024-01-05 | 0.22 | 2023-12-24 | 8.99 | 2 | SO57366 | 2023-12-31 | 0.72 | 3.36 | |
SO57366_3 | 19 | 21582 | 477 | 6 | 2024-01-05 | 0.12 | 2023-12-24 | 4.99 | 3 | SO57366 | 2023-12-31 | 0.40 | 1.87 | |
SO57366_4 | 19 | 21582 | 217 | 6 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 4 | SO57366 | 2023-12-31 | 2.80 | 13.09 | |
SO57367_1 | 19 | 18841 | 388 | 6 | 2024-01-05 | 28.01 | 2023-12-24 | 1120.49 | 1 | SO57367 | 2023-12-31 | 89.64 | 713.08 | |
SO57367_2 | 19 | 18841 | 539 | 6 | 2024-01-05 | 0.62 | 2023-12-24 | 24.99 | 2 | SO57367 | 2023-12-31 | 2.00 | 9.35 | |
SO57370_1 | 19 | 11212 | 231 | 6 | 2024-01-06 | 1.25 | 2023-12-25 | 49.99 | 1 | SO57370 | 2024-01-01 | 4.00 | 38.49 | |
SO57380_1 | 19 | 11212 | 480 | 6 | 2024-01-06 | 0.06 | 2023-12-25 | 2.29 | 1 | SO57380 | 2024-01-01 | 0.18 | 0.86 | |
SO57387_1 | 19 | 13941 | 529 | 6 | 2024-01-06 | 0.10 | 2023-12-25 | 3.99 | 1 | SO57387 | 2024-01-01 | 0.32 | 1.49 | |
SO57387_2 | 19 | 13941 | 540 | 6 | 2024-01-06 | 0.82 | 2023-12-25 | 32.60 | 2 | SO57387 | 2024-01-01 | 2.61 | 12.19 | |
SO57387_3 | 19 | 13941 | 480 | 6 | 2024-01-06 | 0.06 | 2023-12-25 | 2.29 | 3 | SO57387 | 2024-01-01 | 0.18 | 0.86 | |
SO57392_1 | 19 | 11868 | 478 | 6 | 2024-01-06 | 0.25 | 2023-12-25 | 9.99 | 1 | SO57392 | 2024-01-01 | 0.80 | 3.74 | |
SO57392_2 | 19 | 11868 | 477 | 6 | 2024-01-06 | 0.12 | 2023-12-25 | 4.99 | 2 | SO57392 | 2024-01-01 | 0.40 | 1.87 | |
SO57394_1 | 19 | 27049 | 477 | 6 | 2024-01-06 | 0.12 | 2023-12-25 | 4.99 | 1 | SO57394 | 2024-01-01 | 0.40 | 1.87 | |
SO57397_1 | 19 | 22359 | 528 | 6 | 2024-01-06 | 0.12 | 2023-12-25 | 4.99 | 1 | SO57397 | 2024-01-01 | 0.40 | 1.87 | |
SO57397_2 | 19 | 22359 | 480 | 2 | 6 | 2024-01-06 | 0.06 | 2023-12-25 | 2.29 | 2 | SO57397 | 2024-01-01 | 0.18 | 0.86 |
SO57405_1 | 19 | 13231 | 528 | 6 | 2024-01-06 | 0.12 | 2023-12-25 | 4.99 | 1 | SO57405 | 2024-01-01 | 0.40 | 1.87 | |
SO57405_2 | 19 | 13231 | 537 | 6 | 2024-01-06 | 0.88 | 2023-12-25 | 35.00 | 2 | SO57405 | 2024-01-01 | 2.80 | 13.09 | |
SO57405_3 | 19 | 13231 | 222 | 6 | 2024-01-06 | 0.87 | 2023-12-25 | 34.99 | 3 | SO57405 | 2024-01-01 | 2.80 | 13.09 | |
SO57408_1 | 19 | 13303 | 537 | 6 | 2024-01-06 | 0.88 | 2023-12-25 | 35.00 | 1 | SO57408 | 2024-01-01 | 2.80 | 13.09 | |
SO57408_2 | 19 | 13303 | 528 | 6 | 2024-01-06 | 0.12 | 2023-12-25 | 4.99 | 2 | SO57408 | 2024-01-01 | 0.40 | 1.87 | |
SO57408_3 | 19 | 13303 | 480 | 6 | 2024-01-06 | 0.06 | 2023-12-25 | 2.29 | 3 | SO57408 | 2024-01-01 | 0.18 | 0.86 | |
SO45355_1 | 100 | 28778 | 312 | 6 | 2022-04-06 | 89.46 | 2022-03-25 | 3578.27 | 1 | SO45355 | 2022-04-01 | 286.26 | 2171.29 | |
SO45358_1 | 19 | 23172 | 312 | 6 | 2022-04-07 | 89.46 | 2022-03-26 | 3578.27 | 1 | SO45358 | 2022-04-02 | 286.26 | 2171.29 | |
SO45360_1 | 100 | 28036 | 313 | 6 | 2022-04-07 | 89.46 | 2022-03-26 | 3578.27 | 1 | SO45360 | 2022-04-02 | 286.26 | 2171.29 | |
SO45361_1 | 19 | 23057 | 312 | 6 | 2022-04-07 | 89.46 | 2022-03-26 | 3578.27 | 1 | SO45361 | 2022-04-02 | 286.26 | 2171.29 | |
SO45374_1 | 19 | 22996 | 312 | 6 | 2022-04-09 | 89.46 | 2022-03-28 | 3578.27 | 1 | SO45374 | 2022-04-04 | 286.26 | 2171.29 | |
SO45378_1 | 100 | 28178 | 310 | 6 | 2022-04-10 | 89.46 | 2022-03-29 | 3578.27 | 1 | SO45378 | 2022-04-05 | 286.26 | 2171.29 | |
SO45379_1 | 100 | 28363 | 313 | 6 | 2022-04-10 | 89.46 | 2022-03-29 | 3578.27 | 1 | SO45379 | 2022-04-05 | 286.26 | 2171.29 | |
SO45381_1 | 19 | 19988 | 344 | 6 | 2022-04-10 | 85.00 | 2022-03-29 | 3399.99 | 1 | SO45381 | 2022-04-05 | 272.00 | 1912.15 | |
SO45384_1 | 19 | 26789 | 338 | 6 | 2022-04-10 | 17.48 | 2022-03-29 | 699.10 | 1 | SO45384 | 2022-04-05 | 55.93 | 413.15 | |
SO45403_1 | 19 | 23114 | 314 | 6 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45403 | 2022-04-09 | 286.26 | 2171.29 | |
SO45405_1 | 19 | 23209 | 312 | 6 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO45405 | 2022-04-09 | 286.26 | 2171.29 | |
SO45411_1 | 100 | 28197 | 313 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45411 | 2022-04-10 | 286.26 | 2171.29 | |
SO45412_1 | 19 | 23137 | 310 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45412 | 2022-04-10 | 286.26 | 2171.29 | |
SO45415_1 | 100 | 28092 | 312 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45415 | 2022-04-10 | 286.26 | 2171.29 | |
SO45416_1 | 100 | 28161 | 310 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45416 | 2022-04-10 | 286.26 | 2171.29 | |
SO45417_1 | 100 | 28620 | 310 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO45417 | 2022-04-10 | 286.26 | 2171.29 | |
SO45422_1 | 100 | 28198 | 310 | 6 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO45422 | 2022-04-11 | 286.26 | 2171.29 | |
SO45423_1 | 19 | 19997 | 348 | 6 | 2022-04-16 | 84.37 | 2022-04-04 | 3374.99 | 1 | SO45423 | 2022-04-11 | 270.00 | 1898.09 | |
SO45424_1 | 100 | 28165 | 311 | 6 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO45424 | 2022-04-11 | 286.26 | 2171.29 | |
SO45429_1 | 100 | 28129 | 310 | 6 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45429 | 2022-04-12 | 286.26 | 2171.29 | |
SO45430_1 | 100 | 28176 | 312 | 6 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45430 | 2022-04-12 | 286.26 | 2171.29 | |
SO45431_1 | 100 | 28013 | 311 | 6 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45431 | 2022-04-12 | 286.26 | 2171.29 | |
SO45436_1 | 100 | 28130 | 312 | 6 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45436 | 2022-04-13 | 286.26 | 2171.29 | |
SO45437_1 | 100 | 28169 | 312 | 6 | 2022-04-18 | 89.46 | 2022-04-06 | 3578.27 | 1 | SO45437 | 2022-04-13 | 286.26 | 2171.29 | |
SO45450_1 | 100 | 28624 | 312 | 6 | 2022-04-21 | 89.46 | 2022-04-09 | 3578.27 | 1 | SO45450 | 2022-04-16 | 286.26 | 2171.29 | |
SO45454_1 | 19 | 23074 | 312 | 6 | 2022-04-22 | 89.46 | 2022-04-10 | 3578.27 | 1 | SO45454 | 2022-04-17 | 286.26 | 2171.29 |
Generated 2024-09-20 09:01:58.312 UTC