[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 1250 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47975_21 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 331 | 558 | 2 | 2023-02-23 | 939.59 | 23.49 | 2023-02-11 | 2 | 486.71 | 1 | 939.59 | 21 | SO47975 | 2023-02-18 | 75.17 | 973.41 | 469.79 |
SO44502_6 | 5EC5-4410-9C | PO16791147707 | 100 | 281 | 342 | 36 | 2 | 2022-02-23 | 2516.75 | 62.92 | 2022-02-11 | 6 | 413.15 | 1 | 2516.75 | 6 | SO44502 | 2022-02-18 | 201.34 | 2478.88 | 419.46 |
SO49864_17 | D282-4C24-9B | PO13775121562 | 100 | 283 | 456 | 618 | 2 | 2023-07-24 | 134.98 | 3.37 | 2023-07-12 | 3 | 30.93 | 1 | 134.98 | 17 | SO49864 | 2023-07-19 | 10.80 | 92.80 | 44.99 |
SO46986_2 | A56F-42B9-BB | PO12383199580 | 100 | 281 | 433 | 89 | 2 | 2022-11-23 | 973.36 | 24.33 | 2022-11-11 | 3 | 300.12 | 1 | 973.36 | 2 | SO46986 | 2022-11-18 | 77.87 | 900.36 | 324.45 |
SO50733_2 | CFF7-40BF-8E | PO4756133761 | 100 | 283 | 333 | 126 | 2 | 2023-09-23 | 939.59 | 23.49 | 2023-09-11 | 2 | 486.71 | 1 | 939.59 | 2 | SO50733 | 2023-09-18 | 75.17 | 973.41 | 469.79 |
SO46368_15 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 330 | 143 | 2 | 2022-09-23 | 419.46 | 10.49 | 2022-09-11 | 1 | 413.15 | 1 | 419.46 | 15 | SO46368 | 2022-09-18 | 33.56 | 413.15 | 419.46 |
SO49123_19 | FDE5-41D0-A8 | PO18386193475 | 100 | 283 | 389 | 558 | 2 | 2023-05-26 | 1200.53 | 30.01 | 2023-05-14 | 2 | 605.65 | 1 | 1200.53 | 19 | SO49123 | 2023-05-21 | 96.04 | 1211.30 | 600.26 |
SO48788_8 | DD66-4EC8-BF | PO6699145127 | 100 | 283 | 337 | 234 | 2 | 2023-04-25 | 469.79 | 11.74 | 2023-04-13 | 1 | 486.71 | 1 | 469.79 | 8 | SO48788 | 2023-04-20 | 37.58 | 486.71 | 469.79 |
SO48002_1 | C49A-4171-8A | PO14326161105 | 100 | 281 | 329 | 107 | 2 | 2023-02-23 | 2818.76 | 70.47 | 2023-02-11 | 6 | 486.71 | 1 | 2818.76 | 1 | SO48002 | 2023-02-18 | 225.50 | 2920.24 | 469.79 |
SO57091_9 | 46C3-4CC4-85 | PO18792158206 | 100 | 283 | 361 | 378 | 2 | 2024-02-23 | 1376.99 | 34.42 | 2024-02-11 | 1 | 1251.98 | 1 | 1376.99 | 9 | SO57091 | 2024-02-18 | 110.16 | 1251.98 | 1376.99 |
SO67263_4 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 600 | 125 | 2 | 2024-07-24 | 971.98 | 24.30 | 2024-07-12 | 3 | 294.58 | 1 | 971.98 | 4 | SO67263 | 2024-07-19 | 77.76 | 883.74 | 323.99 |
SO51743_3 | 4DE3-4586-96 | PO12006129958 | 100 | 283 | 243 | 270 | 2 | 2023-11-23 | 1717.80 | 42.95 | 2023-11-11 | 2 | 868.63 | 1 | 1717.80 | 3 | SO51743 | 2023-11-18 | 137.42 | 1737.27 | 858.90 |
SO55301_7 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 487 | 414 | 2 | 2024-01-23 | 98.98 | 2.47 | 2024-01-11 | 3 | 20.57 | 1 | 98.98 | 7 | SO55301 | 2024-01-18 | 7.92 | 61.70 | 32.99 |
SO45053_1 | 1527-4B4C-8B | PO13775163879 | 100 | 281 | 334 | 618 | 2 | 2022-04-25 | 419.46 | 10.49 | 2022-04-13 | 1 | 413.15 | 1 | 419.46 | 1 | SO45053 | 2022-04-20 | 33.56 | 413.15 | 419.46 |
SO49843_12 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 366 | 594 | 2 | 2023-07-24 | 3239.97 | 81.00 | 2023-07-12 | 5 | 598.44 | 1 | 3239.97 | 12 | SO49843 | 2023-07-19 | 259.20 | 2992.18 | 647.99 |
SO57098_2 | 310D-44B7-88 | PO18183184808 | 100 | 283 | 475 | 667 | 2 | 2024-02-23 | 167.98 | 4.20 | 2024-02-11 | 4 | 26.18 | 1 | 167.98 | 2 | SO57098 | 2024-02-18 | 13.44 | 104.71 | 41.99 |
SO50259_16 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 230 | 558 | 2 | 2023-08-23 | 86.52 | 2.16 | 2023-08-11 | 3 | 29.08 | 1 | 86.52 | 16 | SO50259 | 2023-08-18 | 6.92 | 87.24 | 28.84 |
SO47055_5 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 445 | 108 | 2 | 2022-11-23 | 215.96 | 5.40 | 2022-11-11 | 6 | 24.75 | 1 | 215.96 | 5 | SO47055 | 2022-11-18 | 17.28 | 148.48 | 35.99 |
SO45793_8 | 0B18-49B2-96 | PO13775113238 | 100 | 281 | 316 | 618 | 2 | 2022-07-24 | 874.79 | 21.87 | 2022-07-12 | 1 | 884.71 | 1 | 874.79 | 8 | SO45793 | 2022-07-19 | 69.98 | 884.71 | 874.79 |
SO49888_43 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 435 | 234 | 2 | 2023-07-24 | 648.91 | 16.22 | 2023-07-12 | 2 | 300.12 | 1 | 648.91 | 43 | SO49888 | 2023-07-19 | 51.91 | 600.24 | 324.45 |
SO49123_18 | FDE5-41D0-A8 | PO18386193475 | 100 | 283 | 387 | 558 | 2 | 2023-05-26 | 1800.79 | 45.02 | 2023-05-14 | 3 | 605.65 | 1 | 1800.79 | 18 | SO49123 | 2023-05-21 | 144.06 | 1816.95 | 600.26 |
SO44778_5 | 32B2-4FA6-81 | PO3190112662 | 100 | 281 | 316 | 575 | 2 | 2022-03-25 | 6123.56 | 153.09 | 2022-03-13 | 7 | 884.71 | 1 | 6123.56 | 5 | SO44778 | 2022-03-20 | 489.88 | 6192.96 | 874.79 |
SO46036_1 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 262 | 558 | 2 | 2022-08-23 | 183.94 | 4.60 | 2022-08-11 | 1 | 181.49 | 1 | 183.94 | 1 | SO46036 | 2022-08-18 | 14.72 | 181.49 | 183.94 |
SO44293_10 | A1AE-48E7-A4 | PO13775127212 | 100 | 281 | 215 | 618 | 2 | 2022-01-23 | 80.75 | 2.02 | 2022-01-11 | 4 | 12.03 | 1 | 80.75 | 10 | SO44293 | 2022-01-18 | 6.46 | 48.11 | 20.19 |
SO49123_20 | FDE5-41D0-A8 | PO18386193475 | 100 | 283 | 370 | 558 | 2 | 2023-05-26 | 1466.01 | 36.65 | 2023-05-14 | 1 | 1518.79 | 1 | 1466.01 | 20 | SO49123 | 2023-05-21 | 117.28 | 1518.79 | 1466.01 |
SO46036_7 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 212 | 558 | 2 | 2022-08-23 | 80.75 | 2.02 | 2022-08-11 | 4 | 12.03 | 1 | 80.75 | 7 | SO46036 | 2022-08-18 | 6.46 | 48.11 | 20.19 |
SO58950_22 | E67E-435E-9F | PO11455199372 | 100 | 283 | 546 | 72 | 2 | 2024-03-24 | 149.02 | 3.73 | 2024-03-12 | 4 | 27.57 | 1 | 149.02 | 22 | SO58950 | 2024-03-19 | 11.92 | 110.27 | 37.25 |
SO51157_10 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 476 | 414 | 2 | 2023-10-23 | 125.98 | 3.15 | 2023-10-11 | 3 | 26.18 | 1 | 125.98 | 10 | SO51157 | 2023-10-18 | 10.08 | 78.53 | 41.99 |
SO46655_14 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 365 | 414 | 2 | 2022-10-23 | 1295.99 | 32.40 | 2022-10-11 | 2 | 598.44 | 1 | 1295.99 | 14 | SO46655 | 2022-10-18 | 103.68 | 1196.87 | 647.99 |
SO47730_2 | 4D13-42BB-90 | PO10092115748 | 100 | 272 | 410 | 252 | 2 | 2023-01-23 | 72.89 | 1.82 | 2023-01-11 | 2 | 26.97 | 1 | 72.89 | 2 | SO47730 | 2023-01-18 | 5.83 | 53.94 | 36.45 |
SO55259_14 | 68EA-4A46-81 | PO11687179986 | 100 | 283 | 567 | 691 | 2 | 2024-01-23 | 445.41 | 11.14 | 2024-01-11 | 1 | 461.44 | 1 | 445.41 | 14 | SO55259 | 2024-01-18 | 35.63 | 461.44 | 445.41 |
SO57164_7 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 605 | 540 | 2 | 2024-02-23 | 647.99 | 16.20 | 2024-02-11 | 2 | 343.65 | 1 | 647.99 | 7 | SO57164 | 2024-02-18 | 51.84 | 687.30 | 323.99 |
SO49157_13 | 9DDB-4852-A8 | PO7424122254 | 100 | 283 | 366 | 642 | 2 | 2023-05-26 | 3239.97 | 81.00 | 2023-05-14 | 5 | 598.44 | 1 | 3239.97 | 13 | SO49157 | 2023-05-21 | 259.20 | 2992.18 | 647.99 |
SO44782_12 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 272 | 143 | 2 | 2022-03-25 | 551.81 | 13.80 | 2022-03-13 | 3 | 181.49 | 1 | 551.81 | 12 | SO44782 | 2022-03-20 | 44.15 | 544.46 | 183.94 |
SO50277_4 | A5F8-42BE-8F | PO14326124278 | 100 | 283 | 329 | 107 | 2 | 2023-08-23 | 939.59 | 23.49 | 2023-08-11 | 2 | 486.71 | 1 | 939.59 | 4 | SO50277 | 2023-08-18 | 75.17 | 973.41 | 469.79 |
SO46376_1 | 0C79-48C0-B9 | PO6322128191 | 100 | 281 | 326 | 503 | 2 | 2022-09-23 | 419.46 | 10.49 | 2022-09-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO46376 | 2022-09-18 | 33.56 | 413.15 | 419.46 |
SO51860_3 | 3799-43C6-B7 | PO3625164674 | 100 | 283 | 442 | 666 | 2 | 2023-11-23 | 2576.70 | 64.42 | 2023-11-11 | 3 | 868.63 | 1 | 2576.70 | 3 | SO51860 | 2023-11-18 | 206.14 | 2605.90 | 858.90 |
SO49877_10 | 493D-497C-AB | PO3828147687 | 100 | 283 | 308 | 414 | 2 | 2023-07-24 | 744.27 | 18.61 | 2023-07-12 | 1 | 660.91 | 1 | 744.27 | 10 | SO49877 | 2023-07-19 | 59.54 | 660.91 | 744.27 |
SO49115_16 | 4A55-4351-88 | PO3625184218 | 100 | 283 | 333 | 666 | 2 | 2023-05-26 | 1409.38 | 35.23 | 2023-05-14 | 3 | 486.71 | 1 | 1409.38 | 16 | SO49115 | 2023-05-21 | 112.75 | 1460.12 | 469.79 |
SO63167_11 | 86F4-4F8E-AE | PO10121113947 | 100 | 283 | 418 | 684 | 2 | 2024-05-25 | 713.80 | 17.84 | 2024-05-13 | 2 | 360.94 | 1 | 713.80 | 11 | SO63167 | 2024-05-20 | 57.10 | 721.89 | 356.90 |
SO49084_4 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 420 | 667 | 2 | 2023-05-26 | 424.85 | 10.62 | 2023-05-14 | 3 | 104.80 | 1 | 424.85 | 4 | SO49084 | 2023-05-21 | 33.99 | 314.39 | 141.62 |
SO50243_3 | A9CB-4732-9E | PO1769116006 | 100 | 283 | 325 | 540 | 2 | 2023-08-23 | 1879.18 | 46.98 | 2023-08-11 | 4 | 486.71 | 1 | 1879.18 | 3 | SO50243 | 2023-08-18 | 150.33 | 1946.83 | 469.79 |
SO71778_1 | C735-48DB-B1 | PO19894146890 | 100 | 283 | 467 | 557 | 2 | 2024-09-23 | 14.69 | 0.37 | 2024-09-11 | 1 | 9.16 | 1 | 14.69 | 1 | SO71778 | 2024-09-18 | 1.18 | 9.16 | 14.69 |
SO63219_2 | E19D-4F90-91 | PO7453184328 | 100 | 283 | 222 | 108 | 2 | 2024-05-25 | 125.96 | 3.15 | 2024-05-13 | 6 | 13.09 | 1 | 125.96 | 2 | SO63219 | 2024-05-20 | 10.08 | 78.52 | 20.99 |
SO49113_30 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 469 | 233 | 2 | 2023-05-26 | 22.79 | 0.57 | 2023-05-14 | 1 | 15.67 | 1 | 22.79 | 30 | SO49113 | 2023-05-21 | 1.82 | 15.67 | 22.79 |
SO50755_1 | 645F-454E-86 | PO8352119690 | 100 | 283 | 254 | 636 | 2 | 2023-09-23 | 551.81 | 13.80 | 2023-09-11 | 3 | 170.14 | 1 | 551.81 | 1 | SO50755 | 2023-09-18 | 44.15 | 510.43 | 183.94 |
SO47052_40 | 1AAD-4284-B8 | PO7424197138 | 100 | 281 | 213 | 642 | 2 | 2022-11-23 | 60.56 | 1.51 | 2022-11-11 | 3 | 13.88 | 1 | 60.56 | 40 | SO47052 | 2022-11-18 | 4.84 | 41.63 | 20.19 |
SO49825_10 | 2F7E-448D-B9 | PO17197161242 | 100 | 283 | 410 | 125 | 2 | 2023-07-24 | 36.45 | 0.91 | 2023-07-12 | 1 | 26.97 | 1 | 36.45 | 10 | SO49825 | 2023-07-19 | 2.92 | 26.97 | 36.45 |
SO51790_13 | E757-43BD-B1 | PO18183195762 | 100 | 283 | 543 | 667 | 2 | 2023-11-23 | 74.51 | 1.86 | 2023-11-11 | 2 | 27.57 | 1 | 74.51 | 13 | SO51790 | 2023-11-18 | 5.96 | 55.14 | 37.25 |
SO49877_3 | 493D-497C-AB | PO3828147687 | 100 | 283 | 410 | 414 | 2 | 2023-07-24 | 72.89 | 1.82 | 2023-07-12 | 2 | 26.97 | 1 | 72.89 | 3 | SO49877 | 2023-07-19 | 5.83 | 53.94 | 36.45 |
SO55261_26 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 600 | 594 | 2 | 2024-01-23 | 323.99 | 8.10 | 2024-01-11 | 1 | 294.58 | 1 | 323.99 | 26 | SO55261 | 2024-01-18 | 25.92 | 294.58 | 323.99 |
SO69450_19 | 7050-466D-9B | PO10121172172 | 100 | 283 | 440 | 684 | 2 | 2024-08-23 | 858.90 | 21.47 | 2024-08-11 | 1 | 868.63 | 1 | 858.90 | 19 | SO69450 | 2024-08-18 | 68.71 | 868.63 | 858.90 |
SO47052_39 | 1AAD-4284-B8 | PO7424197138 | 100 | 281 | 364 | 642 | 2 | 2022-11-23 | 647.99 | 16.20 | 2022-11-11 | 1 | 598.44 | 1 | 647.99 | 39 | SO47052 | 2022-11-18 | 51.84 | 598.44 | 647.99 |
SO47675_32 | 8515-427F-B6 | PO13775136623 | 100 | 281 | 343 | 618 | 2 | 2023-01-23 | 939.59 | 23.49 | 2023-01-11 | 2 | 486.71 | 1 | 939.59 | 32 | SO47675 | 2023-01-18 | 75.17 | 973.41 | 469.79 |
SO44131_8 | A7D8-4DAE-BC | PO9019194963 | 100 | 281 | 351 | 576 | 2 | 2021-12-24 | 4049.99 | 101.25 | 2021-12-12 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO44131 | 2021-12-19 | 324.00 | 3796.19 | 2024.99 |
SO63200_32 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 595 | 233 | 2 | 2024-05-25 | 338.99 | 8.47 | 2024-05-13 | 1 | 308.22 | 1 | 338.99 | 32 | SO63200 | 2024-05-20 | 27.12 | 308.22 | 338.99 |
SO48021_19 | 7215-4D49-AD | PO11629116216 | 100 | 281 | 358 | 396 | 2 | 2023-02-23 | 4917.84 | 122.95 | 2023-02-11 | 4 | 1105.81 | 1 | 4917.84 | 19 | SO48021 | 2023-02-18 | 393.43 | 4423.24 | 1229.46 |
SO45063_3 | B8A8-4744-87 | PO1566189373 | 100 | 281 | 322 | 486 | 2 | 2022-04-25 | 1258.38 | 31.46 | 2022-04-13 | 3 | 413.15 | 1 | 1258.38 | 3 | SO45063 | 2022-04-20 | 100.67 | 1239.44 | 419.46 |
SO57065_30 | B68A-407E-99 | PO11658151711 | 100 | 283 | 400 | 233 | 2 | 2024-02-23 | 111.46 | 2.79 | 2024-02-11 | 3 | 27.49 | 1 | 111.46 | 30 | SO57065 | 2024-02-18 | 8.92 | 82.48 | 37.15 |
SO46043_11 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 253 | 36 | 2 | 2022-08-23 | 178.58 | 4.46 | 2022-08-11 | 1 | 176.20 | 1 | 178.58 | 11 | SO46043 | 2022-08-18 | 14.29 | 176.20 | 178.58 |
SO59075_1 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 601 | 179 | 2 | 2024-03-24 | 32.39 | 0.81 | 2024-03-12 | 1 | 23.97 | 1 | 32.39 | 1 | SO59075 | 2024-03-19 | 2.59 | 23.97 | 32.39 |
SO46994_33 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 411 | 396 | 2 | 2022-11-23 | 125.42 | 3.14 | 2022-11-11 | 1 | 92.81 | 1 | 125.42 | 33 | SO46994 | 2022-11-18 | 10.03 | 92.81 | 125.42 |
Generated 2024-11-10 05:29:33.621 UTC