Lawson Insight Technical Documentation |
|
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 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 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 MA41.1
MA41.2 MA41.4 MA41.7 MA43.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 AP20.1 AP20.2
object that is being used by the AP20.3 AP20.4
attribute. These values are not user AP20.5 AP20.7
maintainable. AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJS-OBJ-ID Numeric 12 AP125 AP126
Element: Object ID The object ID associated with the AP20.1 AP20.2
recurring journal entry. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJS-FISCAL-YEAR Numeric 4 AP125 AP126
Element: Fiscal Year Contains the fiscal year for the data AP20.1 AP20.2
stored on this record. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJS-ACCT-PERIOD Numeric 2 AP125 AP126
Element: Accounting PerThis is the current accounting period. AP20.1 AP20.2
This field is updated by GL199 (Period AP20.3 AP20.4
Closing). AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJS-TRAN-AMOUNT Signed 18.2 AP125 AP126
Element: Tran Amount AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJS-TRAN-ND Numeric 1 AP125 AP126
Tran Number of The number of decimals assigned to a AP20.1 AP20.2
Decimals particular account as determined by the AP20.3 AP20.4
account currency. AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJS-UNITS-AMOUNT Signed 15.2 AP125 AP126
Element: Units Amount Contains the transaction units amount AP20.1 AP20.2
to be scheduled. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJS-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP20.1 AP20.2
transaction. AP20.3 AP20.4
0 = Not Processed AP20.5 AP20.7
1 = Processed AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
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 AP20.1 AP20.2
FISCAL-YEAR AP20.3 AP20.4
ACCT-PERIOD AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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
...
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
|