What is FILE FORMAT for FCKR transaction

[Former Member]

Hello,

I want to upload text file in FCKR transaction but does not know the fields values (data ) to be supplied in text file.

Please help in this regard.

I am very generous in giving points.

Thanks,

Tanaya

[Former Member]

hi tanaya,

it depends up on the req. you got from Functional people.

it varies from req. to req.

in general functional people will give that text file in txt/xls format.

if they have given that sample file as attachment then put dummy values in that for the values which are to be populated in the FCKR transaction and try..

<b>Reward points if useful</b>

[Former Member]

Hi Tanaya

Refer to the structures CHECK_HEAD and CHECK_REC for the file header and line item fields.

Reward points if useful.

[Former Member]

Hi Tanaya,

Try this.

Header Format

Record type HDNUM SBANK House bank id Account number PAYTP Date Currency

Length(1) Length(3) Length(15) Length(15) Length(18) Length(3) Length(8,YYYYMMDD) Length(3)

Item Format

RECTP VALUT CKNUM Amount BANKL ACCNR PDATE BNKTC

Record type Valuedate Check Number Amount in cents Not Used - Routing Number of Receiving Bank (Our Bank) Not Used - Account at Bank Cheque Encashment date Not Used - Bank Transaction Code

Length(1) Length(8) Length(13) Length(11) Length(15) Length(10) Length(8,YYYYMMDD) Length(3)

Trailer

Record type

Length(1)

Thanks.