 |
Lawson Insight Technical Documentation |
|
CBCASHCODE FILE
Cash Code
The Cash Code file contains all valid cash codes. A cash code represents a
bank account at a financial institution location.
REFERENCED BY
AR01.1 AR02.1 AR29.2 AR48.2 AR700 CB05.1
CB11.1 CB211
UPDATED BY
AP00.3 AP00.4 AP00.5 AP01.1 AP10.1 AP10.2
AP10.5 AP10.6 AP110 AP115 AP125 AP126
AP150 AP151 AP155 AP156 AP160 AP161
AP166 AP167 AP170 AP180 AP181 AP190
AP195 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP20.8 AP200 AP23.1 AP230
AP25.1 AP25.2 AP250 AP255 AP26.1 AP265
AP266 AP27.1 AP270 AP28.1 AP28.2 AP30.3
AP510 AP520 AP55.1 AP55.2 AP56.1 AP56.2
AP80.1 AP80.2 AP81.1 AP90.5 AP91.1 API1.1
API2.1 API3.1 API4.1 AR115 AR124 AR14.1
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR27.1
AR28.9 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 CB00.2 CB00.3
CB00.5 CB02.1 CB06.1 CB06.2 CB10.1 CB10.3
CB15.1 CB15.2 CB175 CB180 CB185 CB190
CB191 CB195 CB20.1 CB210 CB215 CB220
CB221 CB25.1 CB260 CB30.1 CB300 CB500
CB80.1 CB90.1 CB90.2 CB90.3 CB90.4 CB99.1
DT150 DT155 DT160 DT161 DT165 DT166
DT170 DT180 DT181 DT185 DT270 DT30.1
DT30.2 DT40.1 DT45.1 DT520 DT60.1 DT60.2
DT70.1 DT70.3 DT80.1 DT80.4 DT85.1 DT85.2
DT90.1 DT90.2 DT90.3 DT92.1 EE135 EE20.1
EE20.2 EE20.4 EE35.1 EE35.2 EE520 IC840
MA41.2 MA43.2 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBC-CASH-CODE Alpha 4 CB00.2 CB99.1
Cash Code A user-defined code representing a bank
account at a bank location.
CBC-BANK-ACCT-NBR Alpha 17 CB00.2
Bank Account Number The bank-assigned account number
identification to be used for the cash
code.
CBC-CURRENCY-CODE Alpha 5 CB00.2
Bank Account The currency of the bank account. Must
Currency be a valid record in the Currency Code
file.
CBC-BANK-ENTITY Alpha 15 CB00.2
Bank Identification The bank location where the bank
account is located. Must be a valid
record in the Bank file.
CBC-SEND-BANK-ENT Alpha 15 CB00.2
Electronic Transfer If the bank for the cash code does not
Bank process electronic payments, this field
contains the bank that processes the
electronic payment media, if applicable.
Must be a valid record in the Bank file.
If left blank, the Bank Identification
defaults.
CBC-ACTIVE-STATUS Alpha 1 CB00.2
Status The status of the of the bank account.
If the bank account is Inactive, new
bank transactions cannot be entered for
the bank account, but bank transactions
already entered in the system can be
processed and reconciled. Valid values
are:
A = Active.
I = Inactive.
CBC-REC-BALANCE Signed 15.2 AP170 AP180
Reconciled Balance The current reconciled balance of the AP181 AP190
bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB00.2 CB06.2
CB10.1 CB15.1
CB15.2 CB180
CB185 CB190
CB191 CB20.1
CB25.1 CB30.1
CB500 CB80.1
CB99.1 DT180
DT181 DT185
DT92.1
CBC-OPEN-BALANCE Signed 15.2 AP170 AP180
Open Balance The current outstanding, or AP181 AP190
unreconciled, balance of the bank AP255 AP265
account. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB00.2 CB06.2
CB10.1 CB15.1
CB15.2 CB180
CB185 CB190
CB191 CB20.1
CB25.1 CB30.1
CB500 CB80.1
CB99.1 DT180
DT181 DT185
DT92.1
CBC-AP-DRAFTS Signed 15.2 CB00.2
AP Bill of Exchange Represents the amount of bills of
Future Amt exchange that are scheduled to be
honored against this bank account.
THIS FIELD IS NOT USED AT THIS TIME.
CBC-AR-DRAFTS Signed 15.2 CB00.2
AR Bill of Exchange The amount of bills of exchange that
Future Amt will be cashed against the bank account
in the future.
THIS FIELD IS NOT USED AT THIS TIME.
CBC-USED-FLAG Alpha 1 AP00.3 AP00.4
Used Indicates whether the cash code has AP00.5 AP01.1
been used. Valid values are: AP10.1 AP10.2
AP10.5 AP10.6
Y = Yes. AP110 AP115
N = No. AP125 AP126
AP150 AP151
AP155 AP156
AP160 AP161
AP166 AP167
AP170 AP180
AP181 AP190
AP195 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP200
AP23.1 AP230
AP25.1 AP25.2
AP250 AP255
AP26.1 AP265
AP266 AP27.1
AP270 AP28.1
AP28.2 AP30.3
AP510 AP520
AP55.1 AP55.2
AP56.1 AP56.2
AP80.1 AP80.2
AP81.1 AP90.5
AP91.1 API1.1
...
CBC-CURR-ND Numeric 1 CB00.2
Currency Number of The number of decimal places defined
Decimals for the bank account currency.
CBC-ROI-RATE Signed 5.3 CB00.2
Return on The return on investment rate granted
Investment Rate by the bank. For example, the interest
rate.
CBC-SERIAL-NUM Numeric 8 CB00.2
Payment Run Serial The serial number of the last payment
Number tape created for the bank.
CBC-USER-CLASS Alpha 12 CB00.2
User Class The user class assigned to the cash
code. Used to restrict access and use of
the cash code to a specific group of
users. If left blank, no access
restrictions apply.
CBC-RECON-STMT-REQ Alpha 1 CB00.2
Reconciliation Indicates whether statements must be
Statement Req reconciled for the cash code. Valid
values are:
N = No. Default.
Y = Yes.
CBC-RECON-JRNL-BK Alpha 12
Reconciliation The reconciliation journal book
Journal Book associated with the cash code. Used only
if the Reconciliation Statement Required
field = Yes.
CBC-NET-BALANCE Derived
Net Balance The Reconciled Balance plus the Open
Balance for the bank account.
CBC-RECON-STMT-NBR Numeric 12 CB00.2 CB06.1
Reconciliation The bank-assigned reconciliation
Statement statement number. Used only for cash
codes that require reconciliation
statements.
CBC-LAST-END-BAL Signed 15.2 CB00.2 CB191
Last End Bal
CBC-SGLSTMT-USR-FL Alpha 1 CB00.2
Sglstmt Usr Fl
CBC-DESCRIPTION Alpha 30 (Lower Case)
Description This field contains the description used
in the GoFinancials product.
CBCASHCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBCSET1 CASH-CODE This index is used to validate a cash AP00.3 AP00.4
code. AP00.5 AP01.1
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP150 AP151
AP155 AP156
AP160 AP161
AP166 AP167
AP170 AP180
AP181 AP190
AP195 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
...
CBCSET2 BANK-ENTITY This index is used to access a cash CB00.2
CASH-CODE code for a specific bank.
KeyChange
CBCSET3 BANK-ENTITY This index is used to access a cash CB00.2 CB185
BANK-ACCT-NBR code record when bank identification and
CASH-CODE account number are provided.
KeyChange
CBCASHCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY -> CBE-BANK-ENTITY
Cbcashcode CBCASHCODE Required
CBC-CASH-CODE -> CBC-CASH-CODE
Cbsend Bankent CBBANKENT Required
CBC-SEND-BANK-ENT -> CBE-BANK-ENTITY
Cucodes CUCODES Required
CBC-CURRENCY-CODE -> CUC-CURRENCY-CODE
CBCASHCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbadjust CBADJUST
CBC-CASH-CODE -> CBJ-CASH-CODE
CBJ-REC-STATUS
CBJ-BANK-INST-CODE
CBJ-TRANS-NBR
CBJ-SUFFIX
CBJ-TRANS-IDENT
Cbadjust Unrel CBADJUST
CBC-CASH-CODE -> CBJ-CASH-CODE
Zeroes -> CBJ-REC-STATUS
CBJ-BANK-INST-CODE
CBJ-TRANS-NBR
CBJ-SUFFIX
CBJ-TRANS-IDENT
Cbbalance CBBALANCE Delete Restricted
CBC-CASH-CODE -> CBB-CASH-CODE
CBB-PER-END-DATE
Cbcashform CBCASHFORM
CBC-CASH-CODE -> CCF-CASH-CODE
CCF-BANK-INST-CODE
Cbcheck CBCHECK
CBC-CASH-CODE -> CHK-CASH-CODE
CHK-BANK-INST-CODE
CHK-TRANS-IDENT
Cbcpycash CBCPYCASH
CBC-CASH-CODE -> CBY-CASH-CODE
CBY-COMPANY
Cbgrpcc CBGRPCC
CBC-CASH-CODE -> CCD-CASH-CODE
CCD-CASH-CODE-GRP
Cbtrans CBTRANS
CBC-CASH-CODE -> CBT-CASH-CODE
CBT-BANK-INST-CODE
CBT-TRANS-NBR
CBT-SUFFIX
CBT-TRANS-IDENT
Cbtrans Date CBTRANS
CBC-CASH-CODE -> CBT-CASH-CODE
CBT-ISSUE-DATE
CBT-BANK-INST-CODE
CBT-SOURCE-CODE
CBT-TRANS-NBR
CBT-SUFFIX
CBT-TRANS-IDENT
Cbtrfhdr CBTRFHDR
CBC-CASH-CODE -> CBH-CASH-CODE
CBH-TRANSFER-NBR
Recpthdr Unrel CBRECPTHDR
CBC-CASH-CODE -> CBP-CASH-CODE
CBP-BANK-INST-CODE
CBP-TRANS-NBR
Trfhdr Unrel CBTRFHDR
CBC-CASH-CODE -> CBH-CASH-CODE
CBH-TRANSFER-NBR
Unrel Trfhdr CBTRFHDR
CBC-CASH-CODE -> CBH-CASH-CODE
CBH-TRANSFER-NBR
|