Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RJTRANS


                              RJTRANS FILE

                     Recurring Journal Transactions

This file contains the recurring journal entry detail information to be
posted to the Lawson General Ledger system.


REFERENCED BY

GL270

UPDATED BY

GL110     GL170     GL70.1    GL70.2    GL70.3    GL70.5
GL70.6    GL75.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RJT-COMPANY            Numeric 4                                 GL110   GL70.1
Element: Company       The company number as defined in GL10.1   GL70.2  GL70.3
                       (Company).                                GL70.6


RJT-REC-GROUP          Numeric 8                                 GL70.1  GL70.2
Element: Record Group  The recurring journal entry number.       GL70.3  GL70.6

RJT-JE-TYPE            Alpha 1                                   GL70.1  GL70.2
Element: Journal Entry The type of journal entry. Valid values   GL70.3  GL70.6
                       are Normal and Intercompany.

                       N = Normal
                       I = Intercompany

RJT-LINE-NBR           Numeric 6                                 GL70.1  GL70.2
Element: Line Number   This field contains the line number.      GL70.3  GL70.6

RJT-ACCT-UNIT          Alpha 15                                  GL70.1  GL70.2
Element: Accounting UniThe accounting unit is a shorthand        GL70.3  GL70.6
                       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.


RJT-ACCOUNT            Numeric 6                                 GL70.1  GL70.2
Element: Account       This field along with the accounting      GL70.3  GL70.6
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

RJT-SUB-ACCOUNT        Numeric 4                                 GL70.1  GL70.2
Element: Subaccount    This field along with the accounting      GL70.3  GL70.6
                       unit and account make up the location
                       (account) where amounts and other
                       account information is stored.


RJT-SOURCE-CODE        Alpha 2                                   GL70.1  GL70.2
Element: Source Code   A two-character code assigned to a        GL70.3  GL70.6
                       transaction that identifies where the
                       transaction was created.


RJT-REFERENCE          Alpha 10  (Lower Case)                    GL70.1  GL70.2
Element: Reference     The reference number associated with      GL70.3  GL70.6
                       the transaction.

RJT-DESCRIPTION        Alpha 30  (Lower Case)                    GL70.1  GL70.2
Element: Description   Contains the transaction description.     GL70.3  GL70.6

RJT-BASE-AMOUNT        Signed 18.2                               GL170   GL70.1
Element: Base Amount   The base amount to be posted to the       GL70.2  GL70.3
                       General Ledger Master file.               GL70.5  GL70.6
                                                                 GL75.1

RJT-BASE-ND            Numeric 1                                 GL170   GL70.1
Base Number of         The number of decimal positions defined   GL70.2  GL70.3
Decimals               for the company base currency.            GL70.5  GL70.6
                                                                 GL75.1

RJT-UNITS-AMOUNT       Signed 15.2                               GL170   GL70.1
Element: Units Amount  Contains the transaction units amount.    GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1

RJT-AUTO-REV           Alpha 1                                   GL70.1  GL70.2
Element: Auto Reverse  When the Auto Reversal field is set to    GL70.3  GL70.6
                       "Y," the Lawson General Ledger Closing
                       program GL199 creates an opposite entry
                       for this transaction in the next period.


                       N = No
                       Y = Yes

RJT-TO-COMPANY         Numeric 4                                 GL110   GL70.1
Element: To Company    This is the company number to which       GL70.2  GL70.3
                       this line is to be posted.                GL70.6

RJT-ACTIVITY           Alpha 15                                  GL70.1  GL70.2
Element: Activity      Activities are the processes or           GL70.3  GL70.6
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


RJT-ACCT-CATEGORY      Alpha 5                                   GL70.1  GL70.2
Element: Account CategoAccount categories are groupings of       GL70.3  GL70.6
                       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

RJT-TRAN-AMOUNT        Signed 18.2                               GL170   GL70.1
Element: Tran Amount   This is the amount in transaction         GL70.2  GL70.3
                       currency to be posted. This amount        GL70.5  GL70.6
                       creates a CUAMOUNT type 1 record.         GL75.1

RJT-TRAN-ND            Numeric 1                                 GL170   GL70.1
Tran Number of         The number of decimal positions defined   GL70.2  GL70.3
Decimals               for the transaction currency.             GL70.5  GL70.6
                                                                 GL75.1

RJT-VOLUME             Signed 16.5                               GL70.1  GL70.2
Element: Volume        This is value will be multiplied by the   GL70.3  GL70.6
                       volume-rate field to determine the
                       transaction amount.


RJT-VOLUME-RATE        Signed 10.5                               GL70.1  GL70.2
Element: Volume Rate   This is the rate that will be             GL70.3  GL70.6
                       multiplied with the volume field to
                       determine the transaction amount.


RJT-VOLUME-ND          Numeric 1                                 GL70.1  GL70.2
Volume Number of       This is the number of decimal positions   GL70.3  GL70.6
Decimals               in the volume field.


RJT-SEGMENT-BLOCK      Alpha 103                                 GL70.1  GL70.2
Element: User Analysis This field identifies the user analysis   GL70.3  GL70.6
                       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.

                         RJTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RJTSET1   COMPANY                                                GL110   GL170
          REC-GROUP                                              GL270   GL70.1
          JE-TYPE                                                GL70.2  GL70.3
          LINE-NBR                                               GL70.5  GL70.6
                                                                 GL75.1

                         RJTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account        GLMASTER     Required

                            RJT-TO-COMPANY     -> GLM-COMPANY
                            RJT-ACCT-UNIT      -> GLM-ACCT-UNIT
                            RJT-ACCOUNT        -> GLM-ACCOUNT
                            RJT-SUB-ACCOUNT    -> GLM-SUB-ACCOUNT

Activity       ACACTIVITY   Not Required

                            RJT-ACTIVITY       -> ACV-ACTIVITY

Chart Detail   GLCHARTDTL   Not Required

                            GLS-CHART-NAME     -> GDT-CHART-NAME
                            RJT-ACCOUNT        -> GDT-ACCOUNT
                            RJT-SUB-ACCOUNT    -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            RJT-COMPANY        -> GLS-COMPANY

Rjcontrol      RJCONTROL    Required

                            RJT-COMPANY        -> RJC-COMPANY
                            RJT-JE-TYPE        -> RJC-JE-TYPE
                            RJT-REC-GROUP      -> RJC-REC-GROUP

Source         GLSRCCODE    Required

                            RJT-SOURCE-CODE    -> GSR-SOURCE-CODE

                         RJTRANS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Rjmxvalue      RJMXVALUE

                            RJT-COMPANY        -> RMV-COMPANY
                            RJT-REC-GROUP      -> RMV-REC-GROUP
                            RJT-JE-TYPE        -> RMV-JE-TYPE
                            RJT-LINE-NBR       -> RMV-LINE-NBR
                                                  RMV-MATRIX-CAT