CBBANKENT – Bank

System
Cash Ledger (CB)
Prefix
CBE
Primary key
BANK-ENTITY
Fields
26
Updated by
55 programs
Referenced by
94 programs

CBBANKENT is the Bank table in Lawson Cash Ledger (prefix CBE). It is indexed by BANK-ENTITY (CBESET1). It is related 1:1 to CBBANKBOD and 1:M to CBBANKAUD and CBCASHCODE. It is updated by AP155, AP156, AP16.1, AP16.2, AP160, AP161, AP166, AP170 and 47 more and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 and 86 more. The table has 26 fields, 1 index and 3 documented relations.

About CBBANKENT

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

Fields (26)

Column = COBOL field name without the CBE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CBE-BANK-ENTITY PK
BANK_ENTITY		Alpha 15The unique identifier assigned to the bank location.AP16.1, AP16.2, AP58.1, CB00.1
CBE-BANK-NAME
BANK_NAME		Alpha 60 (Lower Case)The name of the bank location.AP16.1, AP16.2, AP58.1, CB00.1
CBE-BRANCH-NAME
BRANCH_NAME		Alpha 60 (Lower Case)The name of the bank.AP16.1, AP16.2, AP58.1, CB00.1
CBE-ADDR1
ADDR1		Alpha 30 (Lower Case)The first line of address information for the bank location.AP16.1, AP16.2, AP58.1, CB00.1
CBE-ADDR2
ADDR2		Alpha 30 (Lower Case)The second line of address information for the bank location.AP16.1, AP16.2, AP58.1, CB00.1
CBE-ADDR3
ADDR3		Alpha 30 (Lower Case)The third line of address information for the bank location.AP16.1, AP16.2, AP58.1, CB00.1
CBE-ADDR4
ADDR4		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
CITY_ADDR5		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
STATE_PROV		Alpha 2The state or province for the bank address.AP16.1, AP16.2, AP58.1, CB00.1
CBE-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)The postal code for the bank address.AP16.1, AP16.2, AP58.1, CB00.1
CBE-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.AP16.1, AP16.2, AP58.1, CB00.1
CBE-COUNTRY
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
CONTACT_DESC		Alpha 30The name of the contact person for the bank location.CB00.1
CBE-PHONE-PREFIX
PHONE_PREFIX		Alpha 6The telephone number country code for the bank location.CB00.1
CBE-PHONE-NUMBER
PHONE_NUMBER		Alpha 15The telephone number for the bank location.CB00.1
CBE-PHONE-EXT
PHONE_EXT		Alpha 5The telephone extension number for the bank location.CB00.1
CBE-FAX-PREFIX
FAX_PREFIX		Alpha 6The fax machine telephone number country code for the bank location.CB00.1
CBE-FAX-NUMBER
FAX_NUMBER		Alpha 15The fax machine telephone number for the bank location.CB00.1
CBE-FAX-EXT
FAX_EXT		Alpha 5The fax machine telephone extension number for the bank location.CB00.1
CBE-CHG-ACCT-CODE
CHG_ACCT_CODE		Numeric 1The 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
USED_FLAG		Alpha 1Indicates whether the bank has been used. Valid values are:
  • Y Yes.
  • N No.
AP155, AP156, AP160, AP161, AP166, AP170, AP180, AP181 +44 more
CBE-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The 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
CREATED_BY		Alpha 10—AP16.1, AP16.2, AP58.1, CB00.1
CBE-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP155, AP156, AP16.1, AP16.2, AP160, AP161, AP166, AP170 +47 more
CBE-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP155, AP156, AP16.1, AP16.2, AP160, AP161, AP166, AP170 +47 more
CBE-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP155, AP156, AP16.1, AP16.2, AP160, AP161, AP166, AP170 +47 more

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CBESET1BANK-ENTITYPrimaryAP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CbbankbodCBBANKBODNot Required, Delete CascadesCBE-BANK-ENTITY → YBG-BANK-ENTITY

One to many (2) — child tables

RelationTableRulesConditionField map
CbbankaudCBBANKAUDCBE-BANK-ENTITY → CAB-BANK-ENTITY, → CAB-UNIQUE-I-D
CbcashcodeCBCASHCODECBE-BANK-ENTITY → CBC-BANK-ENTITY, → CBC-CASH-CODE

Programs

Updated by (55)

Referenced by (94)