[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '283' > SKIP 2500 SHUFFLE SKIP 0 < SKIP 1500 > < TAKE 62 >
62 items
| FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO61181_10 | EF82-40B7-8E | PO17197117656 | 100 | 283 | 353 | 125 | 2 | 2024-04-28 | 5567.98 | 139.20 | 2024-04-16 | 4 | 1265.62 | 1 | 5567.98 | 10 | SO61181 | 2024-04-23 | 445.44 | 5062.48 | 1391.99 | |||
| SO61181_14 | EF82-40B7-8E | PO17197117656 | 100 | 283 | 590 | 125 | 2 | 2024-04-28 | 461.69 | 11.54 | 2024-04-16 | 1 | 419.78 | 1 | 461.69 | 14 | SO61181 | 2024-04-23 | 36.94 | 419.78 | 461.69 | |||
| SO47422_34 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 213 | 2 | 130 | 4 | 5.46 | 2022-12-28 | 273.19 | 6.69 | 2022-12-16 | 14 | 13.88 | 1 | 267.73 | 34 | SO47422 | 2022-12-23 | 21.42 | 194.29 | 19.51 | 0.02 |
| SO51691_33 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 527 | 18 | 3 | 2023-11-27 | 158.43 | 3.96 | 2023-11-15 | 1 | 144.59 | 1 | 158.43 | 33 | SO51691 | 2023-11-22 | 12.67 | 144.59 | 158.43 | |||
| SO50683_46 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 375 | 72 | 2 | 2023-09-27 | 6544.69 | 163.62 | 2023-09-15 | 5 | 1320.68 | 1 | 6544.69 | 46 | SO50683 | 2023-09-22 | 523.58 | 6603.42 | 1308.94 | |||
| SO51119_2 | 5EB6-457F-85 | PO10034199265 | 100 | 283 | 562 | 14 | 305 | 2 | 381.45 | 2023-10-27 | 1907.26 | 38.15 | 2023-10-15 | 2 | 1481.94 | 1 | 1525.80 | 2 | SO51119 | 2023-10-22 | 122.06 | 2963.88 | 953.63 | 0.20 |
| SO71894_51 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 493 | 539 | 2 | 2024-09-27 | 200.05 | 5.00 | 2024-09-15 | 1 | 199.85 | 1 | 200.05 | 51 | SO71894 | 2024-09-22 | 16.00 | 199.85 | 200.05 | |||
| SO57015_7 | 8C70-4374-B5 | PO19923181245 | 100 | 283 | 599 | 18 | 3 | 2024-02-27 | 647.99 | 16.20 | 2024-02-15 | 2 | 294.58 | 1 | 647.99 | 7 | SO57015 | 2024-02-22 | 51.84 | 589.16 | 323.99 | |||
| SO65236_14 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 382 | 54 | 2 | 2024-06-27 | 672.29 | 16.81 | 2024-06-15 | 1 | 713.08 | 1 | 672.29 | 14 | SO65236 | 2024-06-22 | 53.78 | 713.08 | 672.29 | |||
| SO47438_16 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 410 | 21 | 4 | 2022-12-28 | 109.34 | 2.73 | 2022-12-16 | 3 | 26.97 | 1 | 109.34 | 16 | SO47438 | 2022-12-23 | 8.75 | 80.91 | 36.45 | |||
| SO47045_32 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 456 | 2 | 309 | 4 | 9.57 | 2022-11-27 | 478.44 | 11.72 | 2022-11-15 | 11 | 30.93 | 1 | 468.87 | 32 | SO47045 | 2022-11-22 | 37.51 | 340.27 | 43.49 | 0.02 |
| SO57076_10 | 4D9A-45E4-88 | PO10121190262 | 100 | 283 | 605 | 684 | 2 | 2024-02-27 | 647.99 | 16.20 | 2024-02-15 | 2 | 343.65 | 1 | 647.99 | 10 | SO57076 | 2024-02-22 | 51.84 | 687.30 | 323.99 | |||
| SO63200_40 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 355 | 233 | 2 | 2024-05-29 | 4175.98 | 104.40 | 2024-05-17 | 3 | 1265.62 | 1 | 4175.98 | 40 | SO63200 | 2024-05-24 | 334.08 | 3796.86 | 1391.99 | |||
| SO46963_1 | 2BAF-4E3A-BC | PO15747156841 | 100 | 283 | 333 | 471 | 4 | 2022-11-27 | 469.79 | 11.74 | 2022-11-15 | 1 | 486.71 | 1 | 469.79 | 1 | SO46963 | 2022-11-22 | 37.58 | 486.71 | 469.79 | |||
| SO65237_14 | 5F94-404B-AE | PO11455137092 | 100 | 283 | 583 | 2 | 72 | 2 | 217.05 | 2024-06-27 | 10852.32 | 265.88 | 2024-06-15 | 11 | 1082.51 | 1 | 10635.27 | 14 | SO65237 | 2024-06-22 | 850.82 | 11907.61 | 986.57 | 0.02 |
| SO53560_62 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 521 | 539 | 2 | 2023-12-28 | 32.54 | 0.81 | 2023-12-16 | 2 | 12.04 | 1 | 32.54 | 62 | SO53560 | 2023-12-23 | 2.60 | 24.08 | 16.27 | |||
| SO51860_33 | 3799-43C6-B7 | PO3625164674 | 100 | 283 | 418 | 666 | 2 | 2023-11-27 | 356.90 | 8.92 | 2023-11-15 | 1 | 360.94 | 1 | 356.90 | 33 | SO51860 | 2023-11-22 | 28.55 | 360.94 | 356.90 | |||
| SO49169_4 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 369 | 684 | 2 | 2023-05-30 | 4398.03 | 109.95 | 2023-05-18 | 3 | 1518.79 | 1 | 4398.03 | 4 | SO49169 | 2023-05-25 | 351.84 | 4556.36 | 1466.01 | |||
| SO71798_2 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 378 | 306 | 3 | 2024-09-27 | 1466.01 | 36.65 | 2024-09-15 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO71798 | 2024-09-22 | 117.28 | 1554.95 | 1466.01 | |||
| SO47384_12 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 286 | 418 | 3 | 2022-12-28 | 551.81 | 13.80 | 2022-12-16 | 3 | 170.14 | 1 | 551.81 | 12 | SO47384 | 2022-12-23 | 44.15 | 510.43 | 183.94 | |||
| SO71894_52 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 487 | 539 | 2 | 2024-09-27 | 263.95 | 6.60 | 2024-09-15 | 8 | 20.57 | 1 | 263.95 | 52 | SO71894 | 2024-09-22 | 21.12 | 164.53 | 32.99 | |||
| SO55301_24 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 398 | 414 | 2 | 2024-01-27 | 53.45 | 1.34 | 2024-01-15 | 2 | 19.78 | 1 | 53.45 | 24 | SO55301 | 2024-01-22 | 4.28 | 39.55 | 26.72 | |||
| SO51088_20 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 357 | 125 | 2 | 2023-10-27 | 2783.99 | 69.60 | 2023-10-15 | 2 | 1265.62 | 1 | 2783.99 | 20 | SO51088 | 2023-10-22 | 222.72 | 2531.24 | 1391.99 | |||
| SO63200_5 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 306 | 233 | 2 | 2024-05-29 | 809.76 | 20.24 | 2024-05-17 | 1 | 739.04 | 1 | 809.76 | 5 | SO63200 | 2024-05-24 | 64.78 | 739.04 | 809.76 | |||
| SO55261_21 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 475 | 594 | 2 | 2024-01-27 | 83.99 | 2.10 | 2024-01-15 | 2 | 26.18 | 1 | 83.99 | 21 | SO55261 | 2024-01-22 | 6.72 | 52.35 | 41.99 | |||
| SO65210_15 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 583 | 90 | 5 | 2024-06-27 | 3061.78 | 76.54 | 2024-06-15 | 3 | 1082.51 | 1 | 3061.78 | 15 | SO65210 | 2024-06-22 | 244.94 | 3247.53 | 1020.59 | |||
| SO71798_13 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 606 | 306 | 3 | 2024-09-27 | 647.99 | 16.20 | 2024-09-15 | 2 | 343.65 | 1 | 647.99 | 13 | SO71798 | 2024-09-22 | 51.84 | 687.30 | 323.99 | |||
| SO53560_31 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 465 | 539 | 2 | 2023-12-28 | 117.55 | 2.94 | 2023-12-16 | 8 | 9.16 | 1 | 117.55 | 31 | SO53560 | 2023-12-23 | 9.40 | 73.27 | 14.69 | |||
| SO49888_23 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 368 | 234 | 2 | 2023-07-28 | 7330.05 | 183.25 | 2023-07-16 | 5 | 1518.79 | 1 | 7330.05 | 23 | SO49888 | 2023-07-23 | 586.40 | 7593.93 | 1466.01 | |||
| SO46648_8 | 2073-4051-9E | PO2494191557 | 100 | 283 | 236 | 184 | 4 | 2022-10-27 | 230.72 | 5.77 | 2022-10-15 | 8 | 29.08 | 1 | 230.72 | 8 | SO46648 | 2022-10-22 | 18.46 | 232.65 | 28.84 | |||
| SO53506_33 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 583 | 3 | 72 | 2 | 701.66 | 2023-12-28 | 14033.17 | 333.29 | 2023-12-16 | 15 | 1082.51 | 1 | 13331.51 | 33 | SO53506 | 2023-12-23 | 1066.52 | 16237.65 | 935.54 | 0.05 |
| SO49123_22 | FDE5-41D0-A8 | PO18386193475 | 100 | 283 | 371 | 558 | 2 | 2023-05-30 | 1308.94 | 32.72 | 2023-05-18 | 1 | 1320.68 | 1 | 1308.94 | 22 | SO49123 | 2023-05-25 | 104.72 | 1320.68 | 1308.94 | |||
| SO51778_15 | 420A-4268-A8 | PO3161175221 | 100 | 283 | 434 | 359 | 2 | 2023-11-27 | 1070.69 | 26.77 | 2023-11-15 | 3 | 360.94 | 1 | 1070.69 | 15 | SO51778 | 2023-11-22 | 85.66 | 1082.83 | 356.90 | |||
| SO47409_11 | FC23-4384-86 | PO1624119173 | 100 | 283 | 383 | 579 | 3 | 2022-12-28 | 600.26 | 15.01 | 2022-12-16 | 1 | 605.65 | 1 | 600.26 | 11 | SO47409 | 2022-12-23 | 48.02 | 605.65 | 600.26 | |||
| SO71798_11 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 372 | 306 | 3 | 2024-09-27 | 4398.03 | 109.95 | 2024-09-15 | 3 | 1554.95 | 1 | 4398.03 | 11 | SO71798 | 2024-09-22 | 351.84 | 4664.84 | 1466.01 | |||
| SO53499_3 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 531 | 197 | 3 | 2023-12-28 | 299.75 | 7.49 | 2023-12-16 | 2 | 136.79 | 1 | 299.75 | 3 | SO53499 | 2023-12-23 | 23.98 | 273.57 | 149.87 | |||
| SO46651_9 | 68A1-47A8-9A | PO3016181627 | 100 | 283 | 469 | 183 | 3 | 2022-10-27 | 91.18 | 2.28 | 2022-10-15 | 4 | 15.67 | 1 | 91.18 | 9 | SO46651 | 2022-10-22 | 7.29 | 62.68 | 22.79 | |||
| SO51810_30 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 480 | 108 | 2 | 2023-11-27 | 5.50 | 0.14 | 2023-11-15 | 4 | 0.86 | 1 | 5.50 | 30 | SO51810 | 2023-11-22 | 0.44 | 3.43 | 1.37 | |||
| SO47393_1 | E163-4B2A-9B | PO11890161866 | 100 | 283 | 394 | 472 | 3 | 2022-12-28 | 20.52 | 0.51 | 2022-12-16 | 1 | 15.18 | 1 | 20.52 | 1 | SO47393 | 2022-12-23 | 1.64 | 15.18 | 20.52 | |||
| SO67271_2 | E734-4CEC-A8 | PO13775181029 | 100 | 283 | 546 | 618 | 2 | 2024-07-28 | 74.51 | 1.86 | 2024-07-16 | 2 | 27.57 | 1 | 74.51 | 2 | SO67271 | 2024-07-23 | 5.96 | 55.14 | 37.25 | |||
| SO49870_9 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 327 | 660 | 3 | 2023-07-28 | 2818.76 | 70.47 | 2023-07-16 | 6 | 486.71 | 1 | 2818.76 | 9 | SO49870 | 2023-07-23 | 225.50 | 2920.24 | 469.79 | |||
| SO51790_18 | E757-43BD-B1 | PO18183195762 | 100 | 283 | 525 | 667 | 2 | 2023-11-27 | 633.72 | 15.84 | 2023-11-15 | 4 | 144.59 | 1 | 633.72 | 18 | SO51790 | 2023-11-22 | 50.70 | 578.38 | 158.43 | |||
| SO55248_35 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 390 | 618 | 2 | 2024-01-27 | 1344.59 | 33.61 | 2024-01-15 | 2 | 713.08 | 1 | 1344.59 | 35 | SO55248 | 2024-01-22 | 107.57 | 1426.16 | 672.29 | |||
| SO58944_42 | 90AC-4F21-90 | PO12354164168 | 100 | 283 | 591 | 197 | 3 | 2024-03-28 | 338.99 | 8.47 | 2024-03-16 | 1 | 308.22 | 1 | 338.99 | 42 | SO58944 | 2024-03-23 | 27.12 | 308.22 | 338.99 | |||
| SO51691_9 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 516 | 18 | 3 | 2023-11-27 | 93.94 | 2.35 | 2023-11-15 | 4 | 17.38 | 1 | 93.94 | 9 | SO51691 | 2023-11-22 | 7.51 | 69.51 | 23.48 | |||
| SO57065_28 | B68A-407E-99 | PO11658151711 | 100 | 283 | 555 | 233 | 2 | 2024-02-27 | 255.60 | 6.39 | 2024-02-15 | 4 | 47.29 | 1 | 255.60 | 28 | SO57065 | 2024-02-22 | 20.45 | 189.14 | 63.90 | |||
| SO53570_7 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 440 | 54 | 2 | 2023-12-28 | 858.90 | 21.47 | 2023-12-16 | 1 | 868.63 | 1 | 858.90 | 7 | SO53570 | 2023-12-23 | 68.71 | 868.63 | 858.90 | |||
| SO53506_31 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 374 | 72 | 2 | 2023-12-28 | 10262.07 | 256.55 | 2023-12-16 | 7 | 1554.95 | 1 | 10262.07 | 31 | SO53506 | 2023-12-23 | 820.97 | 10884.64 | 1466.01 | |||
| SO63167_14 | 86F4-4F8E-AE | PO10121113947 | 100 | 283 | 382 | 684 | 2 | 2024-05-29 | 1344.59 | 33.61 | 2024-05-17 | 2 | 713.08 | 1 | 1344.59 | 14 | SO63167 | 2024-05-24 | 107.57 | 1426.16 | 672.29 | |||
| SO53471_3 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 581 | 306 | 3 | 2023-12-28 | 1020.59 | 25.51 | 2023-12-16 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO53471 | 2023-12-23 | 81.65 | 1082.51 | 1020.59 | |||
| SO50228_22 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 358 | 396 | 2 | 2023-08-27 | 2458.92 | 61.47 | 2023-08-15 | 2 | 1105.81 | 1 | 2458.92 | 22 | SO50228 | 2023-08-22 | 196.71 | 2211.62 | 1229.46 | |||
| SO51810_2 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 467 | 108 | 2 | 2023-11-27 | 117.55 | 2.94 | 2023-11-15 | 8 | 9.16 | 1 | 117.55 | 2 | SO51810 | 2023-11-22 | 9.40 | 73.27 | 14.69 | |||
| SO47384_32 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 331 | 418 | 3 | 2022-12-28 | 1409.38 | 35.23 | 2022-12-16 | 3 | 486.71 | 1 | 1409.38 | 32 | SO47384 | 2022-12-23 | 112.75 | 1460.12 | 469.79 | |||
| SO53530_1 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 581 | 90 | 5 | 2023-12-28 | 2041.19 | 51.03 | 2023-12-16 | 2 | 1082.51 | 1 | 2041.19 | 1 | SO53530 | 2023-12-23 | 163.30 | 2165.02 | 1020.59 | |||
| SO46377_2 | A45C-4A20-BA | PO6786151653 | 100 | 283 | 212 | 3 | 4 | 2022-09-27 | 20.19 | 0.50 | 2022-09-15 | 1 | 12.03 | 1 | 20.19 | 2 | SO46377 | 2022-09-22 | 1.61 | 12.03 | 20.19 | |||
| SO57087_12 | 423C-428C-BB | PO2871167176 | 100 | 283 | 564 | 522 | 2 | 2024-02-27 | 2860.88 | 71.52 | 2024-02-15 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO57087 | 2024-02-22 | 228.87 | 2963.88 | 1430.44 | |||
| SO46648_30 | 2073-4051-9E | PO2494191557 | 100 | 283 | 367 | 184 | 4 | 2022-10-27 | 2591.98 | 64.80 | 2022-10-15 | 4 | 598.44 | 1 | 2591.98 | 30 | SO46648 | 2022-10-22 | 207.36 | 2393.74 | 647.99 | |||
| SO51157_17 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 533 | 414 | 2 | 2023-10-27 | 299.75 | 7.49 | 2023-10-15 | 2 | 136.79 | 1 | 299.75 | 17 | SO51157 | 2023-10-22 | 23.98 | 273.57 | 149.87 | |||
| SO59012_24 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 559 | 539 | 2 | 2024-03-28 | 36.43 | 0.91 | 2024-03-16 | 3 | 8.99 | 1 | 36.43 | 24 | SO59012 | 2024-03-23 | 2.91 | 26.96 | 12.14 | |||
| SO47439_20 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 459 | 3 | 4 | 2022-12-28 | 377.96 | 9.45 | 2022-12-16 | 7 | 37.12 | 1 | 377.96 | 20 | SO47439 | 2022-12-23 | 30.24 | 259.85 | 53.99 | |||
| SO53499_4 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 589 | 197 | 3 | 2023-12-28 | 923.39 | 23.08 | 2023-12-16 | 2 | 419.78 | 1 | 923.39 | 4 | SO53499 | 2023-12-23 | 73.87 | 839.56 | 461.69 | |||
| SO47438_1 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 428 | 21 | 4 | 2022-12-28 | 418.51 | 10.46 | 2022-12-16 | 2 | 185.82 | 1 | 418.51 | 1 | SO47438 | 2022-12-23 | 33.48 | 371.64 | 209.26 |
Generated 2024-11-14 05:39:39.417 UTC