[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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO51124_29 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 295 | 245 | 6 | 2024-10-12 | 4093.50 | 102.34 | 2024-09-30 | 5 | 747.20 | 1 | 4093.50 | 29 | SO51124 | 2024-10-07 | 327.48 | 3736.00 | 818.70 | |||
| SO49066_28 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 448 | 426 | 6 | 2024-05-15 | 23.99 | 0.60 | 2024-05-03 | 2 | 8.25 | 1 | 23.99 | 28 | SO49066 | 2024-05-10 | 1.92 | 16.49 | 11.99 | |||
| SO51839_15 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 490 | 2 | 84 | 6 | 7.52 | 2024-11-12 | 375.77 | 9.21 | 2024-10-31 | 12 | 41.57 | 1 | 368.26 | 15 | SO51839 | 2024-11-07 | 29.46 | 498.87 | 31.31 | 0.02 |
| SO53529_1 | 1AF3-4D1D-8E | PO2001111337 | 19 | 291 | 518 | 701 | 6 | 2024-12-13 | 16.27 | 0.41 | 2024-12-01 | 1 | 12.04 | 1 | 16.27 | 1 | SO53529 | 2024-12-08 | 1.30 | 12.04 | 16.27 | |||
| SO67316_7 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 531 | 496 | 6 | 2025-07-14 | 449.62 | 11.24 | 2025-07-02 | 3 | 136.79 | 1 | 449.62 | 7 | SO67316 | 2025-07-09 | 35.97 | 410.36 | 149.87 | |||
| SO51791_1 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 287 | 552 | 6 | 2024-11-12 | 404.66 | 10.12 | 2024-10-31 | 2 | 204.63 | 1 | 404.66 | 1 | SO51791 | 2024-11-07 | 32.37 | 409.25 | 202.33 | |||
| SO46950_4 | AAC1-43D9-A3 | PO17806144306 | 19 | 291 | 216 | 101 | 6 | 2023-11-13 | 40.37 | 1.01 | 2023-11-01 | 2 | 13.88 | 1 | 40.37 | 4 | SO46950 | 2023-11-08 | 3.23 | 27.76 | 20.19 | |||
| SO53536_29 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 400 | 118 | 6 | 2024-12-13 | 297.22 | 7.43 | 2024-12-01 | 8 | 27.49 | 1 | 297.22 | 29 | SO53536 | 2024-12-08 | 23.78 | 219.94 | 37.15 | |||
| SO46997_6 | 9714-4035-90 | PO11020181604 | 19 | 284 | 329 | 2 | 336 | 6 | 99.91 | 2023-11-13 | 4995.48 | 122.39 | 2023-11-01 | 11 | 486.71 | 1 | 4895.57 | 6 | SO46997 | 2023-11-08 | 391.65 | 5353.77 | 454.13 | 0.02 |
| SO47397_2 | B964-4D2F-B3 | PO11107130091 | 19 | 284 | 415 | 156 | 6 | 2023-12-14 | 198.04 | 4.95 | 2023-12-02 | 1 | 146.55 | 1 | 198.04 | 2 | SO47397 | 2023-12-09 | 15.84 | 146.55 | 198.04 | |||
| SO58930_30 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 590 | 497 | 6 | 2025-03-14 | 461.69 | 11.54 | 2025-03-02 | 1 | 419.78 | 1 | 461.69 | 30 | SO58930 | 2025-03-09 | 36.94 | 419.78 | 461.69 | |||
| SO57152_3 | 6C7E-4B58-93 | PO2030123828 | 19 | 284 | 597 | 661 | 6 | 2025-02-12 | 323.99 | 8.10 | 2025-01-31 | 1 | 294.58 | 1 | 323.99 | 3 | SO57152 | 2025-02-07 | 25.92 | 294.58 | 323.99 | |||
| SO69542_10 | 990B-4CF0-A7 | PO1827116485 | 19 | 291 | 384 | 317 | 6 | 2025-08-13 | 1344.59 | 33.61 | 2025-08-01 | 2 | 713.08 | 1 | 1344.59 | 10 | SO69542 | 2025-08-08 | 107.57 | 1426.16 | 672.29 | |||
| SO50284_38 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 254 | 84 | 6 | 2024-08-12 | 367.88 | 9.20 | 2024-07-31 | 2 | 170.14 | 1 | 367.88 | 38 | SO50284 | 2024-08-07 | 29.43 | 340.29 | 183.94 | |||
| SO45057_11 | 568E-472E-9C | PO11049133413 | 19 | 284 | 223 | 679 | 6 | 2023-04-15 | 15.56 | 0.39 | 2023-04-03 | 3 | 5.71 | 1 | 15.56 | 11 | SO45057 | 2023-04-10 | 1.24 | 17.12 | 5.19 | |||
| SO69397_17 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 552 | 64 | 6 | 2025-08-13 | 109.79 | 2.74 | 2025-08-01 | 2 | 40.62 | 1 | 109.79 | 17 | SO69397 | 2025-08-08 | 8.78 | 81.24 | 54.89 | |||
| SO47670_48 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 239 | 514 | 6 | 2024-01-13 | 3904.09 | 97.60 | 2024-01-01 | 5 | 722.26 | 1 | 3904.09 | 48 | SO47670 | 2024-01-08 | 312.33 | 3611.28 | 780.82 | |||
| SO48033_8 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 230 | 426 | 6 | 2024-02-13 | 57.68 | 1.44 | 2024-02-01 | 2 | 29.08 | 1 | 57.68 | 8 | SO48033 | 2024-02-08 | 4.61 | 58.16 | 28.84 | |||
| SO48296_22 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 458 | 173 | 6 | 2024-03-14 | 134.98 | 3.37 | 2024-03-02 | 3 | 30.93 | 1 | 134.98 | 22 | SO48296 | 2024-03-09 | 10.80 | 92.80 | 44.99 | |||
| SO69432_1 | A640-45AE-A5 | PO12789195722 | 19 | 291 | 483 | 677 | 6 | 2025-08-13 | 144.00 | 3.60 | 2025-08-01 | 2 | 44.88 | 1 | 144.00 | 1 | SO69432 | 2025-08-08 | 11.52 | 89.76 | 72.00 | |||
| SO48307_13 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 273 | 155 | 6 | 2024-03-14 | 809.33 | 20.23 | 2024-03-02 | 4 | 187.16 | 1 | 809.33 | 13 | SO48307 | 2024-03-09 | 64.75 | 748.63 | 202.33 | |||
| SO48764_5 | B2E5-4B83-BC | PO18444188685 | 19 | 291 | 286 | 227 | 6 | 2024-04-14 | 1103.63 | 27.59 | 2024-04-02 | 6 | 170.14 | 1 | 1103.63 | 5 | SO48764 | 2024-04-09 | 88.29 | 1020.86 | 183.94 | |||
| SO63132_16 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 225 | 479 | 6 | 2025-05-15 | 32.36 | 0.81 | 2025-05-03 | 6 | 6.92 | 1 | 32.36 | 16 | SO63132 | 2025-05-10 | 2.59 | 41.53 | 5.39 | |||
| SO61222_10 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 596 | 119 | 6 | 2025-04-14 | 1619.97 | 40.50 | 2025-04-02 | 5 | 294.58 | 1 | 1619.97 | 10 | SO61222 | 2025-04-09 | 129.60 | 1472.90 | 323.99 | |||
| SO55297_1 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 592 | 496 | 6 | 2025-01-12 | 677.99 | 16.95 | 2024-12-31 | 2 | 308.22 | 1 | 677.99 | 1 | SO55297 | 2025-01-07 | 54.24 | 616.44 | 338.99 | |||
| SO57070_4 | A915-448D-82 | PO11020121552 | 19 | 284 | 606 | 336 | 6 | 2025-02-12 | 971.98 | 24.30 | 2025-01-31 | 3 | 343.65 | 1 | 971.98 | 4 | SO57070 | 2025-02-07 | 77.76 | 1030.95 | 323.99 | |||
| SO50242_30 | A651-4343-86 | PO1595193228 | 19 | 284 | 331 | 426 | 6 | 2024-08-12 | 2348.97 | 58.72 | 2024-07-31 | 5 | 486.71 | 1 | 2348.97 | 30 | SO50242 | 2024-08-07 | 187.92 | 2433.53 | 469.79 | |||
| SO46072_9 | 0D05-4D9C-87 | PO2146167606 | 19 | 284 | 350 | 354 | 6 | 2023-08-13 | 4049.99 | 101.25 | 2023-08-01 | 2 | 1898.09 | 1 | 4049.99 | 9 | SO46072 | 2023-08-08 | 324.00 | 3796.19 | 2024.99 | |||
| SO69538_6 | 631A-4D82-A8 | PO2117162793 | 19 | 284 | 476 | 444 | 6 | 2025-08-13 | 83.99 | 2.10 | 2025-08-01 | 2 | 26.18 | 1 | 83.99 | 6 | SO69538 | 2025-08-08 | 6.72 | 52.35 | 41.99 | |||
| SO48038_4 | AF3A-47B6-B4 | PO2117194241 | 19 | 284 | 470 | 3 | 444 | 6 | 15.67 | 2024-02-13 | 313.42 | 7.44 | 2024-02-01 | 15 | 15.67 | 1 | 297.75 | 4 | SO48038 | 2024-02-08 | 23.82 | 235.06 | 20.89 | 0.05 |
| SO51092_27 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 404 | 299 | 6 | 2024-10-12 | 26.72 | 0.67 | 2024-09-30 | 1 | 19.78 | 1 | 26.72 | 27 | SO51092 | 2024-10-07 | 2.14 | 19.78 | 26.72 |
Generated 2025-10-31 23:01:25.936 UTC