|
|
CBRECPTDTL FILE
Cash Receipt Detail
The Cash Receipt Detail file contains all itemized entries for a cash receipt
deposit.
REFERENCED BY
CB150 CB195 CB210
UPDATED BY
CB10.1 CB10.3 CB300 CB543
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBA-CASH-CODE Alpha 4 CB10.3 CB543
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 CB543
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 CB543
Element: Deposit NumberA unique number assigned to the deposit.
CBA-SEQ-NBR Numeric 4 CB10.3 CB543
Element: Seq Nbr The sequence number assigned to cash
receipt distribution.
CBA-PROD-TAX-CAT Alpha 15 CB10.3 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
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 CB543
Element: Chrg Rate The tax rate defined for the tax code.
CBA-ACTIVITY Alpha 15 CB10.3 CB543
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 CB543
Element: Acct 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.
CBA-SEGMENT-BLOCK Alpha 103 CB10.3 CB543
Element: Segment Block 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 CB10.1 CB10.3
BANK-INST-CODE CB150 CB195
TRANS-NBR CB210 CB300
SEQ-NBR CB543
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
|
