[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SKIP 0 < SKIP 2942 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57180_1 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 566 | 520 | 10 | 2024-01-04 | 890.82 | 22.27 | 2023-12-23 | 2 | 461.44 | 1 | 890.82 | 1 | SO57180 | 2023-12-30 | 71.27 | 922.89 | 445.41 | |||
SO57180_2 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 500 | 520 | 10 | 2024-01-04 | 602.35 | 15.06 | 2023-12-23 | 1 | 601.74 | 1 | 602.35 | 2 | SO57180 | 2023-12-30 | 48.19 | 601.74 | 602.35 | |||
SO57180_3 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 503 | 520 | 10 | 2024-01-04 | 600.16 | 15.00 | 2023-12-23 | 3 | 199.85 | 1 | 600.16 | 3 | SO57180 | 2023-12-30 | 48.01 | 599.56 | 200.05 | |||
SO57180_4 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 562 | 520 | 10 | 2024-01-04 | 2860.88 | 71.52 | 2023-12-23 | 2 | 1481.94 | 1 | 2860.88 | 4 | SO57180 | 2023-12-30 | 228.87 | 2963.88 | 1430.44 | |||
SO57180_5 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 498 | 520 | 10 | 2024-01-04 | 1204.69 | 30.12 | 2023-12-23 | 2 | 601.74 | 1 | 1204.69 | 5 | SO57180 | 2023-12-30 | 96.38 | 1203.49 | 602.35 | |||
SO57180_6 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 572 | 520 | 10 | 2024-01-04 | 3117.87 | 77.95 | 2023-12-23 | 7 | 461.44 | 1 | 3117.87 | 6 | SO57180 | 2023-12-30 | 249.43 | 3230.11 | 445.41 | |||
SO57180_7 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 579 | 2 | 520 | 10 | 155.01 | 2024-01-04 | 7750.74 | 189.89 | 2023-12-23 | 11 | 755.15 | 1 | 7595.73 | 7 | SO57180 | 2023-12-30 | 607.66 | 8306.66 | 704.61 | 0.02 |
SO57180_8 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 499 | 520 | 10 | 2024-01-04 | 1204.69 | 30.12 | 2023-12-23 | 2 | 601.74 | 1 | 1204.69 | 8 | SO57180 | 2023-12-30 | 96.38 | 1203.49 | 602.35 | |||
SO57180_9 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 573 | 520 | 10 | 2024-01-04 | 10013.09 | 250.33 | 2023-12-23 | 7 | 1481.94 | 1 | 10013.09 | 9 | SO57180 | 2023-12-30 | 801.05 | 10373.57 | 1430.44 | |||
SO57180_10 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 586 | 3 | 520 | 10 | 367.46 | 2024-01-04 | 7349.27 | 174.55 | 2023-12-23 | 18 | 461.44 | 1 | 6981.80 | 10 | SO57180 | 2023-12-30 | 558.54 | 8306.01 | 408.29 | 0.05 |
SO57180_11 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 493 | 520 | 10 | 2024-01-04 | 200.05 | 5.00 | 2023-12-23 | 1 | 199.85 | 1 | 200.05 | 11 | SO57180 | 2023-12-30 | 16.00 | 199.85 | 200.05 | |||
SO57180_12 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 561 | 520 | 10 | 2024-01-04 | 4291.33 | 107.28 | 2023-12-23 | 3 | 1481.94 | 1 | 4291.33 | 12 | SO57180 | 2023-12-30 | 343.31 | 4445.81 | 1430.44 | |||
SO57180_13 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 564 | 520 | 10 | 2024-01-04 | 5721.77 | 143.04 | 2023-12-23 | 4 | 1481.94 | 1 | 5721.77 | 13 | SO57180 | 2023-12-30 | 457.74 | 5927.75 | 1430.44 | |||
SO57180_14 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 565 | 520 | 10 | 2024-01-04 | 3563.28 | 89.08 | 2023-12-23 | 8 | 461.44 | 1 | 3563.28 | 14 | SO57180 | 2023-12-30 | 285.06 | 3691.56 | 445.41 | |||
SO57180_15 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 577 | 520 | 10 | 2024-01-04 | 2186.73 | 54.67 | 2023-12-23 | 3 | 755.15 | 1 | 2186.73 | 15 | SO57180 | 2023-12-30 | 174.94 | 2265.45 | 728.91 | |||
SO57180_16 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 495 | 520 | 10 | 2024-01-04 | 1204.69 | 30.12 | 2023-12-23 | 2 | 601.74 | 1 | 1204.69 | 16 | SO57180 | 2023-12-30 | 96.38 | 1203.49 | 602.35 | |||
SO57180_17 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 217 | 520 | 10 | 2024-01-04 | 41.99 | 1.05 | 2023-12-23 | 2 | 13.09 | 1 | 41.99 | 17 | SO57180 | 2023-12-30 | 3.36 | 26.17 | 20.99 | |||
SO57180_18 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 507 | 520 | 10 | 2024-01-04 | 1200.31 | 30.01 | 2023-12-23 | 6 | 199.85 | 1 | 1200.31 | 18 | SO57180 | 2023-12-30 | 96.03 | 1199.11 | 200.05 | |||
SO57180_19 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 560 | 520 | 10 | 2024-01-04 | 6560.19 | 164.00 | 2023-12-23 | 9 | 755.15 | 1 | 6560.19 | 19 | SO57180 | 2023-12-30 | 524.82 | 6796.36 | 728.91 | |||
SO57180_20 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 502 | 520 | 10 | 2024-01-04 | 400.10 | 10.00 | 2023-12-23 | 2 | 199.85 | 1 | 400.10 | 20 | SO57180 | 2023-12-30 | 32.01 | 399.70 | 200.05 | |||
SO57180_21 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 570 | 520 | 10 | 2024-01-04 | 890.82 | 22.27 | 2023-12-23 | 2 | 461.44 | 1 | 890.82 | 21 | SO57180 | 2023-12-30 | 71.27 | 922.89 | 445.41 | |||
SO57180_22 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 554 | 520 | 10 | 2024-01-04 | 54.94 | 1.37 | 2023-12-23 | 1 | 40.66 | 1 | 54.94 | 22 | SO57180 | 2023-12-30 | 4.40 | 40.66 | 54.94 | |||
SO57180_23 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 568 | 520 | 10 | 2024-01-04 | 890.82 | 22.27 | 2023-12-23 | 2 | 461.44 | 1 | 890.82 | 23 | SO57180 | 2023-12-30 | 71.27 | 922.89 | 445.41 | |||
SO57180_24 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 523 | 520 | 10 | 2024-01-04 | 31.58 | 0.79 | 2023-12-23 | 1 | 23.37 | 1 | 31.58 | 24 | SO57180 | 2023-12-30 | 2.53 | 23.37 | 31.58 | |||
SO57180_25 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 496 | 520 | 10 | 2024-01-04 | 4818.77 | 120.47 | 2023-12-23 | 8 | 601.74 | 1 | 4818.77 | 25 | SO57180 | 2023-12-30 | 385.50 | 4813.95 | 602.35 | |||
SO57180_26 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 506 | 520 | 10 | 2024-01-04 | 1400.36 | 35.01 | 2023-12-23 | 7 | 199.85 | 1 | 1400.36 | 26 | SO57180 | 2023-12-30 | 112.03 | 1398.96 | 200.05 | |||
SO57180_27 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 497 | 520 | 10 | 2024-01-04 | 602.35 | 15.06 | 2023-12-23 | 1 | 601.74 | 1 | 602.35 | 27 | SO57180 | 2023-12-30 | 48.19 | 601.74 | 602.35 | |||
SO57180_28 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 492 | 520 | 10 | 2024-01-04 | 1204.69 | 30.12 | 2023-12-23 | 2 | 601.74 | 1 | 1204.69 | 28 | SO57180 | 2023-12-30 | 96.38 | 1203.49 | 602.35 | |||
SO57183_1 | CE1E-4523-8F | PO8381128940 | 98 | 288 | 380 | 70 | 10 | 2024-01-04 | 1466.01 | 36.65 | 2023-12-23 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO57183 | 2023-12-30 | 117.28 | 1554.95 | 1466.01 | |||
SO57184_1 | 548D-4D01-A0 | PO8758120194 | 98 | 288 | 361 | 683 | 10 | 2024-01-04 | 2753.99 | 68.85 | 2023-12-23 | 2 | 1251.98 | 1 | 2753.99 | 1 | SO57184 | 2023-12-30 | 220.32 | 2503.96 | 1376.99 | |||
SO57184_2 | 548D-4D01-A0 | PO8758120194 | 98 | 288 | 474 | 683 | 10 | 2024-01-04 | 377.95 | 9.45 | 2023-12-23 | 9 | 26.18 | 1 | 377.95 | 2 | SO57184 | 2023-12-30 | 30.24 | 235.59 | 41.99 | |||
SO57184_3 | 548D-4D01-A0 | PO8758120194 | 98 | 288 | 476 | 683 | 10 | 2024-01-04 | 167.98 | 4.20 | 2023-12-23 | 4 | 26.18 | 1 | 167.98 | 3 | SO57184 | 2023-12-30 | 13.44 | 104.71 | 41.99 | |||
SO57184_4 | 548D-4D01-A0 | PO8758120194 | 98 | 288 | 359 | 683 | 10 | 2024-01-04 | 4130.98 | 103.27 | 2023-12-23 | 3 | 1251.98 | 1 | 4130.98 | 4 | SO57184 | 2023-12-30 | 330.48 | 3755.94 | 1376.99 | |||
SO57184_5 | 548D-4D01-A0 | PO8758120194 | 98 | 288 | 475 | 683 | 10 | 2024-01-04 | 41.99 | 1.05 | 2023-12-23 | 1 | 26.18 | 1 | 41.99 | 5 | SO57184 | 2023-12-30 | 3.36 | 26.18 | 41.99 | |||
SO57185_1 | 683A-464C-8C | PO8729178515 | 98 | 290 | 576 | 556 | 10 | 2024-01-04 | 5721.77 | 143.04 | 2023-12-23 | 4 | 1481.94 | 1 | 5721.77 | 1 | SO57185 | 2023-12-30 | 457.74 | 5927.75 | 1430.44 | |||
SO57185_2 | 683A-464C-8C | PO8729178515 | 98 | 290 | 559 | 556 | 10 | 2024-01-04 | 12.14 | 0.30 | 2023-12-23 | 1 | 8.99 | 1 | 12.14 | 2 | SO57185 | 2023-12-30 | 0.97 | 8.99 | 12.14 | |||
SO57185_3 | 683A-464C-8C | PO8729178515 | 98 | 290 | 569 | 556 | 10 | 2024-01-04 | 445.41 | 11.14 | 2023-12-23 | 1 | 461.44 | 1 | 445.41 | 3 | SO57185 | 2023-12-30 | 35.63 | 461.44 | 445.41 | |||
SO57185_4 | 683A-464C-8C | PO8729178515 | 98 | 290 | 572 | 556 | 10 | 2024-01-04 | 890.82 | 22.27 | 2023-12-23 | 2 | 461.44 | 1 | 890.82 | 4 | SO57185 | 2023-12-30 | 71.27 | 922.89 | 445.41 | |||
SO57185_5 | 683A-464C-8C | PO8729178515 | 98 | 290 | 555 | 556 | 10 | 2024-01-04 | 383.40 | 9.59 | 2023-12-23 | 6 | 47.29 | 1 | 383.40 | 5 | SO57185 | 2023-12-30 | 30.67 | 283.72 | 63.90 | |||
SO57185_6 | 683A-464C-8C | PO8729178515 | 98 | 290 | 579 | 556 | 10 | 2024-01-04 | 3644.55 | 91.11 | 2023-12-23 | 5 | 755.15 | 1 | 3644.55 | 6 | SO57185 | 2023-12-30 | 291.56 | 3775.75 | 728.91 | |||
SO57185_7 | 683A-464C-8C | PO8729178515 | 98 | 290 | 552 | 556 | 10 | 2024-01-04 | 109.79 | 2.74 | 2023-12-23 | 2 | 40.62 | 1 | 109.79 | 7 | SO57185 | 2023-12-30 | 8.78 | 81.24 | 54.89 | |||
SO57185_8 | 683A-464C-8C | PO8729178515 | 98 | 290 | 573 | 556 | 10 | 2024-01-04 | 5721.77 | 143.04 | 2023-12-23 | 4 | 1481.94 | 1 | 5721.77 | 8 | SO57185 | 2023-12-30 | 457.74 | 5927.75 | 1430.44 | |||
SO57185_9 | 683A-464C-8C | PO8729178515 | 98 | 290 | 586 | 556 | 10 | 2024-01-04 | 1336.23 | 33.41 | 2023-12-23 | 3 | 461.44 | 1 | 1336.23 | 9 | SO57185 | 2023-12-30 | 106.90 | 1384.33 | 445.41 | |||
SO57185_10 | 683A-464C-8C | PO8729178515 | 98 | 290 | 560 | 556 | 10 | 2024-01-04 | 728.91 | 18.22 | 2023-12-23 | 1 | 755.15 | 1 | 728.91 | 10 | SO57185 | 2023-12-30 | 58.31 | 755.15 | 728.91 | |||
SO57185_11 | 683A-464C-8C | PO8729178515 | 98 | 290 | 561 | 556 | 10 | 2024-01-04 | 5721.77 | 143.04 | 2023-12-23 | 4 | 1481.94 | 1 | 5721.77 | 11 | SO57185 | 2023-12-30 | 457.74 | 5927.75 | 1430.44 | |||
SO57185_12 | 683A-464C-8C | PO8729178515 | 98 | 290 | 564 | 556 | 10 | 2024-01-04 | 2860.88 | 71.52 | 2023-12-23 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO57185 | 2023-12-30 | 228.87 | 2963.88 | 1430.44 | |||
SO57185_13 | 683A-464C-8C | PO8729178515 | 98 | 290 | 565 | 556 | 10 | 2024-01-04 | 1336.23 | 33.41 | 2023-12-23 | 3 | 461.44 | 1 | 1336.23 | 13 | SO57185 | 2023-12-30 | 106.90 | 1384.33 | 445.41 | |||
SO58905_1 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 592 | 340 | 10 | 2024-02-03 | 677.99 | 16.95 | 2024-01-22 | 2 | 308.22 | 1 | 677.99 | 1 | SO58905 | 2024-01-29 | 54.24 | 616.44 | 338.99 | |||
SO58905_2 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 363 | 340 | 10 | 2024-02-03 | 5507.98 | 137.70 | 2024-01-22 | 4 | 1251.98 | 1 | 5507.98 | 2 | SO58905 | 2024-01-29 | 440.64 | 5007.93 | 1376.99 | |||
SO58905_3 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 591 | 340 | 10 | 2024-02-03 | 338.99 | 8.47 | 2024-01-22 | 1 | 308.22 | 1 | 338.99 | 3 | SO58905 | 2024-01-29 | 27.12 | 308.22 | 338.99 | |||
SO58905_4 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 543 | 340 | 10 | 2024-02-03 | 37.25 | 0.93 | 2024-01-22 | 1 | 27.57 | 1 | 37.25 | 4 | SO58905 | 2024-01-29 | 2.98 | 27.57 | 37.25 | |||
SO58905_5 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 597 | 340 | 10 | 2024-02-03 | 647.99 | 16.20 | 2024-01-22 | 2 | 294.58 | 1 | 647.99 | 5 | SO58905 | 2024-01-29 | 51.84 | 589.16 | 323.99 | |||
SO58905_6 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 359 | 340 | 10 | 2024-02-03 | 1376.99 | 34.42 | 2024-01-22 | 1 | 1251.98 | 1 | 1376.99 | 6 | SO58905 | 2024-01-29 | 110.16 | 1251.98 | 1376.99 | |||
SO58905_7 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 517 | 340 | 10 | 2024-02-03 | 157.92 | 3.95 | 2024-01-22 | 5 | 23.37 | 1 | 157.92 | 7 | SO58905 | 2024-01-29 | 12.63 | 116.86 | 31.58 | |||
SO58905_8 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 590 | 340 | 10 | 2024-02-03 | 461.69 | 11.54 | 2024-01-22 | 1 | 419.78 | 1 | 461.69 | 8 | SO58905 | 2024-01-29 | 36.94 | 419.78 | 461.69 | |||
SO58905_9 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 524 | 340 | 10 | 2024-02-03 | 158.43 | 3.96 | 2024-01-22 | 1 | 144.59 | 1 | 158.43 | 9 | SO58905 | 2024-01-29 | 12.67 | 144.59 | 158.43 | |||
SO58905_10 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 476 | 4 | 340 | 10 | 90.99 | 2024-02-03 | 909.87 | 20.47 | 2024-01-22 | 26 | 26.18 | 1 | 818.88 | 10 | SO58905 | 2024-01-29 | 65.51 | 680.58 | 35.00 | 0.10 |
SO58905_11 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 599 | 340 | 10 | 2024-02-03 | 323.99 | 8.10 | 2024-01-22 | 1 | 294.58 | 1 | 323.99 | 11 | SO58905 | 2024-01-29 | 25.92 | 294.58 | 323.99 | |||
SO58905_12 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 477 | 340 | 10 | 2024-02-03 | 2.99 | 0.07 | 2024-01-22 | 1 | 1.87 | 1 | 2.99 | 12 | SO58905 | 2024-01-29 | 0.24 | 1.87 | 2.99 | |||
SO58905_13 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 544 | 340 | 10 | 2024-02-03 | 97.19 | 2.43 | 2024-01-22 | 2 | 35.96 | 1 | 97.19 | 13 | SO58905 | 2024-01-29 | 7.78 | 71.92 | 48.59 | |||
SO58905_14 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 357 | 340 | 10 | 2024-02-03 | 2783.99 | 69.60 | 2024-01-22 | 2 | 1265.62 | 1 | 2783.99 | 14 | SO58905 | 2024-01-29 | 222.72 | 2531.24 | 1391.99 | |||
SO58905_15 | 79BE-4713-94 | PO19604111681 | 98 | 288 | 355 | 340 | 10 | 2024-02-03 | 4175.98 | 104.40 | 2024-01-22 | 3 | 1265.62 | 1 | 4175.98 | 15 | SO58905 | 2024-01-29 | 334.08 | 3796.86 | 1391.99 |
Generated 2024-09-21 13:50:49.112 UTC