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 CB181 CB211 CBBC.1 CBOP.1
UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP00.3
AP00.4 AP00.5 AP01.1 AP03.3 AP10.1 AP10.2
AP10.5 AP10.6 AP110 AP115 AP125 AP126
AP131 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 AP21.1
AP210 AP220 AP23.1 AP230 AP25.1 AP25.2
AP250 AP255 AP26.1 AP265 AP266 AP27.1
AP270 AP28.1 AP28.2 AP30.2 AP30.3 AP30.4
AP305 AP510 AP520 AP55.1 AP55.2 AP56.1
AP56.2 AP80.1 AP80.2 AP81.1 AP90.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 AR32.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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
CB00.2 CB00.3 CB00.5 CB02.1 CB06.1 CB06.2
CB10.1 CB10.3 CB145 CB15.1 CB15.2 CB150
CB170 CB175 CB180 CB185 CB186 CB187
CB190 CB191 CB195 CB20.1 CB210 CB215
CB220 CB221 CB245 CB246 CB25.1 CB255
CB260 CB281 CB286 CB30.1 CB300 CB43.1
CB44.1 CB45.1 CB46.1 CB50.1 CB500 CB54.1
CB543 CB544 CB55.1 CB554 CB56.1 CB80.1
CB81.1 CB82.1 CB90.1 CB90.2 CB90.3 CB90.4
CB90.6 CB90.7 CB90.8 CB99.1 CB99.3 CB99.4
CB99.5 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
ET09.2 ET09.3 MX123 MX500 MA180 MA279
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD235
PO10.1 PO100 PO101 PO120 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO220 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO27.2 PO278 PO29.1 PO30.1 PO30.2 PO30.3
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 PO536
PO54.1 PO54.2 PO54.3 PO54.4 POI3.1 POID.1
POII.1 POIJ.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 RQ10.1 RQ10.2
WH20.2 WH20.7
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
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB00.2 CB06.2
CB10.1 CB145
CB15.1 CB15.2
CB150 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.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
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB00.2 CB06.2
CB10.1 CB145
CB15.1 CB15.2
CB150 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CB99.1 DT180
DT181 DT185
DT92.1
CBC-AP-DRAFTS Signed 18.2 CB00.2
AP Bill of Exchange
Future Amt
CBC-AR-DRAFTS Signed 18.2 CB00.2
AR Bill of Exchange
Future Amt
CBC-USED-FLAG Alpha 1 AC160 AM115
Element: Used Flag Indicates whether the cash code has AM117 AM15.1
been used. Valid values are: AM15.2 AM15.3
AM15.4 AM19.1
Y = Yes. AM19.2 AM20.1
N = No. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP00.5
AP01.1 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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 AP21.1
AP210 AP220
AP23.1 AP230
AP25.1 AP25.2
...
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 Y = Yes
Required 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
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.
CBC-CBO-BAL-FLAG Alpha 1 CB00.2
Element: All Flag
CBCASHCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBCSET1 CASH-CODE AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP00.5
AP01.1 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
...
CBCSET2 BANK-ENTITY KeyChange CB00.2
CASH-CODE
CBCSET3 BANK-ENTITY KeyChange CB00.2 CB185
BANK-ACCT-NBR CB81.1 CB82.1
CASH-CODE
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
|