[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 62 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55276_20 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 561 | 205 | 4 | 2023-12-02 | 5721.77 | 143.04 | 2023-11-20 | 4 | 1481.94 | 1 | 5721.77 | 20 | SO55276 | 2023-11-27 | 457.74 | 5927.75 | 1430.44 | |||
SO50249_10 | 72CA-4901-8D | PO2320117235 | 100 | 282 | 271 | 529 | 4 | 2023-07-02 | 202.33 | 5.06 | 2023-06-20 | 1 | 187.16 | 1 | 202.33 | 10 | SO50249 | 2023-06-27 | 16.19 | 187.16 | 202.33 | |||
SO48065_30 | 1B78-4DE6-BC | PO5771120852 | 100 | 282 | 387 | 79 | 3 | 2023-01-02 | 4201.84 | 105.05 | 2022-12-21 | 7 | 605.65 | 1 | 4201.84 | 30 | SO48065 | 2022-12-28 | 336.15 | 4239.54 | 600.26 | |||
SO55256_19 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 556 | 331 | 4 | 2023-12-02 | 631.76 | 15.79 | 2023-11-20 | 6 | 77.92 | 1 | 631.76 | 19 | SO55256 | 2023-11-27 | 50.54 | 467.51 | 105.29 | |||
SO67298_26 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 500 | 205 | 4 | 2024-06-02 | 1807.04 | 45.18 | 2024-05-21 | 3 | 601.74 | 1 | 1807.04 | 26 | SO67298 | 2024-05-28 | 144.56 | 1805.23 | 602.35 | |||
SO47002_1 | BC9F-453B-99 | PO609116671 | 100 | 282 | 456 | 492 | 4 | 2022-10-02 | 89.99 | 2.25 | 2022-09-20 | 2 | 30.93 | 1 | 89.99 | 1 | SO47002 | 2022-09-27 | 7.20 | 61.87 | 44.99 | |||
SO67347_19 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 606 | 523 | 3 | 2024-06-02 | 1295.98 | 32.40 | 2024-05-21 | 4 | 343.65 | 1 | 1295.98 | 19 | SO67347 | 2024-05-28 | 103.68 | 1374.60 | 323.99 | |||
SO57042_3 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 580 | 258 | 4 | 2024-01-02 | 2041.19 | 51.03 | 2023-12-21 | 2 | 1082.51 | 1 | 2041.19 | 3 | SO57042 | 2023-12-28 | 163.30 | 2165.02 | 1020.59 | |||
SO53598_5 | 6B0D-4AF3-AB | PO174179317 | 100 | 282 | 583 | 277 | 4 | 2023-11-02 | 1020.59 | 25.51 | 2023-10-21 | 1 | 1082.51 | 1 | 1020.59 | 5 | SO53598 | 2023-10-28 | 81.65 | 1082.51 | 1020.59 | |||
SO58909_46 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 481 | 24 | 4 | 2024-02-01 | 16.18 | 0.40 | 2024-01-20 | 3 | 3.36 | 1 | 16.18 | 46 | SO58909 | 2024-01-27 | 1.29 | 10.09 | 5.39 | |||
SO50226_29 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 327 | 78 | 4 | 2023-07-02 | 939.59 | 23.49 | 2023-06-20 | 2 | 486.71 | 1 | 939.59 | 29 | SO50226 | 2023-06-27 | 75.17 | 973.41 | 469.79 | |||
SO69532_17 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 472 | 312 | 4 | 2024-07-02 | 266.70 | 6.67 | 2024-06-20 | 7 | 23.75 | 1 | 266.70 | 17 | SO69532 | 2024-06-27 | 21.34 | 166.24 | 38.10 | |||
SO67298_22 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 586 | 205 | 4 | 2024-06-02 | 3563.28 | 89.08 | 2024-05-21 | 8 | 461.44 | 1 | 3563.28 | 22 | SO67298 | 2024-05-28 | 285.06 | 3691.56 | 445.41 | |||
SO67273_38 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 306 | 475 | 4 | 2024-06-02 | 3239.04 | 80.98 | 2024-05-21 | 4 | 739.04 | 1 | 3239.04 | 38 | SO67273 | 2024-05-28 | 259.12 | 2956.16 | 809.76 | |||
SO49105_3 | B762-4BA5-A0 | PO14500175804 | 100 | 282 | 397 | 650 | 1 | 2023-04-04 | 24.29 | 0.61 | 2023-03-23 | 1 | 17.98 | 1 | 24.29 | 3 | SO49105 | 2023-03-30 | 1.94 | 17.98 | 24.29 | |||
SO48356_5 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 393 | 187 | 4 | 2023-02-01 | 826.16 | 20.65 | 2023-01-20 | 6 | 101.89 | 1 | 826.16 | 5 | SO48356 | 2023-01-27 | 66.09 | 611.36 | 137.69 | |||
SO53606_18 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 531 | 61 | 4 | 2023-11-02 | 149.87 | 3.75 | 2023-10-21 | 1 | 136.79 | 1 | 149.87 | 18 | SO53606 | 2023-10-28 | 11.99 | 136.79 | 149.87 | |||
SO71783_39 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 225 | 2 | 24 | 4 | 1.15 | 2024-08-02 | 57.36 | 1.41 | 2024-07-21 | 11 | 6.92 | 1 | 56.21 | 39 | SO71783 | 2024-07-28 | 4.50 | 76.15 | 5.21 | 0.02 |
SO69532_49 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 225 | 312 | 4 | 2024-07-02 | 37.76 | 0.94 | 2024-06-20 | 7 | 6.92 | 1 | 37.76 | 49 | SO69532 | 2024-06-27 | 3.02 | 48.46 | 5.39 | |||
SO46625_44 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 289 | 475 | 4 | 2022-09-01 | 744.27 | 18.61 | 2022-08-20 | 1 | 660.91 | 1 | 744.27 | 44 | SO46625 | 2022-08-27 | 59.54 | 660.91 | 744.27 | |||
SO47002_2 | BC9F-453B-99 | PO609116671 | 100 | 282 | 216 | 492 | 4 | 2022-10-02 | 60.56 | 1.51 | 2022-09-20 | 3 | 13.88 | 1 | 60.56 | 2 | SO47002 | 2022-09-27 | 4.84 | 41.63 | 20.19 | |||
SO55249_56 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 488 | 475 | 4 | 2023-12-02 | 129.58 | 3.24 | 2023-11-20 | 4 | 41.57 | 1 | 129.58 | 56 | SO55249 | 2023-11-27 | 10.37 | 166.29 | 32.39 | |||
SO51090_7 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 588 | 475 | 4 | 2023-09-01 | 1846.78 | 46.17 | 2023-08-20 | 4 | 419.78 | 1 | 1846.78 | 7 | SO51090 | 2023-08-27 | 147.74 | 1679.11 | 461.69 | |||
SO46972_10 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 297 | 650 | 1 | 2022-10-02 | 1472.29 | 36.81 | 2022-09-20 | 2 | 653.70 | 1 | 1472.29 | 10 | SO46972 | 2022-09-27 | 117.78 | 1307.39 | 736.15 | |||
SO55324_36 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 482 | 523 | 3 | 2023-12-02 | 21.58 | 0.54 | 2023-11-20 | 4 | 3.36 | 1 | 21.58 | 36 | SO55324 | 2023-11-27 | 1.73 | 13.45 | 5.39 | |||
SO50249_9 | 72CA-4901-8D | PO2320117235 | 100 | 282 | 414 | 529 | 4 | 2023-07-02 | 298.06 | 7.45 | 2023-06-20 | 2 | 110.28 | 1 | 298.06 | 9 | SO50249 | 2023-06-27 | 23.85 | 220.57 | 149.03 | |||
SO49058_8 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 236 | 78 | 4 | 2023-04-04 | 86.52 | 2.16 | 2023-03-23 | 3 | 29.08 | 1 | 86.52 | 8 | SO49058 | 2023-03-30 | 6.92 | 87.24 | 28.84 | |||
SO48049_25 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 469 | 312 | 4 | 2023-01-02 | 113.97 | 2.85 | 2022-12-21 | 5 | 15.67 | 1 | 113.97 | 25 | SO48049 | 2022-12-28 | 9.12 | 78.35 | 22.79 | |||
SO49132_20 | 3562-4169-86 | PO3799126007 | 100 | 282 | 365 | 312 | 4 | 2023-04-04 | 3887.96 | 97.20 | 2023-03-23 | 6 | 598.44 | 1 | 3887.96 | 20 | SO49132 | 2023-03-30 | 311.04 | 3590.61 | 647.99 | |||
SO46671_36 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 333 | 523 | 3 | 2022-09-01 | 2348.97 | 58.72 | 2022-08-20 | 5 | 486.71 | 1 | 2348.97 | 36 | SO46671 | 2022-08-27 | 187.92 | 2433.53 | 469.79 | |||
SO51090_38 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 491 | 3 | 475 | 4 | 23.76 | 2023-09-01 | 475.11 | 11.28 | 2023-08-20 | 16 | 41.57 | 1 | 451.36 | 38 | SO51090 | 2023-08-27 | 36.11 | 665.16 | 29.69 | 0.05 |
Generated 2024-09-19 22:53:13.523 UTC