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