Recurring Journal Transactions

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

GL110	GL170	GL70.1	GL70.2	GL70.3	GL70.5
GL70.6	GL75.1	GL270

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
RJT-COMPANY Element: Company	Numeric 4 The company number as defined in GL10.1 (Company).	GL110 GL70.1 GL70.2 GL70.3 GL70.6
RJT-REC-GROUP Element: Record Group	Numeric 8 The recurring journal entry number.	GL70.1 GL70.2 GL70.3 GL70.6
RJT-JE-TYPE Element: Journal Entry 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 Element: Line Number	Numeric 6 This field contains the line number.	GL70.1 GL70.2 GL70.3 GL70.6
RJT-ACCT-UNIT Element: Accounting 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 Element: 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 Element: Subaccount	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 Element: 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 Element: Reference	Alpha 10 (Lower Case) The reference number associated with the transaction.	GL70.1 GL70.2 GL70.3 GL70.6
RJT-DESCRIPTION Element: Description	Alpha 30 (Lower Case) Contains the transaction description.	GL70.1 GL70.2 GL70.3 GL70.6
RJT-BASE-AMOUNT Element: 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 Number of Decimals	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 Element: 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 Element: Auto Reverse	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 Element: 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 Element: 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 Element: Account 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 Element: Tran Amount	Signed 18.2	GL170 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6 GL75.1
RJT-TRAN-ND Tran Number of Decimals	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 Element: 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 Element: 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 Number of Decimals	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 Element: 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

RJTRANS FILE INDEX

RJTRANS FILE RELATIONS

ONE TO ONE RELATIONS

RJTRANS FILE RELATIONS

ONE TO MANY RELATIONS

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