[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 3031 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO55275_15 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 476 | 2 | 245 | 6 | 11.37 | 2025-01-16 | 568.32 | 13.92 | 2025-01-04 | 14 | 26.18 | 1 | 556.95 | 15 | SO55275 | 2025-01-11 | 44.56 | 366.47 | 40.59 | 0.02 |
| SO47354_41 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 333 | 173 | 6 | 2023-12-18 | 469.79 | 11.74 | 2023-12-06 | 1 | 486.71 | 1 | 469.79 | 41 | SO47354 | 2023-12-13 | 37.58 | 486.71 | 469.79 | |||
| SO45522_3 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 322 | 173 | 6 | 2023-06-17 | 1258.38 | 31.46 | 2023-06-05 | 3 | 413.15 | 1 | 1258.38 | 3 | SO45522 | 2023-06-12 | 100.67 | 1239.44 | 419.46 | |||
| SO43880_9 | 3269-4442-87 | PO11020127453 | 19 | 284 | 317 | 336 | 6 | 2022-11-17 | 1749.59 | 43.74 | 2022-11-05 | 2 | 884.71 | 1 | 1749.59 | 9 | SO43880 | 2022-11-12 | 139.97 | 1769.42 | 874.79 | |||
| SO71842_1 | D220-4EE6-B8 | PO1740169151 | 19 | 291 | 482 | 460 | 6 | 2025-09-17 | 10.79 | 0.27 | 2025-09-05 | 2 | 3.36 | 1 | 10.79 | 1 | SO71842 | 2025-09-12 | 0.86 | 6.72 | 5.39 | |||
| SO61179_15 | 1443-4268-AC | PO18444157069 | 19 | 291 | 583 | 227 | 6 | 2025-04-18 | 5102.97 | 127.57 | 2025-04-06 | 5 | 1082.51 | 1 | 5102.97 | 15 | SO61179 | 2025-04-13 | 408.24 | 5412.55 | 1020.59 | |||
| SO43857_2 | 0CD4-4091-9B | PO16733124458 | 19 | 288 | 332 | 533 | 6 | 2022-11-17 | 419.46 | 10.49 | 2022-11-05 | 1 | 413.15 | 1 | 419.46 | 2 | SO43857 | 2022-11-12 | 33.56 | 413.15 | 419.46 | |||
| SO44288_9 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 232 | 514 | 6 | 2023-01-17 | 115.36 | 2.88 | 2023-01-05 | 4 | 31.72 | 1 | 115.36 | 9 | SO44288 | 2023-01-12 | 9.23 | 126.90 | 28.84 | |||
| SO47663_16 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 239 | 227 | 6 | 2024-01-17 | 3123.27 | 78.08 | 2024-01-05 | 4 | 722.26 | 1 | 3123.27 | 16 | SO47663 | 2024-01-12 | 249.86 | 2889.03 | 780.82 | |||
| SO65174_47 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 491 | 678 | 6 | 2025-06-17 | 323.94 | 8.10 | 2025-06-05 | 10 | 41.57 | 1 | 323.94 | 47 | SO65174 | 2025-06-12 | 25.92 | 415.72 | 32.39 | |||
| SO46639_5 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 213 | 8 | 480 | 6 | 6.73 | 2023-10-17 | 67.29 | 1.51 | 2023-10-05 | 4 | 13.88 | 1 | 60.56 | 5 | SO46639 | 2023-10-12 | 4.84 | 55.51 | 16.82 | 0.10 |
| SO65164_16 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 517 | 118 | 6 | 2025-06-17 | 31.58 | 0.79 | 2025-06-05 | 1 | 23.37 | 1 | 31.58 | 16 | SO65164 | 2025-06-12 | 2.53 | 23.37 | 31.58 | |||
| SO47031_14 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 470 | 3 | 352 | 6 | 17.76 | 2023-11-17 | 355.21 | 8.44 | 2023-11-05 | 17 | 15.67 | 1 | 337.45 | 14 | SO47031 | 2023-11-12 | 27.00 | 266.41 | 20.89 | 0.05 |
| SO45284_6 | 57F0-404F-97 | PO16733112744 | 19 | 288 | 319 | 533 | 6 | 2023-05-20 | 874.79 | 21.87 | 2023-05-08 | 1 | 884.71 | 1 | 874.79 | 6 | SO45284 | 2023-05-15 | 69.98 | 884.71 | 874.79 | |||
| SO47670_22 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 435 | 514 | 6 | 2024-01-17 | 973.36 | 24.33 | 2024-01-05 | 3 | 300.12 | 1 | 973.36 | 22 | SO47670 | 2024-01-12 | 77.87 | 900.36 | 324.45 | |||
| SO71829_25 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 474 | 685 | 6 | 2025-09-17 | 293.96 | 7.35 | 2025-09-05 | 7 | 26.18 | 1 | 293.96 | 25 | SO71829 | 2025-09-12 | 23.52 | 183.23 | 41.99 | |||
| SO58957_21 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 400 | 685 | 6 | 2025-03-18 | 37.15 | 0.93 | 2025-03-06 | 1 | 27.49 | 1 | 37.15 | 21 | SO58957 | 2025-03-13 | 2.97 | 27.49 | 37.15 | |||
| SO63266_6 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 471 | 352 | 6 | 2025-05-19 | 304.80 | 7.62 | 2025-05-07 | 8 | 23.75 | 1 | 304.80 | 6 | SO63266 | 2025-05-14 | 24.38 | 189.99 | 38.10 | |||
| SO69479_6 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 390 | 552 | 6 | 2025-08-17 | 672.29 | 16.81 | 2025-08-05 | 1 | 713.08 | 1 | 672.29 | 6 | SO69479 | 2025-08-12 | 53.78 | 713.08 | 672.29 | |||
| SO67304_11 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 434 | 227 | 6 | 2025-07-18 | 2141.39 | 53.53 | 2025-07-06 | 6 | 360.94 | 1 | 2141.39 | 11 | SO67304 | 2025-07-13 | 171.31 | 2165.66 | 356.90 | |||
| SO44533_15 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 212 | 317 | 6 | 2023-02-17 | 20.19 | 0.50 | 2023-02-05 | 1 | 12.03 | 1 | 20.19 | 15 | SO44533 | 2023-02-12 | 1.61 | 12.03 | 20.19 | |||
| SO45781_14 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 241 | 227 | 6 | 2023-07-18 | 2274.23 | 56.86 | 2023-07-06 | 3 | 747.97 | 1 | 2274.23 | 14 | SO45781 | 2023-07-13 | 181.94 | 2243.90 | 758.08 | |||
| SO69560_1 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 542 | 100 | 6 | 2025-08-17 | 24.29 | 0.61 | 2025-08-05 | 1 | 17.98 | 1 | 24.29 | 1 | SO69560 | 2025-08-12 | 1.94 | 17.98 | 24.29 | |||
| SO49828_43 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 389 | 514 | 6 | 2024-07-17 | 1800.79 | 45.02 | 2024-07-05 | 3 | 605.65 | 1 | 1800.79 | 43 | SO49828 | 2024-07-12 | 144.06 | 1816.95 | 600.26 | |||
| SO45527_23 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 320 | 155 | 6 | 2023-06-17 | 2516.75 | 62.92 | 2023-06-05 | 6 | 413.15 | 1 | 2516.75 | 23 | SO45527 | 2023-06-12 | 201.34 | 2478.88 | 419.46 | |||
| SO71830_25 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 565 | 281 | 6 | 2025-09-17 | 1781.64 | 44.54 | 2025-09-05 | 4 | 461.44 | 1 | 1781.64 | 25 | SO71830 | 2025-09-12 | 142.53 | 1845.78 | 445.41 | |||
| SO53600_7 | 8E02-463C-A5 | PO2233133950 | 19 | 291 | 491 | 262 | 6 | 2024-12-17 | 129.58 | 3.24 | 2024-12-05 | 4 | 41.57 | 1 | 129.58 | 7 | SO53600 | 2024-12-12 | 10.37 | 166.29 | 32.39 | |||
| SO65156_9 | 3295-4FC6-BC | PO19401176373 | 19 | 291 | 584 | 173 | 6 | 2025-06-17 | 323.99 | 8.10 | 2025-06-05 | 1 | 343.65 | 1 | 323.99 | 9 | SO65156 | 2025-06-12 | 25.92 | 343.65 | 323.99 | |||
| SO49085_11 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 420 | 653 | 6 | 2024-05-19 | 141.62 | 3.54 | 2024-05-07 | 1 | 104.80 | 1 | 141.62 | 11 | SO49085 | 2024-05-14 | 11.33 | 104.80 | 141.62 | |||
| SO57070_5 | A915-448D-82 | PO11020121552 | 19 | 284 | 436 | 336 | 6 | 2025-02-16 | 356.90 | 8.92 | 2025-02-04 | 1 | 360.94 | 1 | 356.90 | 5 | SO57070 | 2025-02-11 | 28.55 | 360.94 | 356.90 | |||
| SO69479_35 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 583 | 552 | 6 | 2025-08-17 | 1020.59 | 25.51 | 2025-08-05 | 1 | 1082.51 | 1 | 1020.59 | 35 | SO69479 | 2025-08-12 | 81.65 | 1082.51 | 1020.59 | |||
| SO47663_20 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 325 | 227 | 6 | 2024-01-17 | 4228.15 | 105.70 | 2024-01-05 | 9 | 486.71 | 1 | 4228.15 | 20 | SO47663 | 2024-01-12 | 338.25 | 4380.36 | 469.79 | |||
| SO46351_6 | 9218-4521-8F | PO11107115959 | 19 | 284 | 342 | 156 | 6 | 2023-09-17 | 419.46 | 10.49 | 2023-09-05 | 1 | 413.15 | 1 | 419.46 | 6 | SO46351 | 2023-09-12 | 33.56 | 413.15 | 419.46 | |||
| SO46359_1 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 262 | 460 | 6 | 2023-09-17 | 183.94 | 4.60 | 2023-09-05 | 1 | 181.49 | 1 | 183.94 | 1 | SO46359 | 2023-09-12 | 14.72 | 181.49 | 183.94 | |||
| SO46639_14 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 415 | 480 | 6 | 2023-10-17 | 198.04 | 4.95 | 2023-10-05 | 1 | 146.55 | 1 | 198.04 | 14 | SO46639 | 2023-10-12 | 15.84 | 146.55 | 198.04 | |||
| SO50284_47 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 327 | 84 | 6 | 2024-08-16 | 1409.38 | 35.23 | 2024-08-04 | 3 | 486.71 | 1 | 1409.38 | 47 | SO50284 | 2024-08-11 | 112.75 | 1460.12 | 469.79 | |||
| SO53464_30 | E113-419B-8F | PO17545119283 | 19 | 291 | 376 | 155 | 6 | 2024-12-17 | 2932.02 | 73.30 | 2024-12-05 | 2 | 1554.95 | 1 | 2932.02 | 30 | SO53464 | 2024-12-12 | 234.56 | 3109.90 | 1466.01 | |||
| SO69446_3 | E9F7-4369-85 | PO10498138449 | 19 | 291 | 474 | 316 | 6 | 2025-08-17 | 251.96 | 6.30 | 2025-08-05 | 6 | 26.18 | 1 | 251.96 | 3 | SO69446 | 2025-08-12 | 20.16 | 157.06 | 41.99 | |||
| SO47415_11 | 4C47-41C8-B0 | PO2233131382 | 19 | 291 | 213 | 262 | 6 | 2023-12-18 | 40.37 | 1.01 | 2023-12-06 | 2 | 13.88 | 1 | 40.37 | 11 | SO47415 | 2023-12-13 | 3.23 | 27.76 | 20.19 | |||
| SO44111_11 | CFDA-475D-95 | PO1740120267 | 19 | 288 | 223 | 460 | 6 | 2022-12-18 | 31.12 | 0.78 | 2022-12-06 | 6 | 5.71 | 1 | 31.12 | 11 | SO44111 | 2022-12-13 | 2.49 | 34.23 | 5.19 | |||
| SO51703_11 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 471 | 12 | 6 | 2024-11-16 | 304.80 | 7.62 | 2024-11-04 | 8 | 23.75 | 1 | 304.80 | 11 | SO51703 | 2024-11-11 | 24.38 | 189.99 | 38.10 | |||
| SO48768_13 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 399 | 119 | 6 | 2024-04-18 | 33.77 | 0.84 | 2024-04-06 | 1 | 24.99 | 1 | 33.77 | 13 | SO48768 | 2024-04-13 | 2.70 | 24.99 | 33.77 | |||
| SO57023_3 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 547 | 12 | 6 | 2025-02-16 | 242.97 | 6.07 | 2025-02-04 | 5 | 35.96 | 1 | 242.97 | 3 | SO57023 | 2025-02-11 | 19.44 | 179.80 | 48.59 | |||
| SO43855_6 | FB88-4B92-82 | PO17748116016 | 19 | 284 | 326 | 102 | 6 | 2022-11-17 | 1258.38 | 31.46 | 2022-11-05 | 3 | 413.15 | 1 | 1258.38 | 6 | SO43855 | 2022-11-12 | 100.67 | 1239.44 | 419.46 | |||
| SO67302_27 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 357 | 442 | 6 | 2025-07-18 | 1391.99 | 34.80 | 2025-07-06 | 1 | 1265.62 | 1 | 1391.99 | 27 | SO67302 | 2025-07-13 | 111.36 | 1265.62 | 1391.99 | |||
| SO47398_53 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 337 | 461 | 6 | 2023-12-18 | 1409.38 | 35.23 | 2023-12-06 | 3 | 486.71 | 1 | 1409.38 | 53 | SO47398 | 2023-12-13 | 112.75 | 1460.12 | 469.79 | |||
| SO57122_16 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 605 | 84 | 6 | 2025-02-16 | 1295.98 | 32.40 | 2025-02-04 | 4 | 343.65 | 1 | 1295.98 | 16 | SO57122 | 2025-02-11 | 103.68 | 1374.60 | 323.99 | |||
| SO46951_11 | 6998-44C0-A4 | PO17748125133 | 19 | 284 | 407 | 102 | 6 | 2023-11-17 | 196.81 | 4.92 | 2023-11-05 | 3 | 48.55 | 1 | 196.81 | 11 | SO46951 | 2023-11-12 | 15.74 | 145.64 | 65.60 | |||
| SO65206_28 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 591 | 10 | 6 | 2025-06-17 | 1355.98 | 33.90 | 2025-06-05 | 4 | 308.22 | 1 | 1355.98 | 28 | SO65206 | 2025-06-12 | 108.48 | 1232.87 | 338.99 | |||
| SO53536_37 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 588 | 118 | 6 | 2024-12-17 | 461.69 | 11.54 | 2024-12-05 | 1 | 419.78 | 1 | 461.69 | 37 | SO53536 | 2024-12-12 | 36.94 | 419.78 | 461.69 | |||
| SO45780_7 | 1E49-4721-BA | PO18473162015 | 19 | 288 | 299 | 442 | 6 | 2023-07-18 | 809.76 | 20.24 | 2023-07-06 | 1 | 699.09 | 1 | 809.76 | 7 | SO45780 | 2023-07-13 | 64.78 | 699.09 | 809.76 | |||
| SO44081_2 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 232 | 118 | 6 | 2022-12-18 | 57.68 | 1.44 | 2022-12-06 | 2 | 31.72 | 1 | 57.68 | 2 | SO44081 | 2022-12-13 | 4.61 | 63.45 | 28.84 | |||
| SO55297_3 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 467 | 496 | 6 | 2025-01-16 | 73.47 | 1.84 | 2025-01-04 | 5 | 9.16 | 1 | 73.47 | 3 | SO55297 | 2025-01-11 | 5.88 | 45.80 | 14.69 | |||
| SO69540_39 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 225 | 263 | 6 | 2025-08-17 | 43.15 | 1.08 | 2025-08-05 | 8 | 6.92 | 1 | 43.15 | 39 | SO69540 | 2025-08-12 | 3.45 | 55.38 | 5.39 | |||
| SO58929_1 | 6B54-416D-AC | PO14906166345 | 19 | 291 | 531 | 424 | 6 | 2025-03-18 | 449.62 | 11.24 | 2025-03-06 | 3 | 136.79 | 1 | 449.62 | 1 | SO58929 | 2025-03-13 | 35.97 | 410.36 | 149.87 | |||
| SO46936_18 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 414 | 210 | 6 | 2023-11-17 | 149.03 | 3.73 | 2023-11-05 | 1 | 110.28 | 1 | 149.03 | 18 | SO46936 | 2023-11-12 | 11.92 | 110.28 | 149.03 | |||
| SO61204_29 | E810-4164-82 | PO15312134209 | 19 | 291 | 545 | 299 | 6 | 2025-04-18 | 24.29 | 0.61 | 2025-04-06 | 1 | 17.98 | 1 | 24.29 | 29 | SO61204 | 2025-04-13 | 1.94 | 17.98 | 24.29 | |||
| SO58914_22 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 418 | 155 | 6 | 2025-03-18 | 713.80 | 17.84 | 2025-03-06 | 2 | 360.94 | 1 | 713.80 | 22 | SO58914 | 2025-03-13 | 57.10 | 721.89 | 356.90 | |||
| SO45057_4 | 568E-472E-9C | PO11049133413 | 19 | 284 | 322 | 679 | 6 | 2023-04-19 | 419.46 | 10.49 | 2023-04-07 | 1 | 413.15 | 1 | 419.46 | 4 | SO45057 | 2023-04-14 | 33.56 | 413.15 | 419.46 | |||
| SO71800_12 | 6DBE-44CC-BD | PO15544127760 | 19 | 284 | 572 | 282 | 6 | 2025-09-17 | 890.82 | 22.27 | 2025-09-05 | 2 | 461.44 | 1 | 890.82 | 12 | SO71800 | 2025-09-12 | 71.27 | 922.89 | 445.41 | |||
| SO44750_3 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 292 | 678 | 6 | 2023-03-19 | 2456.10 | 61.40 | 2023-03-07 | 3 | 706.81 | 1 | 2456.10 | 3 | SO44750 | 2023-03-14 | 196.49 | 2120.43 | 818.70 | |||
| SO51699_12 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 507 | 64 | 6 | 2024-11-16 | 400.10 | 10.00 | 2024-11-04 | 2 | 199.85 | 1 | 400.10 | 12 | SO51699 | 2024-11-11 | 32.01 | 399.70 | 200.05 |
Generated 2025-11-04 11:18:59.452 UTC