CBCPYCASH – Company-Cash Code Relationship

System: Cash Ledger (CB)
Prefix: CBY
Primary key: COMPANY, CASH-CODE
Fields: 53
Updated by: 94 programs
Referenced by: 26 programs

CBCPYCASH is the Company-Cash Code Relationship table in Lawson Cash Ledger (prefix CBY). It is indexed by COMPANY, CASH-CODE (CBYSET1); alternate indexes: CBYSET2 and CBYSET3. It is related 1:1 to CBBANKENT, CBCASHCODE and GLSYSTEM and 1:M to CBCPCSAUD, CBMXCONV, CBMXVALUE and MXLISTMBR. It is updated by AP00.4, AP00.5, AP01.1, AP101, AP125, AP126, AP150, AP151 and 86 more and referenced by AP155, AP160, AP161, CB01.1, CB01.4, CB01.5, CB01.6, CB01.7 and 18 more. The table has 53 fields, 3 indexes and 11 documented relations.

About CBCPYCASH

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

Fields (53)

Column = COBOL field name without the CBY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CBY-COMPANY` PK COMPANY	Numeric 4	The company number. Must be a valid record in the General Ledger Company file.	CB00.3
`CBY-CASH-CODE` PK 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` CSH_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` CSH_ACCT_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` CSH_ACCOUNT	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` CSH_SUB_ACCT	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` CLR_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` CLR_ACCOUNT	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` CLR_SUB_ACCT	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` REC_OVER_TOL	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` REC_UNDER_TOL	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` VAR_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` VAR_ACCT_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` VAR_ACCOUNT	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` VAR_SUB_ACCT	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` REC_GL_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` REC_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` REC_ACCT_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` REC_ACCOUNT	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` REC_SUB_ACCT	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` ENCS_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` ENCS_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` ENCS_SUB_ACCT	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` DISC_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` DISC_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` DISC_SUB_ACCT	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` RISK_ACCT_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` RISK_ACCOUNT	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` RISK_SUB_ACCT	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` BEXP_ACCT_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` BEXP_ACCOUNT	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` BEXP_SUB_ACCT	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` FIN_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` FIN_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` FIN_SUB_ACCT	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` ADMN_ACCT_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` ADMN_ACCOUNT	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` ADMN_SUB_ACCT	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` 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 +52 more (list truncated in source)
`CBY-SEL-BANK-NAME` SEL_BANK_NAME	Derived	The name of the bank associated with the cash code.	—
`CBY-SEL-BANK-ACCT` SEL_BANK_ACCT	Derived	The bank account number defined for the cash code.	—
`CBY-RECON-JRNL-BK` RECON_JRNL_BK	Alpha 12	The journal book assigned to the transaction.	CB00.3
`CBY-DEP-INST-CODE` DEP_INST_CODE	Alpha 3	—	CB00.3
`CBY-CHK-INST-CODE` CHK_INST_CODE	Alpha 3	—	CB00.3
`CBY-BANK-INST-CODE` BANK_INST_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` RECN_INST_CODE	Alpha 3	—	CB00.3
`CBY-OBJ-ID` 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` PMT_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` PMT_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` PMT_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` EFT_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` EFT_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` EFT_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

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CBYSET1`	`COMPANY`, `CASH-CODE`	Primary		AP00.4, AP00.5, AP01.1, AP101, AP125, AP126, AP150, AP151 +22 more (list truncated in source)
`CBYSET2`	`CASH-CODE`, `COMPANY`			CB00.2, CB01.5, CB222, CBBC.1, CBOP.1
`CBYSET3`	`OBJ-ID`	Subset	Where OBJ-ID != Zeroes	AP150, AP155, AP160, AP161, AP265, ZA161, CB01.6, CB01.7 +16 more

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
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`

One to many (5) — child tables

Relation	Table	Rules	Field map
Cbcpcsaud	CBCPCSAUD		`CBY-COMPANY` → `CCC-COMPANY`, `CBY-CASH-CODE` → `CCC-CASH-CODE`, → `CCC-UNIQUE-I-D`
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`

Programs

Updated by (94)

AP00.4 Company
AP00.5 Process Level
AP01.1 Pay Group
AP101 Pay Group Update
AP125 Batch Release
AP126 Mass Invoice Release
AP150 Cash Requirements
AP151 Bill of Exchange Generation
AP156 Bill of Exchange Creation
AP170 Payment Closing
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP190 Invoice Reinstatement
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.6 Prepayment
AP20.7 Distributions
AP20.8 Payment Schedule
AP200 Vendor Group, Company Listing
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP255 Bank Account Payment History
AP26.1 Invoice Release
AP265 Cash Payment Register
AP27.1 Single Invoice Release
AP28.1 Bill of Exchange Acceptance by Vendor
AP28.2 Bill of Exchange Acceptance by Date
AP30.3 Payment Schedule Adjustment
AP520 Invoice Interface
AP55.1 Cash Payment Entry
AP55.2 Cash Payment Invoice Application
AP56.1 Bill of Exchange Entry
AP56.2 Bill of Exchange Invoice Application
AP80.1 Bill of Exchange Cashing Selection
AP81.1 Manual Forms Reservation
AP90.5 Cash Payment Inquiry
API1.1 Add Invoice
API2.1 Add Invoice
AR01.1 Company
AR02.1 Process Level
AR14.1 Lockbox
CB00.2 Cash Code
CB00.3 Company Cash Code Relationships
CB06.1 Bank Statement
CB06.2 Bank Statement Detail Entry
CB10.1 Cash Receipt Deposit
CB145 EFT Extract Update
CB15.1 Bank Fund Transfer - Multiple Deposits
CB15.2 Bank Fund Transfer - Multiple Withdrawals
CB150 Mass Release
CB175 Bank Transaction Posting
CB180 Cash Ledger Void Update
CB185 Bank Tape Mass Reconciliation
CB186 Stale Dating Processing
CB187 Stale Dating Reopen Update
CB190 Bank Period Close
CB191 Bank Statement Close
CB20.1 Bank Transaction Entry
CB20.6 Bank Transaction DIstribution
CB222 Cash Position Reconciliation
CB25.1 Manual Reconciliation Entry
CB30.1 Reconciliation Variance Adjustment
CB43.1 Receipts Load Maintenance
CB44.1 Returned Payment Maintenance
CB45.1 EFT/CC Extract Entry
CB46.1 Returned Payment Entry
CB50.1 Bank Transaction Interface Maintenance
CB500 Bank Transaction Interface
CB54.1 Payment Load Maintenance
CB543 Receipts Load
CB544 Returned Payment Load
CB55.1 Payment Entry
CB554 Payment Load
CB80.1 Bank Transaction Adjustment
CB82.1 Statement Reconciliation
EE20.1 Employee Advance
EE20.2 Employee Expense
EE20.4 Employee Payback
EE520 Expense Interface
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA61.1 Match Invoice Approval
MAI1.1 Invoke for MAMATCH Object

Referenced by (26)

AP155 Payment Forms Creation
AP160 Payment Tape Creation
AP161 Electronic Payment File Creation
CB01.1 Credit Risk
CB01.4 Attributes
CB01.5 Values by Attribute
CB01.6 Manual Cash Code List
CB01.7 Cash Code List Members
CB07.1 Stale Dating Accounts
CB162 Cash Code Attribute Interface
CB170 Positive Pay File Creation
CB195 Company Period Close
CB210 Cash Receipt Deposit Listing
CB215 Bank Transfer Listing
CB220 Bank History Report
CB221 Bank Transaction Listing
CB260 Cash Account Activity
CB286 Stale Dating and Escheatment Report
CB62.1 Cash Code Attribute Interface Maintenance
CB90.2 Currency Analysis
CBBC.1 Olap Dimension Retrieval Format
CBOP.1 Cash Ledger OLAP Data Build
MX123 List Member Build
MX223 List Member Listing
MX500 Attribute Value Population
ZA161 Electronic Payment File Creation