 |
Lawson Insight Technical Documentation |
|
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
AP30.2 AP30.4 AP32.2 GL110 GL146 GL170
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL500 GL70.2 GL75.1 GL38.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJS-OBJ-TYPE Alpha 5 AP30.2 AP30.4
Object Type This field will determine the type of AP32.2 GL146
object that is being used by the GL40.1 GL40.2
attribute. These values are not user GL40.3 GL40.7
maintainable. GL40.8 GL44.1
GL45.1 GL500
RJS-OBJ-ID Numeric 12 AP30.2 AP30.4
Object ID The object ID associated with the AP32.2 GL110
recurring journal entry. GL146 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
RJS-FISCAL-YEAR Numeric 4 AP30.2 AP30.4
Fiscal Year This is the current fiscal year. This AP32.2 GL146
field is updated by Period Closing GL40.1 GL40.2
(GL199). GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
RJS-ACCT-PERIOD Numeric 2 AP30.2 AP30.4
Accounting Period This is the current accounting period. AP32.2 GL146
This field is updated by GL199 (Period GL40.1 GL40.2
Closing). GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
RJS-TRAN-AMOUNT Signed 15.2 AP30.2 AP30.4
Tran Amount This is the amount in transaction AP32.2 GL146
currency to be posted. This amount GL38.2 GL40.1
creates a CUAMOUNT type 1 record. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
RJS-TRAN-ND Numeric 1 AP30.2 AP30.4
Tran Number of The number of decimal positions defined AP32.2 GL146
Decimals for the transaction currency. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
RJS-UNITS-AMOUNT Signed 15.2 AP30.2 AP30.4
Units Amount Contains the transaction units amount AP32.2 GL146
to be scheduled. GL38.2 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
RJS-STATUS Numeric 1 AP30.2 AP30.4
Status This field displays the status of the AP32.2 GL146
transaction. GL170 GL40.1
0 = Not Processed GL40.2 GL40.3
1 = Processed GL40.7 GL40.8
GL44.1 GL45.1
GL500 GL75.1
RJSCHEDULE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJSSET1 OBJ-TYPE AP30.2 AP30.4
OBJ-ID AP32.2 GL110
FISCAL-YEAR GL146 GL170
ACCT-PERIOD GL238 GL270
GL275 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GL70.2
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
|