[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 3148 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57119_10 | 588B-4457-8A | PO3712174757 | 100 | 292 | 572 | 662 | 7 | 2024-02-27 | 890.82 | 22.27 | 2024-02-15 | 2 | 461.44 | 1 | 890.82 | 10 | SO57119 | 2024-02-22 | 71.27 | 922.89 | 445.41 |
SO50253_1 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 391 | 535 | 7 | 2023-08-27 | 266.80 | 6.67 | 2023-08-15 | 3 | 65.81 | 1 | 266.80 | 1 | SO50253 | 2023-08-22 | 21.34 | 197.43 | 88.93 |
SO57119_11 | 588B-4457-8A | PO3712174757 | 100 | 292 | 579 | 662 | 7 | 2024-02-27 | 728.91 | 18.22 | 2024-02-15 | 1 | 755.15 | 1 | 728.91 | 11 | SO57119 | 2024-02-22 | 58.31 | 755.15 | 728.91 |
SO50253_2 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 466 | 535 | 7 | 2023-08-27 | 28.26 | 0.71 | 2023-08-15 | 2 | 9.71 | 1 | 28.26 | 2 | SO50253 | 2023-08-22 | 2.26 | 19.43 | 14.13 |
SO57119_12 | 588B-4457-8A | PO3712174757 | 100 | 292 | 555 | 662 | 7 | 2024-02-27 | 63.90 | 1.60 | 2024-02-15 | 1 | 47.29 | 1 | 63.90 | 12 | SO57119 | 2024-02-22 | 5.11 | 47.29 | 63.90 |
SO50253_3 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 360 | 535 | 7 | 2023-08-27 | 1229.46 | 30.74 | 2023-08-15 | 1 | 1105.81 | 1 | 1229.46 | 3 | SO50253 | 2023-08-22 | 98.36 | 1105.81 | 1229.46 |
SO57119_13 | 588B-4457-8A | PO3712174757 | 100 | 292 | 491 | 662 | 7 | 2024-02-27 | 194.36 | 4.86 | 2024-02-15 | 6 | 41.57 | 1 | 194.36 | 13 | SO57119 | 2024-02-22 | 15.55 | 249.43 | 32.39 |
SO50253_4 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 445 | 535 | 7 | 2023-08-27 | 179.97 | 4.50 | 2023-08-15 | 5 | 24.75 | 1 | 179.97 | 4 | SO50253 | 2023-08-22 | 14.40 | 123.73 | 35.99 |
SO57119_14 | 588B-4457-8A | PO3712174757 | 100 | 292 | 564 | 662 | 7 | 2024-02-27 | 2860.88 | 71.52 | 2024-02-15 | 2 | 1481.94 | 1 | 2860.88 | 14 | SO57119 | 2024-02-22 | 228.87 | 2963.88 | 1430.44 |
SO50253_5 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 221 | 535 | 7 | 2023-08-27 | 80.75 | 2.02 | 2023-08-15 | 4 | 13.88 | 1 | 80.75 | 5 | SO50253 | 2023-08-22 | 6.46 | 55.51 | 20.19 |
SO57119_15 | 588B-4457-8A | PO3712174757 | 100 | 292 | 484 | 662 | 7 | 2024-02-27 | 9.54 | 0.24 | 2024-02-15 | 2 | 2.97 | 1 | 9.54 | 15 | SO57119 | 2024-02-22 | 0.76 | 5.95 | 4.77 |
SO50253_6 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 461 | 535 | 7 | 2023-08-27 | 53.99 | 1.35 | 2023-08-15 | 1 | 37.12 | 1 | 53.99 | 6 | SO50253 | 2023-08-22 | 4.32 | 37.12 | 53.99 |
SO57143_1 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 569 | 193 | 7 | 2024-02-27 | 890.82 | 22.27 | 2024-02-15 | 2 | 461.44 | 1 | 890.82 | 1 | SO57143 | 2024-02-22 | 71.27 | 922.89 | 445.41 |
SO50253_7 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 458 | 535 | 7 | 2023-08-27 | 44.99 | 1.12 | 2023-08-15 | 1 | 30.93 | 1 | 44.99 | 7 | SO50253 | 2023-08-22 | 3.60 | 30.93 | 44.99 |
SO57143_2 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 499 | 193 | 7 | 2024-02-27 | 6023.46 | 150.59 | 2024-02-15 | 10 | 601.74 | 1 | 6023.46 | 2 | SO57143 | 2024-02-22 | 481.88 | 6017.44 | 602.35 |
SO50253_8 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 457 | 535 | 7 | 2023-08-27 | 44.99 | 1.12 | 2023-08-15 | 1 | 30.93 | 1 | 44.99 | 8 | SO50253 | 2023-08-22 | 3.60 | 30.93 | 44.99 |
SO57143_3 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 493 | 193 | 7 | 2024-02-27 | 1200.31 | 30.01 | 2024-02-15 | 6 | 199.85 | 1 | 1200.31 | 3 | SO57143 | 2024-02-22 | 96.03 | 1199.11 | 200.05 |
SO50253_9 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 364 | 535 | 7 | 2023-08-27 | 1943.98 | 48.60 | 2023-08-15 | 3 | 598.44 | 1 | 1943.98 | 9 | SO50253 | 2023-08-22 | 155.52 | 1795.31 | 647.99 |
SO57143_4 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 497 | 193 | 7 | 2024-02-27 | 1204.69 | 30.12 | 2024-02-15 | 2 | 601.74 | 1 | 1204.69 | 4 | SO57143 | 2024-02-22 | 96.38 | 1203.49 | 602.35 |
SO50253_10 | 8515-49B2-9B | PO2668111591 | 100 | 292 | 454 | 535 | 7 | 2023-08-27 | 143.98 | 3.60 | 2023-08-15 | 4 | 24.75 | 1 | 143.98 | 10 | SO50253 | 2023-08-22 | 11.52 | 98.98 | 35.99 |
SO57143_5 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 568 | 193 | 7 | 2024-02-27 | 1336.23 | 33.41 | 2024-02-15 | 3 | 461.44 | 1 | 1336.23 | 5 | SO57143 | 2024-02-22 | 106.90 | 1384.33 | 445.41 |
SO50318_1 | 4FB3-4BB2-BC | PO8323117752 | 100 | 292 | 267 | 211 | 7 | 2023-08-27 | 202.33 | 5.06 | 2023-08-15 | 1 | 187.16 | 1 | 202.33 | 1 | SO50318 | 2023-08-22 | 16.19 | 187.16 | 202.33 |
SO57143_6 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 500 | 193 | 7 | 2024-02-27 | 1204.69 | 30.12 | 2024-02-15 | 2 | 601.74 | 1 | 1204.69 | 6 | SO57143 | 2024-02-22 | 96.38 | 1203.49 | 602.35 |
SO50665_1 | F21E-4880-9E | PO18589183989 | 100 | 292 | 414 | 67 | 7 | 2023-09-27 | 149.03 | 3.73 | 2023-09-15 | 1 | 110.28 | 1 | 149.03 | 1 | SO50665 | 2023-09-22 | 11.92 | 110.28 | 149.03 |
SO57143_7 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 561 | 193 | 7 | 2024-02-27 | 2860.88 | 71.52 | 2024-02-15 | 2 | 1481.94 | 1 | 2860.88 | 7 | SO57143 | 2024-02-22 | 228.87 | 2963.88 | 1430.44 |
SO50665_2 | F21E-4880-9E | PO18589183989 | 100 | 292 | 407 | 67 | 7 | 2023-09-27 | 65.60 | 1.64 | 2023-09-15 | 1 | 48.55 | 1 | 65.60 | 2 | SO50665 | 2023-09-22 | 5.25 | 48.55 | 65.60 |
SO57143_8 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 498 | 193 | 7 | 2024-02-27 | 2409.38 | 60.23 | 2024-02-15 | 4 | 601.74 | 1 | 2409.38 | 8 | SO57143 | 2024-02-22 | 192.75 | 2406.97 | 602.35 |
SO50673_1 | 5E3E-4044-A0 | PO15515116492 | 100 | 292 | 373 | 481 | 7 | 2023-09-27 | 5235.75 | 130.89 | 2023-09-15 | 4 | 1320.68 | 1 | 5235.75 | 1 | SO50673 | 2023-09-22 | 418.86 | 5282.74 | 1308.94 |
SO57143_9 | 69ED-4172-83 | PO3567189986 | 100 | 292 | 586 | 193 | 7 | 2024-02-27 | 2672.46 | 66.81 | 2024-02-15 | 6 | 461.44 | 1 | 2672.46 | 9 | SO57143 | 2024-02-22 | 213.80 | 2768.67 | 445.41 |
SO50673_2 | 5E3E-4044-A0 | PO15515116492 | 100 | 292 | 454 | 481 | 7 | 2023-09-27 | 35.99 | 0.90 | 2023-09-15 | 1 | 24.75 | 1 | 35.99 | 2 | SO50673 | 2023-09-22 | 2.88 | 24.75 | 35.99 |
Generated 2024-11-14 16:57:41.007 UTC