[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 970 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57062_4 | D146-4B3C-BB | PO11745129321 | 100 | 282 | 481 | 97 | 4 | 2024-01-03 | 43.15 | 1.08 | 2023-12-22 | 8 | 3.36 | 1 | 43.15 | 4 | SO57062 | 2023-12-29 | 3.45 | 26.90 | 5.39 | |||
SO50217_9 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 466 | 650 | 1 | 2023-07-03 | 14.13 | 0.35 | 2023-06-21 | 1 | 9.71 | 1 | 14.13 | 9 | SO50217 | 2023-06-28 | 1.13 | 9.71 | 14.13 | |||
SO47028_32 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 360 | 312 | 4 | 2022-10-03 | 2458.92 | 61.47 | 2022-09-21 | 2 | 1105.81 | 1 | 2458.92 | 32 | SO47028 | 2022-09-28 | 196.71 | 2211.62 | 1229.46 | |||
SO46972_16 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 366 | 650 | 1 | 2022-10-03 | 647.99 | 16.20 | 2022-09-21 | 1 | 598.44 | 1 | 647.99 | 16 | SO46972 | 2022-09-28 | 51.84 | 598.44 | 647.99 | |||
SO65157_10 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 560 | 582 | 4 | 2024-05-03 | 728.91 | 18.22 | 2024-04-21 | 1 | 755.15 | 1 | 728.91 | 10 | SO65157 | 2024-04-28 | 58.31 | 755.15 | 728.91 | |||
SO63157_1 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 363 | 650 | 1 | 2024-04-04 | 8261.96 | 206.55 | 2024-03-23 | 6 | 1251.98 | 1 | 8261.96 | 1 | SO63157 | 2024-03-30 | 660.96 | 7511.89 | 1376.99 | |||
SO46671_35 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 329 | 2 | 523 | 3 | 108.99 | 2022-09-02 | 5449.61 | 133.52 | 2022-08-21 | 12 | 486.71 | 1 | 5340.62 | 35 | SO46671 | 2022-08-28 | 427.25 | 5840.48 | 454.13 | 0.02 |
SO51833_10 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 513 | 385 | 4 | 2023-10-03 | 436.91 | 10.92 | 2023-09-21 | 2 | 199.38 | 1 | 436.91 | 10 | SO51833 | 2023-09-28 | 34.95 | 398.75 | 218.45 | |||
SO63257_1 | B81B-4565-85 | PO5771197507 | 100 | 282 | 477 | 79 | 3 | 2024-04-04 | 17.96 | 0.45 | 2024-03-23 | 6 | 1.87 | 1 | 17.96 | 1 | SO63257 | 2024-03-30 | 1.44 | 11.20 | 2.99 | |||
SO53459_11 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 465 | 582 | 4 | 2023-11-03 | 88.16 | 2.20 | 2023-10-22 | 6 | 9.16 | 1 | 88.16 | 11 | SO53459 | 2023-10-29 | 7.05 | 54.96 | 14.69 | |||
SO47355_1 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 423 | 24 | 4 | 2022-11-03 | 495.69 | 12.39 | 2022-10-22 | 3 | 122.27 | 1 | 495.69 | 1 | SO47355 | 2022-10-29 | 39.66 | 366.81 | 165.23 | |||
SO63257_3 | B81B-4565-85 | PO5771197507 | 100 | 282 | 490 | 79 | 3 | 2024-04-04 | 129.58 | 3.24 | 2024-03-23 | 4 | 41.57 | 1 | 129.58 | 3 | SO63257 | 2024-03-30 | 10.37 | 166.29 | 32.39 | |||
SO71902_34 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 487 | 61 | 4 | 2024-08-03 | 164.97 | 4.12 | 2024-07-22 | 5 | 20.57 | 1 | 164.97 | 34 | SO71902 | 2024-07-29 | 13.20 | 102.83 | 32.99 | |||
SO49166_19 | 142E-4351-A4 | PO8845115490 | 100 | 282 | 399 | 546 | 3 | 2023-04-05 | 168.87 | 4.22 | 2023-03-24 | 5 | 24.99 | 1 | 168.87 | 19 | SO49166 | 2023-03-31 | 13.51 | 124.97 | 33.77 | |||
SO69539_4 | 9591-4159-98 | PO2320111510 | 100 | 282 | 408 | 529 | 4 | 2024-07-03 | 72.16 | 1.80 | 2024-06-21 | 1 | 53.40 | 1 | 72.16 | 4 | SO69539 | 2024-06-28 | 5.77 | 53.40 | 72.16 | |||
SO53470_26 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 570 | 13 | 420 | 4 | 50.11 | 2023-11-03 | 334.06 | 7.10 | 2023-10-22 | 1 | 461.44 | 1 | 283.95 | 26 | SO53470 | 2023-10-29 | 22.72 | 461.44 | 334.06 | 0.15 |
SO69441_14 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 376 | 97 | 4 | 2024-07-03 | 7330.05 | 183.25 | 2024-06-21 | 5 | 1554.95 | 1 | 7330.05 | 14 | SO69441 | 2024-06-28 | 586.40 | 7774.74 | 1466.01 | |||
SO51090_24 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 592 | 475 | 4 | 2023-09-02 | 2033.96 | 50.85 | 2023-08-21 | 6 | 308.22 | 1 | 2033.96 | 24 | SO51090 | 2023-08-28 | 162.72 | 1849.31 | 338.99 | |||
SO65181_4 | B8F6-4E3D-AA | PO16124172494 | 100 | 282 | 481 | 649 | 4 | 2024-05-03 | 10.79 | 0.27 | 2024-04-21 | 2 | 3.36 | 1 | 10.79 | 4 | SO65181 | 2024-04-28 | 0.86 | 6.72 | 5.39 | |||
SO49481_23 | 474A-4DD1-9B | PO10701112208 | 100 | 282 | 354 | 133 | 4 | 2023-05-03 | 2485.70 | 62.14 | 2023-04-21 | 2 | 1117.86 | 1 | 2485.70 | 23 | SO49481 | 2023-04-28 | 198.86 | 2235.71 | 1242.85 | |||
SO67298_16 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 574 | 205 | 4 | 2024-06-03 | 12873.98 | 321.85 | 2024-05-22 | 9 | 1481.94 | 1 | 12873.98 | 16 | SO67298 | 2024-05-29 | 1029.92 | 13337.44 | 1430.44 | |||
SO69561_52 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 524 | 546 | 3 | 2024-07-03 | 950.58 | 23.76 | 2024-06-21 | 6 | 144.59 | 1 | 950.58 | 52 | SO69561 | 2024-06-28 | 76.05 | 867.56 | 158.43 | |||
SO49490_24 | 0396-4322-83 | PO19343175441 | 100 | 282 | 233 | 24 | 4 | 2023-05-03 | 115.36 | 2.88 | 2023-04-21 | 4 | 29.08 | 1 | 115.36 | 24 | SO49490 | 2023-04-28 | 9.23 | 116.32 | 28.84 | |||
SO57042_18 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 287 | 258 | 4 | 2024-01-03 | 202.33 | 5.06 | 2023-12-22 | 1 | 204.63 | 1 | 202.33 | 18 | SO57042 | 2023-12-29 | 16.19 | 204.63 | 202.33 | |||
SO71856_1 | 3F8D-47BA-BC | PO16530177647 | 100 | 282 | 569 | 601 | 1 | 2024-08-03 | 445.41 | 11.14 | 2024-07-22 | 1 | 461.44 | 1 | 445.41 | 1 | SO71856 | 2024-07-29 | 35.63 | 461.44 | 445.41 | |||
SO50313_42 | B452-44E9-91 | PO7656143984 | 100 | 282 | 343 | 403 | 4 | 2023-07-03 | 939.59 | 23.49 | 2023-06-21 | 2 | 486.71 | 1 | 939.59 | 42 | SO50313 | 2023-06-28 | 75.17 | 973.41 | 469.79 | |||
SO57036_17 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 298 | 43 | 1 | 2024-01-03 | 809.76 | 20.24 | 2023-12-22 | 1 | 739.04 | 1 | 809.76 | 17 | SO57036 | 2023-12-29 | 64.78 | 739.04 | 809.76 | |||
SO47056_24 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 331 | 403 | 4 | 2022-10-03 | 469.79 | 11.74 | 2022-09-21 | 1 | 486.71 | 1 | 469.79 | 24 | SO47056 | 2022-09-28 | 37.58 | 486.71 | 469.79 | |||
SO53496_4 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 572 | 13 | 295 | 4 | 50.11 | 2023-11-03 | 334.06 | 7.10 | 2023-10-22 | 1 | 461.44 | 1 | 283.95 | 4 | SO53496 | 2023-10-29 | 22.72 | 461.44 | 334.06 | 0.15 |
SO51090_7 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 588 | 475 | 4 | 2023-09-02 | 1846.78 | 46.17 | 2023-08-21 | 4 | 419.78 | 1 | 1846.78 | 7 | SO51090 | 2023-08-28 | 147.74 | 1679.11 | 461.69 | |||
SO57121_12 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 378 | 79 | 3 | 2024-01-03 | 2932.02 | 73.30 | 2023-12-22 | 2 | 1554.95 | 1 | 2932.02 | 12 | SO57121 | 2023-12-29 | 234.56 | 3109.90 | 1466.01 |
Generated 2024-09-20 12:37:26.837 UTC