Dynamics Community Forum Thread Details

How to genereate EFT file using Busness Central for CIBC?

Urooj,

Hello. I have seen an 80 byte format from CIBC (Canadian Imperial Bank Corp.) but not 180. Using the Data Exchange Definition this would be easy to create, test, and deploy. Here is the 80 byte format for Canadian Banks:

The following is the format of the Electronic Funds Transfer File:

EFT 80 Byte File Layout – Credits & Debits

In the ASCII file the record length is 80 characters. Header, detail and trailer record are mandatory.

ID = Identifier

DT = Date type

AN = Alphanumeric

N = Numeric

Header

Record	M/O	Type	Start	Length	Value
01 Record Id	M	ID	1	1	H
02 Originator Id Number	M	AN	2	10	Originator Number
03 Payment Type	M	AN	12	1	Payment Type “D” for debit, ”C” for credit
04 CPA Code	M	AN	13	3	CPA Code
05 Payment Due Date	M	N	16	6	Direct Deposit Date. Format “DDMMYY”
06 Originator Name	M	AN	22	15	Originator Name
07 Bank Number	M	AN	37	4	Bank Number
08 Transit Code	M	AN	41	5	Bank Transit Code
09 Bank Account	M	AN	46	12	Bank Account
10 File Creation Number	M	AN	58	4	Direct Deposit Counter. Format ”0001”
11 Filler	M	AN	62	19	Spaces

Detail

Record	M/O	Type	Start	Length	Value
01 Record Id	M	ID	1	1	D
02 Employee Name	M	ID	2	23	Last name, first letter from First name
03 Payment Due Date	M	N	25	6	Direct Deposit Date. Format “DDMMYY”
04 Cheque Number	M	AN	31	19	Cheque Number
05 Bank Code	M	AN	50	4	Bank Code
06 Bank Transit Code	M	AN	54	5	Bank Transit Code
07 Payee Bank Account	M	AN	59	12	Employee Bank Account
08 Payment Amount	M	N	71	10	Payment Amount (eg.1,234.40 become 00000123400)

Trailer

Record	M/O	Type	Start	Length	Value
01 Record Type	M	AN	1	1	T
02 Total Number of Payments	M	N	2	8	Record count (eg.167 become 00000167 )
03 Total Value of Payments	M	N	10	14	Accumulated amounts
04 Spaces	M	N	24	57	Spaces