Entry Detail Record

The ACH extract flat file must have one record of this type for every direct debit record.

Field Name

Format

Source/Value/Description

RECORD-TYPE

A1

"6"

TRANSACTION-CD

A2

If the amount is a debit, this is set to CI_TENDER_TYPE.EXT_TYPE_FLG. If the amount is a credit, this is set based on the external type flag as follows:

  • If the value is Checking Withdrawal ( 27), this is set to 22 (Checking Deposit)

  • If the value is Savings Withdrawal ( 37), this is set to 32 (Savings Deposit)

  • If the value is Credit Card Withdrawal ( 47), this is set to 42 (Credit Card Deposit)

TRANSIT-RTG-NBR

A9

CI_APAY_SRC.EXT_SOURCE_ID

DFI-ACCT-NBR

A17

CI_APAY_CLR_STG.EXT_ACCT_ID

AMOUNT

N8.2

CI_PAY_TNDR.TENDER_AMT

INDIVIDUAL-ID

A15

CI_PAY_TNDR.PAYOR_ACCT_ID

INDIVIDUAL-NAME

A22

CI_APAY_CLR_STG.ENTITY_NAME

DISCRETIONARY-DATA

A2

Spaces

ADDENDA-REC-IND

A1

"0"

TRACE-NBR

N15

"000000000000000"

Note:

External Account ID. The EXT_ACCT_ID field supports up to 50 characters. If the value entered in the field is longer than that supported by the record layout (17 characters), the value will be truncated.