[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 251 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO71847_30 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 492 | 154 | 6 | 2025-09-15 | 2409.38 | 60.23 | 2025-09-03 | 4 | 601.74 | 1 | 2409.38 | 30 | SO71847 | 2025-09-10 | 192.75 | 2406.97 | 602.35 | |||
| SO44750_21 | B71E-4BBF-B5 | PO17574147002 | 19 | 288 | 232 | 678 | 6 | 2023-03-17 | 173.04 | 4.33 | 2023-03-05 | 6 | 31.72 | 1 | 173.04 | 21 | SO44750 | 2023-03-12 | 13.84 | 190.35 | 28.84 | |||
| SO65218_15 | 582E-4D6F-9C | PO15544112763 | 19 | 284 | 576 | 282 | 6 | 2025-06-15 | 1430.44 | 35.76 | 2025-06-03 | 1 | 1481.94 | 1 | 1430.44 | 15 | SO65218 | 2025-06-10 | 114.44 | 1481.94 | 1430.44 | |||
| SO44081_7 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 218 | 118 | 6 | 2022-12-16 | 11.40 | 0.29 | 2022-12-04 | 2 | 3.40 | 1 | 11.40 | 7 | SO44081 | 2022-12-11 | 0.91 | 6.79 | 5.70 | |||
| SO63128_20 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 559 | 64 | 6 | 2025-05-17 | 12.14 | 0.30 | 2025-05-05 | 1 | 8.99 | 1 | 12.14 | 20 | SO63128 | 2025-05-12 | 0.97 | 8.99 | 12.14 | |||
| SO49879_20 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 459 | 496 | 6 | 2024-07-15 | 269.97 | 6.75 | 2024-07-03 | 5 | 37.12 | 1 | 269.97 | 20 | SO49879 | 2024-07-10 | 21.60 | 185.60 | 53.99 | |||
| SO63127_9 | BC04-42FB-8F | PO19227167253 | 19 | 284 | 482 | 210 | 6 | 2025-05-17 | 10.79 | 0.27 | 2025-05-05 | 2 | 3.36 | 1 | 10.79 | 9 | SO63127 | 2025-05-12 | 0.86 | 6.72 | 5.39 | |||
| SO48750_20 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 339 | 514 | 6 | 2024-04-16 | 2348.97 | 58.72 | 2024-04-04 | 5 | 486.71 | 1 | 2348.97 | 20 | SO48750 | 2024-04-11 | 187.92 | 2433.53 | 469.79 | |||
| SO69482_6 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 491 | 138 | 6 | 2025-08-15 | 129.58 | 3.24 | 2025-08-03 | 4 | 41.57 | 1 | 129.58 | 6 | SO69482 | 2025-08-10 | 10.37 | 166.29 | 32.39 | |||
| SO43855_8 | FB88-4B92-82 | PO17748116016 | 19 | 284 | 334 | 102 | 6 | 2022-11-15 | 419.46 | 10.49 | 2022-11-03 | 1 | 413.15 | 1 | 419.46 | 8 | SO43855 | 2022-11-10 | 33.56 | 413.15 | 419.46 | |||
| SO48036_17 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 265 | 66 | 6 | 2024-02-15 | 1011.66 | 25.29 | 2024-02-03 | 5 | 187.16 | 1 | 1011.66 | 17 | SO48036 | 2024-02-10 | 80.93 | 935.79 | 202.33 | |||
| SO47413_27 | E274-4280-9B | PO1885161774 | 19 | 284 | 470 | 588 | 6 | 2023-12-16 | 182.35 | 4.56 | 2023-12-04 | 8 | 15.67 | 1 | 182.35 | 27 | SO47413 | 2023-12-11 | 14.59 | 125.37 | 22.79 | |||
| SO53465_70 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 533 | 678 | 6 | 2024-12-15 | 449.62 | 11.24 | 2024-12-03 | 3 | 136.79 | 1 | 449.62 | 70 | SO53465 | 2024-12-10 | 35.97 | 410.36 | 149.87 | |||
| SO47037_47 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 407 | 84 | 6 | 2023-11-15 | 65.60 | 1.64 | 2023-11-03 | 1 | 48.55 | 1 | 65.60 | 47 | SO47037 | 2023-11-10 | 5.25 | 48.55 | 65.60 | |||
| SO46938_8 | 2E58-4440-89 | PO19198122384 | 19 | 291 | 366 | 653 | 6 | 2023-11-15 | 1943.98 | 48.60 | 2023-11-03 | 3 | 598.44 | 1 | 1943.98 | 8 | SO46938 | 2023-11-10 | 155.52 | 1795.31 | 647.99 | |||
| SO55243_3 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 217 | 2 | 299 | 6 | 5.68 | 2025-01-14 | 284.12 | 6.96 | 2025-01-02 | 14 | 13.09 | 1 | 278.44 | 3 | SO55243 | 2025-01-09 | 22.27 | 183.21 | 20.29 | 0.02 |
| SO48306_14 | EA27-471A-9D | PO17574166075 | 19 | 291 | 396 | 678 | 6 | 2024-03-16 | 149.68 | 3.74 | 2024-03-04 | 2 | 55.38 | 1 | 149.68 | 14 | SO48306 | 2024-03-11 | 11.97 | 110.76 | 74.84 | |||
| SO46607_36 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 403 | 227 | 6 | 2023-10-15 | 72.88 | 1.82 | 2023-10-03 | 3 | 17.98 | 1 | 72.88 | 36 | SO46607 | 2023-10-10 | 5.83 | 53.93 | 24.29 | |||
| SO51160_11 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 355 | 496 | 6 | 2024-10-14 | 5567.98 | 139.20 | 2024-10-02 | 4 | 1265.62 | 1 | 5567.98 | 11 | SO51160 | 2024-10-09 | 445.44 | 5062.48 | 1391.99 | |||
| SO48744_4 | 15DB-48CD-9B | PO1711156590 | 19 | 291 | 420 | 245 | 6 | 2024-04-16 | 424.85 | 10.62 | 2024-04-04 | 3 | 104.80 | 1 | 424.85 | 4 | SO48744 | 2024-04-11 | 33.99 | 314.39 | 141.62 | |||
| SO50694_11 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 453 | 155 | 6 | 2024-09-14 | 287.95 | 7.20 | 2024-09-02 | 8 | 24.75 | 1 | 287.95 | 11 | SO50694 | 2024-09-09 | 23.04 | 197.97 | 35.99 | |||
| SO58981_7 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 490 | 118 | 6 | 2025-03-16 | 259.15 | 6.48 | 2025-03-04 | 8 | 41.57 | 1 | 259.15 | 7 | SO58981 | 2025-03-11 | 20.73 | 332.58 | 32.39 | |||
| SO50265_37 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 456 | 479 | 6 | 2024-08-14 | 89.99 | 2.25 | 2024-08-02 | 2 | 30.93 | 1 | 89.99 | 37 | SO50265 | 2024-08-09 | 7.20 | 61.87 | 44.99 | |||
| SO44298_7 | 960B-4C26-9F | PO11049118093 | 19 | 284 | 324 | 679 | 6 | 2023-01-15 | 419.46 | 10.49 | 2023-01-03 | 1 | 413.15 | 1 | 419.46 | 7 | SO44298 | 2023-01-10 | 33.56 | 413.15 | 419.46 | |||
| SO43890_11 | 6787-4174-98 | PO2146115360 | 19 | 284 | 218 | 354 | 6 | 2022-11-15 | 22.80 | 0.57 | 2022-11-03 | 4 | 3.40 | 1 | 22.80 | 11 | SO43890 | 2022-11-10 | 1.82 | 13.59 | 5.70 | |||
| SO51700_1 | 6837-439E-BC | PO17806126316 | 19 | 291 | 434 | 101 | 6 | 2024-11-14 | 1427.59 | 35.69 | 2024-11-02 | 4 | 360.94 | 1 | 1427.59 | 1 | SO51700 | 2024-11-09 | 114.21 | 1443.77 | 356.90 | |||
| SO48337_5 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 468 | 586 | 6 | 2024-03-16 | 68.38 | 1.71 | 2024-03-04 | 3 | 15.67 | 1 | 68.38 | 5 | SO48337 | 2024-03-11 | 5.47 | 47.01 | 22.79 | |||
| SO58957_28 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 543 | 685 | 6 | 2025-03-16 | 37.25 | 0.93 | 2025-03-04 | 1 | 27.57 | 1 | 37.25 | 28 | SO58957 | 2025-03-11 | 2.98 | 27.57 | 37.25 | |||
| SO49860_9 | DB5C-4441-BE | PO13862128354 | 19 | 291 | 358 | 119 | 6 | 2024-07-15 | 8606.21 | 215.16 | 2024-07-03 | 7 | 1105.81 | 1 | 8606.21 | 9 | SO49860 | 2024-07-10 | 688.50 | 7740.67 | 1229.46 | |||
| SO49856_37 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 414 | 227 | 6 | 2024-07-15 | 596.12 | 14.90 | 2024-07-03 | 4 | 110.28 | 1 | 596.12 | 37 | SO49856 | 2024-07-10 | 47.69 | 441.13 | 149.03 | |||
| SO69520_23 | 654B-484B-8F | PO4466144794 | 19 | 291 | 511 | 352 | 6 | 2025-08-15 | 218.45 | 5.46 | 2025-08-03 | 1 | 199.38 | 1 | 218.45 | 23 | SO69520 | 2025-08-10 | 17.48 | 199.38 | 218.45 | |||
| SO51116_11 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 583 | 480 | 6 | 2024-10-14 | 3061.78 | 76.54 | 2024-10-02 | 3 | 1082.51 | 1 | 3061.78 | 11 | SO51116 | 2024-10-09 | 244.94 | 3247.53 | 1020.59 | |||
| SO46616_56 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 424 | 514 | 6 | 2023-10-15 | 428.47 | 10.71 | 2023-10-03 | 2 | 158.53 | 1 | 428.47 | 56 | SO46616 | 2023-10-10 | 34.28 | 317.07 | 214.24 | |||
| SO69482_13 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 572 | 138 | 6 | 2025-08-15 | 445.41 | 11.14 | 2025-08-03 | 1 | 461.44 | 1 | 445.41 | 13 | SO69482 | 2025-08-10 | 35.63 | 461.44 | 445.41 | |||
| SO46616_21 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 213 | 8 | 514 | 6 | 6.73 | 2023-10-15 | 67.29 | 1.51 | 2023-10-03 | 4 | 13.88 | 1 | 60.56 | 21 | SO46616 | 2023-10-10 | 4.84 | 55.51 | 16.82 | 0.10 |
| SO63269_8 | B1E2-43BD-84 | PO2030137986 | 19 | 284 | 595 | 661 | 6 | 2025-05-17 | 1355.98 | 33.90 | 2025-05-05 | 4 | 308.22 | 1 | 1355.98 | 8 | SO63269 | 2025-05-12 | 108.48 | 1232.87 | 338.99 | |||
| SO58958_7 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 570 | 281 | 6 | 2025-03-16 | 445.41 | 11.14 | 2025-03-04 | 1 | 461.44 | 1 | 445.41 | 7 | SO58958 | 2025-03-11 | 35.63 | 461.44 | 445.41 | |||
| SO47967_8 | DA42-41A7-BD | PO19198173391 | 19 | 291 | 396 | 653 | 6 | 2024-02-15 | 74.84 | 1.87 | 2024-02-03 | 1 | 55.38 | 1 | 74.84 | 8 | SO47967 | 2024-02-10 | 5.99 | 55.38 | 74.84 | |||
| SO49496_10 | 1BAD-4D34-B0 | PO10614179686 | 19 | 291 | 371 | 461 | 6 | 2024-06-14 | 6544.69 | 163.62 | 2024-06-02 | 5 | 1320.68 | 1 | 6544.69 | 10 | SO49496 | 2024-06-09 | 523.58 | 6603.42 | 1308.94 | |||
| SO49507_13 | 405D-4B85-98 | PO14790133950 | 19 | 291 | 458 | 497 | 6 | 2024-06-14 | 44.99 | 1.12 | 2024-06-02 | 1 | 30.93 | 1 | 44.99 | 13 | SO49507 | 2024-06-09 | 3.60 | 30.93 | 44.99 | |||
| SO49066_6 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 453 | 426 | 6 | 2024-05-17 | 71.99 | 1.80 | 2024-05-05 | 2 | 24.75 | 1 | 71.99 | 6 | SO49066 | 2024-05-12 | 5.76 | 49.49 | 35.99 | |||
| SO47365_45 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 395 | 2 | 678 | 6 | 13.05 | 2023-12-16 | 652.61 | 15.99 | 2023-12-04 | 11 | 45.42 | 1 | 639.56 | 45 | SO47365 | 2023-12-11 | 51.16 | 499.58 | 59.33 | 0.02 |
| SO47013_14 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 337 | 317 | 6 | 2023-11-15 | 1409.38 | 35.23 | 2023-11-03 | 3 | 486.71 | 1 | 1409.38 | 14 | SO47013 | 2023-11-10 | 112.75 | 1460.12 | 469.79 | |||
| SO67316_30 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 359 | 496 | 6 | 2025-07-16 | 13769.94 | 344.25 | 2025-07-04 | 10 | 1251.98 | 1 | 13769.94 | 30 | SO67316 | 2025-07-11 | 1101.60 | 12519.81 | 1376.99 | |||
| SO69478_2 | E63C-4ABF-83 | PO18705185140 | 19 | 291 | 584 | 479 | 6 | 2025-08-15 | 323.99 | 8.10 | 2025-08-03 | 1 | 343.65 | 1 | 323.99 | 2 | SO69478 | 2025-08-10 | 25.92 | 343.65 | 323.99 | |||
| SO65235_2 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 474 | 685 | 6 | 2025-06-15 | 209.97 | 5.25 | 2025-06-03 | 5 | 26.18 | 1 | 209.97 | 2 | SO65235 | 2025-06-10 | 16.80 | 130.88 | 41.99 | |||
| SO50284_26 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 368 | 84 | 6 | 2024-08-14 | 10262.07 | 256.55 | 2024-08-02 | 7 | 1518.79 | 1 | 10262.07 | 26 | SO50284 | 2024-08-09 | 820.97 | 10631.50 | 1466.01 | |||
| SO47012_17 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 415 | 66 | 6 | 2023-11-15 | 396.07 | 9.90 | 2023-11-03 | 2 | 146.55 | 1 | 396.07 | 17 | SO47012 | 2023-11-10 | 31.69 | 293.09 | 198.04 | |||
| SO44765_1 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 232 | 156 | 6 | 2023-03-17 | 86.52 | 2.16 | 2023-03-05 | 3 | 31.72 | 1 | 86.52 | 1 | SO44765 | 2023-03-12 | 6.92 | 95.17 | 28.84 | |||
| SO46953_1 | C650-4C32-BE | PO17603154442 | 19 | 284 | 433 | 12 | 6 | 2023-11-15 | 2595.62 | 64.89 | 2023-11-03 | 8 | 300.12 | 1 | 2595.62 | 1 | SO46953 | 2023-11-10 | 207.65 | 2400.95 | 324.45 | |||
| SO47708_6 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 308 | 496 | 6 | 2024-01-15 | 3721.36 | 93.03 | 2024-01-03 | 5 | 660.91 | 1 | 3721.36 | 6 | SO47708 | 2024-01-10 | 297.71 | 3304.57 | 744.27 | |||
| SO47696_12 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 395 | 2 | 245 | 6 | 15.43 | 2024-01-15 | 771.27 | 18.90 | 2024-01-03 | 13 | 45.42 | 1 | 755.84 | 12 | SO47696 | 2024-01-10 | 60.47 | 590.42 | 59.33 | 0.02 |
| SO43677_6 | 8E3A-4564-99 | PO11049174786 | 19 | 284 | 322 | 679 | 6 | 2022-10-15 | 1677.84 | 41.95 | 2022-10-03 | 4 | 413.15 | 1 | 1677.84 | 6 | SO43677 | 2022-10-10 | 134.23 | 1652.59 | 419.46 | |||
| SO48033_4 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 325 | 426 | 6 | 2024-02-15 | 3758.35 | 93.96 | 2024-02-03 | 8 | 486.71 | 1 | 3758.35 | 4 | SO48033 | 2024-02-10 | 300.67 | 3893.65 | 469.79 | |||
| SO61177_25 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 558 | 442 | 6 | 2025-04-16 | 242.99 | 6.07 | 2025-04-04 | 1 | 179.82 | 1 | 242.99 | 25 | SO61177 | 2025-04-11 | 19.44 | 179.82 | 242.99 | |||
| SO53536_40 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 490 | 118 | 6 | 2024-12-15 | 129.58 | 3.24 | 2024-12-03 | 4 | 41.57 | 1 | 129.58 | 40 | SO53536 | 2024-12-10 | 10.37 | 166.29 | 32.39 | |||
| SO47696_11 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 410 | 245 | 6 | 2024-01-15 | 109.34 | 2.73 | 2024-01-03 | 3 | 26.97 | 1 | 109.34 | 11 | SO47696 | 2024-01-10 | 8.75 | 80.91 | 36.45 | |||
| SO44496_5 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 328 | 191 | 6 | 2023-02-15 | 419.46 | 10.49 | 2023-02-03 | 1 | 413.15 | 1 | 419.46 | 5 | SO44496 | 2023-02-10 | 33.56 | 413.15 | 419.46 | |||
| SO51096_10 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 243 | 514 | 6 | 2024-10-14 | 858.90 | 21.47 | 2024-10-02 | 1 | 868.63 | 1 | 858.90 | 10 | SO51096 | 2024-10-09 | 68.71 | 868.63 | 858.90 | |||
| SO49066_8 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 230 | 426 | 6 | 2024-05-17 | 173.04 | 4.33 | 2024-05-05 | 6 | 29.08 | 1 | 173.04 | 8 | SO49066 | 2024-05-12 | 13.84 | 174.48 | 28.84 | |||
| SO51791_31 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 481 | 552 | 6 | 2024-11-14 | 32.36 | 0.81 | 2024-11-02 | 6 | 3.36 | 1 | 32.36 | 31 | SO51791 | 2024-11-09 | 2.59 | 20.17 | 5.39 | |||
| SO49855_6 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 360 | 442 | 6 | 2024-07-15 | 4917.84 | 122.95 | 2024-07-03 | 4 | 1105.81 | 1 | 4917.84 | 6 | SO49855 | 2024-07-10 | 393.43 | 4423.24 | 1229.46 |
Generated 2025-11-03 01:48:23.443 UTC