[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 548 > < TAKE 56 >
56 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58979_14 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 563 | 509 | 4 | 2024-03-27 | 1430.44 | 35.76 | 2024-03-15 | 1 | 1481.94 | 1 | 1430.44 | 14 | SO58979 | 2024-03-22 | 114.44 | 1481.94 | 1430.44 | |||
SO43912_14 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 215 | 403 | 4 | 2021-11-26 | 20.19 | 0.50 | 2021-11-14 | 1 | 12.03 | 1 | 20.19 | 14 | SO43912 | 2021-11-21 | 1.61 | 12.03 | 20.19 | |||
SO47677_4 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 356 | 475 | 4 | 2023-01-26 | 4971.41 | 124.29 | 2023-01-14 | 4 | 1117.86 | 1 | 4971.41 | 4 | SO47677 | 2023-01-21 | 397.71 | 4471.42 | 1242.85 | |||
SO51121_14 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 388 | 491 | 4 | 2023-10-26 | 3361.47 | 84.04 | 2023-10-14 | 5 | 713.08 | 1 | 3361.47 | 14 | SO51121 | 2023-10-21 | 268.92 | 3565.40 | 672.29 | |||
SO58979_15 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 556 | 509 | 4 | 2024-03-27 | 105.29 | 2.63 | 2024-03-15 | 1 | 77.92 | 1 | 105.29 | 15 | SO58979 | 2024-03-22 | 8.42 | 77.92 | 105.29 | |||
SO43912_15 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 285 | 403 | 4 | 2021-11-26 | 178.58 | 4.46 | 2021-11-14 | 1 | 176.20 | 1 | 178.58 | 15 | SO43912 | 2021-11-21 | 14.29 | 176.20 | 178.58 | |||
SO47677_5 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 354 | 475 | 4 | 2023-01-26 | 2485.70 | 62.14 | 2023-01-14 | 2 | 1117.86 | 1 | 2485.70 | 5 | SO47677 | 2023-01-21 | 198.86 | 2235.71 | 1242.85 | |||
SO51121_15 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 488 | 491 | 4 | 2023-10-26 | 64.79 | 1.62 | 2023-10-14 | 2 | 41.57 | 1 | 64.79 | 15 | SO51121 | 2023-10-21 | 5.18 | 83.14 | 32.39 | |||
SO58979_16 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 558 | 509 | 4 | 2024-03-27 | 242.99 | 6.07 | 2024-03-15 | 1 | 179.82 | 1 | 242.99 | 16 | SO58979 | 2024-03-22 | 19.44 | 179.82 | 242.99 | |||
SO43912_16 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 315 | 403 | 4 | 2021-11-26 | 2624.38 | 65.61 | 2021-11-14 | 3 | 884.71 | 1 | 2624.38 | 16 | SO43912 | 2021-11-21 | 209.95 | 2654.12 | 874.79 | |||
SO47677_6 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 459 | 475 | 4 | 2023-01-26 | 107.99 | 2.70 | 2023-01-14 | 2 | 37.12 | 1 | 107.99 | 6 | SO47677 | 2023-01-21 | 8.64 | 74.24 | 53.99 | |||
SO51121_16 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 380 | 491 | 4 | 2023-10-26 | 4398.03 | 109.95 | 2023-10-14 | 3 | 1554.95 | 1 | 4398.03 | 16 | SO51121 | 2023-10-21 | 351.84 | 4664.84 | 1466.01 | |||
SO58979_17 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 572 | 509 | 4 | 2024-03-27 | 445.41 | 11.14 | 2024-03-15 | 1 | 461.44 | 1 | 445.41 | 17 | SO58979 | 2024-03-22 | 35.63 | 461.44 | 445.41 | |||
SO43913_1 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 349 | 40 | 4 | 2021-11-26 | 8099.98 | 202.50 | 2021-11-14 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO43913 | 2021-11-21 | 648.00 | 7592.38 | 2024.99 | |||
SO47677_7 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 427 | 475 | 4 | 2023-01-26 | 627.77 | 15.69 | 2023-01-14 | 3 | 185.82 | 1 | 627.77 | 7 | SO47677 | 2023-01-21 | 50.22 | 557.46 | 209.26 | |||
SO51121_17 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 376 | 491 | 4 | 2023-10-26 | 11728.08 | 293.20 | 2023-10-14 | 8 | 1554.95 | 1 | 11728.08 | 17 | SO51121 | 2023-10-21 | 938.25 | 12439.58 | 1466.01 | |||
SO58979_18 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 566 | 509 | 4 | 2024-03-27 | 890.82 | 22.27 | 2024-03-15 | 2 | 461.44 | 1 | 890.82 | 18 | SO58979 | 2024-03-22 | 71.27 | 922.89 | 445.41 | |||
SO43913_2 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 344 | 40 | 4 | 2021-11-26 | 4079.99 | 102.00 | 2021-11-14 | 2 | 1912.15 | 1 | 4079.99 | 2 | SO43913 | 2021-11-21 | 326.40 | 3824.31 | 2039.99 | |||
SO47677_8 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 448 | 475 | 4 | 2023-01-26 | 59.97 | 1.50 | 2023-01-14 | 5 | 8.25 | 1 | 59.97 | 8 | SO47677 | 2023-01-21 | 4.80 | 41.23 | 11.99 | |||
SO51121_18 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 604 | 491 | 4 | 2023-10-26 | 647.99 | 16.20 | 2023-10-14 | 2 | 343.65 | 1 | 647.99 | 18 | SO51121 | 2023-10-21 | 51.84 | 687.30 | 323.99 | |||
SO58979_19 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 574 | 509 | 4 | 2024-03-27 | 2860.88 | 71.52 | 2024-03-15 | 2 | 1481.94 | 1 | 2860.88 | 19 | SO58979 | 2024-03-22 | 228.87 | 2963.88 | 1430.44 | |||
SO43913_3 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 232 | 40 | 4 | 2021-11-26 | 28.84 | 0.72 | 2021-11-14 | 1 | 31.72 | 1 | 28.84 | 3 | SO43913 | 2021-11-21 | 2.31 | 31.72 | 28.84 | |||
SO47677_9 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 410 | 475 | 4 | 2023-01-26 | 36.45 | 0.91 | 2023-01-14 | 1 | 26.97 | 1 | 36.45 | 9 | SO47677 | 2023-01-21 | 2.92 | 26.97 | 36.45 | |||
SO51121_19 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 382 | 491 | 4 | 2023-10-26 | 2016.88 | 50.42 | 2023-10-14 | 3 | 713.08 | 1 | 2016.88 | 19 | SO51121 | 2023-10-21 | 161.35 | 2139.24 | 672.29 | |||
SO58979_20 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 555 | 509 | 4 | 2024-03-27 | 127.80 | 3.20 | 2024-03-15 | 2 | 47.29 | 1 | 127.80 | 20 | SO58979 | 2024-03-22 | 10.22 | 94.57 | 63.90 | |||
SO43913_4 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 345 | 40 | 4 | 2021-11-26 | 2039.99 | 51.00 | 2021-11-14 | 1 | 1912.15 | 1 | 2039.99 | 4 | SO43913 | 2021-11-21 | 163.20 | 1912.15 | 2039.99 | |||
SO47677_10 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 421 | 475 | 4 | 2023-01-26 | 392.66 | 9.82 | 2023-01-14 | 2 | 145.28 | 1 | 392.66 | 10 | SO47677 | 2023-01-21 | 31.41 | 290.57 | 196.33 | |||
SO51121_20 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 231 | 491 | 4 | 2023-10-26 | 119.98 | 3.00 | 2023-10-14 | 4 | 38.49 | 1 | 119.98 | 20 | SO51121 | 2023-10-21 | 9.60 | 153.97 | 29.99 | |||
SO58979_21 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 569 | 509 | 4 | 2024-03-27 | 1336.23 | 33.41 | 2024-03-15 | 3 | 461.44 | 1 | 1336.23 | 21 | SO58979 | 2024-03-22 | 106.90 | 1384.33 | 445.41 | |||
SO43913_5 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 351 | 40 | 4 | 2021-11-26 | 4049.99 | 101.25 | 2021-11-14 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO43913 | 2021-11-21 | 324.00 | 3796.19 | 2024.99 | |||
SO47677_11 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 224 | 475 | 4 | 2023-01-26 | 36.31 | 0.91 | 2023-01-14 | 7 | 5.23 | 1 | 36.31 | 11 | SO47677 | 2023-01-21 | 2.90 | 36.61 | 5.19 | |||
SO51121_21 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 225 | 491 | 4 | 2023-10-26 | 26.97 | 0.67 | 2023-10-14 | 5 | 6.92 | 1 | 26.97 | 21 | SO51121 | 2023-10-21 | 2.16 | 34.61 | 5.39 | |||
SO58979_22 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 568 | 509 | 4 | 2024-03-27 | 1336.23 | 33.41 | 2024-03-15 | 3 | 461.44 | 1 | 1336.23 | 22 | SO58979 | 2024-03-22 | 106.90 | 1384.33 | 445.41 | |||
SO43913_6 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 215 | 40 | 4 | 2021-11-26 | 20.19 | 0.50 | 2021-11-14 | 1 | 12.03 | 1 | 20.19 | 6 | SO43913 | 2021-11-21 | 1.61 | 12.03 | 20.19 | |||
SO47677_12 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 230 | 475 | 4 | 2023-01-26 | 144.20 | 3.61 | 2023-01-14 | 5 | 29.08 | 1 | 144.20 | 12 | SO47677 | 2023-01-21 | 11.54 | 145.40 | 28.84 | |||
SO51121_22 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 378 | 491 | 4 | 2023-10-26 | 4398.03 | 109.95 | 2023-10-14 | 3 | 1554.95 | 1 | 4398.03 | 22 | SO51121 | 2023-10-21 | 351.84 | 4664.84 | 1466.01 | |||
SO58979_23 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 559 | 509 | 4 | 2024-03-27 | 24.29 | 0.61 | 2024-03-15 | 2 | 8.99 | 1 | 24.29 | 23 | SO58979 | 2024-03-22 | 1.94 | 17.97 | 12.14 | |||
SO43913_7 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 350 | 40 | 4 | 2021-11-26 | 10124.97 | 253.12 | 2021-11-14 | 5 | 1898.09 | 1 | 10124.97 | 7 | SO43913 | 2021-11-21 | 810.00 | 9490.47 | 2024.99 | |||
SO47677_13 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 393 | 475 | 4 | 2023-01-26 | 275.39 | 6.88 | 2023-01-14 | 2 | 101.89 | 1 | 275.39 | 13 | SO47677 | 2023-01-21 | 22.03 | 203.79 | 137.69 | |||
SO51121_23 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 436 | 491 | 4 | 2023-10-26 | 713.80 | 17.84 | 2023-10-14 | 2 | 360.94 | 1 | 713.80 | 23 | SO51121 | 2023-10-21 | 57.10 | 721.89 | 356.90 | |||
SO58982_1 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 382 | 311 | 4 | 2024-03-27 | 2689.18 | 67.23 | 2024-03-15 | 4 | 713.08 | 1 | 2689.18 | 1 | SO58982 | 2024-03-22 | 215.13 | 2852.32 | 672.29 | |||
SO43913_8 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 348 | 40 | 4 | 2021-11-26 | 8099.98 | 202.50 | 2021-11-14 | 4 | 1898.09 | 1 | 8099.98 | 8 | SO43913 | 2021-11-21 | 648.00 | 7592.38 | 2024.99 | |||
SO47677_14 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 365 | 475 | 4 | 2023-01-26 | 3887.96 | 97.20 | 2023-01-14 | 6 | 598.44 | 1 | 3887.96 | 14 | SO47677 | 2023-01-21 | 311.04 | 3590.61 | 647.99 | |||
SO51121_24 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 234 | 2 | 491 | 4 | 6.38 | 2023-10-26 | 318.94 | 7.81 | 2023-10-14 | 11 | 38.49 | 1 | 312.56 | 24 | SO51121 | 2023-10-21 | 25.00 | 423.42 | 28.99 | 0.02 |
SO58982_2 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 386 | 311 | 4 | 2024-03-27 | 1344.59 | 33.61 | 2024-03-15 | 2 | 713.08 | 1 | 1344.59 | 2 | SO58982 | 2024-03-22 | 107.57 | 1426.16 | 672.29 | |||
SO43913_9 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 223 | 40 | 4 | 2021-11-26 | 10.37 | 0.26 | 2021-11-14 | 2 | 5.71 | 1 | 10.37 | 9 | SO43913 | 2021-11-21 | 0.83 | 11.41 | 5.19 | |||
SO47677_15 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 360 | 475 | 4 | 2023-01-26 | 1229.46 | 30.74 | 2023-01-14 | 1 | 1105.81 | 1 | 1229.46 | 15 | SO47677 | 2023-01-21 | 98.36 | 1105.81 | 1229.46 | |||
SO51121_25 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 482 | 491 | 4 | 2023-10-26 | 37.76 | 0.94 | 2023-10-14 | 7 | 3.36 | 1 | 37.76 | 25 | SO51121 | 2023-10-21 | 3.02 | 23.54 | 5.39 | |||
SO58982_3 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 374 | 311 | 4 | 2024-03-27 | 1466.01 | 36.65 | 2024-03-15 | 1 | 1554.95 | 1 | 1466.01 | 3 | SO58982 | 2024-03-22 | 117.28 | 1554.95 | 1466.01 | |||
SO43913_10 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 212 | 40 | 4 | 2021-11-26 | 100.93 | 2.52 | 2021-11-14 | 5 | 12.03 | 1 | 100.93 | 10 | SO43913 | 2021-11-21 | 8.07 | 60.14 | 20.19 | |||
SO47677_16 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 294 | 475 | 4 | 2023-01-26 | 1488.55 | 37.21 | 2023-01-14 | 2 | 660.91 | 1 | 1488.55 | 16 | SO47677 | 2023-01-21 | 119.08 | 1321.83 | 744.27 | |||
SO51121_26 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 584 | 491 | 4 | 2023-10-26 | 647.99 | 16.20 | 2023-10-14 | 2 | 343.65 | 1 | 647.99 | 26 | SO51121 | 2023-10-21 | 51.84 | 687.30 | 323.99 | |||
SO58982_4 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 384 | 311 | 4 | 2024-03-27 | 672.29 | 16.81 | 2024-03-15 | 1 | 713.08 | 1 | 672.29 | 4 | SO58982 | 2024-03-22 | 53.78 | 713.08 | 672.29 | |||
SO43913_11 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 218 | 40 | 4 | 2021-11-26 | 28.50 | 0.71 | 2021-11-14 | 5 | 3.40 | 1 | 28.50 | 11 | SO43913 | 2021-11-21 | 2.28 | 16.98 | 5.70 | |||
SO47677_17 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 236 | 475 | 4 | 2023-01-26 | 144.20 | 3.61 | 2023-01-14 | 5 | 29.08 | 1 | 144.20 | 17 | SO47677 | 2023-01-21 | 11.54 | 145.40 | 28.84 | |||
SO51121_27 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 547 | 491 | 4 | 2023-10-26 | 145.78 | 3.64 | 2023-10-14 | 3 | 35.96 | 1 | 145.78 | 27 | SO51121 | 2023-10-21 | 11.66 | 107.88 | 48.59 |
Generated 2024-11-13 06:08:36.186 UTC