Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBRECLOAD


                             CBRECLOAD FILE

                     Cash Receipt Conversion/Import

UPDATED BY

CB43.1    CB543

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRC-RUN-GROUP          Alpha 15                                  CB43.1
Element: Run Group     Run Group and Seq Number are the keys
                       to the file.  They should be used to
                       group records together for interfacing.

CRC-CASH-CODE          Alpha 4                                   CB43.1
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.


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

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


CRC-SEQ-NBR            Numeric 4                                 CB43.1
Element: Seq Nbr       An automatically assigned sequence
                       number.

CRC-TRANS-TYPE         Alpha 1                                   CB43.1  CB543
Element: Trans Type    Determines if amounts or units are
                       processed in each transaction.
                       1 = Wire
                       2 = Credit Card
                       3 = Lockbox
                       4 = EFT Extract

CRC-REC-STATUS         Numeric 1                                 CB43.1
Element: Rec Status    The record status.
                       0 = Unreleased
                       1 = Released

CRC-COMPANY            Numeric 4                                 CB43.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.

CRC-TRANS-DATE         Numeric 8  (yyyymmdd)                     CB43.1
Element: Date          This field displays the system date
                       when this was created.

CRC-POST-DATE          Numeric 8  (yyyymmdd)                     CB43.1  CB543
Element: Date          This field displays the system date
                       when this was created.

CRC-DESCRIPTION        Alpha 30  (Lower Case)                    CB43.1  CB543
Element: Description   This field displays the description.

CRC-PROC-LEVEL         Alpha 5                                   CB43.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

CRC-ACH-PRENOTE        Alpha 1                                   CB43.1  CB543
Element: Ach Prenot    N = Not Prenotified
                       A = Accepted

CRC-JRNL-BOOK-NBR      Alpha 12                                  CB43.1
Element: Jrnl Book Nbr The journal book assigned to the
                       transaction.

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


CRC-CUST-NAME          Alpha 30                                  CB43.1
Element: Search Name

CRC-CUST-BANK          Alpha 15                                  CB43.1
Element: Bank Entity   Represents a bank institution location.


CRC-CUST-ACCOUNT       Alpha 35                                  CB43.1
Element: Bank Acct Nbr The bank-assigned account number
                       identification to be used for the cash
                       code.


CRC-VBANK-IDENT        Alpha 1                                   CB43.1
Element: Alphadata1    " " = Standard Account Number
                       Y = IBAN Account Number

CRC-USER-FIELD1        Alpha 30                                  CB43.1
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.


CRC-USER-FIELD2        Alpha 30                                  CB43.1
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.


CRC-USER-FIELD3        Alpha 30                                  CB43.1
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.


CRC-USER-FIELD4        Alpha 30                                  CB43.1
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.


CRC-RCPT-COMPANY       Numeric 4                                 CB43.1  CB543
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.

CRC-PROD-TAX-CAT       Alpha 15                                  CB43.1
Element: Prod Tax Cat  A classification of items for
                       determining taxes using the VERTEX
                       system in Lawson Order Entry system or
                       the cash receipts programs in the Lawson
                       Cash Ledger system.

CRC-RCPT-ACCT-UNIT     Alpha 15                                  CB43.1
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.


CRC-RCPT-ACCOUNT       Numeric 6                                 CB43.1  CB543
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

CRC-RCPT-SUB-ACCT      Numeric 4                                 CB43.1  CB543
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.

CRC-RECEIPT-AMOUNT     Signed 18.2                               CB43.1
Element: Intl Amt

CRC-TAX-CODE           Alpha 10                                  CB43.1  CB543
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


CRC-TAXABLE-AMT        Signed 18.2                               CB43.1  CB543
Element: Intl Amt

CRC-TAX-AMOUNT         Signed 18.2                               CB43.1  CB543
Element: Intl Amt

CRC-ACTIVITY           Alpha 15                                  CB43.1  CB543
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.


CRC-ACCT-CATEGORY      Alpha 5                                   CB43.1  CB543
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

CRC-SEGMENT-BLOCK      Alpha 103                                 CB43.1  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.

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

                         CBRECLOAD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRCSET1   RUN-GROUP                                              CB43.1  CB543
          CASH-CODE
          BANK-INST-CODE
          TRANS-NBR
          SEQ-NBR