RJENCUMB – Recurring Journal Encumbrance

System
General Ledger (GL)
Prefix
RJE
Primary key
GLT-OBJ-ID
Fields
11
Updated by
7 programs
Referenced by
0 programs

RJENCUMB is the Recurring Journal Encumbrance table in Lawson General Ledger (prefix RJE). It is indexed by GLT-OBJ-ID (RJESET1); alternate indexes: RJESET2 and RJESET3. It is related 1:1 to ACCOMMITX, GLCOMMITX and RJCONTROL. It is updated by GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6 and GL75.1. The table has 11 fields, 3 indexes and 3 documented relations.

About RJENCUMB

No description in the Lawson data dictionary.

Fields (11)

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

Field / columnTypeDescription & valuesUpdated by
RJE-COMPANY
COMPANY		Numeric 4The company number represents an established company and is maintained on GL10.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-JE-TYPE
JE_TYPE		Alpha 1The type of journal entry. Valid values are Normal and Intercompany.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-REC-GROUP
REC_GROUP		Numeric 8The recurring journal entry number.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-LINE-NBR
LINE_NBR		Numeric 6This field contains the line number.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-FISCAL-YEAR
FISCAL_YEAR		Numeric 4This is the fiscal year for the record.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-PERIOD
PERIOD		Numeric 2This is the period for the record.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. The accounting unit entered in this field must be defined in the General Ledger Names file as a posting accounting unit.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-GLT-OBJ-ID PK
GLT_OBJ_ID		Numeric 12This field contains the object ID sequence number.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJE-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
RJESET1GLT-OBJ-IDPrimary, KeyChange, SubsetWhere (GLT-OBJ-ID != Zeroes)—
RJESET2COMPANY, JE-TYPE, REC-GROUP, LINE-NBR, FISCAL-YEAR, PERIODGL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
RJESET3ATN-OBJ-IDKeyChange, SubsetWhere (ATN-OBJ-ID != Zeroes)—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AccommitxACCOMMITXRequiredRJE-ATN-OBJ-ID → MIX-ATN-OBJ-ID (MIXSET2)
GlcommitxGLCOMMITXRequiredRJE-GLT-OBJ-ID → GOX-GLT-OBJ-ID
RjcontrolRJCONTROLRequiredRJE-COMPANY → RJC-COMPANY, RJE-JE-TYPE → RJC-JE-TYPE, RJE-REC-GROUP → RJC-REC-GROUP

Programs

Updated by (7)