[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 3435 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46953_34 | C650-4C32-BE | PO17603154442 | 19 | 284 | 464 | 12 | 6 | 2023-11-19 | 14.13 | 0.35 | 2023-11-07 | 1 | 9.71 | 1 | 14.13 | 34 | SO46953 | 2023-11-14 | 1.13 | 9.71 | 14.13 | |||
| SO57024_5 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 465 | 264 | 6 | 2025-02-18 | 73.47 | 1.84 | 2025-02-06 | 5 | 9.16 | 1 | 73.47 | 5 | SO57024 | 2025-02-13 | 5.88 | 45.80 | 14.69 | |||
| SO47670_53 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 456 | 514 | 6 | 2024-01-19 | 179.98 | 4.50 | 2024-01-07 | 4 | 30.93 | 1 | 179.98 | 53 | SO47670 | 2024-01-14 | 14.40 | 123.73 | 44.99 | |||
| SO49100_9 | BD42-4470-A8 | PO17603154869 | 19 | 284 | 462 | 12 | 6 | 2024-05-21 | 70.64 | 1.77 | 2024-05-09 | 5 | 9.71 | 1 | 70.64 | 9 | SO49100 | 2024-05-16 | 5.65 | 48.57 | 14.13 | |||
| SO47008_15 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 254 | 426 | 6 | 2023-11-19 | 735.75 | 18.39 | 2023-11-07 | 4 | 170.14 | 1 | 735.75 | 15 | SO47008 | 2023-11-14 | 58.86 | 680.57 | 183.94 | |||
| SO58918_23 | C811-4D40-80 | PO17574131484 | 19 | 291 | 592 | 678 | 6 | 2025-03-20 | 1355.98 | 33.90 | 2025-03-08 | 4 | 308.22 | 1 | 1355.98 | 23 | SO58918 | 2025-03-15 | 108.48 | 1232.87 | 338.99 | |||
| SO47663_34 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 369 | 227 | 6 | 2024-01-19 | 2932.02 | 73.30 | 2024-01-07 | 2 | 1518.79 | 1 | 2932.02 | 34 | SO47663 | 2024-01-14 | 234.56 | 3037.57 | 1466.01 | |||
| SO49879_38 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 216 | 3 | 496 | 6 | 17.58 | 2024-07-19 | 351.58 | 8.35 | 2024-07-07 | 19 | 13.88 | 1 | 334.00 | 38 | SO49879 | 2024-07-14 | 26.72 | 263.69 | 18.50 | 0.05 |
| SO45047_24 | B1C5-444F-BF | PO14732155479 | 19 | 288 | 270 | 514 | 6 | 2023-04-21 | 367.88 | 9.20 | 2023-04-09 | 2 | 181.49 | 1 | 367.88 | 24 | SO45047 | 2023-04-16 | 29.43 | 362.97 | 183.94 | |||
| SO50261_3 | 6142-4396-B8 | PO20039145643 | 19 | 291 | 358 | 65 | 6 | 2024-08-18 | 3688.38 | 92.21 | 2024-08-06 | 3 | 1105.81 | 1 | 3688.38 | 3 | SO50261 | 2024-08-13 | 295.07 | 3317.43 | 1229.46 | |||
| SO45314_15 | E3E6-417D-A7 | PO2088183646 | 19 | 288 | 342 | 136 | 6 | 2023-05-22 | 1677.84 | 41.95 | 2023-05-10 | 4 | 413.15 | 1 | 1677.84 | 15 | SO45314 | 2023-05-17 | 134.23 | 1652.59 | 419.46 | |||
| SO55275_14 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 558 | 245 | 6 | 2025-01-18 | 1214.97 | 30.37 | 2025-01-06 | 5 | 179.82 | 1 | 1214.97 | 14 | SO55275 | 2025-01-13 | 97.20 | 899.08 | 242.99 | |||
| SO53536_19 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 477 | 3 | 118 | 6 | 2.33 | 2024-12-19 | 46.66 | 1.11 | 2024-12-07 | 17 | 1.87 | 1 | 44.32 | 19 | SO53536 | 2024-12-14 | 3.55 | 31.73 | 2.74 | 0.05 |
| SO63128_7 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 558 | 64 | 6 | 2025-05-21 | 728.98 | 18.22 | 2025-05-09 | 3 | 179.82 | 1 | 728.98 | 7 | SO63128 | 2025-05-16 | 58.32 | 539.45 | 242.99 | |||
| SO51755_9 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 547 | 336 | 6 | 2024-11-18 | 48.59 | 1.21 | 2024-11-06 | 1 | 35.96 | 1 | 48.59 | 9 | SO51755 | 2024-11-13 | 3.89 | 35.96 | 48.59 | |||
| SO69400_3 | 761C-4315-82 | PO17806199596 | 19 | 291 | 545 | 101 | 6 | 2025-08-19 | 48.59 | 1.21 | 2025-08-07 | 2 | 17.98 | 1 | 48.59 | 3 | SO69400 | 2025-08-14 | 3.89 | 35.96 | 24.29 | |||
| SO55275_19 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 559 | 245 | 6 | 2025-01-18 | 24.29 | 0.61 | 2025-01-06 | 2 | 8.99 | 1 | 24.29 | 19 | SO55275 | 2025-01-13 | 1.94 | 17.97 | 12.14 | |||
| SO50667_6 | 4C29-4EC4-84 | PO17690111589 | 19 | 291 | 469 | 47 | 6 | 2024-09-18 | 136.76 | 3.42 | 2024-09-06 | 6 | 15.67 | 1 | 136.76 | 6 | SO50667 | 2024-09-13 | 10.94 | 94.03 | 22.79 | |||
| SO44283_22 | D5FF-488D-B7 | PO18444150042 | 19 | 288 | 220 | 227 | 6 | 2023-01-19 | 40.37 | 1.01 | 2023-01-07 | 2 | 12.03 | 1 | 40.37 | 22 | SO44283 | 2023-01-14 | 3.23 | 24.06 | 20.19 | |||
| SO50716_33 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 448 | 118 | 6 | 2024-09-18 | 35.98 | 0.90 | 2024-09-06 | 3 | 8.25 | 1 | 35.98 | 33 | SO50716 | 2024-09-13 | 2.88 | 24.74 | 11.99 | |||
| SO46997_9 | 9714-4035-90 | PO11020181604 | 19 | 284 | 323 | 2 | 336 | 6 | 108.99 | 2023-11-19 | 5449.61 | 133.52 | 2023-11-07 | 12 | 486.71 | 1 | 5340.62 | 9 | SO46997 | 2023-11-14 | 427.25 | 5840.48 | 454.13 | 0.02 |
| SO49848_11 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 362 | 245 | 6 | 2024-07-19 | 3688.38 | 92.21 | 2024-07-07 | 3 | 1105.81 | 1 | 3688.38 | 11 | SO49848 | 2024-07-14 | 295.07 | 3317.43 | 1229.46 | |||
| SO57122_30 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 237 | 84 | 6 | 2025-02-18 | 119.98 | 3.00 | 2025-02-06 | 4 | 38.49 | 1 | 119.98 | 30 | SO57122 | 2025-02-13 | 9.60 | 153.97 | 29.99 | |||
| SO47398_29 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 341 | 461 | 6 | 2023-12-20 | 1879.18 | 46.98 | 2023-12-08 | 4 | 486.71 | 1 | 1879.18 | 29 | SO47398 | 2023-12-15 | 150.33 | 1946.83 | 469.79 | |||
| SO67304_7 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 376 | 227 | 6 | 2025-07-20 | 2932.02 | 73.30 | 2025-07-08 | 2 | 1554.95 | 1 | 2932.02 | 7 | SO67304 | 2025-07-15 | 234.56 | 3109.90 | 1466.01 | |||
| SO63132_15 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 374 | 479 | 6 | 2025-05-21 | 2932.02 | 73.30 | 2025-05-09 | 2 | 1554.95 | 1 | 2932.02 | 15 | SO63132 | 2025-05-16 | 234.56 | 3109.90 | 1466.01 | |||
| SO43662_12 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 275 | 227 | 6 | 2022-10-19 | 356.90 | 8.92 | 2022-10-07 | 1 | 352.14 | 1 | 356.90 | 12 | SO43662 | 2022-10-14 | 28.55 | 352.14 | 356.90 | |||
| SO48296_18 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 343 | 173 | 6 | 2024-03-20 | 1879.18 | 46.98 | 2024-03-08 | 4 | 486.71 | 1 | 1879.18 | 18 | SO48296 | 2024-03-15 | 150.33 | 1946.83 | 469.79 | |||
| SO55263_10 | 10F0-498D-AE | PO11136189942 | 19 | 284 | 573 | 120 | 6 | 2025-01-18 | 1430.44 | 35.76 | 2025-01-06 | 1 | 1481.94 | 1 | 1430.44 | 10 | SO55263 | 2025-01-13 | 114.44 | 1481.94 | 1430.44 | |||
| SO51850_23 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 576 | 2 | 263 | 6 | 331.86 | 2024-11-18 | 16593.13 | 406.53 | 2024-11-06 | 12 | 1481.94 | 1 | 16261.26 | 23 | SO51850 | 2024-11-13 | 1300.90 | 17783.25 | 1382.76 | 0.02 |
| SO50242_30 | A651-4343-86 | PO1595193228 | 19 | 284 | 331 | 426 | 6 | 2024-08-18 | 2348.97 | 58.72 | 2024-08-06 | 5 | 486.71 | 1 | 2348.97 | 30 | SO50242 | 2024-08-13 | 187.92 | 2433.53 | 469.79 | |||
| SO58980_29 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 586 | 154 | 6 | 2025-03-20 | 890.82 | 22.27 | 2025-03-08 | 2 | 461.44 | 1 | 890.82 | 29 | SO58980 | 2025-03-15 | 71.27 | 922.89 | 445.41 | |||
| SO48761_3 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 339 | 299 | 6 | 2024-04-20 | 1879.18 | 46.98 | 2024-04-08 | 4 | 486.71 | 1 | 1879.18 | 3 | SO48761 | 2024-04-15 | 150.33 | 1946.83 | 469.79 | |||
| SO46074_4 | 5178-4FDE-97 | PO2088179248 | 19 | 288 | 253 | 136 | 6 | 2023-08-19 | 535.74 | 13.39 | 2023-08-07 | 3 | 176.20 | 1 | 535.74 | 4 | SO46074 | 2023-08-14 | 42.86 | 528.60 | 178.58 | |||
| SO48754_2 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 458 | 442 | 6 | 2024-04-20 | 179.98 | 4.50 | 2024-04-08 | 4 | 30.93 | 1 | 179.98 | 2 | SO48754 | 2024-04-15 | 14.40 | 123.73 | 44.99 | |||
| 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 | |||
| SO53477_7 | F1BC-4EF4-85 | PO15544120937 | 19 | 284 | 493 | 282 | 6 | 2024-12-19 | 200.05 | 5.00 | 2024-12-07 | 1 | 199.85 | 1 | 200.05 | 7 | SO53477 | 2024-12-14 | 16.00 | 199.85 | 200.05 | |||
| SO47663_4 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 273 | 227 | 6 | 2024-01-19 | 202.33 | 5.06 | 2024-01-07 | 1 | 187.16 | 1 | 202.33 | 4 | SO47663 | 2024-01-14 | 16.19 | 187.16 | 202.33 | |||
| SO51839_48 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 467 | 84 | 6 | 2024-11-18 | 117.55 | 2.94 | 2024-11-06 | 8 | 9.16 | 1 | 117.55 | 48 | SO51839 | 2024-11-13 | 9.40 | 73.27 | 14.69 | |||
| SO71794_52 | C39A-4835-99 | PO17574111985 | 19 | 291 | 234 | 678 | 6 | 2025-09-19 | 59.99 | 1.50 | 2025-09-07 | 2 | 38.49 | 1 | 59.99 | 52 | SO71794 | 2025-09-14 | 4.80 | 76.98 | 29.99 | |||
| SO50284_3 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 381 | 84 | 6 | 2024-08-18 | 600.26 | 15.01 | 2024-08-06 | 1 | 605.65 | 1 | 600.26 | 3 | SO50284 | 2024-08-13 | 48.02 | 605.65 | 600.26 | |||
| SO45529_3 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 347 | 678 | 6 | 2023-06-19 | 6119.98 | 153.00 | 2023-06-07 | 3 | 1912.15 | 1 | 6119.98 | 3 | SO45529 | 2023-06-14 | 489.60 | 5736.46 | 2039.99 | |||
| SO44103_3 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 322 | 156 | 6 | 2022-12-20 | 838.92 | 20.97 | 2022-12-08 | 2 | 413.15 | 1 | 838.92 | 3 | SO44103 | 2022-12-15 | 67.11 | 826.29 | 419.46 | |||
| SO63136_8 | 0873-484A-AE | PO18328125904 | 19 | 284 | 477 | 552 | 6 | 2025-05-21 | 11.98 | 0.30 | 2025-05-09 | 4 | 1.87 | 1 | 11.98 | 8 | SO63136 | 2025-05-16 | 0.96 | 7.47 | 2.99 | |||
| SO46608_12 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 410 | 442 | 6 | 2023-10-19 | 109.34 | 2.73 | 2023-10-07 | 3 | 26.97 | 1 | 109.34 | 12 | SO46608 | 2023-10-14 | 8.75 | 80.91 | 36.45 | |||
| SO57082_1 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 545 | 426 | 6 | 2025-02-18 | 24.29 | 0.61 | 2025-02-06 | 1 | 17.98 | 1 | 24.29 | 1 | SO57082 | 2025-02-13 | 1.94 | 17.98 | 24.29 | |||
| SO71794_18 | C39A-4835-99 | PO17574111985 | 19 | 291 | 491 | 3 | 678 | 6 | 28.21 | 2025-09-19 | 564.20 | 13.40 | 2025-09-07 | 19 | 41.57 | 1 | 535.99 | 18 | SO71794 | 2025-09-14 | 42.88 | 789.87 | 29.69 | 0.05 |
| SO53542_6 | D309-4C20-A5 | PO18531154951 | 19 | 284 | 476 | 613 | 6 | 2024-12-19 | 377.95 | 9.45 | 2024-12-07 | 9 | 26.18 | 1 | 377.95 | 6 | SO53542 | 2024-12-14 | 30.24 | 235.59 | 41.99 | |||
| SO48036_31 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 233 | 66 | 6 | 2024-02-19 | 144.20 | 3.61 | 2024-02-07 | 5 | 29.08 | 1 | 144.20 | 31 | SO48036 | 2024-02-14 | 11.54 | 145.40 | 28.84 | |||
| SO55243_28 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 255 | 299 | 6 | 2025-01-18 | 202.33 | 5.06 | 2025-01-06 | 1 | 204.63 | 1 | 202.33 | 28 | SO55243 | 2025-01-13 | 16.19 | 204.63 | 202.33 | |||
| SO57023_22 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 436 | 12 | 6 | 2025-02-18 | 2498.29 | 62.46 | 2025-02-06 | 7 | 360.94 | 1 | 2498.29 | 22 | SO57023 | 2025-02-13 | 199.86 | 2526.60 | 356.90 | |||
| SO46657_25 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 294 | 496 | 6 | 2023-10-19 | 2977.09 | 74.43 | 2023-10-07 | 4 | 660.91 | 1 | 2977.09 | 25 | SO46657 | 2023-10-14 | 238.17 | 2643.66 | 744.27 | |||
| SO51740_8 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 474 | 677 | 6 | 2024-11-18 | 167.98 | 4.20 | 2024-11-06 | 4 | 26.18 | 1 | 167.98 | 8 | SO51740 | 2024-11-13 | 13.44 | 104.71 | 41.99 | |||
| SO49860_2 | DB5C-4441-BE | PO13862128354 | 19 | 291 | 409 | 119 | 6 | 2024-07-19 | 418.51 | 10.46 | 2024-07-07 | 2 | 185.82 | 1 | 418.51 | 2 | SO49860 | 2024-07-14 | 33.48 | 371.64 | 209.26 | |||
| SO44111_16 | CFDA-475D-95 | PO1740120267 | 19 | 288 | 330 | 460 | 6 | 2022-12-20 | 838.92 | 20.97 | 2022-12-08 | 2 | 413.15 | 1 | 838.92 | 16 | SO44111 | 2022-12-15 | 67.11 | 826.29 | 419.46 | |||
| SO61186_14 | C662-487E-B0 | PO14732152217 | 19 | 291 | 384 | 514 | 6 | 2025-04-20 | 3361.47 | 84.04 | 2025-04-08 | 5 | 713.08 | 1 | 3361.47 | 14 | SO61186 | 2025-04-15 | 268.92 | 3565.40 | 672.29 | |||
| SO61248_31 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 298 | 496 | 6 | 2025-04-20 | 1619.52 | 40.49 | 2025-04-08 | 2 | 739.04 | 1 | 1619.52 | 31 | SO61248 | 2025-04-15 | 129.56 | 1478.08 | 809.76 | |||
| SO48778_31 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 233 | 496 | 6 | 2024-04-20 | 57.68 | 1.44 | 2024-04-08 | 2 | 29.08 | 1 | 57.68 | 31 | SO48778 | 2024-04-15 | 4.61 | 58.16 | 28.84 | |||
| SO47380_3 | EF71-4036-91 | PO14790123967 | 19 | 291 | 427 | 497 | 6 | 2023-12-20 | 418.51 | 10.46 | 2023-12-08 | 2 | 185.82 | 1 | 418.51 | 3 | SO47380 | 2023-12-15 | 33.48 | 371.64 | 209.26 | |||
| SO49828_55 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 271 | 514 | 6 | 2024-07-19 | 809.33 | 20.23 | 2024-07-07 | 4 | 187.16 | 1 | 809.33 | 55 | SO49828 | 2024-07-14 | 64.75 | 748.63 | 202.33 | |||
| SO50204_15 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 273 | 533 | 6 | 2024-08-18 | 607.00 | 15.17 | 2024-08-06 | 3 | 187.16 | 1 | 607.00 | 15 | SO50204 | 2024-08-13 | 48.56 | 561.47 | 202.33 | |||
| SO51156_2 | C598-4D75-B4 | PO4930142451 | 19 | 291 | 475 | 425 | 6 | 2024-10-18 | 83.99 | 2.10 | 2024-10-06 | 2 | 26.18 | 1 | 83.99 | 2 | SO51156 | 2024-10-13 | 6.72 | 52.35 | 41.99 |
Generated 2025-11-06 07:23:54.374 UTC