[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 27 > < TAKE 64 >
64 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55600_3 | 19 | 13101 | 217 | 6 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 3 | SO55600 | 2024-01-22 | 2.80 | 13.09 | |
SO55625_1 | 19 | 11203 | 530 | 6 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55625 | 2024-01-23 | 0.40 | 1.87 | |
SO55625_2 | 19 | 11203 | 480 | 2 | 6 | 2024-01-28 | 0.06 | 2024-01-16 | 2.29 | 2 | SO55625 | 2024-01-23 | 0.18 | 0.86 |
SO55626_1 | 19 | 11091 | 529 | 6 | 2024-01-28 | 0.10 | 2024-01-16 | 3.99 | 1 | SO55626 | 2024-01-23 | 0.32 | 1.49 | |
SO55626_2 | 19 | 11091 | 538 | 6 | 2024-01-28 | 0.54 | 2024-01-16 | 21.49 | 2 | SO55626 | 2024-01-23 | 1.72 | 8.04 | |
SO55626_3 | 19 | 11091 | 480 | 6 | 2024-01-28 | 0.06 | 2024-01-16 | 2.29 | 3 | SO55626 | 2024-01-23 | 0.18 | 0.86 | |
SO55627_1 | 19 | 11506 | 538 | 6 | 2024-01-28 | 0.54 | 2024-01-16 | 21.49 | 1 | SO55627 | 2024-01-23 | 1.72 | 8.04 | |
SO55633_1 | 19 | 15494 | 474 | 6 | 2024-01-28 | 1.75 | 2024-01-16 | 69.99 | 1 | SO55633 | 2024-01-23 | 5.60 | 26.18 | |
SO55633_2 | 19 | 15494 | 228 | 6 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 2 | SO55633 | 2024-01-23 | 4.00 | 38.49 | |
SO55638_1 | 19 | 23498 | 528 | 6 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55638 | 2024-01-23 | 0.40 | 1.87 | |
SO55639_1 | 19 | 19645 | 528 | 6 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55639 | 2024-01-23 | 0.40 | 1.87 | |
SO55639_2 | 19 | 19645 | 217 | 6 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 2 | SO55639 | 2024-01-23 | 2.80 | 13.09 | |
SO55643_1 | 19 | 21471 | 485 | 6 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 1 | SO55643 | 2024-01-23 | 1.76 | 8.22 | |
SO55643_2 | 19 | 21471 | 478 | 6 | 2024-01-28 | 0.25 | 2024-01-16 | 9.99 | 2 | SO55643 | 2024-01-23 | 0.80 | 3.74 | |
SO55657_1 | 19 | 16948 | 485 | 6 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 1 | SO55657 | 2024-01-23 | 1.76 | 8.22 | |
SO55657_2 | 19 | 16948 | 222 | 6 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 2 | SO55657 | 2024-01-23 | 2.80 | 13.09 | |
SO55676_1 | 19 | 18603 | 386 | 6 | 2024-01-28 | 28.01 | 2024-01-16 | 1120.49 | 1 | SO55676 | 2024-01-23 | 89.64 | 713.08 | |
SO55676_2 | 19 | 18603 | 217 | 6 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 2 | SO55676 | 2024-01-23 | 2.80 | 13.09 | |
SO55676_3 | 19 | 18603 | 234 | 6 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 3 | SO55676 | 2024-01-23 | 4.00 | 38.49 | |
SO55691_1 | 19 | 11176 | 237 | 6 | 2024-01-29 | 1.25 | 2024-01-17 | 49.99 | 1 | SO55691 | 2024-01-24 | 4.00 | 38.49 | |
SO55694_1 | 19 | 11677 | 538 | 6 | 2024-01-29 | 0.54 | 2024-01-17 | 21.49 | 1 | SO55694 | 2024-01-24 | 1.72 | 8.04 | |
SO55695_1 | 19 | 11276 | 535 | 6 | 2024-01-29 | 0.62 | 2024-01-17 | 24.99 | 1 | SO55695 | 2024-01-24 | 2.00 | 9.35 | |
SO55695_2 | 19 | 11276 | 528 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 2 | SO55695 | 2024-01-24 | 0.40 | 1.87 | |
SO55697_1 | 19 | 11501 | 530 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 1 | SO55697 | 2024-01-24 | 0.40 | 1.87 | |
SO55699_1 | 19 | 18322 | 528 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 1 | SO55699 | 2024-01-24 | 0.40 | 1.87 | |
SO55699_2 | 19 | 18322 | 536 | 6 | 2024-01-29 | 0.75 | 2024-01-17 | 29.99 | 2 | SO55699 | 2024-01-24 | 2.40 | 11.22 | |
SO55699_3 | 19 | 18322 | 485 | 6 | 2024-01-29 | 0.55 | 2024-01-17 | 21.98 | 3 | SO55699 | 2024-01-24 | 1.76 | 8.22 | |
SO55699_4 | 19 | 18322 | 478 | 6 | 2024-01-29 | 0.25 | 2024-01-17 | 9.99 | 4 | SO55699 | 2024-01-24 | 0.80 | 3.74 | |
SO55699_5 | 19 | 18322 | 477 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 5 | SO55699 | 2024-01-24 | 0.40 | 1.87 | |
SO55699_6 | 19 | 18322 | 463 | 6 | 2024-01-29 | 0.61 | 2024-01-17 | 24.49 | 6 | SO55699 | 2024-01-24 | 1.96 | 9.16 | |
SO55700_1 | 19 | 14626 | 540 | 6 | 2024-01-29 | 0.82 | 2024-01-17 | 32.60 | 1 | SO55700 | 2024-01-24 | 2.61 | 12.19 | |
SO55703_1 | 19 | 14353 | 478 | 6 | 2024-01-29 | 0.25 | 2024-01-17 | 9.99 | 1 | SO55703 | 2024-01-24 | 0.80 | 3.74 | |
SO55703_2 | 19 | 14353 | 477 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 2 | SO55703 | 2024-01-24 | 0.40 | 1.87 | |
SO55704_1 | 19 | 27100 | 477 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 1 | SO55704 | 2024-01-24 | 0.40 | 1.87 | |
SO55704_2 | 19 | 27100 | 480 | 2 | 6 | 2024-01-29 | 0.06 | 2024-01-17 | 2.29 | 2 | SO55704 | 2024-01-24 | 0.18 | 0.86 |
SO55706_1 | 19 | 21815 | 528 | 6 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 1 | SO55706 | 2024-01-24 | 0.40 | 1.87 | |
SO55706_2 | 19 | 21815 | 222 | 6 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 2 | SO55706 | 2024-01-24 | 2.80 | 13.09 | |
SO43697_1 | 19 | 21768 | 310 | 6 | 2021-10-23 | 89.46 | 2021-10-11 | 3578.27 | 1 | SO43697 | 2021-10-18 | 286.26 | 2171.29 | |
SO43769_1 | 19 | 21659 | 312 | 6 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43769 | 2021-11-05 | 286.26 | 2171.29 | |
SO43800_1 | 19 | 21710 | 311 | 6 | 2021-11-15 | 89.46 | 2021-11-03 | 3578.27 | 1 | SO43800 | 2021-11-10 | 286.26 | 2171.29 | |
SO43803_1 | 19 | 21741 | 314 | 6 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43803 | 2021-11-11 | 286.26 | 2171.29 | |
SO43833_1 | 19 | 21727 | 310 | 6 | 2021-11-21 | 89.46 | 2021-11-09 | 3578.27 | 1 | SO43833 | 2021-11-16 | 286.26 | 2171.29 | |
SO43835_1 | 19 | 19802 | 348 | 6 | 2021-11-21 | 84.37 | 2021-11-09 | 3374.99 | 1 | SO43835 | 2021-11-16 | 270.00 | 1898.09 | |
SO43836_1 | 19 | 26620 | 324 | 6 | 2021-11-21 | 17.48 | 2021-11-09 | 699.10 | 1 | SO43836 | 2021-11-16 | 55.93 | 413.15 | |
SO43918_1 | 19 | 22041 | 313 | 6 | 2021-11-23 | 89.46 | 2021-11-11 | 3578.27 | 1 | SO43918 | 2021-11-18 | 286.26 | 2171.29 | |
SO43972_1 | 19 | 21939 | 314 | 6 | 2021-12-04 | 89.46 | 2021-11-22 | 3578.27 | 1 | SO43972 | 2021-11-29 | 286.26 | 2171.29 | |
SO43995_1 | 19 | 21813 | 312 | 6 | 2021-12-10 | 89.46 | 2021-11-28 | 3578.27 | 1 | SO43995 | 2021-12-05 | 286.26 | 2171.29 | |
SO44005_1 | 19 | 26629 | 334 | 6 | 2021-12-11 | 17.48 | 2021-11-29 | 699.10 | 1 | SO44005 | 2021-12-06 | 55.93 | 413.15 | |
SO44022_1 | 19 | 22008 | 313 | 6 | 2021-12-14 | 89.46 | 2021-12-02 | 3578.27 | 1 | SO44022 | 2021-12-09 | 286.26 | 2171.29 | |
SO44023_1 | 19 | 19830 | 349 | 6 | 2021-12-14 | 84.37 | 2021-12-02 | 3374.99 | 1 | SO44023 | 2021-12-09 | 270.00 | 1898.09 | |
SO44027_1 | 19 | 21921 | 310 | 6 | 2021-12-15 | 89.46 | 2021-12-03 | 3578.27 | 1 | SO44027 | 2021-12-10 | 286.26 | 2171.29 | |
SO44064_1 | 19 | 22050 | 310 | 6 | 2021-12-22 | 89.46 | 2021-12-10 | 3578.27 | 1 | SO44064 | 2021-12-17 | 286.26 | 2171.29 | |
SO44070_1 | 19 | 19829 | 349 | 6 | 2021-12-23 | 84.37 | 2021-12-11 | 3374.99 | 1 | SO44070 | 2021-12-18 | 270.00 | 1898.09 | |
SO44136_1 | 19 | 22114 | 311 | 6 | 2021-12-24 | 89.46 | 2021-12-12 | 3578.27 | 1 | SO44136 | 2021-12-19 | 286.26 | 2171.29 | |
SO44142_1 | 19 | 22058 | 313 | 6 | 2021-12-25 | 89.46 | 2021-12-13 | 3578.27 | 1 | SO44142 | 2021-12-20 | 286.26 | 2171.29 | |
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 | |
SO44235_1 | 19 | 22117 | 313 | 6 | 2022-01-14 | 89.46 | 2022-01-02 | 3578.27 | 1 | SO44235 | 2022-01-09 | 286.26 | 2171.29 | |
SO44261_1 | 19 | 22112 | 312 | 6 | 2022-01-19 | 89.46 | 2022-01-07 | 3578.27 | 1 | SO44261 | 2022-01-14 | 286.26 | 2171.29 | |
SO44403_1 | 19 | 19844 | 350 | 6 | 2022-02-06 | 84.37 | 2022-01-25 | 3374.99 | 1 | SO44403 | 2022-02-01 | 270.00 | 1898.09 | |
SO44436_1 | 19 | 26630 | 322 | 6 | 2022-02-13 | 17.48 | 2022-02-01 | 699.10 | 1 | SO44436 | 2022-02-08 | 55.93 | 413.15 | |
SO44441_1 | 19 | 22118 | 312 | 6 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44441 | 2022-02-09 | 286.26 | 2171.29 | |
SO44464_1 | 19 | 22120 | 314 | 6 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44464 | 2022-02-15 | 286.26 | 2171.29 | |
SO44466_1 | 19 | 26640 | 334 | 6 | 2022-02-20 | 17.48 | 2022-02-08 | 699.10 | 1 | SO44466 | 2022-02-15 | 55.93 | 413.15 | |
SO44588_1 | 19 | 26683 | 342 | 6 | 2022-02-26 | 17.48 | 2022-02-14 | 699.10 | 1 | SO44588 | 2022-02-21 | 55.93 | 413.15 |
Generated 2024-11-11 00:10:12.733 UTC