[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 2000 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO53536_25 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 475 | 118 | 6 | 2024-12-18 | 83.99 | 2.10 | 2024-12-06 | 2 | 26.18 | 1 | 83.99 | 25 | SO53536 | 2024-12-13 | 6.72 | 52.35 | 41.99 | |||
| SO44282_5 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 235 | 442 | 6 | 2023-01-18 | 115.36 | 2.88 | 2023-01-06 | 4 | 31.72 | 1 | 115.36 | 5 | SO44282 | 2023-01-13 | 9.23 | 126.90 | 28.84 | |||
| SO43662_21 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 334 | 227 | 6 | 2022-10-18 | 1258.38 | 31.46 | 2022-10-06 | 3 | 413.15 | 1 | 1258.38 | 21 | SO43662 | 2022-10-13 | 100.67 | 1239.44 | 419.46 | |||
| SO46608_3 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 466 | 442 | 6 | 2023-10-18 | 42.39 | 1.06 | 2023-10-06 | 3 | 9.71 | 1 | 42.39 | 3 | SO46608 | 2023-10-13 | 3.39 | 29.14 | 14.13 | |||
| SO46039_7 | D5C9-4969-86 | PO17313170717 | 19 | 288 | 351 | 389 | 6 | 2023-08-18 | 4049.99 | 101.25 | 2023-08-06 | 2 | 1898.09 | 1 | 4049.99 | 7 | SO46039 | 2023-08-13 | 324.00 | 3796.19 | 2024.99 | |||
| SO46657_21 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 454 | 496 | 6 | 2023-10-18 | 179.97 | 4.50 | 2023-10-06 | 5 | 24.75 | 1 | 179.97 | 21 | SO46657 | 2023-10-13 | 14.40 | 123.73 | 35.99 | |||
| SO67316_50 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 357 | 496 | 6 | 2025-07-19 | 6959.97 | 174.00 | 2025-07-07 | 5 | 1265.62 | 1 | 6959.97 | 50 | SO67316 | 2025-07-14 | 556.80 | 6328.10 | 1391.99 | |||
| SO69398_3 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 465 | 28 | 6 | 2025-08-18 | 102.86 | 2.57 | 2025-08-06 | 7 | 9.16 | 1 | 102.86 | 3 | SO69398 | 2025-08-13 | 8.23 | 64.12 | 14.69 | |||
| SO47366_16 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 236 | 155 | 6 | 2023-12-19 | 201.88 | 5.05 | 2023-12-07 | 7 | 29.08 | 1 | 201.88 | 16 | SO47366 | 2023-12-14 | 16.15 | 203.56 | 28.84 | |||
| SO57023_20 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 214 | 12 | 6 | 2025-02-17 | 188.95 | 4.72 | 2025-02-05 | 9 | 13.09 | 1 | 188.95 | 20 | SO57023 | 2025-02-12 | 15.12 | 117.78 | 20.99 | |||
| SO50716_33 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 448 | 118 | 6 | 2024-09-17 | 35.98 | 0.90 | 2024-09-05 | 3 | 8.25 | 1 | 35.98 | 33 | SO50716 | 2024-09-12 | 2.88 | 24.74 | 11.99 | |||
| SO58972_14 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 532 | 10 | 6 | 2025-03-19 | 449.62 | 11.24 | 2025-03-07 | 3 | 136.79 | 1 | 449.62 | 14 | SO58972 | 2025-03-14 | 35.97 | 410.36 | 149.87 | |||
| SO46608_36 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 213 | 8 | 442 | 6 | 8.41 | 2023-10-18 | 84.11 | 1.89 | 2023-10-06 | 5 | 13.88 | 1 | 75.70 | 36 | SO46608 | 2023-10-13 | 6.06 | 69.39 | 16.82 | 0.10 |
| SO48778_34 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 395 | 496 | 6 | 2024-04-19 | 122.75 | 3.07 | 2024-04-07 | 2 | 45.42 | 1 | 122.75 | 34 | SO48778 | 2024-04-14 | 9.82 | 90.83 | 61.37 | |||
| SO51769_1 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 491 | 426 | 6 | 2024-11-17 | 194.36 | 4.86 | 2024-11-05 | 6 | 41.57 | 1 | 194.36 | 1 | SO51769 | 2024-11-12 | 15.55 | 249.43 | 32.39 | |||
| SO49094_24 | FEDE-45BA-90 | PO18705130501 | 19 | 291 | 369 | 479 | 6 | 2024-05-20 | 5864.04 | 146.60 | 2024-05-08 | 4 | 1518.79 | 1 | 5864.04 | 24 | SO49094 | 2024-05-15 | 469.12 | 6075.15 | 1466.01 | |||
| SO65238_11 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 214 | 281 | 6 | 2025-06-18 | 146.96 | 3.67 | 2025-06-06 | 7 | 13.09 | 1 | 146.96 | 11 | SO65238 | 2025-06-13 | 11.76 | 91.60 | 20.99 | |||
| SO48306_13 | EA27-471A-9D | PO17574166075 | 19 | 291 | 410 | 678 | 6 | 2024-03-19 | 109.34 | 2.73 | 2024-03-07 | 3 | 26.97 | 1 | 109.34 | 13 | SO48306 | 2024-03-14 | 8.75 | 80.91 | 36.45 | |||
| SO53464_1 | E113-419B-8F | PO17545119283 | 19 | 291 | 255 | 155 | 6 | 2024-12-18 | 607.00 | 15.17 | 2024-12-06 | 3 | 204.63 | 1 | 607.00 | 1 | SO53464 | 2024-12-13 | 48.56 | 613.88 | 202.33 | |||
| SO69522_2 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 467 | 84 | 6 | 2025-08-18 | 73.47 | 1.84 | 2025-08-06 | 5 | 9.16 | 1 | 73.47 | 2 | SO69522 | 2025-08-13 | 5.88 | 45.80 | 14.69 | |||
| SO45052_1 | 7233-4244-8C | PO13862115869 | 19 | 288 | 348 | 119 | 6 | 2023-04-20 | 12149.96 | 303.75 | 2023-04-08 | 6 | 1898.09 | 1 | 12149.96 | 1 | SO45052 | 2023-04-15 | 972.00 | 11388.57 | 2024.99 | |||
| SO44749_12 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 318 | 155 | 6 | 2023-03-20 | 3499.18 | 87.48 | 2023-03-08 | 4 | 884.71 | 1 | 3499.18 | 12 | SO44749 | 2023-03-15 | 279.93 | 3538.83 | 874.79 | |||
| SO69460_12 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 287 | 426 | 6 | 2025-08-18 | 607.00 | 15.17 | 2025-08-06 | 3 | 204.63 | 1 | 607.00 | 12 | SO69460 | 2025-08-13 | 48.56 | 613.88 | 202.33 | |||
| SO69479_24 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 584 | 552 | 6 | 2025-08-18 | 323.99 | 8.10 | 2025-08-06 | 1 | 343.65 | 1 | 323.99 | 24 | SO69479 | 2025-08-13 | 25.92 | 343.65 | 323.99 | |||
| SO51699_21 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 563 | 14 | 64 | 6 | 572.18 | 2024-11-17 | 2860.88 | 57.22 | 2024-11-05 | 3 | 1481.94 | 1 | 2288.71 | 21 | SO51699 | 2024-11-12 | 183.10 | 4445.81 | 953.63 | 0.20 |
| SO61248_6 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 558 | 496 | 6 | 2025-04-19 | 1214.97 | 30.37 | 2025-04-07 | 5 | 179.82 | 1 | 1214.97 | 6 | SO61248 | 2025-04-14 | 97.20 | 899.08 | 242.99 | |||
| SO46072_10 | 0D05-4D9C-87 | PO2146167606 | 19 | 284 | 346 | 354 | 6 | 2023-08-18 | 4079.99 | 102.00 | 2023-08-06 | 2 | 1912.15 | 1 | 4079.99 | 10 | SO46072 | 2023-08-13 | 326.40 | 3824.31 | 2039.99 | |||
| SO48778_40 | 4F83-4D59-87 | PO4495173571 | 19 | 291 | 427 | 496 | 6 | 2024-04-19 | 1046.28 | 26.16 | 2024-04-07 | 5 | 185.82 | 1 | 1046.28 | 40 | SO48778 | 2024-04-14 | 83.70 | 929.10 | 209.26 | |||
| SO55287_18 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 363 | 119 | 6 | 2025-01-17 | 2753.99 | 68.85 | 2025-01-05 | 2 | 1251.98 | 1 | 2753.99 | 18 | SO55287 | 2025-01-12 | 220.32 | 2503.96 | 1376.99 | |||
| SO51786_3 | CB32-4179-97 | PO18357130739 | 19 | 272 | 576 | 138 | 6 | 2024-11-17 | 4291.33 | 107.28 | 2024-11-05 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO51786 | 2024-11-12 | 343.31 | 4445.81 | 1430.44 | |||
| SO71808_10 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 570 | 408 | 6 | 2025-09-18 | 445.41 | 11.14 | 2025-09-06 | 1 | 461.44 | 1 | 445.41 | 10 | SO71808 | 2025-09-13 | 35.63 | 461.44 | 445.41 | |||
| SO46086_6 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 310 | 84 | 6 | 2023-08-18 | 2146.96 | 53.67 | 2023-08-06 | 1 | 2171.29 | 1 | 2146.96 | 6 | SO46086 | 2023-08-13 | 171.76 | 2171.29 | 2146.96 | |||
| SO44295_9 | DEAE-4D52-B8 | PO12760122918 | 19 | 288 | 223 | 83 | 6 | 2023-01-18 | 10.37 | 0.26 | 2023-01-06 | 2 | 5.71 | 1 | 10.37 | 9 | SO44295 | 2023-01-13 | 0.83 | 11.41 | 5.19 | |||
| SO49072_7 | B98C-4814-B1 | PO2146179731 | 19 | 284 | 354 | 354 | 6 | 2024-05-20 | 3728.56 | 93.21 | 2024-05-08 | 3 | 1117.86 | 1 | 3728.56 | 7 | SO49072 | 2024-05-15 | 298.28 | 3353.57 | 1242.85 | |||
| SO50716_5 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 366 | 118 | 6 | 2024-09-17 | 1943.98 | 48.60 | 2024-09-05 | 3 | 598.44 | 1 | 1943.98 | 5 | SO50716 | 2024-09-12 | 155.52 | 1795.31 | 647.99 | |||
| SO46940_17 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 341 | 479 | 6 | 2023-11-18 | 939.59 | 23.49 | 2023-11-06 | 2 | 486.71 | 1 | 939.59 | 17 | SO46940 | 2023-11-13 | 75.17 | 973.41 | 469.79 | |||
| SO69542_11 | 990B-4CF0-A7 | PO1827116485 | 19 | 291 | 467 | 317 | 6 | 2025-08-18 | 44.08 | 1.10 | 2025-08-06 | 3 | 9.16 | 1 | 44.08 | 11 | SO69542 | 2025-08-13 | 3.53 | 27.48 | 14.69 | |||
| SO69522_34 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 418 | 84 | 6 | 2025-08-18 | 356.90 | 8.92 | 2025-08-06 | 1 | 360.94 | 1 | 356.90 | 34 | SO69522 | 2025-08-13 | 28.55 | 360.94 | 356.90 | |||
| SO53535_14 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 577 | 154 | 6 | 2024-12-18 | 2915.64 | 72.89 | 2024-12-06 | 4 | 755.15 | 1 | 2915.64 | 14 | SO53535 | 2024-12-13 | 233.25 | 3020.60 | 728.91 | |||
| SO47411_4 | 4BDD-4511-AC | PO1798140269 | 19 | 291 | 364 | 10 | 6 | 2023-12-19 | 1295.99 | 32.40 | 2023-12-07 | 2 | 598.44 | 1 | 1295.99 | 4 | SO47411 | 2023-12-14 | 103.68 | 1196.87 | 647.99 | |||
| SO51699_4 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 603 | 64 | 6 | 2024-11-17 | 145.79 | 3.64 | 2024-11-05 | 2 | 53.94 | 1 | 145.79 | 4 | SO51699 | 2024-11-12 | 11.66 | 107.88 | 72.89 | |||
| SO51772_29 | 7800-4280-A7 | PO1827195162 | 19 | 291 | 258 | 317 | 6 | 2024-11-17 | 202.33 | 5.06 | 2024-11-05 | 1 | 204.63 | 1 | 202.33 | 29 | SO51772 | 2024-11-12 | 16.19 | 204.63 | 202.33 | |||
| SO69399_22 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 603 | 264 | 6 | 2025-08-18 | 145.79 | 3.64 | 2025-08-06 | 2 | 53.94 | 1 | 145.79 | 22 | SO69399 | 2025-08-13 | 11.66 | 107.88 | 72.89 | |||
| SO51843_5 | 2960-4D59-96 | PO2117116809 | 19 | 284 | 484 | 444 | 6 | 2024-11-17 | 9.54 | 0.24 | 2024-11-05 | 2 | 2.97 | 1 | 9.54 | 5 | SO51843 | 2024-11-12 | 0.76 | 5.95 | 4.77 | |||
| SO49070_9 | 2B81-47B6-AD | PO1827112158 | 19 | 291 | 331 | 317 | 6 | 2024-05-20 | 469.79 | 11.74 | 2024-05-08 | 1 | 486.71 | 1 | 469.79 | 9 | SO49070 | 2024-05-15 | 37.58 | 486.71 | 469.79 | |||
| SO44111_12 | CFDA-475D-95 | PO1740120267 | 19 | 288 | 285 | 460 | 6 | 2022-12-19 | 178.58 | 4.46 | 2022-12-07 | 1 | 176.20 | 1 | 178.58 | 12 | SO44111 | 2022-12-14 | 14.29 | 176.20 | 178.58 | |||
| SO46334_20 | F652-4575-B7 | PO17574196050 | 19 | 272 | 218 | 678 | 6 | 2023-09-18 | 39.90 | 1.00 | 2023-09-06 | 7 | 3.40 | 1 | 39.90 | 20 | SO46334 | 2023-09-13 | 3.19 | 23.77 | 5.70 | |||
| SO49069_9 | 251D-4CF2-8D | PO1914132192 | 19 | 284 | 224 | 66 | 6 | 2024-05-20 | 15.56 | 0.39 | 2024-05-08 | 3 | 5.23 | 1 | 15.56 | 9 | SO49069 | 2024-05-15 | 1.24 | 15.69 | 5.19 | |||
| SO50694_30 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 321 | 155 | 6 | 2024-09-17 | 3758.35 | 93.96 | 2024-09-05 | 8 | 486.71 | 1 | 3758.35 | 30 | SO50694 | 2024-09-12 | 300.67 | 3893.65 | 469.79 | |||
| SO48053_1 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 419 | 352 | 6 | 2024-02-18 | 105.29 | 2.63 | 2024-02-06 | 2 | 38.96 | 1 | 105.29 | 1 | SO48053 | 2024-02-13 | 8.42 | 77.92 | 52.65 | |||
| SO63141_2 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 234 | 12 | 6 | 2025-05-20 | 149.97 | 3.75 | 2025-05-08 | 5 | 38.49 | 1 | 149.97 | 2 | SO63141 | 2025-05-15 | 12.00 | 192.46 | 29.99 | |||
| SO71808_22 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 500 | 408 | 6 | 2025-09-18 | 602.35 | 15.06 | 2025-09-06 | 1 | 601.74 | 1 | 602.35 | 22 | SO71808 | 2025-09-13 | 48.19 | 601.74 | 602.35 | |||
| SO44535_12 | 26EF-4A69-B0 | PO2088169831 | 19 | 288 | 322 | 136 | 6 | 2023-02-18 | 2097.29 | 52.43 | 2023-02-06 | 5 | 413.15 | 1 | 2097.29 | 12 | SO44535 | 2023-02-13 | 167.78 | 2065.73 | 419.46 | |||
| SO67268_4 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 488 | 299 | 6 | 2025-07-19 | 194.36 | 4.86 | 2025-07-07 | 6 | 41.57 | 1 | 194.36 | 4 | SO67268 | 2025-07-14 | 15.55 | 249.43 | 32.39 | |||
| SO46086_22 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 264 | 84 | 6 | 2023-08-18 | 183.94 | 4.60 | 2023-08-06 | 1 | 181.49 | 1 | 183.94 | 22 | SO46086 | 2023-08-13 | 14.72 | 181.49 | 183.94 | |||
| SO71921_4 | F38D-4417-84 | PO2233121230 | 19 | 291 | 225 | 262 | 6 | 2025-09-18 | 32.36 | 0.81 | 2025-09-06 | 6 | 6.92 | 1 | 32.36 | 4 | SO71921 | 2025-09-13 | 2.59 | 41.53 | 5.39 | |||
| SO47662_13 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 360 | 442 | 6 | 2024-01-18 | 2458.92 | 61.47 | 2024-01-06 | 2 | 1105.81 | 1 | 2458.92 | 13 | SO47662 | 2024-01-13 | 196.71 | 2211.62 | 1229.46 | |||
| SO65238_33 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 561 | 281 | 6 | 2025-06-18 | 2860.88 | 71.52 | 2025-06-06 | 2 | 1481.94 | 1 | 2860.88 | 33 | SO65238 | 2025-06-13 | 228.87 | 2963.88 | 1430.44 | |||
| SO48761_13 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 325 | 299 | 6 | 2024-04-19 | 1409.38 | 35.23 | 2024-04-07 | 3 | 486.71 | 1 | 1409.38 | 13 | SO48761 | 2024-04-14 | 112.75 | 1460.12 | 469.79 | |||
| SO63267_1 | A573-4A2E-B5 | PO2262115390 | 19 | 291 | 586 | 629 | 6 | 2025-05-20 | 445.41 | 11.14 | 2025-05-08 | 1 | 461.44 | 1 | 445.41 | 1 | SO63267 | 2025-05-15 | 35.63 | 461.44 | 445.41 | |||
| SO44495_1 | 7929-4E62-AE | PO18270111190 | 19 | 288 | 219 | 11 | 6 | 2023-02-18 | 11.40 | 0.29 | 2023-02-06 | 2 | 3.40 | 1 | 11.40 | 1 | SO44495 | 2023-02-13 | 0.91 | 6.79 | 5.70 | |||
| SO48761_2 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 271 | 299 | 6 | 2024-04-19 | 404.66 | 10.12 | 2024-04-07 | 2 | 187.16 | 1 | 404.66 | 2 | SO48761 | 2024-04-14 | 32.37 | 374.31 | 202.33 |
Generated 2025-11-05 13:05:28.112 UTC