Re: [Mifos-users] [Mifos-developer] Where Is Loan Purpose Stored ?

[Trilok J. Pandya]

Hi Nayan, Que. 1 :-   lookup_value contains both biz. activity and loan purpose, whichever id you pass, it retrieves value for it. Discussion : - is loan_account Table have the id of loan purpose or how may i find the difference ? i want loan purpose not business activity. Que. 2 :-  is loan_account.business_activities_id used for loan propose ? , i think naming convention is bit confusing, please correct me if I am wrong. Discussion :- according to me i think loan_account.business_activities_id is used for business activity only. but i want loan purpose id. On 10-01-2011 10:53, Nayan Ambali wrote: Hi Trilok, the one initially replied by Ramya is the correct according to your need, Select loan_account.account_id,lookup_value.lookup_name From loan_account Left outer join lookup_value on loan_account.business_activities_id=lookup_value.lookup_id lookup_value contains both biz. activity and loan purpose, whichever id you pass, it retrieves value for it. @Ramya, the screen shot is from Admin section, is loan_account.business_activities_id used for loan propose ? , i think naming convention is bit confusing, please correct me if I am wrong. Thanks Nayan Ambali On Mon, Jan 10, 2011 at 10:08 AM, <ramya.toshni...@sungard.com> wrote: Trilok,   Please send me the complete screenshot because I doubt the one sent by you is of the “client creation screen “ not the loan account one. The reason is that there is a field citizenship in the screenshot which is usually captured at client level.   Thanks, Ramya   From: Trilok J. Pandya [mailto:trilok.pan...@lightmicrofinance.com] Sent: Monday, January 10, 2011 9:54 AM To: Toshniwal, Ramya Cc: mifos-develo...@lists.sourceforge.net; mifos-iss...@lists.sourceforge.net; mifos-users@lists.sourceforge.net Subject: Re: [Mifos-users] Where Is Loan Purpose Stored ?   Hi Ramya, i have just give you the screen part not whole screen. but i think i want this purpose so, i give you part of screen. i want purposes of loan account. which is in green box. On 10-01-2011 09:48, ramya.toshni...@sungard.com wrote: Hi Trilok,   I think you have renamed certain labels of loan account screen. Could you please tell me what all fields you have customized?   Thanks, Ramya   From: Trilok J. Pandya [mailto:trilok.pan...@lightmicrofinance.com] Sent: Saturday, January 08, 2011 10:29 AM To: A good place to start for users or folks new to Mifos. Cc: Toshniwal, Ramya; mifos-develo...@lists.sourceforge.net; mifos-iss...@lists.sourceforge.net Subject: Re: [Mifos-users] Where Is Loan Purpose Stored ?   Ramya the following query gives me business activity but i want loan purpose. let a give u an image. in following image is comes from admin-->define labels. you query gives the "business activity" which is in "RED CIRCLE"  but i want purpose loan which is in "GREEN BOX" in following figure.  -- On 07-01-2011 17:10, ramya.toshni...@sungard.com wrote: Hi Trilok,   Loan purpose is actually the business_activities_id in loan_account table.   So you can find the corresponding purposes in lookup_value table     Select loan_account.account_id,lookup_value.lookup_name From loan_account Left outer join lookup_value on loan_account.business_activities_id=lookup_value.lookup_id     Thanks, Ramya   From: Trilok J. Pandya [mailto:trilok.pan...@lightmicrofinance.com] Sent: Friday, January 07, 2011 4:56 PM To: Mifos Developer Discussions; mifos-users@lists.sourceforge.net; mifos-iss...@lists.sourceforge.net Subject: [Mifos-users] Where Is Loan Purpose Stored ?   Hello, In mifos database , in which table doe the loan purpose values  stored to particular members ? like select customer.display_name,customer.customer_id, loan_purpose  from ........................ --     ------------------------------------------------------------------------------ Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web.   Learn how to best implement a security strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl     _______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web.   Learn how to best implement a security strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl -- Regards Nayan G. A. 9901154134

------------------------------------------------------------------------------
Gaining the trust of online customers is vital for the success of any company
that requires sensitive data to be transmitted over the Web.   Learn how to 
best implement a security strategy that keeps consumers' information secure 
and instills the confidence they need to proceed with transactions.
http://p.sf.net/sfu/oracle-sfdevnl 
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users