CBCASHCODE

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
AP101 AR02.1 CB01.4 CB01.5 CB01.6 CB01.7
CB05.1 CB11.1 CB211 CBBC.1 CBOP.1


UPDATED BY
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 AR14.1
CB00.2 CB00.3 CB00.5 CB02.1 CB06.1 CB06.2
CB10.1 CB10.3 CB10.5 CB145 CB15.1 CB15.2
CB150 CB170 CB175 CB180 CB185 CB186
CB187 CB190 CB191 CB195 CB20.1 CB20.6
CB210 CB215 CB220 CB221 CB222 CB245
CB246 CB25.1 CB255 CB260 CB281 CB286
CB295 CB30.1 CB300 CB305 CB43.1 CB44.1
CB45.1 CB46.1 CB50.1 CB500 CB54.1 CB543
CB544 CB55.1 CB554 CB56.1 CB56.2 CB80.1
CB81.1 CB82.1 CB90.1 CB90.2 CB90.3 CB90.4
CB90.6 CB90.7 CB90.8 CB95.1 CB99.1 CB99.3
CB99.4 CB99.5 EE135 EE20.1 EE20.2 EE20.4
EE35.1 EE35.2 EE520 MX123 MX500 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PO10.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 CB181

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBC-CASH-CODE
Element: Cash Code
Alpha 4
A user-defined code representing a bank account at a bank location.
CB00.2 CB99.1
CBC-BANK-ACCT-NBR
Element: Bank Account Number
Alpha 35
The bank-assigned account number identification to be used for the cash code.
CB00.2
CBC-BANK-IDENT
Element: Alphadata1
Alpha 1
CB00.2
CBC-CURRENCY-CODE
Bank Account
Currency
Alpha 5
The currency of the bank account. Must be a valid record in the Currency Code file.
CB00.2
CBC-BANK-ENTITY
Element: Bank Identification
Alpha 15
The bank location where the bank account is located. Must be a valid record in the Bank file.
CB00.2
CBC-SEND-BANK-ENT
Electronic Transfer
Bank
Alpha 15
If the bank for the cash code does not 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.
CB00.2
CBC-ACTIVE-STATUS
Element: Active Status
Alpha 1
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.
CB00.2
CBC-REC-BALANCE
Element: Reconciled Balance
Signed 18.2
The current reconciled balance of the bank account.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB00.2 CB06.2
CB10.1 CB145
CB15.1 CB15.2
CB150 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.1
CBC-OPEN-BALANCE
Element: Open Balance
Signed 18.2
The current outstanding, or unreconciled, balance of the bank account.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB00.2 CB06.2
CB10.1 CB145
CB15.1 CB15.2
CB150 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.1
CBC-AP-DRAFTS
AP Bill of Exchange
Future Amt
Signed 18.2
CB00.2
CBC-AR-DRAFTS
AR Bill of Exchange
Future Amt
Signed 18.2
CB00.2
CBC-USED-FLAG
Element: Used Flag
Alpha 1
Indicates whether the cash code has been used. Valid values are: Y = Yes. N = No.
...
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
CBC-CURR-ND
Currency Number of
Decimals
Numeric 1
The number of decimal places defined for the bank account currency.
CB00.2
CBC-ROI-RATE
Return on
Investment Rate
Signed 5.3
The return on investment rate granted by the bank. For example, the interest rate.
CB00.2
CBC-SERIAL-NUM
Element: Serial Number
Numeric 8
The serial number of the last payment tape created for the bank.
CB00.2
CBC-USER-CLASS
Element: User Class
Alpha 12
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.
CB00.2
CBC-RECON-STMT-REQ
Reconcile Statement
Required
Alpha 1

Y = Yes
N = No
CB00.2
CBC-RECON-JRNL-BK
Reconciliation
Journal Book
Alpha 12
The reconciliation journal book associated with the cash code. Used only if the Reconciliation Statement Required field = Yes.
CBC-NET-BALANCE
Element: Net Balance
Derived
The Reconciled Balance plus the Open Balance for the bank account.
CBC-RECON-STMT-NBR
Reconcile Statement
Number
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
CB00.2 CB06.1
CBC-LAST-END-BAL
Element: Last End Balance
Signed 18.2
CB00.2 CB191
CBC-SGLSTMT-USR-FL
Single Statement
User Flag
Alpha 1
CB00.2
CBC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description used in the GoFinancials product.
CB00.2
CBC-CBO-BAL-FLAG
Element: All Flag
Alpha 1
CB00.2


CBCASHCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBCSET1 CASH-CODE
...
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 AP101
AP110 AP115
AP125 AP126
CBCSET2 BANK-ENTITY
CASH-CODE
KeyChange
CB00.2
CBCSET3 BANK-ENTITY
BANK-ACCT-NBR
CASH-CODE
KeyChange
CB00.2 CB185
CB81.1 CB82.1


CBCASHCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:48:21 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.