[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 939 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50228_2 | D5B0-4F26-BC | PO11629145611 | 100 | 283 | 297 | 396 | 2 | 2023-07-02 | 736.15 | 18.40 | 2023-06-20 | 1 | 653.70 | 1 | 736.15 | 2 | SO50228 | 2023-06-27 | 58.89 | 653.70 | 736.15 | |||
SO45291_15 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 312 | 328 | 4 | 2022-04-04 | 8587.85 | 214.70 | 2022-03-23 | 4 | 2171.29 | 1 | 8587.85 | 15 | SO45291 | 2022-03-30 | 687.03 | 8685.18 | 2146.96 | |||
SO48349_16 | CD94-4B46-9E | PO1624135169 | 100 | 283 | 448 | 579 | 3 | 2023-02-01 | 71.96 | 1.80 | 2023-01-20 | 6 | 8.25 | 1 | 71.96 | 16 | SO48349 | 2023-01-27 | 5.76 | 49.48 | 11.99 | |||
SO71952_31 | 9490-4552-81 | PO9715163911 | 100 | 281 | 400 | 490 | 4 | 2024-08-02 | 260.06 | 6.50 | 2024-07-21 | 7 | 27.49 | 1 | 260.06 | 31 | SO71952 | 2024-07-28 | 20.81 | 192.45 | 37.15 | |||
SO65263_12 | C0DD-4323-8C | PO7395113656 | 100 | 286 | 400 | 542 | 1 | 2024-05-02 | 74.30 | 1.86 | 2024-04-20 | 2 | 27.49 | 1 | 74.30 | 12 | SO65263 | 2024-04-27 | 5.94 | 54.99 | 37.15 | |||
SO49140_15 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 333 | 84 | 6 | 2023-04-04 | 2348.97 | 58.72 | 2023-03-23 | 5 | 486.71 | 1 | 2348.97 | 15 | SO49140 | 2023-03-30 | 187.92 | 2433.53 | 469.79 | |||
SO69560_20 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 594 | 16 | 100 | 6 | 45.20 | 2024-07-02 | 113.00 | 1.70 | 2024-06-20 | 1 | 308.22 | 1 | 67.80 | 20 | SO69560 | 2024-06-27 | 5.42 | 308.22 | 113.00 | 0.40 |
SO47061_5 | 58AC-406C-9C | PO8584111730 | 98 | 288 | 415 | 592 | 10 | 2022-10-02 | 594.11 | 14.85 | 2022-09-20 | 3 | 146.55 | 1 | 594.11 | 5 | SO47061 | 2022-09-27 | 47.53 | 439.64 | 198.04 | |||
SO57188_12 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 515 | 100 | 6 | 2024-01-02 | 32.54 | 0.81 | 2023-12-21 | 2 | 12.04 | 1 | 32.54 | 12 | SO57188 | 2023-12-28 | 2.60 | 24.08 | 16.27 | |||
SO59018_31 | F605-4DA0-8F | PO8033148787 | 6 | 296 | 559 | 15 | 9 | 2024-02-01 | 48.58 | 1.21 | 2024-01-20 | 4 | 8.99 | 1 | 48.58 | 31 | SO59018 | 2024-01-27 | 3.89 | 35.95 | 12.14 | |||
SO71837_25 | 103E-49BF-93 | PO1624180133 | 100 | 281 | 408 | 579 | 3 | 2024-08-02 | 72.16 | 1.80 | 2024-07-21 | 1 | 53.40 | 1 | 72.16 | 25 | SO71837 | 2024-07-28 | 5.77 | 53.40 | 72.16 | |||
SO65257_12 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 564 | 539 | 2 | 2024-05-02 | 2860.88 | 71.52 | 2024-04-20 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO65257 | 2024-04-27 | 228.87 | 2963.88 | 1430.44 | |||
SO69398_5 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 231 | 28 | 6 | 2024-07-02 | 89.98 | 2.25 | 2024-06-20 | 3 | 38.49 | 1 | 89.98 | 5 | SO69398 | 2024-06-27 | 7.20 | 115.48 | 29.99 | |||
SO53464_13 | E113-419B-8F | PO17545119283 | 19 | 291 | 583 | 155 | 6 | 2023-11-02 | 2041.19 | 51.03 | 2023-10-21 | 2 | 1082.51 | 1 | 2041.19 | 13 | SO53464 | 2023-10-28 | 163.30 | 2165.02 | 1020.59 | |||
SO55322_25 | D600-436A-B7 | PO7859118281 | 100 | 287 | 255 | 221 | 4 | 2023-12-02 | 404.66 | 10.12 | 2023-11-20 | 2 | 204.63 | 1 | 404.66 | 25 | SO55322 | 2023-11-27 | 32.37 | 409.25 | 202.33 | |||
SO71825_1 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 476 | 586 | 6 | 2024-08-02 | 335.95 | 8.40 | 2024-07-21 | 8 | 26.18 | 1 | 335.95 | 1 | SO71825 | 2024-07-28 | 26.88 | 209.41 | 41.99 | |||
SO47725_33 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 329 | 81 | 5 | 2022-12-02 | 2818.76 | 70.47 | 2022-11-20 | 6 | 486.71 | 1 | 2818.76 | 33 | SO47725 | 2022-11-27 | 225.50 | 2920.24 | 469.79 | |||
SO53614_10 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 527 | 21 | 4 | 2023-11-02 | 633.72 | 15.84 | 2023-10-21 | 4 | 144.59 | 1 | 633.72 | 10 | SO53614 | 2023-10-28 | 50.70 | 578.38 | 158.43 | |||
SO47367_3 | 7C51-451A-B4 | PO17139175308 | 100 | 286 | 239 | 644 | 1 | 2022-11-02 | 780.82 | 19.52 | 2022-10-21 | 1 | 722.26 | 1 | 780.82 | 3 | SO47367 | 2022-10-28 | 62.47 | 722.26 | 780.82 | |||
SO51859_2 | 7ECC-4741-9B | PO3306186283 | 100 | 293 | 507 | 181 | 1 | 2023-10-02 | 200.05 | 5.00 | 2023-09-20 | 1 | 199.85 | 1 | 200.05 | 2 | SO51859 | 2023-09-27 | 16.00 | 199.85 | 200.05 | |||
SO47355_40 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 375 | 2 | 24 | 4 | 278.37 | 2022-11-02 | 13918.37 | 341.00 | 2022-10-21 | 11 | 1320.68 | 1 | 13640.00 | 40 | SO47355 | 2022-10-28 | 1091.20 | 14527.52 | 1265.31 | 0.02 |
SO57168_41 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 376 | 436 | 4 | 2024-01-02 | 8796.06 | 219.90 | 2023-12-21 | 6 | 1554.95 | 1 | 8796.06 | 41 | SO57168 | 2023-12-28 | 703.68 | 9329.69 | 1466.01 | |||
SO46673_13 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 447 | 315 | 5 | 2022-09-01 | 45.00 | 1.13 | 2022-08-20 | 3 | 10.31 | 1 | 45.00 | 13 | SO46673 | 2022-08-27 | 3.60 | 30.94 | 15.00 | |||
SO53510_11 | 8E8D-4B13-B1 | PO10962181057 | 19 | 284 | 515 | 685 | 6 | 2023-11-02 | 32.54 | 0.81 | 2023-10-21 | 2 | 12.04 | 1 | 32.54 | 11 | SO53510 | 2023-10-28 | 2.60 | 24.08 | 16.27 | |||
SO67302_30 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 516 | 442 | 6 | 2024-06-02 | 93.94 | 2.35 | 2024-05-21 | 4 | 17.38 | 1 | 93.94 | 30 | SO67302 | 2024-05-28 | 7.51 | 69.51 | 23.48 | |||
SO47027_20 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 375 | 436 | 4 | 2022-10-02 | 2617.88 | 65.45 | 2022-09-20 | 2 | 1320.68 | 1 | 2617.88 | 20 | SO47027 | 2022-09-27 | 209.43 | 2641.37 | 1308.94 | |||
SO51108_33 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 476 | 4 | 530 | 5 | 108.48 | 2023-09-01 | 1084.85 | 24.41 | 2023-08-20 | 31 | 26.18 | 1 | 976.36 | 33 | SO51108 | 2023-08-27 | 78.11 | 811.47 | 35.00 | 0.10 |
SO63219_10 | E19D-4F90-91 | PO7453184328 | 100 | 283 | 465 | 108 | 2 | 2024-04-03 | 58.78 | 1.47 | 2024-03-22 | 4 | 9.16 | 1 | 58.78 | 10 | SO63219 | 2024-03-29 | 4.70 | 36.64 | 14.69 | |||
SO51793_33 | D763-4929-9B | PO18705168707 | 19 | 291 | 520 | 479 | 6 | 2023-10-02 | 63.17 | 1.58 | 2023-09-20 | 2 | 23.37 | 1 | 63.17 | 33 | SO51793 | 2023-09-27 | 5.05 | 46.74 | 31.58 | |||
SO61218_12 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 544 | 475 | 4 | 2024-03-03 | 48.59 | 1.21 | 2024-02-20 | 1 | 35.96 | 1 | 48.59 | 12 | SO61218 | 2024-02-27 | 3.89 | 35.96 | 48.59 | |||
SO51776_11 | 9800-4D08-BA | PO2871145495 | 100 | 283 | 491 | 522 | 2 | 2023-10-02 | 194.36 | 4.86 | 2023-09-20 | 6 | 41.57 | 1 | 194.36 | 11 | SO51776 | 2023-09-27 | 15.55 | 249.43 | 32.39 | |||
SO49503_6 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 308 | 293 | 1 | 2023-05-02 | 744.27 | 18.61 | 2023-04-20 | 1 | 660.91 | 1 | 744.27 | 6 | SO49503 | 2023-04-27 | 59.54 | 660.91 | 744.27 | |||
SO53460_35 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 483 | 3 | 24 | 4 | 59.40 | 2023-11-02 | 1188.00 | 28.22 | 2023-10-21 | 18 | 44.88 | 1 | 1128.60 | 35 | SO53460 | 2023-10-28 | 90.29 | 807.84 | 66.00 | 0.05 |
SO69489_6 | 6F48-4F2F-BC | PO14326153108 | 100 | 283 | 234 | 107 | 2 | 2024-07-02 | 89.98 | 2.25 | 2024-06-20 | 3 | 38.49 | 1 | 89.98 | 6 | SO69489 | 2024-06-27 | 7.20 | 115.48 | 29.99 | |||
SO44546_1 | E0B8-49EB-91 | PO4553186712 | 100 | 282 | 319 | 313 | 4 | 2022-01-02 | 1749.59 | 43.74 | 2021-12-21 | 2 | 884.71 | 1 | 1749.59 | 1 | SO44546 | 2021-12-28 | 139.97 | 1769.42 | 874.79 | |||
SO53577_24 | A44D-449C-80 | PO5713160840 | 98 | 288 | 523 | 52 | 10 | 2023-11-02 | 63.17 | 1.58 | 2023-10-21 | 2 | 23.37 | 1 | 63.17 | 24 | SO53577 | 2023-10-28 | 5.05 | 46.74 | 31.58 | |||
SO61238_8 | 0A37-46F4-8E | PO8410140860 | 98 | 288 | 488 | 538 | 10 | 2024-03-03 | 32.39 | 0.81 | 2024-02-20 | 1 | 41.57 | 1 | 32.39 | 8 | SO61238 | 2024-02-27 | 2.59 | 41.57 | 32.39 | |||
SO50203_9 | 821E-4862-9A | PO17603125956 | 19 | 284 | 448 | 12 | 6 | 2023-07-02 | 35.98 | 0.90 | 2023-06-20 | 3 | 8.25 | 1 | 35.98 | 9 | SO50203 | 2023-06-27 | 2.88 | 24.74 | 11.99 | |||
SO69402_1 | CF2F-4864-B4 | PO16791116995 | 100 | 283 | 418 | 36 | 2 | 2024-07-02 | 356.90 | 8.92 | 2024-06-20 | 1 | 360.94 | 1 | 356.90 | 1 | SO69402 | 2024-06-27 | 28.55 | 360.94 | 356.90 | |||
SO57168_2 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 482 | 2 | 436 | 4 | 1.46 | 2024-01-02 | 73.00 | 1.79 | 2023-12-21 | 14 | 3.36 | 1 | 71.54 | 2 | SO57168 | 2023-12-28 | 5.72 | 47.07 | 5.21 | 0.02 |
SO55260_3 | 0097-43FD-B7 | PO11861162351 | 100 | 283 | 471 | 17 | 5 | 2023-12-02 | 228.60 | 5.72 | 2023-11-20 | 6 | 23.75 | 1 | 228.60 | 3 | SO55260 | 2023-11-27 | 18.29 | 142.49 | 38.10 | |||
SO47436_3 | 4AA1-4884-91 | PO5510133089 | 100 | 287 | 323 | 5 | 4 | 2022-11-02 | 2348.97 | 58.72 | 2022-10-21 | 5 | 486.71 | 1 | 2348.97 | 3 | SO47436 | 2022-10-28 | 187.92 | 2433.53 | 469.79 | |||
SO45300_3 | 650B-4342-95 | PO12586158748 | 100 | 285 | 212 | 278 | 5 | 2022-04-04 | 100.93 | 2.52 | 2022-03-23 | 5 | 12.03 | 1 | 100.93 | 3 | SO45300 | 2022-03-30 | 8.07 | 60.14 | 20.19 | |||
SO51120_32 | 6C2D-4670-B0 | PO10324111289 | 98 | 288 | 484 | 196 | 10 | 2023-09-01 | 14.31 | 0.36 | 2023-08-20 | 3 | 2.97 | 1 | 14.31 | 32 | SO51120 | 2023-08-27 | 1.14 | 8.92 | 4.77 | |||
SO48050_13 | 88AC-458C-88 | PO3625155257 | 100 | 281 | 242 | 666 | 2 | 2023-01-02 | 780.82 | 19.52 | 2022-12-21 | 1 | 722.26 | 1 | 780.82 | 13 | SO48050 | 2022-12-28 | 62.47 | 722.26 | 780.82 | |||
SO46647_21 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 366 | 506 | 1 | 2022-09-01 | 1295.99 | 32.40 | 2022-08-20 | 2 | 598.44 | 1 | 1295.99 | 21 | SO46647 | 2022-08-27 | 103.68 | 1196.87 | 647.99 | |||
SO46629_21 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 381 | 670 | 3 | 2022-09-01 | 1200.53 | 30.01 | 2022-08-20 | 2 | 605.65 | 1 | 1200.53 | 21 | SO46629 | 2022-08-27 | 96.04 | 1211.30 | 600.26 | |||
SO51860_8 | 3799-43C6-B7 | PO3625164674 | 100 | 283 | 481 | 666 | 2 | 2023-10-02 | 16.18 | 0.40 | 2023-09-20 | 3 | 3.36 | 1 | 16.18 | 8 | SO51860 | 2023-09-27 | 1.29 | 10.09 | 5.39 | |||
SO51734_51 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 582 | 638 | 7 | 2023-10-02 | 1020.59 | 25.51 | 2023-09-20 | 1 | 1082.51 | 1 | 1020.59 | 51 | SO51734 | 2023-09-27 | 81.65 | 1082.51 | 1020.59 | |||
SO61236_7 | 1CCD-453C-A4 | PO10237145027 | 100 | 287 | 580 | 41 | 4 | 2024-03-03 | 8164.75 | 204.12 | 2024-02-20 | 8 | 1082.51 | 1 | 8164.75 | 7 | SO61236 | 2024-02-27 | 653.18 | 8660.08 | 1020.59 | |||
SO59010_30 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 599 | 109 | 1 | 2024-02-01 | 971.98 | 24.30 | 2024-01-20 | 3 | 294.58 | 1 | 971.98 | 30 | SO59010 | 2024-01-27 | 77.76 | 883.74 | 323.99 | |||
SO57118_25 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 463 | 63 | 5 | 2024-01-02 | 14.69 | 0.37 | 2023-12-21 | 1 | 9.16 | 1 | 14.69 | 25 | SO57118 | 2023-12-28 | 1.18 | 9.16 | 14.69 | |||
SO67327_18 | 2D2C-4C57-A2 | PO6467126287 | 100 | 283 | 480 | 660 | 3 | 2024-06-02 | 9.62 | 0.24 | 2024-05-21 | 7 | 0.86 | 1 | 9.62 | 18 | SO67327 | 2024-05-28 | 0.77 | 6.00 | 1.37 | |||
SO51729_6 | 5C3E-453A-B0 | PO13369147165 | 100 | 292 | 434 | 391 | 7 | 2023-10-02 | 1427.59 | 35.69 | 2023-09-20 | 4 | 360.94 | 1 | 1427.59 | 6 | SO51729 | 2023-09-27 | 114.21 | 1443.77 | 356.90 | |||
SO51774_28 | 30BA-400A-89 | PO2668194455 | 100 | 292 | 306 | 535 | 7 | 2023-10-02 | 809.76 | 20.24 | 2023-09-20 | 1 | 739.04 | 1 | 809.76 | 28 | SO51774 | 2023-09-27 | 64.78 | 739.04 | 809.76 | |||
SO51143_16 | 5AF9-4974-90 | PO8410118711 | 98 | 288 | 408 | 538 | 10 | 2023-09-01 | 144.32 | 3.61 | 2023-08-20 | 2 | 53.40 | 1 | 144.32 | 16 | SO51143 | 2023-08-27 | 11.55 | 106.80 | 72.16 | |||
SO71841_46 | 1544-4561-AB | PO1798133189 | 19 | 291 | 515 | 10 | 6 | 2024-08-02 | 65.09 | 1.63 | 2024-07-21 | 4 | 12.04 | 1 | 65.09 | 46 | SO71841 | 2024-07-28 | 5.21 | 48.17 | 16.27 | |||
SO61228_20 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 584 | 81 | 5 | 2024-03-03 | 323.99 | 8.10 | 2024-02-20 | 1 | 343.65 | 1 | 323.99 | 20 | SO61228 | 2024-02-27 | 25.92 | 343.65 | 323.99 | |||
SO51850_14 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 467 | 263 | 6 | 2023-10-02 | 88.16 | 2.20 | 2023-09-20 | 6 | 9.16 | 1 | 88.16 | 14 | SO51850 | 2023-09-27 | 7.05 | 54.96 | 14.69 | |||
SO44792_5 | C9BB-4C43-86 | PO7192141378 | 100 | 289 | 345 | 20 | 1 | 2022-02-01 | 2039.99 | 51.00 | 2022-01-20 | 1 | 1912.15 | 1 | 2039.99 | 5 | SO44792 | 2022-01-27 | 163.20 | 1912.15 | 2039.99 | |||
SO51090_44 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 290 | 475 | 4 | 2023-09-01 | 1637.40 | 40.94 | 2023-08-20 | 2 | 747.20 | 1 | 1637.40 | 44 | SO51090 | 2023-08-27 | 130.99 | 1494.40 | 818.70 | |||
SO47369_5 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 415 | 239 | 4 | 2022-11-02 | 792.14 | 19.80 | 2022-10-21 | 4 | 146.55 | 1 | 792.14 | 5 | SO47369 | 2022-10-28 | 63.37 | 586.19 | 198.04 |
Generated 2024-09-19 19:18:58.540 UTC