[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 249 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50252_24 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 453 | 167 | 4 | 2023-08-25 | 71.99 | 1.80 | 2023-08-13 | 2 | 24.75 | 1 | 71.99 | 24 | SO50252 | 2023-08-20 | 5.76 | 49.49 | 35.99 | |||
SO50298_19 | 2A9C-4236-85 | PO4843196377 | 100 | 287 | 417 | 257 | 4 | 2023-08-25 | 648.91 | 16.22 | 2023-08-13 | 2 | 300.12 | 1 | 648.91 | 19 | SO50298 | 2023-08-20 | 51.91 | 600.24 | 324.45 | |||
SO47369_43 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 273 | 239 | 4 | 2022-12-26 | 809.33 | 20.23 | 2022-12-14 | 4 | 187.16 | 1 | 809.33 | 43 | SO47369 | 2022-12-21 | 64.75 | 748.63 | 202.33 | |||
SO67305_1 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 568 | 2 | 599 | 4 | 103.34 | 2024-07-26 | 5166.76 | 126.59 | 2024-07-14 | 12 | 461.44 | 1 | 5063.42 | 1 | SO67305 | 2024-07-21 | 405.07 | 5537.34 | 430.56 | 0.02 |
SO67305_44 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 490 | 2 | 599 | 4 | 7.52 | 2024-07-26 | 375.77 | 9.21 | 2024-07-14 | 12 | 41.57 | 1 | 368.26 | 44 | SO67305 | 2024-07-21 | 29.46 | 498.87 | 31.31 | 0.02 |
SO49841_2 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 224 | 203 | 4 | 2023-07-26 | 10.37 | 0.26 | 2023-07-14 | 2 | 5.23 | 1 | 10.37 | 2 | SO49841 | 2023-07-21 | 0.83 | 10.46 | 5.19 | |||
SO49527_7 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 421 | 648 | 4 | 2023-06-25 | 392.66 | 9.82 | 2023-06-13 | 2 | 145.28 | 1 | 392.66 | 7 | SO49527 | 2023-06-20 | 31.41 | 290.57 | 196.33 | |||
SO50672_16 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 343 | 2 | 239 | 4 | 99.91 | 2023-09-25 | 4995.48 | 122.39 | 2023-09-13 | 11 | 486.71 | 1 | 4895.57 | 16 | SO50672 | 2023-09-20 | 391.65 | 5353.77 | 454.13 | 0.02 |
SO69466_22 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 584 | 167 | 4 | 2024-08-25 | 323.99 | 8.10 | 2024-08-13 | 1 | 343.65 | 1 | 323.99 | 22 | SO69466 | 2024-08-20 | 25.92 | 343.65 | 323.99 | |||
SO67305_13 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 500 | 599 | 4 | 2024-07-26 | 1807.04 | 45.18 | 2024-07-14 | 3 | 601.74 | 1 | 1807.04 | 13 | SO67305 | 2024-07-21 | 144.56 | 1805.23 | 602.35 | |||
SO53580_29 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 516 | 648 | 4 | 2023-12-26 | 70.45 | 1.76 | 2023-12-14 | 3 | 17.38 | 1 | 70.45 | 29 | SO53580 | 2023-12-21 | 5.64 | 52.13 | 23.48 | |||
SO69517_5 | B70F-4B16-A6 | PO5655130015 | 100 | 287 | 492 | 563 | 4 | 2024-08-25 | 602.35 | 15.06 | 2024-08-13 | 1 | 601.74 | 1 | 602.35 | 5 | SO69517 | 2024-08-20 | 48.19 | 601.74 | 602.35 | |||
SO46668_42 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 242 | 221 | 4 | 2022-10-25 | 1561.64 | 39.04 | 2022-10-13 | 2 | 722.26 | 1 | 1561.64 | 42 | SO46668 | 2022-10-20 | 124.93 | 1444.51 | 780.82 | |||
SO50672_52 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 254 | 239 | 4 | 2023-09-25 | 183.94 | 4.60 | 2023-09-13 | 1 | 170.14 | 1 | 183.94 | 52 | SO50672 | 2023-09-20 | 14.72 | 170.14 | 183.94 | |||
SO47034_38 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 263 | 257 | 4 | 2022-11-25 | 809.33 | 20.23 | 2022-11-13 | 4 | 187.16 | 1 | 809.33 | 38 | SO47034 | 2022-11-20 | 64.75 | 748.63 | 202.33 | |||
SO49841_21 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 377 | 203 | 4 | 2023-07-26 | 2617.88 | 65.45 | 2023-07-14 | 2 | 1320.68 | 1 | 2617.88 | 21 | SO49841 | 2023-07-21 | 209.43 | 2641.37 | 1308.94 | |||
SO47057_2 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 356 | 401 | 1 | 2022-11-25 | 3728.56 | 93.21 | 2022-11-13 | 3 | 1117.86 | 1 | 3728.56 | 2 | SO47057 | 2022-11-20 | 298.28 | 3353.57 | 1242.85 | |||
SO50678_6 | CAED-407A-BA | PO13543174640 | 100 | 287 | 305 | 293 | 1 | 2023-09-25 | 736.15 | 18.40 | 2023-09-13 | 1 | 653.70 | 1 | 736.15 | 6 | SO50678 | 2023-09-20 | 58.89 | 653.70 | 736.15 | |||
SO46638_40 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 213 | 8 | 203 | 4 | 5.05 | 2022-10-25 | 50.47 | 1.14 | 2022-10-13 | 3 | 13.88 | 1 | 45.42 | 40 | SO46638 | 2022-10-20 | 3.63 | 41.63 | 16.82 | 0.10 |
SO47018_37 | E622-43B1-98 | PO2523197473 | 100 | 287 | 422 | 167 | 4 | 2022-11-25 | 270.16 | 6.75 | 2022-11-13 | 4 | 49.98 | 1 | 270.16 | 37 | SO47018 | 2022-11-20 | 21.61 | 199.92 | 67.54 | |||
SO55282_4 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 554 | 599 | 4 | 2024-01-25 | 329.65 | 8.24 | 2024-01-13 | 6 | 40.66 | 1 | 329.65 | 4 | SO55282 | 2024-01-20 | 26.37 | 243.94 | 54.94 | |||
SO50743_3 | C1F5-4D36-9F | PO4640120853 | 100 | 287 | 420 | 648 | 4 | 2023-09-25 | 283.23 | 7.08 | 2023-09-13 | 2 | 104.80 | 1 | 283.23 | 3 | SO50743 | 2023-09-20 | 22.66 | 209.59 | 141.62 | |||
SO49498_29 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 464 | 239 | 4 | 2023-06-25 | 56.52 | 1.41 | 2023-06-13 | 4 | 9.71 | 1 | 56.52 | 29 | SO49498 | 2023-06-20 | 4.52 | 38.85 | 14.13 | |||
SO47374_9 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 470 | 23 | 4 | 2022-12-26 | 182.35 | 4.56 | 2022-12-14 | 8 | 15.67 | 1 | 182.35 | 9 | SO47374 | 2022-12-21 | 14.59 | 125.37 | 22.79 | |||
SO71812_18 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 551 | 293 | 1 | 2024-09-25 | 633.72 | 15.84 | 2024-09-13 | 4 | 144.59 | 1 | 633.72 | 18 | SO71812 | 2024-09-20 | 50.70 | 578.38 | 158.43 | |||
SO67290_3 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 583 | 41 | 4 | 2024-07-26 | 3061.78 | 76.54 | 2024-07-14 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO67290 | 2024-07-21 | 244.94 | 3247.53 | 1020.59 | |||
SO67287_16 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 471 | 491 | 4 | 2024-07-26 | 190.50 | 4.76 | 2024-07-14 | 5 | 23.75 | 1 | 190.50 | 16 | SO67287 | 2024-07-21 | 15.24 | 118.75 | 38.10 | |||
SO53610_2 | A496-4DE7-A2 | PO5336183925 | 100 | 287 | 507 | 113 | 4 | 2023-12-26 | 200.05 | 5.00 | 2023-12-14 | 1 | 199.85 | 1 | 200.05 | 2 | SO53610 | 2023-12-21 | 16.00 | 199.85 | 200.05 | |||
SO46980_6 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 415 | 527 | 3 | 2022-11-25 | 1188.22 | 29.71 | 2022-11-13 | 6 | 146.55 | 1 | 1188.22 | 6 | SO46980 | 2022-11-20 | 95.06 | 879.28 | 198.04 | |||
SO58940_14 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 309 | 293 | 1 | 2024-03-26 | 1637.40 | 40.94 | 2024-03-14 | 2 | 747.20 | 1 | 1637.40 | 14 | SO58940 | 2024-03-21 | 130.99 | 1494.40 | 818.70 | |||
SO57085_14 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 472 | 167 | 4 | 2024-02-25 | 76.20 | 1.91 | 2024-02-13 | 2 | 23.75 | 1 | 76.20 | 14 | SO57085 | 2024-02-20 | 6.10 | 47.50 | 38.10 |
Generated 2024-11-13 03:41:33.095 UTC