[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 623 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47662_7 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 448 | 442 | 6 | 2024-01-19 | 35.98 | 0.90 | 2024-01-07 | 3 | 8.25 | 1 | 35.98 | 7 | SO47662 | 2024-01-14 | 2.88 | 24.74 | 11.99 | |||
| SO46657_56 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 458 | 3 | 496 | 6 | 30.93 | 2023-10-19 | 618.67 | 14.69 | 2023-10-07 | 15 | 30.93 | 1 | 587.73 | 56 | SO46657 | 2023-10-14 | 47.02 | 464.00 | 41.24 | 0.05 |
| SO45306_5 | F836-4C32-8D | PO11020195551 | 19 | 284 | 270 | 336 | 6 | 2023-05-22 | 367.88 | 9.20 | 2023-05-10 | 2 | 181.49 | 1 | 367.88 | 5 | SO45306 | 2023-05-17 | 29.43 | 362.97 | 183.94 | |||
| SO61186_3 | C662-487E-B0 | PO14732152217 | 19 | 291 | 584 | 514 | 6 | 2025-04-20 | 323.99 | 8.10 | 2025-04-08 | 1 | 343.65 | 1 | 323.99 | 3 | SO61186 | 2025-04-15 | 25.92 | 343.65 | 323.99 | |||
| SO49484_30 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 305 | 118 | 6 | 2024-06-18 | 736.15 | 18.40 | 2024-06-06 | 1 | 653.70 | 1 | 736.15 | 30 | SO49484 | 2024-06-13 | 58.89 | 653.70 | 736.15 | |||
| SO71841_31 | 1544-4561-AB | PO1798133189 | 19 | 291 | 525 | 10 | 6 | 2025-09-19 | 158.43 | 3.96 | 2025-09-07 | 1 | 144.59 | 1 | 158.43 | 31 | SO71841 | 2025-09-14 | 12.67 | 144.59 | 158.43 | |||
| SO47047_1 | 15AB-44E1-83 | PO6496118179 | 19 | 291 | 354 | 226 | 6 | 2023-11-19 | 1242.85 | 31.07 | 2023-11-07 | 1 | 1117.86 | 1 | 1242.85 | 1 | SO47047 | 2023-11-14 | 99.43 | 1117.86 | 1242.85 | |||
| SO69520_22 | 654B-484B-8F | PO4466144794 | 19 | 291 | 214 | 352 | 6 | 2025-08-19 | 146.96 | 3.67 | 2025-08-07 | 7 | 13.09 | 1 | 146.96 | 22 | SO69520 | 2025-08-14 | 11.76 | 91.60 | 20.99 | |||
| SO51116_2 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 214 | 11 | 480 | 6 | 14.17 | 2024-10-18 | 94.47 | 2.01 | 2024-10-06 | 6 | 13.09 | 1 | 80.30 | 2 | SO51116 | 2024-10-13 | 6.42 | 78.52 | 15.75 | 0.15 |
| SO58914_22 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 418 | 155 | 6 | 2025-03-20 | 713.80 | 17.84 | 2025-03-08 | 2 | 360.94 | 1 | 713.80 | 22 | SO58914 | 2025-03-15 | 57.10 | 721.89 | 356.90 | |||
| SO50204_37 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 233 | 533 | 6 | 2024-08-18 | 173.04 | 4.33 | 2024-08-06 | 6 | 29.08 | 1 | 173.04 | 37 | SO50204 | 2024-08-13 | 13.84 | 174.48 | 28.84 | |||
| SO58918_41 | C811-4D40-80 | PO17574131484 | 19 | 291 | 225 | 3 | 678 | 6 | 4.94 | 2025-03-20 | 98.89 | 2.35 | 2025-03-08 | 20 | 6.92 | 1 | 93.95 | 41 | SO58918 | 2025-03-15 | 7.52 | 138.45 | 4.94 | 0.05 |
| SO46334_20 | F652-4575-B7 | PO17574196050 | 19 | 272 | 218 | 678 | 6 | 2023-09-19 | 39.90 | 1.00 | 2023-09-07 | 7 | 3.40 | 1 | 39.90 | 20 | SO46334 | 2023-09-14 | 3.19 | 23.77 | 5.70 | |||
| SO51793_23 | D763-4929-9B | PO18705168707 | 19 | 291 | 386 | 479 | 6 | 2024-11-18 | 672.29 | 16.81 | 2024-11-06 | 1 | 713.08 | 1 | 672.29 | 23 | SO51793 | 2024-11-13 | 53.78 | 713.08 | 672.29 | |||
| SO53509_16 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 222 | 156 | 6 | 2024-12-19 | 62.98 | 1.57 | 2024-12-07 | 3 | 13.09 | 1 | 62.98 | 16 | SO53509 | 2024-12-14 | 5.04 | 39.26 | 20.99 | |||
| SO47037_27 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 233 | 2 | 84 | 6 | 6.69 | 2023-11-19 | 334.55 | 8.20 | 2023-11-07 | 12 | 29.08 | 1 | 327.86 | 27 | SO47037 | 2023-11-14 | 26.23 | 348.97 | 27.88 | 0.02 |
| SO69520_7 | 654B-484B-8F | PO4466144794 | 19 | 291 | 353 | 352 | 6 | 2025-08-19 | 5567.98 | 139.20 | 2025-08-07 | 4 | 1265.62 | 1 | 5567.98 | 7 | SO69520 | 2025-08-14 | 445.44 | 5062.48 | 1391.99 | |||
| SO47003_3 | 2C85-4918-94 | PO638185142 | 19 | 291 | 354 | 280 | 6 | 2023-11-19 | 3728.56 | 93.21 | 2023-11-07 | 3 | 1117.86 | 1 | 3728.56 | 3 | SO47003 | 2023-11-14 | 298.28 | 3353.57 | 1242.85 | |||
| SO47413_19 | E274-4280-9B | PO1885161774 | 19 | 284 | 213 | 588 | 6 | 2023-12-20 | 60.56 | 1.51 | 2023-12-08 | 3 | 13.88 | 1 | 60.56 | 19 | SO47413 | 2023-12-15 | 4.84 | 41.63 | 20.19 | |||
| SO65164_15 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 298 | 118 | 6 | 2025-06-19 | 809.76 | 20.24 | 2025-06-07 | 1 | 739.04 | 1 | 809.76 | 15 | SO65164 | 2025-06-14 | 64.78 | 739.04 | 809.76 | |||
| SO49085_16 | 7265-4D98-80 | PO19198152404 | 19 | 291 | 396 | 653 | 6 | 2024-05-21 | 149.68 | 3.74 | 2024-05-09 | 2 | 55.38 | 1 | 149.68 | 16 | SO49085 | 2024-05-16 | 11.97 | 110.76 | 74.84 | |||
| SO71792_18 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 388 | 155 | 6 | 2025-09-19 | 2016.88 | 50.42 | 2025-09-07 | 3 | 713.08 | 1 | 2016.88 | 18 | SO71792 | 2025-09-14 | 161.35 | 2139.24 | 672.29 | |||
| SO47008_22 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 373 | 426 | 6 | 2023-11-19 | 10471.50 | 261.79 | 2023-11-07 | 8 | 1320.68 | 1 | 10471.50 | 22 | SO47008 | 2023-11-14 | 837.72 | 10565.47 | 1308.94 | |||
| SO57120_19 | 058D-436F-BF | PO4466170177 | 19 | 291 | 214 | 352 | 6 | 2025-02-18 | 146.96 | 3.67 | 2025-02-06 | 7 | 13.09 | 1 | 146.96 | 19 | SO57120 | 2025-02-13 | 11.76 | 91.60 | 20.99 | |||
| SO55283_33 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 515 | 442 | 6 | 2025-01-18 | 16.27 | 0.41 | 2025-01-06 | 1 | 12.04 | 1 | 16.27 | 33 | SO55283 | 2025-01-13 | 1.30 | 12.04 | 16.27 | |||
| SO47663_32 | 1B17-4C63-B6 | PO18444192283 | 19 | 291 | 343 | 2 | 227 | 6 | 99.91 | 2024-01-19 | 4995.48 | 122.39 | 2024-01-07 | 11 | 486.71 | 1 | 4895.57 | 32 | SO47663 | 2024-01-14 | 391.65 | 5353.77 | 454.13 | 0.02 |
| SO50195_15 | F28B-4548-99 | PO19198175870 | 19 | 291 | 427 | 653 | 6 | 2024-08-18 | 209.26 | 5.23 | 2024-08-06 | 1 | 185.82 | 1 | 209.26 | 15 | SO50195 | 2024-08-13 | 16.74 | 185.82 | 209.26 | |||
| SO48351_3 | 0478-43AC-AB | PO1885129829 | 19 | 284 | 410 | 588 | 6 | 2024-03-20 | 72.89 | 1.82 | 2024-03-08 | 2 | 26.97 | 1 | 72.89 | 3 | SO48351 | 2024-03-15 | 5.83 | 53.94 | 36.45 | |||
| SO47980_28 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 461 | 12 | 6 | 2024-02-19 | 215.98 | 5.40 | 2024-02-07 | 4 | 37.12 | 1 | 215.98 | 28 | SO47980 | 2024-02-14 | 17.28 | 148.48 | 53.99 | |||
| SO50687_19 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 308 | 685 | 6 | 2024-09-18 | 2232.82 | 55.82 | 2024-09-06 | 3 | 660.91 | 1 | 2232.82 | 19 | SO50687 | 2024-09-13 | 178.63 | 1982.74 | 744.27 | |||
| SO47365_48 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 457 | 678 | 6 | 2023-12-20 | 179.98 | 4.50 | 2023-12-08 | 4 | 30.93 | 1 | 179.98 | 48 | SO47365 | 2023-12-15 | 14.40 | 123.73 | 44.99 |
Generated 2025-11-06 10:26:03.934 UTC