[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 2340 > < TAKE 48 >
48 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO45043_7 | 5114-4658-8F | PO16588117521 | 100 | 289 | 232 | 146 | 1 | 2022-04-25 | 28.84 | 0.72 | 2022-04-13 | 1 | 31.72 | 1 | 28.84 | 7 | SO45043 | 2022-04-20 | 2.31 | 31.72 | 28.84 | |||
| SO48328_12 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 420 | 293 | 1 | 2023-03-25 | 283.23 | 7.08 | 2023-03-13 | 2 | 104.80 | 1 | 283.23 | 12 | SO48328 | 2023-03-20 | 22.66 | 209.59 | 141.62 | |||
| SO51789_39 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 477 | 605 | 1 | 2023-11-23 | 23.95 | 0.60 | 2023-11-11 | 8 | 1.87 | 1 | 23.95 | 39 | SO51789 | 2023-11-18 | 1.92 | 14.93 | 2.99 | |||
| SO63156_16 | B5C5-474E-8D | PO14587116412 | 100 | 293 | 565 | 199 | 1 | 2024-05-25 | 445.41 | 11.14 | 2024-05-13 | 1 | 461.44 | 1 | 445.41 | 16 | SO63156 | 2024-05-20 | 35.63 | 461.44 | 445.41 | |||
| SO45043_8 | 5114-4658-8F | PO16588117521 | 100 | 289 | 344 | 146 | 1 | 2022-04-25 | 4079.99 | 102.00 | 2022-04-13 | 2 | 1912.15 | 1 | 4079.99 | 8 | SO45043 | 2022-04-20 | 326.40 | 3824.31 | 2039.99 | |||
| SO48328_13 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 410 | 293 | 1 | 2023-03-25 | 109.34 | 2.73 | 2023-03-13 | 3 | 26.97 | 1 | 109.34 | 13 | SO48328 | 2023-03-20 | 8.75 | 80.91 | 36.45 | |||
| SO51789_40 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 225 | 605 | 1 | 2023-11-23 | 48.55 | 1.21 | 2023-11-11 | 9 | 6.92 | 1 | 48.55 | 40 | SO51789 | 2023-11-18 | 3.88 | 62.30 | 5.39 | |||
| SO63156_17 | B5C5-474E-8D | PO14587116412 | 100 | 293 | 572 | 199 | 1 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 17 | SO63156 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
| SO45049_1 | 9952-4AC1-92 | PO13978117499 | 100 | 289 | 215 | 200 | 1 | 2022-04-25 | 20.19 | 0.50 | 2022-04-13 | 1 | 12.03 | 1 | 20.19 | 1 | SO45049 | 2022-04-20 | 1.61 | 12.03 | 20.19 | |||
| SO48328_14 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 358 | 293 | 1 | 2023-03-25 | 1229.46 | 30.74 | 2023-03-13 | 1 | 1105.81 | 1 | 1229.46 | 14 | SO48328 | 2023-03-20 | 98.36 | 1105.81 | 1229.46 | |||
| SO51789_41 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 490 | 605 | 1 | 2023-11-23 | 291.55 | 7.29 | 2023-11-11 | 9 | 41.57 | 1 | 291.55 | 41 | SO51789 | 2023-11-18 | 23.32 | 374.15 | 32.39 | |||
| SO63156_18 | B5C5-474E-8D | PO14587116412 | 100 | 293 | 496 | 199 | 1 | 2024-05-25 | 602.35 | 15.06 | 2024-05-13 | 1 | 601.74 | 1 | 602.35 | 18 | SO63156 | 2024-05-20 | 48.19 | 601.74 | 602.35 | |||
| SO45049_2 | 9952-4AC1-92 | PO13978117499 | 100 | 289 | 270 | 200 | 1 | 2022-04-25 | 367.88 | 9.20 | 2022-04-13 | 2 | 181.49 | 1 | 367.88 | 2 | SO45049 | 2022-04-20 | 29.43 | 362.97 | 183.94 | |||
| SO48328_15 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 470 | 293 | 1 | 2023-03-25 | 68.38 | 1.71 | 2023-03-13 | 3 | 15.67 | 1 | 68.38 | 15 | SO48328 | 2023-03-20 | 5.47 | 47.01 | 22.79 | |||
| SO51789_42 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 467 | 605 | 1 | 2023-11-23 | 73.47 | 1.84 | 2023-11-11 | 5 | 9.16 | 1 | 73.47 | 42 | SO51789 | 2023-11-18 | 5.88 | 45.80 | 14.69 | |||
| SO63157_1 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 363 | 650 | 1 | 2024-05-25 | 8261.96 | 206.55 | 2024-05-13 | 6 | 1251.98 | 1 | 8261.96 | 1 | SO63157 | 2024-05-20 | 660.96 | 7511.89 | 1376.99 | |||
| SO45049_3 | 9952-4AC1-92 | PO13978117499 | 100 | 289 | 334 | 200 | 1 | 2022-04-25 | 419.46 | 10.49 | 2022-04-13 | 1 | 413.15 | 1 | 419.46 | 3 | SO45049 | 2022-04-20 | 33.56 | 413.15 | 419.46 | |||
| SO48328_16 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 365 | 293 | 1 | 2023-03-25 | 3239.97 | 81.00 | 2023-03-13 | 5 | 598.44 | 1 | 3239.97 | 16 | SO48328 | 2023-03-20 | 259.20 | 2992.18 | 647.99 | |||
| SO51789_43 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 503 | 605 | 1 | 2023-11-23 | 400.10 | 10.00 | 2023-11-11 | 2 | 199.85 | 1 | 400.10 | 43 | SO51789 | 2023-11-18 | 32.01 | 399.70 | 200.05 | |||
| SO63157_2 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 359 | 650 | 1 | 2024-05-25 | 1376.99 | 34.42 | 2024-05-13 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO63157 | 2024-05-20 | 110.16 | 1251.98 | 1376.99 | |||
| SO45049_4 | 9952-4AC1-92 | PO13978117499 | 100 | 289 | 262 | 200 | 1 | 2022-04-25 | 551.81 | 13.80 | 2022-04-13 | 3 | 181.49 | 1 | 551.81 | 4 | SO45049 | 2022-04-20 | 44.15 | 544.46 | 183.94 | |||
| SO48328_17 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 397 | 293 | 1 | 2023-03-25 | 24.29 | 0.61 | 2023-03-13 | 1 | 17.98 | 1 | 24.29 | 17 | SO48328 | 2023-03-20 | 1.94 | 17.98 | 24.29 | |||
| SO51789_44 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 577 | 605 | 1 | 2023-11-23 | 3644.55 | 91.11 | 2023-11-11 | 5 | 755.15 | 1 | 3644.55 | 44 | SO51789 | 2023-11-18 | 291.56 | 3775.75 | 728.91 | |||
| SO63157_3 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 222 | 650 | 1 | 2024-05-25 | 83.98 | 2.10 | 2024-05-13 | 4 | 13.09 | 1 | 83.98 | 3 | SO63157 | 2024-05-20 | 6.72 | 52.35 | 20.99 | |||
| SO45049_5 | 9952-4AC1-92 | PO13978117499 | 100 | 289 | 220 | 200 | 1 | 2022-04-25 | 20.19 | 0.50 | 2022-04-13 | 1 | 12.03 | 1 | 20.19 | 5 | SO45049 | 2022-04-20 | 1.61 | 12.03 | 20.19 | |||
| SO48328_18 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 308 | 293 | 1 | 2023-03-25 | 744.27 | 18.61 | 2023-03-13 | 1 | 660.91 | 1 | 744.27 | 18 | SO48328 | 2023-03-20 | 59.54 | 660.91 | 744.27 | |||
| SO51789_45 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 495 | 605 | 1 | 2023-11-23 | 602.35 | 15.06 | 2023-11-11 | 1 | 601.74 | 1 | 602.35 | 45 | SO51789 | 2023-11-18 | 48.19 | 601.74 | 602.35 | |||
| SO63157_4 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 477 | 650 | 1 | 2024-05-25 | 11.98 | 0.30 | 2024-05-13 | 4 | 1.87 | 1 | 11.98 | 4 | SO63157 | 2024-05-20 | 0.96 | 7.47 | 2.99 | |||
| SO45050_1 | 00C8-44A6-B1 | PO14123112135 | 100 | 289 | 300 | 578 | 1 | 2022-04-25 | 809.76 | 20.24 | 2022-04-13 | 1 | 699.09 | 1 | 809.76 | 1 | SO45050 | 2022-04-20 | 64.78 | 699.09 | 809.76 | |||
| SO48328_19 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 354 | 293 | 1 | 2023-03-25 | 4971.41 | 124.29 | 2023-03-13 | 4 | 1117.86 | 1 | 4971.41 | 19 | SO48328 | 2023-03-20 | 397.71 | 4471.42 | 1242.85 | |||
| SO51789_46 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 562 | 14 | 605 | 1 | 381.45 | 2023-11-23 | 1907.26 | 38.15 | 2023-11-11 | 2 | 1481.94 | 1 | 1525.80 | 46 | SO51789 | 2023-11-18 | 122.06 | 2963.88 | 953.63 | 0.20 |
| SO63157_5 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 488 | 650 | 1 | 2024-05-25 | 129.58 | 3.24 | 2024-05-13 | 4 | 41.57 | 1 | 129.58 | 5 | SO63157 | 2024-05-20 | 10.37 | 166.29 | 32.39 | |||
| SO45050_2 | 00C8-44A6-B1 | PO14123112135 | 100 | 289 | 293 | 578 | 1 | 2022-04-25 | 1445.19 | 36.13 | 2022-04-13 | 2 | 623.84 | 1 | 1445.19 | 2 | SO45050 | 2022-04-20 | 115.62 | 1247.68 | 722.59 | |||
| SO48328_20 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 305 | 293 | 1 | 2023-03-25 | 736.15 | 18.40 | 2023-03-13 | 1 | 653.70 | 1 | 736.15 | 20 | SO48328 | 2023-03-20 | 58.89 | 653.70 | 736.15 | |||
| SO51792_1 | B327-401F-9A | PO18908126183 | 100 | 289 | 290 | 164 | 1 | 2023-11-23 | 818.70 | 20.47 | 2023-11-11 | 1 | 747.20 | 1 | 818.70 | 1 | SO51792 | 2023-11-18 | 65.50 | 747.20 | 818.70 | |||
| SO63157_6 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 532 | 650 | 1 | 2024-05-25 | 899.24 | 22.48 | 2024-05-13 | 6 | 136.79 | 1 | 899.24 | 6 | SO63157 | 2024-05-20 | 71.94 | 820.71 | 149.87 | |||
| SO45050_3 | 00C8-44A6-B1 | PO14123112135 | 100 | 289 | 344 | 578 | 1 | 2022-04-25 | 2039.99 | 51.00 | 2022-04-13 | 1 | 1912.15 | 1 | 2039.99 | 3 | SO45050 | 2022-04-20 | 163.20 | 1912.15 | 2039.99 | |||
| SO48328_21 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 393 | 293 | 1 | 2023-03-25 | 275.39 | 6.88 | 2023-03-13 | 2 | 101.89 | 1 | 275.39 | 21 | SO48328 | 2023-03-20 | 22.03 | 203.79 | 137.69 | |||
| SO51797_1 | 801F-408E-93 | PO16907168167 | 100 | 293 | 517 | 217 | 1 | 2023-11-23 | 31.58 | 0.79 | 2023-11-11 | 1 | 23.37 | 1 | 31.58 | 1 | SO51797 | 2023-11-18 | 2.53 | 23.37 | 31.58 | |||
| SO63157_7 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 524 | 650 | 1 | 2024-05-25 | 1109.01 | 27.73 | 2024-05-13 | 7 | 144.59 | 1 | 1109.01 | 7 | SO63157 | 2024-05-20 | 88.72 | 1012.16 | 158.43 | |||
| SO45064_1 | 2DCA-4F00-94 | PO2552154948 | 100 | 289 | 350 | 506 | 1 | 2022-04-25 | 4049.99 | 101.25 | 2022-04-13 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45064 | 2022-04-20 | 324.00 | 3796.19 | 2024.99 | |||
| SO48328_22 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 294 | 293 | 1 | 2023-03-25 | 744.27 | 18.61 | 2023-03-13 | 1 | 660.91 | 1 | 744.27 | 22 | SO48328 | 2023-03-20 | 59.54 | 660.91 | 744.27 | |||
| SO51800_1 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 400 | 307 | 1 | 2023-11-23 | 37.15 | 0.93 | 2023-11-11 | 1 | 27.49 | 1 | 37.15 | 1 | SO51800 | 2023-11-18 | 2.97 | 27.49 | 37.15 | |||
| SO63157_8 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 511 | 650 | 1 | 2024-05-25 | 436.91 | 10.92 | 2024-05-13 | 2 | 199.38 | 1 | 436.91 | 8 | SO63157 | 2024-05-20 | 34.95 | 398.75 | 218.45 | |||
| SO45064_2 | 2DCA-4F00-94 | PO2552154948 | 100 | 289 | 218 | 506 | 1 | 2022-04-25 | 22.80 | 0.57 | 2022-04-13 | 4 | 3.40 | 1 | 22.80 | 2 | SO45064 | 2022-04-20 | 1.82 | 13.59 | 5.70 | |||
| SO48347_1 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 367 | 254 | 1 | 2023-03-25 | 647.99 | 16.20 | 2023-03-13 | 1 | 598.44 | 1 | 647.99 | 1 | SO48347 | 2023-03-20 | 51.84 | 598.44 | 647.99 | |||
| SO51800_2 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 476 | 307 | 1 | 2023-11-23 | 125.98 | 3.15 | 2023-11-11 | 3 | 26.18 | 1 | 125.98 | 2 | SO51800 | 2023-11-18 | 10.08 | 78.53 | 41.99 | |||
| SO63157_9 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 465 | 650 | 1 | 2024-05-25 | 102.86 | 2.57 | 2024-05-13 | 7 | 9.16 | 1 | 102.86 | 9 | SO63157 | 2024-05-20 | 8.23 | 64.12 | 14.69 |
Generated 2024-11-11 03:46:39.223 UTC