[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '283' > SKIP 2500 SHUFFLE SKIP 1000 < SKIP 312 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55301_57 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 559 | 414 | 2 | 2023-12-03 | 48.58 | 1.21 | 2023-11-21 | 4 | 8.99 | 1 | 48.58 | 57 | SO55301 | 2023-11-28 | 3.89 | 35.95 | 12.14 |
SO57087_1 | 423C-428C-BB | PO2871167176 | 100 | 283 | 477 | 522 | 2 | 2024-01-03 | 5.99 | 0.15 | 2023-12-22 | 2 | 1.87 | 1 | 5.99 | 1 | SO57087 | 2023-12-29 | 0.48 | 3.73 | 2.99 |
SO49512_17 | E722-4D76-AD | PO12354152645 | 100 | 283 | 399 | 197 | 3 | 2023-05-03 | 33.77 | 0.84 | 2023-04-21 | 1 | 24.99 | 1 | 33.77 | 17 | SO49512 | 2023-04-28 | 2.70 | 24.99 | 33.77 |
SO46049_15 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 262 | 328 | 4 | 2022-07-03 | 551.81 | 13.80 | 2022-06-21 | 3 | 181.49 | 1 | 551.81 | 15 | SO46049 | 2022-06-28 | 44.15 | 544.46 | 183.94 |
SO48786_12 | D12C-42C5-83 | PO6467115913 | 100 | 283 | 454 | 660 | 3 | 2023-03-05 | 35.99 | 0.90 | 2023-02-21 | 1 | 24.75 | 1 | 35.99 | 12 | SO48786 | 2023-02-28 | 2.88 | 24.75 | 35.99 |
SO57114_1 | 626A-466A-98 | PO12006142752 | 100 | 283 | 287 | 270 | 2 | 2024-01-03 | 202.33 | 5.06 | 2023-12-22 | 1 | 204.63 | 1 | 202.33 | 1 | SO57114 | 2023-12-29 | 16.19 | 204.63 | 202.33 |
SO53570_2 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 606 | 54 | 2 | 2023-11-03 | 2915.95 | 72.90 | 2023-10-22 | 9 | 343.65 | 1 | 2915.95 | 2 | SO53570 | 2023-10-29 | 233.28 | 3092.85 | 323.99 |
SO49894_8 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 419 | 252 | 2 | 2023-06-03 | 157.94 | 3.95 | 2023-05-22 | 3 | 38.96 | 1 | 157.94 | 8 | SO49894 | 2023-05-29 | 12.64 | 116.88 | 52.65 |
SO46049_19 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 324 | 328 | 4 | 2022-07-03 | 2097.29 | 52.43 | 2022-06-21 | 5 | 413.15 | 1 | 2097.29 | 19 | SO46049 | 2022-06-28 | 167.78 | 2065.73 | 419.46 |
SO50189_12 | 6D35-41E2-A6 | PO19923188059 | 100 | 283 | 360 | 18 | 3 | 2023-07-03 | 1229.46 | 30.74 | 2023-06-21 | 1 | 1105.81 | 1 | 1229.46 | 12 | SO50189 | 2023-06-28 | 98.36 | 1105.81 | 1229.46 |
SO46642_37 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 265 | 4 | 4 | 2022-09-02 | 1416.32 | 35.41 | 2022-08-21 | 7 | 187.16 | 1 | 1416.32 | 37 | SO46642 | 2022-08-28 | 113.31 | 1310.10 | 202.33 |
SO45536_4 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 322 | 273 | 4 | 2022-05-03 | 1258.38 | 31.46 | 2022-04-21 | 3 | 413.15 | 1 | 1258.38 | 4 | SO45536 | 2022-04-28 | 100.67 | 1239.44 | 419.46 |
SO45516_12 | 3473-43AB-AE | PO261128364 | 100 | 283 | 262 | 647 | 4 | 2022-05-03 | 183.94 | 4.60 | 2022-04-21 | 1 | 181.49 | 1 | 183.94 | 12 | SO45516 | 2022-04-28 | 14.72 | 181.49 | 183.94 |
SO46378_3 | 9841-4556-A9 | PO6873118856 | 100 | 283 | 324 | 238 | 3 | 2022-08-03 | 419.46 | 10.49 | 2022-07-22 | 1 | 413.15 | 1 | 419.46 | 3 | SO46378 | 2022-07-29 | 33.56 | 413.15 | 419.46 |
SO65178_15 | 808E-413C-94 | PO16994175277 | 100 | 283 | 372 | 306 | 3 | 2024-05-03 | 5864.04 | 146.60 | 2024-04-21 | 4 | 1554.95 | 1 | 5864.04 | 15 | SO65178 | 2024-04-28 | 469.12 | 6219.79 | 1466.01 |
SO46377_6 | A45C-4A20-BA | PO6786151653 | 100 | 283 | 338 | 3 | 4 | 2022-08-03 | 838.92 | 20.97 | 2022-07-22 | 2 | 413.15 | 1 | 838.92 | 6 | SO46377 | 2022-07-29 | 67.11 | 826.29 | 419.46 |
SO49169_19 | 73B1-4F93-B6 | PO10121138908 | 100 | 283 | 373 | 684 | 2 | 2023-04-05 | 5235.75 | 130.89 | 2023-03-24 | 4 | 1320.68 | 1 | 5235.75 | 19 | SO49169 | 2023-03-31 | 418.86 | 5282.74 | 1308.94 |
SO50228_11 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 393 | 396 | 2 | 2023-07-03 | 413.08 | 10.33 | 2023-06-21 | 3 | 101.89 | 1 | 413.08 | 11 | SO50228 | 2023-06-28 | 33.05 | 305.68 | 137.69 |
SO46642_17 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 389 | 4 | 4 | 2022-09-02 | 3001.31 | 75.03 | 2022-08-21 | 5 | 605.65 | 1 | 3001.31 | 17 | SO46642 | 2022-08-28 | 240.11 | 3028.25 | 600.26 |
SO48375_31 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 294 | 75 | 4 | 2023-02-02 | 2232.82 | 55.82 | 2023-01-21 | 3 | 660.91 | 1 | 2232.82 | 31 | SO48375 | 2023-01-28 | 178.63 | 1982.74 | 744.27 |
SO57065_27 | B68A-407E-99 | PO11658151711 | 100 | 283 | 599 | 233 | 2 | 2024-01-03 | 323.99 | 8.10 | 2023-12-22 | 1 | 294.58 | 1 | 323.99 | 27 | SO57065 | 2023-12-29 | 25.92 | 294.58 | 323.99 |
SO50259_39 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 325 | 558 | 2 | 2023-07-03 | 1879.18 | 46.98 | 2023-06-21 | 4 | 486.71 | 1 | 1879.18 | 39 | SO50259 | 2023-06-28 | 150.33 | 1946.83 | 469.79 |
SO57076_7 | 4D9A-45E4-88 | PO10121190262 | 100 | 283 | 583 | 684 | 2 | 2024-01-03 | 2041.19 | 51.03 | 2023-12-22 | 2 | 1082.51 | 1 | 2041.19 | 7 | SO57076 | 2023-12-29 | 163.30 | 2165.02 | 1020.59 |
SO47049_21 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 394 | 345 | 4 | 2022-10-03 | 41.04 | 1.03 | 2022-09-21 | 2 | 15.18 | 1 | 41.04 | 21 | SO47049 | 2022-09-28 | 3.28 | 30.37 | 20.52 |
SO49117_15 | 9786-4FB8-81 | PO11629122690 | 100 | 283 | 364 | 396 | 2 | 2023-04-05 | 647.99 | 16.20 | 2023-03-24 | 1 | 598.44 | 1 | 647.99 | 15 | SO49117 | 2023-03-31 | 51.84 | 598.44 | 647.99 |
SO46094_11 | 6C13-4966-95 | PO6438128598 | 100 | 283 | 345 | 309 | 4 | 2022-07-03 | 14279.96 | 357.00 | 2022-06-21 | 7 | 1912.15 | 1 | 14279.96 | 11 | SO46094 | 2022-06-28 | 1142.40 | 13385.08 | 2039.99 |
SO57106_5 | 7981-4CAF-8C | PO18734144812 | 100 | 283 | 598 | 449 | 5 | 2024-01-03 | 323.99 | 8.10 | 2023-12-22 | 1 | 294.58 | 1 | 323.99 | 5 | SO57106 | 2023-12-29 | 25.92 | 294.58 | 323.99 |
SO48396_27 | F55B-45AE-8B | PO9715142000 | 100 | 283 | 427 | 490 | 4 | 2023-02-02 | 837.02 | 20.93 | 2023-01-21 | 4 | 185.82 | 1 | 837.02 | 27 | SO48396 | 2023-01-28 | 66.96 | 743.28 | 209.26 |
SO49888_29 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 339 | 234 | 2 | 2023-06-03 | 1879.18 | 46.98 | 2023-05-22 | 4 | 486.71 | 1 | 1879.18 | 29 | SO49888 | 2023-05-29 | 150.33 | 1946.83 | 469.79 |
SO69416_7 | 780C-4219-8A | PO15254137054 | 100 | 283 | 546 | 377 | 3 | 2024-07-03 | 37.25 | 0.93 | 2024-06-21 | 1 | 27.57 | 1 | 37.25 | 7 | SO69416 | 2024-06-28 | 2.98 | 27.57 | 37.25 |
SO47438_26 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 470 | 21 | 4 | 2022-11-03 | 91.18 | 2.28 | 2022-10-22 | 4 | 15.67 | 1 | 91.18 | 26 | SO47438 | 2022-10-29 | 7.29 | 62.68 | 22.79 |
SO47045_37 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 221 | 309 | 4 | 2022-10-03 | 40.37 | 1.01 | 2022-09-21 | 2 | 13.88 | 1 | 40.37 | 37 | SO47045 | 2022-09-28 | 3.23 | 27.76 | 20.19 |
SO50727_21 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 339 | 54 | 2 | 2023-08-03 | 939.59 | 23.49 | 2023-07-22 | 2 | 486.71 | 1 | 939.59 | 21 | SO50727 | 2023-07-29 | 75.17 | 973.41 | 469.79 |
SO48375_19 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 399 | 75 | 4 | 2023-02-02 | 67.55 | 1.69 | 2023-01-21 | 2 | 24.99 | 1 | 67.55 | 19 | SO48375 | 2023-01-28 | 5.40 | 49.99 | 33.77 |
SO46094_8 | 6C13-4966-95 | PO6438128598 | 100 | 283 | 212 | 309 | 4 | 2022-07-03 | 100.93 | 2.52 | 2022-06-21 | 5 | 12.03 | 1 | 100.93 | 8 | SO46094 | 2022-06-28 | 8.07 | 60.14 | 20.19 |
SO55248_8 | 8E6C-4F5E-92 | PO13775186264 | 100 | 283 | 376 | 618 | 2 | 2023-12-03 | 1466.01 | 36.65 | 2023-11-21 | 1 | 1554.95 | 1 | 1466.01 | 8 | SO55248 | 2023-11-28 | 117.28 | 1554.95 | 1466.01 |
SO53560_18 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 573 | 539 | 2 | 2023-11-03 | 2860.88 | 71.52 | 2023-10-22 | 2 | 1481.94 | 1 | 2860.88 | 18 | SO53560 | 2023-10-29 | 228.87 | 2963.88 | 1430.44 |
SO49084_10 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 354 | 667 | 2 | 2023-04-05 | 7457.11 | 186.43 | 2023-03-24 | 6 | 1117.86 | 1 | 7457.11 | 10 | SO49084 | 2023-03-31 | 596.57 | 6707.14 | 1242.85 |
SO45520_16 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 314 | 57 | 3 | 2022-05-03 | 6440.89 | 161.02 | 2022-04-21 | 3 | 2171.29 | 1 | 6440.89 | 16 | SO45520 | 2022-04-28 | 515.27 | 6513.88 | 2146.96 |
SO45520_4 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 326 | 57 | 3 | 2022-05-03 | 838.92 | 20.97 | 2022-04-21 | 2 | 413.15 | 1 | 838.92 | 4 | SO45520 | 2022-04-28 | 67.11 | 826.29 | 419.46 |
SO48380_8 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 364 | 21 | 4 | 2023-02-02 | 647.99 | 16.20 | 2023-01-21 | 1 | 598.44 | 1 | 647.99 | 8 | SO48380 | 2023-01-28 | 51.84 | 598.44 | 647.99 |
SO50703_22 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 466 | 90 | 5 | 2023-08-03 | 70.64 | 1.77 | 2023-07-22 | 5 | 9.71 | 1 | 70.64 | 22 | SO50703 | 2023-07-29 | 5.65 | 48.57 | 14.13 |
SO46629_15 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 415 | 670 | 3 | 2022-09-02 | 792.14 | 19.80 | 2022-08-21 | 4 | 146.55 | 1 | 792.14 | 15 | SO46629 | 2022-08-28 | 63.37 | 586.19 | 198.04 |
SO45536_10 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 338 | 273 | 4 | 2022-05-03 | 1677.84 | 41.95 | 2022-04-21 | 4 | 413.15 | 1 | 1677.84 | 10 | SO45536 | 2022-04-28 | 134.23 | 1652.59 | 419.46 |
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 |
SO49158_3 | 47CD-4C5F-B8 | PO7453124733 | 100 | 283 | 464 | 108 | 2 | 2023-04-05 | 42.39 | 1.06 | 2023-03-24 | 3 | 9.71 | 1 | 42.39 | 3 | SO49158 | 2023-03-31 | 3.39 | 29.14 | 14.13 |
SO49123_2 | FDE5-41D0-A8 | PO18386193475 | 100 | 283 | 335 | 558 | 2 | 2023-04-05 | 1409.38 | 35.23 | 2023-03-24 | 3 | 486.71 | 1 | 1409.38 | 2 | SO49123 | 2023-03-31 | 112.75 | 1460.12 | 469.79 |
SO53471_2 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 606 | 306 | 3 | 2023-11-03 | 647.99 | 16.20 | 2023-10-22 | 2 | 343.65 | 1 | 647.99 | 2 | SO53471 | 2023-10-29 | 51.84 | 687.30 | 323.99 |
SO47438_5 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 426 | 21 | 4 | 2022-11-03 | 627.77 | 15.69 | 2022-10-22 | 3 | 185.82 | 1 | 627.77 | 5 | SO47438 | 2022-10-29 | 50.22 | 557.46 | 209.26 |
SO55259_19 | 68EA-4A46-81 | PO11687179986 | 100 | 283 | 585 | 691 | 2 | 2023-12-03 | 890.82 | 22.27 | 2023-11-21 | 2 | 461.44 | 1 | 890.82 | 19 | SO55259 | 2023-11-28 | 71.27 | 922.89 | 445.41 |
SO67263_4 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 600 | 125 | 2 | 2024-06-03 | 971.98 | 24.30 | 2024-05-22 | 3 | 294.58 | 1 | 971.98 | 4 | SO67263 | 2024-05-29 | 77.76 | 883.74 | 323.99 |
SO55294_31 | D314-4552-B5 | PO6467116955 | 100 | 283 | 234 | 660 | 3 | 2023-12-03 | 299.94 | 7.50 | 2023-11-21 | 10 | 38.49 | 1 | 299.94 | 31 | SO55294 | 2023-11-28 | 24.00 | 384.92 | 29.99 |
SO69462_14 | 05B6-4501-9B | PO1769122113 | 100 | 283 | 484 | 540 | 2 | 2024-07-03 | 14.31 | 0.36 | 2024-06-21 | 3 | 2.97 | 1 | 14.31 | 14 | SO69462 | 2024-06-28 | 1.14 | 8.92 | 4.77 |
SO55294_1 | D314-4552-B5 | PO6467116955 | 100 | 283 | 467 | 660 | 3 | 2023-12-03 | 117.55 | 2.94 | 2023-11-21 | 8 | 9.16 | 1 | 117.55 | 1 | SO55294 | 2023-11-28 | 9.40 | 73.27 | 14.69 |
SO71947_6 | 7269-4186-92 | PO9628115897 | 100 | 283 | 490 | 179 | 2 | 2024-08-03 | 97.18 | 2.43 | 2024-07-22 | 3 | 41.57 | 1 | 97.18 | 6 | SO71947 | 2024-07-29 | 7.77 | 124.72 | 32.39 |
SO47027_25 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 417 | 436 | 4 | 2022-10-03 | 973.36 | 24.33 | 2022-09-21 | 3 | 300.12 | 1 | 973.36 | 25 | SO47027 | 2022-09-28 | 77.87 | 900.36 | 324.45 |
SO50704_3 | 7E83-42D0-A6 | PO3190148529 | 100 | 283 | 265 | 575 | 2 | 2023-08-03 | 202.33 | 5.06 | 2023-07-22 | 1 | 187.16 | 1 | 202.33 | 3 | SO50704 | 2023-07-29 | 16.19 | 187.16 | 202.33 |
SO47439_46 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 435 | 3 | 4 | 2022-11-03 | 1297.81 | 32.45 | 2022-10-22 | 4 | 300.12 | 1 | 1297.81 | 46 | SO47439 | 2022-10-29 | 103.82 | 1200.48 | 324.45 |
SO71798_8 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 604 | 306 | 3 | 2024-08-03 | 647.99 | 16.20 | 2024-07-22 | 2 | 343.65 | 1 | 647.99 | 8 | SO71798 | 2024-07-29 | 51.84 | 687.30 | 323.99 |
SO58921_8 | DB78-489E-8E | PO16994165104 | 100 | 283 | 463 | 306 | 3 | 2024-02-02 | 14.69 | 0.37 | 2024-01-21 | 1 | 9.16 | 1 | 14.69 | 8 | SO58921 | 2024-01-28 | 1.18 | 9.16 | 14.69 |
SO53560_21 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 234 | 539 | 2 | 2023-11-03 | 209.96 | 5.25 | 2023-10-22 | 7 | 38.49 | 1 | 209.96 | 21 | SO53560 | 2023-10-29 | 16.80 | 269.45 | 29.99 |
SO67282_6 | 50CB-4642-B1 | PO11687162635 | 100 | 283 | 575 | 691 | 2 | 2024-06-03 | 2860.88 | 71.52 | 2024-05-22 | 2 | 1481.94 | 1 | 2860.88 | 6 | SO67282 | 2024-05-29 | 228.87 | 2963.88 | 1430.44 |
Generated 2024-09-20 07:19:48.324 UTC