C6BANKM – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
C6B
Primary key
BANK-MNEMONIC
Fields
31
Updated by
0 programs
Referenced by
0 programs

C6BANKM is a Lawson C6 table (prefix C6B); no description in the lawson data dictionary. It is indexed by BANK-MNEMONIC (C6BSET1); alternate indexes: C6BSET2 and C6BSET4. It is related 1:M to BANKACCT and BANKFILE. The table has 31 fields, 3 indexes and 2 documented relations.

About C6BANKM

No description in the Lawson data dictionary.

Fields (31)

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

Field / columnTypeDescription & valuesUpdated by
C6B-BANK-MNEMONIC PK
BANK_MNEMONIC		Alpha 10——
C6B-BANK-LONG-NAME
BANK_LONG_NAME		Alpha 50——
C6B-IN-STATUS
IN_STATUS		Numeric 1——
C6B-IN-MICR-NO
IN_MICR_NO		Numeric 9——
C6B-IFSC
IFSC		Alpha 11——
C6B-IN-BRANCH-NAM
IN_BRANCH_NAM		Alpha 50——
C6B-ADDR1
ADDR1		Alpha 30 (Lower Case)——
C6B-ADDR2
ADDR2		Alpha 30 (Lower Case)——
C6B-ADDR3
ADDR3		Alpha 30 (Lower Case)——
C6B-ADDR4
ADDR4		Alpha 30 (Lower Case)——
C6B-CITY
CITY		Alpha 30——
C6B-COUNTRY-CODE
COUNTRY_CODE		Alpha 2——
C6B-STATE
STATE		Alpha 2——
C6B-PIN-CODE
PIN_CODE		Alpha 10——
C6B-AREA-CODE
AREA_CODE		Alpha 10——
C6B-CONT-PERSON
CONT_PERSON		Alpha 50——
C6B-CONT-NO1
CONT_NO1		Alpha 21——
C6B-CONT-NO2
CONT_NO2		Alpha 21——
C6B-CONT-EMAIL1
CONT_EMAIL1		Alpha 30——
C6B-CONT-EMAIL2
CONT_EMAIL2		Alpha 30——
C6B-TRN-CDE-HEAD
TRN_CDE_HEAD		Numeric 2——
C6B-USER-NUM
USER_NUM		Numeric 7——
C6B-LEDGER-FOLIO
LEDGER_FOLIO		Alpha 3——
C6B-TRN-CDE-DET
TRN_CDE_DET		Numeric 2——
C6B-DEST-ACCT-TYPE
DEST_ACCT_TYPE		Numeric 2——
C6B-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
C6B-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
C6B-CREATE-USERID
CREATE_USERID		Alpha 10 (Lower Case)——
C6B-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
C6B-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
C6B-USER-ID
USER_ID		Alpha 10 (Lower Case)——

Indexes (3)

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

IndexKeysFlagsConditionUsed in
C6BSET1BANK-MNEMONICPrimaryBN66.1, HR200, HR201, PR12.1, PR12.3, PR140, PR160, PR180 +15 more
C6BSET2IN-MICR-NO, BANK-MNEMONICKeyChange—
C6BSET4IFSC, BANK-MNEMONICKeyChangeBN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
BankacctBANKACCTC6B-BANK-MNEMONIC → BAC-BANK-MNEMONIC, → BAC-BNK-ACCT-NBR
BankfileBANKFILEC6B-BANK-MNEMONIC → BFL-BANK-MNEMONIC, → BFL-COMPANY, → BFL-BANK-CODE

Programs

No Lawson programs are documented as updating or referencing this table.