Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            CBBANKINST FILE

                         Bank Transaction Code

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.

REFERENCED BY

AP213     AP284     AP520     CB01.2    CB05.1    DT280

UPDATED BY

AP00.3    AP01.1    AP01.3    AP10.1    AP10.2    AP10.5
AP10.6    AP110     AP150     AP151     AP155     AP156
AP160     AP161     AP166     AP167     AP170     AP180
AP181     AP190     AP230     AP250     AP255     AP260
AP265     AP266     AP28.1    AP28.2    AP28.3    AP30.3
AP510     AP55.1    AP55.2    AP56.1    AP56.2    AP80.1
AP80.2    AP81.1    AP90.5    AP91.2    API1.1    API2.1
API3.1    API4.1    AR01.1    AR08.1    AR100     AR110
AR115     AR124     AR130     AR137     AR190     AR20.1
AR21.1    AR21.2    AR21.3    AR24.1    AR25.1    AR256
AR30.1    AR30.2    AR30.3    AR30.4    AR30.6    AR30.8
AR31.5    AR37.8    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.2    AR44.3    AR501     AR502     AR550
AR560     AR570     AR575     AR580     AR82.1    BL02.1
CB00.3    CB00.4    CB00.5    CB00.7    CB02.1    CB06.1
CB06.2    CB10.1    CB15.1    CB15.2    CB180     CB185
CB190     CB191     CB20.1    CB210     CB220     CB221
CB25.1    CB260     CB30.1    CB300     CB500     CB80.1
CB90.4    DT150     DT155     DT160     DT161     DT165
DT166     DT180     DT181     DT185     DT30.1    DT30.2
DT40.1    DT45.1    DT520     DT60.1    DT60.2    DT70.1
DT70.3    DT80.1    DT80.2    DT80.4    DT85.1    DT85.2
DT85.3    DT90.1    DT90.3    DT92.1    DT95.2    EE20.1
EE20.2    EE20.4    EE35.1    EE35.2    EE520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CBI-BANK-INST-CODE   Alpha 3                                     CB00.4
Transaction Code     A user-defined code that represents a
                     cash payment, bill of exchange payment,
                     or bank service transaction.

CBI-BANK-INST-DESC   Alpha 30  (Lower Case)                      CB00.4
Transaction Code     The description of the transaction code.
Description

CBI-BANK-INST-TYPE   Alpha 1                                     CB00.4
Transaction Code     Indicates the type, or transaction
Type                 category, of bank transaction code.
                     Valid values are:

                     C = Cash Payment Transaction. Used in
                     the Lawson Accounts Payable system.

                     D = Bill of Exchange Payment
                     Transaction. Used in the Lawson Accounts
                     Payable and Accounts Receivable systems.

                     B = Bank Service Transaction. Used in
                     the Lawson Accounts Receivable and Cash
                     Ledger systems.

CBI-TRANS-VALUE      Alpha 1                                     CB00.4
Transaction          Indicates the value of transaction
Numbering Value      numbers for the bank transaction code.
                     Valid values are:

                     N = Numeric.
                     A = Alpha.

CBI-AUTO-RECON       Alpha 1                                     CB00.4
Automatic            Indicates whether transactions for the
Reconciliation       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.

CBI-PMT-DOC-ORIGIN   Alpha 1                                     CB00.4
BOE Payment          Used only for cash and bill of exchange
Document Origin      payment transaction codes. Indicates who
                     creates the payment document. Valid
                     values are:

                     P = Accounts Payable. The person or
                     company responsible for paying an
                     obligation creates the payment.

                     R = Accounts Receivable. The person or
                     company to whom an obligation is owed
                     creates the payment.

                     Blank. Not a cash or bill of exchange
                     payment transaction code.

CBI-OUTPUT-OPTION    Alpha 1                                     CB00.4
Output Option        Used 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:

                     N = No output. Payments are created
                     manually.

                     P = Printed Document. Cash payments are
                     printed using AP155 (Payment Forms
                     Creation). Bill of exchange payments are
                     printed using AP156 (Bill of Exchange
                     Printing) or DT155 (BOE Print-Tape
                     Create).

                     T = Tape or Electronic File. Cash
                     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.

CBI-AR-ACCEPT-FL     Alpha 1                                     CB00.4
AR Acceptance        Used only for bill of exchange payment
Required Flag        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:

                     N = No. Bills of exchange are
                     considered accepted upon entry or
                     creation.

                     Y = Yes. Bills of exchange must be
                     accepted in DT30 (Bill of Exchange
                     Acceptance).

CBI-AR-GL-ACCEPT     Alpha 1                                     CB00.4
AR Acceptance        Determines whether the Lawson Accounts
Accounting Flag      Receivable system will create general
                     ledger entries for this bill of exchange
                     type upon acceptance.
                     Y = Yes
                     N = No

CBI-AP-ACCEPT-FL     Alpha 1                                     CB00.4
AP Acceptance        Used only for bill of exchange payment
Required Flag        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:

                     N = No. Bills of exchange are
                     considered accepted upon entry or
                     creation.

                     Y = Yes. Bills of exchange must be
                     accepted in AP28 (Bill of Exchange
                     Acceptance).

CBI-PRENOTE-REQ      Alpha 1                                     CB00.4
Prenotification      Used only for cash payment bank
Required             transaction codes (Transaction Code Type
                     field = C) with the Output Option field
                     = 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:

                     N = No. Default value.
                     Y = Yes.

CBI-ALTERNATE-PMT    Alpha 3                                     CB00.4
Alternate            Required if Prenotification Required
Transaction Code     field = Y. Represents an alternate cash
                     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.

CBI-ACCT-BAL-TYPE    Alpha 1                                     CB00.4
Banking Transaction  Used only for bank service type bank
Type                 transaction codes (Transaction Code Type
                     field = B). Indicates whether the
                     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:

                     D = Bank Debit Transaction.
                     C = Bank Credit Transaction.
                     Blank = Not a bank service type bank
                     transaction code.

CBI-MN-PMT-RESERVE   Alpha 1                                     CB00.4
Manual Payment       Used only for cash payment type bank
Reservation          transaction codes (Transaction Code Type
                     field = C) with the Output Option field
                     = 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:

                     N = No.
                     Y = Yes.

CBI-TRANS-IDENT      Numeric 10                                  AP150   AP151
Transaction ID       A unique system-generated                   AP155   AP170
                     identification value assigned to a Cash     AP180   AP181
                     Ledger transaction to make the record       AP190   AP255
                     unique.                                     AP265   AP55.1
                                                                 AP56.1  AP81.1
                                                                 AP90.5  AR115
                                                                 AR124   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  CB06.2
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB180
                                                                 CB185   CB190
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 CB80.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT181
                                                                 DT185   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 ...

CBI-ACTIVE-STATUS    Alpha 1                                     CB00.4
Status               The status of the bank transaction
                     code. Valid values are:

                     A = Active.
                     I = Inactive.

CBI-USED-FLAG        Alpha 1                                     AP00.3  AP01.1
Used                 Indicates whether the bank transaction      AP01.3  AP10.1
                     code has been used. Valid values are:       AP10.2  AP10.5
                                                                 AP10.6  AP110
                     N = No.                                     AP150   AP151
                     Y = Yes.                                    AP155   AP156
                                                                 AP160   AP161
                                                                 AP166   AP167
                                                                 AP170   AP180
                                                                 AP181   AP190
                                                                 AP230   AP250
                                                                 AP255   AP260
                                                                 AP265   AP266
                                                                 AP28.1  AP28.2
                                                                 AP28.3  AP30.3
                                                                 AP510   AP55.1
                                                                 AP55.2  AP56.1
                                                                 AP56.2  AP80.1
                                                                 AP80.2  AP81.1
                                                                 AP90.5  AP91.2
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 AR01.1  AR08.1
                                                                 AR100   AR110
                                                                 AR115   AR124
                                                                 AR130   AR137
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR25.1  AR256
                                                                 ...

CBI-TAPE-PMT-SUMM    Alpha 1                                     CB00.4
Tape Payment         The payment summarization option for
Summarization        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.

                         CBBANKINST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBISET1   BANK-INST-CODEThis is the primary index used to keep   AP00.3  AP01.1
                        bank transaction code records unique.    AP01.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP150   AP151
                                                                 AP155   AP156
                                                                 AP160   AP161
                                                                 AP166   AP167
                                                                 AP170   AP180
                                                                 AP181   AP190
                                                                 AP213   AP230
                                                                 AP250   AP255
                                                                 AP260   AP265
                                                                 AP266   AP28.1
                                                                 AP28.2  AP28.3
                                                                 ...

CBISET2   BANK-INST-CODEThis index is used to access only cash
                        payment transaction code records.
                        Subset
                        Where BANK-INST-TYPE = "C"

                         CBBANKINST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbtrans        CBTRANS

                            CBI-BANK-INST-CODE    -> CBT-BANK-INST-CODE  (CBTSET1)
                                                     CBT-TRANS-IDENT