Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ACRJHDR FILE

UPDATED BY

AC170     AC70.1    AC70.4    AC70.6

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RJH-REC-GROUP        Numeric 8                                   AC70.1  AC70.4
Rec Group            The recurring journal entry number.

RJH-TRANS-TYPE       Alpha 1                                     AC70.1  AC70.4
Transaction Type     Determines if amounts or units are
                     processed in each transaction.
                     1 = AC only
                     2 = Ac Gl
                     3 = Resrc Ac only
                     4 = Resrc Ac Gl
                     5 = GL Only

RJH-DESCRIPTION      Alpha 30  (Lower Case)                      AC70.1  AC70.4
Description          This field displays the description.

RJH-COMPANY          Numeric 4                                   AC70.1  AC70.4
Company              The company number represents an
                     established company and is entered on
                     all function codes.

RJH-BASE-CURR        Alpha 5                                     AC70.1  AC70.4
Base Curr

RJH-BASE-ND          Numeric 1                                   AC70.1  AC70.4
Base Number Of       The number of decimal positions defined
Decimals             for the company base currency.

RJH-TRAN-CURR        Alpha 5
Tran Curr

RJH-TRAN-ND          Numeric 1
Transaction Number   The number of decimal positions defined
of Decimals          for the transaction currency.

RJH-POSTING-DATE     Numeric 8  (yyyymmdd)
Posting Date         The date assigned to the journal entry
                     for posting.

RJH-SOURCE-CODE      Alpha 2                                     AC70.1  AC70.4
Source Code          A two character code assigned to a
                     transaction to identify where the
                     transaction was created.

RJH-STATUS           Numeric 1                                   AC170   AC70.1
Status               This field displays the status of the       AC70.4  AC70.6
                     transaction.

RJH-LAST-LINE-NBR    Numeric 6                                   AC70.1  AC70.4
Last Line Number     This field contains the number of the
                     last line item added to the document. It
                     is used to determine what the next line
                     number is when you add another
                     item.

RJH-DEBIT-TOTALS     Signed 15.2                                 AC70.1  AC70.4
Debit Totals                                                     AC70.6

RJH-CREDIT-TOTALS    Signed 15.2                                 AC70.1  AC70.4
Credit Totals                                                    AC70.6

RJH-UNIT-DEBIT       Signed 15.2                                 AC70.1  AC70.4
Unit Debit                                                       AC70.6

RJH-UNIT-CREDIT      Signed 15.2                                 AC70.1  AC70.4
Unit Credit                                                      AC70.6

RJH-AUTO-DEBITS      Signed 15.2                                 AC70.1  AC70.4
Auto Debits          The total positive detail auto              AC70.6
                     reversing amounts.


RJH-AUTO-CREDITS     Signed 15.2                                 AC70.1  AC70.4
Auto Credits         The total negative detail auto              AC70.6
                     reversing  amounts.


RJH-AUTO-DB-UNITS    Signed 15.2                                 AC70.1  AC70.4
Auto Db Units                                                    AC70.6

RJH-AUTO-CR-UNITS    Signed 15.2                                 AC70.1  AC70.4
Auto Cr Units                                                    AC70.6

RJH-OPERATOR         Alpha 10                                    AC70.1  AC70.4
Operator Code        This field is used to store the login       AC70.6
                     id of the person who entered the record.


RJH-AUTO-ZERO        Alpha 1                                     AC70.1  AC70.4
Auto Zero            This field is used to determine if
                     amounts are to be zeroed out after
                     processing.

RJH-AUTO-REVERSE     Alpha 1                                     AC70.1  AC70.4
Auto Reverse

RJH-REFERENCE        Alpha 10  (Lower Case)                      AC70.1  AC70.4
Reference            The reference number associated with
                     the transaction.

RJH-ACTIVE-STATUS    Alpha 1                                     AC70.1  AC70.4
Status               The status of the account. If Inactive,
                     no posting can be done to the account.


RJH-LAST-DATE-PRCD   Numeric 8  (yyyymmdd)                       AC70.1  AC70.4
Last Date Prcd

                         ACRJHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RJHSET1   REC-GROUP                                              AC170   AC70.1
                                                                 AC70.4  AC70.6

RJHSET2   TRANS-TYPE                                             AC70.1  AC70.4
          REC-GROUP

                         ACRJHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acrjdtl        ACRJDTL

                            RJH-REC-GROUP    -> RJD-REC-GROUP
                                                RJD-LINE-NBR