Bank Identification Number


Added On:  03/16/12 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  BankIdentificationNumber 
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
Internal identifier associated with a BIN range that this bank belongs to.
Added On:  03/16/12
SQL Column:  PAYMENT_OPTION_CL
Java Field:  paymentOptionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the type of selected payment option.
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:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the issuing bank's country.
Added On:  03/16/12
SQL Column:  ADDRESS
Java Field:  address
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Address of the issuing bank.
Added On:  03/16/12
SQL Column:  PHONE_NUMBER
Java Field:  phoneNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number of the issuing bank.
Added On:  03/16/12
SQL Column:  CARD_TYPE
Java Field:  cardType
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Type of a credit card.
Added On:  03/16/12
SQL Column:  CARD_CATEGORY
Java Field:  cardCategory
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Category of the credit card.
Added On:  03/16/12
SQL Column:  CARD_INDICATOR
Java Field:  cardIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identificator of the card type (credit, debit, prepaid) and its usage (pin, signature etc).
Added On:  03/16/12
SQL Column:  NETWORK_IDS
Java Field:  networkIds
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
List of debit network identifiers that can be used to process PINless debit transactions.
Added On:  03/16/12
SQL Column:  BIN_UPDATE_DATE
Java Field:  binUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Update date of the bank identification number.
Added On:  03/16/12
SQL Column:  IS_COMMERCIAL
Java Field:  isCommercial
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether used card is a commercial card.
Added On:  03/16/12
SQL Column:  IS_FSA
Java Field:  isFsa
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether a used card is accociated with a flexible spending account or health spending account.
Added On:  03/16/12
SQL Column:  IS_PREPAID
Java Field:  isPrepaid
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether used card is prepaid.
Added On:  03/16/12
SQL Column:  BIN_LOW
Java Field:  binLow
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The lowest BIN value of the BIN range.
Added On:  03/16/12
SQL Column:  BIN_HIGH
Java Field:  binHigh
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The highest BIN value of the BIN range.
Added On:  01/06/15
SQL Column:  PRODUCT_CODE
Java Field:  productCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code that indicates a sub-category of Visa, MasterCard, Discover and American Express card (Purchase Card, Business Card, etc).
Added On:  01/06/15
SQL Column:  REGULATOR_INDICATOR
Java Field:  regulatorIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates whether the card is regulated by Durbin Amendment.
Applied to the US issued cards only.
Added On:  01/06/15
SQL Column:  VISA_PRODUCT_SUB_TYPE
Java Field:  visaProductSubType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Product sub-types, i.e. further classification of product.
Added On:  01/06/15
SQL Column:  IS_LARGE_TICKET
Java Field:  isLargeTicket
Status:  Active
SQL Type:  tinyint(1)(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether used card is a large ticket.
Added On:  01/06/15
SQL Column:  ACCOUNT_LEVEL_PROCESSING_INDICATOR
Java Field:  accountLevelProcessingIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator that provides information whether account level processing is available for the BIN.
Added On:  01/06/15
SQL Column:  ACCOUNT_FUND_SOURCE
Java Field:  accountFundSource
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Source of the funds associated with the primary account for the card.
Added On:  01/06/15
SQL Column:  CARD_CLASS
Java Field:  cardClass
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Information about card usage (Business, Consumer, Purchase, Corporate).
Added On:  10/22/15
SQL Column:  EBT_STATE
Java Field:  ebtState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State that issued the EBT card. Required if card is EBT capable. Information originates from the debit network.
Added On:  10/22/15
SQL Column:  PAN_LENGTH_MIN
Java Field:  panLengthMin
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Minimum length of the account number (PAN).
Added On:  10/22/15
SQL Column:  PAN_LENGTH_MAX
Java Field:  panLengthMax
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Maximum length of the account number (PAN).
Added On:  08/29/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/29/16
SQL Column:  LAST_UPDATE_DATE
Java Field:  lastUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when BIN was updated the last time.
Added On:  08/29/16
SQL Column:  IS_OUT_DATED
Java Field:  isOutDated
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether BIN is out dated.