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