[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE SKIP 0 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45557_1 | 2C02-480B-8E | PO4147117065 | 100 | 282 | 319 | 222 | 3 | 2022-05-02 | 874.79 | 21.87 | 2022-04-20 | 1 | 884.71 | 1 | 874.79 | 1 | SO45557 | 2022-04-27 | 69.98 | 884.71 | 874.79 | |||
SO46069_1 | 29F6-4D30-91 | PO609194739 | 100 | 282 | 348 | 492 | 4 | 2022-07-02 | 2024.99 | 50.62 | 2022-06-20 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO46069 | 2022-06-27 | 162.00 | 1898.09 | 2024.99 | |||
SO46671_24 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 429 | 523 | 3 | 2022-09-01 | 973.36 | 24.33 | 2022-08-20 | 3 | 300.12 | 1 | 973.36 | 24 | SO46671 | 2022-08-27 | 77.87 | 900.36 | 324.45 | |||
SO71863_6 | F39F-4A8F-B9 | PO16124166561 | 100 | 282 | 606 | 649 | 4 | 2024-08-02 | 971.98 | 24.30 | 2024-07-21 | 3 | 343.65 | 1 | 971.98 | 6 | SO71863 | 2024-07-28 | 77.76 | 1030.95 | 323.99 | |||
SO58907_17 | F365-4683-97 | PO19372175613 | 100 | 282 | 490 | 582 | 4 | 2024-02-01 | 161.97 | 4.05 | 2024-01-20 | 5 | 41.57 | 1 | 161.97 | 17 | SO58907 | 2024-01-27 | 12.96 | 207.86 | 32.39 | |||
SO57186_26 | EF93-4946-97 | PO8845159326 | 100 | 282 | 463 | 546 | 3 | 2024-01-02 | 73.47 | 1.84 | 2023-12-21 | 5 | 9.16 | 1 | 73.47 | 26 | SO57186 | 2023-12-28 | 5.88 | 45.80 | 14.69 | |||
SO49486_3 | 7DA8-4E15-AE | PO16124154108 | 100 | 282 | 329 | 649 | 4 | 2023-05-02 | 469.79 | 11.74 | 2023-04-20 | 1 | 486.71 | 1 | 469.79 | 3 | SO49486 | 2023-04-27 | 37.58 | 486.71 | 469.79 | |||
SO58907_20 | F365-4683-97 | PO19372175613 | 100 | 282 | 488 | 582 | 4 | 2024-02-01 | 259.15 | 6.48 | 2024-01-20 | 8 | 41.57 | 1 | 259.15 | 20 | SO58907 | 2024-01-27 | 20.73 | 332.58 | 32.39 | |||
SO57105_32 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 593 | 697 | 1 | 2024-01-02 | 1016.98 | 25.42 | 2023-12-21 | 3 | 308.22 | 1 | 1016.98 | 32 | SO57105 | 2023-12-28 | 81.36 | 924.65 | 338.99 | |||
SO71902_21 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 363 | 61 | 4 | 2024-08-02 | 2753.99 | 68.85 | 2024-07-21 | 2 | 1251.98 | 1 | 2753.99 | 21 | SO71902 | 2024-07-28 | 220.32 | 2503.96 | 1376.99 | |||
SO46372_8 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 345 | 7 | 169 | 1 | 1190.00 | 2022-08-02 | 3399.99 | 55.25 | 2022-07-21 | 4 | 1912.15 | 1 | 2209.99 | 8 | SO46372 | 2022-07-28 | 176.80 | 7648.62 | 850.00 | 0.35 |
SO48356_1 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 395 | 187 | 4 | 2023-02-01 | 490.99 | 12.27 | 2023-01-20 | 8 | 45.42 | 1 | 490.99 | 1 | SO48356 | 2023-01-27 | 39.28 | 363.33 | 61.37 | |||
SO47417_25 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 358 | 187 | 4 | 2022-11-02 | 6147.29 | 153.68 | 2022-10-21 | 5 | 1105.81 | 1 | 6147.29 | 25 | SO47417 | 2022-10-28 | 491.78 | 5529.05 | 1229.46 | |||
SO50744_1 | 2D17-4C84-9B | PO4582137475 | 100 | 282 | 448 | 25 | 4 | 2023-08-02 | 47.98 | 1.20 | 2023-07-21 | 4 | 8.25 | 1 | 47.98 | 1 | SO50744 | 2023-07-28 | 3.84 | 32.98 | 11.99 | |||
SO55249_31 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 527 | 475 | 4 | 2023-12-02 | 158.43 | 3.96 | 2023-11-20 | 1 | 144.59 | 1 | 158.43 | 31 | SO55249 | 2023-11-27 | 12.67 | 144.59 | 158.43 | |||
SO57062_11 | D146-4B3C-BB | PO11745129321 | 100 | 282 | 374 | 97 | 4 | 2024-01-02 | 1466.01 | 36.65 | 2023-12-21 | 1 | 1554.95 | 1 | 1466.01 | 11 | SO57062 | 2023-12-28 | 117.28 | 1554.95 | 1466.01 | |||
SO50294_23 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 366 | 312 | 4 | 2023-07-02 | 1295.99 | 32.40 | 2023-06-20 | 2 | 598.44 | 1 | 1295.99 | 23 | SO50294 | 2023-06-27 | 103.68 | 1196.87 | 647.99 | |||
SO50270_9 | A828-45A2-8B | PO18676112371 | 100 | 282 | 428 | 697 | 1 | 2023-07-02 | 1255.54 | 31.39 | 2023-06-20 | 6 | 185.82 | 1 | 1255.54 | 9 | SO50270 | 2023-06-27 | 100.44 | 1114.92 | 209.26 | |||
SO45339_9 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 313 | 403 | 4 | 2022-04-04 | 2146.96 | 53.67 | 2022-03-23 | 1 | 2171.29 | 1 | 2146.96 | 9 | SO45339 | 2022-03-30 | 171.76 | 2171.29 | 2146.96 | |||
SO45301_23 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 316 | 78 | 4 | 2022-04-04 | 874.79 | 21.87 | 2022-03-23 | 1 | 884.71 | 1 | 874.79 | 23 | SO45301 | 2022-03-30 | 69.98 | 884.71 | 874.79 | |||
SO46625_33 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 447 | 475 | 4 | 2022-09-01 | 60.00 | 1.50 | 2022-08-20 | 4 | 10.31 | 1 | 60.00 | 33 | SO46625 | 2022-08-27 | 4.80 | 41.25 | 15.00 | |||
SO50304_16 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 433 | 79 | 3 | 2023-07-02 | 1297.81 | 32.45 | 2023-06-20 | 4 | 300.12 | 1 | 1297.81 | 16 | SO50304 | 2023-06-27 | 103.82 | 1200.48 | 324.45 | |||
SO69422_36 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 477 | 650 | 1 | 2024-07-02 | 17.96 | 0.45 | 2024-06-20 | 6 | 1.87 | 1 | 17.96 | 36 | SO69422 | 2024-06-27 | 1.44 | 11.20 | 2.99 | |||
SO53606_10 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 517 | 61 | 4 | 2023-11-02 | 94.75 | 2.37 | 2023-10-21 | 3 | 23.37 | 1 | 94.75 | 10 | SO53606 | 2023-10-28 | 7.58 | 70.12 | 31.58 | |||
SO71816_7 | 52D4-4F3B-9E | PO12992180445 | 100 | 282 | 555 | 295 | 4 | 2024-08-02 | 63.90 | 1.60 | 2024-07-21 | 1 | 47.29 | 1 | 63.90 | 7 | SO71816 | 2024-07-28 | 5.11 | 47.29 | 63.90 | |||
SO69413_23 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 593 | 16 | 43 | 1 | 90.40 | 2024-07-02 | 226.00 | 3.39 | 2024-06-20 | 2 | 308.22 | 1 | 135.60 | 23 | SO69413 | 2024-06-27 | 10.85 | 616.44 | 113.00 | 0.40 |
SO57046_6 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 525 | 650 | 1 | 2024-01-02 | 475.29 | 11.88 | 2023-12-21 | 3 | 144.59 | 1 | 475.29 | 6 | SO57046 | 2023-12-28 | 38.02 | 433.78 | 158.43 | |||
SO69503_33 | 559D-4568-82 | PO5771124379 | 100 | 282 | 547 | 79 | 3 | 2024-07-02 | 242.97 | 6.07 | 2024-06-20 | 5 | 35.96 | 1 | 242.97 | 33 | SO69503 | 2024-06-27 | 19.44 | 179.80 | 48.59 | |||
SO46625_43 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 236 | 2 | 475 | 4 | 6.13 | 2022-09-01 | 306.67 | 7.51 | 2022-08-20 | 11 | 29.08 | 1 | 300.54 | 43 | SO46625 | 2022-08-27 | 24.04 | 319.89 | 27.88 | 0.02 |
SO46966_8 | 8FBD-4E87-82 | PO15631150454 | 100 | 282 | 354 | 43 | 1 | 2022-10-02 | 6214.26 | 155.36 | 2022-09-20 | 5 | 1117.86 | 1 | 6214.26 | 8 | SO46966 | 2022-09-27 | 497.14 | 5589.28 | 1242.85 | |||
SO67335_1 | A016-4C1A-9B | PO1479138681 | 100 | 282 | 551 | 673 | 1 | 2024-06-02 | 316.86 | 7.92 | 2024-05-21 | 2 | 144.59 | 1 | 316.86 | 1 | SO67335 | 2024-05-28 | 25.35 | 289.19 | 158.43 |
Generated 2024-09-19 18:41:15.987 UTC