[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 875 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57042_13 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 374 | 258 | 4 | 2023-12-27 | 2932.02 | 73.30 | 2023-12-15 | 2 | 1554.95 | 1 | 2932.02 | 13 | SO57042 | 2023-12-22 | 234.56 | 3109.90 | 1466.01 |
SO47002_2 | BC9F-453B-99 | PO609116671 | 100 | 282 | 216 | 492 | 4 | 2022-09-26 | 60.56 | 1.51 | 2022-09-14 | 3 | 13.88 | 1 | 60.56 | 2 | SO47002 | 2022-09-21 | 4.84 | 41.63 | 20.19 |
SO71854_32 | AF3C-4FDF-A6 | PO16385143469 | 6 | 296 | 572 | 249 | 9 | 2024-07-27 | 890.82 | 22.27 | 2024-07-15 | 2 | 461.44 | 1 | 890.82 | 32 | SO71854 | 2024-07-22 | 71.27 | 922.89 | 445.41 |
SO48731_5 | 2DDD-453B-85 | PO19314141866 | 100 | 281 | 323 | 622 | 3 | 2023-02-26 | 1879.18 | 46.98 | 2023-02-14 | 4 | 486.71 | 1 | 1879.18 | 5 | SO48731 | 2023-02-21 | 150.33 | 1946.83 | 469.79 |
SO43668_15 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 264 | 514 | 6 | 2021-08-26 | 551.81 | 13.80 | 2021-08-14 | 3 | 181.49 | 1 | 551.81 | 15 | SO43668 | 2021-08-21 | 44.15 | 544.46 | 183.94 |
SO53488_1 | C755-4AB9-8A | PO14210144388 | 19 | 284 | 473 | 30 | 6 | 2023-10-27 | 38.10 | 0.95 | 2023-10-15 | 1 | 23.75 | 1 | 38.10 | 1 | SO53488 | 2023-10-22 | 3.05 | 23.75 | 38.10 |
SO46095_5 | A60D-4721-BF | PO6641179809 | 100 | 281 | 315 | 342 | 2 | 2022-06-26 | 1749.59 | 43.74 | 2022-06-14 | 2 | 884.71 | 1 | 1749.59 | 5 | SO46095 | 2022-06-21 | 139.97 | 1769.42 | 874.79 |
SO45804_7 | A72B-452A-BA | PO2552178124 | 100 | 289 | 232 | 506 | 1 | 2022-05-27 | 86.52 | 2.16 | 2022-05-15 | 3 | 31.72 | 1 | 86.52 | 7 | SO45804 | 2022-05-22 | 6.92 | 95.17 | 28.84 |
SO65224_7 | 6213-43FA-9B | PO10353176854 | 98 | 288 | 512 | 88 | 10 | 2024-04-26 | 1092.27 | 27.31 | 2024-04-14 | 5 | 199.38 | 1 | 1092.27 | 7 | SO65224 | 2024-04-21 | 87.38 | 996.88 | 218.45 |
SO46972_7 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 469 | 650 | 1 | 2022-09-26 | 45.59 | 1.14 | 2022-09-14 | 2 | 15.67 | 1 | 45.59 | 7 | SO46972 | 2022-09-21 | 3.65 | 31.34 | 22.79 |
SO50232_6 | 3919-46D4-A1 | PO11020171211 | 19 | 284 | 435 | 336 | 6 | 2023-06-26 | 324.45 | 8.11 | 2023-06-14 | 1 | 300.12 | 1 | 324.45 | 6 | SO50232 | 2023-06-21 | 25.96 | 300.12 | 324.45 |
SO57161_1 | 5BA9-4418-9F | PO1827135302 | 19 | 291 | 481 | 317 | 6 | 2023-12-27 | 5.39 | 0.13 | 2023-12-15 | 1 | 3.36 | 1 | 5.39 | 1 | SO57161 | 2023-12-22 | 0.43 | 3.36 | 5.39 |
SO48730_8 | C918-466B-B1 | PO522152463 | 100 | 285 | 352 | 676 | 5 | 2023-02-26 | 7457.11 | 186.43 | 2023-02-14 | 6 | 1117.86 | 1 | 7457.11 | 8 | SO48730 | 2023-02-21 | 596.57 | 6707.14 | 1242.85 |
SO67336_1 | 96C2-41B3-8F | PO2436172115 | 100 | 282 | 576 | 241 | 4 | 2024-05-27 | 1430.44 | 35.76 | 2024-05-15 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO67336 | 2024-05-22 | 114.44 | 1481.94 | 1430.44 |
SO50217_1 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 399 | 650 | 1 | 2023-06-26 | 33.77 | 0.84 | 2023-06-14 | 1 | 24.99 | 1 | 33.77 | 1 | SO50217 | 2023-06-21 | 2.70 | 24.99 | 33.77 |
SO49828_14 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 368 | 514 | 6 | 2023-05-27 | 5864.04 | 146.60 | 2023-05-15 | 4 | 1518.79 | 1 | 5864.04 | 14 | SO49828 | 2023-05-22 | 469.12 | 6075.15 | 1466.01 |
SO50206_29 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 364 | 236 | 1 | 2023-06-26 | 1943.98 | 48.60 | 2023-06-14 | 3 | 598.44 | 1 | 1943.98 | 29 | SO50206 | 2023-06-21 | 155.52 | 1795.31 | 647.99 |
SO47676_2 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 420 | 437 | 4 | 2022-11-26 | 424.85 | 10.62 | 2022-11-14 | 3 | 104.80 | 1 | 424.85 | 2 | SO47676 | 2022-11-21 | 33.99 | 314.39 | 141.62 |
SO53506_24 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 281 | 72 | 2 | 2023-10-27 | 1011.66 | 25.29 | 2023-10-15 | 5 | 204.63 | 1 | 1011.66 | 24 | SO53506 | 2023-10-22 | 80.93 | 1023.13 | 202.33 |
SO50204_44 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 417 | 533 | 6 | 2023-06-26 | 324.45 | 8.11 | 2023-06-14 | 1 | 300.12 | 1 | 324.45 | 44 | SO50204 | 2023-06-21 | 25.96 | 300.12 | 324.45 |
SO65248_23 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 472 | 170 | 5 | 2024-04-26 | 38.10 | 0.95 | 2024-04-14 | 1 | 23.75 | 1 | 38.10 | 23 | SO65248 | 2024-04-21 | 3.05 | 23.75 | 38.10 |
SO47026_22 | 123B-481F-8F | PO3596190739 | 100 | 285 | 297 | 476 | 5 | 2022-09-26 | 2208.44 | 55.21 | 2022-09-14 | 3 | 653.70 | 1 | 2208.44 | 22 | SO47026 | 2022-09-21 | 176.67 | 1961.09 | 736.15 |
SO63289_3 | AC2B-462B-AA | PO7917194869 | 100 | 287 | 475 | 401 | 1 | 2024-03-28 | 41.99 | 1.05 | 2024-03-16 | 1 | 26.18 | 1 | 41.99 | 3 | SO63289 | 2024-03-23 | 3.36 | 26.18 | 41.99 |
SO45315_11 | A83F-4F76-BA | PO2146148184 | 19 | 284 | 293 | 354 | 6 | 2022-03-29 | 1445.19 | 36.13 | 2022-03-17 | 2 | 623.84 | 1 | 1445.19 | 11 | SO45315 | 2022-03-24 | 115.62 | 1247.68 | 722.59 |
SO69540_30 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 573 | 263 | 6 | 2024-06-26 | 8582.65 | 214.57 | 2024-06-14 | 6 | 1481.94 | 1 | 8582.65 | 30 | SO69540 | 2024-06-21 | 686.61 | 8891.63 | 1430.44 |
SO47973_30 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 323 | 479 | 6 | 2022-12-27 | 1409.38 | 35.23 | 2022-12-15 | 3 | 486.71 | 1 | 1409.38 | 30 | SO47973 | 2022-12-22 | 112.75 | 1460.12 | 469.79 |
SO46981_44 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 433 | 638 | 7 | 2022-09-26 | 1946.72 | 48.67 | 2022-09-14 | 6 | 300.12 | 1 | 1946.72 | 44 | SO46981 | 2022-09-21 | 155.74 | 1800.71 | 324.45 |
SO55301_38 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 355 | 414 | 2 | 2023-11-26 | 4175.98 | 104.40 | 2023-11-14 | 3 | 1265.62 | 1 | 4175.98 | 38 | SO55301 | 2023-11-21 | 334.08 | 3796.86 | 1391.99 |
SO57144_22 | 074E-478C-99 | PO3799111077 | 100 | 282 | 214 | 312 | 4 | 2023-12-27 | 83.98 | 2.10 | 2023-12-15 | 4 | 13.09 | 1 | 83.98 | 22 | SO57144 | 2023-12-22 | 6.72 | 52.35 | 20.99 |
SO49119_1 | 92B0-4959-B5 | PO15254156972 | 100 | 283 | 323 | 377 | 3 | 2023-03-29 | 1409.38 | 35.23 | 2023-03-17 | 3 | 486.71 | 1 | 1409.38 | 1 | SO49119 | 2023-03-24 | 112.75 | 1460.12 | 469.79 |
SO46608_26 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 236 | 442 | 6 | 2022-08-26 | 288.40 | 7.21 | 2022-08-14 | 10 | 29.08 | 1 | 288.40 | 26 | SO46608 | 2022-08-21 | 23.07 | 290.81 | 28.84 |
SO50294_14 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 221 | 312 | 4 | 2023-06-26 | 80.75 | 2.02 | 2023-06-14 | 4 | 13.88 | 1 | 80.75 | 14 | SO50294 | 2023-06-21 | 6.46 | 55.51 | 20.19 |
SO45315_4 | A83F-4F76-BA | PO2146148184 | 19 | 284 | 307 | 354 | 6 | 2022-03-29 | 2167.78 | 54.19 | 2022-03-17 | 3 | 623.84 | 1 | 2167.78 | 4 | SO45315 | 2022-03-24 | 173.42 | 1871.52 | 722.59 |
SO51791_12 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 545 | 552 | 6 | 2023-09-26 | 145.76 | 3.64 | 2023-09-14 | 6 | 17.98 | 1 | 145.76 | 12 | SO51791 | 2023-09-21 | 11.66 | 107.87 | 24.29 |
SO44284_14 | 2A6B-46DE-96 | PO16588183754 | 100 | 289 | 346 | 146 | 1 | 2021-11-26 | 8159.98 | 204.00 | 2021-11-14 | 4 | 1912.15 | 1 | 8159.98 | 14 | SO44284 | 2021-11-21 | 652.80 | 7648.62 | 2039.99 |
SO45793_2 | 0B18-49B2-96 | PO13775113238 | 100 | 281 | 336 | 618 | 2 | 2022-05-27 | 419.46 | 10.49 | 2022-05-15 | 1 | 413.15 | 1 | 419.46 | 2 | SO45793 | 2022-05-22 | 33.56 | 413.15 | 419.46 |
SO50231_22 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 286 | 512 | 5 | 2023-06-26 | 551.81 | 13.80 | 2023-06-14 | 3 | 170.14 | 1 | 551.81 | 22 | SO50231 | 2023-06-21 | 44.15 | 510.43 | 183.94 |
SO71947_7 | 7269-4186-92 | PO9628115897 | 100 | 283 | 556 | 179 | 2 | 2024-07-27 | 210.59 | 5.26 | 2024-07-15 | 2 | 77.92 | 1 | 210.59 | 7 | SO71947 | 2024-07-22 | 16.85 | 155.84 | 105.29 |
SO65236_32 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 436 | 54 | 2 | 2024-04-26 | 713.80 | 17.84 | 2024-04-14 | 2 | 360.94 | 1 | 713.80 | 32 | SO65236 | 2024-04-21 | 57.10 | 721.89 | 356.90 |
SO61267_6 | BCFD-47EE-BD | PO7076191943 | 100 | 293 | 499 | 505 | 1 | 2024-02-26 | 1204.69 | 30.12 | 2024-02-14 | 2 | 601.74 | 1 | 1204.69 | 6 | SO61267 | 2024-02-21 | 96.38 | 1203.49 | 602.35 |
SO45339_16 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 232 | 403 | 4 | 2022-03-29 | 57.68 | 1.44 | 2022-03-17 | 2 | 31.72 | 1 | 57.68 | 16 | SO45339 | 2022-03-24 | 4.61 | 63.45 | 28.84 |
SO55301_21 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 400 | 414 | 2 | 2023-11-26 | 74.30 | 1.86 | 2023-11-14 | 2 | 27.49 | 1 | 74.30 | 21 | SO55301 | 2023-11-21 | 5.94 | 54.99 | 37.15 |
SO46660_3 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 439 | 166 | 4 | 2022-08-26 | 2342.45 | 58.56 | 2022-08-14 | 3 | 722.26 | 1 | 2342.45 | 3 | SO46660 | 2022-08-21 | 187.40 | 2166.77 | 780.82 |
SO71806_6 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 298 | 497 | 6 | 2024-07-27 | 1619.52 | 40.49 | 2024-07-15 | 2 | 739.04 | 1 | 1619.52 | 6 | SO71806 | 2024-07-22 | 129.56 | 1478.08 | 809.76 |
SO63213_19 | 1A10-4A9D-B4 | PO11745122074 | 100 | 282 | 584 | 97 | 4 | 2024-03-28 | 2591.95 | 64.80 | 2024-03-16 | 8 | 343.65 | 1 | 2591.95 | 19 | SO63213 | 2024-03-23 | 207.36 | 2749.20 | 323.99 |
SO65278_4 | 5822-4DF1-92 | PO5017152408 | 100 | 289 | 503 | 308 | 1 | 2024-04-26 | 400.10 | 10.00 | 2024-04-14 | 2 | 199.85 | 1 | 400.10 | 4 | SO65278 | 2024-04-21 | 32.01 | 399.70 | 200.05 |
SO44301_26 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 340 | 491 | 4 | 2021-11-26 | 419.46 | 10.49 | 2021-11-14 | 1 | 413.15 | 1 | 419.46 | 26 | SO44301 | 2021-11-21 | 33.56 | 413.15 | 419.46 |
SO45299_13 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 318 | 240 | 4 | 2022-03-29 | 1749.59 | 43.74 | 2022-03-17 | 2 | 884.71 | 1 | 1749.59 | 13 | SO45299 | 2022-03-24 | 139.97 | 1769.42 | 874.79 |
SO45564_4 | DD65-42A2-80 | PO5220129554 | 100 | 282 | 344 | 169 | 1 | 2022-04-26 | 12239.96 | 306.00 | 2022-04-14 | 6 | 1912.15 | 1 | 12239.96 | 4 | SO45564 | 2022-04-21 | 979.20 | 11472.93 | 2039.99 |
SO45284_10 | 57F0-404F-97 | PO16733112744 | 19 | 288 | 312 | 533 | 6 | 2022-03-29 | 4293.92 | 107.35 | 2022-03-17 | 2 | 2171.29 | 1 | 4293.92 | 10 | SO45284 | 2022-03-24 | 343.51 | 4342.59 | 2146.96 |
SO51154_18 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 404 | 221 | 4 | 2023-08-26 | 53.45 | 1.34 | 2023-08-14 | 2 | 19.78 | 1 | 53.45 | 18 | SO51154 | 2023-08-21 | 4.28 | 39.55 | 26.72 |
SO57179_10 | 93FD-457E-8A | PO8584112874 | 98 | 288 | 390 | 592 | 10 | 2023-12-27 | 2016.88 | 50.42 | 2023-12-15 | 3 | 713.08 | 1 | 2016.88 | 10 | SO57179 | 2023-12-22 | 161.35 | 2139.24 | 672.29 |
SO69449_7 | 457F-4A9C-96 | PO10266117370 | 6 | 296 | 498 | 393 | 9 | 2024-06-26 | 602.35 | 15.06 | 2024-06-14 | 1 | 601.74 | 1 | 602.35 | 7 | SO69449 | 2024-06-21 | 48.19 | 601.74 | 602.35 |
SO51096_16 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 546 | 514 | 6 | 2023-08-26 | 186.27 | 4.66 | 2023-08-14 | 5 | 27.57 | 1 | 186.27 | 16 | SO51096 | 2023-08-21 | 14.90 | 137.84 | 37.25 |
SO65164_15 | 07B8-4AF8-8A | PO18299114573 | 19 | 291 | 298 | 118 | 6 | 2024-04-26 | 809.76 | 20.24 | 2024-04-14 | 1 | 739.04 | 1 | 809.76 | 15 | SO65164 | 2024-04-21 | 64.78 | 739.04 | 809.76 |
SO71802_12 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 568 | 297 | 5 | 2024-07-27 | 445.41 | 11.14 | 2024-07-15 | 1 | 461.44 | 1 | 445.41 | 12 | SO71802 | 2024-07-22 | 35.63 | 461.44 | 445.41 |
SO57121_38 | A796-4C1D-A6 | PO5771187733 | 100 | 282 | 604 | 79 | 3 | 2023-12-27 | 1619.97 | 40.50 | 2023-12-15 | 5 | 343.65 | 1 | 1619.97 | 38 | SO57121 | 2023-12-22 | 129.60 | 1718.25 | 323.99 |
SO46038_10 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 275 | 102 | 6 | 2022-06-26 | 1070.69 | 26.77 | 2022-06-14 | 3 | 352.14 | 1 | 1070.69 | 10 | SO46038 | 2022-06-21 | 85.66 | 1056.42 | 356.90 |
SO57017_9 | 4C6E-47EA-AD | PO19546126186 | 100 | 285 | 388 | 206 | 5 | 2023-12-27 | 3361.47 | 84.04 | 2023-12-15 | 5 | 713.08 | 1 | 3361.47 | 9 | SO57017 | 2023-12-22 | 268.92 | 3565.40 | 672.29 |
SO71797_26 | 8375-4C38-91 | PO16501134889 | 98 | 288 | 606 | 142 | 10 | 2024-07-27 | 1295.98 | 32.40 | 2024-07-15 | 4 | 343.65 | 1 | 1295.98 | 26 | SO71797 | 2024-07-22 | 103.68 | 1374.60 | 323.99 |
SO53534_10 | F0B1-423E-8B | PO20213153510 | 100 | 283 | 491 | 216 | 2 | 2023-10-27 | 194.36 | 4.86 | 2023-10-15 | 6 | 41.57 | 1 | 194.36 | 10 | SO53534 | 2023-10-22 | 15.55 | 249.43 | 32.39 |
SO48389_28 | 304D-46A7-8E | PO8671159284 | 98 | 288 | 305 | 502 | 10 | 2023-01-26 | 2208.44 | 55.21 | 2023-01-14 | 3 | 653.70 | 1 | 2208.44 | 28 | SO48389 | 2023-01-21 | 176.67 | 1961.09 | 736.15 |
Generated 2024-09-13 07:36:44.491 UTC