[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '99' > SHUFFLE SKIP 10
47 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44507_2 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 307 | 99 | 5 | 2023-04-01 | 2167.78 | 54.19 | 2023-03-20 | 3 | 623.84 | 1 | 2167.78 | 2 | SO44507 | 2023-03-27 | 173.42 | 1871.52 | 722.59 | |||
| SO44507_11 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 346 | 99 | 5 | 2023-04-01 | 4079.99 | 102.00 | 2023-03-20 | 2 | 1912.15 | 1 | 4079.99 | 11 | SO44507 | 2023-03-27 | 326.40 | 3824.31 | 2039.99 | |||
| SO43862_8 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 300 | 99 | 5 | 2022-12-30 | 809.76 | 20.24 | 2022-12-18 | 1 | 699.09 | 1 | 809.76 | 8 | SO43862 | 2022-12-25 | 64.78 | 699.09 | 809.76 | |||
| SO51799_1 | 9372-4D4A-AF | PO16211136640 | 100 | 285 | 525 | 99 | 5 | 2024-12-29 | 158.43 | 3.96 | 2024-12-17 | 1 | 144.59 | 1 | 158.43 | 1 | SO51799 | 2024-12-24 | 12.67 | 144.59 | 158.43 | |||
| SO43862_7 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 347 | 99 | 5 | 2022-12-30 | 4079.99 | 102.00 | 2022-12-18 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO43862 | 2022-12-25 | 326.40 | 3824.31 | 2039.99 | |||
| SO45289_7 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 350 | 99 | 5 | 2023-07-02 | 8099.98 | 202.50 | 2023-06-20 | 4 | 1898.09 | 1 | 8099.98 | 7 | SO45289 | 2023-06-27 | 648.00 | 7592.38 | 2024.99 | |||
| SO69485_1 | E19F-443F-BB | PO16211116121 | 100 | 285 | 599 | 99 | 5 | 2025-09-29 | 323.99 | 8.10 | 2025-09-17 | 1 | 294.58 | 1 | 323.99 | 1 | SO69485 | 2025-09-24 | 25.92 | 294.58 | 323.99 | |||
| SO45289_3 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 300 | 99 | 5 | 2023-07-02 | 1619.52 | 40.49 | 2023-06-20 | 2 | 699.09 | 1 | 1619.52 | 3 | SO45289 | 2023-06-27 | 129.56 | 1398.19 | 809.76 | |||
| SO45289_8 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 293 | 99 | 5 | 2023-07-02 | 1445.19 | 36.13 | 2023-06-20 | 2 | 623.84 | 1 | 1445.19 | 8 | SO45289 | 2023-06-27 | 115.62 | 1247.68 | 722.59 | |||
| SO45289_4 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 218 | 99 | 5 | 2023-07-02 | 11.40 | 0.29 | 2023-06-20 | 2 | 3.40 | 1 | 11.40 | 4 | SO45289 | 2023-06-27 | 0.91 | 6.79 | 5.70 | |||
| SO49110_1 | DB44-4376-BD | PO16211161509 | 100 | 285 | 420 | 99 | 5 | 2024-07-01 | 141.62 | 3.54 | 2024-06-19 | 1 | 104.80 | 1 | 141.62 | 1 | SO49110 | 2024-06-26 | 11.33 | 104.80 | 141.62 | |||
| SO46047_1 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 347 | 99 | 5 | 2023-09-29 | 8159.98 | 204.00 | 2023-09-17 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO46047 | 2023-09-24 | 652.80 | 7648.62 | 2039.99 | |||
| SO63189_1 | BB3B-4D4C-A6 | PO16211129800 | 100 | 285 | 516 | 99 | 5 | 2025-07-01 | 23.48 | 0.59 | 2025-06-19 | 1 | 17.38 | 1 | 23.48 | 1 | SO63189 | 2025-06-26 | 1.88 | 17.38 | 23.48 | |||
| SO63189_3 | BB3B-4D4C-A6 | PO16211129800 | 100 | 285 | 295 | 99 | 5 | 2025-07-01 | 1637.40 | 40.94 | 2025-06-19 | 2 | 747.20 | 1 | 1637.40 | 3 | SO63189 | 2025-06-26 | 130.99 | 1494.40 | 818.70 | |||
| SO43862_3 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 350 | 99 | 5 | 2022-12-30 | 6074.98 | 151.87 | 2022-12-18 | 3 | 1898.09 | 1 | 6074.98 | 3 | SO43862 | 2022-12-25 | 486.00 | 5694.28 | 2024.99 | |||
| SO44507_5 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 348 | 99 | 5 | 2023-04-01 | 6074.98 | 151.87 | 2023-03-20 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO44507 | 2023-03-27 | 486.00 | 5694.28 | 2024.99 | |||
| SO69485_4 | E19F-443F-BB | PO16211116121 | 100 | 285 | 543 | 99 | 5 | 2025-09-29 | 37.25 | 0.93 | 2025-09-17 | 1 | 27.57 | 1 | 37.25 | 4 | SO69485 | 2025-09-24 | 2.98 | 27.57 | 37.25 | |||
| SO45289_5 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 347 | 99 | 5 | 2023-07-02 | 2039.99 | 51.00 | 2023-06-20 | 1 | 1912.15 | 1 | 2039.99 | 5 | SO45289 | 2023-06-27 | 163.20 | 1912.15 | 2039.99 | |||
| SO44507_6 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 296 | 99 | 5 | 2023-04-01 | 714.70 | 17.87 | 2023-03-20 | 1 | 617.03 | 1 | 714.70 | 6 | SO44507 | 2023-03-27 | 57.18 | 617.03 | 714.70 | |||
| SO46047_7 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 218 | 99 | 5 | 2023-09-29 | 5.70 | 0.14 | 2023-09-17 | 1 | 3.40 | 1 | 5.70 | 7 | SO46047 | 2023-09-24 | 0.46 | 3.40 | 5.70 | |||
| SO44507_12 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 218 | 99 | 5 | 2023-04-01 | 11.40 | 0.29 | 2023-03-20 | 2 | 3.40 | 1 | 11.40 | 12 | SO44507 | 2023-03-27 | 0.91 | 6.79 | 5.70 | |||
| SO43862_4 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 346 | 99 | 5 | 2022-12-30 | 8159.98 | 204.00 | 2022-12-18 | 4 | 1912.15 | 1 | 8159.98 | 4 | SO43862 | 2022-12-25 | 652.80 | 7648.62 | 2039.99 | |||
| SO46047_6 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 288 | 99 | 5 | 2023-09-29 | 1445.19 | 36.13 | 2023-09-17 | 2 | 623.84 | 1 | 1445.19 | 6 | SO46047 | 2023-09-24 | 115.62 | 1247.68 | 722.59 | |||
| SO69485_5 | E19F-443F-BB | PO16211116121 | 100 | 285 | 593 | 16 | 99 | 5 | 45.20 | 2025-09-29 | 113.00 | 1.70 | 2025-09-17 | 1 | 308.22 | 1 | 67.80 | 5 | SO69485 | 2025-09-24 | 5.42 | 308.22 | 113.00 | 0.40 |
| SO51799_3 | 9372-4D4A-AF | PO16211136640 | 100 | 285 | 549 | 99 | 5 | 2024-12-29 | 218.45 | 5.46 | 2024-12-17 | 1 | 199.38 | 1 | 218.45 | 3 | SO51799 | 2024-12-24 | 17.48 | 199.38 | 218.45 | |||
| SO46047_3 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 307 | 99 | 5 | 2023-09-29 | 722.59 | 18.06 | 2023-09-17 | 1 | 623.84 | 1 | 722.59 | 3 | SO46047 | 2023-09-24 | 57.81 | 623.84 | 722.59 | |||
| SO44507_13 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 299 | 99 | 5 | 2023-04-01 | 809.76 | 20.24 | 2023-03-20 | 1 | 699.09 | 1 | 809.76 | 13 | SO44507 | 2023-03-27 | 64.78 | 699.09 | 809.76 | |||
| SO50273_1 | 8358-4E59-86 | PO16211117741 | 100 | 285 | 308 | 99 | 5 | 2024-09-28 | 744.27 | 18.61 | 2024-09-16 | 1 | 660.91 | 1 | 744.27 | 1 | SO50273 | 2024-09-23 | 59.54 | 660.91 | 744.27 | |||
| SO45289_2 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 351 | 99 | 5 | 2023-07-02 | 4049.99 | 101.25 | 2023-06-20 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO45289 | 2023-06-27 | 324.00 | 3796.19 | 2024.99 | |||
| SO69485_3 | E19F-443F-BB | PO16211116121 | 100 | 285 | 359 | 99 | 5 | 2025-09-29 | 2753.99 | 68.85 | 2025-09-17 | 2 | 1251.98 | 1 | 2753.99 | 3 | SO69485 | 2025-09-24 | 220.32 | 2503.96 | 1376.99 | |||
| SO46047_8 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 345 | 99 | 5 | 2023-09-29 | 8159.98 | 204.00 | 2023-09-17 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO46047 | 2023-09-24 | 652.80 | 7648.62 | 2039.99 | |||
| SO44507_9 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 304 | 99 | 5 | 2023-04-01 | 714.70 | 17.87 | 2023-03-20 | 1 | 617.03 | 1 | 714.70 | 9 | SO44507 | 2023-03-27 | 57.18 | 617.03 | 714.70 | |||
| SO57108_1 | FF80-4FA7-94 | PO16211160206 | 100 | 285 | 595 | 99 | 5 | 2025-03-31 | 338.99 | 8.47 | 2025-03-19 | 1 | 308.22 | 1 | 338.99 | 1 | SO57108 | 2025-03-26 | 27.12 | 308.22 | 338.99 | |||
| SO45289_9 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 304 | 99 | 5 | 2023-07-02 | 2144.11 | 53.60 | 2023-06-20 | 3 | 617.03 | 1 | 2144.11 | 9 | SO45289 | 2023-06-27 | 171.53 | 1851.08 | 714.70 | |||
| SO46047_11 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 351 | 99 | 5 | 2023-09-29 | 6074.98 | 151.87 | 2023-09-17 | 3 | 1898.09 | 1 | 6074.98 | 11 | SO46047 | 2023-09-24 | 486.00 | 5694.28 | 2024.99 | |||
| SO43862_5 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 304 | 99 | 5 | 2022-12-30 | 1429.41 | 35.74 | 2022-12-18 | 2 | 617.03 | 1 | 1429.41 | 5 | SO43862 | 2022-12-25 | 114.35 | 1234.06 | 714.70 | |||
| SO46047_10 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 296 | 99 | 5 | 2023-09-29 | 714.70 | 17.87 | 2023-09-17 | 1 | 617.03 | 1 | 714.70 | 10 | SO46047 | 2023-09-24 | 57.18 | 617.03 | 714.70 | |||
| SO44507_10 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 350 | 99 | 5 | 2023-04-01 | 10124.97 | 253.12 | 2023-03-20 | 5 | 1898.09 | 1 | 10124.97 | 10 | SO44507 | 2023-03-27 | 810.00 | 9490.47 | 2024.99 | |||
| SO44507_4 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 292 | 99 | 5 | 2023-04-01 | 818.70 | 20.47 | 2023-03-20 | 1 | 706.81 | 1 | 818.70 | 4 | SO44507 | 2023-03-27 | 65.50 | 706.81 | 818.70 | |||
| SO46047_9 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 346 | 99 | 5 | 2023-09-29 | 6119.98 | 153.00 | 2023-09-17 | 3 | 1912.15 | 1 | 6119.98 | 9 | SO46047 | 2023-09-24 | 489.60 | 5736.46 | 2039.99 | |||
| SO46047_4 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 292 | 99 | 5 | 2023-09-29 | 818.70 | 20.47 | 2023-09-17 | 1 | 706.81 | 1 | 818.70 | 4 | SO46047 | 2023-09-24 | 65.50 | 706.81 | 818.70 | |||
| SO43862_2 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 292 | 99 | 5 | 2022-12-30 | 818.70 | 20.47 | 2022-12-18 | 1 | 706.81 | 1 | 818.70 | 2 | SO43862 | 2022-12-25 | 65.50 | 706.81 | 818.70 | |||
| SO69485_2 | E19F-443F-BB | PO16211116121 | 100 | 285 | 474 | 99 | 5 | 2025-09-29 | 125.98 | 3.15 | 2025-09-17 | 3 | 26.18 | 1 | 125.98 | 2 | SO69485 | 2025-09-24 | 10.08 | 78.53 | 41.99 | |||
| SO44507_3 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 293 | 99 | 5 | 2023-04-01 | 722.59 | 18.06 | 2023-03-20 | 1 | 623.84 | 1 | 722.59 | 3 | SO44507 | 2023-03-27 | 57.81 | 623.84 | 722.59 | |||
| SO45289_1 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 344 | 99 | 5 | 2023-07-02 | 12239.96 | 306.00 | 2023-06-20 | 6 | 1912.15 | 1 | 12239.96 | 1 | SO45289 | 2023-06-27 | 979.20 | 11472.93 | 2039.99 | |||
| SO51799_2 | 9372-4D4A-AF | PO16211136640 | 100 | 285 | 599 | 99 | 5 | 2024-12-29 | 323.99 | 8.10 | 2024-12-17 | 1 | 294.58 | 1 | 323.99 | 2 | SO51799 | 2024-12-24 | 25.92 | 294.58 | 323.99 | |||
| SO45289_6 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 348 | 99 | 5 | 2023-07-02 | 8099.98 | 202.50 | 2023-06-20 | 4 | 1898.09 | 1 | 8099.98 | 6 | SO45289 | 2023-06-27 | 648.00 | 7592.38 | 2024.99 |
Generated 2025-12-17 07:14:45.989 UTC