[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1945 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50756_23 | C414-447C-84 | PO9570119689 | 100 | 285 | 460 | 585 | 5 | 2023-09-25 | 107.99 | 2.70 | 2023-09-13 | 2 | 37.12 | 1 | 107.99 | 23 | SO50756 | 2023-09-20 | 8.64 | 74.24 | 53.99 | |||
SO53586_12 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 490 | 674 | 4 | 2023-12-26 | 32.39 | 0.81 | 2023-12-14 | 1 | 41.57 | 1 | 32.39 | 12 | SO53586 | 2023-12-21 | 2.59 | 41.57 | 32.39 | |||
SO51714_24 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 546 | 328 | 4 | 2023-11-25 | 111.76 | 2.79 | 2023-11-13 | 3 | 27.57 | 1 | 111.76 | 24 | SO51714 | 2023-11-20 | 8.94 | 82.70 | 37.25 | |||
SO49070_1 | 2B81-47B6-AD | PO1827112158 | 19 | 291 | 368 | 317 | 6 | 2023-05-28 | 1466.01 | 36.65 | 2023-05-16 | 1 | 1518.79 | 1 | 1466.01 | 1 | SO49070 | 2023-05-23 | 117.28 | 1518.79 | 1466.01 | |||
SO61228_20 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 584 | 81 | 5 | 2024-04-26 | 323.99 | 8.10 | 2024-04-14 | 1 | 343.65 | 1 | 323.99 | 20 | SO61228 | 2024-04-21 | 25.92 | 343.65 | 323.99 | |||
SO53458_30 | 0728-4E88-9F | PO19285149036 | 98 | 288 | 523 | 448 | 10 | 2023-12-26 | 126.34 | 3.16 | 2023-12-14 | 4 | 23.37 | 1 | 126.34 | 30 | SO53458 | 2023-12-21 | 10.11 | 93.49 | 31.58 | |||
SO46672_13 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 461 | 81 | 5 | 2022-10-25 | 215.98 | 5.40 | 2022-10-13 | 4 | 37.12 | 1 | 215.98 | 13 | SO46672 | 2022-10-20 | 17.28 | 148.48 | 53.99 | |||
SO51817_1 | 244D-4F94-89 | PO8149119969 | 36 | 295 | 380 | 615 | 8 | 2023-11-25 | 1466.01 | 36.65 | 2023-11-13 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO51817 | 2023-11-20 | 117.28 | 1554.95 | 1466.01 | |||
SO46662_6 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 373 | 660 | 3 | 2022-10-25 | 3926.81 | 98.17 | 2022-10-13 | 3 | 1320.68 | 1 | 3926.81 | 6 | SO46662 | 2022-10-20 | 314.15 | 3962.05 | 1308.94 | |||
SO67263_27 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 532 | 125 | 2 | 2024-07-26 | 449.62 | 11.24 | 2024-07-14 | 3 | 136.79 | 1 | 449.62 | 27 | SO67263 | 2024-07-21 | 35.97 | 410.36 | 149.87 | |||
SO63171_6 | 6618-4F16-BE | PO580178064 | 36 | 295 | 496 | 230 | 8 | 2024-05-27 | 1204.69 | 30.12 | 2024-05-15 | 2 | 601.74 | 1 | 1204.69 | 6 | SO63171 | 2024-05-22 | 96.38 | 1203.49 | 602.35 | |||
SO46993_16 | F652-4085-A4 | PO11658111433 | 100 | 272 | 308 | 233 | 2 | 2022-11-25 | 4465.64 | 111.64 | 2022-11-13 | 6 | 660.91 | 1 | 4465.64 | 16 | SO46993 | 2022-11-20 | 357.25 | 3965.49 | 744.27 | |||
SO48378_39 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 459 | 3 | 4 | 2023-03-27 | 107.99 | 2.70 | 2023-03-15 | 2 | 37.12 | 1 | 107.99 | 39 | SO48378 | 2023-03-22 | 8.64 | 74.24 | 53.99 | |||
SO63136_15 | 0873-484A-AE | PO18328125904 | 19 | 284 | 384 | 552 | 6 | 2024-05-27 | 2016.88 | 50.42 | 2024-05-15 | 3 | 713.08 | 1 | 2016.88 | 15 | SO63136 | 2024-05-22 | 161.35 | 2139.24 | 672.29 | |||
SO49864_4 | D282-4C24-9B | PO13775121562 | 100 | 283 | 460 | 618 | 2 | 2023-07-26 | 107.99 | 2.70 | 2023-07-14 | 2 | 37.12 | 1 | 107.99 | 4 | SO49864 | 2023-07-21 | 8.64 | 74.24 | 53.99 | |||
SO57035_7 | CD56-4460-9B | PO15921199440 | 100 | 287 | 491 | 77 | 4 | 2024-02-25 | 161.97 | 4.05 | 2024-02-13 | 5 | 41.57 | 1 | 161.97 | 7 | SO57035 | 2024-02-20 | 12.96 | 207.86 | 32.39 | |||
SO53623_9 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 490 | 235 | 1 | 2023-12-26 | 64.79 | 1.62 | 2023-12-14 | 2 | 41.57 | 1 | 64.79 | 9 | SO53623 | 2023-12-21 | 5.18 | 83.14 | 32.39 | |||
SO53458_19 | 0728-4E88-9F | PO19285149036 | 98 | 288 | 217 | 448 | 10 | 2023-12-26 | 125.96 | 3.15 | 2023-12-14 | 6 | 13.09 | 1 | 125.96 | 19 | SO53458 | 2023-12-21 | 10.08 | 78.52 | 20.99 | |||
SO44120_14 | E001-437D-A1 | PO5597155510 | 100 | 283 | 232 | 75 | 4 | 2021-12-26 | 57.68 | 1.44 | 2021-12-14 | 2 | 31.72 | 1 | 57.68 | 14 | SO44120 | 2021-12-21 | 4.61 | 63.45 | 28.84 | |||
SO53567_26 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 570 | 13 | 179 | 2 | 100.22 | 2023-12-26 | 668.12 | 14.20 | 2023-12-14 | 2 | 461.44 | 1 | 567.90 | 26 | SO53567 | 2023-12-21 | 45.43 | 922.89 | 334.06 | 0.15 |
SO58916_6 | E928-4943-BC | PO17139180025 | 100 | 293 | 378 | 644 | 1 | 2024-03-26 | 2932.02 | 73.30 | 2024-03-14 | 2 | 1554.95 | 1 | 2932.02 | 6 | SO58916 | 2024-03-21 | 234.56 | 3109.90 | 1466.01 | |||
SO65191_22 | 1CE2-46FD-83 | PO14703119228 | 6 | 296 | 567 | 573 | 9 | 2024-06-25 | 890.82 | 22.27 | 2024-06-13 | 2 | 461.44 | 1 | 890.82 | 22 | SO65191 | 2024-06-20 | 71.27 | 922.89 | 445.41 | |||
SO46967_20 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 460 | 487 | 1 | 2022-11-25 | 269.97 | 6.75 | 2022-11-13 | 5 | 37.12 | 1 | 269.97 | 20 | SO46967 | 2022-11-20 | 21.60 | 185.60 | 53.99 | |||
SO55297_6 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 355 | 496 | 6 | 2024-01-25 | 5567.98 | 139.20 | 2024-01-13 | 4 | 1265.62 | 1 | 5567.98 | 6 | SO55297 | 2024-01-20 | 445.44 | 5062.48 | 1391.99 | |||
SO53621_34 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 544 | 490 | 4 | 2023-12-26 | 485.94 | 12.15 | 2023-12-14 | 10 | 35.96 | 1 | 485.94 | 34 | SO53621 | 2023-12-21 | 38.88 | 359.60 | 48.59 | |||
SO51762_23 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 240 | 684 | 2 | 2023-11-25 | 2576.70 | 64.42 | 2023-11-13 | 3 | 868.63 | 1 | 2576.70 | 23 | SO51762 | 2023-11-20 | 206.14 | 2605.90 | 858.90 | |||
SO51726_17 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 503 | 199 | 1 | 2023-11-25 | 200.05 | 5.00 | 2023-11-13 | 1 | 199.85 | 1 | 200.05 | 17 | SO51726 | 2023-11-20 | 16.00 | 199.85 | 200.05 | |||
SO47677_41 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 462 | 475 | 4 | 2023-01-25 | 56.52 | 1.41 | 2023-01-13 | 4 | 9.71 | 1 | 56.52 | 41 | SO47677 | 2023-01-20 | 4.52 | 38.85 | 14.13 | |||
SO53527_46 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 214 | 10 | 6 | 2023-12-26 | 125.96 | 3.15 | 2023-12-14 | 6 | 13.09 | 1 | 125.96 | 46 | SO53527 | 2023-12-21 | 10.08 | 78.52 | 20.99 | |||
SO51735_9 | 6E95-4EE8-92 | PO13456167695 | 36 | 292 | 497 | 614 | 7 | 2023-11-25 | 1204.69 | 30.12 | 2023-11-13 | 2 | 601.74 | 1 | 1204.69 | 9 | SO51735 | 2023-11-20 | 96.38 | 1203.49 | 602.35 |
Generated 2024-11-13 04:00:06.476 UTC