1.16.2 Entity Maintenance Related Information

This topic provides information on entity maintenance related information.

Serial Number: 1

Segment Identification Number: 00EIM

Description: This segment is used for providing Entity Maintenance Related Information.

Attributes: Mandatory

Table 1-86 Entity Maintenance Related Information

Field Name (as expected in the file) Data type Length Attributes Characteristics/rules Values
SEGMENTID VARCHAR2 16 Mandatory - Segment ID. Value for Segment ID is 00EIM
PROCESSID VARCHAR2 50 Mandatory - Process ID
SEQUENCENUMBER NUMBER 10 Mandatory - Sequence Number
BULKCLIENTCODE VARCHAR2 12 Optional - Bulk Client Code
IMPORTFILENAME VARCHAR2 255 Optional - Import File Name
UPLOADMODE VARCHAR2 1 Mandatory - Operation mode which will be performed on the Upload records. It can have:
  • N - New
  • D - Delete
  • A - Auth
  • E - Modify
ENTITYID VARCHAR2 12 Mandatory - Entity ID
PARENTENTITYFLAG NUMBER 1 Optional - Parent Entity Flag
ENTITYNAME VARCHAR2 60 Mandatory - Entity Name
ENTITYTOBEDELETED VARCHAR2 12 Optional - Entity To be Deleted
ENTITYTYPE VARCHAR2 1 Optional - Entity Type
PARENTENTITY VARCHAR2 12 Optional - Parent Entity
EFFECTIVEDATE DATE 10 Optional - Effective Date
USERID VARCHAR2 320 Mandatory - Indicates the user ID who has entered the latest record.
RECORDLINK NUMBER 10 Optional - Record Link
NEWENTITYNAME VARCHAR2 60 Optional - New Entity Name
NEWENTITYID VARCHAR2 12 Optional - New Entity ID
ENTITYBASECURRENCY VARCHAR2 3 Optional - Entity Base Currency
ADDITIONALINFO1 VARCHAR2 60 Optional - Additional Information 1
ADDITIONALINFO2 VARCHAR2 60 Optional - Additional Information 2
ADDITIONALINFO3 VARCHAR2 60 Optional - Additional Information 3
ADDITIONALINFO4 VARCHAR2 60 Optional - Additional Information 4
ADDITIONALINFO5 VARCHAR2 60 Optional - Additional Information 5
ADDITIONALINFO6 VARCHAR2 60 Optional - Additional Information 6
ADDITIONALINFO7 VARCHAR2 60 Optional - Additional Information 7
ADDITIONALINFO8 VARCHAR2 60 Optional - Additional Information 8
ADDITIONALINFO9 VARCHAR2 60 Optional - Additional Information 9
ADDITIONALINFO10 VARCHAR2 60 Optional - Additional Information 10
ADDITIONALINFO11 VARCHAR2 60 Optional - Additional Information 11
ADDITIONALINFO12 VARCHAR2 60 Optional - Additional Information 12
ADDITIONALINFO13 VARCHAR2 60 Optional - Additional Information 13
ADDITIONALINFO14 VARCHAR2 60 Optional - Additional Information 14
ADDITIONALINFO15 VARCHAR2 60 Optional - Additional Information 15
ADDITIONALINFO16 VARCHAR2 60 Optional - Additional Information 16
ADDITIONALINFO17 VARCHAR2 60 Optional - Additional Information 17
ADDITIONALINFO18 VARCHAR2 60 Optional - Additional Information 18
ADDITIONALINFO19 VARCHAR2 60 Optional - Additional Information 19
ADDITIONALINFO20 VARCHAR2 60 Optional - Additional Information 20
ADDITIONALINFO21 VARCHAR2 60 Optional - Additional Information 21
ADDITIONALINFO22 VARCHAR2 60 Optional - Additional Information 22
ADDITIONALINFO23 VARCHAR2 60 Optional - Additional Information 23
ADDITIONALINFO24 VARCHAR2 60 Optional - Additional Information 24
ADDITIONALINFO25 VARCHAR2 60 Optional - Additional Information 25
ADDITIONALINFO26 VARCHAR2 60 Optional - Additional Information 26
ADDITIONALINFO27 VARCHAR2 60 Optional - Additional Information 27
ADDITIONALINFO28 VARCHAR2 60 Optional - Additional Information 28
ADDITIONALINFO29 VARCHAR2 60 Optional - Additional Information 29
ADDITIONALINFO30 VARCHAR2 60 Optional - Additional Information 30
AUTH_STAT VARCHAR2 1 Optional - Authorisation Status:
  • A - Authorised
  • U - Unauthorised
UNIQUERECORDNUMBER NUMBER 5 Optional - Unique Record Number
MARKEDFORREIMP VARCHAR2 1 Optional - Marked for ReImport
ACCOUNTTYPES VARCHAR2 1000 Optional - Account Types
ENTITYCATEGORYTYPE VARCHAR2 1 Optional - Entity Category Type:
  • I - Individual
  • C - Corporate
ENTITYCATEGORY VARCHAR2 2 Optional - Entity Category
AMCID VARCHAR2 12 Optional - AMC ID
SWITCHINGLOGIC VARCHAR2 12 Optional - Switching Logic
UHGENERATIONLOGIC NUMBER 1 Optional - Unit Holder Generation Logic:
  • 1 - AGT
  • 2 - SERIAL&AMC/DIST&CHK
  • 3 - SERIAL
  • 4 - No Logic
  • 5 - Reference Number
  • 6 - AJF Generation Logic
  • 7 - Ctry(1)&Busi(1)&F MG/DIST&AZ( 1)&Num(5)
NATUREOFBUSINESS VARCHAR2 1 Optional - Nature of Business:
  • U - UnitTrust
  • L - LifeProducts
  • B - Both
SECTION VARCHAR2 40 Optional - Section
ENTITYSUBTYPE VARCHAR2 3 Optional - Module/Agent Type
CROSSBRANCHING NUMBER 1 Optional - Cross Branching Allowed:
  • 1 - Yes
  • 0 - No
FUNDSPOWERINSTALLED NUMBER 1 Optional - FLEXCUBE-IS Installation:
  • 1 - Yes
  • 0 - No
CUSTOMERINTERFACEKEY VARCHAR2 1 Optional - Customer Interface Key:
  • C - Customer
  • A - Account
ONLINEINTERFACE NUMBER 1 Optional - Online Interface:
  • 1 - Yes
  • 0 - No
WEEKENDBITS VARCHAR2 7 Optional - Weekend Bits
AUTHORIZEDSIGNATORY VARCHAR2 70 Optional - Authorized Signatory
MOD_NO NUMBER 5 Optional - Indicates the max number of times the record is modified
ALTLANGENTITYNAME VARCHAR2 60 Optional - Alternate Language Entity Name
ALTLANGCONTACTPERSON VARCHAR2 70 Optional - Alternate Language Contact Person
ALTLANGADDRESS1 VARCHAR2 80 Optional - Alternate Language Address 1
ALTLANGADDRESS2 VARCHAR2 80 Optional - Alternate Language Address 2
ALTLANGCITY VARCHAR2 80 Optional - Alternate Language City
ALTLANGSTATE VARCHAR2 80 Optional - Alternate Language State
FINWAREPOSTING NUMBER 1 Optional - Finware Posting:
  • 1 - Yes
  • 0 - No
CHANNELENTITY NUMBER 1 Optional - Restrict Cross Branching within Agent:
  • 1 - Yes
  • 0 - No
MICRCODE VARCHAR2 12 Optional - MICR Code
NATIONALITY VARCHAR2 3 Optional - Nationality
COUNTRYOFBIRTH VARCHAR2 3 Optional - Indicates the birth country of entity
COUNTRYOFDOMICILE VARCHAR2 3 Optional - Indicates the country of domicile
INCORPORATIONCOUNTRY VARCHAR2 3 Optional - Country of Incorporation
TAXID VARCHAR2 50 Optional - Tax ID
EIN VARCHAR2 50 Optional - Employer ID Number
TAXCERTIFICATEEFFEDATE DATE 10 Optional - Tax Certificate Effective Date
TAXCERTIFICATEEXPDATE DATE 10 Optional - Tax Certificate Expiry Date
TAXCIRCLE VARCHAR2 3 Optional - Tax Circle
TAXCATEGORY VARCHAR2 10 Optional - Tax Category
GIIN VARCHAR2 30 Optional - Global Intermediary Identification Number
CURRENCY VARCHAR2 3 Optional - Currency
ISAREFERENCENO VARCHAR2 5 Optional - ISA ReferenceNo
MINISATRANSFEROUT NUMBER 30 Optional - MinISATransferIn
MINISATRANSFERIN NUMBER 30 Optional - MinISATransferOut

Parent topic: Entity Upload Format