[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 167 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43861_25 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 229 | 584 | 5 | 2021-11-23 | 86.52 | 2.16 | 2021-11-11 | 3 | 31.72 | 1 | 86.52 | 25 | SO43861 | 2021-11-18 | 6.92 | 95.17 | 28.84 |
SO53625_4 | 98EA-458A-B9 | PO9744185498 | 100 | 285 | 544 | 98 | 5 | 2023-12-24 | 48.59 | 1.21 | 2023-12-12 | 1 | 35.96 | 1 | 48.59 | 4 | SO53625 | 2023-12-19 | 3.89 | 35.96 | 48.59 |
SO55331_22 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 588 | 494 | 5 | 2024-01-23 | 923.39 | 23.08 | 2024-01-11 | 2 | 419.78 | 1 | 923.39 | 22 | SO55331 | 2024-01-18 | 73.87 | 839.56 | 461.69 |
SO57088_31 | EA31-4951-8A | PO2842199218 | 100 | 285 | 546 | 700 | 5 | 2024-02-23 | 74.51 | 1.86 | 2024-02-11 | 2 | 27.57 | 1 | 74.51 | 31 | SO57088 | 2024-02-18 | 5.96 | 55.14 | 37.25 |
SO45075_1 | 8934-44C4-A1 | PO8120124936 | 100 | 281 | 348 | 485 | 5 | 2022-04-25 | 4049.99 | 101.25 | 2022-04-13 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO45075 | 2022-04-20 | 324.00 | 3796.19 | 2024.99 |
SO49865_19 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 383 | 81 | 5 | 2023-07-24 | 600.26 | 15.01 | 2023-07-12 | 1 | 605.65 | 1 | 600.26 | 19 | SO49865 | 2023-07-19 | 48.02 | 605.65 | 600.26 |
SO55313_6 | E5E5-4D8A-89 | PO3741111643 | 100 | 285 | 605 | 404 | 5 | 2024-01-23 | 323.99 | 8.10 | 2024-01-11 | 1 | 343.65 | 1 | 323.99 | 6 | SO55313 | 2024-01-18 | 25.92 | 343.65 | 323.99 |
SO44518_11 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 293 | 278 | 5 | 2022-02-23 | 2167.78 | 54.19 | 2022-02-11 | 3 | 623.84 | 1 | 2167.78 | 11 | SO44518 | 2022-02-18 | 173.42 | 1871.52 | 722.59 |
SO45577_20 | 7B09-45DB-A3 | PO9599125078 | 100 | 285 | 270 | 170 | 5 | 2022-06-23 | 551.81 | 13.80 | 2022-06-11 | 3 | 181.49 | 1 | 551.81 | 20 | SO45577 | 2022-06-18 | 44.15 | 544.46 | 183.94 |
SO48395_28 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 352 | 585 | 5 | 2023-03-25 | 6214.26 | 155.36 | 2023-03-13 | 5 | 1117.86 | 1 | 6214.26 | 28 | SO48395 | 2023-03-20 | 497.14 | 5589.28 | 1242.85 |
SO46047_9 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 346 | 99 | 5 | 2022-08-23 | 6119.98 | 153.00 | 2022-08-11 | 3 | 1912.15 | 1 | 6119.98 | 9 | SO46047 | 2022-08-18 | 489.60 | 5736.46 | 2039.99 |
SO51705_7 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 234 | 441 | 5 | 2023-11-23 | 119.98 | 3.00 | 2023-11-11 | 4 | 38.49 | 1 | 119.98 | 7 | SO51705 | 2023-11-18 | 9.60 | 153.97 | 29.99 |
SO45062_8 | 017E-486E-BC | PO1189166374 | 100 | 285 | 314 | 423 | 5 | 2022-04-25 | 4293.92 | 107.35 | 2022-04-13 | 2 | 2171.29 | 1 | 4293.92 | 8 | SO45062 | 2022-04-20 | 343.51 | 4342.59 | 2146.96 |
SO49473_2 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 453 | 90 | 5 | 2023-06-23 | 179.97 | 4.50 | 2023-06-11 | 5 | 24.75 | 1 | 179.97 | 2 | SO49473 | 2023-06-18 | 14.40 | 123.73 | 35.99 |
SO48018_26 | 5D69-492B-A1 | PO11571175810 | 100 | 285 | 331 | 512 | 5 | 2023-02-23 | 469.79 | 11.74 | 2023-02-11 | 1 | 486.71 | 1 | 469.79 | 26 | SO48018 | 2023-02-18 | 37.58 | 486.71 | 469.79 |
SO47681_6 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 308 | 530 | 5 | 2023-01-23 | 744.27 | 18.61 | 2023-01-11 | 1 | 660.91 | 1 | 744.27 | 6 | SO47681 | 2023-01-18 | 59.54 | 660.91 | 744.27 |
SO65248_5 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 390 | 170 | 5 | 2024-06-23 | 2016.88 | 50.42 | 2024-06-11 | 3 | 713.08 | 1 | 2016.88 | 5 | SO65248 | 2024-06-18 | 161.35 | 2139.24 | 672.29 |
SO47042_8 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 364 | 566 | 5 | 2022-11-23 | 1943.98 | 48.60 | 2022-11-11 | 3 | 598.44 | 1 | 1943.98 | 8 | SO47042 | 2022-11-18 | 155.52 | 1795.31 | 647.99 |
SO61173_32 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 598 | 676 | 5 | 2024-04-24 | 971.98 | 24.30 | 2024-04-12 | 3 | 294.58 | 1 | 971.98 | 32 | SO61173 | 2024-04-19 | 77.76 | 883.74 | 323.99 |
SO50306_39 | D376-4A40-86 | PO5858194676 | 100 | 285 | 459 | 566 | 5 | 2023-08-23 | 161.98 | 4.05 | 2023-08-11 | 3 | 37.12 | 1 | 161.98 | 39 | SO50306 | 2023-08-18 | 12.96 | 111.36 | 53.99 |
SO48766_14 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 417 | 81 | 5 | 2023-04-25 | 324.45 | 8.11 | 2023-04-13 | 1 | 300.12 | 1 | 324.45 | 14 | SO48766 | 2023-04-20 | 25.96 | 300.12 | 324.45 |
SO44305_5 | E906-4DF2-BE | PO522153226 | 100 | 285 | 296 | 676 | 5 | 2022-01-23 | 1429.41 | 35.74 | 2022-01-11 | 2 | 617.03 | 1 | 1429.41 | 5 | SO44305 | 2022-01-18 | 114.35 | 1234.06 | 714.70 |
SO61173_27 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 532 | 676 | 5 | 2024-04-24 | 299.75 | 7.49 | 2024-04-12 | 2 | 136.79 | 1 | 299.75 | 27 | SO61173 | 2024-04-19 | 23.98 | 273.57 | 149.87 |
SO44801_9 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 338 | 170 | 5 | 2022-03-25 | 838.92 | 20.97 | 2022-03-13 | 2 | 413.15 | 1 | 838.92 | 9 | SO44801 | 2022-03-20 | 67.11 | 826.29 | 419.46 |
SO44562_17 | 1856-47B2-AD | PO7598190472 | 100 | 285 | 276 | 45 | 5 | 2022-02-23 | 356.90 | 8.92 | 2022-02-11 | 1 | 352.14 | 1 | 356.90 | 17 | SO44562 | 2022-02-18 | 28.55 | 352.14 | 356.90 |
SO49835_2 | 2851-442E-B8 | PO12615187380 | 100 | 285 | 470 | 440 | 5 | 2023-07-24 | 159.56 | 3.99 | 2023-07-12 | 7 | 15.67 | 1 | 159.56 | 2 | SO49835 | 2023-07-19 | 12.76 | 109.70 | 22.79 |
SO43910_7 | 8233-42D0-BD | PO7598186753 | 100 | 285 | 276 | 45 | 5 | 2021-11-23 | 356.90 | 8.92 | 2021-11-11 | 1 | 352.14 | 1 | 356.90 | 7 | SO43910 | 2021-11-18 | 28.55 | 352.14 | 356.90 |
SO61173_30 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 592 | 676 | 5 | 2024-04-24 | 338.99 | 8.47 | 2024-04-12 | 1 | 308.22 | 1 | 338.99 | 30 | SO61173 | 2024-04-19 | 27.12 | 308.22 | 338.99 |
Generated 2024-11-10 13:17:56.545 UTC