6.9 External Customer Account File Upload

This topics describes the information to perform External Customer Account maintenance in common core.

File Type Supported - CSV

File Naming Convention - CmcAccountMaint_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields marked as Required are mandatory.

Table 6-14 External Customer Account File Upload - Master Records

Sequence	Field Name	Type	Size	Description
1	Action*	String	10	Denotes file operation type. Allowed values are new/modify
2	Country Code*	String	10	Country Code
3	Address4*	String	105	Denotes the address details - Address Line 4
4	Address3*	String	105	Denotes the address details - Address Line 3
5	Address2*	String	105	Denotes the address details - Address Line 2
6	Address1*	String	105	Denotes the address details - Address Line 1
7	Eca Check Req*	String	1	Indicates External Credit Approval Required check is required for the external customer account
8	Account Class*	String	6	Denotes the Account Class
9	Ac Stat Dormant*	String	1	Indicates the account status is dormant
10	Ac Stat Frozen*	String	1	Indicates the account status is frozen
11	Gl Stat Blocked*	String	1	Indicates the account status is blocked
12	Ac Stat No Dr*	String	1	Indicates the account does not have any debit facility
13	Ac Stat No Cr*	String	1	Indicates the account does not have any credit facility
14	Ac Open Date*	String	35	Denotes the Account Open Date (Date format should be yyyy-MM-dd, i.e. 2018-03-30)
15	Cust Ac Name*	String	105	Account Name of the customer
16	Cust Ac Ccy*	String	3	Account Currency of the customer
17	Customer No*	String	20	Indicates the Customer Number
18	Source System Acc Brn*	String	20	Denotes the Source Account Branch
19	Source System Acc No*	String	35	Denotes the Source Customer Account Number
20	Source System*	String	35	Source System
21	Cust Ac IBAN	String	35	Indicates the account IBAN details
22	Host Code*	String	8	Denotes the host code details
23	Cust Account No*	String	20	Indicates the Customer Account Number