[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '285' > SKIP 2500 SHUFFLE < SKIP 125 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50293_1 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 412 | 476 | 5 | 2023-08-23 | 180.13 | 4.50 | 2023-08-11 | 1 | 133.30 | 1 | 180.13 | 1 | SO50293 | 2023-08-18 | 14.41 | 133.30 | 180.13 | |||
| SO69443_4 | 7B84-4BA4-86 | PO11542130895 | 100 | 285 | 484 | 62 | 5 | 2024-08-23 | 9.54 | 0.24 | 2024-08-11 | 2 | 2.97 | 1 | 9.54 | 4 | SO69443 | 2024-08-18 | 0.76 | 5.95 | 4.77 | |||
| SO47026_10 | 123B-481F-8F | PO3596190739 | 100 | 285 | 468 | 476 | 5 | 2022-11-23 | 45.59 | 1.14 | 2022-11-11 | 2 | 15.67 | 1 | 45.59 | 10 | SO47026 | 2022-11-18 | 3.65 | 31.34 | 22.79 | |||
| SO65207_7 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 222 | 611 | 5 | 2024-06-23 | 146.96 | 3.67 | 2024-06-11 | 7 | 13.09 | 1 | 146.96 | 7 | SO65207 | 2024-06-18 | 11.76 | 91.60 | 20.99 | |||
| SO67260_42 | 6224-4229-B8 | PO522163557 | 100 | 285 | 551 | 676 | 5 | 2024-07-24 | 158.43 | 3.96 | 2024-07-12 | 1 | 144.59 | 1 | 158.43 | 42 | SO67260 | 2024-07-19 | 12.67 | 144.59 | 158.43 | |||
| SO65242_18 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 570 | 627 | 5 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 18 | SO65242 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
| SO47454_3 | E249-41EE-95 | PO9570119946 | 100 | 285 | 469 | 3 | 585 | 5 | 24.03 | 2022-12-24 | 480.57 | 11.41 | 2022-12-12 | 23 | 15.67 | 1 | 456.54 | 3 | SO47454 | 2022-12-19 | 36.52 | 360.43 | 20.89 | 0.05 |
| SO57104_2 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 483 | 531 | 5 | 2024-02-23 | 216.00 | 5.40 | 2024-02-11 | 3 | 44.88 | 1 | 216.00 | 2 | SO57104 | 2024-02-18 | 17.28 | 134.64 | 72.00 | |||
| SO46056_20 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 218 | 278 | 5 | 2022-08-23 | 39.90 | 1.00 | 2022-08-11 | 7 | 3.40 | 1 | 39.90 | 20 | SO46056 | 2022-08-18 | 3.19 | 23.77 | 5.70 | |||
| SO67348_28 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 596 | 494 | 5 | 2024-07-24 | 971.98 | 24.30 | 2024-07-12 | 3 | 294.58 | 1 | 971.98 | 28 | SO67348 | 2024-07-19 | 77.76 | 883.74 | 323.99 | |||
| SO71802_22 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 500 | 297 | 5 | 2024-09-23 | 1807.04 | 45.18 | 2024-09-11 | 3 | 601.74 | 1 | 1807.04 | 22 | SO71802 | 2024-09-18 | 144.56 | 1805.23 | 602.35 | |||
| SO46630_14 | F512-40F2-91 | PO12644161356 | 100 | 285 | 421 | 530 | 5 | 2022-10-23 | 981.65 | 24.54 | 2022-10-11 | 5 | 145.28 | 1 | 981.65 | 14 | SO46630 | 2022-10-18 | 78.53 | 726.42 | 196.33 | |||
| SO49124_3 | 795F-4192-AD | PO3596184634 | 100 | 285 | 367 | 476 | 5 | 2023-05-26 | 1295.99 | 32.40 | 2023-05-14 | 2 | 598.44 | 1 | 1295.99 | 3 | SO49124 | 2023-05-21 | 103.68 | 1196.87 | 647.99 | |||
| SO50306_22 | D376-4A40-86 | PO5858194676 | 100 | 285 | 362 | 566 | 5 | 2023-08-23 | 1229.46 | 30.74 | 2023-08-11 | 1 | 1105.81 | 1 | 1229.46 | 22 | SO50306 | 2023-08-18 | 98.36 | 1105.81 | 1229.46 | |||
| SO71839_6 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 222 | 611 | 5 | 2024-09-23 | 167.95 | 4.20 | 2024-09-11 | 8 | 13.09 | 1 | 167.95 | 6 | SO71839 | 2024-09-18 | 13.44 | 104.69 | 20.99 | |||
| SO71839_33 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 570 | 611 | 5 | 2024-09-23 | 445.41 | 11.14 | 2024-09-11 | 1 | 461.44 | 1 | 445.41 | 33 | SO71839 | 2024-09-18 | 35.63 | 461.44 | 445.41 | |||
| SO69565_6 | F165-437F-B9 | PO9773181473 | 100 | 285 | 555 | 8 | 5 | 2024-08-23 | 63.90 | 1.60 | 2024-08-11 | 1 | 47.29 | 1 | 63.90 | 6 | SO69565 | 2024-08-18 | 5.11 | 47.29 | 63.90 | |||
| SO50315_13 | EDB3-4074-A9 | PO7598160779 | 100 | 285 | 377 | 45 | 5 | 2023-08-23 | 2617.88 | 65.45 | 2023-08-11 | 2 | 1320.68 | 1 | 2617.88 | 13 | SO50315 | 2023-08-18 | 209.43 | 2641.37 | 1308.94 | |||
| SO49159_11 | 15B4-4CCD-9A | PO7598122487 | 100 | 285 | 381 | 45 | 5 | 2023-05-26 | 600.26 | 15.01 | 2023-05-14 | 1 | 605.65 | 1 | 600.26 | 11 | SO49159 | 2023-05-21 | 48.02 | 605.65 | 600.26 | |||
| SO46654_5 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 233 | 404 | 5 | 2022-10-23 | 115.36 | 2.88 | 2022-10-11 | 4 | 29.08 | 1 | 115.36 | 5 | SO46654 | 2022-10-18 | 9.23 | 116.32 | 28.84 | |||
| SO67260_39 | 6224-4229-B8 | PO522163557 | 100 | 285 | 590 | 676 | 5 | 2024-07-24 | 923.39 | 23.08 | 2024-07-12 | 2 | 419.78 | 1 | 923.39 | 39 | SO67260 | 2024-07-19 | 73.87 | 839.56 | 461.69 | |||
| SO46099_11 | 7E3B-4362-99 | PO7598165395 | 100 | 285 | 322 | 45 | 5 | 2022-08-23 | 2097.29 | 52.43 | 2022-08-11 | 5 | 413.15 | 1 | 2097.29 | 11 | SO46099 | 2022-08-18 | 167.78 | 2065.73 | 419.46 | |||
| SO50212_1 | BDB8-4FEA-94 | PO15051162285 | 100 | 285 | 469 | 207 | 5 | 2023-08-23 | 91.18 | 2.28 | 2023-08-11 | 4 | 15.67 | 1 | 91.18 | 1 | SO50212 | 2023-08-18 | 7.29 | 62.68 | 22.79 | |||
| SO47042_52 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 466 | 566 | 5 | 2022-11-23 | 28.26 | 0.71 | 2022-11-11 | 2 | 9.71 | 1 | 28.26 | 52 | SO47042 | 2022-11-18 | 2.26 | 19.43 | 14.13 | |||
| SO47454_24 | E249-41EE-95 | PO9570119946 | 100 | 285 | 230 | 585 | 5 | 2022-12-24 | 86.52 | 2.16 | 2022-12-12 | 3 | 29.08 | 1 | 86.52 | 24 | SO47454 | 2022-12-19 | 6.92 | 87.24 | 28.84 | |||
| SO47042_31 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 457 | 566 | 5 | 2022-11-23 | 179.98 | 4.50 | 2022-11-11 | 4 | 30.93 | 1 | 179.98 | 31 | SO47042 | 2022-11-18 | 14.40 | 123.73 | 44.99 | |||
| SO69502_3 | 2A73-4DAC-AB | PO6293127965 | 100 | 285 | 434 | 612 | 5 | 2024-08-23 | 713.80 | 17.84 | 2024-08-11 | 2 | 360.94 | 1 | 713.80 | 3 | SO69502 | 2024-08-18 | 57.10 | 721.89 | 356.90 | |||
| SO49516_2 | 7B9E-45A8-89 | PO9106137121 | 100 | 285 | 352 | 602 | 5 | 2023-06-23 | 1242.85 | 31.07 | 2023-06-11 | 1 | 1117.86 | 1 | 1242.85 | 2 | SO49516 | 2023-06-18 | 99.43 | 1117.86 | 1242.85 | |||
| SO71888_2 | E962-4453-9C | PO6583162871 | 100 | 285 | 576 | 44 | 5 | 2024-09-23 | 1430.44 | 35.76 | 2024-09-11 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO71888 | 2024-09-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO51081_11 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 398 | 676 | 5 | 2023-10-23 | 80.17 | 2.00 | 2023-10-11 | 3 | 19.78 | 1 | 80.17 | 11 | SO51081 | 2023-10-18 | 6.41 | 59.33 | 26.72 |
Generated 2024-11-10 09:11:40.719 UTC