1.19 Customer Fund Upload Format

This topic provides information on customer fund upload format.

Table 1-96 Customer Fund Upload Format

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
SEQUENCENUMBER	Number	10	Mandatory	-	Sequence Number
PROCESSID	VARCHAR2	50	Mandatory	-	Process ID
BULKCLIENTCODE	VARCHAR2	12	Mandatory	-	Bulk Client Code
IMPORTFILENAME	VARCHAR2	255	Mandatory	-	Import File Name
UPLOADMODE	VARCHAR2	1	Mandatory	-	Mode of operation which has to be performed on the record
CIFNUMBER	VARCHAR2	20	Mandatory	-	CIF Number
MEDIA	VARCHAR2	15	Optional	-	Media
LOCATION	VARCHAR2	15	Optional	-	Location
FUNDID	VARCHAR2	6	Mandatory	-	Fund ID
NEWFUNDID	VARCHAR2	6	Optional	-	New Fund ID
USERID	VARCHAR2	320	Mandatory	-	Indicates the user ID who has entered the latest record.
AUTH_STAT	VARCHAR2	1	Optional	-	Authorisation Status: A - Authorised U - Unauthorised
MODULEID	VARCHAR2	30	Mandatory	-	Module ID
AGENTCODE	VARCHAR2	12	Mandatory	-	Agent Code
BRANCHCODE	VARCHAR2	12	Mandatory	-	Branch Code