[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '285' > SKIP 2500 SHUFFLE < SKIP 251 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51081_35 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 472 | 676 | 5 | 2023-09-02 | 266.70 | 6.67 | 2023-08-21 | 7 | 23.75 | 1 | 266.70 | 35 | SO51081 | 2023-08-28 | 21.34 | 166.24 | 38.10 | |||
SO67349_2 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 222 | 2 | 81 | 5 | 4.87 | 2024-06-03 | 243.53 | 5.97 | 2024-05-22 | 12 | 13.09 | 1 | 238.66 | 2 | SO67349 | 2024-05-29 | 19.09 | 157.04 | 20.29 | 0.02 |
SO47424_9 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 360 | 368 | 5 | 2022-11-03 | 2458.92 | 61.47 | 2022-10-22 | 2 | 1105.81 | 1 | 2458.92 | 9 | SO47424 | 2022-10-29 | 196.71 | 2211.62 | 1229.46 | |||
SO50306_14 | D376-4A40-86 | PO5858194676 | 100 | 285 | 391 | 566 | 5 | 2023-07-03 | 177.86 | 4.45 | 2023-06-21 | 2 | 65.81 | 1 | 177.86 | 14 | SO50306 | 2023-06-28 | 14.23 | 131.62 | 88.93 | |||
SO51081_29 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 214 | 11 | 676 | 5 | 4.72 | 2023-09-02 | 31.49 | 0.67 | 2023-08-21 | 2 | 13.09 | 1 | 26.77 | 29 | SO51081 | 2023-08-28 | 2.14 | 26.17 | 15.75 | 0.15 |
SO65165_5 | E659-4F16-8A | PO18241154115 | 100 | 285 | 573 | 477 | 5 | 2024-05-03 | 1430.44 | 35.76 | 2024-04-21 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO65165 | 2024-04-28 | 114.44 | 1481.94 | 1430.44 | |||
SO69451_18 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 496 | 260 | 5 | 2024-07-03 | 2409.38 | 60.23 | 2024-06-21 | 4 | 601.74 | 1 | 2409.38 | 18 | SO69451 | 2024-06-28 | 192.75 | 2406.97 | 602.35 | |||
SO50293_20 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 401 | 476 | 5 | 2023-07-03 | 65.60 | 1.64 | 2023-06-21 | 1 | 48.55 | 1 | 65.60 | 20 | SO50293 | 2023-06-28 | 5.25 | 48.55 | 65.60 | |||
SO50293_3 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 365 | 476 | 5 | 2023-07-03 | 1295.99 | 32.40 | 2023-06-21 | 2 | 598.44 | 1 | 1295.99 | 3 | SO50293 | 2023-06-28 | 103.68 | 1196.87 | 647.99 | |||
SO63144_1 | F622-47B8-BF | PO16965152780 | 100 | 285 | 605 | 441 | 5 | 2024-04-04 | 323.99 | 8.10 | 2024-03-23 | 1 | 343.65 | 1 | 323.99 | 1 | SO63144 | 2024-03-30 | 25.92 | 343.65 | 323.99 | |||
SO47042_29 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 308 | 566 | 5 | 2022-10-03 | 2232.82 | 55.82 | 2022-09-21 | 3 | 660.91 | 1 | 2232.82 | 29 | SO47042 | 2022-09-28 | 178.63 | 1982.74 | 744.27 | |||
SO69394_5 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 482 | 206 | 5 | 2024-07-03 | 37.76 | 0.94 | 2024-06-21 | 7 | 3.36 | 1 | 37.76 | 5 | SO69394 | 2024-06-28 | 3.02 | 23.54 | 5.39 | |||
SO63124_13 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 374 | 206 | 5 | 2024-04-04 | 2932.02 | 73.30 | 2024-03-23 | 2 | 1554.95 | 1 | 2932.02 | 13 | SO63124 | 2024-03-30 | 234.56 | 3109.90 | 1466.01 | |||
SO47067_5 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 213 | 135 | 5 | 2022-10-03 | 20.19 | 0.50 | 2022-09-21 | 1 | 13.88 | 1 | 20.19 | 5 | SO47067 | 2022-09-28 | 1.61 | 13.88 | 20.19 | |||
SO50293_2 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 358 | 476 | 5 | 2023-07-03 | 2458.92 | 61.47 | 2023-06-21 | 2 | 1105.81 | 1 | 2458.92 | 2 | SO50293 | 2023-06-28 | 196.71 | 2211.62 | 1229.46 | |||
SO71866_20 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 601 | 627 | 5 | 2024-08-03 | 32.39 | 0.81 | 2024-07-22 | 1 | 23.97 | 1 | 32.39 | 20 | SO71866 | 2024-07-29 | 2.59 | 23.97 | 32.39 | |||
SO71948_12 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 388 | 170 | 5 | 2024-08-03 | 3361.47 | 84.04 | 2024-07-22 | 5 | 713.08 | 1 | 3361.47 | 12 | SO71948 | 2024-07-29 | 268.92 | 3565.40 | 672.29 | |||
SO46672_45 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 323 | 81 | 5 | 2022-09-02 | 2348.97 | 58.72 | 2022-08-21 | 5 | 486.71 | 1 | 2348.97 | 45 | SO46672 | 2022-08-28 | 187.92 | 2433.53 | 469.79 | |||
SO55331_20 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 475 | 494 | 5 | 2023-12-03 | 41.99 | 1.05 | 2023-11-21 | 1 | 26.18 | 1 | 41.99 | 20 | SO55331 | 2023-11-28 | 3.36 | 26.18 | 41.99 | |||
SO65248_22 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 581 | 170 | 5 | 2024-05-03 | 2041.19 | 51.03 | 2024-04-21 | 2 | 1082.51 | 1 | 2041.19 | 22 | SO65248 | 2024-04-28 | 163.30 | 2165.02 | 1020.59 | |||
SO58971_8 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 484 | 2 | 611 | 5 | 1.11 | 2024-02-02 | 55.33 | 1.36 | 2024-01-21 | 12 | 2.97 | 1 | 54.23 | 8 | SO58971 | 2024-01-28 | 4.34 | 35.68 | 4.61 | 0.02 |
SO50234_3 | 97E1-4282-8B | PO10150134950 | 100 | 285 | 457 | 9 | 5 | 2023-07-03 | 224.97 | 5.62 | 2023-06-21 | 5 | 30.93 | 1 | 224.97 | 3 | SO50234 | 2023-06-28 | 18.00 | 154.67 | 44.99 | |||
SO49159_14 | 15B4-4CCD-9A | PO7598122487 | 100 | 285 | 389 | 45 | 5 | 2023-04-05 | 600.26 | 15.01 | 2023-03-24 | 1 | 605.65 | 1 | 600.26 | 14 | SO49159 | 2023-03-31 | 48.02 | 605.65 | 600.26 | |||
SO65242_15 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 558 | 627 | 5 | 2024-05-03 | 485.99 | 12.15 | 2024-04-21 | 2 | 179.82 | 1 | 485.99 | 15 | SO65242 | 2024-04-28 | 38.88 | 359.63 | 242.99 | |||
SO49865_14 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 448 | 81 | 5 | 2023-06-03 | 47.98 | 1.20 | 2023-05-22 | 4 | 8.25 | 1 | 47.98 | 14 | SO49865 | 2023-05-29 | 3.84 | 32.98 | 11.99 | |||
SO50740_6 | 0ACE-4A34-92 | PO4089165876 | 100 | 285 | 352 | 368 | 5 | 2023-08-03 | 1242.85 | 31.07 | 2023-07-22 | 1 | 1117.86 | 1 | 1242.85 | 6 | SO50740 | 2023-07-29 | 99.43 | 1117.86 | 1242.85 | |||
SO55234_42 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 488 | 676 | 5 | 2023-12-03 | 129.58 | 3.24 | 2023-11-21 | 4 | 41.57 | 1 | 129.58 | 42 | SO55234 | 2023-11-28 | 10.37 | 166.29 | 32.39 | |||
SO46672_3 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 429 | 81 | 5 | 2022-09-02 | 324.45 | 8.11 | 2022-08-21 | 1 | 300.12 | 1 | 324.45 | 3 | SO46672 | 2022-08-28 | 25.96 | 300.12 | 324.45 | |||
SO69394_16 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 580 | 206 | 5 | 2024-07-03 | 2041.19 | 51.03 | 2024-06-21 | 2 | 1082.51 | 1 | 2041.19 | 16 | SO69394 | 2024-06-28 | 163.30 | 2165.02 | 1020.59 | |||
SO61228_33 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 234 | 81 | 5 | 2024-03-04 | 119.98 | 3.00 | 2024-02-21 | 4 | 38.49 | 1 | 119.98 | 33 | SO61228 | 2024-02-28 | 9.60 | 153.97 | 29.99 | |||
SO58924_19 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 501 | 297 | 5 | 2024-02-02 | 291.50 | 7.29 | 2024-01-21 | 4 | 53.93 | 1 | 291.50 | 19 | SO58924 | 2024-01-28 | 23.32 | 215.71 | 72.88 | |||
SO53625_7 | 98EA-458A-B9 | PO9744185498 | 100 | 285 | 511 | 98 | 5 | 2023-11-03 | 436.91 | 10.92 | 2023-10-22 | 2 | 199.38 | 1 | 436.91 | 7 | SO53625 | 2023-10-29 | 34.95 | 398.75 | 218.45 | |||
SO63281_13 | 6B19-4C4E-92 | PO3596158829 | 100 | 285 | 544 | 476 | 5 | 2024-04-04 | 48.59 | 1.21 | 2024-03-23 | 1 | 35.96 | 1 | 48.59 | 13 | SO63281 | 2024-03-30 | 3.89 | 35.96 | 48.59 | |||
SO49822_36 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 412 | 676 | 5 | 2023-06-03 | 180.13 | 4.50 | 2023-05-22 | 1 | 133.30 | 1 | 180.13 | 36 | SO49822 | 2023-05-29 | 14.41 | 133.30 | 180.13 | |||
SO71866_15 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 576 | 627 | 5 | 2024-08-03 | 1430.44 | 35.76 | 2024-07-22 | 1 | 1481.94 | 1 | 1430.44 | 15 | SO71866 | 2024-07-29 | 114.44 | 1481.94 | 1430.44 | |||
SO69510_3 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 476 | 422 | 5 | 2024-07-03 | 335.95 | 8.40 | 2024-06-21 | 8 | 26.18 | 1 | 335.95 | 3 | SO69510 | 2024-06-28 | 26.88 | 209.41 | 41.99 | |||
SO46654_1 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 422 | 404 | 5 | 2022-09-02 | 135.08 | 3.38 | 2022-08-21 | 2 | 49.98 | 1 | 135.08 | 1 | SO46654 | 2022-08-28 | 10.81 | 99.96 | 67.54 | |||
SO46995_6 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 415 | 62 | 5 | 2022-10-03 | 594.11 | 14.85 | 2022-09-21 | 3 | 146.55 | 1 | 594.11 | 6 | SO46995 | 2022-09-28 | 47.53 | 439.64 | 198.04 | |||
SO46383_9 | 2398-4D5E-8F | PO9106128085 | 100 | 285 | 351 | 7 | 602 | 5 | 590.62 | 2022-08-03 | 1687.50 | 27.42 | 2022-07-22 | 2 | 1898.09 | 1 | 1096.87 | 9 | SO46383 | 2022-07-29 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO63228_1 | 8736-4385-98 | PO11542125349 | 100 | 285 | 390 | 62 | 5 | 2024-04-04 | 672.29 | 16.81 | 2024-03-23 | 1 | 713.08 | 1 | 672.29 | 1 | SO63228 | 2024-03-30 | 53.78 | 713.08 | 672.29 | |||
SO49878_3 | 3EF0-4F28-B3 | PO3741190259 | 100 | 285 | 458 | 404 | 5 | 2023-06-03 | 44.99 | 1.12 | 2023-05-22 | 1 | 30.93 | 1 | 44.99 | 3 | SO49878 | 2023-05-29 | 3.60 | 30.93 | 44.99 | |||
SO49836_4 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 420 | 530 | 5 | 2023-06-03 | 141.62 | 3.54 | 2023-05-22 | 1 | 104.80 | 1 | 141.62 | 4 | SO49836 | 2023-05-29 | 11.33 | 104.80 | 141.62 | |||
SO50306_7 | D376-4A40-86 | PO5858194676 | 100 | 285 | 470 | 566 | 5 | 2023-07-03 | 45.59 | 1.14 | 2023-06-21 | 2 | 15.67 | 1 | 45.59 | 7 | SO50306 | 2023-06-28 | 3.65 | 31.34 | 22.79 | |||
SO65246_3 | 0818-4676-89 | PO9744127225 | 100 | 285 | 474 | 98 | 5 | 2024-05-03 | 83.99 | 2.10 | 2024-04-21 | 2 | 26.18 | 1 | 83.99 | 3 | SO65246 | 2024-04-28 | 6.72 | 52.35 | 41.99 | |||
SO67260_1 | 6224-4229-B8 | PO522163557 | 100 | 285 | 597 | 676 | 5 | 2024-06-03 | 323.99 | 8.10 | 2024-05-22 | 1 | 294.58 | 1 | 323.99 | 1 | SO67260 | 2024-05-29 | 25.92 | 294.58 | 323.99 | |||
SO69451_19 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 577 | 260 | 5 | 2024-07-03 | 728.91 | 18.22 | 2024-06-21 | 1 | 755.15 | 1 | 728.91 | 19 | SO69451 | 2024-06-28 | 58.31 | 755.15 | 728.91 | |||
SO69518_28 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 555 | 63 | 5 | 2024-07-03 | 191.70 | 4.79 | 2024-06-21 | 3 | 47.29 | 1 | 191.70 | 28 | SO69518 | 2024-06-28 | 15.34 | 141.86 | 63.90 | |||
SO58924_25 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 567 | 297 | 5 | 2024-02-02 | 1336.23 | 33.41 | 2024-01-21 | 3 | 461.44 | 1 | 1336.23 | 25 | SO58924 | 2024-01-28 | 106.90 | 1384.33 | 445.41 | |||
SO46672_17 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 239 | 81 | 5 | 2022-09-02 | 3123.27 | 78.08 | 2022-08-21 | 4 | 722.26 | 1 | 3123.27 | 17 | SO46672 | 2022-08-28 | 249.86 | 2889.03 | 780.82 | |||
SO65220_19 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 586 | 297 | 5 | 2024-05-03 | 445.41 | 11.14 | 2024-04-21 | 1 | 461.44 | 1 | 445.41 | 19 | SO65220 | 2024-04-28 | 35.63 | 461.44 | 445.41 | |||
SO49495_15 | A868-43CF-A4 | PO9570115481 | 100 | 285 | 224 | 585 | 5 | 2023-05-03 | 5.19 | 0.13 | 2023-04-21 | 1 | 5.23 | 1 | 5.19 | 15 | SO49495 | 2023-04-28 | 0.41 | 5.23 | 5.19 | |||
SO58924_22 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 560 | 297 | 5 | 2024-02-02 | 728.91 | 18.22 | 2024-01-21 | 1 | 755.15 | 1 | 728.91 | 22 | SO58924 | 2024-01-28 | 58.31 | 755.15 | 728.91 | |||
SO61173_34 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 234 | 676 | 5 | 2024-03-04 | 119.98 | 3.00 | 2024-02-21 | 4 | 38.49 | 1 | 119.98 | 34 | SO61173 | 2024-02-28 | 9.60 | 153.97 | 29.99 | |||
SO55234_37 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 231 | 676 | 5 | 2023-12-03 | 149.97 | 3.75 | 2023-11-21 | 5 | 38.49 | 1 | 149.97 | 37 | SO55234 | 2023-11-28 | 12.00 | 192.46 | 29.99 | |||
SO67331_7 | F7D7-49F2-83 | PO3741116971 | 100 | 285 | 482 | 404 | 5 | 2024-06-03 | 16.18 | 0.40 | 2024-05-22 | 3 | 3.36 | 1 | 16.18 | 7 | SO67331 | 2024-05-29 | 1.29 | 10.09 | 5.39 | |||
SO46672_16 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 375 | 81 | 5 | 2022-09-02 | 2617.88 | 65.45 | 2022-08-21 | 2 | 1320.68 | 1 | 2617.88 | 16 | SO46672 | 2022-08-28 | 209.43 | 2641.37 | 1308.94 | |||
SO63281_3 | 6B19-4C4E-92 | PO3596158829 | 100 | 285 | 359 | 476 | 5 | 2024-04-04 | 1376.99 | 34.42 | 2024-03-23 | 1 | 1251.98 | 1 | 1376.99 | 3 | SO63281 | 2024-03-30 | 110.16 | 1251.98 | 1376.99 | |||
SO67260_2 | 6224-4229-B8 | PO522163557 | 100 | 285 | 599 | 676 | 5 | 2024-06-03 | 323.99 | 8.10 | 2024-05-22 | 1 | 294.58 | 1 | 323.99 | 2 | SO67260 | 2024-05-29 | 25.92 | 294.58 | 323.99 | |||
SO57126_7 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 382 | 45 | 5 | 2024-01-03 | 2689.18 | 67.23 | 2023-12-22 | 4 | 713.08 | 1 | 2689.18 | 7 | SO57126 | 2023-12-29 | 215.13 | 2852.32 | 672.29 | |||
SO55234_26 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 591 | 676 | 5 | 2023-12-03 | 338.99 | 8.47 | 2023-11-21 | 1 | 308.22 | 1 | 338.99 | 26 | SO55234 | 2023-11-28 | 27.12 | 308.22 | 338.99 | |||
SO50756_20 | C414-447C-84 | PO9570119689 | 100 | 285 | 367 | 585 | 5 | 2023-08-03 | 647.99 | 16.20 | 2023-07-22 | 1 | 598.44 | 1 | 647.99 | 20 | SO50756 | 2023-07-29 | 51.84 | 598.44 | 647.99 | |||
SO63181_8 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 482 | 700 | 5 | 2024-04-04 | 26.97 | 0.67 | 2024-03-23 | 5 | 3.36 | 1 | 26.97 | 8 | SO63181 | 2024-03-30 | 2.16 | 16.81 | 5.39 |
Generated 2024-09-20 17:29:18.955 UTC