[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6499 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO57030_26 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 501 | 236 | 1 | 2024-02-23 | 510.13 | 12.75 | 2024-02-11 | 7 | 53.93 | 1 | 510.13 | 26 | SO57030 | 2024-02-18 | 40.81 | 377.50 | 72.88 | |||
| SO47403_14 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 428 | 254 | 1 | 2022-12-24 | 418.51 | 10.46 | 2022-12-12 | 2 | 185.82 | 1 | 418.51 | 14 | SO47403 | 2022-12-19 | 33.48 | 371.64 | 209.26 | |||
| SO45292_1 | 1E6F-497E-9D | PO14993121765 | 100 | 287 | 235 | 696 | 1 | 2022-05-26 | 28.84 | 0.72 | 2022-05-14 | 1 | 31.72 | 1 | 28.84 | 1 | SO45292 | 2022-05-21 | 2.31 | 31.72 | 28.84 | |||
| SO57105_28 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 363 | 697 | 1 | 2024-02-23 | 9638.96 | 240.97 | 2024-02-11 | 7 | 1251.98 | 1 | 9638.96 | 28 | SO57105 | 2024-02-18 | 771.12 | 8763.87 | 1376.99 | |||
| SO46032_12 | 3A64-43B4-B5 | PO18676118909 | 100 | 282 | 345 | 697 | 1 | 2022-08-23 | 4079.99 | 102.00 | 2022-08-11 | 2 | 1912.15 | 1 | 4079.99 | 12 | SO46032 | 2022-08-18 | 326.40 | 3824.31 | 2039.99 | |||
| SO48057_8 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 368 | 343 | 1 | 2023-02-23 | 7330.05 | 183.25 | 2023-02-11 | 5 | 1518.79 | 1 | 7330.05 | 8 | SO48057 | 2023-02-18 | 586.40 | 7593.93 | 1466.01 | |||
| SO71836_17 | E41E-40C1-84 | PO841118259 | 100 | 286 | 603 | 254 | 1 | 2024-09-23 | 364.47 | 9.11 | 2024-09-11 | 5 | 53.94 | 1 | 364.47 | 17 | SO71836 | 2024-09-18 | 29.16 | 269.71 | 72.89 | |||
| SO46649_9 | A093-4C86-B7 | PO2929149182 | 100 | 289 | 470 | 380 | 1 | 2022-10-23 | 91.18 | 2.28 | 2022-10-11 | 4 | 15.67 | 1 | 91.18 | 9 | SO46649 | 2022-10-18 | 7.29 | 62.68 | 22.79 | |||
| SO47999_11 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 410 | 650 | 1 | 2023-02-23 | 72.89 | 1.82 | 2023-02-11 | 2 | 26.97 | 1 | 72.89 | 11 | SO47999 | 2023-02-18 | 5.83 | 53.94 | 36.45 | |||
| SO57030_5 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 515 | 236 | 1 | 2024-02-23 | 65.09 | 1.63 | 2024-02-11 | 4 | 12.04 | 1 | 65.09 | 5 | SO57030 | 2024-02-18 | 5.21 | 48.17 | 16.27 | |||
| SO44078_6 | 6487-4A93-82 | PO19169159771 | 100 | 289 | 351 | 272 | 1 | 2021-12-24 | 10124.97 | 253.12 | 2021-12-12 | 5 | 1898.09 | 1 | 10124.97 | 6 | SO44078 | 2021-12-19 | 810.00 | 9490.47 | 2024.99 | |||
| SO46957_52 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 409 | 236 | 1 | 2022-11-23 | 418.51 | 10.46 | 2022-11-11 | 2 | 185.82 | 1 | 418.51 | 52 | SO46957 | 2022-11-18 | 33.48 | 371.64 | 209.26 | |||
| SO53613_31 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 477 | 109 | 1 | 2023-12-24 | 26.95 | 0.67 | 2023-12-12 | 9 | 1.87 | 1 | 26.95 | 31 | SO53613 | 2023-12-19 | 2.16 | 16.80 | 2.99 | |||
| SO43917_9 | 9EDA-4CDB-A8 | PO8816199739 | 100 | 289 | 324 | 218 | 1 | 2021-11-23 | 419.46 | 10.49 | 2021-11-11 | 1 | 413.15 | 1 | 419.46 | 9 | SO43917 | 2021-11-18 | 33.56 | 413.15 | 419.46 | |||
| SO49844_30 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 414 | 290 | 1 | 2023-07-24 | 149.03 | 3.73 | 2023-07-12 | 1 | 110.28 | 1 | 149.03 | 30 | SO49844 | 2023-07-19 | 11.92 | 110.28 | 149.03 | |||
| SO50241_2 | ACB7-4116-A8 | PO18908114626 | 100 | 289 | 468 | 164 | 1 | 2023-08-23 | 45.59 | 1.14 | 2023-08-11 | 2 | 15.67 | 1 | 45.59 | 2 | SO50241 | 2023-08-18 | 3.65 | 31.34 | 22.79 | |||
| SO58963_32 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 476 | 254 | 1 | 2024-03-24 | 377.95 | 9.45 | 2024-03-12 | 9 | 26.18 | 1 | 377.95 | 32 | SO58963 | 2024-03-19 | 30.24 | 235.59 | 41.99 | |||
| SO55269_15 | C087-4A55-8D | PO899192335 | 100 | 289 | 471 | 290 | 1 | 2024-01-23 | 304.80 | 7.62 | 2024-01-11 | 8 | 23.75 | 1 | 304.80 | 15 | SO55269 | 2024-01-18 | 24.38 | 189.99 | 38.10 | |||
| SO46967_4 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 308 | 487 | 1 | 2022-11-23 | 3721.36 | 93.03 | 2022-11-11 | 5 | 660.91 | 1 | 3721.36 | 4 | SO46967 | 2022-11-18 | 297.71 | 3304.57 | 744.27 | |||
| SO51830_20 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 520 | 433 | 1 | 2023-11-23 | 157.92 | 3.95 | 2023-11-11 | 5 | 23.37 | 1 | 157.92 | 20 | SO51830 | 2023-11-18 | 12.63 | 116.86 | 31.58 | |||
| SO48326_1 | C7D9-4798-BF | PO14065114327 | 100 | 293 | 407 | 379 | 1 | 2023-03-25 | 65.60 | 1.64 | 2023-03-13 | 1 | 48.55 | 1 | 65.60 | 1 | SO48326 | 2023-03-20 | 5.25 | 48.55 | 65.60 | |||
| SO51830_19 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 372 | 433 | 1 | 2023-11-23 | 4398.03 | 109.95 | 2023-11-11 | 3 | 1554.95 | 1 | 4398.03 | 19 | SO51830 | 2023-11-18 | 351.84 | 4664.84 | 1466.01 | |||
| SO49826_24 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 470 | 3 | 146 | 1 | 19.85 | 2023-07-24 | 397.00 | 9.43 | 2023-07-12 | 19 | 15.67 | 1 | 377.15 | 24 | SO49826 | 2023-07-19 | 30.17 | 297.75 | 20.89 | 0.05 |
| SO45549_4 | E477-44D2-B0 | PO783111978 | 100 | 286 | 336 | 91 | 1 | 2022-06-23 | 1677.84 | 41.95 | 2022-06-11 | 4 | 413.15 | 1 | 1677.84 | 4 | SO45549 | 2022-06-18 | 134.23 | 1652.59 | 419.46 | |||
| SO57045_13 | 4D3C-4309-BE | PO14587121888 | 100 | 293 | 561 | 199 | 1 | 2024-02-23 | 4291.33 | 107.28 | 2024-02-11 | 3 | 1481.94 | 1 | 4291.33 | 13 | SO57045 | 2024-02-18 | 343.31 | 4445.81 | 1430.44 | |||
| SO57136_26 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 372 | 433 | 1 | 2024-02-23 | 8796.06 | 219.90 | 2024-02-11 | 6 | 1554.95 | 1 | 8796.06 | 26 | SO57136 | 2024-02-18 | 703.68 | 9329.69 | 1466.01 | |||
| SO49826_12 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 458 | 146 | 1 | 2023-07-24 | 179.98 | 4.50 | 2023-07-12 | 4 | 30.93 | 1 | 179.98 | 12 | SO49826 | 2023-07-19 | 14.40 | 123.73 | 44.99 | |||
| SO46972_28 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 360 | 650 | 1 | 2022-11-23 | 4917.84 | 122.95 | 2022-11-11 | 4 | 1105.81 | 1 | 4917.84 | 28 | SO46972 | 2022-11-18 | 393.43 | 4423.24 | 1229.46 | |||
| SO49053_42 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 397 | 236 | 1 | 2023-05-26 | 121.47 | 3.04 | 2023-05-14 | 5 | 17.98 | 1 | 121.47 | 42 | SO49053 | 2023-05-21 | 9.72 | 89.89 | 24.29 | |||
| SO59010_25 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 488 | 109 | 1 | 2024-03-24 | 32.39 | 0.81 | 2024-03-12 | 1 | 41.57 | 1 | 32.39 | 25 | SO59010 | 2024-03-19 | 2.59 | 41.57 | 32.39 | |||
| SO50314_21 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 415 | 433 | 1 | 2023-08-23 | 198.04 | 4.95 | 2023-08-11 | 1 | 146.55 | 1 | 198.04 | 21 | SO50314 | 2023-08-18 | 15.84 | 146.55 | 198.04 | |||
| SO46060_7 | FB38-4EAA-A3 | PO11919125075 | 100 | 286 | 346 | 73 | 1 | 2022-08-23 | 16319.95 | 408.00 | 2022-08-11 | 8 | 1912.15 | 1 | 16319.95 | 7 | SO46060 | 2022-08-18 | 1305.60 | 15297.24 | 2039.99 | |||
| SO69508_25 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 378 | 433 | 1 | 2024-08-23 | 5864.04 | 146.60 | 2024-08-11 | 4 | 1554.95 | 1 | 5864.04 | 25 | SO69508 | 2024-08-18 | 469.12 | 6219.79 | 1466.01 | |||
| SO71893_3 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 579 | 163 | 1 | 2024-09-23 | 3644.55 | 91.11 | 2024-09-11 | 5 | 755.15 | 1 | 3644.55 | 3 | SO71893 | 2024-09-18 | 291.56 | 3775.75 | 728.91 | |||
| SO53452_26 | B555-4FD7-8B | PO870113712 | 100 | 286 | 603 | 621 | 1 | 2023-12-24 | 72.89 | 1.82 | 2023-12-12 | 1 | 53.94 | 1 | 72.89 | 26 | SO53452 | 2023-12-19 | 5.83 | 53.94 | 72.89 | |||
| SO69508_5 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 222 | 433 | 1 | 2024-08-23 | 125.96 | 3.15 | 2024-08-11 | 6 | 13.09 | 1 | 125.96 | 5 | SO69508 | 2024-08-18 | 10.08 | 78.52 | 20.99 | |||
| SO51783_20 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 513 | 697 | 1 | 2023-11-23 | 873.82 | 21.85 | 2023-11-11 | 4 | 199.38 | 1 | 873.82 | 20 | SO51783 | 2023-11-18 | 69.91 | 797.50 | 218.45 | |||
| SO59059_10 | FD9E-44C4-97 | PO7482187440 | 100 | 293 | 572 | 163 | 1 | 2024-03-24 | 1336.23 | 33.41 | 2024-03-12 | 3 | 461.44 | 1 | 1336.23 | 10 | SO59059 | 2024-03-19 | 106.90 | 1384.33 | 445.41 | |||
| SO45273_1 | E67F-4741-8D | PO18908136254 | 100 | 289 | 349 | 164 | 1 | 2022-05-26 | 6074.98 | 151.87 | 2022-05-14 | 3 | 1898.09 | 1 | 6074.98 | 1 | SO45273 | 2022-05-21 | 486.00 | 5694.28 | 2024.99 | |||
| SO51711_40 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 552 | 236 | 1 | 2023-11-23 | 109.79 | 2.74 | 2023-11-11 | 2 | 40.62 | 1 | 109.79 | 40 | SO51711 | 2023-11-18 | 8.78 | 81.24 | 54.89 | |||
| SO47666_16 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 224 | 146 | 1 | 2023-01-23 | 10.37 | 0.26 | 2023-01-11 | 2 | 5.23 | 1 | 10.37 | 16 | SO47666 | 2023-01-18 | 0.83 | 10.46 | 5.19 | |||
| SO48087_30 | 2285-4C77-9B | PO8816162044 | 100 | 289 | 323 | 218 | 1 | 2023-02-23 | 939.59 | 23.49 | 2023-02-11 | 2 | 486.71 | 1 | 939.59 | 30 | SO48087 | 2023-02-18 | 75.17 | 973.41 | 469.79 | |||
| SO47403_4 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 367 | 254 | 1 | 2022-12-24 | 1943.98 | 48.60 | 2022-12-12 | 3 | 598.44 | 1 | 1943.98 | 4 | SO47403 | 2022-12-19 | 155.52 | 1795.31 | 647.99 | |||
| SO53605_28 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 553 | 308 | 1 | 2023-12-24 | 55.31 | 1.38 | 2023-12-12 | 2 | 20.46 | 1 | 55.31 | 28 | SO53605 | 2023-12-19 | 4.42 | 40.93 | 27.65 | |||
| SO51138_16 | 685D-4916-A6 | PO9338137293 | 100 | 293 | 566 | 13 | 451 | 1 | 150.33 | 2023-10-23 | 1002.17 | 21.30 | 2023-10-11 | 3 | 461.44 | 1 | 851.85 | 16 | SO51138 | 2023-10-18 | 68.15 | 1384.33 | 334.06 | 0.15 |
| SO43683_2 | 2299-44F7-95 | PO2552113807 | 100 | 289 | 232 | 506 | 1 | 2021-10-23 | 57.68 | 1.44 | 2021-10-11 | 2 | 31.72 | 1 | 57.68 | 2 | SO43683 | 2021-10-18 | 4.61 | 63.45 | 28.84 | |||
| SO53452_42 | B555-4FD7-8B | PO870113712 | 100 | 286 | 569 | 13 | 621 | 1 | 50.11 | 2023-12-24 | 334.06 | 7.10 | 2023-12-12 | 1 | 461.44 | 1 | 283.95 | 42 | SO53452 | 2023-12-19 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO49826_1 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 230 | 146 | 1 | 2023-07-24 | 173.04 | 4.33 | 2023-07-12 | 6 | 29.08 | 1 | 173.04 | 1 | SO49826 | 2023-07-19 | 13.84 | 174.48 | 28.84 | |||
| SO44100_19 | D5BC-4BB2-BF | PO13543119495 | 100 | 287 | 220 | 293 | 1 | 2021-12-24 | 80.75 | 2.02 | 2021-12-12 | 4 | 12.03 | 1 | 80.75 | 19 | SO44100 | 2021-12-19 | 6.46 | 48.11 | 20.19 | |||
| SO47992_26 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 447 | 487 | 1 | 2023-02-23 | 75.00 | 1.88 | 2023-02-11 | 5 | 10.31 | 1 | 75.00 | 26 | SO47992 | 2023-02-18 | 6.00 | 51.56 | 15.00 | |||
| SO49826_10 | 2EBD-4312-9C | PO16588178669 | 100 | 289 | 468 | 146 | 1 | 2023-07-24 | 45.59 | 1.14 | 2023-07-12 | 2 | 15.67 | 1 | 45.59 | 10 | SO49826 | 2023-07-19 | 3.65 | 31.34 | 22.79 | |||
| SO46974_11 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 305 | 127 | 1 | 2022-11-23 | 1472.29 | 36.81 | 2022-11-11 | 2 | 653.70 | 1 | 1472.29 | 11 | SO46974 | 2022-11-18 | 117.78 | 1307.39 | 736.15 | |||
| SO46051_9 | DF61-462A-87 | PO14500186228 | 100 | 282 | 293 | 650 | 1 | 2022-08-23 | 1445.19 | 36.13 | 2022-08-11 | 2 | 623.84 | 1 | 1445.19 | 9 | SO46051 | 2022-08-18 | 115.62 | 1247.68 | 722.59 | |||
| SO65234_18 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 559 | 182 | 1 | 2024-06-23 | 48.58 | 1.21 | 2024-06-11 | 4 | 8.99 | 1 | 48.58 | 18 | SO65234 | 2024-06-18 | 3.89 | 35.95 | 12.14 | |||
| SO50297_27 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 387 | 343 | 1 | 2023-08-23 | 3001.31 | 75.03 | 2023-08-11 | 5 | 605.65 | 1 | 3001.31 | 27 | SO50297 | 2023-08-18 | 240.11 | 3028.25 | 600.26 | |||
| SO49136_9 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 383 | 343 | 1 | 2023-05-26 | 4802.10 | 120.05 | 2023-05-14 | 8 | 605.65 | 1 | 4802.10 | 9 | SO49136 | 2023-05-21 | 384.17 | 4845.19 | 600.26 | |||
| SO69508_1 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 581 | 433 | 1 | 2024-08-23 | 10205.94 | 255.15 | 2024-08-11 | 10 | 1082.51 | 1 | 10205.94 | 1 | SO69508 | 2024-08-18 | 816.48 | 10825.10 | 1020.59 | |||
| SO51711_18 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 514 | 236 | 1 | 2023-11-23 | 319.50 | 7.99 | 2023-11-11 | 5 | 47.29 | 1 | 319.50 | 18 | SO51711 | 2023-11-18 | 25.56 | 236.43 | 63.90 | |||
| SO71812_11 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 298 | 293 | 1 | 2024-09-23 | 809.76 | 20.24 | 2024-09-11 | 1 | 739.04 | 1 | 809.76 | 11 | SO71812 | 2024-09-18 | 64.78 | 739.04 | 809.76 | |||
| SO71790_4 | 4C33-40F1-BC | PO17487184338 | 100 | 293 | 545 | 692 | 1 | 2024-09-23 | 72.88 | 1.82 | 2024-09-11 | 3 | 17.98 | 1 | 72.88 | 4 | SO71790 | 2024-09-18 | 5.83 | 53.93 | 24.29 | |||
| SO51723_5 | 4D27-4A2E-A7 | PO14529141662 | 100 | 293 | 544 | 289 | 1 | 2023-11-23 | 48.59 | 1.21 | 2023-11-11 | 1 | 35.96 | 1 | 48.59 | 5 | SO51723 | 2023-11-18 | 3.89 | 35.96 | 48.59 | |||
| SO47970_17 | 6203-4130-A9 | PO18676198287 | 100 | 282 | 360 | 697 | 1 | 2023-02-23 | 7376.75 | 184.42 | 2023-02-11 | 6 | 1105.81 | 1 | 7376.75 | 17 | SO47970 | 2023-02-18 | 590.14 | 6634.86 | 1229.46 |
Generated 2024-11-10 08:03:37.873 UTC