| New Client Master Feed Structure
|
| Field Sequence
|
Data Item
|
Type
|
Can be blank
|
Length
|
Remarks
|
| Field1
|
CLIENT CODE
|
Character
|
No
|
10
|
Client Code
|
| Field2
|
DEMAT HOLDING NATURE
|
Character
|
No
|
2
|
SI – Single
JO - Joint
|
| Field3 |
TAX STATUS CODE
|
Character
|
No
|
2
|
TAX STATUS CODE (Mandatory for all Transaction)
|
| Field4 |
OCCUPATION CODE
|
Number
|
No
|
2
|
OCCUPATION_CODE (Mandatory for all Transaction)
|
| Field5 |
CLIENT NAME
|
Character
|
No
|
70
|
Name 1
|
| Field6 |
JH1 Name 1
|
Character
|
Yes
|
35
|
Name 2
|
| Field7
|
JH1 Name 3
|
Character
|
Yes
|
35
|
Name 3
|
| Field8 |
DOB
|
Date
|
Yes
|
|
1) Mandatory if tax status is 'on behalf of minor'.
|
| Field9 |
GENDER
|
Character
|
Yes
|
1
|
M- Male
F-female
|
| Field10
|
GUARDIAN NAME
|
Character
|
Yes
|
35
|
Guardian's Name-Applicable if tax status is 'on behalf of minor'
|
| Field11
|
Client PAN
|
Character
|
No
|
10
|
PAN Number of Trade Account
|
| Field12
|
NOMINEE NAME
|
Character
|
Yes
|
35
|
Nominee Name (OPTIONAL)
|
| Field13 |
NOMINEE RELATION
|
Character
|
Yes
|
20
|
Relation with Nominee.(OPTIONAL)
|
| Field14 |
GUARDIAN PAN
|
Character
|
Yes
|
10
|
Mandatory if tax status is “on behalf of minor”.
|
| Field15 |
DEFAULT DP CODE
|
Character
|
No
|
4
|
Default DP Id (CDSL / NSDL),PHYS in case of Physical
|
| Field16 |
CLIENT CDSL DPID
|
Character
|
No
|
8
|
CDSL DPID
(Mandator) |
| Field17 |
CLIENT CDSL BENID
|
Character
|
No
|
16
|
CLIENT CDSL BENID (Mandatory for all Transaction) |
| Field18 |
NSDLDPID
|
Character
|
No |
8
|
NSDLDPID (Mandatory) |
| Field19 |
NSDLBENID
|
Number
|
No
|
8
|
NSDLDPID (Mandatory) |
| Field20 |
BANK NAME
|
Character
|
No
|
40
|
Bank name.
|
| Field21 |
BANK BRANCH
|
Character
|
No
|
40
|
BANK BRANCH
|
| Field22 |
BANK_CITY
|
Character
|
No
|
35
|
Bank City.
|
| Field23 |
ACCOUNTTYPE
|
Character
|
No
|
3
|
SB-Saving Bank
CB-Current/OD/CC Bank
NRE -NRE Account
NRO -NRO Account
|
| Field24 |
ACCOUNTNO
|
Number
|
No
|
20
|
Account Number.
|
| Field25 |
MICR
|
Number
|
Yes
|
9
|
MICR
|
| Field26 |
CLIENT NEFT CODE
|
Alphanumeric
|
Yes
|
11
|
NEFT CODE
Not applicable for cheque and direct credit |
| Field27 |
CHEQUE NAME
|
Character
|
Yes
|
35
|
CHEQUE NAME (OPTIONAL) |
| Field28 |
ADDRESS1
|
Character
|
No
|
40
|
Client Address 1 |
| Field29 |
ADDRESS2
|
Character
|
No
|
40
|
Client Address 2 |
| Field30 |
ADDRESS3
|
Character
|
Yes
|
40
|
Client Address 3 |
| Field31 |
CITY
|
Character
|
No
|
35
|
CITY |
| Field32 |
STATE
|
Character
|
No
|
2
|
STATE |
| Field33 |
PINCODE
|
Number
|
No
|
6
|
PIN CODE |
| Field34 |
COUNTRY
|
Character
|
No
|
35
|
COUNTRY |
| Field35 |
Residence Phone No
|
Character
|
Yes
|
15
|
Residence Phone No. (OPTIONAL)
|
| Field36 |
Residence FAX No
|
Character
|
Yes
|
15
|
Residence FAX No. (OPTIONAL)
|
| Field37 |
Office Phone No. (OPTIONAL)
|
Character
|
Yes
|
15
|
Office Phone No. (OPTIONAL)
|
| Field38 |
Office FAX No
|
Character
|
Yes
|
15
|
Office FAX No. (OPTIONAL)
|
| Field39 |
EMAIL
|
Character
|
No
|
50
|
EMAIL |
| Field40 |
STMT_COMM_MODE
|
Character
|
No
|
1
|
P-physical
E-electronic
|
| Field41 |
PAYMENT MECH
|
Numeric
|
No
|
2
|
01-Cheque
02-Direct Credit
03-ECS
04-NEFT
05-RTGS
|
| Field42 |
JH1 PAN
|
Character
|
Yes
|
10
|
JH1 PAN
|
| Field43 |
JH2 PAN
|
Character
|
Yes
|
10
|
JH2 PAN
|
| Field44 |
MAPIN NO
|
Character
|
Yes
|
16
|
(OPTIONAL) |
| Field45 |
CM_FORADD1
|
Character
|
No
|
40
|
MANDATORY
|
| Field46 |
CM_FORADD2
|
Character
|
No
|
40
|
MANDATORY
|
| Field47 |
CM_FORADD3
|
Character
|
Yes
|
40
|
(OPTIONAL)
|
| Field48 |
CM_FORCITY
|
Character
|
No
|
35
|
MANDATORY
|
| Field49 |
CM_FORPINCODE
|
Character
|
No
|
10
|
MANDATORY
|
| Field50 |
CM_FORSTATE
|
Character
|
No
|
35
|
MANDATORY
|
| Field51 |
CM_FORCOUNTRY
|
Character
|
No
|
35
|
COUNTRY CODE
|
| Field52 |
CM_FORRESIPHONE
|
Character
|
Yes
|
15
|
MANDATORY
|
| Field53 |
CM_FORRESIFAX
|
Character
|
Yes
|
15
|
OPTIONAL
|
| Field54 |
CM_FOROFFPHONE
|
Character
|
Yes
|
15
|
OPTIONAL
|
| Field55 |
CM_FOROFFFAX
|
Character
|
Yes
|
15
|
OPTIONAL
|
| Field56 |
CLIENT PHYSICAL HOLDING
|
Character
|
Yes
|
2
|
SI - Single
JO - Joint
AS - Anyone or Survivor
(OPTIONAL)
|
| Field57 |
FH CKYC REF NO
|
Number
|
Yes
|
14
|
OPTIONAL
|
| Field58 |
JH1 CKYC REF NO
|
Number
|
Yes
|
14
|
OPTIONAL
|
| Field59 |
JH2 CKYC REF NO
|
Number
|
Yes
|
14
|
OPTIONAL
|
| Field60 |
GUARDIAN CKYC REF NO
|
Number
|
Yes
|
14
|
OPTIONAL
|
| Field61 |
JH1 DOB
|
Character
|
Yes
|
|
Applicable if Mode of Holding is Joint. DDMMYYYY
Can be left blank if CKYC fields are blank
|
| Field62 |
JH2 DOB
|
Character
|
Yes
|
|
Applicable if Mode of Holding is Joint. DDMMYYYY
Can be left blank if CKYC fields are blank
|
| Field63 |
GUARDIAN DOB
|
Character
|
Yes
|
|
Applicable if Tax Status is On Behalf of Minor. DDMMYYYY
Can be left blank if CKYC fields are blank
|