[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 539 > < TAKE 24 >
24 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47687_1 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 414 | 203 | 4 | 2022-12-04 | 298.06 | 7.45 | 2022-11-22 | 2 | 110.28 | 1 | 298.06 | 1 | SO47687 | 2022-11-29 | 23.85 | 220.57 | 149.03 |
SO51122_7 | D915-4225-97 | PO551181465 | 100 | 281 | 582 | 4 | 4 | 2023-09-03 | 3061.78 | 76.54 | 2023-08-22 | 3 | 1082.51 | 1 | 3061.78 | 7 | SO51122 | 2023-08-29 | 244.94 | 3247.53 | 1020.59 |
SO58992_1 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 225 | 23 | 4 | 2024-02-03 | 16.18 | 0.40 | 2024-01-22 | 3 | 6.92 | 1 | 16.18 | 1 | SO58992 | 2024-01-29 | 1.29 | 20.77 | 5.39 |
SO43864_5 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 349 | 384 | 4 | 2021-10-04 | 8099.98 | 202.50 | 2021-09-22 | 4 | 1898.09 | 1 | 8099.98 | 5 | SO43864 | 2021-09-29 | 648.00 | 7592.38 | 2024.99 |
SO47687_2 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 381 | 203 | 4 | 2022-12-04 | 3001.31 | 75.03 | 2022-11-22 | 5 | 605.65 | 1 | 3001.31 | 2 | SO47687 | 2022-11-29 | 240.11 | 3028.25 | 600.26 |
SO51122_8 | D915-4225-97 | PO551181465 | 100 | 281 | 374 | 4 | 4 | 2023-09-03 | 4398.03 | 109.95 | 2023-08-22 | 3 | 1554.95 | 1 | 4398.03 | 8 | SO51122 | 2023-08-29 | 351.84 | 4664.84 | 1466.01 |
SO58992_2 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 474 | 23 | 4 | 2024-02-03 | 251.96 | 6.30 | 2024-01-22 | 6 | 26.18 | 1 | 251.96 | 2 | SO58992 | 2024-01-29 | 20.16 | 157.06 | 41.99 |
SO43864_6 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 307 | 384 | 4 | 2021-10-04 | 722.59 | 18.06 | 2021-09-22 | 1 | 623.84 | 1 | 722.59 | 6 | SO43864 | 2021-09-29 | 57.81 | 623.84 | 722.59 |
SO47687_3 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 213 | 203 | 4 | 2022-12-04 | 121.12 | 3.03 | 2022-11-22 | 6 | 13.88 | 1 | 121.12 | 3 | SO47687 | 2022-11-29 | 9.69 | 83.27 | 20.19 |
SO51122_9 | D915-4225-97 | PO551181465 | 100 | 281 | 378 | 4 | 4 | 2023-09-03 | 4398.03 | 109.95 | 2023-08-22 | 3 | 1554.95 | 1 | 4398.03 | 9 | SO51122 | 2023-08-29 | 351.84 | 4664.84 | 1466.01 |
SO58992_3 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 471 | 23 | 4 | 2024-02-03 | 114.30 | 2.86 | 2024-01-22 | 3 | 23.75 | 1 | 114.30 | 3 | SO58992 | 2024-01-29 | 9.14 | 71.25 | 38.10 |
SO43864_7 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 344 | 384 | 4 | 2021-10-04 | 4079.99 | 102.00 | 2021-09-22 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO43864 | 2021-09-29 | 326.40 | 3824.31 | 2039.99 |
SO47687_4 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 456 | 203 | 4 | 2022-12-04 | 314.96 | 7.87 | 2022-11-22 | 7 | 30.93 | 1 | 314.96 | 4 | SO47687 | 2022-11-29 | 25.20 | 216.53 | 44.99 |
SO51122_10 | D915-4225-97 | PO551181465 | 100 | 281 | 372 | 4 | 4 | 2023-09-03 | 2932.02 | 73.30 | 2023-08-22 | 2 | 1554.95 | 1 | 2932.02 | 10 | SO51122 | 2023-08-29 | 234.56 | 3109.90 | 1466.01 |
SO58992_4 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 361 | 23 | 4 | 2024-02-03 | 1376.99 | 34.42 | 2024-01-22 | 1 | 1251.98 | 1 | 1376.99 | 4 | SO58992 | 2024-01-29 | 110.16 | 1251.98 | 1376.99 |
SO43864_8 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 346 | 384 | 4 | 2021-10-04 | 8159.98 | 204.00 | 2021-09-22 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO43864 | 2021-09-29 | 652.80 | 7648.62 | 2039.99 |
SO47687_5 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 286 | 203 | 4 | 2022-12-04 | 183.94 | 4.60 | 2022-11-22 | 1 | 170.14 | 1 | 183.94 | 5 | SO47687 | 2022-11-29 | 14.72 | 170.14 | 183.94 |
SO51122_11 | D915-4225-97 | PO551181465 | 100 | 281 | 418 | 4 | 4 | 2023-09-03 | 713.80 | 17.84 | 2023-08-22 | 2 | 360.94 | 1 | 713.80 | 11 | SO51122 | 2023-08-29 | 57.10 | 721.89 | 356.90 |
SO58992_5 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 477 | 23 | 4 | 2024-02-03 | 14.97 | 0.37 | 2024-01-22 | 5 | 1.87 | 1 | 14.97 | 5 | SO58992 | 2024-01-29 | 1.20 | 9.33 | 2.99 |
SO43864_9 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 300 | 384 | 4 | 2021-10-04 | 809.76 | 20.24 | 2021-09-22 | 1 | 699.09 | 1 | 809.76 | 9 | SO43864 | 2021-09-29 | 64.78 | 699.09 | 809.76 |
SO47687_6 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 448 | 203 | 4 | 2022-12-04 | 23.99 | 0.60 | 2022-11-22 | 2 | 8.25 | 1 | 23.99 | 6 | SO47687 | 2022-11-29 | 1.92 | 16.49 | 11.99 |
SO51122_12 | D915-4225-97 | PO551181465 | 100 | 281 | 545 | 4 | 4 | 2023-09-03 | 170.06 | 4.25 | 2023-08-22 | 7 | 17.98 | 1 | 170.06 | 12 | SO51122 | 2023-08-29 | 13.60 | 125.84 | 24.29 |
SO58992_6 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 476 | 23 | 4 | 2024-02-03 | 251.96 | 6.30 | 2024-01-22 | 6 | 26.18 | 1 | 251.96 | 6 | SO58992 | 2024-01-29 | 20.16 | 157.06 | 41.99 |
SO43865_1 | 071C-4913-89 | PO15689147174 | 100 | 283 | 319 | 328 | 4 | 2021-10-04 | 874.79 | 21.87 | 2021-09-22 | 1 | 884.71 | 1 | 874.79 | 1 | SO43865 | 2021-09-29 | 69.98 | 884.71 | 874.79 |
Generated 2024-09-21 07:23:24.702 UTC