Jofel,
Welcome to the community!
By client activities, I believe you mean Business Activities? Either way,
for most items like that they link to the lookup tables (See the Mifos
database to see more), the primary one being the lookup_value tables. You
can do joins to get the activities properly displayed.
Additionally, I recommend using DBVisualizer (http://www.dbvis.com/) for
navigating the schema. It has a very nice tool for showing a dynamic and
visual layout on how tables are connected!
Hope that helps out and please, share back with the community the query you
come up with.
Cheers,
Ryan
On 9/28/10 9:26, "Jofel Gandeza" <[email protected]> wrote:
>
> Hi guys!
>
> What table can I find the master list of Client's activities? Or the tables
> linking to customer_details table since it just contain CODES for the customer
> details?
>
> Any help from you guys is highly appreciated!
>
> Thank you.
>
> Jofel
>
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
>
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
--
Ryan Whitney
Mifos Technical Program Manager
[email protected]
Mifos® - Technology that Empowers Microfinance (www.mifos.org)
Our mission is to enable the poor, especially the poorest, to create a world
without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
