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