[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 96 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46364_19 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 349 | 7 | 366 | 4 | 2067.18 | 2022-08-03 | 5906.23 | 95.98 | 2022-07-22 | 7 | 1898.09 | 1 | 3839.05 | 19 | SO46364 | 2022-07-29 | 307.12 | 13286.66 | 843.75 | 0.35 |
SO46101_10 | FAFC-4F06-B2 | PO7656119075 | 100 | 282 | 316 | 403 | 4 | 2022-07-03 | 874.79 | 21.87 | 2022-06-21 | 1 | 884.71 | 1 | 874.79 | 10 | SO46101 | 2022-06-28 | 69.98 | 884.71 | 874.79 | |||
SO49104_3 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 339 | 97 | 4 | 2023-04-05 | 2348.97 | 58.72 | 2023-03-24 | 5 | 486.71 | 1 | 2348.97 | 3 | SO49104 | 2023-03-31 | 187.92 | 2433.53 | 469.79 | |||
SO50724_17 | E9DD-40CA-B2 | PO9686154363 | 100 | 282 | 399 | 457 | 4 | 2023-08-03 | 135.10 | 3.38 | 2023-07-22 | 4 | 24.99 | 1 | 135.10 | 17 | SO50724 | 2023-07-29 | 10.81 | 99.97 | 33.77 | |||
SO50663_49 | 286E-4915-89 | PO19343130555 | 100 | 282 | 325 | 24 | 4 | 2023-08-03 | 3758.35 | 93.96 | 2023-07-22 | 8 | 486.71 | 1 | 3758.35 | 49 | SO50663 | 2023-07-29 | 300.67 | 3893.65 | 469.79 | |||
SO47065_9 | D00A-426C-9B | PO8845147622 | 100 | 282 | 236 | 546 | 3 | 2022-10-03 | 57.68 | 1.44 | 2022-09-21 | 2 | 29.08 | 1 | 57.68 | 9 | SO47065 | 2022-09-28 | 4.61 | 58.16 | 28.84 | |||
SO45523_1 | 3D3B-4EA3-8B | PO18937157668 | 100 | 282 | 304 | 439 | 4 | 2022-05-03 | 1429.41 | 35.74 | 2022-04-21 | 2 | 617.03 | 1 | 1429.41 | 1 | SO45523 | 2022-04-28 | 114.35 | 1234.06 | 714.70 | |||
SO49831_7 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 289 | 475 | 4 | 2023-06-03 | 2977.09 | 74.43 | 2023-05-22 | 4 | 660.91 | 1 | 2977.09 | 7 | SO49831 | 2023-05-29 | 238.17 | 2643.66 | 744.27 | |||
SO63283_17 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 597 | 312 | 4 | 2024-04-04 | 323.99 | 8.10 | 2024-03-23 | 1 | 294.58 | 1 | 323.99 | 17 | SO63283 | 2024-03-30 | 25.92 | 294.58 | 323.99 | |||
SO46625_50 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 462 | 475 | 4 | 2022-09-02 | 70.64 | 1.77 | 2022-08-21 | 5 | 9.71 | 1 | 70.64 | 50 | SO46625 | 2022-08-28 | 5.65 | 48.57 | 14.13 | |||
SO69532_38 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 400 | 312 | 4 | 2024-07-03 | 37.15 | 0.93 | 2024-06-21 | 1 | 27.49 | 1 | 37.15 | 38 | SO69532 | 2024-06-28 | 2.97 | 27.49 | 37.15 | |||
SO46992_10 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 331 | 97 | 4 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 10 | SO46992 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO65299_1 | 2FED-4E5A-B6 | PO3770146082 | 100 | 282 | 353 | 151 | 4 | 2024-05-03 | 1391.99 | 34.80 | 2024-04-21 | 1 | 1265.62 | 1 | 1391.99 | 1 | SO65299 | 2024-04-28 | 111.36 | 1265.62 | 1391.99 | |||
SO50313_44 | B452-44E9-91 | PO7656143984 | 100 | 282 | 341 | 403 | 4 | 2023-07-03 | 1879.18 | 46.98 | 2023-06-21 | 4 | 486.71 | 1 | 1879.18 | 44 | SO50313 | 2023-06-28 | 150.33 | 1946.83 | 469.79 | |||
SO65285_1 | 83AC-4FF9-8B | PO4002159016 | 100 | 282 | 481 | 674 | 4 | 2024-05-03 | 16.18 | 0.40 | 2024-04-21 | 3 | 3.36 | 1 | 16.18 | 1 | SO65285 | 2024-04-28 | 1.29 | 10.09 | 5.39 | |||
SO48295_10 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 333 | 24 | 4 | 2023-02-02 | 4697.94 | 117.45 | 2023-01-21 | 10 | 486.71 | 1 | 4697.94 | 10 | SO48295 | 2023-01-28 | 375.84 | 4867.07 | 469.79 | |||
SO50688_37 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 352 | 133 | 4 | 2023-08-03 | 6214.26 | 155.36 | 2023-07-22 | 5 | 1117.86 | 1 | 6214.26 | 37 | SO50688 | 2023-07-29 | 497.14 | 5589.28 | 1242.85 | |||
SO47028_31 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 448 | 312 | 4 | 2022-10-03 | 47.98 | 1.20 | 2022-09-21 | 4 | 8.25 | 1 | 47.98 | 31 | SO47028 | 2022-09-28 | 3.84 | 32.98 | 11.99 | |||
SO47041_52 | C543-4932-83 | PO5771188676 | 100 | 282 | 464 | 79 | 3 | 2022-10-03 | 42.39 | 1.06 | 2022-09-21 | 3 | 9.71 | 1 | 42.39 | 52 | SO47041 | 2022-09-28 | 3.39 | 29.14 | 14.13 | |||
SO57139_3 | A281-4DDD-BC | PO2320173115 | 100 | 282 | 386 | 529 | 4 | 2024-01-03 | 1344.59 | 33.61 | 2023-12-22 | 2 | 713.08 | 1 | 1344.59 | 3 | SO57139 | 2023-12-29 | 107.57 | 1426.16 | 672.29 | |||
SO50322_15 | 4BC2-4C6D-83 | PO8845166508 | 100 | 282 | 399 | 546 | 3 | 2023-07-03 | 101.32 | 2.53 | 2023-06-21 | 3 | 24.99 | 1 | 101.32 | 15 | SO50322 | 2023-06-28 | 8.11 | 74.98 | 33.77 | |||
SO47425_2 | E539-44F6-AA | PO4002163465 | 100 | 282 | 233 | 674 | 4 | 2022-11-03 | 86.52 | 2.16 | 2022-10-22 | 3 | 29.08 | 1 | 86.52 | 2 | SO47425 | 2022-10-29 | 6.92 | 87.24 | 28.84 | |||
SO48295_8 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 415 | 24 | 4 | 2023-02-02 | 792.14 | 19.80 | 2023-01-21 | 4 | 146.55 | 1 | 792.14 | 8 | SO48295 | 2023-01-28 | 63.37 | 586.19 | 198.04 | |||
SO46089_2 | 5E3C-4A0D-BD | PO5684142532 | 100 | 282 | 223 | 385 | 4 | 2022-07-03 | 25.93 | 0.65 | 2022-06-21 | 5 | 5.71 | 1 | 25.93 | 2 | SO46089 | 2022-06-28 | 2.07 | 28.53 | 5.19 | |||
SO45564_2 | DD65-42A2-80 | PO5220129554 | 100 | 282 | 351 | 169 | 1 | 2022-05-03 | 4049.99 | 101.25 | 2022-04-21 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO45564 | 2022-04-28 | 324.00 | 3796.19 | 2024.99 | |||
SO46048_7 | DDA0-4A8A-9C | PO16037150345 | 100 | 282 | 350 | 384 | 4 | 2022-07-03 | 8099.98 | 202.50 | 2022-06-21 | 4 | 1898.09 | 1 | 8099.98 | 7 | SO46048 | 2022-06-28 | 648.00 | 7592.38 | 2024.99 | |||
SO51090_37 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 593 | 475 | 4 | 2023-09-02 | 338.99 | 8.47 | 2023-08-21 | 1 | 308.22 | 1 | 338.99 | 37 | SO51090 | 2023-08-28 | 27.12 | 308.22 | 338.99 | |||
SO50226_11 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 448 | 78 | 4 | 2023-07-03 | 11.99 | 0.30 | 2023-06-21 | 1 | 8.25 | 1 | 11.99 | 11 | SO50226 | 2023-06-28 | 0.96 | 8.25 | 11.99 | |||
SO50688_10 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 362 | 133 | 4 | 2023-08-03 | 4917.84 | 122.95 | 2023-07-22 | 4 | 1105.81 | 1 | 4917.84 | 10 | SO50688 | 2023-07-29 | 393.43 | 4423.24 | 1229.46 | |||
SO47355_30 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 213 | 3 | 24 | 4 | 22.21 | 2022-11-03 | 444.10 | 10.55 | 2022-10-22 | 24 | 13.88 | 1 | 421.90 | 30 | SO47355 | 2022-10-29 | 33.75 | 333.08 | 18.50 | 0.05 |
SO48065_30 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 387 | 79 | 3 | 2023-01-03 | 4201.84 | 105.05 | 2022-12-22 | 7 | 605.65 | 1 | 4201.84 | 30 | SO48065 | 2022-12-29 | 336.15 | 4239.54 | 600.26 | |||
SO63291_25 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 588 | 546 | 3 | 2024-04-04 | 2308.47 | 57.71 | 2024-03-23 | 5 | 419.78 | 1 | 2308.47 | 25 | SO63291 | 2024-03-30 | 184.68 | 2098.89 | 461.69 | |||
SO48065_25 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 460 | 79 | 3 | 2023-01-03 | 323.96 | 8.10 | 2022-12-22 | 6 | 37.12 | 1 | 323.96 | 25 | SO48065 | 2022-12-29 | 25.92 | 222.73 | 53.99 | |||
SO46366_2 | 45E2-4301-82 | PO4002112610 | 100 | 282 | 232 | 674 | 4 | 2022-08-03 | 57.68 | 1.44 | 2022-07-22 | 2 | 31.72 | 1 | 57.68 | 2 | SO46366 | 2022-07-29 | 4.61 | 63.45 | 28.84 | |||
SO49166_12 | 142E-4351-A4 | PO8845115490 | 100 | 282 | 367 | 546 | 3 | 2023-04-05 | 1295.99 | 32.40 | 2023-03-24 | 2 | 598.44 | 1 | 1295.99 | 12 | SO49166 | 2023-03-31 | 103.68 | 1196.87 | 647.99 | |||
SO50663_4 | 286E-4915-89 | PO19343130555 | 100 | 282 | 263 | 24 | 4 | 2023-08-03 | 809.33 | 20.23 | 2023-07-22 | 4 | 187.16 | 1 | 809.33 | 4 | SO50663 | 2023-07-29 | 64.75 | 748.63 | 202.33 | |||
SO51090_11 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 463 | 475 | 4 | 2023-09-02 | 102.86 | 2.57 | 2023-08-21 | 7 | 9.16 | 1 | 102.86 | 11 | SO51090 | 2023-08-28 | 8.23 | 64.12 | 14.69 | |||
SO50238_1 | 434B-41AF-80 | PO609198092 | 100 | 282 | 470 | 492 | 4 | 2023-07-03 | 68.38 | 1.71 | 2023-06-21 | 3 | 15.67 | 1 | 68.38 | 1 | SO50238 | 2023-06-28 | 5.47 | 47.01 | 22.79 | |||
SO69532_1 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 361 | 312 | 4 | 2024-07-03 | 4130.98 | 103.27 | 2024-06-21 | 3 | 1251.98 | 1 | 4130.98 | 1 | SO69532 | 2024-06-28 | 330.48 | 3755.94 | 1376.99 | |||
SO47355_59 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 369 | 24 | 4 | 2022-11-03 | 13194.09 | 329.85 | 2022-10-22 | 9 | 1518.79 | 1 | 13194.09 | 59 | SO47355 | 2022-10-29 | 1055.53 | 13669.08 | 1466.01 | |||
SO49074_6 | F3B3-405D-83 | PO2320167746 | 100 | 282 | 433 | 529 | 4 | 2023-04-05 | 324.45 | 8.11 | 2023-03-24 | 1 | 300.12 | 1 | 324.45 | 6 | SO49074 | 2023-03-31 | 25.96 | 300.12 | 324.45 | |||
SO63277_4 | 1561-40F3-AD | PO3219122722 | 100 | 282 | 581 | 493 | 4 | 2024-04-04 | 1020.59 | 25.51 | 2024-03-23 | 1 | 1082.51 | 1 | 1020.59 | 4 | SO63277 | 2024-03-30 | 81.65 | 1082.51 | 1020.59 | |||
SO46048_2 | DDA0-4A8A-9C | PO16037150345 | 100 | 282 | 307 | 384 | 4 | 2022-07-03 | 722.59 | 18.06 | 2022-06-21 | 1 | 623.84 | 1 | 722.59 | 2 | SO46048 | 2022-06-28 | 57.81 | 623.84 | 722.59 | |||
SO57144_30 | 074E-478C-99 | PO3799111077 | 100 | 282 | 515 | 312 | 4 | 2024-01-03 | 48.82 | 1.22 | 2023-12-22 | 3 | 12.04 | 1 | 48.82 | 30 | SO57144 | 2023-12-29 | 3.91 | 36.12 | 16.27 | |||
SO57144_42 | 074E-478C-99 | PO3799111077 | 100 | 282 | 532 | 312 | 4 | 2024-01-03 | 749.37 | 18.73 | 2023-12-22 | 5 | 136.79 | 1 | 749.37 | 42 | SO57144 | 2023-12-29 | 59.95 | 683.93 | 149.87 | |||
SO47056_36 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 325 | 403 | 4 | 2022-10-03 | 2348.97 | 58.72 | 2022-09-21 | 5 | 486.71 | 1 | 2348.97 | 36 | SO47056 | 2022-09-28 | 187.92 | 2433.53 | 469.79 | |||
SO50688_38 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 395 | 133 | 4 | 2023-08-03 | 613.74 | 15.34 | 2023-07-22 | 10 | 45.42 | 1 | 613.74 | 38 | SO50688 | 2023-07-29 | 49.10 | 454.17 | 61.37 | |||
SO46057_14 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 338 | 78 | 4 | 2022-07-03 | 2516.75 | 62.92 | 2022-06-21 | 6 | 413.15 | 1 | 2516.75 | 14 | SO46057 | 2022-06-28 | 201.34 | 2478.88 | 419.46 | |||
SO49104_8 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 456 | 97 | 4 | 2023-04-05 | 269.96 | 6.75 | 2023-03-24 | 6 | 30.93 | 1 | 269.96 | 8 | SO49104 | 2023-03-31 | 21.60 | 185.60 | 44.99 | |||
SO46970_37 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 439 | 258 | 4 | 2022-10-03 | 2342.45 | 58.56 | 2022-09-21 | 3 | 722.26 | 1 | 2342.45 | 37 | SO46970 | 2022-09-28 | 187.40 | 2166.77 | 780.82 | |||
SO47372_15 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 329 | 649 | 4 | 2022-11-03 | 939.59 | 23.49 | 2022-10-22 | 2 | 486.71 | 1 | 939.59 | 15 | SO47372 | 2022-10-29 | 75.17 | 973.41 | 469.79 | |||
SO46972_2 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 396 | 650 | 1 | 2022-10-03 | 74.84 | 1.87 | 2022-09-21 | 1 | 55.38 | 1 | 74.84 | 2 | SO46972 | 2022-09-28 | 5.99 | 55.38 | 74.84 | |||
SO49160_30 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 456 | 403 | 4 | 2023-04-05 | 134.98 | 3.37 | 2023-03-24 | 3 | 30.93 | 1 | 134.98 | 30 | SO49160 | 2023-03-31 | 10.80 | 92.80 | 44.99 | |||
SO63157_35 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 355 | 650 | 1 | 2024-04-04 | 5567.98 | 139.20 | 2024-03-23 | 4 | 1265.62 | 1 | 5567.98 | 35 | SO63157 | 2024-03-30 | 445.44 | 5062.48 | 1391.99 | |||
SO48758_18 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 396 | 475 | 4 | 2023-03-05 | 74.84 | 1.87 | 2023-02-21 | 1 | 55.38 | 1 | 74.84 | 18 | SO48758 | 2023-02-28 | 5.99 | 55.38 | 74.84 | |||
SO47041_42 | C543-4932-83 | PO5771188676 | 100 | 282 | 221 | 79 | 3 | 2022-10-03 | 60.56 | 1.51 | 2022-09-21 | 3 | 13.88 | 1 | 60.56 | 42 | SO47041 | 2022-09-28 | 4.84 | 41.63 | 20.19 | |||
SO50707_1 | C071-42D6-B3 | PO16124195115 | 100 | 282 | 327 | 649 | 4 | 2023-08-03 | 469.79 | 11.74 | 2023-07-22 | 1 | 486.71 | 1 | 469.79 | 1 | SO50707 | 2023-07-29 | 37.58 | 486.71 | 469.79 | |||
SO46058_15 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 332 | 240 | 4 | 2022-07-03 | 419.46 | 10.49 | 2022-06-21 | 1 | 413.15 | 1 | 419.46 | 15 | SO46058 | 2022-06-28 | 33.56 | 413.15 | 419.46 | |||
SO71782_7 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 471 | 582 | 4 | 2024-08-03 | 228.60 | 5.72 | 2024-07-22 | 6 | 23.75 | 1 | 228.60 | 7 | SO71782 | 2024-07-29 | 18.29 | 142.49 | 38.10 | |||
SO50214_4 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 422 | 258 | 4 | 2023-07-03 | 67.54 | 1.69 | 2023-06-21 | 1 | 49.98 | 1 | 67.54 | 4 | SO50214 | 2023-06-28 | 5.40 | 49.98 | 67.54 | |||
SO47065_14 | D00A-426C-9B | PO8845147622 | 100 | 282 | 419 | 546 | 3 | 2022-10-03 | 315.88 | 7.90 | 2022-09-21 | 6 | 38.96 | 1 | 315.88 | 14 | SO47065 | 2022-09-28 | 25.27 | 233.75 | 52.65 | |||
SO48397_8 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 364 | 457 | 4 | 2023-02-02 | 1295.99 | 32.40 | 2023-01-21 | 2 | 598.44 | 1 | 1295.99 | 8 | SO48397 | 2023-01-28 | 103.68 | 1196.87 | 647.99 |
Generated 2024-09-21 00:34:00.464 UTC