[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 438 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50210_22 | 6347-4C03-9B | PO15631112842 | 100 | 282 | 421 | 43 | 1 | 2023-07-19 | 392.66 | 9.82 | 2023-07-07 | 2 | 145.28 | 1 | 392.66 | 22 | SO50210 | 2023-07-14 | 31.41 | 290.57 | 196.33 | |||
SO46967_30 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 457 | 487 | 1 | 2022-10-19 | 179.98 | 4.50 | 2022-10-07 | 4 | 30.93 | 1 | 179.98 | 30 | SO46967 | 2022-10-14 | 14.40 | 123.73 | 44.99 | |||
SO67335_3 | A016-4C1A-9B | PO1479138681 | 100 | 282 | 513 | 673 | 1 | 2024-06-19 | 218.45 | 5.46 | 2024-06-07 | 1 | 199.38 | 1 | 218.45 | 3 | SO67335 | 2024-06-14 | 17.48 | 199.38 | 218.45 | |||
SO51089_17 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 591 | 146 | 1 | 2023-09-18 | 338.99 | 8.47 | 2023-09-06 | 1 | 308.22 | 1 | 338.99 | 17 | SO51089 | 2023-09-13 | 27.12 | 308.22 | 338.99 | |||
SO57030_14 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 594 | 236 | 1 | 2024-01-19 | 1355.98 | 33.90 | 2024-01-07 | 4 | 308.22 | 1 | 1355.98 | 14 | SO57030 | 2024-01-14 | 108.48 | 1232.87 | 338.99 | |||
SO46972_13 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 394 | 650 | 1 | 2022-10-19 | 41.04 | 1.03 | 2022-10-07 | 2 | 15.18 | 1 | 41.04 | 13 | SO46972 | 2022-10-14 | 3.28 | 30.37 | 20.52 | |||
SO49846_1 | 5B51-4482-BB | PO1392138093 | 100 | 293 | 254 | 19 | 1 | 2023-06-19 | 183.94 | 4.60 | 2023-06-07 | 1 | 170.14 | 1 | 183.94 | 1 | SO49846 | 2023-06-14 | 14.72 | 170.14 | 183.94 | |||
SO44121_13 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 304 | 169 | 1 | 2021-11-19 | 714.70 | 17.87 | 2021-11-07 | 1 | 617.03 | 1 | 714.70 | 13 | SO44121 | 2021-11-14 | 57.18 | 617.03 | 714.70 | |||
SO67294_20 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 374 | 290 | 1 | 2024-06-19 | 10262.07 | 256.55 | 2024-06-07 | 7 | 1554.95 | 1 | 10262.07 | 20 | SO67294 | 2024-06-14 | 820.97 | 10884.64 | 1466.01 | |||
SO58916_5 | E928-4943-BC | PO17139180025 | 100 | 293 | 384 | 644 | 1 | 2024-02-18 | 2016.88 | 50.42 | 2024-02-06 | 3 | 713.08 | 1 | 2016.88 | 5 | SO58916 | 2024-02-13 | 161.35 | 2139.24 | 672.29 | |||
SO53493_20 | F767-491F-84 | PO13543118174 | 100 | 287 | 532 | 293 | 1 | 2023-11-19 | 899.24 | 22.48 | 2023-11-07 | 6 | 136.79 | 1 | 899.24 | 20 | SO53493 | 2023-11-14 | 71.94 | 820.71 | 149.87 | |||
SO46647_37 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 354 | 506 | 1 | 2022-09-18 | 9942.81 | 248.57 | 2022-09-06 | 8 | 1117.86 | 1 | 9942.81 | 37 | SO46647 | 2022-09-13 | 795.43 | 8942.85 | 1242.85 | |||
SO44126_1 | 0FC0-4BE3-AF | PO7192167220 | 100 | 289 | 349 | 20 | 1 | 2021-11-19 | 2024.99 | 50.62 | 2021-11-07 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO44126 | 2021-11-14 | 162.00 | 1898.09 | 2024.99 | |||
SO53452_32 | B555-4FD7-8B | PO870113712 | 100 | 286 | 496 | 621 | 1 | 2023-11-19 | 3011.73 | 75.29 | 2023-11-07 | 5 | 601.74 | 1 | 3011.73 | 32 | SO53452 | 2023-11-14 | 240.94 | 3008.72 | 602.35 | |||
SO46053_14 | E530-47A7-9A | PO14471143194 | 100 | 286 | 232 | 145 | 1 | 2022-07-19 | 57.68 | 1.44 | 2022-07-07 | 2 | 31.72 | 1 | 57.68 | 14 | SO46053 | 2022-07-14 | 4.61 | 63.45 | 28.84 | |||
SO46957_37 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 366 | 236 | 1 | 2022-10-19 | 6479.94 | 162.00 | 2022-10-07 | 10 | 598.44 | 1 | 6479.94 | 37 | SO46957 | 2022-10-14 | 518.40 | 5984.35 | 647.99 | |||
SO58963_25 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 588 | 254 | 1 | 2024-02-18 | 1846.78 | 46.17 | 2024-02-06 | 4 | 419.78 | 1 | 1846.78 | 25 | SO58963 | 2024-02-13 | 147.74 | 1679.11 | 461.69 | |||
SO55241_31 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 488 | 146 | 1 | 2023-12-19 | 64.79 | 1.62 | 2023-12-07 | 2 | 41.57 | 1 | 64.79 | 31 | SO55241 | 2023-12-14 | 5.18 | 83.14 | 32.39 | |||
SO43664_3 | 2F44-4BA1-BB | PO16617121983 | 100 | 286 | 229 | 397 | 1 | 2021-09-18 | 28.84 | 0.72 | 2021-09-06 | 1 | 31.72 | 1 | 28.84 | 3 | SO43664 | 2021-09-13 | 2.31 | 31.72 | 28.84 | |||
SO69525_15 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 582 | 343 | 1 | 2024-07-19 | 3061.78 | 76.54 | 2024-07-07 | 3 | 1082.51 | 1 | 3061.78 | 15 | SO69525 | 2024-07-14 | 244.94 | 3247.53 | 1020.59 | |||
SO50218_12 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 399 | 127 | 1 | 2023-07-19 | 101.32 | 2.53 | 2023-07-07 | 3 | 24.99 | 1 | 101.32 | 12 | SO50218 | 2023-07-14 | 8.11 | 74.98 | 33.77 | |||
SO51123_53 | E412-45DF-AE | PO899150137 | 100 | 289 | 465 | 290 | 1 | 2023-09-18 | 73.47 | 1.84 | 2023-09-06 | 5 | 9.16 | 1 | 73.47 | 53 | SO51123 | 2023-09-13 | 5.88 | 45.80 | 14.69 | |||
SO65270_2 | E73B-4A64-B4 | PO7192196898 | 100 | 289 | 361 | 20 | 1 | 2024-05-19 | 1376.99 | 34.42 | 2024-05-07 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO65270 | 2024-05-14 | 110.16 | 1251.98 | 1376.99 | |||
SO53500_6 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 506 | 672 | 1 | 2023-11-19 | 1200.31 | 30.01 | 2023-11-07 | 6 | 199.85 | 1 | 1200.31 | 6 | SO53500 | 2023-11-14 | 96.03 | 1199.11 | 200.05 | |||
SO71880_9 | B0C7-4858-91 | PO7395117544 | 100 | 286 | 588 | 542 | 1 | 2024-08-19 | 461.69 | 11.54 | 2024-08-07 | 1 | 419.78 | 1 | 461.69 | 9 | SO71880 | 2024-08-14 | 36.94 | 419.78 | 461.69 | |||
SO48746_20 | 3C67-4620-90 | PO2552136060 | 100 | 286 | 366 | 506 | 1 | 2023-03-21 | 5831.95 | 145.80 | 2023-03-09 | 9 | 598.44 | 1 | 5831.95 | 20 | SO48746 | 2023-03-16 | 466.56 | 5385.92 | 647.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 | |||
SO71818_4 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 494 | 672 | 1 | 2024-08-19 | 1204.69 | 30.12 | 2024-08-07 | 2 | 601.74 | 1 | 1204.69 | 4 | SO71818 | 2024-08-14 | 96.38 | 1203.49 | 602.35 | |||
SO53576_11 | 7638-4151-96 | PO7395119515 | 100 | 286 | 588 | 542 | 1 | 2023-11-19 | 2308.47 | 57.71 | 2023-11-07 | 5 | 419.78 | 1 | 2308.47 | 11 | SO53576 | 2023-11-14 | 184.68 | 2098.89 | 461.69 | |||
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 | |||
SO46966_12 | 8FBD-4E87-82 | PO15631150454 | 100 | 282 | 470 | 43 | 1 | 2022-10-19 | 205.15 | 5.13 | 2022-10-07 | 9 | 15.67 | 1 | 205.15 | 12 | SO46966 | 2022-10-14 | 16.41 | 141.04 | 22.79 | |||
SO47368_13 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 458 | 692 | 1 | 2022-11-19 | 89.99 | 2.25 | 2022-11-07 | 2 | 30.93 | 1 | 89.99 | 13 | SO47368 | 2022-11-14 | 7.20 | 61.87 | 44.99 | |||
SO48328_12 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 420 | 293 | 1 | 2023-02-18 | 283.23 | 7.08 | 2023-02-06 | 2 | 104.80 | 1 | 283.23 | 12 | SO48328 | 2023-02-13 | 22.66 | 209.59 | 141.62 | |||
SO58963_49 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 591 | 254 | 1 | 2024-02-18 | 1355.98 | 33.90 | 2024-02-06 | 4 | 308.22 | 1 | 1355.98 | 49 | SO58963 | 2024-02-13 | 108.48 | 1232.87 | 338.99 | |||
SO49163_3 | DE2F-4D6A-99 | PO7917119932 | 100 | 287 | 470 | 401 | 1 | 2023-04-21 | 182.35 | 4.56 | 2023-04-09 | 8 | 15.67 | 1 | 182.35 | 3 | SO49163 | 2023-04-16 | 14.59 | 125.37 | 22.79 | |||
SO57046_38 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 591 | 650 | 1 | 2024-01-19 | 1016.98 | 25.42 | 2024-01-07 | 3 | 308.22 | 1 | 1016.98 | 38 | SO57046 | 2024-01-14 | 81.36 | 924.65 | 338.99 | |||
SO44762_3 | 553E-437E-92 | PO13543176259 | 100 | 287 | 344 | 293 | 1 | 2022-02-18 | 10199.97 | 255.00 | 2022-02-06 | 5 | 1912.15 | 1 | 10199.97 | 3 | SO44762 | 2022-02-13 | 816.00 | 9560.77 | 2039.99 | |||
SO47991_17 | 0F2E-4E6D-8E | PO15631116034 | 100 | 282 | 366 | 43 | 1 | 2023-01-19 | 1295.99 | 32.40 | 2023-01-07 | 2 | 598.44 | 1 | 1295.99 | 17 | SO47991 | 2023-01-14 | 103.68 | 1196.87 | 647.99 | |||
SO46957_53 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 305 | 236 | 1 | 2022-10-19 | 736.15 | 18.40 | 2022-10-07 | 1 | 653.70 | 1 | 736.15 | 53 | SO46957 | 2022-10-14 | 58.89 | 653.70 | 736.15 | |||
SO46053_1 | E530-47A7-9A | PO14471143194 | 100 | 286 | 344 | 145 | 1 | 2022-07-19 | 6119.98 | 153.00 | 2022-07-07 | 3 | 1912.15 | 1 | 6119.98 | 1 | SO46053 | 2022-07-14 | 489.60 | 5736.46 | 2039.99 | |||
SO49464_21 | C383-45FE-83 | PO841195010 | 100 | 286 | 297 | 254 | 1 | 2023-05-19 | 2208.44 | 55.21 | 2023-05-07 | 3 | 653.70 | 1 | 2208.44 | 21 | SO49464 | 2023-05-14 | 176.67 | 1961.09 | 736.15 | |||
SO71836_5 | E41E-40C1-84 | PO841118259 | 100 | 286 | 501 | 254 | 1 | 2024-08-19 | 218.63 | 5.47 | 2024-08-07 | 3 | 53.93 | 1 | 218.63 | 5 | SO71836 | 2024-08-14 | 17.49 | 161.78 | 72.88 | |||
SO47998_2 | 3E7A-47BA-B0 | PO14529157781 | 100 | 293 | 354 | 289 | 1 | 2023-01-19 | 3728.56 | 93.21 | 2023-01-07 | 3 | 1117.86 | 1 | 3728.56 | 2 | SO47998 | 2023-01-14 | 298.28 | 3353.57 | 1242.85 | |||
SO71812_8 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 527 | 293 | 1 | 2024-08-19 | 316.86 | 7.92 | 2024-08-07 | 2 | 144.59 | 1 | 316.86 | 8 | SO71812 | 2024-08-14 | 25.35 | 289.19 | 158.43 | |||
SO46372_5 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 350 | 7 | 169 | 1 | 2362.49 | 2022-08-19 | 6749.98 | 109.69 | 2022-08-07 | 8 | 1898.09 | 1 | 4387.49 | 5 | SO46372 | 2022-08-14 | 351.00 | 15184.76 | 843.75 | 0.35 |
SO67294_36 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 214 | 290 | 1 | 2024-06-19 | 20.99 | 0.52 | 2024-06-07 | 1 | 13.09 | 1 | 20.99 | 36 | SO67294 | 2024-06-14 | 1.68 | 13.09 | 20.99 | |||
SO45782_12 | D609-4F2A-9B | PO16588186502 | 100 | 289 | 348 | 146 | 1 | 2022-06-19 | 4049.99 | 101.25 | 2022-06-07 | 2 | 1898.09 | 1 | 4049.99 | 12 | SO45782 | 2022-06-14 | 324.00 | 3796.19 | 2024.99 | |||
SO44523_6 | BE2B-4DB0-8E | PO11919191573 | 100 | 286 | 220 | 73 | 1 | 2022-01-19 | 100.93 | 2.52 | 2022-01-07 | 5 | 12.03 | 1 | 100.93 | 6 | SO44523 | 2022-01-14 | 8.07 | 60.14 | 20.19 | |||
SO47368_6 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 422 | 692 | 1 | 2022-11-19 | 67.54 | 1.69 | 2022-11-07 | 1 | 49.98 | 1 | 67.54 | 6 | SO47368 | 2022-11-14 | 5.40 | 49.98 | 67.54 | |||
SO65234_28 | 3BB7-4A9F-AF | PO10411160249 | 100 | 289 | 586 | 182 | 1 | 2024-05-19 | 445.41 | 11.14 | 2024-05-07 | 1 | 461.44 | 1 | 445.41 | 28 | SO65234 | 2024-05-14 | 35.63 | 461.44 | 445.41 | |||
SO57105_13 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 587 | 697 | 1 | 2024-01-19 | 2770.16 | 69.25 | 2024-01-07 | 6 | 419.78 | 1 | 2770.16 | 13 | SO57105 | 2024-01-14 | 221.61 | 2518.67 | 461.69 | |||
SO71818_12 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 568 | 672 | 1 | 2024-08-19 | 890.82 | 22.27 | 2024-08-07 | 2 | 461.44 | 1 | 890.82 | 12 | SO71818 | 2024-08-14 | 71.27 | 922.89 | 445.41 | |||
SO51148_28 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 558 | 110 | 1 | 2023-09-18 | 728.98 | 18.22 | 2023-09-06 | 3 | 179.82 | 1 | 728.98 | 28 | SO51148 | 2023-09-13 | 58.32 | 539.45 | 242.99 | |||
SO51089_2 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 516 | 146 | 1 | 2023-09-18 | 140.90 | 3.52 | 2023-09-06 | 6 | 17.38 | 1 | 140.90 | 2 | SO51089 | 2023-09-13 | 11.27 | 104.27 | 23.48 | |||
SO44796_5 | 15BA-4644-82 | PO7946119769 | 100 | 282 | 324 | 438 | 1 | 2022-02-18 | 1258.38 | 31.46 | 2022-02-06 | 3 | 413.15 | 1 | 1258.38 | 5 | SO44796 | 2022-02-13 | 100.67 | 1239.44 | 419.46 | |||
SO49503_9 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 410 | 293 | 1 | 2023-05-19 | 72.89 | 1.82 | 2023-05-07 | 2 | 26.97 | 1 | 72.89 | 9 | SO49503 | 2023-05-14 | 5.83 | 53.94 | 36.45 | |||
SO67346_5 | 545C-4C6E-88 | PO9338145989 | 100 | 293 | 579 | 451 | 1 | 2024-06-19 | 2186.73 | 54.67 | 2024-06-07 | 3 | 755.15 | 1 | 2186.73 | 5 | SO67346 | 2024-06-14 | 174.94 | 2265.45 | 728.91 | |||
SO51127_5 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 400 | 506 | 1 | 2023-09-18 | 74.30 | 1.86 | 2023-09-06 | 2 | 27.49 | 1 | 74.30 | 5 | SO51127 | 2023-09-13 | 5.94 | 54.99 | 37.15 | |||
SO51089_42 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 476 | 4 | 146 | 1 | 115.48 | 2023-09-18 | 1154.84 | 25.98 | 2023-09-06 | 33 | 26.18 | 1 | 1039.35 | 42 | SO51089 | 2023-09-13 | 83.15 | 863.82 | 35.00 | 0.10 |
SO50206_47 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 469 | 236 | 1 | 2023-07-19 | 227.94 | 5.70 | 2023-07-07 | 10 | 15.67 | 1 | 227.94 | 47 | SO50206 | 2023-07-14 | 18.24 | 156.71 | 22.79 | |||
SO51715_15 | 2360-48BD-86 | PO15631184297 | 100 | 282 | 597 | 43 | 1 | 2023-10-19 | 323.99 | 8.10 | 2023-10-07 | 1 | 294.58 | 1 | 323.99 | 15 | SO51715 | 2023-10-14 | 25.92 | 294.58 | 323.99 | |||
SO49889_7 | 8783-45FC-96 | PO7105112550 | 100 | 293 | 343 | 668 | 1 | 2023-06-19 | 1879.18 | 46.98 | 2023-06-07 | 4 | 486.71 | 1 | 1879.18 | 7 | SO49889 | 2023-06-14 | 150.33 | 1946.83 | 469.79 |
Generated 2024-10-06 10:50:04.184 UTC