1. Objective and scope

This OP is a part of Chinese bank details maintenance which is to check CNAPS code for Chinese bank. Once you get CNAPS code, you can search whether bank key was created or not.

2. Context and definition

CNAPS is a unique code represent bank name and branch name which is mandatory information for AP team to run domestic payment

3. Flow of CN bank key maintenance

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-27-54.png

4. How to Login BOC Token

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-30-8.png

#	Main activities	Tips/Best practices	Key points
1	Click “企业客户网银登录”		You have to plug in BOC token (USB) into your computer

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-30-45.png

#	Main activities	Tips/Best practices	Key points
2	Click “OK”

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-31-37.png

#	Main activities	Tips/Best practices	Key points
3	Insert token password in ‘Password’ field
4	Click “OK”

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-32-13.png

#	Main activities	Tips/Best practices	Key points
5	Insert user name
6	Insert password
7	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-32-39.png

#

Main activities

Tips/Best practices

Key points

8

Click “简体中文”

9

Select “English”

5. How to Search CNAPS Code

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-40-4.png

#	Main activities	Tips/Best practices	Key points
1	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-40-21.png

#

Main activities

Tips/Best practices

Key points

2

Select “Management of Transaction Associates”

3

Click “Domestic RMB Payee”

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-40-42.png

#	Main activities	Tips/Best practices	Key points
4	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-41-3.png

#	Main activities	Tips/Best practices	Key points
5	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-41-38.png

#	Main activities	Tips/Best practices	Key points
6	Insert either the keyword of bank and branch name in Chinese
7	Select the correct bank/branch name and CNAPS		Possible bank/branch and CNAPS will be shown in the list

6. How to Download CNAPS Code

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-42-7.png

#	Main activities	Tips/Best practices	Key points
1	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-43-32.png

#	Main activities	Tips/Best practices	Key points
2	Click “Quick Aid”
3	Click “Download Bank Code Table”

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-43-46.png

#	Main activities	Tips/Best practices	Key points
4	Click “Download” in ‘Download CNAPS Code’

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-44-8.png

#	Main activities	Tips/Best practices	Key points
5	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-54-20.png

#	Main activities	Tips/Best practices	Key points
6	Click “Save as”

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-54-50.png

#	Main activities	Tips/Best practices	Key points
7	Select your destination to save and click “Save”

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-55-11.png

#	Main activities	Tips/Best practices	Key points
8	Click “Right” on your mouse on the file you just downloaded
9	Select “WinZip”
10	Select “Extract to folder ……”		Do not select “Extract to folder”
11	The file will be extracted and saved in the same place you downloaded CNAPS file

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-55-50.png

#	Main activities	Tips/Best practices	Key points
12	Open “Excel” and click “Data”
13	Select

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-56-14.png

#	Main activities	Tips/Best practices	Key points
14	Select the file	Always start with cnap1	You can select one file each time
15	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-56-43.png

#	Main activities	Tips/Best practices	Key points
16	Select “Delimited”
17	Click
18	Select “54936: Chinese Simplified (GB18030)”
19	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-57-20.png

#	Main activities	Tips/Best practices	Key points
20	Select only “Comma”
21	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-57-43.png

#	Main activities	Tips/Best practices	Key points
22	Click

#	Main activities	Tips/Best practices	Key points
23	Insert “=$A$1”
24	Click

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-58-45.png

#	Main activities	Tips/Best practices	Key points
25	Click cell D3 and try formula “=trim(A3)” and then click “Enter” on keyboard

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-59-2.png

#	Main activities	Tips/Best practices	Key points
26	Double click on the lower right corner to copy formula from D3 to the end of row

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-59-32.png

#	Main activities	Tips/Best practices	Key points
27	Click “Right” on your mouse at column D
28	Select “Copy”

Data Operations > APAC - CNAPS code searching > image2019-6-11_17-59-58.png

#	Main activities	Tips/Best practices	Key points
29	Click “Right” on your mouse at column D again
30	Click		The formula will be removed

Data Operations > APAC - CNAPS code searching > image2019-6-11_18-0-30.png

#	Main activities	Tips/Best practices	Key points
31	Click to open new worksheet	You will need to repeat step #13 - #31 until you complete all files	You can combine all worksheets into 1 worksheet if you want