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
AR01.1 AR02.1 AR29.2 AR48.2 AR700 CB05.1
CB11.1 CB211
UPDATED BY
AM115 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 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 MA41.7 MA43.2 MA61.1 MAI1.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBC-CASH-CODE Alpha 4 CB00.2 CB99.1
Accounts Receivable A user-defined code representing a bank
Code account at a bank location.
CBC-BANK-ACCT-NBR Alpha 17 CB00.2
Element: Bank Account NThe 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
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: 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
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
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
Element: Current BalancThe 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
Future Amt
CBC-USED-FLAG Alpha 1 AM115 AM15.1
Element: Used Indicates whether the cash code has AM15.2 AM15.3
been used. Valid values are: AM15.4 AM20.1
AM20.3 AM21.1
Y = Yes. AM21.3 AM500
N = No. 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
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
...
CBC-CURR-ND Numeric 1 CB00.2
Account Currency The number of decimal places defined
Code 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
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
Element: All Flag Y = Yes
N = No
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
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
Element: Last End Bal
CBC-SGLSTMT-USR-FL Alpha 1 CB00.2
Element: Sglstmt Usr Fl
CBC-DESCRIPTION Alpha 30 (Lower Case)
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 AM15.1
code. 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
...
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
|