|
|
RJTRANS FILE
Recurring Journal Transactions
This file contains the recurring journal entry detail information to be
posted to the Lawson General Ledger system.
REFERENCED BY
GL270
UPDATED BY
GL110 GL170 GL70.1 GL70.2 GL70.3 GL70.7
GL75.1 GL950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJT-COMPANY Numeric 4 GL110 GL70.1
Company The company number as defined in GL10.1 GL70.2 GL70.3
(Company). GL70.7 GL950
RJT-REC-GROUP Numeric 8 GL70.1 GL70.2
Record Group The recurring journal entry number. GL70.3 GL70.7
GL950
RJT-JE-TYPE Alpha 1 GL70.1 GL70.2
Journal Entry Type The type of journal entry. Valid values GL70.3 GL70.7
are Normal and Intercompany. GL950
N = Normal
I = Intercompany
RJT-LINE-NBR Numeric 6 GL70.1 GL70.2
Line Number This field contains the line number. GL70.3 GL70.7
GL950
RJT-ACCT-UNIT Alpha 15 GL70.1 GL70.2
Accounting Unit The accounting unit is a shorthand GL70.3 GL70.7
notation representing the variable level GL950
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.
RJT-ACCOUNT Numeric 6 GL70.1 GL70.2
Account This field along with the accounting GL70.3 GL70.7
unit and subaccount make up the location GL950
(account) where amounts and other
account information is stored.
RJT-SUB-ACCOUNT Numeric 4 GL70.1 GL70.2
Subaccount This field along with the accounting GL70.3 GL70.7
unit and account make up the location GL950
(account) where amounts and other
account information is stored.
RJT-SOURCE-CODE Alpha 2 GL70.1 GL70.2
Source Code A two-character code assigned to a GL70.3 GL70.7
transaction that identifies where the GL950
transaction was created.
RJT-REFERENCE Alpha 10 (Lower Case) GL70.1 GL70.2
Reference The reference number associated with GL70.3 GL70.7
the transaction. GL950
RJT-DESCRIPTION Alpha 30 (Lower Case) GL70.1 GL70.2
Description Contains the transaction description. GL70.3 GL70.7
GL950
RJT-BASE-AMOUNT Signed 15.2 GL170 GL70.1
Base Amount The base amount to be posted to the GL70.2 GL70.3
General Ledger Master file. GL70.7 GL75.1
GL950
RJT-BASE-ND Numeric 1 GL170 GL70.1
Base Number of The number of decimal positions defined GL70.2 GL70.3
Decimals for the company base currency. GL70.7 GL75.1
GL950
RJT-UNITS-AMOUNT Signed 15.2 GL170 GL70.1
Units Amount Contains the transaction units amount. GL70.2 GL70.3
GL70.7 GL75.1
GL950
RJT-AUTO-REV Alpha 1 GL70.1 GL70.2
Auto Reverse When the Auto Reversal field is set to GL70.3 GL70.7
"Y," the Lawson General Ledger Closing GL950
program GL199 creates an opposite entry
for this transaction in the next period.
N = No
Y = Yes
RJT-TO-COMPANY Numeric 4 GL70.1 GL70.2
To Company This is the company number to which GL70.3 GL70.7
this line is to be posted. GL950
RJT-ACTIVITY Alpha 15 GL70.1 GL70.2
Activity Activities are the processes or GL70.3 GL70.7
procedures that produce work. Cost GL950
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
RJT-ACCT-CATEGORY Alpha 5 GL70.1 GL70.2
Account Category Account categories are groupings of GL70.3 GL70.7
costs, revenues, or a combination of GL950
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.
RJT-TRAN-AMOUNT Signed 15.2 GL170 GL70.1
Tran Amount This is the amount in transaction GL70.2 GL70.3
currency to be posted. This amount GL70.7 GL75.1
creates a CUAMOUNT type 1 record. GL950
RJT-TRAN-ND Numeric 1 GL170 GL70.1
Tran Number of The number of decimal positions defined GL70.2 GL70.3
Decimals for the transaction currency. GL70.7 GL75.1
GL950
RJT-VOLUME Signed 16.5 GL70.1 GL70.2
Volume This is value will be multiplied by the GL70.3 GL70.7
volume-rate field to determine the GL950
transaction amount.
RJT-VOLUME-RATE Signed 10.5 GL70.1 GL70.2
Volume Rate This is the rate that will be GL70.3 GL70.7
multiplied with the volume field to GL950
determine the transaction amount.
RJT-VOLUME-ND Numeric 1 GL70.1 GL70.2
Volume Number of This is the number of decimal positions GL70.3 GL70.7
Decimals in the volume field. GL950
RJT-SEGMENT-BLOCK Alpha 103 GL70.1 GL70.2
User Analysis This field identifies the user analysis GL70.3 GL70.7
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.
RJTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJTSET1 COMPANY GL110 GL170
REC-GROUP GL270 GL70.1
JE-TYPE GL70.2 GL70.3
LINE-NBR GL70.6 GL70.7
GL75.1
RJTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comments GLCOMMENT
RJT-COMPANY -> GCM-COMPANY
"R" -> GCM-RECORD-TYPE
"RJ" -> GCM-SYSTEM
Zeroes -> GCM-FISCAL-YEAR
Zeroes -> GCM-ACCT-PERIOD
RJT-REC-GROUP -> GCM-CONTROL-GROUP
RJT-JE-TYPE -> GCM-JE-TYPE
Zeroes -> GCM-JE-SEQUENCE
GCM-SEQUENCE-NBR
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
|