Community Bank of the Bay User Guide

119

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 J K L M N O P Q R S T U V W X Y Z A B C D E F G H I 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d

10 15 16 17 18 19 20 25 26 27 28 29 30 5 6 7 8 9 J O P Q R S T Y Z E F G H I 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 J K L M N O P Q R S T U V W X Y Z A B C D E F G H I 10 18 19 20 28 29 30 8 9 10a 5a 6a 7a 8a 9a 10b 5b 6b 7b 8b 9b 10c 5c 6c 7c 8c 9c 10d 5d 6d 7d 8d 9d

J2 11c 12c C1 D1 E1 11d B2 C2 D2 E2 A3 B3 C3 D3 E3 J3 1a 2a 3a 4a 5a 1b 2b 3b 4b 5b 1c 2c 3c 4c 5c 11a 12a 13a 4e 15a 11b 12b 13b 14b 15b 1d 2d 3d 4d 5d 11 12 13 14 15 21 22 23 24 25 1 2 3 4 5 K L M N O U V W X Y A B C D E

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9

7. Map the fields. For each data type enter the column number in the “Column” box. 8. (Optional) To mask part of the value, type the mask format in the “Mask Format” box. 9. Click the Next button. 10. In the “File Data” box, type the value as it appears in the file. 11. Use the drop-down to select the assigned value. 12. Click the Add button. 13. Click the Create Template button. J1 J2 J3 11a 12a 13a 4e 15a 16a 17a 18a 19a 20a 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b 1d 2d 3d 4d 5d 6d 7d 8d 9d J1 11c 12c C1 D1 E1 F1 G1 H1 I1 J2 11d B2 C2 D2 E2 F2 G2 H2 I2 J3 A3 B3 C3 D3 E3 F3 G3 H3 I3 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 11a 12a 13a 4e 15a 16a 17a 18a 19a 20a 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b 1d 2d 3d 4d 5d 6d 7d 8d 9d J1 11c 12c C1 D1 E1 F1 G1 H1 I1 J2 11d B2 C2 D2 E2 F2 G2 H2 I2 10a 8a 9a 10b 8b 9b 10c 8c 9c 10d 8d 9d J R S T H I 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 11a 12a 13a 4e 15a 16a 17a 18a 19a 20a 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b 1d 2d 3d 4d 5d 6d 7d 8d 9d J K L M N O P Q R S T U V W X Y Z A B C D E F G H I 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 11a 12a 13a 4e 15a 16a 17a 18a 19a 20a 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b 1d 2d 3d 4d 5d 6d 7d 8d 9d J K L M N O P Q R S T U V W X Y Z A B C D E F G H I 15a 16a 17a 18a 19 20a 15b 16b 17b 18b 19b 20b E2 F2 G2 H2 I2 E3 F3 G3 H3 I3 J3 A3 B3 C3 D3 E3 F3 G3 H3 I3 18a 19a 20a 11c 12c C1 D1 E1 F1 G1 H1 I1 J1

1 E1 F1 G1 H1 I1

18b 19b 20b

J1

11c 12c C1 D1 E1 F1 G1 H1 I1

11d B2 C2 D2 E2 F2 G2 H2 I2

J1

H1 I1

J2

11d B2 C2 D2 E2 F2 G2 H2 I2

A3 B3 C3 D3 E3 F3 G3 H3 I3

J2

H2 I2

J3

A3 B3 C3 D3 E3 F3 G3 H3 I3

J3

H3 I3

Positive Pay: Import Templates