Identification of a complete sample of northern ROSAT All-Sky Survey X-ray sources. VIII. The late-type stellar component