 |
Lawson Insight Technical Documentation |
|
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
|