4. Annexure - A - File Formats

4.1 Introduction

This chapter contains the following sections:

• Section 4.2, "BIC Record Upload"
• Section 4.3, "Record File Formats"

4.2 BIC Record Upload

As mentioned earlier, Oracle FLEXCUBE allows you to upload the entire BIC directory or individual records like FI and AM. The record Financial Instructions (FI) includes the modified data of all the fields in the BIC directory except the BIC. The Amendments (AM) record contains the modified BIC details.

4.3 Record File Formats

The file formats for the FI and AM records is as under:

FI record

	Position		Description		Length		Type		Mandatory		Data
	1		Tag Identifier		2		VAR­CHAR2		Y		‘FI’
	3		Modification Flag		1		VAR­CHAR2		Y		‘A’ addition	‘M’ modification	‘D’ deletion	‘U’ unchanged
	4		BIC (Bank, Country &	Location Code)		8		VAR­CHAR2		Y		Bank code (4 char)	Country code (2 char)	Location code (2 char)
	12		BIC (Branch code)		3		VAR­CHAR2		Y		Branch code, with	- ‘XXX’ if no branch code exists
	15		Institution Name		35		VAR­CHAR2		Y		Name (first part)
	50		Institution Name		35		VAR­CHAR2		N		Name (second part)
	85		Institution Name		35		VAR­CHAR2		N		Name (third part)
	120		Branch Infor­mation		35		VAR­CHAR2		N		Branch specifi­cation (first part)
	155		Branch Infor­mation		35		VAR­CHAR2		N		Branch specifi­cation (second	part)
	190		City Heading		35		VAR­CHAR2		Y		City name
	225		Subtype indi­cation		4		VAR­CHAR2		Y		A subtype can be bank, bro­ker,	etc.
	229		Value Added	Services		60		VAR­CHAR2		N		20 x 3 char. Fields indicat­ing	the	Value-added Service Code
	289		Extra Infor­mation		35		VAR­CHAR2		N		Specific infor­mation
	324		Physical address		35		VAR­CHAR2		N		Physical address (first part)
	359		Physical address		35		VAR­CHAR2		N		Physical address (sec­ond part)
	394		Physical address		35		VAR­CHAR2		N		Physical address (third part)
	429		Physical address		35		VAR­CHAR2		N		Physical address (fourth part)
	464		Location		35		VAR­CHAR2		N		Location (first part)
	199		Location		35		VAR­CHAR2		N		Location (sec­ond part)
	534		Location		35		VAR­CHAR2		N		Location (third part)
	569		Country name		35		VAR­CHAR2		N		Country name (first part)
	604		Country name		35		VAR­CHAR2		N		Country name (second part)
	639		POB Number		35		VAR­CHAR2		N		Post Office Box number
	674		POB Location		35		VAR­CHAR2		N		POB Location (first part)
	709		POB Location		35		VAR­CHAR2		N		POB Location (second part)
	744		POB Location		35		VAR­CHAR2		N		POB Location (third part)
	779		POB Country name		35		VAR­CHAR2		N		POB Country name (first part)
	814		POB Country name		35		VAR­CHAR2		N		POB Country name (second part)

 

AM record

The AM record would consist of only the tag identifier, old BIC and the new BIC.. The file format is as follows:

	Position		Description		Length		Type		Mandatory		Data
	1		Tag Identifier		2		VAR­CHAR2		Y		‘AM’
	3		Old BIC		11		VAR­CHAR2		Y		Old BIC
	14		New BIC		11		VAR­CHAR2		Y		New BIC