Hi All,
I Have a Senarion, I have two tables on is tbl_CreditLine_Funding_Details and tbl_FundingLine_Entry,
I vl pass the Creditline_id based on this it should take the FUNDER_NAME_Id and FUNDING_BRANCH_ID
and update the loan_assigned with Amount_Sanctioned for that credit line. please find the table details with sample data:
[tbl_FundingLine_Entry]
ID Funding_Type_Id Funder_Name_Id Funding_Branch_Id Net_Balance User_Id Modifiedon Loan_Assigned
1 1061 1068 NULL 1542145.00 1 2015-10-21 10:59:26.113 0.00
3 1067 1070 NULL 232332.00 1 2015-10-21 05:38:34.000 0.00
5 1073 1075 1076 252500.00 1 2015-12-03 16:24:49.000 94000.00
tbl_CreditLine_Funding_Details:
ID CreditLine_Id Funding_Instituition_Id Funding_Name_Id Funding_Branch_Id Amount_Sanctioned Comments
7 21 1061 1068 NULL 25000.00
8 21 1067 1070 NULL 25000.00
9 22 1073 1075 1076 25000.00
10 22 1067 1070 NULL 25000.00
11 23 1067 1070 NULL 28000.00
12 23 1073 1075 1076 22000.00
kindly help me, its very urgent.
Thanks & Regards,
Kiran Murali