[ROOT] dt FactResellerSale WHERE DimEmployeeId EQ '272' > < SKIP 750 > < TAKE 1000
42 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57136_18 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 582 | 433 | 1 | 2024-01-18 | 6123.56 | 153.09 | 2024-01-06 | 6 | 1082.51 | 1 | 6123.56 | 18 | SO57136 | 2024-01-13 | 489.89 | 6495.06 | 1020.59 | |||
SO57136_19 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 487 | 433 | 1 | 2024-01-18 | 65.99 | 1.65 | 2024-01-06 | 2 | 20.57 | 1 | 65.99 | 19 | SO57136 | 2024-01-13 | 5.28 | 41.13 | 32.99 | |||
SO57136_20 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 546 | 433 | 1 | 2024-01-18 | 37.25 | 0.93 | 2024-01-06 | 1 | 27.57 | 1 | 37.25 | 20 | SO57136 | 2024-01-13 | 2.98 | 27.57 | 37.25 | |||
SO57136_21 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 225 | 433 | 1 | 2024-01-18 | 26.97 | 0.67 | 2024-01-06 | 5 | 6.92 | 1 | 26.97 | 21 | SO57136 | 2024-01-13 | 2.16 | 34.61 | 5.39 | |||
SO57136_22 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 384 | 433 | 1 | 2024-01-18 | 672.29 | 16.81 | 2024-01-06 | 1 | 713.08 | 1 | 672.29 | 22 | SO57136 | 2024-01-13 | 53.78 | 713.08 | 672.29 | |||
SO57136_23 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 545 | 433 | 1 | 2024-01-18 | 145.76 | 3.64 | 2024-01-06 | 6 | 17.98 | 1 | 145.76 | 23 | SO57136 | 2024-01-13 | 11.66 | 107.87 | 24.29 | |||
SO57136_24 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 477 | 433 | 1 | 2024-01-18 | 20.96 | 0.52 | 2024-01-06 | 7 | 1.87 | 1 | 20.96 | 24 | SO57136 | 2024-01-13 | 1.68 | 13.06 | 2.99 | |||
SO57136_25 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 471 | 433 | 1 | 2024-01-18 | 304.80 | 7.62 | 2024-01-06 | 8 | 23.75 | 1 | 304.80 | 25 | SO57136 | 2024-01-13 | 24.38 | 189.99 | 38.10 | |||
SO57136_26 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 372 | 433 | 1 | 2024-01-18 | 8796.06 | 219.90 | 2024-01-06 | 6 | 1554.95 | 1 | 8796.06 | 26 | SO57136 | 2024-01-13 | 703.68 | 9329.69 | 1466.01 | |||
SO57136_27 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 234 | 433 | 1 | 2024-01-18 | 59.99 | 1.50 | 2024-01-06 | 2 | 38.49 | 1 | 59.99 | 27 | SO57136 | 2024-01-13 | 4.80 | 76.98 | 29.99 | |||
SO57136_28 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 374 | 433 | 1 | 2024-01-18 | 5864.04 | 146.60 | 2024-01-06 | 4 | 1554.95 | 1 | 5864.04 | 28 | SO57136 | 2024-01-13 | 469.12 | 6219.79 | 1466.01 | |||
SO57136_29 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 214 | 433 | 1 | 2024-01-18 | 104.97 | 2.62 | 2024-01-06 | 5 | 13.09 | 1 | 104.97 | 29 | SO57136 | 2024-01-13 | 8.40 | 65.43 | 20.99 | |||
SO57136_30 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 217 | 433 | 1 | 2024-01-18 | 167.95 | 4.20 | 2024-01-06 | 8 | 13.09 | 1 | 167.95 | 30 | SO57136 | 2024-01-13 | 13.44 | 104.69 | 20.99 | |||
SO57136_31 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 434 | 433 | 1 | 2024-01-18 | 1784.49 | 44.61 | 2024-01-06 | 5 | 360.94 | 1 | 1784.49 | 31 | SO57136 | 2024-01-13 | 142.76 | 1804.71 | 356.90 | |||
SO57136_32 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 222 | 433 | 1 | 2024-01-18 | 104.97 | 2.62 | 2024-01-06 | 5 | 13.09 | 1 | 104.97 | 32 | SO57136 | 2024-01-13 | 8.40 | 65.43 | 20.99 | |||
SO57136_33 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 584 | 433 | 1 | 2024-01-18 | 1943.96 | 48.60 | 2024-01-06 | 6 | 343.65 | 1 | 1943.96 | 33 | SO57136 | 2024-01-13 | 155.52 | 2061.90 | 323.99 | |||
SO57136_34 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 481 | 433 | 1 | 2024-01-18 | 43.15 | 1.08 | 2024-01-06 | 8 | 3.36 | 1 | 43.15 | 34 | SO57136 | 2024-01-13 | 3.45 | 26.90 | 5.39 | |||
SO57136_35 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 482 | 3 | 433 | 1 | 4.45 | 2024-01-18 | 89.00 | 2.11 | 2024-01-06 | 18 | 3.36 | 1 | 84.55 | 35 | SO57136 | 2024-01-13 | 6.76 | 60.52 | 4.94 | 0.05 |
SO57136_36 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 380 | 433 | 1 | 2024-01-18 | 2932.02 | 73.30 | 2024-01-06 | 2 | 1554.95 | 1 | 2932.02 | 36 | SO57136 | 2024-01-13 | 234.56 | 3109.90 | 1466.01 | |||
SO57136_37 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 605 | 433 | 1 | 2024-01-18 | 3239.94 | 81.00 | 2024-01-06 | 10 | 343.65 | 1 | 3239.94 | 37 | SO57136 | 2024-01-13 | 259.20 | 3436.50 | 323.99 | |||
SO57136_38 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 386 | 433 | 1 | 2024-01-18 | 3361.47 | 84.04 | 2024-01-06 | 5 | 713.08 | 1 | 3361.47 | 38 | SO57136 | 2024-01-13 | 268.92 | 3565.40 | 672.29 | |||
SO57136_39 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 390 | 433 | 1 | 2024-01-18 | 672.29 | 16.81 | 2024-01-06 | 1 | 713.08 | 1 | 672.29 | 39 | SO57136 | 2024-01-13 | 53.78 | 713.08 | 672.29 | |||
SO49890_39 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 459 | 221 | 4 | 2023-06-18 | 215.98 | 5.40 | 2023-06-06 | 4 | 37.12 | 1 | 215.98 | 39 | SO49890 | 2023-06-13 | 17.28 | 148.48 | 53.99 | |||
SO49890_40 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 230 | 221 | 4 | 2023-06-18 | 86.52 | 2.16 | 2023-06-06 | 3 | 29.08 | 1 | 86.52 | 40 | SO49890 | 2023-06-13 | 6.92 | 87.24 | 28.84 | |||
SO49890_41 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 329 | 221 | 4 | 2023-06-18 | 4228.15 | 105.70 | 2023-06-06 | 9 | 486.71 | 1 | 4228.15 | 41 | SO49890 | 2023-06-13 | 338.25 | 4380.36 | 469.79 | |||
SO49890_42 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 435 | 221 | 4 | 2023-06-18 | 648.91 | 16.22 | 2023-06-06 | 2 | 300.12 | 1 | 648.91 | 42 | SO49890 | 2023-06-13 | 51.91 | 600.24 | 324.45 | |||
SO49890_43 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 466 | 221 | 4 | 2023-06-18 | 56.52 | 1.41 | 2023-06-06 | 4 | 9.71 | 1 | 56.52 | 43 | SO49890 | 2023-06-13 | 4.52 | 38.85 | 14.13 | |||
SO49890_44 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 263 | 221 | 4 | 2023-06-18 | 607.00 | 15.17 | 2023-06-06 | 3 | 187.16 | 1 | 607.00 | 44 | SO49890 | 2023-06-13 | 48.56 | 561.47 | 202.33 | |||
SO49890_45 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 327 | 3 | 221 | 4 | 366.05 | 2023-06-18 | 7320.96 | 173.87 | 2023-06-06 | 17 | 486.71 | 1 | 6954.91 | 45 | SO49890 | 2023-06-13 | 556.39 | 8274.01 | 430.64 | 0.05 |
SO50205_1 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 433 | 259 | 4 | 2023-07-18 | 324.45 | 8.11 | 2023-07-06 | 1 | 300.12 | 1 | 324.45 | 1 | SO50205 | 2023-07-13 | 25.96 | 300.12 | 324.45 | |||
SO50205_2 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 323 | 259 | 4 | 2023-07-18 | 469.79 | 11.74 | 2023-07-06 | 1 | 486.71 | 1 | 469.79 | 2 | SO50205 | 2023-07-13 | 37.58 | 486.71 | 469.79 | |||
SO50205_3 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 325 | 259 | 4 | 2023-07-18 | 469.79 | 11.74 | 2023-07-06 | 1 | 486.71 | 1 | 469.79 | 3 | SO50205 | 2023-07-13 | 37.58 | 486.71 | 469.79 | |||
SO50205_4 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 224 | 259 | 4 | 2023-07-18 | 15.56 | 0.39 | 2023-07-06 | 3 | 5.23 | 1 | 15.56 | 4 | SO50205 | 2023-07-13 | 1.24 | 15.69 | 5.19 | |||
SO50205_5 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 343 | 259 | 4 | 2023-07-18 | 939.59 | 23.49 | 2023-07-06 | 2 | 486.71 | 1 | 939.59 | 5 | SO50205 | 2023-07-13 | 75.17 | 973.41 | 469.79 | |||
SO50205_6 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 458 | 259 | 4 | 2023-07-18 | 134.98 | 3.37 | 2023-07-06 | 3 | 30.93 | 1 | 134.98 | 6 | SO50205 | 2023-07-13 | 10.80 | 92.80 | 44.99 | |||
SO50205_7 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 456 | 259 | 4 | 2023-07-18 | 89.99 | 2.25 | 2023-07-06 | 2 | 30.93 | 1 | 89.99 | 7 | SO50205 | 2023-07-13 | 7.20 | 61.87 | 44.99 | |||
SO50205_8 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 327 | 259 | 4 | 2023-07-18 | 469.79 | 11.74 | 2023-07-06 | 1 | 486.71 | 1 | 469.79 | 8 | SO50205 | 2023-07-13 | 37.58 | 486.71 | 469.79 | |||
SO50205_9 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 329 | 259 | 4 | 2023-07-18 | 469.79 | 11.74 | 2023-07-06 | 1 | 486.71 | 1 | 469.79 | 9 | SO50205 | 2023-07-13 | 37.58 | 486.71 | 469.79 | |||
SO50205_10 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 422 | 259 | 4 | 2023-07-18 | 202.62 | 5.07 | 2023-07-06 | 3 | 49.98 | 1 | 202.62 | 10 | SO50205 | 2023-07-13 | 16.21 | 149.94 | 67.54 | |||
SO50205_11 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 333 | 259 | 4 | 2023-07-18 | 1409.38 | 35.23 | 2023-07-06 | 3 | 486.71 | 1 | 1409.38 | 11 | SO50205 | 2023-07-13 | 112.75 | 1460.12 | 469.79 | |||
SO50205_12 | 9A7F-44D8-AF | PO16762191475 | 100 | 272 | 233 | 259 | 4 | 2023-07-18 | 259.56 | 6.49 | 2023-07-06 | 9 | 29.08 | 1 | 259.56 | 12 | SO50205 | 2023-07-13 | 20.77 | 261.73 | 28.84 | |||
SO50729_1 | CB51-4A79-9F | PO5974114073 | 100 | 272 | 370 | 330 | 4 | 2023-08-18 | 1466.01 | 36.65 | 2023-08-06 | 1 | 1518.79 | 1 | 1466.01 | 1 | SO50729 | 2023-08-13 | 117.28 | 1518.79 | 1466.01 |
Generated 2024-10-05 19:40:42.370 UTC