|
|
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 CBBB.1 CBOP.1
DT280
UPDATED BY
AC160 AC56.1 AC560 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP00.3 AP01.1 AP01.3 AP03.3 AP10.1
AP10.2 AP10.5 AP10.6 AP110 AP115 AP125
AP126 AP131 AP136 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 AP21.1
AP210 AP220 AP23.1 AP230 AP25.1 AP25.2
AP250 AP255 AP26.1 AP265 AP266 AP27.1
AP28.1 AP28.2 AP28.3 AP30.2 AP30.3 AP30.4
AP305 AP510 AP520 AP55.1 AP55.2 AP56.1
AP56.2 AP80.1 AP80.2 AP81.1 AP90.1 AP90.5
AP91.1 AP91.2 API1.1 API2.1 API3.1 API4.1
AR01.1 AR08.1 AR09.1 AR10.1 AR100 AR110
AR115 AR120 AR124 AR130 AR137 AR180
AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1
AR25.1 AR256 AR30.1 AR30.2 AR30.6 AR30.8
AR301 AR32.1 AR33.1 AR33.3 AR33.5 AR34.1
AR37.8 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.2 AR44.3 AR501 AR502 AR550 AR560
AR570 AR575 AR580 AR80.1 AR80.2 AR82.1
ARLL.1 BL02.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL802 BL820 BL92.1 BR10.9 CB00.3 CB00.4
CB00.5 CB00.7 CB02.1 CB06.1 CB06.2 CB10.1
CB145 CB15.1 CB15.2 CB150 CB170 CB180
CB185 CB186 CB187 CB190 CB191 CB20.1
CB210 CB220 CB221 CB245 CB246 CB25.1
CB255 CB260 CB286 CB30.1 CB300 CB43.1
CB44.1 CB45.1 CB46.1 CB50.1 CB500 CB54.1
CB543 CB544 CB55.1 CB554 CB56.1 CB80.1
CB81.1 CB82.1 CB82.2 CB90.4 CB90.8 CB99.5
CBBI.1 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 MX123
MX500 MA180 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO223
PO23.1 PO233 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO254 PO27.2 PO278 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.1 PO54.2 PO54.3
PO54.4 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 PW550 RQ10.1 RQ10.2 TX140 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
Description code.
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 AP21.1
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 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR570
AR575 AR580
AR82.1 ARLL.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
...
CBI-ACTIVE-STATUS Alpha 1 CB00.4
Element: Active Status The status of the bank transaction
code. Valid values are:
A = Active.
I = Inactive.
CBI-USED-FLAG Alpha 1 AC160 AC56.1
Element: Used Flag Indicates whether the bank transaction AC560 AM115
code has been used. Valid values are: AM117 AM15.1
AM15.2 AM15.3
N = No. AM15.4 AM19.1
Y = Yes. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP01.1 AP01.3
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP136 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 AP21.1
AP210 AP220
AP23.1 AP230
AP25.1 AP25.2
...
CBI-TAPE-PMT-SUMM Alpha 1 CB00.4
Element: Tape Payment SThe 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.
CBI-PMT-FORMAT Alpha 3 CB00.4
Element: Pmt Format This is the format of the electronic
payment (ie Post Giro)
CBI-ORG-IDENTIFIER Alpha 15 CB00.4
Element: Org Id
CBI-PMT-INSTRUCT1 Alpha 35 CB00.4
Element: Pmt Instruct
CBI-PMT-INSTRUCT2 Alpha 35 CB00.4
Element: Pmt Instruct
CBI-USER-FIELD1 Alpha 30 CB00.4
Element: User Field1 This 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.
CBI-USER-FIELD2 Alpha 30 CB00.4
Element: User Field2 This 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.
CBI-SORT-OPTION Alpha 1
Element: Sort Option
CBI-PAYMENT-OPT Alpha 1
Element: Payment Opt
CBBANKINST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBISET1 BANK-INST-CODE AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP01.1 AP01.3
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
...
CBISET2 BANK-INST-CODESubset
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
|
