[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 1439 > < TAKE 62 >
62 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO47687_23 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 389 | 203 | 4 | 2023-01-23 | 1200.53 | 30.01 | 2023-01-11 | 2 | 605.65 | 1 | 1200.53 | 23 | SO47687 | 2023-01-18 | 96.04 | 1211.30 | 600.26 | |||
| SO48295_37 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 377 | 24 | 4 | 2023-03-25 | 1308.94 | 32.72 | 2023-03-13 | 1 | 1320.68 | 1 | 1308.94 | 37 | SO48295 | 2023-03-20 | 104.72 | 1320.68 | 1308.94 | |||
| SO50208_29 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 456 | 328 | 4 | 2023-08-23 | 134.98 | 3.37 | 2023-08-11 | 3 | 30.93 | 1 | 134.98 | 29 | SO50208 | 2023-08-18 | 10.80 | 92.80 | 44.99 | |||
| SO51126_24 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 574 | 205 | 4 | 2023-10-23 | 10013.09 | 250.33 | 2023-10-11 | 7 | 1481.94 | 1 | 10013.09 | 24 | SO51126 | 2023-10-18 | 801.05 | 10373.57 | 1430.44 | |||
| SO45317_14 | 92DD-46A2-8D | PO2523164373 | 100 | 272 | 319 | 167 | 4 | 2022-05-26 | 874.79 | 21.87 | 2022-05-14 | 1 | 884.71 | 1 | 874.79 | 14 | SO45317 | 2022-05-21 | 69.98 | 884.71 | 874.79 | |||
| SO67325_16 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 483 | 3 | 221 | 4 | 56.10 | 2024-07-24 | 1122.00 | 26.65 | 2024-07-12 | 17 | 44.88 | 1 | 1065.90 | 16 | SO67325 | 2024-07-19 | 85.27 | 762.96 | 66.00 | 0.05 |
| SO44509_12 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 215 | 328 | 4 | 2022-02-23 | 60.56 | 1.51 | 2022-02-11 | 3 | 12.03 | 1 | 60.56 | 12 | SO44509 | 2022-02-18 | 4.84 | 36.08 | 20.19 | |||
| SO44087_1 | F58F-45C1-8E | PO16095130285 | 100 | 282 | 310 | 96 | 4 | 2021-12-24 | 4293.92 | 107.35 | 2021-12-12 | 2 | 2171.29 | 1 | 4293.92 | 1 | SO44087 | 2021-12-19 | 343.51 | 4342.59 | 2146.96 | |||
| SO49538_21 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 456 | 3 | 4 | 2023-06-23 | 134.98 | 3.37 | 2023-06-11 | 3 | 30.93 | 1 | 134.98 | 21 | SO49538 | 2023-06-18 | 10.80 | 92.80 | 44.99 | |||
| SO58992_2 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 474 | 23 | 4 | 2024-03-24 | 251.96 | 6.30 | 2024-03-12 | 6 | 26.18 | 1 | 251.96 | 2 | SO58992 | 2024-03-19 | 20.16 | 157.06 | 41.99 | |||
| SO45074_21 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 270 | 221 | 4 | 2022-04-25 | 735.75 | 18.39 | 2022-04-13 | 4 | 181.49 | 1 | 735.75 | 21 | SO45074 | 2022-04-20 | 58.86 | 725.94 | 183.94 | |||
| SO47990_16 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 329 | 328 | 4 | 2023-02-23 | 4228.15 | 105.70 | 2023-02-11 | 9 | 486.71 | 1 | 4228.15 | 16 | SO47990 | 2023-02-18 | 338.25 | 4380.36 | 469.79 | |||
| SO43865_7 | 071C-4913-89 | PO15689147174 | 100 | 283 | 326 | 328 | 4 | 2021-11-23 | 419.46 | 10.49 | 2021-11-11 | 1 | 413.15 | 1 | 419.46 | 7 | SO43865 | 2021-11-18 | 33.56 | 413.15 | 419.46 | |||
| SO57138_15 | CD80-4144-8A | PO5684168325 | 100 | 282 | 533 | 385 | 4 | 2024-02-23 | 599.50 | 14.99 | 2024-02-11 | 4 | 136.79 | 1 | 599.50 | 15 | SO57138 | 2024-02-18 | 47.96 | 547.14 | 149.87 | |||
| SO46338_15 | 0BAC-4D7E-AD | PO15834128897 | 100 | 283 | 315 | 417 | 4 | 2022-09-23 | 2624.38 | 65.61 | 2022-09-11 | 3 | 884.71 | 1 | 2624.38 | 15 | SO46338 | 2022-09-18 | 209.95 | 2654.12 | 874.79 | |||
| SO61243_11 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 287 | 221 | 4 | 2024-04-24 | 404.66 | 10.12 | 2024-04-12 | 2 | 204.63 | 1 | 404.66 | 11 | SO61243 | 2024-04-19 | 32.37 | 409.25 | 202.33 | |||
| SO47045_25 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 447 | 309 | 4 | 2022-11-23 | 45.00 | 1.13 | 2022-11-11 | 3 | 10.31 | 1 | 45.00 | 25 | SO47045 | 2022-11-18 | 3.60 | 30.94 | 15.00 | |||
| SO51122_14 | D915-4225-97 | PO551181465 | 100 | 281 | 434 | 4 | 4 | 2023-10-23 | 1784.49 | 44.61 | 2023-10-11 | 5 | 360.94 | 1 | 1784.49 | 14 | SO51122 | 2023-10-18 | 142.76 | 1804.71 | 356.90 | |||
| SO59023_28 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 309 | 61 | 4 | 2024-03-24 | 1637.40 | 40.94 | 2024-03-12 | 2 | 747.20 | 1 | 1637.40 | 28 | SO59023 | 2024-03-19 | 130.99 | 1494.40 | 818.70 | |||
| SO47435_51 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 216 | 75 | 4 | 2022-12-24 | 161.49 | 4.04 | 2022-12-12 | 8 | 13.88 | 1 | 161.49 | 51 | SO47435 | 2022-12-19 | 12.92 | 111.03 | 20.19 | |||
| SO65315_18 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 222 | 21 | 4 | 2024-06-23 | 20.99 | 0.52 | 2024-06-11 | 1 | 13.09 | 1 | 20.99 | 18 | SO65315 | 2024-06-18 | 1.68 | 13.09 | 20.99 | |||
| SO67320_20 | 771C-4E57-91 | PO5626199373 | 100 | 281 | 583 | 166 | 4 | 2024-07-24 | 9185.35 | 229.63 | 2024-07-12 | 9 | 1082.51 | 1 | 9185.35 | 20 | SO67320 | 2024-07-19 | 734.83 | 9742.59 | 1020.59 | |||
| SO50313_30 | B452-44E9-91 | PO7656143984 | 100 | 282 | 273 | 403 | 4 | 2023-08-23 | 202.33 | 5.06 | 2023-08-11 | 1 | 187.16 | 1 | 202.33 | 30 | SO50313 | 2023-08-18 | 16.19 | 187.16 | 202.33 | |||
| SO48016_12 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 447 | 97 | 4 | 2023-02-23 | 45.00 | 1.13 | 2023-02-11 | 3 | 10.31 | 1 | 45.00 | 12 | SO48016 | 2023-02-18 | 3.60 | 30.94 | 15.00 | |||
| SO48780_19 | F139-41F4-83 | PO5626121558 | 100 | 281 | 389 | 166 | 4 | 2023-04-25 | 600.26 | 15.01 | 2023-04-13 | 1 | 605.65 | 1 | 600.26 | 19 | SO48780 | 2023-04-20 | 48.02 | 605.65 | 600.26 | |||
| SO45536_18 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 310 | 273 | 4 | 2022-06-23 | 2146.96 | 53.67 | 2022-06-11 | 1 | 2171.29 | 1 | 2146.96 | 18 | SO45536 | 2022-06-18 | 171.76 | 2171.29 | 2146.96 | |||
| SO69515_25 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 372 | 255 | 4 | 2024-08-23 | 1466.01 | 36.65 | 2024-08-11 | 1 | 1554.95 | 1 | 1466.01 | 25 | SO69515 | 2024-08-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO51131_12 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 576 | 3 | 599 | 4 | 1376.80 | 2023-10-23 | 27536.01 | 653.98 | 2023-10-11 | 21 | 1481.94 | 1 | 26159.21 | 12 | SO51131 | 2023-10-18 | 2092.74 | 31120.70 | 1311.24 | 0.05 |
| SO59027_24 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 551 | 21 | 4 | 2024-03-24 | 158.43 | 3.96 | 2024-03-12 | 1 | 144.59 | 1 | 158.43 | 24 | SO59027 | 2024-03-19 | 12.67 | 144.59 | 158.43 | |||
| SO50214_24 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 371 | 258 | 4 | 2023-08-23 | 5235.75 | 130.89 | 2023-08-11 | 4 | 1320.68 | 1 | 5235.75 | 24 | SO50214 | 2023-08-18 | 418.86 | 5282.74 | 1308.94 | |||
| SO58979_12 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 552 | 509 | 4 | 2024-03-24 | 54.89 | 1.37 | 2024-03-12 | 1 | 40.62 | 1 | 54.89 | 12 | SO58979 | 2024-03-19 | 4.39 | 40.62 | 54.89 | |||
| SO47400_23 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 294 | 133 | 4 | 2022-12-24 | 744.27 | 18.61 | 2022-12-12 | 1 | 660.91 | 1 | 744.27 | 23 | SO47400 | 2022-12-19 | 59.54 | 660.91 | 744.27 | |||
| SO50663_12 | 286E-4915-89 | PO19343130555 | 100 | 282 | 458 | 3 | 24 | 4 | 30.93 | 2023-09-23 | 618.67 | 14.69 | 2023-09-11 | 15 | 30.93 | 1 | 587.73 | 12 | SO50663 | 2023-09-18 | 47.02 | 464.00 | 41.24 | 0.05 |
| SO47990_19 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 263 | 328 | 4 | 2023-02-23 | 1011.66 | 25.29 | 2023-02-11 | 5 | 187.16 | 1 | 1011.66 | 19 | SO47990 | 2023-02-18 | 80.93 | 935.79 | 202.33 | |||
| SO50753_14 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 308 | 608 | 4 | 2023-09-23 | 4465.64 | 111.64 | 2023-09-11 | 6 | 660.91 | 1 | 4465.64 | 14 | SO50753 | 2023-09-18 | 357.25 | 3965.49 | 744.27 | |||
| SO48356_16 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 421 | 187 | 4 | 2023-03-25 | 1177.97 | 29.45 | 2023-03-13 | 6 | 145.28 | 1 | 1177.97 | 16 | SO48356 | 2023-03-20 | 94.24 | 871.70 | 196.33 | |||
| SO71952_24 | 9490-4552-81 | PO9715163911 | 100 | 281 | 361 | 490 | 4 | 2024-09-23 | 5507.98 | 137.70 | 2024-09-11 | 4 | 1251.98 | 1 | 5507.98 | 24 | SO71952 | 2024-09-18 | 440.64 | 5007.93 | 1376.99 | |||
| SO63201_3 | 8299-4DE4-AD | PO15689136917 | 100 | 281 | 374 | 328 | 4 | 2024-05-25 | 2932.02 | 73.30 | 2024-05-13 | 2 | 1554.95 | 1 | 2932.02 | 3 | SO63201 | 2024-05-20 | 234.56 | 3109.90 | 1466.01 | |||
| SO46058_11 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 264 | 240 | 4 | 2022-08-23 | 183.94 | 4.60 | 2022-08-11 | 1 | 181.49 | 1 | 183.94 | 11 | SO46058 | 2022-08-18 | 14.72 | 181.49 | 183.94 | |||
| SO48775_14 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 375 | 203 | 4 | 2023-04-25 | 1308.94 | 32.72 | 2023-04-13 | 1 | 1320.68 | 1 | 1308.94 | 14 | SO48775 | 2023-04-20 | 104.72 | 1320.68 | 1308.94 | |||
| SO71881_29 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 512 | 21 | 4 | 2024-09-23 | 436.91 | 10.92 | 2024-09-11 | 2 | 199.38 | 1 | 436.91 | 29 | SO71881 | 2024-09-18 | 34.95 | 398.75 | 218.45 | |||
| SO49841_42 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 286 | 203 | 4 | 2023-07-24 | 551.81 | 13.80 | 2023-07-12 | 3 | 170.14 | 1 | 551.81 | 42 | SO49841 | 2023-07-19 | 44.15 | 510.43 | 183.94 | |||
| SO58907_2 | F365-4683-97 | PO19372175613 | 100 | 282 | 571 | 582 | 4 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 2 | SO58907 | 2024-03-19 | 35.63 | 461.44 | 445.41 | |||
| SO65157_22 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 555 | 582 | 4 | 2024-06-23 | 63.90 | 1.60 | 2024-06-11 | 1 | 47.29 | 1 | 63.90 | 22 | SO65157 | 2024-06-18 | 5.11 | 47.29 | 63.90 | |||
| SO49515_20 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 297 | 490 | 4 | 2023-06-23 | 736.15 | 18.40 | 2023-06-11 | 1 | 653.70 | 1 | 736.15 | 20 | SO49515 | 2023-06-18 | 58.89 | 653.70 | 736.15 | |||
| SO71882_12 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 355 | 75 | 4 | 2024-09-23 | 2783.99 | 69.60 | 2024-09-11 | 2 | 1265.62 | 1 | 2783.99 | 12 | SO71882 | 2024-09-18 | 222.72 | 2531.24 | 1391.99 | |||
| SO44756_6 | 7857-4221-BA | PO15138192148 | 100 | 283 | 276 | 93 | 4 | 2022-03-25 | 356.90 | 8.92 | 2022-03-13 | 1 | 352.14 | 1 | 356.90 | 6 | SO44756 | 2022-03-20 | 28.55 | 352.14 | 356.90 | |||
| SO46355_17 | D579-4B15-AB | PO261195016 | 100 | 283 | 229 | 647 | 4 | 2022-09-23 | 86.52 | 2.16 | 2022-09-11 | 3 | 31.72 | 1 | 86.52 | 17 | SO46355 | 2022-09-18 | 6.92 | 95.17 | 28.84 | |||
| SO44521_23 | E46D-4692-AC | PO12557171689 | 100 | 282 | 315 | 240 | 4 | 2022-02-23 | 874.79 | 21.87 | 2022-02-11 | 1 | 884.71 | 1 | 874.79 | 23 | SO44521 | 2022-02-18 | 69.98 | 884.71 | 874.79 | |||
| SO44752_8 | 584D-40E8-AF | PO15950187592 | 100 | 282 | 315 | 114 | 4 | 2022-03-25 | 3499.18 | 87.48 | 2022-03-13 | 4 | 884.71 | 1 | 3499.18 | 8 | SO44752 | 2022-03-20 | 279.93 | 3538.83 | 874.79 | |||
| SO44564_17 | 142F-443C-90 | PO7656157194 | 100 | 282 | 328 | 403 | 4 | 2022-02-23 | 419.46 | 10.49 | 2022-02-11 | 1 | 413.15 | 1 | 419.46 | 17 | SO44564 | 2022-02-18 | 33.56 | 413.15 | 419.46 | |||
| SO65180_2 | B9CA-46FC-B0 | PO16182138917 | 100 | 287 | 475 | 23 | 4 | 2024-06-23 | 125.98 | 3.15 | 2024-06-11 | 3 | 26.18 | 1 | 125.98 | 2 | SO65180 | 2024-06-18 | 10.08 | 78.53 | 41.99 | |||
| SO71845_4 | 4781-4673-85 | PO2697119362 | 100 | 282 | 295 | 187 | 4 | 2024-09-23 | 2456.10 | 61.40 | 2024-09-11 | 3 | 747.20 | 1 | 2456.10 | 4 | SO71845 | 2024-09-18 | 196.49 | 2241.60 | 818.70 | |||
| SO46625_6 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 399 | 475 | 4 | 2022-10-23 | 135.10 | 3.38 | 2022-10-11 | 4 | 24.99 | 1 | 135.10 | 6 | SO46625 | 2022-10-18 | 10.81 | 99.97 | 33.77 | |||
| SO71848_2 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 559 | 59 | 4 | 2024-09-23 | 12.14 | 0.30 | 2024-09-11 | 1 | 8.99 | 1 | 12.14 | 2 | SO71848 | 2024-09-18 | 0.97 | 8.99 | 12.14 | |||
| SO47034_30 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 424 | 257 | 4 | 2022-11-23 | 428.47 | 10.71 | 2022-11-11 | 2 | 158.53 | 1 | 428.47 | 30 | SO47034 | 2022-11-18 | 34.28 | 317.07 | 214.24 | |||
| SO51121_4 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 463 | 491 | 4 | 2023-10-23 | 29.39 | 0.73 | 2023-10-11 | 2 | 9.16 | 1 | 29.39 | 4 | SO51121 | 2023-10-18 | 2.35 | 18.32 | 14.69 | |||
| SO50266_5 | 5A1A-4C41-B9 | PO15921150902 | 100 | 287 | 343 | 77 | 4 | 2023-08-23 | 939.59 | 23.49 | 2023-08-11 | 2 | 486.71 | 1 | 939.59 | 5 | SO50266 | 2023-08-18 | 75.17 | 973.41 | 469.79 | |||
| SO51773_32 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 217 | 167 | 4 | 2023-11-23 | 125.96 | 3.15 | 2023-11-11 | 6 | 13.09 | 1 | 125.96 | 32 | SO51773 | 2023-11-18 | 10.08 | 78.52 | 20.99 | |||
| SO71924_2 | 1C32-4971-8C | PO725177386 | 100 | 281 | 353 | 291 | 4 | 2024-09-23 | 2783.99 | 69.60 | 2024-09-11 | 2 | 1265.62 | 1 | 2783.99 | 2 | SO71924 | 2024-09-18 | 222.72 | 2531.24 | 1391.99 | |||
| SO71845_25 | 4781-4673-85 | PO2697119362 | 100 | 282 | 532 | 187 | 4 | 2024-09-23 | 299.75 | 7.49 | 2024-09-11 | 2 | 136.79 | 1 | 299.75 | 25 | SO71845 | 2024-09-18 | 23.98 | 273.57 | 149.87 | |||
| SO71889_29 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 234 | 3 | 4 | 2024-09-23 | 239.95 | 6.00 | 2024-09-11 | 8 | 38.49 | 1 | 239.95 | 29 | SO71889 | 2024-09-18 | 19.20 | 307.94 | 29.99 |
Generated 2024-11-10 13:31:28.257 UTC