[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE SKIP 2000 < SKIP 62 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63127_3 | BC04-42FB-8F | PO19227167253 | 19 | 284 | 605 | 210 | 6 | 2024-05-25 | 647.99 | 16.20 | 2024-05-13 | 2 | 343.65 | 1 | 647.99 | 3 | SO63127 | 2024-05-20 | 51.84 | 687.30 | 323.99 |
SO61179_16 | 1443-4268-AC | PO18444157069 | 19 | 291 | 382 | 227 | 6 | 2024-04-24 | 2689.18 | 67.23 | 2024-04-12 | 4 | 713.08 | 1 | 2689.18 | 16 | SO61179 | 2024-04-19 | 215.13 | 2852.32 | 672.29 |
SO47031_36 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 456 | 352 | 6 | 2022-11-23 | 179.98 | 4.50 | 2022-11-11 | 4 | 30.93 | 1 | 179.98 | 36 | SO47031 | 2022-11-18 | 14.40 | 123.73 | 44.99 |
SO49138_16 | 487B-46D8-9B | PO4466190674 | 19 | 291 | 469 | 352 | 6 | 2023-05-26 | 136.76 | 3.42 | 2023-05-14 | 6 | 15.67 | 1 | 136.76 | 16 | SO49138 | 2023-05-21 | 10.94 | 94.03 | 22.79 |
SO48297_1 | FF31-49F8-B2 | PO18531121802 | 19 | 284 | 224 | 613 | 6 | 2023-03-25 | 31.12 | 0.78 | 2023-03-13 | 6 | 5.23 | 1 | 31.12 | 1 | SO48297 | 2023-03-20 | 2.49 | 31.38 | 5.19 |
SO48321_28 | FA9B-4026-BF | PO14790154902 | 19 | 291 | 401 | 497 | 6 | 2023-03-25 | 131.20 | 3.28 | 2023-03-13 | 2 | 48.55 | 1 | 131.20 | 28 | SO48321 | 2023-03-20 | 10.50 | 97.09 | 65.60 |
SO47365_22 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 470 | 678 | 6 | 2022-12-24 | 159.56 | 3.99 | 2022-12-12 | 7 | 15.67 | 1 | 159.56 | 22 | SO47365 | 2022-12-19 | 12.76 | 109.70 | 22.79 |
SO58956_18 | 36A4-4154-AB | PO11194174095 | 19 | 284 | 566 | 48 | 6 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 18 | SO58956 | 2024-03-19 | 71.27 | 922.89 | 445.41 |
SO57120_26 | 058D-436F-BF | PO4466170177 | 19 | 291 | 361 | 352 | 6 | 2024-02-23 | 2753.99 | 68.85 | 2024-02-11 | 2 | 1251.98 | 1 | 2753.99 | 26 | SO57120 | 2024-02-18 | 220.32 | 2503.96 | 1376.99 |
SO58930_20 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 593 | 497 | 6 | 2024-03-24 | 1016.98 | 25.42 | 2024-03-12 | 3 | 308.22 | 1 | 1016.98 | 20 | SO58930 | 2024-03-19 | 81.36 | 924.65 | 338.99 |
SO47359_29 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 294 | 118 | 6 | 2022-12-24 | 1488.55 | 37.21 | 2022-12-12 | 2 | 660.91 | 1 | 1488.55 | 29 | SO47359 | 2022-12-19 | 119.08 | 1321.83 | 744.27 |
SO69460_7 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 546 | 426 | 6 | 2024-08-23 | 37.25 | 0.93 | 2024-08-11 | 1 | 27.57 | 1 | 37.25 | 7 | SO69460 | 2024-08-18 | 2.98 | 27.57 | 37.25 |
SO63128_9 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 560 | 64 | 6 | 2024-05-25 | 1457.82 | 36.45 | 2024-05-13 | 2 | 755.15 | 1 | 1457.82 | 9 | SO63128 | 2024-05-20 | 116.63 | 1510.30 | 728.91 |
SO49828_5 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 339 | 514 | 6 | 2023-07-24 | 2348.97 | 58.72 | 2023-07-12 | 5 | 486.71 | 1 | 2348.97 | 5 | SO49828 | 2023-07-19 | 187.92 | 2433.53 | 469.79 |
SO51740_8 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 474 | 677 | 6 | 2023-11-23 | 167.98 | 4.20 | 2023-11-11 | 4 | 26.18 | 1 | 167.98 | 8 | SO51740 | 2023-11-18 | 13.44 | 104.71 | 41.99 |
SO46074_7 | 5178-4FDE-97 | PO2088179248 | 19 | 288 | 264 | 136 | 6 | 2022-08-23 | 367.88 | 9.20 | 2022-08-11 | 2 | 181.49 | 1 | 367.88 | 7 | SO46074 | 2022-08-18 | 29.43 | 362.97 | 183.94 |
SO46334_1 | F652-4575-B7 | PO17574196050 | 19 | 272 | 300 | 678 | 6 | 2022-09-23 | 1619.52 | 40.49 | 2022-09-11 | 2 | 699.09 | 1 | 1619.52 | 1 | SO46334 | 2022-09-18 | 129.56 | 1398.19 | 809.76 |
SO58925_23 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 576 | 282 | 6 | 2024-03-24 | 1430.44 | 35.76 | 2024-03-12 | 1 | 1481.94 | 1 | 1430.44 | 23 | SO58925 | 2024-03-19 | 114.44 | 1481.94 | 1430.44 |
SO58918_3 | C811-4D40-80 | PO17574131484 | 19 | 291 | 552 | 678 | 6 | 2024-03-24 | 384.26 | 9.61 | 2024-03-12 | 7 | 40.62 | 1 | 384.26 | 3 | SO58918 | 2024-03-19 | 30.74 | 284.35 | 54.89 |
SO47398_47 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 333 | 461 | 6 | 2022-12-24 | 469.79 | 11.74 | 2022-12-12 | 1 | 486.71 | 1 | 469.79 | 47 | SO47398 | 2022-12-19 | 37.58 | 486.71 | 469.79 |
SO47354_29 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 327 | 173 | 6 | 2022-12-24 | 469.79 | 11.74 | 2022-12-12 | 1 | 486.71 | 1 | 469.79 | 29 | SO47354 | 2022-12-19 | 37.58 | 486.71 | 469.79 |
SO67304_11 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 434 | 227 | 6 | 2024-07-24 | 2141.39 | 53.53 | 2024-07-12 | 6 | 360.94 | 1 | 2141.39 | 11 | SO67304 | 2024-07-19 | 171.31 | 2165.66 | 356.90 |
SO47031_27 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 364 | 352 | 6 | 2022-11-23 | 1295.99 | 32.40 | 2022-11-11 | 2 | 598.44 | 1 | 1295.99 | 27 | SO47031 | 2022-11-18 | 103.68 | 1196.87 | 647.99 |
SO47696_23 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 428 | 245 | 6 | 2023-01-23 | 1464.79 | 36.62 | 2023-01-11 | 7 | 185.82 | 1 | 1464.79 | 23 | SO47696 | 2023-01-18 | 117.18 | 1300.74 | 209.26 |
SO47690_9 | B248-4AA7-92 | PO10527158850 | 19 | 284 | 422 | 480 | 6 | 2023-01-23 | 67.54 | 1.69 | 2023-01-11 | 1 | 49.98 | 1 | 67.54 | 9 | SO47690 | 2023-01-18 | 5.40 | 49.98 | 67.54 |
SO57161_11 | 5BA9-4418-9F | PO1827135302 | 19 | 291 | 546 | 317 | 6 | 2024-02-23 | 37.25 | 0.93 | 2024-02-11 | 1 | 27.57 | 1 | 37.25 | 11 | SO57161 | 2024-02-18 | 2.98 | 27.57 | 37.25 |
SO46953_41 | C650-4C32-BE | PO17603154442 | 19 | 284 | 343 | 12 | 6 | 2022-11-23 | 4697.94 | 117.45 | 2022-11-11 | 10 | 486.71 | 1 | 4697.94 | 41 | SO46953 | 2022-11-18 | 375.84 | 4867.07 | 469.79 |
SO65163_9 | 6062-4B82-A4 | PO18502160930 | 19 | 291 | 492 | 154 | 6 | 2024-06-23 | 1204.69 | 30.12 | 2024-06-11 | 2 | 601.74 | 1 | 1204.69 | 9 | SO65163 | 2024-06-18 | 96.38 | 1203.49 | 602.35 |
SO48036_3 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 454 | 66 | 6 | 2023-02-23 | 215.96 | 5.40 | 2023-02-11 | 6 | 24.75 | 1 | 215.96 | 3 | SO48036 | 2023-02-18 | 17.28 | 148.48 | 35.99 |
SO44104_1 | FF83-4094-A9 | PO10585171940 | 19 | 284 | 346 | 498 | 6 | 2021-12-24 | 2039.99 | 51.00 | 2021-12-12 | 1 | 1912.15 | 1 | 2039.99 | 1 | SO44104 | 2021-12-19 | 163.20 | 1912.15 | 2039.99 |
SO55283_10 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 353 | 442 | 6 | 2024-01-23 | 2783.99 | 69.60 | 2024-01-11 | 2 | 1265.62 | 1 | 2783.99 | 10 | SO55283 | 2024-01-18 | 222.72 | 2531.24 | 1391.99 |
SO47365_54 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 460 | 678 | 6 | 2022-12-24 | 431.95 | 10.80 | 2022-12-12 | 8 | 37.12 | 1 | 431.95 | 54 | SO47365 | 2022-12-19 | 34.56 | 296.97 | 53.99 |
SO55283_12 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 533 | 442 | 6 | 2024-01-23 | 299.75 | 7.49 | 2024-01-11 | 2 | 136.79 | 1 | 299.75 | 12 | SO55283 | 2024-01-18 | 23.98 | 273.57 | 149.87 |
SO46330_11 | 4E4A-4105-8E | PO18299117472 | 19 | 288 | 218 | 118 | 6 | 2022-09-23 | 34.20 | 0.86 | 2022-09-11 | 6 | 3.40 | 1 | 34.20 | 11 | SO46330 | 2022-09-18 | 2.74 | 20.38 | 5.70 |
SO45545_1 | D3A8-40B1-BF | PO11107196467 | 19 | 284 | 326 | 156 | 6 | 2022-06-23 | 419.46 | 10.49 | 2022-06-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO45545 | 2022-06-18 | 33.56 | 413.15 | 419.46 |
SO50666_1 | 1380-41E5-A4 | PO17951169852 | 19 | 284 | 221 | 637 | 6 | 2023-09-23 | 40.37 | 1.01 | 2023-09-11 | 2 | 13.88 | 1 | 40.37 | 1 | SO50666 | 2023-09-18 | 3.23 | 27.76 | 20.19 |
SO47031_25 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 297 | 352 | 6 | 2022-11-23 | 736.15 | 18.40 | 2022-11-11 | 1 | 653.70 | 1 | 736.15 | 25 | SO47031 | 2022-11-18 | 58.89 | 653.70 | 736.15 |
SO48306_35 | EA27-471A-9D | PO17574166075 | 19 | 291 | 365 | 678 | 6 | 2023-03-25 | 3887.96 | 97.20 | 2023-03-13 | 6 | 598.44 | 1 | 3887.96 | 35 | SO48306 | 2023-03-20 | 311.04 | 3590.61 | 647.99 |
SO51124_36 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 558 | 245 | 6 | 2023-10-23 | 485.99 | 12.15 | 2023-10-11 | 2 | 179.82 | 1 | 485.99 | 36 | SO51124 | 2023-10-18 | 38.88 | 359.63 | 242.99 |
SO50676_34 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 365 | 497 | 6 | 2023-09-23 | 647.99 | 16.20 | 2023-09-11 | 1 | 598.44 | 1 | 647.99 | 34 | SO50676 | 2023-09-18 | 51.84 | 598.44 | 647.99 |
SO69399_33 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 555 | 264 | 6 | 2024-08-23 | 127.80 | 3.20 | 2024-08-11 | 2 | 47.29 | 1 | 127.80 | 33 | SO69399 | 2024-08-18 | 10.22 | 94.57 | 63.90 |
SO65240_1 | 8555-4591-9E | PO14877131396 | 19 | 291 | 512 | 172 | 6 | 2024-06-23 | 218.45 | 5.46 | 2024-06-11 | 1 | 199.38 | 1 | 218.45 | 1 | SO65240 | 2024-06-18 | 17.48 | 199.38 | 218.45 |
SO47365_41 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 428 | 678 | 6 | 2022-12-24 | 418.51 | 10.46 | 2022-12-12 | 2 | 185.82 | 1 | 418.51 | 41 | SO47365 | 2022-12-19 | 33.48 | 371.64 | 209.26 |
SO46936_6 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 239 | 210 | 6 | 2022-11-23 | 780.82 | 19.52 | 2022-11-11 | 1 | 722.26 | 1 | 780.82 | 6 | SO46936 | 2022-11-18 | 62.47 | 722.26 | 780.82 |
SO57023_28 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 483 | 12 | 6 | 2024-02-23 | 432.00 | 10.80 | 2024-02-11 | 6 | 44.88 | 1 | 432.00 | 28 | SO57023 | 2024-02-18 | 34.56 | 269.28 | 72.00 |
SO69479_20 | 3D8D-4908-A6 | PO18328116976 | 19 | 284 | 483 | 552 | 6 | 2024-08-23 | 216.00 | 5.40 | 2024-08-11 | 3 | 44.88 | 1 | 216.00 | 20 | SO69479 | 2024-08-18 | 17.28 | 134.64 | 72.00 |
SO47359_20 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 409 | 118 | 6 | 2022-12-24 | 418.51 | 10.46 | 2022-12-12 | 2 | 185.82 | 1 | 418.51 | 20 | SO47359 | 2022-12-19 | 33.48 | 371.64 | 209.26 |
SO46333_20 | B042-408B-A8 | PO17545158984 | 19 | 288 | 316 | 155 | 6 | 2022-09-23 | 3499.18 | 87.48 | 2022-09-11 | 4 | 884.71 | 1 | 3499.18 | 20 | SO46333 | 2022-09-18 | 279.93 | 3538.83 | 874.79 |
SO48339_15 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 331 | 461 | 6 | 2023-03-25 | 1879.18 | 46.98 | 2023-03-13 | 4 | 486.71 | 1 | 1879.18 | 15 | SO48339 | 2023-03-20 | 150.33 | 1946.83 | 469.79 |
SO51703_36 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 243 | 12 | 6 | 2023-11-23 | 1717.80 | 42.95 | 2023-11-11 | 2 | 868.63 | 1 | 1717.80 | 36 | SO51703 | 2023-11-18 | 137.42 | 1737.27 | 858.90 |
SO53527_21 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 527 | 10 | 6 | 2023-12-24 | 158.43 | 3.96 | 2023-12-12 | 1 | 144.59 | 1 | 158.43 | 21 | SO53527 | 2023-12-19 | 12.67 | 144.59 | 158.43 |
SO51850_13 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 577 | 263 | 6 | 2023-11-23 | 2915.64 | 72.89 | 2023-11-11 | 4 | 755.15 | 1 | 2915.64 | 13 | SO51850 | 2023-11-18 | 233.25 | 3020.60 | 728.91 |
SO63239_4 | AF5E-48ED-A4 | PO4901178462 | 19 | 284 | 606 | 84 | 6 | 2024-05-25 | 647.99 | 16.20 | 2024-05-13 | 2 | 343.65 | 1 | 647.99 | 4 | SO63239 | 2024-05-20 | 51.84 | 687.30 | 323.99 |
SO45527_2 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 312 | 155 | 6 | 2022-06-23 | 4293.92 | 107.35 | 2022-06-11 | 2 | 2171.29 | 1 | 4293.92 | 2 | SO45527 | 2022-06-18 | 343.51 | 4342.59 | 2146.96 |
SO71847_4 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 570 | 154 | 6 | 2024-09-23 | 445.41 | 11.14 | 2024-09-11 | 1 | 461.44 | 1 | 445.41 | 4 | SO71847 | 2024-09-18 | 35.63 | 461.44 | 445.41 |
SO48768_1 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 362 | 119 | 6 | 2023-04-25 | 1229.46 | 30.74 | 2023-04-13 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO48768 | 2023-04-20 | 98.36 | 1105.81 | 1229.46 |
SO61196_5 | 8DD6-4DC9-A5 | PO1711193720 | 19 | 291 | 558 | 245 | 6 | 2024-04-24 | 728.98 | 18.22 | 2024-04-12 | 3 | 179.82 | 1 | 728.98 | 5 | SO61196 | 2024-04-19 | 58.32 | 539.45 | 242.99 |
SO55287_4 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 353 | 119 | 6 | 2024-01-23 | 6959.97 | 174.00 | 2024-01-11 | 5 | 1265.62 | 1 | 6959.97 | 4 | SO55287 | 2024-01-18 | 556.80 | 6328.10 | 1391.99 |
SO46038_6 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 285 | 102 | 6 | 2022-08-23 | 178.58 | 4.46 | 2022-08-11 | 1 | 176.20 | 1 | 178.58 | 6 | SO46038 | 2022-08-18 | 14.29 | 176.20 | 178.58 |
SO47980_19 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 435 | 12 | 6 | 2023-02-23 | 1946.72 | 48.67 | 2023-02-11 | 6 | 300.12 | 1 | 1946.72 | 19 | SO47980 | 2023-02-18 | 155.74 | 1800.71 | 324.45 |
SO46044_18 | 029B-4675-9A | PO16733123313 | 19 | 288 | 312 | 533 | 6 | 2022-08-23 | 4293.92 | 107.35 | 2022-08-11 | 2 | 2171.29 | 1 | 4293.92 | 18 | SO46044 | 2022-08-18 | 343.51 | 4342.59 | 2146.96 |
SO65206_27 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 353 | 10 | 6 | 2024-06-23 | 8351.96 | 208.80 | 2024-06-11 | 6 | 1265.62 | 1 | 8351.96 | 27 | SO65206 | 2024-06-18 | 668.16 | 7593.72 | 1391.99 |
Generated 2024-11-10 23:58:24.842 UTC