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.
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.
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.
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.
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.
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.
Added On:  03/16/12
SQL Column:  RECORD_TYPE_CODE
Java Field:  recordTypeCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  02/03/16
SQL Column:  BRANCH
Java Field:  branch
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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.
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.