[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 1031 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46992_20 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 407 | 97 | 4 | 2022-10-03 | 196.81 | 4.92 | 2022-09-21 | 3 | 48.55 | 1 | 196.81 | 20 | SO46992 | 2022-09-28 | 15.74 | 145.64 | 65.60 | |||
SO63212_8 | B54D-4C63-85 | PO5684113881 | 100 | 282 | 524 | 385 | 4 | 2024-04-04 | 158.43 | 3.96 | 2024-03-23 | 1 | 144.59 | 1 | 158.43 | 8 | SO63212 | 2024-03-30 | 12.67 | 144.59 | 158.43 | |||
SO57046_16 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 483 | 650 | 1 | 2024-01-03 | 720.00 | 18.00 | 2023-12-22 | 10 | 44.88 | 1 | 720.00 | 16 | SO57046 | 2023-12-29 | 57.60 | 448.80 | 72.00 | |||
SO57121_24 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 388 | 79 | 3 | 2024-01-03 | 2016.88 | 50.42 | 2023-12-22 | 3 | 713.08 | 1 | 2016.88 | 24 | SO57121 | 2023-12-29 | 161.35 | 2139.24 | 672.29 | |||
SO46671_5 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 375 | 523 | 3 | 2022-09-02 | 5235.75 | 130.89 | 2022-08-21 | 4 | 1320.68 | 1 | 5235.75 | 5 | SO46671 | 2022-08-28 | 418.86 | 5282.74 | 1308.94 | |||
SO57186_58 | EF93-4946-97 | PO8845159326 | 100 | 282 | 525 | 546 | 3 | 2024-01-03 | 1109.01 | 27.73 | 2023-12-22 | 7 | 144.59 | 1 | 1109.01 | 58 | SO57186 | 2023-12-29 | 88.72 | 1012.16 | 158.43 | |||
SO53459_37 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 483 | 582 | 4 | 2023-11-03 | 144.00 | 3.60 | 2023-10-22 | 2 | 44.88 | 1 | 144.00 | 37 | SO53459 | 2023-10-29 | 11.52 | 89.76 | 72.00 | |||
SO49893_8 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 233 | 523 | 3 | 2023-06-03 | 144.20 | 3.61 | 2023-05-22 | 5 | 29.08 | 1 | 144.20 | 8 | SO49893 | 2023-05-29 | 11.54 | 145.40 | 28.84 | |||
SO71863_5 | F39F-4A8F-B9 | PO16124166561 | 100 | 282 | 222 | 649 | 4 | 2024-08-03 | 20.99 | 0.52 | 2024-07-22 | 1 | 13.09 | 1 | 20.99 | 5 | SO71863 | 2024-07-29 | 1.68 | 13.09 | 20.99 | |||
SO47400_43 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 399 | 133 | 4 | 2022-11-03 | 202.65 | 5.07 | 2022-10-22 | 6 | 24.99 | 1 | 202.65 | 43 | SO47400 | 2022-10-29 | 16.21 | 149.96 | 33.77 | |||
SO46058_12 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 319 | 240 | 4 | 2022-07-03 | 874.79 | 21.87 | 2022-06-21 | 1 | 884.71 | 1 | 874.79 | 12 | SO46058 | 2022-06-28 | 69.98 | 884.71 | 874.79 | |||
SO57186_34 | EF93-4946-97 | PO8845159326 | 100 | 282 | 359 | 546 | 3 | 2024-01-03 | 4130.98 | 103.27 | 2023-12-22 | 3 | 1251.98 | 1 | 4130.98 | 34 | SO57186 | 2023-12-29 | 330.48 | 3755.94 | 1376.99 | |||
SO45557_7 | 2C02-480B-8E | PO4147117065 | 100 | 282 | 334 | 222 | 3 | 2022-05-03 | 838.92 | 20.97 | 2022-04-21 | 2 | 413.15 | 1 | 838.92 | 7 | SO45557 | 2022-04-28 | 67.11 | 826.29 | 419.46 | |||
SO71782_31 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 558 | 582 | 4 | 2024-08-03 | 485.99 | 12.15 | 2024-07-22 | 2 | 179.82 | 1 | 485.99 | 31 | SO71782 | 2024-07-29 | 38.88 | 359.63 | 242.99 | |||
SO71796_20 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 492 | 420 | 4 | 2024-08-03 | 1204.69 | 30.12 | 2024-07-22 | 2 | 601.74 | 1 | 1204.69 | 20 | SO71796 | 2024-07-29 | 96.38 | 1203.49 | 602.35 | |||
SO63291_9 | 9B60-437E-88 | PO8845151318 | 100 | 282 | 587 | 546 | 3 | 2024-04-04 | 1385.08 | 34.63 | 2024-03-23 | 3 | 419.78 | 1 | 1385.08 | 9 | SO63291 | 2024-03-30 | 110.81 | 1259.34 | 461.69 | |||
SO71845_21 | 4781-4673-85 | PO2697119362 | 100 | 282 | 234 | 187 | 4 | 2024-08-03 | 59.99 | 1.50 | 2024-07-22 | 2 | 38.49 | 1 | 59.99 | 21 | SO71845 | 2024-07-29 | 4.80 | 76.98 | 29.99 | |||
SO67298_26 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 500 | 205 | 4 | 2024-06-03 | 1807.04 | 45.18 | 2024-05-22 | 3 | 601.74 | 1 | 1807.04 | 26 | SO67298 | 2024-05-29 | 144.56 | 1805.23 | 602.35 | |||
SO69422_25 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 603 | 650 | 1 | 2024-07-03 | 437.36 | 10.93 | 2024-06-21 | 6 | 53.94 | 1 | 437.36 | 25 | SO69422 | 2024-06-28 | 34.99 | 323.65 | 72.89 | |||
SO71902_8 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 476 | 61 | 4 | 2024-08-03 | 293.96 | 7.35 | 2024-07-22 | 7 | 26.18 | 1 | 293.96 | 8 | SO71902 | 2024-07-29 | 23.52 | 183.23 | 41.99 | |||
SO46372_8 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 345 | 7 | 169 | 1 | 1190.00 | 2022-08-03 | 3399.99 | 55.25 | 2022-07-22 | 4 | 1912.15 | 1 | 2209.99 | 8 | SO46372 | 2022-07-29 | 176.80 | 7648.62 | 850.00 | 0.35 |
SO50254_1 | C82A-4399-A6 | PO2784191494 | 100 | 282 | 325 | 625 | 4 | 2023-07-03 | 469.79 | 11.74 | 2023-06-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO50254 | 2023-06-28 | 37.58 | 486.71 | 469.79 | |||
SO53470_18 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 522 | 420 | 4 | 2023-11-03 | 23.48 | 0.59 | 2023-10-22 | 1 | 17.38 | 1 | 23.48 | 18 | SO53470 | 2023-10-29 | 1.88 | 17.38 | 23.48 | |||
SO50663_18 | 286E-4915-89 | PO19343130555 | 100 | 282 | 457 | 24 | 4 | 2023-08-03 | 404.95 | 10.12 | 2023-07-22 | 9 | 30.93 | 1 | 404.95 | 18 | SO50663 | 2023-07-29 | 32.40 | 278.40 | 44.99 | |||
SO50272_32 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 323 | 97 | 4 | 2023-07-03 | 939.59 | 23.49 | 2023-06-21 | 2 | 486.71 | 1 | 939.59 | 32 | SO50272 | 2023-06-28 | 75.17 | 973.41 | 469.79 | |||
SO50658_3 | 9939-4D87-B1 | PO174172019 | 100 | 282 | 323 | 277 | 4 | 2023-08-03 | 1879.18 | 46.98 | 2023-07-22 | 4 | 486.71 | 1 | 1879.18 | 3 | SO50658 | 2023-07-29 | 150.33 | 1946.83 | 469.79 | |||
SO50270_15 | A828-45A2-8B | PO18676112371 | 100 | 282 | 419 | 697 | 1 | 2023-07-03 | 210.59 | 5.26 | 2023-06-21 | 4 | 38.96 | 1 | 210.59 | 15 | SO50270 | 2023-06-28 | 16.85 | 155.84 | 52.65 | |||
SO50272_24 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 458 | 97 | 4 | 2023-07-03 | 89.99 | 2.25 | 2023-06-21 | 2 | 30.93 | 1 | 89.99 | 24 | SO50272 | 2023-06-28 | 7.20 | 61.87 | 44.99 | |||
SO58919_20 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 562 | 420 | 4 | 2024-02-02 | 2860.88 | 71.52 | 2024-01-21 | 2 | 1481.94 | 1 | 2860.88 | 20 | SO58919 | 2024-01-28 | 228.87 | 2963.88 | 1430.44 | |||
SO71796_14 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 562 | 420 | 4 | 2024-08-03 | 1430.44 | 35.76 | 2024-07-22 | 1 | 1481.94 | 1 | 1430.44 | 14 | SO71796 | 2024-07-29 | 114.44 | 1481.94 | 1430.44 |
Generated 2024-09-20 21:35:11.023 UTC