[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 1813 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47366_13 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 325 | 155 | 6 | 2023-12-18 | 2818.76 | 70.47 | 2023-12-06 | 6 | 486.71 | 1 | 2818.76 | 13 | SO47366 | 2023-12-13 | 225.50 | 2920.24 | 469.79 | |||
| SO51772_31 | 7800-4280-A7 | PO1827195162 | 19 | 291 | 480 | 317 | 6 | 2024-11-16 | 6.87 | 0.17 | 2024-11-04 | 5 | 0.86 | 1 | 6.87 | 31 | SO51772 | 2024-11-11 | 0.55 | 4.28 | 1.37 | |||
| SO47673_16 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 399 | 119 | 6 | 2024-01-17 | 33.77 | 0.84 | 2024-01-05 | 1 | 24.99 | 1 | 33.77 | 16 | SO47673 | 2024-01-12 | 2.70 | 24.99 | 33.77 | |||
| SO47973_27 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 321 | 479 | 6 | 2024-02-17 | 939.59 | 23.49 | 2024-02-05 | 2 | 486.71 | 1 | 939.59 | 27 | SO47973 | 2024-02-12 | 75.17 | 973.41 | 469.79 | |||
| SO67268_5 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 390 | 299 | 6 | 2025-07-18 | 672.29 | 16.81 | 2025-07-06 | 1 | 713.08 | 1 | 672.29 | 5 | SO67268 | 2025-07-13 | 53.78 | 713.08 | 672.29 | |||
| SO44086_13 | B4B4-44C7-84 | PO17574175064 | 19 | 288 | 307 | 678 | 6 | 2022-12-18 | 2167.78 | 54.19 | 2022-12-06 | 3 | 623.84 | 1 | 2167.78 | 13 | SO44086 | 2022-12-13 | 173.42 | 1871.52 | 722.59 | |||
| SO51769_21 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 374 | 426 | 6 | 2024-11-16 | 2932.02 | 73.30 | 2024-11-04 | 2 | 1554.95 | 1 | 2932.02 | 21 | SO51769 | 2024-11-11 | 234.56 | 3109.90 | 1466.01 | |||
| SO46330_13 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 307 | 118 | 6 | 2023-09-17 | 1445.19 | 36.13 | 2023-09-05 | 2 | 623.84 | 1 | 1445.19 | 13 | SO46330 | 2023-09-12 | 115.62 | 1247.68 | 722.59 | |||
| SO44283_26 | D5FF-488D-B7 | PO18444150042 | 19 | 288 | 315 | 227 | 6 | 2023-01-17 | 5248.76 | 131.22 | 2023-01-05 | 6 | 884.71 | 1 | 5248.76 | 26 | SO44283 | 2023-01-12 | 419.90 | 5308.25 | 874.79 | |||
| SO58958_38 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 214 | 281 | 6 | 2025-03-18 | 83.98 | 2.10 | 2025-03-06 | 4 | 13.09 | 1 | 83.98 | 38 | SO58958 | 2025-03-13 | 6.72 | 52.35 | 20.99 | |||
| SO53464_8 | E113-419B-8F | PO17545119283 | 19 | 291 | 378 | 155 | 6 | 2024-12-17 | 7330.05 | 183.25 | 2024-12-05 | 5 | 1554.95 | 1 | 7330.05 | 8 | SO53464 | 2024-12-12 | 586.40 | 7774.74 | 1466.01 | |||
| SO46608_25 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 462 | 442 | 6 | 2023-10-17 | 98.90 | 2.47 | 2023-10-05 | 7 | 9.71 | 1 | 98.90 | 25 | SO46608 | 2023-10-12 | 7.91 | 68.00 | 14.13 | |||
| SO55297_39 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 295 | 496 | 6 | 2025-01-16 | 818.70 | 20.47 | 2025-01-04 | 1 | 747.20 | 1 | 818.70 | 39 | SO55297 | 2025-01-11 | 65.50 | 747.20 | 818.70 | |||
| SO71853_6 | C03F-40A4-B6 | PO18531164420 | 19 | 284 | 477 | 613 | 6 | 2025-09-17 | 11.98 | 0.30 | 2025-09-05 | 4 | 1.87 | 1 | 11.98 | 6 | SO71853 | 2025-09-12 | 0.96 | 7.47 | 2.99 | |||
| SO48754_10 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 445 | 442 | 6 | 2024-04-18 | 107.98 | 2.70 | 2024-04-06 | 3 | 24.75 | 1 | 107.98 | 10 | SO48754 | 2024-04-13 | 8.64 | 74.24 | 35.99 | |||
| SO57122_4 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 482 | 84 | 6 | 2025-02-16 | 32.36 | 0.81 | 2025-02-04 | 6 | 3.36 | 1 | 32.36 | 4 | SO57122 | 2025-02-11 | 2.59 | 20.17 | 5.39 | |||
| SO47668_26 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 368 | 299 | 6 | 2024-01-17 | 5864.04 | 146.60 | 2024-01-05 | 4 | 1518.79 | 1 | 5864.04 | 26 | SO47668 | 2024-01-12 | 469.12 | 6075.15 | 1466.01 | |||
| SO53527_10 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 515 | 10 | 6 | 2024-12-17 | 48.82 | 1.22 | 2024-12-05 | 3 | 12.04 | 1 | 48.82 | 10 | SO53527 | 2024-12-12 | 3.91 | 36.12 | 16.27 | |||
| SO48768_12 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 356 | 119 | 6 | 2024-04-18 | 2485.70 | 62.14 | 2024-04-06 | 2 | 1117.86 | 1 | 2485.70 | 12 | SO48768 | 2024-04-13 | 198.86 | 2235.71 | 1242.85 | |||
| SO45786_24 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 342 | 2 | 514 | 6 | 105.42 | 2023-07-18 | 5271.20 | 129.14 | 2023-07-06 | 13 | 413.15 | 1 | 5165.78 | 24 | SO45786 | 2023-07-13 | 413.26 | 5370.90 | 405.48 | 0.02 |
| SO57159_1 | DDBB-4887-AA | PO2262133775 | 19 | 291 | 573 | 629 | 6 | 2025-02-16 | 2860.88 | 71.52 | 2025-02-04 | 2 | 1481.94 | 1 | 2860.88 | 1 | SO57159 | 2025-02-11 | 228.87 | 2963.88 | 1430.44 | |||
| SO67316_19 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 532 | 496 | 6 | 2025-07-18 | 1049.12 | 26.23 | 2025-07-06 | 7 | 136.79 | 1 | 1049.12 | 19 | SO67316 | 2025-07-13 | 83.93 | 957.50 | 149.87 | |||
| SO45522_11 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 317 | 173 | 6 | 2023-06-17 | 874.79 | 21.87 | 2023-06-05 | 1 | 884.71 | 1 | 874.79 | 11 | SO45522 | 2023-06-12 | 69.98 | 884.71 | 874.79 | |||
| SO48340_10 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 356 | 685 | 6 | 2024-03-18 | 4971.41 | 124.29 | 2024-03-06 | 4 | 1117.86 | 1 | 4971.41 | 10 | SO48340 | 2024-03-13 | 397.71 | 4471.42 | 1242.85 | |||
| SO58980_12 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 497 | 154 | 6 | 2025-03-18 | 602.35 | 15.06 | 2025-03-06 | 1 | 601.74 | 1 | 602.35 | 12 | SO58980 | 2025-03-13 | 48.19 | 601.74 | 602.35 | |||
| SO51793_31 | D763-4929-9B | PO18705168707 | 19 | 291 | 482 | 479 | 6 | 2024-11-16 | 43.15 | 1.08 | 2024-11-04 | 8 | 3.36 | 1 | 43.15 | 31 | SO51793 | 2024-11-11 | 3.45 | 26.90 | 5.39 | |||
| SO61196_17 | 8DD6-4DC9-A5 | PO1711193720 | 19 | 291 | 524 | 245 | 6 | 2025-04-18 | 633.72 | 15.84 | 2025-04-06 | 4 | 144.59 | 1 | 633.72 | 17 | SO61196 | 2025-04-13 | 50.70 | 578.38 | 158.43 | |||
| SO57122_6 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 374 | 84 | 6 | 2025-02-16 | 1466.01 | 36.65 | 2025-02-04 | 1 | 1554.95 | 1 | 1466.01 | 6 | SO57122 | 2025-02-11 | 117.28 | 1554.95 | 1466.01 | |||
| SO65163_8 | 6062-4B82-A4 | PO18502160930 | 19 | 291 | 506 | 154 | 6 | 2025-06-17 | 200.05 | 5.00 | 2025-06-05 | 1 | 199.85 | 1 | 200.05 | 8 | SO65163 | 2025-06-12 | 16.00 | 199.85 | 200.05 | |||
| SO47966_6 | 86D0-4101-B5 | PO19227154269 | 19 | 284 | 343 | 210 | 6 | 2024-02-17 | 939.59 | 23.49 | 2024-02-05 | 2 | 486.71 | 1 | 939.59 | 6 | SO47966 | 2024-02-12 | 75.17 | 973.41 | 469.79 | |||
| SO46930_16 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 399 | 65 | 6 | 2023-11-17 | 33.77 | 0.84 | 2023-11-05 | 1 | 24.99 | 1 | 33.77 | 16 | SO46930 | 2023-11-12 | 2.70 | 24.99 | 33.77 | |||
| SO69538_4 | 631A-4D82-A8 | PO2117162793 | 19 | 284 | 359 | 444 | 6 | 2025-08-17 | 4130.98 | 103.27 | 2025-08-05 | 3 | 1251.98 | 1 | 4130.98 | 4 | SO69538 | 2025-08-12 | 330.48 | 3755.94 | 1376.99 | |||
| SO48351_2 | 0478-43AC-AB | PO1885129829 | 19 | 284 | 356 | 588 | 6 | 2024-03-18 | 3728.56 | 93.21 | 2024-03-06 | 3 | 1117.86 | 1 | 3728.56 | 2 | SO48351 | 2024-03-13 | 298.28 | 3353.57 | 1242.85 | |||
| SO71828_3 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 492 | 48 | 6 | 2025-09-17 | 2409.38 | 60.23 | 2025-09-05 | 4 | 601.74 | 1 | 2409.38 | 3 | SO71828 | 2025-09-12 | 192.75 | 2406.97 | 602.35 | |||
| SO51793_16 | D763-4929-9B | PO18705168707 | 19 | 291 | 234 | 479 | 6 | 2024-11-16 | 299.94 | 7.50 | 2024-11-04 | 10 | 38.49 | 1 | 299.94 | 16 | SO51793 | 2024-11-11 | 24.00 | 384.92 | 29.99 | |||
| SO53545_12 | 2CC7-4F36-B6 | PO14239178578 | 19 | 291 | 234 | 550 | 6 | 2024-12-17 | 149.97 | 3.75 | 2024-12-05 | 5 | 38.49 | 1 | 149.97 | 12 | SO53545 | 2024-12-12 | 12.00 | 192.46 | 29.99 | |||
| SO49069_10 | 251D-4CF2-8D | PO1914132192 | 19 | 284 | 462 | 66 | 6 | 2024-05-19 | 84.77 | 2.12 | 2024-05-07 | 6 | 9.71 | 1 | 84.77 | 10 | SO49069 | 2024-05-14 | 6.78 | 58.28 | 14.13 | |||
| SO53527_49 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 551 | 10 | 6 | 2024-12-17 | 792.15 | 19.80 | 2024-12-05 | 5 | 144.59 | 1 | 792.15 | 49 | SO53527 | 2024-12-12 | 63.37 | 722.97 | 158.43 | |||
| SO71906_1 | F041-4B61-85 | PO4234112564 | 19 | 284 | 551 | 655 | 6 | 2025-09-17 | 158.43 | 3.96 | 2025-09-05 | 1 | 144.59 | 1 | 158.43 | 1 | SO71906 | 2025-09-12 | 12.67 | 144.59 | 158.43 | |||
| SO51096_24 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 481 | 514 | 6 | 2024-10-16 | 21.58 | 0.54 | 2024-10-04 | 4 | 3.36 | 1 | 21.58 | 24 | SO51096 | 2024-10-11 | 1.73 | 13.45 | 5.39 | |||
| SO67268_21 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 234 | 3 | 299 | 6 | 22.00 | 2025-07-18 | 439.91 | 10.45 | 2025-07-06 | 16 | 38.49 | 1 | 417.92 | 21 | SO67268 | 2025-07-13 | 33.43 | 615.88 | 27.49 | 0.05 |
| SO46953_40 | C650-4C32-BE | PO17603154442 | 19 | 284 | 461 | 12 | 6 | 2023-11-17 | 215.98 | 5.40 | 2023-11-05 | 4 | 37.12 | 1 | 215.98 | 40 | SO46953 | 2023-11-12 | 17.28 | 148.48 | 53.99 | |||
| SO50203_13 | 821E-4862-9A | PO17603125956 | 19 | 284 | 325 | 12 | 6 | 2024-08-16 | 1409.38 | 35.23 | 2024-08-04 | 3 | 486.71 | 1 | 1409.38 | 13 | SO50203 | 2024-08-11 | 112.75 | 1460.12 | 469.79 | |||
| SO50687_10 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 352 | 685 | 6 | 2024-09-16 | 6214.26 | 155.36 | 2024-09-04 | 5 | 1117.86 | 1 | 6214.26 | 10 | SO50687 | 2024-09-11 | 497.14 | 5589.28 | 1242.85 | |||
| SO46038_3 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 330 | 102 | 6 | 2023-08-17 | 419.46 | 10.49 | 2023-08-05 | 1 | 413.15 | 1 | 419.46 | 3 | SO46038 | 2023-08-12 | 33.56 | 413.15 | 419.46 | |||
| SO47709_2 | C56A-4A93-90 | PO4930142687 | 19 | 291 | 468 | 425 | 6 | 2024-01-17 | 45.59 | 1.14 | 2024-01-05 | 2 | 15.67 | 1 | 45.59 | 2 | SO47709 | 2024-01-12 | 3.65 | 31.34 | 22.79 | |||
| SO46071_2 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 276 | 317 | 6 | 2023-08-17 | 713.80 | 17.84 | 2023-08-05 | 2 | 352.14 | 1 | 713.80 | 2 | SO46071 | 2023-08-12 | 57.10 | 704.28 | 356.90 | |||
| SO46333_17 | B042-408B-A8 | PO17545158984 | 19 | 288 | 318 | 155 | 6 | 2023-09-17 | 1749.59 | 43.74 | 2023-09-05 | 2 | 884.71 | 1 | 1749.59 | 17 | SO46333 | 2023-09-12 | 139.97 | 1769.42 | 874.79 | |||
| SO61177_2 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 531 | 442 | 6 | 2025-04-18 | 749.37 | 18.73 | 2025-04-06 | 5 | 136.79 | 1 | 749.37 | 2 | SO61177 | 2025-04-13 | 59.95 | 683.93 | 149.87 | |||
| SO58972_46 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 298 | 10 | 6 | 2025-03-18 | 3239.04 | 80.98 | 2025-03-06 | 4 | 739.04 | 1 | 3239.04 | 46 | SO58972 | 2025-03-13 | 259.12 | 2956.16 | 809.76 | |||
| SO71830_3 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 560 | 281 | 6 | 2025-09-17 | 1457.82 | 36.45 | 2025-09-05 | 2 | 755.15 | 1 | 1457.82 | 3 | SO71830 | 2025-09-12 | 116.63 | 1510.30 | 728.91 | |||
| SO71841_46 | 1544-4561-AB | PO1798133189 | 19 | 291 | 515 | 10 | 6 | 2025-09-17 | 65.09 | 1.63 | 2025-09-05 | 4 | 12.04 | 1 | 65.09 | 46 | SO71841 | 2025-09-12 | 5.21 | 48.17 | 16.27 | |||
| SO47979_7 | 33B2-4238-8F | PO17806159797 | 19 | 291 | 433 | 101 | 6 | 2024-02-17 | 648.91 | 16.22 | 2024-02-05 | 2 | 300.12 | 1 | 648.91 | 7 | SO47979 | 2024-02-12 | 51.91 | 600.24 | 324.45 | |||
| SO44527_1 | 68F6-4911-A4 | PO10469169045 | 19 | 288 | 218 | 335 | 6 | 2023-02-17 | 17.10 | 0.43 | 2023-02-05 | 3 | 3.40 | 1 | 17.10 | 1 | SO44527 | 2023-02-12 | 1.37 | 10.19 | 5.70 | |||
| SO45552_8 | AF2A-49F1-92 | PO1740119260 | 19 | 288 | 215 | 460 | 6 | 2023-06-17 | 20.19 | 0.50 | 2023-06-05 | 1 | 12.03 | 1 | 20.19 | 8 | SO45552 | 2023-06-12 | 1.61 | 12.03 | 20.19 | |||
| SO61232_4 | 3450-43E5-B1 | PO11136111699 | 19 | 284 | 569 | 120 | 6 | 2025-04-18 | 890.82 | 22.27 | 2025-04-06 | 2 | 461.44 | 1 | 890.82 | 4 | SO61232 | 2025-04-13 | 71.27 | 922.89 | 445.41 | |||
| SO63239_17 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 214 | 84 | 6 | 2025-05-19 | 104.97 | 2.62 | 2025-05-07 | 5 | 13.09 | 1 | 104.97 | 17 | SO63239 | 2025-05-14 | 8.40 | 65.43 | 20.99 | |||
| SO55297_8 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 361 | 496 | 6 | 2025-01-16 | 8261.96 | 206.55 | 2025-01-04 | 6 | 1251.98 | 1 | 8261.96 | 8 | SO55297 | 2025-01-11 | 660.96 | 7511.89 | 1376.99 | |||
| SO49485_20 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 216 | 155 | 6 | 2024-06-16 | 40.37 | 1.01 | 2024-06-04 | 2 | 13.88 | 1 | 40.37 | 20 | SO49485 | 2024-06-11 | 3.23 | 27.76 | 20.19 | |||
| SO53536_43 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 552 | 118 | 6 | 2024-12-17 | 439.15 | 10.98 | 2024-12-05 | 8 | 40.62 | 1 | 439.15 | 43 | SO53536 | 2024-12-12 | 35.13 | 324.97 | 54.89 | |||
| SO69490_2 | 3F16-44B5-8B | PO10991119950 | 19 | 284 | 513 | 570 | 6 | 2025-08-17 | 218.45 | 5.46 | 2025-08-05 | 1 | 199.38 | 1 | 218.45 | 2 | SO69490 | 2025-08-12 | 17.48 | 199.38 | 218.45 | |||
| SO49094_10 | FEDE-45BA-90 | PO18705130501 | 19 | 291 | 327 | 479 | 6 | 2024-05-19 | 2348.97 | 58.72 | 2024-05-07 | 5 | 486.71 | 1 | 2348.97 | 10 | SO49094 | 2024-05-14 | 187.92 | 2433.53 | 469.79 |
Generated 2025-11-04 12:02:24.569 UTC