[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6816 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43894_6 | 7DF2-4E54-B0 | PO2958194987 | 100 | 286 | 351 | 559 | 1 | 2021-11-23 | 10124.97 | 253.12 | 2021-11-11 | 5 | 1898.09 | 1 | 10124.97 | 6 | SO43894 | 2021-11-18 | 810.00 | 9490.47 | 2024.99 | |||
SO50297_33 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 339 | 343 | 1 | 2023-08-23 | 1409.38 | 35.23 | 2023-08-11 | 3 | 486.71 | 1 | 1409.38 | 33 | SO50297 | 2023-08-18 | 112.75 | 1460.12 | 469.79 | |||
SO51826_16 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 495 | 693 | 1 | 2023-11-23 | 602.35 | 15.06 | 2023-11-11 | 1 | 601.74 | 1 | 602.35 | 16 | SO51826 | 2023-11-18 | 48.19 | 601.74 | 602.35 | |||
SO69475_2 | F74A-4967-BA | PO18618162557 | 100 | 286 | 569 | 605 | 1 | 2024-08-23 | 1781.64 | 44.54 | 2024-08-11 | 4 | 461.44 | 1 | 1781.64 | 2 | SO69475 | 2024-08-18 | 142.53 | 1845.78 | 445.41 | |||
SO51711_13 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 599 | 236 | 1 | 2023-11-23 | 1943.96 | 48.60 | 2023-11-11 | 6 | 294.58 | 1 | 1943.96 | 13 | SO51711 | 2023-11-18 | 155.52 | 1767.48 | 323.99 | |||
SO53569_21 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 521 | 55 | 1 | 2023-12-24 | 48.82 | 1.22 | 2023-12-12 | 3 | 12.04 | 1 | 48.82 | 21 | SO53569 | 2023-12-19 | 3.91 | 36.12 | 16.27 | |||
SO46643_25 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 417 | 290 | 1 | 2022-10-23 | 1622.26 | 40.56 | 2022-10-11 | 5 | 300.12 | 1 | 1622.26 | 25 | SO46643 | 2022-10-18 | 129.78 | 1500.59 | 324.45 | |||
SO71893_10 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 574 | 163 | 1 | 2024-09-23 | 2860.88 | 71.52 | 2024-09-11 | 2 | 1481.94 | 1 | 2860.88 | 10 | SO71893 | 2024-09-18 | 228.87 | 2963.88 | 1430.44 | |||
SO53493_26 | F767-491F-84 | PO13543118174 | 100 | 287 | 516 | 293 | 1 | 2023-12-24 | 46.97 | 1.17 | 2023-12-12 | 2 | 17.38 | 1 | 46.97 | 26 | SO53493 | 2023-12-19 | 3.76 | 34.76 | 23.48 | |||
SO55241_1 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 512 | 146 | 1 | 2024-01-23 | 655.36 | 16.38 | 2024-01-11 | 3 | 199.38 | 1 | 655.36 | 1 | SO55241 | 2024-01-18 | 52.43 | 598.13 | 218.45 | |||
SO47986_25 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 230 | 236 | 1 | 2023-02-23 | 173.04 | 4.33 | 2023-02-11 | 6 | 29.08 | 1 | 173.04 | 25 | SO47986 | 2023-02-18 | 13.84 | 174.48 | 28.84 | |||
SO69475_24 | F74A-4967-BA | PO18618162557 | 100 | 286 | 480 | 605 | 1 | 2024-08-23 | 1.37 | 0.03 | 2024-08-11 | 1 | 0.86 | 1 | 1.37 | 24 | SO69475 | 2024-08-18 | 0.11 | 0.86 | 1.37 | |||
SO59066_20 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 499 | 55 | 1 | 2024-03-24 | 602.35 | 15.06 | 2024-03-12 | 1 | 601.74 | 1 | 602.35 | 20 | SO59066 | 2024-03-19 | 48.19 | 601.74 | 602.35 | |||
SO53576_26 | 7638-4151-96 | PO7395119515 | 100 | 286 | 353 | 542 | 1 | 2023-12-24 | 2783.99 | 69.60 | 2023-12-12 | 2 | 1265.62 | 1 | 2783.99 | 26 | SO53576 | 2023-12-19 | 222.72 | 2531.24 | 1391.99 | |||
SO49167_7 | 5A78-4DE2-89 | PO8816115193 | 100 | 289 | 343 | 218 | 1 | 2023-05-26 | 1879.18 | 46.98 | 2023-05-14 | 4 | 486.71 | 1 | 1879.18 | 7 | SO49167 | 2023-05-21 | 150.33 | 1946.83 | 469.79 | |||
SO50270_10 | A828-45A2-8B | PO18676112371 | 100 | 282 | 409 | 697 | 1 | 2023-08-23 | 418.51 | 10.46 | 2023-08-11 | 2 | 185.82 | 1 | 418.51 | 10 | SO50270 | 2023-08-18 | 33.48 | 371.64 | 209.26 | |||
SO53469_4 | 9CB4-402C-94 | PO17139199092 | 100 | 293 | 436 | 644 | 1 | 2023-12-24 | 356.90 | 8.92 | 2023-12-12 | 1 | 360.94 | 1 | 356.90 | 4 | SO53469 | 2023-12-19 | 28.55 | 360.94 | 356.90 | |||
SO45344_16 | 166F-4C74-85 | PO8816179390 | 100 | 289 | 328 | 218 | 1 | 2022-05-26 | 838.92 | 20.97 | 2022-05-14 | 2 | 413.15 | 1 | 838.92 | 16 | SO45344 | 2022-05-21 | 67.11 | 826.29 | 419.46 | |||
SO50671_1 | 9526-4D73-83 | PO17139132177 | 100 | 293 | 407 | 644 | 1 | 2023-09-23 | 131.20 | 3.28 | 2023-09-11 | 2 | 48.55 | 1 | 131.20 | 1 | SO50671 | 2023-09-18 | 10.50 | 97.09 | 65.60 | |||
SO45267_1 | E20E-4F50-AC | PO19981117950 | 100 | 286 | 326 | 271 | 1 | 2022-05-26 | 419.46 | 10.49 | 2022-05-14 | 1 | 413.15 | 1 | 419.46 | 1 | SO45267 | 2022-05-21 | 33.56 | 413.15 | 419.46 | |||
SO67266_22 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 511 | 146 | 1 | 2024-07-24 | 1747.63 | 43.69 | 2024-07-12 | 8 | 199.38 | 1 | 1747.63 | 22 | SO67266 | 2024-07-19 | 139.81 | 1595.01 | 218.45 | |||
SO59010_42 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 533 | 109 | 1 | 2024-03-24 | 149.87 | 3.75 | 2024-03-12 | 1 | 136.79 | 1 | 149.87 | 42 | SO59010 | 2024-03-19 | 11.99 | 136.79 | 149.87 | |||
SO58961_8 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 574 | 182 | 1 | 2024-03-24 | 5721.77 | 143.04 | 2024-03-12 | 4 | 1481.94 | 1 | 5721.77 | 8 | SO58961 | 2024-03-19 | 457.74 | 5927.75 | 1430.44 | |||
SO46323_2 | 3AF8-4F1A-97 | PO20155112356 | 100 | 289 | 345 | 7 | 92 | 1 | 297.50 | 2022-09-23 | 850.00 | 13.81 | 2022-09-11 | 1 | 1912.15 | 1 | 552.50 | 2 | SO46323 | 2022-09-18 | 44.20 | 1912.15 | 850.00 | 0.35 |
SO59010_4 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 587 | 109 | 1 | 2024-03-24 | 461.69 | 11.54 | 2024-03-12 | 1 | 419.78 | 1 | 461.69 | 4 | SO59010 | 2024-03-19 | 36.94 | 419.78 | 461.69 | |||
SO51726_10 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 523 | 199 | 1 | 2023-11-23 | 63.17 | 1.58 | 2023-11-11 | 2 | 23.37 | 1 | 63.17 | 10 | SO51726 | 2023-11-18 | 5.05 | 46.74 | 31.58 | |||
SO65252_17 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 566 | 672 | 1 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 17 | SO65252 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO44483_2 | 678B-447B-A1 | PO19981138202 | 100 | 286 | 319 | 271 | 1 | 2022-02-23 | 1749.59 | 43.74 | 2022-02-11 | 2 | 884.71 | 1 | 1749.59 | 2 | SO44483 | 2022-02-18 | 139.97 | 1769.42 | 874.79 | |||
SO44075_2 | 2920-4332-89 | PO20155139653 | 100 | 289 | 344 | 92 | 1 | 2021-12-24 | 8159.98 | 204.00 | 2021-12-12 | 4 | 1912.15 | 1 | 8159.98 | 2 | SO44075 | 2021-12-19 | 652.80 | 7648.62 | 2039.99 | |||
SO51800_3 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 359 | 307 | 1 | 2023-11-23 | 1376.99 | 34.42 | 2023-11-11 | 1 | 1251.98 | 1 | 1376.99 | 3 | SO51800 | 2023-11-18 | 110.16 | 1251.98 | 1376.99 | |||
SO46643_7 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 370 | 290 | 1 | 2022-10-23 | 2932.02 | 73.30 | 2022-10-11 | 2 | 1518.79 | 1 | 2932.02 | 7 | SO46643 | 2022-10-18 | 234.56 | 3037.57 | 1466.01 | |||
SO44541_8 | 64BA-409F-A1 | PO2958192556 | 100 | 286 | 348 | 559 | 1 | 2022-02-23 | 4049.99 | 101.25 | 2022-02-11 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO44541 | 2022-02-18 | 324.00 | 3796.19 | 2024.99 | |||
SO44308_6 | 49A4-4845-B2 | PO2552158889 | 100 | 289 | 350 | 506 | 1 | 2022-01-23 | 4049.99 | 101.25 | 2022-01-11 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO44308 | 2022-01-18 | 324.00 | 3796.19 | 2024.99 | |||
SO57030_29 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 595 | 236 | 1 | 2024-02-23 | 1694.97 | 42.37 | 2024-02-11 | 5 | 308.22 | 1 | 1694.97 | 29 | SO57030 | 2024-02-18 | 135.60 | 1541.09 | 338.99 | |||
SO57030_31 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 593 | 236 | 1 | 2024-02-23 | 338.99 | 8.47 | 2024-02-11 | 1 | 308.22 | 1 | 338.99 | 31 | SO57030 | 2024-02-18 | 27.12 | 308.22 | 338.99 | |||
SO57026_3 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 234 | 361 | 1 | 2024-02-23 | 119.98 | 3.00 | 2024-02-11 | 4 | 38.49 | 1 | 119.98 | 3 | SO57026 | 2024-02-18 | 9.60 | 153.97 | 29.99 | |||
SO57046_60 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 517 | 650 | 1 | 2024-02-23 | 126.34 | 3.16 | 2024-02-11 | 4 | 23.37 | 1 | 126.34 | 60 | SO57046 | 2024-02-18 | 10.11 | 93.49 | 31.58 | |||
SO44563_14 | 9AFF-40A9-96 | PO7627161014 | 100 | 286 | 334 | 433 | 1 | 2022-02-23 | 1258.38 | 31.46 | 2022-02-11 | 3 | 413.15 | 1 | 1258.38 | 14 | SO44563 | 2022-02-18 | 100.67 | 1239.44 | 419.46 | |||
SO50218_29 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 427 | 127 | 1 | 2023-08-23 | 837.02 | 20.93 | 2023-08-11 | 4 | 185.82 | 1 | 837.02 | 29 | SO50218 | 2023-08-18 | 66.96 | 743.28 | 209.26 | |||
SO48757_20 | C817-44D2-B4 | PO16588132026 | 100 | 289 | 364 | 146 | 1 | 2023-04-25 | 5831.95 | 145.80 | 2023-04-13 | 9 | 598.44 | 1 | 5831.95 | 20 | SO48757 | 2023-04-20 | 466.56 | 5385.92 | 647.99 | |||
SO46974_21 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 427 | 127 | 1 | 2022-11-23 | 1255.54 | 31.39 | 2022-11-11 | 6 | 185.82 | 1 | 1255.54 | 21 | SO46974 | 2022-11-18 | 100.44 | 1114.92 | 209.26 | |||
SO48385_2 | 753C-4EBE-B8 | PO7946110963 | 100 | 282 | 325 | 438 | 1 | 2023-03-25 | 939.59 | 23.49 | 2023-03-13 | 2 | 486.71 | 1 | 939.59 | 2 | SO48385 | 2023-03-20 | 75.17 | 973.41 | 469.79 | |||
SO67315_12 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 477 | 668 | 1 | 2024-07-24 | 2.99 | 0.07 | 2024-07-12 | 1 | 1.87 | 1 | 2.99 | 12 | SO67315 | 2024-07-19 | 0.24 | 1.87 | 2.99 | |||
SO71925_4 | 9291-44AD-BD | PO3277150701 | 100 | 293 | 545 | 604 | 1 | 2024-09-23 | 24.29 | 0.61 | 2024-09-11 | 1 | 17.98 | 1 | 24.29 | 4 | SO71925 | 2024-09-18 | 1.94 | 17.98 | 24.29 | |||
SO69406_44 | E101-486C-A5 | PO16675181672 | 100 | 293 | 568 | 361 | 1 | 2024-08-23 | 445.41 | 11.14 | 2024-08-11 | 1 | 461.44 | 1 | 445.41 | 44 | SO69406 | 2024-08-18 | 35.63 | 461.44 | 445.41 | |||
SO59066_21 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 566 | 55 | 1 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 21 | SO59066 | 2024-03-19 | 35.63 | 461.44 | 445.41 | |||
SO43909_1 | 9467-4A37-A4 | PO7221199520 | 100 | 289 | 350 | 326 | 1 | 2021-11-23 | 4049.99 | 101.25 | 2021-11-11 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO43909 | 2021-11-18 | 324.00 | 3796.19 | 2024.99 | |||
SO44771_22 | A78D-40A1-9E | PO783176074 | 100 | 286 | 310 | 91 | 1 | 2022-03-25 | 6440.89 | 161.02 | 2022-03-13 | 3 | 2171.29 | 1 | 6440.89 | 22 | SO44771 | 2022-03-20 | 515.27 | 6513.88 | 2146.96 | |||
SO71790_2 | 4C33-40F1-BC | PO17487184338 | 100 | 293 | 225 | 692 | 1 | 2024-09-23 | 5.39 | 0.13 | 2024-09-11 | 1 | 6.92 | 1 | 5.39 | 2 | SO71790 | 2024-09-18 | 0.43 | 6.92 | 5.39 | |||
SO48746_5 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 362 | 506 | 1 | 2023-04-25 | 3688.38 | 92.21 | 2023-04-13 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO48746 | 2023-04-20 | 295.07 | 3317.43 | 1229.46 | |||
SO53500_30 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 560 | 672 | 1 | 2023-12-24 | 3644.55 | 91.11 | 2023-12-12 | 5 | 755.15 | 1 | 3644.55 | 30 | SO53500 | 2023-12-19 | 291.56 | 3775.75 | 728.91 | |||
SO46976_15 | 23E2-4510-88 | PO14558186797 | 100 | 289 | 221 | 2 | 1 | 2022-11-23 | 20.19 | 0.50 | 2022-11-11 | 1 | 13.88 | 1 | 20.19 | 15 | SO46976 | 2022-11-18 | 1.61 | 13.88 | 20.19 | |||
SO67321_17 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 493 | 505 | 1 | 2024-07-24 | 200.05 | 5.00 | 2024-07-12 | 1 | 199.85 | 1 | 200.05 | 17 | SO67321 | 2024-07-19 | 16.00 | 199.85 | 200.05 | |||
SO49844_10 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 435 | 290 | 1 | 2023-07-24 | 1946.72 | 48.67 | 2023-07-12 | 6 | 300.12 | 1 | 1946.72 | 10 | SO49844 | 2023-07-19 | 155.74 | 1800.71 | 324.45 | |||
SO43683_12 | 2299-44F7-95 | PO2552113807 | 100 | 289 | 351 | 506 | 1 | 2021-10-23 | 10124.97 | 253.12 | 2021-10-11 | 5 | 1898.09 | 1 | 10124.97 | 12 | SO43683 | 2021-10-18 | 810.00 | 9490.47 | 2024.99 | |||
SO51127_31 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 517 | 506 | 1 | 2023-10-23 | 94.75 | 2.37 | 2023-10-11 | 3 | 23.37 | 1 | 94.75 | 31 | SO51127 | 2023-10-18 | 7.58 | 70.12 | 31.58 | |||
SO69408_12 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 588 | 236 | 1 | 2024-08-23 | 923.39 | 23.08 | 2024-08-11 | 2 | 419.78 | 1 | 923.39 | 12 | SO69408 | 2024-08-18 | 73.87 | 839.56 | 461.69 | |||
SO45549_1 | E477-44D2-B0 | PO783111978 | 100 | 286 | 338 | 91 | 1 | 2022-06-23 | 838.92 | 20.97 | 2022-06-11 | 2 | 413.15 | 1 | 838.92 | 1 | SO45549 | 2022-06-18 | 67.11 | 826.29 | 419.46 | |||
SO50209_36 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 395 | 487 | 1 | 2023-08-23 | 122.75 | 3.07 | 2023-08-11 | 2 | 45.42 | 1 | 122.75 | 36 | SO50209 | 2023-08-18 | 9.82 | 90.83 | 61.37 | |||
SO51789_35 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 463 | 605 | 1 | 2023-11-23 | 117.55 | 2.94 | 2023-11-11 | 8 | 9.16 | 1 | 117.55 | 35 | SO51789 | 2023-11-18 | 9.40 | 73.27 | 14.69 | |||
SO46032_1 | 3A64-43B4-B5 | PO18676118909 | 100 | 282 | 307 | 697 | 1 | 2022-08-23 | 722.59 | 18.06 | 2022-08-11 | 1 | 623.84 | 1 | 722.59 | 1 | SO46032 | 2022-08-18 | 57.81 | 623.84 | 722.59 | |||
SO44771_18 | A78D-40A1-9E | PO783176074 | 100 | 286 | 232 | 91 | 1 | 2022-03-25 | 57.68 | 1.44 | 2022-03-13 | 2 | 31.72 | 1 | 57.68 | 18 | SO44771 | 2022-03-20 | 4.61 | 63.45 | 28.84 |
Generated 2024-11-10 16:03:56.925 UTC