Lawson Insight Technical Documentation |
|
CBCASHCODE
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
AR02.1 AR29.2 CB01.4 CB01.5 CB01.6 CB01.7
CB05.1 CB11.1 CB211
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 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 AP200 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 AR01.1 AR115 AR124 AR14.1
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR27.1
AR28.2 AR28.5 AR28.9 AR30.1 AR34.1 AR42.1
AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR48.2
AR502 AR560 AR570 AR575 AR580 AR82.1
AR97.6 ARLL.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 MA61.1 MAI1.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBC-CASH-CODE Alpha 4 CB00.2 CB99.1
Element: Cash Code A user-defined code representing a bank
account at a bank location.
CBC-BANK-ACCT-NBR Alpha 35 CB00.2
Element: Bank Account NThe bank-assigned account number
identification to be used for the cash
code.
CBC-BANK-IDENT Alpha 1 CB00.2
Element: Alphadata1
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
Element: Bank IdentificThe 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
Element: Active 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 18.2 AP170 AP180
Element: Reconciled BalThe 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
AR34.1 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 18.2 AP170 AP180
Element: 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
AR34.1 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 18.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 18.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 AM115 AM117
Element: Used Flag Indicates whether the cash code has AM15.1 AM15.2
been used. Valid values are: AM15.3 AM15.4
AM20.1 AM20.3
Y = Yes. AM21.1 AM21.3
N = No. AM500 AM51.1
AM551 AM97.1
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 AP200
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
...
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
Element: Serial Number The serial number of the last payment
tape created for the bank.
CBC-USER-CLASS Alpha 12 CB00.2
Element: 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
Reconcile Statement Indicates whether statements must be
Required 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
Element: Net Balance The Reconciled Balance plus the Open
Balance for the bank account.
CBC-RECON-STMT-NBR Numeric 12 CB00.2 CB06.1
Reconcile Statement The bank-assigned reconciliation
Number statement number. Used only for cash
codes that require reconciliation
statements.
CBC-LAST-END-BAL Signed 18.2 CB00.2 CB191
Element: Last End Balance
CBC-SGLSTMT-USR-FL Alpha 1 CB00.2
Single Statement
User Flag
CBC-DESCRIPTION Alpha 30 (Lower Case) CB00.2
Element: 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 AM115 AM117
code. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP00.5 AP01.1
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP150 AP151
AP155 AP156
...
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
CCF-PROC-GRP
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
|