2.2 Incremental Upload Format

This topic explains the information on Incremental Upload Format.

For Incremental mode, the system will modify data present in upload file. If data provided in the file is already present, then the system will override existing data with new value provided in the file. If data is not present in system, then the data provided in the file will be added.

The system will not change/replace data which is not available in file for incremental mode. for instance, in unit holder upload, if only telephone number is given in Incremental mode, the system will just update old phone number with new phone number without changing other fields.

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 Incremental upload are given below for reference:

Table 2-40 Incremental Upload Format

Upload Type	Use Case	Description	Upload mode	Segments to be used in Incremental upload
Entity	Contact details update	Cell phone number to be made available in upload file	I	00EIM,02ECI
Entity	Contact details update	E-mail to be made available in upload file	I	00EIM,02ECI
Entity	Bank details Update	BANKCODE,BRANCHCODE, ACCOUNTTYPE, ACCOUNTNUMBER,ACCOUNTNAME,ACCOUNTCURRENCY, DEFAULTDETAILS, DIRECTDEBITAPPLICABLE to be made available in upload file. If default flag is set as Yes, default flag for existing bank detail for same bank/ branch/account type/account currency combination will be set as No	I	00EIM,01EBD
Broker	Contact details update	Cell phone number to be made available in upload file	I	00BRO,01CON
Broker	Contact details update	email number to be made available in upload file	I	00BRO,01CON
Broker	Bank details Update	BANKCODE,BRANCHCODE, ACCOUNTTYPE, ACCOUNTNUMBER,ACCOUNTNAME,ACCOUNTCURRENCY, DEFAULTDETAILS, DIRECTDEBITAPPLICABLE to be made available in upload file. If default flag is set as Yes, default flag for existing bank detail for same bank/ branch/account type/account currency combination will be set as No	I	00BRO,02BAN
Unitholder	Address update	Address1,2,3,4,zip code, country code to be made available in upload file	I	00UH,15CON
Unitholder	Address update	Address line to be made available in upload file	I	00UH,15CON
Unitholder	Address update	Address type along with Address1,2, city, country & BIC code to be made available in upload file	I	00UH,15CON
Unitholder	Contact details update	Cell phone number to be made available in upload file	I	00UH,15CON
Unitholder	Contact details update	email to be made available in upload file	I	00UH,15CON
Unitholder	Bank details update	Beneficiary details to be made available in upload file	I	00UH,03BNK
Unitholder	Bank details update	BANKCODE,BRANCHCODE, ACCOUNTTYPE, ACCOUNTNUMBER,ACCOUNTNAME,ACCOUNTCURRENCY, DEFAULTDETAILS, DIRECTDEBITAPPLICABLE to be made available in upload file.If default flag is set as Yes, default flag for existing bank detail for same bank/ branch/account type/account currency combination will be set as No	I	00UH,03BNK
Unitholder	Address & bank details update	Alternate Address line 2 & beneficiary info details to be made available in upload file in respective segments	I	00UH,15CON, 03BNK
Transaction	Settlement details update	Cheque number & cheque date to be made available in file	I	00CON,01SET
Transaction	Settlement details update	Paid Date and settled to be made available in file	I	00CON,01SET
Transaction	Settlement details update	TRANSFERACCOUNTCURRENCY, TRANSFERACCOUNTNUMBER, TRANSFER ACCOUNTTYPE,TRANSFERBRANCHCODE, PAYMENT DATE,PAYMENT AMOUNT to be made available in file	I	00CON,01SET
Transaction	Settlement details update	SWIFTFORMAT,BANKCHARGED, BENEFICIARY, BENEFICIARYADDRESS,BENEFICIARYBICCODE, BENEFICIARYACCTNO, BENEFICIARYCODE,BENEFICIARYINFO to be made available in file	I	00CON,01SET