[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE SKIP 1000 < SKIP 312 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50737_2 | 1B3A-4961-B0 | PO4002125356 | 100 | 282 | 233 | 674 | 4 | 2023-09-23 | 86.52 | 2.16 | 2023-09-11 | 3 | 29.08 | 1 | 86.52 | 2 | SO50737 | 2023-09-18 | 6.92 | 87.24 | 28.84 | |||
SO47400_54 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 447 | 2 | 133 | 4 | 4.06 | 2022-12-24 | 203.00 | 4.97 | 2022-12-12 | 14 | 10.31 | 1 | 198.94 | 54 | SO47400 | 2022-12-19 | 15.92 | 144.38 | 14.50 | 0.02 |
SO67273_29 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 516 | 475 | 4 | 2024-07-24 | 70.45 | 1.76 | 2024-07-12 | 3 | 17.38 | 1 | 70.45 | 29 | SO67273 | 2024-07-19 | 5.64 | 52.13 | 23.48 | |||
SO53470_17 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 554 | 420 | 4 | 2023-12-24 | 54.94 | 1.37 | 2023-12-12 | 1 | 40.66 | 1 | 54.94 | 17 | SO53470 | 2023-12-19 | 4.40 | 40.66 | 54.94 | |||
SO71783_24 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 606 | 24 | 4 | 2024-09-23 | 1619.97 | 40.50 | 2024-09-11 | 5 | 343.65 | 1 | 1619.97 | 24 | SO71783 | 2024-09-18 | 129.60 | 1718.25 | 323.99 | |||
SO69441_12 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 582 | 97 | 4 | 2024-08-23 | 5102.97 | 127.57 | 2024-08-11 | 5 | 1082.51 | 1 | 5102.97 | 12 | SO69441 | 2024-08-18 | 408.24 | 5412.55 | 1020.59 | |||
SO47426_1 | 9D6D-42F0-A2 | PO4147153085 | 100 | 282 | 375 | 222 | 3 | 2022-12-24 | 1308.94 | 32.72 | 2022-12-12 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO47426 | 2022-12-19 | 104.72 | 1320.68 | 1308.94 | |||
SO63277_8 | 1561-40F3-AD | PO3219122722 | 100 | 282 | 374 | 493 | 4 | 2024-05-25 | 1466.01 | 36.65 | 2024-05-13 | 1 | 1554.95 | 1 | 1466.01 | 8 | SO63277 | 2024-05-20 | 117.28 | 1554.95 | 1466.01 | |||
SO50294_19 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 428 | 312 | 4 | 2023-08-23 | 418.51 | 10.46 | 2023-08-11 | 2 | 185.82 | 1 | 418.51 | 19 | SO50294 | 2023-08-18 | 33.48 | 371.64 | 209.26 | |||
SO51106_4 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 577 | 331 | 4 | 2023-10-23 | 1457.82 | 36.45 | 2023-10-11 | 2 | 755.15 | 1 | 1457.82 | 4 | SO51106 | 2023-10-18 | 116.63 | 1510.30 | 728.91 | |||
SO53531_6 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 517 | 187 | 4 | 2023-12-24 | 126.34 | 3.16 | 2023-12-12 | 4 | 23.37 | 1 | 126.34 | 6 | SO53531 | 2023-12-19 | 10.11 | 93.49 | 31.58 | |||
SO71782_26 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 586 | 582 | 4 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 26 | SO71782 | 2024-09-18 | 71.27 | 922.89 | 445.41 | |||
SO47041_27 | C543-4932-83 | PO5771188676 | 100 | 282 | 433 | 79 | 3 | 2022-11-23 | 1622.26 | 40.56 | 2022-11-11 | 5 | 300.12 | 1 | 1622.26 | 27 | SO47041 | 2022-11-18 | 129.78 | 1500.59 | 324.45 | |||
SO57105_10 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 533 | 697 | 1 | 2024-02-23 | 449.62 | 11.24 | 2024-02-11 | 3 | 136.79 | 1 | 449.62 | 10 | SO57105 | 2024-02-18 | 35.97 | 410.36 | 149.87 | |||
SO71782_4 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 225 | 582 | 4 | 2024-09-23 | 53.94 | 1.35 | 2024-09-11 | 10 | 6.92 | 1 | 53.94 | 4 | SO71782 | 2024-09-18 | 4.32 | 69.22 | 5.39 | |||
SO50304_3 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 339 | 79 | 3 | 2023-08-23 | 2818.76 | 70.47 | 2023-08-11 | 6 | 486.71 | 1 | 2818.76 | 3 | SO50304 | 2023-08-18 | 225.50 | 2920.24 | 469.79 | |||
SO69559_1 | 5217-44A2-B0 | PO8874167571 | 100 | 282 | 593 | 16 | 348 | 3 | 90.40 | 2024-08-23 | 226.00 | 3.39 | 2024-08-11 | 2 | 308.22 | 1 | 135.60 | 1 | SO69559 | 2024-08-18 | 10.85 | 616.44 | 113.00 | 0.40 |
SO51745_15 | C261-441D-A5 | PO11745132954 | 100 | 282 | 580 | 97 | 4 | 2023-11-23 | 5102.97 | 127.57 | 2023-11-11 | 5 | 1082.51 | 1 | 5102.97 | 15 | SO51745 | 2023-11-18 | 408.24 | 5412.55 | 1020.59 | |||
SO51844_16 | DE76-4481-AA | PO4553182082 | 100 | 282 | 490 | 313 | 4 | 2023-11-23 | 97.18 | 2.43 | 2023-11-11 | 3 | 41.57 | 1 | 97.18 | 16 | SO51844 | 2023-11-18 | 7.77 | 124.72 | 32.39 | |||
SO69422_37 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 501 | 650 | 1 | 2024-08-23 | 291.50 | 7.29 | 2024-08-11 | 4 | 53.93 | 1 | 291.50 | 37 | SO69422 | 2024-08-18 | 23.32 | 215.71 | 72.88 | |||
SO63213_8 | 1A10-4A9D-B4 | PO11745122074 | 100 | 282 | 382 | 97 | 4 | 2024-05-25 | 3361.47 | 84.04 | 2024-05-13 | 5 | 713.08 | 1 | 3361.47 | 8 | SO63213 | 2024-05-20 | 268.92 | 3565.40 | 672.29 | |||
SO69422_21 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 472 | 650 | 1 | 2024-08-23 | 190.50 | 4.76 | 2024-08-11 | 5 | 23.75 | 1 | 190.50 | 21 | SO69422 | 2024-08-18 | 15.24 | 118.75 | 38.10 | |||
SO47065_16 | D00A-426C-9B | PO8845147622 | 100 | 282 | 421 | 546 | 3 | 2022-11-23 | 785.32 | 19.63 | 2022-11-11 | 4 | 145.28 | 1 | 785.32 | 16 | SO47065 | 2022-11-18 | 62.83 | 581.13 | 196.33 | |||
SO55249_47 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 463 | 475 | 4 | 2024-01-23 | 29.39 | 0.73 | 2024-01-11 | 2 | 9.16 | 1 | 29.39 | 47 | SO55249 | 2024-01-18 | 2.35 | 18.32 | 14.69 | |||
SO53460_4 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 481 | 24 | 4 | 2023-12-24 | 16.18 | 0.40 | 2023-12-12 | 3 | 3.36 | 1 | 16.18 | 4 | SO53460 | 2023-12-19 | 1.29 | 10.09 | 5.39 | |||
SO65244_5 | 9913-4EA4-9F | PO12992138491 | 100 | 282 | 576 | 295 | 4 | 2024-06-23 | 5721.77 | 143.04 | 2024-06-11 | 4 | 1481.94 | 1 | 5721.77 | 5 | SO65244 | 2024-06-18 | 457.74 | 5927.75 | 1430.44 | |||
SO46367_14 | EF40-4AFF-B2 | PO4147155635 | 100 | 282 | 270 | 222 | 3 | 2022-09-23 | 183.94 | 4.60 | 2022-09-11 | 1 | 181.49 | 1 | 183.94 | 14 | SO46367 | 2022-09-18 | 14.72 | 181.49 | 183.94 | |||
SO55235_1 | CE6C-41A5-91 | PO20126150960 | 100 | 282 | 527 | 421 | 4 | 2024-01-23 | 158.43 | 3.96 | 2024-01-11 | 1 | 144.59 | 1 | 158.43 | 1 | SO55235 | 2024-01-18 | 12.67 | 144.59 | 158.43 | |||
SO53531_36 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 531 | 187 | 4 | 2023-12-24 | 299.75 | 7.49 | 2023-12-12 | 2 | 136.79 | 1 | 299.75 | 36 | SO53531 | 2023-12-19 | 23.98 | 273.57 | 149.87 | |||
SO51745_13 | C261-441D-A5 | PO11745132954 | 100 | 282 | 546 | 97 | 4 | 2023-11-23 | 149.02 | 3.73 | 2023-11-11 | 4 | 27.57 | 1 | 149.02 | 13 | SO51745 | 2023-11-18 | 11.92 | 110.27 | 37.25 | |||
SO59023_21 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 214 | 61 | 4 | 2024-03-24 | 125.96 | 3.15 | 2024-03-12 | 6 | 13.09 | 1 | 125.96 | 21 | SO59023 | 2024-03-19 | 10.08 | 78.52 | 20.99 |
Generated 2024-11-10 08:36:10.721 UTC