[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 120 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55324_14 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 463 | 523 | 3 | 2023-12-03 | 117.55 | 2.94 | 2023-11-21 | 8 | 9.16 | 1 | 117.55 | 14 | SO55324 | 2023-11-28 | 9.40 | 73.27 | 14.69 | |||
SO69441_2 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 583 | 97 | 4 | 2024-07-03 | 4082.38 | 102.06 | 2024-06-21 | 4 | 1082.51 | 1 | 4082.38 | 2 | SO69441 | 2024-06-28 | 326.59 | 4330.04 | 1020.59 | |||
SO47041_3 | C543-4932-83 | PO5771188676 | 100 | 282 | 339 | 79 | 3 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 3 | SO47041 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO44776_3 | 289E-464B-BE | PO2697147596 | 100 | 282 | 346 | 187 | 4 | 2022-02-02 | 10199.97 | 255.00 | 2022-01-21 | 5 | 1912.15 | 1 | 10199.97 | 3 | SO44776 | 2022-01-28 | 816.00 | 9560.77 | 2039.99 | |||
SO50724_14 | E9DD-40CA-B2 | PO9686154363 | 100 | 282 | 358 | 457 | 4 | 2023-08-03 | 4917.84 | 122.95 | 2023-07-22 | 4 | 1105.81 | 1 | 4917.84 | 14 | SO50724 | 2023-07-29 | 393.43 | 4423.24 | 1229.46 | |||
SO49893_32 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 265 | 523 | 3 | 2023-06-03 | 202.33 | 5.06 | 2023-05-22 | 1 | 187.16 | 1 | 202.33 | 32 | SO49893 | 2023-05-29 | 16.19 | 187.16 | 202.33 | |||
SO69422_14 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 298 | 650 | 1 | 2024-07-03 | 4048.80 | 101.22 | 2024-06-21 | 5 | 739.04 | 1 | 4048.80 | 14 | SO69422 | 2024-06-28 | 323.90 | 3695.21 | 809.76 | |||
SO57042_24 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 482 | 258 | 4 | 2024-01-03 | 16.18 | 0.40 | 2023-12-22 | 3 | 3.36 | 1 | 16.18 | 24 | SO57042 | 2023-12-29 | 1.29 | 10.09 | 5.39 | |||
SO50663_19 | 286E-4915-89 | PO19343130555 | 100 | 282 | 448 | 24 | 4 | 2023-08-03 | 119.94 | 3.00 | 2023-07-22 | 10 | 8.25 | 1 | 119.94 | 19 | SO50663 | 2023-07-29 | 9.60 | 82.46 | 11.99 | |||
SO67273_34 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 353 | 475 | 4 | 2024-06-03 | 9743.96 | 243.60 | 2024-05-22 | 7 | 1265.62 | 1 | 9743.96 | 34 | SO67273 | 2024-05-29 | 779.52 | 8859.34 | 1391.99 | |||
SO46966_20 | 8FBD-4E87-82 | PO15631150454 | 100 | 282 | 308 | 43 | 1 | 2022-10-03 | 1488.55 | 37.21 | 2022-09-21 | 2 | 660.91 | 1 | 1488.55 | 20 | SO46966 | 2022-09-28 | 119.08 | 1321.83 | 744.27 | |||
SO57036_27 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 588 | 43 | 1 | 2024-01-03 | 1385.08 | 34.63 | 2023-12-22 | 3 | 419.78 | 1 | 1385.08 | 27 | SO57036 | 2023-12-29 | 110.81 | 1259.34 | 461.69 | |||
SO47355_40 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 375 | 2 | 24 | 4 | 278.37 | 2022-11-03 | 13918.37 | 341.00 | 2022-10-22 | 11 | 1320.68 | 1 | 13640.00 | 40 | SO47355 | 2022-10-29 | 1091.20 | 14527.52 | 1265.31 | 0.02 |
SO57042_15 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 582 | 258 | 4 | 2024-01-03 | 4082.38 | 102.06 | 2023-12-22 | 4 | 1082.51 | 1 | 4082.38 | 15 | SO57042 | 2023-12-29 | 326.59 | 4330.04 | 1020.59 | |||
SO46972_19 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 410 | 650 | 1 | 2022-10-03 | 182.24 | 4.56 | 2022-09-21 | 5 | 26.97 | 1 | 182.24 | 19 | SO46972 | 2022-09-28 | 14.58 | 134.85 | 36.45 | |||
SO46058_24 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 334 | 240 | 4 | 2022-07-03 | 419.46 | 10.49 | 2022-06-21 | 1 | 413.15 | 1 | 419.46 | 24 | SO46058 | 2022-06-28 | 33.56 | 413.15 | 419.46 | |||
SO50226_33 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 439 | 78 | 4 | 2023-07-03 | 780.82 | 19.52 | 2023-06-21 | 1 | 722.26 | 1 | 780.82 | 33 | SO50226 | 2023-06-28 | 62.47 | 722.26 | 780.82 | |||
SO45290_2 | 913D-41B7-81 | PO16037118184 | 100 | 282 | 345 | 384 | 4 | 2022-04-05 | 6119.98 | 153.00 | 2022-03-24 | 3 | 1912.15 | 1 | 6119.98 | 2 | SO45290 | 2022-03-31 | 489.60 | 5736.46 | 2039.99 | |||
SO53531_40 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 551 | 187 | 4 | 2023-11-03 | 633.72 | 15.84 | 2023-10-22 | 4 | 144.59 | 1 | 633.72 | 40 | SO53531 | 2023-10-29 | 50.70 | 578.38 | 158.43 | |||
SO71902_2 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 588 | 61 | 4 | 2024-08-03 | 923.39 | 23.08 | 2024-07-22 | 2 | 419.78 | 1 | 923.39 | 2 | SO71902 | 2024-07-29 | 73.87 | 839.56 | 461.69 | |||
SO67273_49 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 488 | 475 | 4 | 2024-06-03 | 161.97 | 4.05 | 2024-05-22 | 5 | 41.57 | 1 | 161.97 | 49 | SO67273 | 2024-05-29 | 12.96 | 207.86 | 32.39 | |||
SO49831_35 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 397 | 475 | 4 | 2023-06-03 | 48.59 | 1.21 | 2023-05-22 | 2 | 17.98 | 1 | 48.59 | 35 | SO49831 | 2023-05-29 | 3.89 | 35.96 | 24.29 | |||
SO44777_20 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 218 | 366 | 4 | 2022-02-02 | 17.10 | 0.43 | 2022-01-21 | 3 | 3.40 | 1 | 17.10 | 20 | SO44777 | 2022-01-28 | 1.37 | 10.19 | 5.70 | |||
SO57186_26 | EF93-4946-97 | PO8845159326 | 100 | 282 | 463 | 546 | 3 | 2024-01-03 | 73.47 | 1.84 | 2023-12-22 | 5 | 9.16 | 1 | 73.47 | 26 | SO57186 | 2023-12-29 | 5.88 | 45.80 | 14.69 | |||
SO65160_2 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 580 | 2 | 24 | 4 | 217.05 | 2024-05-03 | 10852.32 | 265.88 | 2024-04-21 | 11 | 1082.51 | 1 | 10635.27 | 2 | SO65160 | 2024-04-28 | 850.82 | 11907.61 | 986.57 | 0.02 |
SO45555_16 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 347 | 366 | 4 | 2022-05-03 | 6119.98 | 153.00 | 2022-04-21 | 3 | 1912.15 | 1 | 6119.98 | 16 | SO45555 | 2022-04-28 | 489.60 | 5736.46 | 2039.99 | |||
SO55256_29 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 570 | 331 | 4 | 2023-12-03 | 890.82 | 22.27 | 2023-11-21 | 2 | 461.44 | 1 | 890.82 | 29 | SO55256 | 2023-11-28 | 71.27 | 922.89 | 445.41 | |||
SO67347_9 | 6E87-4127-80 | PO8787117055 | 100 | 282 | 490 | 523 | 3 | 2024-06-03 | 194.36 | 4.86 | 2024-05-22 | 6 | 41.57 | 1 | 194.36 | 9 | SO67347 | 2024-05-29 | 15.55 | 249.43 | 32.39 | |||
SO58919_18 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 499 | 420 | 4 | 2024-02-02 | 3614.08 | 90.35 | 2024-01-21 | 6 | 601.74 | 1 | 3614.08 | 18 | SO58919 | 2024-01-28 | 289.13 | 3610.46 | 602.35 | |||
SO49483_9 | 7C7A-4ABF-BA | PO9686173262 | 100 | 282 | 358 | 457 | 4 | 2023-05-03 | 1229.46 | 30.74 | 2023-04-21 | 1 | 1105.81 | 1 | 1229.46 | 9 | SO49483 | 2023-04-28 | 98.36 | 1105.81 | 1229.46 |
Generated 2024-09-20 10:40:10.638 UTC