[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 870 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67301_1 | 549B-408C-84 | PO20126125116 | 100 | 282 | 398 | 421 | 4 | 2024-07-27 | 26.72 | 0.67 | 2024-07-15 | 1 | 19.78 | 1 | 26.72 | 1 | SO67301 | 2024-07-22 | 2.14 | 19.78 | 26.72 | |||
SO47056_25 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 385 | 403 | 4 | 2022-11-26 | 1800.79 | 45.02 | 2022-11-14 | 3 | 605.65 | 1 | 1800.79 | 25 | SO47056 | 2022-11-21 | 144.06 | 1816.95 | 600.26 | |||
SO63157_28 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 225 | 650 | 1 | 2024-05-28 | 32.36 | 0.81 | 2024-05-16 | 6 | 6.92 | 1 | 32.36 | 28 | SO63157 | 2024-05-23 | 2.59 | 41.53 | 5.39 | |||
SO46960_3 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 271 | 259 | 4 | 2022-11-26 | 404.66 | 10.12 | 2022-11-14 | 2 | 187.16 | 1 | 404.66 | 3 | SO46960 | 2022-11-21 | 32.37 | 374.31 | 202.33 | |||
SO50663_54 | 286E-4915-89 | PO19343130555 | 100 | 282 | 460 | 3 | 24 | 4 | 44.55 | 2023-09-26 | 890.90 | 21.16 | 2023-09-14 | 18 | 37.12 | 1 | 846.36 | 54 | SO50663 | 2023-09-21 | 67.71 | 668.18 | 49.49 | 0.05 |
SO71845_15 | 4781-4673-85 | PO2697119362 | 100 | 282 | 363 | 187 | 4 | 2024-09-26 | 2753.99 | 68.85 | 2024-09-14 | 2 | 1251.98 | 1 | 2753.99 | 15 | SO71845 | 2024-09-21 | 220.32 | 2503.96 | 1376.99 | |||
SO51845_11 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 594 | 312 | 4 | 2023-11-26 | 1016.98 | 25.42 | 2023-11-14 | 3 | 308.22 | 1 | 1016.98 | 11 | SO51845 | 2023-11-21 | 81.36 | 924.65 | 338.99 | |||
SO47400_20 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 289 | 133 | 4 | 2022-12-27 | 2232.82 | 55.82 | 2022-12-15 | 3 | 660.91 | 1 | 2232.82 | 20 | SO47400 | 2022-12-22 | 178.63 | 1982.74 | 744.27 | |||
SO53531_19 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 601 | 187 | 4 | 2023-12-27 | 97.18 | 2.43 | 2023-12-15 | 3 | 23.97 | 1 | 97.18 | 19 | SO53531 | 2023-12-22 | 7.77 | 71.91 | 32.39 | |||
SO71845_23 | 4781-4673-85 | PO2697119362 | 100 | 282 | 398 | 187 | 4 | 2024-09-26 | 26.72 | 0.67 | 2024-09-14 | 1 | 19.78 | 1 | 26.72 | 23 | SO71845 | 2024-09-21 | 2.14 | 19.78 | 26.72 | |||
SO53496_8 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 586 | 13 | 295 | 4 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 8 | SO53496 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO50322_15 | 4BC2-4C6D-83 | PO8845166508 | 100 | 282 | 399 | 546 | 3 | 2023-08-26 | 101.32 | 2.53 | 2023-08-14 | 3 | 24.99 | 1 | 101.32 | 15 | SO50322 | 2023-08-21 | 8.11 | 74.98 | 33.77 | |||
SO53582_23 | 9E24-4A2C-8A | PO4785164058 | 100 | 282 | 490 | 223 | 3 | 2023-12-27 | 259.15 | 6.48 | 2023-12-15 | 8 | 41.57 | 1 | 259.15 | 23 | SO53582 | 2023-12-22 | 20.73 | 332.58 | 32.39 | |||
SO53582_14 | 9E24-4A2C-8A | PO4785164058 | 100 | 282 | 471 | 223 | 3 | 2023-12-27 | 228.60 | 5.72 | 2023-12-15 | 6 | 23.75 | 1 | 228.60 | 14 | SO53582 | 2023-12-22 | 18.29 | 142.49 | 38.10 | |||
SO49893_24 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 368 | 523 | 3 | 2023-07-27 | 4398.03 | 109.95 | 2023-07-15 | 3 | 1518.79 | 1 | 4398.03 | 24 | SO49893 | 2023-07-22 | 351.84 | 4556.36 | 1466.01 | |||
SO63291_33 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 477 | 546 | 3 | 2024-05-28 | 2.99 | 0.07 | 2024-05-16 | 1 | 1.87 | 1 | 2.99 | 33 | SO63291 | 2024-05-23 | 0.24 | 1.87 | 2.99 | |||
SO57144_34 | 074E-478C-99 | PO3799111077 | 100 | 282 | 525 | 312 | 4 | 2024-02-26 | 158.43 | 3.96 | 2024-02-14 | 1 | 144.59 | 1 | 158.43 | 34 | SO57144 | 2024-02-21 | 12.67 | 144.59 | 158.43 | |||
SO57046_67 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 361 | 650 | 1 | 2024-02-26 | 13769.94 | 344.25 | 2024-02-14 | 10 | 1251.98 | 1 | 13769.94 | 67 | SO57046 | 2024-02-21 | 1101.60 | 12519.81 | 1376.99 | |||
SO47056_7 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 456 | 403 | 4 | 2022-11-26 | 179.98 | 4.50 | 2022-11-14 | 4 | 30.93 | 1 | 179.98 | 7 | SO47056 | 2022-11-21 | 14.40 | 123.73 | 44.99 | |||
SO71858_2 | 32BA-49C8-8B | PO16153112278 | 100 | 282 | 569 | 186 | 4 | 2024-09-26 | 445.41 | 11.14 | 2024-09-14 | 1 | 461.44 | 1 | 445.41 | 2 | SO71858 | 2024-09-21 | 35.63 | 461.44 | 445.41 | |||
SO55249_37 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 467 | 475 | 4 | 2024-01-26 | 58.78 | 1.47 | 2024-01-14 | 4 | 9.16 | 1 | 58.78 | 37 | SO55249 | 2024-01-21 | 4.70 | 36.64 | 14.69 | |||
SO51783_25 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 588 | 2 | 697 | 1 | 98.19 | 2023-11-26 | 4909.35 | 120.28 | 2023-11-14 | 11 | 419.78 | 1 | 4811.16 | 25 | SO51783 | 2023-11-21 | 384.89 | 4617.56 | 446.30 | 0.02 |
SO63155_11 | 000A-434D-BC | PO15196165529 | 100 | 282 | 583 | 258 | 4 | 2024-05-28 | 3061.78 | 76.54 | 2024-05-16 | 3 | 1082.51 | 1 | 3061.78 | 11 | SO63155 | 2024-05-23 | 244.94 | 3247.53 | 1020.59 | |||
SO51090_62 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 597 | 475 | 4 | 2023-10-26 | 971.98 | 24.30 | 2023-10-14 | 3 | 294.58 | 1 | 971.98 | 62 | SO51090 | 2023-10-21 | 77.76 | 883.74 | 323.99 | |||
SO63277_9 | 1561-40F3-AD | PO3219122722 | 100 | 282 | 384 | 493 | 4 | 2024-05-28 | 1344.59 | 33.61 | 2024-05-16 | 2 | 713.08 | 1 | 1344.59 | 9 | SO63277 | 2024-05-23 | 107.57 | 1426.16 | 672.29 | |||
SO53470_21 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 496 | 420 | 4 | 2023-12-27 | 5421.11 | 135.53 | 2023-12-15 | 9 | 601.74 | 1 | 5421.11 | 21 | SO53470 | 2023-12-22 | 433.69 | 5415.69 | 602.35 | |||
SO47355_21 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 333 | 24 | 4 | 2022-12-27 | 2818.76 | 70.47 | 2022-12-15 | 6 | 486.71 | 1 | 2818.76 | 21 | SO47355 | 2022-12-22 | 225.50 | 2920.24 | 469.79 | |||
SO49486_2 | 7DA8-4E15-AE | PO16124154108 | 100 | 282 | 327 | 649 | 4 | 2023-06-26 | 1879.18 | 46.98 | 2023-06-14 | 4 | 486.71 | 1 | 1879.18 | 2 | SO49486 | 2023-06-21 | 150.33 | 1946.83 | 469.79 | |||
SO57138_9 | CD80-4144-8A | PO5684168325 | 100 | 282 | 355 | 385 | 4 | 2024-02-26 | 1391.99 | 34.80 | 2024-02-14 | 1 | 1265.62 | 1 | 1391.99 | 9 | SO57138 | 2024-02-21 | 111.36 | 1265.62 | 1391.99 | |||
SO49852_5 | 5DD7-447A-8D | PO2581189096 | 100 | 282 | 422 | 698 | 1 | 2023-07-27 | 135.08 | 3.38 | 2023-07-15 | 2 | 49.98 | 1 | 135.08 | 5 | SO49852 | 2023-07-22 | 10.81 | 99.96 | 67.54 |
Generated 2024-11-13 08:54:40.764 UTC