[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '281' > SKIP 2500 SHUFFLE < SKIP 125 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49125_9 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 297 | 435 | 4 | 2023-04-04 | 2208.44 | 55.21 | 2023-03-23 | 3 | 653.70 | 1 | 2208.44 | 9 | SO49125 | 2023-03-30 | 176.67 | 1961.09 | 736.15 | |||
SO65311_21 | 8732-477D-BC | PO7047142102 | 100 | 281 | 398 | 544 | 3 | 2024-05-02 | 26.72 | 0.67 | 2024-04-20 | 1 | 19.78 | 1 | 26.72 | 21 | SO65311 | 2024-04-27 | 2.14 | 19.78 | 26.72 | |||
SO67280_3 | D663-42E1-A2 | PO12412130838 | 100 | 281 | 376 | 670 | 3 | 2024-06-02 | 5864.04 | 146.60 | 2024-05-21 | 4 | 1554.95 | 1 | 5864.04 | 3 | SO67280 | 2024-05-28 | 469.12 | 6219.79 | 1466.01 | |||
SO65277_7 | B368-4131-A5 | PO3973124151 | 100 | 281 | 564 | 201 | 4 | 2024-05-02 | 1430.44 | 35.76 | 2024-04-20 | 1 | 1481.94 | 1 | 1430.44 | 7 | SO65277 | 2024-04-27 | 114.44 | 1481.94 | 1430.44 | |||
SO47395_7 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 439 | 72 | 2 | 2022-11-02 | 3904.09 | 97.60 | 2022-10-21 | 5 | 722.26 | 1 | 3904.09 | 7 | SO47395 | 2022-10-28 | 312.33 | 3611.28 | 780.82 | |||
SO49851_29 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 221 | 3 | 184 | 4 | 13.88 | 2023-06-02 | 277.56 | 6.59 | 2023-05-21 | 15 | 13.88 | 1 | 263.69 | 29 | SO49851 | 2023-05-28 | 21.09 | 208.17 | 18.50 | 0.05 |
SO71881_19 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 516 | 21 | 4 | 2024-08-02 | 70.45 | 1.76 | 2024-07-21 | 3 | 17.38 | 1 | 70.45 | 19 | SO71881 | 2024-07-28 | 5.64 | 52.13 | 23.48 | |||
SO45556_3 | A9AB-44F3-9F | PO3190111178 | 100 | 281 | 324 | 575 | 2 | 2022-05-02 | 1258.38 | 31.46 | 2022-04-20 | 3 | 413.15 | 1 | 1258.38 | 3 | SO45556 | 2022-04-27 | 100.67 | 1239.44 | 419.46 | |||
SO46968_8 | 280B-4350-80 | PO15254133264 | 100 | 281 | 271 | 377 | 3 | 2022-10-02 | 809.33 | 20.23 | 2022-09-20 | 4 | 187.16 | 1 | 809.33 | 8 | SO46968 | 2022-09-27 | 64.75 | 748.63 | 202.33 | |||
SO69536_19 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 353 | 435 | 4 | 2024-07-02 | 4175.98 | 104.40 | 2024-06-20 | 3 | 1265.62 | 1 | 4175.98 | 19 | SO69536 | 2024-06-27 | 334.08 | 3796.86 | 1391.99 | |||
SO47416_18 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 327 | 90 | 5 | 2022-11-02 | 2348.97 | 58.72 | 2022-10-21 | 5 | 486.71 | 1 | 2348.97 | 18 | SO47416 | 2022-10-28 | 187.92 | 2433.53 | 469.79 | |||
SO53590_22 | E7FF-4C04-9E | PO4118162346 | 100 | 281 | 553 | 454 | 3 | 2023-11-02 | 55.31 | 1.38 | 2023-10-21 | 2 | 20.46 | 1 | 55.31 | 22 | SO53590 | 2023-10-28 | 4.42 | 40.93 | 27.65 | |||
SO48748_4 | 4FC9-469B-88 | PO3016138326 | 100 | 281 | 468 | 183 | 3 | 2023-03-04 | 45.59 | 1.14 | 2023-02-20 | 2 | 15.67 | 1 | 45.59 | 4 | SO48748 | 2023-02-27 | 3.65 | 31.34 | 22.79 | |||
SO69549_1 | 15D6-4C17-80 | PO7540191274 | 100 | 281 | 564 | 607 | 4 | 2024-07-02 | 4291.33 | 107.28 | 2024-06-20 | 3 | 1481.94 | 1 | 4291.33 | 1 | SO69549 | 2024-06-27 | 343.31 | 4445.81 | 1430.44 | |||
SO55303_22 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 374 | 166 | 4 | 2023-12-02 | 5864.04 | 146.60 | 2023-11-20 | 4 | 1554.95 | 1 | 5864.04 | 22 | SO55303 | 2023-11-27 | 469.12 | 6219.79 | 1466.01 | |||
SO50696_30 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 343 | 579 | 3 | 2023-08-02 | 2348.97 | 58.72 | 2023-07-21 | 5 | 486.71 | 1 | 2348.97 | 30 | SO50696 | 2023-07-28 | 187.92 | 2433.53 | 469.79 | |||
SO45575_6 | 358D-446A-9A | PO9483193232 | 100 | 281 | 317 | 54 | 2 | 2022-05-02 | 2624.38 | 65.61 | 2022-04-20 | 3 | 884.71 | 1 | 2624.38 | 6 | SO45575 | 2022-04-27 | 209.95 | 2654.12 | 874.79 | |||
SO69515_8 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 545 | 255 | 4 | 2024-07-02 | 24.29 | 0.61 | 2024-06-20 | 1 | 17.98 | 1 | 24.29 | 8 | SO69515 | 2024-06-27 | 1.94 | 17.98 | 24.29 | |||
SO48787_1 | 0EAC-4469-9A | PO6409126669 | 100 | 281 | 329 | 292 | 4 | 2023-03-04 | 1409.38 | 35.23 | 2023-02-20 | 3 | 486.71 | 1 | 1409.38 | 1 | SO48787 | 2023-02-27 | 112.75 | 1460.12 | 469.79 | |||
SO50748_31 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 383 | 3 | 4 | 2023-08-02 | 600.26 | 15.01 | 2023-07-21 | 1 | 605.65 | 1 | 600.26 | 31 | SO50748 | 2023-07-28 | 48.02 | 605.65 | 600.26 | |||
SO57034_12 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 222 | 328 | 4 | 2024-01-02 | 188.95 | 4.72 | 2023-12-21 | 9 | 13.09 | 1 | 188.95 | 12 | SO57034 | 2023-12-28 | 15.12 | 117.78 | 20.99 | |||
SO45809_4 | D8A0-4462-8A | PO5365154898 | 100 | 281 | 319 | 161 | 2 | 2022-06-02 | 1749.59 | 43.74 | 2022-05-21 | 2 | 884.71 | 1 | 1749.59 | 4 | SO45809 | 2022-05-28 | 139.97 | 1769.42 | 874.79 | |||
SO50738_40 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 331 | 130 | 4 | 2023-08-02 | 939.59 | 23.49 | 2023-07-21 | 2 | 486.71 | 1 | 939.59 | 40 | SO50738 | 2023-07-28 | 75.17 | 973.41 | 469.79 | |||
SO50705_2 | CFC7-4B41-A2 | PO3103161654 | 100 | 281 | 327 | 147 | 3 | 2023-08-02 | 1879.18 | 46.98 | 2023-07-21 | 4 | 486.71 | 1 | 1879.18 | 2 | SO50705 | 2023-07-28 | 150.33 | 1946.83 | 469.79 | |||
SO46662_53 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 213 | 8 | 660 | 3 | 16.82 | 2022-09-01 | 168.22 | 3.79 | 2022-08-20 | 10 | 13.88 | 1 | 151.40 | 53 | SO46662 | 2022-08-27 | 12.11 | 138.78 | 16.82 | 0.10 |
SO46385_21 | F727-48F0-AF | PO9483110086 | 100 | 281 | 322 | 54 | 2 | 2022-08-02 | 2516.75 | 62.92 | 2022-07-21 | 6 | 413.15 | 1 | 2516.75 | 21 | SO46385 | 2022-07-28 | 201.34 | 2478.88 | 419.46 | |||
SO49837_12 | C136-4536-9D | PO12412160791 | 100 | 281 | 343 | 670 | 3 | 2023-06-02 | 1409.38 | 35.23 | 2023-05-21 | 3 | 486.71 | 1 | 1409.38 | 12 | SO49837 | 2023-05-28 | 112.75 | 1460.12 | 469.79 | |||
SO48735_24 | BFBE-46B9-A1 | PO12412161905 | 100 | 281 | 373 | 670 | 3 | 2023-03-04 | 1308.94 | 32.72 | 2023-02-20 | 1 | 1320.68 | 1 | 1308.94 | 24 | SO48735 | 2023-02-27 | 104.72 | 1320.68 | 1308.94 | |||
SO65232_8 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 524 | 490 | 4 | 2024-05-02 | 475.29 | 11.88 | 2024-04-20 | 3 | 144.59 | 1 | 475.29 | 8 | SO65232 | 2024-04-27 | 38.02 | 433.78 | 158.43 | |||
SO49880_3 | E43C-4D1F-9F | PO4350182387 | 100 | 281 | 224 | 274 | 3 | 2023-06-02 | 15.56 | 0.39 | 2023-05-21 | 3 | 5.23 | 1 | 15.56 | 3 | SO49880 | 2023-05-28 | 1.24 | 15.69 | 5.19 | |||
SO50292_7 | E329-4164-85 | PO3654177485 | 100 | 281 | 399 | 435 | 4 | 2023-07-02 | 168.87 | 4.22 | 2023-06-20 | 5 | 24.99 | 1 | 168.87 | 7 | SO50292 | 2023-06-27 | 13.51 | 124.97 | 33.77 |
Generated 2024-09-20 01:04:10.317 UTC