CBCPYCASH

Company-Cash Code Relationship

The Company-Cash Code Relationship file contains relationship records between a general ledger company and a cash code (bank account).

REFERENCED BY
CB162 CB195 CB62.1 MX223


UPDATED BY
AP00.4 AP00.5 AP01.1 AP101 AP125 AP126
AP150 AP151 AP156 AP170 AP180 AP181
AP190 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP20.8 AP200 AP21.1 AP23.1
AP25.1 AP25.2 AP255 AP26.1 AP265 AP27.1
AP28.1 AP28.2 AP30.3 AP520 AP55.1 AP55.2
AP56.1 AP56.2 AP80.1 AP81.1 AP90.5 API1.1
API2.1 AR01.1 AR02.1 AR14.1 CB00.2 CB00.3
CB06.1 CB06.2 CB10.1 CB145 CB15.1 CB15.2
CB150 CB175 CB180 CB185 CB186 CB187
CB190 CB191 CB20.1 CB20.6 CB222 CB25.1
CB30.1 CB43.1 CB44.1 CB45.1 CB46.1 CB50.1
CB500 CB54.1 CB543 CB544 CB55.1 CB554
CB80.1 CB82.1 EE20.1 EE20.2 EE20.4 EE520
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MAI1.1 AP155 AP160
AP161 CB01.5 CB01.7 CB170 CB210 CB215
CB220 CB221 CB260 CB286 CB90.2 MX123
MX500 CBBC.1 CBOP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBY-COMPANY
Element: Company
Numeric 4
The company number. Must be a valid record in the General Ledger Company file.
CB00.3
CBY-CASH-CODE
Element: Cash Code
Alpha 4
The cash code. Represents a bank account. Must be a valid record in the Cash Code file.
CB00.3
CBY-CSH-COMPANY
Element: Cash Company
Numeric 4
The general ledger company a cash transaction will be made against. THIS FIELD IS NOT USED AT THIS TIME.
CB00.3
CBY-CSH-ACCT-UNIT
GL Cash Accounting
Unit
Alpha 15
The general ledger cash accounting unit for the company-cash code relationship. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-CSH-ACCOUNT
GL Cash Account
Number
Numeric 6
The general ledger cash account number for the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-CSH-SUB-ACCT
GL Cash Subaccount
Number
Numeric 4
The general ledger cash subaccount number for the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-CLR-ACCT-UNIT
Transfer Clearing
Acct Unit
Alpha 15
The general ledger bank transfer clearing accounting unit used for bank fund transfers to or from the company-cash code relationship. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-CLR-ACCOUNT
Transfer Clearing
Account Nbr
Numeric 6
The general ledger bank transfer clearing account number used for bank fund transfers to or from the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-CLR-SUB-ACCT
Transfer Clearing
Subacct Nbr
Numeric 4
The general ledger bank transfer clearing subaccount number used for bank fund transfers to or from the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-REC-OVER-TOL
Over Reconcile
Tolerance
Signed 18.2
Indicates by what amount, if any, the reconciled amount can exceed the issued amount of a transaction. If defined and the reconciled amount exceeds the issued amount within the defined tolerance, the difference is posted to the GL Variance Account selected for the company-cash code relationship. If the difference exceeds the defined tolerance, the reconciliation must be approved in CB30.1 (Reconciliation Variance Adjustment). If left blank, zero defaults, which means the reconciled amount must equal the issued amount.
CB00.3
CBY-REC-UNDER-TOL
Under Reconcile
Tolerance
Signed 18.2
Indicates by what amount, if any, the reconciled amount can be less than the issued amount of a transaction. If defined and the reconciled amount is less than the issued amount within the defined tolerance, the difference is posted to the GL Variance Account selected for the company-cash code relationship. If the difference exceeds the defined tolerance, the reconciliation must be approved in CB30.1 (Reconciliation Variance Adjustment). If left blank, zero defaults, which means the reconciled amount must equal the issued amount.
CB00.3
CBY-VAR-COMPANY
Element: GL Variance Company
Numeric 4
The general ledger company a reconciliation variance transaction will be made against. THIS FIELD IS NOT USED AT THIS TIME.
CB00.3
CBY-VAR-ACCT-UNIT
GL Variance
Accounting Unit
Alpha 15
The general ledger variance accounting unit for the company-cash code relationship. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-VAR-ACCOUNT
GL Variance Account
Number
Numeric 6
The general ledger variance account number for the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-VAR-SUB-ACCT
GL Variance
Subaccount Number
Numeric 4
The general ledger variance subaccount number for the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-REC-GL-ENTRY
Element: GL Reconcile Entry
Alpha 1
Indicates whether a general ledger entry is created from the GL Cash Account to a GL Reconcile Account when the company reconciles a transaction for the cash code. If this field = Yes, a general ledger entry is created from the GL Cash Account to the GL Reconcile Account. The difference between the reconciled amount and the issued amount, within the defined tolerances, posts to the GL Variance Account. Valid values are: N = No. Y = Yes.
CB00.3
CBY-REC-COMPANY
Element: Reconcile Company
Numeric 4
The general ledger company a reconciled transaction will be made against. THIS FIELD IS NOT USED AT THIS TIME.
CB00.3
CBY-REC-ACCT-UNIT
GL Reconcile
Accounting Unit
Alpha 15
If the GL Reconcile Entry field = Yes, this field contains the general ledger reconcile accounting unit for the company-cash code relationship. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-REC-ACCOUNT
GL Reconcile
Account Number
Numeric 6
If the GL Reconcile Entry field = Yes, this field contains the general ledger reconcile account number for the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-REC-SUB-ACCT
GL Reconcile
Subaccount Number
Numeric 4
If the GL Reconcile Entry field = Yes, this field contains the general ledger reconcile subaccount number for the company-cash code relationship. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-ENCS-ACCT-UNIT
Encashed Remittance
Acct Unit
Alpha 15
The general ledger encashed remittance accounting unit used for bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-ENCS-ACCOUNT
Encashed Remittance
Account
Numeric 6
The general ledger encashed remittance account number used for bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-ENCS-SUB-ACCT
Encashed Remittance
Subaccount
Numeric 4
The general ledger encashed remittance subaccount number used for bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-DISC-ACCT-UNIT
Discounted Remit
Acct Unit
Alpha 15
The general ledger discounted remittance accounting unit used for bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-DISC-ACCOUNT
Discounted
Remittance Account
Numeric 6
The general ledger discounted remittance account number used for bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-DISC-SUB-ACCT
Discounted
Remittance Subacct
Numeric 4
The general ledger discounted remittance subaccount number used for bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-RISK-ACCT-UNIT
Bank Risk
Accounting Unit
Alpha 15
The general ledger bank risk accounting unit used for discounted bill of exchange risk processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-RISK-ACCOUNT
Bank Risk Account
Number
Numeric 6
The general ledger bank risk account number used for discounted bill of exchange risk processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-RISK-SUB-ACCT
Bank Risk
Subaccount Number
Numeric 4
The general ledger bank risk subaccount number used for discounted bill of exchange risk processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-BEXP-ACCT-UNIT
Bank Expense
Accounting Unit
Alpha 15
The general ledger bank expense accounting unit used for bill of exchange cashing expenses. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-BEXP-ACCOUNT
Bank Expense
Account Number
Numeric 6
The general ledger bank expense account number used for bill of exchange cashing expenses. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-BEXP-SUB-ACCT
Bank Expense
Subaccount Number
Numeric 4
The general ledger bank expense subaccount number used for bill of exchange cashing expenses. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-FIN-ACCT-UNIT
Financial Expense
Acct Unit
Alpha 15
The general ledger financial expense accounting unit used for financial expenses associated with bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Names file. THIS FIELD IS NOT CURRENTLY USED.
CB00.3
CBY-FIN-ACCOUNT
Financial Expense
Account
Numeric 6
The general ledger financial expense account number used for financial expenses associated with bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file. THIS FIELD IS NOT CURRENTLY USED.
CB00.3
CBY-FIN-SUB-ACCT
Financial Expense
Subaccount
Numeric 4
The general ledger financial expense subaccount number used for financial expenses associated with bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file. THIS FIELD IS NOT CURRENTLY USED.
CB00.3
CBY-ADMN-ACCT-UNIT
Admin Expense
Accounting Unit
Alpha 15
The general ledger administration expense accounting unit used for administration expenses associated with bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Names file.
CB00.3
CBY-ADMN-ACCOUNT
Admin Expense
Account Number
Numeric 6
The general ledger administration expense account number used for administration expenses associated with bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-ADMN-SUB-ACCT
Admin Expense
Subaccount
Numeric 4
The general ledger administration expense subaccount number used for administration expenses associated with bill of exchange processing. Required if company uses the cash code to process bills of exchange. Must be a valid record in the General Ledger Account Master file.
CB00.3
CBY-USED-FLAG
Element: Used Flag
Alpha 1
Indicates whether the company-cash code relationship has been used. Valid values are: N = No. Y = Yes.
...
AP00.4 AP00.5
AP01.1 AP101
AP125 AP126
AP150 AP151
AP156 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP200
AP21.1 AP23.1
AP25.1 AP25.2
AP255 AP26.1
AP265 AP27.1
AP28.1 AP28.2
AP30.3 AP520
AP55.1 AP55.2
AP56.1 AP56.2
AP80.1 AP81.1
AP90.5 API1.1
API2.1 AR01.1
AR02.1 AR14.1
CB00.3 CB06.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CBY-SEL-BANK-NAME
Element: Bank Name
Derived
The name of the bank associated with the cash code.
CBY-SEL-BANK-ACCT
Element: Bank Account Number
Derived
The bank account number defined for the cash code.
CBY-RECON-JRNL-BK
Reconcile Journal
Book
Alpha 12
The journal book assigned to the transaction.
CB00.3
CBY-DEP-INST-CODE
Customer Bank
Instrument Code
Alpha 3
CB00.3
CBY-CHK-INST-CODE
Vendor Bank
Instrument Code
Alpha 3
CB00.3
CBY-BANK-INST-CODE
GL Bank Instrument
Code
Alpha 3
A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.
CB00.3
CBY-RECN-INST-CODE
Reconcile Bank
Instrument Code
Alpha 3
CB00.3
CBY-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
CB00.3
CBY-PMT-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
CB00.3
CBY-PMT-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
CB00.3
CBY-PMT-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
CB00.3
CBY-EFT-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
CB00.3
CBY-EFT-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
CB00.3
CBY-EFT-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
CB00.3


CBCPYCASH FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBYSET1 COMPANY
CASH-CODE
...
AP00.4 AP00.5
AP01.1 AP101
AP125 AP126
AP150 AP151
AP155 AP156
AP160 AP161
AP170 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP200 AP21.1
AP23.1 AP25.1
AP25.2 AP255
CBYSET2 CASH-CODE
COMPANY
CB00.2 CB01.5
CB222 CBBC.1
CBOP.1
CBYSET3 OBJ-ID
Subset
WhereOBJ-ID !=Zeroes
AP150 AP155
AP160 AP161
AP265 CB01.6
CB01.7 CB145
CB170 CB175
CB180 CB186
CB187 CB210
CB215 CB220
CB221 CB222
CB260 CB286
MX123 MX223
MX500


CBCPYCASH 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
CBY-CASH-CODE->CBC-CASH-CODE
Glsystem GLSYSTEM Required
CBY-COMPANY->GLS-COMPANY
Glsystem Cash GLSYSTEM Required
CBY-CSH-COMPANY->GLS-COMPANY
Glsystem Recon GLSYSTEM Required
CBY-REC-COMPANY->GLS-COMPANY
Glsystem Var GLSYSTEM Required
CBY-VAR-COMPANY->GLS-COMPANY


CBCPYCASH FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbmxconv CBMXCONV
CBY-COMPANY->CBN-COMPANY
CBY-CASH-CODE->CBN-CASH-CODE
  CBN-RUN-GROUP
  CBN-MATRIX-CAT
Cbmxvalue CBMXVALUE Delete Cascades
CBY-OBJ-ID->CMV-OBJ-ID
  CMV-MATRIX-CAT
Member In List MXLISTMBR Delete Cascades
"CSHCD"->MLM-OBJ-TYPE
CBY-OBJ-ID->MLM-OBJ-ID
  MLM-MATRIX-LIST
Mxlistmbr MXLISTMBR
"CSHCD"->MLM-OBJ-TYPE
CBY-OBJ-ID->MLM-OBJ-ID
  MLM-MATRIX-LIST


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

Home
Contact Us



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