CBBANKENT

Bank

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

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


UPDATED BY
AP155 AP156 AP16.1 AP16.2 AP160 AP161
AP166 AP170 AP180 AP181 AP190 AP200
AP255 AP265 AP58.1 AP81.1 AP90.5 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
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
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 AR09.1
AR09.2 AR10.1
AR301 AR501
AR550 CB00.1
CB00.2 CB00.3
CB00.5 CB01.1


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: Wed Jun 08 20:48:21 2016

Home
Contact Us



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