[ROOT] dt FactResellerSale < WHERE DimEmployeeId EQ '281' > SKIP 2500 SHUFFLE < SKIP 220 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53583_28 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 517 | 75 | 4 | 2023-11-03 | 94.75 | 2.37 | 2023-10-22 | 3 | 23.37 | 1 | 94.75 | 28 | SO53583 | 2023-10-29 | 7.58 | 70.12 | 31.58 |
SO71803_43 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 542 | 327 | 3 | 2024-08-03 | 48.59 | 1.21 | 2024-07-22 | 2 | 17.98 | 1 | 48.59 | 43 | SO71803 | 2024-07-29 | 3.89 | 35.96 | 24.29 |
SO67320_25 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 605 | 166 | 4 | 2024-06-03 | 3239.94 | 81.00 | 2024-05-22 | 10 | 343.65 | 1 | 3239.94 | 25 | SO67320 | 2024-05-29 | 259.20 | 3436.50 | 323.99 |
SO48740_15 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 385 | 4 | 4 | 2023-03-05 | 1800.79 | 45.02 | 2023-02-21 | 3 | 605.65 | 1 | 1800.79 | 15 | SO48740 | 2023-02-28 | 144.06 | 1816.95 | 600.26 |
SO71882_23 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 511 | 75 | 4 | 2024-08-03 | 1092.27 | 27.31 | 2024-07-22 | 5 | 199.38 | 1 | 1092.27 | 23 | SO71882 | 2024-07-29 | 87.38 | 996.88 | 218.45 |
SO49125_22 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 470 | 435 | 4 | 2023-04-05 | 45.59 | 1.14 | 2023-03-24 | 2 | 15.67 | 1 | 45.59 | 22 | SO49125 | 2023-03-31 | 3.65 | 31.34 | 22.79 |
SO51731_21 | FF50-4EB1-9E | PO13601192740 | 100 | 281 | 491 | 310 | 3 | 2023-10-03 | 32.39 | 0.81 | 2023-09-21 | 1 | 41.57 | 1 | 32.39 | 21 | SO51731 | 2023-09-28 | 2.59 | 41.57 | 32.39 |
SO50208_18 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 286 | 328 | 4 | 2023-07-03 | 1103.63 | 27.59 | 2023-06-21 | 6 | 170.14 | 1 | 1103.63 | 18 | SO50208 | 2023-06-28 | 88.29 | 1020.86 | 183.94 |
SO61189_4 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 388 | 670 | 3 | 2024-03-04 | 1344.59 | 33.61 | 2024-02-21 | 2 | 713.08 | 1 | 1344.59 | 4 | SO61189 | 2024-02-28 | 107.57 | 1426.16 | 672.29 |
SO50289_45 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 375 | 436 | 4 | 2023-07-03 | 9162.56 | 229.06 | 2023-06-21 | 7 | 1320.68 | 1 | 9162.56 | 45 | SO50289 | 2023-06-28 | 733.01 | 9244.79 | 1308.94 |
SO67262_2 | 5BD7-455E-9A | PO19314114641 | 100 | 281 | 580 | 622 | 3 | 2024-06-03 | 1020.59 | 25.51 | 2024-05-22 | 1 | 1082.51 | 1 | 1020.59 | 2 | SO67262 | 2024-05-29 | 81.65 | 1082.51 | 1020.59 |
SO57034_6 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 374 | 328 | 4 | 2024-01-03 | 7330.05 | 183.25 | 2023-12-22 | 5 | 1554.95 | 1 | 7330.05 | 6 | SO57034 | 2023-12-29 | 586.40 | 7774.74 | 1466.01 |
SO51855_41 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 546 | 436 | 4 | 2023-10-03 | 149.02 | 3.73 | 2023-09-21 | 4 | 27.57 | 1 | 149.02 | 41 | SO51855 | 2023-09-28 | 11.92 | 110.27 | 37.25 |
SO50751_2 | 5750-45C6-9C | PO7018191419 | 100 | 281 | 224 | 695 | 3 | 2023-08-03 | 31.12 | 0.78 | 2023-07-22 | 6 | 5.23 | 1 | 31.12 | 2 | SO50751 | 2023-07-29 | 2.49 | 31.38 | 5.19 |
SO51091_3 | DEAC-431D-94 | PO15399127644 | 100 | 281 | 471 | 220 | 3 | 2023-09-02 | 76.20 | 1.91 | 2023-08-21 | 2 | 23.75 | 1 | 76.20 | 3 | SO51091 | 2023-08-28 | 6.10 | 47.50 | 38.10 |
SO50282_15 | 9C0C-42E0-B6 | PO6525160235 | 100 | 281 | 305 | 345 | 4 | 2023-07-03 | 3680.73 | 92.02 | 2023-06-21 | 5 | 653.70 | 1 | 3680.73 | 15 | SO50282 | 2023-06-28 | 294.46 | 3268.49 | 736.15 |
SO48076_16 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 421 | 642 | 2 | 2023-01-03 | 588.99 | 14.72 | 2022-12-22 | 3 | 145.28 | 1 | 588.99 | 16 | SO48076 | 2022-12-29 | 47.12 | 435.85 | 196.33 |
SO53480_43 | 36E1-4FCF-B4 | PO15341137525 | 100 | 281 | 515 | 327 | 3 | 2023-11-03 | 16.27 | 0.41 | 2023-10-22 | 1 | 12.04 | 1 | 16.27 | 43 | SO53480 | 2023-10-29 | 1.30 | 12.04 | 16.27 |
SO48076_34 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 213 | 642 | 2 | 2023-01-03 | 80.75 | 2.02 | 2022-12-22 | 4 | 13.88 | 1 | 80.75 | 34 | SO48076 | 2022-12-29 | 6.46 | 55.51 | 20.19 |
SO53616_18 | A692-4827-93 | PO6786150961 | 100 | 281 | 471 | 3 | 4 | 2023-11-03 | 152.40 | 3.81 | 2023-10-22 | 4 | 23.75 | 1 | 152.40 | 18 | SO53616 | 2023-10-29 | 12.19 | 95.00 | 38.10 |
SO48748_1 | 4FC9-469B-88 | PO3016138326 | 100 | 281 | 358 | 183 | 3 | 2023-03-05 | 1229.46 | 30.74 | 2023-02-21 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO48748 | 2023-02-28 | 98.36 | 1105.81 | 1229.46 |
SO58928_12 | 6C1A-4E73-97 | PO15341119997 | 100 | 281 | 598 | 327 | 3 | 2024-02-02 | 323.99 | 8.10 | 2024-01-21 | 1 | 294.58 | 1 | 323.99 | 12 | SO58928 | 2024-01-28 | 25.92 | 294.58 | 323.99 |
SO65311_25 | 8732-477D-BC | PO7047142102 | 100 | 281 | 512 | 544 | 3 | 2024-05-03 | 436.91 | 10.92 | 2024-04-21 | 2 | 199.38 | 1 | 436.91 | 25 | SO65311 | 2024-04-28 | 34.95 | 398.75 | 218.45 |
SO53621_47 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 398 | 490 | 4 | 2023-11-03 | 106.90 | 2.67 | 2023-10-22 | 4 | 19.78 | 1 | 106.90 | 47 | SO53621 | 2023-10-29 | 8.55 | 79.10 | 26.72 |
SO67299_3 | C526-4C88-8A | PO3016155212 | 100 | 281 | 475 | 183 | 3 | 2024-06-03 | 125.98 | 3.15 | 2024-05-22 | 3 | 26.18 | 1 | 125.98 | 3 | SO67299 | 2024-05-29 | 10.08 | 78.53 | 41.99 |
SO57145_7 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 515 | 435 | 4 | 2024-01-03 | 32.54 | 0.81 | 2023-12-22 | 2 | 12.04 | 1 | 32.54 | 7 | SO57145 | 2023-12-29 | 2.60 | 24.08 | 16.27 |
SO61247_6 | 813A-4977-AD | PO6409149613 | 100 | 281 | 482 | 292 | 4 | 2024-03-04 | 16.18 | 0.40 | 2024-02-21 | 3 | 3.36 | 1 | 16.18 | 6 | SO61247 | 2024-02-28 | 1.29 | 10.09 | 5.39 |
SO50748_3 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 453 | 3 | 4 | 2023-08-03 | 71.99 | 1.80 | 2023-07-22 | 2 | 24.75 | 1 | 71.99 | 3 | SO50748 | 2023-07-29 | 5.76 | 49.49 | 35.99 |
SO51714_46 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 231 | 328 | 4 | 2023-10-03 | 239.95 | 6.00 | 2023-09-21 | 8 | 38.49 | 1 | 239.95 | 46 | SO51714 | 2023-09-28 | 19.20 | 307.94 | 29.99 |
SO50748_24 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 335 | 3 | 4 | 2023-08-03 | 2818.76 | 70.47 | 2023-07-22 | 6 | 486.71 | 1 | 2818.76 | 24 | SO50748 | 2023-07-29 | 225.50 | 2920.24 | 469.79 |
SO51720_48 | E39F-4680-AC | PO15370128892 | 100 | 281 | 597 | 381 | 3 | 2023-10-03 | 2267.96 | 56.70 | 2023-09-21 | 7 | 294.58 | 1 | 2267.96 | 48 | SO51720 | 2023-09-28 | 181.44 | 2062.06 | 323.99 |
Generated 2024-09-20 09:41:58.972 UTC