[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE < SKIP 140 > < TAKE 30 >
30 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO71871_3 | DD8F-4CAB-A1 | PO14239120760 | 19 | 291 | 481 | 550 | 6 | 2025-09-19 | 10.79 | 0.27 | 2025-09-07 | 2 | 3.36 | 1 | 10.79 | 3 | SO71871 | 2025-09-14 | 0.86 | 6.72 | 5.39 | |||
| SO49513_5 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 360 | 685 | 6 | 2024-06-18 | 2458.92 | 61.47 | 2024-06-06 | 2 | 1105.81 | 1 | 2458.92 | 5 | SO49513 | 2024-06-13 | 196.71 | 2211.62 | 1229.46 | |||
| SO61196_17 | 8DD6-4DC9-A5 | PO1711193720 | 19 | 291 | 524 | 245 | 6 | 2025-04-20 | 633.72 | 15.84 | 2025-04-08 | 4 | 144.59 | 1 | 633.72 | 17 | SO61196 | 2025-04-15 | 50.70 | 578.38 | 158.43 | |||
| SO51791_18 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 491 | 3 | 552 | 6 | 26.73 | 2024-11-18 | 534.50 | 12.69 | 2024-11-06 | 18 | 41.57 | 1 | 507.78 | 18 | SO51791 | 2024-11-13 | 40.62 | 748.30 | 29.69 | 0.05 |
| SO50699_20 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 356 | 588 | 6 | 2024-09-18 | 4971.41 | 124.29 | 2024-09-06 | 4 | 1117.86 | 1 | 4971.41 | 20 | SO50699 | 2024-09-13 | 397.71 | 4471.42 | 1242.85 | |||
| SO55297_56 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 515 | 496 | 6 | 2025-01-18 | 65.09 | 1.63 | 2025-01-06 | 4 | 12.04 | 1 | 65.09 | 56 | SO55297 | 2025-01-13 | 5.21 | 48.17 | 16.27 | |||
| SO46959_10 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 271 | 533 | 6 | 2023-11-19 | 1213.99 | 30.35 | 2023-11-07 | 6 | 187.16 | 1 | 1213.99 | 10 | SO46959 | 2023-11-14 | 97.12 | 1122.94 | 202.33 | |||
| SO47365_17 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 221 | 678 | 6 | 2023-12-20 | 121.12 | 3.03 | 2023-12-08 | 6 | 13.88 | 1 | 121.12 | 17 | SO47365 | 2023-12-15 | 9.69 | 83.27 | 20.19 | |||
| SO44283_3 | D5FF-488D-B7 | PO18444150042 | 19 | 288 | 272 | 227 | 6 | 2023-01-19 | 183.94 | 4.60 | 2023-01-07 | 1 | 181.49 | 1 | 183.94 | 3 | SO44283 | 2023-01-14 | 14.72 | 181.49 | 183.94 | |||
| SO46086_12 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 262 | 84 | 6 | 2023-08-19 | 551.81 | 13.80 | 2023-08-07 | 3 | 181.49 | 1 | 551.81 | 12 | SO46086 | 2023-08-14 | 44.15 | 544.46 | 183.94 | |||
| SO71792_22 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 374 | 155 | 6 | 2025-09-19 | 1466.01 | 36.65 | 2025-09-07 | 1 | 1554.95 | 1 | 1466.01 | 22 | SO71792 | 2025-09-14 | 117.28 | 1554.95 | 1466.01 | |||
| SO63128_1 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 563 | 64 | 6 | 2025-05-21 | 1430.44 | 35.76 | 2025-05-09 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO63128 | 2025-05-16 | 114.44 | 1481.94 | 1430.44 | |||
| SO48340_14 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 409 | 685 | 6 | 2024-03-20 | 209.26 | 5.23 | 2024-03-08 | 1 | 185.82 | 1 | 209.26 | 14 | SO48340 | 2024-03-15 | 16.74 | 185.82 | 209.26 | |||
| SO51704_42 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 490 | 264 | 6 | 2024-11-18 | 291.55 | 7.29 | 2024-11-06 | 9 | 41.57 | 1 | 291.55 | 42 | SO51704 | 2024-11-13 | 23.32 | 374.15 | 32.39 | |||
| SO58932_36 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 483 | 2 | 408 | 6 | 16.70 | 2025-03-20 | 835.20 | 20.46 | 2025-03-08 | 12 | 44.88 | 1 | 818.50 | 36 | SO58932 | 2025-03-15 | 65.48 | 538.56 | 69.60 | 0.02 |
| SO45323_2 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 334 | 84 | 6 | 2023-05-22 | 419.46 | 10.49 | 2023-05-10 | 1 | 413.15 | 1 | 419.46 | 2 | SO45323 | 2023-05-17 | 33.56 | 413.15 | 419.46 | |||
| SO57024_32 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 603 | 264 | 6 | 2025-02-18 | 72.89 | 1.82 | 2025-02-06 | 1 | 53.94 | 1 | 72.89 | 32 | SO57024 | 2025-02-13 | 5.83 | 53.94 | 72.89 | |||
| SO57082_2 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 255 | 426 | 6 | 2025-02-18 | 1213.99 | 30.35 | 2025-02-06 | 6 | 204.63 | 1 | 1213.99 | 2 | SO57082 | 2025-02-13 | 97.12 | 1227.75 | 202.33 | |||
| SO49480_9 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 327 | 173 | 6 | 2024-06-18 | 1409.38 | 35.23 | 2024-06-06 | 3 | 486.71 | 1 | 1409.38 | 9 | SO49480 | 2024-06-13 | 112.75 | 1460.12 | 469.79 | |||
| SO53535_19 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 564 | 14 | 154 | 6 | 2860.88 | 2024-12-19 | 14304.42 | 286.09 | 2024-12-07 | 15 | 1481.94 | 1 | 11443.54 | 19 | SO53535 | 2024-12-14 | 915.48 | 22229.07 | 953.63 | 0.20 |
| SO47366_18 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 233 | 2 | 155 | 6 | 6.69 | 2023-12-20 | 334.55 | 8.20 | 2023-12-08 | 12 | 29.08 | 1 | 327.86 | 18 | SO47366 | 2023-12-15 | 26.23 | 348.97 | 27.88 | 0.02 |
| SO57082_18 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 471 | 426 | 6 | 2025-02-18 | 228.60 | 5.72 | 2025-02-06 | 6 | 23.75 | 1 | 228.60 | 18 | SO57082 | 2025-02-13 | 18.29 | 142.49 | 38.10 | |||
| SO67316_15 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 594 | 496 | 6 | 2025-07-20 | 677.99 | 16.95 | 2025-07-08 | 2 | 308.22 | 1 | 677.99 | 15 | SO67316 | 2025-07-15 | 54.24 | 616.44 | 338.99 | |||
| SO47008_1 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 454 | 426 | 6 | 2023-11-19 | 71.99 | 1.80 | 2023-11-07 | 2 | 24.75 | 1 | 71.99 | 1 | SO47008 | 2023-11-14 | 5.76 | 49.49 | 35.99 | |||
| SO48754_17 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 453 | 442 | 6 | 2024-04-20 | 107.98 | 2.70 | 2024-04-08 | 3 | 24.75 | 1 | 107.98 | 17 | SO48754 | 2024-04-15 | 8.64 | 74.24 | 35.99 | |||
| SO49501_10 | EF67-4713-BD | PO17574111786 | 19 | 291 | 230 | 678 | 6 | 2024-06-18 | 86.52 | 2.16 | 2024-06-06 | 3 | 29.08 | 1 | 86.52 | 10 | SO49501 | 2024-06-13 | 6.92 | 87.24 | 28.84 | |||
| SO46333_14 | B042-408B-A8 | PO17545158984 | 19 | 288 | 264 | 155 | 6 | 2023-09-19 | 367.88 | 9.20 | 2023-09-07 | 2 | 181.49 | 1 | 367.88 | 14 | SO46333 | 2023-09-14 | 29.43 | 362.97 | 183.94 | |||
| SO49467_5 | 9917-4AE9-86 | PO1798127190 | 19 | 291 | 358 | 10 | 6 | 2024-06-18 | 1229.46 | 30.74 | 2024-06-06 | 1 | 1105.81 | 1 | 1229.46 | 5 | SO49467 | 2024-06-13 | 98.36 | 1105.81 | 1229.46 | |||
| SO47696_15 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 397 | 245 | 6 | 2024-01-19 | 170.06 | 4.25 | 2024-01-07 | 7 | 17.98 | 1 | 170.06 | 15 | SO47696 | 2024-01-14 | 13.60 | 125.85 | 24.29 | |||
| SO48059_35 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 373 | 84 | 6 | 2024-02-19 | 1308.94 | 32.72 | 2024-02-07 | 1 | 1320.68 | 1 | 1308.94 | 35 | SO48059 | 2024-02-14 | 104.72 | 1320.68 | 1308.94 |
Generated 2025-11-06 09:45:18.613 UTC