Hi Rohan.

Greetings!

You can please use some query like this.

select (nvl(<column which holds account number>,'00')|| Nominal || cost_center)) full_account_code from <your table name>;

In above query, nvl part is optional i.e. you can avoid nvl(<column which holds account number>,'00') by using (<column which holds account number>) and rest is self-explanatory.

Please do reach out back for any additional information required in this regard.

Regards

Prasad B.

HI Prasad

I am familiar with the SQL. Please let me know the tables which has the Full Account Code for an employee

Regards

Rohan

Hi Rohan.

Specifically, a table name which has full employee code can't be told directly unless I have the database access.

However, Given access to associated db, I can find out for you.

Regards

Prasad B.

Hello, we hope we were able to resolve your query. Please know, we are always there to help you out in such times.

Thanks for you cooperation

Have a great day!

Thanks