[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > < SKIP 2551 > < TAKE 24 >
24 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50675_12 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 411 | 327 | 3 | 2023-08-04 | 125.42 | 3.14 | 2023-07-23 | 1 | 92.81 | 1 | 125.42 | 12 | SO50675 | 2023-07-30 | 10.03 | 92.81 | 125.42 |
SO50675_13 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 401 | 327 | 3 | 2023-08-04 | 196.81 | 4.92 | 2023-07-23 | 3 | 48.55 | 1 | 196.81 | 13 | SO50675 | 2023-07-30 | 15.74 | 145.64 | 65.60 |
SO50675_14 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 410 | 327 | 3 | 2023-08-04 | 72.89 | 1.82 | 2023-07-23 | 2 | 26.97 | 1 | 72.89 | 14 | SO50675 | 2023-07-30 | 5.83 | 53.94 | 36.45 |
SO50675_15 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 447 | 327 | 3 | 2023-08-04 | 45.00 | 1.13 | 2023-07-23 | 3 | 10.31 | 1 | 45.00 | 15 | SO50675 | 2023-07-30 | 3.60 | 30.94 | 15.00 |
SO50675_16 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 216 | 327 | 3 | 2023-08-04 | 20.19 | 0.50 | 2023-07-23 | 1 | 13.88 | 1 | 20.19 | 16 | SO50675 | 2023-07-30 | 1.61 | 13.88 | 20.19 |
SO50675_17 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 453 | 327 | 3 | 2023-08-04 | 143.98 | 3.60 | 2023-07-23 | 4 | 24.75 | 1 | 143.98 | 17 | SO50675 | 2023-07-30 | 11.52 | 98.98 | 35.99 |
SO50675_18 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 365 | 327 | 3 | 2023-08-04 | 4535.96 | 113.40 | 2023-07-23 | 7 | 598.44 | 1 | 4535.96 | 18 | SO50675 | 2023-07-30 | 362.88 | 4189.05 | 647.99 |
SO50675_19 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 360 | 327 | 3 | 2023-08-04 | 8606.21 | 215.16 | 2023-07-23 | 7 | 1105.81 | 1 | 8606.21 | 19 | SO50675 | 2023-07-30 | 688.50 | 7740.67 | 1229.46 |
SO50675_20 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 366 | 327 | 3 | 2023-08-04 | 1295.99 | 32.40 | 2023-07-23 | 2 | 598.44 | 1 | 1295.99 | 20 | SO50675 | 2023-07-30 | 103.68 | 1196.87 | 647.99 |
SO63194_25 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 398 | 381 | 3 | 2024-04-05 | 53.45 | 1.34 | 2024-03-24 | 2 | 19.78 | 1 | 53.45 | 25 | SO63194 | 2024-03-31 | 4.28 | 39.55 | 26.72 |
SO63205_1 | 2472-4EFB-9E | PO13601146069 | 100 | 281 | 482 | 310 | 3 | 2024-04-05 | 32.36 | 0.81 | 2024-03-24 | 6 | 3.36 | 1 | 32.36 | 1 | SO63205 | 2024-03-31 | 2.59 | 20.17 | 5.39 |
SO63205_2 | 2472-4EFB-9E | PO13601146069 | 100 | 281 | 481 | 310 | 3 | 2024-04-05 | 16.18 | 0.40 | 2024-03-24 | 3 | 3.36 | 1 | 16.18 | 2 | SO63205 | 2024-03-31 | 1.29 | 10.09 | 5.39 |
SO63205_3 | 2472-4EFB-9E | PO13601146069 | 100 | 281 | 471 | 310 | 3 | 2024-04-05 | 114.30 | 2.86 | 2024-03-24 | 3 | 23.75 | 1 | 114.30 | 3 | SO63205 | 2024-03-31 | 9.14 | 71.25 | 38.10 |
SO63215_1 | A697-4D03-B0 | PO8874198670 | 100 | 282 | 588 | 348 | 3 | 2024-04-05 | 461.69 | 11.54 | 2024-03-24 | 1 | 419.78 | 1 | 461.69 | 1 | SO63215 | 2024-03-31 | 36.94 | 419.78 | 461.69 |
SO63215_2 | A697-4D03-B0 | PO8874198670 | 100 | 282 | 512 | 348 | 3 | 2024-04-05 | 218.45 | 5.46 | 2024-03-24 | 1 | 199.38 | 1 | 218.45 | 2 | SO63215 | 2024-03-31 | 17.48 | 199.38 | 218.45 |
SO63215_3 | A697-4D03-B0 | PO8874198670 | 100 | 282 | 475 | 348 | 3 | 2024-04-05 | 41.99 | 1.05 | 2024-03-24 | 1 | 26.18 | 1 | 41.99 | 3 | SO63215 | 2024-03-31 | 3.36 | 26.18 | 41.99 |
SO63226_1 | F7CF-4152-A5 | PO8932196842 | 100 | 283 | 475 | 287 | 3 | 2024-04-05 | 41.99 | 1.05 | 2024-03-24 | 1 | 26.18 | 1 | 41.99 | 1 | SO63226 | 2024-03-31 | 3.36 | 26.18 | 41.99 |
SO63257_1 | B81B-4565-85 | PO5771197507 | 100 | 282 | 477 | 79 | 3 | 2024-04-05 | 17.96 | 0.45 | 2024-03-24 | 6 | 1.87 | 1 | 17.96 | 1 | SO63257 | 2024-03-31 | 1.44 | 11.20 | 2.99 |
SO63257_2 | B81B-4565-85 | PO5771197507 | 100 | 282 | 384 | 79 | 3 | 2024-04-05 | 2689.18 | 67.23 | 2024-03-24 | 4 | 713.08 | 1 | 2689.18 | 2 | SO63257 | 2024-03-31 | 215.13 | 2852.32 | 672.29 |
SO63257_3 | B81B-4565-85 | PO5771197507 | 100 | 282 | 490 | 79 | 3 | 2024-04-05 | 129.58 | 3.24 | 2024-03-24 | 4 | 41.57 | 1 | 129.58 | 3 | SO63257 | 2024-03-31 | 10.37 | 166.29 | 32.39 |
SO63257_4 | B81B-4565-85 | PO5771197507 | 100 | 282 | 581 | 79 | 3 | 2024-04-05 | 2041.19 | 51.03 | 2024-03-24 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO63257 | 2024-03-31 | 163.30 | 2165.02 | 1020.59 |
SO63257_5 | B81B-4565-85 | PO5771197507 | 100 | 282 | 372 | 79 | 3 | 2024-04-05 | 4398.03 | 109.95 | 2024-03-24 | 3 | 1554.95 | 1 | 4398.03 | 5 | SO63257 | 2024-03-31 | 351.84 | 4664.84 | 1466.01 |
SO63257_6 | B81B-4565-85 | PO5771197507 | 100 | 282 | 374 | 79 | 3 | 2024-04-05 | 5864.04 | 146.60 | 2024-03-24 | 4 | 1554.95 | 1 | 5864.04 | 6 | SO63257 | 2024-03-31 | 469.12 | 6219.79 | 1466.01 |
SO63257_7 | B81B-4565-85 | PO5771197507 | 100 | 282 | 380 | 79 | 3 | 2024-04-05 | 2932.02 | 73.30 | 2024-03-24 | 2 | 1554.95 | 1 | 2932.02 | 7 | SO63257 | 2024-03-31 | 234.56 | 3109.90 | 1466.01 |
Generated 2024-09-21 09:56:05.693 UTC