2.9 Account Officer Upload Format
This topic explains the information on Account Officer Upload Format.
Using this interface, user can map Agent, Agency Branch, Account Officer and IFA. Operations such as NEW, EDIT, DELETE, AUTHORIZE, AMEND and CLOSE are supported in this interface.
This section contains the following topics:
Account Officer Maintenance:
Serial Number: 1
Description: This Segment is added to populate Account Officer details.
Table 2-68 Account Officer Upload Format
Field Name | Data type | Length | Mandatory/ Optional | Characteristics/rules | Values |
---|---|---|---|---|---|
PROCESSID | VARCHAR2 | 50 | Mandatory | - | Unique value to process interface |
SEQUENCENUMBER | NUMBER | 10 | Mandatory | - | Sequence Number |
BULKCLIENTCODE | VARCHAR2 | 12 | Mandatory | - | Bulk client code |
IMPORTFILENAME | VARCHAR2 | 255 | Mandatory | - | Import File name |
UPLOADMODE | VARCHAR2 | 1 | Mandatory | - | Represents the action code:
|
AGENTCODE | VARCHAR2 | 12 | Mandatory | - | Represents the valid agent code to be mapped |
BRANCHCODE | VARCHAR2 | 12 | Mandatory | - | Represents the valid branch code to be mapped |
EFFECTIVEDATE | DATE | Mandatory | - | Effective date | |
AOID | VARCHAR2 | 12 | Mandatory | - | Account officer ID |
IFAID | VARCHAR2 | 12 | Mandatory | - | IFA Identification details |
DEFAULTDETAILS | NUMBER | 1 | Mandatory | - | Default details:
|
USER_ID | VARCHAR2 | 15 | Mandatory | - | Maker Id |
Parent topic: Appendix B - Upload File Formats B