[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1777 > < TAKE 48 >
48 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50726_4 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 327 | 170 | 5 | 2023-09-23 | 1879.18 | 46.98 | 2023-09-11 | 4 | 486.71 | 1 | 1879.18 | 4 | SO50726 | 2023-09-18 | 150.33 | 1946.83 | 469.79 | |||
| SO71803_33 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 511 | 327 | 3 | 2024-09-23 | 655.36 | 16.38 | 2024-09-11 | 3 | 199.38 | 1 | 655.36 | 33 | SO71803 | 2024-09-18 | 52.43 | 598.13 | 218.45 | |||
| SO69444_27 | C494-47D6-AF | PO11368134457 | 36 | 295 | 234 | 687 | 8 | 2024-08-23 | 119.98 | 3.00 | 2024-08-11 | 4 | 38.49 | 1 | 119.98 | 27 | SO69444 | 2024-08-18 | 9.60 | 153.97 | 29.99 | |||
| SO47975_22 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 369 | 558 | 2 | 2023-02-23 | 1466.01 | 36.65 | 2023-02-11 | 1 | 1518.79 | 1 | 1466.01 | 22 | SO47975 | 2023-02-18 | 117.28 | 1518.79 | 1466.01 | |||
| SO63174_12 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 217 | 317 | 6 | 2024-05-25 | 125.96 | 3.15 | 2024-05-13 | 6 | 13.09 | 1 | 125.96 | 12 | SO63174 | 2024-05-20 | 10.08 | 78.52 | 20.99 | |||
| SO61188_17 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 603 | 331 | 4 | 2024-04-24 | 218.68 | 5.47 | 2024-04-12 | 3 | 53.94 | 1 | 218.68 | 17 | SO61188 | 2024-04-19 | 17.49 | 161.82 | 72.89 | |||
| SO46657_39 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 221 | 8 | 496 | 6 | 13.46 | 2022-10-23 | 134.58 | 3.03 | 2022-10-11 | 8 | 13.88 | 1 | 121.12 | 39 | SO46657 | 2022-10-18 | 9.69 | 111.03 | 16.82 | 0.10 |
| SO49844_34 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 375 | 290 | 1 | 2023-07-24 | 2617.88 | 65.45 | 2023-07-12 | 2 | 1320.68 | 1 | 2617.88 | 34 | SO49844 | 2023-07-19 | 209.43 | 2641.37 | 1308.94 | |||
| SO45311_4 | 054A-4208-9E | PO609120236 | 100 | 282 | 346 | 492 | 4 | 2022-05-26 | 4079.99 | 102.00 | 2022-05-14 | 2 | 1912.15 | 1 | 4079.99 | 4 | SO45311 | 2022-05-21 | 326.40 | 3824.31 | 2039.99 | |||
| SO65167_4 | D40C-4211-94 | PO18125182344 | 100 | 287 | 436 | 311 | 4 | 2024-06-23 | 713.80 | 17.84 | 2024-06-11 | 2 | 360.94 | 1 | 713.80 | 4 | SO65167 | 2024-06-18 | 57.10 | 721.89 | 356.90 | |||
| SO50259_43 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 375 | 558 | 2 | 2023-08-23 | 1308.94 | 32.72 | 2023-08-11 | 1 | 1320.68 | 1 | 1308.94 | 43 | SO50259 | 2023-08-18 | 104.72 | 1320.68 | 1308.94 | |||
| SO45059_8 | C618-4998-BE | PO10730115502 | 100 | 287 | 332 | 491 | 4 | 2022-04-25 | 419.46 | 10.49 | 2022-04-13 | 1 | 413.15 | 1 | 419.46 | 8 | SO45059 | 2022-04-20 | 33.56 | 413.15 | 419.46 | |||
| SO57137_36 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 483 | 309 | 4 | 2024-02-23 | 288.00 | 7.20 | 2024-02-11 | 4 | 44.88 | 1 | 288.00 | 36 | SO57137 | 2024-02-18 | 23.04 | 179.52 | 72.00 | |||
| SO63209_4 | 1C23-4681-BF | PO11223142410 | 100 | 292 | 512 | 632 | 7 | 2024-05-25 | 436.91 | 10.92 | 2024-05-13 | 2 | 199.38 | 1 | 436.91 | 4 | SO63209 | 2024-05-20 | 34.95 | 398.75 | 218.45 | |||
| SO47365_45 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 395 | 2 | 678 | 6 | 13.05 | 2022-12-24 | 652.61 | 15.99 | 2022-12-12 | 11 | 45.42 | 1 | 639.56 | 45 | SO47365 | 2022-12-19 | 51.16 | 499.58 | 59.33 | 0.02 |
| SO49472_2 | 653C-45A9-B1 | PO2697138792 | 100 | 282 | 397 | 187 | 4 | 2023-06-23 | 48.59 | 1.21 | 2023-06-11 | 2 | 17.98 | 1 | 48.59 | 2 | SO49472 | 2023-06-18 | 3.89 | 35.96 | 24.29 | |||
| SO47965_32 | 953F-437D-84 | PO19546111394 | 100 | 285 | 417 | 206 | 5 | 2023-02-23 | 324.45 | 8.11 | 2023-02-11 | 1 | 300.12 | 1 | 324.45 | 32 | SO47965 | 2023-02-18 | 25.96 | 300.12 | 324.45 | |||
| SO57172_4 | 694F-4039-93 | PO5655181244 | 100 | 287 | 576 | 563 | 4 | 2024-02-23 | 2860.88 | 71.52 | 2024-02-11 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO57172 | 2024-02-18 | 228.87 | 2963.88 | 1430.44 | |||
| SO46996_5 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 371 | 512 | 5 | 2022-11-23 | 3926.81 | 98.17 | 2022-11-11 | 3 | 1320.68 | 1 | 3926.81 | 5 | SO46996 | 2022-11-18 | 314.15 | 3962.05 | 1308.94 | |||
| SO49086_4 | DC81-474D-82 | PO15196160156 | 100 | 282 | 337 | 258 | 4 | 2023-05-26 | 2348.97 | 58.72 | 2023-05-14 | 5 | 486.71 | 1 | 2348.97 | 4 | SO49086 | 2023-05-21 | 187.92 | 2433.53 | 469.79 | |||
| SO63141_14 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 488 | 12 | 6 | 2024-05-25 | 194.36 | 4.86 | 2024-05-13 | 6 | 41.57 | 1 | 194.36 | 14 | SO63141 | 2024-05-20 | 15.55 | 249.43 | 32.39 | |||
| SO43911_15 | EB9C-47A4-AC | PO7627190040 | 100 | 286 | 270 | 433 | 1 | 2021-11-23 | 551.81 | 13.80 | 2021-11-11 | 3 | 181.49 | 1 | 551.81 | 15 | SO43911 | 2021-11-18 | 44.15 | 544.46 | 183.94 | |||
| SO47008_25 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 461 | 426 | 6 | 2022-11-23 | 161.98 | 4.05 | 2022-11-11 | 3 | 37.12 | 1 | 161.98 | 25 | SO47008 | 2022-11-18 | 12.96 | 111.36 | 53.99 | |||
| SO47676_10 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 366 | 437 | 4 | 2023-01-23 | 647.99 | 16.20 | 2023-01-11 | 1 | 598.44 | 1 | 647.99 | 10 | SO47676 | 2023-01-18 | 51.84 | 598.44 | 647.99 | |||
| SO48057_40 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 385 | 343 | 1 | 2023-02-23 | 3601.58 | 90.04 | 2023-02-11 | 6 | 605.65 | 1 | 3601.58 | 40 | SO48057 | 2023-02-18 | 288.13 | 3633.90 | 600.26 | |||
| SO50306_42 | D376-4A40-86 | PO5858194676 | 100 | 285 | 460 | 566 | 5 | 2023-08-23 | 431.95 | 10.80 | 2023-08-11 | 8 | 37.12 | 1 | 431.95 | 42 | SO50306 | 2023-08-18 | 34.56 | 296.97 | 53.99 | |||
| SO46997_1 | 9714-4035-90 | PO11020181604 | 19 | 284 | 239 | 336 | 6 | 2022-11-23 | 780.82 | 19.52 | 2022-11-11 | 1 | 722.26 | 1 | 780.82 | 1 | SO46997 | 2022-11-18 | 62.47 | 722.26 | 780.82 | |||
| SO50735_4 | 915C-46CF-8E | PO2001132307 | 19 | 291 | 280 | 701 | 6 | 2023-09-23 | 183.94 | 4.60 | 2023-09-11 | 1 | 170.14 | 1 | 183.94 | 4 | SO50735 | 2023-09-18 | 14.72 | 170.14 | 183.94 | |||
| SO53473_1 | E4F8-4F0B-BC | PO16530183958 | 100 | 282 | 565 | 13 | 601 | 1 | 50.11 | 2023-12-24 | 334.06 | 7.10 | 2023-12-12 | 1 | 461.44 | 1 | 283.95 | 1 | SO53473 | 2023-12-19 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO50297_19 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 221 | 343 | 1 | 2023-08-23 | 161.49 | 4.04 | 2023-08-11 | 8 | 13.88 | 1 | 161.49 | 19 | SO50297 | 2023-08-18 | 12.92 | 111.03 | 20.19 | |||
| SO71797_45 | 8375-4C38-91 | PO16501134889 | 98 | 288 | 217 | 2 | 142 | 10 | 4.87 | 2024-09-23 | 243.53 | 5.97 | 2024-09-11 | 12 | 13.09 | 1 | 238.66 | 45 | SO71797 | 2024-09-18 | 19.09 | 157.04 | 20.29 | 0.02 |
| SO61232_3 | 3450-43E5-B1 | PO11136111699 | 19 | 284 | 579 | 120 | 6 | 2024-04-24 | 2186.73 | 54.67 | 2024-04-12 | 3 | 755.15 | 1 | 2186.73 | 3 | SO61232 | 2024-04-19 | 174.94 | 2265.45 | 728.91 | |||
| SO69508_24 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 384 | 433 | 1 | 2024-08-23 | 3361.47 | 84.04 | 2024-08-11 | 5 | 713.08 | 1 | 3361.47 | 24 | SO69508 | 2024-08-18 | 268.92 | 3565.40 | 672.29 | |||
| SO47369_2 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 435 | 239 | 4 | 2022-12-24 | 324.45 | 8.11 | 2022-12-12 | 1 | 300.12 | 1 | 324.45 | 2 | SO47369 | 2022-12-19 | 25.96 | 300.12 | 324.45 | |||
| SO71892_21 | 5153-412B-84 | PO4814151834 | 36 | 295 | 483 | 464 | 8 | 2024-09-23 | 360.00 | 9.00 | 2024-09-11 | 5 | 44.88 | 1 | 360.00 | 21 | SO71892 | 2024-09-18 | 28.80 | 224.40 | 72.00 | |||
| SO58905_13 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 544 | 340 | 10 | 2024-03-24 | 97.19 | 2.43 | 2024-03-12 | 2 | 35.96 | 1 | 97.19 | 13 | SO58905 | 2024-03-19 | 7.78 | 71.92 | 48.59 | |||
| SO71830_27 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 570 | 281 | 6 | 2024-09-23 | 445.41 | 11.14 | 2024-09-11 | 1 | 461.44 | 1 | 445.41 | 27 | SO71830 | 2024-09-18 | 35.63 | 461.44 | 445.41 | |||
| SO47012_7 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 453 | 66 | 6 | 2022-11-23 | 215.96 | 5.40 | 2022-11-11 | 6 | 24.75 | 1 | 215.96 | 7 | SO47012 | 2022-11-18 | 17.28 | 148.48 | 35.99 | |||
| SO53492_24 | 6D1A-4E58-A3 | PO13630111535 | 6 | 294 | 214 | 640 | 9 | 2023-12-24 | 41.99 | 1.05 | 2023-12-12 | 2 | 13.09 | 1 | 41.99 | 24 | SO53492 | 2023-12-19 | 3.36 | 26.17 | 20.99 | |||
| SO49490_25 | 0396-4322-83 | PO19343175441 | 100 | 282 | 213 | 24 | 4 | 2023-06-23 | 201.87 | 5.05 | 2023-06-11 | 10 | 13.88 | 1 | 201.87 | 25 | SO49490 | 2023-06-18 | 16.15 | 138.78 | 20.19 | |||
| SO46672_33 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 271 | 81 | 5 | 2022-10-23 | 404.66 | 10.12 | 2022-10-11 | 2 | 187.16 | 1 | 404.66 | 33 | SO46672 | 2022-10-18 | 32.37 | 374.31 | 202.33 | |||
| SO51720_9 | E39F-4680-AC | PO15370128892 | 100 | 281 | 516 | 381 | 3 | 2023-11-23 | 46.97 | 1.17 | 2023-11-11 | 2 | 17.38 | 1 | 46.97 | 9 | SO51720 | 2023-11-18 | 3.76 | 34.76 | 23.48 | |||
| SO53467_22 | BE84-4F9B-8E | PO17487177251 | 100 | 293 | 287 | 692 | 1 | 2023-12-24 | 809.33 | 20.23 | 2023-12-12 | 4 | 204.63 | 1 | 809.33 | 22 | SO53467 | 2023-12-19 | 64.75 | 818.50 | 202.33 | |||
| SO65310_11 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 225 | 3 | 4 | 2024-06-23 | 16.18 | 0.40 | 2024-06-11 | 3 | 6.92 | 1 | 16.18 | 11 | SO65310 | 2024-06-18 | 1.29 | 20.77 | 5.39 | |||
| SO48052_3 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 365 | 435 | 4 | 2023-02-23 | 647.99 | 16.20 | 2023-02-11 | 1 | 598.44 | 1 | 647.99 | 3 | SO48052 | 2023-02-18 | 51.84 | 598.44 | 647.99 | |||
| SO61201_2 | 7954-474E-AB | PO3016192040 | 100 | 281 | 475 | 183 | 3 | 2024-04-24 | 125.98 | 3.15 | 2024-04-12 | 3 | 26.18 | 1 | 125.98 | 2 | SO61201 | 2024-04-19 | 10.08 | 78.53 | 41.99 | |||
| SO48051_6 | D18B-421F-99 | PO3596190178 | 100 | 285 | 469 | 476 | 5 | 2023-02-23 | 182.35 | 4.56 | 2023-02-11 | 8 | 15.67 | 1 | 182.35 | 6 | SO48051 | 2023-02-18 | 14.59 | 125.37 | 22.79 | |||
| SO63179_32 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 490 | 535 | 7 | 2024-05-25 | 161.97 | 4.05 | 2024-05-13 | 5 | 41.57 | 1 | 161.97 | 32 | SO63179 | 2024-05-20 | 12.96 | 207.86 | 32.39 |
Generated 2024-11-10 13:42:42.819 UTC