[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 3387 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46612_1 | 8645-4FD3-B4 | PO16443150420 | 100 | 289 | 239 | 398 | 1 | 2022-09-03 | 780.82 | 19.52 | 2022-08-22 | 1 | 722.26 | 1 | 780.82 | 1 | SO46612 | 2022-08-29 | 62.47 | 722.26 | 780.82 |
SO46612_2 | 8645-4FD3-B4 | PO16443150420 | 100 | 289 | 236 | 398 | 1 | 2022-09-03 | 28.84 | 0.72 | 2022-08-22 | 1 | 29.08 | 1 | 28.84 | 2 | SO46612 | 2022-08-29 | 2.31 | 29.08 | 28.84 |
SO46612_3 | 8645-4FD3-B4 | PO16443150420 | 100 | 289 | 242 | 398 | 1 | 2022-09-03 | 780.82 | 19.52 | 2022-08-22 | 1 | 722.26 | 1 | 780.82 | 3 | SO46612 | 2022-08-29 | 62.47 | 722.26 | 780.82 |
SO46612_4 | 8645-4FD3-B4 | PO16443150420 | 100 | 289 | 453 | 398 | 1 | 2022-09-03 | 35.99 | 0.90 | 2022-08-22 | 1 | 24.75 | 1 | 35.99 | 4 | SO46612 | 2022-08-29 | 2.88 | 24.75 | 35.99 |
SO46613_1 | D7EC-42C8-AF | PO15602156182 | 100 | 272 | 352 | 7 | 1 | 2022-09-03 | 1242.85 | 31.07 | 2022-08-22 | 1 | 1117.86 | 1 | 1242.85 | 1 | SO46613 | 2022-08-29 | 99.43 | 1117.86 | 1242.85 |
SO67321_9 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 523 | 505 | 1 | 2024-06-04 | 63.17 | 1.58 | 2024-05-23 | 2 | 23.37 | 1 | 63.17 | 9 | SO67321 | 2024-05-30 | 5.05 | 46.74 | 31.58 |
SO67321_10 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 569 | 505 | 1 | 2024-06-04 | 890.82 | 22.27 | 2024-05-23 | 2 | 461.44 | 1 | 890.82 | 10 | SO67321 | 2024-05-30 | 71.27 | 922.89 | 445.41 |
SO67321_11 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 492 | 505 | 1 | 2024-06-04 | 1807.04 | 45.18 | 2024-05-23 | 3 | 601.74 | 1 | 1807.04 | 11 | SO67321 | 2024-05-30 | 144.56 | 1805.23 | 602.35 |
SO67321_12 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 586 | 505 | 1 | 2024-06-04 | 890.82 | 22.27 | 2024-05-23 | 2 | 461.44 | 1 | 890.82 | 12 | SO67321 | 2024-05-30 | 71.27 | 922.89 | 445.41 |
SO67321_13 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 496 | 505 | 1 | 2024-06-04 | 2409.38 | 60.23 | 2024-05-23 | 4 | 601.74 | 1 | 2409.38 | 13 | SO67321 | 2024-05-30 | 192.75 | 2406.97 | 602.35 |
SO67321_14 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 572 | 505 | 1 | 2024-06-04 | 1336.23 | 33.41 | 2024-05-23 | 3 | 461.44 | 1 | 1336.23 | 14 | SO67321 | 2024-05-30 | 106.90 | 1384.33 | 445.41 |
SO67321_15 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 498 | 505 | 1 | 2024-06-04 | 602.35 | 15.06 | 2024-05-23 | 1 | 601.74 | 1 | 602.35 | 15 | SO67321 | 2024-05-30 | 48.19 | 601.74 | 602.35 |
SO67321_16 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 502 | 505 | 1 | 2024-06-04 | 1000.26 | 25.01 | 2024-05-23 | 5 | 199.85 | 1 | 1000.26 | 16 | SO67321 | 2024-05-30 | 80.02 | 999.26 | 200.05 |
SO67321_17 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 493 | 505 | 1 | 2024-06-04 | 200.05 | 5.00 | 2024-05-23 | 1 | 199.85 | 1 | 200.05 | 17 | SO67321 | 2024-05-30 | 16.00 | 199.85 | 200.05 |
SO67321_18 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 560 | 505 | 1 | 2024-06-04 | 2915.64 | 72.89 | 2024-05-23 | 4 | 755.15 | 1 | 2915.64 | 18 | SO67321 | 2024-05-30 | 233.25 | 3020.60 | 728.91 |
SO67321_19 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 499 | 505 | 1 | 2024-06-04 | 2409.38 | 60.23 | 2024-05-23 | 4 | 601.74 | 1 | 2409.38 | 19 | SO67321 | 2024-05-30 | 192.75 | 2406.97 | 602.35 |
SO67321_20 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 564 | 505 | 1 | 2024-06-04 | 4291.33 | 107.28 | 2024-05-23 | 3 | 1481.94 | 1 | 4291.33 | 20 | SO67321 | 2024-05-30 | 343.31 | 4445.81 | 1430.44 |
SO67321_21 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 562 | 505 | 1 | 2024-06-04 | 7152.21 | 178.81 | 2024-05-23 | 5 | 1481.94 | 1 | 7152.21 | 21 | SO67321 | 2024-05-30 | 572.18 | 7409.69 | 1430.44 |
SO67322_1 | 1881-4634-82 | PO6612121393 | 100 | 286 | 566 | 110 | 1 | 2024-06-04 | 1336.23 | 33.41 | 2024-05-23 | 3 | 461.44 | 1 | 1336.23 | 1 | SO67322 | 2024-05-30 | 106.90 | 1384.33 | 445.41 |
SO67322_2 | 1881-4634-82 | PO6612121393 | 100 | 286 | 496 | 110 | 1 | 2024-06-04 | 602.35 | 15.06 | 2024-05-23 | 1 | 601.74 | 1 | 602.35 | 2 | SO67322 | 2024-05-30 | 48.19 | 601.74 | 602.35 |
SO67322_3 | 1881-4634-82 | PO6612121393 | 100 | 286 | 554 | 110 | 1 | 2024-06-04 | 109.88 | 2.75 | 2024-05-23 | 2 | 40.66 | 1 | 109.88 | 3 | SO67322 | 2024-05-30 | 8.79 | 81.31 | 54.94 |
SO67322_4 | 1881-4634-82 | PO6612121393 | 100 | 286 | 569 | 110 | 1 | 2024-06-04 | 1336.23 | 33.41 | 2024-05-23 | 3 | 461.44 | 1 | 1336.23 | 4 | SO67322 | 2024-05-30 | 106.90 | 1384.33 | 445.41 |
SO67322_5 | 1881-4634-82 | PO6612121393 | 100 | 286 | 501 | 110 | 1 | 2024-06-04 | 145.75 | 3.64 | 2024-05-23 | 2 | 53.93 | 1 | 145.75 | 5 | SO67322 | 2024-05-30 | 11.66 | 107.86 | 72.88 |
SO67322_6 | 1881-4634-82 | PO6612121393 | 100 | 286 | 493 | 110 | 1 | 2024-06-04 | 200.05 | 5.00 | 2024-05-23 | 1 | 199.85 | 1 | 200.05 | 6 | SO67322 | 2024-05-30 | 16.00 | 199.85 | 200.05 |
SO67322_7 | 1881-4634-82 | PO6612121393 | 100 | 286 | 575 | 110 | 1 | 2024-06-04 | 4291.33 | 107.28 | 2024-05-23 | 3 | 1481.94 | 1 | 4291.33 | 7 | SO67322 | 2024-05-30 | 343.31 | 4445.81 | 1430.44 |
SO67322_8 | 1881-4634-82 | PO6612121393 | 100 | 286 | 514 | 110 | 1 | 2024-06-04 | 191.70 | 4.79 | 2024-05-23 | 3 | 47.29 | 1 | 191.70 | 8 | SO67322 | 2024-05-30 | 15.34 | 141.86 | 63.90 |
SO67322_9 | 1881-4634-82 | PO6612121393 | 100 | 286 | 488 | 110 | 1 | 2024-06-04 | 64.79 | 1.62 | 2024-05-23 | 2 | 41.57 | 1 | 64.79 | 9 | SO67322 | 2024-05-30 | 5.18 | 83.14 | 32.39 |
SO67322_10 | 1881-4634-82 | PO6612121393 | 100 | 286 | 585 | 110 | 1 | 2024-06-04 | 1336.23 | 33.41 | 2024-05-23 | 3 | 461.44 | 1 | 1336.23 | 10 | SO67322 | 2024-05-30 | 106.90 | 1384.33 | 445.41 |
Generated 2024-09-21 15:22:28.535 UTC