[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > < SKIP 813 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51745_5 | C261-441D-A5 | PO11745132954 | 100 | 282 | 382 | 97 | 4 | 2023-10-18 | 4033.76 | 100.84 | 2023-10-06 | 6 | 713.08 | 1 | 4033.76 | 5 | SO51745 | 2023-10-13 | 322.70 | 4278.48 | 672.29 |
SO48012_10 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 233 | 78 | 4 | 2023-01-18 | 173.04 | 4.33 | 2023-01-06 | 6 | 29.08 | 1 | 173.04 | 10 | SO48012 | 2023-01-13 | 13.84 | 174.48 | 28.84 |
SO51745_6 | C261-441D-A5 | PO11745132954 | 100 | 282 | 234 | 97 | 4 | 2023-10-18 | 29.99 | 0.75 | 2023-10-06 | 1 | 38.49 | 1 | 29.99 | 6 | SO51745 | 2023-10-13 | 2.40 | 38.49 | 29.99 |
SO48012_11 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 445 | 78 | 4 | 2023-01-18 | 179.97 | 4.50 | 2023-01-06 | 5 | 24.75 | 1 | 179.97 | 11 | SO48012 | 2023-01-13 | 14.40 | 123.73 | 35.99 |
SO51745_7 | C261-441D-A5 | PO11745132954 | 100 | 282 | 374 | 97 | 4 | 2023-10-18 | 5864.04 | 146.60 | 2023-10-06 | 4 | 1554.95 | 1 | 5864.04 | 7 | SO51745 | 2023-10-13 | 469.12 | 6219.79 | 1466.01 |
SO48012_12 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 433 | 78 | 4 | 2023-01-18 | 1946.72 | 48.67 | 2023-01-06 | 6 | 300.12 | 1 | 1946.72 | 12 | SO48012 | 2023-01-13 | 155.74 | 1800.71 | 324.45 |
SO51745_8 | C261-441D-A5 | PO11745132954 | 100 | 282 | 583 | 97 | 4 | 2023-10-18 | 3061.78 | 76.54 | 2023-10-06 | 3 | 1082.51 | 1 | 3061.78 | 8 | SO51745 | 2023-10-13 | 244.94 | 3247.53 | 1020.59 |
SO48012_13 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 461 | 78 | 4 | 2023-01-18 | 161.98 | 4.05 | 2023-01-06 | 3 | 37.12 | 1 | 161.98 | 13 | SO48012 | 2023-01-13 | 12.96 | 111.36 | 53.99 |
SO51745_9 | C261-441D-A5 | PO11745132954 | 100 | 282 | 408 | 97 | 4 | 2023-10-18 | 216.49 | 5.41 | 2023-10-06 | 3 | 53.40 | 1 | 216.49 | 9 | SO51745 | 2023-10-13 | 17.32 | 160.20 | 72.16 |
SO48012_14 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 464 | 78 | 4 | 2023-01-18 | 70.64 | 1.77 | 2023-01-06 | 5 | 9.71 | 1 | 70.64 | 14 | SO48012 | 2023-01-13 | 5.65 | 48.57 | 14.13 |
SO51745_10 | C261-441D-A5 | PO11745132954 | 100 | 282 | 255 | 97 | 4 | 2023-10-18 | 607.00 | 15.17 | 2023-10-06 | 3 | 204.63 | 1 | 607.00 | 10 | SO51745 | 2023-10-13 | 48.56 | 613.88 | 202.33 |
SO48012_15 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 377 | 78 | 4 | 2023-01-18 | 5235.75 | 130.89 | 2023-01-06 | 4 | 1320.68 | 1 | 5235.75 | 15 | SO48012 | 2023-01-13 | 418.86 | 5282.74 | 1308.94 |
SO51745_11 | C261-441D-A5 | PO11745132954 | 100 | 282 | 547 | 97 | 4 | 2023-10-18 | 242.97 | 6.07 | 2023-10-06 | 5 | 35.96 | 1 | 242.97 | 11 | SO51745 | 2023-10-13 | 19.44 | 179.80 | 48.59 |
SO48012_16 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 335 | 78 | 4 | 2023-01-18 | 939.59 | 23.49 | 2023-01-06 | 2 | 486.71 | 1 | 939.59 | 16 | SO48012 | 2023-01-13 | 75.17 | 973.41 | 469.79 |
SO51745_12 | C261-441D-A5 | PO11745132954 | 100 | 282 | 605 | 97 | 4 | 2023-10-18 | 971.98 | 24.30 | 2023-10-06 | 3 | 343.65 | 1 | 971.98 | 12 | SO51745 | 2023-10-13 | 77.76 | 1030.95 | 323.99 |
SO48012_17 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 265 | 78 | 4 | 2023-01-18 | 202.33 | 5.06 | 2023-01-06 | 1 | 187.16 | 1 | 202.33 | 17 | SO48012 | 2023-01-13 | 16.19 | 187.16 | 202.33 |
SO51745_13 | C261-441D-A5 | PO11745132954 | 100 | 282 | 546 | 97 | 4 | 2023-10-18 | 149.02 | 3.73 | 2023-10-06 | 4 | 27.57 | 1 | 149.02 | 13 | SO51745 | 2023-10-13 | 11.92 | 110.27 | 37.25 |
SO48012_18 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 224 | 78 | 4 | 2023-01-18 | 46.68 | 1.17 | 2023-01-06 | 9 | 5.23 | 1 | 46.68 | 18 | SO48012 | 2023-01-13 | 3.73 | 47.07 | 5.19 |
SO51745_14 | C261-441D-A5 | PO11745132954 | 100 | 282 | 604 | 97 | 4 | 2023-10-18 | 647.99 | 16.20 | 2023-10-06 | 2 | 343.65 | 1 | 647.99 | 14 | SO51745 | 2023-10-13 | 51.84 | 687.30 | 323.99 |
SO48012_19 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 435 | 78 | 4 | 2023-01-18 | 324.45 | 8.11 | 2023-01-06 | 1 | 300.12 | 1 | 324.45 | 19 | SO48012 | 2023-01-13 | 25.96 | 300.12 | 324.45 |
SO51745_15 | C261-441D-A5 | PO11745132954 | 100 | 282 | 580 | 97 | 4 | 2023-10-18 | 5102.97 | 127.57 | 2023-10-06 | 5 | 1082.51 | 1 | 5102.97 | 15 | SO51745 | 2023-10-13 | 408.24 | 5412.55 | 1020.59 |
SO48012_20 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 447 | 78 | 4 | 2023-01-18 | 90.00 | 2.25 | 2023-01-06 | 6 | 10.31 | 1 | 90.00 | 20 | SO48012 | 2023-01-13 | 7.20 | 61.88 | 15.00 |
SO51745_16 | C261-441D-A5 | PO11745132954 | 100 | 282 | 418 | 97 | 4 | 2023-10-18 | 1070.69 | 26.77 | 2023-10-06 | 3 | 360.94 | 1 | 1070.69 | 16 | SO51745 | 2023-10-13 | 85.66 | 1082.83 | 356.90 |
SO48012_21 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 213 | 78 | 4 | 2023-01-18 | 80.75 | 2.02 | 2023-01-06 | 4 | 13.88 | 1 | 80.75 | 21 | SO48012 | 2023-01-13 | 6.46 | 55.51 | 20.19 |
SO51745_17 | C261-441D-A5 | PO11745132954 | 100 | 282 | 581 | 97 | 4 | 2023-10-18 | 3061.78 | 76.54 | 2023-10-06 | 3 | 1082.51 | 1 | 3061.78 | 17 | SO51745 | 2023-10-13 | 244.94 | 3247.53 | 1020.59 |
SO48012_22 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 385 | 78 | 4 | 2023-01-18 | 2401.05 | 60.03 | 2023-01-06 | 4 | 605.65 | 1 | 2401.05 | 22 | SO48012 | 2023-01-13 | 192.08 | 2422.60 | 600.26 |
SO51745_18 | C261-441D-A5 | PO11745132954 | 100 | 282 | 482 | 97 | 4 | 2023-10-18 | 43.15 | 1.08 | 2023-10-06 | 8 | 3.36 | 1 | 43.15 | 18 | SO51745 | 2023-10-13 | 3.45 | 26.90 | 5.39 |
SO48012_23 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 462 | 78 | 4 | 2023-01-18 | 56.52 | 1.41 | 2023-01-06 | 4 | 9.71 | 1 | 56.52 | 23 | SO48012 | 2023-01-13 | 4.52 | 38.85 | 14.13 |
SO51745_19 | C261-441D-A5 | PO11745132954 | 100 | 282 | 378 | 97 | 4 | 2023-10-18 | 8796.06 | 219.90 | 2023-10-06 | 6 | 1554.95 | 1 | 8796.06 | 19 | SO51745 | 2023-10-13 | 703.68 | 9329.69 | 1466.01 |
SO48012_24 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 368 | 78 | 4 | 2023-01-18 | 8796.06 | 219.90 | 2023-01-06 | 6 | 1518.79 | 1 | 8796.06 | 24 | SO48012 | 2023-01-13 | 703.68 | 9112.72 | 1466.01 |
SO51745_20 | C261-441D-A5 | PO11745132954 | 100 | 282 | 386 | 97 | 4 | 2023-10-18 | 2016.88 | 50.42 | 2023-10-06 | 3 | 713.08 | 1 | 2016.88 | 20 | SO51745 | 2023-10-13 | 161.35 | 2139.24 | 672.29 |
Generated 2024-10-05 22:28:24.926 UTC