[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '284' > 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50245_7 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 230 | 66 | 6 | 2023-07-02 | 28.84 | 0.72 | 2023-06-20 | 1 | 29.08 | 1 | 28.84 | 7 | SO50245 | 2023-06-27 | 2.31 | 29.08 | 28.84 | |||
SO71868_1 | A2CA-4B41-9A | PO14210134527 | 19 | 284 | 281 | 30 | 6 | 2024-08-02 | 202.33 | 5.06 | 2024-07-21 | 1 | 204.63 | 1 | 202.33 | 1 | SO71868 | 2024-07-28 | 16.19 | 204.63 | 202.33 | |||
SO50284_30 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 343 | 84 | 6 | 2023-07-02 | 2818.76 | 70.47 | 2023-06-20 | 6 | 486.71 | 1 | 2818.76 | 30 | SO50284 | 2023-06-27 | 225.50 | 2920.24 | 469.79 | |||
SO50245_45 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 461 | 66 | 6 | 2023-07-02 | 323.96 | 8.10 | 2023-06-20 | 6 | 37.12 | 1 | 323.96 | 45 | SO50245 | 2023-06-27 | 25.92 | 222.73 | 53.99 | |||
SO50687_20 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 419 | 685 | 6 | 2023-08-02 | 210.59 | 5.26 | 2023-07-21 | 4 | 38.96 | 1 | 210.59 | 20 | SO50687 | 2023-07-28 | 16.85 | 155.84 | 52.65 | |||
SO50284_11 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 439 | 84 | 6 | 2023-07-02 | 780.82 | 19.52 | 2023-06-20 | 1 | 722.26 | 1 | 780.82 | 11 | SO50284 | 2023-06-27 | 62.47 | 722.26 | 780.82 | |||
SO47399_8 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 468 | 685 | 6 | 2022-11-02 | 22.79 | 0.57 | 2022-10-21 | 1 | 15.67 | 1 | 22.79 | 8 | SO47399 | 2022-10-28 | 1.82 | 15.67 | 22.79 | |||
SO50699_12 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 421 | 588 | 6 | 2023-08-02 | 196.33 | 4.91 | 2023-07-21 | 1 | 145.28 | 1 | 196.33 | 12 | SO50699 | 2023-07-28 | 15.71 | 145.28 | 196.33 | |||
SO47012_26 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 445 | 66 | 6 | 2022-10-02 | 215.96 | 5.40 | 2022-09-20 | 6 | 24.75 | 1 | 215.96 | 26 | SO47012 | 2022-09-27 | 17.28 | 148.48 | 35.99 | |||
SO58925_21 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 569 | 282 | 6 | 2024-02-01 | 445.41 | 11.14 | 2024-01-20 | 1 | 461.44 | 1 | 445.41 | 21 | SO58925 | 2024-01-27 | 35.63 | 461.44 | 445.41 | |||
SO47037_2 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 453 | 84 | 6 | 2022-10-02 | 107.98 | 2.70 | 2022-09-20 | 3 | 24.75 | 1 | 107.98 | 2 | SO47037 | 2022-09-27 | 8.64 | 74.24 | 35.99 | |||
SO58932_28 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 490 | 408 | 6 | 2024-02-01 | 259.15 | 6.48 | 2024-01-20 | 8 | 41.57 | 1 | 259.15 | 28 | SO58932 | 2024-01-27 | 20.73 | 332.58 | 32.39 | |||
SO71827_6 | C6C1-47DB-95 | PO11107195325 | 19 | 284 | 471 | 156 | 6 | 2024-08-02 | 38.10 | 0.95 | 2024-07-21 | 1 | 23.75 | 1 | 38.10 | 6 | SO71827 | 2024-07-28 | 3.05 | 23.75 | 38.10 | |||
SO50680_5 | FA18-4AE1-91 | PO12876114100 | 19 | 284 | 417 | 300 | 6 | 2023-08-02 | 324.45 | 8.11 | 2023-07-21 | 1 | 300.12 | 1 | 324.45 | 5 | SO50680 | 2023-07-28 | 25.96 | 300.12 | 324.45 | |||
SO47357_15 | 3E93-4357-9B | PO18531126368 | 19 | 284 | 213 | 613 | 6 | 2022-11-02 | 60.56 | 1.51 | 2022-10-21 | 3 | 13.88 | 1 | 60.56 | 15 | SO47357 | 2022-10-28 | 4.84 | 41.63 | 20.19 | |||
SO69482_10 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 471 | 138 | 6 | 2024-07-02 | 152.40 | 3.81 | 2024-06-20 | 4 | 23.75 | 1 | 152.40 | 10 | SO69482 | 2024-06-27 | 12.19 | 95.00 | 38.10 | |||
SO50685_10 | 52FE-4932-85 | PO11107117790 | 19 | 284 | 329 | 156 | 6 | 2023-08-02 | 2348.97 | 58.72 | 2023-07-21 | 5 | 486.71 | 1 | 2348.97 | 10 | SO50685 | 2023-07-28 | 187.92 | 2433.53 | 469.79 | |||
SO71829_19 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 543 | 685 | 6 | 2024-08-02 | 37.25 | 0.93 | 2024-07-21 | 1 | 27.57 | 1 | 37.25 | 19 | SO71829 | 2024-07-28 | 2.98 | 27.57 | 37.25 | |||
SO50284_49 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 339 | 84 | 6 | 2023-07-02 | 1409.38 | 35.23 | 2023-06-20 | 3 | 486.71 | 1 | 1409.38 | 49 | SO50284 | 2023-06-27 | 112.75 | 1460.12 | 469.79 | |||
SO47037_31 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 464 | 84 | 6 | 2022-10-02 | 42.39 | 1.06 | 2022-09-20 | 3 | 9.71 | 1 | 42.39 | 31 | SO47037 | 2022-09-27 | 3.39 | 29.14 | 14.13 | |||
SO71800_21 | 6DBE-44CC-BD | PO15544127760 | 19 | 284 | 558 | 282 | 6 | 2024-08-02 | 242.99 | 6.07 | 2024-07-21 | 1 | 179.82 | 1 | 242.99 | 21 | SO71800 | 2024-07-28 | 19.44 | 179.82 | 242.99 | |||
SO71828_16 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 503 | 48 | 6 | 2024-08-02 | 200.05 | 5.00 | 2024-07-21 | 1 | 199.85 | 1 | 200.05 | 16 | SO71828 | 2024-07-28 | 16.00 | 199.85 | 200.05 | |||
SO71829_21 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 532 | 685 | 6 | 2024-08-02 | 149.87 | 3.75 | 2024-07-21 | 1 | 136.79 | 1 | 149.87 | 21 | SO71829 | 2024-07-28 | 11.99 | 136.79 | 149.87 | |||
SO69541_1 | 75C0-4A42-AE | PO2030150622 | 19 | 284 | 595 | 16 | 661 | 6 | 135.60 | 2024-07-02 | 338.99 | 5.08 | 2024-06-20 | 3 | 308.22 | 1 | 203.40 | 1 | SO69541 | 2024-06-27 | 16.27 | 924.65 | 113.00 | 0.40 |
SO58932_38 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 565 | 408 | 6 | 2024-02-01 | 445.41 | 11.14 | 2024-01-20 | 1 | 461.44 | 1 | 445.41 | 38 | SO58932 | 2024-01-27 | 35.63 | 461.44 | 445.41 | |||
SO69482_12 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 552 | 138 | 6 | 2024-07-02 | 54.89 | 1.37 | 2024-06-20 | 1 | 40.62 | 1 | 54.89 | 12 | SO69482 | 2024-06-27 | 4.39 | 40.62 | 54.89 | |||
SO50687_11 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 297 | 685 | 6 | 2023-08-02 | 736.15 | 18.40 | 2023-07-21 | 1 | 653.70 | 1 | 736.15 | 11 | SO50687 | 2023-07-28 | 58.89 | 653.70 | 736.15 | |||
SO57097_30 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 214 | 552 | 6 | 2024-01-02 | 83.98 | 2.10 | 2023-12-21 | 4 | 13.09 | 1 | 83.98 | 30 | SO57097 | 2023-12-28 | 6.72 | 52.35 | 20.99 | |||
SO71868_3 | A2CA-4B41-9A | PO14210134527 | 19 | 284 | 418 | 30 | 6 | 2024-08-02 | 356.90 | 8.92 | 2024-07-21 | 1 | 360.94 | 1 | 356.90 | 3 | SO71868 | 2024-07-28 | 28.55 | 360.94 | 356.90 | |||
SO50699_16 | FEA0-4613-AE | PO1885169186 | 19 | 284 | 213 | 588 | 6 | 2023-08-02 | 40.37 | 1.01 | 2023-07-21 | 2 | 13.88 | 1 | 40.37 | 16 | SO50699 | 2023-07-28 | 3.23 | 27.76 | 20.19 | |||
SO71829_13 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 533 | 685 | 6 | 2024-08-02 | 899.24 | 22.48 | 2024-07-21 | 6 | 136.79 | 1 | 899.24 | 13 | SO71829 | 2024-07-28 | 71.94 | 820.71 | 149.87 |
Generated 2024-09-20 02:41:11.842 UTC