BAI Files

[cas]

hi

Has anybody enountered a BAI file like this.Its a balance reporting
statment.Experts say that MT940 & MT941 of Accelator supports this kind of
file.

The Wikipedia article on BAI provides some helpful details on the format. It
refers to the document
http://web.archive.org/web/20060825050734/www.bai.org/operations/PDF/Cash_Management_2005.pdf,
providing the exact details including the SWIFT 940 and 941 message types
that represent the BAI format.

But when i am trying to run thru the BizTalk engine its throwing error.

01,111017979,111017979,080822,2359,1,200,,2/
02,111017979,111017979,1,080822,2359,USD,2/
03,1114000290,,015,269901,,,040,269901,,,045,269901,,/
88,050,269901,,,076,0,,,072,0,,,074,0,,/
88,100,0,0,,400,0,0,,470,0,0,/
88,110,0,0,,140,0,0,,450,0,0,/
88,190,0,0,,490,0,0,,580,0,0,/
49,1079604,6/
03,1114000423,,015,109796,,,040,109796,,,045,109796,,/
88,050,109796,,,076,0,,,072,0,,,074,0,,/
88,100,0,0,,400,0,0,,470,0,0,/
88,110,0,0,,140,0,0,,450,0,0,/
88,190,0,0,,490,0,0,,580,0,0,/
49,439184,6/

[Jay Kinker]

What are these BAI files? Is it CSV format data for MT940/941?

I don't think by default A4SWIFT would support these structures. However,
you can always create custom schemas and maps to process these messages via
BTS and A4SWIFT.

Cheers,

Jay Kinker
http://geekswithblogs.net/jaykinker
----------------------------------------------------

[Jay Kinker]

Are you trying to create SWIFT messages out of sample data you have provided?
Or you are trying to create the CSV data from SWIFT messages?

Both are possible via BTS and A4SWIFT.

Assuming the first scenario for you:
- You need to create proper flat file schema to validate incoming data
- Create map to transform incoming CSV file into SWIFT XML
- Use A4SWIFT Assembler to transform the SWIFT XML into MT940 or
whatever MT message your want to create.

The approach is straight forward for both scenarios.