[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 1000 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44535_10 | 26EF-4A69-B0 | PO2088169831 | 19 | 288 | 316 | 136 | 6 | 2023-02-13 | 1749.59 | 43.74 | 2023-02-01 | 2 | 884.71 | 1 | 1749.59 | 10 | SO44535 | 2023-02-08 | 139.97 | 1769.42 | 874.79 | |||
| SO69432_3 | A640-45AE-A5 | PO12789195722 | 19 | 291 | 474 | 677 | 6 | 2025-08-13 | 125.98 | 3.15 | 2025-08-01 | 3 | 26.18 | 1 | 125.98 | 3 | SO69432 | 2025-08-08 | 10.08 | 78.53 | 41.99 | |||
| SO50200_10 | C47A-4C44-97 | PO17806151620 | 19 | 291 | 433 | 101 | 6 | 2024-08-12 | 648.91 | 16.22 | 2024-07-31 | 2 | 300.12 | 1 | 648.91 | 10 | SO50200 | 2024-08-07 | 51.91 | 600.24 | 324.45 | |||
| SO48287_1 | 7A9E-45FF-8B | PO493197818 | 19 | 291 | 415 | 654 | 6 | 2024-03-14 | 198.04 | 4.95 | 2024-03-02 | 1 | 146.55 | 1 | 198.04 | 1 | SO48287 | 2024-03-09 | 15.84 | 146.55 | 198.04 | |||
| SO48053_9 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 453 | 352 | 6 | 2024-02-13 | 215.96 | 5.40 | 2024-02-01 | 6 | 24.75 | 1 | 215.96 | 9 | SO48053 | 2024-02-08 | 17.28 | 148.48 | 35.99 | |||
| SO46951_12 | 6998-44C0-A4 | PO17748125133 | 19 | 284 | 280 | 102 | 6 | 2023-11-13 | 735.75 | 18.39 | 2023-11-01 | 4 | 170.14 | 1 | 735.75 | 12 | SO46951 | 2023-11-08 | 58.86 | 680.57 | 183.94 | |||
| SO48754_20 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 420 | 442 | 6 | 2024-04-14 | 708.08 | 17.70 | 2024-04-02 | 5 | 104.80 | 1 | 708.08 | 20 | SO48754 | 2024-04-09 | 56.65 | 523.98 | 141.62 | |||
| SO47383_9 | C260-48F6-A0 | PO14239114721 | 19 | 291 | 216 | 550 | 6 | 2023-12-14 | 20.19 | 0.50 | 2023-12-02 | 1 | 13.88 | 1 | 20.19 | 9 | SO47383 | 2023-12-09 | 1.61 | 13.88 | 20.19 | |||
| SO46639_11 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 458 | 2 | 480 | 6 | 9.57 | 2023-10-13 | 478.44 | 11.72 | 2023-10-01 | 11 | 30.93 | 1 | 468.87 | 11 | SO46639 | 2023-10-08 | 37.51 | 340.27 | 43.49 | 0.02 |
| SO47008_20 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 429 | 426 | 6 | 2023-11-13 | 324.45 | 8.11 | 2023-11-01 | 1 | 300.12 | 1 | 324.45 | 20 | SO47008 | 2023-11-08 | 25.96 | 300.12 | 324.45 | |||
| SO48299_4 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 391 | 118 | 6 | 2024-03-14 | 266.80 | 6.67 | 2024-03-02 | 3 | 65.81 | 1 | 266.80 | 4 | SO48299 | 2024-03-09 | 21.34 | 197.43 | 88.93 | |||
| SO57093_4 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 384 | 479 | 6 | 2025-02-12 | 3361.47 | 84.04 | 2025-01-31 | 5 | 713.08 | 1 | 3361.47 | 4 | SO57093 | 2025-02-07 | 268.92 | 3565.40 | 672.29 | |||
| SO69401_25 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 471 | 3 | 12 | 6 | 26.19 | 2025-08-13 | 523.88 | 12.44 | 2025-08-01 | 15 | 23.75 | 1 | 497.68 | 25 | SO69401 | 2025-08-08 | 39.81 | 356.24 | 34.93 | 0.05 |
| SO63239_13 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 237 | 84 | 6 | 2025-05-15 | 59.99 | 1.50 | 2025-05-03 | 2 | 38.49 | 1 | 59.99 | 13 | SO63239 | 2025-05-10 | 4.80 | 76.98 | 29.99 | |||
| SO50676_4 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 468 | 497 | 6 | 2024-09-12 | 22.79 | 0.57 | 2024-08-31 | 1 | 15.67 | 1 | 22.79 | 4 | SO50676 | 2024-09-07 | 1.82 | 15.67 | 22.79 | |||
| SO46940_13 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 377 | 479 | 6 | 2023-11-13 | 2617.88 | 65.45 | 2023-11-01 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO46940 | 2023-11-08 | 209.43 | 2641.37 | 1308.94 | |||
| SO49860_11 | DB5C-4441-BE | PO13862128354 | 19 | 291 | 401 | 119 | 6 | 2024-07-13 | 131.20 | 3.28 | 2024-07-01 | 2 | 48.55 | 1 | 131.20 | 11 | SO49860 | 2024-07-08 | 10.50 | 97.09 | 65.60 | |||
| SO67268_27 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 217 | 299 | 6 | 2025-07-14 | 167.95 | 4.20 | 2025-07-02 | 8 | 13.09 | 1 | 167.95 | 27 | SO67268 | 2025-07-09 | 13.44 | 104.69 | 20.99 | |||
| SO47398_24 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 273 | 461 | 6 | 2023-12-14 | 404.66 | 10.12 | 2023-12-02 | 2 | 187.16 | 1 | 404.66 | 24 | SO47398 | 2023-12-09 | 32.37 | 374.31 | 202.33 | |||
| SO51839_12 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 465 | 84 | 6 | 2024-11-12 | 117.55 | 2.94 | 2024-10-31 | 8 | 9.16 | 1 | 117.55 | 12 | SO51839 | 2024-11-07 | 9.40 | 73.27 | 14.69 | |||
| SO49100_8 | BD42-4470-A8 | PO17603154869 | 19 | 284 | 213 | 12 | 6 | 2024-05-15 | 60.56 | 1.51 | 2024-05-03 | 3 | 13.88 | 1 | 60.56 | 8 | SO49100 | 2024-05-10 | 4.84 | 41.63 | 20.19 | |||
| SO46351_2 | 9218-4521-8F | PO11107115959 | 19 | 284 | 319 | 156 | 6 | 2023-09-13 | 874.79 | 21.87 | 2023-09-01 | 1 | 884.71 | 1 | 874.79 | 2 | SO46351 | 2023-09-08 | 69.98 | 884.71 | 874.79 | |||
| SO51727_1 | F66A-4E49-8E | PO14848190887 | 19 | 291 | 240 | 478 | 6 | 2024-11-12 | 858.90 | 21.47 | 2024-10-31 | 1 | 868.63 | 1 | 858.90 | 1 | SO51727 | 2024-11-07 | 68.71 | 868.63 | 858.90 | |||
| SO69520_41 | 654B-484B-8F | PO4466144794 | 19 | 291 | 225 | 352 | 6 | 2025-08-13 | 37.76 | 0.94 | 2025-08-01 | 7 | 6.92 | 1 | 37.76 | 41 | SO69520 | 2025-08-08 | 3.02 | 48.46 | 5.39 | |||
| SO65189_14 | 985E-4937-94 | PO14761195376 | 19 | 284 | 574 | 408 | 6 | 2025-06-13 | 2860.88 | 71.52 | 2025-06-01 | 2 | 1481.94 | 1 | 2860.88 | 14 | SO65189 | 2025-06-08 | 228.87 | 2963.88 | 1430.44 | |||
| SO45057_11 | 568E-472E-9C | PO11049133413 | 19 | 284 | 223 | 679 | 6 | 2023-04-15 | 15.56 | 0.39 | 2023-04-03 | 3 | 5.71 | 1 | 15.56 | 11 | SO45057 | 2023-04-10 | 1.24 | 17.12 | 5.19 | |||
| SO55297_36 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 556 | 496 | 6 | 2025-01-12 | 421.18 | 10.53 | 2024-12-31 | 4 | 77.92 | 1 | 421.18 | 36 | SO55297 | 2025-01-07 | 33.69 | 311.67 | 105.29 | |||
| SO47413_14 | E274-4280-9B | PO1885161774 | 19 | 284 | 233 | 588 | 6 | 2023-12-14 | 201.88 | 5.05 | 2023-12-02 | 7 | 29.08 | 1 | 201.88 | 14 | SO47413 | 2023-12-09 | 16.15 | 203.56 | 28.84 | |||
| SO44077_2 | D160-4713-81 | PO19401178507 | 19 | 288 | 342 | 173 | 6 | 2022-12-14 | 838.92 | 20.97 | 2022-12-02 | 2 | 413.15 | 1 | 838.92 | 2 | SO44077 | 2022-12-09 | 67.11 | 826.29 | 419.46 | |||
| SO71794_20 | C39A-4835-99 | PO17574111985 | 19 | 291 | 488 | 678 | 6 | 2025-09-13 | 161.97 | 4.05 | 2025-09-01 | 5 | 41.57 | 1 | 161.97 | 20 | SO71794 | 2025-09-08 | 12.96 | 207.86 | 32.39 | |||
| SO58918_24 | C811-4D40-80 | PO17574131484 | 19 | 291 | 543 | 678 | 6 | 2025-03-14 | 149.02 | 3.73 | 2025-03-02 | 4 | 27.57 | 1 | 149.02 | 24 | SO58918 | 2025-03-09 | 11.92 | 110.27 | 37.25 | |||
| SO44747_7 | 0914-46F6-9D | PO17719150324 | 19 | 284 | 322 | 631 | 6 | 2023-03-15 | 419.46 | 10.49 | 2023-03-03 | 1 | 413.15 | 1 | 419.46 | 7 | SO44747 | 2023-03-10 | 33.56 | 413.15 | 419.46 | |||
| SO65174_31 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 511 | 678 | 6 | 2025-06-13 | 218.45 | 5.46 | 2025-06-01 | 1 | 199.38 | 1 | 218.45 | 31 | SO65174 | 2025-06-08 | 17.48 | 199.38 | 218.45 | |||
| SO71792_18 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 388 | 155 | 6 | 2025-09-13 | 2016.88 | 50.42 | 2025-09-01 | 3 | 713.08 | 1 | 2016.88 | 18 | SO71792 | 2025-09-08 | 161.35 | 2139.24 | 672.29 | |||
| SO58925_4 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 572 | 282 | 6 | 2025-03-14 | 890.82 | 22.27 | 2025-03-02 | 2 | 461.44 | 1 | 890.82 | 4 | SO58925 | 2025-03-09 | 71.27 | 922.89 | 445.41 | |||
| SO49828_21 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 381 | 514 | 6 | 2024-07-13 | 3001.31 | 75.03 | 2024-07-01 | 5 | 605.65 | 1 | 3001.31 | 21 | SO49828 | 2024-07-08 | 240.11 | 3028.25 | 600.26 | |||
| SO57024_31 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 477 | 264 | 6 | 2025-02-12 | 11.98 | 0.30 | 2025-01-31 | 4 | 1.87 | 1 | 11.98 | 31 | SO57024 | 2025-02-07 | 0.96 | 7.47 | 2.99 | |||
| SO47359_32 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 396 | 118 | 6 | 2023-12-14 | 149.68 | 3.74 | 2023-12-02 | 2 | 55.38 | 1 | 149.68 | 32 | SO47359 | 2023-12-09 | 11.97 | 110.76 | 74.84 | |||
| SO47365_54 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 460 | 678 | 6 | 2023-12-14 | 431.95 | 10.80 | 2023-12-02 | 8 | 37.12 | 1 | 431.95 | 54 | SO47365 | 2023-12-09 | 34.56 | 296.97 | 53.99 | |||
| SO58932_38 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 565 | 408 | 6 | 2025-03-14 | 445.41 | 11.14 | 2025-03-02 | 1 | 461.44 | 1 | 445.41 | 38 | SO58932 | 2025-03-09 | 35.63 | 461.44 | 445.41 | |||
| SO51791_27 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 583 | 552 | 6 | 2024-11-12 | 1020.59 | 25.51 | 2024-10-31 | 1 | 1082.51 | 1 | 1020.59 | 27 | SO51791 | 2024-11-07 | 81.65 | 1082.51 | 1020.59 | |||
| SO47662_41 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 213 | 442 | 6 | 2024-01-13 | 20.19 | 0.50 | 2024-01-01 | 1 | 13.88 | 1 | 20.19 | 41 | SO47662 | 2024-01-08 | 1.61 | 13.88 | 20.19 | |||
| SO45522_14 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 318 | 173 | 6 | 2023-06-13 | 4373.97 | 109.35 | 2023-06-01 | 5 | 884.71 | 1 | 4373.97 | 14 | SO45522 | 2023-06-08 | 349.92 | 4423.54 | 874.79 | |||
| SO50666_2 | 1380-41E5-A4 | PO17951169852 | 19 | 284 | 460 | 637 | 6 | 2024-09-12 | 53.99 | 1.35 | 2024-08-31 | 1 | 37.12 | 1 | 53.99 | 2 | SO50666 | 2024-09-07 | 4.32 | 37.12 | 53.99 | |||
| SO45323_23 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 317 | 84 | 6 | 2023-05-16 | 2624.38 | 65.61 | 2023-05-04 | 3 | 884.71 | 1 | 2624.38 | 23 | SO45323 | 2023-05-11 | 209.95 | 2654.12 | 874.79 | |||
| SO46086_24 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 334 | 84 | 6 | 2023-08-13 | 419.46 | 10.49 | 2023-08-01 | 1 | 413.15 | 1 | 419.46 | 24 | SO46086 | 2023-08-08 | 33.56 | 413.15 | 419.46 | |||
| SO69446_3 | E9F7-4369-85 | PO10498138449 | 19 | 291 | 474 | 316 | 6 | 2025-08-13 | 251.96 | 6.30 | 2025-08-01 | 6 | 26.18 | 1 | 251.96 | 3 | SO69446 | 2025-08-08 | 20.16 | 157.06 | 41.99 | |||
| SO48764_22 | B2E5-4B83-BC | PO18444188685 | 19 | 291 | 327 | 227 | 6 | 2024-04-14 | 3758.35 | 93.96 | 2024-04-02 | 8 | 486.71 | 1 | 3758.35 | 22 | SO48764 | 2024-04-09 | 300.67 | 3893.65 | 469.79 | |||
| SO49140_3 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 263 | 84 | 6 | 2024-05-15 | 404.66 | 10.12 | 2024-05-03 | 2 | 187.16 | 1 | 404.66 | 3 | SO49140 | 2024-05-10 | 32.37 | 374.31 | 202.33 | |||
| SO47709_4 | C56A-4A93-90 | PO4930142687 | 19 | 291 | 456 | 425 | 6 | 2024-01-13 | 134.98 | 3.37 | 2024-01-01 | 3 | 30.93 | 1 | 134.98 | 4 | SO47709 | 2024-01-08 | 10.80 | 92.80 | 44.99 | |||
| SO50204_34 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 453 | 533 | 6 | 2024-08-12 | 179.97 | 4.50 | 2024-07-31 | 5 | 24.75 | 1 | 179.97 | 34 | SO50204 | 2024-08-07 | 14.40 | 123.73 | 35.99 | |||
| SO71829_3 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 589 | 685 | 6 | 2025-09-13 | 923.39 | 23.08 | 2025-09-01 | 2 | 419.78 | 1 | 923.39 | 3 | SO71829 | 2025-09-08 | 73.87 | 839.56 | 461.69 | |||
| SO58972_46 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 298 | 10 | 6 | 2025-03-14 | 3239.04 | 80.98 | 2025-03-02 | 4 | 739.04 | 1 | 3239.04 | 46 | SO58972 | 2025-03-09 | 259.12 | 2956.16 | 809.76 | |||
| SO63140_15 | 0582-4EB7-B7 | PO17661112720 | 19 | 284 | 483 | 264 | 6 | 2025-05-15 | 288.00 | 7.20 | 2025-05-03 | 4 | 44.88 | 1 | 288.00 | 15 | SO63140 | 2025-05-10 | 23.04 | 179.52 | 72.00 | |||
| SO51740_13 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 477 | 677 | 6 | 2024-11-12 | 17.96 | 0.45 | 2024-10-31 | 6 | 1.87 | 1 | 17.96 | 13 | SO51740 | 2024-11-07 | 1.44 | 11.20 | 2.99 | |||
| SO48340_11 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 362 | 685 | 6 | 2024-03-14 | 1229.46 | 30.74 | 2024-03-02 | 1 | 1105.81 | 1 | 1229.46 | 11 | SO48340 | 2024-03-09 | 98.36 | 1105.81 | 1229.46 | |||
| SO44526_9 | 9F1A-4CE0-93 | PO11020190357 | 19 | 284 | 315 | 336 | 6 | 2023-02-13 | 4373.97 | 109.35 | 2023-02-01 | 5 | 884.71 | 1 | 4373.97 | 9 | SO44526 | 2023-02-08 | 349.92 | 4423.54 | 874.79 | |||
| SO67316_54 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 555 | 496 | 6 | 2025-07-14 | 255.60 | 6.39 | 2025-07-02 | 4 | 47.29 | 1 | 255.60 | 54 | SO67316 | 2025-07-09 | 20.45 | 189.14 | 63.90 | |||
| SO63140_20 | 0582-4EB7-B7 | PO17661112720 | 19 | 284 | 477 | 264 | 6 | 2025-05-15 | 8.98 | 0.22 | 2025-05-03 | 3 | 1.87 | 1 | 8.98 | 20 | SO63140 | 2025-05-10 | 0.72 | 5.60 | 2.99 | |||
| SO46072_13 | 0D05-4D9C-87 | PO2146167606 | 19 | 284 | 218 | 354 | 6 | 2023-08-13 | 11.40 | 0.29 | 2023-08-01 | 2 | 3.40 | 1 | 11.40 | 13 | SO46072 | 2023-08-08 | 0.91 | 6.79 | 5.70 | |||
| SO67272_1 | F467-41BF-8B | PO13862111340 | 19 | 291 | 309 | 119 | 6 | 2025-07-14 | 1637.40 | 40.94 | 2025-07-02 | 2 | 747.20 | 1 | 1637.40 | 1 | SO67272 | 2025-07-09 | 130.99 | 1494.40 | 818.70 | |||
| SO51850_35 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 554 | 263 | 6 | 2024-11-12 | 54.94 | 1.37 | 2024-10-31 | 1 | 40.66 | 1 | 54.94 | 35 | SO51850 | 2024-11-07 | 4.40 | 40.66 | 54.94 |
Generated 2025-11-01 00:19:27.659 UTC