[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '284' > SKIP 2500 SHUFFLE < SKIP 750 > < TAKE 125 >
34 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47037_50 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 213 | 84 | 6 | 2022-11-22 | 161.49 | 4.04 | 2022-11-10 | 8 | 13.88 | 1 | 161.49 | 50 | SO47037 | 2022-11-17 | 12.92 | 111.03 | 20.19 | |||
SO57082_14 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 390 | 426 | 6 | 2024-02-22 | 672.29 | 16.81 | 2024-02-10 | 1 | 713.08 | 1 | 672.29 | 14 | SO57082 | 2024-02-17 | 53.78 | 713.08 | 672.29 | |||
SO47037_30 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 273 | 84 | 6 | 2022-11-22 | 202.33 | 5.06 | 2022-11-10 | 1 | 187.16 | 1 | 202.33 | 30 | SO47037 | 2022-11-17 | 16.19 | 187.16 | 202.33 | |||
SO69522_5 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 234 | 84 | 6 | 2024-08-22 | 149.97 | 3.75 | 2024-08-10 | 5 | 38.49 | 1 | 149.97 | 5 | SO69522 | 2024-08-17 | 12.00 | 192.46 | 29.99 | |||
SO57071_1 | 576F-449A-A3 | PO10991157868 | 19 | 284 | 513 | 570 | 6 | 2024-02-22 | 218.45 | 5.46 | 2024-02-10 | 1 | 199.38 | 1 | 218.45 | 1 | SO57071 | 2024-02-17 | 17.48 | 199.38 | 218.45 | |||
SO47413_31 | E274-4280-9B | PO1885161774 | 19 | 284 | 410 | 588 | 6 | 2022-12-23 | 36.45 | 0.91 | 2022-12-11 | 1 | 26.97 | 1 | 36.45 | 31 | SO47413 | 2022-12-18 | 2.92 | 26.97 | 36.45 | |||
SO69522_17 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 471 | 84 | 6 | 2024-08-22 | 190.50 | 4.76 | 2024-08-10 | 5 | 23.75 | 1 | 190.50 | 17 | SO69522 | 2024-08-17 | 15.24 | 118.75 | 38.10 | |||
SO69538_7 | 631A-4D82-A8 | PO2117162793 | 19 | 284 | 477 | 444 | 6 | 2024-08-22 | 8.98 | 0.22 | 2024-08-10 | 3 | 1.87 | 1 | 8.98 | 7 | SO69538 | 2024-08-17 | 0.72 | 5.60 | 2.99 | |||
SO71829_28 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 595 | 16 | 685 | 6 | 45.20 | 2024-09-22 | 113.00 | 1.70 | 2024-09-10 | 1 | 308.22 | 1 | 67.80 | 28 | SO71829 | 2024-09-17 | 5.42 | 308.22 | 113.00 | 0.40 |
SO69522_11 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 606 | 84 | 6 | 2024-08-22 | 971.98 | 24.30 | 2024-08-10 | 3 | 343.65 | 1 | 971.98 | 11 | SO69522 | 2024-08-17 | 77.76 | 1030.95 | 323.99 | |||
SO47037_38 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 454 | 84 | 6 | 2022-11-22 | 143.98 | 3.60 | 2022-11-10 | 4 | 24.75 | 1 | 143.98 | 38 | SO47037 | 2022-11-17 | 11.52 | 98.98 | 35.99 | |||
SO58932_30 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 576 | 2 | 408 | 6 | 359.52 | 2024-03-23 | 17975.89 | 440.41 | 2024-03-11 | 13 | 1481.94 | 1 | 17616.37 | 30 | SO58932 | 2024-03-18 | 1409.31 | 19265.19 | 1382.76 | 0.02 |
SO57122_10 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 580 | 84 | 6 | 2024-02-22 | 2041.19 | 51.03 | 2024-02-10 | 2 | 1082.51 | 1 | 2041.19 | 10 | SO57122 | 2024-02-17 | 163.30 | 2165.02 | 1020.59 | |||
SO71891_3 | A2BC-4140-A6 | PO7366158003 | 19 | 284 | 554 | 372 | 6 | 2024-09-22 | 54.94 | 1.37 | 2024-09-10 | 1 | 40.66 | 1 | 54.94 | 3 | SO71891 | 2024-09-17 | 4.40 | 40.66 | 54.94 | |||
SO57122_17 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 472 | 84 | 6 | 2024-02-22 | 304.80 | 7.62 | 2024-02-10 | 8 | 23.75 | 1 | 304.80 | 17 | SO57122 | 2024-02-17 | 24.38 | 189.99 | 38.10 | |||
SO50284_20 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 435 | 84 | 6 | 2023-08-22 | 324.45 | 8.11 | 2023-08-10 | 1 | 300.12 | 1 | 324.45 | 20 | SO50284 | 2023-08-17 | 25.96 | 300.12 | 324.45 | |||
SO50685_10 | 52FE-4932-85 | PO11107117790 | 19 | 284 | 329 | 156 | 6 | 2023-09-22 | 2348.97 | 58.72 | 2023-09-10 | 5 | 486.71 | 1 | 2348.97 | 10 | SO50685 | 2023-09-17 | 187.92 | 2433.53 | 469.79 | |||
SO58925_22 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 578 | 282 | 6 | 2024-03-23 | 1457.82 | 36.45 | 2024-03-11 | 2 | 755.15 | 1 | 1457.82 | 22 | SO58925 | 2024-03-18 | 116.63 | 1510.30 | 728.91 | |||
SO57122_1 | 048F-465A-A8 | PO4901112587 | 19 | 284 | 287 | 84 | 6 | 2024-02-22 | 607.00 | 15.17 | 2024-02-10 | 3 | 204.63 | 1 | 607.00 | 1 | SO57122 | 2024-02-17 | 48.56 | 613.88 | 202.33 | |||
SO69522_34 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 418 | 84 | 6 | 2024-08-22 | 356.90 | 8.92 | 2024-08-10 | 1 | 360.94 | 1 | 356.90 | 34 | SO69522 | 2024-08-17 | 28.55 | 360.94 | 356.90 | |||
SO50685_6 | 52FE-4932-85 | PO11107117790 | 19 | 284 | 327 | 156 | 6 | 2023-09-22 | 469.79 | 11.74 | 2023-09-10 | 1 | 486.71 | 1 | 469.79 | 6 | SO50685 | 2023-09-17 | 37.58 | 486.71 | 469.79 | |||
SO71808_2 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 499 | 408 | 6 | 2024-09-22 | 1204.69 | 30.12 | 2024-09-10 | 2 | 601.74 | 1 | 1204.69 | 2 | SO71808 | 2024-09-17 | 96.38 | 1203.49 | 602.35 | |||
SO71828_9 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 586 | 48 | 6 | 2024-09-22 | 3563.28 | 89.08 | 2024-09-10 | 8 | 461.44 | 1 | 3563.28 | 9 | SO71828 | 2024-09-17 | 285.06 | 3691.56 | 445.41 | |||
SO71808_31 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 483 | 408 | 6 | 2024-09-22 | 720.00 | 18.00 | 2024-09-10 | 10 | 44.88 | 1 | 720.00 | 31 | SO71808 | 2024-09-17 | 57.60 | 448.80 | 72.00 | |||
SO71800_22 | 6DBE-44CC-BD | PO15544127760 | 19 | 284 | 523 | 282 | 6 | 2024-09-22 | 63.17 | 1.58 | 2024-09-10 | 2 | 23.37 | 1 | 63.17 | 22 | SO71800 | 2024-09-17 | 5.05 | 46.74 | 31.58 | |||
SO47399_10 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 354 | 685 | 6 | 2022-12-23 | 2485.70 | 62.14 | 2022-12-11 | 2 | 1117.86 | 1 | 2485.70 | 10 | SO47399 | 2022-12-18 | 198.86 | 2235.71 | 1242.85 | |||
SO71808_13 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 225 | 408 | 6 | 2024-09-22 | 26.97 | 0.67 | 2024-09-10 | 5 | 6.92 | 1 | 26.97 | 13 | SO71808 | 2024-09-17 | 2.16 | 34.61 | 5.39 | |||
SO47012_31 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 323 | 66 | 6 | 2022-11-22 | 3288.56 | 82.21 | 2022-11-10 | 7 | 486.71 | 1 | 3288.56 | 31 | SO47012 | 2022-11-17 | 263.08 | 3406.95 | 469.79 | |||
SO47037_13 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 224 | 84 | 6 | 2022-11-22 | 15.56 | 0.39 | 2022-11-10 | 3 | 5.23 | 1 | 15.56 | 13 | SO47037 | 2022-11-17 | 1.24 | 15.69 | 5.19 | |||
SO58932_3 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 564 | 408 | 6 | 2024-03-23 | 4291.33 | 107.28 | 2024-03-11 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO58932 | 2024-03-18 | 343.31 | 4445.81 | 1430.44 | |||
SO57024_28 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 487 | 264 | 6 | 2024-02-22 | 230.96 | 5.77 | 2024-02-10 | 7 | 20.57 | 1 | 230.96 | 28 | SO57024 | 2024-02-17 | 18.48 | 143.96 | 32.99 | |||
SO50284_22 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 335 | 84 | 6 | 2023-08-22 | 469.79 | 11.74 | 2023-08-10 | 1 | 486.71 | 1 | 469.79 | 22 | SO50284 | 2023-08-17 | 37.58 | 486.71 | 469.79 | |||
SO71808_28 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 472 | 408 | 6 | 2024-09-22 | 381.00 | 9.53 | 2024-09-10 | 10 | 23.75 | 1 | 381.00 | 28 | SO71808 | 2024-09-17 | 30.48 | 237.49 | 38.10 | |||
SO57097_29 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 374 | 552 | 6 | 2024-02-22 | 2932.02 | 73.30 | 2024-02-10 | 2 | 1554.95 | 1 | 2932.02 | 29 | SO57097 | 2024-02-17 | 234.56 | 3109.90 | 1466.01 |
Generated 2024-11-10 03:26:56.660 UTC