BUSINESS LOAN APPROVAL & DATABASE FORMATS
HOW TO COPY …. •
BL Approval Database file I copy bra;J D Drive y; paste bra;J bfhs;s ntz;Lk;/
•
gpwF file I open bra;J Tool menu-tpy; options-I fpspf; bra;a ntz;Lk;/
•
mjpy; Security-I fpspf; bra;J Marco Security-I njh;t[ bra;a ntz;Lk;/ gpwF Low vd;w option - I njh;t[ bra;a ntz;Lk;/
•
gpwF file I close bra;J kWgoa[k; open bra;a ntz;Lk;/
SHEETS IN THE FILE….
•
fld; Ma;t[ gotj;jpy; cs;s tpgu';fis epug;gpa gpwF.
SAVE vd;w
gl;lid fpspf; bra;a ntz;Lk;/ ,t;thW fpspf; bra;j gpwF me;j cWg;gpdh; bjhHpy; fld; bgw jFjpa[s;stuh vd rhpghh;f;fg;gl;L message display bra;ag;gLk;/ xU ntis cWg;gpdu; jFjpaw;wtuhf ,Uf;Fk;gl;rj;jpy; ”Do you want to continue” nfl;fg;gLk; bghGJ ”Yes” vd;W fpspf; bra;a ntz;Lk;/
vd;W
•
jw;nghJ process bra;J bfhz;oUf;Fk; cWg;gpduJ Approval form-I jdpahf xU file-ypy; nghl CREATE APPROVAL FILE gl;lid fpspf; bra;a ntz;Lk;/ ,t;thW bra;tjd; K:yk; vd;w D drive-y; OPERATIONS\BUSINESS LOAN vd;w folder create bra;ag;gLk;/ gpwF file name bfhLf;f ntz;Lk;/
•
file name bfhLj;j gpwF SUBMIT APPROVAL FORM vd;w gl;lid fpspf; bra;a ntz;Lk;/ bjhlh;r;rpahf ,e;j database-I cgnahfg;gLj;Jk; nghJ xt;bthU cWg;gpduJ tpgu';fisa[k; ilg; bra;J Koj;J. SAVE gl;lid fpspf; bra;J gpwF. SUBMIT APPROVAL FORM vd;w gl;lid fpspf; bra;a ntz;Lk;/
•
Kd;ng cs;s file-ypy; SAVE bra;a tpUk;gpdhy; SUBMIT APPROVAL FORM vd;w gl;lid fpspf; bra;a ntz;Lk;/ gpwF D drive-y; OPERATIONS\BUSINESS LOAN vd;w folder –Uf;Fs; jh';fs; SAVE bra;a tpUk;g[k; file-ypd; bgaiu njh;t[ bra;a ntz;Lk;/ gpwF kWgoa[k; SUBMIT APPROVAL FORM vd;w gl;lid fpspf; bra;a ntz;Lk;/
•
jh';fs; create bra;j APPROVAL FORM file-I ghh;f;f
FORM
VIEW APPROVAL
vd;w gl;lid fpspf; bra;a ntz;Lk;/ APPROVAL FORM -I ghh;j;j gpwF clnd
file I close bra;a ntz;Lk;/
LOAN DISBURSEMENT DETAILS
• mDkjp mspf;fg;gl;l bjhHpy; fld;fis tH';fpa gpwF. ,e;j database file- I open bra;J cWg;gpdu; bgaiu njh;t[ bra;a ntz;Lk;/ • gpwF Loan Disbursement Details vd;w jiyg;gpd; fPH; cs;s tpgu';fis ilg; bra;a ntz;Lk;/
SAVE DATABASE
• gpwF
vd;w gl;lid fpspf; bra;a ntz;Lk;/
cWg;gpdu; tpgu';fis delete /clear bra;a tpUk;gpdhy;. cWg;gpdh; bgaiu njh;t[ bra;J. SAVCLEAR ALL vd;w gl;lid fpspf; bra;a ntz;Lk;/ mt;thW fpspf; bra;a[k; nghJ ”Do you want to delete from database” vd;W nfl;fg;gLk; bghGJ ”Yes” vd;W fpspf; bra;a ntz;Lk;/ mt;thW ”Yes” vd;W fpspf; bra;jhy;. Database-y; cs;s tpgu';fSk; delete bra;ag;gLk;/ ”No” vd;W fpspf; bra;jhy; INPUT sheet-y; cs;s tpgu';fs; kl;Lnk delete bra;ag;gLk;/
• SAVE DATABASE vd;w gl;ld; fld; tH';fpa gpwF kl;Lnk njh;t[ bra;a ntz;Lk;/
DATABASES • ACTIVE DATABASE
-
elg;g[ fld; bjhif kw;Wk; elg;g[ fld; bjhiff;fhf bra;ag;gl;l fld; Ma;t[ tpgu';fs; kl;Lk; ACTIVE DATABASE y; ,Uf;Fk;/ ilg; bra;a njitapy;iy/
• DATABASE-1 YR-
,J jhdhfnt generate bra;ag;gLk;/ Kjy; bjhHpy; fld; bgWk; nghJ bra;ag;gl;l fld; Ma;t[ tpgu';fs; kl;Lk; ,Uf;Fk;/
• DATABASE-2 YR-
,J jhdhfnt generate bra;ag;gLk;/ ,uz;lhtJ bjhHpy; fld; tH';Fk; nghJ bra;ag;gl;l fld; Ma;t[ tpgu';fs; kl;Lk; ,Uf;Fk;/
• DATABASE-3 YR-
,J jhdhfnt generate bra;ag;gLk;/ K:d;whtJ bjhHpy; fld; tH';Fk; nghJ bra;ag;gl;l fld; Ma;t[ tpgu';fs; kl;Lk; ,Uf;Fk;/
• DATABASE-4 YR-
,J jhdhfnt generate bra;ag;gLk;/ ehd;fhtJ bjhHpy; fld; tH';Fk; nghJ bra;ag;gl;l fld; Ma;t[ tpgu';fs; kl;Lk; ,Uf;Fk;/