TRN Record

Start Position

End Position

Length

Required

Description

Format

Field Number

Comments

1

5

5

Y

Record Identifier

Alpha Numeric

N/A

Always Equal To 'TRN'

6

15

10

Y

Account Number

Alpha Numeric

13006

Add the 10 character number with trailing spaces.

16

25

10

Y

Client ID

Numeric

1

Add the 10 character number with leading zeros.

Example: 0000001234

26

33

8

Y

Date Of Transaction

Date

1321

Use the format: MMDDYYYY

Must not be a future date.

34

39

6

Transaction Code

Alpha Numeric

1324

Must be the transaction codes from the Transaction Code table. The upload is validated against the table.

Add the 6 character number with trailing spaces.

40

64

25

Y

Description of Transaction

Alpha Numeric

1323

Add the 25 character entry with trailing spaces.

65

74

10

N

Dollar Amount

Numeric

13010

Add the 10 character number with leading zeros. This field has an implied decimal.

Example: 0000012345 = $123.45

75

94

20

N

Check Number

Alpha Numeric

13012

Add the 20 character number with trailing spaces. Only used if transaction code is a debit code.

95

114

20

N

Receipt Number

Alpha Numeric

13012

Add the 20 character number with trailing spaces. Only used if transaction code is a credit code.

115

134

20

N

Withdrawal Number

Alpha Numeric

13012

Add the 20 character number with trailing spaces. Only used if transaction code is a debit code.