[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 260 > < TAKE 56 >
56 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51143_36 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 465 | 2 | 538 | 10 | 3.98 | 2023-10-25 | 198.86 | 4.87 | 2023-10-13 | 14 | 9.16 | 1 | 194.88 | 36 | SO51143 | 2023-10-20 | 15.59 | 128.23 | 14.20 | 0.02 |
SO45341_6 | AA2C-4A41-AD | PO7830178569 | 100 | 283 | 218 | 2 | 40 | 4 | 1.54 | 2022-05-28 | 77.14 | 1.89 | 2022-05-16 | 14 | 3.40 | 1 | 75.60 | 6 | SO45341 | 2022-05-23 | 6.05 | 47.55 | 5.51 | 0.02 |
SO47419_1 | 7703-4F2C-92 | PO3103122578 | 100 | 283 | 327 | 147 | 3 | 2022-12-26 | 2818.76 | 70.47 | 2022-12-14 | 6 | 486.71 | 1 | 2818.76 | 1 | SO47419 | 2022-12-21 | 225.50 | 2920.24 | 469.79 | |||
SO61218_22 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 234 | 475 | 4 | 2024-04-26 | 299.94 | 7.50 | 2024-04-14 | 10 | 38.49 | 1 | 299.94 | 22 | SO61218 | 2024-04-21 | 24.00 | 384.92 | 29.99 | |||
SO51132_2 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 287 | 227 | 6 | 2023-10-25 | 1416.32 | 35.41 | 2023-10-13 | 7 | 204.63 | 1 | 1416.32 | 2 | SO51132 | 2023-10-20 | 113.31 | 1432.38 | 202.33 | |||
SO49878_1 | 3EF0-4F28-B3 | PO3741190259 | 100 | 285 | 327 | 404 | 5 | 2023-07-26 | 939.59 | 23.49 | 2023-07-14 | 2 | 486.71 | 1 | 939.59 | 1 | SO49878 | 2023-07-21 | 75.17 | 973.41 | 469.79 | |||
SO53452_30 | B555-4FD7-8B | PO870113712 | 100 | 286 | 503 | 621 | 1 | 2023-12-26 | 800.21 | 20.01 | 2023-12-14 | 4 | 199.85 | 1 | 800.21 | 30 | SO53452 | 2023-12-21 | 64.02 | 799.41 | 200.05 | |||
SO49888_13 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 263 | 234 | 2 | 2023-07-26 | 404.66 | 10.12 | 2023-07-14 | 2 | 187.16 | 1 | 404.66 | 13 | SO49888 | 2023-07-21 | 32.37 | 374.31 | 202.33 | |||
SO59046_2 | E122-49CE-A7 | PO348164363 | 100 | 282 | 418 | 609 | 4 | 2024-03-26 | 356.90 | 8.92 | 2024-03-14 | 1 | 360.94 | 1 | 356.90 | 2 | SO59046 | 2024-03-21 | 28.55 | 360.94 | 356.90 | |||
SO65307_7 | 1878-4FDF-80 | PO5510180917 | 100 | 287 | 471 | 5 | 4 | 2024-06-25 | 266.70 | 6.67 | 2024-06-13 | 7 | 23.75 | 1 | 266.70 | 7 | SO65307 | 2024-06-20 | 21.34 | 166.24 | 38.10 | |||
SO71902_49 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 590 | 61 | 4 | 2024-09-25 | 1846.78 | 46.17 | 2024-09-13 | 4 | 419.78 | 1 | 1846.78 | 49 | SO71902 | 2024-09-20 | 147.74 | 1679.11 | 461.69 | |||
SO45804_7 | A72B-452A-BA | PO2552178124 | 100 | 289 | 232 | 506 | 1 | 2022-07-26 | 86.52 | 2.16 | 2022-07-14 | 3 | 31.72 | 1 | 86.52 | 7 | SO45804 | 2022-07-21 | 6.92 | 95.17 | 28.84 | |||
SO57012_15 | BE3B-4D30-A7 | PO580126740 | 36 | 295 | 570 | 230 | 8 | 2024-02-25 | 1781.64 | 44.54 | 2024-02-13 | 4 | 461.44 | 1 | 1781.64 | 15 | SO57012 | 2024-02-20 | 142.53 | 1845.78 | 445.41 | |||
SO71785_4 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 595 | 16 | 272 | 1 | 135.60 | 2024-09-25 | 338.99 | 5.08 | 2024-09-13 | 3 | 308.22 | 1 | 203.40 | 4 | SO71785 | 2024-09-20 | 16.27 | 924.65 | 113.00 | 0.40 |
SO51150_25 | 5831-4C4F-B1 | PO8004129956 | 6 | 296 | 554 | 231 | 9 | 2023-10-25 | 54.94 | 1.37 | 2023-10-13 | 1 | 40.66 | 1 | 54.94 | 25 | SO51150 | 2023-10-20 | 4.40 | 40.66 | 54.94 | |||
SO71902_22 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 402 | 61 | 4 | 2024-09-25 | 72.16 | 1.80 | 2024-09-13 | 1 | 53.40 | 1 | 72.16 | 22 | SO71902 | 2024-09-20 | 5.77 | 53.40 | 72.16 | |||
SO59071_28 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 606 | 170 | 5 | 2024-03-26 | 1295.98 | 32.40 | 2024-03-14 | 4 | 343.65 | 1 | 1295.98 | 28 | SO59071 | 2024-03-21 | 103.68 | 1374.60 | 323.99 | |||
SO46636_1 | F0E4-4F58-AB | PO9889175865 | 100 | 285 | 412 | 494 | 5 | 2022-10-25 | 180.13 | 4.50 | 2022-10-13 | 1 | 133.30 | 1 | 180.13 | 1 | SO46636 | 2022-10-20 | 14.41 | 133.30 | 180.13 | |||
SO51164_3 | 595F-419D-AD | PO1421153638 | 100 | 293 | 517 | 325 | 1 | 2023-10-25 | 63.17 | 1.58 | 2023-10-13 | 2 | 23.37 | 1 | 63.17 | 3 | SO51164 | 2023-10-20 | 5.05 | 46.74 | 31.58 | |||
SO48051_14 | D18B-421F-99 | PO3596190178 | 100 | 285 | 356 | 476 | 5 | 2023-02-25 | 4971.41 | 124.29 | 2023-02-13 | 4 | 1117.86 | 1 | 4971.41 | 14 | SO48051 | 2023-02-20 | 397.71 | 4471.42 | 1242.85 | |||
SO71851_38 | AABE-4443-91 | PO18299133687 | 19 | 291 | 225 | 2 | 118 | 6 | 1.25 | 2024-09-25 | 62.57 | 1.53 | 2024-09-13 | 12 | 6.92 | 1 | 61.32 | 38 | SO71851 | 2024-09-20 | 4.91 | 83.07 | 5.21 | 0.02 |
SO71803_33 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 511 | 327 | 3 | 2024-09-25 | 655.36 | 16.38 | 2024-09-13 | 3 | 199.38 | 1 | 655.36 | 33 | SO71803 | 2024-09-20 | 52.43 | 598.13 | 218.45 | |||
SO51783_21 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 592 | 697 | 1 | 2023-11-25 | 677.99 | 16.95 | 2023-11-13 | 2 | 308.22 | 1 | 677.99 | 21 | SO51783 | 2023-11-20 | 54.24 | 616.44 | 338.99 | |||
SO46981_1 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 381 | 638 | 7 | 2022-11-25 | 3601.58 | 90.04 | 2022-11-13 | 6 | 605.65 | 1 | 3601.58 | 1 | SO46981 | 2022-11-20 | 288.13 | 3633.90 | 600.26 | |||
SO44114_19 | 3082-4C08-AA | PO3190199320 | 100 | 281 | 324 | 575 | 2 | 2021-12-26 | 1677.84 | 41.95 | 2021-12-14 | 4 | 413.15 | 1 | 1677.84 | 19 | SO44114 | 2021-12-21 | 134.23 | 1652.59 | 419.46 | |||
SO47403_1 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 305 | 254 | 1 | 2022-12-26 | 736.15 | 18.40 | 2022-12-14 | 1 | 653.70 | 1 | 736.15 | 1 | SO47403 | 2022-12-21 | 58.89 | 653.70 | 736.15 | |||
SO61193_17 | DFEB-4C0D-88 | PO551160749 | 100 | 281 | 606 | 4 | 4 | 2024-04-26 | 971.98 | 24.30 | 2024-04-14 | 3 | 343.65 | 1 | 971.98 | 17 | SO61193 | 2024-04-21 | 77.76 | 1030.95 | 323.99 | |||
SO53580_23 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 592 | 648 | 4 | 2023-12-26 | 1016.98 | 25.42 | 2023-12-14 | 3 | 308.22 | 1 | 1016.98 | 23 | SO53580 | 2023-12-21 | 81.36 | 924.65 | 338.99 | |||
SO69471_20 | 2CF9-42DE-B1 | PO18676191433 | 100 | 282 | 587 | 697 | 1 | 2024-08-25 | 3231.86 | 80.80 | 2024-08-13 | 7 | 419.78 | 1 | 3231.86 | 20 | SO69471 | 2024-08-20 | 258.55 | 2938.45 | 461.69 | |||
SO67314_12 | 6653-491A-80 | PO3828116396 | 100 | 283 | 471 | 3 | 414 | 2 | 31.43 | 2024-07-26 | 628.65 | 14.93 | 2024-07-14 | 18 | 23.75 | 1 | 597.22 | 12 | SO67314 | 2024-07-21 | 47.78 | 427.48 | 34.93 | 0.05 |
SO44762_9 | 553E-437E-92 | PO13543176259 | 100 | 287 | 218 | 293 | 1 | 2022-03-27 | 34.20 | 0.86 | 2022-03-15 | 6 | 3.40 | 1 | 34.20 | 9 | SO44762 | 2022-03-22 | 2.74 | 20.38 | 5.70 | |||
SO47394_17 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 447 | 197 | 3 | 2022-12-26 | 30.00 | 0.75 | 2022-12-14 | 2 | 10.31 | 1 | 30.00 | 17 | SO47394 | 2022-12-21 | 2.40 | 20.63 | 15.00 | |||
SO46366_6 | 45E2-4301-82 | PO4002112610 | 100 | 282 | 342 | 674 | 4 | 2022-09-25 | 838.92 | 20.97 | 2022-09-13 | 2 | 413.15 | 1 | 838.92 | 6 | SO46366 | 2022-09-20 | 67.11 | 826.29 | 419.46 | |||
SO71798_10 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 580 | 306 | 3 | 2024-09-25 | 1020.59 | 25.51 | 2024-09-13 | 1 | 1082.51 | 1 | 1020.59 | 10 | SO71798 | 2024-09-20 | 81.65 | 1082.51 | 1020.59 | |||
SO50217_4 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 297 | 650 | 1 | 2023-08-25 | 736.15 | 18.40 | 2023-08-13 | 1 | 653.70 | 1 | 736.15 | 4 | SO50217 | 2023-08-20 | 58.89 | 653.70 | 736.15 | |||
SO61207_2 | 7864-4908-A8 | PO14123129987 | 100 | 289 | 298 | 578 | 1 | 2024-04-26 | 809.76 | 20.24 | 2024-04-14 | 1 | 739.04 | 1 | 809.76 | 2 | SO61207 | 2024-04-21 | 64.78 | 739.04 | 809.76 | |||
SO46616_16 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 417 | 514 | 6 | 2022-10-25 | 2271.17 | 56.78 | 2022-10-13 | 7 | 300.12 | 1 | 2271.17 | 16 | SO46616 | 2022-10-20 | 181.69 | 2100.83 | 324.45 | |||
SO46662_54 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 460 | 660 | 3 | 2022-10-25 | 485.95 | 12.15 | 2022-10-13 | 9 | 37.12 | 1 | 485.95 | 54 | SO46662 | 2022-10-20 | 38.88 | 334.09 | 53.99 | |||
SO47662_33 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 216 | 442 | 6 | 2023-01-25 | 80.75 | 2.02 | 2023-01-13 | 4 | 13.88 | 1 | 80.75 | 33 | SO47662 | 2023-01-20 | 6.46 | 55.51 | 20.19 | |||
SO57169_1 | 8741-47A2-A2 | PO3857160888 | 100 | 281 | 606 | 256 | 4 | 2024-02-25 | 323.99 | 8.10 | 2024-02-13 | 1 | 343.65 | 1 | 323.99 | 1 | SO57169 | 2024-02-20 | 25.92 | 343.65 | 323.99 | |||
SO50231_1 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 373 | 512 | 5 | 2023-08-25 | 2617.88 | 65.45 | 2023-08-13 | 2 | 1320.68 | 1 | 2617.88 | 1 | SO50231 | 2023-08-20 | 209.43 | 2641.37 | 1308.94 | |||
SO44107_21 | 99CE-4ADA-B1 | PO261177749 | 100 | 283 | 215 | 647 | 4 | 2021-12-26 | 20.19 | 0.50 | 2021-12-14 | 1 | 12.03 | 1 | 20.19 | 21 | SO44107 | 2021-12-21 | 1.61 | 12.03 | 20.19 | |||
SO71889_33 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 490 | 2 | 3 | 4 | 7.52 | 2024-09-25 | 375.77 | 9.21 | 2024-09-13 | 12 | 41.57 | 1 | 368.26 | 33 | SO71889 | 2024-09-20 | 29.46 | 498.87 | 31.31 | 0.02 |
SO49483_10 | 7C7A-4ABF-BA | PO9686173262 | 100 | 282 | 420 | 457 | 4 | 2023-06-25 | 283.23 | 7.08 | 2023-06-13 | 2 | 104.80 | 1 | 283.23 | 10 | SO49483 | 2023-06-20 | 22.66 | 209.59 | 141.62 | |||
SO47980_13 | 4C76-4276-8E | PO17603160708 | 19 | 284 | 458 | 12 | 6 | 2023-02-25 | 359.95 | 9.00 | 2023-02-13 | 8 | 30.93 | 1 | 359.95 | 13 | SO47980 | 2023-02-20 | 28.80 | 247.47 | 44.99 | |||
SO55261_5 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 513 | 594 | 2 | 2024-01-25 | 436.91 | 10.92 | 2024-01-13 | 2 | 199.38 | 1 | 436.91 | 5 | SO55261 | 2024-01-20 | 34.95 | 398.75 | 218.45 | |||
SO57157_17 | 2435-487B-AC | PO4843135815 | 100 | 287 | 482 | 257 | 4 | 2024-02-25 | 5.39 | 0.13 | 2024-02-13 | 1 | 3.36 | 1 | 5.39 | 17 | SO57157 | 2024-02-20 | 0.43 | 3.36 | 5.39 | |||
SO48336_27 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 265 | 72 | 2 | 2023-03-27 | 809.33 | 20.23 | 2023-03-15 | 4 | 187.16 | 1 | 809.33 | 27 | SO48336 | 2023-03-22 | 64.75 | 748.63 | 202.33 | |||
SO71902_46 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 491 | 61 | 4 | 2024-09-25 | 161.97 | 4.05 | 2024-09-13 | 5 | 41.57 | 1 | 161.97 | 46 | SO71902 | 2024-09-20 | 12.96 | 207.86 | 32.39 | |||
SO49488_5 | AB06-4177-BD | PO15515149078 | 100 | 292 | 461 | 481 | 7 | 2023-06-25 | 107.99 | 2.70 | 2023-06-13 | 2 | 37.12 | 1 | 107.99 | 5 | SO49488 | 2023-06-20 | 8.64 | 74.24 | 53.99 | |||
SO49095_13 | EDD6-411E-A3 | PO18676116817 | 100 | 282 | 421 | 697 | 1 | 2023-05-28 | 588.99 | 14.72 | 2023-05-16 | 3 | 145.28 | 1 | 588.99 | 13 | SO49095 | 2023-05-23 | 47.12 | 435.85 | 196.33 | |||
SO47353_24 | 7C9E-474F-9A | PO19604180596 | 98 | 288 | 470 | 340 | 10 | 2022-12-26 | 159.56 | 3.99 | 2022-12-14 | 7 | 15.67 | 1 | 159.56 | 24 | SO47353 | 2022-12-21 | 12.76 | 109.70 | 22.79 | |||
SO53573_39 | F674-4899-B9 | PO8671117198 | 98 | 288 | 353 | 2 | 502 | 10 | 349.85 | 2023-12-26 | 17492.72 | 428.57 | 2023-12-14 | 13 | 1265.62 | 1 | 17142.87 | 39 | SO53573 | 2023-12-21 | 1371.43 | 16453.05 | 1345.59 | 0.02 |
SO69464_39 | 8924-465B-BE | PO2668146931 | 100 | 292 | 490 | 535 | 7 | 2024-08-25 | 129.58 | 3.24 | 2024-08-13 | 4 | 41.57 | 1 | 129.58 | 39 | SO69464 | 2024-08-20 | 10.37 | 166.29 | 32.39 | |||
SO46097_1 | 9835-4D6A-8F | PO6670136353 | 100 | 281 | 241 | 432 | 2 | 2022-08-25 | 1516.15 | 37.90 | 2022-08-13 | 2 | 747.97 | 1 | 1516.15 | 1 | SO46097 | 2022-08-20 | 121.29 | 1495.94 | 758.08 | |||
SO48076_14 | C38A-4C0F-BD | PO7424167037 | 100 | 281 | 469 | 2 | 642 | 2 | 5.29 | 2023-02-25 | 264.41 | 6.48 | 2023-02-13 | 12 | 15.67 | 1 | 259.12 | 14 | SO48076 | 2023-02-20 | 20.73 | 188.05 | 22.03 | 0.02 |
Generated 2024-11-13 02:26:53.563 UTC