[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 486 > < TAKE 28 >
28 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO45524_8 | D7A1-4CAA-B1 | PO18299160578 | 19 | 288 | 347 | 118 | 6 | 2023-06-19 | 8159.98 | 204.00 | 2023-06-07 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO45524 | 2023-06-14 | 652.80 | 7648.62 | 2039.99 | |||
| SO49140_8 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 213 | 84 | 6 | 2024-05-21 | 161.49 | 4.04 | 2024-05-09 | 8 | 13.88 | 1 | 161.49 | 8 | SO49140 | 2024-05-16 | 12.92 | 111.03 | 20.19 | |||
| SO67288_12 | C763-4CCD-AB | PO10527192676 | 19 | 284 | 481 | 480 | 6 | 2025-07-20 | 10.79 | 0.27 | 2025-07-08 | 2 | 3.36 | 1 | 10.79 | 12 | SO67288 | 2025-07-15 | 0.86 | 6.72 | 5.39 | |||
| SO53513_13 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 483 | 281 | 6 | 2024-12-19 | 216.00 | 5.40 | 2024-12-07 | 3 | 44.88 | 1 | 216.00 | 13 | SO53513 | 2024-12-14 | 17.28 | 134.64 | 72.00 | |||
| SO48038_9 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 358 | 444 | 6 | 2024-02-19 | 2458.92 | 61.47 | 2024-02-07 | 2 | 1105.81 | 1 | 2458.92 | 9 | SO48038 | 2024-02-14 | 196.71 | 2211.62 | 1229.46 | |||
| SO47668_28 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 286 | 299 | 6 | 2024-01-19 | 183.94 | 4.60 | 2024-01-07 | 1 | 170.14 | 1 | 183.94 | 28 | SO47668 | 2024-01-14 | 14.72 | 170.14 | 183.94 | |||
| SO45781_21 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 253 | 227 | 6 | 2023-07-20 | 714.32 | 17.86 | 2023-07-08 | 4 | 176.20 | 1 | 714.32 | 21 | SO45781 | 2023-07-15 | 57.15 | 704.80 | 178.58 | |||
| SO48023_17 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 339 | 336 | 6 | 2024-02-19 | 939.59 | 23.49 | 2024-02-07 | 2 | 486.71 | 1 | 939.59 | 17 | SO48023 | 2024-02-14 | 75.17 | 973.41 | 469.79 | |||
| SO49501_34 | EF67-4713-BD | PO17574111786 | 19 | 291 | 393 | 678 | 6 | 2024-06-18 | 688.47 | 17.21 | 2024-06-06 | 5 | 101.89 | 1 | 688.47 | 34 | SO49501 | 2024-06-13 | 55.08 | 509.47 | 137.69 | |||
| SO65264_4 | 296E-492E-8B | PO12818156002 | 19 | 291 | 384 | 587 | 6 | 2025-06-19 | 2016.88 | 50.42 | 2025-06-07 | 3 | 713.08 | 1 | 2016.88 | 4 | SO65264 | 2025-06-14 | 161.35 | 2139.24 | 672.29 | |||
| SO49072_4 | B98C-4814-B1 | PO2146179731 | 19 | 284 | 305 | 354 | 6 | 2024-05-21 | 736.15 | 18.40 | 2024-05-09 | 1 | 653.70 | 1 | 736.15 | 4 | SO49072 | 2024-05-16 | 58.89 | 653.70 | 736.15 | |||
| SO53536_15 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 598 | 118 | 6 | 2024-12-19 | 647.99 | 16.20 | 2024-12-07 | 2 | 294.58 | 1 | 647.99 | 15 | SO53536 | 2024-12-14 | 51.84 | 589.16 | 323.99 | |||
| SO57023_23 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 287 | 12 | 6 | 2025-02-18 | 1011.66 | 25.29 | 2025-02-06 | 5 | 204.63 | 1 | 1011.66 | 23 | SO57023 | 2025-02-13 | 80.93 | 1023.13 | 202.33 | |||
| SO44533_18 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 319 | 317 | 6 | 2023-02-19 | 2624.38 | 65.61 | 2023-02-07 | 3 | 884.71 | 1 | 2624.38 | 18 | SO44533 | 2023-02-14 | 209.95 | 2654.12 | 874.79 | |||
| SO65238_3 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 465 | 281 | 6 | 2025-06-19 | 14.69 | 0.37 | 2025-06-07 | 1 | 9.16 | 1 | 14.69 | 3 | SO65238 | 2025-06-14 | 1.18 | 9.16 | 14.69 | |||
| SO48750_8 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 448 | 514 | 6 | 2024-04-20 | 47.98 | 1.20 | 2024-04-08 | 4 | 8.25 | 1 | 47.98 | 8 | SO48750 | 2024-04-15 | 3.84 | 32.98 | 11.99 | |||
| SO49856_3 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 333 | 227 | 6 | 2024-07-19 | 4697.94 | 117.45 | 2024-07-07 | 10 | 486.71 | 1 | 4697.94 | 3 | SO49856 | 2024-07-14 | 375.84 | 4867.07 | 469.79 | |||
| SO53477_19 | F1BC-4EF4-85 | PO15544120937 | 19 | 284 | 564 | 14 | 282 | 6 | 190.73 | 2024-12-19 | 953.63 | 19.07 | 2024-12-07 | 1 | 1481.94 | 1 | 762.90 | 19 | SO53477 | 2024-12-14 | 61.03 | 1481.94 | 953.63 | 0.20 |
| SO48036_1 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 323 | 66 | 6 | 2024-02-19 | 2348.97 | 58.72 | 2024-02-07 | 5 | 486.71 | 1 | 2348.97 | 1 | SO48036 | 2024-02-14 | 187.92 | 2433.53 | 469.79 | |||
| SO47354_44 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 325 | 173 | 6 | 2023-12-20 | 469.79 | 11.74 | 2023-12-08 | 1 | 486.71 | 1 | 469.79 | 44 | SO47354 | 2023-12-15 | 37.58 | 486.71 | 469.79 | |||
| SO65188_10 | 86B3-49B3-A1 | PO14790112162 | 19 | 291 | 400 | 497 | 6 | 2025-06-19 | 74.30 | 1.86 | 2025-06-07 | 2 | 27.49 | 1 | 74.30 | 10 | SO65188 | 2025-06-14 | 5.94 | 54.99 | 37.15 | |||
| SO48299_30 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 420 | 118 | 6 | 2024-03-20 | 566.46 | 14.16 | 2024-03-08 | 4 | 104.80 | 1 | 566.46 | 30 | SO48299 | 2024-03-15 | 45.32 | 419.18 | 141.62 | |||
| SO47662_15 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 358 | 442 | 6 | 2024-01-19 | 3688.38 | 92.21 | 2024-01-07 | 3 | 1105.81 | 1 | 3688.38 | 15 | SO47662 | 2024-01-14 | 295.07 | 3317.43 | 1229.46 | |||
| SO50716_17 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 458 | 118 | 6 | 2024-09-18 | 359.95 | 9.00 | 2024-09-06 | 8 | 30.93 | 1 | 359.95 | 17 | SO50716 | 2024-09-13 | 28.80 | 247.47 | 44.99 | |||
| SO53508_10 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 553 | 48 | 6 | 2024-12-19 | 55.31 | 1.38 | 2024-12-07 | 2 | 20.46 | 1 | 55.31 | 10 | SO53508 | 2024-12-14 | 4.42 | 40.93 | 27.65 | |||
| SO44490_1 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 322 | 210 | 6 | 2023-02-19 | 419.46 | 10.49 | 2023-02-07 | 1 | 413.15 | 1 | 419.46 | 1 | SO44490 | 2023-02-14 | 33.56 | 413.15 | 419.46 | |||
| SO48036_40 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 368 | 66 | 6 | 2024-02-19 | 2932.02 | 73.30 | 2024-02-07 | 2 | 1518.79 | 1 | 2932.02 | 40 | SO48036 | 2024-02-14 | 234.56 | 3037.57 | 1466.01 | |||
| SO58972_50 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 475 | 10 | 6 | 2025-03-20 | 209.97 | 5.25 | 2025-03-08 | 5 | 26.18 | 1 | 209.97 | 50 | SO58972 | 2025-03-15 | 16.80 | 130.88 | 41.99 |
Generated 2025-11-06 15:15:32.578 UTC