[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2230 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47678_1 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 469 | 265 | 7 | 2022-12-04 | 91.18 | 2.28 | 2022-11-22 | 4 | 15.67 | 1 | 91.18 | 1 | SO47678 | 2022-11-29 | 7.29 | 62.68 | 22.79 |
SO51116_22 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 287 | 480 | 6 | 2023-09-03 | 202.33 | 5.06 | 2023-08-22 | 1 | 204.63 | 1 | 202.33 | 22 | SO51116 | 2023-08-29 | 16.19 | 204.63 | 202.33 |
SO58976_3 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 390 | 216 | 2 | 2024-02-03 | 672.29 | 16.81 | 2024-01-22 | 1 | 713.08 | 1 | 672.29 | 3 | SO58976 | 2024-01-29 | 53.78 | 713.08 | 672.29 |
SO43867_5 | 061F-4449-BE | PO14471123403 | 100 | 286 | 346 | 145 | 1 | 2021-10-04 | 4079.99 | 102.00 | 2021-09-22 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO43867 | 2021-09-29 | 326.40 | 3824.31 | 2039.99 |
SO47678_2 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 233 | 265 | 7 | 2022-12-04 | 86.52 | 2.16 | 2022-11-22 | 3 | 29.08 | 1 | 86.52 | 2 | SO47678 | 2022-11-29 | 6.92 | 87.24 | 28.84 |
SO51116_23 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 547 | 480 | 6 | 2023-09-03 | 145.78 | 3.64 | 2023-08-22 | 3 | 35.96 | 1 | 145.78 | 23 | SO51116 | 2023-08-29 | 11.66 | 107.88 | 48.59 |
SO58976_4 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 605 | 216 | 2 | 2024-02-03 | 971.98 | 24.30 | 2024-01-22 | 3 | 343.65 | 1 | 971.98 | 4 | SO58976 | 2024-01-29 | 77.76 | 1030.95 | 323.99 |
SO43867_6 | 061F-4449-BE | PO14471123403 | 100 | 286 | 218 | 145 | 1 | 2021-10-04 | 11.40 | 0.29 | 2021-09-22 | 2 | 3.40 | 1 | 11.40 | 6 | SO43867 | 2021-09-29 | 0.91 | 6.79 | 5.70 |
SO47678_3 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 360 | 265 | 7 | 2022-12-04 | 2458.92 | 61.47 | 2022-11-22 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO47678 | 2022-11-29 | 196.71 | 2211.62 | 1229.46 |
SO51117_1 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 547 | 41 | 4 | 2023-09-03 | 194.38 | 4.86 | 2023-08-22 | 4 | 35.96 | 1 | 194.38 | 1 | SO51117 | 2023-08-29 | 15.55 | 143.84 | 48.59 |
SO58976_5 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 547 | 216 | 2 | 2024-02-03 | 97.19 | 2.43 | 2024-01-22 | 2 | 35.96 | 1 | 97.19 | 5 | SO58976 | 2024-01-29 | 7.78 | 71.92 | 48.59 |
SO43867_7 | 061F-4449-BE | PO14471123403 | 100 | 286 | 229 | 145 | 1 | 2021-10-04 | 86.52 | 2.16 | 2021-09-22 | 3 | 31.72 | 1 | 86.52 | 7 | SO43867 | 2021-09-29 | 6.92 | 95.17 | 28.84 |
SO47678_4 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 224 | 265 | 7 | 2022-12-04 | 5.19 | 0.13 | 2022-11-22 | 1 | 5.23 | 1 | 5.19 | 4 | SO47678 | 2022-11-29 | 0.41 | 5.23 | 5.19 |
SO51117_2 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 484 | 41 | 4 | 2023-09-03 | 28.62 | 0.72 | 2023-08-22 | 6 | 2.97 | 1 | 28.62 | 2 | SO51117 | 2023-08-29 | 2.29 | 17.84 | 4.77 |
SO58976_6 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 606 | 216 | 2 | 2024-02-03 | 647.99 | 16.20 | 2024-01-22 | 2 | 343.65 | 1 | 647.99 | 6 | SO58976 | 2024-01-29 | 51.84 | 687.30 | 323.99 |
SO43867_8 | 061F-4449-BE | PO14471123403 | 100 | 286 | 344 | 145 | 1 | 2021-10-04 | 8159.98 | 204.00 | 2021-09-22 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO43867 | 2021-09-29 | 652.80 | 7648.62 | 2039.99 |
SO47678_5 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 358 | 265 | 7 | 2022-12-04 | 3688.38 | 92.21 | 2022-11-22 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO47678 | 2022-11-29 | 295.07 | 3317.43 | 1229.46 |
SO51117_3 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 471 | 41 | 4 | 2023-09-03 | 190.50 | 4.76 | 2023-08-22 | 5 | 23.75 | 1 | 190.50 | 3 | SO51117 | 2023-08-29 | 15.24 | 118.75 | 38.10 |
SO58976_7 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 471 | 216 | 2 | 2024-02-03 | 228.60 | 5.72 | 2024-01-22 | 6 | 23.75 | 1 | 228.60 | 7 | SO58976 | 2024-01-29 | 18.29 | 142.49 | 38.10 |
SO43867_9 | 061F-4449-BE | PO14471123403 | 100 | 286 | 220 | 145 | 1 | 2021-10-04 | 40.37 | 1.01 | 2021-09-22 | 2 | 12.03 | 1 | 40.37 | 9 | SO43867 | 2021-09-29 | 3.23 | 24.06 | 20.19 |
SO47678_6 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 468 | 265 | 7 | 2022-12-04 | 113.97 | 2.85 | 2022-11-22 | 5 | 15.67 | 1 | 113.97 | 6 | SO47678 | 2022-11-29 | 9.12 | 78.35 | 22.79 |
SO51117_4 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 465 | 41 | 4 | 2023-09-03 | 29.39 | 0.73 | 2023-08-22 | 2 | 9.16 | 1 | 29.39 | 4 | SO51117 | 2023-08-29 | 2.35 | 18.32 | 14.69 |
SO58976_8 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 484 | 216 | 2 | 2024-02-03 | 4.77 | 0.12 | 2024-01-22 | 1 | 2.97 | 1 | 4.77 | 8 | SO58976 | 2024-01-29 | 0.38 | 2.97 | 4.77 |
SO43867_10 | 061F-4449-BE | PO14471123403 | 100 | 286 | 212 | 145 | 1 | 2021-10-04 | 20.19 | 0.50 | 2021-09-22 | 1 | 12.03 | 1 | 20.19 | 10 | SO43867 | 2021-09-29 | 1.61 | 12.03 | 20.19 |
SO47678_7 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 458 | 265 | 7 | 2022-12-04 | 269.96 | 6.75 | 2022-11-22 | 6 | 30.93 | 1 | 269.96 | 7 | SO47678 | 2022-11-29 | 21.60 | 185.60 | 44.99 |
SO51117_5 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 546 | 41 | 4 | 2023-09-03 | 111.76 | 2.79 | 2023-08-22 | 3 | 27.57 | 1 | 111.76 | 5 | SO51117 | 2023-08-29 | 8.94 | 82.70 | 37.25 |
SO58976_9 | 3BF9-484F-A1 | PO20213146485 | 100 | 283 | 483 | 216 | 2 | 2024-02-03 | 360.00 | 9.00 | 2024-01-22 | 5 | 44.88 | 1 | 360.00 | 9 | SO58976 | 2024-01-29 | 28.80 | 224.40 | 72.00 |
SO43867_11 | 061F-4449-BE | PO14471123403 | 100 | 286 | 351 | 145 | 1 | 2021-10-04 | 4049.99 | 101.25 | 2021-09-22 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO43867 | 2021-09-29 | 324.00 | 3796.19 | 2024.99 |
SO47678_8 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 470 | 265 | 7 | 2022-12-04 | 205.15 | 5.13 | 2022-11-22 | 9 | 15.67 | 1 | 205.15 | 8 | SO47678 | 2022-11-29 | 16.41 | 141.04 | 22.79 |
SO51117_6 | 1B03-4F11-83 | PO10237188382 | 100 | 287 | 605 | 41 | 4 | 2023-09-03 | 971.98 | 24.30 | 2023-08-22 | 3 | 343.65 | 1 | 971.98 | 6 | SO51117 | 2023-08-29 | 77.76 | 1030.95 | 323.99 |
Generated 2024-09-21 03:10:01.884 UTC