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
AP155 | AP160 | AP161 | ZA161 | CB01.1 | CB01.4 |
CB01.5 | CB01.6 | CB01.7 | CB07.1 | CB162 | CB170 |
CB195 | CB210 | CB215 | CB220 | CB221 | CB260 |
CB286 | CB62.1 | CB90.2 | MX123 | MX500 | CBBC.1 |
CBOP.1 | MX223 |
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|||
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. |
|
||
CBY-DEP-INST-CODE Customer Bank Instrument Code | Alpha 3 |
|
||
CBY-CHK-INST-CODE Vendor Bank Instrument Code | Alpha 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. |
|
||
CBY-RECN-INST-CODE Reconcile Bank Instrument Code | Alpha 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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CBYSET1 |
COMPANY CASH-CODE |
|
| ||||||||||||||||||||||||||||||||||||
CBYSET2 |
CASH-CODE COMPANY |
|
| ||||||||||||||||||||||||||||||||||||
CBYSET3 |
OBJ-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Cbbankent | CBBANKENT |
Required
| |||
Cbcashcode | CBCASHCODE |
Required
| |||
Glsystem | GLSYSTEM |
Required
| |||
Glsystem Cash | GLSYSTEM |
Required
| |||
Glsystem Recon | GLSYSTEM |
Required
| |||
Glsystem Var | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cbcpcsaud | CBCPCSAUD |
| ||||||||||||
Cbmxconv | CBMXCONV |
| ||||||||||||
Cbmxvalue | CBMXVALUE |
Delete Cascades
| ||||||||||||
Member In List | MXLISTMBR |
Delete Cascades
| ||||||||||||
Mxlistmbr | MXLISTMBR |
|
All trademarks and registered trademarks are the property of their
respective owners.