[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 289 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48026_14 | E497-4BCF-A5 | PO10121196875 | 100 | 281 | 439 | 684 | 2 | 2023-02-26 | 780.82 | 19.52 | 2023-02-14 | 1 | 722.26 | 1 | 780.82 | 14 | SO48026 | 2023-02-21 | 62.47 | 722.26 | 780.82 | |||
SO59074_26 | 1711-471C-82 | PO9483120932 | 100 | 283 | 386 | 54 | 2 | 2024-03-27 | 672.29 | 16.81 | 2024-03-15 | 1 | 713.08 | 1 | 672.29 | 26 | SO59074 | 2024-03-22 | 53.78 | 713.08 | 672.29 | |||
SO49888_34 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 379 | 234 | 2 | 2023-07-27 | 5235.75 | 130.89 | 2023-07-15 | 4 | 1320.68 | 1 | 5235.75 | 34 | SO49888 | 2023-07-22 | 418.86 | 5282.74 | 1308.94 | |||
SO48050_2 | 88AC-458C-88 | PO3625155257 | 100 | 281 | 389 | 666 | 2 | 2023-02-26 | 2401.05 | 60.03 | 2023-02-14 | 4 | 605.65 | 1 | 2401.05 | 2 | SO48050 | 2023-02-21 | 192.08 | 2422.60 | 600.26 | |||
SO57125_4 | 2D2B-4159-87 | PO7453119638 | 100 | 283 | 488 | 108 | 2 | 2024-02-26 | 161.97 | 4.05 | 2024-02-14 | 5 | 41.57 | 1 | 161.97 | 4 | SO57125 | 2024-02-21 | 12.96 | 207.86 | 32.39 | |||
SO45053_11 | 1527-4B4C-8B | PO13775163879 | 100 | 281 | 315 | 618 | 2 | 2022-04-28 | 1749.59 | 43.74 | 2022-04-16 | 2 | 884.71 | 1 | 1749.59 | 11 | SO45053 | 2022-04-23 | 139.97 | 1769.42 | 874.79 | |||
SO48392_39 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 236 | 54 | 2 | 2023-03-28 | 144.20 | 3.61 | 2023-03-16 | 5 | 29.08 | 1 | 144.20 | 39 | SO48392 | 2023-03-23 | 11.54 | 145.40 | 28.84 | |||
SO46620_43 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 273 | 618 | 2 | 2022-10-26 | 202.33 | 5.06 | 2022-10-14 | 1 | 187.16 | 1 | 202.33 | 43 | SO46620 | 2022-10-21 | 16.19 | 187.16 | 202.33 | |||
SO51748_4 | 1D77-486A-86 | PO11658169327 | 100 | 283 | 517 | 233 | 2 | 2023-11-26 | 63.17 | 1.58 | 2023-11-14 | 2 | 23.37 | 1 | 63.17 | 4 | SO51748 | 2023-11-21 | 5.05 | 46.74 | 31.58 | |||
SO53567_12 | 2385-4ADE-B6 | PO9628113784 | 100 | 283 | 585 | 13 | 179 | 2 | 50.11 | 2023-12-27 | 334.06 | 7.10 | 2023-12-15 | 1 | 461.44 | 1 | 283.95 | 12 | SO53567 | 2023-12-22 | 22.72 | 461.44 | 334.06 | 0.15 |
SO47052_16 | 1AAD-4284-B8 | PO7424197138 | 100 | 281 | 233 | 642 | 2 | 2022-11-26 | 115.36 | 2.88 | 2022-11-14 | 4 | 29.08 | 1 | 115.36 | 16 | SO47052 | 2022-11-21 | 9.23 | 116.32 | 28.84 | |||
SO44558_1 | 9613-43D3-B4 | PO6670113276 | 100 | 281 | 332 | 432 | 2 | 2022-02-26 | 838.92 | 20.97 | 2022-02-14 | 2 | 413.15 | 1 | 838.92 | 1 | SO44558 | 2022-02-21 | 67.11 | 826.29 | 419.46 | |||
SO45575_4 | 358D-446A-9A | PO9483193232 | 100 | 281 | 332 | 54 | 2 | 2022-06-26 | 838.92 | 20.97 | 2022-06-14 | 2 | 413.15 | 1 | 838.92 | 4 | SO45575 | 2022-06-21 | 67.11 | 826.29 | 419.46 | |||
SO44502_6 | 5EC5-4410-9C | PO16791147707 | 100 | 281 | 342 | 36 | 2 | 2022-02-26 | 2516.75 | 62.92 | 2022-02-14 | 6 | 413.15 | 1 | 2516.75 | 6 | SO44502 | 2022-02-21 | 201.34 | 2478.88 | 419.46 | |||
SO46061_4 | 2B65-4F76-8A | PO11716117697 | 100 | 281 | 349 | 144 | 2 | 2022-08-26 | 6074.98 | 151.87 | 2022-08-14 | 3 | 1898.09 | 1 | 6074.98 | 4 | SO46061 | 2022-08-21 | 486.00 | 5694.28 | 2024.99 | |||
SO45556_9 | A9AB-44F3-9F | PO3190111178 | 100 | 281 | 262 | 575 | 2 | 2022-06-26 | 735.75 | 18.39 | 2022-06-14 | 4 | 181.49 | 1 | 735.75 | 9 | SO45556 | 2022-06-21 | 58.86 | 725.94 | 183.94 | |||
SO51748_34 | 1D77-486A-86 | PO11658169327 | 100 | 283 | 514 | 233 | 2 | 2023-11-26 | 63.90 | 1.60 | 2023-11-14 | 1 | 47.29 | 1 | 63.90 | 34 | SO51748 | 2023-11-21 | 5.11 | 47.29 | 63.90 | |||
SO47453_1 | 9736-49EE-BD | PO9019173488 | 100 | 281 | 410 | 576 | 2 | 2022-12-27 | 36.45 | 0.91 | 2022-12-15 | 1 | 26.97 | 1 | 36.45 | 1 | SO47453 | 2022-12-22 | 2.92 | 26.97 | 36.45 | |||
SO51088_10 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 589 | 125 | 2 | 2023-10-26 | 923.39 | 23.08 | 2023-10-14 | 2 | 419.78 | 1 | 923.39 | 10 | SO51088 | 2023-10-21 | 73.87 | 839.56 | 461.69 | |||
SO43858_1 | 8FFA-4339-B7 | PO16791124272 | 100 | 281 | 326 | 36 | 2 | 2021-11-26 | 838.92 | 20.97 | 2021-11-14 | 2 | 413.15 | 1 | 838.92 | 1 | SO43858 | 2021-11-21 | 67.11 | 826.29 | 419.46 | |||
SO55301_6 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 512 | 414 | 2 | 2024-01-26 | 218.45 | 5.46 | 2024-01-14 | 1 | 199.38 | 1 | 218.45 | 6 | SO55301 | 2024-01-21 | 17.48 | 199.38 | 218.45 | |||
SO49084_7 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 470 | 667 | 2 | 2023-05-29 | 113.97 | 2.85 | 2023-05-17 | 5 | 15.67 | 1 | 113.97 | 7 | SO49084 | 2023-05-24 | 9.12 | 78.35 | 22.79 | |||
SO48781_1 | 6591-47F7-B9 | PO4959133095 | 100 | 283 | 454 | 269 | 2 | 2023-04-28 | 35.99 | 0.90 | 2023-04-16 | 1 | 24.75 | 1 | 35.99 | 1 | SO48781 | 2023-04-23 | 2.88 | 24.75 | 35.99 | |||
SO69450_11 | 7050-466D-9B | PO10121172172 | 100 | 283 | 606 | 684 | 2 | 2024-08-26 | 323.99 | 8.10 | 2024-08-14 | 1 | 343.65 | 1 | 323.99 | 11 | SO69450 | 2024-08-21 | 25.92 | 343.65 | 323.99 | |||
SO71947_20 | 7269-4186-92 | PO9628115897 | 100 | 283 | 234 | 179 | 2 | 2024-09-26 | 119.98 | 3.00 | 2024-09-14 | 4 | 38.49 | 1 | 119.98 | 20 | SO71947 | 2024-09-21 | 9.60 | 153.97 | 29.99 | |||
SO65152_7 | 9C5B-4E79-98 | PO20213135029 | 100 | 283 | 471 | 216 | 2 | 2024-06-26 | 114.30 | 2.86 | 2024-06-14 | 3 | 23.75 | 1 | 114.30 | 7 | SO65152 | 2024-06-21 | 9.14 | 71.25 | 38.10 | |||
SO48392_18 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 448 | 54 | 2 | 2023-03-28 | 35.98 | 0.90 | 2023-03-16 | 3 | 8.25 | 1 | 35.98 | 18 | SO48392 | 2023-03-23 | 2.88 | 24.74 | 11.99 | |||
SO51790_11 | E757-43BD-B1 | PO18183195762 | 100 | 283 | 533 | 667 | 2 | 2023-11-26 | 599.50 | 14.99 | 2023-11-14 | 4 | 136.79 | 1 | 599.50 | 11 | SO51790 | 2023-11-21 | 47.96 | 547.14 | 149.87 |
Generated 2024-11-13 08:40:37.729 UTC