[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > < SKIP 5551 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47450_51 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 375 | 54 | 2 | 2022-11-04 | 2617.88 | 65.45 | 2022-10-23 | 2 | 1320.68 | 1 | 2617.88 | 51 | SO47450 | 2022-10-30 | 209.43 | 2641.37 | 1308.94 |
SO47450_52 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 447 | 54 | 2 | 2022-11-04 | 60.00 | 1.50 | 2022-10-23 | 4 | 10.31 | 1 | 60.00 | 52 | SO47450 | 2022-10-30 | 4.80 | 41.25 | 15.00 |
SO47450_53 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 457 | 54 | 2 | 2022-11-04 | 269.96 | 6.75 | 2022-10-23 | 6 | 30.93 | 1 | 269.96 | 53 | SO47450 | 2022-10-30 | 21.60 | 185.60 | 44.99 |
SO47450_54 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 273 | 54 | 2 | 2022-11-04 | 202.33 | 5.06 | 2022-10-23 | 1 | 187.16 | 1 | 202.33 | 54 | SO47450 | 2022-10-30 | 16.19 | 187.16 | 202.33 |
SO47450_55 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 453 | 54 | 2 | 2022-11-04 | 143.98 | 3.60 | 2022-10-23 | 4 | 24.75 | 1 | 143.98 | 55 | SO47450 | 2022-10-30 | 11.52 | 98.98 | 35.99 |
SO47450_56 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 464 | 54 | 2 | 2022-11-04 | 14.13 | 0.35 | 2022-10-23 | 1 | 9.71 | 1 | 14.13 | 56 | SO47450 | 2022-10-30 | 1.13 | 9.71 | 14.13 |
SO47453_1 | 9736-49EE-BD | PO9019173488 | 100 | 281 | 410 | 576 | 2 | 2022-11-04 | 36.45 | 0.91 | 2022-10-23 | 1 | 26.97 | 1 | 36.45 | 1 | SO47453 | 2022-10-30 | 2.92 | 26.97 | 36.45 |
SO47453_2 | 9736-49EE-BD | PO9019173488 | 100 | 281 | 289 | 576 | 2 | 2022-11-04 | 2232.82 | 55.82 | 2022-10-23 | 3 | 660.91 | 1 | 2232.82 | 2 | SO47453 | 2022-10-30 | 178.63 | 1982.74 | 744.27 |
SO57141_23 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 386 | 666 | 2 | 2024-01-04 | 672.29 | 16.81 | 2023-12-23 | 1 | 713.08 | 1 | 672.29 | 23 | SO57141 | 2023-12-30 | 53.78 | 713.08 | 672.29 |
SO57141_24 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 584 | 666 | 2 | 2024-01-04 | 971.98 | 24.30 | 2023-12-23 | 3 | 343.65 | 1 | 971.98 | 24 | SO57141 | 2023-12-30 | 77.76 | 1030.95 | 323.99 |
SO57141_25 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 547 | 666 | 2 | 2024-01-04 | 97.19 | 2.43 | 2023-12-23 | 2 | 35.96 | 1 | 97.19 | 25 | SO57141 | 2023-12-30 | 7.78 | 71.92 | 48.59 |
SO57146_1 | C94B-4FD3-BB | PO6264144670 | 100 | 283 | 290 | 593 | 2 | 2024-01-04 | 818.70 | 20.47 | 2023-12-23 | 1 | 747.20 | 1 | 818.70 | 1 | SO57146 | 2023-12-30 | 65.50 | 747.20 | 818.70 |
SO57164_1 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 481 | 540 | 2 | 2024-01-04 | 21.58 | 0.54 | 2023-12-23 | 4 | 3.36 | 1 | 21.58 | 1 | SO57164 | 2023-12-30 | 1.73 | 13.45 | 5.39 |
SO57164_2 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 545 | 540 | 2 | 2024-01-04 | 97.18 | 2.43 | 2023-12-23 | 4 | 17.98 | 1 | 97.18 | 2 | SO57164 | 2023-12-30 | 7.77 | 71.91 | 24.29 |
SO57164_3 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 390 | 540 | 2 | 2024-01-04 | 672.29 | 16.81 | 2023-12-23 | 1 | 713.08 | 1 | 672.29 | 3 | SO57164 | 2023-12-30 | 53.78 | 713.08 | 672.29 |
SO57164_4 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 583 | 540 | 2 | 2024-01-04 | 7144.16 | 178.60 | 2023-12-23 | 7 | 1082.51 | 1 | 7144.16 | 4 | SO57164 | 2023-12-30 | 571.53 | 7577.57 | 1020.59 |
SO57164_5 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 547 | 540 | 2 | 2024-01-04 | 242.97 | 6.07 | 2023-12-23 | 5 | 35.96 | 1 | 242.97 | 5 | SO57164 | 2023-12-30 | 19.44 | 179.80 | 48.59 |
SO57164_6 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 482 | 540 | 2 | 2024-01-04 | 37.76 | 0.94 | 2023-12-23 | 7 | 3.36 | 1 | 37.76 | 6 | SO57164 | 2023-12-30 | 3.02 | 23.54 | 5.39 |
SO57164_7 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 605 | 540 | 2 | 2024-01-04 | 647.99 | 16.20 | 2023-12-23 | 2 | 343.65 | 1 | 647.99 | 7 | SO57164 | 2023-12-30 | 51.84 | 687.30 | 323.99 |
SO57164_8 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 483 | 540 | 2 | 2024-01-04 | 72.00 | 1.80 | 2023-12-23 | 1 | 44.88 | 1 | 72.00 | 8 | SO57164 | 2023-12-30 | 5.76 | 44.88 | 72.00 |
SO57164_9 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 606 | 540 | 2 | 2024-01-04 | 1943.96 | 48.60 | 2023-12-23 | 6 | 343.65 | 1 | 1943.96 | 9 | SO57164 | 2023-12-30 | 155.52 | 2061.90 | 323.99 |
SO57164_10 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 546 | 540 | 2 | 2024-01-04 | 111.76 | 2.79 | 2023-12-23 | 3 | 27.57 | 1 | 111.76 | 10 | SO57164 | 2023-12-30 | 8.94 | 82.70 | 37.25 |
SO57164_11 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 580 | 540 | 2 | 2024-01-04 | 4082.38 | 102.06 | 2023-12-23 | 4 | 1082.51 | 1 | 4082.38 | 11 | SO57164 | 2023-12-30 | 326.59 | 4330.04 | 1020.59 |
SO57164_12 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 490 | 540 | 2 | 2024-01-04 | 226.76 | 5.67 | 2023-12-23 | 7 | 41.57 | 1 | 226.76 | 12 | SO57164 | 2023-12-30 | 18.14 | 291.01 | 32.39 |
SO57164_13 | CCA0-46EF-93 | PO1769132448 | 100 | 283 | 484 | 540 | 2 | 2024-01-04 | 9.54 | 0.24 | 2023-12-23 | 2 | 2.97 | 1 | 9.54 | 13 | SO57164 | 2023-12-30 | 0.76 | 5.95 | 4.77 |
SO58903_1 | A9DB-4EDD-B7 | PO19894119597 | 100 | 283 | 494 | 557 | 2 | 2024-02-03 | 1807.04 | 45.18 | 2024-01-22 | 3 | 601.74 | 1 | 1807.04 | 1 | SO58903 | 2024-01-29 | 144.56 | 1805.23 | 602.35 |
SO58903_2 | A9DB-4EDD-B7 | PO19894119597 | 100 | 283 | 522 | 557 | 2 | 2024-02-03 | 93.94 | 2.35 | 2024-01-22 | 4 | 17.38 | 1 | 93.94 | 2 | SO58903 | 2024-01-29 | 7.51 | 69.51 | 23.48 |
SO58903_3 | A9DB-4EDD-B7 | PO19894119597 | 100 | 283 | 548 | 557 | 2 | 2024-02-03 | 145.78 | 3.64 | 2024-01-22 | 3 | 35.96 | 1 | 145.78 | 3 | SO58903 | 2024-01-29 | 11.66 | 107.88 | 48.59 |
SO58903_4 | A9DB-4EDD-B7 | PO19894119597 | 100 | 283 | 579 | 557 | 2 | 2024-02-03 | 1457.82 | 36.45 | 2024-01-22 | 2 | 755.15 | 1 | 1457.82 | 4 | SO58903 | 2024-01-29 | 116.63 | 1510.30 | 728.91 |
SO58903_5 | A9DB-4EDD-B7 | PO19894119597 | 100 | 283 | 554 | 557 | 2 | 2024-02-03 | 109.88 | 2.75 | 2024-01-22 | 2 | 40.66 | 1 | 109.88 | 5 | SO58903 | 2024-01-29 | 8.79 | 81.31 | 54.94 |
Generated 2024-09-21 03:07:18.166 UTC