Lawson Insight Technical Documentation |
|
CBBANKENT
CBBANKENT FILE
Bank
The Bank file contains bank records. A bank represents a financial
institution location.
REFERENCED BY
AP167 AR09.1 AR09.2 AR10.1 AR301 AR501
AR550 BL02.1 CB01.1 CB01.7 DT52.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 AR115
AR124 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1
AR30.1 AR31.5 AR33.5 AR34.1 AR42.1 AR42.2
AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR560
AR570 AR575 AR580 AR82.1 ARLL.1 CB00.1
CB00.2 CB00.3 CB00.5 CB06.2 CB10.1 CB15.1
CB15.2 CB180 CB185 CB190 CB191 CB20.1
CB210 CB215 CB220 CB221 CB25.1 CB260
CB30.1 CB300 CB500 CB80.1 DT150 DT155
DT160 DT161 DT165 DT166 DT170 DT180
DT181 DT185 DT30.1 DT30.2 DT40.1 DT42.1
DT45.1 DT520 DT60.1 DT60.2 DT70.1 DT70.3
DT80.1 DT85.1 DT85.2 DT92.1 EE20.1 EE20.2
EE20.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBE-BANK-ENTITY Alpha 15 AP16.1 AP16.2
Element: Bank The unique identifier assigned to the AP58.1 CB00.1
bank location.
CBE-BANK-NAME Alpha 60 (Lower Case) AP16.1 AP16.2
Element: Bank Name The name of the bank location. AP58.1 CB00.1
CBE-BRANCH-NAME Alpha 60 (Lower Case) AP16.1 AP16.2
Element: Bank Name AP58.1 CB00.1
CBE-ADDR1 Alpha 30 (Lower Case) AP16.1 AP16.2
Element: Address 1 The first line of address information AP58.1 CB00.1
for the bank location.
CBE-ADDR2 Alpha 30 (Lower Case) AP16.1 AP16.2
Element: Address 2 The second line of address information AP58.1 CB00.1
for the bank location.
CBE-ADDR3 Alpha 30 (Lower Case) AP16.1 AP16.2
Element: Address 3 The third line of address information AP58.1 CB00.1
for the bank location.
CBE-ADDR4 Alpha 30 (Lower Case) AP16.1 AP16.2
Element: Address 4 The fourth line of address information AP58.1 CB00.1
for the bank location.
CBE-CITY-ADDR5 Alpha 18 (Lower Case) AP16.1 AP16.2
Element: City or AddresThe city or fifth line of address AP58.1 CB00.1
information for the bank location.
CBE-STATE-PROV Alpha 2 AP16.1 AP16.2
Element: State or ProviThe state or province for the bank AP58.1 CB00.1
address.
CBE-POSTAL-CODE Alpha 10 (Lower Case) AP16.1 AP16.2
Element: Postal Code The postal code for the bank address. AP58.1 CB00.1
CBE-COUNTY Alpha 25 (Lower Case) AP16.1 AP16.2
Element: County The county for the company address. AP58.1 CB00.1
CBE-COUNTRY Alpha 30 (Lower Case) AP16.1 AP16.2
Element: Country The country for the bank address. Can AP58.1 CB00.1
also be used for additional information
such as an attention name.
CBE-CONTACT-DESC Alpha 30 CB00.1
Element: Contact The name of the contact person for the
bank location.
CBE-PHONE-PREFIX Alpha 6 CB00.1
Element: Phone Prefix The telephone number country code for
the bank location.
CBE-PHONE-NUMBER Alpha 15 CB00.1
Element: Phone Number The telephone number for the bank
location.
CBE-PHONE-EXT Alpha 5 CB00.1
Element: Phone ExtensioThe telephone extension number for the
bank location.
CBE-FAX-PREFIX Alpha 6 CB00.1
Element: Fax Prefix The fax machine telephone number country
code for the bank location.
CBE-FAX-NUMBER Alpha 15 CB00.1
Element: Fax Number The fax machine telephone number for
the bank location.
CBE-FAX-EXT Alpha 5 CB00.1
Element: Fax Extension The fax machine telephone extension
number for the bank location.
CBE-CHG-ACCT-CODE Numeric 1 CB00.1
Element: Charge AccountThe 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 AP155 AP156
Element: Used Flag Indicates whether the bank has been AP160 AP161
used. Valid values are: AP166 AP170
AP180 AP181
Y = Yes. AP190 AP200
N = No. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR570
AR575 AR580
AR82.1 ARLL.1
CB00.1 CB00.2
CB00.3 CB00.5
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB210
CB215 CB220
CB221 CB25.1
CB260 CB30.1
CB300 CB500
...
CBE-COUNTRY-CODE Alpha 2 AP16.1 AP16.2
Element: Country Code The country code. Required for VAT and AP58.1 CB00.1
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 AP155 AP156
validate and keep bank records unique. 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 AR115
AR124 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR30.1 AR301
...
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
|