Previous Next JavaScript must be enabled to correctly display this content

## 4.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, which are marked with an asterisk, are mandatory.

Table 4-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

Parent topic: File Upload