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
GL270
UPDATED BY
AP125 AP126 AP20.1 AP20.2 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4
AP32.2 GL110 GL146 GL170 GL40.1 GL40.2
GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500
GL70.2 GL75.1 GL38.2 MA40.1 MA40.2 MA41.1
MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2
MA43.3 MA43.4 MA52.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJS-OBJ-TYPE Alpha 5 AP125 AP126
Object Type This field will determine the type of AP20.1 AP20.2
object that is being used by the AP20.5 AP20.7
attribute. These values are not user AP23.1 AP25.1
maintainable. AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL500
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJS-OBJ-ID Numeric 12 AP125 AP126
Object ID The object ID associated with the AP20.1 AP20.2
recurring journal entry. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL110
GL146 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJS-FISCAL-YEAR Numeric 4 AP125 AP126
Fiscal Year This is the current fiscal year. This AP20.1 AP20.2
field is updated by GL199 (Period AP20.5 AP20.7
Closing). AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL500
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJS-ACCT-PERIOD Numeric 2 AP125 AP126
Accounting Period This is the current accounting period. AP20.1 AP20.2
This field is updated by GL199 (Period AP20.5 AP20.7
Closing). AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL500
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJS-TRAN-AMOUNT Signed 15.2 AP125 AP126
Tran Amount This is the amount in transaction AP20.1 AP20.2
currency to be posted. This amount AP20.5 AP20.7
creates a CUAMOUNT type 1 record. AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL38.2 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJS-TRAN-ND Numeric 1 AP125 AP126
Tran Number of The number of decimal positions defined AP20.1 AP20.2
Decimals for the transaction currency. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL500
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJS-UNITS-AMOUNT Signed 15.2 AP125 AP126
Units Amount Contains the transaction units amount AP20.1 AP20.2
to be scheduled. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL38.2 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJS-PERIOD-PERCENT Percent 8.5 (Percent) AP125 AP126
Period Percent The percent of the transaction AP20.1 AP20.2
scheduled for the period. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL38.2 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJS-STATUS Numeric 1 AP125 AP126
Status This field contains the status of the AP20.1 AP20.2
transaction. AP20.5 AP20.7
0 = Not Processed AP23.1 AP25.1
1 = Processed AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL75.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.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.5 AP20.7
ACCT-PERIOD AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL110
GL146 GL170
GL270 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.2
GL75.1 GL38.2
MA40.1 MA40.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
|