2.4 Entity Upload Format
This topic explains the information on Entity Upload Format.
This topic explains the systematic instructions on Entity Upload Format.The upload file would contain various segment identification number in the first column to indicate the type of data that is present in that entire row. The possible segments that would be used in entity upload are given below for reference:
Segment ID - 00EIM
This segment will be mandatory for incremental upload segment.
Table 2-42 Entity Upload Format - 00EIM
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Yes | - | 00EIM |
| PROCESSID | Yes | - | Unique |
| SEQUENCENUMBER | Yes | - | Unique |
| BULKCLIENTCODE | Yes | - | Unique |
| IMPORTFILENAME | Yes | - | Unique |
| ENTITYID | Yes | - | Existing Entity ID |
| PARENTENTITYFLAG | No | - | - |
| ENTITYNAME | No | - | - |
| ENTITYTYPE | Yes | - | Entity type belonging to Entity ID |
| PARENTENTITY | No | - | - |
| EFFECTIVEDATE | No | - | - |
| RECORDLINK | No | - | - |
| NEWENTITYNAME | No | - | - |
| NEWENTITYID | No | - | - |
| ENTITYBASECURRENCY | No | - | - |
| AUTH_STAT | Yes | - | - |
| UNIQUERECORDNUMBER | No | - | - |
| MARKEDFORREIMP | No | - | - |
| ACCOUNTTYPES | No | - | - |
| ENTITYCATEGORYTYPE | No | - | - |
| ENTITYCATEGORY | No | - | - |
| AMCID | No | - | - |
| SWITCHINGLOGIC | No | - | - |
| UHGENERATIONLOGIC | No | - | - |
| NATUREOFBUSINESS | No | - | - |
| SECTION | No | -- | |
| ENTITYSUBTYPE | No | - | - |
| CROSSBRANCHING | No | - | - |
| FUNDSPOWERINSTALLED | No | - | - |
| CUSTOMERINTERFACEKEY | No | - | - |
| ONLINEINTERFACE | No | - | - |
| WEEKENDBITS | No | - | - |
| AUTHORIZEDSIGNATORY | No | - | - |
| LINKENTITYID | No | - | - |
| LINKENTITYTYPE | No | - | - |
| ALTLANGENTITYNAME | No | - | - |
| ALTLANGCONTACTPERSON | No | - | - |
| ALTLANGADDRESS1 | No | - | - |
| ALTLANGADDRESS2 | No | - | - |
| ALTLANGCITY | No | - | - |
| ALTLANGSTATE | No | - | - |
| FINWAREPOSTING | No | - | - |
| CHANNELENTITY | No | - | - |
| MICRCODE | No | - | - |
| COUNTRYOFBIRTH | No | - | - |
| COUNTRYOFDOMICILE | No | - | - |
| EIN | No | - | - |
| FATCACLASSIFICATION | No | - | - |
| FATCASTATUS | No | - | - |
| INCORPORATIONCOUNTRY | No | - | |
| USERID | Yes | - | Represents the user ID who has entered the latest record |
| MOD_NO | No | - | - |
| NATIONALITY | No | - | - |
| TAXCATEGORY | No | - | - |
| TAXCERTIFICATEEFFEDATE | No | - | - |
| TAXCERTIFICATEEXPDATE | No | - | - |
| TAXCIRCLE | No | - | - |
| TAXID | No | - | - |
| UPLOADMODE | Yes | - | I |
| USINDICIAAVAILABLE | No | - | - |
| GIIN | No | - | - |
| FATCACLASSIFICATION | No | - | - |
| ISAREFERENCENO | No | - | - |
| CURRENCY | No | - | - |
| MINISATRANSFERIN | No | - | - |
| MINISATRANSFEROUT | No | - | - |
| FUNDSTRUCTAPPLICABLE | No | - | - |
| AUTOSETTLESWITCH | No | - | - |
| SWIFTMSGLIST | No | - | - |
| ELECTRONICDEALFLAG | No | - | - |
| DEFAULTAGENCYBRANCH | No | - | - |
| BENEFICIARYACCTNO | No | - | - |
| EMAILID | No | - | - |
| PHONENUMBER | No | - | - |
Segment ID - 01EBD
Table 2-43 Entity Upload Format - 01EBD
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Yes | - | 01EBD |
| PROCESSID | Yes | - | Unique |
| SEQUENCENUMBER | Yes | - | Unique |
| BULKCLIENTCODE | No | - | - |
| ENTITYID | No | - | - |
| ENTITYTYPE | Yes | - | - |
| BANKCODE | Yes | - | If bank/branch/ account type/ account number/ account currency combination provided in file exists in system- other details will be updated.If does not exist, record will be inserted in system |
| BRANCHCODE | Yes | - | - |
| ACCOUNTTYPE | Yes | - | - |
| ACCOUNTNUMBER | Yes | - | - |
| ACCOUNTNAME | Yes | - | - |
| ACCOUNTCURRENCY | Yes | - | - |
| DEFAULTDETAILS | Yes | Yes | - |
| DIRECTDEBITAPPLICABLE | No | Yes | - |
| SWIFTFORMAT | No | Yes | - |
| BANKCHARGED | No | Yes | - |
| BENEFICIARY | No | Yes | - |
| BENEFICIARYADD1 | No | Yes | - |
| BENEFICIARYADD2 | No | Yes | - |
| BENEFICIARYADD3 | No | Yes | - |
| BENEFICIARYBICCODE | No | Yes | - |
| BENEFICIARYACCTNO | No | Yes | - |
| BENEFICIARYCODE | No | Yes | - |
| BENEFICIARYINFO | No | Yes | - |
| INTERMEDIARY | No | Yes | - |
| INTERMEDIARYADD1 | No | Yes | - |
| INTERMEDIARYADD2 | No | Yes | - |
| INTERMEDIARYADD3 | No | Yes | - |
| INTERMEDIARYBICCODE | No | Yes | - |
| INTERMEDIARYACCTNO | No | Yes | - |
| INTERMEDIARYCODE | No | Yes | - |
| INTERMEDIARYINFO | No | Yes | - |
| FURTHERCREDITNAME | No | Yes | - |
| FURTHERCREDITACCTNO | No | Yes | - |
| REFERENCE1 | No | Yes | - |
| REFERENCE2 | No | Yes | - |
| IBAN | No | Yes | - |
| BENEFICIARYIBAN | No | Yes | - |
| INTERMEDIARYIBAN | No | Yes | - |
SegmentID - 02ECI
Table 2-44 Entity Upload Format - 02ECI
| Column Name | Mandatory Fields in Upload File for Upload Mode I | Modifiable Fields in Incremental Mode | Remarks |
|---|---|---|---|
| SEGMENTID | Yes | - | 02ECI |
| PROCESSID | Yes | - | Unique |
| SEQUENCENUMBER | Yes | - | Unique |
| BULKCLIENTCODE | No | - | |
| ENTITYID | No | - | |
| ENTITYTYPE | No | - | |
| ADDRESSTYPE | Yes | - | If address type present in file is available in sys- tem, system will be updated with remaining details present in file.If Address type pres- ent in file is not available in sys- tem, new address type will be added with details as avail- able in file |
| ADDRESSLINE1 | No | Yes | - |
| ADDRESSLINE2 | No | Yes | - |
| ADDRESSLINE3 | No | Yes | - |
| ADDRESSLINE4 | No | Yes | - |
| ZIPCODE | No | Yes | - |
| COUNTRY | No | Yes | - |
| USSTATE | No | Yes | - |
| TELEPHONE1 | No | Yes | - |
| TELEPHONE2 | No | Yes | - |
| CELLPHONENUMBER | No | Yes | - |
| FAX | No | Yes | - |
| No | Yes | - | |
| CONTACTPERSON | No | Yes | - |
| EFFECTIVEFROMDATE | No | Yes | - |
| EFFECTIVETODATE | No | Yes | - |
| BICCODE | No | Yes | - |
| INTDIALLINGCODEPH1 | No | Yes | - |
| INTDIALLINGCODEPH2 | No | Yes | - |
| INTDIALLINGCODE- CELL | No | Yes | - |
| INTDIALLINGCODEFAX | No | Yes | - |
Segment ID - 05ADD
Table 2-45 Entity Upload Format - 05ADD
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Yes | - | 05ADD |
| SEQUENCENUMBER | Yes | - | Unique |
| PROCESSID | Yes | - | Unique |
| ADDINFOLABEL | Yes | - | - |
| FIELDVALUE | Yes | Yes | - |
Parent topic: Appendix B - Upload File Formats B