[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51132_17 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 374 | 227 | 6 | 2023-09-18 | 8796.06 | 219.90 | 2023-09-06 | 6 | 1554.95 | 1 | 8796.06 | 17 | SO51132 | 2023-09-13 | 703.68 | 9329.69 | 1466.01 |
SO45532_11 | 1342-4F90-B0 | PO15834119448 | 100 | 283 | 342 | 417 | 4 | 2022-05-19 | 838.92 | 20.97 | 2022-05-07 | 2 | 413.15 | 1 | 838.92 | 11 | SO45532 | 2022-05-14 | 67.11 | 826.29 | 419.46 |
SO44752_9 | 584D-40E8-AF | PO15950187592 | 100 | 282 | 326 | 114 | 4 | 2022-02-18 | 1677.84 | 41.95 | 2022-02-06 | 4 | 413.15 | 1 | 1677.84 | 9 | SO44752 | 2022-02-13 | 134.23 | 1652.59 | 419.46 |
SO51150_23 | 5831-4C4F-B1 | PO8004129956 | 6 | 296 | 578 | 231 | 9 | 2023-09-18 | 2186.73 | 54.67 | 2023-09-06 | 3 | 755.15 | 1 | 2186.73 | 23 | SO51150 | 2023-09-13 | 174.94 | 2265.45 | 728.91 |
SO57161_18 | 5BA9-4418-9F | PO1827135302 | 19 | 291 | 547 | 317 | 6 | 2024-01-19 | 145.78 | 3.64 | 2024-01-07 | 3 | 35.96 | 1 | 145.78 | 18 | SO57161 | 2024-01-14 | 11.66 | 107.88 | 48.59 |
SO47352_26 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 456 | 149 | 3 | 2022-11-19 | 134.98 | 3.37 | 2022-11-07 | 3 | 30.93 | 1 | 134.98 | 26 | SO47352 | 2022-11-14 | 10.80 | 92.80 | 44.99 |
SO47056_50 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 461 | 403 | 4 | 2022-10-19 | 323.96 | 8.10 | 2022-10-07 | 6 | 37.12 | 1 | 323.96 | 50 | SO47056 | 2022-10-14 | 25.92 | 222.73 | 53.99 |
SO53547_1 | C80F-4007-AC | PO14065128727 | 100 | 293 | 240 | 379 | 1 | 2023-11-19 | 1717.80 | 42.95 | 2023-11-07 | 2 | 868.63 | 1 | 1717.80 | 1 | SO53547 | 2023-11-14 | 137.42 | 1737.27 | 858.90 |
SO44111_17 | CFDA-475D-95 | PO1740120267 | 19 | 288 | 270 | 460 | 6 | 2021-11-19 | 183.94 | 4.60 | 2021-11-07 | 1 | 181.49 | 1 | 183.94 | 17 | SO44111 | 2021-11-14 | 14.72 | 181.49 | 183.94 |
SO48780_12 | F139-41F4-83 | PO5626121558 | 100 | 281 | 435 | 166 | 4 | 2023-03-21 | 324.45 | 8.11 | 2023-03-09 | 1 | 300.12 | 1 | 324.45 | 12 | SO48780 | 2023-03-16 | 25.96 | 300.12 | 324.45 |
SO49827_7 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 335 | 299 | 6 | 2023-06-19 | 939.59 | 23.49 | 2023-06-07 | 2 | 486.71 | 1 | 939.59 | 7 | SO49827 | 2023-06-14 | 75.17 | 973.41 | 469.79 |
SO46326_22 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 316 | 173 | 6 | 2022-08-19 | 874.79 | 21.87 | 2022-08-07 | 1 | 884.71 | 1 | 874.79 | 22 | SO46326 | 2022-08-14 | 69.98 | 884.71 | 874.79 |
SO49837_11 | C136-4536-9D | PO12412160791 | 100 | 281 | 339 | 670 | 3 | 2023-06-19 | 3288.56 | 82.21 | 2023-06-07 | 7 | 486.71 | 1 | 3288.56 | 11 | SO49837 | 2023-06-14 | 263.08 | 3406.95 | 469.79 |
SO69513_11 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 384 | 45 | 5 | 2024-07-19 | 672.29 | 16.81 | 2024-07-07 | 1 | 713.08 | 1 | 672.29 | 11 | SO69513 | 2024-07-14 | 53.78 | 713.08 | 672.29 |
SO59028_38 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 484 | 464 | 8 | 2024-02-18 | 28.62 | 0.72 | 2024-02-06 | 6 | 2.97 | 1 | 28.62 | 38 | SO59028 | 2024-02-13 | 2.29 | 17.84 | 4.77 |
SO43857_12 | 0CD4-4091-9B | PO16733124458 | 19 | 288 | 328 | 533 | 6 | 2021-10-19 | 419.46 | 10.49 | 2021-10-07 | 1 | 413.15 | 1 | 419.46 | 12 | SO43857 | 2021-10-14 | 33.56 | 413.15 | 419.46 |
SO67294_1 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 384 | 290 | 1 | 2024-06-19 | 2689.18 | 67.23 | 2024-06-07 | 4 | 713.08 | 1 | 2689.18 | 1 | SO67294 | 2024-06-14 | 215.13 | 2852.32 | 672.29 |
SO53590_9 | E7FF-4C04-9E | PO4118162346 | 100 | 281 | 579 | 454 | 3 | 2023-11-19 | 2915.64 | 72.89 | 2023-11-07 | 4 | 755.15 | 1 | 2915.64 | 9 | SO53590 | 2023-11-14 | 233.25 | 3020.60 | 728.91 |
SO48079_23 | A42B-43D5-B0 | PO7627191699 | 100 | 293 | 271 | 433 | 1 | 2023-01-19 | 607.00 | 15.17 | 2023-01-07 | 3 | 187.16 | 1 | 607.00 | 23 | SO48079 | 2023-01-14 | 48.56 | 561.47 | 202.33 |
SO61188_2 | 0CFA-4338-90 | PO12528143455 | 100 | 282 | 565 | 331 | 4 | 2024-03-20 | 1781.64 | 44.54 | 2024-03-08 | 4 | 461.44 | 1 | 1781.64 | 2 | SO61188 | 2024-03-15 | 142.53 | 1845.78 | 445.41 |
SO44301_21 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 310 | 491 | 4 | 2021-12-19 | 2146.96 | 53.67 | 2021-12-07 | 1 | 2171.29 | 1 | 2146.96 | 21 | SO44301 | 2021-12-14 | 171.76 | 2171.29 | 2146.96 |
SO69437_12 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 487 | 175 | 7 | 2024-07-19 | 329.94 | 8.25 | 2024-07-07 | 10 | 20.57 | 1 | 329.94 | 12 | SO69437 | 2024-07-14 | 26.40 | 205.66 | 32.99 |
SO53530_28 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 434 | 90 | 5 | 2023-11-19 | 2498.29 | 62.46 | 2023-11-07 | 7 | 360.94 | 1 | 2498.29 | 28 | SO53530 | 2023-11-14 | 199.86 | 2526.60 | 356.90 |
SO50726_2 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 263 | 170 | 5 | 2023-08-19 | 1213.99 | 30.35 | 2023-08-07 | 6 | 187.16 | 1 | 1213.99 | 2 | SO50726 | 2023-08-14 | 97.12 | 1122.94 | 202.33 |
SO45544_1 | 052D-4EB1-A1 | PO11426116218 | 100 | 285 | 322 | 386 | 5 | 2022-05-19 | 419.46 | 10.49 | 2022-05-07 | 1 | 413.15 | 1 | 419.46 | 1 | SO45544 | 2022-05-14 | 33.56 | 413.15 | 419.46 |
SO69564_15 | 9BAA-4E23-A3 | PO9425176552 | 6 | 294 | 560 | 519 | 9 | 2024-07-19 | 1457.82 | 36.45 | 2024-07-07 | 2 | 755.15 | 1 | 1457.82 | 15 | SO69564 | 2024-07-14 | 116.63 | 1510.30 | 728.91 |
SO49888_12 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 415 | 234 | 2 | 2023-06-19 | 1386.25 | 34.66 | 2023-06-07 | 7 | 146.55 | 1 | 1386.25 | 12 | SO49888 | 2023-06-14 | 110.90 | 1025.83 | 198.04 |
SO53456_13 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 386 | 173 | 6 | 2023-11-19 | 2016.88 | 50.42 | 2023-11-07 | 3 | 713.08 | 1 | 2016.88 | 13 | SO53456 | 2023-11-14 | 161.35 | 2139.24 | 672.29 |
SO53492_21 | 6D1A-4E58-A3 | PO13630111535 | 6 | 294 | 488 | 640 | 9 | 2023-11-19 | 97.18 | 2.43 | 2023-11-07 | 3 | 41.57 | 1 | 97.18 | 21 | SO53492 | 2023-11-14 | 7.77 | 124.72 | 32.39 |
SO49066_25 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 381 | 426 | 6 | 2023-04-21 | 1800.79 | 45.02 | 2023-04-09 | 3 | 605.65 | 1 | 1800.79 | 25 | SO49066 | 2023-04-16 | 144.06 | 1816.95 | 600.26 |
SO51838_13 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 604 | 343 | 1 | 2023-10-19 | 647.99 | 16.20 | 2023-10-07 | 2 | 343.65 | 1 | 647.99 | 13 | SO51838 | 2023-10-14 | 51.84 | 687.30 | 323.99 |
SO46950_6 | AAC1-43D9-A3 | PO17806144306 | 19 | 291 | 233 | 101 | 6 | 2022-10-19 | 144.20 | 3.61 | 2022-10-07 | 5 | 29.08 | 1 | 144.20 | 6 | SO46950 | 2022-10-14 | 11.54 | 145.40 | 28.84 |
SO69498_1 | 7EF3-46E3-B8 | PO8758118867 | 98 | 288 | 359 | 683 | 10 | 2024-07-19 | 1376.99 | 34.42 | 2024-07-07 | 1 | 1251.98 | 1 | 1376.99 | 1 | SO69498 | 2024-07-14 | 110.16 | 1251.98 | 1376.99 |
SO48307_45 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 286 | 155 | 6 | 2023-02-18 | 183.94 | 4.60 | 2023-02-06 | 1 | 170.14 | 1 | 183.94 | 45 | SO48307 | 2023-02-13 | 14.72 | 170.14 | 183.94 |
SO50204_24 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 213 | 533 | 6 | 2023-07-19 | 40.37 | 1.01 | 2023-07-07 | 2 | 13.88 | 1 | 40.37 | 24 | SO50204 | 2023-07-14 | 3.23 | 27.76 | 20.19 |
SO69558_20 | 0B27-4F3C-97 | PO8642129578 | 98 | 288 | 586 | 520 | 10 | 2024-07-19 | 445.41 | 11.14 | 2024-07-07 | 1 | 461.44 | 1 | 445.41 | 20 | SO69558 | 2024-07-14 | 35.63 | 461.44 | 445.41 |
SO47352_21 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 448 | 149 | 3 | 2022-11-19 | 47.98 | 1.20 | 2022-11-07 | 4 | 8.25 | 1 | 47.98 | 21 | SO47352 | 2022-11-14 | 3.84 | 32.98 | 11.99 |
SO51791_19 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 436 | 552 | 6 | 2023-10-19 | 713.80 | 17.84 | 2023-10-07 | 2 | 360.94 | 1 | 713.80 | 19 | SO51791 | 2023-10-14 | 57.10 | 721.89 | 356.90 |
SO71826_37 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 491 | 176 | 8 | 2024-08-19 | 129.58 | 3.24 | 2024-08-07 | 4 | 41.57 | 1 | 129.58 | 37 | SO71826 | 2024-08-14 | 10.37 | 166.29 | 32.39 |
SO53534_25 | F0B1-423E-8B | PO20213153510 | 100 | 283 | 606 | 216 | 2 | 2023-11-19 | 647.99 | 16.20 | 2023-11-07 | 2 | 343.65 | 1 | 647.99 | 25 | SO53534 | 2023-11-14 | 51.84 | 687.30 | 323.99 |
SO47387_29 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 358 | 293 | 1 | 2022-11-19 | 3688.38 | 92.21 | 2022-11-07 | 3 | 1105.81 | 1 | 3688.38 | 29 | SO47387 | 2022-11-14 | 295.07 | 3317.43 | 1229.46 |
SO51823_12 | 2FB1-4AE1-BC | PO8642173409 | 98 | 288 | 504 | 520 | 10 | 2023-10-19 | 200.05 | 5.00 | 2023-10-07 | 1 | 199.85 | 1 | 200.05 | 12 | SO51823 | 2023-10-14 | 16.00 | 199.85 | 200.05 |
SO48745_6 | CDB4-4FFB-87 | PO2494111050 | 100 | 281 | 447 | 184 | 4 | 2023-03-21 | 75.00 | 1.88 | 2023-03-09 | 5 | 10.31 | 1 | 75.00 | 6 | SO48745 | 2023-03-16 | 6.00 | 51.56 | 15.00 |
SO46345_8 | 469D-4520-80 | PO13746192187 | 100 | 285 | 292 | 567 | 5 | 2022-08-19 | 1637.40 | 40.94 | 2022-08-07 | 2 | 706.81 | 1 | 1637.40 | 8 | SO46345 | 2022-08-14 | 130.99 | 1413.62 | 818.70 |
SO47687_16 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 375 | 203 | 4 | 2022-12-19 | 3926.81 | 98.17 | 2022-12-07 | 3 | 1320.68 | 1 | 3926.81 | 16 | SO47687 | 2022-12-14 | 314.15 | 3962.05 | 1308.94 |
SO44093_11 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 223 | 93 | 4 | 2021-11-19 | 31.12 | 0.78 | 2021-11-07 | 6 | 5.71 | 1 | 31.12 | 11 | SO44093 | 2021-11-14 | 2.49 | 34.23 | 5.19 |
SO51856_14 | E170-419C-92 | PO3654183134 | 100 | 281 | 532 | 435 | 4 | 2023-10-19 | 599.50 | 14.99 | 2023-10-07 | 4 | 136.79 | 1 | 599.50 | 14 | SO51856 | 2023-10-14 | 47.96 | 547.14 | 149.87 |
SO63132_5 | C9E0-492C-AA | PO18705140198 | 19 | 291 | 545 | 479 | 6 | 2024-04-20 | 121.47 | 3.04 | 2024-04-08 | 5 | 17.98 | 1 | 121.47 | 5 | SO63132 | 2024-04-15 | 9.72 | 89.89 | 24.29 |
SO49839_2 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 456 | 480 | 6 | 2023-06-19 | 44.99 | 1.12 | 2023-06-07 | 1 | 30.93 | 1 | 44.99 | 2 | SO49839 | 2023-06-14 | 3.60 | 30.93 | 44.99 |
SO57160_18 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 390 | 343 | 1 | 2024-01-19 | 2016.88 | 50.42 | 2024-01-07 | 3 | 713.08 | 1 | 2016.88 | 18 | SO57160 | 2024-01-14 | 161.35 | 2139.24 | 672.29 |
SO57150_6 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 496 | 85 | 7 | 2024-01-19 | 2409.38 | 60.23 | 2024-01-07 | 4 | 601.74 | 1 | 2409.38 | 6 | SO57150 | 2024-01-14 | 192.75 | 2406.97 | 602.35 |
SO71798_6 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 481 | 306 | 3 | 2024-08-19 | 43.15 | 1.08 | 2024-08-07 | 8 | 3.36 | 1 | 43.15 | 6 | SO71798 | 2024-08-14 | 3.45 | 26.90 | 5.39 |
SO51694_1 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 542 | 353 | 6 | 2023-10-19 | 24.29 | 0.61 | 2023-10-07 | 1 | 17.98 | 1 | 24.29 | 1 | SO51694 | 2023-10-14 | 1.94 | 17.98 | 24.29 |
SO48052_8 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 420 | 435 | 4 | 2023-01-19 | 1132.92 | 28.32 | 2023-01-07 | 8 | 104.80 | 1 | 1132.92 | 8 | SO48052 | 2023-01-14 | 90.63 | 838.36 | 141.62 |
SO53599_3 | 6D38-4AD7-96 | PO3973121763 | 100 | 281 | 552 | 201 | 4 | 2023-11-19 | 109.79 | 2.74 | 2023-11-07 | 2 | 40.62 | 1 | 109.79 | 3 | SO53599 | 2023-11-14 | 8.78 | 81.24 | 54.89 |
SO48325_38 | 0A85-48D3-97 | PO14268111638 | 100 | 283 | 447 | 418 | 3 | 2023-02-18 | 75.00 | 1.88 | 2023-02-06 | 5 | 10.31 | 1 | 75.00 | 38 | SO48325 | 2023-02-13 | 6.00 | 51.56 | 15.00 |
SO63233_27 | 94CA-453D-AF | PO5829114197 | 36 | 295 | 574 | 266 | 8 | 2024-04-20 | 1430.44 | 35.76 | 2024-04-08 | 1 | 1481.94 | 1 | 1430.44 | 27 | SO63233 | 2024-04-15 | 114.44 | 1481.94 | 1430.44 |
SO44782_3 | 8A91-4DA7-97 | PO4408110571 | 100 | 281 | 330 | 143 | 2 | 2022-02-18 | 419.46 | 10.49 | 2022-02-06 | 1 | 413.15 | 1 | 419.46 | 3 | SO44782 | 2022-02-13 | 33.56 | 413.15 | 419.46 |
SO50308_2 | 5160-4E43-9B | PO6496194098 | 19 | 291 | 358 | 226 | 6 | 2023-07-19 | 1229.46 | 30.74 | 2023-07-07 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO50308 | 2023-07-14 | 98.36 | 1105.81 | 1229.46 |
SO51693_10 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 243 | 206 | 5 | 2023-10-19 | 1717.80 | 42.95 | 2023-10-07 | 2 | 868.63 | 1 | 1717.80 | 10 | SO51693 | 2023-10-14 | 137.42 | 1737.27 | 858.90 |
SO49468_6 | DB7C-4159-88 | PO1885116335 | 19 | 284 | 365 | 588 | 6 | 2023-05-19 | 4535.96 | 113.40 | 2023-05-07 | 7 | 598.44 | 1 | 4535.96 | 6 | SO49468 | 2023-05-14 | 362.88 | 4189.05 | 647.99 |
SO50682_10 | 1145-4AD1-B8 | PO12354142084 | 100 | 283 | 460 | 197 | 3 | 2023-08-19 | 215.98 | 5.40 | 2023-08-07 | 4 | 37.12 | 1 | 215.98 | 10 | SO50682 | 2023-08-14 | 17.28 | 148.48 | 53.99 |
Generated 2024-10-06 16:40:35.556 UTC