[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 2097 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47963_3 | 9A95-4541-91 | PO19691179567 | 19 | 291 | 358 | 353 | 6 | 2023-02-23 | 2458.92 | 61.47 | 2023-02-11 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO47963 | 2023-02-18 | 196.71 | 2211.62 | 1229.46 |
SO51791_5 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 382 | 552 | 6 | 2023-11-23 | 2016.88 | 50.42 | 2023-11-11 | 3 | 713.08 | 1 | 2016.88 | 5 | SO51791 | 2023-11-18 | 161.35 | 2139.24 | 672.29 |
SO63177_22 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 562 | 263 | 6 | 2024-05-25 | 4291.33 | 107.28 | 2024-05-13 | 3 | 1481.94 | 1 | 4291.33 | 22 | SO63177 | 2024-05-20 | 343.31 | 4445.81 | 1430.44 |
SO44282_4 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 288 | 442 | 6 | 2022-01-23 | 1445.19 | 36.13 | 2022-01-11 | 2 | 623.84 | 1 | 1445.19 | 4 | SO44282 | 2022-01-18 | 115.62 | 1247.68 | 722.59 |
SO47963_4 | 9A95-4541-91 | PO19691179567 | 19 | 291 | 470 | 353 | 6 | 2023-02-23 | 68.38 | 1.71 | 2023-02-11 | 3 | 15.67 | 1 | 68.38 | 4 | SO47963 | 2023-02-18 | 5.47 | 47.01 | 22.79 |
SO51791_6 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 390 | 552 | 6 | 2023-11-23 | 1344.59 | 33.61 | 2023-11-11 | 2 | 713.08 | 1 | 1344.59 | 6 | SO51791 | 2023-11-18 | 107.57 | 1426.16 | 672.29 |
SO63177_23 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 500 | 263 | 6 | 2024-05-25 | 602.35 | 15.06 | 2024-05-13 | 1 | 601.74 | 1 | 602.35 | 23 | SO63177 | 2024-05-20 | 48.19 | 601.74 | 602.35 |
SO44282_5 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 235 | 442 | 6 | 2022-01-23 | 115.36 | 2.88 | 2022-01-11 | 4 | 31.72 | 1 | 115.36 | 5 | SO44282 | 2022-01-18 | 9.23 | 126.90 | 28.84 |
SO47964_1 | 5CE9-4D75-8F | PO19459187071 | 19 | 291 | 323 | 334 | 6 | 2023-02-23 | 469.79 | 11.74 | 2023-02-11 | 1 | 486.71 | 1 | 469.79 | 1 | SO47964 | 2023-02-18 | 37.58 | 486.71 | 469.79 |
SO51791_7 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 471 | 552 | 6 | 2023-11-23 | 304.80 | 7.62 | 2023-11-11 | 8 | 23.75 | 1 | 304.80 | 7 | SO51791 | 2023-11-18 | 24.38 | 189.99 | 38.10 |
SO63177_24 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 569 | 263 | 6 | 2024-05-25 | 1336.23 | 33.41 | 2024-05-13 | 3 | 461.44 | 1 | 1336.23 | 24 | SO63177 | 2024-05-20 | 106.90 | 1384.33 | 445.41 |
SO44282_6 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 229 | 442 | 6 | 2022-01-23 | 86.52 | 2.16 | 2022-01-11 | 3 | 31.72 | 1 | 86.52 | 6 | SO44282 | 2022-01-18 | 6.92 | 95.17 | 28.84 |
SO47964_2 | 5CE9-4D75-8F | PO19459187071 | 19 | 291 | 448 | 334 | 6 | 2023-02-23 | 71.96 | 1.80 | 2023-02-11 | 6 | 8.25 | 1 | 71.96 | 2 | SO47964 | 2023-02-18 | 5.76 | 49.48 | 11.99 |
SO51791_8 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 483 | 552 | 6 | 2023-11-23 | 576.00 | 14.40 | 2023-11-11 | 8 | 44.88 | 1 | 576.00 | 8 | SO51791 | 2023-11-18 | 46.08 | 359.04 | 72.00 |
SO63177_25 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 465 | 263 | 6 | 2024-05-25 | 88.16 | 2.20 | 2024-05-13 | 6 | 9.16 | 1 | 88.16 | 25 | SO63177 | 2024-05-20 | 7.05 | 54.96 | 14.69 |
SO44282_7 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 212 | 442 | 6 | 2022-01-23 | 40.37 | 1.01 | 2022-01-11 | 2 | 12.03 | 1 | 40.37 | 7 | SO44282 | 2022-01-18 | 3.23 | 24.06 | 20.19 |
SO47964_3 | 5CE9-4D75-8F | PO19459187071 | 19 | 291 | 447 | 334 | 6 | 2023-02-23 | 15.00 | 0.38 | 2023-02-11 | 1 | 10.31 | 1 | 15.00 | 3 | SO47964 | 2023-02-18 | 1.20 | 10.31 | 15.00 |
SO51791_9 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 231 | 552 | 6 | 2023-11-23 | 179.96 | 4.50 | 2023-11-11 | 6 | 38.49 | 1 | 179.96 | 9 | SO51791 | 2023-11-18 | 14.40 | 230.95 | 29.99 |
SO63177_26 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 231 | 263 | 6 | 2024-05-25 | 209.96 | 5.25 | 2024-05-13 | 7 | 38.49 | 1 | 209.96 | 26 | SO63177 | 2024-05-20 | 16.80 | 269.45 | 29.99 |
SO44282_8 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 345 | 442 | 6 | 2022-01-23 | 4079.99 | 102.00 | 2022-01-11 | 2 | 1912.15 | 1 | 4079.99 | 8 | SO44282 | 2022-01-18 | 326.40 | 3824.31 | 2039.99 |
SO47964_4 | 5CE9-4D75-8F | PO19459187071 | 19 | 291 | 414 | 334 | 6 | 2023-02-23 | 596.12 | 14.90 | 2023-02-11 | 4 | 110.28 | 1 | 596.12 | 4 | SO47964 | 2023-02-18 | 47.69 | 441.13 | 149.03 |
SO51791_10 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 222 | 552 | 6 | 2023-11-23 | 125.96 | 3.15 | 2023-11-11 | 6 | 13.09 | 1 | 125.96 | 10 | SO51791 | 2023-11-18 | 10.08 | 78.52 | 20.99 |
SO63178_1 | 63E5-40BB-9E | PO2117138284 | 19 | 284 | 474 | 444 | 6 | 2024-05-25 | 419.94 | 10.50 | 2024-05-13 | 10 | 26.18 | 1 | 419.94 | 1 | SO63178 | 2024-05-20 | 33.60 | 261.76 | 41.99 |
SO44282_9 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 220 | 442 | 6 | 2022-01-23 | 80.75 | 2.02 | 2022-01-11 | 4 | 12.03 | 1 | 80.75 | 9 | SO44282 | 2022-01-18 | 6.46 | 48.11 | 20.19 |
SO47964_5 | 5CE9-4D75-8F | PO19459187071 | 19 | 291 | 368 | 334 | 6 | 2023-02-23 | 1466.01 | 36.65 | 2023-02-11 | 1 | 1518.79 | 1 | 1466.01 | 5 | SO47964 | 2023-02-18 | 117.28 | 1518.79 | 1466.01 |
SO51791_11 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 386 | 552 | 6 | 2023-11-23 | 1344.59 | 33.61 | 2023-11-11 | 2 | 713.08 | 1 | 1344.59 | 11 | SO51791 | 2023-11-18 | 107.57 | 1426.16 | 672.29 |
SO63178_2 | 63E5-40BB-9E | PO2117138284 | 19 | 284 | 476 | 444 | 6 | 2024-05-25 | 41.99 | 1.05 | 2024-05-13 | 1 | 26.18 | 1 | 41.99 | 2 | SO63178 | 2024-05-20 | 3.36 | 26.18 | 41.99 |
SO44282_10 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 299 | 442 | 6 | 2022-01-23 | 809.76 | 20.24 | 2022-01-11 | 1 | 699.09 | 1 | 809.76 | 10 | SO44282 | 2022-01-18 | 64.78 | 699.09 | 809.76 |
Generated 2024-11-11 01:23:23.550 UTC