[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '281' > SKIP 2500 SHUFFLE < SKIP 1108 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69501_30 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 592 | 16 | 345 | 4 | 45.20 | 2024-08-23 | 113.00 | 1.70 | 2024-08-11 | 1 | 308.22 | 1 | 67.80 | 30 | SO69501 | 2024-08-18 | 5.42 | 308.22 | 113.00 | 0.40 |
SO67292_24 | 09EF-4688-BB | PO551144976 | 100 | 281 | 378 | 4 | 4 | 2024-07-24 | 4398.03 | 109.95 | 2024-07-12 | 3 | 1554.95 | 1 | 4398.03 | 24 | SO67292 | 2024-07-19 | 351.84 | 4664.84 | 1466.01 | |||
SO71803_27 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 490 | 327 | 3 | 2024-09-23 | 291.55 | 7.29 | 2024-09-11 | 9 | 41.57 | 1 | 291.55 | 27 | SO71803 | 2024-09-18 | 23.32 | 374.15 | 32.39 | |||
SO47394_12 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 420 | 197 | 3 | 2022-12-24 | 708.08 | 17.70 | 2022-12-12 | 5 | 104.80 | 1 | 708.08 | 12 | SO47394 | 2022-12-19 | 56.65 | 523.98 | 141.62 | |||
SO51825_11 | E395-4F72-84 | PO6525184188 | 100 | 281 | 402 | 345 | 4 | 2023-11-23 | 144.32 | 3.61 | 2023-11-11 | 2 | 53.40 | 1 | 144.32 | 11 | SO51825 | 2023-11-18 | 11.55 | 106.80 | 72.16 | |||
SO53614_37 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 511 | 21 | 4 | 2023-12-24 | 1310.72 | 32.77 | 2023-12-12 | 6 | 199.38 | 1 | 1310.72 | 37 | SO53614 | 2023-12-19 | 104.86 | 1196.25 | 218.45 | |||
SO45561_1 | D3C4-4FED-A4 | PO4408154584 | 100 | 281 | 270 | 143 | 2 | 2022-06-23 | 183.94 | 4.60 | 2022-06-11 | 1 | 181.49 | 1 | 183.94 | 1 | SO45561 | 2022-06-18 | 14.72 | 181.49 | 183.94 | |||
SO69536_17 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 591 | 16 | 435 | 4 | 135.60 | 2024-08-23 | 338.99 | 5.08 | 2024-08-11 | 3 | 308.22 | 1 | 203.40 | 17 | SO69536 | 2024-08-18 | 16.27 | 924.65 | 113.00 | 0.40 |
SO51856_39 | E170-419C-92 | PO3654183134 | 100 | 281 | 551 | 435 | 4 | 2023-11-23 | 316.86 | 7.92 | 2023-11-11 | 2 | 144.59 | 1 | 316.86 | 39 | SO51856 | 2023-11-18 | 25.35 | 289.19 | 158.43 | |||
SO49540_22 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 354 | 21 | 4 | 2023-06-23 | 1242.85 | 31.07 | 2023-06-11 | 1 | 1117.86 | 1 | 1242.85 | 22 | SO49540 | 2023-06-18 | 99.43 | 1117.86 | 1242.85 | |||
SO47351_12 | E79A-4588-B4 | PO20213129467 | 100 | 281 | 263 | 216 | 2 | 2022-12-24 | 607.00 | 15.17 | 2022-12-12 | 3 | 187.16 | 1 | 607.00 | 12 | SO47351 | 2022-12-19 | 48.56 | 561.47 | 202.33 | |||
SO46666_13 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 385 | 234 | 2 | 2022-10-23 | 5402.36 | 135.06 | 2022-10-11 | 9 | 605.65 | 1 | 5402.36 | 13 | SO46666 | 2022-10-18 | 432.19 | 5450.84 | 600.26 | |||
SO51855_18 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 477 | 436 | 4 | 2023-11-23 | 11.98 | 0.30 | 2023-11-11 | 4 | 1.87 | 1 | 11.98 | 18 | SO51855 | 2023-11-18 | 0.96 | 7.47 | 2.99 | |||
SO46947_5 | 871C-4835-AD | PO18183118836 | 100 | 281 | 470 | 3 | 667 | 2 | 18.81 | 2022-11-23 | 376.10 | 8.93 | 2022-11-11 | 18 | 15.67 | 1 | 357.30 | 5 | SO46947 | 2022-11-18 | 28.58 | 282.08 | 20.89 | 0.05 |
SO46666_42 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 213 | 8 | 234 | 2 | 8.41 | 2022-10-23 | 84.11 | 1.89 | 2022-10-11 | 5 | 13.88 | 1 | 75.70 | 42 | SO46666 | 2022-10-18 | 6.06 | 69.39 | 16.82 | 0.10 |
SO47416_6 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 224 | 2 | 90 | 5 | 1.10 | 2022-12-24 | 55.15 | 1.35 | 2022-12-12 | 11 | 5.23 | 1 | 54.05 | 6 | SO47416 | 2022-12-19 | 4.32 | 57.53 | 5.01 | 0.02 |
SO47395_23 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 280 | 72 | 2 | 2022-12-24 | 367.88 | 9.20 | 2022-12-12 | 2 | 170.14 | 1 | 367.88 | 23 | SO47395 | 2022-12-19 | 29.43 | 340.29 | 183.94 | |||
SO71803_13 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 234 | 327 | 3 | 2024-09-23 | 179.96 | 4.50 | 2024-09-11 | 6 | 38.49 | 1 | 179.96 | 13 | SO71803 | 2024-09-18 | 14.40 | 230.95 | 29.99 | |||
SO50282_14 | 9C0C-42E0-B6 | PO6525160235 | 100 | 281 | 294 | 345 | 4 | 2023-08-23 | 1488.55 | 37.21 | 2023-08-11 | 2 | 660.91 | 1 | 1488.55 | 14 | SO50282 | 2023-08-18 | 119.08 | 1321.83 | 744.27 | |||
SO71837_20 | 103E-49BF-93 | PO1624180133 | 100 | 281 | 231 | 579 | 3 | 2024-09-23 | 119.98 | 3.00 | 2024-09-11 | 4 | 38.49 | 1 | 119.98 | 20 | SO71837 | 2024-09-18 | 9.60 | 153.97 | 29.99 | |||
SO53616_48 | A692-4827-93 | PO6786150961 | 100 | 281 | 547 | 3 | 4 | 2023-12-24 | 97.19 | 2.43 | 2023-12-12 | 2 | 35.96 | 1 | 97.19 | 48 | SO53616 | 2023-12-19 | 7.78 | 71.92 | 48.59 | |||
SO44568_3 | F675-42E0-A0 | PO8932184745 | 100 | 281 | 299 | 287 | 3 | 2022-02-23 | 809.76 | 20.24 | 2022-02-11 | 1 | 699.09 | 1 | 809.76 | 3 | SO44568 | 2022-02-18 | 64.78 | 699.09 | 809.76 | |||
SO49540_13 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 297 | 21 | 4 | 2023-06-23 | 736.15 | 18.40 | 2023-06-11 | 1 | 653.70 | 1 | 736.15 | 13 | SO49540 | 2023-06-18 | 58.89 | 653.70 | 736.15 | |||
SO69495_5 | D387-4497-83 | PO12122175008 | 100 | 281 | 434 | 22 | 3 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 5 | SO69495 | 2024-08-18 | 28.55 | 360.94 | 356.90 | |||
SO49151_3 | D25B-462C-8C | PO6438151235 | 100 | 281 | 399 | 309 | 4 | 2023-05-26 | 168.87 | 4.22 | 2023-05-14 | 5 | 24.99 | 1 | 168.87 | 3 | SO49151 | 2023-05-21 | 13.51 | 124.97 | 33.77 | |||
SO44531_6 | E4D9-426B-8B | PO10121174343 | 100 | 281 | 279 | 684 | 2 | 2022-02-23 | 178.58 | 4.46 | 2022-02-11 | 1 | 176.20 | 1 | 178.58 | 6 | SO44531 | 2022-02-18 | 14.29 | 176.20 | 178.58 | |||
SO47394_32 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 236 | 197 | 3 | 2022-12-24 | 86.52 | 2.16 | 2022-12-12 | 3 | 29.08 | 1 | 86.52 | 32 | SO47394 | 2022-12-19 | 6.92 | 87.24 | 28.84 | |||
SO46994_26 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 289 | 396 | 2 | 2022-11-23 | 1488.55 | 37.21 | 2022-11-11 | 2 | 660.91 | 1 | 1488.55 | 26 | SO46994 | 2022-11-18 | 119.08 | 1321.83 | 744.27 | |||
SO55303_9 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 482 | 166 | 4 | 2024-01-23 | 16.18 | 0.40 | 2024-01-11 | 3 | 3.36 | 1 | 16.18 | 9 | SO55303 | 2024-01-18 | 1.29 | 10.09 | 5.39 | |||
SO47450_2 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 385 | 54 | 2 | 2022-12-24 | 1200.53 | 30.01 | 2022-12-12 | 2 | 605.65 | 1 | 1200.53 | 2 | SO47450 | 2022-12-19 | 96.04 | 1211.30 | 600.26 |
Generated 2024-11-10 21:01:29.785 UTC