RJSCHEDULE

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 ML275 ML75.1


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 MA42.2 MA43.2 MA44.1
MA44.2 MA61.1 MA70.1 MA75.1 MAI1.1 ML70.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJS-OBJ-TYPE
Element: Object Type
Alpha 5
This field will determine the type of object that is being used by the attribute. These values are not user maintainable.
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
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJS-OBJ-ID
Element: Object ID
Numeric 12
The object ID associated with the recurring journal entry.
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
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJS-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Contains the fiscal year for the data stored on this record.
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
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJS-ACCT-PERIOD
Element: Accounting Period
Numeric 2
This is the current accounting period. This field is updated by GL199 (Period Closing).
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
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJS-TRAN-AMOUNT
Element: Tran Amount
Signed 18.2
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
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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJS-TRAN-ND
Tran Number of
Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
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
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJS-UNITS-AMOUNT
Element: Units Amount
Signed 15.2
Contains the transaction units amount to be scheduled.
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
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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJS-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Not Processed
1 = Processed
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
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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1


RJSCHEDULE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJSSET1 OBJ-TYPE
OBJ-ID
FISCAL-YEAR
ACCT-PERIOD
...
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
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
NAME
RELATED 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


File created: Thu Jun 09 11:18:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.