CBBANKINST – Bank Transaction Code

System
Cash Ledger (CB)
Prefix
CBI
Primary key
BANK-INST-CODE
Fields
34
Updated by
404 programs
Referenced by
20 programs

CBBANKINST is the Bank Transaction Code table in Lawson Cash Ledger (prefix CBI). It is indexed by BANK-INST-CODE (CBISET1); alternate indexes: CBISET2. It is related 1:M to CBTRANS. It is updated by AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 and 396 more and referenced by AP100, AP109, AP111, AP14.1, AP14.2, AP14.5, AP16.1, AP16.2 and 12 more. The table has 34 fields, 2 indexes and 1 documented relation.

About CBBANKINST

The Bank Transaction Code file contains transaction code records. A transaction code represents a type of cash payment, bill of exchange payment, or bank service.

Fields (34)

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

Field / columnTypeDescription & valuesUpdated by
CBI-BANK-INST-CODE PK
BANK_INST_CODE
Alpha 3A user-defined code that represents a cash payment, bill of exchange payment, or bank service transaction.CB00.4
CBI-BANK-INST-DESC
BANK_INST_DESC
Alpha 30 (Lower Case)The description of the transaction code.CB00.4
CBI-BANK-INST-TYPE
BANK_INST_TYPE
Alpha 1Indicates the type, or transaction category, of bank transaction code. Valid values are: the Lawson Accounts Payable system. Transaction. Used in the Lawson Accounts Payable and Accounts Receivable systems. the Lawson Accounts Receivable and Cash Ledger systems.
  • C Cash Payment Transaction. Used in
  • D Bill of Exchange Payment
  • B Bank Service Transaction. Used in
CB00.4
CBI-TRANS-VALUE
TRANS_VALUE
Alpha 1Indicates the value of transaction numbers for the bank transaction code. Valid values are:
  • N Numeric.
  • A Alpha.
  • U Numeric Auto Numbering
CB00.4
CBI-AUTO-RECON
AUTO_RECON
Alpha 1Indicates whether transactions for the bank transaction code are considered reconciled when they reach or are entered into the Lawson Cash Ledger system. If this field = No, transactions associated with this bank transaction code must be reconciled in the Lawson Cash Ledger system. Valid values are:
  • N No.
  • Y Yes.
CB00.4
CBI-PMT-DOC-ORIGIN
PMT_DOC_ORIGIN
Alpha 1Used only for cash and bill of exchange payment transaction codes. Indicates who creates the payment document. Valid values are: company responsible for paying an obligation creates the payment. company to whom an obligation is owed creates the payment. Blank. Not a cash or bill of exchange payment transaction code.
  • P Accounts Payable. The person or
  • R Accounts Receivable. The person or
CB00.4
CBI-OUTPUT-OPTION
OUTPUT_OPTION
Alpha 1Used only for cash payment and bill of exchange payment type bank transaction codes (Transaction Code Type field = C or D). Indicates the type of payment output to be created. Valid values are: manually. printed using AP155 (Payment Forms Creation). Bill of exchange payments are printed using AP156 (Bill of Exchange Printing) or DT155 (BOE Print-Tape Create). payments are created using AP160 (Payment Tape Creation) or AP161 (Electronic Payment File). Bill of Exchange payments are created using DT155 (BOE Print-Tape Create). Blank. Not a cash payment or bill of exchange payment type bank transaction code.
  • N No output. Payments are created
  • P Printed Document. Cash payments are
  • T Tape or Electronic File. Cash
CB00.4
CBI-AR-ACCEPT-FL
AR_ACCEPT_FL
Alpha 1Used only for bill of exchange payment type bank transaction codes (Transaction Code Type field = D). Indicates whether bill of exchange payments for this transaction code require acceptance in the Lawson Accounts Receivable system. Valid values are: considered accepted upon entry or creation. accepted in DT30 (Bill of Exchange Acceptance).
  • N No. Bills of exchange are
  • Y Yes. Bills of exchange must be
CB00.4
CBI-AR-GL-ACCEPT
AR_GL_ACCEPT
Alpha 1
  • Y Yes
  • N No
CB00.4
CBI-AP-ACCEPT-FL
AP_ACCEPT_FL
Alpha 1Used only for bill of exchange payment type bank transaction codes (Transaction Code Type field = D). Indicates whether bill of exchange payments for this transaction code require acceptance in the Lawson Accounts Payable system. Valid values are: considered accepted upon entry or creation. accepted in AP28 (Bill of Exchange Acceptance).
  • N No. Bills of exchange are
  • Y Yes. Bills of exchange must be
CB00.4
CBI-PRENOTE-REQ
PRENOTE_REQ
Alpha 1Used only for cash payment bank transaction codes (Transaction Code Type = T. Indicates whether the processing bank must be prenotified with bank account information before AP160 can create an ACH payment for a vendor using this cash payment transaction code. Valid values are:
  • field C) with the Output Option field
  • N No. Default value.
  • Y Yes.
CB00.4
CBI-ALTERNATE-PMT
ALTERNATE_PMT
Alpha 3Required if Prenotification Required payment transaction code used to create an accounts payable cash payment when the processing bank has not been prenotified. Must be a valid cash payment transaction code in the Transaction Code file.
  • field Y. Represents an alternate cash
CB00.4
CBI-ACCT-BAL-TYPE
ACCT_BAL_TYPE
Alpha 1Used only for bank service type bank transaction codes (Transaction Code Type transaction represents a bank debit, such as a withdrawal, which credits the general ledger or a bank credit, such as a bank charge, which debits the general ledger. Valid values are: transaction code.
  • field B). Indicates whether the
  • D Bank Debit Transaction.
  • C Bank Credit Transaction.
  • Blank Not a bank service type bank
CB00.4
CBI-MN-PMT-RESERVE
MN_PMT_RESERVE
Alpha 1Used only for cash payment type bank transaction codes (Transaction Code Type = N or P. Indicates whether the payment numbers you assign to manual payments in AP20 or AP55 must be reserved in AP81.1 (Manual Forms Reservation). Valid values are:
  • field C) with the Output Option field
  • N No.
  • Y Yes.
CB00.4
CBI-TRANS-IDENT
TRANS_IDENT
Numeric 10A unique system-generated identification value assigned to a Cash Ledger transaction to make the record unique.AP150, AP151, AP155, AP170, AP180, AP181, AP190, AP20.1 +51 more
CBI-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the bank transaction code. Valid values are:
  • A Active.
  • I Inactive.
CB00.4
CBI-USED-FLAG
USED_FLAG
Alpha 1Indicates whether the bank transaction code has been used. Valid values are:
  • N No.
  • Y Yes.
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
CBI-TAPE-PMT-SUMM
TAPE_PMT_SUMM
Alpha 1The payment summarization option for the transaction code. Indicates the cash ledger summarization breaks for electronic payments. Used for cash payment transaction codes only. Valid values are:
  • S Summarize Payments.
  • N Payment Detail.
CB00.4
CBI-PMT-FORMAT
PMT_FORMAT
Alpha 3This is the format of the electronic payment (ie Post Giro)CB00.4
CBI-ORG-IDENTIFIER
ORG_IDENTIFIER
Alpha 15CB00.4
CBI-PMT-INSTRUCT1
PMT_INSTRUCT1
Alpha 35CB00.4
CBI-PMT-INSTRUCT2
PMT_INSTRUCT2
Alpha 35CB00.4
CBI-USER-FIELD1
USER_FIELD1
Alpha 30This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.CB00.4
CBI-USER-FIELD2
USER_FIELD2
Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.CB00.4
CBI-SORT-OPTION
SORT_OPTION
Alpha 1CB00.4
CBI-PAYMENT-OPT
PAYMENT_OPT
Alpha 1CB00.4
CBI-PG-WITH-BG
PG_WITH_BG
Alpha 1CB00.4
CBI-SEQ-CTR
SEQ_CTR
Numeric 5
CBI-SEQ-NBR
SEQ_NBR
Numeric 6
CBI-LAST-RUN-DATE
LAST_RUN_DATE
Numeric 8 (yyyymmdd)
CBI-AUTO-NBR-VAL
AUTO_NBR_VAL
Numeric 10CB00.4, CB10.1, CB15.1, CB15.2, CB20.1, CB46.1, CB500, CB543 +1 more
CBI-ENTERPRISE-NBR
ENTERPRISE_NBR
Numeric 11
CBI-PAYER-CPY-ID
PAYER_CPY_ID
Alpha 11
CBI-PAYER-ACCT-NBR
PAYER_ACCT_NBR
Alpha 5

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CBISET1BANK-INST-CODEPrimaryAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
CBISET2BANK-INST-CODESubsetWhere BANK-INST-TYPE = "C"

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
CbtransCBTRANSCBI-BANK-INST-CODECBT-BANK-INST-CODE (CBTSET1), CBT-TRANS-IDENT

Programs

Updated by (404)

Referenced by (20)