[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 5834 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69411_11 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 605 | 77 | 4 | 2024-08-23 | 647.99 | 16.20 | 2024-08-11 | 2 | 343.65 | 1 | 647.99 | 11 | SO69411 | 2024-08-18 | 51.84 | 687.30 | 323.99 |
SO69411_12 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 583 | 77 | 4 | 2024-08-23 | 2041.19 | 51.03 | 2024-08-11 | 2 | 1082.51 | 1 | 2041.19 | 12 | SO69411 | 2024-08-18 | 163.30 | 2165.02 | 1020.59 |
SO69411_13 | E0BB-44D1-83 | PO15921144493 | 100 | 287 | 477 | 77 | 4 | 2024-08-23 | 2.99 | 0.07 | 2024-08-11 | 1 | 1.87 | 1 | 2.99 | 13 | SO69411 | 2024-08-18 | 0.24 | 1.87 | 2.99 |
SO69412_1 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 378 | 328 | 4 | 2024-08-23 | 7330.05 | 183.25 | 2024-08-11 | 5 | 1554.95 | 1 | 7330.05 | 1 | SO69412 | 2024-08-18 | 586.40 | 7774.74 | 1466.01 |
SO69412_2 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 483 | 328 | 4 | 2024-08-23 | 288.00 | 7.20 | 2024-08-11 | 4 | 44.88 | 1 | 288.00 | 2 | SO69412 | 2024-08-18 | 23.04 | 179.52 | 72.00 |
SO69412_3 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 581 | 328 | 4 | 2024-08-23 | 1020.59 | 25.51 | 2024-08-11 | 1 | 1082.51 | 1 | 1020.59 | 3 | SO69412 | 2024-08-18 | 81.65 | 1082.51 | 1020.59 |
SO69412_4 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 477 | 328 | 4 | 2024-08-23 | 14.97 | 0.37 | 2024-08-11 | 5 | 1.87 | 1 | 14.97 | 4 | SO69412 | 2024-08-18 | 1.20 | 9.33 | 2.99 |
SO69412_5 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 388 | 328 | 4 | 2024-08-23 | 1344.59 | 33.61 | 2024-08-11 | 2 | 713.08 | 1 | 1344.59 | 5 | SO69412 | 2024-08-18 | 107.57 | 1426.16 | 672.29 |
SO69412_6 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 234 | 328 | 4 | 2024-08-23 | 119.98 | 3.00 | 2024-08-11 | 4 | 38.49 | 1 | 119.98 | 6 | SO69412 | 2024-08-18 | 9.60 | 153.97 | 29.99 |
SO69412_7 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 380 | 328 | 4 | 2024-08-23 | 5864.04 | 146.60 | 2024-08-11 | 4 | 1554.95 | 1 | 5864.04 | 7 | SO69412 | 2024-08-18 | 469.12 | 6219.79 | 1466.01 |
SO69412_8 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 384 | 328 | 4 | 2024-08-23 | 2016.88 | 50.42 | 2024-08-11 | 3 | 713.08 | 1 | 2016.88 | 8 | SO69412 | 2024-08-18 | 161.35 | 2139.24 | 672.29 |
SO69412_9 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 217 | 328 | 4 | 2024-08-23 | 83.98 | 2.10 | 2024-08-11 | 4 | 13.09 | 1 | 83.98 | 9 | SO69412 | 2024-08-18 | 6.72 | 52.35 | 20.99 |
SO69412_10 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 490 | 328 | 4 | 2024-08-23 | 226.76 | 5.67 | 2024-08-11 | 7 | 41.57 | 1 | 226.76 | 10 | SO69412 | 2024-08-18 | 18.14 | 291.01 | 32.39 |
SO69412_11 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 472 | 328 | 4 | 2024-08-23 | 114.30 | 2.86 | 2024-08-11 | 3 | 23.75 | 1 | 114.30 | 11 | SO69412 | 2024-08-18 | 9.14 | 71.25 | 38.10 |
SO69412_12 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 546 | 328 | 4 | 2024-08-23 | 223.52 | 5.59 | 2024-08-11 | 6 | 27.57 | 1 | 223.52 | 12 | SO69412 | 2024-08-18 | 17.88 | 165.41 | 37.25 |
SO69412_13 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 584 | 328 | 4 | 2024-08-23 | 971.98 | 24.30 | 2024-08-11 | 3 | 343.65 | 1 | 971.98 | 13 | SO69412 | 2024-08-18 | 77.76 | 1030.95 | 323.99 |
SO69412_14 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 390 | 328 | 4 | 2024-08-23 | 672.29 | 16.81 | 2024-08-11 | 1 | 713.08 | 1 | 672.29 | 14 | SO69412 | 2024-08-18 | 53.78 | 713.08 | 672.29 |
SO69412_15 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 580 | 328 | 4 | 2024-08-23 | 2041.19 | 51.03 | 2024-08-11 | 2 | 1082.51 | 1 | 2041.19 | 15 | SO69412 | 2024-08-18 | 163.30 | 2165.02 | 1020.59 |
SO69412_16 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 604 | 328 | 4 | 2024-08-23 | 1295.98 | 32.40 | 2024-08-11 | 4 | 343.65 | 1 | 1295.98 | 16 | SO69412 | 2024-08-18 | 103.68 | 1374.60 | 323.99 |
SO69412_17 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 386 | 328 | 4 | 2024-08-23 | 2016.88 | 50.42 | 2024-08-11 | 3 | 713.08 | 1 | 2016.88 | 17 | SO69412 | 2024-08-18 | 161.35 | 2139.24 | 672.29 |
SO69412_18 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 583 | 328 | 4 | 2024-08-23 | 7144.16 | 178.60 | 2024-08-11 | 7 | 1082.51 | 1 | 7144.16 | 18 | SO69412 | 2024-08-18 | 571.53 | 7577.57 | 1020.59 |
SO69412_19 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 376 | 328 | 4 | 2024-08-23 | 4398.03 | 109.95 | 2024-08-11 | 3 | 1554.95 | 1 | 4398.03 | 19 | SO69412 | 2024-08-18 | 351.84 | 4664.84 | 1466.01 |
SO69412_20 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 287 | 328 | 4 | 2024-08-23 | 404.66 | 10.12 | 2024-08-11 | 2 | 204.63 | 1 | 404.66 | 20 | SO69412 | 2024-08-18 | 32.37 | 409.25 | 202.33 |
SO69412_21 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 434 | 328 | 4 | 2024-08-23 | 1427.59 | 35.69 | 2024-08-11 | 4 | 360.94 | 1 | 1427.59 | 21 | SO69412 | 2024-08-18 | 114.21 | 1443.77 | 356.90 |
SO69412_22 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 491 | 328 | 4 | 2024-08-23 | 291.55 | 7.29 | 2024-08-11 | 9 | 41.57 | 1 | 291.55 | 22 | SO69412 | 2024-08-18 | 23.32 | 374.15 | 32.39 |
SO69412_23 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 481 | 328 | 4 | 2024-08-23 | 32.36 | 0.81 | 2024-08-11 | 6 | 3.36 | 1 | 32.36 | 23 | SO69412 | 2024-08-18 | 2.59 | 20.17 | 5.39 |
SO69412_24 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 225 | 328 | 4 | 2024-08-23 | 43.15 | 1.08 | 2024-08-11 | 8 | 6.92 | 1 | 43.15 | 24 | SO69412 | 2024-08-18 | 3.45 | 55.38 | 5.39 |
SO69412_25 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 487 | 328 | 4 | 2024-08-23 | 197.96 | 4.95 | 2024-08-11 | 6 | 20.57 | 1 | 197.96 | 25 | SO69412 | 2024-08-18 | 15.84 | 123.40 | 32.99 |
Generated 2024-11-10 21:55:25.754 UTC