[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 165 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49472_4 | 653C-45A9-B1 | PO2697138792 | 100 | 282 | 393 | 187 | 4 | 2023-05-03 | 275.39 | 6.88 | 2023-04-21 | 2 | 101.89 | 1 | 275.39 | 4 | SO49472 | 2023-04-28 | 22.03 | 203.79 | 137.69 | |||
SO59023_17 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 596 | 61 | 4 | 2024-02-02 | 1943.96 | 48.60 | 2024-01-21 | 6 | 294.58 | 1 | 1943.96 | 17 | SO59023 | 2024-01-28 | 155.52 | 1767.48 | 323.99 | |||
SO50702_11 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 409 | 187 | 4 | 2023-08-03 | 209.26 | 5.23 | 2023-07-22 | 1 | 185.82 | 1 | 209.26 | 11 | SO50702 | 2023-07-29 | 16.74 | 185.82 | 209.26 | |||
SO55249_35 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 603 | 475 | 4 | 2023-12-03 | 291.58 | 7.29 | 2023-11-21 | 4 | 53.94 | 1 | 291.58 | 35 | SO55249 | 2023-11-28 | 23.33 | 215.77 | 72.89 | |||
SO50226_18 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 370 | 78 | 4 | 2023-07-03 | 1466.01 | 36.65 | 2023-06-21 | 1 | 1518.79 | 1 | 1466.01 | 18 | SO50226 | 2023-06-28 | 117.28 | 1518.79 | 1466.01 | |||
SO57046_28 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 531 | 650 | 1 | 2024-01-03 | 449.62 | 11.24 | 2023-12-22 | 3 | 136.79 | 1 | 449.62 | 28 | SO57046 | 2023-12-29 | 35.97 | 410.36 | 149.87 | |||
SO63257_25 | B81B-4565-85 | PO5771197507 | 100 | 282 | 606 | 79 | 3 | 2024-04-04 | 647.99 | 16.20 | 2024-03-23 | 2 | 343.65 | 1 | 647.99 | 25 | SO63257 | 2024-03-30 | 51.84 | 687.30 | 323.99 | |||
SO71796_12 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 577 | 420 | 4 | 2024-08-03 | 728.91 | 18.22 | 2024-07-22 | 1 | 755.15 | 1 | 728.91 | 12 | SO71796 | 2024-07-29 | 58.31 | 755.15 | 728.91 | |||
SO69422_61 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 525 | 650 | 1 | 2024-07-03 | 792.15 | 19.80 | 2024-06-21 | 5 | 144.59 | 1 | 792.15 | 61 | SO69422 | 2024-06-28 | 63.37 | 722.97 | 158.43 | |||
SO65176_11 | 2516-4DF3-BB | PO17052135284 | 100 | 282 | 493 | 420 | 4 | 2024-05-03 | 200.05 | 5.00 | 2024-04-21 | 1 | 199.85 | 1 | 200.05 | 11 | SO65176 | 2024-04-28 | 16.00 | 199.85 | 200.05 | |||
SO48369_6 | 92AB-4468-B5 | PO4582138864 | 100 | 282 | 308 | 25 | 4 | 2023-02-02 | 1488.55 | 37.21 | 2023-01-21 | 2 | 660.91 | 1 | 1488.55 | 6 | SO48369 | 2023-01-28 | 119.08 | 1321.83 | 744.27 | |||
SO51783_30 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 600 | 697 | 1 | 2023-10-03 | 1943.96 | 48.60 | 2023-09-21 | 6 | 294.58 | 1 | 1943.96 | 30 | SO51783 | 2023-09-28 | 155.52 | 1767.48 | 323.99 | |||
SO71845_25 | 4781-4673-85 | PO2697119362 | 100 | 282 | 532 | 187 | 4 | 2024-08-03 | 299.75 | 7.49 | 2024-07-22 | 2 | 136.79 | 1 | 299.75 | 25 | SO71845 | 2024-07-29 | 23.98 | 273.57 | 149.87 | |||
SO69546_2 | A1BC-4567-82 | PO3219164489 | 100 | 282 | 240 | 493 | 4 | 2024-07-03 | 858.90 | 21.47 | 2024-06-21 | 1 | 868.63 | 1 | 858.90 | 2 | SO69546 | 2024-06-28 | 68.71 | 868.63 | 858.90 | |||
SO53460_28 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 404 | 24 | 4 | 2023-11-03 | 26.72 | 0.67 | 2023-10-22 | 1 | 19.78 | 1 | 26.72 | 28 | SO53460 | 2023-10-29 | 2.14 | 19.78 | 26.72 | |||
SO65244_1 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 572 | 295 | 4 | 2024-05-03 | 445.41 | 11.14 | 2024-04-21 | 1 | 461.44 | 1 | 445.41 | 1 | SO65244 | 2024-04-28 | 35.63 | 461.44 | 445.41 | |||
SO63213_2 | 1A10-4A9D-B4 | PO11745122074 | 100 | 282 | 390 | 97 | 4 | 2024-04-04 | 3361.47 | 84.04 | 2024-03-23 | 5 | 713.08 | 1 | 3361.47 | 2 | SO63213 | 2024-03-30 | 268.92 | 3565.40 | 672.29 | |||
SO48341_15 | A747-471B-97 | PO10701176180 | 100 | 282 | 393 | 133 | 4 | 2023-02-02 | 963.86 | 24.10 | 2023-01-21 | 7 | 101.89 | 1 | 963.86 | 15 | SO48341 | 2023-01-28 | 77.11 | 713.26 | 137.69 | |||
SO53460_27 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 490 | 3 | 24 | 4 | 31.18 | 2023-11-03 | 623.58 | 14.81 | 2023-10-22 | 21 | 41.57 | 1 | 592.41 | 27 | SO53460 | 2023-10-29 | 47.39 | 873.02 | 29.69 | 0.05 |
SO49490_31 | 0396-4322-83 | PO19343175441 | 100 | 282 | 216 | 2 | 24 | 4 | 4.68 | 2023-05-03 | 234.16 | 5.74 | 2023-04-21 | 12 | 13.88 | 1 | 229.48 | 31 | SO49490 | 2023-04-28 | 18.36 | 166.54 | 19.51 | 0.02 |
SO59017_4 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 231 | 25 | 4 | 2024-02-02 | 119.98 | 3.00 | 2024-01-21 | 4 | 38.49 | 1 | 119.98 | 4 | SO59017 | 2024-01-28 | 9.60 | 153.97 | 29.99 | |||
SO57186_5 | EF93-4946-97 | PO8845159326 | 100 | 282 | 476 | 4 | 546 | 3 | 139.98 | 2024-01-03 | 1399.80 | 31.50 | 2023-12-22 | 40 | 26.18 | 1 | 1259.82 | 5 | SO57186 | 2023-12-29 | 100.79 | 1047.05 | 35.00 | 0.10 |
SO63283_17 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 597 | 312 | 4 | 2024-04-04 | 323.99 | 8.10 | 2024-03-23 | 1 | 294.58 | 1 | 323.99 | 17 | SO63283 | 2024-03-30 | 25.92 | 294.58 | 323.99 | |||
SO53459_7 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 576 | 582 | 4 | 2023-11-03 | 2860.88 | 71.52 | 2023-10-22 | 2 | 1481.94 | 1 | 2860.88 | 7 | SO53459 | 2023-10-29 | 228.87 | 2963.88 | 1430.44 | |||
SO53459_13 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 222 | 582 | 4 | 2023-11-03 | 146.96 | 3.67 | 2023-10-22 | 7 | 13.09 | 1 | 146.96 | 13 | SO53459 | 2023-10-29 | 11.76 | 91.60 | 20.99 | |||
SO57042_15 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 582 | 258 | 4 | 2024-01-03 | 4082.38 | 102.06 | 2023-12-22 | 4 | 1082.51 | 1 | 4082.38 | 15 | SO57042 | 2023-12-29 | 326.59 | 4330.04 | 1020.59 | |||
SO57186_50 | EF93-4946-97 | PO8845159326 | 100 | 282 | 591 | 546 | 3 | 2024-01-03 | 1355.98 | 33.90 | 2023-12-22 | 4 | 308.22 | 1 | 1355.98 | 50 | SO57186 | 2023-12-29 | 108.48 | 1232.87 | 338.99 | |||
SO57121_10 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 225 | 79 | 3 | 2024-01-03 | 26.97 | 0.67 | 2023-12-22 | 5 | 6.92 | 1 | 26.97 | 10 | SO57121 | 2023-12-29 | 2.16 | 34.61 | 5.39 | |||
SO49147_27 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 381 | 79 | 3 | 2023-04-05 | 2401.05 | 60.03 | 2023-03-24 | 4 | 605.65 | 1 | 2401.05 | 27 | SO49147 | 2023-03-31 | 192.08 | 2422.60 | 600.26 | |||
SO48397_23 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 391 | 457 | 4 | 2023-02-02 | 177.86 | 4.45 | 2023-01-21 | 2 | 65.81 | 1 | 177.86 | 23 | SO48397 | 2023-01-28 | 14.23 | 131.62 | 88.93 |
Generated 2024-09-20 21:49:33.269 UTC