Routing Number

Added On:  03/16/12 

SQL Table:  IAPP_ROUTING_NUMBER 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  RoutingNumber 

Represents fields that contain information about routing number.

Available Fields:

• Bank Name
• BIC
• Branch
• Change Date
• City
• Code

• Country Code
• Create Date
• Is Changed
• New Routing Number
• Office Code
• Phone Number

• Record Type Code
• Routing Number
• Servicing Frb Number
• State
• Street
• ZIP Code

Bank Name

Added On:  03/16/12

SQL Column:  BANK_NAME

Java Field:  bankName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Name of the issuing bank.

BIC

Added On:  02/03/16

SQL Column:  BIC

Java Field:  bic

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Business Identifier Code of the issuing bank.

Branch

Added On:  02/03/16

SQL Column:  BRANCH

Java Field:  branch

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Change Date

Added On:  03/16/12

SQL Column:  CHANGE_DATE

Java Field:  changeDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Date when the routing number was changed.

City

Added On:  03/16/12

SQL Column:  CITY

Java Field:  city

Status:  Active

SQL Type:  varchar(70)

Java Type:  String

Attributes:

City of the issuing bank's address.

Code

Added On:  03/16/12

SQL Column:  CODE

Java Field:  code

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Identifier / Primary Key

Attributes: Required

Identifier of the object used for references; auto-incremented integer value.

Country Code

Added On:  08/31/16

SQL Column:  COUNTRY_CODE

Java Field:  countryCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Code of the country of the issuing bank's address.

Create Date

Added On:  08/31/16

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Date when the record was created.

Is Changed

Added On:  03/16/12

SQL Column:  IS_CHANGED

Java Field:  isChanged

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether routing number is changed.

New Routing Number

Added On:  03/16/12

SQL Column:  NEW_ROUTING_NUMBER

Java Field:  newRoutingNumber

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

New routing number of the issuing bank.

Office Code

Added On:  03/16/12

SQL Column:  OFFICE_CODE

Java Field:  officeCode

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Code of the issuing bank's office.

Phone Number

Added On:  03/16/12

SQL Column:  PHONE_NUMBER

Java Field:  phoneNumber

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Phone number of the issuing bank.

Record Type Code

Added On:  03/16/12

SQL Column:  RECORD_TYPE_CODE

Java Field:  recordTypeCode

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Routing Number

Added On:  03/16/12

SQL Column:  ROUTING_NUMBER

Java Field:  routingNumber

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

Routing number of the issuing bank.

Servicing Frb Number

Added On:  03/16/12

SQL Column:  SERVICING_FRB_NUMBER

Java Field:  servicingFrbNumber

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Servicing routing number of the federal reserve bank's main office.

State

Added On:  03/16/12

SQL Column:  STATE

Java Field:  state

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

State of the issuing bank's address.

Street

Added On:  03/16/12

SQL Column:  STREET

Java Field:  street

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

Street of the issuing bank's address.

ZIP Code

Added On:  03/16/12

SQL Column:  ZIP_CODE

Java Field:  zipCode

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

ZIP or postal code of the issuing bank's address.