[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 345 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO53477_29 | F1BC-4EF4-85 | PO15544120937 | 19 | 284 | 552 | 282 | 6 | 2024-12-19 | 109.79 | 2.74 | 2024-12-07 | 2 | 40.62 | 1 | 109.79 | 29 | SO53477 | 2024-12-14 | 8.78 | 81.24 | 54.89 | |||
| SO63138_3 | 3BDB-40B5-A6 | PO17806142534 | 19 | 291 | 583 | 101 | 6 | 2025-05-21 | 3061.78 | 76.54 | 2025-05-09 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO63138 | 2025-05-16 | 244.94 | 3247.53 | 1020.59 | |||
| SO44774_7 | 6F0A-4629-A5 | PO1885185716 | 19 | 284 | 232 | 588 | 6 | 2023-03-21 | 28.84 | 0.72 | 2023-03-09 | 1 | 31.72 | 1 | 28.84 | 7 | SO44774 | 2023-03-16 | 2.31 | 31.72 | 28.84 | |||
| SO71828_6 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 566 | 48 | 6 | 2025-09-19 | 445.41 | 11.14 | 2025-09-07 | 1 | 461.44 | 1 | 445.41 | 6 | SO71828 | 2025-09-14 | 35.63 | 461.44 | 445.41 | |||
| SO61186_3 | C662-487E-B0 | PO14732152217 | 19 | 291 | 584 | 514 | 6 | 2025-04-20 | 323.99 | 8.10 | 2025-04-08 | 1 | 343.65 | 1 | 323.99 | 3 | SO61186 | 2025-04-15 | 25.92 | 343.65 | 323.99 | |||
| SO45323_21 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 314 | 84 | 6 | 2023-05-22 | 4293.92 | 107.35 | 2023-05-10 | 2 | 2171.29 | 1 | 4293.92 | 21 | SO45323 | 2023-05-17 | 343.51 | 4342.59 | 2146.96 | |||
| SO58918_16 | C811-4D40-80 | PO17574131484 | 19 | 291 | 400 | 678 | 6 | 2025-03-20 | 148.61 | 3.72 | 2025-03-08 | 4 | 27.49 | 1 | 148.61 | 16 | SO58918 | 2025-03-15 | 11.89 | 109.97 | 37.15 | |||
| SO57023_15 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 545 | 12 | 6 | 2025-02-18 | 72.88 | 1.82 | 2025-02-06 | 3 | 17.98 | 1 | 72.88 | 15 | SO57023 | 2025-02-13 | 5.83 | 53.93 | 24.29 | |||
| SO50694_43 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 230 | 155 | 6 | 2024-09-18 | 173.04 | 4.33 | 2024-09-06 | 6 | 29.08 | 1 | 173.04 | 43 | SO50694 | 2024-09-13 | 13.84 | 174.48 | 28.84 | |||
| SO47359_4 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 470 | 2 | 118 | 6 | 4.85 | 2023-12-20 | 242.38 | 5.94 | 2023-12-08 | 11 | 15.67 | 1 | 237.53 | 4 | SO47359 | 2023-12-15 | 19.00 | 172.38 | 22.03 | 0.02 |
| SO57024_6 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 559 | 264 | 6 | 2025-02-18 | 12.14 | 0.30 | 2025-02-06 | 1 | 8.99 | 1 | 12.14 | 6 | SO57024 | 2025-02-13 | 0.97 | 8.99 | 12.14 | |||
| SO45781_17 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 342 | 227 | 6 | 2023-07-20 | 2097.29 | 52.43 | 2023-07-08 | 5 | 413.15 | 1 | 2097.29 | 17 | SO45781 | 2023-07-15 | 167.78 | 2065.73 | 419.46 | |||
| SO49070_6 | 2B81-47B6-AD | PO1827112158 | 19 | 291 | 383 | 317 | 6 | 2024-05-21 | 1800.79 | 45.02 | 2024-05-09 | 3 | 605.65 | 1 | 1800.79 | 6 | SO49070 | 2024-05-16 | 144.06 | 1816.95 | 600.26 | |||
| SO47673_20 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 469 | 3 | 119 | 6 | 18.81 | 2024-01-19 | 376.10 | 8.93 | 2024-01-07 | 18 | 15.67 | 1 | 357.30 | 20 | SO47673 | 2024-01-14 | 28.58 | 282.08 | 20.89 | 0.05 |
| SO71792_1 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 605 | 155 | 6 | 2025-09-19 | 647.99 | 16.20 | 2025-09-07 | 2 | 343.65 | 1 | 647.99 | 1 | SO71792 | 2025-09-14 | 51.84 | 687.30 | 323.99 | |||
| SO63178_1 | 63E5-40BB-9E | PO2117138284 | 19 | 284 | 474 | 444 | 6 | 2025-05-21 | 419.94 | 10.50 | 2025-05-09 | 10 | 26.18 | 1 | 419.94 | 1 | SO63178 | 2025-05-16 | 33.60 | 261.76 | 41.99 | |||
| SO53510_13 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 524 | 685 | 6 | 2024-12-19 | 950.58 | 23.76 | 2024-12-07 | 6 | 144.59 | 1 | 950.58 | 13 | SO53510 | 2024-12-14 | 76.05 | 867.56 | 158.43 | |||
| SO57154_23 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 561 | 263 | 6 | 2025-02-18 | 2860.88 | 71.52 | 2025-02-06 | 2 | 1481.94 | 1 | 2860.88 | 23 | SO57154 | 2025-02-13 | 228.87 | 2963.88 | 1430.44 | |||
| SO47398_25 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 447 | 461 | 6 | 2023-12-20 | 150.00 | 3.75 | 2023-12-08 | 10 | 10.31 | 1 | 150.00 | 25 | SO47398 | 2023-12-15 | 12.00 | 103.13 | 15.00 | |||
| SO65206_17 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 589 | 10 | 6 | 2025-06-19 | 923.39 | 23.08 | 2025-06-07 | 2 | 419.78 | 1 | 923.39 | 17 | SO65206 | 2025-06-14 | 73.87 | 839.56 | 461.69 | |||
| SO67316_53 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 491 | 496 | 6 | 2025-07-20 | 291.55 | 7.29 | 2025-07-08 | 9 | 41.57 | 1 | 291.55 | 53 | SO67316 | 2025-07-15 | 23.32 | 374.15 | 32.39 | |||
| SO53465_52 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 527 | 678 | 6 | 2024-12-19 | 316.86 | 7.92 | 2024-12-07 | 2 | 144.59 | 1 | 316.86 | 52 | SO53465 | 2024-12-14 | 25.35 | 289.19 | 158.43 | |||
| SO57188_20 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 544 | 100 | 6 | 2025-02-18 | 48.59 | 1.21 | 2025-02-06 | 1 | 35.96 | 1 | 48.59 | 20 | SO57188 | 2025-02-13 | 3.89 | 35.96 | 48.59 | |||
| SO51699_17 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 548 | 64 | 6 | 2024-11-18 | 145.78 | 3.64 | 2024-11-06 | 3 | 35.96 | 1 | 145.78 | 17 | SO51699 | 2024-11-13 | 11.66 | 107.88 | 48.59 | |||
| SO44547_6 | 801C-4288-87 | PO4901179982 | 19 | 284 | 332 | 84 | 6 | 2023-02-19 | 1677.84 | 41.95 | 2023-02-07 | 4 | 413.15 | 1 | 1677.84 | 6 | SO44547 | 2023-02-14 | 134.23 | 1652.59 | 419.46 | |||
| SO63138_1 | 3BDB-40B5-A6 | PO17806142534 | 19 | 291 | 605 | 101 | 6 | 2025-05-21 | 323.99 | 8.10 | 2025-05-09 | 1 | 343.65 | 1 | 323.99 | 1 | SO63138 | 2025-05-16 | 25.92 | 343.65 | 323.99 | |||
| SO47708_38 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 391 | 496 | 6 | 2024-01-19 | 177.86 | 4.45 | 2024-01-07 | 2 | 65.81 | 1 | 177.86 | 38 | SO47708 | 2024-01-14 | 14.23 | 131.62 | 88.93 | |||
| 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 | |||
| SO71828_19 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 500 | 48 | 6 | 2025-09-19 | 1204.69 | 30.12 | 2025-09-07 | 2 | 601.74 | 1 | 1204.69 | 19 | SO71828 | 2025-09-14 | 96.38 | 1203.49 | 602.35 | |||
| SO44300_9 | 5132-4204-BB | PO10527120063 | 19 | 284 | 324 | 480 | 6 | 2023-01-19 | 419.46 | 10.49 | 2023-01-07 | 1 | 413.15 | 1 | 419.46 | 9 | SO44300 | 2023-01-14 | 33.56 | 413.15 | 419.46 | |||
| SO47396_3 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 352 | 586 | 6 | 2023-12-20 | 4971.41 | 124.29 | 2023-12-08 | 4 | 1117.86 | 1 | 4971.41 | 3 | SO47396 | 2023-12-15 | 397.71 | 4471.42 | 1242.85 | |||
| SO50689_32 | 20BC-4161-86 | PO10614135588 | 19 | 291 | 265 | 461 | 6 | 2024-09-18 | 202.33 | 5.06 | 2024-09-06 | 1 | 187.16 | 1 | 202.33 | 32 | SO50689 | 2024-09-13 | 16.19 | 187.16 | 202.33 | |||
| SO44498_7 | 7715-4053-B5 | PO17748167942 | 19 | 284 | 324 | 102 | 6 | 2023-02-19 | 2516.75 | 62.92 | 2023-02-07 | 6 | 413.15 | 1 | 2516.75 | 7 | SO44498 | 2023-02-14 | 201.34 | 2478.88 | 419.46 | |||
| SO46065_2 | 4002-48B7-BF | PO10469188321 | 19 | 288 | 350 | 335 | 6 | 2023-08-19 | 2024.99 | 50.62 | 2023-08-07 | 1 | 1898.09 | 1 | 2024.99 | 2 | SO46065 | 2023-08-14 | 162.00 | 1898.09 | 2024.99 | |||
| SO65188_5 | 86B3-49B3-A1 | PO14790112162 | 19 | 291 | 474 | 497 | 6 | 2025-06-19 | 377.95 | 9.45 | 2025-06-07 | 9 | 26.18 | 1 | 377.95 | 5 | SO65188 | 2025-06-14 | 30.24 | 235.59 | 41.99 | |||
| SO46940_55 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 265 | 479 | 6 | 2023-11-19 | 607.00 | 15.17 | 2023-11-07 | 3 | 187.16 | 1 | 607.00 | 55 | SO46940 | 2023-11-14 | 48.56 | 561.47 | 202.33 | |||
| SO45306_4 | F836-4C32-8D | PO11020195551 | 19 | 284 | 342 | 336 | 6 | 2023-05-22 | 838.92 | 20.97 | 2023-05-10 | 2 | 413.15 | 1 | 838.92 | 4 | SO45306 | 2023-05-17 | 67.11 | 826.29 | 419.46 | |||
| SO47380_28 | EF71-4036-91 | PO14790123967 | 19 | 291 | 352 | 497 | 6 | 2023-12-20 | 4971.41 | 124.29 | 2023-12-08 | 4 | 1117.86 | 1 | 4971.41 | 28 | SO47380 | 2023-12-15 | 397.71 | 4471.42 | 1242.85 | |||
| SO47366_29 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 422 | 155 | 6 | 2023-12-20 | 405.23 | 10.13 | 2023-12-08 | 6 | 49.98 | 1 | 405.23 | 29 | SO47366 | 2023-12-15 | 32.42 | 299.87 | 67.54 | |||
| SO51100_20 | A159-4950-A0 | PO13862191766 | 19 | 291 | 542 | 119 | 6 | 2024-10-18 | 72.88 | 1.82 | 2024-10-06 | 3 | 17.98 | 1 | 72.88 | 20 | SO51100 | 2024-10-13 | 5.83 | 53.93 | 24.29 | |||
| SO47366_2 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 333 | 155 | 6 | 2023-12-20 | 939.59 | 23.49 | 2023-12-08 | 2 | 486.71 | 1 | 939.59 | 2 | SO47366 | 2023-12-15 | 75.17 | 973.41 | 469.79 | |||
| SO53508_7 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 523 | 48 | 6 | 2024-12-19 | 221.09 | 5.53 | 2024-12-07 | 7 | 23.37 | 1 | 221.09 | 7 | SO53508 | 2024-12-14 | 17.69 | 163.61 | 31.58 | |||
| SO57023_9 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 434 | 12 | 6 | 2025-02-18 | 1784.49 | 44.61 | 2025-02-06 | 5 | 360.94 | 1 | 1784.49 | 9 | SO57023 | 2025-02-13 | 142.76 | 1804.71 | 356.90 | |||
| SO63177_12 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 463 | 263 | 6 | 2025-05-21 | 88.16 | 2.20 | 2025-05-09 | 6 | 9.16 | 1 | 88.16 | 12 | SO63177 | 2025-05-16 | 7.05 | 54.96 | 14.69 | |||
| SO50687_2 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 421 | 685 | 6 | 2024-09-18 | 196.33 | 4.91 | 2024-09-06 | 1 | 145.28 | 1 | 196.33 | 2 | SO50687 | 2024-09-13 | 15.71 | 145.28 | 196.33 | |||
| SO71786_1 | 80E7-439C-8F | PO17690128583 | 19 | 291 | 476 | 47 | 6 | 2025-09-19 | 335.95 | 8.40 | 2025-09-07 | 8 | 26.18 | 1 | 335.95 | 1 | SO71786 | 2025-09-14 | 26.88 | 209.41 | 41.99 | |||
| SO55266_4 | 03C7-431B-BA | PO10527171106 | 19 | 284 | 225 | 480 | 6 | 2025-01-18 | 16.18 | 0.40 | 2025-01-06 | 3 | 6.92 | 1 | 16.18 | 4 | SO55266 | 2025-01-13 | 1.29 | 20.77 | 5.39 | |||
| SO46940_50 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 373 | 479 | 6 | 2023-11-19 | 1308.94 | 32.72 | 2023-11-07 | 1 | 1320.68 | 1 | 1308.94 | 50 | SO46940 | 2023-11-14 | 104.72 | 1320.68 | 1308.94 | |||
| SO44504_7 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 320 | 533 | 6 | 2023-02-19 | 419.46 | 10.49 | 2023-02-07 | 1 | 413.15 | 1 | 419.46 | 7 | SO44504 | 2023-02-14 | 33.56 | 413.15 | 419.46 | |||
| SO48351_23 | 0478-43AC-AB | PO1885129829 | 19 | 284 | 367 | 588 | 6 | 2024-03-20 | 1943.98 | 48.60 | 2024-03-08 | 3 | 598.44 | 1 | 1943.98 | 23 | SO48351 | 2024-03-15 | 155.52 | 1795.31 | 647.99 | |||
| SO71794_12 | C39A-4835-99 | PO17574111985 | 19 | 291 | 559 | 678 | 6 | 2025-09-19 | 24.29 | 0.61 | 2025-09-07 | 2 | 8.99 | 1 | 24.29 | 12 | SO71794 | 2025-09-14 | 1.94 | 17.97 | 12.14 | |||
| SO65251_2 | 21EB-4282-A4 | PO11107110635 | 19 | 284 | 482 | 156 | 6 | 2025-06-19 | 21.58 | 0.54 | 2025-06-07 | 4 | 3.36 | 1 | 21.58 | 2 | SO65251 | 2025-06-14 | 1.73 | 13.45 | 5.39 | |||
| SO58980_12 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 497 | 154 | 6 | 2025-03-20 | 602.35 | 15.06 | 2025-03-08 | 1 | 601.74 | 1 | 602.35 | 12 | SO58980 | 2025-03-15 | 48.19 | 601.74 | 602.35 | |||
| SO43886_21 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 232 | 317 | 6 | 2022-11-19 | 115.36 | 2.88 | 2022-11-07 | 4 | 31.72 | 1 | 115.36 | 21 | SO43886 | 2022-11-14 | 9.23 | 126.90 | 28.84 | |||
| SO48350_16 | 1505-4FEA-92 | PO1798152196 | 19 | 291 | 364 | 10 | 6 | 2024-03-20 | 5183.95 | 129.60 | 2024-03-08 | 8 | 598.44 | 1 | 5183.95 | 16 | SO48350 | 2024-03-15 | 414.72 | 4787.48 | 647.99 | |||
| SO47662_17 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 230 | 442 | 6 | 2024-01-19 | 57.68 | 1.44 | 2024-01-07 | 2 | 29.08 | 1 | 57.68 | 17 | SO47662 | 2024-01-14 | 4.61 | 58.16 | 28.84 | |||
| SO43847_2 | 4E09-4638-82 | PO19227161888 | 19 | 284 | 223 | 210 | 6 | 2022-11-19 | 5.19 | 0.13 | 2022-11-07 | 1 | 5.71 | 1 | 5.19 | 2 | SO43847 | 2022-11-14 | 0.41 | 5.71 | 5.19 | |||
| SO51130_24 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 295 | 442 | 6 | 2024-10-18 | 1637.40 | 40.94 | 2024-10-06 | 2 | 747.20 | 1 | 1637.40 | 24 | SO51130 | 2024-10-13 | 130.99 | 1494.40 | 818.70 | |||
| SO69400_7 | 761C-4315-82 | PO17806199596 | 19 | 291 | 580 | 101 | 6 | 2025-08-19 | 1020.59 | 25.51 | 2025-08-07 | 1 | 1082.51 | 1 | 1020.59 | 7 | SO69400 | 2025-08-14 | 81.65 | 1082.51 | 1020.59 | |||
| SO50245_43 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 433 | 66 | 6 | 2024-08-18 | 1297.81 | 32.45 | 2024-08-06 | 4 | 300.12 | 1 | 1297.81 | 43 | SO50245 | 2024-08-13 | 103.82 | 1200.48 | 324.45 | |||
| SO44283_17 | D5FF-488D-B7 | PO18444150042 | 19 | 288 | 276 | 227 | 6 | 2023-01-19 | 713.80 | 17.84 | 2023-01-07 | 2 | 352.14 | 1 | 713.80 | 17 | SO44283 | 2023-01-14 | 57.10 | 704.28 | 356.90 | |||
| SO48779_1 | 1E4A-4963-9E | PO4930175427 | 19 | 291 | 468 | 425 | 6 | 2024-04-20 | 22.79 | 0.57 | 2024-04-08 | 1 | 15.67 | 1 | 22.79 | 1 | SO48779 | 2024-04-15 | 1.82 | 15.67 | 22.79 |
Generated 2025-11-06 08:06:11.156 UTC