 |
Lawson Insight Technical Documentation |
|
CBBANKENT FILE
Bank
The Bank file contains bank records. A bank represents a financial
institution location.
REFERENCED BY
AP167 AR501 AR550 CB01.1 CB05.1 CB99.1
CB99.2 DT52.1
UPDATED BY
AP01.1 AP151 AP155 AP156 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-COUNTY Alpha 25 (Lower Case) CB00.1
County The county for the company 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: AP160 AP161
AP166 AP170
Y = Yes. AP180 AP181
N = No. 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
...
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
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
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
...
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
|