[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 4248 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49140_9 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 327 | 84 | 6 | 2024-05-21 | 939.59 | 23.49 | 2024-05-09 | 2 | 486.71 | 1 | 939.59 | 9 | SO49140 | 2024-05-16 | 75.17 | 973.41 | 469.79 | |||
| SO47013_15 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 370 | 317 | 6 | 2023-11-19 | 2932.02 | 73.30 | 2023-11-07 | 2 | 1518.79 | 1 | 2932.02 | 15 | SO47013 | 2023-11-14 | 234.56 | 3037.57 | 1466.01 | |||
| SO67268_8 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 225 | 2 | 299 | 6 | 1.25 | 2025-07-20 | 62.57 | 1.53 | 2025-07-08 | 12 | 6.92 | 1 | 61.32 | 8 | SO67268 | 2025-07-15 | 4.91 | 83.07 | 5.21 | 0.02 |
| SO46645_25 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 396 | 245 | 6 | 2023-10-19 | 224.51 | 5.61 | 2023-10-07 | 3 | 55.38 | 1 | 224.51 | 25 | SO46645 | 2023-10-14 | 17.96 | 166.14 | 74.84 | |||
| SO50200_4 | C47A-4C44-97 | PO17806151620 | 19 | 291 | 224 | 101 | 6 | 2024-08-18 | 20.75 | 0.52 | 2024-08-06 | 4 | 5.23 | 1 | 20.75 | 4 | SO50200 | 2024-08-13 | 1.66 | 20.92 | 5.19 | |||
| SO45284_18 | 57F0-404F-97 | PO16733112744 | 19 | 288 | 340 | 533 | 6 | 2023-05-22 | 419.46 | 10.49 | 2023-05-10 | 1 | 413.15 | 1 | 419.46 | 18 | SO45284 | 2023-05-17 | 33.56 | 413.15 | 419.46 | |||
| SO46645_22 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 354 | 245 | 6 | 2023-10-19 | 12428.52 | 310.71 | 2023-10-07 | 10 | 1117.86 | 1 | 12428.52 | 22 | SO46645 | 2023-10-14 | 994.28 | 11178.56 | 1242.85 | |||
| SO47012_33 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 422 | 66 | 6 | 2023-11-19 | 202.62 | 5.07 | 2023-11-07 | 3 | 49.98 | 1 | 202.62 | 33 | SO47012 | 2023-11-14 | 16.21 | 149.94 | 67.54 | |||
| SO50242_38 | A651-4343-86 | PO1595193228 | 19 | 284 | 369 | 426 | 6 | 2024-08-18 | 1466.01 | 36.65 | 2024-08-06 | 1 | 1518.79 | 1 | 1466.01 | 38 | SO50242 | 2024-08-13 | 117.28 | 1518.79 | 1466.01 | |||
| SO63141_7 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 222 | 12 | 6 | 2025-05-21 | 146.96 | 3.67 | 2025-05-09 | 7 | 13.09 | 1 | 146.96 | 7 | SO63141 | 2025-05-16 | 11.76 | 91.60 | 20.99 | |||
| SO47365_18 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 393 | 678 | 6 | 2023-12-20 | 1101.55 | 27.54 | 2023-12-08 | 8 | 101.89 | 1 | 1101.55 | 18 | SO47365 | 2023-12-15 | 88.12 | 815.15 | 137.69 | |||
| SO48761_19 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 333 | 299 | 6 | 2024-04-20 | 3758.35 | 93.96 | 2024-04-08 | 8 | 486.71 | 1 | 3758.35 | 19 | SO48761 | 2024-04-15 | 300.67 | 3893.65 | 469.79 | |||
| SO53536_24 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 225 | 118 | 6 | 2024-12-19 | 26.97 | 0.67 | 2024-12-07 | 5 | 6.92 | 1 | 26.97 | 24 | SO53536 | 2024-12-14 | 2.16 | 34.61 | 5.39 | |||
| SO63136_5 | 0873-484A-AE | PO18328125904 | 19 | 284 | 217 | 552 | 6 | 2025-05-21 | 125.96 | 3.15 | 2025-05-09 | 6 | 13.09 | 1 | 125.96 | 5 | SO63136 | 2025-05-16 | 10.08 | 78.52 | 20.99 | |||
| SO47365_31 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 445 | 678 | 6 | 2023-12-20 | 107.98 | 2.70 | 2023-12-08 | 3 | 24.75 | 1 | 107.98 | 31 | SO47365 | 2023-12-15 | 8.64 | 74.24 | 35.99 | |||
| SO50685_10 | 52FE-4932-85 | PO11107117790 | 19 | 284 | 329 | 156 | 6 | 2024-09-18 | 2348.97 | 58.72 | 2024-09-06 | 5 | 486.71 | 1 | 2348.97 | 10 | SO50685 | 2024-09-13 | 187.92 | 2433.53 | 469.79 | |||
| SO65189_13 | 985E-4937-94 | PO14761195376 | 19 | 284 | 573 | 408 | 6 | 2025-06-19 | 8582.65 | 214.57 | 2025-06-07 | 6 | 1481.94 | 1 | 8582.65 | 13 | SO65189 | 2025-06-14 | 686.61 | 8891.63 | 1430.44 | |||
| SO48036_12 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 448 | 66 | 6 | 2024-02-19 | 59.97 | 1.50 | 2024-02-07 | 5 | 8.25 | 1 | 59.97 | 12 | SO48036 | 2024-02-14 | 4.80 | 41.23 | 11.99 | |||
| SO53535_32 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 548 | 154 | 6 | 2024-12-19 | 97.19 | 2.43 | 2024-12-07 | 2 | 35.96 | 1 | 97.19 | 32 | SO53535 | 2024-12-14 | 7.78 | 71.92 | 48.59 | |||
| SO47973_23 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 371 | 479 | 6 | 2024-02-19 | 1308.94 | 32.72 | 2024-02-07 | 1 | 1320.68 | 1 | 1308.94 | 23 | SO47973 | 2024-02-14 | 104.72 | 1320.68 | 1308.94 | |||
| SO46984_3 | 0C1F-467E-93 | PO12789152571 | 19 | 291 | 213 | 677 | 6 | 2023-11-19 | 60.56 | 1.51 | 2023-11-07 | 3 | 13.88 | 1 | 60.56 | 3 | SO46984 | 2023-11-14 | 4.84 | 41.63 | 20.19 | |||
| SO45529_18 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 220 | 678 | 6 | 2023-06-19 | 60.56 | 1.51 | 2023-06-07 | 3 | 12.03 | 1 | 60.56 | 18 | SO45529 | 2023-06-14 | 4.84 | 36.08 | 20.19 | |||
| SO47008_39 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 230 | 426 | 6 | 2023-11-19 | 230.72 | 5.77 | 2023-11-07 | 8 | 29.08 | 1 | 230.72 | 39 | SO47008 | 2023-11-14 | 18.46 | 232.65 | 28.84 | |||
| SO44298_1 | 960B-4C26-9F | PO11049118093 | 19 | 284 | 235 | 679 | 6 | 2023-01-19 | 115.36 | 2.88 | 2023-01-07 | 4 | 31.72 | 1 | 115.36 | 1 | SO44298 | 2023-01-14 | 9.23 | 126.90 | 28.84 | |||
| SO53483_8 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 483 | 3 | 408 | 6 | 69.30 | 2024-12-19 | 1386.00 | 32.92 | 2024-12-07 | 21 | 44.88 | 1 | 1316.70 | 8 | SO53483 | 2024-12-14 | 105.34 | 942.48 | 66.00 | 0.05 |
| SO45781_3 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 324 | 227 | 6 | 2023-07-20 | 2516.75 | 62.92 | 2023-07-08 | 6 | 413.15 | 1 | 2516.75 | 3 | SO45781 | 2023-07-15 | 201.34 | 2478.88 | 419.46 | |||
| SO47399_12 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 427 | 685 | 6 | 2023-12-20 | 418.51 | 10.46 | 2023-12-08 | 2 | 185.82 | 1 | 418.51 | 12 | SO47399 | 2023-12-15 | 33.48 | 371.64 | 209.26 | |||
| SO45546_1 | B424-4A7F-B4 | PO10585114494 | 19 | 272 | 347 | 498 | 6 | 2023-06-19 | 4079.99 | 102.00 | 2023-06-07 | 2 | 1912.15 | 1 | 4079.99 | 1 | SO45546 | 2023-06-14 | 326.40 | 3824.31 | 2039.99 | |||
| SO45524_11 | D7A1-4CAA-B1 | PO18299160578 | 19 | 288 | 220 | 118 | 6 | 2023-06-19 | 40.37 | 1.01 | 2023-06-07 | 2 | 12.03 | 1 | 40.37 | 11 | SO45524 | 2023-06-14 | 3.23 | 24.06 | 20.19 | |||
| SO61222_11 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 476 | 119 | 6 | 2025-04-20 | 377.95 | 9.45 | 2025-04-08 | 9 | 26.18 | 1 | 377.95 | 11 | SO61222 | 2025-04-15 | 30.24 | 235.59 | 41.99 | |||
| SO44773_23 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 212 | 460 | 6 | 2023-03-21 | 121.12 | 3.03 | 2023-03-09 | 6 | 12.03 | 1 | 121.12 | 23 | SO44773 | 2023-03-16 | 9.69 | 72.17 | 20.19 | |||
| SO65156_12 | 3295-4FC6-BC | PO19401176373 | 19 | 291 | 583 | 173 | 6 | 2025-06-19 | 2041.19 | 51.03 | 2025-06-07 | 2 | 1082.51 | 1 | 2041.19 | 12 | SO65156 | 2025-06-14 | 163.30 | 2165.02 | 1020.59 | |||
| SO46614_55 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 337 | 299 | 6 | 2023-10-19 | 469.79 | 11.74 | 2023-10-07 | 1 | 486.71 | 1 | 469.79 | 55 | SO46614 | 2023-10-14 | 37.58 | 486.71 | 469.79 | |||
| SO48338_2 | CF00-46C1-99 | PO11107115615 | 19 | 284 | 343 | 156 | 6 | 2024-03-20 | 469.79 | 11.74 | 2024-03-08 | 1 | 486.71 | 1 | 469.79 | 2 | SO48338 | 2024-03-15 | 37.58 | 486.71 | 469.79 | |||
| SO47696_16 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 421 | 245 | 6 | 2024-01-19 | 1177.97 | 29.45 | 2024-01-07 | 6 | 145.28 | 1 | 1177.97 | 16 | SO47696 | 2024-01-14 | 94.24 | 871.70 | 196.33 | |||
| SO58981_17 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 517 | 118 | 6 | 2025-03-20 | 94.75 | 2.37 | 2025-03-08 | 3 | 23.37 | 1 | 94.75 | 17 | SO58981 | 2025-03-15 | 7.58 | 70.12 | 31.58 | |||
| SO51847_12 | 7E3E-4DB0-80 | PO2030165560 | 19 | 284 | 593 | 661 | 6 | 2024-11-18 | 338.99 | 8.47 | 2024-11-06 | 1 | 308.22 | 1 | 338.99 | 12 | SO51847 | 2024-11-13 | 27.12 | 308.22 | 338.99 | |||
| SO46064_6 | EC45-4C82-8B | PO11020129544 | 19 | 284 | 322 | 336 | 6 | 2023-08-19 | 2097.29 | 52.43 | 2023-08-07 | 5 | 413.15 | 1 | 2097.29 | 6 | SO46064 | 2023-08-14 | 167.78 | 2065.73 | 419.46 | |||
| SO46086_3 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 232 | 2 | 84 | 6 | 7.25 | 2023-08-19 | 362.43 | 8.88 | 2023-08-07 | 13 | 31.72 | 1 | 355.18 | 3 | SO46086 | 2023-08-14 | 28.41 | 412.42 | 27.88 | 0.02 |
| SO46936_4 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 456 | 210 | 6 | 2023-11-19 | 179.98 | 4.50 | 2023-11-07 | 4 | 30.93 | 1 | 179.98 | 4 | SO46936 | 2023-11-14 | 14.40 | 123.73 | 44.99 | |||
| SO48038_2 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 456 | 444 | 6 | 2024-02-19 | 134.98 | 3.37 | 2024-02-07 | 3 | 30.93 | 1 | 134.98 | 2 | SO48038 | 2024-02-14 | 10.80 | 92.80 | 44.99 | |||
| SO44773_5 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 262 | 460 | 6 | 2023-03-21 | 183.94 | 4.60 | 2023-03-09 | 1 | 181.49 | 1 | 183.94 | 5 | SO44773 | 2023-03-16 | 14.72 | 181.49 | 183.94 | |||
| SO49856_23 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 323 | 227 | 6 | 2024-07-19 | 2348.97 | 58.72 | 2024-07-07 | 5 | 486.71 | 1 | 2348.97 | 23 | SO49856 | 2024-07-14 | 187.92 | 2433.53 | 469.79 | |||
| 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 | |||
| SO71800_15 | 6DBE-44CC-BD | PO15544127760 | 19 | 284 | 496 | 282 | 6 | 2025-09-19 | 1807.04 | 45.18 | 2025-09-07 | 3 | 601.74 | 1 | 1807.04 | 15 | SO71800 | 2025-09-14 | 144.56 | 1805.23 | 602.35 | |||
| SO50265_13 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 375 | 479 | 6 | 2024-08-18 | 1308.94 | 32.72 | 2024-08-06 | 1 | 1320.68 | 1 | 1308.94 | 13 | SO50265 | 2024-08-13 | 104.72 | 1320.68 | 1308.94 | |||
| SO49138_10 | 487B-46D8-9B | PO4466190674 | 19 | 291 | 224 | 352 | 6 | 2024-05-21 | 36.31 | 0.91 | 2024-05-09 | 7 | 5.23 | 1 | 36.31 | 10 | SO49138 | 2024-05-16 | 2.90 | 36.61 | 5.19 | |||
| SO71841_24 | 1544-4561-AB | PO1798133189 | 19 | 291 | 214 | 10 | 6 | 2025-09-19 | 188.95 | 4.72 | 2025-09-07 | 9 | 13.09 | 1 | 188.95 | 24 | SO71841 | 2025-09-14 | 15.12 | 117.78 | 20.99 | |||
| SO49855_11 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 364 | 442 | 6 | 2024-07-19 | 647.99 | 16.20 | 2024-07-07 | 1 | 598.44 | 1 | 647.99 | 11 | SO49855 | 2024-07-14 | 51.84 | 598.44 | 647.99 | |||
| SO67295_24 | D785-46A0-BC | PO1711155302 | 19 | 291 | 544 | 2 | 245 | 6 | 11.27 | 2025-07-20 | 563.69 | 13.81 | 2025-07-08 | 12 | 35.96 | 1 | 552.42 | 24 | SO67295 | 2025-07-15 | 44.19 | 431.52 | 46.97 | 0.02 |
| SO69560_21 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 359 | 100 | 6 | 2025-08-19 | 8261.96 | 206.55 | 2025-08-07 | 6 | 1251.98 | 1 | 8261.96 | 21 | SO69560 | 2025-08-14 | 660.96 | 7511.89 | 1376.99 | |||
| SO58956_6 | 36A4-4154-AB | PO11194174095 | 19 | 284 | 576 | 48 | 6 | 2025-03-20 | 8582.65 | 214.57 | 2025-03-08 | 6 | 1481.94 | 1 | 8582.65 | 6 | SO58956 | 2025-03-15 | 686.61 | 8891.63 | 1430.44 | |||
| SO55287_24 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 402 | 119 | 6 | 2025-01-18 | 72.16 | 1.80 | 2025-01-06 | 1 | 53.40 | 1 | 72.16 | 24 | SO55287 | 2025-01-13 | 5.77 | 53.40 | 72.16 | |||
| SO48059_43 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 464 | 84 | 6 | 2024-02-19 | 70.64 | 1.77 | 2024-02-07 | 5 | 9.71 | 1 | 70.64 | 43 | SO48059 | 2024-02-14 | 5.65 | 48.57 | 14.13 | |||
| SO51740_10 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 225 | 677 | 6 | 2024-11-18 | 26.97 | 0.67 | 2024-11-06 | 5 | 6.92 | 1 | 26.97 | 10 | SO51740 | 2024-11-13 | 2.16 | 34.61 | 5.39 | |||
| SO51786_3 | CB32-4179-97 | PO18357130739 | 19 | 272 | 576 | 138 | 6 | 2024-11-18 | 4291.33 | 107.28 | 2024-11-06 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO51786 | 2024-11-13 | 343.31 | 4445.81 | 1430.44 | |||
| SO71841_5 | 1544-4561-AB | PO1798133189 | 19 | 291 | 544 | 10 | 6 | 2025-09-19 | 242.97 | 6.07 | 2025-09-07 | 5 | 35.96 | 1 | 242.97 | 5 | SO71841 | 2025-09-14 | 19.44 | 179.80 | 48.59 | |||
| SO50203_16 | 821E-4862-9A | PO17603125956 | 19 | 284 | 462 | 12 | 6 | 2024-08-18 | 56.52 | 1.41 | 2024-08-06 | 4 | 9.71 | 1 | 56.52 | 16 | SO50203 | 2024-08-13 | 4.52 | 38.85 | 14.13 | |||
| SO47708_33 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 367 | 496 | 6 | 2024-01-19 | 1295.99 | 32.40 | 2024-01-07 | 2 | 598.44 | 1 | 1295.99 | 33 | SO47708 | 2024-01-14 | 103.68 | 1196.87 | 647.99 | |||
| SO58932_27 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 488 | 408 | 6 | 2025-03-20 | 259.15 | 6.48 | 2025-03-08 | 8 | 41.57 | 1 | 259.15 | 27 | SO58932 | 2025-03-15 | 20.73 | 332.58 | 32.39 | |||
| SO48339_18 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 325 | 461 | 6 | 2024-03-20 | 2348.97 | 58.72 | 2024-03-08 | 5 | 486.71 | 1 | 2348.97 | 18 | SO48339 | 2024-03-15 | 187.92 | 2433.53 | 469.79 | |||
| SO44525_21 | E0C6-40AA-AD | PO11600189203 | 19 | 288 | 314 | 569 | 6 | 2023-02-19 | 10734.81 | 268.37 | 2023-02-07 | 5 | 2171.29 | 1 | 10734.81 | 21 | SO44525 | 2023-02-14 | 858.78 | 10856.47 | 2146.96 |
Generated 2025-11-06 10:19:08.621 UTC