Relationship B/W Partner and partner Function

Hi CRM Experts,

I have a requirement where i have to read the Orders based on the partner and Partner function.

I found the partners in the table CRMD_ORDER_INDEX .

I found the partner Functions in the table CRMC_PARTNER_FCT.

But i want the relation b/w the partner and the partner functions.

For example. I have the partner No: 10060071. I want to know the table where we can determine the partner whether partner belongs to sold-to , ship-to, payer...etc.

Regards,

TMR.