[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 997 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50221_12 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 415 | 527 | 3 | 2023-07-03 | 198.04 | 4.95 | 2023-06-21 | 1 | 146.55 | 1 | 198.04 | 12 | SO50221 | 2023-06-28 | 15.84 | 146.55 | 198.04 | |||
SO65304_1 | B5DE-42B5-83 | PO5336142643 | 100 | 287 | 573 | 113 | 4 | 2024-05-03 | 1430.44 | 35.76 | 2024-04-21 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO65304 | 2024-04-28 | 114.44 | 1481.94 | 1430.44 | |||
SO50753_26 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 305 | 608 | 4 | 2023-08-03 | 3680.73 | 92.02 | 2023-07-22 | 5 | 653.70 | 1 | 3680.73 | 26 | SO50753 | 2023-07-29 | 294.46 | 3268.49 | 736.15 | |||
SO50252_16 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 369 | 167 | 4 | 2023-07-03 | 4398.03 | 109.95 | 2023-06-21 | 3 | 1518.79 | 1 | 4398.03 | 16 | SO50252 | 2023-06-28 | 351.84 | 4556.36 | 1466.01 | |||
SO67287_11 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 418 | 491 | 4 | 2024-06-03 | 1070.69 | 26.77 | 2024-05-22 | 3 | 360.94 | 1 | 1070.69 | 11 | SO67287 | 2024-05-29 | 85.66 | 1082.83 | 356.90 | |||
SO47034_18 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 407 | 257 | 4 | 2022-10-03 | 131.20 | 3.28 | 2022-09-21 | 2 | 48.55 | 1 | 131.20 | 18 | SO47034 | 2022-09-28 | 10.50 | 97.09 | 65.60 | |||
SO46668_17 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 383 | 221 | 4 | 2022-09-02 | 1200.53 | 30.01 | 2022-08-21 | 2 | 605.65 | 1 | 1200.53 | 17 | SO46668 | 2022-08-28 | 96.04 | 1211.30 | 600.26 | |||
SO65252_6 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 569 | 672 | 1 | 2024-05-03 | 445.41 | 11.14 | 2024-04-21 | 1 | 461.44 | 1 | 445.41 | 6 | SO65252 | 2024-04-28 | 35.63 | 461.44 | 445.41 | |||
SO46380_13 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 218 | 608 | 4 | 2022-08-03 | 11.40 | 0.29 | 2022-07-22 | 2 | 3.40 | 1 | 11.40 | 13 | SO46380 | 2022-07-29 | 0.91 | 6.79 | 5.70 | |||
SO63263_12 | 1E1A-44EE-94 | PO4843118280 | 100 | 287 | 382 | 257 | 4 | 2024-04-04 | 672.29 | 16.81 | 2024-03-23 | 1 | 713.08 | 1 | 672.29 | 12 | SO63263 | 2024-03-30 | 53.78 | 713.08 | 672.29 | |||
SO47018_28 | E622-43B1-98 | PO2523197473 | 100 | 287 | 325 | 167 | 4 | 2022-10-03 | 1879.18 | 46.98 | 2022-09-21 | 4 | 486.71 | 1 | 1879.18 | 28 | SO47018 | 2022-09-28 | 150.33 | 1946.83 | 469.79 | |||
SO69466_9 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 487 | 167 | 4 | 2024-07-03 | 131.98 | 3.30 | 2024-06-21 | 4 | 20.57 | 1 | 131.98 | 9 | SO69466 | 2024-06-28 | 10.56 | 82.27 | 32.99 | |||
SO65252_10 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 499 | 672 | 1 | 2024-05-03 | 602.35 | 15.06 | 2024-04-21 | 1 | 601.74 | 1 | 602.35 | 10 | SO65252 | 2024-04-28 | 48.19 | 601.74 | 602.35 | |||
SO50316_4 | A6A4-4479-89 | PO7917123398 | 100 | 287 | 358 | 401 | 1 | 2023-07-03 | 3688.38 | 92.21 | 2023-06-21 | 3 | 1105.81 | 1 | 3688.38 | 4 | SO50316 | 2023-06-28 | 295.07 | 3317.43 | 1229.46 | |||
SO46102_7 | ADBC-4E22-85 | PO7917135523 | 100 | 287 | 350 | 401 | 1 | 2022-07-03 | 2024.99 | 50.62 | 2022-06-21 | 1 | 1898.09 | 1 | 2024.99 | 7 | SO46102 | 2022-06-28 | 162.00 | 1898.09 | 2024.99 | |||
SO50252_43 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 433 | 167 | 4 | 2023-07-03 | 1946.72 | 48.67 | 2023-06-21 | 6 | 300.12 | 1 | 1946.72 | 43 | SO50252 | 2023-06-28 | 155.74 | 1800.71 | 324.45 | |||
SO55290_2 | 86B1-47CC-94 | PO14413186228 | 100 | 287 | 481 | 383 | 4 | 2023-12-03 | 37.76 | 0.94 | 2023-11-21 | 7 | 3.36 | 1 | 37.76 | 2 | SO55290 | 2023-11-28 | 3.02 | 23.54 | 5.39 | |||
SO67325_25 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 382 | 221 | 4 | 2024-06-03 | 1344.59 | 33.61 | 2024-05-22 | 2 | 713.08 | 1 | 1344.59 | 25 | SO67325 | 2024-05-29 | 107.57 | 1426.16 | 672.29 | |||
SO46342_7 | 9BA4-4F6E-96 | PO14964115309 | 100 | 287 | 349 | 7 | 581 | 4 | 885.93 | 2022-08-03 | 2531.24 | 41.13 | 2022-07-22 | 3 | 1898.09 | 1 | 1645.31 | 7 | SO46342 | 2022-07-29 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO71857_25 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 482 | 624 | 4 | 2024-08-03 | 53.94 | 1.35 | 2024-07-22 | 10 | 3.36 | 1 | 53.94 | 25 | SO71857 | 2024-07-29 | 4.32 | 33.62 | 5.39 | |||
SO65258_10 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 552 | 293 | 1 | 2024-05-03 | 54.89 | 1.37 | 2024-04-21 | 1 | 40.62 | 1 | 54.89 | 10 | SO65258 | 2024-04-28 | 4.39 | 40.62 | 54.89 | |||
SO71848_4 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 565 | 59 | 4 | 2024-08-03 | 890.82 | 22.27 | 2024-07-22 | 2 | 461.44 | 1 | 890.82 | 4 | SO71848 | 2024-07-29 | 71.27 | 922.89 | 445.41 | |||
SO65168_5 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 555 | 509 | 4 | 2024-05-03 | 191.70 | 4.79 | 2024-04-21 | 3 | 47.29 | 1 | 191.70 | 5 | SO65168 | 2024-04-28 | 15.34 | 141.86 | 63.90 | |||
SO71890_6 | D31D-413E-BB | PO5510169156 | 100 | 287 | 490 | 5 | 4 | 2024-08-03 | 161.97 | 4.05 | 2024-07-22 | 5 | 41.57 | 1 | 161.97 | 6 | SO71890 | 2024-07-29 | 12.96 | 207.86 | 32.39 | |||
SO63180_11 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 490 | 167 | 4 | 2024-04-04 | 161.97 | 4.05 | 2024-03-23 | 5 | 41.57 | 1 | 161.97 | 11 | SO63180 | 2024-03-30 | 12.96 | 207.86 | 32.39 | |||
SO50672_33 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 333 | 239 | 4 | 2023-08-03 | 3758.35 | 93.96 | 2023-07-22 | 8 | 486.71 | 1 | 3758.35 | 33 | SO50672 | 2023-07-29 | 300.67 | 3893.65 | 469.79 | |||
SO65168_13 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 564 | 509 | 4 | 2024-05-03 | 1430.44 | 35.76 | 2024-04-21 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO65168 | 2024-04-28 | 114.44 | 1481.94 | 1430.44 | |||
SO50672_27 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 464 | 239 | 4 | 2023-08-03 | 56.52 | 1.41 | 2023-07-22 | 4 | 9.71 | 1 | 56.52 | 27 | SO50672 | 2023-07-29 | 4.52 | 38.85 | 14.13 | |||
SO65183_8 | 4E49-448C-93 | PO16269127603 | 100 | 287 | 390 | 624 | 4 | 2024-05-03 | 2689.18 | 67.23 | 2024-04-21 | 4 | 713.08 | 1 | 2689.18 | 8 | SO65183 | 2024-04-28 | 215.13 | 2852.32 | 672.29 | |||
SO71857_15 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 390 | 624 | 4 | 2024-08-03 | 1344.59 | 33.61 | 2024-07-22 | 2 | 713.08 | 1 | 1344.59 | 15 | SO71857 | 2024-07-29 | 107.57 | 1426.16 | 672.29 |
Generated 2024-09-20 21:28:56.124 UTC