[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 6156 > < TAKE 28 >
28 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO51095_5 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 287 | 383 | 4 | 2023-10-27 | 202.33 | 5.06 | 2023-10-15 | 1 | 204.63 | 1 | 202.33 | 5 | SO51095 | 2023-10-22 | 16.19 | 204.63 | 202.33 | |||
| SO58975_5 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 559 | 187 | 4 | 2024-03-28 | 85.01 | 2.13 | 2024-03-16 | 7 | 8.99 | 1 | 85.01 | 5 | SO58975 | 2024-03-23 | 6.80 | 62.91 | 12.14 | |||
| SO46625_39 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 396 | 475 | 4 | 2022-10-27 | 149.68 | 3.74 | 2022-10-15 | 2 | 55.38 | 1 | 149.68 | 39 | SO46625 | 2022-10-22 | 11.97 | 110.76 | 74.84 | |||
| SO51095_6 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 482 | 383 | 4 | 2023-10-27 | 48.55 | 1.21 | 2023-10-15 | 9 | 3.36 | 1 | 48.55 | 6 | SO51095 | 2023-10-22 | 3.88 | 30.26 | 5.39 | |||
| SO58975_6 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 556 | 187 | 4 | 2024-03-28 | 105.29 | 2.63 | 2024-03-16 | 1 | 77.92 | 1 | 105.29 | 6 | SO58975 | 2024-03-23 | 8.42 | 77.92 | 105.29 | |||
| SO46625_40 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 454 | 475 | 4 | 2022-10-27 | 35.99 | 0.90 | 2022-10-15 | 1 | 24.75 | 1 | 35.99 | 40 | SO46625 | 2022-10-22 | 2.88 | 24.75 | 35.99 | |||
| SO51099_1 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 559 | 95 | 4 | 2023-10-27 | 12.14 | 0.30 | 2023-10-15 | 1 | 8.99 | 1 | 12.14 | 1 | SO51099 | 2023-10-22 | 0.97 | 8.99 | 12.14 | |||
| SO58975_7 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 501 | 187 | 4 | 2024-03-28 | 145.75 | 3.64 | 2024-03-16 | 2 | 53.93 | 1 | 145.75 | 7 | SO58975 | 2024-03-23 | 11.66 | 107.86 | 72.88 | |||
| SO46625_41 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 393 | 475 | 4 | 2022-10-27 | 275.39 | 6.88 | 2022-10-15 | 2 | 101.89 | 1 | 275.39 | 41 | SO46625 | 2022-10-22 | 22.03 | 203.79 | 137.69 | |||
| SO51099_2 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 572 | 13 | 95 | 4 | 50.11 | 2023-10-27 | 334.06 | 7.10 | 2023-10-15 | 1 | 461.44 | 1 | 283.95 | 2 | SO51099 | 2023-10-22 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO58975_8 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 551 | 187 | 4 | 2024-03-28 | 475.29 | 11.88 | 2024-03-16 | 3 | 144.59 | 1 | 475.29 | 8 | SO58975 | 2024-03-23 | 38.02 | 433.78 | 158.43 | |||
| SO46625_42 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 421 | 475 | 4 | 2022-10-27 | 785.32 | 19.63 | 2022-10-15 | 4 | 145.28 | 1 | 785.32 | 42 | SO46625 | 2022-10-22 | 62.83 | 581.13 | 196.33 | |||
| SO51099_3 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 560 | 95 | 4 | 2023-10-27 | 1457.82 | 36.45 | 2023-10-15 | 2 | 755.15 | 1 | 1457.82 | 3 | SO51099 | 2023-10-22 | 116.63 | 1510.30 | 728.91 | |||
| SO58975_9 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 531 | 187 | 4 | 2024-03-28 | 149.87 | 3.75 | 2024-03-16 | 1 | 136.79 | 1 | 149.87 | 9 | SO58975 | 2024-03-23 | 11.99 | 136.79 | 149.87 | |||
| SO46625_43 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 236 | 2 | 475 | 4 | 6.13 | 2022-10-27 | 306.67 | 7.51 | 2022-10-15 | 11 | 29.08 | 1 | 300.54 | 43 | SO46625 | 2022-10-22 | 24.04 | 319.89 | 27.88 | 0.02 |
| SO51099_4 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 561 | 14 | 95 | 4 | 190.73 | 2023-10-27 | 953.63 | 19.07 | 2023-10-15 | 1 | 1481.94 | 1 | 762.90 | 4 | SO51099 | 2023-10-22 | 61.03 | 1481.94 | 953.63 | 0.20 |
| SO58975_10 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 475 | 187 | 4 | 2024-03-28 | 125.98 | 3.15 | 2024-03-16 | 3 | 26.18 | 1 | 125.98 | 10 | SO58975 | 2024-03-23 | 10.08 | 78.53 | 41.99 | |||
| SO46625_44 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 289 | 475 | 4 | 2022-10-27 | 744.27 | 18.61 | 2022-10-15 | 1 | 660.91 | 1 | 744.27 | 44 | SO46625 | 2022-10-22 | 59.54 | 660.91 | 744.27 | |||
| SO51099_5 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 555 | 95 | 4 | 2023-10-27 | 63.90 | 1.60 | 2023-10-15 | 1 | 47.29 | 1 | 63.90 | 5 | SO51099 | 2023-10-22 | 5.11 | 47.29 | 63.90 | |||
| SO58975_11 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 592 | 187 | 4 | 2024-03-28 | 338.99 | 8.47 | 2024-03-16 | 1 | 308.22 | 1 | 338.99 | 11 | SO58975 | 2024-03-23 | 27.12 | 308.22 | 338.99 | |||
| SO46625_45 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 456 | 475 | 4 | 2022-10-27 | 224.97 | 5.62 | 2022-10-15 | 5 | 30.93 | 1 | 224.97 | 45 | SO46625 | 2022-10-22 | 18.00 | 154.67 | 44.99 | |||
| SO51099_6 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 603 | 95 | 4 | 2023-10-27 | 145.79 | 3.64 | 2023-10-15 | 2 | 53.94 | 1 | 145.79 | 6 | SO51099 | 2023-10-22 | 11.66 | 107.88 | 72.89 | |||
| SO58975_12 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 309 | 187 | 4 | 2024-03-28 | 818.70 | 20.47 | 2024-03-16 | 1 | 747.20 | 1 | 818.70 | 12 | SO58975 | 2024-03-23 | 65.50 | 747.20 | 818.70 | |||
| SO46625_46 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 461 | 475 | 4 | 2022-10-27 | 215.98 | 5.40 | 2022-10-15 | 4 | 37.12 | 1 | 215.98 | 46 | SO46625 | 2022-10-22 | 17.28 | 148.48 | 53.99 | |||
| SO51099_7 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 568 | 13 | 95 | 4 | 50.11 | 2023-10-27 | 334.06 | 7.10 | 2023-10-15 | 1 | 461.44 | 1 | 283.95 | 7 | SO51099 | 2023-10-22 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO58975_13 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 361 | 187 | 4 | 2024-03-28 | 8261.96 | 206.55 | 2024-03-16 | 6 | 1251.98 | 1 | 8261.96 | 13 | SO58975 | 2024-03-23 | 660.96 | 7511.89 | 1376.99 | |||
| SO46625_47 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 362 | 475 | 4 | 2022-10-27 | 1229.46 | 30.74 | 2022-10-15 | 1 | 1105.81 | 1 | 1229.46 | 47 | SO46625 | 2022-10-22 | 98.36 | 1105.81 | 1229.46 | |||
| SO51099_8 | FF5E-417D-8D | PO13833111492 | 100 | 287 | 564 | 14 | 95 | 4 | 381.45 | 2023-10-27 | 1907.26 | 38.15 | 2023-10-15 | 2 | 1481.94 | 1 | 1525.80 | 8 | SO51099 | 2023-10-22 | 122.06 | 2963.88 | 953.63 | 0.20 |
Generated 2024-11-14 05:25:11.632 UTC