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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RJE-COMPANY SET2COMPANY | Numeric 4 | The 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 SET2JE_TYPE | Alpha 1 | The 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 SET2REC_GROUP | Numeric 8 | The recurring journal entry number. | GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1 |
#RJE-LINE-NBR SET2LINE_NBR | Numeric 6 | This field contains the line number. | GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1 |
#RJE-FISCAL-YEAR SET2FISCAL_YEAR | Numeric 4 | This is the fiscal year for the record. | GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1 |
#RJE-PERIOD SET2PERIOD | Numeric 2 | This is the period for the record. | GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1 |
#RJE-ACCT-UNITACCT_UNIT | Alpha 15 | The 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-ACCOUNTACCOUNT | Numeric 6 | This 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-ACCOUNTSUB_ACCOUNT | Numeric 4 | This 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 PKGLT_OBJ_ID | Numeric 12 | This field contains the object ID sequence number. | GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1 |
#RJE-ATN-OBJ-ID SET3ATN_OBJ_ID | Numeric 12 | This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RJESET1 |
| Primary, KeyChange, Subset | Where (GLT-OBJ-ID != Zeroes) | — |
RJESET2 |
| GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1 | ||
RJESET3 |
| KeyChange, Subset | Where (ATN-OBJ-ID != Zeroes) | — |