Import New Customer Feed Structure(Supports .DBF or .TXT File only)
Field Sequence Data Item Type Can be blank Length Remarks
Field1 Investor Name Character No 70 Investor Name as per PAN/ITD
Field2 Broker Code Character No 20 Broker Code
Field3 MFU_CAN Character Yes 20 PAN Status
Field4 Title Character Yes 6 Title
Field5 Date of Birth Date(mm/dd/yyyy) Yes 11 DOB/DOI as per PAN/ITD
Field6 Address1 Character No 120 Address1
Field7 Address2 Character Yes 120 Address2
Field8 Address3 Character Yes 120 Address3
Field9 City Character No 35 City
Field10 State Character No 4 State
Field11 Country Character No 35 Country
Field12 Pincode Number No 15 Pincode
Field13 Phone Office Number Yes 35 Phone Office
Field14 Phone Residence Number Yes 35 Phone Residence
Field15 Fax Office Number Yes 35 Fax Office
Field16 Fax Residence Number Yes 35 Fax Residence
Field17 Email Character No 128  Email ID
Field18 Mobile No Number No 13 Mobile Number
Field19 Father Name Character Yes 40 Father Name
Field20 Mother Name Character Yes 40 Mother Name
Field21 Hold n Code Character No 2 Holding Nature
Field22 Customer PAN Character No 10 Customer PAN Number
Field23 Customer KYC Status Character Yes 1 Customer KYC Status
Field24 JH1 Name Character Yes 75 Joint Holder 1 Name as per PAN/ITD
Field25 JH1 DOB Date (mm/dd/yyyy) Yes 11 Joint Holder 1 DOB as per PAN/ITD
Field26 JH1 PAN Character Yes 10 First Joint Holder PAN
Field27 JH1 KYC Status Character Yes 1 First Joint Holder KYC Status
Field28 JH2 Name Character Yes 75 Joint Holder 2 Name as per PAN/ITD
Field29 JH2 DOB Date (mm/dd/yyyy) Yes 11 Joint Holder 2 DOB as per PAN/ITD
Field30 JH2 PAN Character Yes 10 Second Joint Holder PAN
Field31 JH2 KYC Status Character Yes 1 Second Joint Holder KYC Status
Field32 Guardian Character Yes 120 Guardian Name as per PAN/ITD
Field33 Guardian DOB Date (mm/dd/yyyy) Yes 11 Guardian DOB as per PAN/ITD
Field34 Guardian PAN Character Yes 10 Guardian PAN Number
Field35 Guardian KYC Character Yes 1 Guardian KYC Status
Field36 Bank Code Character No 40 Customer Bank Code
Field37 AcType Character No 5 Account Type
Field38 AcNo Number No 40 Account Number
Field39 Branch Name Character No 40 Branch Name
Field40 Branch Address1 Character No 120 Branch Address
Field41 Branch Address2 Character Yes 120 Branch Address
Field42 Branch Address3 Character Yes 120 Branch Address
Field43 Branch City Character Yes 35 Branch City
Field44 Branch Pincode Character Yes 15 Branch Pincode
Field45 Branch Country Character Yes 35 Branch Country
Field46 DP ID Character Yes 16 DP ID
Field47 Nominee Name1 Character Yes 40  Nominee Name
Field48 Nominee1 Date of Birth Date (mm/dd/yyyy) Yes 11 Nominee Date of Birth
Field49 Nominee1 Relation Character Yes 40 Nominee Relation
Field50 Nominee1 Address1 Character Yes 120 Nominee1 Address1
Field51 Nominee1 Address2 Character Yes 120 Nominee1 Address2
Field52 Nominee1 Address3 Character Yes 120 Nominee1 Address3
Field53 Nominee1 City Character Yes 40 Nominee1 City
Field54 Nominee1 PINCODE Character Yes 15 Nominee1 PINCODE
Field55 Nominee1 State Character Yes 2 Nominee1 State
Field56 Nominee1 COUNTRY Character Yes 40 Nominee1 COUNTRY
Field57 Nominee1 GUARDIAN Character Yes 35 Nominee1 GUARDIAN Name
Field58 Nominee1 PERCENTAGE Number Yes (25,8) Nominee1 PERCENTAGE
Field59 Nominee2 Name Character Yes 40 Nominee2 Name
Field60 Nominee2 Relation Character Yes 40 Nominee2 Relation
Field61 Nominee2 PERCENTAGE Number Yes (25,8) Nominee2 PERCENTAGE
Field62 Nominee3 Name Character Yes 40 Nominee2 Name
Field63 Nominee3 Relation Character Yes 40 Nominee3 Relation
Field64 Nominee3 PERCENTAGE Number Yes (25,8) Nominee2 PERCENTAGE
Field65 PAN Exempt Category Character Yes 5 First Holder PAN Exempt Category
Field66 Tax Status Code Character Yes 2 Tax Status Code
Field67 Occupation Code Character Yes 2 Occupation Code
Field68 NRI Address1 Character Yes 120 NRI Address1
Field69 NRI Address2 Character Yes 120 NRI Address2
Field70 NRI Address3 Character Yes 120 NRI Address3
Field71 NRI City Character Yes 40 NRI City
Field72 NRI Pincode Character Yes 25 NRI Pincode
Field73 NRI Country Character Yes 35 NRI Country
Field74 Nominee Count Number Yes 1 Nominee Count
Field75 Guardian PAN Exempt Category Character Yes 5 Guardian PAN Exempt Category
Field76 Joint1 PAN Exempt Category Character Yes 5 Joint1 PAN Exempt Category
Field77 Joint2 PAN Exempt Category Character Yes 5 Joint2 PAN Exempt Category
Field78 Transaction Through Character Yes 10 Transaction Through (OL for Online,PH for Phone and ALL)
Field79 FH PAN REF NO Character Yes 10 FH PAN Reference NO
Field80 Guardian PAN REF NO Character Yes 10 Guardian PAN Reference NO
Field81 JH1 PAN REF NO Character Yes 10 Joint1 PAN Reference NO
Field82 JH2 PAN REF NO Character Yes 10 Joint2 PAN Reference NO
Field83 FH PAN Valid Character Yes 1 Individual Valid PAN
Field84 Joint1 PAN Valid Character Yes 1 Joint1 Valid PAN
Field85 Joint2 PAN Valid Character Yes 1 Joint2 Valid PAN
Field86 Guardian PAN Valid Character Yes 1 Guardian Valid PAN
Field87 IFSC Code Character No 11 IFSC Code
Field88 Nominee1 Guardian PAN Character Yes 10 Nominee1 Guardian PAN
Field89 Nominee2 Date Of Birth Date (mm/dd/yyyy) Yes 11 Nominee2 Date Of Birth
Field90 Nominee2 Guardian Name Character Yes 75 Nominee2 Guardian Name
Field91 Nominee2 Guardian PAN Character Yes 10 Nominee2 Guardian PAN
Field92 Nominee3 Date Of Birth Date (mm/dd/yyyy) Yes 11 Nominee3 Date Of Birth
Field93 Nominee3 Guardian Name Character Yes 75 Nominee3 Guardian Name
Field94 Nominee3 Guardian PAN Character Yes 10 Nominee3 Guardian PAN
Field95 NRI State Character Yes 35 NRI State
Field96 JH1 Email Character No 128 First Joint Holder Email
Field97 JH1 Mobile No Number No 13 First Joint Holder Mobile No
Field98 JH2 Email Character No 128 Second Joint Holder Email
Field99 JH2 Mobile No Number No 13 Second Joint Holder Mobile No
Field100 FH CKYC FLAG Character Yes 1 First Holder CKYC Status. (Value should be Y or N)
Field101 GUARD CKYC FLAG Character Yes 1 Guardian CKYC Status. (Value should be Y or N)
Field102 JH1 CKYC FLAG Character Yes 1 Joint Holder 1 CKYC Status. (Value should be Y or N)
Field103 JH2 CKYC FLAG Character Yes 1 Joint Holder 2 CKYC Status. (Value should be Y or N)
Field104 FH CKYC Ref No Character Yes 14 First Holder CKYC Ref No
Field105 GUARD CKYC Ref No Character Yes 14 Guardian CKYC Ref No
Field106 JH1 CKYC Ref No Character Yes 14 Joint Holder 1 CKYC Ref No
Field107 JH2 CKYC Ref No Character Yes 14 Joint Holder 2 CKYC Ref No
FIeld108 MICR No Number Yes 9 MICR Number
Field109 Guardian Relation Character Yes 20 Value Should be NG or LG; NG - Natural guardian or LG-Legally appointed guardian
Field110 Mobile Relation Character Yes 20 Value Should be SE = Self SP = Spouse DC = Dependent Children DS = Dependent Siblings DP = Dependent Parents GD = Guardian PM = PMS CD = Custodian PO = POA
Field111 Email Relation Character Yes 20 ValueValue Should be SE = Self SP = Spouse DC = Dependent Children DS = Dependent Siblings DP = Dependent Parents GD = Guardian PM = PMS CD = Custodian PO = POA
Field112 Nominee 1 PAN Character Yes 20 Nominee 1 PAN
Field113 Nominee 2 PAN Character Yes 20 Nominee 1 PAN
Field114 Nominee 3 PAN Character Yes 20 Nominee 3 PAN
Field115 Nominee Opted Character Yes 1 Nominee Opted Status
Field116 JH1 Mobile Relation Character Yes 20 Value Should be SE = Self SP = Spouse DC = Dependent Children DS = Dependent Siblings DP = Dependent Parents GD = Guardian PM = PMS CD = Custodian PO = POA
Field117 JH1 Email Relation Character Yes 20 Value Should be SE = Self SP = Spouse DC = Dependent Children DS = Dependent Siblings DP = Dependent Parents GD = Guardian PM = PMS CD = Custodian PO = POA
Field118 JH2 Mobile Relation Character Yes 20 Value Should be SE = Self SP = Spouse DC = Dependent Children DS = Dependent Siblings DP = Dependent Parents GD = Guardian PM = PMS CD = Custodian PO = POA
Field119 JH2 Email Relation Character Yes 20 Value Should be SE = Self SP = Spouse DC = Dependent Children DS = Dependent Siblings DP = Dependent Parents GD = Guardian PM = PMS CD = Custodian PO = POA
Field120 Nominee1 Guardian Relation Character Yes 40 Nominee1 Guardian Relation
Field121 Nominee2 Guardian Relation Character Yes 40 Nominee2 Guardian Relation
Field122 Nominee3 Guardian Relation Character Yes 40 Nominee3 Guardian Relation