[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 144 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49160_6 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 341 | 403 | 4 | 2023-05-29 | 1879.18 | 46.98 | 2023-05-17 | 4 | 486.71 | 1 | 1879.18 | 6 | SO49160 | 2023-05-24 | 150.33 | 1946.83 | 469.79 | |||
SO58988_5 | 419B-4310-83 | PO16124114660 | 100 | 282 | 382 | 649 | 4 | 2024-03-27 | 672.29 | 16.81 | 2024-03-15 | 1 | 713.08 | 1 | 672.29 | 5 | SO58988 | 2024-03-22 | 53.78 | 713.08 | 672.29 | |||
SO49831_46 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 460 | 475 | 4 | 2023-07-27 | 431.95 | 10.80 | 2023-07-15 | 8 | 37.12 | 1 | 431.95 | 46 | SO49831 | 2023-07-22 | 34.56 | 296.97 | 53.99 | |||
SO43678_17 | FBD8-4CE4-8B | PO10817150168 | 100 | 287 | 316 | 203 | 4 | 2021-10-26 | 874.79 | 21.87 | 2021-10-14 | 1 | 884.71 | 1 | 874.79 | 17 | SO43678 | 2021-10-21 | 69.98 | 884.71 | 874.79 | |||
SO51090_16 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 237 | 475 | 4 | 2023-10-26 | 269.95 | 6.75 | 2023-10-14 | 9 | 38.49 | 1 | 269.95 | 16 | SO51090 | 2023-10-21 | 21.60 | 346.43 | 29.99 | |||
SO51856_3 | E170-419C-92 | PO3654183134 | 100 | 281 | 517 | 435 | 4 | 2023-11-26 | 31.58 | 0.79 | 2023-11-14 | 1 | 23.37 | 1 | 31.58 | 3 | SO51856 | 2023-11-21 | 2.53 | 23.37 | 31.58 | |||
SO49146_2 | 273A-4635-9D | PO5684148238 | 100 | 282 | 469 | 385 | 4 | 2023-05-29 | 136.76 | 3.42 | 2023-05-17 | 6 | 15.67 | 1 | 136.76 | 2 | SO49146 | 2023-05-24 | 10.94 | 94.03 | 22.79 | |||
SO63251_1 | CA03-47EE-90 | PO6525146360 | 100 | 281 | 355 | 345 | 4 | 2024-05-28 | 5567.98 | 139.20 | 2024-05-16 | 4 | 1265.62 | 1 | 5567.98 | 1 | SO63251 | 2024-05-23 | 445.44 | 5062.48 | 1391.99 | |||
SO51153_2 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 287 | 2 | 166 | 4 | 43.03 | 2023-10-26 | 2151.46 | 52.71 | 2023-10-14 | 11 | 204.63 | 1 | 2108.43 | 2 | SO51153 | 2023-10-21 | 168.67 | 2250.88 | 195.59 | 0.02 |
SO47687_41 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 458 | 203 | 4 | 2023-01-26 | 179.98 | 4.50 | 2023-01-14 | 4 | 30.93 | 1 | 179.98 | 41 | SO47687 | 2023-01-21 | 14.40 | 123.73 | 44.99 | |||
SO47687_23 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 389 | 203 | 4 | 2023-01-26 | 1200.53 | 30.01 | 2023-01-14 | 2 | 605.65 | 1 | 1200.53 | 23 | SO47687 | 2023-01-21 | 96.04 | 1211.30 | 600.26 | |||
SO69466_31 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 390 | 167 | 4 | 2024-08-26 | 672.29 | 16.81 | 2024-08-14 | 1 | 713.08 | 1 | 672.29 | 31 | SO69466 | 2024-08-21 | 53.78 | 713.08 | 672.29 | |||
SO43872_16 | 52FF-45CD-9B | PO12557127067 | 100 | 282 | 223 | 240 | 4 | 2021-11-26 | 20.75 | 0.52 | 2021-11-14 | 4 | 5.71 | 1 | 20.75 | 16 | SO43872 | 2021-11-21 | 1.66 | 22.82 | 5.19 | |||
SO63251_4 | CA03-47EE-90 | PO6525146360 | 100 | 281 | 517 | 345 | 4 | 2024-05-28 | 31.58 | 0.79 | 2024-05-16 | 1 | 23.37 | 1 | 31.58 | 4 | SO63251 | 2024-05-23 | 2.53 | 23.37 | 31.58 | |||
SO46089_15 | 5E3C-4A0D-BD | PO5684142532 | 100 | 282 | 220 | 385 | 4 | 2022-08-26 | 80.75 | 2.02 | 2022-08-14 | 4 | 12.03 | 1 | 80.75 | 15 | SO46089 | 2022-08-21 | 6.46 | 48.11 | 20.19 | |||
SO48069_8 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 420 | 309 | 4 | 2023-02-26 | 283.23 | 7.08 | 2023-02-14 | 2 | 104.80 | 1 | 283.23 | 8 | SO48069 | 2023-02-21 | 22.66 | 209.59 | 141.62 | |||
SO69501_29 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 532 | 345 | 4 | 2024-08-26 | 149.87 | 3.75 | 2024-08-14 | 1 | 136.79 | 1 | 149.87 | 29 | SO69501 | 2024-08-21 | 11.99 | 136.79 | 149.87 | |||
SO44757_9 | C27A-4D15-8C | PO14964184059 | 100 | 287 | 304 | 581 | 4 | 2022-03-28 | 714.70 | 17.87 | 2022-03-16 | 1 | 617.03 | 1 | 714.70 | 9 | SO44757 | 2022-03-23 | 57.18 | 617.03 | 714.70 | |||
SO47369_26 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 369 | 2 | 239 | 4 | 311.77 | 2022-12-27 | 15588.57 | 381.92 | 2022-12-15 | 11 | 1518.79 | 1 | 15276.80 | 26 | SO47369 | 2022-12-22 | 1222.14 | 16706.65 | 1417.14 | 0.02 |
SO47024_17 | F254-4053-A3 | PO3654136382 | 100 | 283 | 360 | 435 | 4 | 2022-11-26 | 4917.84 | 122.95 | 2022-11-14 | 4 | 1105.81 | 1 | 4917.84 | 17 | SO47024 | 2022-11-21 | 393.43 | 4423.24 | 1229.46 | |||
SO46638_13 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 323 | 203 | 4 | 2022-10-26 | 469.79 | 11.74 | 2022-10-14 | 1 | 486.71 | 1 | 469.79 | 13 | SO46638 | 2022-10-21 | 37.58 | 486.71 | 469.79 | |||
SO51856_16 | E170-419C-92 | PO3654183134 | 100 | 281 | 559 | 435 | 4 | 2023-11-26 | 48.58 | 1.21 | 2023-11-14 | 4 | 8.99 | 1 | 48.58 | 16 | SO51856 | 2023-11-21 | 3.89 | 35.95 | 12.14 | |||
SO48363_46 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 407 | 130 | 4 | 2023-03-28 | 131.20 | 3.28 | 2023-03-16 | 2 | 48.55 | 1 | 131.20 | 46 | SO48363 | 2023-03-23 | 10.50 | 97.09 | 65.60 | |||
SO46965_10 | C9A7-4125-95 | PO15921113146 | 100 | 287 | 414 | 77 | 4 | 2022-11-26 | 298.06 | 7.45 | 2022-11-14 | 2 | 110.28 | 1 | 298.06 | 10 | SO46965 | 2022-11-21 | 23.85 | 220.57 | 149.03 | |||
SO45516_2 | 3473-43AB-AE | PO261128364 | 100 | 283 | 332 | 647 | 4 | 2022-06-26 | 419.46 | 10.49 | 2022-06-14 | 1 | 413.15 | 1 | 419.46 | 2 | SO45516 | 2022-06-21 | 33.56 | 413.15 | 419.46 | |||
SO50269_6 | 78AA-40D5-B3 | PO18647136011 | 100 | 282 | 233 | 583 | 4 | 2023-08-26 | 173.04 | 4.33 | 2023-08-14 | 6 | 29.08 | 1 | 173.04 | 6 | SO50269 | 2023-08-21 | 13.84 | 174.48 | 28.84 | |||
SO43864_3 | B5D8-4B03-96 | PO16037151094 | 100 | 282 | 292 | 384 | 4 | 2021-11-26 | 1637.40 | 40.94 | 2021-11-14 | 2 | 706.81 | 1 | 1637.40 | 3 | SO43864 | 2021-11-21 | 130.99 | 1413.62 | 818.70 | |||
SO51090_1 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 515 | 475 | 4 | 2023-10-26 | 16.27 | 0.41 | 2023-10-14 | 1 | 12.04 | 1 | 16.27 | 1 | SO51090 | 2023-10-21 | 1.30 | 12.04 | 16.27 | |||
SO44509_9 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 342 | 328 | 4 | 2022-02-26 | 1258.38 | 31.46 | 2022-02-14 | 3 | 413.15 | 1 | 1258.38 | 9 | SO44509 | 2022-02-21 | 100.67 | 1239.44 | 419.46 | |||
SO69501_31 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 298 | 345 | 4 | 2024-08-26 | 2429.28 | 60.73 | 2024-08-14 | 3 | 739.04 | 1 | 2429.28 | 31 | SO69501 | 2024-08-21 | 194.34 | 2217.12 | 809.76 |
Generated 2024-11-13 05:09:51.051 UTC