[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'USD' > SKIP 875 < SKIP 1124 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47687_27 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 379 | 203 | 4 | 2023-01-27 | 2617.88 | 65.45 | 2023-01-15 | 2 | 1320.68 | 1 | 2617.88 | 27 | SO47687 | 2023-01-22 | 209.43 | 2641.37 | 1308.94 |
SO43875_19 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 215 | 278 | 5 | 2021-11-27 | 100.93 | 2.52 | 2021-11-15 | 5 | 12.03 | 1 | 100.93 | 19 | SO43875 | 2021-11-22 | 8.07 | 60.14 | 20.19 |
SO47687_28 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 325 | 203 | 4 | 2023-01-27 | 1409.38 | 35.23 | 2023-01-15 | 3 | 486.71 | 1 | 1409.38 | 28 | SO47687 | 2023-01-22 | 112.75 | 1460.12 | 469.79 |
SO43875_20 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 293 | 278 | 5 | 2021-11-27 | 2167.78 | 54.19 | 2021-11-15 | 3 | 623.84 | 1 | 2167.78 | 20 | SO43875 | 2021-11-22 | 173.42 | 1871.52 | 722.59 |
SO47687_29 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 385 | 203 | 4 | 2023-01-27 | 1200.53 | 30.01 | 2023-01-15 | 2 | 605.65 | 1 | 1200.53 | 29 | SO47687 | 2023-01-22 | 96.04 | 1211.30 | 600.26 |
SO43875_21 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 229 | 278 | 5 | 2021-11-27 | 57.68 | 1.44 | 2021-11-15 | 2 | 31.72 | 1 | 57.68 | 21 | SO43875 | 2021-11-22 | 4.61 | 63.45 | 28.84 |
SO47687_30 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 216 | 203 | 4 | 2023-01-27 | 80.75 | 2.02 | 2023-01-15 | 4 | 13.88 | 1 | 80.75 | 30 | SO47687 | 2023-01-22 | 6.46 | 55.51 | 20.19 |
SO43876_1 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 326 | 270 | 2 | 2021-11-27 | 838.92 | 20.97 | 2021-11-15 | 2 | 413.15 | 1 | 838.92 | 1 | SO43876 | 2021-11-22 | 67.11 | 826.29 | 419.46 |
SO47687_31 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 233 | 203 | 4 | 2023-01-27 | 144.20 | 3.61 | 2023-01-15 | 5 | 29.08 | 1 | 144.20 | 31 | SO47687 | 2023-01-22 | 11.54 | 145.40 | 28.84 |
SO43876_2 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 319 | 270 | 2 | 2021-11-27 | 874.79 | 21.87 | 2021-11-15 | 1 | 884.71 | 1 | 874.79 | 2 | SO43876 | 2021-11-22 | 69.98 | 884.71 | 874.79 |
SO47687_32 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 224 | 203 | 4 | 2023-01-27 | 25.93 | 0.65 | 2023-01-15 | 5 | 5.23 | 1 | 25.93 | 32 | SO47687 | 2023-01-22 | 2.07 | 26.15 | 5.19 |
SO43876_3 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 328 | 270 | 2 | 2021-11-27 | 1258.38 | 31.46 | 2021-11-15 | 3 | 413.15 | 1 | 1258.38 | 3 | SO43876 | 2021-11-22 | 100.67 | 1239.44 | 419.46 |
SO47687_33 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 341 | 203 | 4 | 2023-01-27 | 939.59 | 23.49 | 2023-01-15 | 2 | 486.71 | 1 | 939.59 | 33 | SO47687 | 2023-01-22 | 75.17 | 973.41 | 469.79 |
SO43876_4 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 315 | 270 | 2 | 2021-11-27 | 1749.59 | 43.74 | 2021-11-15 | 2 | 884.71 | 1 | 1749.59 | 4 | SO43876 | 2021-11-22 | 139.97 | 1769.42 | 874.79 |
SO47687_34 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 331 | 203 | 4 | 2023-01-27 | 469.79 | 11.74 | 2023-01-15 | 1 | 486.71 | 1 | 469.79 | 34 | SO47687 | 2023-01-22 | 37.58 | 486.71 | 469.79 |
SO43876_5 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 262 | 270 | 2 | 2021-11-27 | 367.88 | 9.20 | 2021-11-15 | 2 | 181.49 | 1 | 367.88 | 5 | SO43876 | 2021-11-22 | 29.43 | 362.97 | 183.94 |
SO47687_35 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 383 | 203 | 4 | 2023-01-27 | 1200.53 | 30.01 | 2023-01-15 | 2 | 605.65 | 1 | 1200.53 | 35 | SO47687 | 2023-01-22 | 96.04 | 1211.30 | 600.26 |
SO43876_6 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 324 | 270 | 2 | 2021-11-27 | 838.92 | 20.97 | 2021-11-15 | 2 | 413.15 | 1 | 838.92 | 6 | SO43876 | 2021-11-22 | 67.11 | 826.29 | 419.46 |
SO47687_36 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 339 | 203 | 4 | 2023-01-27 | 939.59 | 23.49 | 2023-01-15 | 2 | 486.71 | 1 | 939.59 | 36 | SO47687 | 2023-01-22 | 75.17 | 973.41 | 469.79 |
SO43876_7 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 342 | 270 | 2 | 2021-11-27 | 838.92 | 20.97 | 2021-11-15 | 2 | 413.15 | 1 | 838.92 | 7 | SO43876 | 2021-11-22 | 67.11 | 826.29 | 419.46 |
SO47687_37 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 335 | 203 | 4 | 2023-01-27 | 469.79 | 11.74 | 2023-01-15 | 1 | 486.71 | 1 | 469.79 | 37 | SO47687 | 2023-01-22 | 37.58 | 486.71 | 469.79 |
SO43876_8 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 270 | 270 | 2 | 2021-11-27 | 367.88 | 9.20 | 2021-11-15 | 2 | 181.49 | 1 | 367.88 | 8 | SO43876 | 2021-11-22 | 29.43 | 362.97 | 183.94 |
SO47687_38 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 368 | 203 | 4 | 2023-01-27 | 2932.02 | 73.30 | 2023-01-15 | 2 | 1518.79 | 1 | 2932.02 | 38 | SO47687 | 2023-01-22 | 234.56 | 3037.57 | 1466.01 |
SO43877_1 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 232 | 73 | 1 | 2021-11-27 | 115.36 | 2.88 | 2021-11-15 | 4 | 31.72 | 1 | 115.36 | 1 | SO43877 | 2021-11-22 | 9.23 | 126.90 | 28.84 |
SO47687_39 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 343 | 203 | 4 | 2023-01-27 | 2348.97 | 58.72 | 2023-01-15 | 5 | 486.71 | 1 | 2348.97 | 39 | SO47687 | 2023-01-22 | 187.92 | 2433.53 | 469.79 |
SO43877_2 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 215 | 73 | 1 | 2021-11-27 | 40.37 | 1.01 | 2021-11-15 | 2 | 12.03 | 1 | 40.37 | 2 | SO43877 | 2021-11-22 | 3.23 | 24.06 | 20.19 |
SO47687_40 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 230 | 203 | 4 | 2023-01-27 | 28.84 | 0.72 | 2023-01-15 | 1 | 29.08 | 1 | 28.84 | 40 | SO47687 | 2023-01-22 | 2.31 | 29.08 | 28.84 |
SO43877_3 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 218 | 73 | 1 | 2021-11-27 | 28.50 | 0.71 | 2021-11-15 | 5 | 3.40 | 1 | 28.50 | 3 | SO43877 | 2021-11-22 | 2.28 | 16.98 | 5.70 |
SO47687_41 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 458 | 203 | 4 | 2023-01-27 | 179.98 | 4.50 | 2023-01-15 | 4 | 30.93 | 1 | 179.98 | 41 | SO47687 | 2023-01-22 | 14.40 | 123.73 | 44.99 |
SO43877_4 | 4ECF-42F2-A7 | PO11919119101 | 100 | 286 | 344 | 73 | 1 | 2021-11-27 | 6119.98 | 153.00 | 2021-11-15 | 3 | 1912.15 | 1 | 6119.98 | 4 | SO43877 | 2021-11-22 | 489.60 | 5736.46 | 2039.99 |
SO47687_42 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 221 | 203 | 4 | 2023-01-27 | 60.56 | 1.51 | 2023-01-15 | 3 | 13.88 | 1 | 60.56 | 42 | SO47687 | 2023-01-22 | 4.84 | 41.63 | 20.19 |
Generated 2024-11-14 23:00:05.066 UTC