[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 2188 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO63136_7 | 0873-484A-AE | PO18328125904 | 19 | 284 | 606 | 552 | 6 | 2025-05-19 | 323.99 | 8.10 | 2025-05-07 | 1 | 343.65 | 1 | 323.99 | 7 | SO63136 | 2025-05-14 | 25.92 | 343.65 | 323.99 | |||
| SO46062_13 | 114A-41C0-B5 | PO11600112515 | 19 | 288 | 212 | 569 | 6 | 2023-08-17 | 40.37 | 1.01 | 2023-08-05 | 2 | 12.03 | 1 | 40.37 | 13 | SO46062 | 2023-08-12 | 3.23 | 24.06 | 20.19 | |||
| SO49052_27 | 8769-409E-94 | PO16733182723 | 19 | 291 | 339 | 533 | 6 | 2024-05-19 | 2348.97 | 58.72 | 2024-05-07 | 5 | 486.71 | 1 | 2348.97 | 27 | SO49052 | 2024-05-14 | 187.92 | 2433.53 | 469.79 | |||
| SO51818_30 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 527 | 100 | 6 | 2024-11-16 | 475.29 | 11.88 | 2024-11-04 | 3 | 144.59 | 1 | 475.29 | 30 | SO51818 | 2024-11-11 | 38.02 | 433.78 | 158.43 | |||
| SO69520_30 | 654B-484B-8F | PO4466144794 | 19 | 291 | 476 | 2 | 352 | 6 | 11.37 | 2025-08-17 | 568.32 | 13.92 | 2025-08-05 | 14 | 26.18 | 1 | 556.95 | 30 | SO69520 | 2025-08-12 | 44.56 | 366.47 | 40.59 | 0.02 |
| SO51096_6 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 581 | 514 | 6 | 2024-10-16 | 7144.16 | 178.60 | 2024-10-04 | 7 | 1082.51 | 1 | 7144.16 | 6 | SO51096 | 2024-10-11 | 571.53 | 7577.57 | 1020.59 | |||
| SO49485_21 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 377 | 155 | 6 | 2024-06-16 | 9162.56 | 229.06 | 2024-06-04 | 7 | 1320.68 | 1 | 9162.56 | 21 | SO49485 | 2024-06-11 | 733.01 | 9244.79 | 1308.94 | |||
| SO71829_21 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 532 | 685 | 6 | 2025-09-17 | 149.87 | 3.75 | 2025-09-05 | 1 | 136.79 | 1 | 149.87 | 21 | SO71829 | 2025-09-12 | 11.99 | 136.79 | 149.87 | |||
| SO48350_17 | 1505-4FEA-92 | PO1798152196 | 19 | 291 | 356 | 10 | 6 | 2024-03-18 | 4971.41 | 124.29 | 2024-03-06 | 4 | 1117.86 | 1 | 4971.41 | 17 | SO48350 | 2024-03-13 | 397.71 | 4471.42 | 1242.85 | |||
| SO45553_4 | 87C3-40D7-80 | PO1885177550 | 19 | 284 | 349 | 588 | 6 | 2023-06-17 | 10124.97 | 253.12 | 2023-06-05 | 5 | 1898.09 | 1 | 10124.97 | 4 | SO45553 | 2023-06-12 | 810.00 | 9490.47 | 2024.99 | |||
| SO55243_19 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 234 | 299 | 6 | 2025-01-16 | 239.95 | 6.00 | 2025-01-04 | 8 | 38.49 | 1 | 239.95 | 19 | SO55243 | 2025-01-11 | 19.20 | 307.94 | 29.99 | |||
| SO63128_9 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 560 | 64 | 6 | 2025-05-19 | 1457.82 | 36.45 | 2025-05-07 | 2 | 755.15 | 1 | 1457.82 | 9 | SO63128 | 2025-05-14 | 116.63 | 1510.30 | 728.91 | |||
| SO46940_19 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 383 | 479 | 6 | 2023-11-17 | 1200.53 | 30.01 | 2023-11-05 | 2 | 605.65 | 1 | 1200.53 | 19 | SO46940 | 2023-11-12 | 96.04 | 1211.30 | 600.26 | |||
| SO44765_6 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 262 | 156 | 6 | 2023-03-19 | 183.94 | 4.60 | 2023-03-07 | 1 | 181.49 | 1 | 183.94 | 6 | SO44765 | 2023-03-14 | 14.72 | 181.49 | 183.94 | |||
| SO71891_1 | A2BC-4140-A6 | PO7366158003 | 19 | 284 | 498 | 372 | 6 | 2025-09-17 | 602.35 | 15.06 | 2025-09-05 | 1 | 601.74 | 1 | 602.35 | 1 | SO71891 | 2025-09-12 | 48.19 | 601.74 | 602.35 | |||
| SO53572_3 | 21C2-4D78-95 | PO7366118504 | 19 | 284 | 563 | 14 | 372 | 6 | 381.45 | 2024-12-17 | 1907.26 | 38.15 | 2024-12-05 | 2 | 1481.94 | 1 | 1525.80 | 3 | SO53572 | 2024-12-12 | 122.06 | 2963.88 | 953.63 | 0.20 |
| SO57023_8 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 490 | 12 | 6 | 2025-02-16 | 259.15 | 6.48 | 2025-02-04 | 8 | 41.57 | 1 | 259.15 | 8 | SO57023 | 2025-02-11 | 20.73 | 332.58 | 32.39 | |||
| SO50265_13 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 375 | 479 | 6 | 2024-08-16 | 1308.94 | 32.72 | 2024-08-04 | 1 | 1320.68 | 1 | 1308.94 | 13 | SO50265 | 2024-08-11 | 104.72 | 1320.68 | 1308.94 | |||
| SO46614_47 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 460 | 299 | 6 | 2023-10-17 | 485.95 | 12.15 | 2023-10-05 | 9 | 37.12 | 1 | 485.95 | 47 | SO46614 | 2023-10-12 | 38.88 | 334.09 | 53.99 | |||
| SO50250_5 | D67C-4BB1-92 | PO2117115526 | 19 | 284 | 224 | 444 | 6 | 2024-08-16 | 5.19 | 0.13 | 2024-08-04 | 1 | 5.23 | 1 | 5.19 | 5 | SO50250 | 2024-08-11 | 0.41 | 5.23 | 5.19 | |||
| SO46614_35 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 245 | 299 | 6 | 2023-10-17 | 1561.64 | 39.04 | 2023-10-05 | 2 | 722.26 | 1 | 1561.64 | 35 | SO46614 | 2023-10-12 | 124.93 | 1444.51 | 780.82 | |||
| SO51793_2 | D763-4929-9B | PO18705168707 | 19 | 291 | 434 | 479 | 6 | 2024-11-16 | 713.80 | 17.84 | 2024-11-04 | 2 | 360.94 | 1 | 713.80 | 2 | SO51793 | 2024-11-11 | 57.10 | 721.89 | 356.90 | |||
| SO65164_30 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 488 | 118 | 6 | 2025-06-17 | 194.36 | 4.86 | 2025-06-05 | 6 | 41.57 | 1 | 194.36 | 30 | SO65164 | 2025-06-12 | 15.55 | 249.43 | 32.39 | |||
| SO47015_11 | 853D-4913-A7 | PO2117171072 | 19 | 284 | 356 | 444 | 6 | 2023-11-17 | 3728.56 | 93.21 | 2023-11-05 | 3 | 1117.86 | 1 | 3728.56 | 11 | SO47015 | 2023-11-12 | 298.28 | 3353.57 | 1242.85 | |||
| SO46330_9 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 232 | 118 | 6 | 2023-09-17 | 57.68 | 1.44 | 2023-09-05 | 2 | 31.72 | 1 | 57.68 | 9 | SO46330 | 2023-09-12 | 4.61 | 63.45 | 28.84 | |||
| SO46616_39 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 216 | 8 | 514 | 6 | 13.46 | 2023-10-17 | 134.58 | 3.03 | 2023-10-05 | 8 | 13.88 | 1 | 121.12 | 39 | SO46616 | 2023-10-12 | 9.69 | 111.03 | 16.82 | 0.10 |
| SO51740_4 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 234 | 677 | 6 | 2024-11-16 | 89.98 | 2.25 | 2024-11-04 | 3 | 38.49 | 1 | 89.98 | 4 | SO51740 | 2024-11-11 | 7.20 | 115.48 | 29.99 | |||
| SO46936_13 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 242 | 210 | 6 | 2023-11-17 | 780.82 | 19.52 | 2023-11-05 | 1 | 722.26 | 1 | 780.82 | 13 | SO46936 | 2023-11-12 | 62.47 | 722.26 | 780.82 | |||
| SO53536_24 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 225 | 118 | 6 | 2024-12-17 | 26.97 | 0.67 | 2024-12-05 | 5 | 6.92 | 1 | 26.97 | 24 | SO53536 | 2024-12-12 | 2.16 | 34.61 | 5.39 | |||
| SO55297_47 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 477 | 496 | 6 | 2025-01-16 | 11.98 | 0.30 | 2025-01-04 | 4 | 1.87 | 1 | 11.98 | 47 | SO55297 | 2025-01-11 | 0.96 | 7.47 | 2.99 | |||
| SO47366_39 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 459 | 155 | 6 | 2023-12-18 | 323.96 | 8.10 | 2023-12-06 | 6 | 37.12 | 1 | 323.96 | 39 | SO47366 | 2023-12-13 | 25.92 | 222.73 | 53.99 | |||
| SO49485_14 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 385 | 155 | 6 | 2024-06-16 | 3001.31 | 75.03 | 2024-06-04 | 5 | 605.65 | 1 | 3001.31 | 14 | SO49485 | 2024-06-11 | 240.11 | 3028.25 | 600.26 | |||
| SO71781_15 | 2FB9-4F05-82 | PO19401117806 | 19 | 291 | 390 | 173 | 6 | 2025-09-17 | 1344.59 | 33.61 | 2025-09-05 | 2 | 713.08 | 1 | 1344.59 | 15 | SO71781 | 2025-09-12 | 107.57 | 1426.16 | 672.29 | |||
| SO46334_2 | F652-4575-B7 | PO17574196050 | 19 | 272 | 307 | 678 | 6 | 2023-09-17 | 1445.19 | 36.13 | 2023-09-05 | 2 | 623.84 | 1 | 1445.19 | 2 | SO46334 | 2023-09-12 | 115.62 | 1247.68 | 722.59 | |||
| SO53535_11 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 575 | 154 | 6 | 2024-12-17 | 1430.44 | 35.76 | 2024-12-05 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO53535 | 2024-12-12 | 114.44 | 1481.94 | 1430.44 | |||
| SO71808_10 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 570 | 408 | 6 | 2025-09-17 | 445.41 | 11.14 | 2025-09-05 | 1 | 461.44 | 1 | 445.41 | 10 | SO71808 | 2025-09-12 | 35.63 | 461.44 | 445.41 | |||
| SO51793_13 | D763-4929-9B | PO18705168707 | 19 | 291 | 545 | 479 | 6 | 2024-11-16 | 24.29 | 0.61 | 2024-11-04 | 1 | 17.98 | 1 | 24.29 | 13 | SO51793 | 2024-11-11 | 1.94 | 17.98 | 24.29 | |||
| SO58911_5 | C991-4920-91 | PO19401135315 | 19 | 291 | 434 | 173 | 6 | 2025-03-18 | 713.80 | 17.84 | 2025-03-06 | 2 | 360.94 | 1 | 713.80 | 5 | SO58911 | 2025-03-13 | 57.10 | 721.89 | 356.90 | |||
| SO65164_28 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 524 | 118 | 6 | 2025-06-17 | 158.43 | 3.96 | 2025-06-05 | 1 | 144.59 | 1 | 158.43 | 28 | SO65164 | 2025-06-12 | 12.67 | 144.59 | 158.43 | |||
| SO47963_3 | 9A95-4541-91 | PO19691179567 | 19 | 291 | 358 | 353 | 6 | 2024-02-17 | 2458.92 | 61.47 | 2024-02-05 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO47963 | 2024-02-12 | 196.71 | 2211.62 | 1229.46 | |||
| SO58932_23 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 467 | 408 | 6 | 2025-03-18 | 29.39 | 0.73 | 2025-03-06 | 2 | 9.16 | 1 | 29.39 | 23 | SO58932 | 2025-03-13 | 2.35 | 18.32 | 14.69 | |||
| SO46616_63 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 242 | 514 | 6 | 2023-10-17 | 3123.27 | 78.08 | 2023-10-05 | 4 | 722.26 | 1 | 3123.27 | 63 | SO46616 | 2023-10-12 | 249.86 | 2889.03 | 780.82 | |||
| SO71871_4 | DD8F-4CAB-A1 | PO14239120760 | 19 | 291 | 491 | 550 | 6 | 2025-09-17 | 226.76 | 5.67 | 2025-09-05 | 7 | 41.57 | 1 | 226.76 | 4 | SO71871 | 2025-09-12 | 18.14 | 291.01 | 32.39 | |||
| SO46657_43 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 428 | 496 | 6 | 2023-10-17 | 1255.54 | 31.39 | 2023-10-05 | 6 | 185.82 | 1 | 1255.54 | 43 | SO46657 | 2023-10-12 | 100.44 | 1114.92 | 209.26 | |||
| SO63132_15 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 374 | 479 | 6 | 2025-05-19 | 2932.02 | 73.30 | 2025-05-07 | 2 | 1554.95 | 1 | 2932.02 | 15 | SO63132 | 2025-05-14 | 234.56 | 3109.90 | 1466.01 | |||
| SO50735_4 | 915C-46CF-8E | PO2001132307 | 19 | 291 | 280 | 701 | 6 | 2024-09-16 | 183.94 | 4.60 | 2024-09-04 | 1 | 170.14 | 1 | 183.94 | 4 | SO50735 | 2024-09-11 | 14.72 | 170.14 | 183.94 | |||
| SO53513_30 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 471 | 4 | 281 | 6 | 79.38 | 2024-12-17 | 793.75 | 17.86 | 2024-12-05 | 25 | 23.75 | 1 | 714.38 | 30 | SO53513 | 2024-12-12 | 57.15 | 593.73 | 31.75 | 0.10 |
| SO48287_1 | 7A9E-45FF-8B | PO493197818 | 19 | 291 | 415 | 654 | 6 | 2024-03-18 | 198.04 | 4.95 | 2024-03-06 | 1 | 146.55 | 1 | 198.04 | 1 | SO48287 | 2024-03-13 | 15.84 | 146.55 | 198.04 | |||
| SO67316_31 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 517 | 496 | 6 | 2025-07-18 | 31.58 | 0.79 | 2025-07-06 | 1 | 23.37 | 1 | 31.58 | 31 | SO67316 | 2025-07-13 | 2.53 | 23.37 | 31.58 | |||
| SO46064_6 | EC45-4C82-8B | PO11020129544 | 19 | 284 | 322 | 336 | 6 | 2023-08-17 | 2097.29 | 52.43 | 2023-08-05 | 5 | 413.15 | 1 | 2097.29 | 6 | SO46064 | 2023-08-12 | 167.78 | 2065.73 | 419.46 | |||
| SO47973_20 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 387 | 479 | 6 | 2024-02-17 | 1200.53 | 30.01 | 2024-02-05 | 2 | 605.65 | 1 | 1200.53 | 20 | SO47973 | 2024-02-12 | 96.04 | 1211.30 | 600.26 | |||
| SO58932_32 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 217 | 3 | 408 | 6 | 16.36 | 2025-03-18 | 327.16 | 7.77 | 2025-03-06 | 17 | 13.09 | 1 | 310.80 | 32 | SO58932 | 2025-03-13 | 24.86 | 222.47 | 19.24 | 0.05 |
| SO46658_1 | F375-4C62-AB | PO4930144247 | 19 | 291 | 399 | 425 | 6 | 2023-10-17 | 135.10 | 3.38 | 2023-10-05 | 4 | 24.99 | 1 | 135.10 | 1 | SO46658 | 2023-10-12 | 10.81 | 99.97 | 33.77 | |||
| SO53510_3 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 398 | 685 | 6 | 2024-12-17 | 26.72 | 0.67 | 2024-12-05 | 1 | 19.78 | 1 | 26.72 | 3 | SO53510 | 2024-12-12 | 2.14 | 19.78 | 26.72 | |||
| SO58918_27 | C811-4D40-80 | PO17574131484 | 19 | 291 | 544 | 678 | 6 | 2025-03-18 | 291.56 | 7.29 | 2025-03-06 | 6 | 35.96 | 1 | 291.56 | 27 | SO58918 | 2025-03-13 | 23.33 | 215.76 | 48.59 | |||
| SO58957_17 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 544 | 685 | 6 | 2025-03-18 | 48.59 | 1.21 | 2025-03-06 | 1 | 35.96 | 1 | 48.59 | 17 | SO58957 | 2025-03-13 | 3.89 | 35.96 | 48.59 | |||
| SO53536_51 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 217 | 2 | 118 | 6 | 5.68 | 2024-12-17 | 284.12 | 6.96 | 2024-12-05 | 14 | 13.09 | 1 | 278.44 | 51 | SO53536 | 2024-12-12 | 22.27 | 183.21 | 20.29 | 0.02 |
| SO58981_4 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 217 | 118 | 6 | 2025-03-18 | 209.94 | 5.25 | 2025-03-06 | 10 | 13.09 | 1 | 209.94 | 4 | SO58981 | 2025-03-13 | 16.80 | 130.86 | 20.99 | |||
| SO46938_1 | 2E58-4440-89 | PO19198122384 | 19 | 291 | 358 | 653 | 6 | 2023-11-17 | 4917.84 | 122.95 | 2023-11-05 | 4 | 1105.81 | 1 | 4917.84 | 1 | SO46938 | 2023-11-12 | 393.43 | 4423.24 | 1229.46 | |||
| SO46332_10 | E23A-485D-A3 | PO17690199814 | 19 | 288 | 346 | 7 | 47 | 6 | 297.50 | 2023-09-17 | 850.00 | 13.81 | 2023-09-05 | 1 | 1912.15 | 1 | 552.50 | 10 | SO46332 | 2023-09-12 | 44.20 | 1912.15 | 850.00 | 0.35 |
| SO46953_42 | C650-4C32-BE | PO17603154442 | 19 | 284 | 224 | 3 | 12 | 6 | 3.80 | 2023-11-17 | 76.07 | 1.81 | 2023-11-05 | 16 | 5.23 | 1 | 72.27 | 42 | SO46953 | 2023-11-12 | 5.78 | 83.68 | 4.75 | 0.05 |
| SO63266_7 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 353 | 352 | 6 | 2025-05-19 | 2783.99 | 69.60 | 2025-05-07 | 2 | 1265.62 | 1 | 2783.99 | 7 | SO63266 | 2025-05-14 | 222.72 | 2531.24 | 1391.99 |
Generated 2025-11-04 04:21:38.218 UTC