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 AP520 AR01.1 AR02.1 AR29.2 AR700 AR980 CB05.1 CB733 UPDATED BY AP00.3 AP00.4 AP00.7 AP01.1 AP10.1 AP10.2 AP10.5 AP10.6 AP110 AP125 AP126 AP150 AP151 AP155 AP156 AP157 AP160 AP161 AP166 AP167 AP170 AP180 AP181 AP190 AP195 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP200 AP23.1 AP230 AP25.1 AP25.2 AP250 AP255 AP26.1 AP265 AP266 AP270 AP28.1 AP28.2 AP30.3 AP510 AP55.1 AP55.2 AP56.1 AP56.2 AP80.1 AP80.2 AP81.1 AP90.5 AP91.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 CB950 CB951 CB980 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 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY CBC-CASH-CODE Alpha 4 CB00.2 CB950 Cash Code A user-defined code representing a bank CB99.1 account at a bank location. CBC-BANK-ACCT-NBR Alpha 17 CB00.2 CB950 Bank Account Number The bank-assigned account number identification to be used for the cash code. CBC-CURRENCY-CODE Alpha 5 CB00.2 CB950 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 CB950 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 CB950 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 CB950 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 CB30.1 CB500 CB80.1 CB950 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 CB30.1 CB500 CB80.1 CB950 CB99.1 DT180 DT181 DT185 DT92.1 CBC-AP-DRAFTS Signed 15.2 CB00.2 CB950 AP Bill of Exchange Represents the amount of bills of Future Amt exchange that are scheduled to be honored against this bank account. CBC-AR-DRAFTS Signed 15.2 CB00.2 CB950 AR Bill of Exchange The amount of bills of exchange that Future Amt will be cashed against the bank account in the future. CBC-USED-FLAG Alpha 1 AP00.3 AP00.4 Used Indicates whether the cash code has AP00.7 AP01.1 been used. Valid values are: AP10.1 AP10.2 AP10.5 AP10.6 Y = Yes. AP110 AP125 N = No. AP126 AP150 AP151 AP155 AP156 AP157 AP160 AP161 AP166 AP167 AP170 AP180 AP181 AP190 AP195 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP200 AP23.1 AP230 AP25.1 AP25.2 AP250 AP255 AP26.1 AP265 AP266 AP270 AP28.1 AP28.2 AP30.3 AP510 AP55.1 AP55.2 AP56.1 AP56.2 AP80.1 AP80.2 AP81.1 AP90.5 AP91.1 AR115 AR124 AR14.1 AR20.1 AR21.1 ... CBC-CURR-ND Numeric 1 CB00.2 CB950 Currency Number of The number of decimal places defined Decimals for the bank account currency. CBC-ROI-RATE Signed 5.3 CB00.2 CB950 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 CB950 Payment Run Serial The serial number of the last payment Number tape created for the bank. CBC-USER-CLASS Alpha 12 CB00.2 CB950 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 CB950 Reconciliation Indicates whether statements must be Statement Req reconciled for the cash code. Valid values are: N = No. Default. Y = 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 last bank-assigned reconciliation CB950 Statement Nbr statement number. Used only for cash codes that require reconciliation statements. CBC-LAST-END-BAL Signed 15.2 CB00.2 CB191 Last Ending Balance The last ending balance for the cash CB950 code. CBC-SGLSTMT-USR-FL Alpha 1 CB00.2 CB950 Single Statement Single statement user flag. Determines User Flag if you can have only one statement open at a time. N = No Y = Yes CBC-DESCRIPTION Alpha 30 (Lower Case) Description This field contains the description. 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.7 AP01.1 AP10.1 AP10.2 AP10.5 AP10.6 AP110 AP125 AP126 AP150 AP151 AP155 AP156 AP157 AP160 AP161 AP166 AP167 AP170 AP180 AP181 AP190 AP195 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 ... 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 account number are provided. KeyChange, Duplicates 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 Cbadjust Unrel CBADJUST CBC-CASH-CODE -> CBJ-CASH-CODE Zeroes -> CBJ-REC-STATUS CBJ-BANK-INST-CODE CBJ-TRANS-NBR CBJ-SUFFIX 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 Cbtrans CBTRANS CBC-CASH-CODE -> CBT-CASH-CODE CBT-BANK-INST-CODE CBT-TRANS-NBR CBT-SUFFIX 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 |