CBBANKINST

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
AP100 AP109 AP111 AP14.1 AP14.2 AP14.5
AP16.1 AP16.2 AP193 AP213 AP284 AP590
CB01.2 CB05.1 CBBB.1 CBOP.1 EE135 MA64.6
MA64.9 MAED.1


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 AM22.1 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 AP232
AP25.1 AP25.2 AP250 AP255 AP26.1 AP265
AP266 AP27.1 AP271 AP28.1 AP28.2 AP28.3
AP30.2 AP30.3 AP30.4 AP300 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 ZA161 AR01.1
AR08.1 AR09.1 AR10.1 AR301 AR501 AR550
ARLL.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 CB20.6 CB210
CB220 CB221 CB222 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.2 CB56.4
CB57.1 CB80.1 CB81.1 CB82.1 CB82.2 CB90.4
CB90.8 CB99.5 CBBI.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 EE20.1 EE20.2 EE20.4 EE35.1 EE35.2
EE520 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 IC840 MX123 MX500 MA126
MA180 MA278 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO192 PO195
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO222 PO223 PO224
PO225 PO229 PO23.1 PO230 PO233 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO253 PO254 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO278
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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
PO529 PO536 PO54.1 PO54.2 PO54.3 PO54.4
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 TX140 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBI-BANK-INST-CODE
Element: Transaction Code
Alpha 3
A user-defined code that represents a cash payment, bill of exchange payment, or bank service transaction.
CB00.4
CBI-BANK-INST-DESC
Transaction Code
Description
Alpha 30 (Lower Case)
The description of the transaction code.
CB00.4
CBI-BANK-INST-TYPE
Transaction Code
Type
Alpha 1
Indicates the type, or transaction 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.
CB00.4
CBI-TRANS-VALUE
Transaction
Numbering Value
Alpha 1
Indicates the value of transaction numbers for the bank transaction code. Valid values are: N = Numeric. A = Alpha.
U = Numeric Auto Numbering
CB00.4
CBI-AUTO-RECON
Automatic
Reconciliation
Alpha 1
Indicates whether transactions for the 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.
CB00.4
CBI-PMT-DOC-ORIGIN
BOE Payment
Document Origin
Alpha 1
Used only for cash and bill of exchange 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.
CB00.4
CBI-OUTPUT-OPTION
Element: Output Option
Alpha 1
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.
CB00.4
CBI-AR-ACCEPT-FL
AR Acceptance
Required Flag
Alpha 1
Used only for bill of exchange payment 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).
CB00.4
CBI-AR-GL-ACCEPT
AR Acceptance
Accounting Flag
Alpha 1

Y = Yes
N = No
CB00.4
CBI-AP-ACCEPT-FL
AP Acceptance
Required Flag
Alpha 1
Used only for bill of exchange payment 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).
CB00.4
CBI-PRENOTE-REQ
Prenotification
Required
Alpha 1
Used only for cash payment bank 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.
CB00.4
CBI-ALTERNATE-PMT
Alternate
Transaction Code
Alpha 3
Required if Prenotification Required 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.
CB00.4
CBI-ACCT-BAL-TYPE
Banking Transaction
Type
Alpha 1
Used only for bank service type bank 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.
CB00.4
CBI-MN-PMT-RESERVE
Manual Payment
Reservation
Alpha 1
Used only for cash payment type bank 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.
CB00.4
CBI-TRANS-IDENT
Element: Transaction ID
Numeric 10
A unique system-generated identification value assigned to a Cash Ledger transaction to make the record unique.
AP150 AP151
AP155 AP170
AP180 AP181
AP190 AP20.1
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 ARLL.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE20.1
EE20.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
CBI-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the bank transaction code. Valid values are: A = Active. I = Inactive.
CB00.4
CBI-USED-FLAG
Element: Used Flag
Alpha 1
Indicates whether the bank transaction code has been used. Valid values are: N = No. Y = Yes.
...
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 AM22.1
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 AP232
CBI-TAPE-PMT-SUMM
Element: Tape Payment Summary
Alpha 1
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.
CB00.4
CBI-PMT-FORMAT
Element: Pmt Format
Alpha 3
This is the format of the electronic payment (ie Post Giro)
CB00.4
CBI-ORG-IDENTIFIER
Element: Org Id
Alpha 15
CB00.4
CBI-PMT-INSTRUCT1
Element: Pmt Instruct
Alpha 35
CB00.4
CBI-PMT-INSTRUCT2
Element: Pmt Instruct
Alpha 35
CB00.4
CBI-USER-FIELD1
Element: User Field1
Alpha 30
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.
CB00.4
CBI-USER-FIELD2
Element: User Field2
Alpha 30
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.
CB00.4
CBI-SORT-OPTION
Element: Sort Option
Alpha 1
CB00.4
CBI-PAYMENT-OPT
Element: Payment Opt
Alpha 1
CB00.4
CBI-PG-WITH-BG
Element: Pg With Bg
Alpha 1
CB00.4
CBI-SEQ-CTR
Element: Seq Ctr
Numeric 5
CBI-SEQ-NBR
Element: Seq Number
Numeric 6
CBI-LAST-RUN-DATE
Element: Last Run Date
Numeric 8 (yyyymmdd)
CBI-AUTO-NBR-VAL
Element: Last Doc Nbr
Numeric 10
CB00.4 CB10.1
CB15.1 CB15.2
CB20.1 CB46.1
CB500 CB543
CB544
CBI-ENTERPRISE-NBR
Element: Dollar Limit
Numeric 11
CBI-PAYER-CPY-ID
Element: Bsi Group
Alpha 11
CBI-PAYER-ACCT-NBR
Element: Approve Cd
Alpha 5


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 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP01.1
AP01.3 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP100 AP109
CBISET2 BANK-INST-CODE
Subset
WhereBANK-INST-TYPE ="C"


CBBANKINST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbtrans CBTRANS
CBI-BANK-INST-CODE->CBT-BANK-INST-CODE (CBTSET1)
  CBT-TRANS-IDENT


File created: Thu Jun 09 02:11:59 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.