[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1721 > < TAKE 56 >
56 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45077_2 | 4002-46AC-B7 | PO10179199539 | 100 | 285 | 292 | 27 | 5 | 2022-04-25 | 2456.10 | 61.40 | 2022-04-13 | 3 | 706.81 | 1 | 2456.10 | 2 | SO45077 | 2022-04-20 | 196.49 | 2120.43 | 818.70 |
SO48292_25 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 409 | 149 | 3 | 2023-03-25 | 209.26 | 5.23 | 2023-03-13 | 1 | 185.82 | 1 | 209.26 | 25 | SO48292 | 2023-03-20 | 16.74 | 185.82 | 209.26 |
SO48306_24 | EA27-471A-9D | PO17574166075 | 19 | 291 | 448 | 678 | 6 | 2023-03-25 | 35.98 | 0.90 | 2023-03-13 | 3 | 8.25 | 1 | 35.98 | 24 | SO48306 | 2023-03-20 | 2.88 | 24.74 | 11.99 |
SO61229_16 | AC88-46DA-A3 | PO10324197030 | 98 | 288 | 490 | 196 | 10 | 2024-04-24 | 129.58 | 3.24 | 2024-04-12 | 4 | 41.57 | 1 | 129.58 | 16 | SO61229 | 2024-04-19 | 10.37 | 166.29 | 32.39 |
SO50749_4 | 4BD9-4D6C-83 | PO6757115716 | 100 | 281 | 470 | 21 | 4 | 2023-09-23 | 68.38 | 1.71 | 2023-09-11 | 3 | 15.67 | 1 | 68.38 | 4 | SO50749 | 2023-09-18 | 5.47 | 47.01 | 22.79 |
SO67272_2 | F467-41BF-8B | PO13862111340 | 19 | 291 | 595 | 119 | 6 | 2024-07-24 | 677.99 | 16.95 | 2024-07-12 | 2 | 308.22 | 1 | 677.99 | 2 | SO67272 | 2024-07-19 | 54.24 | 616.44 | 338.99 |
SO44773_6 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 338 | 460 | 6 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 6 | SO44773 | 2022-03-20 | 33.56 | 413.15 | 419.46 |
SO46071_1 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 235 | 317 | 6 | 2022-08-23 | 86.52 | 2.16 | 2022-08-11 | 3 | 31.72 | 1 | 86.52 | 1 | SO46071 | 2022-08-18 | 6.92 | 95.17 | 28.84 |
SO51825_37 | E395-4F72-84 | PO6525184188 | 100 | 281 | 601 | 345 | 4 | 2023-11-23 | 97.18 | 2.43 | 2023-11-11 | 3 | 23.97 | 1 | 97.18 | 37 | SO51825 | 2023-11-18 | 7.77 | 71.91 | 32.39 |
SO50685_6 | 52FE-4932-85 | PO11107117790 | 19 | 284 | 327 | 156 | 6 | 2023-09-23 | 469.79 | 11.74 | 2023-09-11 | 1 | 486.71 | 1 | 469.79 | 6 | SO50685 | 2023-09-18 | 37.58 | 486.71 | 469.79 |
SO45275_4 | 43C2-4392-A6 | PO18560176206 | 100 | 285 | 342 | 531 | 5 | 2022-05-26 | 2097.29 | 52.43 | 2022-05-14 | 5 | 413.15 | 1 | 2097.29 | 4 | SO45275 | 2022-05-21 | 167.78 | 2065.73 | 419.46 |
SO45534_4 | F5A4-4CEE-97 | PO14964111594 | 100 | 287 | 348 | 581 | 4 | 2022-06-23 | 6074.98 | 151.87 | 2022-06-11 | 3 | 1898.09 | 1 | 6074.98 | 4 | SO45534 | 2022-06-18 | 486.00 | 5694.28 | 2024.99 |
SO48306_40 | EA27-471A-9D | PO17574166075 | 19 | 291 | 236 | 678 | 6 | 2023-03-25 | 144.20 | 3.61 | 2023-03-13 | 5 | 29.08 | 1 | 144.20 | 40 | SO48306 | 2023-03-20 | 11.54 | 145.40 | 28.84 |
SO49870_51 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 385 | 660 | 3 | 2023-07-24 | 600.26 | 15.01 | 2023-07-12 | 1 | 605.65 | 1 | 600.26 | 51 | SO49870 | 2023-07-19 | 48.02 | 605.65 | 600.26 |
SO45516_20 | 3473-43AB-AE | PO261128364 | 100 | 283 | 212 | 647 | 4 | 2022-06-23 | 20.19 | 0.50 | 2022-06-11 | 1 | 12.03 | 1 | 20.19 | 20 | SO45516 | 2022-06-18 | 1.61 | 12.03 | 20.19 |
SO58981_4 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 217 | 118 | 6 | 2024-03-24 | 209.94 | 5.25 | 2024-03-12 | 10 | 13.09 | 1 | 209.94 | 4 | SO58981 | 2024-03-19 | 16.80 | 130.86 | 20.99 |
SO59013_38 | C224-4535-BA | PO5597199820 | 100 | 281 | 591 | 75 | 4 | 2024-03-24 | 677.99 | 16.95 | 2024-03-12 | 2 | 308.22 | 1 | 677.99 | 38 | SO59013 | 2024-03-19 | 54.24 | 616.44 | 338.99 |
SO57168_22 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 217 | 436 | 4 | 2024-02-23 | 83.98 | 2.10 | 2024-02-11 | 4 | 13.09 | 1 | 83.98 | 22 | SO57168 | 2024-02-18 | 6.72 | 52.35 | 20.99 |
SO69512_1 | 8A04-4DD5-89 | PO7279111263 | 100 | 281 | 566 | 399 | 4 | 2024-08-23 | 1336.23 | 33.41 | 2024-08-11 | 3 | 461.44 | 1 | 1336.23 | 1 | SO69512 | 2024-08-18 | 106.90 | 1384.33 | 445.41 |
SO63171_9 | 6618-4F16-BE | PO580178064 | 36 | 295 | 465 | 230 | 8 | 2024-05-25 | 58.78 | 1.47 | 2024-05-13 | 4 | 9.16 | 1 | 58.78 | 9 | SO63171 | 2024-05-20 | 4.70 | 36.64 | 14.69 |
SO69406_44 | E101-486C-A5 | PO16675181672 | 100 | 293 | 568 | 361 | 1 | 2024-08-23 | 445.41 | 11.14 | 2024-08-11 | 1 | 461.44 | 1 | 445.41 | 44 | SO69406 | 2024-08-18 | 35.63 | 461.44 | 445.41 |
SO51828_37 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 418 | 79 | 3 | 2023-11-23 | 1784.49 | 44.61 | 2023-11-11 | 5 | 360.94 | 1 | 1784.49 | 37 | SO51828 | 2023-11-18 | 142.76 | 1804.71 | 356.90 |
SO50696_27 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 368 | 579 | 3 | 2023-09-23 | 1466.01 | 36.65 | 2023-09-11 | 1 | 1518.79 | 1 | 1466.01 | 27 | SO50696 | 2023-09-18 | 117.28 | 1518.79 | 1466.01 |
SO71923_2 | 16C3-46BF-98 | PO174173096 | 100 | 282 | 481 | 277 | 4 | 2024-09-23 | 21.58 | 0.54 | 2024-09-11 | 4 | 3.36 | 1 | 21.58 | 2 | SO71923 | 2024-09-18 | 1.73 | 13.45 | 5.39 |
SO57134_15 | 040D-4B73-AD | PO6351190175 | 100 | 281 | 481 | 255 | 4 | 2024-02-23 | 32.36 | 0.81 | 2024-02-11 | 6 | 3.36 | 1 | 32.36 | 15 | SO57134 | 2024-02-18 | 2.59 | 20.17 | 5.39 |
SO58910_21 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 517 | 272 | 1 | 2024-03-24 | 31.58 | 0.79 | 2024-03-12 | 1 | 23.37 | 1 | 31.58 | 21 | SO58910 | 2024-03-19 | 2.53 | 23.37 | 31.58 |
SO47969_4 | 437D-4650-BB | PO18821182050 | 100 | 290 | 468 | 686 | 7 | 2023-02-23 | 22.79 | 0.57 | 2023-02-11 | 1 | 15.67 | 1 | 22.79 | 4 | SO47969 | 2023-02-18 | 1.82 | 15.67 | 22.79 |
SO59068_7 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 398 | 490 | 4 | 2024-03-24 | 133.62 | 3.34 | 2024-03-12 | 5 | 19.78 | 1 | 133.62 | 7 | SO59068 | 2024-03-19 | 10.69 | 98.88 | 26.72 |
SO63149_5 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 231 | 236 | 1 | 2024-05-25 | 29.99 | 0.75 | 2024-05-13 | 1 | 38.49 | 1 | 29.99 | 5 | SO63149 | 2024-05-20 | 2.40 | 38.49 | 29.99 |
SO61224_5 | 3D8E-4C8E-B7 | PO13775159907 | 100 | 283 | 222 | 618 | 2 | 2024-04-24 | 62.98 | 1.57 | 2024-04-12 | 3 | 13.09 | 1 | 62.98 | 5 | SO61224 | 2024-04-19 | 5.04 | 39.26 | 20.99 |
SO61239_24 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 483 | 414 | 2 | 2024-04-24 | 432.00 | 10.80 | 2024-04-12 | 6 | 44.88 | 1 | 432.00 | 24 | SO61239 | 2024-04-19 | 34.56 | 269.28 | 72.00 |
SO48754_18 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 356 | 442 | 6 | 2023-04-25 | 2485.70 | 62.14 | 2023-04-13 | 2 | 1117.86 | 1 | 2485.70 | 18 | SO48754 | 2023-04-20 | 198.86 | 2235.71 | 1242.85 |
SO46988_41 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 343 | 78 | 4 | 2022-11-23 | 1879.18 | 46.98 | 2022-11-11 | 4 | 486.71 | 1 | 1879.18 | 41 | SO46988 | 2022-11-18 | 150.33 | 1946.83 | 469.79 |
SO47726_7 | 7256-4599-93 | PO9657190563 | 100 | 285 | 421 | 315 | 5 | 2023-01-23 | 588.99 | 14.72 | 2023-01-11 | 3 | 145.28 | 1 | 588.99 | 7 | SO47726 | 2023-01-18 | 47.12 | 435.85 | 196.33 |
SO47033_58 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 464 | 343 | 1 | 2022-11-23 | 42.39 | 1.06 | 2022-11-11 | 3 | 9.71 | 1 | 42.39 | 58 | SO47033 | 2022-11-18 | 3.39 | 29.14 | 14.13 |
SO48076_6 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 364 | 642 | 2 | 2023-02-23 | 3239.97 | 81.00 | 2023-02-11 | 5 | 598.44 | 1 | 3239.97 | 6 | SO48076 | 2023-02-18 | 259.20 | 2992.18 | 647.99 |
SO50272_3 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 327 | 97 | 4 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 3 | SO50272 | 2023-08-18 | 37.58 | 486.71 | 469.79 |
SO51704_31 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 488 | 264 | 6 | 2023-11-23 | 64.79 | 1.62 | 2023-11-11 | 2 | 41.57 | 1 | 64.79 | 31 | SO51704 | 2023-11-18 | 5.18 | 83.14 | 32.39 |
SO65151_1 | 901D-4BB2-B1 | PO19952180240 | 98 | 288 | 472 | 106 | 10 | 2024-06-23 | 76.20 | 1.91 | 2024-06-11 | 2 | 23.75 | 1 | 76.20 | 1 | SO65151 | 2024-06-18 | 6.10 | 47.50 | 38.10 |
SO65159_9 | DDDD-4736-9B | PO19169187435 | 100 | 289 | 476 | 272 | 1 | 2024-06-23 | 251.96 | 6.30 | 2024-06-11 | 6 | 26.18 | 1 | 251.96 | 9 | SO65159 | 2024-06-18 | 20.16 | 157.06 | 41.99 |
SO69556_2 | 9FEE-452B-B9 | PO8149168478 | 36 | 295 | 408 | 615 | 8 | 2024-08-23 | 288.65 | 7.22 | 2024-08-11 | 4 | 53.40 | 1 | 288.65 | 2 | SO69556 | 2024-08-18 | 23.09 | 213.60 | 72.16 |
SO50668_18 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 428 | 678 | 6 | 2023-09-23 | 1046.28 | 26.16 | 2023-09-11 | 5 | 185.82 | 1 | 1046.28 | 18 | SO50668 | 2023-09-18 | 83.70 | 929.10 | 209.26 |
SO67204_3 | 42CC-4B77-AA | PO5916191420 | 36 | 295 | 222 | 392 | 8 | 2024-07-24 | 41.99 | 1.05 | 2024-07-11 | 2 | 13.09 | 2 | 41.99 | 3 | SO67204 | 2024-07-19 | 3.36 | 26.17 | 20.99 |
SO50254_1 | C82A-4399-A6 | PO2784191494 | 100 | 282 | 325 | 625 | 4 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 1 | SO50254 | 2023-08-18 | 37.58 | 486.71 | 469.79 |
SO49125_19 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 365 | 435 | 4 | 2023-05-26 | 647.99 | 16.20 | 2023-05-14 | 1 | 598.44 | 1 | 647.99 | 19 | SO49125 | 2023-05-21 | 51.84 | 598.44 | 647.99 |
SO50221_21 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 333 | 527 | 3 | 2023-08-23 | 939.59 | 23.49 | 2023-08-11 | 2 | 486.71 | 1 | 939.59 | 21 | SO50221 | 2023-08-18 | 75.17 | 973.41 | 469.79 |
SO53460_15 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 390 | 24 | 4 | 2023-12-24 | 2689.18 | 67.23 | 2023-12-12 | 4 | 713.08 | 1 | 2689.18 | 15 | SO53460 | 2023-12-19 | 215.13 | 2852.32 | 672.29 |
SO57061_29 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 592 | 175 | 7 | 2024-02-23 | 338.99 | 8.47 | 2024-02-11 | 1 | 308.22 | 1 | 338.99 | 29 | SO57061 | 2024-02-18 | 27.12 | 308.22 | 338.99 |
SO43886_10 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 342 | 317 | 6 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 10 | SO43886 | 2021-11-18 | 67.11 | 826.29 | 419.46 |
SO51828_9 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 287 | 79 | 3 | 2023-11-23 | 404.66 | 10.12 | 2023-11-11 | 2 | 204.63 | 1 | 404.66 | 9 | SO51828 | 2023-11-18 | 32.37 | 409.25 | 202.33 |
SO47721_16 | 1629-4338-BE | PO8410190478 | 98 | 288 | 369 | 538 | 10 | 2023-01-23 | 1466.01 | 36.65 | 2023-01-11 | 1 | 1518.79 | 1 | 1466.01 | 16 | SO47721 | 2023-01-18 | 117.28 | 1518.79 | 1466.01 |
SO47028_5 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 419 | 312 | 4 | 2022-11-23 | 157.94 | 3.95 | 2022-11-11 | 3 | 38.96 | 1 | 157.94 | 5 | SO47028 | 2022-11-18 | 12.64 | 116.88 | 52.65 |
SO46090_8 | 987E-4B5B-B6 | PO5858172038 | 100 | 285 | 229 | 566 | 5 | 2022-08-23 | 28.84 | 0.72 | 2022-08-11 | 1 | 31.72 | 1 | 28.84 | 8 | SO46090 | 2022-08-18 | 2.31 | 31.72 | 28.84 |
SO51832_20 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 527 | 352 | 6 | 2023-11-23 | 316.86 | 7.92 | 2023-11-11 | 2 | 144.59 | 1 | 316.86 | 20 | SO51832 | 2023-11-18 | 25.35 | 289.19 | 158.43 |
SO67348_22 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 512 | 494 | 5 | 2024-07-24 | 218.45 | 5.46 | 2024-07-12 | 1 | 199.38 | 1 | 218.45 | 22 | SO67348 | 2024-07-19 | 17.48 | 199.38 | 218.45 |
SO50661_29 | CE6E-45C9-A1 | PO19633184648 | 100 | 287 | 308 | 149 | 3 | 2023-09-23 | 744.27 | 18.61 | 2023-09-11 | 1 | 660.91 | 1 | 744.27 | 29 | SO50661 | 2023-09-18 | 59.54 | 660.91 | 744.27 |
Generated 2024-11-10 12:55:39.009 UTC