[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 874 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO48750_36 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 368 | 514 | 6 | 2024-04-20 | 2932.02 | 73.30 | 2024-04-08 | 2 | 1518.79 | 1 | 2932.02 | 36 | SO48750 | 2024-04-15 | 234.56 | 3037.57 | 1466.01 | |||
| SO50664_29 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 385 | 173 | 6 | 2024-09-18 | 1800.79 | 45.02 | 2024-09-06 | 3 | 605.65 | 1 | 1800.79 | 29 | SO50664 | 2024-09-13 | 144.06 | 1816.95 | 600.26 | |||
| SO46351_7 | 9218-4521-8F | PO11107115959 | 19 | 284 | 232 | 156 | 6 | 2023-09-19 | 57.68 | 1.44 | 2023-09-07 | 2 | 31.72 | 1 | 57.68 | 7 | SO46351 | 2023-09-14 | 4.61 | 63.45 | 28.84 | |||
| SO50689_29 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 337 | 461 | 6 | 2024-09-18 | 1409.38 | 35.23 | 2024-09-06 | 3 | 486.71 | 1 | 1409.38 | 29 | SO50689 | 2024-09-13 | 112.75 | 1460.12 | 469.79 | |||
| SO69398_6 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 484 | 28 | 6 | 2025-08-19 | 4.77 | 0.12 | 2025-08-07 | 1 | 2.97 | 1 | 4.77 | 6 | SO69398 | 2025-08-14 | 0.38 | 2.97 | 4.77 | |||
| SO53464_6 | E113-419B-8F | PO17545119283 | 19 | 291 | 547 | 155 | 6 | 2024-12-19 | 145.78 | 3.64 | 2024-12-07 | 3 | 35.96 | 1 | 145.78 | 6 | SO53464 | 2024-12-14 | 11.66 | 107.88 | 48.59 | |||
| SO47670_30 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 458 | 2 | 514 | 6 | 9.57 | 2024-01-19 | 478.44 | 11.72 | 2024-01-07 | 11 | 30.93 | 1 | 468.87 | 30 | SO47670 | 2024-01-14 | 37.51 | 340.27 | 43.49 | 0.02 |
| SO63290_8 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 524 | 100 | 6 | 2025-05-21 | 792.15 | 19.80 | 2025-05-09 | 5 | 144.59 | 1 | 792.15 | 8 | SO63290 | 2025-05-16 | 63.37 | 722.97 | 158.43 | |||
| SO47413_7 | E274-4280-9B | PO1885161774 | 19 | 284 | 399 | 588 | 6 | 2023-12-20 | 135.10 | 3.38 | 2023-12-08 | 4 | 24.99 | 1 | 135.10 | 7 | SO47413 | 2023-12-15 | 10.81 | 99.97 | 33.77 | |||
| SO71851_40 | AABE-4443-91 | PO18299133687 | 19 | 291 | 490 | 118 | 6 | 2025-09-19 | 129.58 | 3.24 | 2025-09-07 | 4 | 41.57 | 1 | 129.58 | 40 | SO71851 | 2025-09-14 | 10.37 | 166.29 | 32.39 | |||
| SO65173_18 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 481 | 155 | 6 | 2025-06-19 | 26.97 | 0.67 | 2025-06-07 | 5 | 3.36 | 1 | 26.97 | 18 | SO65173 | 2025-06-14 | 2.16 | 16.81 | 5.39 | |||
| SO50698_8 | 304A-4672-BA | PO1798139213 | 19 | 291 | 401 | 10 | 6 | 2024-09-18 | 131.20 | 3.28 | 2024-09-06 | 2 | 48.55 | 1 | 131.20 | 8 | SO50698 | 2024-09-13 | 10.50 | 97.09 | 65.60 | |||
| SO49140_32 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 373 | 84 | 6 | 2024-05-21 | 1308.94 | 32.72 | 2024-05-09 | 1 | 1320.68 | 1 | 1308.94 | 32 | SO49140 | 2024-05-16 | 104.72 | 1320.68 | 1308.94 | |||
| SO48350_6 | 1505-4FEA-92 | PO1798152196 | 19 | 291 | 360 | 10 | 6 | 2024-03-20 | 4917.84 | 122.95 | 2024-03-08 | 4 | 1105.81 | 1 | 4917.84 | 6 | SO48350 | 2024-03-15 | 393.43 | 4423.24 | 1229.46 | |||
| SO47662_13 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 360 | 442 | 6 | 2024-01-19 | 2458.92 | 61.47 | 2024-01-07 | 2 | 1105.81 | 1 | 2458.92 | 13 | SO47662 | 2024-01-14 | 196.71 | 2211.62 | 1229.46 | |||
| SO50689_40 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 341 | 461 | 6 | 2024-09-18 | 469.79 | 11.74 | 2024-09-06 | 1 | 486.71 | 1 | 469.79 | 40 | SO50689 | 2024-09-13 | 37.58 | 486.71 | 469.79 | |||
| SO53464_34 | E113-419B-8F | PO17545119283 | 19 | 291 | 390 | 155 | 6 | 2024-12-19 | 672.29 | 16.81 | 2024-12-07 | 1 | 713.08 | 1 | 672.29 | 34 | SO53464 | 2024-12-14 | 53.78 | 713.08 | 672.29 | |||
| SO49856_11 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 461 | 227 | 6 | 2024-07-19 | 53.99 | 1.35 | 2024-07-07 | 1 | 37.12 | 1 | 53.99 | 11 | SO49856 | 2024-07-14 | 4.32 | 37.12 | 53.99 | |||
| SO53484_5 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 544 | 497 | 6 | 2024-12-19 | 194.38 | 4.86 | 2024-12-07 | 4 | 35.96 | 1 | 194.38 | 5 | SO53484 | 2024-12-14 | 15.55 | 143.84 | 48.59 | |||
| SO45323_10 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 270 | 84 | 6 | 2023-05-22 | 919.69 | 22.99 | 2023-05-10 | 5 | 181.49 | 1 | 919.69 | 10 | SO45323 | 2023-05-17 | 73.58 | 907.43 | 183.94 | |||
| SO55297_15 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 217 | 496 | 6 | 2025-01-18 | 104.97 | 2.62 | 2025-01-06 | 5 | 13.09 | 1 | 104.97 | 15 | SO55297 | 2025-01-13 | 8.40 | 65.43 | 20.99 | |||
| SO57097_7 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 372 | 552 | 6 | 2025-02-18 | 4398.03 | 109.95 | 2025-02-06 | 3 | 1554.95 | 1 | 4398.03 | 7 | SO57097 | 2025-02-13 | 351.84 | 4664.84 | 1466.01 | |||
| SO50699_28 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 410 | 588 | 6 | 2024-09-18 | 109.34 | 2.73 | 2024-09-06 | 3 | 26.97 | 1 | 109.34 | 28 | SO50699 | 2024-09-13 | 8.75 | 80.91 | 36.45 | |||
| SO47708_1 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 456 | 496 | 6 | 2024-01-19 | 179.98 | 4.50 | 2024-01-07 | 4 | 30.93 | 1 | 179.98 | 1 | SO47708 | 2024-01-14 | 14.40 | 123.73 | 44.99 | |||
| SO47012_32 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 407 | 66 | 6 | 2023-11-19 | 65.60 | 1.64 | 2023-11-07 | 1 | 48.55 | 1 | 65.60 | 32 | SO47012 | 2023-11-14 | 5.25 | 48.55 | 65.60 | |||
| SO65238_14 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 586 | 281 | 6 | 2025-06-19 | 1336.23 | 33.41 | 2025-06-07 | 3 | 461.44 | 1 | 1336.23 | 14 | SO65238 | 2025-06-14 | 106.90 | 1384.33 | 445.41 | |||
| SO61248_45 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 595 | 496 | 6 | 2025-04-20 | 338.99 | 8.47 | 2025-04-08 | 1 | 308.22 | 1 | 338.99 | 45 | SO61248 | 2025-04-15 | 27.12 | 308.22 | 338.99 | |||
| SO49103_10 | 0B8A-4326-8A | PO17748175932 | 19 | 284 | 286 | 102 | 6 | 2024-05-21 | 367.88 | 9.20 | 2024-05-09 | 2 | 170.14 | 1 | 367.88 | 10 | SO49103 | 2024-05-16 | 29.43 | 340.29 | 183.94 | |||
| SO57073_1 | 6481-4651-B6 | PO10498143051 | 19 | 291 | 475 | 316 | 6 | 2025-02-18 | 41.99 | 1.05 | 2025-02-06 | 1 | 26.18 | 1 | 41.99 | 1 | SO57073 | 2025-02-13 | 3.36 | 26.18 | 41.99 | |||
| SO51781_12 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 472 | 65 | 6 | 2024-11-18 | 114.30 | 2.86 | 2024-11-06 | 3 | 23.75 | 1 | 114.30 | 12 | SO51781 | 2024-11-13 | 9.14 | 71.25 | 38.10 | |||
| SO44749_1 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 334 | 155 | 6 | 2023-03-21 | 419.46 | 10.49 | 2023-03-09 | 1 | 413.15 | 1 | 419.46 | 1 | SO44749 | 2023-03-16 | 33.56 | 413.15 | 419.46 | |||
| SO51124_6 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 551 | 245 | 6 | 2024-10-18 | 158.43 | 3.96 | 2024-10-06 | 1 | 144.59 | 1 | 158.43 | 6 | SO51124 | 2024-10-13 | 12.67 | 144.59 | 158.43 | |||
| SO49060_2 | 7CC0-486B-BA | PO638179417 | 19 | 291 | 469 | 280 | 6 | 2024-05-21 | 22.79 | 0.57 | 2024-05-09 | 1 | 15.67 | 1 | 22.79 | 2 | SO49060 | 2024-05-16 | 1.82 | 15.67 | 22.79 | |||
| SO55297_65 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 501 | 496 | 6 | 2025-01-18 | 145.75 | 3.64 | 2025-01-06 | 2 | 53.93 | 1 | 145.75 | 65 | SO55297 | 2025-01-13 | 11.66 | 107.86 | 72.88 | |||
| SO55287_20 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 511 | 119 | 6 | 2025-01-18 | 218.45 | 5.46 | 2025-01-06 | 1 | 199.38 | 1 | 218.45 | 20 | SO55287 | 2025-01-13 | 17.48 | 199.38 | 218.45 | |||
| SO69397_4 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 601 | 64 | 6 | 2025-08-19 | 32.39 | 0.81 | 2025-08-07 | 1 | 23.97 | 1 | 32.39 | 4 | SO69397 | 2025-08-14 | 2.59 | 23.97 | 32.39 | |||
| SO44103_4 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 232 | 156 | 6 | 2022-12-20 | 28.84 | 0.72 | 2022-12-08 | 1 | 31.72 | 1 | 28.84 | 4 | SO44103 | 2022-12-15 | 2.31 | 31.72 | 28.84 | |||
| SO58914_2 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 374 | 155 | 6 | 2025-03-20 | 4398.03 | 109.95 | 2025-03-08 | 3 | 1554.95 | 1 | 4398.03 | 2 | SO58914 | 2025-03-15 | 351.84 | 4664.84 | 1466.01 | |||
| SO50265_9 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 383 | 479 | 6 | 2024-08-18 | 1800.79 | 45.02 | 2024-08-06 | 3 | 605.65 | 1 | 1800.79 | 9 | SO50265 | 2024-08-13 | 144.06 | 1816.95 | 600.26 | |||
| SO45800_1 | 5B67-4FE2-B9 | PO10527156525 | 19 | 284 | 223 | 480 | 6 | 2023-07-20 | 5.19 | 0.13 | 2023-07-08 | 1 | 5.71 | 1 | 5.19 | 1 | SO45800 | 2023-07-15 | 0.41 | 5.71 | 5.19 | |||
| SO44749_18 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 324 | 155 | 6 | 2023-03-21 | 1677.84 | 41.95 | 2023-03-09 | 4 | 413.15 | 1 | 1677.84 | 18 | SO44749 | 2023-03-16 | 134.23 | 1652.59 | 419.46 | |||
| SO65166_1 | FB7B-4351-80 | PO17835116706 | 19 | 291 | 398 | 551 | 6 | 2025-06-19 | 26.72 | 0.67 | 2025-06-07 | 1 | 19.78 | 1 | 26.72 | 1 | SO65166 | 2025-06-14 | 2.14 | 19.78 | 26.72 | |||
| SO65173_9 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 580 | 155 | 6 | 2025-06-19 | 6123.56 | 153.09 | 2025-06-07 | 6 | 1082.51 | 1 | 6123.56 | 9 | SO65173 | 2025-06-14 | 489.89 | 6495.06 | 1020.59 | |||
| SO67316_30 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 359 | 496 | 6 | 2025-07-20 | 13769.94 | 344.25 | 2025-07-08 | 10 | 1251.98 | 1 | 13769.94 | 30 | SO67316 | 2025-07-15 | 1101.60 | 12519.81 | 1376.99 | |||
| SO71794_41 | C39A-4835-99 | PO17574111985 | 19 | 291 | 543 | 678 | 6 | 2025-09-19 | 74.51 | 1.86 | 2025-09-07 | 2 | 27.57 | 1 | 74.51 | 41 | SO71794 | 2025-09-14 | 5.96 | 55.14 | 37.25 | |||
| SO55287_30 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 525 | 119 | 6 | 2025-01-18 | 158.43 | 3.96 | 2025-01-06 | 1 | 144.59 | 1 | 158.43 | 30 | SO55287 | 2025-01-13 | 12.67 | 144.59 | 158.43 | |||
| SO61215_4 | 58AF-4A8D-B4 | PO10527132307 | 19 | 284 | 583 | 480 | 6 | 2025-04-20 | 2041.19 | 51.03 | 2025-04-08 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO61215 | 2025-04-15 | 163.30 | 2165.02 | 1020.59 | |||
| SO53456_17 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 481 | 173 | 6 | 2024-12-19 | 10.79 | 0.27 | 2024-12-07 | 2 | 3.36 | 1 | 10.79 | 17 | SO53456 | 2024-12-14 | 0.86 | 6.72 | 5.39 | |||
| SO48299_5 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 462 | 118 | 6 | 2024-03-20 | 42.39 | 1.06 | 2024-03-08 | 3 | 9.71 | 1 | 42.39 | 5 | SO48299 | 2024-03-15 | 3.39 | 29.14 | 14.13 | |||
| SO51698_24 | C8C8-43A4-AC | PO19227173300 | 19 | 284 | 222 | 210 | 6 | 2024-11-18 | 104.97 | 2.62 | 2024-11-06 | 5 | 13.09 | 1 | 104.97 | 24 | SO51698 | 2024-11-13 | 8.40 | 65.43 | 20.99 | |||
| SO48036_41 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 422 | 66 | 6 | 2024-02-19 | 67.54 | 1.69 | 2024-02-07 | 1 | 49.98 | 1 | 67.54 | 41 | SO48036 | 2024-02-14 | 5.40 | 49.98 | 67.54 | |||
| SO48307_21 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 458 | 155 | 6 | 2024-03-20 | 404.95 | 10.12 | 2024-03-08 | 9 | 30.93 | 1 | 404.95 | 21 | SO48307 | 2024-03-15 | 32.40 | 278.40 | 44.99 | |||
| SO50676_32 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 224 | 497 | 6 | 2024-09-18 | 15.56 | 0.39 | 2024-09-06 | 3 | 5.23 | 1 | 15.56 | 32 | SO50676 | 2024-09-13 | 1.24 | 15.69 | 5.19 | |||
| SO65174_22 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 363 | 678 | 6 | 2025-06-19 | 5507.98 | 137.70 | 2025-06-07 | 4 | 1251.98 | 1 | 5507.98 | 22 | SO65174 | 2025-06-14 | 440.64 | 5007.93 | 1376.99 | |||
| SO48744_11 | 15DB-48CD-9B | PO1711156590 | 19 | 291 | 352 | 245 | 6 | 2024-04-20 | 4971.41 | 124.29 | 2024-04-08 | 4 | 1117.86 | 1 | 4971.41 | 11 | SO48744 | 2024-04-15 | 397.71 | 4471.42 | 1242.85 | |||
| SO69522_20 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 217 | 2 | 84 | 6 | 5.28 | 2025-08-19 | 263.82 | 6.46 | 2025-08-07 | 13 | 13.09 | 1 | 258.55 | 20 | SO69522 | 2025-08-14 | 20.68 | 170.12 | 20.29 | 0.02 |
| SO58918_17 | C811-4D40-80 | PO17574131484 | 19 | 291 | 467 | 678 | 6 | 2025-03-20 | 73.47 | 1.84 | 2025-03-08 | 5 | 9.16 | 1 | 73.47 | 17 | SO58918 | 2025-03-15 | 5.88 | 45.80 | 14.69 | |||
| SO51793_9 | D763-4929-9B | PO18705168707 | 19 | 291 | 376 | 479 | 6 | 2024-11-18 | 1466.01 | 36.65 | 2024-11-06 | 1 | 1554.95 | 1 | 1466.01 | 9 | SO51793 | 2024-11-13 | 117.28 | 1554.95 | 1466.01 | |||
| SO71806_5 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 597 | 497 | 6 | 2025-09-19 | 323.99 | 8.10 | 2025-09-07 | 1 | 294.58 | 1 | 323.99 | 5 | SO71806 | 2025-09-14 | 25.92 | 294.58 | 323.99 | |||
| SO65164_38 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 544 | 118 | 6 | 2025-06-19 | 97.19 | 2.43 | 2025-06-07 | 2 | 35.96 | 1 | 97.19 | 38 | SO65164 | 2025-06-14 | 7.78 | 71.92 | 48.59 | |||
| SO67270_28 | 685A-440D-8C | PO14732111382 | 19 | 291 | 408 | 514 | 6 | 2025-07-20 | 144.32 | 3.61 | 2025-07-08 | 2 | 53.40 | 1 | 144.32 | 28 | SO67270 | 2025-07-15 | 11.55 | 106.80 | 72.16 | |||
| SO50698_18 | 304A-4672-BA | PO1798139213 | 19 | 291 | 297 | 10 | 6 | 2024-09-18 | 1472.29 | 36.81 | 2024-09-06 | 2 | 653.70 | 1 | 1472.29 | 18 | SO50698 | 2024-09-13 | 117.78 | 1307.39 | 736.15 |
Generated 2025-11-06 10:57:38.298 UTC