Lawson Insight Technical Documentation |
|
CBBANKINST
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 CB01.2 CB05.1 DT280
UPDATED BY
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP00.3 AP01.1 AP01.3 AP10.1 AP10.2
AP10.5 AP10.6 AP110 AP125 AP126 AP150
AP151 AP155 AP156 AP160 AP161 AP166
AP167 AP170 AP180 AP181 AP190 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP20.8 AP23.1 AP230 AP25.1 AP25.2 AP250
AP255 AP26.1 AP260 AP265 AP266 AP27.1
AP28.1 AP28.2 AP28.3 AP30.3 AP510 AP520
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 AR10.1 AR100 AR110
AR115 AR124 AR130 AR137 AR180 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 AR30.9 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 BR15.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 IC840 MA41.2 MA41.7 MA43.2 MA61.1
MAI1.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBI-BANK-INST-CODE Alpha 3 CB00.4
Element: Transaction CoA 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
Element: 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 Y = Yes
Accounting Flag 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
Element: Transaction IDA unique system-generated AP155 AP170
identification value assigned to a Cash AP180 AP181
Ledger transaction to make the record AP190 AP20.1
unique. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP255 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 CB25.1
CB30.1 CB500
CB80.1 DT150
DT155 DT160
...
CBI-ACTIVE-STATUS Alpha 1 CB00.4
Element: Status The status of the bank transaction
code. Valid values are:
A = Active.
I = Inactive.
CBI-USED-FLAG Alpha 1 AM115 AM15.1
Element: Used Indicates whether the bank transaction AM15.2 AM15.3
code has been used. Valid values are: AM15.4 AM20.1
AM20.3 AM21.1
N = No. AM21.3 AM500
Y = Yes. AM51.1 AM551
AM97.1 AP00.3
AP01.1 AP01.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP150
AP151 AP155
AP156 AP160
AP161 AP166
AP167 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP230 AP25.1
AP25.2 AP250
AP255 AP26.1
AP260 AP265
AP266 AP27.1
AP28.1 AP28.2
AP28.3 AP30.3
AP510 AP520
...
CBI-TAPE-PMT-SUMM Alpha 1 CB00.4
Element: Ac Usage The 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.
CBBANKINST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBISET1 BANK-INST-CODEThis is the primary index used to keep AM115 AM15.1
bank transaction code records unique. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP01.1 AP01.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP150
AP151 AP155
AP156 AP160
AP161 AP166
...
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
|