[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49894_16 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 420 | 252 | 2 | 2023-06-04 | 566.46 | 14.16 | 2023-05-23 | 4 | 104.80 | 1 | 566.46 | 16 | SO49894 | 2023-05-30 | 45.32 | 419.18 | 141.62 |
SO49894_17 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 358 | 252 | 2 | 2023-06-04 | 2458.92 | 61.47 | 2023-05-23 | 2 | 1105.81 | 1 | 2458.92 | 17 | SO49894 | 2023-05-30 | 196.71 | 2211.62 | 1229.46 |
SO49894_18 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 399 | 252 | 2 | 2023-06-04 | 33.77 | 0.84 | 2023-05-23 | 1 | 24.99 | 1 | 33.77 | 18 | SO49894 | 2023-05-30 | 2.70 | 24.99 | 33.77 |
SO49894_19 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 468 | 252 | 2 | 2023-06-04 | 68.38 | 1.71 | 2023-05-23 | 3 | 15.67 | 1 | 68.38 | 19 | SO49894 | 2023-05-30 | 5.47 | 47.01 | 22.79 |
SO49894_20 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 352 | 252 | 2 | 2023-06-04 | 4971.41 | 124.29 | 2023-05-23 | 4 | 1117.86 | 1 | 4971.41 | 20 | SO49894 | 2023-05-30 | 397.71 | 4471.42 | 1242.85 |
SO49894_21 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 364 | 252 | 2 | 2023-06-04 | 1943.98 | 48.60 | 2023-05-23 | 3 | 598.44 | 1 | 1943.98 | 21 | SO49894 | 2023-05-30 | 155.52 | 1795.31 | 647.99 |
SO49894_22 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 362 | 252 | 2 | 2023-06-04 | 1229.46 | 30.74 | 2023-05-23 | 1 | 1105.81 | 1 | 1229.46 | 22 | SO49894 | 2023-05-30 | 98.36 | 1105.81 | 1229.46 |
SO50228_1 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 366 | 396 | 2 | 2023-07-04 | 3239.97 | 81.00 | 2023-06-22 | 5 | 598.44 | 1 | 3239.97 | 1 | SO50228 | 2023-06-29 | 259.20 | 2992.18 | 647.99 |
SO50228_2 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 297 | 396 | 2 | 2023-07-04 | 736.15 | 18.40 | 2023-06-22 | 1 | 653.70 | 1 | 736.15 | 2 | SO50228 | 2023-06-29 | 58.89 | 653.70 | 736.15 |
SO50228_3 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 354 | 396 | 2 | 2023-07-04 | 3728.56 | 93.21 | 2023-06-22 | 3 | 1117.86 | 1 | 3728.56 | 3 | SO50228 | 2023-06-29 | 298.28 | 3353.57 | 1242.85 |
SO50228_4 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 224 | 396 | 2 | 2023-07-04 | 10.37 | 0.26 | 2023-06-22 | 2 | 5.23 | 1 | 10.37 | 4 | SO50228 | 2023-06-29 | 0.83 | 10.46 | 5.19 |
SO50228_5 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 420 | 396 | 2 | 2023-07-04 | 566.46 | 14.16 | 2023-06-22 | 4 | 104.80 | 1 | 566.46 | 5 | SO50228 | 2023-06-29 | 45.32 | 419.18 | 141.62 |
SO50228_6 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 308 | 396 | 2 | 2023-07-04 | 1488.55 | 37.21 | 2023-06-22 | 2 | 660.91 | 1 | 1488.55 | 6 | SO50228 | 2023-06-29 | 119.08 | 1321.83 | 744.27 |
SO50228_7 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 356 | 396 | 2 | 2023-07-04 | 1242.85 | 31.07 | 2023-06-22 | 1 | 1117.86 | 1 | 1242.85 | 7 | SO50228 | 2023-06-29 | 99.43 | 1117.86 | 1242.85 |
SO50228_8 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 410 | 396 | 2 | 2023-07-04 | 72.89 | 1.82 | 2023-06-22 | 2 | 26.97 | 1 | 72.89 | 8 | SO50228 | 2023-06-29 | 5.83 | 53.94 | 36.45 |
SO50228_9 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 364 | 396 | 2 | 2023-07-04 | 647.99 | 16.20 | 2023-06-22 | 1 | 598.44 | 1 | 647.99 | 9 | SO50228 | 2023-06-29 | 51.84 | 598.44 | 647.99 |
SO50228_10 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 352 | 396 | 2 | 2023-07-04 | 3728.56 | 93.21 | 2023-06-22 | 3 | 1117.86 | 1 | 3728.56 | 10 | SO50228 | 2023-06-29 | 298.28 | 3353.57 | 1242.85 |
SO50228_11 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 393 | 396 | 2 | 2023-07-04 | 413.08 | 10.33 | 2023-06-22 | 3 | 101.89 | 1 | 413.08 | 11 | SO50228 | 2023-06-29 | 33.05 | 305.68 | 137.69 |
SO50228_12 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 421 | 396 | 2 | 2023-07-04 | 1177.97 | 29.45 | 2023-06-22 | 6 | 145.28 | 1 | 1177.97 | 12 | SO50228 | 2023-06-29 | 94.24 | 871.70 | 196.33 |
SO50228_13 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 470 | 396 | 2 | 2023-07-04 | 136.76 | 3.42 | 2023-06-22 | 6 | 15.67 | 1 | 136.76 | 13 | SO50228 | 2023-06-29 | 10.94 | 94.03 | 22.79 |
SO50228_14 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 367 | 396 | 2 | 2023-07-04 | 1943.98 | 48.60 | 2023-06-22 | 3 | 598.44 | 1 | 1943.98 | 14 | SO50228 | 2023-06-29 | 155.52 | 1795.31 | 647.99 |
SO50228_15 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 396 | 396 | 2 | 2023-07-04 | 224.51 | 5.61 | 2023-06-22 | 3 | 55.38 | 1 | 224.51 | 15 | SO50228 | 2023-06-29 | 17.96 | 166.14 | 74.84 |
SO50228_16 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 399 | 396 | 2 | 2023-07-04 | 67.55 | 1.69 | 2023-06-22 | 2 | 24.99 | 1 | 67.55 | 16 | SO50228 | 2023-06-29 | 5.40 | 49.99 | 33.77 |
SO50228_17 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 360 | 396 | 2 | 2023-07-04 | 3688.38 | 92.21 | 2023-06-22 | 3 | 1105.81 | 1 | 3688.38 | 17 | SO50228 | 2023-06-29 | 295.07 | 3317.43 | 1229.46 |
Generated 2024-09-21 12:34:57.648 UTC