Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBRETPMT


                             CBRETPMT FILE

                             Return Payment

REFERENCED BY

CB246

UPDATED BY

CB150     CB300     CB46.1    CB544

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRP-CASH-CODE          Alpha 4                                   CB46.1  CB544
Element: Cash Code     A cash code represents a bank account.
                       More than one company can use the same
                       cash code.  The cash code must be linked
                       to a bank in the Lawson Cash Ledger
                       system.


CRP-BANK-INST-CODE     Alpha 3                                   CB46.1  CB544
Element: Bank Inst CodeA transaction code represents a type of
                       cash payment, bill of exchange payment,
                       or bank service transaction.

CRP-TRANS-NBR          Alpha 10  (Right Justified)               CB46.1  CB544
Element: Trans Nbr     A unique, user-defined value used to
                       identify the transaction.


CRP-TRANS-IDENT        Numeric 10                                CB46.1  CB544
Element: Trans Ident   A unique system-generated
                       identification value assigned to the
                       transaction to make this record unique.

CRP-REC-STATUS         Numeric 1                                 CB150   CB46.1
Element: Rec Status    The record status.                        CB544
                       0 = Unreleased
                       1 = Released

CRP-COMPANY            Numeric 4                                 CB46.1  CB544
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CRP-DEPOSIT-AMOUNT     Signed 18.2                               CB46.1  CB544
Element: Intl Amt

CRP-DEPOSIT-DATE       Numeric 8  (yyyymmdd)                     CB46.1  CB544
Element: Date          This field displays the system date
                       when this was created.

CRP-RETURN-AMOUNT      Signed 18.2                               CB46.1  CB544
Element: Intl Amt

CRP-BASE-RET-AMT       Signed 18.2                               CB46.1  CB544
Element: Intl Amt

CRP-TO-RET-AMT         Signed 18.2                               CB544
Element: Intl Amt

CRP-TRAN-ND            Numeric 1                                 CB46.1  CB544
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


CRP-BASE-ND            Numeric 1                                 CB46.1  CB544
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


CRP-CURRENCY-CODE      Alpha 5                                   CB46.1  CB544
Element: Currency Code This field contains the bank account
                       currency defined for the cash code.

CRP-EXCHANGE-RATE      Signed 14.7                               CB46.1  CB544
Element: Curr Rate     The currency rate.

CRP-DEP-JBK-NBR        Alpha 12                                  CB46.1  CB544
Element: Jrnl Book Nbr The journal book assigned to the
                       transaction.

CRP-DEP-JBK-SEQ        Numeric 10
Element: Jbk Seq Nbr   The journal book sequence number
                       assigned to a journal book transaction
                       when it is added or interfaced to the
                       Lawson system. Used only when  Auto
                       Journal Book Seq Nbr is set to Yes in
                       GL10.1 (Company).


CRP-RET-DATE           Numeric 8  (yyyymmdd)                     CB46.1  CB544
Element: Date          This field displays the system date
                       when this was created.

CRP-POST-DATE          Numeric 8  (yyyymmdd)                     CB46.1  CB544
Element: Date          This field displays the system date
                       when this was created.

CRP-DESCRIPTION        Alpha 30  (Lower Case)                    CB46.1  CB544
Element: Description   This field displays the description.

CRP-DEP-BANK-INST      Alpha 3                                   CB46.1  CB544
Element: Bank Inst CodeA transaction code represents a type of
                       cash payment, bill of exchange payment,
                       or bank service transaction.

CRP-DEPOSIT-NBR        Alpha 10  (Right Justified)               CB46.1  CB544
Element: Trans Nbr     A unique, user-defined value used to
                       identify the transaction.


CRP-DEPOSIT-TYPE       Alpha 1                                   CB46.1  CB544
Element: Trans Type    Determines if amounts or units are
                       processed in each transaction.
                       " " = Manual
                       1 = Wire
                       2 = Credit Card
                       3 = Lockbox
                       4 = EFT Extract

CRP-DEP-TRANS-IDEN     Numeric 10                                CB544
Element: Trans Ident   A unique system-generated
                       identification value assigned to the
                       transaction to make this record unique.

CRP-EFT-NUMBER         Alpha 10  (Right Justified)               CB46.1  CB544
Element: Trans Nbr     A unique, user-defined value used to
                       identify the transaction.


CRP-BEXP-TRAN-AMT      Signed 18.2                               CB46.1  CB544
Element: Intl Amt

CRP-BEXP-COMPANY       Numeric 4                                 CB46.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CRP-BEXP-ACCT-UNIT     Alpha 15                                  CB46.1  CB544
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


CRP-BEXP-ACCOUNT       Numeric 6                                 CB46.1  CB544
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

CRP-BEXP-SUB-ACCT      Numeric 4                                 CB46.1  CB544
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

CRP-BEXP-ACTIVITY      Alpha 15                                  CB46.1  CB544
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


CRP-BEXP-ACCT-CAT      Alpha 5                                   CB46.1  CB544
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

CRP-USER-FIELD1        Alpha 30                                  CB46.1  CB544
Element: User Field1   This is the first user definable field.
                       It can be used to capture any data that
                       the user wants.  The title of the field
                       is setup in IC00.


CRP-USER-FIELD2        Alpha 30                                  CB46.1  CB544
Element: User Field2   This is the second user definable
                       field. This field can be used to enter
                       any data that the user wants to capture
                       for this item.  The title of the field
                       is setup in IC00.


CRP-USER-FIELD3        Alpha 30                                  CB46.1  CB544
Element: User Field1   This is the first user definable field.
                       It can be used to capture any data that
                       the user wants.  The title of the field
                       is setup in IC00.


CRP-USER-FIELD4        Alpha 30                                  CB46.1  CB544
Element: User Field2   This is the second user definable
                       field. This field can be used to enter
                       any data that the user wants to capture
                       for this item.  The title of the field
                       is setup in IC00.


CRP-LAST-DIST-SEQ      Numeric 4                                 CB46.1  CB544
Element: Seq Nbr       An automatically assigned sequence
                       number.

CRP-SOURCE-CODE        Alpha 2                                   CB46.1  CB544
Element: Source Code   A two character code assigned to a
                       transaction to identify where the
                       transaction was created.

CRP-RECON-STMT-NBR     Numeric 12                                CB46.1  CB544
Element: Recon Stmt NbrThe bank-assigned reconciliation
                       statement number. Used only for cash
                       codes that require reconciliation
                       statements.


                         CBRETPMT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRPSET1   CASH-CODE                                              CB150   CB246
          BANK-INST-CODE                                         CB300
          TRANS-IDENT

CRPSET2   CASH-CODE                                              CB150   CB46.1
          BANK-INST-CODE
          TRANS-NBR
          TRANS-IDENT

                         CBRETPMT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbfttrans      CBFTTRANS    Required

                            CRP-CASH-CODE         -> CFT-CASH-CODE
                            CRP-BANK-INST-CODE    -> CFT-BANK-INST-CODE
                            CRP-TRANS-IDENT       -> CFT-TRANS-IDENT

Cbtrans        CBTRANS      Required

                            CRP-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            CRP-TRANS-IDENT       -> CBT-TRANS-IDENT

                         CBRETPMT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbdistrib      CBDISTRIB

                            CRP-CASH-CODE         -> CBD-CASH-CODE
                            CRP-BANK-INST-CODE    -> CBD-BANK-INST-CODE
                            CRP-TRANS-IDENT       -> CBD-TRANS-IDENT
                                                     CBD-DIST-TYPE
                                                     CBD-SEQ-NBR

Cbdistrib1     CBDISTRIB

                            CRP-CASH-CODE         -> CBD-CASH-CODE
                            CRP-DEP-BANK-INST     -> CBD-BANK-INST-CODE
                            CRP-DEP-TRANS-IDEN    -> CBD-TRANS-IDENT
                                                     CBD-DIST-TYPE
                                                     CBD-SEQ-NBR