RJTRANS

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJTSET1 COMPANY
REC-GROUP
JE-TYPE
LINE-NBR
GL110 GL170
GL270 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1


RJTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


RJTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:48:43 2016

Home
Contact Us



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