[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > < SKIP 2712 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53499_29 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 588 | 197 | 3 | 2023-12-28 | 1846.78 | 46.17 | 2023-12-16 | 4 | 419.78 | 1 | 1846.78 | 29 | SO53499 | 2023-12-23 | 147.74 | 1679.11 | 461.69 |
SO53499_30 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 463 | 197 | 3 | 2023-12-28 | 58.78 | 1.47 | 2023-12-16 | 4 | 9.16 | 1 | 58.78 | 30 | SO53499 | 2023-12-23 | 4.70 | 36.64 | 14.69 |
SO53499_31 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 214 | 197 | 3 | 2023-12-28 | 146.96 | 3.67 | 2023-12-16 | 7 | 13.09 | 1 | 146.96 | 31 | SO53499 | 2023-12-23 | 11.76 | 91.60 | 20.99 |
SO53499_32 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 290 | 197 | 3 | 2023-12-28 | 1637.40 | 40.94 | 2023-12-16 | 2 | 747.20 | 1 | 1637.40 | 32 | SO53499 | 2023-12-23 | 130.99 | 1494.40 | 818.70 |
SO53499_33 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 225 | 197 | 3 | 2023-12-28 | 21.58 | 0.54 | 2023-12-16 | 4 | 6.92 | 1 | 21.58 | 33 | SO53499 | 2023-12-23 | 1.73 | 27.69 | 5.39 |
SO53499_34 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 511 | 197 | 3 | 2023-12-28 | 436.91 | 10.92 | 2023-12-16 | 2 | 199.38 | 1 | 436.91 | 34 | SO53499 | 2023-12-23 | 34.95 | 398.75 | 218.45 |
SO53499_35 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 472 | 197 | 3 | 2023-12-28 | 114.30 | 2.86 | 2023-12-16 | 3 | 23.75 | 1 | 114.30 | 35 | SO53499 | 2023-12-23 | 9.14 | 71.25 | 38.10 |
SO53499_36 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 491 | 197 | 3 | 2023-12-28 | 323.94 | 8.10 | 2023-12-16 | 10 | 41.57 | 1 | 323.94 | 36 | SO53499 | 2023-12-23 | 25.92 | 415.72 | 32.39 |
SO53499_37 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 487 | 197 | 3 | 2023-12-28 | 131.98 | 3.30 | 2023-12-16 | 4 | 20.57 | 1 | 131.98 | 37 | SO53499 | 2023-12-23 | 10.56 | 82.27 | 32.99 |
SO53499_38 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 476 | 197 | 3 | 2023-12-28 | 335.95 | 8.40 | 2023-12-16 | 8 | 26.18 | 1 | 335.95 | 38 | SO53499 | 2023-12-23 | 26.88 | 209.41 | 41.99 |
SO53499_39 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 532 | 197 | 3 | 2023-12-28 | 599.50 | 14.99 | 2023-12-16 | 4 | 136.79 | 1 | 599.50 | 39 | SO53499 | 2023-12-23 | 47.96 | 547.14 | 149.87 |
SO53499_40 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 600 | 197 | 3 | 2023-12-28 | 647.99 | 16.20 | 2023-12-16 | 2 | 294.58 | 1 | 647.99 | 40 | SO53499 | 2023-12-23 | 51.84 | 589.16 | 323.99 |
SO53499_41 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 465 | 197 | 3 | 2023-12-28 | 58.78 | 1.47 | 2023-12-16 | 4 | 9.16 | 1 | 58.78 | 41 | SO53499 | 2023-12-23 | 4.70 | 36.64 | 14.69 |
SO53499_42 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 542 | 197 | 3 | 2023-12-28 | 97.18 | 2.43 | 2023-12-16 | 4 | 17.98 | 1 | 97.18 | 42 | SO53499 | 2023-12-23 | 7.77 | 71.91 | 24.29 |
SO53499_43 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 475 | 197 | 3 | 2023-12-28 | 167.98 | 4.20 | 2023-12-16 | 4 | 26.18 | 1 | 167.98 | 43 | SO53499 | 2023-12-23 | 13.44 | 104.71 | 41.99 |
SO53499_44 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 237 | 197 | 3 | 2023-12-28 | 149.97 | 3.75 | 2023-12-16 | 5 | 38.49 | 1 | 149.97 | 44 | SO53499 | 2023-12-23 | 12.00 | 192.46 | 29.99 |
SO53499_45 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 353 | 197 | 3 | 2023-12-28 | 1391.99 | 34.80 | 2023-12-16 | 1 | 1265.62 | 1 | 1391.99 | 45 | SO53499 | 2023-12-23 | 111.36 | 1265.62 | 1391.99 |
SO53499_46 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 516 | 197 | 3 | 2023-12-28 | 46.97 | 1.17 | 2023-12-16 | 2 | 17.38 | 1 | 46.97 | 46 | SO53499 | 2023-12-23 | 3.76 | 34.76 | 23.48 |
SO53499_47 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 484 | 197 | 3 | 2023-12-28 | 33.39 | 0.83 | 2023-12-16 | 7 | 2.97 | 1 | 33.39 | 47 | SO53499 | 2023-12-23 | 2.67 | 20.81 | 4.77 |
SO53499_48 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 593 | 197 | 3 | 2023-12-28 | 1016.98 | 25.42 | 2023-12-16 | 3 | 308.22 | 1 | 1016.98 | 48 | SO53499 | 2023-12-23 | 81.36 | 924.65 | 338.99 |
SO53499_49 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 517 | 197 | 3 | 2023-12-28 | 31.58 | 0.79 | 2023-12-16 | 1 | 23.37 | 1 | 31.58 | 49 | SO53499 | 2023-12-23 | 2.53 | 23.37 | 31.58 |
SO53499_50 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 598 | 197 | 3 | 2023-12-28 | 647.99 | 16.20 | 2023-12-16 | 2 | 294.58 | 1 | 647.99 | 50 | SO53499 | 2023-12-23 | 51.84 | 589.16 | 323.99 |
SO53526_1 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 604 | 579 | 3 | 2023-12-28 | 323.99 | 8.10 | 2023-12-16 | 1 | 343.65 | 1 | 323.99 | 1 | SO53526 | 2023-12-23 | 25.92 | 343.65 | 323.99 |
SO53526_2 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 382 | 579 | 3 | 2023-12-28 | 2016.88 | 50.42 | 2023-12-16 | 3 | 713.08 | 1 | 2016.88 | 2 | SO53526 | 2023-12-23 | 161.35 | 2139.24 | 672.29 |
SO53526_3 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 581 | 579 | 3 | 2023-12-28 | 4082.38 | 102.06 | 2023-12-16 | 4 | 1082.51 | 1 | 4082.38 | 3 | SO53526 | 2023-12-23 | 326.59 | 4330.04 | 1020.59 |
SO53526_4 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 255 | 579 | 3 | 2023-12-28 | 404.66 | 10.12 | 2023-12-16 | 2 | 204.63 | 1 | 404.66 | 4 | SO53526 | 2023-12-23 | 32.37 | 409.25 | 202.33 |
SO53526_5 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 480 | 579 | 3 | 2023-12-28 | 1.37 | 0.03 | 2023-12-16 | 1 | 0.86 | 1 | 1.37 | 5 | SO53526 | 2023-12-23 | 0.11 | 0.86 | 1.37 |
SO53526_6 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 386 | 579 | 3 | 2023-12-28 | 672.29 | 16.81 | 2023-12-16 | 1 | 713.08 | 1 | 672.29 | 6 | SO53526 | 2023-12-23 | 53.78 | 713.08 | 672.29 |
SO53526_7 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 582 | 579 | 3 | 2023-12-28 | 3061.78 | 76.54 | 2023-12-16 | 3 | 1082.51 | 1 | 3061.78 | 7 | SO53526 | 2023-12-23 | 244.94 | 3247.53 | 1020.59 |
SO53526_8 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 436 | 579 | 3 | 2023-12-28 | 2141.39 | 53.53 | 2023-12-16 | 6 | 360.94 | 1 | 2141.39 | 8 | SO53526 | 2023-12-23 | 171.31 | 2165.66 | 356.90 |
Generated 2024-11-14 16:53:14.568 UTC