CBBANKENT FILE
Bank
The Bank file contains bank records. A bank represents a financial
institution location.
REFERENCED BY
AP167 AR09.2 AR501 AR550 CB01.1 CB05.1
CB99.1 CB99.2 DT52.1
UPDATED BY
AP01.1 AP151 AP155 AP156 AP157 AP160
AP161 AP166 AP170 AP180 AP181 AP190
AP195 AP200 AP230 AP250 AP255 AP265
AP55.1 AP55.2 AP56.1 AP80.1 AP81.1 AP90.5
AR115 AR124 AR20.1 AR21.1 AR21.2 AR21.3
AR24.1 AR30.1 AR30.2 AR30.4 AR31.5 AR42.1
AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR502
AR560 AR570 AR575 AR580 AR82.1 CB00.1
CB00.2 CB00.3 CB00.5 CB02.1 CB06.2 CB10.1
CB15.1 CB15.2 CB175 CB180 CB185 CB190
CB191 CB195 CB20.1 CB210 CB215 CB220
CB221 CB25.1 CB260 CB30.1 CB300 CB500
CB80.1 CB90.3 CB90.4 DT150 DT155 DT160
DT161 DT165 DT166 DT170 DT180 DT181
DT185 DT270 DT30.1 DT30.2 DT40.1 DT42.1
DT45.1 DT520 DT60.1 DT60.2 DT70.1 DT70.3
DT80.1 DT80.4 DT85.1 DT85.2 DT90.3 DT92.1
EE20.1 EE20.2 EE20.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBE-BANK-ENTITY Alpha 15 CB00.1
Bank The unique identifier assigned to the
bank location.
CBE-BANK-NAME Alpha 30 (Lower Case) CB00.1
Bank Name The name of the bank location.
CBE-ADDR1 Alpha 30 (Lower Case) CB00.1
Address 1 The first line of address information
for the bank location.
CBE-ADDR2 Alpha 30 (Lower Case) CB00.1
Address 2 The second line of address information
for the bank location.
CBE-ADDR3 Alpha 30 (Lower Case) CB00.1
Address 3 The third line of address information
for the bank location.
CBE-ADDR4 Alpha 30 (Lower Case) CB00.1
Address 4 The fourth line of address information
for the bank location.
CBE-CITY-ADDR5 Alpha 18 (Lower Case) CB00.1
City or Address 5 The city or fifth line of address
information for the bank location.
CBE-STATE-PROV Alpha 2 CB00.1
State or Province The state or province for the bank
address.
CBE-POSTAL-CODE Alpha 10 (Lower Case) CB00.1
Postal Code The postal code for the bank address.
CBE-COUNTRY Alpha 30 (Lower Case) CB00.1
Country or Other The country for the bank address. Can
also be used for additional information
such as an attention name.
CBE-CONTACT-DESC Alpha 30 CB00.1
Contact The name of the contact person for the
bank location.
CBE-PHONE-PREFIX Alpha 6 CB00.1
Telephone Country The telephone number country code for
Code the bank location.
CBE-PHONE-NUMBER Alpha 15 CB00.1
Telephone Number The telephone number for the bank
location.
CBE-PHONE-EXT Alpha 5 CB00.1
Telephone Extension The telephone extension number for the
bank location.
CBE-FAX-PREFIX Alpha 6 CB00.1
Fax Country Code The fax machine telephone number
country code for the bank location.
CBE-FAX-NUMBER Alpha 15 CB00.1
Fax Number The fax machine telephone number for
the bank location.
CBE-FAX-EXT Alpha 5 CB00.1
Fax Extension The fax machine telephone extension
number for the bank location.
CBE-CHG-ACCT-CODE Numeric 1 CB00.1
Charge Account 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.
CBE-USED-FLAG Alpha 1 AP01.1 AP151
Used Indicates whether the bank has been AP155 AP156
used. Valid values are: AP157 AP160
AP161 AP166
Y = Yes. AP170 AP180
N = No. AP181 AP190
AP195 AP200
AP230 AP250
AP255 AP265
AP55.1 AP55.2
AP56.1 AP80.1
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR570
AR575 AR580
AR82.1 CB00.1
CB00.2 CB00.3
CB00.5 CB02.1
CB06.2 CB10.1
CB15.1 CB15.2
CB175 CB180
CB185 CB190
...
CBE-COUNTRY-CODE Alpha 2 CB00.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CBBANKENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBESET1 BANK-ENTITY This is the primary index used to AP01.1 AP151
validate and keep bank records unique. AP155 AP156
AP157 AP160
AP161 AP166
AP167 AP170
AP180 AP181
AP190 AP195
AP200 AP230
AP250 AP255
AP265 AP55.1
AP55.2 AP56.1
AP80.1 AP81.1
AP90.5 AR09.2
AR115 AR124
AR20.1 AR21.1
...
CBBANKENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbcashcode CBCASHCODE
CBE-BANK-ENTITY -> CBC-BANK-ENTITY
CBC-CASH-CODE
|