|
|
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).
REFERENCED BY
CB01.4 CB01.5 CB01.6 CB01.7 CB195 CB90.2
UPDATED BY
AP00.4 AP00.5 AP01.1 AP125 AP126 AP150
AP151 AP156 AP170 AP180 AP181 AP190
AP200 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 AR115 AR124
AR14.1 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1
AR28.2 AR28.5 AR29.2 AR30.1 AR34.1 AR48.2
AR570 AR575 AR580 AR82.1 CB00.2 CB00.3
CB06.1 CB06.2 CB10.1 CB15.1 CB15.2 CB175
CB180 CB185 CB190 CB191 CB20.1 CB25.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 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBY-COMPANY Numeric 4 CB00.3
Element: Company The company number. Must be a valid
record in the General Ledger Company
file.
CBY-CASH-CODE Alpha 4 CB00.3
Element: 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
Element: Cash Company The general ledger company a cash
transaction will be made against. THIS
FIELD IS NOT USED AT THIS TIME.
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 18.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 18.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
Element: GL Variance CoThe general ledger company a
reconciliation variance transaction will
be made against. THIS FIELD IS NOT USED
AT THIS TIME.
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
Element: GL Reconcile EIndicates 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
Element: Reconcile CompThe general ledger company a reconciled
transaction will be made against. THIS
FIELD IS NOT USED AT THIS TIME.
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. THIS FIELD IS
NOT CURRENTLY USED.
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. THIS
FIELD IS NOT CURRENTLY USED.
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. THIS
FIELD IS NOT CURRENTLY USED.
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.5
Element: Used Flag 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. AP200 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
AR115 AR124
AR14.1 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR28.2 AR28.5
AR29.2 AR30.1
AR34.1 AR48.2
AR570 AR575
AR580 AR82.1
CB00.3 CB06.1
CB06.2 CB10.1
CB15.1 CB15.2
CB175 CB180
...
CBY-SEL-BANK-NAME Derived
Element: Bank Name The name of the bank associated with
the cash code.
CBY-SEL-BANK-ACCT Derived
Element: Bank Account NThe bank account number defined for the
cash code.
CBY-RECON-JRNL-BK Alpha 12 CB00.3
Reconcile Journal The reconciliation journal book
Book associated with the cash code.
CBY-DEP-INST-CODE Alpha 3 CB00.3
Customer Bank
Instrument Code
CBY-CHK-INST-CODE Alpha 3 CB00.3
Vendor Bank
Instrument Code
CBY-BANK-INST-CODE Alpha 3 CB00.3
GL Bank Instrument A transaction code represents a type of
Code cash payment, bill of exchange payment,
or bank service transaction.
CBY-RECN-INST-CODE Alpha 3 CB00.3
Reconcile Bank
Instrument Code
CBY-OBJ-ID Numeric 12 CB00.3
Object This is the object identifier. It is
Identification 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 Alpha 15
Element: Accounting Unit
CBY-PMT-ACCOUNT Numeric 6
Element: Account
CBY-PMT-SUB-ACCT Numeric 4
Element: Subaccount
CBY-EFT-ACCT-UNIT Alpha 15
Element: Accounting Unit
CBY-EFT-ACCOUNT Numeric 6
Element: Account
CBY-EFT-SUB-ACCT Numeric 4
Element: Subaccount
CBCPYCASH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBYSET1 COMPANY This is the primary index used to AP00.4 AP00.5
CASH-CODE access and keep company-cash code AP01.1 AP125
relationship records unique. AP126 AP150
AP151 AP156
AP170 AP180
AP181 AP190
AP200 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
...
CBYSET2 CASH-CODE This index is used to access companies CB00.2 CB01.5
COMPANY that have relationship records with a
specific cash code.
CBYSET3 OBJ-ID Subset CB01.6 CB01.7
Where OBJ-ID != Zeroes
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
CBCPYCASH FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
