Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBRECPTDTL


                            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
Accounts Receivable    The cash code. Represents the bank
Code                   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 15.2                               CB10.3
Element: Adj Amt       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
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 15.2                               CB10.3
Element: Adj Amt       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
Element: Base Cost     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
Element: Adj Amt       The amount of tax for the cash receipt
                       distribution in the company base
                       currency.

CBA-TO-TAX-AMT         Signed 15.2                               CB10.3
Element: Adj 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