Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RJSCHEDULE


                            RJSCHEDULE FILE

                       Recurring Journal Schedule

The Recurring Journal Schedule file contains recurring journal schedule
information that is used by the Recurring Journal programs.



REFERENCED BY

GL238     GL270     GL275

UPDATED BY

AP125     AP126     AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    GL110     GL146     GL170     GL197
GL40.1    GL40.2    GL40.3    GL40.7    GL40.8    GL44.1
GL45.1    GL500     GL70.1    GL70.2    GL70.3    GL70.5
GL70.6    GL75.1    GL38.2    MA61.1    MA70.1    MA75.1
MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RJS-OBJ-TYPE           Alpha 5                                   AP125   AP126
Element: Object Type   This field will determine the type of     AP25.1  AP25.2
                       object that is being used by the          AP26.1  AP27.1
                       attribute. These values are not user      AP30.2  AP30.4
                       maintainable.                             GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJS-OBJ-ID             Numeric 12                                AP125   AP126
Element: Object ID     The object ID associated with the         AP25.1  AP25.2
                       recurring journal entry.                  AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL110   GL146
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJS-FISCAL-YEAR        Numeric 4                                 AP125   AP126
Element: Fiscal Year   This is the current fiscal year.  This    AP25.1  AP25.2
                       field is updated by Period Closing        AP26.1  AP27.1
                       (GL199).                                  AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJS-ACCT-PERIOD        Numeric 2                                 AP125   AP126
Element: Accounting PerThis is the current accounting period.    AP25.1  AP25.2
                       This field is updated by GL199 (Period    AP26.1  AP27.1
                       Closing).                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJS-TRAN-AMOUNT        Signed 18.2                               AP125   AP126
Element: Tran Amount   This is the amount in transaction         AP25.1  AP25.2
                       currency to be posted. This amount        AP26.1  AP27.1
                       creates a CUAMOUNT type 1 record.         AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL38.2  GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJS-TRAN-ND            Numeric 1                                 AP125   AP126
Tran Number of         The number of decimal positions defined   AP25.1  AP25.2
Decimals               for the transaction currency.             AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJS-UNITS-AMOUNT       Signed 15.2                               AP125   AP126
Element: Units Amount  Contains the transaction units amount     AP25.1  AP25.2
                       to be scheduled.                          AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL38.2  GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJS-STATUS             Numeric 1                                 AP125   AP126
Element: Status        This field displays the status of the     AP25.1  AP25.2
                       transaction.                              AP26.1  AP27.1
                       0 = Not Processed                         AP30.2  AP30.4
                       1 = Processed                             GL146   GL170
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

                         RJSCHEDULE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RJSSET1   OBJ-TYPE                                               AP125   AP126
          OBJ-ID                                                 AP25.1  AP25.2
          FISCAL-YEAR                                            AP26.1  AP27.1
          ACCT-PERIOD                                            AP30.2  AP30.4
                                                                 GL110   GL146
                                                                 GL170   GL197
                                                                 GL238   GL270
                                                                 GL275   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1  GL38.2
                                                                 ...

                         RJSCHEDULE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Rjbridge       RJBRIDGE     Required

                            RJS-OBJ-TYPE     -> RJB-OBJ-TYPE
                            RJS-OBJ-ID       -> RJB-OBJ-ID

Rjcontrol      RJCONTROL    Required

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