[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 2405 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO45039_15 | F427-497C-A1 | PO18444197500 | 19 | 288 | 317 | 227 | 6 | 2023-04-21 | 4373.97 | 109.35 | 2023-04-09 | 5 | 884.71 | 1 | 4373.97 | 15 | SO45039 | 2023-04-16 | 349.92 | 4423.54 | 874.79 | |||
| SO67302_16 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 524 | 442 | 6 | 2025-07-20 | 316.86 | 7.92 | 2025-07-08 | 2 | 144.59 | 1 | 316.86 | 16 | SO67302 | 2025-07-15 | 25.35 | 289.19 | 158.43 | |||
| SO53510_11 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 515 | 685 | 6 | 2024-12-19 | 32.54 | 0.81 | 2024-12-07 | 2 | 12.04 | 1 | 32.54 | 11 | SO53510 | 2024-12-14 | 2.60 | 24.08 | 16.27 | |||
| SO43886_1 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 315 | 317 | 6 | 2022-11-19 | 1749.59 | 43.74 | 2022-11-07 | 2 | 884.71 | 1 | 1749.59 | 1 | SO43886 | 2022-11-14 | 139.97 | 1769.42 | 874.79 | |||
| SO51160_4 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 512 | 496 | 6 | 2024-10-18 | 1747.63 | 43.69 | 2024-10-06 | 8 | 199.38 | 1 | 1747.63 | 4 | SO51160 | 2024-10-13 | 139.81 | 1595.01 | 218.45 | |||
| SO61177_8 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 595 | 442 | 6 | 2025-04-20 | 677.99 | 16.95 | 2025-04-08 | 2 | 308.22 | 1 | 677.99 | 8 | SO61177 | 2025-04-15 | 54.24 | 616.44 | 338.99 | |||
| SO47978_13 | 6C70-48BF-96 | PO17748122244 | 19 | 284 | 375 | 102 | 6 | 2024-02-19 | 2617.88 | 65.45 | 2024-02-07 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO47978 | 2024-02-14 | 209.43 | 2641.37 | 1308.94 | |||
| SO51703_26 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 490 | 12 | 6 | 2024-11-18 | 226.76 | 5.67 | 2024-11-06 | 7 | 41.57 | 1 | 226.76 | 26 | SO51703 | 2024-11-13 | 18.14 | 291.01 | 32.39 | |||
| SO71786_4 | 80E7-439C-8F | PO17690128583 | 19 | 291 | 475 | 47 | 6 | 2025-09-19 | 125.98 | 3.15 | 2025-09-07 | 3 | 26.18 | 1 | 125.98 | 4 | SO71786 | 2025-09-14 | 10.08 | 78.53 | 41.99 | |||
| SO65216_2 | A00E-46E0-BD | PO14239135307 | 19 | 291 | 580 | 550 | 6 | 2025-06-19 | 1020.59 | 25.51 | 2025-06-07 | 1 | 1082.51 | 1 | 1020.59 | 2 | SO65216 | 2025-06-14 | 81.65 | 1082.51 | 1020.59 | |||
| SO45323_11 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 215 | 84 | 6 | 2023-05-22 | 80.75 | 2.02 | 2023-05-10 | 4 | 12.03 | 1 | 80.75 | 11 | SO45323 | 2023-05-17 | 6.46 | 48.11 | 20.19 | |||
| SO51113_18 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 565 | 13 | 120 | 6 | 50.11 | 2024-10-18 | 334.06 | 7.10 | 2024-10-06 | 1 | 461.44 | 1 | 283.95 | 18 | SO51113 | 2024-10-13 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO67268_7 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 463 | 299 | 6 | 2025-07-20 | 88.16 | 2.20 | 2025-07-08 | 6 | 9.16 | 1 | 88.16 | 7 | SO67268 | 2025-07-15 | 7.05 | 54.96 | 14.69 | |||
| SO43679_1 | 918F-49F3-AD | PO10527142759 | 19 | 284 | 322 | 480 | 6 | 2022-10-19 | 419.46 | 10.49 | 2022-10-07 | 1 | 413.15 | 1 | 419.46 | 1 | SO43679 | 2022-10-14 | 33.56 | 413.15 | 419.46 | |||
| SO47354_16 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 254 | 173 | 6 | 2023-12-20 | 1103.63 | 27.59 | 2023-12-08 | 6 | 170.14 | 1 | 1103.63 | 16 | SO47354 | 2023-12-15 | 88.29 | 1020.86 | 183.94 | |||
| SO45313_10 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 220 | 317 | 6 | 2023-05-22 | 60.56 | 1.51 | 2023-05-10 | 3 | 12.03 | 1 | 60.56 | 10 | SO45313 | 2023-05-17 | 4.84 | 36.08 | 20.19 | |||
| SO61179_14 | 1443-4268-AC | PO18444157069 | 19 | 291 | 384 | 227 | 6 | 2025-04-20 | 2689.18 | 67.23 | 2025-04-08 | 4 | 713.08 | 1 | 2689.18 | 14 | SO61179 | 2025-04-15 | 215.13 | 2852.32 | 672.29 | |||
| SO67288_15 | C763-4CCD-AB | PO10527192676 | 19 | 284 | 546 | 480 | 6 | 2025-07-20 | 37.25 | 0.93 | 2025-07-08 | 1 | 27.57 | 1 | 37.25 | 15 | SO67288 | 2025-07-15 | 2.98 | 27.57 | 37.25 | |||
| SO46031_2 | 48FE-4B7F-92 | PO19430136502 | 19 | 284 | 232 | 318 | 6 | 2023-08-19 | 28.84 | 0.72 | 2023-08-07 | 1 | 31.72 | 1 | 28.84 | 2 | SO46031 | 2023-08-14 | 2.31 | 31.72 | 28.84 | |||
| SO45280_4 | 46AF-4DA9-99 | PO17748162196 | 19 | 284 | 285 | 102 | 6 | 2023-05-22 | 178.58 | 4.46 | 2023-05-10 | 1 | 176.20 | 1 | 178.58 | 4 | SO45280 | 2023-05-17 | 14.29 | 176.20 | 178.58 | |||
| SO49039_1 | 4F9E-4A1A-B3 | PO20039119229 | 19 | 291 | 469 | 65 | 6 | 2024-05-21 | 45.59 | 1.14 | 2024-05-09 | 2 | 15.67 | 1 | 45.59 | 1 | SO49039 | 2024-05-16 | 3.65 | 31.34 | 22.79 | |||
| SO57122_26 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 465 | 84 | 6 | 2025-02-18 | 58.78 | 1.47 | 2025-02-06 | 4 | 9.16 | 1 | 58.78 | 26 | SO57122 | 2025-02-13 | 4.70 | 36.64 | 14.69 | |||
| SO51793_25 | D763-4929-9B | PO18705168707 | 19 | 291 | 463 | 479 | 6 | 2024-11-18 | 102.86 | 2.57 | 2024-11-06 | 7 | 9.16 | 1 | 102.86 | 25 | SO51793 | 2024-11-13 | 8.23 | 64.12 | 14.69 | |||
| SO46326_10 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 340 | 173 | 6 | 2023-09-19 | 838.92 | 20.97 | 2023-09-07 | 2 | 413.15 | 1 | 838.92 | 10 | SO46326 | 2023-09-14 | 67.11 | 826.29 | 419.46 | |||
| SO71851_52 | AABE-4443-91 | PO18299133687 | 19 | 291 | 298 | 118 | 6 | 2025-09-19 | 809.76 | 20.24 | 2025-09-07 | 1 | 739.04 | 1 | 809.76 | 52 | SO71851 | 2025-09-14 | 64.78 | 739.04 | 809.76 | |||
| SO45522_8 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 312 | 173 | 6 | 2023-06-19 | 4293.92 | 107.35 | 2023-06-07 | 2 | 2171.29 | 1 | 4293.92 | 8 | SO45522 | 2023-06-14 | 343.51 | 4342.59 | 2146.96 | |||
| SO50265_6 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 286 | 479 | 6 | 2024-08-18 | 183.94 | 4.60 | 2024-08-06 | 1 | 170.14 | 1 | 183.94 | 6 | SO50265 | 2024-08-13 | 14.72 | 170.14 | 183.94 | |||
| SO50239_2 | E1A7-444D-BB | PO638156203 | 19 | 291 | 224 | 280 | 6 | 2024-08-18 | 36.31 | 0.91 | 2024-08-06 | 7 | 5.23 | 1 | 36.31 | 2 | SO50239 | 2024-08-13 | 2.90 | 36.61 | 5.19 | |||
| SO63266_26 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 476 | 352 | 6 | 2025-05-21 | 209.97 | 5.25 | 2025-05-09 | 5 | 26.18 | 1 | 209.97 | 26 | SO63266 | 2025-05-16 | 16.80 | 130.88 | 41.99 | |||
| SO46079_3 | 1491-44DD-AD | PO2726172637 | 19 | 288 | 348 | 29 | 6 | 2023-08-19 | 2024.99 | 50.62 | 2023-08-07 | 1 | 1898.09 | 1 | 2024.99 | 3 | SO46079 | 2023-08-14 | 162.00 | 1898.09 | 2024.99 | |||
| SO71792_28 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 434 | 155 | 6 | 2025-09-19 | 1070.69 | 26.77 | 2025-09-07 | 3 | 360.94 | 1 | 1070.69 | 28 | SO71792 | 2025-09-14 | 85.66 | 1082.83 | 356.90 | |||
| SO48340_17 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 469 | 685 | 6 | 2024-03-20 | 91.18 | 2.28 | 2024-03-08 | 4 | 15.67 | 1 | 91.18 | 17 | SO48340 | 2024-03-15 | 7.29 | 62.68 | 22.79 | |||
| SO48761_5 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 460 | 299 | 6 | 2024-04-20 | 431.95 | 10.80 | 2024-04-08 | 8 | 37.12 | 1 | 431.95 | 5 | SO48761 | 2024-04-15 | 34.56 | 296.97 | 53.99 | |||
| SO63132_9 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 471 | 479 | 6 | 2025-05-21 | 152.40 | 3.81 | 2025-05-09 | 4 | 23.75 | 1 | 152.40 | 9 | SO63132 | 2025-05-16 | 12.19 | 95.00 | 38.10 | |||
| SO44744_25 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 317 | 173 | 6 | 2023-03-21 | 874.79 | 21.87 | 2023-03-09 | 1 | 884.71 | 1 | 874.79 | 25 | SO44744 | 2023-03-16 | 69.98 | 884.71 | 874.79 | |||
| SO58980_25 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 498 | 154 | 6 | 2025-03-20 | 2409.38 | 60.23 | 2025-03-08 | 4 | 601.74 | 1 | 2409.38 | 25 | SO58980 | 2025-03-15 | 192.75 | 2406.97 | 602.35 | |||
| SO51160_70 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 593 | 496 | 6 | 2024-10-18 | 1355.98 | 33.90 | 2024-10-06 | 4 | 308.22 | 1 | 1355.98 | 70 | SO51160 | 2024-10-13 | 108.48 | 1232.87 | 338.99 | |||
| SO51703_12 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 237 | 12 | 6 | 2024-11-18 | 149.97 | 3.75 | 2024-11-06 | 5 | 38.49 | 1 | 149.97 | 12 | SO51703 | 2024-11-13 | 12.00 | 192.46 | 29.99 | |||
| SO46951_7 | 6998-44C0-A4 | PO17748125133 | 19 | 284 | 339 | 102 | 6 | 2023-11-19 | 1409.38 | 35.23 | 2023-11-07 | 3 | 486.71 | 1 | 1409.38 | 7 | SO46951 | 2023-11-14 | 112.75 | 1460.12 | 469.79 | |||
| SO50192_10 | A5BA-4696-96 | PO19227162823 | 19 | 284 | 343 | 210 | 6 | 2024-08-18 | 1409.38 | 35.23 | 2024-08-06 | 3 | 486.71 | 1 | 1409.38 | 10 | SO50192 | 2024-08-13 | 112.75 | 1460.12 | 469.79 | |||
| SO44525_15 | E0C6-40AA-AD | PO11600189203 | 19 | 288 | 332 | 569 | 6 | 2023-02-19 | 1677.84 | 41.95 | 2023-02-07 | 4 | 413.15 | 1 | 1677.84 | 15 | SO44525 | 2023-02-14 | 134.23 | 1652.59 | 419.46 | |||
| SO71830_30 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 506 | 281 | 6 | 2025-09-19 | 600.16 | 15.00 | 2025-09-07 | 3 | 199.85 | 1 | 600.16 | 30 | SO71830 | 2025-09-14 | 48.01 | 599.56 | 200.05 | |||
| SO50204_1 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 459 | 533 | 6 | 2024-08-18 | 107.99 | 2.70 | 2024-08-06 | 2 | 37.12 | 1 | 107.99 | 1 | SO50204 | 2024-08-13 | 8.64 | 74.24 | 53.99 | |||
| SO47973_20 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 387 | 479 | 6 | 2024-02-19 | 1200.53 | 30.01 | 2024-02-07 | 2 | 605.65 | 1 | 1200.53 | 20 | SO47973 | 2024-02-14 | 96.04 | 1211.30 | 600.26 | |||
| SO47365_37 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 233 | 3 | 678 | 6 | 23.79 | 2023-12-20 | 475.87 | 11.30 | 2023-12-08 | 18 | 29.08 | 1 | 452.07 | 37 | SO47365 | 2023-12-15 | 36.17 | 523.45 | 26.44 | 0.05 |
| SO51100_2 | A159-4950-A0 | PO13862191766 | 19 | 291 | 524 | 119 | 6 | 2024-10-18 | 475.29 | 11.88 | 2024-10-06 | 3 | 144.59 | 1 | 475.29 | 2 | SO51100 | 2024-10-13 | 38.02 | 433.78 | 158.43 | |||
| SO45305_3 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 212 | 569 | 6 | 2023-05-22 | 121.12 | 3.03 | 2023-05-10 | 6 | 12.03 | 1 | 121.12 | 3 | SO45305 | 2023-05-17 | 9.69 | 72.17 | 20.19 | |||
| SO53535_2 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 521 | 154 | 6 | 2024-12-19 | 32.54 | 0.81 | 2024-12-07 | 2 | 12.04 | 1 | 32.54 | 2 | SO53535 | 2024-12-14 | 2.60 | 24.08 | 16.27 | |||
| SO58981_38 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 544 | 118 | 6 | 2025-03-20 | 194.38 | 4.86 | 2025-03-08 | 4 | 35.96 | 1 | 194.38 | 38 | SO58981 | 2025-03-15 | 15.55 | 143.84 | 48.59 | |||
| SO57155_7 | 4EB5-4191-9E | PO2117166089 | 19 | 284 | 491 | 444 | 6 | 2025-02-18 | 129.58 | 3.24 | 2025-02-06 | 4 | 41.57 | 1 | 129.58 | 7 | SO57155 | 2025-02-13 | 10.37 | 166.29 | 32.39 | |||
| SO65235_8 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 587 | 685 | 6 | 2025-06-19 | 461.69 | 11.54 | 2025-06-07 | 1 | 419.78 | 1 | 461.69 | 8 | SO65235 | 2025-06-14 | 36.94 | 419.78 | 461.69 | |||
| SO46645_9 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 399 | 245 | 6 | 2023-10-19 | 270.20 | 6.75 | 2023-10-07 | 8 | 24.99 | 1 | 270.20 | 9 | SO46645 | 2023-10-14 | 21.62 | 199.95 | 33.77 | |||
| SO51832_35 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 590 | 352 | 6 | 2024-11-18 | 461.69 | 11.54 | 2024-11-06 | 1 | 419.78 | 1 | 461.69 | 35 | SO51832 | 2024-11-13 | 36.94 | 419.78 | 461.69 | |||
| SO59022_3 | F672-4E69-A9 | PO7366189433 | 19 | 284 | 494 | 372 | 6 | 2025-03-20 | 1204.69 | 30.12 | 2025-03-08 | 2 | 601.74 | 1 | 1204.69 | 3 | SO59022 | 2025-03-15 | 96.38 | 1203.49 | 602.35 | |||
| SO58953_12 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 434 | 156 | 6 | 2025-03-20 | 1070.69 | 26.77 | 2025-03-08 | 3 | 360.94 | 1 | 1070.69 | 12 | SO58953 | 2025-03-15 | 85.66 | 1082.83 | 356.90 | |||
| SO51793_48 | D763-4929-9B | PO18705168707 | 19 | 291 | 481 | 479 | 6 | 2024-11-18 | 43.15 | 1.08 | 2024-11-06 | 8 | 3.36 | 1 | 43.15 | 48 | SO51793 | 2024-11-13 | 3.45 | 26.90 | 5.39 | |||
| 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 | |||
| SO47411_4 | 4BDD-4511-AC | PO1798140269 | 19 | 291 | 364 | 10 | 6 | 2023-12-20 | 1295.99 | 32.40 | 2023-12-08 | 2 | 598.44 | 1 | 1295.99 | 4 | SO47411 | 2023-12-15 | 103.68 | 1196.87 | 647.99 | |||
| SO51160_46 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 511 | 496 | 6 | 2024-10-18 | 1747.63 | 43.69 | 2024-10-06 | 8 | 199.38 | 1 | 1747.63 | 46 | SO51160 | 2024-10-13 | 139.81 | 1595.01 | 218.45 | |||
| SO58918_52 | C811-4D40-80 | PO17574131484 | 19 | 291 | 524 | 678 | 6 | 2025-03-20 | 475.29 | 11.88 | 2025-03-08 | 3 | 144.59 | 1 | 475.29 | 52 | SO58918 | 2025-03-15 | 38.02 | 433.78 | 158.43 | |||
| SO48037_8 | D0D4-4B5F-84 | PO1827138439 | 19 | 291 | 370 | 317 | 6 | 2024-02-19 | 4398.03 | 109.95 | 2024-02-07 | 3 | 1518.79 | 1 | 4398.03 | 8 | SO48037 | 2024-02-14 | 351.84 | 4556.36 | 1466.01 | |||
| SO67270_3 | 685A-440D-8C | PO14732111382 | 19 | 291 | 482 | 514 | 6 | 2025-07-20 | 16.18 | 0.40 | 2025-07-08 | 3 | 3.36 | 1 | 16.18 | 3 | SO67270 | 2025-07-15 | 1.29 | 10.09 | 5.39 |
Generated 2025-11-06 09:28:09.374 UTC