|
|
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
AP155 AP160 AP161 CB01.4 CB01.5 CB01.6
CB01.7 CB162 CB170 CB195 CB210 CB215
CB220 CB221 CB260 CB286 CB62.1 CB90.2
MX123 MX500 CBBC.1 CBOP.1 MX223
UPDATED BY
AP00.4 AP00.5 AP01.1 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 AR115 AR124 AR14.1 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR28.2 AR28.5
AR29.2 AR30.1 AR32.1 AR34.1 AR48.2 AR570
AR575 AR580 AR82.1 CB00.2 CB00.3 CB06.1
CB06.2 CB10.1 CB145 CB15.1 CB15.2 CB150
CB175 CB180 CB185 CB186 CB187 CB190
CB191 CB20.1 CB25.1 CB30.1 CB43.1 CB44.1
CB45.1 CB46.1 CB50.1 CB500 CB54.1 CB543
CB544 CB55.1 CB554 CB80.1 CB82.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
ET09.2 MA41.1 MA41.2 MA41.4 MA41.7 MA43.2
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. 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
AR115 AR124
AR14.1 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR28.2 AR28.5
AR29.2 AR30.1
AR32.1 AR34.1
AR48.2 AR570
...
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 journal book assigned to the
Book transaction.
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
Element: Obj Id 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 Alpha 15 CB00.3
Element: Acct Unit 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 Numeric 6 CB00.3
Element: Account 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 Numeric 4 CB00.3
Element: Sub Acct 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 Alpha 15 CB00.3
Element: Acct Unit 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 Numeric 6 CB00.3
Element: Account 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 Numeric 4 CB00.3
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
CBCPYCASH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBYSET1 COMPANY AP00.4 AP00.5
CASH-CODE AP01.1 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
...
CBYSET2 CASH-CODE CB00.2 CB01.5
COMPANY CBBC.1 CBOP.1
CBYSET3 OBJ-ID Subset AP150 AP155
Where OBJ-ID != Zeroes AP160 AP161
AP265 CB01.6
CB01.7 CB145
CB170 CB175
CB180 CB186
CB187 CB210
CB215 CB220
CB221 CB260
CB286 MX123
MX223 MX500
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
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
|
