RJSCHEDULE – Recurring Journal Schedule

System
General Ledger Setup (IF)
Prefix
RJS
Primary key
OBJ-TYPE, OBJ-ID, FISCAL-YEAR, ACCT-PERIOD
Fields
8
Updated by
48 programs
Referenced by
5 programs

RJSCHEDULE is the Recurring Journal Schedule table in Lawson General Ledger Setup (prefix RJS). It is indexed by OBJ-TYPE, OBJ-ID, FISCAL-YEAR, ACCT-PERIOD (RJSSET1). It is related 1:1 to RJBRIDGE and RJCONTROL. It is updated by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 40 more and referenced by GL238, GL270, GL275, ML275 and ML75.1. The table has 8 fields, 1 index and 2 documented relations.

About RJSCHEDULE

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

Fields (8)

Column = COBOL field name without the RJS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RJS-OBJ-TYPE PK
OBJ_TYPE		Alpha 5This 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 +30 more
RJS-OBJ-ID PK
OBJ_ID		Numeric 12The object ID associated with the recurring journal entry.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
RJS-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +30 more
RJS-ACCT-PERIOD PK
ACCT_PERIOD		Numeric 2This 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 +30 more
RJS-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
RJS-TRAN-ND
TRAN_ND		Numeric 1The 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 +30 more
RJS-UNITS-AMOUNT
UNITS_AMOUNT		Signed 15.2Contains the transaction units amount to be scheduled.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
RJS-STATUS
STATUS		Numeric 1This 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 +37 more

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RJSSET1OBJ-TYPE, OBJ-ID, FISCAL-YEAR, ACCT-PERIODPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
RjbridgeRJBRIDGERequiredRJS-OBJ-TYPE → RJB-OBJ-TYPE, RJS-OBJ-ID → RJB-OBJ-ID
RjcontrolRJCONTROLRequiredRJB-COMPANY → RJC-COMPANY, RJB-JE-TYPE → RJC-JE-TYPE, RJB-REC-GROUP → RJC-REC-GROUP

Programs

Updated by (48)

Referenced by (5)