CBBANKENT

Bank

The Bank file contains bank records. A bank represents a financial institution location.

REFERENCED BY
AP150 AR09.1 AR09.2 AR10.1 AR301 AR501
AR550 CB170 CB175 CB286 CB55.1 MX123
MX500 TX140 AP167 CB01.1 CB01.7 CBBC.1


UPDATED BY
AP155 AP156 AP16.1 AP16.2 AP160 AP161
AP166 AP170 AP180 AP181 AP190 AP200
AP255 AP265 AP58.1 AP81.1 AP90.5 ZA161
ARLL.1 CB00.1 CB00.2 CB00.3 CB00.5 CB06.2
CB10.1 CB145 CB15.1 CB15.2 CB150 CB180
CB185 CB186 CB187 CB190 CB191 CB20.1
CB20.6 CB210 CB215 CB220 CB221 CB222
CB25.1 CB260 CB30.1 CB300 CB46.1 CB500
CB543 CB544 CB80.1 CB82.1 EE20.1 EE20.2
EE20.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBE-BANK-ENTITY
Element: Bank		Alpha 15
The unique identifier assigned to the bank location.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-BANK-NAME
Element: Bank Name		Alpha 60 (Lower Case)
The name of the bank location.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-BRANCH-NAME
Element: Bank Name		Alpha 60 (Lower Case)
The name of the bank.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-ADDR1
Element: Address 1		Alpha 30 (Lower Case)
The first line of address information for the bank location.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-ADDR2
Element: Address 2		Alpha 30 (Lower Case)
The second line of address information for the bank location.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-ADDR3
Element: Address 3		Alpha 30 (Lower Case)
The third line of address information for the bank location.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-ADDR4
Element: Address 4		Alpha 30 (Lower Case)
The fourth line of address information for the bank location.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-CITY-ADDR5
Element: City or Address 5		Alpha 18 (Lower Case)
The city or fifth line of address information for the bank location.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-STATE-PROV
Element: State or Province		Alpha 2
The state or province for the bank address.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-POSTAL-CODE
Element: Postal Code		Alpha 10 (Lower Case)
The postal code for the bank address.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-COUNTRY
Element: Country		Alpha 30 (Lower Case)
The country for the bank address. Can also be used for additional information such as an attention name.
AP16.1 AP16.2
AP58.1 CB00.1
CBE-CONTACT-DESC
Element: Contact		Alpha 30
The name of the contact person for the bank location.
CB00.1
CBE-PHONE-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code for the bank location.
CB00.1
CBE-PHONE-NUMBER
Element: Phone Number		Alpha 15
The telephone number for the bank location.
CB00.1
CBE-PHONE-EXT
Element: Phone Extension		Alpha 5
The telephone extension number for the bank location.
CB00.1
CBE-FAX-PREFIX
Element: Fax Prefix		Alpha 6
The fax machine telephone number country code for the bank location.
CB00.1
CBE-FAX-NUMBER
Element: Fax Number		Alpha 15
The fax machine telephone number for the bank location.
CB00.1
CBE-FAX-EXT
Element: Fax Extension		Alpha 5
The fax machine telephone extension number for the bank location.
CB00.1
CBE-CHG-ACCT-CODE
Element: Charge Account		Numeric 1
The charge account for the bank. Used for payments transmitted electronically using the SWIFT system. Indicates which account should be charged. Valid values are: 1 = Principals base account. 2 = Principals foreign account. 3 = Beneficiary.
CB00.1
CBE-USED-FLAG
Element: Used Flag		Alpha 1
Indicates whether the bank has been used. Valid values are: Y = Yes. N = No.
AP155 AP156
AP160 AP161
AP166 AP170
AP180 AP181
AP190 AP200
AP255 AP265
AP81.1 AP90.5
ARLL.1 CB00.1
CB00.2 CB00.3
CB00.5 CB06.2
CB10.1 CB145
CB15.1 CB15.2
CB150 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB210
CB215 CB220
CB221 CB222
CB25.1 CB260
CB30.1 CB300
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
EE20.1 EE20.2
EE20.4 ZA161
CBE-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AP16.1 AP16.2
AP58.1 CB00.1


CBBANKENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBESET1 BANK-ENTITY
...
AP150 AP155
AP156 AP16.1
AP16.2 AP160
AP161 AP166
AP167 AP170
AP180 AP181
AP190 AP200
AP255 AP265
AP58.1 AP81.1
AP90.5 ZA161
AR09.1 AR09.2
AR10.1 AR301
AR501 AR550
ARLL.1 CB00.1
CB00.2 CB00.3


CBBANKENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbcashcode CBCASHCODE
CBE-BANK-ENTITY->CBC-BANK-ENTITY
  CBC-CASH-CODE

File created: Thu Jun 09 11:11:36 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.