Cash Receipt Detail
The Cash Receipt Detail file contains all itemized entries for a cash receipt deposit.
REFERENCED BY
CB210 |
CB10.1 | CB10.3 | CB10.5 | CB150 | CB195 | CB300 |
CB543 |
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. |
|
||||
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. |
|
||||
CBA-TRANS-NBR Element: Deposit Number | Alpha 10 (Right Justified) A unique number assigned to the deposit. |
|
||||
CBA-SEQ-NBR Element: Seq Nbr | Numeric 4 The sequence number assigned to cash receipt distribution. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
CBA-TAXABLE-AMT Element: Intl Amt | Signed 18.2 The taxable amount of the cash receipt distribution in the currency of the bank account. |
|
||||
CBA-BASE-TXBL-AMT Base Currency Taxable Amount | Signed 18.2 The taxable amount of the cash receipt distribution in the company base currency. |
|
||||
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. |
|
||||
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. |
|
||||
CBA-BASE-TAX-AMT Element: Intl Amt | Signed 18.2 The amount of tax for the cash receipt distribution in the company base currency. |
|
||||
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. |
|
||||
CBA-TAX-RATE Element: Chrg Rate | Percent 7.5 (Percent) The tax rate defined for the tax code. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CBASET1 |
CASH-CODE BANK-INST-CODE TRANS-NBR SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cbbankinst | CBBANKINST |
Required
| ||||||||||||
Cbcashcode | CBCASHCODE |
Required
| ||||||||||||
Cbcategory | CBCATEGORY |
Required
| ||||||||||||
Cbrecpthdr | CBRECPTHDR |
Required
| ||||||||||||
Gladdress Dtl | GLADDRESS |
Required
| ||||||||||||
Gladdress Hdr | GLADDRESS |
Required
| ||||||||||||
Glsystem Dtl | GLSYSTEM |
Required
| ||||||||||||
Glsystem Hdr | GLSYSTEM |
Required
| ||||||||||||
Porebdist | POREBDIST |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.