[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '283' > SKIP 2500 SHUFFLE < SKIP 1000 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67282_11 | 50CB-4642-B1 | PO11687162635 | 100 | 283 | 568 | 691 | 2 | 2024-06-02 | 445.41 | 11.14 | 2024-05-21 | 1 | 461.44 | 1 | 445.41 | 11 | SO67282 | 2024-05-28 | 35.63 | 461.44 | 445.41 |
SO59006_3 | 44DF-4F7B-BE | PO9019145536 | 100 | 283 | 600 | 576 | 2 | 2024-02-01 | 323.99 | 8.10 | 2024-01-20 | 1 | 294.58 | 1 | 323.99 | 3 | SO59006 | 2024-01-27 | 25.92 | 294.58 | 323.99 |
SO51796_2 | F389-4FC2-92 | PO18734163485 | 100 | 283 | 480 | 449 | 5 | 2023-10-02 | 4.12 | 0.10 | 2023-09-20 | 3 | 0.86 | 1 | 4.12 | 2 | SO51796 | 2023-09-27 | 0.33 | 2.57 | 1.37 |
SO53499_30 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 463 | 197 | 3 | 2023-11-02 | 58.78 | 1.47 | 2023-10-21 | 4 | 9.16 | 1 | 58.78 | 30 | SO53499 | 2023-10-28 | 4.70 | 36.64 | 14.69 |
SO49113_16 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 297 | 233 | 2 | 2023-04-04 | 4416.87 | 110.42 | 2023-03-23 | 6 | 653.70 | 1 | 4416.87 | 16 | SO49113 | 2023-03-30 | 353.35 | 3922.18 | 736.15 |
SO49843_21 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 427 | 594 | 2 | 2023-06-02 | 1255.54 | 31.39 | 2023-05-21 | 6 | 185.82 | 1 | 1255.54 | 21 | SO49843 | 2023-05-28 | 100.44 | 1114.92 | 209.26 |
SO49113_17 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 233 | 233 | 2 | 2023-04-04 | 86.52 | 2.16 | 2023-03-23 | 3 | 29.08 | 1 | 86.52 | 17 | SO49113 | 2023-03-30 | 6.92 | 87.24 | 28.84 |
SO59012_2 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 487 | 539 | 2 | 2024-02-01 | 164.97 | 4.12 | 2024-01-20 | 5 | 20.57 | 1 | 164.97 | 2 | SO59012 | 2024-01-27 | 13.20 | 102.83 | 32.99 |
SO65178_1 | 808E-413C-94 | PO16994175277 | 100 | 283 | 388 | 306 | 3 | 2024-05-02 | 2689.18 | 67.23 | 2024-04-20 | 4 | 713.08 | 1 | 2689.18 | 1 | SO65178 | 2024-04-27 | 215.13 | 2852.32 | 672.29 |
SO50235_8 | 20B9-4308-A5 | PO10121141993 | 100 | 283 | 327 | 684 | 2 | 2023-07-02 | 2818.76 | 70.47 | 2023-06-20 | 6 | 486.71 | 1 | 2818.76 | 8 | SO50235 | 2023-06-27 | 225.50 | 2920.24 | 469.79 |
SO51748_26 | 1D77-486A-86 | PO11658169327 | 100 | 283 | 483 | 233 | 2 | 2023-10-02 | 144.00 | 3.60 | 2023-09-20 | 2 | 44.88 | 1 | 144.00 | 26 | SO51748 | 2023-09-27 | 11.52 | 89.76 | 72.00 |
SO50259_7 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 415 | 558 | 2 | 2023-07-02 | 792.14 | 19.80 | 2023-06-20 | 4 | 146.55 | 1 | 792.14 | 7 | SO50259 | 2023-06-27 | 63.37 | 586.19 | 198.04 |
SO69450_4 | 7050-466D-9B | PO10121172172 | 100 | 283 | 374 | 684 | 2 | 2024-07-02 | 2932.02 | 73.30 | 2024-06-20 | 2 | 1554.95 | 1 | 2932.02 | 4 | SO69450 | 2024-06-27 | 234.56 | 3109.90 | 1466.01 |
SO50682_32 | 1145-4AD1-B8 | PO12354142084 | 100 | 283 | 365 | 197 | 3 | 2023-08-02 | 647.99 | 16.20 | 2023-07-21 | 1 | 598.44 | 1 | 647.99 | 32 | SO50682 | 2023-07-28 | 51.84 | 598.44 | 647.99 |
SO50235_16 | 20B9-4308-A5 | PO10121141993 | 100 | 283 | 439 | 684 | 2 | 2023-07-02 | 780.82 | 19.52 | 2023-06-20 | 1 | 722.26 | 1 | 780.82 | 16 | SO50235 | 2023-06-27 | 62.47 | 722.26 | 780.82 |
SO51810_25 | 0D49-491D-BD | PO7453119597 | 100 | 283 | 580 | 108 | 2 | 2023-10-02 | 8164.75 | 204.12 | 2023-09-20 | 8 | 1082.51 | 1 | 8164.75 | 25 | SO51810 | 2023-09-27 | 653.18 | 8660.08 | 1020.59 |
SO50683_4 | 8EBE-4D2C-AB | PO11455112273 | 100 | 283 | 407 | 72 | 2 | 2023-08-02 | 65.60 | 1.64 | 2023-07-21 | 1 | 48.55 | 1 | 65.60 | 4 | SO50683 | 2023-07-28 | 5.25 | 48.55 | 65.60 |
SO48770_14 | 28CC-48AC-B8 | PO11484112888 | 100 | 283 | 420 | 594 | 2 | 2023-03-04 | 566.46 | 14.16 | 2023-02-20 | 4 | 104.80 | 1 | 566.46 | 14 | SO48770 | 2023-02-27 | 45.32 | 419.18 | 141.62 |
SO59075_8 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 483 | 179 | 2 | 2024-02-01 | 504.00 | 12.60 | 2024-01-20 | 7 | 44.88 | 1 | 504.00 | 8 | SO59075 | 2024-01-27 | 40.32 | 314.16 | 72.00 |
SO59074_24 | 1711-471C-82 | PO9483120932 | 100 | 283 | 482 | 54 | 2 | 2024-02-01 | 10.79 | 0.27 | 2024-01-20 | 2 | 3.36 | 1 | 10.79 | 24 | SO59074 | 2024-01-27 | 0.86 | 6.72 | 5.39 |
SO53506_24 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 281 | 72 | 2 | 2023-11-02 | 1011.66 | 25.29 | 2023-10-21 | 5 | 204.63 | 1 | 1011.66 | 24 | SO53506 | 2023-10-28 | 80.93 | 1023.13 | 202.33 |
SO47700_24 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 428 | 184 | 4 | 2022-12-02 | 1255.54 | 31.39 | 2022-11-20 | 6 | 185.82 | 1 | 1255.54 | 24 | SO47700 | 2022-11-27 | 100.44 | 1114.92 | 209.26 |
SO50706_1 | 70CD-450F-88 | PO20213136162 | 100 | 283 | 325 | 216 | 2 | 2023-08-02 | 1409.38 | 35.23 | 2023-07-21 | 3 | 486.71 | 1 | 1409.38 | 1 | SO50706 | 2023-07-28 | 112.75 | 1460.12 | 469.79 |
SO57065_39 | B68A-407E-99 | PO11658151711 | 100 | 283 | 595 | 233 | 2 | 2024-01-02 | 1694.97 | 42.37 | 2023-12-21 | 5 | 308.22 | 1 | 1694.97 | 39 | SO57065 | 2023-12-28 | 135.60 | 1541.09 | 338.99 |
SO53570_25 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 240 | 54 | 2 | 2023-11-02 | 1717.80 | 42.95 | 2023-10-21 | 2 | 868.63 | 1 | 1717.80 | 25 | SO53570 | 2023-10-28 | 137.42 | 1737.27 | 858.90 |
SO57101_4 | E5FB-42E2-A9 | PO18386193019 | 100 | 283 | 408 | 558 | 2 | 2024-01-02 | 216.49 | 5.41 | 2023-12-21 | 3 | 53.40 | 1 | 216.49 | 4 | SO57101 | 2023-12-28 | 17.32 | 160.20 | 72.16 |
SO49843_30 | D3CA-4A51-B6 | PO11484175391 | 100 | 283 | 401 | 594 | 2 | 2023-06-02 | 131.20 | 3.28 | 2023-05-21 | 2 | 48.55 | 1 | 131.20 | 30 | SO49843 | 2023-05-28 | 10.50 | 97.09 | 65.60 |
SO51140_21 | 0583-4C94-BA | PO6467148715 | 100 | 283 | 408 | 660 | 3 | 2023-09-01 | 72.16 | 1.80 | 2023-08-20 | 1 | 53.40 | 1 | 72.16 | 21 | SO51140 | 2023-08-27 | 5.77 | 53.40 | 72.16 |
SO47700_22 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 365 | 184 | 4 | 2022-12-02 | 2591.98 | 64.80 | 2022-11-20 | 4 | 598.44 | 1 | 2591.98 | 22 | SO47700 | 2022-11-27 | 207.36 | 2393.74 | 647.99 |
SO48375_5 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 364 | 75 | 4 | 2023-02-01 | 647.99 | 16.20 | 2023-01-20 | 1 | 598.44 | 1 | 647.99 | 5 | SO48375 | 2023-01-27 | 51.84 | 598.44 | 647.99 |
SO63219_8 | E19D-4F90-91 | PO7453184328 | 100 | 283 | 231 | 108 | 2 | 2024-04-03 | 269.95 | 6.75 | 2024-03-22 | 9 | 38.49 | 1 | 269.95 | 8 | SO63219 | 2024-03-29 | 21.60 | 346.43 | 29.99 |
Generated 2024-09-20 00:42:04.524 UTC