[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 6185 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50270_1 | A828-45A2-8B | PO18676112371 | 100 | 282 | 354 | 697 | 1 | 2023-08-26 | 11185.67 | 279.64 | 2023-08-14 | 9 | 1117.86 | 1 | 11185.67 | 1 | SO50270 | 2023-08-21 | 894.85 | 10060.70 | 1242.85 | |||
| SO50270_2 | A828-45A2-8B | PO18676112371 | 100 | 282 | 421 | 697 | 1 | 2023-08-26 | 785.32 | 19.63 | 2023-08-14 | 4 | 145.28 | 1 | 785.32 | 2 | SO50270 | 2023-08-21 | 62.83 | 581.13 | 196.33 | |||
| SO50270_3 | A828-45A2-8B | PO18676112371 | 100 | 282 | 365 | 697 | 1 | 2023-08-26 | 3887.96 | 97.20 | 2023-08-14 | 6 | 598.44 | 1 | 3887.96 | 3 | SO50270 | 2023-08-21 | 311.04 | 3590.61 | 647.99 | |||
| SO50270_4 | A828-45A2-8B | PO18676112371 | 100 | 282 | 401 | 697 | 1 | 2023-08-26 | 262.41 | 6.56 | 2023-08-14 | 4 | 48.55 | 1 | 262.41 | 4 | SO50270 | 2023-08-21 | 20.99 | 194.18 | 65.60 | |||
| SO50270_5 | A828-45A2-8B | PO18676112371 | 100 | 282 | 352 | 697 | 1 | 2023-08-26 | 8699.96 | 217.50 | 2023-08-14 | 7 | 1117.86 | 1 | 8699.96 | 5 | SO50270 | 2023-08-21 | 696.00 | 7824.99 | 1242.85 | |||
| SO50270_6 | A828-45A2-8B | PO18676112371 | 100 | 282 | 399 | 697 | 1 | 2023-08-26 | 168.87 | 4.22 | 2023-08-14 | 5 | 24.99 | 1 | 168.87 | 6 | SO50270 | 2023-08-21 | 13.51 | 124.97 | 33.77 | |||
| SO50270_7 | A828-45A2-8B | PO18676112371 | 100 | 282 | 410 | 697 | 1 | 2023-08-26 | 182.24 | 4.56 | 2023-08-14 | 5 | 26.97 | 1 | 182.24 | 7 | SO50270 | 2023-08-21 | 14.58 | 134.85 | 36.45 | |||
| SO50270_8 | A828-45A2-8B | PO18676112371 | 100 | 282 | 468 | 697 | 1 | 2023-08-26 | 68.38 | 1.71 | 2023-08-14 | 3 | 15.67 | 1 | 68.38 | 8 | SO50270 | 2023-08-21 | 5.47 | 47.01 | 22.79 | |||
| SO50270_9 | A828-45A2-8B | PO18676112371 | 100 | 282 | 428 | 697 | 1 | 2023-08-26 | 1255.54 | 31.39 | 2023-08-14 | 6 | 185.82 | 1 | 1255.54 | 9 | SO50270 | 2023-08-21 | 100.44 | 1114.92 | 209.26 | |||
| SO50270_10 | A828-45A2-8B | PO18676112371 | 100 | 282 | 409 | 697 | 1 | 2023-08-26 | 418.51 | 10.46 | 2023-08-14 | 2 | 185.82 | 1 | 418.51 | 10 | SO50270 | 2023-08-21 | 33.48 | 371.64 | 209.26 | |||
| SO50270_11 | A828-45A2-8B | PO18676112371 | 100 | 282 | 297 | 697 | 1 | 2023-08-26 | 4416.87 | 110.42 | 2023-08-14 | 6 | 653.70 | 1 | 4416.87 | 11 | SO50270 | 2023-08-21 | 353.35 | 3922.18 | 736.15 | |||
| SO50270_12 | A828-45A2-8B | PO18676112371 | 100 | 282 | 308 | 697 | 1 | 2023-08-26 | 2977.09 | 74.43 | 2023-08-14 | 4 | 660.91 | 1 | 2977.09 | 12 | SO50270 | 2023-08-21 | 238.17 | 2643.66 | 744.27 | |||
| SO50270_13 | A828-45A2-8B | PO18676112371 | 100 | 282 | 360 | 697 | 1 | 2023-08-26 | 8606.21 | 215.16 | 2023-08-14 | 7 | 1105.81 | 1 | 8606.21 | 13 | SO50270 | 2023-08-21 | 688.50 | 7740.67 | 1229.46 | |||
| SO50270_14 | A828-45A2-8B | PO18676112371 | 100 | 282 | 358 | 697 | 1 | 2023-08-26 | 4917.84 | 122.95 | 2023-08-14 | 4 | 1105.81 | 1 | 4917.84 | 14 | SO50270 | 2023-08-21 | 393.43 | 4423.24 | 1229.46 | |||
| SO50270_15 | A828-45A2-8B | PO18676112371 | 100 | 282 | 419 | 697 | 1 | 2023-08-26 | 210.59 | 5.26 | 2023-08-14 | 4 | 38.96 | 1 | 210.59 | 15 | SO50270 | 2023-08-21 | 16.85 | 155.84 | 52.65 | |||
| SO50270_16 | A828-45A2-8B | PO18676112371 | 100 | 282 | 356 | 697 | 1 | 2023-08-26 | 3728.56 | 93.21 | 2023-08-14 | 3 | 1117.86 | 1 | 3728.56 | 16 | SO50270 | 2023-08-21 | 298.28 | 3353.57 | 1242.85 | |||
| SO50270_17 | A828-45A2-8B | PO18676112371 | 100 | 282 | 411 | 697 | 1 | 2023-08-26 | 376.25 | 9.41 | 2023-08-14 | 3 | 92.81 | 1 | 376.25 | 17 | SO50270 | 2023-08-21 | 30.10 | 278.42 | 125.42 | |||
| SO50270_18 | A828-45A2-8B | PO18676112371 | 100 | 282 | 364 | 697 | 1 | 2023-08-26 | 5183.95 | 129.60 | 2023-08-14 | 8 | 598.44 | 1 | 5183.95 | 18 | SO50270 | 2023-08-21 | 414.72 | 4787.48 | 647.99 | |||
| SO50270_19 | A828-45A2-8B | PO18676112371 | 100 | 282 | 366 | 697 | 1 | 2023-08-26 | 5183.95 | 129.60 | 2023-08-14 | 8 | 598.44 | 1 | 5183.95 | 19 | SO50270 | 2023-08-21 | 414.72 | 4787.48 | 647.99 | |||
| SO50270_20 | A828-45A2-8B | PO18676112371 | 100 | 282 | 420 | 697 | 1 | 2023-08-26 | 424.85 | 10.62 | 2023-08-14 | 3 | 104.80 | 1 | 424.85 | 20 | SO50270 | 2023-08-21 | 33.99 | 314.39 | 141.62 | |||
| SO50270_21 | A828-45A2-8B | PO18676112371 | 100 | 282 | 362 | 697 | 1 | 2023-08-26 | 6147.29 | 153.68 | 2023-08-14 | 5 | 1105.81 | 1 | 6147.29 | 21 | SO50270 | 2023-08-21 | 491.78 | 5529.05 | 1229.46 | |||
| SO50270_22 | A828-45A2-8B | PO18676112371 | 100 | 282 | 427 | 697 | 1 | 2023-08-26 | 837.02 | 20.93 | 2023-08-14 | 4 | 185.82 | 1 | 837.02 | 22 | SO50270 | 2023-08-21 | 66.96 | 743.28 | 209.26 | |||
| SO50270_23 | A828-45A2-8B | PO18676112371 | 100 | 282 | 469 | 3 | 697 | 1 | 24.03 | 2023-08-26 | 480.57 | 11.41 | 2023-08-14 | 23 | 15.67 | 1 | 456.54 | 23 | SO50270 | 2023-08-21 | 36.52 | 360.43 | 20.89 | 0.05 |
| SO55299_25 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 560 | 110 | 1 | 2024-01-26 | 728.91 | 18.22 | 2024-01-14 | 1 | 755.15 | 1 | 728.91 | 25 | SO55299 | 2024-01-21 | 58.31 | 755.15 | 728.91 | |||
| SO55299_26 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 564 | 110 | 1 | 2024-01-26 | 8582.65 | 214.57 | 2024-01-14 | 6 | 1481.94 | 1 | 8582.65 | 26 | SO55299 | 2024-01-21 | 686.61 | 8891.63 | 1430.44 | |||
| SO55299_27 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 555 | 110 | 1 | 2024-01-26 | 63.90 | 1.60 | 2024-01-14 | 1 | 47.29 | 1 | 63.90 | 27 | SO55299 | 2024-01-21 | 5.11 | 47.29 | 63.90 | |||
| SO55299_28 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 572 | 110 | 1 | 2024-01-26 | 445.41 | 11.14 | 2024-01-14 | 1 | 461.44 | 1 | 445.41 | 28 | SO55299 | 2024-01-21 | 35.63 | 461.44 | 445.41 | |||
| SO55299_29 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 567 | 110 | 1 | 2024-01-26 | 445.41 | 11.14 | 2024-01-14 | 1 | 461.44 | 1 | 445.41 | 29 | SO55299 | 2024-01-21 | 35.63 | 461.44 | 445.41 | |||
| SO55299_30 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 558 | 110 | 1 | 2024-01-26 | 1214.97 | 30.37 | 2024-01-14 | 5 | 179.82 | 1 | 1214.97 | 30 | SO55299 | 2024-01-21 | 97.20 | 899.08 | 242.99 | |||
| SO55299_31 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 554 | 110 | 1 | 2024-01-26 | 164.83 | 4.12 | 2024-01-14 | 3 | 40.66 | 1 | 164.83 | 31 | SO55299 | 2024-01-21 | 13.19 | 121.97 | 54.94 | |||
| SO55299_32 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 552 | 110 | 1 | 2024-01-26 | 164.68 | 4.12 | 2024-01-14 | 3 | 40.62 | 1 | 164.68 | 32 | SO55299 | 2024-01-21 | 13.17 | 121.86 | 54.89 | |||
| SO55299_33 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 578 | 110 | 1 | 2024-01-26 | 4373.46 | 109.34 | 2024-01-14 | 6 | 755.15 | 1 | 4373.46 | 33 | SO55299 | 2024-01-21 | 349.88 | 4530.90 | 728.91 | |||
| SO55299_34 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 568 | 110 | 1 | 2024-01-26 | 890.82 | 22.27 | 2024-01-14 | 2 | 461.44 | 1 | 890.82 | 34 | SO55299 | 2024-01-21 | 71.27 | 922.89 | 445.41 | |||
| SO55299_35 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 585 | 110 | 1 | 2024-01-26 | 1336.23 | 33.41 | 2024-01-14 | 3 | 461.44 | 1 | 1336.23 | 35 | SO55299 | 2024-01-21 | 106.90 | 1384.33 | 445.41 | |||
| SO55299_36 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 566 | 110 | 1 | 2024-01-26 | 890.82 | 22.27 | 2024-01-14 | 2 | 461.44 | 1 | 890.82 | 36 | SO55299 | 2024-01-21 | 71.27 | 922.89 | 445.41 | |||
| SO55318_1 | 70C0-4B27-8F | PO5075167857 | 100 | 289 | 606 | 344 | 1 | 2024-01-26 | 647.99 | 16.20 | 2024-01-14 | 2 | 343.65 | 1 | 647.99 | 1 | SO55318 | 2024-01-21 | 51.84 | 687.30 | 323.99 | |||
| SO55318_2 | 70C0-4B27-8F | PO5075167857 | 100 | 289 | 547 | 344 | 1 | 2024-01-26 | 48.59 | 1.21 | 2024-01-14 | 1 | 35.96 | 1 | 48.59 | 2 | SO55318 | 2024-01-21 | 3.89 | 35.96 | 48.59 | |||
| SO55325_1 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 573 | 451 | 1 | 2024-01-26 | 8582.65 | 214.57 | 2024-01-14 | 6 | 1481.94 | 1 | 8582.65 | 1 | SO55325 | 2024-01-21 | 686.61 | 8891.63 | 1430.44 | |||
| SO55325_2 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 507 | 451 | 1 | 2024-01-26 | 200.05 | 5.00 | 2024-01-14 | 1 | 199.85 | 1 | 200.05 | 2 | SO55325 | 2024-01-21 | 16.00 | 199.85 | 200.05 | |||
| SO55325_3 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 570 | 451 | 1 | 2024-01-26 | 445.41 | 11.14 | 2024-01-14 | 1 | 461.44 | 1 | 445.41 | 3 | SO55325 | 2024-01-21 | 35.63 | 461.44 | 445.41 | |||
| SO55325_4 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 568 | 451 | 1 | 2024-01-26 | 3563.28 | 89.08 | 2024-01-14 | 8 | 461.44 | 1 | 3563.28 | 4 | SO55325 | 2024-01-21 | 285.06 | 3691.56 | 445.41 | |||
| SO55325_5 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 499 | 451 | 1 | 2024-01-26 | 4216.42 | 105.41 | 2024-01-14 | 7 | 601.74 | 1 | 4216.42 | 5 | SO55325 | 2024-01-21 | 337.31 | 4212.21 | 602.35 | |||
| SO55325_6 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 500 | 451 | 1 | 2024-01-26 | 1204.69 | 30.12 | 2024-01-14 | 2 | 601.74 | 1 | 1204.69 | 6 | SO55325 | 2024-01-21 | 96.38 | 1203.49 | 602.35 | |||
| SO55325_7 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 554 | 451 | 1 | 2024-01-26 | 54.94 | 1.37 | 2024-01-14 | 1 | 40.66 | 1 | 54.94 | 7 | SO55325 | 2024-01-21 | 4.40 | 40.66 | 54.94 | |||
| SO55325_8 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 586 | 451 | 1 | 2024-01-26 | 1781.64 | 44.54 | 2024-01-14 | 4 | 461.44 | 1 | 1781.64 | 8 | SO55325 | 2024-01-21 | 142.53 | 1845.78 | 445.41 | |||
| SO55325_9 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 569 | 451 | 1 | 2024-01-26 | 890.82 | 22.27 | 2024-01-14 | 2 | 461.44 | 1 | 890.82 | 9 | SO55325 | 2024-01-21 | 71.27 | 922.89 | 445.41 | |||
| SO55325_10 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 566 | 451 | 1 | 2024-01-26 | 1781.64 | 44.54 | 2024-01-14 | 4 | 461.44 | 1 | 1781.64 | 10 | SO55325 | 2024-01-21 | 142.53 | 1845.78 | 445.41 | |||
| SO55325_11 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 493 | 451 | 1 | 2024-01-26 | 400.10 | 10.00 | 2024-01-14 | 2 | 199.85 | 1 | 400.10 | 11 | SO55325 | 2024-01-21 | 32.01 | 399.70 | 200.05 | |||
| SO55325_12 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 576 | 451 | 1 | 2024-01-26 | 12873.98 | 321.85 | 2024-01-14 | 9 | 1481.94 | 1 | 12873.98 | 12 | SO55325 | 2024-01-21 | 1029.92 | 13337.44 | 1430.44 | |||
| SO55325_13 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 560 | 451 | 1 | 2024-01-26 | 1457.82 | 36.45 | 2024-01-14 | 2 | 755.15 | 1 | 1457.82 | 13 | SO55325 | 2024-01-21 | 116.63 | 1510.30 | 728.91 | |||
| SO55325_14 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 506 | 451 | 1 | 2024-01-26 | 200.05 | 5.00 | 2024-01-14 | 1 | 199.85 | 1 | 200.05 | 14 | SO55325 | 2024-01-21 | 16.00 | 199.85 | 200.05 | |||
| SO55325_15 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 579 | 451 | 1 | 2024-01-26 | 4373.46 | 109.34 | 2024-01-14 | 6 | 755.15 | 1 | 4373.46 | 15 | SO55325 | 2024-01-21 | 349.88 | 4530.90 | 728.91 | |||
| SO55325_16 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 574 | 451 | 1 | 2024-01-26 | 4291.33 | 107.28 | 2024-01-14 | 3 | 1481.94 | 1 | 4291.33 | 16 | SO55325 | 2024-01-21 | 343.31 | 4445.81 | 1430.44 | |||
| SO55325_17 | 2A57-4E18-99 | PO9338115445 | 100 | 293 | 496 | 451 | 1 | 2024-01-26 | 1204.69 | 30.12 | 2024-01-14 | 2 | 601.74 | 1 | 1204.69 | 17 | SO55325 | 2024-01-21 | 96.38 | 1203.49 | 602.35 | |||
| SO57025_1 | 850A-4849-BD | PO16878117767 | 100 | 282 | 594 | 115 | 1 | 2024-02-26 | 338.99 | 8.47 | 2024-02-14 | 1 | 308.22 | 1 | 338.99 | 1 | SO57025 | 2024-02-21 | 27.12 | 308.22 | 338.99 | |||
| SO57026_1 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 465 | 361 | 1 | 2024-02-26 | 29.39 | 0.73 | 2024-02-14 | 2 | 9.16 | 1 | 29.39 | 1 | SO57026 | 2024-02-21 | 2.35 | 18.32 | 14.69 |
Generated 2024-11-13 10:43:34.532 UTC