[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE SKIP 2000 < SKIP 125 > < TAKE 60 >
60 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49893_3 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 224 | 523 | 3 | 2023-07-26 | 36.31 | 0.91 | 2023-07-14 | 7 | 5.23 | 1 | 36.31 | 3 | SO49893 | 2023-07-21 | 2.90 | 36.61 | 5.19 | |||
| SO51101_17 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 471 | 2 | 618 | 2 | 8.84 | 2023-10-25 | 441.96 | 10.83 | 2023-10-13 | 12 | 23.75 | 1 | 433.12 | 17 | SO51101 | 2023-10-20 | 34.65 | 284.99 | 36.83 | 0.02 |
| SO51090_24 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 592 | 475 | 4 | 2023-10-25 | 2033.96 | 50.85 | 2023-10-13 | 6 | 308.22 | 1 | 2033.96 | 24 | SO51090 | 2023-10-20 | 162.72 | 1849.31 | 338.99 | |||
| SO55323_17 | 7398-4A3C-BE | PO8410135313 | 98 | 288 | 484 | 538 | 10 | 2024-01-25 | 38.16 | 0.95 | 2024-01-13 | 8 | 2.97 | 1 | 38.16 | 17 | SO55323 | 2024-01-20 | 3.05 | 23.79 | 4.77 | |||
| SO44110_20 | D69E-4EC8-8A | PO1624152036 | 100 | 283 | 262 | 579 | 3 | 2021-12-26 | 551.81 | 13.80 | 2021-12-14 | 3 | 181.49 | 1 | 551.81 | 20 | SO44110 | 2021-12-21 | 44.15 | 544.46 | 183.94 | |||
| SO47372_11 | 70B5-428B-86 | PO16124198007 | 100 | 282 | 323 | 649 | 4 | 2022-12-26 | 1409.38 | 35.23 | 2022-12-14 | 3 | 486.71 | 1 | 1409.38 | 11 | SO47372 | 2022-12-21 | 112.75 | 1460.12 | 469.79 | |||
| SO48325_26 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 263 | 418 | 3 | 2023-03-27 | 607.00 | 15.17 | 2023-03-15 | 3 | 187.16 | 1 | 607.00 | 26 | SO48325 | 2023-03-22 | 48.56 | 561.47 | 202.33 | |||
| SO55254_35 | BFF6-440D-80 | PO12441172246 | 36 | 295 | 484 | 302 | 8 | 2024-01-25 | 28.62 | 0.72 | 2024-01-13 | 6 | 2.97 | 1 | 28.62 | 35 | SO55254 | 2024-01-20 | 2.29 | 17.84 | 4.77 | |||
| SO57132_16 | C079-4BDD-A1 | PO5829189627 | 36 | 295 | 573 | 266 | 8 | 2024-02-25 | 4291.33 | 107.28 | 2024-02-13 | 3 | 1481.94 | 1 | 4291.33 | 16 | SO57132 | 2024-02-20 | 343.31 | 4445.81 | 1430.44 | |||
| SO50675_26 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 468 | 327 | 3 | 2023-09-25 | 22.79 | 0.57 | 2023-09-13 | 1 | 15.67 | 1 | 22.79 | 26 | SO50675 | 2023-09-20 | 1.82 | 15.67 | 22.79 | |||
| SO65241_9 | 1B2B-492F-A9 | PO9396172185 | 6 | 296 | 483 | 267 | 9 | 2024-06-25 | 216.00 | 5.40 | 2024-06-13 | 3 | 44.88 | 1 | 216.00 | 9 | SO65241 | 2024-06-20 | 17.28 | 134.64 | 72.00 | |||
| SO47354_7 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 273 | 173 | 6 | 2022-12-26 | 404.66 | 10.12 | 2022-12-14 | 2 | 187.16 | 1 | 404.66 | 7 | SO47354 | 2022-12-21 | 32.37 | 374.31 | 202.33 | |||
| SO53505_23 | B522-40FD-B5 | PO11397144048 | 36 | 295 | 309 | 176 | 8 | 2023-12-26 | 2456.10 | 61.40 | 2023-12-14 | 3 | 747.20 | 1 | 2456.10 | 23 | SO53505 | 2023-12-21 | 196.49 | 2241.60 | 818.70 | |||
| SO48090_10 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 433 | 135 | 5 | 2023-02-25 | 648.91 | 16.22 | 2023-02-13 | 2 | 300.12 | 1 | 648.91 | 10 | SO48090 | 2023-02-20 | 51.91 | 600.24 | 324.45 | |||
| SO58993_19 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 585 | 627 | 5 | 2024-03-26 | 1336.23 | 33.41 | 2024-03-14 | 3 | 461.44 | 1 | 1336.23 | 19 | SO58993 | 2024-03-21 | 106.90 | 1384.33 | 445.41 | |||
| SO63157_17 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 491 | 650 | 1 | 2024-05-27 | 226.76 | 5.67 | 2024-05-15 | 7 | 41.57 | 1 | 226.76 | 17 | SO63157 | 2024-05-22 | 18.14 | 291.01 | 32.39 | |||
| SO49849_17 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 224 | 506 | 1 | 2023-07-26 | 25.93 | 0.65 | 2023-07-14 | 5 | 5.23 | 1 | 25.93 | 17 | SO49849 | 2023-07-21 | 2.07 | 26.15 | 5.19 | |||
| SO51831_13 | C581-4EA9-9D | PO7598131197 | 100 | 285 | 376 | 45 | 5 | 2023-11-25 | 7330.05 | 183.25 | 2023-11-13 | 5 | 1554.95 | 1 | 7330.05 | 13 | SO51831 | 2023-11-20 | 586.40 | 7774.74 | 1466.01 | |||
| SO47001_10 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 415 | 684 | 2 | 2022-11-25 | 792.14 | 19.80 | 2022-11-13 | 4 | 146.55 | 1 | 792.14 | 10 | SO47001 | 2022-11-20 | 63.37 | 586.19 | 198.04 | |||
| SO49821_34 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 373 | 4 | 4 | 2023-07-26 | 6544.69 | 163.62 | 2023-07-14 | 5 | 1320.68 | 1 | 6544.69 | 34 | SO49821 | 2023-07-21 | 523.58 | 6603.42 | 1308.94 | |||
| SO57099_39 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 565 | 605 | 1 | 2024-02-25 | 890.82 | 22.27 | 2024-02-13 | 2 | 461.44 | 1 | 890.82 | 39 | SO57099 | 2024-02-20 | 71.27 | 922.89 | 445.41 | |||
| SO58918_26 | C811-4D40-80 | PO17574131484 | 19 | 291 | 463 | 678 | 6 | 2024-03-26 | 44.08 | 1.10 | 2024-03-14 | 3 | 9.16 | 1 | 44.08 | 26 | SO58918 | 2024-03-21 | 3.53 | 27.48 | 14.69 | |||
| SO61230_14 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 361 | 530 | 5 | 2024-04-26 | 2753.99 | 68.85 | 2024-04-14 | 2 | 1251.98 | 1 | 2753.99 | 14 | SO61230 | 2024-04-21 | 220.32 | 2503.96 | 1376.99 | |||
| SO69522_36 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 231 | 84 | 6 | 2024-08-25 | 179.96 | 4.50 | 2024-08-13 | 6 | 38.49 | 1 | 179.96 | 36 | SO69522 | 2024-08-20 | 14.40 | 230.95 | 29.99 | |||
| SO47398_10 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 321 | 461 | 6 | 2022-12-26 | 469.79 | 11.74 | 2022-12-14 | 1 | 486.71 | 1 | 469.79 | 10 | SO47398 | 2022-12-21 | 37.58 | 486.71 | 469.79 | |||
| SO48380_9 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 469 | 21 | 4 | 2023-03-27 | 91.18 | 2.28 | 2023-03-15 | 4 | 15.67 | 1 | 91.18 | 9 | SO48380 | 2023-03-22 | 7.29 | 62.68 | 22.79 | |||
| SO50313_39 | B452-44E9-91 | PO7656143984 | 100 | 282 | 230 | 403 | 4 | 2023-08-25 | 86.52 | 2.16 | 2023-08-13 | 3 | 29.08 | 1 | 86.52 | 39 | SO50313 | 2023-08-20 | 6.92 | 87.24 | 28.84 | |||
| SO53538_1 | D7FE-4E54-BD | PO18125134677 | 100 | 287 | 243 | 311 | 4 | 2023-12-26 | 858.90 | 21.47 | 2023-12-14 | 1 | 868.63 | 1 | 858.90 | 1 | SO53538 | 2023-12-21 | 68.71 | 868.63 | 858.90 | |||
| SO50727_40 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 435 | 54 | 2 | 2023-09-25 | 648.91 | 16.22 | 2023-09-13 | 2 | 300.12 | 1 | 648.91 | 40 | SO50727 | 2023-09-20 | 51.91 | 600.24 | 324.45 | |||
| SO49140_31 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 216 | 84 | 6 | 2023-05-28 | 100.93 | 2.52 | 2023-05-16 | 5 | 13.88 | 1 | 100.93 | 31 | SO49140 | 2023-05-23 | 8.07 | 69.39 | 20.19 | |||
| SO47049_22 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 468 | 345 | 4 | 2022-11-25 | 45.59 | 1.14 | 2022-11-13 | 2 | 15.67 | 1 | 45.59 | 22 | SO47049 | 2022-11-20 | 3.65 | 31.34 | 22.79 | |||
| SO48308_2 | D385-4FC5-B8 | PO17487191201 | 100 | 293 | 456 | 692 | 1 | 2023-03-27 | 224.97 | 5.62 | 2023-03-15 | 5 | 30.93 | 1 | 224.97 | 2 | SO48308 | 2023-03-22 | 18.00 | 154.67 | 44.99 | |||
| SO47006_2 | 142D-4F23-BF | PO957186440 | 98 | 288 | 447 | 376 | 10 | 2022-11-25 | 45.00 | 1.13 | 2022-11-13 | 3 | 10.31 | 1 | 45.00 | 2 | SO47006 | 2022-11-20 | 3.60 | 30.94 | 15.00 | |||
| SO69413_21 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 543 | 43 | 1 | 2024-08-25 | 74.51 | 1.86 | 2024-08-13 | 2 | 27.57 | 1 | 74.51 | 21 | SO69413 | 2024-08-20 | 5.96 | 55.14 | 37.25 | |||
| SO71863_7 | F39F-4A8F-B9 | PO16124166561 | 100 | 282 | 545 | 649 | 4 | 2024-09-25 | 48.59 | 1.21 | 2024-09-13 | 2 | 17.98 | 1 | 48.59 | 7 | SO71863 | 2024-09-20 | 3.89 | 35.96 | 24.29 | |||
| SO47004_7 | BB9D-49AE-A9 | PO928175019 | 98 | 290 | 456 | 2 | 484 | 10 | 11.31 | 2022-11-25 | 565.42 | 13.85 | 2022-11-13 | 13 | 30.93 | 1 | 554.12 | 7 | SO47004 | 2022-11-20 | 44.33 | 402.13 | 43.49 | 0.02 |
| SO53565_4 | 7768-4A45-93 | PO9396130858 | 6 | 296 | 561 | 14 | 267 | 9 | 381.45 | 2023-12-26 | 1907.26 | 38.15 | 2023-12-14 | 2 | 1481.94 | 1 | 1525.80 | 4 | SO53565 | 2023-12-21 | 122.06 | 2963.88 | 953.63 | 0.20 |
| SO49053_8 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 427 | 236 | 1 | 2023-05-28 | 627.77 | 15.69 | 2023-05-16 | 3 | 185.82 | 1 | 627.77 | 8 | SO49053 | 2023-05-23 | 50.22 | 557.46 | 209.26 | |||
| SO67325_9 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 484 | 2 | 221 | 4 | 1.29 | 2024-07-26 | 64.55 | 1.58 | 2024-07-14 | 14 | 2.97 | 1 | 63.26 | 9 | SO67325 | 2024-07-21 | 5.06 | 41.63 | 4.61 | 0.02 |
| SO67314_52 | 6653-491A-80 | PO3828116396 | 100 | 283 | 544 | 414 | 2 | 2024-07-26 | 48.59 | 1.21 | 2024-07-14 | 1 | 35.96 | 1 | 48.59 | 52 | SO67314 | 2024-07-21 | 3.89 | 35.96 | 48.59 | |||
| SO48012_17 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 265 | 78 | 4 | 2023-02-25 | 202.33 | 5.06 | 2023-02-13 | 1 | 187.16 | 1 | 202.33 | 17 | SO48012 | 2023-02-20 | 16.19 | 187.16 | 202.33 | |||
| SO44540_1 | 4773-44B5-9B | PO2900111031 | 100 | 286 | 232 | 469 | 1 | 2022-02-25 | 57.68 | 1.44 | 2022-02-13 | 2 | 31.72 | 1 | 57.68 | 1 | SO44540 | 2022-02-20 | 4.61 | 63.45 | 28.84 | |||
| SO46981_43 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 448 | 638 | 7 | 2022-11-25 | 119.94 | 3.00 | 2022-11-13 | 10 | 8.25 | 1 | 119.94 | 43 | SO46981 | 2022-11-20 | 9.60 | 82.46 | 11.99 | |||
| SO61229_29 | AC88-46DA-A3 | PO10324197030 | 98 | 288 | 527 | 196 | 10 | 2024-04-26 | 633.72 | 15.84 | 2024-04-14 | 4 | 144.59 | 1 | 633.72 | 29 | SO61229 | 2024-04-21 | 50.70 | 578.38 | 158.43 | |||
| SO50297_49 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 417 | 343 | 1 | 2023-08-25 | 973.36 | 24.33 | 2023-08-13 | 3 | 300.12 | 1 | 973.36 | 49 | SO50297 | 2023-08-20 | 77.87 | 900.36 | 324.45 | |||
| SO67307_1 | ED03-4D31-93 | PO14413128868 | 100 | 287 | 481 | 383 | 4 | 2024-07-26 | 26.97 | 0.67 | 2024-07-14 | 5 | 3.36 | 1 | 26.97 | 1 | SO67307 | 2024-07-21 | 2.16 | 16.81 | 5.39 | |||
| SO48350_19 | 1505-4FEA-92 | PO1798152196 | 19 | 291 | 411 | 10 | 6 | 2023-03-27 | 125.42 | 3.14 | 2023-03-15 | 1 | 92.81 | 1 | 125.42 | 19 | SO48350 | 2023-03-22 | 10.03 | 92.81 | 125.42 | |||
| SO46342_7 | 9BA4-4F6E-96 | PO14964115309 | 100 | 287 | 349 | 7 | 581 | 4 | 885.93 | 2022-09-25 | 2531.24 | 41.13 | 2022-09-13 | 3 | 1898.09 | 1 | 1645.31 | 7 | SO46342 | 2022-09-20 | 131.62 | 5694.28 | 843.75 | 0.35 |
| SO47417_11 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 354 | 187 | 4 | 2022-12-26 | 4971.41 | 124.29 | 2022-12-14 | 4 | 1117.86 | 1 | 4971.41 | 11 | SO47417 | 2022-12-21 | 397.71 | 4471.42 | 1242.85 | |||
| SO49076_9 | 8DE0-4335-95 | PO2523199507 | 100 | 287 | 371 | 167 | 4 | 2023-05-28 | 6544.69 | 163.62 | 2023-05-16 | 5 | 1320.68 | 1 | 6544.69 | 9 | SO49076 | 2023-05-23 | 523.58 | 6603.42 | 1308.94 | |||
| SO47403_46 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 427 | 254 | 1 | 2022-12-26 | 837.02 | 20.93 | 2022-12-14 | 4 | 185.82 | 1 | 837.02 | 46 | SO47403 | 2022-12-21 | 66.96 | 743.28 | 209.26 | |||
| SO49893_24 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 368 | 523 | 3 | 2023-07-26 | 4398.03 | 109.95 | 2023-07-14 | 3 | 1518.79 | 1 | 4398.03 | 24 | SO49893 | 2023-07-21 | 351.84 | 4556.36 | 1466.01 | |||
| SO71839_26 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 573 | 611 | 5 | 2024-09-25 | 8582.65 | 214.57 | 2024-09-13 | 6 | 1481.94 | 1 | 8582.65 | 26 | SO71839 | 2024-09-20 | 686.61 | 8891.63 | 1430.44 | |||
| SO57148_5 | AE28-4B3B-9D | PO3074151668 | 100 | 281 | 513 | 237 | 3 | 2024-02-25 | 218.45 | 5.46 | 2024-02-13 | 1 | 199.38 | 1 | 218.45 | 5 | SO57148 | 2024-02-20 | 17.48 | 199.38 | 218.45 | |||
| SO63123_4 | ADA9-4CA6-94 | PO19923184888 | 100 | 283 | 400 | 18 | 3 | 2024-05-27 | 74.30 | 1.86 | 2024-05-15 | 2 | 27.49 | 1 | 74.30 | 4 | SO63123 | 2024-05-22 | 5.94 | 54.99 | 37.15 | |||
| SO71822_17 | AEDC-410A-9B | PO11774139099 | 6 | 296 | 573 | 682 | 9 | 2024-09-25 | 1430.44 | 35.76 | 2024-09-13 | 1 | 1481.94 | 1 | 1430.44 | 17 | SO71822 | 2024-09-20 | 114.44 | 1481.94 | 1430.44 | |||
| SO53621_7 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 511 | 2 | 490 | 4 | 50.68 | 2023-12-26 | 2534.07 | 62.08 | 2023-12-14 | 12 | 199.38 | 1 | 2483.39 | 7 | SO53621 | 2023-12-21 | 198.67 | 2392.51 | 211.17 | 0.02 |
| SO51117_19 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 472 | 41 | 4 | 2023-10-25 | 114.30 | 2.86 | 2023-10-13 | 3 | 23.75 | 1 | 114.30 | 19 | SO51117 | 2023-10-20 | 9.14 | 71.25 | 38.10 | |||
| SO48776_18 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 305 | 414 | 2 | 2023-04-27 | 2208.44 | 55.21 | 2023-04-15 | 3 | 653.70 | 1 | 2208.44 | 18 | SO48776 | 2023-04-22 | 176.67 | 1961.09 | 736.15 | |||
| SO65200_20 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 474 | 2 | 254 | 1 | 10.55 | 2024-06-25 | 527.72 | 12.93 | 2024-06-13 | 13 | 26.18 | 1 | 517.17 | 20 | SO65200 | 2024-06-20 | 41.37 | 340.29 | 40.59 | 0.02 |
Generated 2024-11-13 00:57:28.935 UTC