|
|
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 AM117 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
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 AR09.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.6 AR30.8 AR301 AR31.5 AR33.1
AR33.3 AR33.5 AR34.1 AR34.2 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 BL820 BL92.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 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
IC840 MA61.1 MAI1.1 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 OE111 OE113
OE114 OE129 OE13.2 OE14.4 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE530 OE810 OE830 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 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 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
Element: Transaction IDA 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 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 CB15.1
CB15.2 CB180
CB185 CB190
CB191 CB20.1
CB25.1 CB30.1
CB500 CB80.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT185
DT30.1 DT30.2
DT40.1 DT45.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 AM115 AM117
Element: Used Flag Indicates whether the bank transaction AM15.1 AM15.2
code has been used. Valid values are: AM15.3 AM15.4
AM20.1 AM20.3
N = No. AM21.1 AM21.3
Y = Yes. 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
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
...
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 Numeric 15 CB00.4
Element: Org Identifier
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
Item Mster User This is the first user definable field.
Defined Field1 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
Item Mster User This is the second user definable
Defined Field2 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-CODEThis is the primary index used to keep AM115 AM117
bank transaction code records unique. 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
...
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
|
