[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '283' > SKIP 2500 SHUFFLE < SKIP 125 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69393_29 | 3E84-4AA4-B6 | PO19923114948 | 100 | 283 | 476 | 18 | 3 | 2024-07-02 | 251.96 | 6.30 | 2024-06-20 | 6 | 26.18 | 1 | 251.96 | 29 | SO69393 | 2024-06-27 | 20.16 | 157.06 | 41.99 | |||
SO53471_16 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 580 | 306 | 3 | 2023-11-02 | 1020.59 | 25.51 | 2023-10-21 | 1 | 1082.51 | 1 | 1020.59 | 16 | SO53471 | 2023-10-28 | 81.65 | 1082.51 | 1020.59 | |||
SO46605_5 | 88F6-4172-B3 | PO19314112090 | 100 | 283 | 456 | 622 | 3 | 2022-09-01 | 179.98 | 4.50 | 2022-08-20 | 4 | 30.93 | 1 | 179.98 | 5 | SO46605 | 2022-08-27 | 14.40 | 123.73 | 44.99 | |||
SO46969_17 | 3C39-4176-A8 | PO15370166954 | 100 | 283 | 410 | 381 | 3 | 2022-10-02 | 145.79 | 3.64 | 2022-09-20 | 4 | 26.97 | 1 | 145.79 | 17 | SO46969 | 2022-09-27 | 11.66 | 107.88 | 36.45 | |||
SO71824_5 | BBB4-42D9-86 | PO11455162600 | 100 | 283 | 384 | 72 | 2 | 2024-08-02 | 4033.76 | 100.84 | 2024-07-21 | 6 | 713.08 | 1 | 4033.76 | 5 | SO71824 | 2024-07-28 | 322.70 | 4278.48 | 672.29 | |||
SO45520_20 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 334 | 57 | 3 | 2022-05-02 | 838.92 | 20.97 | 2022-04-20 | 2 | 413.15 | 1 | 838.92 | 20 | SO45520 | 2022-04-27 | 67.11 | 826.29 | 419.46 | |||
SO53560_11 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 507 | 539 | 2 | 2023-11-02 | 400.10 | 10.00 | 2023-10-21 | 2 | 199.85 | 1 | 400.10 | 11 | SO53560 | 2023-10-28 | 32.01 | 399.70 | 200.05 | |||
SO69442_21 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 474 | 2 | 233 | 2 | 8.93 | 2024-07-02 | 446.54 | 10.94 | 2024-06-20 | 11 | 26.18 | 1 | 437.61 | 21 | SO69442 | 2024-06-27 | 35.01 | 287.94 | 40.59 | 0.02 |
SO50683_13 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 331 | 72 | 2 | 2023-08-02 | 1879.18 | 46.98 | 2023-07-21 | 4 | 486.71 | 1 | 1879.18 | 13 | SO50683 | 2023-07-28 | 150.33 | 1946.83 | 469.79 | |||
SO45308_17 | 81AA-4F3D-A7 | PO10440184078 | 100 | 283 | 351 | 623 | 3 | 2022-04-04 | 8099.98 | 202.50 | 2022-03-23 | 4 | 1898.09 | 1 | 8099.98 | 17 | SO45308 | 2022-03-30 | 648.00 | 7592.38 | 2024.99 | |||
SO53530_15 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 225 | 90 | 5 | 2023-11-02 | 10.79 | 0.27 | 2023-10-21 | 2 | 6.92 | 1 | 10.79 | 15 | SO53530 | 2023-10-28 | 0.86 | 13.84 | 5.39 | |||
SO50683_20 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 389 | 2 | 72 | 2 | 139.26 | 2023-08-02 | 6963.05 | 170.59 | 2023-07-21 | 12 | 605.65 | 1 | 6823.78 | 20 | SO50683 | 2023-07-28 | 545.90 | 7267.79 | 580.25 | 0.02 |
SO57065_14 | B68A-407E-99 | PO11658151711 | 100 | 283 | 514 | 233 | 2 | 2024-01-02 | 191.70 | 4.79 | 2023-12-21 | 3 | 47.29 | 1 | 191.70 | 14 | SO57065 | 2023-12-28 | 15.34 | 141.86 | 63.90 | |||
SO45538_16 | 0310-4DCB-B5 | PO14268192541 | 100 | 283 | 322 | 418 | 3 | 2022-05-02 | 419.46 | 10.49 | 2022-04-20 | 1 | 413.15 | 1 | 419.46 | 16 | SO45538 | 2022-04-27 | 33.56 | 413.15 | 419.46 | |||
SO45532_6 | 1342-4F90-B0 | PO15834119448 | 100 | 283 | 215 | 417 | 4 | 2022-05-02 | 60.56 | 1.51 | 2022-04-20 | 3 | 12.03 | 1 | 60.56 | 6 | SO45532 | 2022-04-27 | 4.84 | 36.08 | 20.19 | |||
SO46094_4 | 6C13-4966-95 | PO6438128598 | 100 | 283 | 229 | 309 | 4 | 2022-07-02 | 144.20 | 3.61 | 2022-06-20 | 5 | 31.72 | 1 | 144.20 | 4 | SO46094 | 2022-06-27 | 11.54 | 158.62 | 28.84 | |||
SO57140_3 | 5E5D-46A1-94 | PO3161152145 | 100 | 283 | 483 | 359 | 2 | 2024-01-02 | 144.00 | 3.60 | 2023-12-21 | 2 | 44.88 | 1 | 144.00 | 3 | SO57140 | 2023-12-28 | 11.52 | 89.76 | 72.00 | |||
SO47384_49 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 213 | 418 | 3 | 2022-11-02 | 60.56 | 1.51 | 2022-10-21 | 3 | 13.88 | 1 | 60.56 | 49 | SO47384 | 2022-10-28 | 4.84 | 41.63 | 20.19 | |||
SO67314_19 | 6653-491A-80 | PO3828116396 | 100 | 283 | 309 | 414 | 2 | 2024-06-02 | 1637.40 | 40.94 | 2024-05-21 | 2 | 747.20 | 1 | 1637.40 | 19 | SO67314 | 2024-05-28 | 130.99 | 1494.40 | 818.70 | |||
SO61181_3 | EF82-40B7-8E | PO17197117656 | 100 | 283 | 363 | 125 | 2 | 2024-03-03 | 1376.99 | 34.42 | 2024-02-20 | 1 | 1251.98 | 1 | 1376.99 | 3 | SO61181 | 2024-02-27 | 110.16 | 1251.98 | 1376.99 | |||
SO47045_41 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 453 | 309 | 4 | 2022-10-02 | 35.99 | 0.90 | 2022-09-20 | 1 | 24.75 | 1 | 35.99 | 41 | SO47045 | 2022-09-27 | 2.88 | 24.75 | 35.99 | |||
SO47435_23 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 294 | 75 | 4 | 2022-11-02 | 1488.55 | 37.21 | 2022-10-21 | 2 | 660.91 | 1 | 1488.55 | 23 | SO47435 | 2022-10-28 | 119.08 | 1321.83 | 744.27 | |||
SO51088_12 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 290 | 125 | 2 | 2023-09-01 | 818.70 | 20.47 | 2023-08-20 | 1 | 747.20 | 1 | 818.70 | 12 | SO51088 | 2023-08-27 | 65.50 | 747.20 | 818.70 | |||
SO53534_19 | F0B1-423E-8B | PO20213153510 | 100 | 283 | 287 | 216 | 2 | 2023-11-02 | 202.33 | 5.06 | 2023-10-21 | 1 | 204.63 | 1 | 202.33 | 19 | SO53534 | 2023-10-28 | 16.19 | 204.63 | 202.33 | |||
SO47439_51 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 454 | 3 | 4 | 2022-11-02 | 143.98 | 3.60 | 2022-10-21 | 4 | 24.75 | 1 | 143.98 | 51 | SO47439 | 2022-10-28 | 11.52 | 98.98 | 35.99 | |||
SO71894_34 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 552 | 539 | 2 | 2024-08-02 | 54.89 | 1.37 | 2024-07-21 | 1 | 40.62 | 1 | 54.89 | 34 | SO71894 | 2024-07-28 | 4.39 | 40.62 | 54.89 | |||
SO69467_4 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 586 | 522 | 2 | 2024-07-02 | 890.82 | 22.27 | 2024-06-20 | 2 | 461.44 | 1 | 890.82 | 4 | SO69467 | 2024-06-27 | 71.27 | 922.89 | 445.41 | |||
SO61234_8 | 70F9-4CD3-93 | PO6235157155 | 100 | 283 | 491 | 431 | 3 | 2024-03-03 | 64.79 | 1.62 | 2024-02-20 | 2 | 41.57 | 1 | 64.79 | 8 | SO61234 | 2024-02-27 | 5.18 | 83.14 | 32.39 | |||
SO61240_19 | 16E9-4057-BF | PO6467181082 | 100 | 283 | 231 | 660 | 3 | 2024-03-03 | 149.97 | 3.75 | 2024-02-20 | 5 | 38.49 | 1 | 149.97 | 19 | SO61240 | 2024-02-27 | 12.00 | 192.46 | 29.99 | |||
SO71949_27 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 384 | 54 | 2 | 2024-08-02 | 2016.88 | 50.42 | 2024-07-21 | 3 | 713.08 | 1 | 2016.88 | 27 | SO71949 | 2024-07-28 | 161.35 | 2139.24 | 672.29 | |||
SO47435_5 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 364 | 75 | 4 | 2022-11-02 | 1943.98 | 48.60 | 2022-10-21 | 3 | 598.44 | 1 | 1943.98 | 5 | SO47435 | 2022-10-28 | 155.52 | 1795.31 | 647.99 |
Generated 2024-09-20 00:38:07.807 UTC