CBBANKENT

Bank

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

REFERENCED BY
AP10.1 AP10.2 AP100 AP109 AP110 AP111
AP115 AP125 AP126 AP14.1 AP14.2 AP14.5
AP150 AP151 AP167 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.6 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1
AP28.2 AP30.1 AP30.2 AP30.4 AP300 AP305
AP510 AP520 AP590 API1.1 API2.1 AR09.1
AR09.2 AR10.1 AR301 AR501 AR550 CB01.1
CB01.7 CB07.1 CB170 CB175 CB286 CB55.1
CBBC.1 CBOD.2 EE135 EE35.1 EE35.2 EE520
IC64.6 MX123 MX500 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA44.1 MA44.2 MA60.2 MA60.3
MA60.4 MA61.1 MA64.6 MA64.9 MA65.1 MA66.1
MA66.2 MA66.3 MA67.3 MA68.2 MA68.4 MA70.1
MA75.1 MAED.1 MAI1.1 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 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
CBE-CREATED-BY
Element: Operator
Alpha 10
AP16.1 AP16.2
AP58.1 CB00.1
CBE-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
AP155 AP156
AP16.1 AP16.2
AP160 AP161
AP166 AP170
AP180 AP181
AP190 AP200
AP255 AP265
AP58.1 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-LAST-UPDT-TIME
Element: Time
Numeric 8
AP155 AP156
AP16.1 AP16.2
AP160 AP161
AP166 AP170
AP180 AP181
AP190 AP200
AP255 AP265
AP58.1 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-LAST-UPDATE-BY
Element: Operator
Alpha 10
AP155 AP156
AP16.1 AP16.2
AP160 AP161
AP166 AP170
AP180 AP181
AP190 AP200
AP255 AP265
AP58.1 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


CBBANKENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBESET1 BANK-ENTITY
...
AP10.1 AP10.2
AP100 AP109
AP110 AP111
AP115 AP125
AP126 AP14.1
AP14.2 AP14.5
AP150 AP151
AP155 AP156
AP16.1 AP16.2
AP160 AP161
AP166 AP167
AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3


CBBANKENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbbankbod CBBANKBOD Not Required, Delete Cascades
CBE-BANK-ENTITY->YBG-BANK-ENTITY


CBBANKENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbbankaud CBBANKAUD
CBE-BANK-ENTITY->CAB-BANK-ENTITY
  CAB-UNIQUE-I-D
Cbcashcode CBCASHCODE
CBE-BANK-ENTITY->CBC-BANK-ENTITY
  CBC-CASH-CODE


File created: Thu Jun 09 02:11:58 2016

Home
Contact Us



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