There is a field called "Target Billing Rate" on the Resource Properties -> Financial subpage -> "Rates and Costs" section in Classic UI,
Where is that in the database?
Is it in the data warehouse?
Release : All
The field is contained in table PAC_MNT_RESOURCES
It is called targetbillrate
For use in query it would be PAC_MNT_RESOURCES.targetbillrate
If you want to join this back to the resource (SRM_RESROUCES) table then:
PAC_MNT_RESOURCES.id = SRM_RESOURCES.id
Note: This field is not currently included in the Data Warehouse.