To create a new account, you should execute the following procedure: 'prc_Account_insert'.
Modifying this procedure should tell you all of the values you need to enter.
Setting the password as 'Password_not_set' will require the password to be reset on first use. This can be done either by using the 'forgotten password' link or by following this guide.
TFS Item: 72596 shows an example of creating a Best Companies account.