[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 207 > < TAKE 60 >
60 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48062_5 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 469 | 422 | 5 | 2023-02-25 | 136.76 | 3.42 | 2023-02-13 | 6 | 15.67 | 1 | 136.76 | 5 | SO48062 | 2023-02-20 | 10.94 | 94.03 | 22.79 |
SO55256_14 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 552 | 331 | 4 | 2024-01-25 | 164.68 | 4.12 | 2024-01-13 | 3 | 40.62 | 1 | 164.68 | 14 | SO55256 | 2024-01-20 | 13.17 | 121.86 | 54.89 |
SO44780_12 | EE26-4C8F-95 | PO4147150441 | 100 | 282 | 270 | 222 | 3 | 2022-03-27 | 551.81 | 13.80 | 2022-03-15 | 3 | 181.49 | 1 | 551.81 | 12 | SO44780 | 2022-03-22 | 44.15 | 544.46 | 183.94 |
SO69426_34 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 545 | 638 | 7 | 2024-08-25 | 97.18 | 2.43 | 2024-08-13 | 4 | 17.98 | 1 | 97.18 | 34 | SO69426 | 2024-08-20 | 7.77 | 71.91 | 24.29 |
SO47445_1 | 8C37-45D6-9C | PO8700197197 | 98 | 288 | 410 | 665 | 10 | 2022-12-26 | 36.45 | 0.91 | 2022-12-14 | 1 | 26.97 | 1 | 36.45 | 1 | SO47445 | 2022-12-21 | 2.92 | 26.97 | 36.45 |
SO49499_9 | E899-4E47-A2 | PO15341196181 | 100 | 281 | 409 | 327 | 3 | 2023-06-25 | 209.26 | 5.23 | 2023-06-13 | 1 | 185.82 | 1 | 209.26 | 9 | SO49499 | 2023-06-20 | 16.74 | 185.82 | 209.26 |
SO65226_6 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 465 | 481 | 7 | 2024-06-25 | 73.47 | 1.84 | 2024-06-13 | 5 | 9.16 | 1 | 73.47 | 6 | SO65226 | 2024-06-20 | 5.88 | 45.80 | 14.69 |
SO59075_29 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 564 | 179 | 2 | 2024-03-26 | 4291.33 | 107.28 | 2024-03-14 | 3 | 1481.94 | 1 | 4291.33 | 29 | SO59075 | 2024-03-21 | 343.31 | 4445.81 | 1430.44 |
SO45812_6 | 309C-4710-B7 | PO6235178037 | 100 | 281 | 223 | 431 | 3 | 2022-07-26 | 10.37 | 0.26 | 2022-07-14 | 2 | 5.71 | 1 | 10.37 | 6 | SO45812 | 2022-07-21 | 0.83 | 11.41 | 5.19 |
SO71889_1 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 231 | 3 | 4 | 2024-09-25 | 89.98 | 2.25 | 2024-09-13 | 3 | 38.49 | 1 | 89.98 | 1 | SO71889 | 2024-09-20 | 7.20 | 115.48 | 29.99 |
SO48035_5 | EDA1-4042-A6 | PO1508198786 | 98 | 288 | 337 | 430 | 10 | 2023-02-25 | 1409.38 | 35.23 | 2023-02-13 | 3 | 486.71 | 1 | 1409.38 | 5 | SO48035 | 2023-02-20 | 112.75 | 1460.12 | 469.79 |
SO59050_3 | 0C0C-4810-A6 | PO3277119270 | 100 | 293 | 605 | 604 | 1 | 2024-03-26 | 971.98 | 24.30 | 2024-03-14 | 3 | 343.65 | 1 | 971.98 | 3 | SO59050 | 2024-03-21 | 77.76 | 1030.95 | 323.99 |
SO47354_4 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 213 | 173 | 6 | 2022-12-26 | 80.75 | 2.02 | 2022-12-14 | 4 | 13.88 | 1 | 80.75 | 4 | SO47354 | 2022-12-21 | 6.46 | 55.51 | 20.19 |
SO58914_8 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 372 | 155 | 6 | 2024-03-26 | 5864.04 | 146.60 | 2024-03-14 | 4 | 1554.95 | 1 | 5864.04 | 8 | SO58914 | 2024-03-21 | 469.12 | 6219.79 | 1466.01 |
SO45812_8 | 309C-4710-B7 | PO6235178037 | 100 | 281 | 328 | 431 | 3 | 2022-07-26 | 838.92 | 20.97 | 2022-07-14 | 2 | 413.15 | 1 | 838.92 | 8 | SO45812 | 2022-07-21 | 67.11 | 826.29 | 419.46 |
SO61184_35 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 572 | 599 | 4 | 2024-04-26 | 890.82 | 22.27 | 2024-04-14 | 2 | 461.44 | 1 | 890.82 | 35 | SO61184 | 2024-04-21 | 71.27 | 922.89 | 445.41 |
SO47028_16 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 356 | 312 | 4 | 2022-11-25 | 6214.26 | 155.36 | 2022-11-13 | 5 | 1117.86 | 1 | 6214.26 | 16 | SO47028 | 2022-11-20 | 497.14 | 5589.28 | 1242.85 |
SO44525_13 | E0C6-40AA-AD | PO11600189203 | 19 | 288 | 316 | 569 | 6 | 2022-02-25 | 3499.18 | 87.48 | 2022-02-13 | 4 | 884.71 | 1 | 3499.18 | 13 | SO44525 | 2022-02-20 | 279.93 | 3538.83 | 874.79 |
SO47409_12 | FC23-4384-86 | PO1624119173 | 100 | 283 | 271 | 579 | 3 | 2022-12-26 | 202.33 | 5.06 | 2022-12-14 | 1 | 187.16 | 1 | 202.33 | 12 | SO47409 | 2022-12-21 | 16.19 | 187.16 | 202.33 |
SO58957_16 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 593 | 685 | 6 | 2024-03-26 | 338.99 | 8.47 | 2024-03-14 | 1 | 308.22 | 1 | 338.99 | 16 | SO58957 | 2024-03-21 | 27.12 | 308.22 | 338.99 |
SO57072_1 | 699B-409D-98 | PO10150192457 | 100 | 285 | 295 | 9 | 5 | 2024-02-25 | 818.70 | 20.47 | 2024-02-13 | 1 | 747.20 | 1 | 818.70 | 1 | SO57072 | 2024-02-20 | 65.50 | 747.20 | 818.70 |
SO57075_15 | 27EF-4569-AD | PO10266197377 | 6 | 296 | 487 | 393 | 9 | 2024-02-25 | 65.99 | 1.65 | 2024-02-13 | 2 | 20.57 | 1 | 65.99 | 15 | SO57075 | 2024-02-20 | 5.28 | 41.13 | 32.99 |
SO53623_16 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 234 | 235 | 1 | 2023-12-26 | 59.99 | 1.50 | 2023-12-14 | 2 | 38.49 | 1 | 59.99 | 16 | SO53623 | 2023-12-21 | 4.80 | 76.98 | 29.99 |
SO47999_7 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 308 | 650 | 1 | 2023-02-25 | 744.27 | 18.61 | 2023-02-13 | 1 | 660.91 | 1 | 744.27 | 7 | SO47999 | 2023-02-20 | 59.54 | 660.91 | 744.27 |
SO51824_21 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 591 | 63 | 5 | 2023-11-25 | 677.99 | 16.95 | 2023-11-13 | 2 | 308.22 | 1 | 677.99 | 21 | SO51824 | 2023-11-20 | 54.24 | 616.44 | 338.99 |
SO69460_12 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 287 | 426 | 6 | 2024-08-25 | 607.00 | 15.17 | 2024-08-13 | 3 | 204.63 | 1 | 607.00 | 12 | SO69460 | 2024-08-20 | 48.56 | 613.88 | 202.33 |
SO48069_1 | 60CF-43B6-82 | PO6438117188 | 100 | 283 | 453 | 309 | 4 | 2023-02-25 | 143.98 | 3.60 | 2023-02-13 | 4 | 24.75 | 1 | 143.98 | 1 | SO48069 | 2023-02-20 | 11.52 | 98.98 | 35.99 |
SO46038_8 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 264 | 102 | 6 | 2022-08-25 | 183.94 | 4.60 | 2022-08-13 | 1 | 181.49 | 1 | 183.94 | 8 | SO46038 | 2022-08-20 | 14.72 | 181.49 | 183.94 |
SO53571_2 | 89B3-4B87-A8 | PO7482124191 | 100 | 293 | 499 | 163 | 1 | 2023-12-26 | 1807.04 | 45.18 | 2023-12-14 | 3 | 601.74 | 1 | 1807.04 | 2 | SO53571 | 2023-12-21 | 144.56 | 1805.23 | 602.35 |
SO44509_23 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 338 | 328 | 4 | 2022-02-25 | 419.46 | 10.49 | 2022-02-13 | 1 | 413.15 | 1 | 419.46 | 23 | SO44509 | 2022-02-20 | 33.56 | 413.15 | 419.46 |
SO57160_20 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 482 | 343 | 1 | 2024-02-25 | 48.55 | 1.21 | 2024-02-13 | 9 | 3.36 | 1 | 48.55 | 20 | SO57160 | 2024-02-20 | 3.88 | 30.26 | 5.39 |
SO63262_12 | 3368-4317-8F | PO6351144702 | 100 | 281 | 604 | 255 | 4 | 2024-05-27 | 323.99 | 8.10 | 2024-05-15 | 1 | 343.65 | 1 | 323.99 | 12 | SO63262 | 2024-05-22 | 25.92 | 343.65 | 323.99 |
SO50721_7 | E836-480F-AA | PO16182137721 | 100 | 287 | 458 | 23 | 4 | 2023-09-25 | 89.99 | 2.25 | 2023-09-13 | 2 | 30.93 | 1 | 89.99 | 7 | SO50721 | 2023-09-20 | 7.20 | 61.87 | 44.99 |
SO65275_2 | 40CC-4629-AD | PO4031163164 | 6 | 296 | 567 | 555 | 9 | 2024-06-25 | 445.41 | 11.14 | 2024-06-13 | 1 | 461.44 | 1 | 445.41 | 2 | SO65275 | 2024-06-20 | 35.63 | 461.44 | 445.41 |
SO58957_6 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 598 | 685 | 6 | 2024-03-26 | 323.99 | 8.10 | 2024-03-14 | 1 | 294.58 | 1 | 323.99 | 6 | SO58957 | 2024-03-21 | 25.92 | 294.58 | 323.99 |
SO57044_8 | 6960-4E37-97 | PO14558116667 | 100 | 289 | 475 | 2 | 1 | 2024-02-25 | 41.99 | 1.05 | 2024-02-13 | 1 | 26.18 | 1 | 41.99 | 8 | SO57044 | 2024-02-20 | 3.36 | 26.18 | 41.99 |
SO48356_8 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 397 | 187 | 4 | 2023-03-27 | 24.29 | 0.61 | 2023-03-15 | 1 | 17.98 | 1 | 24.29 | 8 | SO48356 | 2023-03-22 | 1.94 | 17.98 | 24.29 |
SO59013_3 | C224-4535-BA | PO5597199820 | 100 | 281 | 306 | 75 | 4 | 2024-03-26 | 809.76 | 20.24 | 2024-03-14 | 1 | 739.04 | 1 | 809.76 | 3 | SO59013 | 2024-03-21 | 64.78 | 739.04 | 809.76 |
SO53460_28 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 404 | 24 | 4 | 2023-12-26 | 26.72 | 0.67 | 2023-12-14 | 1 | 19.78 | 1 | 26.72 | 28 | SO53460 | 2023-12-21 | 2.14 | 19.78 | 26.72 |
SO48395_29 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 419 | 585 | 5 | 2023-03-27 | 52.65 | 1.32 | 2023-03-15 | 1 | 38.96 | 1 | 52.65 | 29 | SO48395 | 2023-03-22 | 4.21 | 38.96 | 52.65 |
SO47666_22 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 365 | 146 | 1 | 2023-01-25 | 3887.96 | 97.20 | 2023-01-13 | 6 | 598.44 | 1 | 3887.96 | 22 | SO47666 | 2023-01-20 | 311.04 | 3590.61 | 647.99 |
SO61232_9 | 3450-43E5-B1 | PO11136111699 | 19 | 284 | 564 | 120 | 6 | 2024-04-26 | 1430.44 | 35.76 | 2024-04-14 | 1 | 1481.94 | 1 | 1430.44 | 9 | SO61232 | 2024-04-21 | 114.44 | 1481.94 | 1430.44 |
SO48056_11 | 5868-43E3-AD | PO4843164827 | 100 | 287 | 381 | 257 | 4 | 2023-02-25 | 600.26 | 15.01 | 2023-02-13 | 1 | 605.65 | 1 | 600.26 | 11 | SO48056 | 2023-02-20 | 48.02 | 605.65 | 600.26 |
SO49512_16 | E722-4D76-AD | PO12354152645 | 100 | 283 | 367 | 197 | 3 | 2023-06-25 | 1943.98 | 48.60 | 2023-06-13 | 3 | 598.44 | 1 | 1943.98 | 16 | SO49512 | 2023-06-20 | 155.52 | 1795.31 | 647.99 |
SO46380_11 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 215 | 608 | 4 | 2022-09-25 | 20.19 | 0.50 | 2022-09-13 | 1 | 12.03 | 1 | 20.19 | 11 | SO46380 | 2022-09-20 | 1.61 | 12.03 | 20.19 |
SO61228_26 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 225 | 81 | 5 | 2024-04-26 | 26.97 | 0.67 | 2024-04-14 | 5 | 6.92 | 1 | 26.97 | 26 | SO61228 | 2024-04-21 | 2.16 | 34.61 | 5.39 |
SO43867_5 | 061F-4449-BE | PO14471123403 | 100 | 286 | 346 | 145 | 1 | 2021-11-25 | 4079.99 | 102.00 | 2021-11-13 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO43867 | 2021-11-20 | 326.40 | 3824.31 | 2039.99 |
SO71822_34 | AEDC-410A-9B | PO11774139099 | 6 | 296 | 484 | 682 | 9 | 2024-09-25 | 14.31 | 0.36 | 2024-09-13 | 3 | 2.97 | 1 | 14.31 | 34 | SO71822 | 2024-09-20 | 1.14 | 8.92 | 4.77 |
SO71784_23 | B186-4413-B4 | PO19285135919 | 98 | 288 | 568 | 448 | 10 | 2024-09-25 | 1336.23 | 33.41 | 2024-09-13 | 3 | 461.44 | 1 | 1336.23 | 23 | SO71784 | 2024-09-20 | 106.90 | 1384.33 | 445.41 |
SO65178_9 | 808E-413C-94 | PO16994175277 | 100 | 283 | 481 | 306 | 3 | 2024-06-25 | 5.39 | 0.13 | 2024-06-13 | 1 | 3.36 | 1 | 5.39 | 9 | SO65178 | 2024-06-20 | 0.43 | 3.36 | 5.39 |
SO45793_2 | 0B18-49B2-96 | PO13775113238 | 100 | 281 | 336 | 618 | 2 | 2022-07-26 | 419.46 | 10.49 | 2022-07-14 | 1 | 413.15 | 1 | 419.46 | 2 | SO45793 | 2022-07-21 | 33.56 | 413.15 | 419.46 |
SO48750_40 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 233 | 514 | 6 | 2023-04-27 | 115.36 | 2.88 | 2023-04-15 | 4 | 29.08 | 1 | 115.36 | 40 | SO48750 | 2023-04-22 | 9.23 | 116.32 | 28.84 |
SO50214_16 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 415 | 258 | 4 | 2023-08-25 | 792.14 | 19.80 | 2023-08-13 | 4 | 146.55 | 1 | 792.14 | 16 | SO50214 | 2023-08-20 | 63.37 | 586.19 | 198.04 |
SO48771_38 | E98F-4302-92 | PO8410125811 | 98 | 288 | 368 | 538 | 10 | 2023-04-27 | 1466.01 | 36.65 | 2023-04-15 | 1 | 1518.79 | 1 | 1466.01 | 38 | SO48771 | 2023-04-22 | 117.28 | 1518.79 | 1466.01 |
SO51734_47 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 378 | 638 | 7 | 2023-11-25 | 2932.02 | 73.30 | 2023-11-13 | 2 | 1554.95 | 1 | 2932.02 | 47 | SO51734 | 2023-11-20 | 234.56 | 3109.90 | 1466.01 |
SO63201_18 | 8299-4DE4-AD | PO15689136917 | 100 | 281 | 380 | 328 | 4 | 2024-05-27 | 7330.05 | 183.25 | 2024-05-15 | 5 | 1554.95 | 1 | 7330.05 | 18 | SO63201 | 2024-05-22 | 586.40 | 7774.74 | 1466.01 |
SO58957_25 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 599 | 685 | 6 | 2024-03-26 | 1295.98 | 32.40 | 2024-03-14 | 4 | 294.58 | 1 | 1295.98 | 25 | SO58957 | 2024-03-21 | 103.68 | 1178.32 | 323.99 |
SO47725_24 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 459 | 81 | 5 | 2023-01-25 | 107.99 | 2.70 | 2023-01-13 | 2 | 37.12 | 1 | 107.99 | 24 | SO47725 | 2023-01-20 | 8.64 | 74.24 | 53.99 |
SO50310_26 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 464 | 309 | 4 | 2023-08-25 | 70.64 | 1.77 | 2023-08-13 | 5 | 9.71 | 1 | 70.64 | 26 | SO50310 | 2023-08-20 | 5.65 | 48.57 | 14.13 |
SO45315_4 | A83F-4F76-BA | PO2146148184 | 19 | 284 | 307 | 354 | 6 | 2022-05-28 | 2167.78 | 54.19 | 2022-05-16 | 3 | 623.84 | 1 | 2167.78 | 4 | SO45315 | 2022-05-23 | 173.42 | 1871.52 | 722.59 |
Generated 2024-11-13 02:17:19.363 UTC