[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 6403 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO69521_22 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 507 | 693 | 1 | 2024-08-23 | 200.05 | 5.00 | 2024-08-11 | 1 | 199.85 | 1 | 200.05 | 22 | SO69521 | 2024-08-18 | 16.00 | 199.85 | 200.05 | |||
| SO69524_1 | B8BC-4D73-8B | PO5162129421 | 100 | 289 | 436 | 669 | 1 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 1 | SO69524 | 2024-08-18 | 28.55 | 360.94 | 356.90 | |||
| SO69524_2 | B8BC-4D73-8B | PO5162129421 | 100 | 289 | 378 | 669 | 1 | 2024-08-23 | 1466.01 | 36.65 | 2024-08-11 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO69524 | 2024-08-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO69524_3 | B8BC-4D73-8B | PO5162129421 | 100 | 289 | 520 | 669 | 1 | 2024-08-23 | 94.75 | 2.37 | 2024-08-11 | 3 | 23.37 | 1 | 94.75 | 3 | SO69524 | 2024-08-18 | 7.58 | 70.12 | 31.58 | |||
| SO69525_1 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 376 | 343 | 1 | 2024-08-23 | 4398.03 | 109.95 | 2024-08-11 | 3 | 1554.95 | 1 | 4398.03 | 1 | SO69525 | 2024-08-18 | 351.84 | 4664.84 | 1466.01 | |||
| SO69525_2 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 378 | 343 | 1 | 2024-08-23 | 1466.01 | 36.65 | 2024-08-11 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO69525 | 2024-08-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO69525_3 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 388 | 343 | 1 | 2024-08-23 | 3361.47 | 84.04 | 2024-08-11 | 5 | 713.08 | 1 | 3361.47 | 3 | SO69525 | 2024-08-18 | 268.92 | 3565.40 | 672.29 | |||
| SO69525_4 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 418 | 343 | 1 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 4 | SO69525 | 2024-08-18 | 28.55 | 360.94 | 356.90 | |||
| SO69525_5 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 382 | 343 | 1 | 2024-08-23 | 2689.18 | 67.23 | 2024-08-11 | 4 | 713.08 | 1 | 2689.18 | 5 | SO69525 | 2024-08-18 | 215.13 | 2852.32 | 672.29 | |||
| SO69525_6 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 386 | 343 | 1 | 2024-08-23 | 1344.59 | 33.61 | 2024-08-11 | 2 | 713.08 | 1 | 1344.59 | 6 | SO69525 | 2024-08-18 | 107.57 | 1426.16 | 672.29 | |||
| SO69525_7 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 390 | 343 | 1 | 2024-08-23 | 672.29 | 16.81 | 2024-08-11 | 1 | 713.08 | 1 | 672.29 | 7 | SO69525 | 2024-08-18 | 53.78 | 713.08 | 672.29 | |||
| SO69525_8 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 580 | 343 | 1 | 2024-08-23 | 3061.78 | 76.54 | 2024-08-11 | 3 | 1082.51 | 1 | 3061.78 | 8 | SO69525 | 2024-08-18 | 244.94 | 3247.53 | 1020.59 | |||
| SO69525_9 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 581 | 343 | 1 | 2024-08-23 | 1020.59 | 25.51 | 2024-08-11 | 1 | 1082.51 | 1 | 1020.59 | 9 | SO69525 | 2024-08-18 | 81.65 | 1082.51 | 1020.59 | |||
| SO69525_10 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 583 | 343 | 1 | 2024-08-23 | 1020.59 | 25.51 | 2024-08-11 | 1 | 1082.51 | 1 | 1020.59 | 10 | SO69525 | 2024-08-18 | 81.65 | 1082.51 | 1020.59 | |||
| SO69525_11 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 374 | 343 | 1 | 2024-08-23 | 1466.01 | 36.65 | 2024-08-11 | 1 | 1554.95 | 1 | 1466.01 | 11 | SO69525 | 2024-08-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO69525_12 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 436 | 343 | 1 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 12 | SO69525 | 2024-08-18 | 28.55 | 360.94 | 356.90 | |||
| SO53518_10 | 5712-444B-BC | PO841197199 | 100 | 286 | 290 | 254 | 1 | 2023-12-24 | 4093.50 | 102.34 | 2023-12-12 | 5 | 747.20 | 1 | 4093.50 | 10 | SO53518 | 2023-12-19 | 327.48 | 3736.00 | 818.70 | |||
| SO53518_11 | 5712-444B-BC | PO841197199 | 100 | 286 | 402 | 254 | 1 | 2023-12-24 | 216.49 | 5.41 | 2023-12-12 | 3 | 53.40 | 1 | 216.49 | 11 | SO53518 | 2023-12-19 | 17.32 | 160.20 | 72.16 | |||
| SO53518_12 | 5712-444B-BC | PO841197199 | 100 | 286 | 516 | 254 | 1 | 2023-12-24 | 234.84 | 5.87 | 2023-12-12 | 10 | 17.38 | 1 | 234.84 | 12 | SO53518 | 2023-12-19 | 18.79 | 173.78 | 23.48 | |||
| SO53518_13 | 5712-444B-BC | PO841197199 | 100 | 286 | 298 | 254 | 1 | 2023-12-24 | 4048.80 | 101.22 | 2023-12-12 | 5 | 739.04 | 1 | 4048.80 | 13 | SO53518 | 2023-12-19 | 323.90 | 3695.21 | 809.76 | |||
| SO53518_14 | 5712-444B-BC | PO841197199 | 100 | 286 | 472 | 254 | 1 | 2023-12-24 | 76.20 | 1.91 | 2023-12-12 | 2 | 23.75 | 1 | 76.20 | 14 | SO53518 | 2023-12-19 | 6.10 | 47.50 | 38.10 | |||
| SO53518_15 | 5712-444B-BC | PO841197199 | 100 | 286 | 593 | 254 | 1 | 2023-12-24 | 1016.98 | 25.42 | 2023-12-12 | 3 | 308.22 | 1 | 1016.98 | 15 | SO53518 | 2023-12-19 | 81.36 | 924.65 | 338.99 | |||
| SO53518_16 | 5712-444B-BC | PO841197199 | 100 | 286 | 559 | 254 | 1 | 2023-12-24 | 72.86 | 1.82 | 2023-12-12 | 6 | 8.99 | 1 | 72.86 | 16 | SO53518 | 2023-12-19 | 5.83 | 53.92 | 12.14 | |||
| SO53518_17 | 5712-444B-BC | PO841197199 | 100 | 286 | 552 | 254 | 1 | 2023-12-24 | 219.58 | 5.49 | 2023-12-12 | 4 | 40.62 | 1 | 219.58 | 17 | SO53518 | 2023-12-19 | 17.57 | 162.49 | 54.89 | |||
| SO53518_18 | 5712-444B-BC | PO841197199 | 100 | 286 | 532 | 2 | 254 | 1 | 31.87 | 2023-12-24 | 1593.66 | 39.04 | 2023-12-12 | 11 | 136.79 | 1 | 1561.79 | 18 | SO53518 | 2023-12-19 | 124.94 | 1504.64 | 144.88 | 0.02 |
| SO53518_19 | 5712-444B-BC | PO841197199 | 100 | 286 | 487 | 254 | 1 | 2023-12-24 | 131.98 | 3.30 | 2023-12-12 | 4 | 20.57 | 1 | 131.98 | 19 | SO53518 | 2023-12-19 | 10.56 | 82.27 | 32.99 | |||
| SO53518_20 | 5712-444B-BC | PO841197199 | 100 | 286 | 603 | 254 | 1 | 2023-12-24 | 728.94 | 18.22 | 2023-12-12 | 10 | 53.94 | 1 | 728.94 | 20 | SO53518 | 2023-12-19 | 58.32 | 539.42 | 72.89 | |||
| SO53518_21 | 5712-444B-BC | PO841197199 | 100 | 286 | 558 | 254 | 1 | 2023-12-24 | 1943.95 | 48.60 | 2023-12-12 | 8 | 179.82 | 1 | 1943.95 | 21 | SO53518 | 2023-12-19 | 155.52 | 1438.52 | 242.99 |
Generated 2024-11-10 22:29:43.123 UTC