[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '285' > SKIP 2500 SHUFFLE SKIP 1000 < SKIP 64 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65242_16 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 573 | 627 | 5 | 2024-05-03 | 1430.44 | 35.76 | 2024-04-21 | 1 | 1481.94 | 1 | 1430.44 | 16 | SO65242 | 2024-04-28 | 114.44 | 1481.94 | 1430.44 |
SO50306_10 | D376-4A40-86 | PO5858194676 | 100 | 285 | 367 | 566 | 5 | 2023-07-03 | 1295.99 | 32.40 | 2023-06-21 | 2 | 598.44 | 1 | 1295.99 | 10 | SO50306 | 2023-06-28 | 103.68 | 1196.87 | 647.99 |
SO55281_2 | E19D-4F17-B4 | PO18850196229 | 100 | 285 | 547 | 117 | 5 | 2023-12-03 | 194.38 | 4.86 | 2023-11-21 | 4 | 35.96 | 1 | 194.38 | 2 | SO55281 | 2023-11-28 | 15.55 | 143.84 | 48.59 |
SO46962_1 | DB18-4737-90 | PO16211133020 | 100 | 285 | 352 | 99 | 5 | 2022-10-03 | 2485.70 | 62.14 | 2022-09-21 | 2 | 1117.86 | 1 | 2485.70 | 1 | SO46962 | 2022-09-28 | 198.86 | 2235.71 | 1242.85 |
SO67348_21 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 511 | 494 | 5 | 2024-06-03 | 655.36 | 16.38 | 2024-05-22 | 3 | 199.38 | 1 | 655.36 | 21 | SO67348 | 2024-05-29 | 52.43 | 598.13 | 218.45 |
SO50191_19 | 1DDA-4B5A-95 | PO19546193423 | 100 | 285 | 368 | 206 | 5 | 2023-07-03 | 1466.01 | 36.65 | 2023-06-21 | 1 | 1518.79 | 1 | 1466.01 | 19 | SO50191 | 2023-06-28 | 117.28 | 1518.79 | 1466.01 |
SO51874_2 | 0176-4E11-91 | PO9773132815 | 100 | 285 | 559 | 8 | 5 | 2023-10-03 | 24.29 | 0.61 | 2023-09-21 | 2 | 8.99 | 1 | 24.29 | 2 | SO51874 | 2023-09-28 | 1.94 | 17.97 | 12.14 |
SO49822_24 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 459 | 676 | 5 | 2023-06-03 | 161.98 | 4.05 | 2023-05-22 | 3 | 37.12 | 1 | 161.98 | 24 | SO49822 | 2023-05-29 | 12.96 | 111.36 | 53.99 |
SO46604_17 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 421 | 676 | 5 | 2022-09-02 | 392.66 | 9.82 | 2022-08-21 | 2 | 145.28 | 1 | 392.66 | 17 | SO46604 | 2022-08-28 | 31.41 | 290.57 | 196.33 |
SO49865_49 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 286 | 81 | 5 | 2023-06-03 | 367.88 | 9.20 | 2023-05-22 | 2 | 170.14 | 1 | 367.88 | 49 | SO49865 | 2023-05-29 | 29.43 | 340.29 | 183.94 |
SO69513_15 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 547 | 45 | 5 | 2024-07-03 | 97.19 | 2.43 | 2024-06-21 | 2 | 35.96 | 1 | 97.19 | 15 | SO69513 | 2024-06-28 | 7.78 | 71.92 | 48.59 |
SO50756_33 | C414-447C-84 | PO9570119689 | 100 | 285 | 468 | 585 | 5 | 2023-08-03 | 22.79 | 0.57 | 2023-07-22 | 1 | 15.67 | 1 | 22.79 | 33 | SO50756 | 2023-07-29 | 1.82 | 15.67 | 22.79 |
SO46091_22 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 275 | 612 | 5 | 2022-07-03 | 356.90 | 8.92 | 2022-06-21 | 1 | 352.14 | 1 | 356.90 | 22 | SO46091 | 2022-06-28 | 28.55 | 352.14 | 356.90 |
SO50315_1 | EDB3-4074-A9 | PO7598160779 | 100 | 285 | 429 | 45 | 5 | 2023-07-03 | 973.36 | 24.33 | 2023-06-21 | 3 | 300.12 | 1 | 973.36 | 1 | SO50315 | 2023-06-28 | 77.87 | 900.36 | 324.45 |
SO55331_3 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 298 | 494 | 5 | 2023-12-03 | 809.76 | 20.24 | 2023-11-21 | 1 | 739.04 | 1 | 809.76 | 3 | SO55331 | 2023-11-28 | 64.78 | 739.04 | 809.76 |
SO46384_13 | 9F38-4366-91 | PO9541189751 | 100 | 285 | 220 | 279 | 5 | 2022-08-03 | 80.75 | 2.02 | 2022-07-22 | 4 | 12.03 | 1 | 80.75 | 13 | SO46384 | 2022-07-29 | 6.46 | 48.11 | 20.19 |
SO46028_28 | 7BBE-413C-83 | PO19546126425 | 100 | 285 | 272 | 206 | 5 | 2022-07-03 | 367.88 | 9.20 | 2022-06-21 | 2 | 181.49 | 1 | 367.88 | 28 | SO46028 | 2022-06-28 | 29.43 | 362.97 | 183.94 |
SO69518_14 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 357 | 63 | 5 | 2024-07-03 | 2783.99 | 69.60 | 2024-06-21 | 2 | 1265.62 | 1 | 2783.99 | 14 | SO69518 | 2024-06-28 | 222.72 | 2531.24 | 1391.99 |
SO71948_5 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 604 | 170 | 5 | 2024-08-03 | 2267.96 | 56.70 | 2024-07-22 | 7 | 343.65 | 1 | 2267.96 | 5 | SO71948 | 2024-07-29 | 181.44 | 2405.55 | 323.99 |
SO47042_5 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 470 | 566 | 5 | 2022-10-03 | 91.18 | 2.28 | 2022-09-21 | 4 | 15.67 | 1 | 91.18 | 5 | SO47042 | 2022-09-28 | 7.29 | 62.68 | 22.79 |
SO47026_7 | 123B-481F-8F | PO3596190739 | 100 | 285 | 409 | 476 | 5 | 2022-10-03 | 418.51 | 10.46 | 2022-09-21 | 2 | 185.82 | 1 | 418.51 | 7 | SO47026 | 2022-09-28 | 33.48 | 371.64 | 209.26 |
SO67260_36 | 6224-4229-B8 | PO522163557 | 100 | 285 | 587 | 676 | 5 | 2024-06-03 | 2308.47 | 57.71 | 2024-05-22 | 5 | 419.78 | 1 | 2308.47 | 36 | SO67260 | 2024-05-29 | 184.68 | 2098.89 | 461.69 |
SO46387_15 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 320 | 170 | 5 | 2022-08-03 | 1258.38 | 31.46 | 2022-07-22 | 3 | 413.15 | 1 | 1258.38 | 15 | SO46387 | 2022-07-29 | 100.67 | 1239.44 | 419.46 |
SO46933_32 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 273 | 206 | 5 | 2022-10-03 | 607.00 | 15.17 | 2022-09-21 | 3 | 187.16 | 1 | 607.00 | 32 | SO46933 | 2022-09-28 | 48.56 | 561.47 | 202.33 |
SO57027_6 | 15A6-4057-85 | PO16965111189 | 100 | 285 | 471 | 441 | 5 | 2024-01-03 | 266.70 | 6.67 | 2023-12-22 | 7 | 23.75 | 1 | 266.70 | 6 | SO57027 | 2023-12-29 | 21.34 | 166.24 | 38.10 |
SO46091_12 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 270 | 612 | 5 | 2022-07-03 | 183.94 | 4.60 | 2022-06-21 | 1 | 181.49 | 1 | 183.94 | 12 | SO46091 | 2022-06-28 | 14.72 | 181.49 | 183.94 |
SO46604_7 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 354 | 676 | 5 | 2022-09-02 | 4971.41 | 124.29 | 2022-08-21 | 4 | 1117.86 | 1 | 4971.41 | 7 | SO46604 | 2022-08-28 | 397.71 | 4471.42 | 1242.85 |
SO69451_18 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 496 | 260 | 5 | 2024-07-03 | 2409.38 | 60.23 | 2024-06-21 | 4 | 601.74 | 1 | 2409.38 | 18 | SO69451 | 2024-06-28 | 192.75 | 2406.97 | 602.35 |
SO58924_13 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 463 | 297 | 5 | 2024-02-02 | 73.47 | 1.84 | 2024-01-21 | 5 | 9.16 | 1 | 73.47 | 13 | SO58924 | 2024-01-28 | 5.88 | 45.80 | 14.69 |
SO49145_2 | 31DA-4BD5-9C | PO5568187962 | 100 | 285 | 468 | 422 | 5 | 2023-04-05 | 22.79 | 0.57 | 2023-03-24 | 1 | 15.67 | 1 | 22.79 | 2 | SO49145 | 2023-03-31 | 1.82 | 15.67 | 22.79 |
SO46933_33 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 369 | 206 | 5 | 2022-10-03 | 1466.01 | 36.65 | 2022-09-21 | 1 | 1518.79 | 1 | 1466.01 | 33 | SO46933 | 2022-09-28 | 117.28 | 1518.79 | 1466.01 |
Generated 2024-09-20 19:13:53.552 UTC