[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > SHUFFLE SKIP 0 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO45786_1 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 315 | 514 | 6 | 2023-07-14 | 7873.15 | 196.83 | 2023-07-02 | 9 | 884.71 | 1 | 7873.15 | 1 | SO45786 | 2023-07-09 | 629.85 | 7962.37 | 874.79 | |||
| SO50284_8 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 265 | 84 | 6 | 2024-08-12 | 404.66 | 10.12 | 2024-07-31 | 2 | 187.16 | 1 | 404.66 | 8 | SO50284 | 2024-08-07 | 32.37 | 374.31 | 202.33 | |||
| SO65173_5 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 390 | 155 | 6 | 2025-06-13 | 2689.18 | 67.23 | 2025-06-01 | 4 | 713.08 | 1 | 2689.18 | 5 | SO65173 | 2025-06-08 | 215.13 | 2852.32 | 672.29 | |||
| SO47008_36 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 456 | 426 | 6 | 2023-11-13 | 224.97 | 5.62 | 2023-11-01 | 5 | 30.93 | 1 | 224.97 | 36 | SO47008 | 2023-11-08 | 18.00 | 154.67 | 44.99 | |||
| SO57154_28 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 222 | 263 | 6 | 2025-02-12 | 188.95 | 4.72 | 2025-01-31 | 9 | 13.09 | 1 | 188.95 | 28 | SO57154 | 2025-02-07 | 15.12 | 117.78 | 20.99 | |||
| SO50284_11 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 439 | 84 | 6 | 2024-08-12 | 780.82 | 19.52 | 2024-07-31 | 1 | 722.26 | 1 | 780.82 | 11 | SO50284 | 2024-08-07 | 62.47 | 722.26 | 780.82 | |||
| SO46930_20 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 358 | 65 | 6 | 2023-11-13 | 2458.92 | 61.47 | 2023-11-01 | 2 | 1105.81 | 1 | 2458.92 | 20 | SO46930 | 2023-11-08 | 196.71 | 2211.62 | 1229.46 | |||
| SO46352_1 | A467-4700-9C | PO10585133264 | 19 | 284 | 351 | 7 | 498 | 6 | 590.62 | 2023-09-13 | 1687.50 | 27.42 | 2023-09-01 | 2 | 1898.09 | 1 | 1096.87 | 1 | SO46352 | 2023-09-08 | 87.75 | 3796.19 | 843.75 | 0.35 |
| SO53465_25 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 475 | 678 | 6 | 2024-12-13 | 125.98 | 3.15 | 2024-12-01 | 3 | 26.18 | 1 | 125.98 | 25 | SO53465 | 2024-12-08 | 10.08 | 78.53 | 41.99 | |||
| SO48296_34 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 327 | 173 | 6 | 2024-03-14 | 939.59 | 23.49 | 2024-03-02 | 2 | 486.71 | 1 | 939.59 | 34 | SO48296 | 2024-03-09 | 75.17 | 973.41 | 469.79 | |||
| SO45529_13 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 292 | 678 | 6 | 2023-06-13 | 2456.10 | 61.40 | 2023-06-01 | 3 | 706.81 | 1 | 2456.10 | 13 | SO45529 | 2023-06-08 | 196.49 | 2120.43 | 818.70 | |||
| SO49484_25 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 216 | 118 | 6 | 2024-06-12 | 60.56 | 1.51 | 2024-05-31 | 3 | 13.88 | 1 | 60.56 | 25 | SO49484 | 2024-06-07 | 4.84 | 41.63 | 20.19 | |||
| SO50295_3 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 358 | 352 | 6 | 2024-08-12 | 3688.38 | 92.21 | 2024-07-31 | 3 | 1105.81 | 1 | 3688.38 | 3 | SO50295 | 2024-08-07 | 295.07 | 3317.43 | 1229.46 | |||
| SO49066_29 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 373 | 426 | 6 | 2024-05-15 | 5235.75 | 130.89 | 2024-05-03 | 4 | 1320.68 | 1 | 5235.75 | 29 | SO49066 | 2024-05-10 | 418.86 | 5282.74 | 1308.94 | |||
| SO65189_18 | 985E-4937-94 | PO14761195376 | 19 | 284 | 572 | 408 | 6 | 2025-06-13 | 1336.23 | 33.41 | 2025-06-01 | 3 | 461.44 | 1 | 1336.23 | 18 | SO65189 | 2025-06-08 | 106.90 | 1384.33 | 445.41 | |||
| SO71877_1 | 7428-4791-8C | PO10904138732 | 19 | 291 | 390 | 244 | 6 | 2025-09-13 | 672.29 | 16.81 | 2025-09-01 | 1 | 713.08 | 1 | 672.29 | 1 | SO71877 | 2025-09-08 | 53.78 | 713.08 | 672.29 | |||
| SO58918_15 | C811-4D40-80 | PO17574131484 | 19 | 291 | 555 | 678 | 6 | 2025-03-14 | 255.60 | 6.39 | 2025-03-02 | 4 | 47.29 | 1 | 255.60 | 15 | SO58918 | 2025-03-09 | 20.45 | 189.14 | 63.90 | |||
| SO47668_36 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 325 | 299 | 6 | 2024-01-13 | 469.79 | 11.74 | 2024-01-01 | 1 | 486.71 | 1 | 469.79 | 36 | SO47668 | 2024-01-08 | 37.58 | 486.71 | 469.79 | |||
| SO44774_7 | 6F0A-4629-A5 | PO1885185716 | 19 | 284 | 232 | 588 | 6 | 2023-03-15 | 28.84 | 0.72 | 2023-03-03 | 1 | 31.72 | 1 | 28.84 | 7 | SO44774 | 2023-03-10 | 2.31 | 31.72 | 28.84 | |||
| SO51839_17 | 411D-4ACA-8E | PO4901195797 | 19 | 284 | 222 | 84 | 6 | 2024-11-12 | 41.99 | 1.05 | 2024-10-31 | 2 | 13.09 | 1 | 41.99 | 17 | SO51839 | 2024-11-07 | 3.36 | 26.17 | 20.99 | |||
| SO48754_8 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 393 | 442 | 6 | 2024-04-14 | 275.39 | 6.88 | 2024-04-02 | 2 | 101.89 | 1 | 275.39 | 8 | SO48754 | 2024-04-09 | 22.03 | 203.79 | 137.69 | |||
| SO53535_23 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 522 | 154 | 6 | 2024-12-13 | 23.48 | 0.59 | 2024-12-01 | 1 | 17.38 | 1 | 23.48 | 23 | SO53535 | 2024-12-08 | 1.88 | 17.38 | 23.48 | |||
| SO71851_42 | AABE-4443-91 | PO18299133687 | 19 | 291 | 231 | 118 | 6 | 2025-09-13 | 179.96 | 4.50 | 2025-09-01 | 6 | 38.49 | 1 | 179.96 | 42 | SO71851 | 2025-09-08 | 14.40 | 230.95 | 29.99 | |||
| SO43850_9 | EBA6-4C6F-86 | PO18415143340 | 19 | 288 | 317 | 191 | 6 | 2022-11-13 | 874.79 | 21.87 | 2022-11-01 | 1 | 884.71 | 1 | 874.79 | 9 | SO43850 | 2022-11-08 | 69.98 | 884.71 | 874.79 | |||
| SO47366_40 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 286 | 155 | 6 | 2023-12-14 | 919.69 | 22.99 | 2023-12-02 | 5 | 170.14 | 1 | 919.69 | 40 | SO47366 | 2023-12-09 | 73.58 | 850.71 | 183.94 | |||
| SO53535_8 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 560 | 154 | 6 | 2024-12-13 | 2186.73 | 54.67 | 2024-12-01 | 3 | 755.15 | 1 | 2186.73 | 8 | SO53535 | 2024-12-08 | 174.94 | 2265.45 | 728.91 | |||
| SO46959_19 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 453 | 533 | 6 | 2023-11-13 | 107.98 | 2.70 | 2023-11-01 | 3 | 24.75 | 1 | 107.98 | 19 | SO46959 | 2023-11-08 | 8.64 | 74.24 | 35.99 | |||
| SO46326_17 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 319 | 173 | 6 | 2023-09-13 | 874.79 | 21.87 | 2023-09-01 | 1 | 884.71 | 1 | 874.79 | 17 | SO46326 | 2023-09-08 | 69.98 | 884.71 | 874.79 | |||
| SO46959_11 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 389 | 533 | 6 | 2023-11-13 | 2401.05 | 60.03 | 2023-11-01 | 4 | 605.65 | 1 | 2401.05 | 11 | SO46959 | 2023-11-08 | 192.08 | 2422.60 | 600.26 | |||
| SO47013_11 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 245 | 317 | 6 | 2023-11-13 | 2342.45 | 58.56 | 2023-11-01 | 3 | 722.26 | 1 | 2342.45 | 11 | SO47013 | 2023-11-08 | 187.40 | 2166.77 | 780.82 | |||
| SO53545_4 | 2CC7-4F36-B6 | PO14239178578 | 19 | 291 | 287 | 550 | 6 | 2024-12-13 | 202.33 | 5.06 | 2024-12-01 | 1 | 204.63 | 1 | 202.33 | 4 | SO53545 | 2024-12-08 | 16.19 | 204.63 | 202.33 |
Generated 2025-10-31 13:58:37.186 UTC