[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 621 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49827_34 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 415 | 299 | 6 | 2024-07-19 | 198.04 | 4.95 | 2024-07-07 | 1 | 146.55 | 1 | 198.04 | 34 | SO49827 | 2024-07-14 | 15.84 | 146.55 | 198.04 | |||
| SO44749_29 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 320 | 155 | 6 | 2023-03-21 | 419.46 | 10.49 | 2023-03-09 | 1 | 413.15 | 1 | 419.46 | 29 | SO44749 | 2023-03-16 | 33.56 | 413.15 | 419.46 | |||
| SO53465_8 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 531 | 678 | 6 | 2024-12-19 | 749.37 | 18.73 | 2024-12-07 | 5 | 136.79 | 1 | 749.37 | 8 | SO53465 | 2024-12-14 | 59.95 | 683.93 | 149.87 | |||
| SO57154_18 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 503 | 263 | 6 | 2025-02-18 | 600.16 | 15.00 | 2025-02-06 | 3 | 199.85 | 1 | 600.16 | 18 | SO57154 | 2025-02-13 | 48.01 | 599.56 | 200.05 | |||
| SO50295_14 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 410 | 352 | 6 | 2024-08-18 | 72.89 | 1.82 | 2024-08-06 | 2 | 26.97 | 1 | 72.89 | 14 | SO50295 | 2024-08-13 | 5.83 | 53.94 | 36.45 | |||
| SO61179_15 | 1443-4268-AC | PO18444157069 | 19 | 291 | 583 | 227 | 6 | 2025-04-20 | 5102.97 | 127.57 | 2025-04-08 | 5 | 1082.51 | 1 | 5102.97 | 15 | SO61179 | 2025-04-15 | 408.24 | 5412.55 | 1020.59 | |||
| SO55297_12 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 237 | 496 | 6 | 2025-01-18 | 89.98 | 2.25 | 2025-01-06 | 3 | 38.49 | 1 | 89.98 | 12 | SO55297 | 2025-01-13 | 7.20 | 115.48 | 29.99 | |||
| SO69401_22 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 491 | 3 | 12 | 6 | 23.76 | 2025-08-19 | 475.11 | 11.28 | 2025-08-07 | 16 | 41.57 | 1 | 451.36 | 22 | SO69401 | 2025-08-14 | 36.11 | 665.16 | 29.69 | 0.05 |
| SO44498_12 | 7715-4053-B5 | PO17748167942 | 19 | 284 | 315 | 102 | 6 | 2023-02-19 | 874.79 | 21.87 | 2023-02-07 | 1 | 884.71 | 1 | 874.79 | 12 | SO44498 | 2023-02-14 | 69.98 | 884.71 | 874.79 | |||
| SO48350_14 | 1505-4FEA-92 | PO1798152196 | 19 | 291 | 401 | 10 | 6 | 2024-03-20 | 196.81 | 4.92 | 2024-03-08 | 3 | 48.55 | 1 | 196.81 | 14 | SO48350 | 2024-03-15 | 15.74 | 145.64 | 65.60 | |||
| SO46086_25 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 220 | 84 | 6 | 2023-08-19 | 141.31 | 3.53 | 2023-08-07 | 7 | 12.03 | 1 | 141.31 | 25 | SO46086 | 2023-08-14 | 11.30 | 84.19 | 20.19 | |||
| SO48761_22 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 435 | 299 | 6 | 2024-04-20 | 324.45 | 8.11 | 2024-04-08 | 1 | 300.12 | 1 | 324.45 | 22 | SO48761 | 2024-04-15 | 25.96 | 300.12 | 324.45 | |||
| SO71869_1 | F7E5-49CA-8C | PO14877155420 | 19 | 291 | 556 | 172 | 6 | 2025-09-19 | 105.29 | 2.63 | 2025-09-07 | 1 | 77.92 | 1 | 105.29 | 1 | SO71869 | 2025-09-14 | 8.42 | 77.92 | 105.29 | |||
| SO46044_24 | 029B-4675-9A | PO16733123313 | 19 | 288 | 220 | 533 | 6 | 2023-08-19 | 40.37 | 1.01 | 2023-08-07 | 2 | 12.03 | 1 | 40.37 | 24 | SO46044 | 2023-08-14 | 3.23 | 24.06 | 20.19 | |||
| SO48299_1 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 367 | 118 | 6 | 2024-03-20 | 647.99 | 16.20 | 2024-03-08 | 1 | 598.44 | 1 | 647.99 | 1 | SO48299 | 2024-03-15 | 51.84 | 598.44 | 647.99 | |||
| SO57188_30 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 474 | 100 | 6 | 2025-02-18 | 251.96 | 6.30 | 2025-02-06 | 6 | 26.18 | 1 | 251.96 | 30 | SO57188 | 2025-02-13 | 20.16 | 157.06 | 41.99 | |||
| SO71828_4 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 507 | 48 | 6 | 2025-09-19 | 400.10 | 10.00 | 2025-09-07 | 2 | 199.85 | 1 | 400.10 | 4 | SO71828 | 2025-09-14 | 32.01 | 399.70 | 200.05 | |||
| SO51132_34 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 481 | 227 | 6 | 2024-10-18 | 5.39 | 0.13 | 2024-10-06 | 1 | 3.36 | 1 | 5.39 | 34 | SO51132 | 2024-10-13 | 0.43 | 3.36 | 5.39 | |||
| SO49855_18 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 454 | 442 | 6 | 2024-07-19 | 143.98 | 3.60 | 2024-07-07 | 4 | 24.75 | 1 | 143.98 | 18 | SO49855 | 2024-07-14 | 11.52 | 98.98 | 35.99 | |||
| SO46064_2 | EC45-4C82-8B | PO11020129544 | 19 | 284 | 319 | 336 | 6 | 2023-08-19 | 3499.18 | 87.48 | 2023-08-07 | 4 | 884.71 | 1 | 3499.18 | 2 | SO46064 | 2023-08-14 | 279.93 | 3538.83 | 874.79 | |||
| SO47037_50 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 213 | 84 | 6 | 2023-11-19 | 161.49 | 4.04 | 2023-11-07 | 8 | 13.88 | 1 | 161.49 | 50 | SO47037 | 2023-11-14 | 12.92 | 111.03 | 20.19 | |||
| SO53484_18 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 543 | 497 | 6 | 2024-12-19 | 37.25 | 0.93 | 2024-12-07 | 1 | 27.57 | 1 | 37.25 | 18 | SO53484 | 2024-12-14 | 2.98 | 27.57 | 37.25 | |||
| SO46959_4 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 459 | 533 | 6 | 2023-11-19 | 323.96 | 8.10 | 2023-11-07 | 6 | 37.12 | 1 | 323.96 | 4 | SO46959 | 2023-11-14 | 25.92 | 222.73 | 53.99 | |||
| SO61222_7 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 599 | 119 | 6 | 2025-04-20 | 323.99 | 8.10 | 2025-04-08 | 1 | 294.58 | 1 | 323.99 | 7 | SO61222 | 2025-04-15 | 25.92 | 294.58 | 323.99 | |||
| SO50242_36 | A651-4343-86 | PO1595193228 | 19 | 284 | 368 | 426 | 6 | 2024-08-18 | 1466.01 | 36.65 | 2024-08-06 | 1 | 1518.79 | 1 | 1466.01 | 36 | SO50242 | 2024-08-13 | 117.28 | 1518.79 | 1466.01 | |||
| SO53536_25 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 475 | 118 | 6 | 2024-12-19 | 83.99 | 2.10 | 2024-12-07 | 2 | 26.18 | 1 | 83.99 | 25 | SO53536 | 2024-12-14 | 6.72 | 52.35 | 41.99 | |||
| SO69479_37 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 482 | 552 | 6 | 2025-08-19 | 16.18 | 0.40 | 2025-08-07 | 3 | 3.36 | 1 | 16.18 | 37 | SO69479 | 2025-08-14 | 1.29 | 10.09 | 5.39 | |||
| SO57188_25 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 309 | 100 | 6 | 2025-02-18 | 818.70 | 20.47 | 2025-02-06 | 1 | 747.20 | 1 | 818.70 | 25 | SO57188 | 2025-02-13 | 65.50 | 747.20 | 818.70 | |||
| SO51096_19 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 582 | 514 | 6 | 2024-10-18 | 1020.59 | 25.51 | 2024-10-06 | 1 | 1082.51 | 1 | 1020.59 | 19 | SO51096 | 2024-10-13 | 81.65 | 1082.51 | 1020.59 | |||
| SO63174_5 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 605 | 317 | 6 | 2025-05-21 | 1619.97 | 40.50 | 2025-05-09 | 5 | 343.65 | 1 | 1619.97 | 5 | SO63174 | 2025-05-16 | 129.60 | 1718.25 | 323.99 | |||
| SO65264_1 | 296E-492E-8B | PO12818156002 | 19 | 291 | 376 | 587 | 6 | 2025-06-19 | 2932.02 | 73.30 | 2025-06-07 | 2 | 1554.95 | 1 | 2932.02 | 1 | SO65264 | 2025-06-14 | 234.56 | 3109.90 | 1466.01 | |||
| SO58911_16 | C991-4920-91 | PO19401135315 | 19 | 291 | 384 | 173 | 6 | 2025-03-20 | 672.29 | 16.81 | 2025-03-08 | 1 | 713.08 | 1 | 672.29 | 16 | SO58911 | 2025-03-15 | 53.78 | 713.08 | 672.29 | |||
| 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 | |||
| SO58978_3 | 3AD0-4CD8-97 | PO18531185017 | 19 | 284 | 474 | 2 | 613 | 6 | 9.74 | 2025-03-20 | 487.13 | 11.93 | 2025-03-08 | 12 | 26.18 | 1 | 477.39 | 3 | SO58978 | 2025-03-15 | 38.19 | 314.12 | 40.59 | 0.02 |
| SO49848_22 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 365 | 245 | 6 | 2024-07-19 | 3239.97 | 81.00 | 2024-07-07 | 5 | 598.44 | 1 | 3239.97 | 22 | SO49848 | 2024-07-14 | 259.20 | 2992.18 | 647.99 | |||
| SO43898_21 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 285 | 84 | 6 | 2022-11-19 | 357.16 | 8.93 | 2022-11-07 | 2 | 176.20 | 1 | 357.16 | 21 | SO43898 | 2022-11-14 | 28.57 | 352.40 | 178.58 | |||
| SO69540_22 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 502 | 263 | 6 | 2025-08-19 | 400.10 | 10.00 | 2025-08-07 | 2 | 199.85 | 1 | 400.10 | 22 | SO69540 | 2025-08-14 | 32.01 | 399.70 | 200.05 | |||
| SO57093_38 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 484 | 479 | 6 | 2025-02-18 | 14.31 | 0.36 | 2025-02-06 | 3 | 2.97 | 1 | 14.31 | 38 | SO57093 | 2025-02-13 | 1.14 | 8.92 | 4.77 | |||
| SO58980_29 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 586 | 154 | 6 | 2025-03-20 | 890.82 | 22.27 | 2025-03-08 | 2 | 461.44 | 1 | 890.82 | 29 | SO58980 | 2025-03-15 | 71.27 | 922.89 | 445.41 | |||
| SO50664_16 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 460 | 173 | 6 | 2024-09-18 | 107.99 | 2.70 | 2024-09-06 | 2 | 37.12 | 1 | 107.99 | 16 | SO50664 | 2024-09-13 | 8.64 | 74.24 | 53.99 | |||
| SO51704_32 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 564 | 14 | 264 | 6 | 190.73 | 2024-11-18 | 953.63 | 19.07 | 2024-11-06 | 1 | 1481.94 | 1 | 762.90 | 32 | SO51704 | 2024-11-13 | 61.03 | 1481.94 | 953.63 | 0.20 |
| SO47673_16 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 399 | 119 | 6 | 2024-01-19 | 33.77 | 0.84 | 2024-01-07 | 1 | 24.99 | 1 | 33.77 | 16 | SO47673 | 2024-01-14 | 2.70 | 24.99 | 33.77 | |||
| SO63266_21 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 590 | 352 | 6 | 2025-05-21 | 1385.08 | 34.63 | 2025-05-09 | 3 | 419.78 | 1 | 1385.08 | 21 | SO63266 | 2025-05-16 | 110.81 | 1259.34 | 461.69 | |||
| SO47000_5 | 4946-4EC7-8D | PO10469179014 | 19 | 291 | 468 | 335 | 6 | 2023-11-19 | 45.59 | 1.14 | 2023-11-07 | 2 | 15.67 | 1 | 45.59 | 5 | SO47000 | 2023-11-14 | 3.65 | 31.34 | 22.79 | |||
| SO45781_23 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 238 | 227 | 6 | 2023-07-20 | 3032.30 | 75.81 | 2023-07-08 | 4 | 747.97 | 1 | 3032.30 | 23 | SO45781 | 2023-07-15 | 242.58 | 2991.87 | 758.08 | |||
| SO49480_12 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 335 | 173 | 6 | 2024-06-18 | 469.79 | 11.74 | 2024-06-06 | 1 | 486.71 | 1 | 469.79 | 12 | SO49480 | 2024-06-13 | 37.58 | 486.71 | 469.79 | |||
| SO48306_20 | EA27-471A-9D | PO17574166075 | 19 | 291 | 421 | 678 | 6 | 2024-03-20 | 785.32 | 19.63 | 2024-03-08 | 4 | 145.28 | 1 | 785.32 | 20 | SO48306 | 2024-03-15 | 62.83 | 581.13 | 196.33 | |||
| SO57093_37 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 374 | 479 | 6 | 2025-02-18 | 4398.03 | 109.95 | 2025-02-06 | 3 | 1554.95 | 1 | 4398.03 | 37 | SO57093 | 2025-02-13 | 351.84 | 4664.84 | 1466.01 | |||
| SO44300_2 | 5132-4204-BB | PO10527120063 | 19 | 284 | 232 | 480 | 6 | 2023-01-19 | 57.68 | 1.44 | 2023-01-07 | 2 | 31.72 | 1 | 57.68 | 2 | SO44300 | 2023-01-14 | 4.61 | 63.45 | 28.84 | |||
| SO44773_2 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 322 | 460 | 6 | 2023-03-21 | 4194.59 | 104.86 | 2023-03-09 | 10 | 413.15 | 1 | 4194.59 | 2 | SO44773 | 2023-03-16 | 335.57 | 4131.46 | 419.46 | |||
| SO48059_42 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 286 | 84 | 6 | 2024-02-19 | 551.81 | 13.80 | 2024-02-07 | 3 | 170.14 | 1 | 551.81 | 42 | SO48059 | 2024-02-14 | 44.15 | 510.43 | 183.94 | |||
| SO57022_9 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 482 | 101 | 6 | 2025-02-18 | 16.18 | 0.40 | 2025-02-06 | 3 | 3.36 | 1 | 16.18 | 9 | SO57022 | 2025-02-13 | 1.29 | 10.09 | 5.39 | |||
| SO45306_6 | F836-4C32-8D | PO11020195551 | 19 | 284 | 315 | 336 | 6 | 2023-05-22 | 874.79 | 21.87 | 2023-05-10 | 1 | 884.71 | 1 | 874.79 | 6 | SO45306 | 2023-05-17 | 69.98 | 884.71 | 874.79 | |||
| SO53510_3 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 398 | 685 | 6 | 2024-12-19 | 26.72 | 0.67 | 2024-12-07 | 1 | 19.78 | 1 | 26.72 | 3 | SO53510 | 2024-12-14 | 2.14 | 19.78 | 26.72 | |||
| SO51700_3 | 6837-439E-BC | PO17806126316 | 19 | 291 | 487 | 101 | 6 | 2024-11-18 | 131.98 | 3.30 | 2024-11-06 | 4 | 20.57 | 1 | 131.98 | 3 | SO51700 | 2024-11-13 | 10.56 | 82.27 | 32.99 | |||
| SO65189_25 | 985E-4937-94 | PO14761195376 | 19 | 284 | 491 | 408 | 6 | 2025-06-19 | 161.97 | 4.05 | 2025-06-07 | 5 | 41.57 | 1 | 161.97 | 25 | SO65189 | 2025-06-14 | 12.96 | 207.86 | 32.39 | |||
| SO53527_52 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 544 | 10 | 6 | 2024-12-19 | 194.38 | 4.86 | 2024-12-07 | 4 | 35.96 | 1 | 194.38 | 52 | SO53527 | 2024-12-14 | 15.55 | 143.84 | 48.59 | |||
| SO57154_5 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 225 | 263 | 6 | 2025-02-18 | 32.36 | 0.81 | 2025-02-06 | 6 | 6.92 | 1 | 32.36 | 5 | SO57154 | 2025-02-13 | 2.59 | 41.53 | 5.39 | |||
| SO46657_23 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 236 | 496 | 6 | 2023-10-19 | 86.52 | 2.16 | 2023-10-07 | 3 | 29.08 | 1 | 86.52 | 23 | SO46657 | 2023-10-14 | 6.92 | 87.24 | 28.84 | |||
| SO57019_17 | D018-44A0-BF | PO18879140423 | 19 | 291 | 570 | 64 | 6 | 2025-02-18 | 1781.64 | 44.54 | 2025-02-06 | 4 | 461.44 | 1 | 1781.64 | 17 | SO57019 | 2025-02-13 | 142.53 | 1845.78 | 445.41 | |||
| SO61196_13 | 8DD6-4DC9-A5 | PO1711193720 | 19 | 291 | 398 | 245 | 6 | 2025-04-20 | 80.17 | 2.00 | 2025-04-08 | 3 | 19.78 | 1 | 80.17 | 13 | SO61196 | 2025-04-15 | 6.41 | 59.33 | 26.72 | |||
| SO67302_19 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 298 | 442 | 6 | 2025-07-20 | 2429.28 | 60.73 | 2025-07-08 | 3 | 739.04 | 1 | 2429.28 | 19 | SO67302 | 2025-07-15 | 194.34 | 2217.12 | 809.76 |
Generated 2025-11-06 07:30:49.514 UTC