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

CB195	MX223	CB01.4	CB01.5	CB01.6	CB01.7
CB162	CB210	CB62.1	CBBC.1	CBOP.1

UPDATED BY

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
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	ZA161	AR01.1
AR02.1	AR14.1	CB00.2	CB00.3	CB06.1	CB06.2
CB10.1	CB145	CB15.1	CB15.2	CB150	CB170
CB175	CB180	CB185	CB186	CB187	CB190
CB191	CB20.1	CB20.6	CB215	CB220	CB221
CB222	CB25.1	CB260	CB286	CB30.1	CB43.1
CB44.1	CB45.1	CB46.1	CB50.1	CB500	CB54.1
CB543	CB544	CB55.1	CB554	CB80.1	CB82.1
CB90.2	EE20.1	EE20.2	EE20.4	EE520	MX123
MX500	MA41.1	MA41.2	MA41.4	MA41.7	MA42.2
MA43.2	MA44.1	MA44.2	MA61.1	MAI1.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

CBCPYCASH FILE RELATIONS

ONE TO ONE RELATIONS

CBCPYCASH FILE RELATIONS

ONE TO MANY RELATIONS

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