[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SKIP 0 < SKIP 32 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47659_7 | 8639-4639-AA | PO19314173599 | 100 | 283 | 325 | 622 | 3 | 2022-12-03 | 469.79 | 11.74 | 2022-11-21 | 1 | 486.71 | 1 | 469.79 | 7 | SO47659 | 2022-11-28 | 37.58 | 486.71 | 469.79 | |||
SO51105_9 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 482 | 2 | 670 | 3 | 1.46 | 2023-09-02 | 73.00 | 1.79 | 2023-08-21 | 14 | 3.36 | 1 | 71.54 | 9 | SO51105 | 2023-08-28 | 5.72 | 47.07 | 5.21 | 0.02 |
SO58970_9 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 380 | 579 | 3 | 2024-02-02 | 2932.02 | 73.30 | 2024-01-21 | 2 | 1554.95 | 1 | 2932.02 | 9 | SO58970 | 2024-01-28 | 234.56 | 3109.90 | 1466.01 | |||
SO43675_1 | 5069-4470-BE | PO12412186464 | 100 | 283 | 324 | 670 | 3 | 2021-09-02 | 1677.84 | 41.95 | 2021-08-21 | 4 | 413.15 | 1 | 1677.84 | 1 | SO43675 | 2021-08-28 | 134.23 | 1652.59 | 419.46 | |||
SO47659_8 | 8639-4639-AA | PO19314173599 | 100 | 283 | 333 | 622 | 3 | 2022-12-03 | 939.59 | 23.49 | 2022-11-21 | 2 | 486.71 | 1 | 939.59 | 8 | SO47659 | 2022-11-28 | 75.17 | 973.41 | 469.79 | |||
SO51105_10 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 546 | 670 | 3 | 2023-09-02 | 111.76 | 2.79 | 2023-08-21 | 3 | 27.57 | 1 | 111.76 | 10 | SO51105 | 2023-08-28 | 8.94 | 82.70 | 37.25 | |||
SO58970_10 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 386 | 579 | 3 | 2024-02-02 | 3361.47 | 84.04 | 2024-01-21 | 5 | 713.08 | 1 | 3361.47 | 10 | SO58970 | 2024-01-28 | 268.92 | 3565.40 | 672.29 | |||
SO43675_2 | 5069-4470-BE | PO12412186464 | 100 | 283 | 220 | 670 | 3 | 2021-09-02 | 100.93 | 2.52 | 2021-08-21 | 5 | 12.03 | 1 | 100.93 | 2 | SO43675 | 2021-08-28 | 8.07 | 60.14 | 20.19 | |||
SO47659_9 | 8639-4639-AA | PO19314173599 | 100 | 283 | 323 | 622 | 3 | 2022-12-03 | 1409.38 | 35.23 | 2022-11-21 | 3 | 486.71 | 1 | 1409.38 | 9 | SO47659 | 2022-11-28 | 112.75 | 1460.12 | 469.79 | |||
SO51105_11 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 390 | 670 | 3 | 2023-09-02 | 2016.88 | 50.42 | 2023-08-21 | 3 | 713.08 | 1 | 2016.88 | 11 | SO51105 | 2023-08-28 | 161.35 | 2139.24 | 672.29 | |||
SO58970_11 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 434 | 579 | 3 | 2024-02-02 | 713.80 | 17.84 | 2024-01-21 | 2 | 360.94 | 1 | 713.80 | 11 | SO58970 | 2024-01-28 | 57.10 | 721.89 | 356.90 | |||
SO43675_3 | 5069-4470-BE | PO12412186464 | 100 | 283 | 285 | 670 | 3 | 2021-09-02 | 357.16 | 8.93 | 2021-08-21 | 2 | 176.20 | 1 | 357.16 | 3 | SO43675 | 2021-08-28 | 28.57 | 352.40 | 178.58 | |||
SO47674_1 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 327 | 643 | 3 | 2022-12-03 | 939.59 | 23.49 | 2022-11-21 | 2 | 486.71 | 1 | 939.59 | 1 | SO47674 | 2022-11-28 | 75.17 | 973.41 | 469.79 | |||
SO51105_12 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 481 | 670 | 3 | 2023-09-02 | 26.97 | 0.67 | 2023-08-21 | 5 | 3.36 | 1 | 26.97 | 12 | SO51105 | 2023-08-28 | 2.16 | 16.81 | 5.39 | |||
SO58970_12 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 582 | 579 | 3 | 2024-02-02 | 5102.97 | 127.57 | 2024-01-21 | 5 | 1082.51 | 1 | 5102.97 | 12 | SO58970 | 2024-01-28 | 408.24 | 5412.55 | 1020.59 | |||
SO43675_4 | 5069-4470-BE | PO12412186464 | 100 | 283 | 215 | 670 | 3 | 2021-09-02 | 20.19 | 0.50 | 2021-08-21 | 1 | 12.03 | 1 | 20.19 | 4 | SO43675 | 2021-08-28 | 1.61 | 12.03 | 20.19 | |||
SO47674_2 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 323 | 643 | 3 | 2022-12-03 | 2348.97 | 58.72 | 2022-11-21 | 5 | 486.71 | 1 | 2348.97 | 2 | SO47674 | 2022-11-28 | 187.92 | 2433.53 | 469.79 | |||
SO51105_13 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 545 | 670 | 3 | 2023-09-02 | 170.06 | 4.25 | 2023-08-21 | 7 | 17.98 | 1 | 170.06 | 13 | SO51105 | 2023-08-28 | 13.60 | 125.84 | 24.29 | |||
SO58970_13 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 388 | 579 | 3 | 2024-02-02 | 672.29 | 16.81 | 2024-01-21 | 1 | 713.08 | 1 | 672.29 | 13 | SO58970 | 2024-01-28 | 53.78 | 713.08 | 672.29 | |||
SO43675_5 | 5069-4470-BE | PO12412186464 | 100 | 283 | 326 | 670 | 3 | 2021-09-02 | 838.92 | 20.97 | 2021-08-21 | 2 | 413.15 | 1 | 838.92 | 5 | SO43675 | 2021-08-28 | 67.11 | 826.29 | 419.46 | |||
SO47674_3 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 422 | 643 | 3 | 2022-12-03 | 202.62 | 5.07 | 2022-11-21 | 3 | 49.98 | 1 | 202.62 | 3 | SO47674 | 2022-11-28 | 16.21 | 149.94 | 67.54 | |||
SO51105_14 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 604 | 670 | 3 | 2023-09-02 | 1295.98 | 32.40 | 2023-08-21 | 4 | 343.65 | 1 | 1295.98 | 14 | SO51105 | 2023-08-28 | 103.68 | 1374.60 | 323.99 | |||
SO58970_14 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 547 | 579 | 3 | 2024-02-02 | 97.19 | 2.43 | 2024-01-21 | 2 | 35.96 | 1 | 97.19 | 14 | SO58970 | 2024-01-28 | 7.78 | 71.92 | 48.59 | |||
SO43675_6 | 5069-4470-BE | PO12412186464 | 100 | 283 | 319 | 670 | 3 | 2021-09-02 | 1749.59 | 43.74 | 2021-08-21 | 2 | 884.71 | 1 | 1749.59 | 6 | SO43675 | 2021-08-28 | 139.97 | 1769.42 | 874.79 | |||
SO47674_4 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 333 | 643 | 3 | 2022-12-03 | 2818.76 | 70.47 | 2022-11-21 | 6 | 486.71 | 1 | 2818.76 | 4 | SO47674 | 2022-11-28 | 225.50 | 2920.24 | 469.79 | |||
SO51105_15 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 376 | 670 | 3 | 2023-09-02 | 4398.03 | 109.95 | 2023-08-21 | 3 | 1554.95 | 1 | 4398.03 | 15 | SO51105 | 2023-08-28 | 351.84 | 4664.84 | 1466.01 | |||
SO58970_15 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 374 | 579 | 3 | 2024-02-02 | 1466.01 | 36.65 | 2024-01-21 | 1 | 1554.95 | 1 | 1466.01 | 15 | SO58970 | 2024-01-28 | 117.28 | 1554.95 | 1466.01 | |||
SO43675_7 | 5069-4470-BE | PO12412186464 | 100 | 283 | 223 | 670 | 3 | 2021-09-02 | 10.37 | 0.26 | 2021-08-21 | 2 | 5.71 | 1 | 10.37 | 7 | SO43675 | 2021-08-28 | 0.83 | 11.41 | 5.19 | |||
SO47674_5 | D724-43A2-B7 | PO13949139803 | 100 | 281 | 325 | 643 | 3 | 2022-12-03 | 939.59 | 23.49 | 2022-11-21 | 2 | 486.71 | 1 | 939.59 | 5 | SO47674 | 2022-11-28 | 75.17 | 973.41 | 469.79 | |||
SO51105_16 | 1785-4FFE-9D | PO12412192932 | 100 | 281 | 581 | 670 | 3 | 2023-09-02 | 7144.16 | 178.60 | 2023-08-21 | 7 | 1082.51 | 1 | 7144.16 | 16 | SO51105 | 2023-08-28 | 571.53 | 7577.57 | 1020.59 | |||
SO58970_16 | 7853-4F60-87 | PO1624182044 | 100 | 281 | 584 | 579 | 3 | 2024-02-02 | 647.99 | 16.20 | 2024-01-21 | 2 | 343.65 | 1 | 647.99 | 16 | SO58970 | 2024-01-28 | 51.84 | 687.30 | 323.99 |
Generated 2024-09-20 06:54:24.199 UTC