[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '283' > SKIP 2500 SHUFFLE < SKIP 970 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49870_41 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 236 | 660 | 3 | 2023-06-03 | 57.68 | 1.44 | 2023-05-22 | 2 | 29.08 | 1 | 57.68 | 41 | SO49870 | 2023-05-29 | 4.61 | 58.16 | 28.84 | |||
SO46648_48 | 2073-4051-9E | PO2494191557 | 100 | 283 | 428 | 184 | 4 | 2022-09-02 | 418.51 | 10.46 | 2022-08-21 | 2 | 185.82 | 1 | 418.51 | 48 | SO46648 | 2022-08-28 | 33.48 | 371.64 | 209.26 | |||
SO71949_29 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 580 | 54 | 2 | 2024-08-03 | 8164.75 | 204.12 | 2024-07-22 | 8 | 1082.51 | 1 | 8164.75 | 29 | SO71949 | 2024-07-29 | 653.18 | 8660.08 | 1020.59 | |||
SO65178_6 | 808E-413C-94 | PO16994175277 | 100 | 283 | 482 | 306 | 3 | 2024-05-03 | 10.79 | 0.27 | 2024-04-21 | 2 | 3.36 | 1 | 10.79 | 6 | SO65178 | 2024-04-28 | 0.86 | 6.72 | 5.39 | |||
SO53499_7 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 488 | 197 | 3 | 2023-11-03 | 129.58 | 3.24 | 2023-10-22 | 4 | 41.57 | 1 | 129.58 | 7 | SO53499 | 2023-10-29 | 10.37 | 166.29 | 32.39 | |||
SO71819_33 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 471 | 197 | 3 | 2024-08-03 | 152.40 | 3.81 | 2024-07-22 | 4 | 23.75 | 1 | 152.40 | 33 | SO71819 | 2024-07-29 | 12.19 | 95.00 | 38.10 | |||
SO55248_28 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 487 | 618 | 2 | 2023-12-03 | 98.98 | 2.47 | 2023-11-21 | 3 | 20.57 | 1 | 98.98 | 28 | SO55248 | 2023-11-28 | 7.92 | 61.70 | 32.99 | |||
SO50727_13 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 325 | 2 | 54 | 2 | 99.91 | 2023-08-03 | 4995.48 | 122.39 | 2023-07-22 | 11 | 486.71 | 1 | 4895.57 | 13 | SO50727 | 2023-07-29 | 391.65 | 5353.77 | 454.13 | 0.02 |
SO50228_8 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 410 | 396 | 2 | 2023-07-03 | 72.89 | 1.82 | 2023-06-21 | 2 | 26.97 | 1 | 72.89 | 8 | SO50228 | 2023-06-28 | 5.83 | 53.94 | 36.45 | |||
SO49123_5 | FDE5-41D0-A8 | PO18386193475 | 100 | 283 | 385 | 558 | 2 | 2023-04-05 | 1200.53 | 30.01 | 2023-03-24 | 2 | 605.65 | 1 | 1200.53 | 5 | SO49123 | 2023-03-31 | 96.04 | 1211.30 | 600.26 | |||
SO46969_18 | 3C39-4176-A8 | PO15370166954 | 100 | 283 | 470 | 381 | 3 | 2022-10-03 | 68.38 | 1.71 | 2022-09-21 | 3 | 15.67 | 1 | 68.38 | 18 | SO46969 | 2022-09-28 | 5.47 | 47.01 | 22.79 | |||
SO46964_38 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 254 | 328 | 4 | 2022-10-03 | 551.81 | 13.80 | 2022-09-21 | 3 | 170.14 | 1 | 551.81 | 38 | SO46964 | 2022-09-28 | 44.15 | 510.43 | 183.94 | |||
SO49825_17 | 2F7E-448D-B9 | PO17197161242 | 100 | 283 | 409 | 125 | 2 | 2023-06-03 | 837.02 | 20.93 | 2023-05-22 | 4 | 185.82 | 1 | 837.02 | 17 | SO49825 | 2023-05-29 | 66.96 | 743.28 | 209.26 | |||
SO63200_20 | E73D-4A02-88 | PO11658161535 | 100 | 283 | 471 | 233 | 2 | 2024-04-04 | 228.60 | 5.72 | 2024-03-23 | 6 | 23.75 | 1 | 228.60 | 20 | SO63200 | 2024-03-30 | 18.29 | 142.49 | 38.10 | |||
SO71894_8 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 465 | 539 | 2 | 2024-08-03 | 102.86 | 2.57 | 2024-07-22 | 7 | 9.16 | 1 | 102.86 | 8 | SO71894 | 2024-07-29 | 8.23 | 64.12 | 14.69 | |||
SO71798_9 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 390 | 306 | 3 | 2024-08-03 | 672.29 | 16.81 | 2024-07-22 | 1 | 713.08 | 1 | 672.29 | 9 | SO71798 | 2024-07-29 | 53.78 | 713.08 | 672.29 | |||
SO55301_29 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 465 | 414 | 2 | 2023-12-03 | 132.25 | 3.31 | 2023-11-21 | 9 | 9.16 | 1 | 132.25 | 29 | SO55301 | 2023-11-28 | 10.58 | 82.43 | 14.69 | |||
SO50280_32 | 7938-4E14-A7 | PO11658187917 | 100 | 283 | 421 | 233 | 2 | 2023-07-03 | 785.32 | 19.63 | 2023-06-21 | 4 | 145.28 | 1 | 785.32 | 32 | SO50280 | 2023-06-28 | 62.83 | 581.13 | 196.33 | |||
SO51776_24 | 9800-4D08-BA | PO2871145495 | 100 | 283 | 559 | 522 | 2 | 2023-10-03 | 60.72 | 1.52 | 2023-09-21 | 5 | 8.99 | 1 | 60.72 | 24 | SO51776 | 2023-09-28 | 4.86 | 44.93 | 12.14 | |||
SO53570_12 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 484 | 2 | 54 | 2 | 1.20 | 2023-11-03 | 59.94 | 1.47 | 2023-10-22 | 13 | 2.97 | 1 | 58.74 | 12 | SO53570 | 2023-10-29 | 4.70 | 38.65 | 4.61 | 0.02 |
SO47409_6 | FC23-4384-86 | PO1624119173 | 100 | 283 | 339 | 579 | 3 | 2022-11-03 | 1879.18 | 46.98 | 2022-10-22 | 4 | 486.71 | 1 | 1879.18 | 6 | SO47409 | 2022-10-29 | 150.33 | 1946.83 | 469.79 | |||
SO57015_8 | 8C70-4374-B5 | PO19923181245 | 100 | 283 | 531 | 18 | 3 | 2024-01-03 | 149.87 | 3.75 | 2023-12-22 | 1 | 136.79 | 1 | 149.87 | 8 | SO57015 | 2023-12-29 | 11.99 | 136.79 | 149.87 | |||
SO46358_24 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 318 | 579 | 3 | 2022-08-03 | 874.79 | 21.87 | 2022-07-22 | 1 | 884.71 | 1 | 874.79 | 24 | SO46358 | 2022-07-29 | 69.98 | 884.71 | 874.79 | |||
SO46642_30 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 422 | 4 | 4 | 2022-09-02 | 67.54 | 1.69 | 2022-08-21 | 1 | 49.98 | 1 | 67.54 | 30 | SO46642 | 2022-08-28 | 5.40 | 49.98 | 67.54 | |||
SO50228_19 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 427 | 396 | 2 | 2023-07-03 | 627.77 | 15.69 | 2023-06-21 | 3 | 185.82 | 1 | 627.77 | 19 | SO50228 | 2023-06-28 | 50.22 | 557.46 | 209.26 | |||
SO51691_12 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 531 | 18 | 3 | 2023-10-03 | 299.75 | 7.49 | 2023-09-21 | 2 | 136.79 | 1 | 299.75 | 12 | SO51691 | 2023-09-28 | 23.98 | 273.57 | 149.87 | |||
SO50727_40 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 435 | 54 | 2 | 2023-08-03 | 648.91 | 16.22 | 2023-07-22 | 2 | 300.12 | 1 | 648.91 | 40 | SO50727 | 2023-07-29 | 51.91 | 600.24 | 324.45 | |||
SO63165_1 | E8F9-4B74-A9 | PO10788196505 | 100 | 283 | 374 | 468 | 3 | 2024-04-04 | 1466.01 | 36.65 | 2024-03-23 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO63165 | 2024-03-30 | 117.28 | 1554.95 | 1466.01 | |||
SO46979_1 | 5605-4AB3-96 | PO13601184435 | 100 | 283 | 286 | 310 | 3 | 2022-10-03 | 919.69 | 22.99 | 2022-09-21 | 5 | 170.14 | 1 | 919.69 | 1 | SO46979 | 2022-09-28 | 73.58 | 850.71 | 183.94 | |||
SO58974_19 | FB64-4792-81 | PO2813115918 | 100 | 283 | 481 | 90 | 5 | 2024-02-02 | 16.18 | 0.40 | 2024-01-21 | 3 | 3.36 | 1 | 16.18 | 19 | SO58974 | 2024-01-28 | 1.29 | 10.09 | 5.39 |
Generated 2024-09-20 07:44:37.640 UTC