[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 < SKIP 4639 > < TAKE 60 >
60 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57074_7 | FF65-4261-97 | PO9918191120 | 100 | 285 | 503 | 260 | 5 | 2024-02-26 | 200.05 | 5.00 | 2024-02-14 | 1 | 199.85 | 1 | 200.05 | 7 | SO57074 | 2024-02-21 | 16.00 | 199.85 | 200.05 |
SO57074_8 | FF65-4261-97 | PO9918191120 | 100 | 285 | 569 | 260 | 5 | 2024-02-26 | 890.82 | 22.27 | 2024-02-14 | 2 | 461.44 | 1 | 890.82 | 8 | SO57074 | 2024-02-21 | 71.27 | 922.89 | 445.41 |
SO57074_9 | FF65-4261-97 | PO9918191120 | 100 | 285 | 507 | 260 | 5 | 2024-02-26 | 400.10 | 10.00 | 2024-02-14 | 2 | 199.85 | 1 | 400.10 | 9 | SO57074 | 2024-02-21 | 32.01 | 399.70 | 200.05 |
SO57074_10 | FF65-4261-97 | PO9918191120 | 100 | 285 | 500 | 260 | 5 | 2024-02-26 | 602.35 | 15.06 | 2024-02-14 | 1 | 601.74 | 1 | 602.35 | 10 | SO57074 | 2024-02-21 | 48.19 | 601.74 | 602.35 |
SO57074_11 | FF65-4261-97 | PO9918191120 | 100 | 285 | 492 | 260 | 5 | 2024-02-26 | 3011.73 | 75.29 | 2024-02-14 | 5 | 601.74 | 1 | 3011.73 | 11 | SO57074 | 2024-02-21 | 240.94 | 3008.72 | 602.35 |
SO57074_12 | FF65-4261-97 | PO9918191120 | 100 | 285 | 506 | 260 | 5 | 2024-02-26 | 200.05 | 5.00 | 2024-02-14 | 1 | 199.85 | 1 | 200.05 | 12 | SO57074 | 2024-02-21 | 16.00 | 199.85 | 200.05 |
SO57074_13 | FF65-4261-97 | PO9918191120 | 100 | 285 | 499 | 260 | 5 | 2024-02-26 | 1204.69 | 30.12 | 2024-02-14 | 2 | 601.74 | 1 | 1204.69 | 13 | SO57074 | 2024-02-21 | 96.38 | 1203.49 | 602.35 |
SO57074_14 | FF65-4261-97 | PO9918191120 | 100 | 285 | 560 | 260 | 5 | 2024-02-26 | 3644.55 | 91.11 | 2024-02-14 | 5 | 755.15 | 1 | 3644.55 | 14 | SO57074 | 2024-02-21 | 291.56 | 3775.75 | 728.91 |
SO57074_15 | FF65-4261-97 | PO9918191120 | 100 | 285 | 548 | 260 | 5 | 2024-02-26 | 48.59 | 1.21 | 2024-02-14 | 1 | 35.96 | 1 | 48.59 | 15 | SO57074 | 2024-02-21 | 3.89 | 35.96 | 48.59 |
SO57074_16 | FF65-4261-97 | PO9918191120 | 100 | 285 | 568 | 260 | 5 | 2024-02-26 | 1336.23 | 33.41 | 2024-02-14 | 3 | 461.44 | 1 | 1336.23 | 16 | SO57074 | 2024-02-21 | 106.90 | 1384.33 | 445.41 |
SO57074_17 | FF65-4261-97 | PO9918191120 | 100 | 285 | 564 | 260 | 5 | 2024-02-26 | 4291.33 | 107.28 | 2024-02-14 | 3 | 1481.94 | 1 | 4291.33 | 17 | SO57074 | 2024-02-21 | 343.31 | 4445.81 | 1430.44 |
SO57074_18 | FF65-4261-97 | PO9918191120 | 100 | 285 | 579 | 260 | 5 | 2024-02-26 | 2186.73 | 54.67 | 2024-02-14 | 3 | 755.15 | 1 | 2186.73 | 18 | SO57074 | 2024-02-21 | 174.94 | 2265.45 | 728.91 |
SO57074_19 | FF65-4261-97 | PO9918191120 | 100 | 285 | 498 | 260 | 5 | 2024-02-26 | 602.35 | 15.06 | 2024-02-14 | 1 | 601.74 | 1 | 602.35 | 19 | SO57074 | 2024-02-21 | 48.19 | 601.74 | 602.35 |
SO57081_1 | 2D14-4C3F-AB | PO1247134214 | 100 | 285 | 592 | 296 | 5 | 2024-02-26 | 677.99 | 16.95 | 2024-02-14 | 2 | 308.22 | 1 | 677.99 | 1 | SO57081 | 2024-02-21 | 54.24 | 616.44 | 338.99 |
SO57081_2 | 2D14-4C3F-AB | PO1247134214 | 100 | 285 | 591 | 296 | 5 | 2024-02-26 | 677.99 | 16.95 | 2024-02-14 | 2 | 308.22 | 1 | 677.99 | 2 | SO57081 | 2024-02-21 | 54.24 | 616.44 | 338.99 |
SO57081_3 | 2D14-4C3F-AB | PO1247134214 | 100 | 285 | 556 | 296 | 5 | 2024-02-26 | 105.29 | 2.63 | 2024-02-14 | 1 | 77.92 | 1 | 105.29 | 3 | SO57081 | 2024-02-21 | 8.42 | 77.92 | 105.29 |
SO57081_4 | 2D14-4C3F-AB | PO1247134214 | 100 | 285 | 476 | 296 | 5 | 2024-02-26 | 83.99 | 2.10 | 2024-02-14 | 2 | 26.18 | 1 | 83.99 | 4 | SO57081 | 2024-02-21 | 6.72 | 52.35 | 41.99 |
SO57081_5 | 2D14-4C3F-AB | PO1247134214 | 100 | 285 | 594 | 296 | 5 | 2024-02-26 | 1355.98 | 33.90 | 2024-02-14 | 4 | 308.22 | 1 | 1355.98 | 5 | SO57081 | 2024-02-21 | 108.48 | 1232.87 | 338.99 |
SO57088_1 | EA31-4951-8A | PO2842199218 | 100 | 285 | 386 | 700 | 5 | 2024-02-26 | 672.29 | 16.81 | 2024-02-14 | 1 | 713.08 | 1 | 672.29 | 1 | SO57088 | 2024-02-21 | 53.78 | 713.08 | 672.29 |
SO57088_2 | EA31-4951-8A | PO2842199218 | 100 | 285 | 217 | 700 | 5 | 2024-02-26 | 104.97 | 2.62 | 2024-02-14 | 5 | 13.09 | 1 | 104.97 | 2 | SO57088 | 2024-02-21 | 8.40 | 65.43 | 20.99 |
SO57088_3 | EA31-4951-8A | PO2842199218 | 100 | 285 | 490 | 700 | 5 | 2024-02-26 | 97.18 | 2.43 | 2024-02-14 | 3 | 41.57 | 1 | 97.18 | 3 | SO57088 | 2024-02-21 | 7.77 | 124.72 | 32.39 |
SO57088_4 | EA31-4951-8A | PO2842199218 | 100 | 285 | 545 | 700 | 5 | 2024-02-26 | 24.29 | 0.61 | 2024-02-14 | 1 | 17.98 | 1 | 24.29 | 4 | SO57088 | 2024-02-21 | 1.94 | 17.98 | 24.29 |
SO57088_5 | EA31-4951-8A | PO2842199218 | 100 | 285 | 484 | 700 | 5 | 2024-02-26 | 33.39 | 0.83 | 2024-02-14 | 7 | 2.97 | 1 | 33.39 | 5 | SO57088 | 2024-02-21 | 2.67 | 20.81 | 4.77 |
SO57088_6 | EA31-4951-8A | PO2842199218 | 100 | 285 | 378 | 700 | 5 | 2024-02-26 | 1466.01 | 36.65 | 2024-02-14 | 1 | 1554.95 | 1 | 1466.01 | 6 | SO57088 | 2024-02-21 | 117.28 | 1554.95 | 1466.01 |
SO57088_7 | EA31-4951-8A | PO2842199218 | 100 | 285 | 483 | 700 | 5 | 2024-02-26 | 288.00 | 7.20 | 2024-02-14 | 4 | 44.88 | 1 | 288.00 | 7 | SO57088 | 2024-02-21 | 23.04 | 179.52 | 72.00 |
SO57088_8 | EA31-4951-8A | PO2842199218 | 100 | 285 | 434 | 700 | 5 | 2024-02-26 | 1427.59 | 35.69 | 2024-02-14 | 4 | 360.94 | 1 | 1427.59 | 8 | SO57088 | 2024-02-21 | 114.21 | 1443.77 | 356.90 |
SO57088_9 | EA31-4951-8A | PO2842199218 | 100 | 285 | 465 | 700 | 5 | 2024-02-26 | 73.47 | 1.84 | 2024-02-14 | 5 | 9.16 | 1 | 73.47 | 9 | SO57088 | 2024-02-21 | 5.88 | 45.80 | 14.69 |
SO57088_10 | EA31-4951-8A | PO2842199218 | 100 | 285 | 463 | 700 | 5 | 2024-02-26 | 88.16 | 2.20 | 2024-02-14 | 6 | 9.16 | 1 | 88.16 | 10 | SO57088 | 2024-02-21 | 7.05 | 54.96 | 14.69 |
SO57088_11 | EA31-4951-8A | PO2842199218 | 100 | 285 | 606 | 700 | 5 | 2024-02-26 | 971.98 | 24.30 | 2024-02-14 | 3 | 343.65 | 1 | 971.98 | 11 | SO57088 | 2024-02-21 | 77.76 | 1030.95 | 323.99 |
SO57088_12 | EA31-4951-8A | PO2842199218 | 100 | 285 | 372 | 700 | 5 | 2024-02-26 | 4398.03 | 109.95 | 2024-02-14 | 3 | 1554.95 | 1 | 4398.03 | 12 | SO57088 | 2024-02-21 | 351.84 | 4664.84 | 1466.01 |
SO57088_13 | EA31-4951-8A | PO2842199218 | 100 | 285 | 477 | 700 | 5 | 2024-02-26 | 8.98 | 0.22 | 2024-02-14 | 3 | 1.87 | 1 | 8.98 | 13 | SO57088 | 2024-02-21 | 0.72 | 5.60 | 2.99 |
SO57088_14 | EA31-4951-8A | PO2842199218 | 100 | 285 | 581 | 700 | 5 | 2024-02-26 | 1020.59 | 25.51 | 2024-02-14 | 1 | 1082.51 | 1 | 1020.59 | 14 | SO57088 | 2024-02-21 | 81.65 | 1082.51 | 1020.59 |
SO57088_15 | EA31-4951-8A | PO2842199218 | 100 | 285 | 580 | 700 | 5 | 2024-02-26 | 1020.59 | 25.51 | 2024-02-14 | 1 | 1082.51 | 1 | 1020.59 | 15 | SO57088 | 2024-02-21 | 81.65 | 1082.51 | 1020.59 |
SO69394_2 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 384 | 206 | 5 | 2024-08-26 | 672.29 | 16.81 | 2024-08-14 | 1 | 713.08 | 1 | 672.29 | 2 | SO69394 | 2024-08-21 | 53.78 | 713.08 | 672.29 |
SO69394_3 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 386 | 206 | 5 | 2024-08-26 | 672.29 | 16.81 | 2024-08-14 | 1 | 713.08 | 1 | 672.29 | 3 | SO69394 | 2024-08-21 | 53.78 | 713.08 | 672.29 |
SO69394_4 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 287 | 206 | 5 | 2024-08-26 | 202.33 | 5.06 | 2024-08-14 | 1 | 204.63 | 1 | 202.33 | 4 | SO69394 | 2024-08-21 | 16.19 | 204.63 | 202.33 |
SO69394_5 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 482 | 206 | 5 | 2024-08-26 | 37.76 | 0.94 | 2024-08-14 | 7 | 3.36 | 1 | 37.76 | 5 | SO69394 | 2024-08-21 | 3.02 | 23.54 | 5.39 |
SO69394_6 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 581 | 206 | 5 | 2024-08-26 | 2041.19 | 51.03 | 2024-08-14 | 2 | 1082.51 | 1 | 2041.19 | 6 | SO69394 | 2024-08-21 | 163.30 | 2165.02 | 1020.59 |
SO69394_7 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 388 | 206 | 5 | 2024-08-26 | 1344.59 | 33.61 | 2024-08-14 | 2 | 713.08 | 1 | 1344.59 | 7 | SO69394 | 2024-08-21 | 107.57 | 1426.16 | 672.29 |
SO69394_8 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 584 | 206 | 5 | 2024-08-26 | 323.99 | 8.10 | 2024-08-14 | 1 | 343.65 | 1 | 323.99 | 8 | SO69394 | 2024-08-21 | 25.92 | 343.65 | 323.99 |
SO69394_9 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 390 | 206 | 5 | 2024-08-26 | 672.29 | 16.81 | 2024-08-14 | 1 | 713.08 | 1 | 672.29 | 9 | SO69394 | 2024-08-21 | 53.78 | 713.08 | 672.29 |
SO69394_10 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 374 | 206 | 5 | 2024-08-26 | 1466.01 | 36.65 | 2024-08-14 | 1 | 1554.95 | 1 | 1466.01 | 10 | SO69394 | 2024-08-21 | 117.28 | 1554.95 | 1466.01 |
SO69394_11 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 546 | 206 | 5 | 2024-08-26 | 111.76 | 2.79 | 2024-08-14 | 3 | 27.57 | 1 | 111.76 | 11 | SO69394 | 2024-08-21 | 8.94 | 82.70 | 37.25 |
SO69394_12 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 605 | 206 | 5 | 2024-08-26 | 971.98 | 24.30 | 2024-08-14 | 3 | 343.65 | 1 | 971.98 | 12 | SO69394 | 2024-08-21 | 77.76 | 1030.95 | 323.99 |
SO69394_13 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 604 | 206 | 5 | 2024-08-26 | 323.99 | 8.10 | 2024-08-14 | 1 | 343.65 | 1 | 323.99 | 13 | SO69394 | 2024-08-21 | 25.92 | 343.65 | 323.99 |
SO69394_14 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 606 | 206 | 5 | 2024-08-26 | 323.99 | 8.10 | 2024-08-14 | 1 | 343.65 | 1 | 323.99 | 14 | SO69394 | 2024-08-21 | 25.92 | 343.65 | 323.99 |
SO69394_15 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 382 | 206 | 5 | 2024-08-26 | 2016.88 | 50.42 | 2024-08-14 | 3 | 713.08 | 1 | 2016.88 | 15 | SO69394 | 2024-08-21 | 161.35 | 2139.24 | 672.29 |
SO69394_16 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 580 | 206 | 5 | 2024-08-26 | 2041.19 | 51.03 | 2024-08-14 | 2 | 1082.51 | 1 | 2041.19 | 16 | SO69394 | 2024-08-21 | 163.30 | 2165.02 | 1020.59 |
SO69394_17 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 582 | 206 | 5 | 2024-08-26 | 1020.59 | 25.51 | 2024-08-14 | 1 | 1082.51 | 1 | 1020.59 | 17 | SO69394 | 2024-08-21 | 81.65 | 1082.51 | 1020.59 |
SO69394_18 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 583 | 206 | 5 | 2024-08-26 | 2041.19 | 51.03 | 2024-08-14 | 2 | 1082.51 | 1 | 2041.19 | 18 | SO69394 | 2024-08-21 | 163.30 | 2165.02 | 1020.59 |
SO69394_19 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 376 | 206 | 5 | 2024-08-26 | 2932.02 | 73.30 | 2024-08-14 | 2 | 1554.95 | 1 | 2932.02 | 19 | SO69394 | 2024-08-21 | 234.56 | 3109.90 | 1466.01 |
SO69394_20 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 378 | 206 | 5 | 2024-08-26 | 1466.01 | 36.65 | 2024-08-14 | 1 | 1554.95 | 1 | 1466.01 | 20 | SO69394 | 2024-08-21 | 117.28 | 1554.95 | 1466.01 |
SO69394_21 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 545 | 206 | 5 | 2024-08-26 | 97.18 | 2.43 | 2024-08-14 | 4 | 17.98 | 1 | 97.18 | 21 | SO69394 | 2024-08-21 | 7.77 | 71.91 | 24.29 |
SO69394_22 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 434 | 206 | 5 | 2024-08-26 | 1070.69 | 26.77 | 2024-08-14 | 3 | 360.94 | 1 | 1070.69 | 22 | SO69394 | 2024-08-21 | 85.66 | 1082.83 | 356.90 |
SO69403_1 | 1903-46D6-BD | PO17255162361 | 100 | 285 | 579 | 80 | 5 | 2024-08-26 | 728.91 | 18.22 | 2024-08-14 | 1 | 755.15 | 1 | 728.91 | 1 | SO69403 | 2024-08-21 | 58.31 | 755.15 | 728.91 |
SO69403_2 | 1903-46D6-BD | PO17255162361 | 100 | 285 | 576 | 80 | 5 | 2024-08-26 | 1430.44 | 35.76 | 2024-08-14 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO69403 | 2024-08-21 | 114.44 | 1481.94 | 1430.44 |
SO69405_1 | E3D1-4246-9F | PO16965195306 | 100 | 285 | 605 | 441 | 5 | 2024-08-26 | 647.99 | 16.20 | 2024-08-14 | 2 | 343.65 | 1 | 647.99 | 1 | SO69405 | 2024-08-21 | 51.84 | 687.30 | 323.99 |
SO69405_2 | E3D1-4246-9F | PO16965195306 | 100 | 285 | 491 | 441 | 5 | 2024-08-26 | 97.18 | 2.43 | 2024-08-14 | 3 | 41.57 | 1 | 97.18 | 2 | SO69405 | 2024-08-21 | 7.77 | 124.72 | 32.39 |
SO69405_3 | E3D1-4246-9F | PO16965195306 | 100 | 285 | 471 | 441 | 5 | 2024-08-26 | 114.30 | 2.86 | 2024-08-14 | 3 | 23.75 | 1 | 114.30 | 3 | SO69405 | 2024-08-21 | 9.14 | 71.25 | 38.10 |
SO69405_4 | E3D1-4246-9F | PO16965195306 | 100 | 285 | 580 | 441 | 5 | 2024-08-26 | 2041.19 | 51.03 | 2024-08-14 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO69405 | 2024-08-21 | 163.30 | 2165.02 | 1020.59 |
Generated 2024-11-13 09:38:21.512 UTC