[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 889 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO43689_12 | DCD9-4C9A-AB | PO5626159507 | 100 | 283 | 270 | 166 | 4 | 2021-10-23 | 367.88 | 9.20 | 2021-10-11 | 2 | 181.49 | 1 | 367.88 | 12 | SO43689 | 2021-10-18 | 29.43 | 362.97 | 183.94 | |||
| SO63280_15 | C73E-4203-80 | PO3654118854 | 100 | 281 | 400 | 435 | 4 | 2024-05-25 | 74.30 | 1.86 | 2024-05-13 | 2 | 27.49 | 1 | 74.30 | 15 | SO63280 | 2024-05-20 | 5.94 | 54.99 | 37.15 | |||
| SO57069_5 | 3D65-4219-9F | PO11281141888 | 36 | 295 | 225 | 68 | 8 | 2024-02-23 | 21.58 | 0.54 | 2024-02-11 | 4 | 6.92 | 1 | 21.58 | 5 | SO57069 | 2024-02-18 | 1.73 | 27.69 | 5.39 | |||
| SO47658_24 | C574-484B-83 | PO551177057 | 100 | 283 | 370 | 4 | 4 | 2023-01-23 | 4398.03 | 109.95 | 2023-01-11 | 3 | 1518.79 | 1 | 4398.03 | 24 | SO47658 | 2023-01-18 | 351.84 | 4556.36 | 1466.01 | |||
| SO47365_1 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 427 | 678 | 6 | 2022-12-24 | 1674.05 | 41.85 | 2022-12-12 | 8 | 185.82 | 1 | 1674.05 | 1 | SO47365 | 2022-12-19 | 133.92 | 1486.55 | 209.26 | |||
| SO53460_46 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 376 | 24 | 4 | 2023-12-24 | 2932.02 | 73.30 | 2023-12-12 | 2 | 1554.95 | 1 | 2932.02 | 46 | SO53460 | 2023-12-19 | 234.56 | 3109.90 | 1466.01 | |||
| SO47066_25 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 370 | 218 | 1 | 2022-11-23 | 2932.02 | 73.30 | 2022-11-11 | 2 | 1518.79 | 1 | 2932.02 | 25 | SO47066 | 2022-11-18 | 234.56 | 3037.57 | 1466.01 | |||
| SO44547_20 | 801C-4288-87 | PO4901179982 | 19 | 284 | 330 | 84 | 6 | 2022-02-23 | 1677.84 | 41.95 | 2022-02-11 | 4 | 413.15 | 1 | 1677.84 | 20 | SO44547 | 2022-02-18 | 134.23 | 1652.59 | 419.46 | |||
| SO71889_19 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 483 | 3 | 4 | 2024-09-23 | 720.00 | 18.00 | 2024-09-11 | 10 | 44.88 | 1 | 720.00 | 19 | SO71889 | 2024-09-18 | 57.60 | 448.80 | 72.00 | |||
| SO51761_14 | 056F-4C15-93 | PO580111702 | 36 | 295 | 465 | 230 | 8 | 2023-11-23 | 29.39 | 0.73 | 2023-11-11 | 2 | 9.16 | 1 | 29.39 | 14 | SO51761 | 2023-11-18 | 2.35 | 18.32 | 14.69 | |||
| SO51160_23 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 543 | 496 | 6 | 2023-10-23 | 37.25 | 0.93 | 2023-10-11 | 1 | 27.57 | 1 | 37.25 | 23 | SO51160 | 2023-10-18 | 2.98 | 27.57 | 37.25 | |||
| SO67348_3 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 363 | 494 | 5 | 2024-07-24 | 2753.99 | 68.85 | 2024-07-12 | 2 | 1251.98 | 1 | 2753.99 | 3 | SO67348 | 2024-07-19 | 220.32 | 2503.96 | 1376.99 | |||
| SO63157_1 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 363 | 650 | 1 | 2024-05-25 | 8261.96 | 206.55 | 2024-05-13 | 6 | 1251.98 | 1 | 8261.96 | 1 | SO63157 | 2024-05-20 | 660.96 | 7511.89 | 1376.99 | |||
| SO63214_43 | 5C93-4C23-8D | PO11368112676 | 36 | 295 | 398 | 687 | 8 | 2024-05-25 | 106.90 | 2.67 | 2024-05-13 | 4 | 19.78 | 1 | 106.90 | 43 | SO63214 | 2024-05-20 | 8.55 | 79.10 | 26.72 | |||
| SO48016_33 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 383 | 97 | 4 | 2023-02-23 | 1800.79 | 45.02 | 2023-02-11 | 3 | 605.65 | 1 | 1800.79 | 33 | SO48016 | 2023-02-18 | 144.06 | 1816.95 | 600.26 | |||
| SO57128_6 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 588 | 345 | 4 | 2024-02-23 | 923.39 | 23.08 | 2024-02-11 | 2 | 419.78 | 1 | 923.39 | 6 | SO57128 | 2024-02-18 | 73.87 | 839.56 | 461.69 | |||
| SO71816_3 | 52D4-4F3B-9E | PO12992180445 | 100 | 282 | 234 | 295 | 4 | 2024-09-23 | 59.99 | 1.50 | 2024-09-11 | 2 | 38.49 | 1 | 59.99 | 3 | SO71816 | 2024-09-18 | 4.80 | 76.98 | 29.99 | |||
| SO46620_8 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 453 | 618 | 2 | 2022-10-23 | 107.98 | 2.70 | 2022-10-11 | 3 | 24.75 | 1 | 107.98 | 8 | SO46620 | 2022-10-18 | 8.64 | 74.24 | 35.99 | |||
| SO53612_3 | A412-4D5C-AD | PO6931152431 | 100 | 281 | 553 | 400 | 3 | 2023-12-24 | 55.31 | 1.38 | 2023-12-12 | 2 | 20.46 | 1 | 55.31 | 3 | SO53612 | 2023-12-19 | 4.42 | 40.93 | 27.65 | |||
| SO50663_22 | 286E-4915-89 | PO19343130555 | 100 | 282 | 216 | 3 | 24 | 4 | 14.80 | 2023-09-23 | 296.07 | 7.03 | 2023-09-11 | 16 | 13.88 | 1 | 281.27 | 22 | SO50663 | 2023-09-18 | 22.50 | 222.05 | 18.50 | 0.05 |
| SO71894_35 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 563 | 539 | 2 | 2024-09-23 | 5721.77 | 143.04 | 2024-09-11 | 4 | 1481.94 | 1 | 5721.77 | 35 | SO71894 | 2024-09-18 | 457.74 | 5927.75 | 1430.44 | |||
| SO49849_6 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 458 | 506 | 1 | 2023-07-24 | 269.96 | 6.75 | 2023-07-12 | 6 | 30.93 | 1 | 269.96 | 6 | SO49849 | 2023-07-19 | 21.60 | 185.60 | 44.99 | |||
| SO53574_10 | A501-443D-A3 | PO6119138590 | 98 | 288 | 472 | 268 | 10 | 2023-12-24 | 114.30 | 2.86 | 2023-12-12 | 3 | 23.75 | 1 | 114.30 | 10 | SO53574 | 2023-12-19 | 9.14 | 71.25 | 38.10 | |||
| SO58953_14 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 545 | 156 | 6 | 2024-03-24 | 48.59 | 1.21 | 2024-03-12 | 2 | 17.98 | 1 | 48.59 | 14 | SO58953 | 2024-03-19 | 3.89 | 35.96 | 24.29 | |||
| SO65208_2 | EC05-4765-B6 | PO1450163231 | 100 | 292 | 359 | 571 | 7 | 2024-06-23 | 2753.99 | 68.85 | 2024-06-11 | 2 | 1251.98 | 1 | 2753.99 | 2 | SO65208 | 2024-06-18 | 220.32 | 2503.96 | 1376.99 | |||
| SO50245_6 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 368 | 66 | 6 | 2023-08-23 | 2932.02 | 73.30 | 2023-08-11 | 2 | 1518.79 | 1 | 2932.02 | 6 | SO50245 | 2023-08-18 | 234.56 | 3037.57 | 1466.01 | |||
| SO49837_4 | C136-4536-9D | PO12412160791 | 100 | 281 | 370 | 670 | 3 | 2023-07-24 | 10262.07 | 256.55 | 2023-07-12 | 7 | 1518.79 | 1 | 10262.07 | 4 | SO49837 | 2023-07-19 | 820.97 | 10631.50 | 1466.01 | |||
| SO65171_4 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 474 | 47 | 6 | 2024-06-23 | 419.94 | 10.50 | 2024-06-11 | 10 | 26.18 | 1 | 419.94 | 4 | SO65171 | 2024-06-18 | 33.60 | 261.76 | 41.99 | |||
| SO49851_27 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 365 | 184 | 4 | 2023-07-24 | 1943.98 | 48.60 | 2023-07-12 | 3 | 598.44 | 1 | 1943.98 | 27 | SO49851 | 2023-07-19 | 155.52 | 1795.31 | 647.99 | |||
| SO63214_22 | 5C93-4C23-8D | PO11368112676 | 36 | 295 | 353 | 687 | 8 | 2024-05-25 | 4175.98 | 104.40 | 2024-05-13 | 3 | 1265.62 | 1 | 4175.98 | 22 | SO63214 | 2024-05-20 | 334.08 | 3796.86 | 1391.99 | |||
| SO63266_11 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 597 | 352 | 6 | 2024-05-25 | 323.99 | 8.10 | 2024-05-13 | 1 | 294.58 | 1 | 323.99 | 11 | SO63266 | 2024-05-20 | 25.92 | 294.58 | 323.99 | |||
| SO49040_7 | 6653-43A9-8D | PO19923195099 | 100 | 283 | 428 | 18 | 3 | 2023-05-26 | 209.26 | 5.23 | 2023-05-14 | 1 | 185.82 | 1 | 209.26 | 7 | SO49040 | 2023-05-21 | 16.74 | 185.82 | 209.26 | |||
| SO65257_19 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 487 | 539 | 2 | 2024-06-23 | 32.99 | 0.82 | 2024-06-11 | 1 | 20.57 | 1 | 32.99 | 19 | SO65257 | 2024-06-18 | 2.64 | 20.57 | 32.99 | |||
| SO49523_10 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 343 | 130 | 4 | 2023-06-23 | 2818.76 | 70.47 | 2023-06-11 | 6 | 486.71 | 1 | 2818.76 | 10 | SO49523 | 2023-06-18 | 225.50 | 2920.24 | 469.79 | |||
| SO44744_10 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 312 | 173 | 6 | 2022-03-25 | 4293.92 | 107.35 | 2022-03-13 | 2 | 2171.29 | 1 | 4293.92 | 10 | SO44744 | 2022-03-20 | 343.51 | 4342.59 | 2146.96 | |||
| SO59064_33 | AE68-4CAD-B8 | PO8671111477 | 98 | 290 | 398 | 502 | 10 | 2024-03-24 | 106.90 | 2.67 | 2024-03-12 | 4 | 19.78 | 1 | 106.90 | 33 | SO59064 | 2024-03-19 | 8.55 | 79.10 | 26.72 | |||
| SO43863_1 | D0C0-435D-A2 | PO15747169584 | 100 | 283 | 319 | 471 | 4 | 2021-11-23 | 874.79 | 21.87 | 2021-11-11 | 1 | 884.71 | 1 | 874.79 | 1 | SO43863 | 2021-11-18 | 69.98 | 884.71 | 874.79 | |||
| SO51845_9 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 600 | 312 | 4 | 2023-11-23 | 971.98 | 24.30 | 2023-11-11 | 3 | 294.58 | 1 | 971.98 | 9 | SO51845 | 2023-11-18 | 77.76 | 883.74 | 323.99 | |||
| SO43685_2 | C519-4AB3-88 | PO4176124783 | 100 | 285 | 328 | 458 | 5 | 2021-10-23 | 419.46 | 10.49 | 2021-10-11 | 1 | 413.15 | 1 | 419.46 | 2 | SO43685 | 2021-10-18 | 33.56 | 413.15 | 419.46 | |||
| SO53458_47 | 0728-4E88-9F | PO19285149036 | 98 | 288 | 234 | 3 | 448 | 10 | 24.75 | 2023-12-24 | 494.90 | 11.75 | 2023-12-12 | 18 | 38.49 | 1 | 470.16 | 47 | SO53458 | 2023-12-19 | 37.61 | 692.86 | 27.49 | 0.05 |
| SO45294_8 | 2F48-482E-A9 | PO14500175708 | 100 | 282 | 307 | 650 | 1 | 2022-05-26 | 722.59 | 18.06 | 2022-05-14 | 1 | 623.84 | 1 | 722.59 | 8 | SO45294 | 2022-05-21 | 57.81 | 623.84 | 722.59 | |||
| SO44282_15 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 344 | 442 | 6 | 2022-01-23 | 6119.98 | 153.00 | 2022-01-11 | 3 | 1912.15 | 1 | 6119.98 | 15 | SO44282 | 2022-01-18 | 489.60 | 5736.46 | 2039.99 | |||
| SO46950_18 | AAC1-43D9-A3 | PO17806144306 | 19 | 291 | 325 | 101 | 6 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 18 | SO46950 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
| SO49465_18 | DE18-49CF-B2 | PO1624120205 | 100 | 281 | 337 | 579 | 3 | 2023-06-23 | 939.59 | 23.49 | 2023-06-11 | 2 | 486.71 | 1 | 939.59 | 18 | SO49465 | 2023-06-18 | 75.17 | 973.41 | 469.79 | |||
| SO45308_2 | 81AA-4F3D-A7 | PO10440184078 | 100 | 283 | 344 | 623 | 3 | 2022-05-26 | 14279.96 | 357.00 | 2022-05-14 | 7 | 1912.15 | 1 | 14279.96 | 2 | SO45308 | 2022-05-21 | 1142.40 | 13385.08 | 2039.99 | |||
| SO65174_33 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 359 | 678 | 6 | 2024-06-23 | 4130.98 | 103.27 | 2024-06-11 | 3 | 1251.98 | 1 | 4130.98 | 33 | SO65174 | 2024-06-18 | 330.48 | 3755.94 | 1376.99 | |||
| SO65319_32 | 9F05-4591-9D | PO8671197482 | 98 | 288 | 363 | 502 | 10 | 2024-06-23 | 2753.99 | 68.85 | 2024-06-11 | 2 | 1251.98 | 1 | 2753.99 | 32 | SO65319 | 2024-06-18 | 220.32 | 2503.96 | 1376.99 | |||
| SO44093_8 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 264 | 93 | 4 | 2021-12-24 | 367.88 | 9.20 | 2021-12-12 | 2 | 181.49 | 1 | 367.88 | 8 | SO44093 | 2021-12-19 | 29.43 | 362.97 | 183.94 | |||
| SO59014_2 | E148-47F7-98 | PO5510184760 | 100 | 287 | 605 | 5 | 4 | 2024-03-24 | 2267.96 | 56.70 | 2024-03-12 | 7 | 343.65 | 1 | 2267.96 | 2 | SO59014 | 2024-03-19 | 181.44 | 2405.55 | 323.99 | |||
| SO47366_36 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 383 | 155 | 6 | 2022-12-24 | 1800.79 | 45.02 | 2022-12-12 | 3 | 605.65 | 1 | 1800.79 | 36 | SO47366 | 2022-12-19 | 144.06 | 1816.95 | 600.26 | |||
| SO48370_12 | 2BBA-46FF-BD | PO4640118571 | 100 | 287 | 421 | 648 | 4 | 2023-03-25 | 196.33 | 4.91 | 2023-03-13 | 1 | 145.28 | 1 | 196.33 | 12 | SO48370 | 2023-03-20 | 15.71 | 145.28 | 196.33 | |||
| SO47696_10 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 356 | 245 | 6 | 2023-01-23 | 8699.96 | 217.50 | 2023-01-11 | 7 | 1117.86 | 1 | 8699.96 | 10 | SO47696 | 2023-01-18 | 696.00 | 7824.99 | 1242.85 | |||
| SO49125_2 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 421 | 435 | 4 | 2023-05-26 | 392.66 | 9.82 | 2023-05-14 | 2 | 145.28 | 1 | 392.66 | 2 | SO49125 | 2023-05-21 | 31.41 | 290.57 | 196.33 | |||
| SO69467_12 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 576 | 522 | 2 | 2024-08-23 | 2860.88 | 71.52 | 2024-08-11 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO69467 | 2024-08-18 | 228.87 | 2963.88 | 1430.44 | |||
| SO45520_10 | 86A2-4B9B-8D | PO19488171523 | 100 | 283 | 322 | 57 | 3 | 2022-06-23 | 1677.84 | 41.95 | 2022-06-11 | 4 | 413.15 | 1 | 1677.84 | 10 | SO45520 | 2022-06-18 | 134.23 | 1652.59 | 419.46 | |||
| SO48375_20 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 391 | 75 | 4 | 2023-03-25 | 177.86 | 4.45 | 2023-03-13 | 2 | 65.81 | 1 | 177.86 | 20 | SO48375 | 2023-03-20 | 14.23 | 131.62 | 88.93 |
Generated 2024-11-10 11:12:01.451 UTC