[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 984 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49085_4 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 308 | 653 | 6 | 2024-05-21 | 2977.09 | 74.43 | 2024-05-09 | 4 | 660.91 | 1 | 2977.09 | 4 | SO49085 | 2024-05-16 | 238.17 | 2643.66 | 744.27 | |||
| SO44744_11 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 340 | 173 | 6 | 2023-03-21 | 419.46 | 10.49 | 2023-03-09 | 1 | 413.15 | 1 | 419.46 | 11 | SO44744 | 2023-03-16 | 33.56 | 413.15 | 419.46 | |||
| SO58930_26 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 591 | 497 | 6 | 2025-03-20 | 1016.98 | 25.42 | 2025-03-08 | 3 | 308.22 | 1 | 1016.98 | 26 | SO58930 | 2025-03-15 | 81.36 | 924.65 | 338.99 | |||
| SO61177_16 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 559 | 442 | 6 | 2025-04-20 | 24.29 | 0.61 | 2025-04-08 | 2 | 8.99 | 1 | 24.29 | 16 | SO61177 | 2025-04-15 | 1.94 | 17.97 | 12.14 | |||
| SO47988_17 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 333 | 533 | 6 | 2024-02-19 | 939.59 | 23.49 | 2024-02-07 | 2 | 486.71 | 1 | 939.59 | 17 | SO47988 | 2024-02-14 | 75.17 | 973.41 | 469.79 | |||
| SO57021_3 | D648-4574-9E | PO17632193909 | 19 | 291 | 488 | 28 | 6 | 2025-02-18 | 97.18 | 2.43 | 2025-02-06 | 3 | 41.57 | 1 | 97.18 | 3 | SO57021 | 2025-02-13 | 7.77 | 124.72 | 32.39 | |||
| SO58980_10 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 502 | 154 | 6 | 2025-03-20 | 800.21 | 20.01 | 2025-03-08 | 4 | 199.85 | 1 | 800.21 | 10 | SO58980 | 2025-03-15 | 64.02 | 799.41 | 200.05 | |||
| SO51766_10 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 472 | 280 | 6 | 2024-11-18 | 190.50 | 4.76 | 2024-11-06 | 5 | 23.75 | 1 | 190.50 | 10 | SO51766 | 2024-11-13 | 15.24 | 118.75 | 38.10 | |||
| SO49485_19 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 343 | 155 | 6 | 2024-06-18 | 2348.97 | 58.72 | 2024-06-06 | 5 | 486.71 | 1 | 2348.97 | 19 | SO49485 | 2024-06-13 | 187.92 | 2433.53 | 469.79 | |||
| SO65206_10 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 357 | 10 | 6 | 2025-06-19 | 8351.96 | 208.80 | 2025-06-07 | 6 | 1265.62 | 1 | 8351.96 | 10 | SO65206 | 2025-06-14 | 668.16 | 7593.72 | 1391.99 | |||
| SO51698_16 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 465 | 210 | 6 | 2024-11-18 | 29.39 | 0.73 | 2024-11-06 | 2 | 9.16 | 1 | 29.39 | 16 | SO51698 | 2024-11-13 | 2.35 | 18.32 | 14.69 | |||
| SO58930_5 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 512 | 497 | 6 | 2025-03-20 | 436.91 | 10.92 | 2025-03-08 | 2 | 199.38 | 1 | 436.91 | 5 | SO58930 | 2025-03-15 | 34.95 | 398.75 | 218.45 | |||
| SO47003_1 | 2C85-4918-94 | PO638185142 | 19 | 291 | 358 | 280 | 6 | 2023-11-19 | 3688.38 | 92.21 | 2023-11-07 | 3 | 1105.81 | 1 | 3688.38 | 1 | SO47003 | 2023-11-14 | 295.07 | 3317.43 | 1229.46 | |||
| SO46330_3 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 220 | 118 | 6 | 2023-09-19 | 20.19 | 0.50 | 2023-09-07 | 1 | 12.03 | 1 | 20.19 | 3 | SO46330 | 2023-09-14 | 1.61 | 12.03 | 20.19 | |||
| SO45527_22 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 334 | 155 | 6 | 2023-06-19 | 419.46 | 10.49 | 2023-06-07 | 1 | 413.15 | 1 | 419.46 | 22 | SO45527 | 2023-06-14 | 33.56 | 413.15 | 419.46 | |||
| SO65243_2 | F88F-4FB2-85 | PO11194174051 | 19 | 284 | 576 | 48 | 6 | 2025-06-19 | 2860.88 | 71.52 | 2025-06-07 | 2 | 1481.94 | 1 | 2860.88 | 2 | SO65243 | 2025-06-14 | 228.87 | 2963.88 | 1430.44 | |||
| SO51769_31 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 390 | 426 | 6 | 2024-11-18 | 1344.59 | 33.61 | 2024-11-06 | 2 | 713.08 | 1 | 1344.59 | 31 | SO51769 | 2024-11-13 | 107.57 | 1426.16 | 672.29 | |||
| SO46608_41 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 360 | 442 | 6 | 2023-10-19 | 4917.84 | 122.95 | 2023-10-07 | 4 | 1105.81 | 1 | 4917.84 | 41 | SO46608 | 2023-10-14 | 393.43 | 4423.24 | 1229.46 | |||
| SO48036_2 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 325 | 66 | 6 | 2024-02-19 | 939.59 | 23.49 | 2024-02-07 | 2 | 486.71 | 1 | 939.59 | 2 | SO48036 | 2024-02-14 | 75.17 | 973.41 | 469.79 | |||
| SO48306_10 | EA27-471A-9D | PO17574166075 | 19 | 291 | 230 | 678 | 6 | 2024-03-20 | 173.04 | 4.33 | 2024-03-08 | 6 | 29.08 | 1 | 173.04 | 10 | SO48306 | 2024-03-15 | 13.84 | 174.48 | 28.84 | |||
| SO46086_11 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 215 | 2 | 84 | 6 | 5.07 | 2023-08-19 | 253.68 | 6.22 | 2023-08-07 | 13 | 12.03 | 1 | 248.60 | 11 | SO46086 | 2023-08-14 | 19.89 | 156.36 | 19.51 | 0.02 |
| SO47354_39 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 385 | 173 | 6 | 2023-12-20 | 1200.53 | 30.01 | 2023-12-08 | 2 | 605.65 | 1 | 1200.53 | 39 | SO47354 | 2023-12-15 | 96.04 | 1211.30 | 600.26 | |||
| SO65164_4 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 531 | 118 | 6 | 2025-06-19 | 299.75 | 7.49 | 2025-06-07 | 2 | 136.79 | 1 | 299.75 | 4 | SO65164 | 2025-06-14 | 23.98 | 273.57 | 149.87 | |||
| SO49827_31 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 286 | 299 | 6 | 2024-07-19 | 551.81 | 13.80 | 2024-07-07 | 3 | 170.14 | 1 | 551.81 | 31 | SO49827 | 2024-07-14 | 44.15 | 510.43 | 183.94 | |||
| SO46940_8 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 385 | 479 | 6 | 2023-11-19 | 2401.05 | 60.03 | 2023-11-07 | 4 | 605.65 | 1 | 2401.05 | 8 | SO46940 | 2023-11-14 | 192.08 | 2422.60 | 600.26 | |||
| SO51703_5 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 545 | 12 | 6 | 2024-11-18 | 121.47 | 3.04 | 2024-11-06 | 5 | 17.98 | 1 | 121.47 | 5 | SO51703 | 2024-11-13 | 9.72 | 89.89 | 24.29 | |||
| SO51160_22 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 513 | 496 | 6 | 2024-10-18 | 1310.72 | 32.77 | 2024-10-06 | 6 | 199.38 | 1 | 1310.72 | 22 | SO51160 | 2024-10-13 | 104.86 | 1196.25 | 218.45 | |||
| SO65189_22 | 985E-4937-94 | PO14761195376 | 19 | 284 | 234 | 408 | 6 | 2025-06-19 | 239.95 | 6.00 | 2025-06-07 | 8 | 38.49 | 1 | 239.95 | 22 | SO65189 | 2025-06-14 | 19.20 | 307.94 | 29.99 | |||
| SO49052_5 | 8769-409E-94 | PO16733182723 | 19 | 291 | 456 | 533 | 6 | 2024-05-21 | 179.98 | 4.50 | 2024-05-09 | 4 | 30.93 | 1 | 179.98 | 5 | SO49052 | 2024-05-16 | 14.40 | 123.73 | 44.99 | |||
| SO57161_23 | 5BA9-4418-9F | PO1827135302 | 19 | 291 | 584 | 317 | 6 | 2025-02-18 | 647.99 | 16.20 | 2025-02-06 | 2 | 343.65 | 1 | 647.99 | 23 | SO57161 | 2025-02-13 | 51.84 | 687.30 | 323.99 | |||
| SO57016_1 | 5FA2-418F-AF | PO19227187256 | 19 | 284 | 234 | 210 | 6 | 2025-02-18 | 89.98 | 2.25 | 2025-02-06 | 3 | 38.49 | 1 | 89.98 | 1 | SO57016 | 2025-02-13 | 7.20 | 115.48 | 29.99 | |||
| SO53464_14 | E113-419B-8F | PO17545119283 | 19 | 291 | 545 | 155 | 6 | 2024-12-19 | 145.76 | 3.64 | 2024-12-07 | 6 | 17.98 | 1 | 145.76 | 14 | SO53464 | 2024-12-14 | 11.66 | 107.87 | 24.29 | |||
| SO46359_19 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 317 | 460 | 6 | 2023-09-19 | 5248.76 | 131.22 | 2023-09-07 | 6 | 884.71 | 1 | 5248.76 | 19 | SO46359 | 2023-09-14 | 419.90 | 5308.25 | 874.79 | |||
| SO47380_30 | EF71-4036-91 | PO14790123967 | 19 | 291 | 447 | 497 | 6 | 2023-12-20 | 45.00 | 1.13 | 2023-12-08 | 3 | 10.31 | 1 | 45.00 | 30 | SO47380 | 2023-12-15 | 3.60 | 30.94 | 15.00 | |||
| SO44750_5 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 345 | 678 | 6 | 2023-03-21 | 4079.99 | 102.00 | 2023-03-09 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO44750 | 2023-03-16 | 326.40 | 3824.31 | 2039.99 | |||
| SO45316_1 | E1CF-4A57-87 | PO2175190522 | 19 | 288 | 349 | 137 | 6 | 2023-05-22 | 2024.99 | 50.62 | 2023-05-10 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO45316 | 2023-05-17 | 162.00 | 1898.09 | 2024.99 | |||
| SO44526_11 | 9F1A-4CE0-93 | PO11020190357 | 19 | 284 | 262 | 336 | 6 | 2023-02-19 | 183.94 | 4.60 | 2023-02-07 | 1 | 181.49 | 1 | 183.94 | 11 | SO44526 | 2023-02-14 | 14.72 | 181.49 | 183.94 | |||
| SO43668_4 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 332 | 514 | 6 | 2022-10-19 | 2516.75 | 62.92 | 2022-10-07 | 6 | 413.15 | 1 | 2516.75 | 4 | SO43668 | 2022-10-14 | 201.34 | 2478.88 | 419.46 | |||
| SO44085_6 | D35C-4208-A3 | PO17545192039 | 19 | 288 | 262 | 155 | 6 | 2022-12-20 | 367.88 | 9.20 | 2022-12-08 | 2 | 181.49 | 1 | 367.88 | 6 | SO44085 | 2022-12-15 | 29.43 | 362.97 | 183.94 | |||
| SO58911_20 | C991-4920-91 | PO19401135315 | 19 | 291 | 546 | 173 | 6 | 2025-03-20 | 149.02 | 3.73 | 2025-03-08 | 4 | 27.57 | 1 | 149.02 | 20 | SO58911 | 2025-03-15 | 11.92 | 110.27 | 37.25 | |||
| SO69399_7 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 225 | 264 | 6 | 2025-08-19 | 32.36 | 0.81 | 2025-08-07 | 6 | 6.92 | 1 | 32.36 | 7 | SO69399 | 2025-08-14 | 2.59 | 41.53 | 5.39 | |||
| SO51818_26 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 542 | 100 | 6 | 2024-11-18 | 24.29 | 0.61 | 2024-11-06 | 1 | 17.98 | 1 | 24.29 | 26 | SO51818 | 2024-11-13 | 1.94 | 17.98 | 24.29 | |||
| SO48304_6 | C44F-4632-AD | PO17690111423 | 19 | 291 | 468 | 47 | 6 | 2024-03-20 | 68.38 | 1.71 | 2024-03-08 | 3 | 15.67 | 1 | 68.38 | 6 | SO48304 | 2024-03-15 | 5.47 | 47.01 | 22.79 | |||
| SO44547_15 | 801C-4288-87 | PO4901179982 | 19 | 284 | 326 | 84 | 6 | 2023-02-19 | 2097.29 | 52.43 | 2023-02-07 | 5 | 413.15 | 1 | 2097.29 | 15 | SO44547 | 2023-02-14 | 167.78 | 2065.73 | 419.46 | |||
| SO48338_1 | CF00-46C1-99 | PO11107115615 | 19 | 284 | 433 | 156 | 6 | 2024-03-20 | 648.91 | 16.22 | 2024-03-08 | 2 | 300.12 | 1 | 648.91 | 1 | SO48338 | 2024-03-15 | 51.91 | 600.24 | 324.45 | |||
| SO47366_44 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 254 | 155 | 6 | 2023-12-20 | 919.69 | 22.99 | 2023-12-08 | 5 | 170.14 | 1 | 919.69 | 44 | SO47366 | 2023-12-15 | 73.58 | 850.71 | 183.94 | |||
| SO71792_27 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 546 | 155 | 6 | 2025-09-19 | 186.27 | 4.66 | 2025-09-07 | 5 | 27.57 | 1 | 186.27 | 27 | SO71792 | 2025-09-14 | 14.90 | 137.84 | 37.25 | |||
| SO53463_10 | 39D5-46C9-80 | PO17690192070 | 19 | 291 | 491 | 47 | 6 | 2024-12-19 | 32.39 | 0.81 | 2024-12-07 | 1 | 41.57 | 1 | 32.39 | 10 | SO53463 | 2024-12-14 | 2.59 | 41.57 | 32.39 | |||
| SO47398_42 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 417 | 461 | 6 | 2023-12-20 | 324.45 | 8.11 | 2023-12-08 | 1 | 300.12 | 1 | 324.45 | 42 | SO47398 | 2023-12-15 | 25.96 | 300.12 | 324.45 | |||
| SO49484_37 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 428 | 118 | 6 | 2024-06-18 | 209.26 | 5.23 | 2024-06-06 | 1 | 185.82 | 1 | 209.26 | 37 | SO49484 | 2024-06-13 | 16.74 | 185.82 | 209.26 | |||
| SO47008_13 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 329 | 426 | 6 | 2023-11-19 | 1879.18 | 46.98 | 2023-11-07 | 4 | 486.71 | 1 | 1879.18 | 13 | SO47008 | 2023-11-14 | 150.33 | 1946.83 | 469.79 | |||
| SO44750_10 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 346 | 678 | 6 | 2023-03-21 | 8159.98 | 204.00 | 2023-03-09 | 4 | 1912.15 | 1 | 8159.98 | 10 | SO44750 | 2023-03-16 | 652.80 | 7648.62 | 2039.99 | |||
| SO49501_13 | EF67-4713-BD | PO17574111786 | 19 | 291 | 460 | 678 | 6 | 2024-06-18 | 107.99 | 2.70 | 2024-06-06 | 2 | 37.12 | 1 | 107.99 | 13 | SO49501 | 2024-06-13 | 8.64 | 74.24 | 53.99 | |||
| SO51116_16 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 488 | 480 | 6 | 2024-10-18 | 32.39 | 0.81 | 2024-10-06 | 1 | 41.57 | 1 | 32.39 | 16 | SO51116 | 2024-10-13 | 2.59 | 41.57 | 32.39 | |||
| SO48059_30 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 236 | 84 | 6 | 2024-02-19 | 201.88 | 5.05 | 2024-02-07 | 7 | 29.08 | 1 | 201.88 | 30 | SO48059 | 2024-02-14 | 16.15 | 203.56 | 28.84 | |||
| SO45057_16 | 568E-472E-9C | PO11049133413 | 19 | 284 | 318 | 679 | 6 | 2023-04-21 | 1749.59 | 43.74 | 2023-04-09 | 2 | 884.71 | 1 | 1749.59 | 16 | SO45057 | 2023-04-16 | 139.97 | 1769.42 | 874.79 | |||
| SO55275_8 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 527 | 245 | 6 | 2025-01-18 | 633.72 | 15.84 | 2025-01-06 | 4 | 144.59 | 1 | 633.72 | 8 | SO55275 | 2025-01-13 | 50.70 | 578.38 | 158.43 | |||
| SO48778_18 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 364 | 496 | 6 | 2024-04-20 | 1295.99 | 32.40 | 2024-04-08 | 2 | 598.44 | 1 | 1295.99 | 18 | SO48778 | 2024-04-15 | 103.68 | 1196.87 | 647.99 | |||
| SO50689_37 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 387 | 461 | 6 | 2024-09-18 | 1200.53 | 30.01 | 2024-09-06 | 2 | 605.65 | 1 | 1200.53 | 37 | SO50689 | 2024-09-13 | 96.04 | 1211.30 | 600.26 | |||
| SO51096_1 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 440 | 514 | 6 | 2024-10-18 | 2576.70 | 64.42 | 2024-10-06 | 3 | 868.63 | 1 | 2576.70 | 1 | SO51096 | 2024-10-13 | 206.14 | 2605.90 | 858.90 |
Generated 2025-11-06 11:06:58.670 UTC