[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '282' > SKIP 2500 SHUFFLE < SKIP 468 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47041_22 | C543-4932-83 | PO5771188676 | 100 | 282 | 371 | 79 | 3 | 2022-10-03 | 5235.75 | 130.89 | 2022-09-21 | 4 | 1320.68 | 1 | 5235.75 | 22 | SO47041 | 2022-09-28 | 418.86 | 5282.74 | 1308.94 | |||
SO63283_36 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 474 | 312 | 4 | 2024-04-04 | 377.95 | 9.45 | 2024-03-23 | 9 | 26.18 | 1 | 377.95 | 36 | SO63283 | 2024-03-30 | 30.24 | 235.59 | 41.99 | |||
SO51844_19 | DE76-4481-AA | PO4553182082 | 100 | 282 | 225 | 313 | 4 | 2023-10-03 | 26.97 | 0.67 | 2023-09-21 | 5 | 6.92 | 1 | 26.97 | 19 | SO51844 | 2023-09-28 | 2.16 | 34.61 | 5.39 | |||
SO50688_39 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 360 | 133 | 4 | 2023-08-03 | 4917.84 | 122.95 | 2023-07-22 | 4 | 1105.81 | 1 | 4917.84 | 39 | SO50688 | 2023-07-29 | 393.43 | 4423.24 | 1229.46 | |||
SO57186_23 | EF93-4946-97 | PO8845159326 | 100 | 282 | 600 | 546 | 3 | 2024-01-03 | 1619.97 | 40.50 | 2023-12-22 | 5 | 294.58 | 1 | 1619.97 | 23 | SO57186 | 2023-12-29 | 129.60 | 1472.90 | 323.99 | |||
SO47041_32 | C543-4932-83 | PO5771188676 | 100 | 282 | 216 | 79 | 3 | 2022-10-03 | 100.93 | 2.52 | 2022-09-21 | 5 | 13.88 | 1 | 100.93 | 32 | SO47041 | 2022-09-28 | 8.07 | 69.39 | 20.19 | |||
SO65303_16 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 225 | 61 | 4 | 2024-05-03 | 43.15 | 1.08 | 2024-04-21 | 8 | 6.92 | 1 | 43.15 | 16 | SO65303 | 2024-04-28 | 3.45 | 55.38 | 5.39 | |||
SO65303_17 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 590 | 61 | 4 | 2024-05-03 | 2770.16 | 69.25 | 2024-04-21 | 6 | 419.78 | 1 | 2770.16 | 17 | SO65303 | 2024-04-28 | 221.61 | 2518.67 | 461.69 | |||
SO51090_39 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 487 | 3 | 475 | 4 | 30.24 | 2023-09-02 | 604.89 | 14.37 | 2023-08-21 | 20 | 20.57 | 1 | 574.65 | 39 | SO51090 | 2023-08-28 | 45.97 | 411.33 | 30.24 | 0.05 |
SO65160_7 | 9375-44FE-94 | PO19343172976 | 100 | 282 | 546 | 24 | 4 | 2024-05-03 | 74.51 | 1.86 | 2024-04-21 | 2 | 27.57 | 1 | 74.51 | 7 | SO65160 | 2024-04-28 | 5.96 | 55.14 | 37.25 | |||
SO50313_30 | B452-44E9-91 | PO7656143984 | 100 | 282 | 273 | 403 | 4 | 2023-07-03 | 202.33 | 5.06 | 2023-06-21 | 1 | 187.16 | 1 | 202.33 | 30 | SO50313 | 2023-06-28 | 16.19 | 187.16 | 202.33 | |||
SO47355_1 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 423 | 24 | 4 | 2022-11-03 | 495.69 | 12.39 | 2022-10-22 | 3 | 122.27 | 1 | 495.69 | 1 | SO47355 | 2022-10-29 | 39.66 | 366.81 | 165.23 | |||
SO46372_2 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 293 | 169 | 1 | 2022-08-03 | 722.59 | 18.06 | 2022-07-22 | 1 | 623.84 | 1 | 722.59 | 2 | SO46372 | 2022-07-29 | 57.81 | 623.84 | 722.59 | |||
SO63283_24 | 5DCA-44B0-BB | PO3799140598 | 100 | 282 | 544 | 312 | 4 | 2024-04-04 | 48.59 | 1.21 | 2024-03-23 | 1 | 35.96 | 1 | 48.59 | 24 | SO63283 | 2024-03-30 | 3.89 | 35.96 | 48.59 | |||
SO50754_3 | 5AA5-4CCE-B6 | PO7946158767 | 100 | 282 | 325 | 438 | 1 | 2023-08-03 | 939.59 | 23.49 | 2023-07-22 | 2 | 486.71 | 1 | 939.59 | 3 | SO50754 | 2023-07-29 | 75.17 | 973.41 | 469.79 | |||
SO51828_6 | 3204-40B6-A5 | PO5771194719 | 100 | 282 | 490 | 79 | 3 | 2023-10-03 | 194.36 | 4.86 | 2023-09-21 | 6 | 41.57 | 1 | 194.36 | 6 | SO51828 | 2023-09-28 | 15.55 | 249.43 | 32.39 | |||
SO57029_4 | F624-4906-AF | PO16762128411 | 100 | 282 | 482 | 3 | 259 | 4 | 4.45 | 2024-01-03 | 89.00 | 2.11 | 2023-12-22 | 18 | 3.36 | 1 | 84.55 | 4 | SO57029 | 2023-12-29 | 6.76 | 60.52 | 4.94 | 0.05 |
SO65209_2 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 363 | 187 | 4 | 2024-05-03 | 1376.99 | 34.42 | 2024-04-21 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO65209 | 2024-04-28 | 110.16 | 1251.98 | 1376.99 | |||
SO57186_53 | EF93-4946-97 | PO8845159326 | 100 | 282 | 484 | 546 | 3 | 2024-01-03 | 33.39 | 0.83 | 2023-12-22 | 7 | 2.97 | 1 | 33.39 | 53 | SO57186 | 2023-12-29 | 2.67 | 20.81 | 4.77 | |||
SO59026_4 | 6264-4C83-B2 | PO4002182599 | 100 | 282 | 583 | 674 | 4 | 2024-02-02 | 2041.19 | 51.03 | 2024-01-21 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO59026 | 2024-01-28 | 163.30 | 2165.02 | 1020.59 | |||
SO58991_2 | D7E6-4630-81 | PO16530115443 | 100 | 282 | 484 | 601 | 1 | 2024-02-02 | 4.77 | 0.12 | 2024-01-21 | 1 | 2.97 | 1 | 4.77 | 2 | SO58991 | 2024-01-28 | 0.38 | 2.97 | 4.77 | |||
SO69503_30 | 559D-4568-82 | PO5771124379 | 100 | 282 | 483 | 79 | 3 | 2024-07-03 | 504.00 | 12.60 | 2024-06-21 | 7 | 44.88 | 1 | 504.00 | 30 | SO69503 | 2024-06-28 | 40.32 | 314.16 | 72.00 | |||
SO51721_35 | 9429-430D-89 | PO14500124798 | 100 | 282 | 513 | 650 | 1 | 2023-10-03 | 655.36 | 16.38 | 2023-09-21 | 3 | 199.38 | 1 | 655.36 | 35 | SO51721 | 2023-09-28 | 52.43 | 598.13 | 218.45 | |||
SO55324_19 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 237 | 523 | 3 | 2023-12-03 | 179.96 | 4.50 | 2023-11-21 | 6 | 38.49 | 1 | 179.96 | 19 | SO55324 | 2023-11-28 | 14.40 | 230.95 | 29.99 | |||
SO46970_1 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 368 | 258 | 4 | 2022-10-03 | 1466.01 | 36.65 | 2022-09-21 | 1 | 1518.79 | 1 | 1466.01 | 1 | SO46970 | 2022-09-28 | 117.28 | 1518.79 | 1466.01 | |||
SO46988_27 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 335 | 78 | 4 | 2022-10-03 | 469.79 | 11.74 | 2022-09-21 | 1 | 486.71 | 1 | 469.79 | 27 | SO46988 | 2022-09-28 | 37.58 | 486.71 | 469.79 | |||
SO53606_27 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 474 | 3 | 61 | 4 | 30.80 | 2023-11-03 | 615.91 | 14.63 | 2023-10-22 | 16 | 26.18 | 1 | 585.12 | 27 | SO53606 | 2023-10-29 | 46.81 | 418.82 | 38.49 | 0.05 |
SO58942_3 | 5900-4D8F-A6 | PO13021136057 | 100 | 282 | 287 | 276 | 4 | 2024-02-02 | 809.33 | 20.23 | 2024-01-21 | 4 | 204.63 | 1 | 809.33 | 3 | SO58942 | 2024-01-28 | 64.75 | 818.50 | 202.33 | |||
SO57046_19 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 515 | 650 | 1 | 2024-01-03 | 32.54 | 0.81 | 2023-12-22 | 2 | 12.04 | 1 | 32.54 | 19 | SO57046 | 2023-12-29 | 2.60 | 24.08 | 16.27 | |||
SO47028_33 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 233 | 312 | 4 | 2022-10-03 | 173.04 | 4.33 | 2022-09-21 | 6 | 29.08 | 1 | 173.04 | 33 | SO47028 | 2022-09-28 | 13.84 | 174.48 | 28.84 | |||
SO67273_39 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 309 | 475 | 4 | 2024-06-03 | 818.70 | 20.47 | 2024-05-22 | 1 | 747.20 | 1 | 818.70 | 39 | SO67273 | 2024-05-29 | 65.50 | 747.20 | 818.70 |
Generated 2024-09-20 04:31:21.976 UTC