|
|
CBRECPTDTL FILE
Cash Receipt Detail
The Cash Receipt Detail file contains all itemized entries for a cash receipt
deposit.
REFERENCED BY
CB195 CB210
UPDATED BY
CB10.1 CB10.3 CB300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBA-CASH-CODE Alpha 4 CB10.3
Element: 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
Element: Transaction CoThe 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
Element: Deposit NumberA unique number assigned to the deposit.
CBA-SEQ-NBR Numeric 4 CB10.3
Element: Sequence NumbeThe sequence number assigned to cash
receipt distribution.
CBA-PROD-TAX-CAT Alpha 15 CB10.3
Element: 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 18.2 CB10.3
Element: Intl Amt The total receipt amount (distribution
amount) including tax for the category
in the currency of the bank account.
CBA-BASE-RECPT-AMT Signed 18.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 18.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
Element: 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
Element: 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
Element: GL Accounting 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
Element: GL Account NumThe 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
Element: GL Subaccount 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 18.2 CB10.3
Element: Intl Amt The taxable amount of the cash receipt
distribution in the currency of the bank
account.
CBA-BASE-TXBL-AMT Signed 18.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 18.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 18.2 CB10.3
Element: Intl Amt The amount of tax for the cash receipt
distribution in the currency of the bank
account.
CBA-BASE-TAX-AMT Signed 18.2 CB10.3
Element: Intl Amt The amount of tax for the cash receipt
distribution in the company base
currency.
CBA-TO-TAX-AMT Signed 18.2 CB10.3
Element: Intl 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
Element: Chrg Rate The tax rate defined for the tax code.
CBA-ACTIVITY Alpha 15 CB10.3
Element: 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
Element: Account CategoThe 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.
CBA-SEGMENT-BLOCK Alpha 103 CB10.3
Element: User Analysis This field identifies the user analysis
values included in the transaction.
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
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 CB195 CB210
TRANS-NBR deposit. CB300
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
Gladdress Hdr GLADDRESS Required
CBA-RCPT-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
Glsystem Dtl GLSYSTEM Required
CBA-RCPT-COMPANY -> GLS-COMPANY
Glsystem Hdr GLSYSTEM Required
CBP-COMPANY -> GLS-COMPANY
|
