[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 170 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO48016_6 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 422 | 97 | 4 | 2023-02-27 | 270.16 | 6.75 | 2023-02-15 | 4 | 49.98 | 1 | 270.16 | 6 | SO48016 | 2023-02-22 | 21.61 | 199.92 | 67.54 | |||
| SO71882_18 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 542 | 75 | 4 | 2024-09-27 | 48.59 | 1.21 | 2024-09-15 | 2 | 17.98 | 1 | 48.59 | 18 | SO71882 | 2024-09-22 | 3.89 | 35.96 | 24.29 | |||
| SO65310_2 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 390 | 3 | 4 | 2024-06-27 | 672.29 | 16.81 | 2024-06-15 | 1 | 713.08 | 1 | 672.29 | 2 | SO65310 | 2024-06-22 | 53.78 | 713.08 | 672.29 | |||
| SO48043_35 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 460 | 167 | 4 | 2023-02-27 | 161.98 | 4.05 | 2023-02-15 | 3 | 37.12 | 1 | 161.98 | 35 | SO48043 | 2023-02-22 | 12.96 | 111.36 | 53.99 | |||
| SO46362_2 | 0291-45A5-B2 | PO2697124986 | 100 | 282 | 304 | 187 | 4 | 2022-09-27 | 714.70 | 17.87 | 2022-09-15 | 1 | 617.03 | 1 | 714.70 | 2 | SO46362 | 2022-09-22 | 57.18 | 617.03 | 714.70 | |||
| SO47024_28 | F254-4053-A3 | PO3654136382 | 100 | 283 | 367 | 435 | 4 | 2022-11-27 | 1295.99 | 32.40 | 2022-11-15 | 2 | 598.44 | 1 | 1295.99 | 28 | SO47024 | 2022-11-22 | 103.68 | 1196.87 | 647.99 | |||
| SO47720_23 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 323 | 221 | 4 | 2023-01-27 | 2818.76 | 70.47 | 2023-01-15 | 6 | 486.71 | 1 | 2818.76 | 23 | SO47720 | 2023-01-22 | 225.50 | 2920.24 | 469.79 | |||
| SO53616_2 | A692-4827-93 | PO6786150961 | 100 | 281 | 237 | 3 | 4 | 2023-12-28 | 239.95 | 6.00 | 2023-12-16 | 8 | 38.49 | 1 | 239.95 | 2 | SO53616 | 2023-12-23 | 19.20 | 307.94 | 29.99 | |||
| SO47355_32 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 321 | 24 | 4 | 2022-12-28 | 1409.38 | 35.23 | 2022-12-16 | 3 | 486.71 | 1 | 1409.38 | 32 | SO47355 | 2022-12-23 | 112.75 | 1460.12 | 469.79 | |||
| SO51745_20 | C261-441D-A5 | PO11745132954 | 100 | 282 | 386 | 97 | 4 | 2023-11-27 | 2016.88 | 50.42 | 2023-11-15 | 3 | 713.08 | 1 | 2016.88 | 20 | SO51745 | 2023-11-22 | 161.35 | 2139.24 | 672.29 | |||
| SO51122_25 | D915-4225-97 | PO551181465 | 100 | 281 | 546 | 4 | 4 | 2023-10-27 | 149.02 | 3.73 | 2023-10-15 | 4 | 27.57 | 1 | 149.02 | 25 | SO51122 | 2023-10-22 | 11.92 | 110.27 | 37.25 | |||
| SO47369_30 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 389 | 239 | 4 | 2022-12-28 | 4201.84 | 105.05 | 2022-12-16 | 7 | 605.65 | 1 | 4201.84 | 30 | SO47369 | 2022-12-23 | 336.15 | 4239.54 | 600.26 | |||
| SO47034_12 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 280 | 257 | 4 | 2022-11-27 | 551.81 | 13.80 | 2022-11-15 | 3 | 170.14 | 1 | 551.81 | 12 | SO47034 | 2022-11-22 | 44.15 | 510.43 | 183.94 | |||
| SO65269_17 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 590 | 648 | 4 | 2024-06-27 | 2770.16 | 69.25 | 2024-06-15 | 6 | 419.78 | 1 | 2770.16 | 17 | SO65269 | 2024-06-22 | 221.61 | 2518.67 | 461.69 | |||
| SO69515_6 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 581 | 255 | 4 | 2024-08-27 | 2041.19 | 51.03 | 2024-08-15 | 2 | 1082.51 | 1 | 2041.19 | 6 | SO69515 | 2024-08-22 | 163.30 | 2165.02 | 1020.59 | |||
| SO50748_41 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 368 | 3 | 4 | 2023-09-27 | 2932.02 | 73.30 | 2023-09-15 | 2 | 1518.79 | 1 | 2932.02 | 41 | SO50748 | 2023-09-22 | 234.56 | 3037.57 | 1466.01 | |||
| SO48016_37 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 415 | 97 | 4 | 2023-02-27 | 1188.22 | 29.71 | 2023-02-15 | 6 | 146.55 | 1 | 1188.22 | 37 | SO48016 | 2023-02-22 | 95.06 | 879.28 | 198.04 | |||
| SO50310_37 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 360 | 309 | 4 | 2023-08-27 | 4917.84 | 122.95 | 2023-08-15 | 4 | 1105.81 | 1 | 4917.84 | 37 | SO50310 | 2023-08-22 | 393.43 | 4423.24 | 1229.46 | |||
| SO53539_16 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 576 | 59 | 4 | 2023-12-28 | 4291.33 | 107.28 | 2023-12-16 | 3 | 1481.94 | 1 | 4291.33 | 16 | SO53539 | 2023-12-23 | 343.31 | 4445.81 | 1430.44 | |||
| SO48341_30 | A747-471B-97 | PO10701176180 | 100 | 282 | 469 | 133 | 4 | 2023-03-29 | 227.94 | 5.70 | 2023-03-17 | 10 | 15.67 | 1 | 227.94 | 30 | SO48341 | 2023-03-24 | 18.24 | 156.71 | 22.79 | |||
| SO67287_34 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 584 | 491 | 4 | 2024-07-28 | 1619.97 | 40.50 | 2024-07-16 | 5 | 343.65 | 1 | 1619.97 | 34 | SO67287 | 2024-07-23 | 129.60 | 1718.25 | 323.99 | |||
| SO53470_9 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 562 | 14 | 420 | 4 | 1144.35 | 2023-12-28 | 5721.77 | 114.44 | 2023-12-16 | 6 | 1481.94 | 1 | 4577.41 | 9 | SO53470 | 2023-12-23 | 366.19 | 8891.63 | 953.63 | 0.20 |
| SO50269_7 | 78AA-40D5-B3 | PO18647136011 | 100 | 282 | 224 | 583 | 4 | 2023-08-27 | 10.37 | 0.26 | 2023-08-15 | 2 | 5.23 | 1 | 10.37 | 7 | SO50269 | 2023-08-22 | 0.83 | 10.46 | 5.19 | |||
| SO49139_1 | 2662-4BFD-96 | PO4843131080 | 100 | 287 | 327 | 257 | 4 | 2023-05-30 | 1879.18 | 46.98 | 2023-05-18 | 4 | 486.71 | 1 | 1879.18 | 1 | SO49139 | 2023-05-25 | 150.33 | 1946.83 | 469.79 | |||
| SO50702_7 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 308 | 187 | 4 | 2023-09-27 | 744.27 | 18.61 | 2023-09-15 | 1 | 660.91 | 1 | 744.27 | 7 | SO50702 | 2023-09-22 | 59.54 | 660.91 | 744.27 | |||
| SO50313_34 | B452-44E9-91 | PO7656143984 | 100 | 282 | 389 | 403 | 4 | 2023-08-27 | 1200.53 | 30.01 | 2023-08-15 | 2 | 605.65 | 1 | 1200.53 | 34 | SO50313 | 2023-08-22 | 96.04 | 1211.30 | 600.26 | |||
| SO55256_1 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 565 | 331 | 4 | 2024-01-27 | 1336.23 | 33.41 | 2024-01-15 | 3 | 461.44 | 1 | 1336.23 | 1 | SO55256 | 2024-01-22 | 106.90 | 1384.33 | 445.41 | |||
| SO50310_38 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 409 | 309 | 4 | 2023-08-27 | 1255.54 | 31.39 | 2023-08-15 | 6 | 185.82 | 1 | 1255.54 | 38 | SO50310 | 2023-08-22 | 100.44 | 1114.92 | 209.26 | |||
| SO47355_60 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 464 | 2 | 24 | 4 | 3.82 | 2022-12-28 | 191.21 | 4.68 | 2022-12-16 | 14 | 9.71 | 1 | 187.39 | 60 | SO47355 | 2022-12-23 | 14.99 | 135.99 | 13.66 | 0.02 |
| SO43873_10 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 319 | 78 | 4 | 2021-11-27 | 4373.97 | 109.35 | 2021-11-15 | 5 | 884.71 | 1 | 4373.97 | 10 | SO43873 | 2021-11-22 | 349.92 | 4423.54 | 874.79 |
Generated 2024-11-15 02:15:54.222 UTC