|
|
CBRECPTDTL FILE
Cash Receipt Detail
The Cash Receipt Detail file contains all itemized entries for a cash receipt
deposit.
REFERENCED BY
CB210
UPDATED BY
CB10.1 CB10.3 CB300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBA-CASH-CODE Alpha 4 CB10.3
Cash Code The cash code. Represents the bank
account you are depositing cash receipt
funds to. Must be a valid record in the
Cash Code file.
CBA-BANK-INST-CODE Alpha 3 CB10.3
Transaction Code The bank service transaction code.
Represents a deposit for the cash code.
Must be a valid bank service type
transaction code record in the Bank
Transaction Code file.
CBA-TRANS-NBR Alpha 10 (Right Justified) CB10.3
Deposit Number A unique number assigned to the
deposit.
CBA-SEQ-NBR Numeric 4 CB10.3
Sequence Number The sequence number assigned to cash
receipt distribution.
CBA-PROD-TAX-CAT Alpha 15 CB10.3
Category The cash receipt category. Used to
default a general ledger account and
optional tax code to the cash receipt
distribution. Must be a valid record in
the Cash Receipt Category file.
CBA-RECEIPT-AMOUNT Signed 15.2 CB10.3
Receipt Amount The total receipt amount (distribution
amount) including tax for the category
in the currency of the bank account.
CBA-BASE-RECPT-AMT Signed 15.2 CB10.3
Base Currency The total receipt amount (distribution
Deposit Amount amount) including tax for the category
in the company base currency.
CBA-TO-RCPT-AMT Signed 15.2 CB10.3
To Company Deposit The total receipt amount (distribution
Amount amount) including tax for the category
in the distribution company base
currency.
CBA-TAX-CODE Alpha 10 CB10.3
Tax Code The tax code to be applied to the cash
receipt category distribution. Used to
calculate tax information for the
distribution. Must be a valid record in
the Tax Code file. If left blank, the
tax code assigned to the category, if
assigned, defaults.
CBA-RCPT-COMPANY Numeric 4 CB10.3
To Company The company the cash receipt
distribution should be posted to. Must
be a valid record in the General Ledger
Company file and a valid relationship
must exist in the Intercompany
Relationship file. If left blank, the
Company assigned to the cash receipt
defaults.
CBA-RCPT-ACCT-UNIT Alpha 15 CB10.3
GL Accounting Unit The general ledger accounting unit for
the cash receipt distribution. Must be a
valid record in the General Ledger Names
file.
CBA-RCPT-ACCOUNT Numeric 6 CB10.3
GL Account Number The general ledger account number for
the cash receipt distribution. Must be a
valid record in the General Ledger
Account Master file.
CBA-RCPT-SUB-ACCT Numeric 4 CB10.3
GL Subaccount Number The general ledger subaccount number
for the cash receipt distribution. Must
be a valid record in the General Ledger
Account Master file.
CBA-TAXABLE-AMT Signed 15.2 CB10.3
Taxable Amount The taxable amount of the cash receipt
distribution in the currency of the bank
account.
CBA-BASE-TXBL-AMT Signed 15.2 CB10.3
Base Currency The taxable amount of the cash receipt
Taxable Amount distribution in the company base
currency.
CBA-TO-TXBL-AMT Signed 15.2 CB10.3
To Company Taxable The taxable amount of the cash receipt
Amount distribution in the distribution company
base currency.
CBA-TAX-AMOUNT Signed 13.5 CB10.3
Tax Amount The amount of tax for the cash receipt
distribution in the currency of the bank
account.
CBA-BASE-TAX-AMT Signed 15.2 CB10.3
Total Tax Amount The amount of tax for the cash receipt
distribution in the company base
currency.
CBA-TO-TAX-AMT Signed 15.2 CB10.3
To Tax Amt The amount of tax for the cash receipt
distribution in the distribution company
base currency.
CBA-TAX-RATE Percent 7.5 (Percent) CB10.3
Tax Rate The tax rate defined for the tax code.
CBA-ACTIVITY Alpha 15 CB10.3
Activity The activity assigned to the cash
receipt distribution. Must be a valid
record in the Activity file. If left
blank, the activity assigned to the cash
receipt header or the category, if
assigned, defaults.
Activities are the tasks that make up
an activity group. Activities identify
work being done, such as work orders,
phases, products, and so on. A variety
of costs, revenues, or both make up an
activity.
CBA-ACCT-CATEGORY Alpha 5 CB10.3
Account Category The account category assigned to the
cash receipt distribution. Must be a
valid record in the Activity Account
Category file. If left blank, the
account category assigned to the cash
receipt header or the category, if
assigned, defaults.
Account categories are the Activity
Management accounts by which activity
transactions are grouped for budgeting
and reporting.
CBRECPTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBASET1 CASH-CODE This index is used to group all CB10.1 CB10.3
BANK-INST-CODEreceipts for a specific cash receipt CB210 CB300
TRANS-NBR deposit.
SEQ-NBR
CBRECPTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbbankinst CBBANKINST Required
CBA-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
CBA-CASH-CODE -> CBC-CASH-CODE
Cbcategory CBCATEGORY Required
CBP-COMPANY -> CBG-COMPANY
CBP-PROC-LEVEL -> CBG-PROC-LEVEL
CBA-PROD-TAX-CAT -> CBG-PROD-TAX-CAT
Cbrecpthdr CBRECPTHDR Required
CBA-CASH-CODE -> CBP-CASH-CODE
CBA-BANK-INST-CODE -> CBP-BANK-INST-CODE
CBA-TRANS-NBR -> CBP-TRANS-NBR
Gladdress Dtl GLADDRESS Required
CBA-RCPT-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
Spaces -> GAD-ADDR-TYPE
Gladdress Hdr GLADDRESS Required
CBA-RCPT-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
Spaces -> GAD-ADDR-TYPE
Glsystem Dtl GLSYSTEM Required
CBA-RCPT-COMPANY -> GLS-COMPANY
Glsystem Hdr GLSYSTEM Required
CBP-COMPANY -> GLS-COMPANY
|