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:
|
MODULEID | VARCHAR2 | 30 | Mandatory | - | Module ID |
AGENTCODE | VARCHAR2 | 12 | Mandatory | - | Agent Code |
BRANCHCODE | VARCHAR2 | 12 | Mandatory | - | Branch Code |
Parent topic: Appendix A - Upload File Formats A