[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 3500 SHUFFLE < SKIP 625 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46660_44 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 337 | 166 | 4 | 2022-10-25 | 1409.38 | 35.23 | 2022-10-13 | 3 | 486.71 | 1 | 1409.38 | 44 | SO46660 | 2022-10-20 | 112.75 | 1460.12 | 469.79 | |||
| SO48775_25 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 329 | 203 | 4 | 2023-04-27 | 1879.18 | 46.98 | 2023-04-15 | 4 | 486.71 | 1 | 1879.18 | 25 | SO48775 | 2023-04-22 | 150.33 | 1946.83 | 469.79 | |||
| SO48788_19 | DD66-4EC8-BF | PO6699145127 | 100 | 283 | 422 | 234 | 2 | 2023-04-27 | 202.62 | 5.07 | 2023-04-15 | 3 | 49.98 | 1 | 202.62 | 19 | SO48788 | 2023-04-22 | 16.21 | 149.94 | 67.54 | |||
| SO50675_35 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 458 | 327 | 3 | 2023-09-25 | 89.99 | 2.25 | 2023-09-13 | 2 | 30.93 | 1 | 89.99 | 35 | SO50675 | 2023-09-20 | 7.20 | 61.87 | 44.99 | |||
| SO46616_28 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 273 | 514 | 6 | 2022-10-25 | 202.33 | 5.06 | 2022-10-13 | 1 | 187.16 | 1 | 202.33 | 28 | SO46616 | 2022-10-20 | 16.19 | 187.16 | 202.33 | |||
| SO46992_43 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 321 | 97 | 4 | 2022-11-25 | 1409.38 | 35.23 | 2022-11-13 | 3 | 486.71 | 1 | 1409.38 | 43 | SO46992 | 2022-11-20 | 112.75 | 1460.12 | 469.79 | |||
| SO45564_3 | DD65-42A2-80 | PO5220129554 | 100 | 282 | 348 | 169 | 1 | 2022-06-25 | 12149.96 | 303.75 | 2022-06-13 | 6 | 1898.09 | 1 | 12149.96 | 3 | SO45564 | 2022-06-20 | 972.00 | 11388.57 | 2024.99 | |||
| SO69418_9 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 542 | 381 | 3 | 2024-08-25 | 24.29 | 0.61 | 2024-08-13 | 1 | 17.98 | 1 | 24.29 | 9 | SO69418 | 2024-08-20 | 1.94 | 17.98 | 24.29 | |||
| SO47394_36 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 428 | 197 | 3 | 2022-12-26 | 418.51 | 10.46 | 2022-12-14 | 2 | 185.82 | 1 | 418.51 | 36 | SO47394 | 2022-12-21 | 33.48 | 371.64 | 209.26 | |||
| SO44513_5 | A881-41E7-AD | PO14471116260 | 100 | 286 | 349 | 145 | 1 | 2022-02-25 | 6074.98 | 151.87 | 2022-02-13 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO44513 | 2022-02-20 | 486.00 | 5694.28 | 2024.99 | |||
| SO69405_1 | E3D1-4246-9F | PO16965195306 | 100 | 285 | 605 | 441 | 5 | 2024-08-25 | 647.99 | 16.20 | 2024-08-13 | 2 | 343.65 | 1 | 647.99 | 1 | SO69405 | 2024-08-20 | 51.84 | 687.30 | 323.99 | |||
| SO50753_22 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 409 | 608 | 4 | 2023-09-25 | 1046.28 | 26.16 | 2023-09-13 | 5 | 185.82 | 1 | 1046.28 | 22 | SO50753 | 2023-09-20 | 83.70 | 929.10 | 209.26 | |||
| SO63125_1 | F7DD-4FA0-B5 | PO18792150789 | 100 | 283 | 309 | 378 | 2 | 2024-05-27 | 1637.40 | 40.94 | 2024-05-15 | 2 | 747.20 | 1 | 1637.40 | 1 | SO63125 | 2024-05-22 | 130.99 | 1494.40 | 818.70 | |||
| SO50265_16 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 337 | 479 | 6 | 2023-08-25 | 939.59 | 23.49 | 2023-08-13 | 2 | 486.71 | 1 | 939.59 | 16 | SO50265 | 2023-08-20 | 75.17 | 973.41 | 469.79 | |||
| SO43913_1 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 349 | 40 | 4 | 2021-11-25 | 8099.98 | 202.50 | 2021-11-13 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO43913 | 2021-11-20 | 648.00 | 7592.38 | 2024.99 | |||
| SO55252_20 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 597 | 355 | 7 | 2024-01-25 | 323.99 | 8.10 | 2024-01-13 | 1 | 294.58 | 1 | 323.99 | 20 | SO55252 | 2024-01-20 | 25.92 | 294.58 | 323.99 | |||
| SO49149_10 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 365 | 566 | 5 | 2023-05-28 | 1295.99 | 32.40 | 2023-05-16 | 2 | 598.44 | 1 | 1295.99 | 10 | SO49149 | 2023-05-23 | 103.68 | 1196.87 | 647.99 | |||
| SO53562_21 | 9FC2-4D08-A7 | PO8468156175 | 98 | 288 | 584 | 16 | 10 | 2023-12-26 | 1619.97 | 40.50 | 2023-12-14 | 5 | 343.65 | 1 | 1619.97 | 21 | SO53562 | 2023-12-21 | 129.60 | 1718.25 | 323.99 | |||
| SO53570_1 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 471 | 4 | 54 | 2 | 79.38 | 2023-12-26 | 793.75 | 17.86 | 2023-12-14 | 25 | 23.75 | 1 | 714.38 | 1 | SO53570 | 2023-12-21 | 57.15 | 593.73 | 31.75 | 0.10 |
| SO61204_23 | E810-4164-82 | PO15312134209 | 19 | 291 | 222 | 299 | 6 | 2024-04-26 | 146.96 | 3.67 | 2024-04-14 | 7 | 13.09 | 1 | 146.96 | 23 | SO61204 | 2024-04-21 | 11.76 | 91.60 | 20.99 | |||
| SO48750_22 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 369 | 514 | 6 | 2023-04-27 | 2932.02 | 73.30 | 2023-04-15 | 2 | 1518.79 | 1 | 2932.02 | 22 | SO48750 | 2023-04-22 | 234.56 | 3037.57 | 1466.01 | |||
| SO71822_19 | AEDC-410A-9B | PO11774139099 | 6 | 296 | 576 | 682 | 9 | 2024-09-25 | 1430.44 | 35.76 | 2024-09-13 | 1 | 1481.94 | 1 | 1430.44 | 19 | SO71822 | 2024-09-20 | 114.44 | 1481.94 | 1430.44 | |||
| SO47434_17 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 360 | 61 | 4 | 2022-12-26 | 8606.21 | 215.16 | 2022-12-14 | 7 | 1105.81 | 1 | 8606.21 | 17 | SO47434 | 2022-12-21 | 688.50 | 7740.67 | 1229.46 | |||
| SO48363_30 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 339 | 130 | 4 | 2023-03-27 | 2348.97 | 58.72 | 2023-03-15 | 5 | 486.71 | 1 | 2348.97 | 30 | SO48363 | 2023-03-22 | 187.92 | 2433.53 | 469.79 | |||
| SO44774_8 | 6F0A-4629-A5 | PO1885185716 | 19 | 284 | 220 | 588 | 6 | 2022-03-27 | 20.19 | 0.50 | 2022-03-15 | 1 | 12.03 | 1 | 20.19 | 8 | SO44774 | 2022-03-22 | 1.61 | 12.03 | 20.19 | |||
| SO48373_7 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 427 | 61 | 4 | 2023-03-27 | 209.26 | 5.23 | 2023-03-15 | 1 | 185.82 | 1 | 209.26 | 7 | SO48373 | 2023-03-22 | 16.74 | 185.82 | 209.26 | |||
| SO71836_29 | E41E-40C1-84 | PO841118259 | 100 | 286 | 400 | 254 | 1 | 2024-09-25 | 222.91 | 5.57 | 2024-09-13 | 6 | 27.49 | 1 | 222.91 | 29 | SO71836 | 2024-09-20 | 17.83 | 164.96 | 37.15 | |||
| SO59010_24 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 532 | 109 | 1 | 2024-03-26 | 449.62 | 11.24 | 2024-03-14 | 3 | 136.79 | 1 | 449.62 | 24 | SO59010 | 2024-03-21 | 35.97 | 410.36 | 149.87 | |||
| SO47061_15 | 58AC-406C-9C | PO8584111730 | 98 | 288 | 213 | 592 | 10 | 2022-11-25 | 80.75 | 2.02 | 2022-11-13 | 4 | 13.88 | 1 | 80.75 | 15 | SO47061 | 2022-11-20 | 6.46 | 55.51 | 20.19 | |||
| SO48292_16 | 7546-4477-B2 | PO19633112676 | 100 | 287 | 401 | 149 | 3 | 2023-03-27 | 65.60 | 1.64 | 2023-03-15 | 1 | 48.55 | 1 | 65.60 | 16 | SO48292 | 2023-03-22 | 5.25 | 48.55 | 65.60 | |||
| SO47424_6 | 9DF2-4A59-AE | PO4089167750 | 100 | 285 | 470 | 368 | 5 | 2022-12-26 | 91.18 | 2.28 | 2022-12-14 | 4 | 15.67 | 1 | 91.18 | 6 | SO47424 | 2022-12-21 | 7.29 | 62.68 | 22.79 | |||
| SO69406_29 | E101-486C-A5 | PO16675181672 | 100 | 293 | 477 | 361 | 1 | 2024-08-25 | 23.95 | 0.60 | 2024-08-13 | 8 | 1.87 | 1 | 23.95 | 29 | SO69406 | 2024-08-20 | 1.92 | 14.93 | 2.99 | |||
| SO44124_11 | 2927-45C2-BE | PO6786110112 | 100 | 283 | 322 | 3 | 4 | 2021-12-26 | 2097.29 | 52.43 | 2021-12-14 | 5 | 413.15 | 1 | 2097.29 | 11 | SO44124 | 2021-12-21 | 167.78 | 2065.73 | 419.46 | |||
| SO48017_35 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 393 | 233 | 2 | 2023-02-25 | 275.39 | 6.88 | 2023-02-13 | 2 | 101.89 | 1 | 275.39 | 35 | SO48017 | 2023-02-20 | 22.03 | 203.79 | 137.69 | |||
| SO69470_1 | 44E4-4264-A5 | PO19024173467 | 98 | 288 | 580 | 124 | 10 | 2024-08-25 | 3061.78 | 76.54 | 2024-08-13 | 3 | 1082.51 | 1 | 3061.78 | 1 | SO69470 | 2024-08-20 | 244.94 | 3247.53 | 1020.59 | |||
| SO51834_20 | 8058-4316-AF | PO7975192665 | 6 | 296 | 234 | 141 | 9 | 2023-11-25 | 59.99 | 1.50 | 2023-11-13 | 2 | 38.49 | 1 | 59.99 | 20 | SO51834 | 2023-11-20 | 4.80 | 76.98 | 29.99 | |||
| SO46953_21 | C650-4C32-BE | PO17603154442 | 19 | 284 | 445 | 12 | 6 | 2022-11-25 | 143.98 | 3.60 | 2022-11-13 | 4 | 24.75 | 1 | 143.98 | 21 | SO46953 | 2022-11-20 | 11.52 | 98.98 | 35.99 | |||
| SO49891_29 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 415 | 538 | 10 | 2023-07-26 | 396.07 | 9.90 | 2023-07-14 | 2 | 146.55 | 1 | 396.07 | 29 | SO49891 | 2023-07-21 | 31.69 | 293.09 | 198.04 | |||
| SO48375_14 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 464 | 75 | 4 | 2023-03-27 | 28.26 | 0.71 | 2023-03-15 | 2 | 9.71 | 1 | 28.26 | 14 | SO48375 | 2023-03-22 | 2.26 | 19.43 | 14.13 | |||
| SO57137_52 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 513 | 309 | 4 | 2024-02-25 | 436.91 | 10.92 | 2024-02-13 | 2 | 199.38 | 1 | 436.91 | 52 | SO57137 | 2024-02-20 | 34.95 | 398.75 | 218.45 | |||
| SO50745_12 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 216 | 61 | 4 | 2023-09-25 | 80.75 | 2.02 | 2023-09-13 | 4 | 13.88 | 1 | 80.75 | 12 | SO50745 | 2023-09-20 | 6.46 | 55.51 | 20.19 | |||
| SO47400_54 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 447 | 2 | 133 | 4 | 4.06 | 2022-12-26 | 203.00 | 4.97 | 2022-12-14 | 14 | 10.31 | 1 | 198.94 | 54 | SO47400 | 2022-12-21 | 15.92 | 144.38 | 14.50 | 0.02 |
| SO59074_22 | 1711-471C-82 | PO9483120932 | 100 | 283 | 463 | 54 | 2 | 2024-03-26 | 73.47 | 1.84 | 2024-03-14 | 5 | 9.16 | 1 | 73.47 | 22 | SO59074 | 2024-03-21 | 5.88 | 45.80 | 14.69 | |||
| SO51780_2 | 30C4-4B8F-AA | PO18560115626 | 100 | 285 | 487 | 531 | 5 | 2023-11-25 | 98.98 | 2.47 | 2023-11-13 | 3 | 20.57 | 1 | 98.98 | 2 | SO51780 | 2023-11-20 | 7.92 | 61.70 | 32.99 | |||
| SO50668_31 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 457 | 678 | 6 | 2023-09-25 | 44.99 | 1.12 | 2023-09-13 | 1 | 30.93 | 1 | 44.99 | 31 | SO50668 | 2023-09-20 | 3.60 | 30.93 | 44.99 | |||
| SO50195_15 | F28B-4548-99 | PO19198175870 | 19 | 291 | 427 | 653 | 6 | 2023-08-25 | 209.26 | 5.23 | 2023-08-13 | 1 | 185.82 | 1 | 209.26 | 15 | SO50195 | 2023-08-20 | 16.74 | 185.82 | 209.26 | |||
| SO50314_22 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 337 | 433 | 1 | 2023-08-25 | 1409.38 | 35.23 | 2023-08-13 | 3 | 486.71 | 1 | 1409.38 | 22 | SO50314 | 2023-08-20 | 112.75 | 1460.12 | 469.79 | |||
| SO51762_20 | E7DC-4AC1-AD | PO10121132749 | 100 | 283 | 386 | 684 | 2 | 2023-11-25 | 672.29 | 16.81 | 2023-11-13 | 1 | 713.08 | 1 | 672.29 | 20 | SO51762 | 2023-11-20 | 53.78 | 713.08 | 672.29 | |||
| SO50696_5 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 329 | 579 | 3 | 2023-09-25 | 2348.97 | 58.72 | 2023-09-13 | 5 | 486.71 | 1 | 2348.97 | 5 | SO50696 | 2023-09-20 | 187.92 | 2433.53 | 469.79 | |||
| SO53576_18 | 7638-4151-96 | PO7395119515 | 100 | 286 | 400 | 542 | 1 | 2023-12-26 | 74.30 | 1.86 | 2023-12-14 | 2 | 27.49 | 1 | 74.30 | 18 | SO53576 | 2023-12-21 | 5.94 | 54.99 | 37.15 | |||
| SO61239_32 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 524 | 414 | 2 | 2024-04-26 | 316.86 | 7.92 | 2024-04-14 | 2 | 144.59 | 1 | 316.86 | 32 | SO61239 | 2024-04-21 | 25.35 | 289.19 | 158.43 | |||
| SO51702_3 | 48F0-4F3E-AE | PO17632172635 | 19 | 291 | 480 | 28 | 6 | 2023-11-25 | 4.12 | 0.10 | 2023-11-13 | 3 | 0.86 | 1 | 4.12 | 3 | SO51702 | 2023-11-20 | 0.33 | 2.57 | 1.37 | |||
| SO61258_5 | 9DCB-43A8-8D | PO3509137345 | 36 | 292 | 487 | 139 | 7 | 2024-04-26 | 98.98 | 2.47 | 2024-04-14 | 3 | 20.57 | 1 | 98.98 | 5 | SO61258 | 2024-04-21 | 7.92 | 61.70 | 32.99 | |||
| SO47975_16 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 415 | 558 | 2 | 2023-02-25 | 792.14 | 19.80 | 2023-02-13 | 4 | 146.55 | 1 | 792.14 | 16 | SO47975 | 2023-02-20 | 63.37 | 586.19 | 198.04 | |||
| SO67294_39 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 472 | 290 | 1 | 2024-07-26 | 381.00 | 9.53 | 2024-07-14 | 10 | 23.75 | 1 | 381.00 | 39 | SO67294 | 2024-07-21 | 30.48 | 237.49 | 38.10 | |||
| SO69527_3 | A6FE-49DA-BE | PO4843110434 | 100 | 287 | 240 | 257 | 4 | 2024-08-25 | 2576.70 | 64.42 | 2024-08-13 | 3 | 868.63 | 1 | 2576.70 | 3 | SO69527 | 2024-08-20 | 206.14 | 2605.90 | 858.90 | |||
| SO46036_20 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 330 | 558 | 2 | 2022-08-25 | 419.46 | 10.49 | 2022-08-13 | 1 | 413.15 | 1 | 419.46 | 20 | SO46036 | 2022-08-20 | 33.56 | 413.15 | 419.46 | |||
| SO44497_1 | 90B5-4A92-99 | PO17777180922 | 19 | 288 | 276 | 208 | 6 | 2022-02-25 | 356.90 | 8.92 | 2022-02-13 | 1 | 352.14 | 1 | 356.90 | 1 | SO44497 | 2022-02-20 | 28.55 | 352.14 | 356.90 | |||
| SO69462_7 | 05B6-4501-9B | PO1769122113 | 100 | 283 | 225 | 540 | 2 | 2024-08-25 | 10.79 | 0.27 | 2024-08-13 | 2 | 6.92 | 1 | 10.79 | 7 | SO69462 | 2024-08-20 | 0.86 | 13.84 | 5.39 | |||
| SO63220_5 | 25AE-42A1-80 | PO9773177410 | 100 | 285 | 568 | 8 | 5 | 2024-05-27 | 445.41 | 11.14 | 2024-05-15 | 1 | 461.44 | 1 | 445.41 | 5 | SO63220 | 2024-05-22 | 35.63 | 461.44 | 445.41 | |||
| SO50311_2 | E09E-4D02-9F | PO7453115958 | 100 | 283 | 327 | 2 | 108 | 2 | 118.07 | 2023-08-25 | 5903.74 | 144.64 | 2023-08-13 | 13 | 486.71 | 1 | 5785.67 | 2 | SO50311 | 2023-08-20 | 462.85 | 6327.19 | 454.13 | 0.02 |
| SO53457_24 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 353 | 272 | 1 | 2023-12-26 | 4175.98 | 104.40 | 2023-12-14 | 3 | 1265.62 | 1 | 4175.98 | 24 | SO53457 | 2023-12-21 | 334.08 | 3796.86 | 1391.99 |
Generated 2024-11-13 00:49:31.032 UTC