[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 440 > < TAKE 56 >
56 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO53576_6 | 7638-4151-96 | PO7395119515 | 100 | 286 | 543 | 542 | 1 | 2023-12-24 | 149.02 | 3.73 | 2023-12-12 | 4 | 27.57 | 1 | 149.02 | 6 | SO53576 | 2023-12-19 | 11.92 | 110.27 | 37.25 | |||
| SO50703_36 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 417 | 90 | 5 | 2023-09-23 | 648.91 | 16.22 | 2023-09-11 | 2 | 300.12 | 1 | 648.91 | 36 | SO50703 | 2023-09-18 | 51.91 | 600.24 | 324.45 | |||
| SO51761_22 | 056F-4C15-93 | PO580111702 | 36 | 295 | 497 | 230 | 8 | 2023-11-23 | 1204.69 | 30.12 | 2023-11-11 | 2 | 601.74 | 1 | 1204.69 | 22 | SO51761 | 2023-11-18 | 96.38 | 1203.49 | 602.35 | |||
| SO47033_7 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 381 | 343 | 1 | 2022-11-23 | 1800.79 | 45.02 | 2022-11-11 | 3 | 605.65 | 1 | 1800.79 | 7 | SO47033 | 2022-11-18 | 144.06 | 1816.95 | 600.26 | |||
| SO67321_3 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 576 | 505 | 1 | 2024-07-24 | 12873.98 | 321.85 | 2024-07-12 | 9 | 1481.94 | 1 | 12873.98 | 3 | SO67321 | 2024-07-19 | 1029.92 | 13337.44 | 1430.44 | |||
| SO61266_6 | CE88-43C2-A3 | PO7105127855 | 100 | 293 | 390 | 668 | 1 | 2024-04-24 | 672.29 | 16.81 | 2024-04-12 | 1 | 713.08 | 1 | 672.29 | 6 | SO61266 | 2024-04-19 | 53.78 | 713.08 | 672.29 | |||
| SO47057_16 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 410 | 401 | 1 | 2022-11-23 | 109.34 | 2.73 | 2022-11-11 | 3 | 26.97 | 1 | 109.34 | 16 | SO47057 | 2022-11-18 | 8.75 | 80.91 | 36.45 | |||
| SO50670_1 | FE24-428B-88 | PO17226158606 | 100 | 281 | 335 | 561 | 4 | 2023-09-23 | 469.79 | 11.74 | 2023-09-11 | 1 | 486.71 | 1 | 469.79 | 1 | SO50670 | 2023-09-18 | 37.58 | 486.71 | 469.79 | |||
| SO65234_4 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 560 | 182 | 1 | 2024-06-23 | 1457.82 | 36.45 | 2024-06-11 | 2 | 755.15 | 1 | 1457.82 | 4 | SO65234 | 2024-06-18 | 116.63 | 1510.30 | 728.91 | |||
| SO67343_27 | 4919-449D-87 | PO8410198369 | 98 | 288 | 606 | 538 | 10 | 2024-07-24 | 971.98 | 24.30 | 2024-07-12 | 3 | 343.65 | 1 | 971.98 | 27 | SO67343 | 2024-07-19 | 77.76 | 1030.95 | 323.99 | |||
| SO57067_1 | 08F2-42FC-BE | PO11368183380 | 36 | 295 | 483 | 687 | 8 | 2024-02-23 | 576.00 | 14.40 | 2024-02-11 | 8 | 44.88 | 1 | 576.00 | 1 | SO57067 | 2024-02-18 | 46.08 | 359.04 | 72.00 | |||
| SO71936_21 | 95F1-4758-A0 | PO8671170385 | 98 | 288 | 353 | 502 | 10 | 2024-09-23 | 5567.98 | 139.20 | 2024-09-11 | 4 | 1265.62 | 1 | 5567.98 | 21 | SO71936 | 2024-09-18 | 445.44 | 5062.48 | 1391.99 | |||
| SO49101_8 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 216 | 487 | 1 | 2023-05-26 | 80.75 | 2.02 | 2023-05-14 | 4 | 13.88 | 1 | 80.75 | 8 | SO49101 | 2023-05-21 | 6.46 | 55.51 | 20.19 | |||
| SO44123_1 | 9F0F-4FBC-9A | PO6322187277 | 100 | 281 | 316 | 503 | 2 | 2021-12-24 | 874.79 | 21.87 | 2021-12-12 | 1 | 884.71 | 1 | 874.79 | 1 | SO44123 | 2021-12-19 | 69.98 | 884.71 | 874.79 | |||
| SO46043_9 | 1230-4EA4-83 | PO16791123625 | 100 | 281 | 270 | 36 | 2 | 2022-08-23 | 183.94 | 4.60 | 2022-08-11 | 1 | 181.49 | 1 | 183.94 | 9 | SO46043 | 2022-08-18 | 14.72 | 181.49 | 183.94 | |||
| SO67270_6 | 685A-440D-8C | PO14732111382 | 19 | 291 | 374 | 514 | 6 | 2024-07-24 | 7330.05 | 183.25 | 2024-07-12 | 5 | 1554.95 | 1 | 7330.05 | 6 | SO67270 | 2024-07-19 | 586.40 | 7774.74 | 1466.01 | |||
| SO51720_34 | E39F-4680-AC | PO15370128892 | 100 | 281 | 511 | 381 | 3 | 2023-11-23 | 873.82 | 21.85 | 2023-11-11 | 4 | 199.38 | 1 | 873.82 | 34 | SO51720 | 2023-11-18 | 69.91 | 797.50 | 218.45 | |||
| SO44749_13 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 332 | 155 | 6 | 2022-03-25 | 1258.38 | 31.46 | 2022-03-13 | 3 | 413.15 | 1 | 1258.38 | 13 | SO44749 | 2022-03-20 | 100.67 | 1239.44 | 419.46 | |||
| SO57111_1 | 8478-4B8E-95 | PO14181151887 | 100 | 272 | 475 | 307 | 1 | 2024-02-23 | 209.97 | 5.25 | 2024-02-11 | 5 | 26.18 | 1 | 209.97 | 1 | SO57111 | 2024-02-18 | 16.80 | 130.88 | 41.99 | |||
| SO51106_22 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 499 | 331 | 4 | 2023-10-23 | 1204.69 | 30.12 | 2023-10-11 | 2 | 601.74 | 1 | 1204.69 | 22 | SO51106 | 2023-10-18 | 96.38 | 1203.49 | 602.35 | |||
| SO46942_7 | B18D-4253-81 | PO18647164826 | 100 | 282 | 456 | 583 | 4 | 2022-11-23 | 134.98 | 3.37 | 2022-11-11 | 3 | 30.93 | 1 | 134.98 | 7 | SO46942 | 2022-11-18 | 10.80 | 92.80 | 44.99 | |||
| SO49133_6 | 50D5-4F65-92 | PO9512136037 | 100 | 285 | 327 | 135 | 5 | 2023-05-26 | 939.59 | 23.49 | 2023-05-14 | 2 | 486.71 | 1 | 939.59 | 6 | SO49133 | 2023-05-21 | 75.17 | 973.41 | 469.79 | |||
| SO67271_7 | E734-4CEC-A8 | PO13775181029 | 100 | 283 | 482 | 2 | 618 | 2 | 1.15 | 2024-07-24 | 57.36 | 1.41 | 2024-07-12 | 11 | 3.36 | 1 | 56.21 | 7 | SO67271 | 2024-07-19 | 4.50 | 36.99 | 5.21 | 0.02 |
| SO59023_5 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 542 | 61 | 4 | 2024-03-24 | 97.18 | 2.43 | 2024-03-12 | 4 | 17.98 | 1 | 97.18 | 5 | SO59023 | 2024-03-19 | 7.77 | 71.91 | 24.29 | |||
| SO46614_44 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 415 | 299 | 6 | 2022-10-23 | 396.07 | 9.90 | 2022-10-11 | 2 | 146.55 | 1 | 396.07 | 44 | SO46614 | 2022-10-18 | 31.69 | 293.09 | 198.04 | |||
| SO43692_20 | BFA9-470E-B4 | PO7859187017 | 100 | 287 | 314 | 221 | 4 | 2021-10-23 | 4293.92 | 107.35 | 2021-10-11 | 2 | 2171.29 | 1 | 4293.92 | 20 | SO43692 | 2021-10-18 | 343.51 | 4342.59 | 2146.96 | |||
| SO48746_13 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 428 | 506 | 1 | 2023-04-25 | 418.51 | 10.46 | 2023-04-13 | 2 | 185.82 | 1 | 418.51 | 13 | SO48746 | 2023-04-20 | 33.48 | 371.64 | 209.26 | |||
| SO51734_7 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 580 | 638 | 7 | 2023-11-23 | 9185.35 | 229.63 | 2023-11-11 | 9 | 1082.51 | 1 | 9185.35 | 7 | SO51734 | 2023-11-18 | 734.83 | 9742.59 | 1020.59 | |||
| SO57151_3 | 017C-41CB-BB | PO5162182690 | 100 | 289 | 378 | 669 | 1 | 2024-02-23 | 1466.01 | 36.65 | 2024-02-11 | 1 | 1554.95 | 1 | 1466.01 | 3 | SO57151 | 2024-02-18 | 117.28 | 1554.95 | 1466.01 | |||
| SO57126_11 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 481 | 45 | 5 | 2024-02-23 | 16.18 | 0.40 | 2024-02-11 | 3 | 3.36 | 1 | 16.18 | 11 | SO57126 | 2024-02-18 | 1.29 | 10.09 | 5.39 | |||
| SO44085_5 | D35C-4208-A3 | PO17545192039 | 19 | 288 | 223 | 155 | 6 | 2021-12-24 | 10.37 | 0.26 | 2021-12-12 | 2 | 5.71 | 1 | 10.37 | 5 | SO44085 | 2021-12-19 | 0.83 | 11.41 | 5.19 | |||
| SO57082_6 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 237 | 426 | 6 | 2024-02-23 | 29.99 | 0.75 | 2024-02-11 | 1 | 38.49 | 1 | 29.99 | 6 | SO57082 | 2024-02-18 | 2.40 | 38.49 | 29.99 | |||
| SO57101_3 | E5FB-42E2-A9 | PO18386193019 | 100 | 283 | 434 | 558 | 2 | 2024-02-23 | 1070.69 | 26.77 | 2024-02-11 | 3 | 360.94 | 1 | 1070.69 | 3 | SO57101 | 2024-02-18 | 85.66 | 1082.83 | 356.90 | |||
| SO67267_2 | 21CB-4720-99 | PO15399118335 | 100 | 281 | 490 | 220 | 3 | 2024-07-24 | 32.39 | 0.81 | 2024-07-12 | 1 | 41.57 | 1 | 32.39 | 2 | SO67267 | 2024-07-19 | 2.59 | 41.57 | 32.39 | |||
| SO45077_4 | 4002-46AC-B7 | PO10179199539 | 100 | 285 | 344 | 27 | 5 | 2022-04-25 | 4079.99 | 102.00 | 2022-04-13 | 2 | 1912.15 | 1 | 4079.99 | 4 | SO45077 | 2022-04-20 | 326.40 | 3824.31 | 2039.99 | |||
| SO69495_1 | D387-4497-83 | PO12122175008 | 100 | 281 | 418 | 22 | 3 | 2024-08-23 | 713.80 | 17.84 | 2024-08-11 | 2 | 360.94 | 1 | 713.80 | 1 | SO69495 | 2024-08-18 | 57.10 | 721.89 | 356.90 | |||
| SO50292_1 | E329-4164-85 | PO3654177485 | 100 | 281 | 410 | 435 | 4 | 2023-08-23 | 36.45 | 0.91 | 2023-08-11 | 1 | 26.97 | 1 | 36.45 | 1 | SO50292 | 2023-08-18 | 2.92 | 26.97 | 36.45 | |||
| SO50720_3 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 421 | 490 | 4 | 2023-09-23 | 196.33 | 4.91 | 2023-09-11 | 1 | 145.28 | 1 | 196.33 | 3 | SO50720 | 2023-09-18 | 15.71 | 145.28 | 196.33 | |||
| SO67348_8 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 309 | 494 | 5 | 2024-07-24 | 1637.40 | 40.94 | 2024-07-12 | 2 | 747.20 | 1 | 1637.40 | 8 | SO67348 | 2024-07-19 | 130.99 | 1494.40 | 818.70 | |||
| SO71782_14 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 555 | 582 | 4 | 2024-09-23 | 63.90 | 1.60 | 2024-09-11 | 1 | 47.29 | 1 | 63.90 | 14 | SO71782 | 2024-09-18 | 5.11 | 47.29 | 63.90 | |||
| SO67292_22 | 09EF-4688-BB | PO551144976 | 100 | 281 | 372 | 4 | 4 | 2024-07-24 | 2932.02 | 73.30 | 2024-07-12 | 2 | 1554.95 | 1 | 2932.02 | 22 | SO67292 | 2024-07-19 | 234.56 | 3109.90 | 1466.01 | |||
| SO63249_14 | ABDD-4795-8F | PO4727178983 | 100 | 293 | 545 | 343 | 1 | 2024-05-25 | 48.59 | 1.21 | 2024-05-13 | 2 | 17.98 | 1 | 48.59 | 14 | SO63249 | 2024-05-20 | 3.89 | 35.96 | 24.29 | |||
| SO55323_27 | 7398-4A3C-BE | PO8410135313 | 98 | 288 | 545 | 538 | 10 | 2024-01-23 | 24.29 | 0.61 | 2024-01-11 | 1 | 17.98 | 1 | 24.29 | 27 | SO55323 | 2024-01-18 | 1.94 | 17.98 | 24.29 | |||
| SO45062_4 | 017E-486E-BC | PO1189166374 | 100 | 285 | 332 | 423 | 5 | 2022-04-25 | 838.92 | 20.97 | 2022-04-13 | 2 | 413.15 | 1 | 838.92 | 4 | SO45062 | 2022-04-20 | 67.11 | 826.29 | 419.46 | |||
| SO53568_6 | 4523-4AB4-99 | PO9222138547 | 100 | 285 | 545 | 171 | 5 | 2023-12-24 | 72.88 | 1.82 | 2023-12-12 | 3 | 17.98 | 1 | 72.88 | 6 | SO53568 | 2023-12-19 | 5.83 | 53.93 | 24.29 | |||
| SO51714_29 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 482 | 328 | 4 | 2023-11-23 | 53.94 | 1.35 | 2023-11-11 | 10 | 3.36 | 1 | 53.94 | 29 | SO51714 | 2023-11-18 | 4.32 | 33.62 | 5.39 | |||
| SO57119_5 | 588B-4457-8A | PO3712174757 | 100 | 292 | 490 | 662 | 7 | 2024-02-23 | 64.79 | 1.62 | 2024-02-11 | 2 | 41.57 | 1 | 64.79 | 5 | SO57119 | 2024-02-18 | 5.18 | 83.14 | 32.39 | |||
| SO59064_31 | AE68-4CAD-B8 | PO8671111477 | 98 | 290 | 531 | 502 | 10 | 2024-03-24 | 599.50 | 14.99 | 2024-03-12 | 4 | 136.79 | 1 | 599.50 | 31 | SO59064 | 2024-03-19 | 47.96 | 547.14 | 149.87 | |||
| SO47438_13 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 397 | 21 | 4 | 2022-12-24 | 48.59 | 1.21 | 2022-12-12 | 2 | 17.98 | 1 | 48.59 | 13 | SO47438 | 2022-12-19 | 3.89 | 35.96 | 24.29 | |||
| SO67297_12 | 58AA-422C-BB | PO2552176926 | 100 | 286 | 474 | 3 | 506 | 1 | 34.65 | 2024-07-24 | 692.90 | 16.46 | 2024-07-12 | 18 | 26.18 | 1 | 658.26 | 12 | SO67297 | 2024-07-19 | 52.66 | 471.17 | 38.49 | 0.05 |
| SO47677_45 | 2C43-407F-B3 | PO13688179339 | 100 | 282 | 233 | 475 | 4 | 2023-01-23 | 230.72 | 5.77 | 2023-01-11 | 8 | 29.08 | 1 | 230.72 | 45 | SO47677 | 2023-01-18 | 18.46 | 232.65 | 28.84 | |||
| SO43869_5 | 96FA-4DF1-81 | PO14500145975 | 100 | 282 | 344 | 650 | 1 | 2021-11-23 | 10199.97 | 255.00 | 2021-11-11 | 5 | 1912.15 | 1 | 10199.97 | 5 | SO43869 | 2021-11-18 | 816.00 | 9560.77 | 2039.99 | |||
| SO47454_35 | E249-41EE-95 | PO9570119946 | 100 | 285 | 464 | 585 | 5 | 2022-12-24 | 14.13 | 0.35 | 2022-12-12 | 1 | 9.71 | 1 | 14.13 | 35 | SO47454 | 2022-12-19 | 1.13 | 9.71 | 14.13 | |||
| SO47668_20 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 458 | 299 | 6 | 2023-01-23 | 359.95 | 9.00 | 2023-01-11 | 8 | 30.93 | 1 | 359.95 | 20 | SO47668 | 2023-01-18 | 28.80 | 247.47 | 44.99 | |||
| SO50688_17 | C55C-41B0-92 | PO10701178438 | 100 | 282 | 358 | 133 | 4 | 2023-09-23 | 3688.38 | 92.21 | 2023-09-11 | 3 | 1105.81 | 1 | 3688.38 | 17 | SO50688 | 2023-09-18 | 295.07 | 3317.43 | 1229.46 | |||
| SO47443_8 | DDB8-4FAB-92 | PO7192110823 | 100 | 289 | 213 | 20 | 1 | 2022-12-24 | 20.19 | 0.50 | 2022-12-12 | 1 | 13.88 | 1 | 20.19 | 8 | SO47443 | 2022-12-19 | 1.61 | 13.88 | 20.19 |
Generated 2024-11-10 15:57:39.700 UTC