Template EFT etext for Canada "National Bank"

Hi,

We are cuurently implementing electronic payment EFT using eText output file to be transfered to the bank.

I tried to update Oracle Template "IBYDE_N1US_en.rtf" to fit with the National Bank's output file specifications.

However, it's not really flexible because there is some columns that I can't update as the below one :

41

1

Alpha

R, ‘ ‘

DECODE(SEQUENCE_NUMBER (US_NACHA_CCD_DAILY_SEQ), 1, ‘A’, 2, ‘B’, 3, ‘C’, 4, ‘D’, 5, ‘E’, 6, ‘F’, 7, ‘G’, 8, ‘H’, 9, ‘I’, 10, ‘J’, 11, ‘K’, 12, ‘L’, 13, ‘M’, 14, ‘N’, 15, ‘O’, 16, ‘P’, 17, ‘Q’, 18, ‘R’, 19, ‘S’, 20, ‘T’, 21, ‘U’, 22, ‘V’, 23, ‘W’, 24, ‘X’, 25, ‘Y’, 26, ‘Z’)

File ID Modifier.

I wonder if there is some already preformated template to be used with BNC (Nationa Bank of Canada) or either Template that could be updated easily ?