[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 1156 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47708_17 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 397 | 496 | 6 | 2024-01-16 | 48.59 | 1.21 | 2024-01-04 | 2 | 17.98 | 1 | 48.59 | 17 | SO47708 | 2024-01-11 | 3.89 | 35.96 | 24.29 | |||
| SO65174_12 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 355 | 678 | 6 | 2025-06-16 | 4175.98 | 104.40 | 2025-06-04 | 3 | 1265.62 | 1 | 4175.98 | 12 | SO65174 | 2025-06-11 | 334.08 | 3796.86 | 1391.99 | |||
| SO48299_26 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 445 | 118 | 6 | 2024-03-17 | 107.98 | 2.70 | 2024-03-05 | 3 | 24.75 | 1 | 107.98 | 26 | SO48299 | 2024-03-12 | 8.64 | 74.24 | 35.99 | |||
| SO53513_34 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 586 | 13 | 281 | 6 | 100.22 | 2024-12-16 | 668.12 | 14.20 | 2024-12-04 | 2 | 461.44 | 1 | 567.90 | 34 | SO53513 | 2024-12-11 | 45.43 | 922.89 | 334.06 | 0.15 |
| SO49140_18 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 460 | 84 | 6 | 2024-05-18 | 269.97 | 6.75 | 2024-05-06 | 5 | 37.12 | 1 | 269.97 | 18 | SO49140 | 2024-05-13 | 21.60 | 185.60 | 53.99 | |||
| SO51160_47 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 361 | 496 | 6 | 2024-10-15 | 6884.97 | 172.12 | 2024-10-03 | 5 | 1251.98 | 1 | 6884.97 | 47 | SO51160 | 2024-10-10 | 550.80 | 6259.91 | 1376.99 | |||
| SO57093_22 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 491 | 479 | 6 | 2025-02-15 | 97.18 | 2.43 | 2025-02-03 | 3 | 41.57 | 1 | 97.18 | 22 | SO57093 | 2025-02-10 | 7.77 | 124.72 | 32.39 | |||
| SO71792_16 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 584 | 155 | 6 | 2025-09-16 | 1295.98 | 32.40 | 2025-09-04 | 4 | 343.65 | 1 | 1295.98 | 16 | SO71792 | 2025-09-11 | 103.68 | 1374.60 | 323.99 | |||
| SO53456_18 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 547 | 173 | 6 | 2024-12-16 | 242.97 | 6.07 | 2024-12-04 | 5 | 35.96 | 1 | 242.97 | 18 | SO53456 | 2024-12-11 | 19.44 | 179.80 | 48.59 | |||
| SO50660_1 | D614-4B44-B3 | PO19778143270 | 19 | 291 | 468 | 388 | 6 | 2024-09-15 | 22.79 | 0.57 | 2024-09-03 | 1 | 15.67 | 1 | 22.79 | 1 | SO50660 | 2024-09-10 | 1.82 | 15.67 | 22.79 | |||
| SO50716_2 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 454 | 118 | 6 | 2024-09-15 | 179.97 | 4.50 | 2024-09-03 | 5 | 24.75 | 1 | 179.97 | 2 | SO50716 | 2024-09-10 | 14.40 | 123.73 | 35.99 | |||
| SO44484_5 | 99EE-44F9-BF | PO19691173790 | 19 | 288 | 350 | 353 | 6 | 2023-02-16 | 2024.99 | 50.62 | 2023-02-04 | 1 | 1898.09 | 1 | 2024.99 | 5 | SO44484 | 2023-02-11 | 162.00 | 1898.09 | 2024.99 | |||
| SO58981_23 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 511 | 118 | 6 | 2025-03-17 | 1747.63 | 43.69 | 2025-03-05 | 8 | 199.38 | 1 | 1747.63 | 23 | SO58981 | 2025-03-12 | 139.81 | 1595.01 | 218.45 | |||
| SO47668_8 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 213 | 299 | 6 | 2024-01-16 | 80.75 | 2.02 | 2024-01-04 | 4 | 13.88 | 1 | 80.75 | 8 | SO47668 | 2024-01-11 | 6.46 | 55.51 | 20.19 | |||
| SO71827_16 | C6C1-47DB-95 | PO11107195325 | 19 | 284 | 390 | 156 | 6 | 2025-09-16 | 1344.59 | 33.61 | 2025-09-04 | 2 | 713.08 | 1 | 1344.59 | 16 | SO71827 | 2025-09-11 | 107.57 | 1426.16 | 672.29 | |||
| SO50232_17 | 3919-46D4-A1 | PO11020171211 | 19 | 284 | 213 | 336 | 6 | 2024-08-15 | 20.19 | 0.50 | 2024-08-03 | 1 | 13.88 | 1 | 20.19 | 17 | SO50232 | 2024-08-10 | 1.61 | 13.88 | 20.19 | |||
| SO69560_4 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 588 | 100 | 6 | 2025-08-16 | 1846.78 | 46.17 | 2025-08-04 | 4 | 419.78 | 1 | 1846.78 | 4 | SO69560 | 2025-08-11 | 147.74 | 1679.11 | 461.69 | |||
| SO47662_12 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 294 | 442 | 6 | 2024-01-16 | 744.27 | 18.61 | 2024-01-04 | 1 | 660.91 | 1 | 744.27 | 12 | SO47662 | 2024-01-11 | 59.54 | 660.91 | 744.27 | |||
| SO48750_43 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 375 | 514 | 6 | 2024-04-17 | 5235.75 | 130.89 | 2024-04-05 | 4 | 1320.68 | 1 | 5235.75 | 43 | SO48750 | 2024-04-12 | 418.86 | 5282.74 | 1308.94 | |||
| SO48340_14 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 409 | 685 | 6 | 2024-03-17 | 209.26 | 5.23 | 2024-03-05 | 1 | 185.82 | 1 | 209.26 | 14 | SO48340 | 2024-03-12 | 16.74 | 185.82 | 209.26 | |||
| SO47365_41 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 428 | 678 | 6 | 2023-12-17 | 418.51 | 10.46 | 2023-12-05 | 2 | 185.82 | 1 | 418.51 | 41 | SO47365 | 2023-12-12 | 33.48 | 371.64 | 209.26 | |||
| SO43853_1 | 434D-4DAA-96 | PO18270155899 | 19 | 288 | 350 | 11 | 6 | 2022-11-16 | 4049.99 | 101.25 | 2022-11-04 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO43853 | 2022-11-11 | 324.00 | 3796.19 | 2024.99 | |||
| SO51092_44 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 378 | 299 | 6 | 2024-10-15 | 1466.01 | 36.65 | 2024-10-03 | 1 | 1554.95 | 1 | 1466.01 | 44 | SO51092 | 2024-10-10 | 117.28 | 1554.95 | 1466.01 | |||
| SO57122_36 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 547 | 84 | 6 | 2025-02-15 | 48.59 | 1.21 | 2025-02-03 | 1 | 35.96 | 1 | 48.59 | 36 | SO57122 | 2025-02-10 | 3.89 | 35.96 | 48.59 | |||
| SO47708_2 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 395 | 2 | 496 | 6 | 16.61 | 2024-01-16 | 830.59 | 20.35 | 2024-01-04 | 14 | 45.42 | 1 | 813.98 | 2 | SO47708 | 2024-01-11 | 65.12 | 635.84 | 59.33 | 0.02 |
| SO53464_24 | E113-419B-8F | PO17545119283 | 19 | 291 | 380 | 155 | 6 | 2024-12-16 | 8796.06 | 219.90 | 2024-12-04 | 6 | 1554.95 | 1 | 8796.06 | 24 | SO53464 | 2024-12-11 | 703.68 | 9329.69 | 1466.01 | |||
| SO49045_2 | B1B9-4F02-A4 | PO19227111923 | 19 | 284 | 327 | 210 | 6 | 2024-05-18 | 1409.38 | 35.23 | 2024-05-06 | 3 | 486.71 | 1 | 1409.38 | 2 | SO49045 | 2024-05-13 | 112.75 | 1460.12 | 469.79 | |||
| SO48299_33 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 358 | 118 | 6 | 2024-03-17 | 2458.92 | 61.47 | 2024-03-05 | 2 | 1105.81 | 1 | 2458.92 | 33 | SO48299 | 2024-03-12 | 196.71 | 2211.62 | 1229.46 | |||
| SO58953_9 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 481 | 156 | 6 | 2025-03-17 | 5.39 | 0.13 | 2025-03-05 | 1 | 3.36 | 1 | 5.39 | 9 | SO58953 | 2025-03-12 | 0.43 | 3.36 | 5.39 | |||
| SO44103_5 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 223 | 156 | 6 | 2022-12-17 | 10.37 | 0.26 | 2022-12-05 | 2 | 5.71 | 1 | 10.37 | 5 | SO44103 | 2022-12-12 | 0.83 | 11.41 | 5.19 | |||
| SO46936_20 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 422 | 210 | 6 | 2023-11-16 | 67.54 | 1.69 | 2023-11-04 | 1 | 49.98 | 1 | 67.54 | 20 | SO46936 | 2023-11-11 | 5.40 | 49.98 | 67.54 | |||
| SO58980_29 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 586 | 154 | 6 | 2025-03-17 | 890.82 | 22.27 | 2025-03-05 | 2 | 461.44 | 1 | 890.82 | 29 | SO58980 | 2025-03-12 | 71.27 | 922.89 | 445.41 | |||
| SO50716_22 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 453 | 118 | 6 | 2024-09-15 | 251.96 | 6.30 | 2024-09-03 | 7 | 24.75 | 1 | 251.96 | 22 | SO50716 | 2024-09-10 | 20.16 | 173.22 | 35.99 | |||
| SO48339_16 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 273 | 461 | 6 | 2024-03-17 | 202.33 | 5.06 | 2024-03-05 | 1 | 187.16 | 1 | 202.33 | 16 | SO48339 | 2024-03-12 | 16.19 | 187.16 | 202.33 | |||
| SO49052_18 | 8769-409E-94 | PO16733182723 | 19 | 291 | 337 | 533 | 6 | 2024-05-18 | 1409.38 | 35.23 | 2024-05-06 | 3 | 486.71 | 1 | 1409.38 | 18 | SO49052 | 2024-05-13 | 112.75 | 1460.12 | 469.79 | |||
| SO47365_51 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 454 | 678 | 6 | 2023-12-17 | 107.98 | 2.70 | 2023-12-05 | 3 | 24.75 | 1 | 107.98 | 51 | SO47365 | 2023-12-12 | 8.64 | 74.24 | 35.99 | |||
| SO46959_16 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 415 | 533 | 6 | 2023-11-16 | 792.14 | 19.80 | 2023-11-04 | 4 | 146.55 | 1 | 792.14 | 16 | SO46959 | 2023-11-11 | 63.37 | 586.19 | 198.04 | |||
| SO55245_9 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 463 | 514 | 6 | 2025-01-15 | 14.69 | 0.37 | 2025-01-03 | 1 | 9.16 | 1 | 14.69 | 9 | SO55245 | 2025-01-10 | 1.18 | 9.16 | 14.69 | |||
| SO48754_31 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 213 | 442 | 6 | 2024-04-17 | 121.12 | 3.03 | 2024-04-05 | 6 | 13.88 | 1 | 121.12 | 31 | SO48754 | 2024-04-12 | 9.69 | 83.27 | 20.19 | |||
| SO46330_5 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 345 | 7 | 118 | 6 | 595.00 | 2023-09-16 | 1700.00 | 27.62 | 2023-09-04 | 2 | 1912.15 | 1 | 1105.00 | 5 | SO46330 | 2023-09-11 | 88.40 | 3824.31 | 850.00 | 0.35 |
| SO44496_5 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 328 | 191 | 6 | 2023-02-16 | 419.46 | 10.49 | 2023-02-04 | 1 | 413.15 | 1 | 419.46 | 5 | SO44496 | 2023-02-11 | 33.56 | 413.15 | 419.46 | |||
| SO49468_11 | DB7C-4159-88 | PO1885116335 | 19 | 284 | 399 | 588 | 6 | 2024-06-15 | 33.77 | 0.84 | 2024-06-03 | 1 | 24.99 | 1 | 33.77 | 11 | SO49468 | 2024-06-10 | 2.70 | 24.99 | 33.77 | |||
| SO51786_16 | CB32-4179-97 | PO18357130739 | 19 | 272 | 222 | 138 | 6 | 2024-11-15 | 83.98 | 2.10 | 2024-11-03 | 4 | 13.09 | 1 | 83.98 | 16 | SO51786 | 2024-11-10 | 6.72 | 52.35 | 20.99 | |||
| SO45792_8 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 346 | 119 | 6 | 2023-07-17 | 8159.98 | 204.00 | 2023-07-05 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO45792 | 2023-07-12 | 652.80 | 7648.62 | 2039.99 | |||
| SO44765_2 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 332 | 156 | 6 | 2023-03-18 | 838.92 | 20.97 | 2023-03-06 | 2 | 413.15 | 1 | 838.92 | 2 | SO44765 | 2023-03-13 | 67.11 | 826.29 | 419.46 | |||
| SO49480_5 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 325 | 173 | 6 | 2024-06-15 | 939.59 | 23.49 | 2024-06-03 | 2 | 486.71 | 1 | 939.59 | 5 | SO49480 | 2024-06-10 | 75.17 | 973.41 | 469.79 | |||
| SO71806_5 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 597 | 497 | 6 | 2025-09-16 | 323.99 | 8.10 | 2025-09-04 | 1 | 294.58 | 1 | 323.99 | 5 | SO71806 | 2025-09-11 | 25.92 | 294.58 | 323.99 | |||
| SO47668_17 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 415 | 299 | 6 | 2024-01-16 | 594.11 | 14.85 | 2024-01-04 | 3 | 146.55 | 1 | 594.11 | 17 | SO47668 | 2024-01-11 | 47.53 | 439.64 | 198.04 | |||
| SO63141_2 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 234 | 12 | 6 | 2025-05-18 | 149.97 | 3.75 | 2025-05-06 | 5 | 38.49 | 1 | 149.97 | 2 | SO63141 | 2025-05-13 | 12.00 | 192.46 | 29.99 | |||
| SO47047_4 | 15AB-44E1-83 | PO6496118179 | 19 | 291 | 420 | 226 | 6 | 2023-11-16 | 141.62 | 3.54 | 2023-11-04 | 1 | 104.80 | 1 | 141.62 | 4 | SO47047 | 2023-11-11 | 11.33 | 104.80 | 141.62 | |||
| SO47008_39 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 230 | 426 | 6 | 2023-11-16 | 230.72 | 5.77 | 2023-11-04 | 8 | 29.08 | 1 | 230.72 | 39 | SO47008 | 2023-11-11 | 18.46 | 232.65 | 28.84 | |||
| SO45313_21 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 229 | 317 | 6 | 2023-05-19 | 144.20 | 3.61 | 2023-05-07 | 5 | 31.72 | 1 | 144.20 | 21 | SO45313 | 2023-05-14 | 11.54 | 158.62 | 28.84 | |||
| SO58932_26 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 463 | 408 | 6 | 2025-03-17 | 132.25 | 3.31 | 2025-03-05 | 9 | 9.16 | 1 | 132.25 | 26 | SO58932 | 2025-03-12 | 10.58 | 82.43 | 14.69 | |||
| SO51124_9 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 363 | 245 | 6 | 2024-10-15 | 4130.98 | 103.27 | 2024-10-03 | 3 | 1251.98 | 1 | 4130.98 | 9 | SO51124 | 2024-10-10 | 330.48 | 3755.94 | 1376.99 | |||
| SO57152_10 | 6C7E-4B58-93 | PO2030123828 | 19 | 284 | 363 | 661 | 6 | 2025-02-15 | 1376.99 | 34.42 | 2025-02-03 | 1 | 1251.98 | 1 | 1376.99 | 10 | SO57152 | 2025-02-10 | 110.16 | 1251.98 | 1376.99 | |||
| SO47380_29 | EF71-4036-91 | PO14790123967 | 19 | 291 | 460 | 497 | 6 | 2023-12-17 | 161.98 | 4.05 | 2023-12-05 | 3 | 37.12 | 1 | 161.98 | 29 | SO47380 | 2023-12-12 | 12.96 | 111.36 | 53.99 | |||
| SO44526_8 | 9F1A-4CE0-93 | PO11020190357 | 19 | 284 | 324 | 336 | 6 | 2023-02-16 | 838.92 | 20.97 | 2023-02-04 | 2 | 413.15 | 1 | 838.92 | 8 | SO44526 | 2023-02-11 | 67.11 | 826.29 | 419.46 | |||
| SO46330_2 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 215 | 118 | 6 | 2023-09-16 | 100.93 | 2.52 | 2023-09-04 | 5 | 12.03 | 1 | 100.93 | 2 | SO46330 | 2023-09-11 | 8.07 | 60.14 | 20.19 | |||
| SO44504_25 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 316 | 533 | 6 | 2023-02-16 | 1749.59 | 43.74 | 2023-02-04 | 2 | 884.71 | 1 | 1749.59 | 25 | SO44504 | 2023-02-11 | 139.97 | 1769.42 | 874.79 | |||
| SO48307_5 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 417 | 155 | 6 | 2024-03-17 | 1622.26 | 40.56 | 2024-03-05 | 5 | 300.12 | 1 | 1622.26 | 5 | SO48307 | 2024-03-12 | 129.78 | 1500.59 | 324.45 | |||
| SO44529_1 | EF3C-4FE3-85 | PO10556131826 | 19 | 284 | 326 | 534 | 6 | 2023-02-16 | 419.46 | 10.49 | 2023-02-04 | 1 | 413.15 | 1 | 419.46 | 1 | SO44529 | 2023-02-11 | 33.56 | 413.15 | 419.46 | |||
| SO51703_16 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 491 | 12 | 6 | 2024-11-15 | 129.58 | 3.24 | 2024-11-03 | 4 | 41.57 | 1 | 129.58 | 16 | SO51703 | 2024-11-10 | 10.37 | 166.29 | 32.39 |
Generated 2025-11-03 20:36:48.215 UTC