JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Gallery
Share
Explore
Report Automation
ABFL Reports:
Everyday emails will be received with below MIS from ABFL These emails will have .xlsx attachment Data needs to be extracted from these MIS’s excel and replaced in
SCF- Large Pipeline
google sheet under “Utilization - Auto Update” tab
JINDAL STEEL AND POWER LTD
From: “
abflportfolio@supermoney.in
“ or “
care.abf@adityabirlacapital.net.in
“
To:
“abflportfolio@supermoney.in”
Subject:
Starts with
“CF Anchorwise Outstanding MIS-JINDAL STEEL AND POWER LTD”
Haier
From: “
abflportfolio@supermoney.in
“ or “
care.abf@adityabirlacapital.net.in
“
To:
“abflportfolio@supermoney.in”
Subject:
Starts with
“
CF Anchorwise Outstanding MIS-HAIER APPLIANCES INDIA PRIVATE LIMITED”
JINDAL STAINLESS STEELWAY LTD
From: “
abflportfolio@supermoney.in
“ or “
care.abf@adityabirlacapital.net.in
“
To:
“abflportfolio@supermoney.in”
Subject:
Starts with
“
CF Anchorwise Outstanding MIS-JINDAL STAINLESS STEELWAY LIMITED
ABFL Sheet Mapping
ABFL Sheet Mapping
Target Sheet Column Name
Source Sheet Column Names
Target Sheet Column Name
Source Sheet Column Names
1
TEAM
2
Lender
"ABFL"
3
DEBTOR_ANCHOR_NAME
DEBTOR_ANCHOR_NAME
4
CLIENT_NAME
CLIENT_NAME
5
SM Spoc
6
LIMIT_AMOUNT
LIMIT_AMOUNT
7
AUM
PP_OUTSTANDING_AMT
8
AVAILABILITY(in lacs)
AVAILABILITY
9
CL_LIMIT_EXPIRY_DATE
CL_LIMIT_EXPIRY_DATE
10
Utilisation Plan
11
City
12
States
13
Zone
14
Total OD
TOTAL_OD_AMOUNT
15
Phn Nos.
16
Product
17
Cust IDs
There are no rows in this table
Kotak Report:
From: “
Scf.Mis@kotak.com
“
To: “
sheetal.kushalkar@supermoney.in
“
Subject:
Starts with
“Supermoney Utilisation report as on” <<today’s Date>>
Source and Target Sheet Mapping
Lender: Kotak
Dealer Name: Client Name
Sanction limit: Limit Amount (to be converted in Lacs)
Outstanding Amount: AUM (to be converted in Lacs)
Available Amount: Availability (to be converted in Lacs)
Kotak Sheet Mapping
Kotak Sheet Mapping
Target Sheet Column Name
Source Sheet Column Name
Target Sheet Column Name
Source Sheet Column Name
1
TEAM
2
Lender
"Kotak"
3
DEBTOR_ANCHOR_NAME
4
CLIENT_NAME
Dealer Name
5
SM Spoc
6
LIMIT_AMOUNT
Sanction limit (to be converted in Lacs)
7
AUM
Outstanding Amount (to be converted in Lacs)
8
AVAILABILITY(in lacs)
Available Amount (to be converted in Lacs)
9
CL_LIMIT_EXPIRY_DATE
10
Utilisation Plan
11
City
12
States
13
Zone
14
Total OD
15
Phn Nos.
16
Product
17
Cust IDs
There are no rows in this table
Mintwalk
(Only activated customers: JSSL, JSPL, Haier)
Lender: Hero
Program Name: DEBTOR_ANCHOR_NAME
CLIENT_NAME: Trade Name
LIMIT_AMOUNT: Sanctioned Limit (to be converted in Lacs)
AUM: Total Outstanding (princ +int+penal)(to be converted in Lacs)
CL_LIMIT_EXPIRY_DATE: 365 + Sanctioned Date
City: POB City
States: POB State
Hero
:
This will be manual
Lender: Hero
Client Name: Client Name
Product: DEBTOR_ANCHOR_NAME
Branch: City
Sanction limit: Limit Amount (to be converted in Lacs)
Utilized Amount: AUM (to be converted in Lacs)
Deal Expiry: CL_LIMIT_EXPIRY_DATE
ABFL: PID will be manual
Ugrow will be manual
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.