[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 7187 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO58961_11 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 585 | 182 | 1 | 2024-03-24 | 1336.23 | 33.41 | 2024-03-12 | 3 | 461.44 | 1 | 1336.23 | 11 | SO58961 | 2024-03-19 | 106.90 | 1384.33 | 445.41 | |||
| SO46966_19 | 8FBD-4E87-82 | PO15631150454 | 100 | 282 | 469 | 2 | 43 | 1 | 4.85 | 2022-11-23 | 242.38 | 5.94 | 2022-11-11 | 11 | 15.67 | 1 | 237.53 | 19 | SO46966 | 2022-11-18 | 19.00 | 172.38 | 22.03 | 0.02 |
| 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 | |||
| SO67321_21 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 562 | 505 | 1 | 2024-07-24 | 7152.21 | 178.81 | 2024-07-12 | 5 | 1481.94 | 1 | 7152.21 | 21 | SO67321 | 2024-07-19 | 572.18 | 7409.69 | 1430.44 | |||
| SO44567_1 | A14C-49FF-A8 | PO7917171062 | 100 | 287 | 348 | 401 | 1 | 2022-02-23 | 8099.98 | 202.50 | 2022-02-11 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO44567 | 2022-02-18 | 648.00 | 7592.38 | 2024.99 | |||
| SO53605_6 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 497 | 308 | 1 | 2023-12-24 | 602.35 | 15.06 | 2023-12-12 | 1 | 601.74 | 1 | 602.35 | 6 | SO53605 | 2023-12-19 | 48.19 | 601.74 | 602.35 | |||
| SO48057_40 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 385 | 343 | 1 | 2023-02-23 | 3601.58 | 90.04 | 2023-02-11 | 6 | 605.65 | 1 | 3601.58 | 40 | SO48057 | 2023-02-18 | 288.13 | 3633.90 | 600.26 | |||
| SO51127_3 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 353 | 506 | 1 | 2023-10-23 | 2783.99 | 69.60 | 2023-10-11 | 2 | 1265.62 | 1 | 2783.99 | 3 | SO51127 | 2023-10-18 | 222.72 | 2531.24 | 1391.99 | |||
| SO71835_16 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 565 | 621 | 1 | 2024-09-23 | 2227.05 | 55.68 | 2024-09-11 | 5 | 461.44 | 1 | 2227.05 | 16 | SO71835 | 2024-09-18 | 178.16 | 2307.22 | 445.41 | |||
| SO47986_7 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 454 | 236 | 1 | 2023-02-23 | 143.98 | 3.60 | 2023-02-11 | 4 | 24.75 | 1 | 143.98 | 7 | SO47986 | 2023-02-18 | 11.52 | 98.98 | 35.99 | |||
| SO44492_11 | 8AF8-4DDE-A8 | PO18676158978 | 100 | 282 | 347 | 697 | 1 | 2022-02-23 | 10199.97 | 255.00 | 2022-02-11 | 5 | 1912.15 | 1 | 10199.97 | 11 | SO44492 | 2022-02-18 | 816.00 | 9560.77 | 2039.99 | |||
| SO50314_25 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 422 | 433 | 1 | 2023-08-23 | 270.16 | 6.75 | 2023-08-11 | 4 | 49.98 | 1 | 270.16 | 25 | SO50314 | 2023-08-18 | 21.61 | 199.92 | 67.54 | |||
| SO45338_16 | EA29-4912-A1 | PO7627114520 | 100 | 286 | 311 | 433 | 1 | 2022-05-26 | 6440.89 | 161.02 | 2022-05-14 | 3 | 2171.29 | 1 | 6440.89 | 16 | SO45338 | 2022-05-21 | 515.27 | 6513.88 | 2146.96 | |||
| SO47054_14 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 265 | 433 | 1 | 2022-11-23 | 202.33 | 5.06 | 2022-11-11 | 1 | 187.16 | 1 | 202.33 | 14 | SO47054 | 2022-11-18 | 16.19 | 187.16 | 202.33 | |||
| SO44483_3 | 678B-447B-A1 | PO19981138202 | 100 | 286 | 223 | 271 | 1 | 2022-02-23 | 10.37 | 0.26 | 2022-02-11 | 2 | 5.71 | 1 | 10.37 | 3 | SO44483 | 2022-02-18 | 0.83 | 11.41 | 5.19 | |||
| SO57026_44 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 523 | 361 | 1 | 2024-02-23 | 63.17 | 1.58 | 2024-02-11 | 2 | 23.37 | 1 | 63.17 | 44 | SO57026 | 2024-02-18 | 5.05 | 46.74 | 31.58 | |||
| SO71836_32 | E41E-40C1-84 | PO841118259 | 100 | 286 | 231 | 254 | 1 | 2024-09-23 | 29.99 | 0.75 | 2024-09-11 | 1 | 38.49 | 1 | 29.99 | 32 | SO71836 | 2024-09-18 | 2.40 | 38.49 | 29.99 | |||
| SO50270_5 | A828-45A2-8B | PO18676112371 | 100 | 282 | 352 | 697 | 1 | 2023-08-23 | 8699.96 | 217.50 | 2023-08-11 | 7 | 1117.86 | 1 | 8699.96 | 5 | SO50270 | 2023-08-18 | 696.00 | 7824.99 | 1242.85 | |||
| SO46051_3 | DF61-462A-87 | PO14500186228 | 100 | 282 | 292 | 650 | 1 | 2022-08-23 | 818.70 | 20.47 | 2022-08-11 | 1 | 706.81 | 1 | 818.70 | 3 | SO46051 | 2022-08-18 | 65.50 | 706.81 | 818.70 | |||
| SO49136_20 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 325 | 343 | 1 | 2023-05-26 | 1879.18 | 46.98 | 2023-05-14 | 4 | 486.71 | 1 | 1879.18 | 20 | SO49136 | 2023-05-21 | 150.33 | 1946.83 | 469.79 | |||
| SO44513_3 | A881-41E7-AD | PO14471116260 | 100 | 286 | 215 | 145 | 1 | 2022-02-23 | 141.31 | 3.53 | 2022-02-11 | 7 | 12.03 | 1 | 141.31 | 3 | SO44513 | 2022-02-18 | 11.30 | 84.19 | 20.19 | |||
| SO44501_19 | 4971-4FC0-A3 | PO16646128920 | 100 | 286 | 336 | 1 | 1 | 2022-02-23 | 838.92 | 20.97 | 2022-02-11 | 2 | 413.15 | 1 | 838.92 | 19 | SO44501 | 2022-02-18 | 67.11 | 826.29 | 419.46 | |||
| SO45274_8 | D0B9-4CC5-B8 | PO18676111897 | 100 | 282 | 345 | 697 | 1 | 2022-05-26 | 8159.98 | 204.00 | 2022-05-14 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO45274 | 2022-05-21 | 652.80 | 7648.62 | 2039.99 | |||
| SO51826_11 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 553 | 693 | 1 | 2023-11-23 | 27.65 | 0.69 | 2023-11-11 | 1 | 20.46 | 1 | 27.65 | 11 | SO51826 | 2023-11-18 | 2.21 | 20.46 | 27.65 | |||
| SO50218_14 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 362 | 127 | 1 | 2023-08-23 | 1229.46 | 30.74 | 2023-08-11 | 1 | 1105.81 | 1 | 1229.46 | 14 | SO50218 | 2023-08-18 | 98.36 | 1105.81 | 1229.46 | |||
| SO51789_41 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 490 | 605 | 1 | 2023-11-23 | 291.55 | 7.29 | 2023-11-11 | 9 | 41.57 | 1 | 291.55 | 41 | SO51789 | 2023-11-18 | 23.32 | 374.15 | 32.39 | |||
| SO51783_14 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 516 | 697 | 1 | 2023-11-23 | 46.97 | 1.17 | 2023-11-11 | 2 | 17.38 | 1 | 46.97 | 14 | SO51783 | 2023-11-18 | 3.76 | 34.76 | 23.48 | |||
| SO51712_22 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 573 | 361 | 1 | 2023-11-23 | 1430.44 | 35.76 | 2023-11-11 | 1 | 1481.94 | 1 | 1430.44 | 22 | SO51712 | 2023-11-18 | 114.44 | 1481.94 | 1430.44 | |||
| SO51789_8 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 507 | 605 | 1 | 2023-11-23 | 200.05 | 5.00 | 2023-11-11 | 1 | 199.85 | 1 | 200.05 | 8 | SO51789 | 2023-11-18 | 16.00 | 199.85 | 200.05 | |||
| SO57026_14 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 483 | 361 | 1 | 2024-02-23 | 648.00 | 16.20 | 2024-02-11 | 9 | 44.88 | 1 | 648.00 | 14 | SO57026 | 2024-02-18 | 51.84 | 403.92 | 72.00 | |||
| SO71812_5 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 306 | 293 | 1 | 2024-09-23 | 809.76 | 20.24 | 2024-09-11 | 1 | 739.04 | 1 | 809.76 | 5 | SO71812 | 2024-09-18 | 64.78 | 739.04 | 809.76 | |||
| SO47666_17 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 362 | 2 | 146 | 1 | 285.23 | 2023-01-23 | 14261.72 | 349.41 | 2023-01-11 | 12 | 1105.81 | 1 | 13976.49 | 17 | SO47666 | 2023-01-18 | 1118.12 | 13269.72 | 1188.48 | 0.02 |
| SO50321_23 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 335 | 218 | 1 | 2023-08-23 | 939.59 | 23.49 | 2023-08-11 | 2 | 486.71 | 1 | 939.59 | 23 | SO50321 | 2023-08-18 | 75.17 | 973.41 | 469.79 | |||
| SO51721_70 | 9429-430D-89 | PO14500124798 | 100 | 282 | 517 | 650 | 1 | 2023-11-23 | 63.17 | 1.58 | 2023-11-11 | 2 | 23.37 | 1 | 63.17 | 70 | SO51721 | 2023-11-18 | 5.05 | 46.74 | 31.58 | |||
| SO46052_9 | 347B-49F0-A8 | PO14529158983 | 100 | 286 | 345 | 289 | 1 | 2022-08-23 | 2039.99 | 51.00 | 2022-08-11 | 1 | 1912.15 | 1 | 2039.99 | 9 | SO46052 | 2022-08-18 | 163.20 | 1912.15 | 2039.99 | |||
| SO69508_13 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 214 | 433 | 1 | 2024-08-23 | 146.96 | 3.67 | 2024-08-11 | 7 | 13.09 | 1 | 146.96 | 13 | SO69508 | 2024-08-18 | 11.76 | 91.60 | 20.99 | |||
| SO44312_4 | 7FAE-402E-A5 | PO5075136657 | 100 | 289 | 332 | 344 | 1 | 2022-01-23 | 838.92 | 20.97 | 2022-01-11 | 2 | 413.15 | 1 | 838.92 | 4 | SO44312 | 2022-01-18 | 67.11 | 826.29 | 419.46 | |||
| SO45295_2 | 113A-4330-B0 | PO14529163242 | 100 | 286 | 345 | 289 | 1 | 2022-05-26 | 2039.99 | 51.00 | 2022-05-14 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO45295 | 2022-05-21 | 163.20 | 1912.15 | 2039.99 | |||
| SO55241_28 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 533 | 146 | 1 | 2024-01-23 | 449.62 | 11.24 | 2024-01-11 | 3 | 136.79 | 1 | 449.62 | 28 | SO55241 | 2024-01-18 | 35.97 | 410.36 | 149.87 | |||
| SO49849_1 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 362 | 506 | 1 | 2023-07-24 | 2458.92 | 61.47 | 2023-07-12 | 2 | 1105.81 | 1 | 2458.92 | 1 | SO49849 | 2023-07-19 | 196.71 | 2211.62 | 1229.46 | |||
| SO46609_1 | 87E3-4F5C-AC | PO17458117152 | 100 | 286 | 242 | 577 | 1 | 2022-10-23 | 1561.64 | 39.04 | 2022-10-11 | 2 | 722.26 | 1 | 1561.64 | 1 | SO46609 | 2022-10-18 | 124.93 | 1444.51 | 780.82 | |||
| SO51148_35 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 225 | 110 | 1 | 2023-10-23 | 5.39 | 0.13 | 2023-10-11 | 1 | 6.92 | 1 | 5.39 | 35 | SO51148 | 2023-10-18 | 0.43 | 6.92 | 5.39 | |||
| SO47387_3 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 360 | 293 | 1 | 2022-12-24 | 2458.92 | 61.47 | 2022-12-12 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO47387 | 2022-12-19 | 196.71 | 2211.62 | 1229.46 | |||
| SO58963_33 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 551 | 254 | 1 | 2024-03-24 | 475.29 | 11.88 | 2024-03-12 | 3 | 144.59 | 1 | 475.29 | 33 | SO58963 | 2024-03-19 | 38.02 | 433.78 | 158.43 | |||
| SO51145_12 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 605 | 668 | 1 | 2023-10-23 | 971.98 | 24.30 | 2023-10-11 | 3 | 343.65 | 1 | 971.98 | 12 | SO51145 | 2023-10-18 | 77.76 | 1030.95 | 323.99 | |||
| SO53467_3 | BE84-4F9B-8E | PO17487177251 | 100 | 293 | 545 | 692 | 1 | 2023-12-24 | 24.29 | 0.61 | 2023-12-12 | 1 | 17.98 | 1 | 24.29 | 3 | SO53467 | 2023-12-19 | 1.94 | 17.98 | 24.29 | |||
| SO57046_58 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 488 | 650 | 1 | 2024-02-23 | 129.58 | 3.24 | 2024-02-11 | 4 | 41.57 | 1 | 129.58 | 58 | SO57046 | 2024-02-18 | 10.37 | 166.29 | 32.39 | |||
| SO59021_9 | A306-4E83-B7 | PO7395154426 | 100 | 286 | 355 | 542 | 1 | 2024-03-24 | 8351.96 | 208.80 | 2024-03-12 | 6 | 1265.62 | 1 | 8351.96 | 9 | SO59021 | 2024-03-19 | 668.16 | 7593.72 | 1391.99 | |||
| SO47699_1 | 07B7-4742-A7 | PO2581192932 | 100 | 282 | 329 | 698 | 1 | 2023-01-23 | 939.59 | 23.49 | 2023-01-11 | 2 | 486.71 | 1 | 939.59 | 1 | SO47699 | 2023-01-18 | 75.17 | 973.41 | 469.79 | |||
| SO69408_24 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 533 | 236 | 1 | 2024-08-23 | 299.75 | 7.49 | 2024-08-11 | 2 | 136.79 | 1 | 299.75 | 24 | SO69408 | 2024-08-18 | 23.98 | 273.57 | 149.87 | |||
| SO50321_30 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 327 | 218 | 1 | 2023-08-23 | 1409.38 | 35.23 | 2023-08-11 | 3 | 486.71 | 1 | 1409.38 | 30 | SO50321 | 2023-08-18 | 112.75 | 1460.12 | 469.79 | |||
| SO67322_16 | 1881-4634-82 | PO6612121393 | 100 | 286 | 560 | 110 | 1 | 2024-07-24 | 3644.55 | 91.11 | 2024-07-12 | 5 | 755.15 | 1 | 3644.55 | 16 | SO67322 | 2024-07-19 | 291.56 | 3775.75 | 728.91 | |||
| SO47992_45 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 289 | 487 | 1 | 2023-02-23 | 744.27 | 18.61 | 2023-02-11 | 1 | 660.91 | 1 | 744.27 | 45 | SO47992 | 2023-02-18 | 59.54 | 660.91 | 744.27 | |||
| SO50754_5 | 5AA5-4CCE-B6 | PO7946158767 | 100 | 282 | 343 | 438 | 1 | 2023-09-23 | 1879.18 | 46.98 | 2023-09-11 | 4 | 486.71 | 1 | 1879.18 | 5 | SO50754 | 2023-09-18 | 150.33 | 1946.83 | 469.79 | |||
| SO50206_37 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 366 | 236 | 1 | 2023-08-23 | 2591.98 | 64.80 | 2023-08-11 | 4 | 598.44 | 1 | 2591.98 | 37 | SO50206 | 2023-08-18 | 207.36 | 2393.74 | 647.99 | |||
| SO71835_1 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 496 | 621 | 1 | 2024-09-23 | 602.35 | 15.06 | 2024-09-11 | 1 | 601.74 | 1 | 602.35 | 1 | SO71835 | 2024-09-18 | 48.19 | 601.74 | 602.35 | |||
| SO71904_3 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 560 | 308 | 1 | 2024-09-23 | 728.91 | 18.22 | 2024-09-11 | 1 | 755.15 | 1 | 728.91 | 3 | SO71904 | 2024-09-18 | 58.31 | 755.15 | 728.91 | |||
| SO69525_3 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 388 | 343 | 1 | 2024-08-23 | 3361.47 | 84.04 | 2024-08-11 | 5 | 713.08 | 1 | 3361.47 | 3 | SO69525 | 2024-08-18 | 268.92 | 3565.40 | 672.29 | |||
| SO71835_10 | EBBF-4B16-99 | PO870120974 | 100 | 286 | 499 | 621 | 1 | 2024-09-23 | 1807.04 | 45.18 | 2024-09-11 | 3 | 601.74 | 1 | 1807.04 | 10 | SO71835 | 2024-09-18 | 144.56 | 1805.23 | 602.35 | |||
| 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 | |||
| SO58946_18 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 506 | 672 | 1 | 2024-03-24 | 200.05 | 5.00 | 2024-03-12 | 1 | 199.85 | 1 | 200.05 | 18 | SO58946 | 2024-03-19 | 16.00 | 199.85 | 200.05 | |||
| SO48057_19 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 460 | 343 | 1 | 2023-02-23 | 269.97 | 6.75 | 2023-02-11 | 5 | 37.12 | 1 | 269.97 | 19 | SO48057 | 2023-02-18 | 21.60 | 185.60 | 53.99 |
Generated 2024-11-10 05:01:56.077 UTC