[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '287' > SKIP 2500 SHUFFLE < SKIP 937 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61184_23 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 500 | 599 | 4 | 2024-03-04 | 1204.69 | 30.12 | 2024-02-21 | 2 | 601.74 | 1 | 1204.69 | 23 | SO61184 | 2024-02-28 | 96.38 | 1203.49 | 602.35 | |||
SO58940_19 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 361 | 293 | 1 | 2024-02-02 | 5507.98 | 137.70 | 2024-01-21 | 4 | 1251.98 | 1 | 5507.98 | 19 | SO58940 | 2024-01-28 | 440.64 | 5007.93 | 1376.99 | |||
SO71890_11 | D31D-413E-BB | PO5510169156 | 100 | 287 | 484 | 5 | 4 | 2024-08-03 | 4.77 | 0.12 | 2024-07-22 | 1 | 2.97 | 1 | 4.77 | 11 | SO71890 | 2024-07-29 | 0.38 | 2.97 | 4.77 | |||
SO61184_5 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 570 | 599 | 4 | 2024-03-04 | 2227.05 | 55.68 | 2024-02-21 | 5 | 461.44 | 1 | 2227.05 | 5 | SO61184 | 2024-02-28 | 178.16 | 2307.22 | 445.41 | |||
SO58979_16 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 558 | 509 | 4 | 2024-02-02 | 242.99 | 6.07 | 2024-01-21 | 1 | 179.82 | 1 | 242.99 | 16 | SO58979 | 2024-01-28 | 19.44 | 179.82 | 242.99 | |||
SO69466_24 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 547 | 167 | 4 | 2024-07-03 | 48.59 | 1.21 | 2024-06-21 | 1 | 35.96 | 1 | 48.59 | 24 | SO69466 | 2024-06-28 | 3.89 | 35.96 | 48.59 | |||
SO47387_30 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 421 | 293 | 1 | 2022-11-03 | 1374.30 | 34.36 | 2022-10-22 | 7 | 145.28 | 1 | 1374.30 | 30 | SO47387 | 2022-10-29 | 109.94 | 1016.98 | 196.33 | |||
SO65183_19 | 4E49-448C-93 | PO16269127603 | 100 | 287 | 384 | 624 | 4 | 2024-05-03 | 672.29 | 16.81 | 2024-04-21 | 1 | 713.08 | 1 | 672.29 | 19 | SO65183 | 2024-04-28 | 53.78 | 713.08 | 672.29 | |||
SO49541_15 | B736-4142-A1 | PO7569133326 | 100 | 287 | 395 | 608 | 4 | 2023-05-03 | 368.24 | 9.21 | 2023-04-21 | 6 | 45.42 | 1 | 368.24 | 15 | SO49541 | 2023-04-28 | 29.46 | 272.50 | 61.37 | |||
SO69411_6 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 482 | 77 | 4 | 2024-07-03 | 48.55 | 1.21 | 2024-06-21 | 9 | 3.36 | 1 | 48.55 | 6 | SO69411 | 2024-06-28 | 3.88 | 30.26 | 5.39 | |||
SO61227_4 | 9006-4208-8F | PO10730172247 | 100 | 287 | 380 | 491 | 4 | 2024-03-04 | 4398.03 | 109.95 | 2024-02-21 | 3 | 1554.95 | 1 | 4398.03 | 4 | SO61227 | 2024-02-28 | 351.84 | 4664.84 | 1466.01 | |||
SO47427_13 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 419 | 648 | 4 | 2022-11-03 | 52.65 | 1.32 | 2022-10-22 | 1 | 38.96 | 1 | 52.65 | 13 | SO47427 | 2022-10-29 | 4.21 | 38.96 | 52.65 | |||
SO58995_25 | DA16-4097-96 | PO16269190750 | 100 | 287 | 546 | 624 | 4 | 2024-02-02 | 149.02 | 3.73 | 2024-01-21 | 4 | 27.57 | 1 | 149.02 | 25 | SO58995 | 2024-01-28 | 11.92 | 110.27 | 37.25 | |||
SO47441_25 | 2582-4E47-98 | PO7569166535 | 100 | 287 | 470 | 608 | 4 | 2022-11-03 | 182.35 | 4.56 | 2022-10-22 | 8 | 15.67 | 1 | 182.35 | 25 | SO47441 | 2022-10-29 | 14.59 | 125.37 | 22.79 | |||
SO55282_33 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 502 | 599 | 4 | 2023-12-03 | 400.10 | 10.00 | 2023-11-21 | 2 | 199.85 | 1 | 400.10 | 33 | SO55282 | 2023-11-28 | 32.01 | 399.70 | 200.05 | |||
SO53607_2 | 329F-491C-8E | PO5510117855 | 100 | 287 | 287 | 5 | 4 | 2023-11-03 | 404.66 | 10.12 | 2023-10-22 | 2 | 204.63 | 1 | 404.66 | 2 | SO53607 | 2023-10-29 | 32.37 | 409.25 | 202.33 | |||
SO58982_3 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 374 | 311 | 4 | 2024-02-02 | 1466.01 | 36.65 | 2024-01-21 | 1 | 1554.95 | 1 | 1466.01 | 3 | SO58982 | 2024-01-28 | 117.28 | 1554.95 | 1466.01 | |||
SO49841_27 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 371 | 203 | 4 | 2023-06-03 | 2617.88 | 65.45 | 2023-05-22 | 2 | 1320.68 | 1 | 2617.88 | 27 | SO49841 | 2023-05-29 | 209.43 | 2641.37 | 1308.94 | |||
SO67305_8 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 503 | 599 | 4 | 2024-06-03 | 600.16 | 15.00 | 2024-05-22 | 3 | 199.85 | 1 | 600.16 | 8 | SO67305 | 2024-05-29 | 48.01 | 599.56 | 200.05 | |||
SO55251_24 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 474 | 2 | 437 | 4 | 10.55 | 2023-12-03 | 527.72 | 12.93 | 2023-11-21 | 13 | 26.18 | 1 | 517.17 | 24 | SO55251 | 2023-11-28 | 41.37 | 340.29 | 40.59 | 0.02 |
SO71848_2 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 559 | 59 | 4 | 2024-08-03 | 12.14 | 0.30 | 2024-07-22 | 1 | 8.99 | 1 | 12.14 | 2 | SO71848 | 2024-07-29 | 0.97 | 8.99 | 12.14 | |||
SO55282_5 | A72A-4D3A-BA | PO16298125578 | 100 | 287 | 586 | 599 | 4 | 2023-12-03 | 2227.05 | 55.68 | 2023-11-21 | 5 | 461.44 | 1 | 2227.05 | 5 | SO55282 | 2023-11-28 | 178.16 | 2307.22 | 445.41 | |||
SO61243_20 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 580 | 221 | 4 | 2024-03-04 | 1020.59 | 25.51 | 2024-02-21 | 1 | 1082.51 | 1 | 1020.59 | 20 | SO61243 | 2024-02-28 | 81.65 | 1082.51 | 1020.59 | |||
SO69527_22 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 546 | 257 | 4 | 2024-07-03 | 74.51 | 1.86 | 2024-06-21 | 2 | 27.57 | 1 | 74.51 | 22 | SO69527 | 2024-06-28 | 5.96 | 55.14 | 37.25 | |||
SO58940_7 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 475 | 293 | 1 | 2024-02-02 | 41.99 | 1.05 | 2024-01-21 | 1 | 26.18 | 1 | 41.99 | 7 | SO58940 | 2024-01-28 | 3.36 | 26.18 | 41.99 | |||
SO59029_20 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 543 | 648 | 4 | 2024-02-02 | 37.25 | 0.93 | 2024-01-21 | 1 | 27.57 | 1 | 37.25 | 20 | SO59029 | 2024-01-28 | 2.98 | 27.57 | 37.25 | |||
SO63263_4 | 1E1A-44EE-94 | PO4843118280 | 100 | 287 | 434 | 257 | 4 | 2024-04-04 | 1070.69 | 26.77 | 2024-03-23 | 3 | 360.94 | 1 | 1070.69 | 4 | SO63263 | 2024-03-30 | 85.66 | 1082.83 | 356.90 | |||
SO58979_20 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 555 | 509 | 4 | 2024-02-02 | 127.80 | 3.20 | 2024-01-21 | 2 | 47.29 | 1 | 127.80 | 20 | SO58979 | 2024-01-28 | 10.22 | 94.57 | 63.90 | |||
SO50252_18 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 464 | 167 | 4 | 2023-07-03 | 113.03 | 2.83 | 2023-06-21 | 8 | 9.71 | 1 | 113.03 | 18 | SO50252 | 2023-06-28 | 9.04 | 77.71 | 14.13 | |||
SO71857_13 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 481 | 624 | 4 | 2024-08-03 | 32.36 | 0.81 | 2024-07-22 | 6 | 3.36 | 1 | 32.36 | 13 | SO71857 | 2024-07-29 | 2.59 | 20.17 | 5.39 |
Generated 2024-09-20 17:26:09.641 UTC