[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 715 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71851_1 | AABE-4443-91 | PO18299133687 | 19 | 291 | 603 | 118 | 6 | 2024-08-04 | 364.47 | 9.11 | 2024-07-23 | 5 | 53.94 | 1 | 364.47 | 1 | SO71851 | 2024-07-30 | 29.16 | 269.71 | 72.89 | |||
SO50716_38 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 457 | 118 | 6 | 2023-08-04 | 224.97 | 5.62 | 2023-07-23 | 5 | 30.93 | 1 | 224.97 | 38 | SO50716 | 2023-07-30 | 18.00 | 154.67 | 44.99 | |||
SO48307_11 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 375 | 155 | 6 | 2023-02-03 | 2617.88 | 65.45 | 2023-01-22 | 2 | 1320.68 | 1 | 2617.88 | 11 | SO48307 | 2023-01-29 | 209.43 | 2641.37 | 1308.94 | |||
SO69482_11 | 0D35-42F6-9E | PO18357170772 | 19 | 284 | 560 | 138 | 6 | 2024-07-04 | 1457.82 | 36.45 | 2024-06-22 | 2 | 755.15 | 1 | 1457.82 | 11 | SO69482 | 2024-06-29 | 116.63 | 1510.30 | 728.91 | |||
SO63290_13 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 587 | 100 | 6 | 2024-04-05 | 461.69 | 11.54 | 2024-03-24 | 1 | 419.78 | 1 | 461.69 | 13 | SO63290 | 2024-03-31 | 36.94 | 419.78 | 461.69 | |||
SO47980_24 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 271 | 12 | 6 | 2023-01-04 | 607.00 | 15.17 | 2022-12-23 | 3 | 187.16 | 1 | 607.00 | 24 | SO47980 | 2022-12-30 | 48.56 | 561.47 | 202.33 | |||
SO69399_24 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 570 | 264 | 6 | 2024-07-04 | 445.41 | 11.14 | 2024-06-22 | 1 | 461.44 | 1 | 445.41 | 24 | SO69399 | 2024-06-29 | 35.63 | 461.44 | 445.41 | |||
SO51791_39 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 546 | 552 | 6 | 2023-10-04 | 74.51 | 1.86 | 2023-09-22 | 2 | 27.57 | 1 | 74.51 | 39 | SO51791 | 2023-09-29 | 5.96 | 55.14 | 37.25 | |||
SO45310_1 | E43D-4178-B9 | PO10469159835 | 19 | 288 | 346 | 335 | 6 | 2022-04-06 | 2039.99 | 51.00 | 2022-03-25 | 1 | 1912.15 | 1 | 2039.99 | 1 | SO45310 | 2022-04-01 | 163.20 | 1912.15 | 2039.99 | |||
SO46326_11 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 223 | 173 | 6 | 2022-08-04 | 5.19 | 0.13 | 2022-07-23 | 1 | 5.71 | 1 | 5.19 | 11 | SO46326 | 2022-07-30 | 0.41 | 5.71 | 5.19 | |||
SO46657_50 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 419 | 496 | 6 | 2022-09-03 | 52.65 | 1.32 | 2022-08-22 | 1 | 38.96 | 1 | 52.65 | 50 | SO46657 | 2022-08-29 | 4.21 | 38.96 | 52.65 | |||
SO51694_4 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 400 | 353 | 6 | 2023-10-04 | 74.30 | 1.86 | 2023-09-22 | 2 | 27.49 | 1 | 74.30 | 4 | SO51694 | 2023-09-29 | 5.94 | 54.99 | 37.15 | |||
SO44525_23 | E0C6-40AA-AD | PO11600189203 | 19 | 288 | 276 | 569 | 6 | 2022-01-04 | 1070.69 | 26.77 | 2021-12-23 | 3 | 352.14 | 1 | 1070.69 | 23 | SO44525 | 2021-12-30 | 85.66 | 1056.42 | 356.90 | |||
SO58930_26 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 591 | 497 | 6 | 2024-02-03 | 1016.98 | 25.42 | 2024-01-22 | 3 | 308.22 | 1 | 1016.98 | 26 | SO58930 | 2024-01-29 | 81.36 | 924.65 | 338.99 | |||
SO47413_2 | E274-4280-9B | PO1885161774 | 19 | 284 | 409 | 588 | 6 | 2022-11-04 | 418.51 | 10.46 | 2022-10-23 | 2 | 185.82 | 1 | 418.51 | 2 | SO47413 | 2022-10-30 | 33.48 | 371.64 | 209.26 | |||
SO50284_16 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 433 | 84 | 6 | 2023-07-04 | 1297.81 | 32.45 | 2023-06-22 | 4 | 300.12 | 1 | 1297.81 | 16 | SO50284 | 2023-06-29 | 103.82 | 1200.48 | 324.45 | |||
SO47413_21 | E274-4280-9B | PO1885161774 | 19 | 284 | 365 | 588 | 6 | 2022-11-04 | 1295.99 | 32.40 | 2022-10-23 | 2 | 598.44 | 1 | 1295.99 | 21 | SO47413 | 2022-10-30 | 103.68 | 1196.87 | 647.99 | |||
SO50664_37 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 286 | 173 | 6 | 2023-08-04 | 367.88 | 9.20 | 2023-07-23 | 2 | 170.14 | 1 | 367.88 | 37 | SO50664 | 2023-07-30 | 29.43 | 340.29 | 183.94 | |||
SO47365_51 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 454 | 678 | 6 | 2022-11-04 | 107.98 | 2.70 | 2022-10-23 | 3 | 24.75 | 1 | 107.98 | 51 | SO47365 | 2022-10-30 | 8.64 | 74.24 | 35.99 | |||
SO47708_13 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 216 | 496 | 6 | 2022-12-04 | 181.68 | 4.54 | 2022-11-22 | 9 | 13.88 | 1 | 181.68 | 13 | SO47708 | 2022-11-29 | 14.53 | 124.90 | 20.19 | |||
SO47012_37 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 447 | 2 | 66 | 6 | 3.19 | 2022-10-04 | 159.50 | 3.91 | 2022-09-22 | 11 | 10.31 | 1 | 156.31 | 37 | SO47012 | 2022-09-29 | 12.50 | 113.44 | 14.50 | 0.02 |
SO51160_40 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 532 | 496 | 6 | 2023-09-03 | 299.75 | 7.49 | 2023-08-22 | 2 | 136.79 | 1 | 299.75 | 40 | SO51160 | 2023-08-29 | 23.98 | 273.57 | 149.87 | |||
SO58953_5 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 583 | 156 | 6 | 2024-02-03 | 1020.59 | 25.51 | 2024-01-22 | 1 | 1082.51 | 1 | 1020.59 | 5 | SO58953 | 2024-01-29 | 81.65 | 1082.51 | 1020.59 | |||
SO51160_66 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 465 | 3 | 496 | 6 | 11.45 | 2023-09-03 | 228.98 | 5.44 | 2023-08-22 | 17 | 9.16 | 1 | 217.53 | 66 | SO51160 | 2023-08-29 | 17.40 | 155.71 | 13.47 | 0.05 |
SO46614_20 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 213 | 8 | 299 | 6 | 16.82 | 2022-09-03 | 168.22 | 3.79 | 2022-08-22 | 10 | 13.88 | 1 | 151.40 | 20 | SO46614 | 2022-08-29 | 12.11 | 138.78 | 16.82 | 0.10 |
SO49839_4 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 433 | 480 | 6 | 2023-06-04 | 973.36 | 24.33 | 2023-05-23 | 3 | 300.12 | 1 | 973.36 | 4 | SO49839 | 2023-05-30 | 77.87 | 900.36 | 324.45 | |||
SO51781_11 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 475 | 65 | 6 | 2023-10-04 | 251.96 | 6.30 | 2023-09-22 | 6 | 26.18 | 1 | 251.96 | 11 | SO51781 | 2023-09-29 | 20.16 | 157.06 | 41.99 | |||
SO45524_11 | D7A1-4CAA-B1 | PO18299160578 | 19 | 288 | 220 | 118 | 6 | 2022-05-04 | 40.37 | 1.01 | 2022-04-22 | 2 | 12.03 | 1 | 40.37 | 11 | SO45524 | 2022-04-29 | 3.23 | 24.06 | 20.19 |
Generated 2024-09-21 11:03:43.086 UTC