CBRECPTDTL

Cash Receipt Detail

The Cash Receipt Detail file contains all itemized entries for a cash receipt deposit.
UPDATED BY
CB10.1 CB10.3 CB10.5 CB300 CB543 CB150
CB195 CB210

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBA-CASH-CODE
Element: Cash Code
Alpha 4
The cash code. Represents the bank account you are depositing cash receipt funds to. Must be a valid record in the Cash Code file.
CB10.3 CB10.5
CB543
CBA-BANK-INST-CODE
Element: Transaction Code
Alpha 3
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.
CB10.3 CB10.5
CB543
CBA-TRANS-NBR
Element: Deposit Number
Alpha 10 (Right Justified)
A unique number assigned to the deposit.
CB10.3 CB10.5
CB543
CBA-SEQ-NBR
Element: Seq Nbr
Numeric 4
The sequence number assigned to cash receipt distribution.
CB10.3 CB10.5
CB543
CBA-PROD-TAX-CAT
Element: Category
Alpha 15
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.
CB10.3 CB10.5
CB543
CBA-RECEIPT-AMOUNT
Element: Intl Amt
Signed 18.2
The total receipt amount (distribution amount) including tax for the category in the currency of the bank account.
CB10.3 CB10.5
CB543
CBA-BASE-RECPT-AMT
Base Currency
Deposit Amount
Signed 18.2
The total receipt amount (distribution amount) including tax for the category in the company base currency.
CB10.3 CB10.5
CB543
CBA-TO-RCPT-AMT
To Company Deposit
Amount
Signed 18.2
The total receipt amount (distribution amount) including tax for the category in the distribution company base currency.
CB10.3 CB10.5
CB543
CBA-TAX-CODE
Element: Tax Code
Alpha 10
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.
CB10.3 CB10.5
CB543
CBA-RCPT-COMPANY
Element: To Company
Numeric 4
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.
CB10.3 CB10.5
CB543
CBA-RCPT-ACCT-UNIT
Element: GL Accounting Unit
Alpha 15
The general ledger accounting unit for the cash receipt distribution. Must be a valid record in the General Ledger Names file.
CB10.3 CB10.5
CB543
CBA-RCPT-ACCOUNT
Element: GL Account Number
Numeric 6
The general ledger account number for the cash receipt distribution. Must be a valid record in the General Ledger Account Master file.
CB10.3 CB10.5
CB543
CBA-RCPT-SUB-ACCT
Element: GL Subaccount Number
Numeric 4
The general ledger subaccount number for the cash receipt distribution. Must be a valid record in the General Ledger Account Master file.
CB10.3 CB10.5
CB543
CBA-TAXABLE-AMT
Element: Intl Amt
Signed 18.2
The taxable amount of the cash receipt distribution in the currency of the bank account.
CB10.3 CB10.5
CB543
CBA-BASE-TXBL-AMT
Base Currency
Taxable Amount
Signed 18.2
The taxable amount of the cash receipt distribution in the company base currency.
CB10.3 CB10.5
CB543
CBA-TO-TXBL-AMT
To Company Taxable
Amount
Signed 18.2
The taxable amount of the cash receipt distribution in the distribution company base currency.
CB10.3 CB10.5
CB543
CBA-TAX-AMOUNT
Element: Intl Amt
Signed 18.2
The amount of tax for the cash receipt distribution in the currency of the bank account.
CB10.3 CB10.5
CB543
CBA-BASE-TAX-AMT
Element: Intl Amt
Signed 18.2
The amount of tax for the cash receipt distribution in the company base currency.
CB10.3 CB10.5
CB543
CBA-TO-TAX-AMT
Element: Intl Amt
Signed 18.2
The amount of tax for the cash receipt distribution in the distribution company base currency.
CB10.3 CB10.5
CB543
CBA-TAX-RATE
Element: Chrg Rate
Percent 7.5 (Percent)
The tax rate defined for the tax code.
CB10.3 CB10.5
CB543
CBA-ACTIVITY
Element: Activity
Alpha 15
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.
CB10.3 CB10.5
CB543
CBA-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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.
CB10.3 CB10.5
CB543
CBA-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
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.
CB10.3 CB10.5
CB543


CBRECPTDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBASET1 CASH-CODE
BANK-INST-CODE
TRANS-NBR
SEQ-NBR
CB10.1 CB10.3
CB10.5 CB150
CB195 CB210
CB300 CB543


CBRECPTDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Porebdist POREBDIST Required
CBA-CASH-CODE->RDS-CB-CASH-CODE
CBA-BANK-INST-CODE->RDS-CB-BANK-INST
CBA-TRANS-NBR->RDS-CB-TRANS-NBR
CBA-SEQ-NBR->RDS-DIST-SEQ-NBR


File created: Wed Jun 08 20:48:22 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.