[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1688 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55283_19 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 514 | 442 | 6 | 2024-01-22 | 127.80 | 3.20 | 2024-01-10 | 2 | 47.29 | 1 | 127.80 | 19 | SO55283 | 2024-01-17 | 10.22 | 94.57 | 63.90 | |||
SO65226_21 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 436 | 481 | 7 | 2024-06-22 | 356.90 | 8.92 | 2024-06-10 | 1 | 360.94 | 1 | 356.90 | 21 | SO65226 | 2024-06-17 | 28.55 | 360.94 | 356.90 | |||
SO65269_6 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 361 | 648 | 4 | 2024-06-22 | 2753.99 | 68.85 | 2024-06-10 | 2 | 1251.98 | 1 | 2753.99 | 6 | SO65269 | 2024-06-17 | 220.32 | 2503.96 | 1376.99 | |||
SO48293_9 | 85D2-4CB9-A6 | PO19604177614 | 98 | 288 | 401 | 340 | 10 | 2023-03-24 | 65.60 | 1.64 | 2023-03-12 | 1 | 48.55 | 1 | 65.60 | 9 | SO48293 | 2023-03-19 | 5.25 | 48.55 | 65.60 | |||
SO45053_4 | 1527-4B4C-8B | PO13775163879 | 100 | 281 | 223 | 618 | 2 | 2022-04-24 | 10.37 | 0.26 | 2022-04-12 | 2 | 5.71 | 1 | 10.37 | 4 | SO45053 | 2022-04-19 | 0.83 | 11.41 | 5.19 | |||
SO65303_31 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 490 | 61 | 4 | 2024-06-22 | 64.79 | 1.62 | 2024-06-10 | 2 | 41.57 | 1 | 64.79 | 31 | SO65303 | 2024-06-17 | 5.18 | 83.14 | 32.39 | |||
SO51124_39 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 353 | 2 | 245 | 6 | 376.77 | 2023-10-22 | 18838.32 | 461.54 | 2023-10-10 | 14 | 1265.62 | 1 | 18461.55 | 39 | SO51124 | 2023-10-17 | 1476.92 | 17718.67 | 1345.59 | 0.02 |
SO58926_21 | B82A-4380-9C | PO15486118845 | 100 | 292 | 511 | 121 | 7 | 2024-03-23 | 1092.27 | 27.31 | 2024-03-11 | 5 | 199.38 | 1 | 1092.27 | 21 | SO58926 | 2024-03-18 | 87.38 | 996.88 | 218.45 | |||
SO61181_1 | EF82-40B7-8E | PO17197117656 | 100 | 283 | 355 | 125 | 2 | 2024-04-23 | 2783.99 | 69.60 | 2024-04-11 | 2 | 1265.62 | 1 | 2783.99 | 1 | SO61181 | 2024-04-18 | 222.72 | 2531.24 | 1391.99 | |||
SO49837_17 | C136-4536-9D | PO12412160791 | 100 | 281 | 448 | 670 | 3 | 2023-07-23 | 23.99 | 0.60 | 2023-07-11 | 2 | 8.25 | 1 | 23.99 | 17 | SO49837 | 2023-07-18 | 1.92 | 16.49 | 11.99 | |||
SO63181_23 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 384 | 700 | 5 | 2024-05-24 | 672.29 | 16.81 | 2024-05-12 | 1 | 713.08 | 1 | 672.29 | 23 | SO63181 | 2024-05-19 | 53.78 | 713.08 | 672.29 | |||
SO49084_8 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 352 | 667 | 2 | 2023-05-25 | 4971.41 | 124.29 | 2023-05-13 | 4 | 1117.86 | 1 | 4971.41 | 8 | SO49084 | 2023-05-20 | 397.71 | 4471.42 | 1242.85 | |||
SO50225_48 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 466 | 175 | 7 | 2023-08-22 | 56.52 | 1.41 | 2023-08-10 | 4 | 9.71 | 1 | 56.52 | 48 | SO50225 | 2023-08-17 | 4.52 | 38.85 | 14.13 | |||
SO51761_4 | 056F-4C15-93 | PO580111702 | 36 | 295 | 570 | 13 | 230 | 8 | 200.43 | 2023-11-22 | 1336.23 | 28.39 | 2023-11-10 | 4 | 461.44 | 1 | 1135.80 | 4 | SO51761 | 2023-11-17 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO44488_12 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 322 | 206 | 5 | 2022-02-22 | 1258.38 | 31.46 | 2022-02-10 | 3 | 413.15 | 1 | 1258.38 | 12 | SO44488 | 2022-02-17 | 100.67 | 1239.44 | 419.46 | |||
SO55300_14 | 40F4-470B-82 | PO8004112820 | 6 | 296 | 566 | 231 | 9 | 2024-01-22 | 445.41 | 11.14 | 2024-01-10 | 1 | 461.44 | 1 | 445.41 | 14 | SO55300 | 2024-01-17 | 35.63 | 461.44 | 445.41 | |||
SO55243_14 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 605 | 299 | 6 | 2024-01-22 | 647.99 | 16.20 | 2024-01-10 | 2 | 343.65 | 1 | 647.99 | 14 | SO55243 | 2024-01-17 | 51.84 | 687.30 | 323.99 | |||
SO51126_26 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 568 | 13 | 205 | 4 | 250.54 | 2023-10-22 | 1670.29 | 35.49 | 2023-10-10 | 5 | 461.44 | 1 | 1419.74 | 26 | SO51126 | 2023-10-17 | 113.58 | 2307.22 | 334.06 | 0.15 |
SO65195_14 | 11FD-44C6-95 | PO12354156814 | 100 | 283 | 600 | 197 | 3 | 2024-06-22 | 647.99 | 16.20 | 2024-06-10 | 2 | 294.58 | 1 | 647.99 | 14 | SO65195 | 2024-06-17 | 51.84 | 589.16 | 323.99 | |||
SO57143_28 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 560 | 2 | 193 | 7 | 155.01 | 2024-02-22 | 7750.74 | 189.89 | 2024-02-10 | 11 | 755.15 | 1 | 7595.73 | 28 | SO57143 | 2024-02-17 | 607.66 | 8306.66 | 704.61 | 0.02 |
SO47416_51 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 280 | 90 | 5 | 2022-12-23 | 919.69 | 22.99 | 2022-12-11 | 5 | 170.14 | 1 | 919.69 | 51 | SO47416 | 2022-12-18 | 73.58 | 850.71 | 183.94 | |||
SO58981_7 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 490 | 118 | 6 | 2024-03-23 | 259.15 | 6.48 | 2024-03-11 | 8 | 41.57 | 1 | 259.15 | 7 | SO58981 | 2024-03-18 | 20.73 | 332.58 | 32.39 | |||
SO57157_23 | 2435-487B-AC | PO4843135815 | 100 | 287 | 408 | 257 | 4 | 2024-02-22 | 72.16 | 1.80 | 2024-02-10 | 1 | 53.40 | 1 | 72.16 | 23 | SO57157 | 2024-02-17 | 5.77 | 53.40 | 72.16 | |||
SO65280_6 | FE9D-45E4-AE | PO4814116369 | 36 | 295 | 565 | 464 | 8 | 2024-06-22 | 445.41 | 11.14 | 2024-06-10 | 1 | 461.44 | 1 | 445.41 | 6 | SO65280 | 2024-06-17 | 35.63 | 461.44 | 445.41 | |||
SO50705_6 | CFC7-4B41-A2 | PO3103161654 | 100 | 281 | 333 | 147 | 3 | 2023-09-22 | 1409.38 | 35.23 | 2023-09-10 | 3 | 486.71 | 1 | 1409.38 | 6 | SO50705 | 2023-09-17 | 112.75 | 1460.12 | 469.79 | |||
SO51740_7 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 214 | 677 | 6 | 2023-11-22 | 41.99 | 1.05 | 2023-11-10 | 2 | 13.09 | 1 | 41.99 | 7 | SO51740 | 2023-11-17 | 3.36 | 26.17 | 20.99 | |||
SO69464_40 | 8924-465B-BE | PO2668146931 | 100 | 292 | 474 | 535 | 7 | 2024-08-22 | 419.94 | 10.50 | 2024-08-10 | 10 | 26.18 | 1 | 419.94 | 40 | SO69464 | 2024-08-17 | 33.60 | 261.76 | 41.99 | |||
SO43898_11 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 215 | 84 | 6 | 2021-11-22 | 161.49 | 4.04 | 2021-11-10 | 8 | 12.03 | 1 | 161.49 | 11 | SO43898 | 2021-11-17 | 12.92 | 96.22 | 20.19 | |||
SO51726_6 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 573 | 199 | 1 | 2023-11-22 | 4291.33 | 107.28 | 2023-11-10 | 3 | 1481.94 | 1 | 4291.33 | 6 | SO51726 | 2023-11-17 | 343.31 | 4445.81 | 1430.44 | |||
SO46993_28 | F652-4085-A4 | PO11658111433 | 100 | 272 | 448 | 233 | 2 | 2022-11-22 | 95.95 | 2.40 | 2022-11-10 | 8 | 8.25 | 1 | 95.95 | 28 | SO46993 | 2022-11-17 | 7.68 | 65.97 | 11.99 | |||
SO58951_18 | 96F8-470F-9B | PO11397163065 | 36 | 295 | 532 | 176 | 8 | 2024-03-23 | 299.75 | 7.49 | 2024-03-11 | 2 | 136.79 | 1 | 299.75 | 18 | SO58951 | 2024-03-18 | 23.98 | 273.57 | 149.87 | |||
SO53512_16 | 6AC2-4C2F-81 | PO10353157108 | 98 | 290 | 474 | 3 | 88 | 10 | 32.72 | 2023-12-23 | 654.41 | 15.54 | 2023-12-11 | 17 | 26.18 | 1 | 621.69 | 16 | SO53512 | 2023-12-18 | 49.73 | 445.00 | 38.49 | 0.05 |
SO47054_7 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 415 | 433 | 1 | 2022-11-22 | 198.04 | 4.95 | 2022-11-10 | 1 | 146.55 | 1 | 198.04 | 7 | SO47054 | 2022-11-17 | 15.84 | 146.55 | 198.04 | |||
SO43886_11 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 322 | 317 | 6 | 2021-11-22 | 2097.29 | 52.43 | 2021-11-10 | 5 | 413.15 | 1 | 2097.29 | 11 | SO43886 | 2021-11-17 | 167.78 | 2065.73 | 419.46 | |||
SO58918_64 | C811-4D40-80 | PO17574131484 | 19 | 291 | 309 | 678 | 6 | 2024-03-23 | 1637.40 | 40.94 | 2024-03-11 | 2 | 747.20 | 1 | 1637.40 | 64 | SO58918 | 2024-03-18 | 130.99 | 1494.40 | 818.70 | |||
SO48033_44 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 329 | 426 | 6 | 2023-02-22 | 1409.38 | 35.23 | 2023-02-10 | 3 | 486.71 | 1 | 1409.38 | 44 | SO48033 | 2023-02-17 | 112.75 | 1460.12 | 469.79 | |||
SO57145_13 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 501 | 435 | 4 | 2024-02-22 | 72.88 | 1.82 | 2024-02-10 | 1 | 53.93 | 1 | 72.88 | 13 | SO57145 | 2024-02-17 | 5.83 | 53.93 | 72.88 | |||
SO44772_6 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 314 | 579 | 3 | 2022-03-24 | 12881.77 | 322.04 | 2022-03-12 | 6 | 2171.29 | 1 | 12881.77 | 6 | SO44772 | 2022-03-19 | 1030.54 | 13027.77 | 2146.96 | |||
SO44800_6 | 3119-4CF3-BF | PO9019144492 | 100 | 281 | 351 | 576 | 2 | 2022-03-24 | 4049.99 | 101.25 | 2022-03-12 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO44800 | 2022-03-19 | 324.00 | 3796.19 | 2024.99 | |||
SO55264_14 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 484 | 491 | 4 | 2024-01-22 | 23.85 | 0.60 | 2024-01-10 | 5 | 2.97 | 1 | 23.85 | 14 | SO55264 | 2024-01-17 | 1.91 | 14.87 | 4.77 | |||
SO51721_48 | 9429-430D-89 | PO14500124798 | 100 | 282 | 472 | 650 | 1 | 2023-11-22 | 304.80 | 7.62 | 2023-11-10 | 8 | 23.75 | 1 | 304.80 | 48 | SO51721 | 2023-11-17 | 24.38 | 189.99 | 38.10 | |||
SO46987_1 | 60CF-4768-AF | PO12702179544 | 100 | 292 | 358 | 175 | 7 | 2022-11-22 | 4917.84 | 122.95 | 2022-11-10 | 4 | 1105.81 | 1 | 4917.84 | 1 | SO46987 | 2022-11-17 | 393.43 | 4423.24 | 1229.46 | |||
SO55324_12 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 231 | 523 | 3 | 2024-01-22 | 59.99 | 1.50 | 2024-01-10 | 2 | 38.49 | 1 | 59.99 | 12 | SO55324 | 2024-01-17 | 4.80 | 76.98 | 29.99 | |||
SO49891_33 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 339 | 538 | 10 | 2023-07-23 | 469.79 | 11.74 | 2023-07-11 | 1 | 486.71 | 1 | 469.79 | 33 | SO49891 | 2023-07-18 | 37.58 | 486.71 | 469.79 | |||
SO44742_4 | BE6B-4A54-91 | PO19488180017 | 100 | 283 | 334 | 57 | 3 | 2022-03-24 | 1677.84 | 41.95 | 2022-03-12 | 4 | 413.15 | 1 | 1677.84 | 4 | SO44742 | 2022-03-19 | 134.23 | 1652.59 | 419.46 | |||
SO46028_21 | 7BBE-413C-83 | PO19546126425 | 100 | 285 | 318 | 206 | 5 | 2022-08-22 | 1749.59 | 43.74 | 2022-08-10 | 2 | 884.71 | 1 | 1749.59 | 21 | SO46028 | 2022-08-17 | 139.97 | 1769.42 | 874.79 | |||
SO55266_3 | 03C7-431B-BA | PO10527171106 | 19 | 284 | 484 | 480 | 6 | 2024-01-22 | 9.54 | 0.24 | 2024-01-10 | 2 | 2.97 | 1 | 9.54 | 3 | SO55266 | 2024-01-17 | 0.76 | 5.95 | 4.77 | |||
SO63263_11 | 1E1A-44EE-94 | PO4843118280 | 100 | 287 | 384 | 257 | 4 | 2024-05-24 | 672.29 | 16.81 | 2024-05-12 | 1 | 713.08 | 1 | 672.29 | 11 | SO63263 | 2024-05-19 | 53.78 | 713.08 | 672.29 | |||
SO46053_3 | E530-47A7-9A | PO14471143194 | 100 | 286 | 350 | 145 | 1 | 2022-08-22 | 6074.98 | 151.87 | 2022-08-10 | 3 | 1898.09 | 1 | 6074.98 | 3 | SO46053 | 2022-08-17 | 486.00 | 5694.28 | 2024.99 | |||
SO47352_18 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 447 | 149 | 3 | 2022-12-23 | 75.00 | 1.88 | 2022-12-11 | 5 | 10.31 | 1 | 75.00 | 18 | SO47352 | 2022-12-18 | 6.00 | 51.56 | 15.00 | |||
SO69452_1 | 5ADC-4093-86 | PO10150198555 | 100 | 285 | 588 | 9 | 5 | 2024-08-22 | 461.69 | 11.54 | 2024-08-10 | 1 | 419.78 | 1 | 461.69 | 1 | SO69452 | 2024-08-17 | 36.94 | 419.78 | 461.69 | |||
SO53527_1 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 309 | 10 | 6 | 2023-12-23 | 1637.40 | 40.94 | 2023-12-11 | 2 | 747.20 | 1 | 1637.40 | 1 | SO53527 | 2023-12-18 | 130.99 | 1494.40 | 818.70 | |||
SO65199_19 | F8B4-4F74-87 | PO870111351 | 100 | 286 | 577 | 621 | 1 | 2024-06-22 | 2186.73 | 54.67 | 2024-06-10 | 3 | 755.15 | 1 | 2186.73 | 19 | SO65199 | 2024-06-17 | 174.94 | 2265.45 | 728.91 | |||
SO57154_14 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 237 | 263 | 6 | 2024-02-22 | 149.97 | 3.75 | 2024-02-10 | 5 | 38.49 | 1 | 149.97 | 14 | SO57154 | 2024-02-17 | 12.00 | 192.46 | 29.99 | |||
SO71832_7 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 532 | 88 | 10 | 2024-09-22 | 299.75 | 7.49 | 2024-09-10 | 2 | 136.79 | 1 | 299.75 | 7 | SO71832 | 2024-09-17 | 23.98 | 273.57 | 149.87 | |||
SO46038_17 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 332 | 102 | 6 | 2022-08-22 | 1677.84 | 41.95 | 2022-08-10 | 4 | 413.15 | 1 | 1677.84 | 17 | SO46038 | 2022-08-17 | 134.23 | 1652.59 | 419.46 | |||
SO57054_10 | 8D1A-4AF0-91 | PO13456189029 | 36 | 292 | 522 | 614 | 7 | 2024-02-22 | 46.97 | 1.17 | 2024-02-10 | 2 | 17.38 | 1 | 46.97 | 10 | SO57054 | 2024-02-17 | 3.76 | 34.76 | 23.48 | |||
SO71820_17 | D332-4AF2-A3 | PO12673129941 | 100 | 292 | 287 | 499 | 7 | 2024-09-22 | 607.00 | 15.17 | 2024-09-10 | 3 | 204.63 | 1 | 607.00 | 17 | SO71820 | 2024-09-17 | 48.56 | 613.88 | 202.33 | |||
SO63132_17 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 378 | 479 | 6 | 2024-05-24 | 5864.04 | 146.60 | 2024-05-12 | 4 | 1554.95 | 1 | 5864.04 | 17 | SO63132 | 2024-05-19 | 469.12 | 6219.79 | 1466.01 | |||
SO51739_48 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 525 | 175 | 7 | 2023-11-22 | 950.58 | 23.76 | 2023-11-10 | 6 | 144.59 | 1 | 950.58 | 48 | SO51739 | 2023-11-17 | 76.05 | 867.56 | 158.43 |
Generated 2024-11-10 02:25:28.698 UTC