RJTRANS – Recurring Journal Transactions

System: General Ledger (GL)
Prefix: RJT
Primary key: COMPANY, REC-GROUP, JE-TYPE, LINE-NBR
Fields: 23
Updated by: 8 programs
Referenced by: 2 programs

RJTRANS is the Recurring Journal Transactions table in Lawson General Ledger (prefix RJT). It is indexed by COMPANY, REC-GROUP, JE-TYPE, LINE-NBR (RJTSET1). It is related 1:1 to GLMASTER, ACACTIVITY, GLCHARTDTL, GLSYSTEM, RJCONTROL and GLSRCCODE and 1:M to RJMXVALUE. It is updated by GL110, GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6 and GL75.1 and referenced by GL270 and ML110. The table has 23 fields, 1 index and 7 documented relations.

About RJTRANS

This file contains the recurring journal entry detail information to be posted to the Lawson General Ledger system.

Fields (23)

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

Field / column	Type	Description & values	Updated by
`RJT-COMPANY` PK COMPANY	Numeric 4	The company number as defined in GL10.1 (Company).	GL110, GL70.1, GL70.2, GL70.3, GL70.6
`RJT-REC-GROUP` PK REC_GROUP	Numeric 8	The recurring journal entry number.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-JE-TYPE` PK JE_TYPE	Alpha 1	The type of journal entry. Valid values are Normal and Intercompany. `N` Normal `I` Intercompany	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the line number.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-ACCOUNT` ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-SUB-ACCOUNT` SUB_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.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two-character code assigned to a transaction that identifies where the transaction was created.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the transaction description.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-BASE-AMOUNT` BASE_AMOUNT	Signed 18.2	The base amount to be posted to the General Ledger Master file.	GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
`RJT-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
`RJT-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	Contains the transaction units amount.	GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
`RJT-AUTO-REV` AUTO_REV	Alpha 1	When the Auto Reversal field is set to "Y," the Lawson General Ledger Closing program GL199 creates an opposite entry for this transaction in the next period. `N` No `Y` Yes	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-TO-COMPANY` TO_COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	GL110, GL70.1, GL70.2, GL70.3, GL70.6
`RJT-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-TRAN-AMOUNT` TRAN_AMOUNT	Signed 18.2	—	GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
`RJT-TRAN-ND` TRAN_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	GL170, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
`RJT-VOLUME` VOLUME	Signed 16.5	This is value will be multiplied by the volume-rate field to determine the transaction amount.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-VOLUME-RATE` VOLUME_RATE	Signed 10.5	This is the rate that will be multiplied with the volume field to determine the transaction amount.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-VOLUME-ND` VOLUME_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	GL70.1, GL70.2, GL70.3, GL70.6
`RJT-SEGMENT-BLOCK` SEGMENT_BLOCK	Alpha 103	This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.	GL70.1, GL70.2, GL70.3, GL70.6

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`RJTSET1`	`COMPANY`, `REC-GROUP`, `JE-TYPE`, `LINE-NBR`	Primary		GL110, GL170, GL270, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6 +2 more

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
Account	GLMASTER	Required	`RJT-TO-COMPANY` → `GLM-COMPANY`, `RJT-ACCT-UNIT` → `GLM-ACCT-UNIT`, `RJT-ACCOUNT` → `GLM-ACCOUNT`, `RJT-SUB-ACCOUNT` → `GLM-SUB-ACCOUNT`
Activity	ACACTIVITY	Not Required	`RJT-ACTIVITY` → `ACV-ACTIVITY`
Chart Detail	GLCHARTDTL	Not Required	`GLS-CHART-NAME` → `GDT-CHART-NAME`, `RJT-ACCOUNT` → `GDT-ACCOUNT`, `RJT-SUB-ACCOUNT` → `GDT-SUB-ACCOUNT`
Company	GLSYSTEM	Required	`RJT-COMPANY` → `GLS-COMPANY`
Rjcontrol	RJCONTROL	Required	`RJT-COMPANY` → `RJC-COMPANY`, `RJT-JE-TYPE` → `RJC-JE-TYPE`, `RJT-REC-GROUP` → `RJC-REC-GROUP`
Source	GLSRCCODE	Required	`RJT-SOURCE-CODE` → `GSR-SOURCE-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Rjmxvalue	RJMXVALUE			`RJT-COMPANY` → `RMV-COMPANY`, `RJT-REC-GROUP` → `RMV-REC-GROUP`, `RJT-JE-TYPE` → `RMV-JE-TYPE`, `RJT-LINE-NBR` → `RMV-LINE-NBR`, → `RMV-MATRIX-CAT`

Programs

Updated by (8)

GL110 Company Copy Delete
GL170 Recurring Journal Interface
GL70.1 Recurring Journal
GL70.2 Define Recurring Journal
GL70.3 Amounts Only
GL70.5 Filter
GL70.6 Recurring Copy
GL75.1 Recurring Journal Control

Referenced by (2)

GL270 Recurring Journal Edit Listing
ML110 Ledger Company Copy Delete