[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '285' > SKIP 2500 SHUFFLE SKIP 1000 < SKIP 30 > < TAKE 60 >
60 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO63144_1 | F622-47B8-BF | PO16965152780 | 100 | 285 | 605 | 441 | 5 | 2024-05-29 | 323.99 | 8.10 | 2024-05-17 | 1 | 343.65 | 1 | 323.99 | 1 | SO63144 | 2024-05-24 | 25.92 | 343.65 | 323.99 | |||
| SO71948_18 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 380 | 170 | 5 | 2024-09-27 | 10262.07 | 256.55 | 2024-09-15 | 7 | 1554.95 | 1 | 10262.07 | 18 | SO71948 | 2024-09-22 | 820.97 | 10884.64 | 1466.01 | |||
| SO69394_19 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 376 | 206 | 5 | 2024-08-27 | 2932.02 | 73.30 | 2024-08-15 | 2 | 1554.95 | 1 | 2932.02 | 19 | SO69394 | 2024-08-22 | 234.56 | 3109.90 | 1466.01 | |||
| SO69451_7 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 502 | 260 | 5 | 2024-08-27 | 400.10 | 10.00 | 2024-08-15 | 2 | 199.85 | 1 | 400.10 | 7 | SO69451 | 2024-08-22 | 32.01 | 399.70 | 200.05 | |||
| SO46995_6 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 415 | 62 | 5 | 2022-11-27 | 594.11 | 14.85 | 2022-11-15 | 3 | 146.55 | 1 | 594.11 | 6 | SO46995 | 2022-11-22 | 47.53 | 439.64 | 198.04 | |||
| SO55331_12 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 544 | 494 | 5 | 2024-01-27 | 97.19 | 2.43 | 2024-01-15 | 2 | 35.96 | 1 | 97.19 | 12 | SO55331 | 2024-01-22 | 7.78 | 71.92 | 48.59 | |||
| SO51081_5 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 591 | 676 | 5 | 2023-10-27 | 338.99 | 8.47 | 2023-10-15 | 1 | 308.22 | 1 | 338.99 | 5 | SO51081 | 2023-10-22 | 27.12 | 308.22 | 338.99 | |||
| SO69518_10 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 295 | 63 | 5 | 2024-08-27 | 818.70 | 20.47 | 2024-08-15 | 1 | 747.20 | 1 | 818.70 | 10 | SO69518 | 2024-08-22 | 65.50 | 747.20 | 818.70 | |||
| SO57088_19 | EA31-4951-8A | PO2842199218 | 100 | 285 | 390 | 700 | 5 | 2024-02-27 | 3361.47 | 84.04 | 2024-02-15 | 5 | 713.08 | 1 | 3361.47 | 19 | SO57088 | 2024-02-22 | 268.92 | 3565.40 | 672.29 | |||
| SO65248_15 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 388 | 170 | 5 | 2024-06-27 | 2689.18 | 67.23 | 2024-06-15 | 4 | 713.08 | 1 | 2689.18 | 15 | SO65248 | 2024-06-22 | 215.13 | 2852.32 | 672.29 | |||
| SO57104_11 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 481 | 531 | 5 | 2024-02-27 | 21.58 | 0.54 | 2024-02-15 | 4 | 3.36 | 1 | 21.58 | 11 | SO57104 | 2024-02-22 | 1.73 | 13.45 | 5.39 | |||
| SO53568_7 | 4523-4AB4-99 | PO9222138547 | 100 | 285 | 287 | 171 | 5 | 2023-12-28 | 404.66 | 10.12 | 2023-12-16 | 2 | 204.63 | 1 | 404.66 | 7 | SO53568 | 2023-12-23 | 32.37 | 409.25 | 202.33 | |||
| SO69533_10 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 355 | 476 | 5 | 2024-08-27 | 2783.99 | 69.60 | 2024-08-15 | 2 | 1265.62 | 1 | 2783.99 | 10 | SO69533 | 2024-08-22 | 222.72 | 2531.24 | 1391.99 | |||
| SO46673_15 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 470 | 4 | 315 | 5 | 66.48 | 2022-10-27 | 664.83 | 14.96 | 2022-10-15 | 35 | 15.67 | 1 | 598.34 | 15 | SO46673 | 2022-10-22 | 47.87 | 548.48 | 19.00 | 0.10 |
| SO47042_53 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 460 | 566 | 5 | 2022-11-27 | 485.95 | 12.15 | 2022-11-15 | 9 | 37.12 | 1 | 485.95 | 53 | SO47042 | 2022-11-22 | 38.88 | 334.09 | 53.99 | |||
| SO71839_14 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 496 | 611 | 5 | 2024-09-27 | 1204.69 | 30.12 | 2024-09-15 | 2 | 601.74 | 1 | 1204.69 | 14 | SO71839 | 2024-09-22 | 96.38 | 1203.49 | 602.35 | |||
| SO51864_18 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 400 | 422 | 5 | 2023-11-27 | 74.30 | 1.86 | 2023-11-15 | 2 | 27.49 | 1 | 74.30 | 18 | SO51864 | 2023-11-22 | 5.94 | 54.99 | 37.15 | |||
| SO55313_1 | E5E5-4D8A-89 | PO3741111643 | 100 | 285 | 583 | 404 | 5 | 2024-01-27 | 1020.59 | 25.51 | 2024-01-15 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO55313 | 2024-01-22 | 81.65 | 1082.51 | 1020.59 | |||
| SO65207_21 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 506 | 611 | 5 | 2024-06-27 | 400.10 | 10.00 | 2024-06-15 | 2 | 199.85 | 1 | 400.10 | 21 | SO65207 | 2024-06-22 | 32.01 | 399.70 | 200.05 | |||
| SO69394_13 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 604 | 206 | 5 | 2024-08-27 | 323.99 | 8.10 | 2024-08-15 | 1 | 343.65 | 1 | 323.99 | 13 | SO69394 | 2024-08-22 | 25.92 | 343.65 | 323.99 | |||
| SO55234_18 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 465 | 676 | 5 | 2024-01-27 | 58.78 | 1.47 | 2024-01-15 | 4 | 9.16 | 1 | 58.78 | 18 | SO55234 | 2024-01-22 | 4.70 | 36.64 | 14.69 | |||
| SO46933_33 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 369 | 206 | 5 | 2022-11-27 | 1466.01 | 36.65 | 2022-11-15 | 1 | 1518.79 | 1 | 1466.01 | 33 | SO46933 | 2022-11-22 | 117.28 | 1518.79 | 1466.01 | |||
| SO53563_20 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 436 | 170 | 5 | 2023-12-28 | 1784.49 | 44.61 | 2023-12-16 | 5 | 360.94 | 1 | 1784.49 | 20 | SO53563 | 2023-12-23 | 142.76 | 1804.71 | 356.90 | |||
| SO50307_6 | C275-40B9-98 | PO6293157460 | 100 | 285 | 321 | 612 | 5 | 2023-08-27 | 469.79 | 11.74 | 2023-08-15 | 1 | 486.71 | 1 | 469.79 | 6 | SO50307 | 2023-08-22 | 37.58 | 486.71 | 469.79 | |||
| SO47040_1 | 5A71-45F5-B9 | PO5568168365 | 100 | 285 | 216 | 422 | 5 | 2022-11-27 | 20.19 | 0.50 | 2022-11-15 | 1 | 13.88 | 1 | 20.19 | 1 | SO47040 | 2022-11-22 | 1.61 | 13.88 | 20.19 | |||
| SO50230_2 | E4FB-421B-A5 | PO11542120242 | 100 | 285 | 333 | 62 | 5 | 2023-08-27 | 469.79 | 11.74 | 2023-08-15 | 1 | 486.71 | 1 | 469.79 | 2 | SO50230 | 2023-08-22 | 37.58 | 486.71 | 469.79 | |||
| SO51081_8 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 465 | 676 | 5 | 2023-10-27 | 88.16 | 2.20 | 2023-10-15 | 6 | 9.16 | 1 | 88.16 | 8 | SO51081 | 2023-10-22 | 7.05 | 54.96 | 14.69 | |||
| SO57126_15 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 240 | 45 | 5 | 2024-02-27 | 3435.60 | 85.89 | 2024-02-15 | 4 | 868.63 | 1 | 3435.60 | 15 | SO57126 | 2024-02-22 | 274.85 | 3474.54 | 858.90 | |||
| SO57039_1 | 34D9-46BE-B4 | PO15051154053 | 100 | 285 | 474 | 207 | 5 | 2024-02-27 | 377.95 | 9.45 | 2024-02-15 | 9 | 26.18 | 1 | 377.95 | 1 | SO57039 | 2024-02-22 | 30.24 | 235.59 | 41.99 | |||
| SO69518_23 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 512 | 63 | 5 | 2024-08-27 | 655.36 | 16.38 | 2024-08-15 | 3 | 199.38 | 1 | 655.36 | 23 | SO69518 | 2024-08-22 | 52.43 | 598.13 | 218.45 | |||
| SO50726_23 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 331 | 170 | 5 | 2023-09-27 | 2818.76 | 70.47 | 2023-09-15 | 6 | 486.71 | 1 | 2818.76 | 23 | SO50726 | 2023-09-22 | 225.50 | 2920.24 | 469.79 | |||
| SO51775_44 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 217 | 700 | 5 | 2023-11-27 | 62.98 | 1.57 | 2023-11-15 | 3 | 13.09 | 1 | 62.98 | 44 | SO51775 | 2023-11-22 | 5.04 | 39.26 | 20.99 | |||
| SO67340_1 | 429B-48A6-9C | PO4176157624 | 100 | 285 | 382 | 458 | 5 | 2024-07-28 | 672.29 | 16.81 | 2024-07-16 | 1 | 713.08 | 1 | 672.29 | 1 | SO67340 | 2024-07-23 | 53.78 | 713.08 | 672.29 | |||
| SO50231_29 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 370 | 512 | 5 | 2023-08-27 | 2932.02 | 73.30 | 2023-08-15 | 2 | 1518.79 | 1 | 2932.02 | 29 | SO50231 | 2023-08-22 | 234.56 | 3037.57 | 1466.01 | |||
| SO71948_23 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 418 | 170 | 5 | 2024-09-27 | 713.80 | 17.84 | 2024-09-15 | 2 | 360.94 | 1 | 713.80 | 23 | SO71948 | 2024-09-22 | 57.10 | 721.89 | 356.90 | |||
| SO65207_16 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 488 | 611 | 5 | 2024-06-27 | 129.58 | 3.24 | 2024-06-15 | 4 | 41.57 | 1 | 129.58 | 16 | SO65207 | 2024-06-22 | 10.37 | 166.29 | 32.39 | |||
| SO51780_4 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 580 | 531 | 5 | 2023-11-27 | 3061.78 | 76.54 | 2023-11-15 | 3 | 1082.51 | 1 | 3061.78 | 4 | SO51780 | 2023-11-22 | 244.94 | 3247.53 | 1020.59 | |||
| SO69394_7 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 388 | 206 | 5 | 2024-08-27 | 1344.59 | 33.61 | 2024-08-15 | 2 | 713.08 | 1 | 1344.59 | 7 | SO69394 | 2024-08-22 | 107.57 | 1426.16 | 672.29 | |||
| SO69474_1 | 2DD3-46CB-BD | PO18560139140 | 100 | 285 | 605 | 531 | 5 | 2024-08-27 | 323.99 | 8.10 | 2024-08-15 | 1 | 343.65 | 1 | 323.99 | 1 | SO69474 | 2024-08-22 | 25.92 | 343.65 | 323.99 | |||
| SO53524_33 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 506 | 611 | 5 | 2023-12-28 | 400.10 | 10.00 | 2023-12-16 | 2 | 199.85 | 1 | 400.10 | 33 | SO53524 | 2023-12-23 | 32.01 | 399.70 | 200.05 | |||
| SO71839_34 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 488 | 611 | 5 | 2024-09-27 | 194.36 | 4.86 | 2024-09-15 | 6 | 41.57 | 1 | 194.36 | 34 | SO71839 | 2024-09-22 | 15.55 | 249.43 | 32.39 | |||
| SO67260_40 | 6224-4229-B8 | PO522163557 | 100 | 285 | 361 | 676 | 5 | 2024-07-28 | 2753.99 | 68.85 | 2024-07-16 | 2 | 1251.98 | 1 | 2753.99 | 40 | SO67260 | 2024-07-23 | 220.32 | 2503.96 | 1376.99 | |||
| SO61217_17 | 9B9A-4C8B-93 | PO9889149314 | 100 | 285 | 359 | 494 | 5 | 2024-04-28 | 2753.99 | 68.85 | 2024-04-16 | 2 | 1251.98 | 1 | 2753.99 | 17 | SO61217 | 2024-04-23 | 220.32 | 2503.96 | 1376.99 | |||
| SO46635_2 | 61A1-4A71-99 | PO10005144378 | 100 | 285 | 453 | 628 | 5 | 2022-10-27 | 35.99 | 0.90 | 2022-10-15 | 1 | 24.75 | 1 | 35.99 | 2 | SO46635 | 2022-10-22 | 2.88 | 24.75 | 35.99 | |||
| SO57088_25 | EA31-4951-8A | PO2842199218 | 100 | 285 | 231 | 700 | 5 | 2024-02-27 | 149.97 | 3.75 | 2024-02-15 | 5 | 38.49 | 1 | 149.97 | 25 | SO57088 | 2024-02-22 | 12.00 | 192.46 | 29.99 | |||
| SO51081_2 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 596 | 676 | 5 | 2023-10-27 | 323.99 | 8.10 | 2023-10-15 | 1 | 294.58 | 1 | 323.99 | 2 | SO51081 | 2023-10-22 | 25.92 | 294.58 | 323.99 | |||
| SO61228_27 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 545 | 81 | 5 | 2024-04-28 | 24.29 | 0.61 | 2024-04-16 | 1 | 17.98 | 1 | 24.29 | 27 | SO61228 | 2024-04-23 | 1.94 | 17.98 | 24.29 | |||
| SO55253_30 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 357 | 530 | 5 | 2024-01-27 | 2783.99 | 69.60 | 2024-01-15 | 2 | 1265.62 | 1 | 2783.99 | 30 | SO55253 | 2024-01-22 | 222.72 | 2531.24 | 1391.99 | |||
| SO57104_12 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 234 | 531 | 5 | 2024-02-27 | 179.96 | 4.50 | 2024-02-15 | 6 | 38.49 | 1 | 179.96 | 12 | SO57104 | 2024-02-22 | 14.40 | 230.95 | 29.99 | |||
| SO65242_19 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 568 | 627 | 5 | 2024-06-27 | 890.82 | 22.27 | 2024-06-15 | 2 | 461.44 | 1 | 890.82 | 19 | SO65242 | 2024-06-22 | 71.27 | 922.89 | 445.41 | |||
| SO49865_35 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 333 | 81 | 5 | 2023-07-28 | 1879.18 | 46.98 | 2023-07-16 | 4 | 486.71 | 1 | 1879.18 | 35 | SO49865 | 2023-07-23 | 150.33 | 1946.83 | 469.79 | |||
| SO63245_20 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 488 | 63 | 5 | 2024-05-29 | 32.39 | 0.81 | 2024-05-17 | 1 | 41.57 | 1 | 32.39 | 20 | SO63245 | 2024-05-24 | 2.59 | 41.57 | 32.39 | |||
| SO55328_8 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 214 | 81 | 5 | 2024-01-27 | 125.96 | 3.15 | 2024-01-15 | 6 | 13.09 | 1 | 125.96 | 8 | SO55328 | 2024-01-22 | 10.08 | 78.52 | 20.99 | |||
| SO63245_23 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 558 | 63 | 5 | 2024-05-29 | 242.99 | 6.07 | 2024-05-17 | 1 | 179.82 | 1 | 242.99 | 23 | SO63245 | 2024-05-24 | 19.44 | 179.82 | 242.99 | |||
| SO65248_16 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 580 | 170 | 5 | 2024-06-27 | 3061.78 | 76.54 | 2024-06-15 | 3 | 1082.51 | 1 | 3061.78 | 16 | SO65248 | 2024-06-22 | 244.94 | 3247.53 | 1020.59 | |||
| SO50306_11 | D376-4A40-86 | PO5858194676 | 100 | 285 | 409 | 566 | 5 | 2023-08-27 | 1046.28 | 26.16 | 2023-08-15 | 5 | 185.82 | 1 | 1046.28 | 11 | SO50306 | 2023-08-22 | 83.70 | 929.10 | 209.26 | |||
| SO57017_5 | 4C6E-47EA-AD | PO19546126186 | 100 | 285 | 386 | 206 | 5 | 2024-02-27 | 672.29 | 16.81 | 2024-02-15 | 1 | 713.08 | 1 | 672.29 | 5 | SO57017 | 2024-02-22 | 53.78 | 713.08 | 672.29 | |||
| SO67260_18 | 6224-4229-B8 | PO522163557 | 100 | 285 | 476 | 676 | 5 | 2024-07-28 | 251.96 | 6.30 | 2024-07-16 | 6 | 26.18 | 1 | 251.96 | 18 | SO67260 | 2024-07-23 | 20.16 | 157.06 | 41.99 | |||
| SO50726_2 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 263 | 170 | 5 | 2023-09-27 | 1213.99 | 30.35 | 2023-09-15 | 6 | 187.16 | 1 | 1213.99 | 2 | SO50726 | 2023-09-22 | 97.12 | 1122.94 | 202.33 | |||
| SO67349_32 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 465 | 81 | 5 | 2024-07-28 | 58.78 | 1.47 | 2024-07-16 | 4 | 9.16 | 1 | 58.78 | 32 | SO67349 | 2024-07-23 | 4.70 | 36.64 | 14.69 |
Generated 2024-11-14 17:13:30.435 UTC