Where is the resource financial data stored in the database?

Document ID : KB000029848
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Where is the resource financial data stored in the database?

Where do the details of the resource financial subpage get stored?

Solution:

Once the resource is financially enabled, the PAC_MNT_RESOURCES table gets populated.

Financial Department, Financial Location, Transaction Class, Resource Class data gets stored on the table above.

The initials field and resource_code field were deprecated in Clarity 13.0, these fields being blank from 13.0 onwards