[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6874 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44308_4 | 49A4-4845-B2 | PO2552158889 | 100 | 289 | 235 | 506 | 1 | 2022-01-27 | 28.84 | 0.72 | 2022-01-15 | 1 | 31.72 | 1 | 28.84 | 4 | SO44308 | 2022-01-22 | 2.31 | 31.72 | 28.84 | |||
SO46974_52 | BEE6-4EC8-8E | PO14442112586 | 100 | 286 | 289 | 127 | 1 | 2022-11-27 | 1488.55 | 37.21 | 2022-11-15 | 2 | 660.91 | 1 | 1488.55 | 52 | SO46974 | 2022-11-22 | 119.08 | 1321.83 | 744.27 | |||
SO71836_3 | E41E-40C1-84 | PO841118259 | 100 | 286 | 512 | 254 | 1 | 2024-09-27 | 436.91 | 10.92 | 2024-09-15 | 2 | 199.38 | 1 | 436.91 | 3 | SO71836 | 2024-09-22 | 34.95 | 398.75 | 218.45 | |||
SO44511_3 | 4BD6-4CFA-B8 | PO14529113218 | 100 | 286 | 345 | 289 | 1 | 2022-02-27 | 2039.99 | 51.00 | 2022-02-15 | 1 | 1912.15 | 1 | 2039.99 | 3 | SO44511 | 2022-02-22 | 163.20 | 1912.15 | 2039.99 | |||
SO48057_50 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 213 | 343 | 1 | 2023-02-27 | 121.12 | 3.03 | 2023-02-15 | 6 | 13.88 | 1 | 121.12 | 50 | SO48057 | 2023-02-22 | 9.69 | 83.27 | 20.19 | |||
SO53500_14 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 496 | 672 | 1 | 2023-12-28 | 4216.42 | 105.41 | 2023-12-16 | 7 | 601.74 | 1 | 4216.42 | 14 | SO53500 | 2023-12-23 | 337.31 | 4212.21 | 602.35 | |||
SO61195_28 | 0AF4-457F-9C | PO899113333 | 100 | 289 | 234 | 290 | 1 | 2024-04-28 | 89.98 | 2.25 | 2024-04-16 | 3 | 38.49 | 1 | 89.98 | 28 | SO61195 | 2024-04-23 | 7.20 | 115.48 | 29.99 | |||
SO69422_4 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 532 | 650 | 1 | 2024-08-27 | 899.24 | 22.48 | 2024-08-15 | 6 | 136.79 | 1 | 899.24 | 4 | SO69422 | 2024-08-22 | 71.94 | 820.71 | 149.87 | |||
SO53500_16 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 575 | 672 | 1 | 2023-12-28 | 1430.44 | 35.76 | 2023-12-16 | 1 | 1481.94 | 1 | 1430.44 | 16 | SO53500 | 2023-12-23 | 114.44 | 1481.94 | 1430.44 | |||
SO49849_22 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 352 | 506 | 1 | 2023-07-28 | 4971.41 | 124.29 | 2023-07-16 | 4 | 1117.86 | 1 | 4971.41 | 22 | SO49849 | 2023-07-23 | 397.71 | 4471.42 | 1242.85 | |||
SO43664_6 | 2F44-4BA1-BB | PO16617121983 | 100 | 286 | 344 | 397 | 1 | 2021-10-27 | 6119.98 | 153.00 | 2021-10-15 | 3 | 1912.15 | 1 | 6119.98 | 6 | SO43664 | 2021-10-22 | 489.60 | 5736.46 | 2039.99 | |||
SO49092_30 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 224 | 127 | 1 | 2023-05-30 | 46.68 | 1.17 | 2023-05-18 | 9 | 5.23 | 1 | 46.68 | 30 | SO49092 | 2023-05-25 | 3.73 | 47.07 | 5.19 | |||
SO71904_2 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 523 | 308 | 1 | 2024-09-27 | 94.75 | 2.37 | 2024-09-15 | 3 | 23.37 | 1 | 94.75 | 2 | SO71904 | 2024-09-22 | 7.58 | 70.12 | 31.58 | |||
SO49850_9 | CBD2-4015-97 | PO2929118431 | 100 | 289 | 469 | 380 | 1 | 2023-07-28 | 45.59 | 1.14 | 2023-07-16 | 2 | 15.67 | 1 | 45.59 | 9 | SO49850 | 2023-07-23 | 3.65 | 31.34 | 22.79 | |||
SO45542_5 | A757-4830-AE | PO13543153598 | 100 | 287 | 351 | 293 | 1 | 2022-06-27 | 6074.98 | 151.87 | 2022-06-15 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO45542 | 2022-06-22 | 486.00 | 5694.28 | 2024.99 | |||
SO46327_11 | 62A7-4A24-82 | PO19169130329 | 100 | 289 | 344 | 7 | 272 | 1 | 595.00 | 2022-09-27 | 1700.00 | 27.62 | 2022-09-15 | 2 | 1912.15 | 1 | 1105.00 | 11 | SO46327 | 2022-09-22 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO57099_12 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 217 | 2 | 605 | 1 | 4.87 | 2024-02-27 | 243.53 | 5.97 | 2024-02-15 | 12 | 13.09 | 1 | 238.66 | 12 | SO57099 | 2024-02-22 | 19.09 | 157.04 | 20.29 | 0.02 |
SO49167_1 | 5A78-4DE2-89 | PO8816115193 | 100 | 289 | 371 | 218 | 1 | 2023-05-30 | 2617.88 | 65.45 | 2023-05-18 | 2 | 1320.68 | 1 | 2617.88 | 1 | SO49167 | 2023-05-25 | 209.43 | 2641.37 | 1308.94 | |||
SO69475_43 | F74A-4967-BA | PO18618162557 | 100 | 286 | 491 | 605 | 1 | 2024-08-27 | 161.97 | 4.05 | 2024-08-15 | 5 | 41.57 | 1 | 161.97 | 43 | SO69475 | 2024-08-22 | 12.96 | 207.86 | 32.39 | |||
SO53578_4 | 55BE-495E-B7 | PO7946144630 | 100 | 282 | 547 | 438 | 1 | 2023-12-28 | 291.56 | 7.29 | 2023-12-16 | 6 | 35.96 | 1 | 291.56 | 4 | SO53578 | 2023-12-23 | 23.33 | 215.76 | 48.59 | |||
SO46647_2 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 453 | 506 | 1 | 2022-10-27 | 143.98 | 3.60 | 2022-10-15 | 4 | 24.75 | 1 | 143.98 | 2 | SO46647 | 2022-10-22 | 11.52 | 98.98 | 35.99 | |||
SO53518_56 | 5712-444B-BC | PO841197199 | 100 | 286 | 598 | 254 | 1 | 2023-12-28 | 647.99 | 16.20 | 2023-12-16 | 2 | 294.58 | 1 | 647.99 | 56 | SO53518 | 2023-12-23 | 51.84 | 589.16 | 323.99 | |||
SO44561_4 | C323-4470-8B | PO7221158411 | 100 | 289 | 292 | 326 | 1 | 2022-02-27 | 1637.40 | 40.94 | 2022-02-15 | 2 | 706.81 | 1 | 1637.40 | 4 | SO44561 | 2022-02-22 | 130.99 | 1413.62 | 818.70 | |||
SO55299_13 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 569 | 110 | 1 | 2024-01-27 | 1336.23 | 33.41 | 2024-01-15 | 3 | 461.44 | 1 | 1336.23 | 13 | SO55299 | 2024-01-22 | 106.90 | 1384.33 | 445.41 | |||
SO53514_4 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 523 | 182 | 1 | 2023-12-28 | 94.75 | 2.37 | 2023-12-16 | 3 | 23.37 | 1 | 94.75 | 4 | SO53514 | 2023-12-23 | 7.58 | 70.12 | 31.58 | |||
SO47443_7 | DDB8-4FAB-92 | PO7192110823 | 100 | 289 | 458 | 20 | 1 | 2022-12-28 | 224.97 | 5.62 | 2022-12-16 | 5 | 30.93 | 1 | 224.97 | 7 | SO47443 | 2022-12-23 | 18.00 | 154.67 | 44.99 | |||
SO49136_13 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 216 | 343 | 1 | 2023-05-30 | 60.56 | 1.51 | 2023-05-18 | 3 | 13.88 | 1 | 60.56 | 13 | SO49136 | 2023-05-25 | 4.84 | 41.63 | 20.19 | |||
SO67294_25 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 465 | 290 | 1 | 2024-07-28 | 88.16 | 2.20 | 2024-07-16 | 6 | 9.16 | 1 | 88.16 | 25 | SO67294 | 2024-07-23 | 7.05 | 54.96 | 14.69 | |||
SO50270_9 | A828-45A2-8B | PO18676112371 | 100 | 282 | 428 | 697 | 1 | 2023-08-27 | 1255.54 | 31.39 | 2023-08-15 | 6 | 185.82 | 1 | 1255.54 | 9 | SO50270 | 2023-08-22 | 100.44 | 1114.92 | 209.26 | |||
SO57160_8 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 374 | 343 | 1 | 2024-02-27 | 1466.01 | 36.65 | 2024-02-15 | 1 | 1554.95 | 1 | 1466.01 | 8 | SO57160 | 2024-02-22 | 117.28 | 1554.95 | 1466.01 | |||
SO46052_1 | 347B-49F0-A8 | PO14529158983 | 100 | 286 | 218 | 289 | 1 | 2022-08-27 | 17.10 | 0.43 | 2022-08-15 | 3 | 3.40 | 1 | 17.10 | 1 | SO46052 | 2022-08-22 | 1.37 | 10.19 | 5.70 | |||
SO44075_4 | 2920-4332-89 | PO20155139653 | 100 | 289 | 351 | 92 | 1 | 2021-12-28 | 4049.99 | 101.25 | 2021-12-16 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO44075 | 2021-12-23 | 324.00 | 3796.19 | 2024.99 | |||
SO61195_13 | 0AF4-457F-9C | PO899113333 | 100 | 289 | 231 | 290 | 1 | 2024-04-28 | 89.98 | 2.25 | 2024-04-16 | 3 | 38.49 | 1 | 89.98 | 13 | SO61195 | 2024-04-23 | 7.20 | 115.48 | 29.99 | |||
SO53493_30 | F767-491F-84 | PO13543118174 | 100 | 287 | 601 | 293 | 1 | 2023-12-28 | 32.39 | 0.81 | 2023-12-16 | 1 | 23.97 | 1 | 32.39 | 30 | SO53493 | 2023-12-23 | 2.59 | 23.97 | 32.39 | |||
SO53569_6 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 586 | 13 | 55 | 1 | 50.11 | 2023-12-28 | 334.06 | 7.10 | 2023-12-16 | 1 | 461.44 | 1 | 283.95 | 6 | SO53569 | 2023-12-23 | 22.72 | 461.44 | 334.06 | 0.15 |
SO69508_23 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 491 | 433 | 1 | 2024-08-27 | 97.18 | 2.43 | 2024-08-15 | 3 | 41.57 | 1 | 97.18 | 23 | SO69508 | 2024-08-22 | 7.77 | 124.72 | 32.39 | |||
SO47666_3 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 352 | 146 | 1 | 2023-01-27 | 11185.67 | 279.64 | 2023-01-15 | 9 | 1117.86 | 1 | 11185.67 | 3 | SO47666 | 2023-01-22 | 894.85 | 10060.70 | 1242.85 | |||
SO51728_11 | 5481-42D0-8C | PO14558119777 | 100 | 289 | 484 | 2 | 1 | 2023-11-27 | 19.08 | 0.48 | 2023-11-15 | 4 | 2.97 | 1 | 19.08 | 11 | SO51728 | 2023-11-22 | 1.53 | 11.89 | 4.77 | |||
SO63149_24 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 298 | 236 | 1 | 2024-05-29 | 5668.32 | 141.71 | 2024-05-17 | 7 | 739.04 | 1 | 5668.32 | 24 | SO63149 | 2024-05-24 | 453.47 | 5173.29 | 809.76 | |||
SO48057_20 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 456 | 343 | 1 | 2023-02-27 | 269.96 | 6.75 | 2023-02-15 | 6 | 30.93 | 1 | 269.96 | 20 | SO48057 | 2023-02-22 | 21.60 | 185.60 | 44.99 | |||
SO71904_11 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 492 | 308 | 1 | 2024-09-27 | 602.35 | 15.06 | 2024-09-15 | 1 | 601.74 | 1 | 602.35 | 11 | SO71904 | 2024-09-22 | 48.19 | 601.74 | 602.35 | |||
SO69529_2 | D890-4BC3-89 | PO5046186347 | 100 | 289 | 588 | 596 | 1 | 2024-08-27 | 1385.08 | 34.63 | 2024-08-15 | 3 | 419.78 | 1 | 1385.08 | 2 | SO69529 | 2024-08-22 | 110.81 | 1259.34 | 461.69 | |||
SO53514_11 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 559 | 182 | 1 | 2023-12-28 | 97.15 | 2.43 | 2023-12-16 | 8 | 8.99 | 1 | 97.15 | 11 | SO53514 | 2023-12-23 | 7.77 | 71.89 | 12.14 | |||
SO59010_12 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 517 | 109 | 1 | 2024-03-28 | 31.58 | 0.79 | 2024-03-16 | 1 | 23.37 | 1 | 31.58 | 12 | SO59010 | 2024-03-23 | 2.53 | 23.37 | 31.58 | |||
SO46957_6 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 410 | 236 | 1 | 2022-11-27 | 364.47 | 9.11 | 2022-11-15 | 10 | 26.97 | 1 | 364.47 | 6 | SO46957 | 2022-11-22 | 29.16 | 269.71 | 36.45 | |||
SO55295_7 | 7757-4CE3-A1 | PO7105140110 | 100 | 293 | 580 | 668 | 1 | 2024-01-27 | 4082.38 | 102.06 | 2024-01-15 | 4 | 1082.51 | 1 | 4082.38 | 7 | SO55295 | 2024-01-22 | 326.59 | 4330.04 | 1020.59 | |||
SO51721_23 | 9429-430D-89 | PO14500124798 | 100 | 282 | 353 | 650 | 1 | 2023-11-27 | 12527.95 | 313.20 | 2023-11-15 | 9 | 1265.62 | 1 | 12527.95 | 23 | SO51721 | 2023-11-22 | 1002.24 | 11390.58 | 1391.99 | |||
SO46976_7 | 23E2-4510-88 | PO14558186797 | 100 | 289 | 468 | 2 | 1 | 2022-11-27 | 68.38 | 1.71 | 2022-11-15 | 3 | 15.67 | 1 | 68.38 | 7 | SO46976 | 2022-11-22 | 5.47 | 47.01 | 22.79 | |||
SO47403_44 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 308 | 254 | 1 | 2022-12-28 | 2977.09 | 74.43 | 2022-12-16 | 4 | 660.91 | 1 | 2977.09 | 44 | SO47403 | 2022-12-23 | 238.17 | 2643.66 | 744.27 | |||
SO47057_16 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 410 | 401 | 1 | 2022-11-27 | 109.34 | 2.73 | 2022-11-15 | 3 | 26.97 | 1 | 109.34 | 16 | SO47057 | 2022-11-22 | 8.75 | 80.91 | 36.45 | |||
SO45320_1 | D132-4E84-8E | PO2958131179 | 100 | 286 | 350 | 559 | 1 | 2022-05-30 | 2024.99 | 50.62 | 2022-05-18 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO45320 | 2022-05-25 | 162.00 | 1898.09 | 2024.99 | |||
SO57036_14 | A71E-4FC0-8D | PO15631137127 | 100 | 282 | 357 | 43 | 1 | 2024-02-27 | 6959.97 | 174.00 | 2024-02-15 | 5 | 1265.62 | 1 | 6959.97 | 14 | SO57036 | 2024-02-22 | 556.80 | 6328.10 | 1391.99 | |||
SO44109_9 | 1055-4F53-BB | PO783112882 | 100 | 286 | 315 | 91 | 1 | 2021-12-28 | 1749.59 | 43.74 | 2021-12-16 | 2 | 884.71 | 1 | 1749.59 | 9 | SO44109 | 2021-12-23 | 139.97 | 1769.42 | 874.79 | |||
SO53493_12 | F767-491F-84 | PO13543118174 | 100 | 287 | 552 | 293 | 1 | 2023-12-28 | 109.79 | 2.74 | 2023-12-16 | 2 | 40.62 | 1 | 109.79 | 12 | SO53493 | 2023-12-23 | 8.78 | 81.24 | 54.89 | |||
SO51726_8 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 554 | 199 | 1 | 2023-11-27 | 109.88 | 2.75 | 2023-11-15 | 2 | 40.66 | 1 | 109.88 | 8 | SO51726 | 2023-11-22 | 8.79 | 81.31 | 54.94 | |||
SO59066_24 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 554 | 55 | 1 | 2024-03-28 | 164.83 | 4.12 | 2024-03-16 | 3 | 40.66 | 1 | 164.83 | 24 | SO59066 | 2024-03-23 | 13.19 | 121.97 | 54.94 | |||
SO50321_15 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 381 | 218 | 1 | 2023-08-27 | 1200.53 | 30.01 | 2023-08-15 | 2 | 605.65 | 1 | 1200.53 | 15 | SO50321 | 2023-08-22 | 96.04 | 1211.30 | 600.26 | |||
SO58962_29 | 12B1-4451-9A | PO870180310 | 100 | 286 | 576 | 621 | 1 | 2024-03-28 | 2860.88 | 71.52 | 2024-03-16 | 2 | 1481.94 | 1 | 2860.88 | 29 | SO58962 | 2024-03-23 | 228.87 | 2963.88 | 1430.44 | |||
SO44312_4 | 7FAE-402E-A5 | PO5075136657 | 100 | 289 | 332 | 344 | 1 | 2022-01-27 | 838.92 | 20.97 | 2022-01-15 | 2 | 413.15 | 1 | 838.92 | 4 | SO44312 | 2022-01-22 | 67.11 | 826.29 | 419.46 | |||
SO48741_17 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 271 | 290 | 1 | 2023-04-29 | 607.00 | 15.17 | 2023-04-17 | 3 | 187.16 | 1 | 607.00 | 17 | SO48741 | 2023-04-24 | 48.56 | 561.47 | 202.33 | |||
SO47054_32 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 371 | 433 | 1 | 2022-11-27 | 1308.94 | 32.72 | 2022-11-15 | 1 | 1320.68 | 1 | 1308.94 | 32 | SO47054 | 2022-11-22 | 104.72 | 1320.68 | 1308.94 | |||
SO43671_3 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 317 | 200 | 1 | 2021-10-27 | 874.79 | 21.87 | 2021-10-15 | 1 | 884.71 | 1 | 874.79 | 3 | SO43671 | 2021-10-22 | 69.98 | 884.71 | 874.79 |
Generated 2024-11-14 04:46:12.249 UTC