Previous Next JavaScript must be enabled to correctly display this content

## 4.8 External Customer File Upload

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

File Type Supported - CSV

File Naming Convention - CmcCustomerMaint_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields, which are marked with an asterisk, are mandatory.

Table 4-13 External Customer 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* | String | 3 | Country of the customer
3 | Language* | String | 3 | Denotes the Language of the customer
4 | Nationality* | String | 3 | Denotes the Nationality of the customer
5 | Locale | String | 10 | Indicates the Locale of the customer
6 | Deceased* | String | 1 | Indicates the customer is deceased
7 | Frozen* | String | 1 | Denotes the customer account is frozen
8 | Whereabouts Unknown* | String | 1 | Indicates the customerâ€™s whereabouts are unknown
9 | RmId | String | 12 | Relationship Manager ID
10 | Sanctions Checks Required* | String | 1 | Indicates the sanction check is required
11 | Staff* | String | 1 | Indicates a staff customer
12 | Walkin Customer* | String | 1 | Indicates a walk-in customer
13 | Source System* | String | 35 | Source System
14 | Source System Cust No* | String | 35 | Denotes the Source System Customer Number
15 | Customer No* | String | 20 | Number for the customer
16 | Host Code | String | 8 | Denotes the Host Code
17 | Customer Type* | String | 1 | Type of Customer
18 | Customer Category | String | 10 | Denotes the Customer Category
19 | Customer Name1* | String | 105 | Name of the customer
20 | Short Name* | String | 20 | Short name of the customer
21 | Address Line1* | String | 105 | Indicates the customer address details - Address Line 1
22 | Address Line2* | String | 105 | Indicates the customer address details - Address Line 2
23 | Address Line3* | String | 105 | Indicates the customer address details - Address Line 3
24 | Address Line4* | String | 105 | Indicates the customer address details - Address Line 4
25 | Pincode* | String | 15 | Denotes the postal code details of the customer

Parent topic: File Upload