[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE SKIP 371 < SKIP 1437 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO65278_4 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 503 | 308 | 1 | 2024-05-04 | 400.10 | 10.00 | 2024-04-22 | 2 | 199.85 | 1 | 400.10 | 4 | SO65278 | 2024-04-29 | 32.01 | 399.70 | 200.05 | |||
| SO49540_14 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 470 | 21 | 4 | 2023-05-04 | 182.35 | 4.56 | 2023-04-22 | 8 | 15.67 | 1 | 182.35 | 14 | SO49540 | 2023-04-29 | 14.59 | 125.37 | 22.79 | |||
| SO57087_10 | 423C-428C-BB | PO2871167176 | 100 | 283 | 568 | 522 | 2 | 2024-01-04 | 1781.64 | 44.54 | 2023-12-23 | 4 | 461.44 | 1 | 1781.64 | 10 | SO57087 | 2023-12-30 | 142.53 | 1845.78 | 445.41 | |||
| SO48373_24 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 224 | 61 | 4 | 2023-02-03 | 15.56 | 0.39 | 2023-01-22 | 3 | 5.23 | 1 | 15.56 | 24 | SO48373 | 2023-01-29 | 1.24 | 15.69 | 5.19 | |||
| SO48025_3 | AE8D-4A49-83 | PO10469118037 | 19 | 291 | 470 | 335 | 6 | 2023-01-04 | 68.38 | 1.71 | 2022-12-23 | 3 | 15.67 | 1 | 68.38 | 3 | SO48025 | 2022-12-30 | 5.47 | 47.01 | 22.79 | |||
| SO48770_5 | 28CC-48AC-B8 | PO11484112888 | 100 | 283 | 365 | 594 | 2 | 2023-03-06 | 4535.96 | 113.40 | 2023-02-22 | 7 | 598.44 | 1 | 4535.96 | 5 | SO48770 | 2023-03-01 | 362.88 | 4189.05 | 647.99 | |||
| SO59028_23 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 558 | 464 | 8 | 2024-02-03 | 242.99 | 6.07 | 2024-01-22 | 1 | 179.82 | 1 | 242.99 | 23 | SO59028 | 2024-01-29 | 19.44 | 179.82 | 242.99 | |||
| SO48016_6 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 422 | 97 | 4 | 2023-01-04 | 270.16 | 6.75 | 2022-12-23 | 4 | 49.98 | 1 | 270.16 | 6 | SO48016 | 2022-12-30 | 21.61 | 199.92 | 67.54 | |||
| SO49844_17 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 325 | 2 | 290 | 1 | 108.99 | 2023-06-04 | 5449.61 | 133.52 | 2023-05-23 | 12 | 486.71 | 1 | 5340.62 | 17 | SO49844 | 2023-05-30 | 427.25 | 5840.48 | 454.13 | 0.02 |
| SO71903_1 | 6CBA-47B4-A5 | PO3973194629 | 100 | 281 | 579 | 201 | 4 | 2024-08-04 | 728.91 | 18.22 | 2024-07-23 | 1 | 755.15 | 1 | 728.91 | 1 | SO71903 | 2024-07-30 | 58.31 | 755.15 | 728.91 | |||
| SO47438_7 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 365 | 21 | 4 | 2022-11-04 | 1295.99 | 32.40 | 2022-10-23 | 2 | 598.44 | 1 | 1295.99 | 7 | SO47438 | 2022-10-30 | 103.68 | 1196.87 | 647.99 | |||
| SO61248_5 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 517 | 496 | 6 | 2024-03-05 | 63.17 | 1.58 | 2024-02-22 | 2 | 23.37 | 1 | 63.17 | 5 | SO61248 | 2024-02-29 | 5.05 | 46.74 | 31.58 | |||
| SO51833_8 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 527 | 385 | 4 | 2023-10-04 | 316.86 | 7.92 | 2023-09-22 | 2 | 144.59 | 1 | 316.86 | 8 | SO51833 | 2023-09-29 | 25.35 | 289.19 | 158.43 | |||
| SO63122_3 | 49E9-48B0-81 | PO19459112433 | 19 | 291 | 217 | 334 | 6 | 2024-04-05 | 83.98 | 2.10 | 2024-03-24 | 4 | 13.09 | 1 | 83.98 | 3 | SO63122 | 2024-03-31 | 6.72 | 52.35 | 20.99 | |||
| SO57119_3 | 588B-4457-8A | PO3712174757 | 100 | 292 | 576 | 662 | 7 | 2024-01-04 | 1430.44 | 35.76 | 2023-12-23 | 1 | 1481.94 | 1 | 1430.44 | 3 | SO57119 | 2023-12-30 | 114.44 | 1481.94 | 1430.44 | |||
| SO63149_19 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 475 | 236 | 1 | 2024-04-05 | 125.98 | 3.15 | 2024-03-24 | 3 | 26.18 | 1 | 125.98 | 19 | SO63149 | 2024-03-31 | 10.08 | 78.53 | 41.99 | |||
| SO48008_3 | D4D5-432B-95 | PO12789161534 | 19 | 291 | 470 | 677 | 6 | 2023-01-04 | 205.15 | 5.13 | 2022-12-23 | 9 | 15.67 | 1 | 205.15 | 3 | SO48008 | 2022-12-30 | 16.41 | 141.04 | 22.79 | |||
| SO51853_3 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 357 | 476 | 5 | 2023-10-04 | 2783.99 | 69.60 | 2023-09-22 | 2 | 1265.62 | 1 | 2783.99 | 3 | SO51853 | 2023-09-29 | 222.72 | 2531.24 | 1391.99 | |||
| SO67260_12 | 6224-4229-B8 | PO522163557 | 100 | 285 | 543 | 676 | 5 | 2024-06-04 | 37.25 | 0.93 | 2024-05-23 | 1 | 27.57 | 1 | 37.25 | 12 | SO67260 | 2024-05-30 | 2.98 | 27.57 | 37.25 | |||
| SO65158_13 | 3613-4FA2-B8 | PO19285194632 | 98 | 288 | 484 | 448 | 10 | 2024-05-04 | 14.31 | 0.36 | 2024-04-22 | 3 | 2.97 | 1 | 14.31 | 13 | SO65158 | 2024-04-29 | 1.14 | 8.92 | 4.77 | |||
| SO58926_5 | B82A-4380-9C | PO15486118845 | 100 | 292 | 542 | 121 | 7 | 2024-02-03 | 24.29 | 0.61 | 2024-01-22 | 1 | 17.98 | 1 | 24.29 | 5 | SO58926 | 2024-01-29 | 1.94 | 17.98 | 24.29 | |||
| SO51102_3 | F2B1-4561-84 | PO13659193365 | 100 | 287 | 595 | 437 | 4 | 2023-09-03 | 677.99 | 16.95 | 2023-08-22 | 2 | 308.22 | 1 | 677.99 | 3 | SO51102 | 2023-08-29 | 54.24 | 616.44 | 338.99 | |||
| SO47714_11 | 884B-4F33-A1 | PO6235113773 | 100 | 281 | 333 | 431 | 3 | 2022-12-04 | 469.79 | 11.74 | 2022-11-22 | 1 | 486.71 | 1 | 469.79 | 11 | SO47714 | 2022-11-29 | 37.58 | 486.71 | 469.79 | |||
| SO47378_33 | E766-4274-A7 | PO15341116216 | 100 | 283 | 453 | 327 | 3 | 2022-11-04 | 215.96 | 5.40 | 2022-10-23 | 6 | 24.75 | 1 | 215.96 | 33 | SO47378 | 2022-10-30 | 17.28 | 148.48 | 35.99 | |||
| SO44556_8 | 4B50-4F3F-A9 | PO6438122669 | 100 | 283 | 229 | 309 | 4 | 2022-01-04 | 86.52 | 2.16 | 2021-12-23 | 3 | 31.72 | 1 | 86.52 | 8 | SO44556 | 2021-12-30 | 6.92 | 95.17 | 28.84 | |||
| SO51739_27 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 598 | 175 | 7 | 2023-10-04 | 971.98 | 24.30 | 2023-09-22 | 3 | 294.58 | 1 | 971.98 | 27 | SO51739 | 2023-09-29 | 77.76 | 883.74 | 323.99 | |||
| SO51832_13 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 525 | 352 | 6 | 2023-10-04 | 475.29 | 11.88 | 2023-09-22 | 3 | 144.59 | 1 | 475.29 | 13 | SO51832 | 2023-09-29 | 38.02 | 433.78 | 158.43 | |||
| SO49132_16 | 3562-4169-86 | PO3799126007 | 100 | 282 | 456 | 312 | 4 | 2023-04-06 | 134.98 | 3.37 | 2023-03-25 | 3 | 30.93 | 1 | 134.98 | 16 | SO49132 | 2023-04-01 | 10.80 | 92.80 | 44.99 | |||
| SO58972_29 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 600 | 10 | 6 | 2024-02-03 | 1619.97 | 40.50 | 2024-01-22 | 5 | 294.58 | 1 | 1619.97 | 29 | SO58972 | 2024-01-29 | 129.60 | 1472.90 | 323.99 | |||
| SO71836_4 | E41E-40C1-84 | PO841118259 | 100 | 286 | 543 | 254 | 1 | 2024-08-04 | 149.02 | 3.73 | 2024-07-23 | 4 | 27.57 | 1 | 149.02 | 4 | SO71836 | 2024-07-30 | 11.92 | 110.27 | 37.25 | |||
| SO47365_27 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 462 | 678 | 6 | 2022-11-04 | 14.13 | 0.35 | 2022-10-23 | 1 | 9.71 | 1 | 14.13 | 27 | SO47365 | 2022-10-30 | 1.13 | 9.71 | 14.13 | |||
| SO71873_1 | 0140-467E-A2 | PO12325121185 | 100 | 283 | 579 | 53 | 2 | 2024-08-04 | 728.91 | 18.22 | 2024-07-23 | 1 | 755.15 | 1 | 728.91 | 1 | SO71873 | 2024-07-30 | 58.31 | 755.15 | 728.91 | |||
| SO51120_42 | 6C2D-4670-B0 | PO10324111289 | 98 | 288 | 480 | 196 | 10 | 2023-09-03 | 1.37 | 0.03 | 2023-08-22 | 1 | 0.86 | 1 | 1.37 | 42 | SO51120 | 2023-08-29 | 0.11 | 0.86 | 1.37 | |||
| SO45535_15 | BDC5-404A-8E | PO15138174425 | 100 | 283 | 330 | 93 | 4 | 2022-05-04 | 838.92 | 20.97 | 2022-04-22 | 2 | 413.15 | 1 | 838.92 | 15 | SO45535 | 2022-04-29 | 67.11 | 826.29 | 419.46 | |||
| SO57121_33 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 472 | 79 | 3 | 2024-01-04 | 266.70 | 6.67 | 2023-12-23 | 7 | 23.75 | 1 | 266.70 | 33 | SO57121 | 2023-12-30 | 21.34 | 166.24 | 38.10 | |||
| SO44308_1 | 49A4-4845-B2 | PO2552158889 | 100 | 289 | 349 | 506 | 1 | 2021-12-04 | 4049.99 | 101.25 | 2021-11-22 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO44308 | 2021-11-29 | 324.00 | 3796.19 | 2024.99 | |||
| SO50232_8 | 3919-46D4-A1 | PO11020171211 | 19 | 284 | 327 | 336 | 6 | 2023-07-04 | 469.79 | 11.74 | 2023-06-22 | 1 | 486.71 | 1 | 469.79 | 8 | SO50232 | 2023-06-29 | 37.58 | 486.71 | 469.79 | |||
| SO57022_12 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 471 | 101 | 6 | 2024-01-04 | 38.10 | 0.95 | 2023-12-23 | 1 | 23.75 | 1 | 38.10 | 12 | SO57022 | 2023-12-30 | 3.05 | 23.75 | 38.10 | |||
| SO61224_9 | 3D8E-4C8E-B7 | PO13775159907 | 100 | 283 | 581 | 618 | 2 | 2024-03-05 | 2041.19 | 51.03 | 2024-02-22 | 2 | 1082.51 | 1 | 2041.19 | 9 | SO61224 | 2024-02-29 | 163.30 | 2165.02 | 1020.59 | |||
| SO45330_2 | 19B9-4EA4-8F | PO5800111159 | 100 | 285 | 218 | 63 | 5 | 2022-04-06 | 11.40 | 0.29 | 2022-03-25 | 2 | 3.40 | 1 | 11.40 | 2 | SO45330 | 2022-04-01 | 0.91 | 6.79 | 5.70 | |||
| SO69501_2 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 542 | 345 | 4 | 2024-07-04 | 48.59 | 1.21 | 2024-06-22 | 2 | 17.98 | 1 | 48.59 | 2 | SO69501 | 2024-06-29 | 3.89 | 35.96 | 24.29 | |||
| SO51712_36 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 578 | 361 | 1 | 2023-10-04 | 728.91 | 18.22 | 2023-09-22 | 1 | 755.15 | 1 | 728.91 | 36 | SO51712 | 2023-09-29 | 58.31 | 755.15 | 728.91 | |||
| SO50220_3 | 55C2-4DF0-BD | PO13311179597 | 100 | 292 | 422 | 301 | 7 | 2023-07-04 | 202.62 | 5.07 | 2023-06-22 | 3 | 49.98 | 1 | 202.62 | 3 | SO50220 | 2023-06-29 | 16.21 | 149.94 | 67.54 | |||
| SO58954_1 | F62A-4794-B4 | PO11426118490 | 100 | 285 | 606 | 386 | 5 | 2024-02-03 | 323.99 | 8.10 | 2024-01-22 | 1 | 343.65 | 1 | 323.99 | 1 | SO58954 | 2024-01-29 | 25.92 | 343.65 | 323.99 | |||
| SO47056_58 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 329 | 403 | 4 | 2022-10-04 | 1409.38 | 35.23 | 2022-09-22 | 3 | 486.71 | 1 | 1409.38 | 58 | SO47056 | 2022-09-29 | 112.75 | 1460.12 | 469.79 | |||
| SO46970_40 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 417 | 258 | 4 | 2022-10-04 | 1297.81 | 32.45 | 2022-09-22 | 4 | 300.12 | 1 | 1297.81 | 40 | SO46970 | 2022-09-29 | 103.82 | 1200.48 | 324.45 | |||
| SO63293_15 | 12C9-43D2-B4 | PO9918196921 | 100 | 285 | 523 | 260 | 5 | 2024-04-05 | 63.17 | 1.58 | 2024-03-24 | 2 | 23.37 | 1 | 63.17 | 15 | SO63293 | 2024-03-31 | 5.05 | 46.74 | 31.58 | |||
| SO51150_34 | 5831-4C4F-B1 | PO8004129956 | 6 | 296 | 496 | 231 | 9 | 2023-09-03 | 1204.69 | 30.12 | 2023-08-22 | 2 | 601.74 | 1 | 1204.69 | 34 | SO51150 | 2023-08-29 | 96.38 | 1203.49 | 602.35 | |||
| SO67276_22 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 544 | 355 | 7 | 2024-06-04 | 48.59 | 1.21 | 2024-05-23 | 1 | 35.96 | 1 | 48.59 | 22 | SO67276 | 2024-05-30 | 3.89 | 35.96 | 48.59 | |||
| SO50221_1 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 273 | 527 | 3 | 2023-07-04 | 809.33 | 20.23 | 2023-06-22 | 4 | 187.16 | 1 | 809.33 | 1 | SO50221 | 2023-06-29 | 64.75 | 748.63 | 202.33 | |||
| SO46107_11 | 75E6-43D6-92 | PO8874169089 | 100 | 282 | 345 | 348 | 3 | 2022-07-04 | 12239.96 | 306.00 | 2022-06-22 | 6 | 1912.15 | 1 | 12239.96 | 11 | SO46107 | 2022-06-29 | 979.20 | 11472.93 | 2039.99 | |||
| SO47041_21 | C543-4932-83 | PO5771188676 | 100 | 282 | 335 | 79 | 3 | 2022-10-04 | 1409.38 | 35.23 | 2022-09-22 | 3 | 486.71 | 1 | 1409.38 | 21 | SO47041 | 2022-09-29 | 112.75 | 1460.12 | 469.79 | |||
| SO48771_18 | E98F-4302-92 | PO8410125811 | 98 | 288 | 383 | 538 | 10 | 2023-03-06 | 1800.79 | 45.02 | 2023-02-22 | 3 | 605.65 | 1 | 1800.79 | 18 | SO48771 | 2023-03-01 | 144.06 | 1816.95 | 600.26 | |||
| SO53472_53 | 892C-445A-B6 | PO16501111174 | 98 | 288 | 234 | 142 | 10 | 2023-11-04 | 149.97 | 3.75 | 2023-10-23 | 5 | 38.49 | 1 | 149.97 | 53 | SO53472 | 2023-10-30 | 12.00 | 192.46 | 29.99 | |||
| SO46647_11 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 420 | 506 | 1 | 2022-09-03 | 141.62 | 3.54 | 2022-08-22 | 1 | 104.80 | 1 | 141.62 | 11 | SO46647 | 2022-08-29 | 11.33 | 104.80 | 141.62 | |||
| SO46651_2 | 68A1-47A8-9A | PO3016181627 | 100 | 283 | 420 | 183 | 3 | 2022-09-03 | 283.23 | 7.08 | 2022-08-22 | 2 | 104.80 | 1 | 283.23 | 2 | SO46651 | 2022-08-29 | 22.66 | 209.59 | 141.62 | |||
| SO63170_1 | 9588-481B-B3 | PO957184615 | 98 | 288 | 598 | 376 | 10 | 2024-04-05 | 971.98 | 24.30 | 2024-03-24 | 3 | 294.58 | 1 | 971.98 | 1 | SO63170 | 2024-03-31 | 77.76 | 883.74 | 323.99 | |||
| SO57123_2 | BB1E-492D-A7 | PO6670124664 | 100 | 283 | 378 | 432 | 2 | 2024-01-04 | 1466.01 | 36.65 | 2023-12-23 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO57123 | 2023-12-30 | 117.28 | 1554.95 | 1466.01 | |||
| SO44306_10 | 464C-43BA-9F | PO1189114917 | 100 | 285 | 272 | 423 | 5 | 2021-12-04 | 367.88 | 9.20 | 2021-11-22 | 2 | 181.49 | 1 | 367.88 | 10 | SO44306 | 2021-11-29 | 29.43 | 362.97 | 183.94 | |||
| SO44107_9 | 99CE-4ADA-B1 | PO261177749 | 100 | 283 | 315 | 647 | 4 | 2021-11-04 | 2624.38 | 65.61 | 2021-10-23 | 3 | 884.71 | 1 | 2624.38 | 9 | SO44107 | 2021-10-30 | 209.95 | 2654.12 | 874.79 | |||
| SO44801_8 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 316 | 170 | 5 | 2022-02-03 | 4373.97 | 109.35 | 2022-01-22 | 5 | 884.71 | 1 | 4373.97 | 8 | SO44801 | 2022-01-29 | 349.92 | 4423.54 | 874.79 | |||
| SO50322_27 | 4BC2-4C6D-83 | PO8845166508 | 100 | 282 | 464 | 546 | 3 | 2023-07-04 | 28.26 | 0.71 | 2023-06-22 | 2 | 9.71 | 1 | 28.26 | 27 | SO50322 | 2023-06-29 | 2.26 | 19.43 | 14.13 |
Generated 2024-09-21 14:45:17.971 UTC