[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 317 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO48775_11 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 387 | 203 | 4 | 2023-04-28 | 2401.05 | 60.03 | 2023-04-16 | 4 | 605.65 | 1 | 2401.05 | 11 | SO48775 | 2023-04-23 | 192.08 | 2422.60 | 600.26 | |||
| SO67290_8 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 234 | 41 | 4 | 2024-07-27 | 89.98 | 2.25 | 2024-07-15 | 3 | 38.49 | 1 | 89.98 | 8 | SO67290 | 2024-07-22 | 7.20 | 115.48 | 29.99 | |||
| SO71845_4 | 4781-4673-85 | PO2697119362 | 100 | 282 | 295 | 187 | 4 | 2024-09-26 | 2456.10 | 61.40 | 2024-09-14 | 3 | 747.20 | 1 | 2456.10 | 4 | SO71845 | 2024-09-21 | 196.49 | 2241.60 | 818.70 | |||
| SO57145_27 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 594 | 435 | 4 | 2024-02-26 | 677.99 | 16.95 | 2024-02-14 | 2 | 308.22 | 1 | 677.99 | 27 | SO57145 | 2024-02-21 | 54.24 | 616.44 | 338.99 | |||
| SO58907_27 | F365-4683-97 | PO19372175613 | 100 | 282 | 214 | 582 | 4 | 2024-03-27 | 62.98 | 1.57 | 2024-03-15 | 3 | 13.09 | 1 | 62.98 | 27 | SO58907 | 2024-03-22 | 5.04 | 39.26 | 20.99 | |||
| SO47692_2 | F786-4312-9B | PO10237186654 | 100 | 287 | 422 | 41 | 4 | 2023-01-26 | 67.54 | 1.69 | 2023-01-14 | 1 | 49.98 | 1 | 67.54 | 2 | SO47692 | 2023-01-21 | 5.40 | 49.98 | 67.54 | |||
| SO47458_8 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 468 | 457 | 4 | 2022-12-27 | 113.97 | 2.85 | 2022-12-15 | 5 | 15.67 | 1 | 113.97 | 8 | SO47458 | 2022-12-22 | 9.12 | 78.35 | 22.79 | |||
| SO49137_4 | 52CF-44E3-9A | PO4553119422 | 100 | 282 | 327 | 313 | 4 | 2023-05-29 | 469.79 | 11.74 | 2023-05-17 | 1 | 486.71 | 1 | 469.79 | 4 | SO49137 | 2023-05-24 | 37.58 | 486.71 | 469.79 | |||
| SO47024_9 | F254-4053-A3 | PO3654136382 | 100 | 283 | 354 | 435 | 4 | 2022-11-26 | 4971.41 | 124.29 | 2022-11-14 | 4 | 1117.86 | 1 | 4971.41 | 9 | SO47024 | 2022-11-21 | 397.71 | 4471.42 | 1242.85 | |||
| SO49489_5 | 7419-48A5-B8 | PO16182158783 | 100 | 287 | 352 | 23 | 4 | 2023-06-26 | 3728.56 | 93.21 | 2023-06-14 | 3 | 1117.86 | 1 | 3728.56 | 5 | SO49489 | 2023-06-21 | 298.28 | 3353.57 | 1242.85 | |||
| SO49498_3 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 381 | 239 | 4 | 2023-06-26 | 600.26 | 15.01 | 2023-06-14 | 1 | 605.65 | 1 | 600.26 | 3 | SO49498 | 2023-06-21 | 48.02 | 605.65 | 600.26 | |||
| SO46642_28 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 415 | 4 | 4 | 2022-10-26 | 792.14 | 19.80 | 2022-10-14 | 4 | 146.55 | 1 | 792.14 | 28 | SO46642 | 2022-10-21 | 63.37 | 586.19 | 198.04 | |||
| SO49533_18 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 447 | 75 | 4 | 2023-06-26 | 60.00 | 1.50 | 2023-06-14 | 4 | 10.31 | 1 | 60.00 | 18 | SO49533 | 2023-06-21 | 4.80 | 41.25 | 15.00 | |||
| SO69545_6 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 222 | 436 | 4 | 2024-08-26 | 83.98 | 2.10 | 2024-08-14 | 4 | 13.09 | 1 | 83.98 | 6 | SO69545 | 2024-08-21 | 6.72 | 52.35 | 20.99 | |||
| SO47700_13 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 410 | 184 | 4 | 2023-01-26 | 36.45 | 0.91 | 2023-01-14 | 1 | 26.97 | 1 | 36.45 | 13 | SO47700 | 2023-01-21 | 2.92 | 26.97 | 36.45 | |||
| SO46374_10 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 350 | 7 | 75 | 4 | 590.62 | 2022-09-26 | 1687.50 | 27.42 | 2022-09-14 | 2 | 1898.09 | 1 | 1096.87 | 10 | SO46374 | 2022-09-21 | 87.75 | 3796.19 | 843.75 | 0.35 |
| SO59014_8 | E148-47F7-98 | PO5510184760 | 100 | 287 | 482 | 5 | 4 | 2024-03-27 | 48.55 | 1.21 | 2024-03-15 | 9 | 3.36 | 1 | 48.55 | 8 | SO59014 | 2024-03-22 | 3.88 | 30.26 | 5.39 | |||
| SO65232_26 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 544 | 490 | 4 | 2024-06-26 | 194.38 | 4.86 | 2024-06-14 | 4 | 35.96 | 1 | 194.38 | 26 | SO65232 | 2024-06-21 | 15.55 | 143.84 | 48.59 | |||
| SO44509_29 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 235 | 328 | 4 | 2022-02-26 | 259.56 | 6.49 | 2022-02-14 | 9 | 31.72 | 1 | 259.56 | 29 | SO44509 | 2022-02-21 | 20.77 | 285.52 | 28.84 | |||
| SO49151_8 | D25B-462C-8C | PO6438151235 | 100 | 281 | 469 | 2 | 309 | 4 | 5.29 | 2023-05-29 | 264.41 | 6.48 | 2023-05-17 | 12 | 15.67 | 1 | 259.12 | 8 | SO49151 | 2023-05-24 | 20.73 | 188.05 | 22.03 | 0.02 |
| SO44757_1 | C27A-4D15-8C | PO14964184059 | 100 | 287 | 344 | 581 | 4 | 2022-03-28 | 4079.99 | 102.00 | 2022-03-16 | 2 | 1912.15 | 1 | 4079.99 | 1 | SO44757 | 2022-03-23 | 326.40 | 3824.31 | 2039.99 | |||
| SO67298_23 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 561 | 205 | 4 | 2024-07-27 | 10013.09 | 250.33 | 2024-07-15 | 7 | 1481.94 | 1 | 10013.09 | 23 | SO67298 | 2024-07-22 | 801.05 | 10373.57 | 1430.44 | |||
| SO46082_4 | E8B4-45CF-8C | PO3799169418 | 100 | 282 | 351 | 312 | 4 | 2022-08-26 | 8099.98 | 202.50 | 2022-08-14 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO46082 | 2022-08-21 | 648.00 | 7592.38 | 2024.99 | |||
| SO53460_9 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 378 | 24 | 4 | 2023-12-27 | 2932.02 | 73.30 | 2023-12-15 | 2 | 1554.95 | 1 | 2932.02 | 9 | SO53460 | 2023-12-22 | 234.56 | 3109.90 | 1466.01 | |||
| SO44777_1 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 232 | 366 | 4 | 2022-03-28 | 57.68 | 1.44 | 2022-03-16 | 2 | 31.72 | 1 | 57.68 | 1 | SO44777 | 2022-03-23 | 4.61 | 63.45 | 28.84 | |||
| SO43689_14 | DCD9-4C9A-AB | PO5626159507 | 100 | 283 | 275 | 166 | 4 | 2021-10-26 | 713.80 | 17.84 | 2021-10-14 | 2 | 352.14 | 1 | 713.80 | 14 | SO43689 | 2021-10-21 | 57.10 | 704.28 | 356.90 | |||
| SO45286_2 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 324 | 259 | 4 | 2022-05-29 | 838.92 | 20.97 | 2022-05-17 | 2 | 413.15 | 1 | 838.92 | 2 | SO45286 | 2022-05-24 | 67.11 | 826.29 | 419.46 | |||
| SO59068_30 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 533 | 490 | 4 | 2024-03-27 | 599.50 | 14.99 | 2024-03-15 | 4 | 136.79 | 1 | 599.50 | 30 | SO59068 | 2024-03-22 | 47.96 | 547.14 | 149.87 | |||
| SO44521_11 | E46D-4692-AC | PO12557171689 | 100 | 282 | 275 | 240 | 4 | 2022-02-26 | 356.90 | 8.92 | 2022-02-14 | 1 | 352.14 | 1 | 356.90 | 11 | SO44521 | 2022-02-21 | 28.55 | 352.14 | 356.90 | |||
| SO44538_11 | E495-47A9-AD | PO2523126243 | 100 | 287 | 317 | 167 | 4 | 2022-02-26 | 2624.38 | 65.61 | 2022-02-14 | 3 | 884.71 | 1 | 2624.38 | 11 | SO44538 | 2022-02-21 | 209.95 | 2654.12 | 874.79 | |||
| SO49832_14 | 3280-41FF-A3 | PO13659150841 | 100 | 287 | 427 | 437 | 4 | 2023-07-27 | 209.26 | 5.23 | 2023-07-15 | 1 | 185.82 | 1 | 209.26 | 14 | SO49832 | 2023-07-22 | 16.74 | 185.82 | 209.26 | |||
| SO47720_40 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 329 | 221 | 4 | 2023-01-26 | 1879.18 | 46.98 | 2023-01-14 | 4 | 486.71 | 1 | 1879.18 | 40 | SO47720 | 2023-01-21 | 150.33 | 1946.83 | 469.79 | |||
| SO58988_8 | 419B-4310-83 | PO16124114660 | 100 | 282 | 545 | 649 | 4 | 2024-03-27 | 24.29 | 0.61 | 2024-03-15 | 1 | 17.98 | 1 | 24.29 | 8 | SO58988 | 2024-03-22 | 1.94 | 17.98 | 24.29 | |||
| SO44755_8 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 317 | 273 | 4 | 2022-03-28 | 874.79 | 21.87 | 2022-03-16 | 1 | 884.71 | 1 | 874.79 | 8 | SO44755 | 2022-03-23 | 69.98 | 884.71 | 874.79 | |||
| SO43912_3 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 229 | 403 | 4 | 2021-11-26 | 57.68 | 1.44 | 2021-11-14 | 2 | 31.72 | 1 | 57.68 | 3 | SO43912 | 2021-11-21 | 4.61 | 63.45 | 28.84 | |||
| SO48397_14 | A1DC-424B-A8 | PO9686169278 | 100 | 282 | 399 | 457 | 4 | 2023-03-28 | 33.77 | 0.84 | 2023-03-16 | 1 | 24.99 | 1 | 33.77 | 14 | SO48397 | 2023-03-23 | 2.70 | 24.99 | 33.77 | |||
| SO48363_6 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 445 | 130 | 4 | 2023-03-28 | 71.99 | 1.80 | 2023-03-16 | 2 | 24.75 | 1 | 71.99 | 6 | SO48363 | 2023-03-23 | 5.76 | 49.49 | 35.99 | |||
| SO61218_22 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 234 | 475 | 4 | 2024-04-27 | 299.94 | 7.50 | 2024-04-15 | 10 | 38.49 | 1 | 299.94 | 22 | SO61218 | 2024-04-22 | 24.00 | 384.92 | 29.99 | |||
| SO51773_20 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 484 | 167 | 4 | 2023-11-26 | 9.54 | 0.24 | 2023-11-14 | 2 | 2.97 | 1 | 9.54 | 20 | SO51773 | 2023-11-21 | 0.76 | 5.95 | 4.77 | |||
| SO46965_11 | C9A7-4125-95 | PO15921113146 | 100 | 287 | 221 | 77 | 4 | 2022-11-26 | 60.56 | 1.51 | 2022-11-14 | 3 | 13.88 | 1 | 60.56 | 11 | SO46965 | 2022-11-21 | 4.84 | 41.63 | 20.19 | |||
| SO71899_6 | C395-434F-89 | PO4582142611 | 100 | 282 | 231 | 25 | 4 | 2024-09-26 | 59.99 | 1.50 | 2024-09-14 | 2 | 38.49 | 1 | 59.99 | 6 | SO71899 | 2024-09-21 | 4.80 | 76.98 | 29.99 | |||
| SO53614_37 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 511 | 21 | 4 | 2023-12-27 | 1310.72 | 32.77 | 2023-12-15 | 6 | 199.38 | 1 | 1310.72 | 37 | SO53614 | 2023-12-22 | 104.86 | 1196.25 | 218.45 | |||
| SO51855_1 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 418 | 436 | 4 | 2023-11-26 | 713.80 | 17.84 | 2023-11-14 | 2 | 360.94 | 1 | 713.80 | 1 | SO51855 | 2023-11-21 | 57.10 | 721.89 | 356.90 | |||
| SO48043_16 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 213 | 167 | 4 | 2023-02-26 | 161.49 | 4.04 | 2023-02-14 | 8 | 13.88 | 1 | 161.49 | 16 | SO48043 | 2023-02-21 | 12.92 | 111.03 | 20.19 | |||
| SO49498_26 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 327 | 239 | 4 | 2023-06-26 | 4697.94 | 117.45 | 2023-06-14 | 10 | 486.71 | 1 | 4697.94 | 26 | SO49498 | 2023-06-21 | 375.84 | 4867.07 | 469.79 | |||
| SO69517_4 | B70F-4B16-A6 | PO5655130015 | 100 | 287 | 568 | 563 | 4 | 2024-08-26 | 445.41 | 11.14 | 2024-08-14 | 1 | 461.44 | 1 | 445.41 | 4 | SO69517 | 2024-08-21 | 35.63 | 461.44 | 445.41 | |||
| SO69412_35 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 605 | 328 | 4 | 2024-08-26 | 1295.98 | 32.40 | 2024-08-14 | 4 | 343.65 | 1 | 1295.98 | 35 | SO69412 | 2024-08-21 | 103.68 | 1374.60 | 323.99 | |||
| SO50738_32 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 373 | 130 | 4 | 2023-09-26 | 7853.63 | 196.34 | 2023-09-14 | 6 | 1320.68 | 1 | 7853.63 | 32 | SO50738 | 2023-09-21 | 628.29 | 7924.10 | 1308.94 | |||
| SO58979_11 | A35B-403A-A4 | PO18038174164 | 100 | 287 | 501 | 509 | 4 | 2024-03-27 | 145.75 | 3.64 | 2024-03-15 | 2 | 53.93 | 1 | 145.75 | 11 | SO58979 | 2024-03-22 | 11.66 | 107.86 | 72.88 | |||
| SO48375_5 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 364 | 75 | 4 | 2023-03-28 | 647.99 | 16.20 | 2023-03-16 | 1 | 598.44 | 1 | 647.99 | 5 | SO48375 | 2023-03-23 | 51.84 | 598.44 | 647.99 | |||
| SO46049_18 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 326 | 328 | 4 | 2022-08-26 | 838.92 | 20.97 | 2022-08-14 | 2 | 413.15 | 1 | 838.92 | 18 | SO46049 | 2022-08-21 | 67.11 | 826.29 | 419.46 | |||
| SO46648_49 | 2073-4051-9E | PO2494191557 | 100 | 283 | 459 | 184 | 4 | 2022-10-26 | 377.96 | 9.45 | 2022-10-14 | 7 | 37.12 | 1 | 377.96 | 49 | SO46648 | 2022-10-21 | 30.24 | 259.85 | 53.99 | |||
| SO47049_18 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 366 | 345 | 4 | 2022-11-26 | 3239.97 | 81.00 | 2022-11-14 | 5 | 598.44 | 1 | 3239.97 | 18 | SO47049 | 2022-11-21 | 259.20 | 2992.18 | 647.99 | |||
| SO53546_17 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 384 | 624 | 4 | 2023-12-27 | 1344.59 | 33.61 | 2023-12-15 | 2 | 713.08 | 1 | 1344.59 | 17 | SO53546 | 2023-12-22 | 107.57 | 1426.16 | 672.29 | |||
| SO48043_27 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 422 | 167 | 4 | 2023-02-26 | 270.16 | 6.75 | 2023-02-14 | 4 | 49.98 | 1 | 270.16 | 27 | SO48043 | 2023-02-21 | 21.61 | 199.92 | 67.54 | |||
| SO47369_14 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 464 | 239 | 4 | 2022-12-27 | 113.03 | 2.83 | 2022-12-15 | 8 | 9.71 | 1 | 113.03 | 14 | SO47369 | 2022-12-22 | 9.04 | 77.71 | 14.13 |
Generated 2024-11-13 07:17:09.981 UTC