[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 31 > < TAKE 31 >
31 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO67272_24 | F467-41BF-8B | PO13862111340 | 19 | 291 | 524 | 119 | 6 | 2025-07-19 | 158.43 | 3.96 | 2025-07-07 | 1 | 144.59 | 1 | 158.43 | 24 | SO67272 | 2025-07-14 | 12.67 | 144.59 | 158.43 | |||
| SO59003_2 | 514A-4B62-B4 | PO14239121229 | 19 | 291 | 483 | 550 | 6 | 2025-03-19 | 144.00 | 3.60 | 2025-03-07 | 2 | 44.88 | 1 | 144.00 | 2 | SO59003 | 2025-03-14 | 11.52 | 89.76 | 72.00 | |||
| SO45047_7 | B1C5-444F-BF | PO14732155479 | 19 | 288 | 285 | 514 | 6 | 2023-04-20 | 178.58 | 4.46 | 2023-04-08 | 1 | 176.20 | 1 | 178.58 | 7 | SO45047 | 2023-04-15 | 14.29 | 176.20 | 178.58 | |||
| SO44288_27 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 328 | 514 | 6 | 2023-01-18 | 1677.84 | 41.95 | 2023-01-06 | 4 | 413.15 | 1 | 1677.84 | 27 | SO44288 | 2023-01-13 | 134.23 | 1652.59 | 419.46 | |||
| SO46657_53 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 364 | 496 | 6 | 2023-10-18 | 3887.96 | 97.20 | 2023-10-06 | 6 | 598.44 | 1 | 3887.96 | 53 | SO46657 | 2023-10-13 | 311.04 | 3590.61 | 647.99 | |||
| SO48764_26 | B2E5-4B83-BC | PO18444188685 | 19 | 291 | 435 | 227 | 6 | 2024-04-19 | 324.45 | 8.11 | 2024-04-07 | 1 | 300.12 | 1 | 324.45 | 26 | SO48764 | 2024-04-14 | 25.96 | 300.12 | 324.45 | |||
| SO47365_38 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 421 | 2 | 678 | 6 | 45.55 | 2023-12-19 | 2277.42 | 55.80 | 2023-12-07 | 12 | 145.28 | 1 | 2231.87 | 38 | SO47365 | 2023-12-14 | 178.55 | 1743.40 | 189.78 | 0.02 |
| SO61177_2 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 531 | 442 | 6 | 2025-04-19 | 749.37 | 18.73 | 2025-04-07 | 5 | 136.79 | 1 | 749.37 | 2 | SO61177 | 2025-04-14 | 59.95 | 683.93 | 149.87 | |||
| SO71841_42 | 1544-4561-AB | PO1798133189 | 19 | 291 | 361 | 10 | 6 | 2025-09-18 | 4130.98 | 103.27 | 2025-09-06 | 3 | 1251.98 | 1 | 4130.98 | 42 | SO71841 | 2025-09-13 | 330.48 | 3755.94 | 1376.99 | |||
| SO69400_12 | 761C-4315-82 | PO17806199596 | 19 | 291 | 547 | 101 | 6 | 2025-08-18 | 48.59 | 1.21 | 2025-08-06 | 1 | 35.96 | 1 | 48.59 | 12 | SO69400 | 2025-08-13 | 3.89 | 35.96 | 48.59 | |||
| SO53536_59 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 467 | 118 | 6 | 2024-12-18 | 132.25 | 3.31 | 2024-12-06 | 9 | 9.16 | 1 | 132.25 | 59 | SO53536 | 2024-12-13 | 10.58 | 82.43 | 14.69 | |||
| SO50735_2 | 915C-46CF-8E | PO2001132307 | 19 | 291 | 429 | 701 | 6 | 2024-09-17 | 973.36 | 24.33 | 2024-09-05 | 3 | 300.12 | 1 | 973.36 | 2 | SO50735 | 2024-09-12 | 77.87 | 900.36 | 324.45 | |||
| SO58972_15 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 357 | 10 | 6 | 2025-03-19 | 12527.95 | 313.20 | 2025-03-07 | 9 | 1265.62 | 1 | 12527.95 | 15 | SO58972 | 2025-03-14 | 1002.24 | 11390.58 | 1391.99 | |||
| SO69398_5 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 231 | 28 | 6 | 2025-08-18 | 89.98 | 2.25 | 2025-08-06 | 3 | 38.49 | 1 | 89.98 | 5 | SO69398 | 2025-08-13 | 7.20 | 115.48 | 29.99 | |||
| SO46938_18 | 2E58-4440-89 | PO19198122384 | 19 | 291 | 354 | 653 | 6 | 2023-11-18 | 6214.26 | 155.36 | 2023-11-06 | 5 | 1117.86 | 1 | 6214.26 | 18 | SO46938 | 2023-11-13 | 497.14 | 5589.28 | 1242.85 | |||
| SO46062_21 | 114A-41C0-B5 | PO11600112515 | 19 | 288 | 324 | 569 | 6 | 2023-08-18 | 1677.84 | 41.95 | 2023-08-06 | 4 | 413.15 | 1 | 1677.84 | 21 | SO46062 | 2023-08-13 | 134.23 | 1652.59 | 419.46 | |||
| SO47380_13 | EF71-4036-91 | PO14790123967 | 19 | 291 | 401 | 497 | 6 | 2023-12-19 | 196.81 | 4.92 | 2023-12-07 | 3 | 48.55 | 1 | 196.81 | 13 | SO47380 | 2023-12-14 | 15.74 | 145.64 | 65.60 | |||
| SO49496_3 | 1BAD-4D34-B0 | PO10614179686 | 19 | 291 | 335 | 461 | 6 | 2024-06-17 | 939.59 | 23.49 | 2024-06-05 | 2 | 486.71 | 1 | 939.59 | 3 | SO49496 | 2024-06-12 | 75.17 | 973.41 | 469.79 | |||
| SO45797_4 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 317 | 679 | 6 | 2023-07-19 | 874.79 | 21.87 | 2023-07-07 | 1 | 884.71 | 1 | 874.79 | 4 | SO45797 | 2023-07-14 | 69.98 | 884.71 | 874.79 | |||
| SO48750_7 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 454 | 514 | 6 | 2024-04-19 | 35.99 | 0.90 | 2024-04-07 | 1 | 24.75 | 1 | 35.99 | 7 | SO48750 | 2024-04-14 | 2.88 | 24.75 | 35.99 | |||
| SO46330_13 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 307 | 118 | 6 | 2023-09-18 | 1445.19 | 36.13 | 2023-09-06 | 2 | 623.84 | 1 | 1445.19 | 13 | SO46330 | 2023-09-13 | 115.62 | 1247.68 | 722.59 | |||
| SO51772_19 | 7800-4280-A7 | PO1827195162 | 19 | 291 | 605 | 317 | 6 | 2024-11-17 | 1943.96 | 48.60 | 2024-11-05 | 6 | 343.65 | 1 | 1943.96 | 19 | SO51772 | 2024-11-12 | 155.52 | 2061.90 | 323.99 | |||
| SO71806_7 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 533 | 497 | 6 | 2025-09-18 | 149.87 | 3.75 | 2025-09-06 | 1 | 136.79 | 1 | 149.87 | 7 | SO71806 | 2025-09-13 | 11.99 | 136.79 | 149.87 | |||
| SO69399_23 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 585 | 264 | 6 | 2025-08-18 | 1336.23 | 33.41 | 2025-08-06 | 3 | 461.44 | 1 | 1336.23 | 23 | SO69399 | 2025-08-13 | 106.90 | 1384.33 | 445.41 | |||
| SO45522_1 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 232 | 173 | 6 | 2023-06-18 | 28.84 | 0.72 | 2023-06-06 | 1 | 31.72 | 1 | 28.84 | 1 | SO45522 | 2023-06-13 | 2.31 | 31.72 | 28.84 | |||
| SO53545_11 | 2CC7-4F36-B6 | PO14239178578 | 19 | 291 | 472 | 550 | 6 | 2024-12-18 | 152.40 | 3.81 | 2024-12-06 | 4 | 23.75 | 1 | 152.40 | 11 | SO53545 | 2024-12-13 | 12.19 | 95.00 | 38.10 | |||
| SO48299_38 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 366 | 118 | 6 | 2024-03-19 | 2591.98 | 64.80 | 2024-03-07 | 4 | 598.44 | 1 | 2591.98 | 38 | SO48299 | 2024-03-14 | 207.36 | 2393.74 | 647.99 | |||
| SO69401_21 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 237 | 12 | 6 | 2025-08-18 | 29.99 | 0.75 | 2025-08-06 | 1 | 38.49 | 1 | 29.99 | 21 | SO69401 | 2025-08-13 | 2.40 | 38.49 | 29.99 | |||
| SO65164_33 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 217 | 118 | 6 | 2025-06-18 | 83.98 | 2.10 | 2025-06-06 | 4 | 13.09 | 1 | 83.98 | 33 | SO65164 | 2025-06-13 | 6.72 | 52.35 | 20.99 | |||
| SO69399_27 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 576 | 264 | 6 | 2025-08-18 | 4291.33 | 107.28 | 2025-08-06 | 3 | 1481.94 | 1 | 4291.33 | 27 | SO69399 | 2025-08-13 | 343.31 | 4445.81 | 1430.44 | |||
| SO67302_36 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 290 | 442 | 6 | 2025-07-19 | 1637.40 | 40.94 | 2025-07-07 | 2 | 747.20 | 1 | 1637.40 | 36 | SO67302 | 2025-07-14 | 130.99 | 1494.40 | 818.70 |
Generated 2025-11-05 15:31:47.949 UTC