6.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 marked as Required are mandatory.Table 6-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