|
|
CBCPYCASH FILE
Company-Cash Code Relationship
The Company-Cash Code Relationship file contains relationship records between
a general ledger company and a cash code (bank account).
UPDATED BY
AP00.4 AP00.7 AP01.1 AP125 AP126 AP150
AP151 AP156 AP170 AP180 AP181 AP190
AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8
AP200 AP23.1 AP25.1 AP25.2 AP255 AP26.1
AP265 AP28.1 AP28.2 AP30.3 AP520 AP55.1
AP55.2 AP56.1 AP56.2 AP80.1 AP81.1 AP90.5
AR01.1 AR02.1 AR115 AR124 AR14.1 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR28.2 AR28.5
AR29.2 AR30.1 AR30.2 AR30.4 AR570 AR575
AR580 AR700 AR82.1 AR980 CB00.2 CB00.3
CB06.1 CB06.2 CB10.1 CB15.1 CB15.2 CB175
CB180 CB185 CB190 CB191 CB20.1 CB30.1
CB500 CB80.1 DT160 DT161 DT170 DT180
DT181 DT185 DT270 DT60.1 DT60.2 DT70.1
DT70.3 DT80.1 DT80.4 DT90.3 DT92.1 EE20.1
EE20.2 EE20.4 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
CBY-COMPANY Numeric 4 CB00.3
Company The company number. Must be a valid
record in the General Ledger Company
file.
CBY-CASH-CODE Alpha 4 CB00.3
Cash Code The cash code. Represents a bank
account. Must be a valid record in the
Cash Code file.
CBY-CSH-COMPANY Numeric 4 CB00.3
Cash Company The general ledger company a cash
transaction will be made against.
CBY-CSH-ACCT-UNIT Alpha 15 CB00.3
GL Cash Accounting The general ledger cash accounting unit
Unit for the company-cash code relationship.
Must be a valid record in the General
Ledger Names file.
CBY-CSH-ACCOUNT Numeric 6 CB00.3
GL Cash Account The general ledger cash account number
Number for the company-cash code relationship.
Must be a valid record in the General
Ledger Account Master file.
CBY-CSH-SUB-ACCT Numeric 4 CB00.3
GL Cash Subaccount The general ledger cash subaccount
Number number for the company-cash code
relationship. Must be a valid record in
the General Ledger Account Master file.
CBY-CLR-ACCT-UNIT Alpha 15 CB00.3
Transfer Clearing The general ledger bank transfer
Acct Unit 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 Numeric 6 CB00.3
Transfer Clearing The general ledger bank transfer
Account Nbr 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 Numeric 4 CB00.3
Transfer Clearing The general ledger bank transfer
Subacct Nbr 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 Signed 15.2 CB00.3
Over Reconcile Indicates by what amount, if any, the
Tolerance 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 Signed 15.2 CB00.3
Under Reconcile Indicates by what amount, if any, the
Tolerance 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 Numeric 4 CB00.3
Cost Variance The general ledger company a
Company reconciliation variance transaction will
be made against.
CBY-VAR-ACCT-UNIT Alpha 15 CB00.3
GL Variance The general ledger variance accounting
Accounting Unit unit for the company-cash code
relationship. Must be a valid record in
the General Ledger Names file.
CBY-VAR-ACCOUNT Numeric 6 CB00.3
GL Variance Account The general ledger variance account
Number number for the company-cash code
relationship. Must be a valid record in
the General Ledger Account Master file.
CBY-VAR-SUB-ACCT Numeric 4 CB00.3
GL Variance The general ledger variance subaccount
Subaccount Number number for the company-cash code
relationship. Must be a valid record in
the General Ledger Account Master file.
CBY-REC-GL-ENTRY Alpha 1 CB00.3
GL Reconcile Entry 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 Numeric 4 CB00.3
Reconcile Company The general ledger company a reconciled
transaction will be made against.
CBY-REC-ACCT-UNIT Alpha 15 CB00.3
GL Reconcile If the GL Reconcile Entry field = Yes,
Accounting Unit 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 Numeric 6 CB00.3
GL Reconcile If the GL Reconcile Entry field = Yes,
Account Number 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 Numeric 4 CB00.3
GL Reconcile If the GL Reconcile Entry field = Yes,
Subaccount Number 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 Alpha 15 CB00.3
Encashed Remittance The general ledger encashed remittance
Acct Unit 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 Numeric 6 CB00.3
Encashed Remittance The general ledger encashed remittance
Account 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 Numeric 4 CB00.3
Encashed Remittance The general ledger encashed remittance
Subaccount 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 Alpha 15 CB00.3
Discounted Remit The general ledger discounted
Acct Unit 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 Numeric 6 CB00.3
Discounted The general ledger discounted
Remittance Account 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 Numeric 4 CB00.3
Discounted The general ledger discounted
Remittance Subacct 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 Alpha 15 CB00.3
Bank Risk The general ledger bank risk accounting
Accounting Unit 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 Numeric 6 CB00.3
Bank Risk Account The general ledger bank risk account
Number 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 Numeric 4 CB00.3
Bank Risk The general ledger bank risk subaccount
Subaccount Number 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 Alpha 15 CB00.3
Bank Expense The general ledger bank expense
Accounting Unit 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 Numeric 6 CB00.3
Bank Expense The general ledger bank expense account
Account Number 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 Numeric 4 CB00.3
Bank Expense The general ledger bank expense
Subaccount Number 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 Alpha 15 CB00.3
Financial Expense The general ledger financial expense
Acct Unit 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.
CBY-FIN-ACCOUNT Numeric 6 CB00.3
Financial Expense The general ledger financial expense
Account 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.
CBY-FIN-SUB-ACCT Numeric 4 CB00.3
Financial Expense The general ledger financial expense
Subaccount 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.
CBY-ADMN-ACCT-UNIT Alpha 15 CB00.3
Admin Expense The general ledger administration
Accounting Unit 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 Numeric 6 CB00.3
Admin Expense The general ledger administration
Account Number 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 Numeric 4 CB00.3
Admin Expense The general ledger administration
Subaccount 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 Alpha 1 AP00.4 AP00.7
Used Indicates whether the company-cash code AP01.1 AP125
relationship has been used. Valid values AP126 AP150
are: AP151 AP156
AP170 AP180
N = No. AP181 AP190
Y = Yes. AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP20.8
AP200 AP23.1
AP25.1 AP25.2
AP255 AP26.1
AP265 AP28.1
AP28.2 AP30.3
AP520 AP55.1
AP55.2 AP56.1
AP56.2 AP80.1
AP81.1 AP90.5
AR01.1 AR02.1
AR115 AR124
AR14.1 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR28.2 AR28.5
AR29.2 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR700
AR82.1 AR980
CB00.3 CB06.1
...
CBY-SEL-BANK-NAME Derived
Bank Name The name of the bank associated with
the cash code.
CBY-SEL-BANK-ACCT Derived
Bank Account Number The bank account number defined for the
cash code.
CBY-RECON-JRNL-BK Alpha 12 CB00.3
Reconciliation The reconciliation journal book
Journal Book associated with the cash code.
CBY-DEP-INST-CODE Alpha 3 CB00.3
Dep Inst Code Bank statement default deposit pay
(transaction) code.
CBY-CHK-INST-CODE Alpha 3 CB00.3
Cash Payment Bank statement default cash payment pay
Pay/Trans Code (transaction) code.
CBY-BANK-INST-CODE Alpha 3 CB00.3
Transaction Code Bank statement default bank service
transaction pay (transaction) code.
CBY-RECN-INST-CODE Alpha 3 CB00.3
Reconciliation Bank statement default reconciliation
Trans Code pay (transaction) code.
CBCPYCASH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBYSET1 COMPANY This is the primary index used to AP00.4 AP00.7
CASH-CODE access and keep company-cash code AP01.1 AP125
relationship records unique. AP126 AP150
AP151 AP156
AP170 AP180
AP181 AP190
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP20.8
AP200 AP23.1
AP25.1 AP25.2
AP255 AP26.1
AP265 AP28.1
AP28.2 AP30.3
AP520 AP55.1
...
CBYSET2 CASH-CODE This index is used to access companies CB00.2
COMPANY that have relationship records with a
specific cash code.
CBCPYCASH 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
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
|