Destination of Data

BOA Bank File is Uploaded via Screen: Administration ==> Batch ==> Check Reconciliation ==> Check Reconciliation Bank Upload

Field ID

Column Name for Bank File Data

Start

End

Length

Comment (UConn)

Data Type

Required in Dest?

1

BOA Bank Account Number

1

10

10

Leading zeros. See Note 1 below.

NUMBER (10,0)

Yes

2

Check Number

11

20

10

Leading zeros.

NUMBER (10,0)

Yes

3

Check Status Code

21

21

1

Constant: See Status Codes below.

Alphanumeric

Yes

4

Check Amount

22

33

12

Leading zeros; Implied decimal point.

NUMBER (12,2)

Yes

5

Check Status Update Date

34

39

6

Format: MMDDYY

DATE

Yes

Note 1:

In 'KFS-UAT', 'dummy' bank account numbers are used:

Bank01 = '0000000001'

Bank04 = '0000000002'

Bank15 = '0000000004'

Bank16 = '0000000005'

Bank17 = '0000000006'

In 'KFS-PRD', actual bank account numbers are used.

Status Codes:

'P' for CLEARED checks

'R' for CLEARED checks

'S' for STOPPPED checks

'T' for STALE checks (Escheated checks)

'V' for VOIDED checks