Versions Compared

Version Old Version 16 New Version 17
Changes made by

Chris Smith

Chris Smith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeEclipse
title1. View current accountant code assignments
select accountant_code, user_id from ps_accountant_codes order by to_number(accountant_code);


Code Block
languagesql
themeEclipse
title2a. Assign a new user to an existing accountant code
update ps_accountant_codes set user_id='efitzp01' where accountant_code='99';

...