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