|
|
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
AP00.3 AP01.1 AP01.3 AP10.1 AP10.2 AP10.5
AP10.6 AP110 AP125 AP126 AP150 AP151
AP155 AP156 AP157 AP160 AP161 AP166
AP167 AP170 AP180 AP181 AP190 AP20.1
AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP23.1
AP230 AP25.1 AP25.2 AP250 AP255 AP26.1
AP260 AP265 AP266 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
AR01.1 AR08.1 AR10.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 AR953 AR970
AR971 AR973 AR976 BL02.1 BL120 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 BL940 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 CB950
CB951 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 MA40.1
MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6
MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530
MA540 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE920
OE950 PO31.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBI-BANK-INST-CODE Alpha 3 CB00.4 CB950
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 CB950
Transaction Code The description of the transaction code.
Description
CBI-BANK-INST-TYPE Alpha 1 CB00.4 CB950
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 CB950
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 CB950
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 CB950
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 CB950
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 CB950
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 CB950
AR Acceptance Determines whether the Lawson Accounts
Accounting Flag Receivable system will create general
ledger entries for this bill of exchange
type upon acceptance. Valid values are:
Y = Yes.
N = No.
CBI-AP-ACCEPT-FL Alpha 1 CB00.4 CB950
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 CB950
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 CB950
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 CB950
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 CB950
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 AP157
identification value assigned to a Cash AP170 AP180
Ledger transaction to make the record AP181 AP190
unique. AP20.1 AP20.2
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
CB30.1 CB500
CB80.1 CB950
CB951 DT150
DT155 DT160
...
CBI-ACTIVE-STATUS Alpha 1 CB00.4 CB950
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. AP125 AP126
Y = Yes. AP150 AP151
AP155 AP156
AP157 AP160
AP161 AP166
AP167 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP230 AP25.1
AP25.2 AP250
AP255 AP26.1
AP260 AP265
AP266 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
AR01.1 AR08.1
AR10.1 AR100
AR110 AR115
...
CBI-TAPE-PMT-SUMM Alpha 1 CB00.4 CB950
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
AP125 AP126
AP150 AP151
AP155 AP156
AP157 AP160
AP161 AP166
AP167 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP213
...
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
|