Concept | Description |
---|
AccuityLocationID (ACCUITY) | This field contains eight digits that identify a physical location of an institution. This is not unique. All records of the same street address will share this Accuity Location ID. This field will be useful for performing recursive queries to find alternate bank routing codes of a given financial institution. |
BranchName (ACCUITY) | Name of particular branch office, if applicable. |
City (ACCUITY) | The city in which the institution is located. |
Country (ACCUITY) | The country in which the institution is located. |
CountryIsoCode (ACCUITY) | The two-digit ISO country code corresponding to the institutions location. |
Fax (ACCUITY) | The fax machine telephone number. |
HeadOfficeAccuityLocationID (ACCUITY) | This field contains eight digits that identify the physical location of an institution’s legal head office. This field is not unique. This field will be useful for performing recursive queries to find alternate bank routing codes of a given financial institution. |
InstitutionNameAbbr (ACCUITY) | The full legal title contained in the file is abbreviated to 35 or fewer characters. The name is abbreviated to SWIFT messaging standards. |
InstitutionNameFull (ACCUITY) | The institution name is the institution’s full legal title. Unused positions are null. This field may contain numbers or letters. |
InstitutionType (ACCUITY) | A two-digit code that indicates the type of institution. |
NationalBankCode (ACCUITY) | This is the actual national bank code routing number (or clearing code). |
NationalBankCodeRefFlag (ACCUITY) | This field will identify the main location for a national bank code. This allows for filtering the data to show only one instance for each national bank code. The value of this field will equal Y or N, where Y indicates a unique instance and N indicates an additional instance. |
NationalBankCodeType (ACCUITY) | This indicates the type of the national bank code routing number. |
NationalBankCodeValue (ACCUITY) | Formatted version of the national bank code value in NationalBankCode field. This presentation of the national bank code will vary for certain countries by including spaces, hyphens, slashes, and other marks. |
OfficeType (ACCUITY) | A two-digit code that indicates the office type of the institution. |
PhysicalAddress1 (ACCUITY) | The physical location including the street number of the institution. |
PhysicalAddress2 (ACCUITY) | Additional address information for the institution. |
PostalCode (ACCUITY) | The postal service number concurring with the address and city. |
PrimaryKey (ACCUITY) | Each record in this file is assigned a key for maintenance and linking purposes. The key is unique to each record in the file. |
SanctionsEU (ACCUITY) | This flag (set to Y or N) indicates whether the institution is sanctioned by the European Union (EU). |
SanctionsHMT (ACCUITY) | This flag (set to Y or N) indicates whether the institution is sanctioned by Her Majesty’s Treasury (HMT). |
SanctionsOFAC (ACCUITY) | This flag (set to Y or N) indicates whether the institution is sanctioned by The Office of Foreign Assets Control (OFAC). |
SanctionsUN (ACCUITY) | This flag (set to Y or N) indicates whether the institution is sanctioned by The United Nations (UN). |
StateAbbr (ACCUITY) | The abbreviation for any state, province or region where an abbreviation exists. |
StateFull (ACCUITY) | The state, province or region in which the institution is located. |
SwiftBic (ACCUITY) | The SWIFT/BIC (Society for Worldwide Interbank Financial Telecommunication/Bank Identifier Code) address is a worldwide bank identifier that allows the exchange of electronic information among institutions. Field can contain letters or numbers. All SWIFT/BIC addresses are left-justified and unused positions are completed with XXX. Spaces are removed from SWIFT/BICs. |
SwiftBicRefFlag (ACCUITY) | This field will identify the main location for a SWIFT/BIC. This allows for filtering the data to show only one instance for each SWIFT/BIC. The value of this field will equal Y or N, where Y indicates a unique instance and N indicates an additional instance |
Telephone (ACCUITY) | The telephone number of the institution (country and city codes are included). |
UpdateFlag (ACCUITY) | D = Deleted record, A = Add or New record, M = Modified record |