[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 252 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69422_23 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 483 | 650 | 1 | 2024-08-27 | 576.00 | 14.40 | 2024-08-15 | 8 | 44.88 | 1 | 576.00 | 23 | SO69422 | 2024-08-22 | 46.08 | 359.04 | 72.00 | |||
SO46364_16 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 212 | 366 | 4 | 2022-09-27 | 80.75 | 2.02 | 2022-09-15 | 4 | 12.03 | 1 | 80.75 | 16 | SO46364 | 2022-09-22 | 6.46 | 48.11 | 20.19 | |||
SO46372_11 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 304 | 169 | 1 | 2022-09-27 | 714.70 | 17.87 | 2022-09-15 | 1 | 617.03 | 1 | 714.70 | 11 | SO46372 | 2022-09-22 | 57.18 | 617.03 | 714.70 | |||
SO47041_36 | C543-4932-83 | PO5771188676 | 100 | 282 | 369 | 79 | 3 | 2022-11-27 | 4398.03 | 109.95 | 2022-11-15 | 3 | 1518.79 | 1 | 4398.03 | 36 | SO47041 | 2022-11-22 | 351.84 | 4556.36 | 1466.01 | |||
SO50226_50 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 242 | 78 | 4 | 2023-08-27 | 2342.45 | 58.56 | 2023-08-15 | 3 | 722.26 | 1 | 2342.45 | 50 | SO50226 | 2023-08-22 | 187.40 | 2166.77 | 780.82 | |||
SO65209_8 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 552 | 187 | 4 | 2024-06-27 | 54.89 | 1.37 | 2024-06-15 | 1 | 40.62 | 1 | 54.89 | 8 | SO65209 | 2024-06-22 | 4.39 | 40.62 | 54.89 | |||
SO63257_27 | B81B-4565-85 | PO5771197507 | 100 | 282 | 386 | 79 | 3 | 2024-05-29 | 2016.88 | 50.42 | 2024-05-17 | 3 | 713.08 | 1 | 2016.88 | 27 | SO63257 | 2024-05-24 | 161.35 | 2139.24 | 672.29 | |||
SO53531_37 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 471 | 187 | 4 | 2023-12-28 | 152.40 | 3.81 | 2023-12-16 | 4 | 23.75 | 1 | 152.40 | 37 | SO53531 | 2023-12-23 | 12.19 | 95.00 | 38.10 | |||
SO69532_38 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 400 | 312 | 4 | 2024-08-27 | 37.15 | 0.93 | 2024-08-15 | 1 | 27.49 | 1 | 37.15 | 38 | SO69532 | 2024-08-22 | 2.97 | 27.49 | 37.15 | |||
SO47056_7 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 456 | 403 | 4 | 2022-11-27 | 179.98 | 4.50 | 2022-11-15 | 4 | 30.93 | 1 | 179.98 | 7 | SO47056 | 2022-11-22 | 14.40 | 123.73 | 44.99 | |||
SO48366_3 | A45C-4EB1-A2 | PO4002178011 | 100 | 282 | 327 | 674 | 4 | 2023-03-29 | 469.79 | 11.74 | 2023-03-17 | 1 | 486.71 | 1 | 469.79 | 3 | SO48366 | 2023-03-24 | 37.58 | 486.71 | 469.79 | |||
SO47056_57 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 460 | 403 | 4 | 2022-11-27 | 539.94 | 13.50 | 2022-11-15 | 10 | 37.12 | 1 | 539.94 | 57 | SO47056 | 2022-11-22 | 43.20 | 371.21 | 53.99 | |||
SO49893_26 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 373 | 523 | 3 | 2023-07-28 | 1308.94 | 32.72 | 2023-07-16 | 1 | 1320.68 | 1 | 1308.94 | 26 | SO49893 | 2023-07-23 | 104.72 | 1320.68 | 1308.94 | |||
SO57036_15 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 474 | 43 | 1 | 2024-02-27 | 209.97 | 5.25 | 2024-02-15 | 5 | 26.18 | 1 | 209.97 | 15 | SO57036 | 2024-02-22 | 16.80 | 130.88 | 41.99 | |||
SO46367_20 | EF40-4AFF-B2 | PO4147155635 | 100 | 282 | 318 | 222 | 3 | 2022-09-27 | 874.79 | 21.87 | 2022-09-15 | 1 | 884.71 | 1 | 874.79 | 20 | SO46367 | 2022-09-22 | 69.98 | 884.71 | 874.79 | |||
SO58909_19 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 234 | 3 | 24 | 4 | 22.00 | 2024-03-28 | 439.91 | 10.45 | 2024-03-16 | 16 | 38.49 | 1 | 417.92 | 19 | SO58909 | 2024-03-23 | 33.43 | 615.88 | 27.49 | 0.05 |
SO49147_16 | B753-40C9-A6 | PO5771172608 | 100 | 282 | 456 | 79 | 3 | 2023-05-30 | 179.98 | 4.50 | 2023-05-18 | 4 | 30.93 | 1 | 179.98 | 16 | SO49147 | 2023-05-25 | 14.40 | 123.73 | 44.99 | |||
SO49104_6 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 375 | 97 | 4 | 2023-05-30 | 3926.81 | 98.17 | 2023-05-18 | 3 | 1320.68 | 1 | 3926.81 | 6 | SO49104 | 2023-05-25 | 314.15 | 3962.05 | 1308.94 | |||
SO46107_13 | 75E6-43D6-92 | PO8874169089 | 100 | 282 | 235 | 348 | 3 | 2022-08-27 | 86.52 | 2.16 | 2022-08-15 | 3 | 31.72 | 1 | 86.52 | 13 | SO46107 | 2022-08-22 | 6.92 | 95.17 | 28.84 | |||
SO49114_1 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 470 | 43 | 1 | 2023-05-30 | 227.94 | 5.70 | 2023-05-18 | 10 | 15.67 | 1 | 227.94 | 1 | SO49114 | 2023-05-25 | 18.24 | 156.71 | 22.79 | |||
SO48373_23 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 367 | 61 | 4 | 2023-03-29 | 1943.98 | 48.60 | 2023-03-17 | 3 | 598.44 | 1 | 1943.98 | 23 | SO48373 | 2023-03-24 | 155.52 | 1795.31 | 647.99 | |||
SO47425_5 | E539-44F6-AA | PO4002163465 | 100 | 282 | 323 | 674 | 4 | 2022-12-28 | 2348.97 | 58.72 | 2022-12-16 | 5 | 486.71 | 1 | 2348.97 | 5 | SO47425 | 2022-12-23 | 187.92 | 2433.53 | 469.79 | |||
SO47028_7 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 367 | 312 | 4 | 2022-11-27 | 1943.98 | 48.60 | 2022-11-15 | 3 | 598.44 | 1 | 1943.98 | 7 | SO47028 | 2022-11-22 | 155.52 | 1795.31 | 647.99 | |||
SO47041_17 | C543-4932-83 | PO5771188676 | 100 | 282 | 254 | 79 | 3 | 2022-11-27 | 919.69 | 22.99 | 2022-11-15 | 5 | 170.14 | 1 | 919.69 | 17 | SO47041 | 2022-11-22 | 73.58 | 850.71 | 183.94 | |||
SO69561_44 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 543 | 546 | 3 | 2024-08-27 | 223.52 | 5.59 | 2024-08-15 | 6 | 27.57 | 1 | 223.52 | 44 | SO69561 | 2024-08-22 | 17.88 | 165.41 | 37.25 | |||
SO48373_17 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 409 | 61 | 4 | 2023-03-29 | 418.51 | 10.46 | 2023-03-17 | 2 | 185.82 | 1 | 418.51 | 17 | SO48373 | 2023-03-24 | 33.48 | 371.64 | 209.26 | |||
SO49058_7 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 224 | 78 | 4 | 2023-05-30 | 31.12 | 0.78 | 2023-05-18 | 6 | 5.23 | 1 | 31.12 | 7 | SO49058 | 2023-05-25 | 2.49 | 31.38 | 5.19 | |||
SO46960_6 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 458 | 259 | 4 | 2022-11-27 | 89.99 | 2.25 | 2022-11-15 | 2 | 30.93 | 1 | 89.99 | 6 | SO46960 | 2022-11-22 | 7.20 | 61.87 | 44.99 | |||
SO55324_22 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 390 | 523 | 3 | 2024-01-27 | 4033.76 | 100.84 | 2024-01-15 | 6 | 713.08 | 1 | 4033.76 | 22 | SO55324 | 2024-01-22 | 322.70 | 4278.48 | 672.29 | |||
SO63291_7 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 594 | 546 | 3 | 2024-05-29 | 1694.97 | 42.37 | 2024-05-17 | 5 | 308.22 | 1 | 1694.97 | 7 | SO63291 | 2024-05-24 | 135.60 | 1541.09 | 338.99 | |||
SO50688_44 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 230 | 133 | 4 | 2023-09-27 | 230.72 | 5.77 | 2023-09-15 | 8 | 29.08 | 1 | 230.72 | 44 | SO50688 | 2023-09-22 | 18.46 | 232.65 | 28.84 | |||
SO47355_51 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 327 | 24 | 4 | 2022-12-28 | 4697.94 | 117.45 | 2022-12-16 | 10 | 486.71 | 1 | 4697.94 | 51 | SO47355 | 2022-12-23 | 375.84 | 4867.07 | 469.79 | |||
SO53598_2 | 6B0D-4AF3-AB | PO174179317 | 100 | 282 | 434 | 277 | 4 | 2023-12-28 | 1784.49 | 44.61 | 2023-12-16 | 5 | 360.94 | 1 | 1784.49 | 2 | SO53598 | 2023-12-23 | 142.76 | 1804.71 | 356.90 | |||
SO46089_15 | 5E3C-4A0D-BD | PO5684142532 | 100 | 282 | 220 | 385 | 4 | 2022-08-27 | 80.75 | 2.02 | 2022-08-15 | 4 | 12.03 | 1 | 80.75 | 15 | SO46089 | 2022-08-22 | 6.46 | 48.11 | 20.19 | |||
SO71845_30 | 4781-4673-85 | PO2697119362 | 100 | 282 | 531 | 187 | 4 | 2024-09-27 | 599.50 | 14.99 | 2024-09-15 | 4 | 136.79 | 1 | 599.50 | 30 | SO71845 | 2024-09-22 | 47.96 | 547.14 | 149.87 | |||
SO47355_33 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 439 | 24 | 4 | 2022-12-28 | 2342.45 | 58.56 | 2022-12-16 | 3 | 722.26 | 1 | 2342.45 | 33 | SO47355 | 2022-12-23 | 187.40 | 2166.77 | 780.82 | |||
SO50313_37 | B452-44E9-91 | PO7656143984 | 100 | 282 | 435 | 403 | 4 | 2023-08-27 | 324.45 | 8.11 | 2023-08-15 | 1 | 300.12 | 1 | 324.45 | 37 | SO50313 | 2023-08-22 | 25.96 | 300.12 | 324.45 | |||
SO57036_3 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 475 | 43 | 1 | 2024-02-27 | 41.99 | 1.05 | 2024-02-15 | 1 | 26.18 | 1 | 41.99 | 3 | SO57036 | 2024-02-22 | 3.36 | 26.18 | 41.99 | |||
SO50688_36 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 397 | 133 | 4 | 2023-09-27 | 72.88 | 1.82 | 2023-09-15 | 3 | 17.98 | 1 | 72.88 | 36 | SO50688 | 2023-09-22 | 5.83 | 53.93 | 24.29 | |||
SO47056_39 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 407 | 403 | 4 | 2022-11-27 | 65.60 | 1.64 | 2022-11-15 | 1 | 48.55 | 1 | 65.60 | 39 | SO47056 | 2022-11-22 | 5.25 | 48.55 | 65.60 | |||
SO69471_18 | 2CF9-42DE-B1 | PO18676191433 | 100 | 282 | 474 | 697 | 1 | 2024-08-27 | 251.96 | 6.30 | 2024-08-15 | 6 | 26.18 | 1 | 251.96 | 18 | SO69471 | 2024-08-22 | 20.16 | 157.06 | 41.99 | |||
SO50702_7 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 308 | 187 | 4 | 2023-09-27 | 744.27 | 18.61 | 2023-09-15 | 1 | 660.91 | 1 | 744.27 | 7 | SO50702 | 2023-09-22 | 59.54 | 660.91 | 744.27 | |||
SO57186_2 | EF93-4946-97 | PO8845159326 | 100 | 282 | 590 | 546 | 3 | 2024-02-27 | 2308.47 | 57.71 | 2024-02-15 | 5 | 419.78 | 1 | 2308.47 | 2 | SO57186 | 2024-02-22 | 184.68 | 2098.89 | 461.69 | |||
SO55324_35 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 605 | 523 | 3 | 2024-01-27 | 2915.95 | 72.90 | 2024-01-15 | 9 | 343.65 | 1 | 2915.95 | 35 | SO55324 | 2024-01-22 | 233.28 | 3092.85 | 323.99 | |||
SO48295_7 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 459 | 24 | 4 | 2023-03-29 | 323.96 | 8.10 | 2023-03-17 | 6 | 37.12 | 1 | 323.96 | 7 | SO48295 | 2023-03-24 | 25.92 | 222.73 | 53.99 | |||
SO48397_23 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 391 | 457 | 4 | 2023-03-29 | 177.86 | 4.45 | 2023-03-17 | 2 | 65.81 | 1 | 177.86 | 23 | SO48397 | 2023-03-24 | 14.23 | 131.62 | 88.93 | |||
SO47039_10 | B548-493E-AE | PO5684166879 | 100 | 282 | 468 | 385 | 4 | 2022-11-27 | 45.59 | 1.14 | 2022-11-15 | 2 | 15.67 | 1 | 45.59 | 10 | SO47039 | 2022-11-22 | 3.65 | 31.34 | 22.79 | |||
SO49472_2 | 653C-45A9-B1 | PO2697138792 | 100 | 282 | 397 | 187 | 4 | 2023-06-27 | 48.59 | 1.21 | 2023-06-15 | 2 | 17.98 | 1 | 48.59 | 2 | SO49472 | 2023-06-22 | 3.89 | 35.96 | 24.29 | |||
SO50663_24 | 286E-4915-89 | PO19343130555 | 100 | 282 | 265 | 24 | 4 | 2023-09-27 | 1011.66 | 25.29 | 2023-09-15 | 5 | 187.16 | 1 | 1011.66 | 24 | SO50663 | 2023-09-22 | 80.93 | 935.79 | 202.33 | |||
SO46972_30 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 409 | 650 | 1 | 2022-11-27 | 627.77 | 15.69 | 2022-11-15 | 3 | 185.82 | 1 | 627.77 | 30 | SO46972 | 2022-11-22 | 50.22 | 557.46 | 209.26 | |||
SO63202_21 | 5C83-47EE-AA | PO15631193825 | 100 | 282 | 484 | 43 | 1 | 2024-05-29 | 14.31 | 0.36 | 2024-05-17 | 3 | 2.97 | 1 | 14.31 | 21 | SO63202 | 2024-05-24 | 1.14 | 8.92 | 4.77 | |||
SO46988_18 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 435 | 78 | 4 | 2022-11-27 | 324.45 | 8.11 | 2022-11-15 | 1 | 300.12 | 1 | 324.45 | 18 | SO46988 | 2022-11-22 | 25.96 | 300.12 | 324.45 | |||
SO69413_14 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 524 | 43 | 1 | 2024-08-27 | 158.43 | 3.96 | 2024-08-15 | 1 | 144.59 | 1 | 158.43 | 14 | SO69413 | 2024-08-22 | 12.67 | 144.59 | 158.43 | |||
SO47355_26 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 267 | 24 | 4 | 2022-12-28 | 202.33 | 5.06 | 2022-12-16 | 1 | 187.16 | 1 | 202.33 | 26 | SO47355 | 2022-12-23 | 16.19 | 187.16 | 202.33 | |||
SO69561_29 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 532 | 546 | 3 | 2024-08-27 | 749.37 | 18.73 | 2024-08-15 | 5 | 136.79 | 1 | 749.37 | 29 | SO69561 | 2024-08-22 | 59.95 | 683.93 | 149.87 | |||
SO53531_22 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 483 | 187 | 4 | 2023-12-28 | 432.00 | 10.80 | 2023-12-16 | 6 | 44.88 | 1 | 432.00 | 22 | SO53531 | 2023-12-23 | 34.56 | 269.28 | 72.00 | |||
SO71902_17 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 596 | 61 | 4 | 2024-09-27 | 323.99 | 8.10 | 2024-09-15 | 1 | 294.58 | 1 | 323.99 | 17 | SO71902 | 2024-09-22 | 25.92 | 294.58 | 323.99 | |||
SO49893_5 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 383 | 523 | 3 | 2023-07-28 | 600.26 | 15.01 | 2023-07-16 | 1 | 605.65 | 1 | 600.26 | 5 | SO49893 | 2023-07-23 | 48.02 | 605.65 | 600.26 | |||
SO47355_46 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 339 | 24 | 4 | 2022-12-28 | 469.79 | 11.74 | 2022-12-16 | 1 | 486.71 | 1 | 469.79 | 46 | SO47355 | 2022-12-23 | 37.58 | 486.71 | 469.79 | |||
SO47065_22 | D00A-426C-9B | PO8845147622 | 100 | 282 | 459 | 546 | 3 | 2022-11-27 | 215.98 | 5.40 | 2022-11-15 | 4 | 37.12 | 1 | 215.98 | 22 | SO47065 | 2022-11-22 | 17.28 | 148.48 | 53.99 | |||
SO49893_8 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 233 | 523 | 3 | 2023-07-28 | 144.20 | 3.61 | 2023-07-16 | 5 | 29.08 | 1 | 144.20 | 8 | SO49893 | 2023-07-23 | 11.54 | 145.40 | 28.84 | |||
SO50272_25 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 213 | 97 | 4 | 2023-08-27 | 100.93 | 2.52 | 2023-08-15 | 5 | 13.88 | 1 | 100.93 | 25 | SO50272 | 2023-08-22 | 8.07 | 69.39 | 20.19 |
Generated 2024-11-14 04:40:42.713 UTC