[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 625 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49101_5 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 393 | 487 | 1 | 2023-04-21 | 413.08 | 10.33 | 2023-04-09 | 3 | 101.89 | 1 | 413.08 | 5 | SO49101 | 2023-04-16 | 33.05 | 305.68 | 137.69 | |||
SO58904_1 | 6137-4F2B-89 | PO20097116051 | 100 | 289 | 418 | 128 | 1 | 2024-02-18 | 713.80 | 17.84 | 2024-02-06 | 2 | 360.94 | 1 | 713.80 | 1 | SO58904 | 2024-02-13 | 57.10 | 721.89 | 356.90 | |||
SO46957_5 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 453 | 236 | 1 | 2022-10-19 | 359.94 | 9.00 | 2022-10-07 | 10 | 24.75 | 1 | 359.94 | 5 | SO46957 | 2022-10-14 | 28.80 | 247.46 | 35.99 | |||
SO57176_3 | 6881-42A1-B6 | PO7917176909 | 100 | 287 | 471 | 401 | 1 | 2024-01-19 | 76.20 | 1.91 | 2024-01-07 | 2 | 23.75 | 1 | 76.20 | 3 | SO57176 | 2024-01-14 | 6.10 | 47.50 | 38.10 | |||
SO50209_1 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 396 | 487 | 1 | 2023-07-19 | 74.84 | 1.87 | 2023-07-07 | 1 | 55.38 | 1 | 74.84 | 1 | SO50209 | 2023-07-14 | 5.99 | 55.38 | 74.84 | |||
SO47698_21 | 3841-4995-8C | PO2552129685 | 100 | 286 | 352 | 506 | 1 | 2022-12-19 | 6214.26 | 155.36 | 2022-12-07 | 5 | 1117.86 | 1 | 6214.26 | 21 | SO47698 | 2022-12-14 | 497.14 | 5589.28 | 1242.85 | |||
SO51127_4 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 587 | 506 | 1 | 2023-09-18 | 1385.08 | 34.63 | 2023-09-06 | 3 | 419.78 | 1 | 1385.08 | 4 | SO51127 | 2023-09-13 | 110.81 | 1259.34 | 461.69 | |||
SO47403_49 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 365 | 254 | 1 | 2022-11-19 | 1943.98 | 48.60 | 2022-11-07 | 3 | 598.44 | 1 | 1943.98 | 49 | SO47403 | 2022-11-14 | 155.52 | 1795.31 | 647.99 | |||
SO50209_17 | D138-4E7C-86 | PO15573136083 | 100 | 293 | 458 | 487 | 1 | 2023-07-19 | 359.95 | 9.00 | 2023-07-07 | 8 | 30.93 | 1 | 359.95 | 17 | SO50209 | 2023-07-14 | 28.80 | 247.47 | 44.99 | |||
SO47992_31 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 457 | 487 | 1 | 2023-01-19 | 134.98 | 3.37 | 2023-01-07 | 3 | 30.93 | 1 | 134.98 | 31 | SO47992 | 2023-01-14 | 10.80 | 92.80 | 44.99 | |||
SO71886_39 | AE34-4CC5-9B | PO6815136550 | 100 | 293 | 544 | 109 | 1 | 2024-08-19 | 48.59 | 1.21 | 2024-08-07 | 1 | 35.96 | 1 | 48.59 | 39 | SO71886 | 2024-08-14 | 3.89 | 35.96 | 48.59 | |||
SO46053_10 | E530-47A7-9A | PO14471143194 | 100 | 286 | 212 | 145 | 1 | 2022-07-19 | 40.37 | 1.01 | 2022-07-07 | 2 | 12.03 | 1 | 40.37 | 10 | SO46053 | 2022-07-14 | 3.23 | 24.06 | 20.19 | |||
SO65200_24 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 527 | 254 | 1 | 2024-05-19 | 792.15 | 19.80 | 2024-05-07 | 5 | 144.59 | 1 | 792.15 | 24 | SO65200 | 2024-05-14 | 63.37 | 722.97 | 158.43 | |||
SO71880_8 | B0C7-4858-91 | PO7395117544 | 100 | 286 | 298 | 542 | 1 | 2024-08-19 | 809.76 | 20.24 | 2024-08-07 | 1 | 739.04 | 1 | 809.76 | 8 | SO71880 | 2024-08-14 | 64.78 | 739.04 | 809.76 | |||
SO45318_3 | 13CE-461F-B9 | PO2900174093 | 100 | 286 | 293 | 469 | 1 | 2022-04-21 | 1445.19 | 36.13 | 2022-04-09 | 2 | 623.84 | 1 | 1445.19 | 3 | SO45318 | 2022-04-16 | 115.62 | 1247.68 | 722.59 | |||
SO46972_7 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 469 | 650 | 1 | 2022-10-19 | 45.59 | 1.14 | 2022-10-07 | 2 | 15.67 | 1 | 45.59 | 7 | SO46972 | 2022-10-14 | 3.65 | 31.34 | 22.79 | |||
SO49095_6 | EDD6-411E-A3 | PO18676116817 | 100 | 282 | 460 | 697 | 1 | 2023-04-21 | 161.98 | 4.05 | 2023-04-09 | 3 | 37.12 | 1 | 161.98 | 6 | SO49095 | 2023-04-16 | 12.96 | 111.36 | 53.99 | |||
SO69475_4 | F74A-4967-BA | PO18618162557 | 100 | 286 | 579 | 605 | 1 | 2024-07-19 | 2186.73 | 54.67 | 2024-07-07 | 3 | 755.15 | 1 | 2186.73 | 4 | SO69475 | 2024-07-14 | 174.94 | 2265.45 | 728.91 | |||
SO57026_15 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 484 | 361 | 1 | 2024-01-19 | 42.93 | 1.07 | 2024-01-07 | 9 | 2.97 | 1 | 42.93 | 15 | SO57026 | 2024-01-14 | 3.43 | 26.76 | 4.77 | |||
SO47443_8 | DDB8-4FAB-92 | PO7192110823 | 100 | 289 | 213 | 20 | 1 | 2022-11-19 | 20.19 | 0.50 | 2022-11-07 | 1 | 13.88 | 1 | 20.19 | 8 | SO47443 | 2022-11-14 | 1.61 | 13.88 | 20.19 | |||
SO47986_37 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 410 | 236 | 1 | 2023-01-19 | 182.24 | 4.56 | 2023-01-07 | 5 | 26.97 | 1 | 182.24 | 37 | SO47986 | 2023-01-14 | 14.58 | 134.85 | 36.45 | |||
SO61182_1 | C1B1-4DBF-A9 | PO16588179661 | 100 | 289 | 592 | 146 | 1 | 2024-03-20 | 338.99 | 8.47 | 2024-03-08 | 1 | 308.22 | 1 | 338.99 | 1 | SO61182 | 2024-03-15 | 27.12 | 308.22 | 338.99 | |||
SO43911_14 | EB9C-47A4-AC | PO7627190040 | 100 | 286 | 342 | 433 | 1 | 2021-10-19 | 838.92 | 20.97 | 2021-10-07 | 2 | 413.15 | 1 | 838.92 | 14 | SO43911 | 2021-10-14 | 67.11 | 826.29 | 419.46 | |||
SO51711_55 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 361 | 236 | 1 | 2023-10-19 | 11015.95 | 275.40 | 2023-10-07 | 8 | 1251.98 | 1 | 11015.95 | 55 | SO51711 | 2023-10-14 | 881.28 | 10015.85 | 1376.99 | |||
SO48741_6 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 286 | 290 | 1 | 2023-03-21 | 367.88 | 9.20 | 2023-03-09 | 2 | 170.14 | 1 | 367.88 | 6 | SO48741 | 2023-03-16 | 29.43 | 340.29 | 183.94 | |||
SO46042_22 | FE13-4E1B-A4 | PO16646156443 | 100 | 286 | 338 | 1 | 1 | 2022-07-19 | 419.46 | 10.49 | 2022-07-07 | 1 | 413.15 | 1 | 419.46 | 22 | SO46042 | 2022-07-14 | 33.56 | 413.15 | 419.46 | |||
SO51712_45 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 472 | 361 | 1 | 2023-10-19 | 152.40 | 3.81 | 2023-10-07 | 4 | 23.75 | 1 | 152.40 | 45 | SO51712 | 2023-10-14 | 12.19 | 95.00 | 38.10 | |||
SO63157_29 | 9E62-4577-80 | PO14500183845 | 100 | 282 | 471 | 650 | 1 | 2024-04-20 | 304.80 | 7.62 | 2024-04-08 | 8 | 23.75 | 1 | 304.80 | 29 | SO63157 | 2024-04-15 | 24.38 | 189.99 | 38.10 | |||
SO48079_15 | A42B-43D5-B0 | PO7627191699 | 100 | 293 | 329 | 433 | 1 | 2023-01-19 | 939.59 | 23.49 | 2023-01-07 | 2 | 486.71 | 1 | 939.59 | 15 | SO48079 | 2023-01-14 | 75.17 | 973.41 | 469.79 | |||
SO48079_6 | A42B-43D5-B0 | PO7627191699 | 100 | 293 | 375 | 433 | 1 | 2023-01-19 | 5235.75 | 130.89 | 2023-01-07 | 4 | 1320.68 | 1 | 5235.75 | 6 | SO48079 | 2023-01-14 | 418.86 | 5282.74 | 1308.94 | |||
SO69408_25 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 400 | 236 | 1 | 2024-07-19 | 222.91 | 5.57 | 2024-07-07 | 6 | 27.49 | 1 | 222.91 | 25 | SO69408 | 2024-07-14 | 17.83 | 164.96 | 37.15 | |||
SO57026_16 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 566 | 361 | 1 | 2024-01-19 | 445.41 | 11.14 | 2024-01-07 | 1 | 461.44 | 1 | 445.41 | 16 | SO57026 | 2024-01-14 | 35.63 | 461.44 | 445.41 | |||
SO57105_35 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 600 | 697 | 1 | 2024-01-19 | 323.99 | 8.10 | 2024-01-07 | 1 | 294.58 | 1 | 323.99 | 35 | SO57105 | 2024-01-14 | 25.92 | 294.58 | 323.99 | |||
SO65252_2 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 572 | 672 | 1 | 2024-05-19 | 2672.46 | 66.81 | 2024-05-07 | 6 | 461.44 | 1 | 2672.46 | 2 | SO65252 | 2024-05-14 | 213.80 | 2768.67 | 445.41 | |||
SO59059_3 | FD9E-44C4-97 | PO7482187440 | 100 | 293 | 568 | 163 | 1 | 2024-02-18 | 1781.64 | 44.54 | 2024-02-06 | 4 | 461.44 | 1 | 1781.64 | 3 | SO59059 | 2024-02-13 | 142.53 | 1845.78 | 445.41 | |||
SO57099_15 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 483 | 605 | 1 | 2024-01-19 | 288.00 | 7.20 | 2024-01-07 | 4 | 44.88 | 1 | 288.00 | 15 | SO57099 | 2024-01-14 | 23.04 | 179.52 | 72.00 | |||
SO51123_21 | E412-45DF-AE | PO899150137 | 100 | 289 | 463 | 290 | 1 | 2023-09-18 | 132.25 | 3.31 | 2023-09-06 | 9 | 9.16 | 1 | 132.25 | 21 | SO51123 | 2023-09-13 | 10.58 | 82.43 | 14.69 | |||
SO67266_20 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 524 | 146 | 1 | 2024-06-19 | 475.29 | 11.88 | 2024-06-07 | 3 | 144.59 | 1 | 475.29 | 20 | SO67266 | 2024-06-14 | 38.02 | 433.78 | 158.43 | |||
SO48328_21 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 393 | 293 | 1 | 2023-02-18 | 275.39 | 6.88 | 2023-02-06 | 2 | 101.89 | 1 | 275.39 | 21 | SO48328 | 2023-02-13 | 22.03 | 203.79 | 137.69 | |||
SO53518_22 | 5712-444B-BC | PO841197199 | 100 | 286 | 501 | 254 | 1 | 2023-11-19 | 218.63 | 5.47 | 2023-11-07 | 3 | 53.93 | 1 | 218.63 | 22 | SO53518 | 2023-11-14 | 17.49 | 161.78 | 72.88 | |||
SO58962_2 | 12B1-4451-9A | PO870180310 | 100 | 286 | 577 | 621 | 1 | 2024-02-18 | 2915.64 | 72.89 | 2024-02-06 | 4 | 755.15 | 1 | 2915.64 | 2 | SO58962 | 2024-02-13 | 233.25 | 3020.60 | 728.91 | |||
SO46348_10 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 346 | 7 | 293 | 1 | 595.00 | 2022-08-19 | 1700.00 | 27.62 | 2022-08-07 | 2 | 1912.15 | 1 | 1105.00 | 10 | SO46348 | 2022-08-14 | 88.40 | 3824.31 | 850.00 | 0.35 |
SO71836_47 | E41E-40C1-84 | PO841118259 | 100 | 286 | 355 | 254 | 1 | 2024-08-19 | 5567.98 | 139.20 | 2024-08-07 | 4 | 1265.62 | 1 | 5567.98 | 47 | SO71836 | 2024-08-14 | 445.44 | 5062.48 | 1391.99 | |||
SO45521_1 | CD43-442B-91 | PO19169144736 | 100 | 289 | 346 | 272 | 1 | 2022-05-19 | 2039.99 | 51.00 | 2022-05-07 | 1 | 1912.15 | 1 | 2039.99 | 1 | SO45521 | 2022-05-14 | 163.20 | 1912.15 | 2039.99 | |||
SO43867_2 | 061F-4449-BE | PO14471123403 | 100 | 286 | 347 | 145 | 1 | 2021-10-19 | 2039.99 | 51.00 | 2021-10-07 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO43867 | 2021-10-14 | 163.20 | 1912.15 | 2039.99 | |||
SO53518_57 | 5712-444B-BC | PO841197199 | 100 | 286 | 512 | 254 | 1 | 2023-11-19 | 1529.18 | 38.23 | 2023-11-07 | 7 | 199.38 | 1 | 1529.18 | 57 | SO53518 | 2023-11-14 | 122.33 | 1395.63 | 218.45 | |||
SO47999_10 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 366 | 650 | 1 | 2023-01-19 | 1943.98 | 48.60 | 2023-01-07 | 3 | 598.44 | 1 | 1943.98 | 10 | SO47999 | 2023-01-14 | 155.52 | 1795.31 | 647.99 | |||
SO51830_22 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 582 | 433 | 1 | 2023-10-19 | 8164.75 | 204.12 | 2023-10-07 | 8 | 1082.51 | 1 | 8164.75 | 22 | SO51830 | 2023-10-14 | 653.18 | 8660.08 | 1020.59 | |||
SO57026_26 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 574 | 361 | 1 | 2024-01-19 | 1430.44 | 35.76 | 2024-01-07 | 1 | 1481.94 | 1 | 1430.44 | 26 | SO57026 | 2024-01-14 | 114.44 | 1481.94 | 1430.44 | |||
SO48289_3 | 5243-4D2E-A2 | PO20097151054 | 100 | 289 | 254 | 128 | 1 | 2023-02-18 | 367.88 | 9.20 | 2023-02-06 | 2 | 170.14 | 1 | 367.88 | 3 | SO48289 | 2023-02-13 | 29.43 | 340.29 | 183.94 | |||
SO53605_19 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 500 | 308 | 1 | 2023-11-19 | 1204.69 | 30.12 | 2023-11-07 | 2 | 601.74 | 1 | 1204.69 | 19 | SO53605 | 2023-11-14 | 96.38 | 1203.49 | 602.35 | |||
SO47387_4 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 420 | 293 | 1 | 2022-11-19 | 566.46 | 14.16 | 2022-11-07 | 4 | 104.80 | 1 | 566.46 | 4 | SO47387 | 2022-11-14 | 45.32 | 419.18 | 141.62 | |||
SO69525_8 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 580 | 343 | 1 | 2024-07-19 | 3061.78 | 76.54 | 2024-07-07 | 3 | 1082.51 | 1 | 3061.78 | 8 | SO69525 | 2024-07-14 | 244.94 | 3247.53 | 1020.59 | |||
SO46647_4 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 221 | 8 | 506 | 1 | 6.73 | 2022-09-18 | 67.29 | 1.51 | 2022-09-06 | 4 | 13.88 | 1 | 60.56 | 4 | SO46647 | 2022-09-13 | 4.84 | 55.51 | 16.82 | 0.10 |
SO63278_2 | 5ED5-4C40-B9 | PO3306193746 | 100 | 293 | 577 | 181 | 1 | 2024-04-20 | 728.91 | 18.22 | 2024-04-08 | 1 | 755.15 | 1 | 728.91 | 2 | SO63278 | 2024-04-15 | 58.31 | 755.15 | 728.91 | |||
SO47992_36 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 216 | 487 | 1 | 2023-01-19 | 100.93 | 2.52 | 2023-01-07 | 5 | 13.88 | 1 | 100.93 | 36 | SO47992 | 2023-01-14 | 8.07 | 69.39 | 20.19 | |||
SO50218_35 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 305 | 127 | 1 | 2023-07-19 | 1472.29 | 36.81 | 2023-07-07 | 2 | 653.70 | 1 | 1472.29 | 35 | SO50218 | 2023-07-14 | 117.78 | 1307.39 | 736.15 | |||
SO65268_7 | E14C-42AB-92 | PO9309127032 | 100 | 293 | 569 | 55 | 1 | 2024-05-19 | 1336.23 | 33.41 | 2024-05-07 | 3 | 461.44 | 1 | 1336.23 | 7 | SO65268 | 2024-05-14 | 106.90 | 1384.33 | 445.41 | |||
SO63149_3 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 512 | 236 | 1 | 2024-04-20 | 1310.72 | 32.77 | 2024-04-08 | 6 | 199.38 | 1 | 1310.72 | 3 | SO63149 | 2024-04-15 | 104.86 | 1196.25 | 218.45 | |||
SO65263_2 | C0DD-4323-8C | PO7395113656 | 100 | 286 | 593 | 542 | 1 | 2024-05-19 | 1016.98 | 25.42 | 2024-05-07 | 3 | 308.22 | 1 | 1016.98 | 2 | SO65263 | 2024-05-14 | 81.36 | 924.65 | 338.99 | |||
SO69422_19 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 463 | 650 | 1 | 2024-07-19 | 58.78 | 1.47 | 2024-07-07 | 4 | 9.16 | 1 | 58.78 | 19 | SO69422 | 2024-07-14 | 4.70 | 36.64 | 14.69 | |||
SO49544_2 | 9647-4E6D-B8 | PO8294194867 | 100 | 289 | 421 | 488 | 1 | 2023-05-19 | 196.33 | 4.91 | 2023-05-07 | 1 | 145.28 | 1 | 196.33 | 2 | SO49544 | 2023-05-14 | 15.71 | 145.28 | 196.33 |
Generated 2024-10-06 09:41:12.423 UTC