|
|
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.5
GL70.6 GL75.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJT-COMPANY Numeric 4 GL110 GL70.1
Element: Company The company number as defined in GL10.1 GL70.2 GL70.3
(Company). GL70.6
RJT-REC-GROUP Numeric 8 GL70.1 GL70.2
Element: Record Group The recurring journal entry number. GL70.3 GL70.6
RJT-JE-TYPE Alpha 1 GL70.1 GL70.2
Element: Journal Entry The type of journal entry. Valid values GL70.3 GL70.6
are Normal and Intercompany.
N = Normal
I = Intercompany
RJT-LINE-NBR Numeric 6 GL70.1 GL70.2
Element: Line Number This field contains the line number. GL70.3 GL70.6
RJT-ACCT-UNIT Alpha 15 GL70.1 GL70.2
Element: Accounting UniThe accounting unit is a shorthand GL70.3 GL70.6
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.
RJT-ACCOUNT Numeric 6 GL70.1 GL70.2
Element: Account This field along with the accounting GL70.3 GL70.6
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RJT-SUB-ACCOUNT Numeric 4 GL70.1 GL70.2
Element: Subaccount This field along with the accounting GL70.3 GL70.6
unit and account make up the location
(account) where amounts and other
account information is stored.
RJT-SOURCE-CODE Alpha 2 GL70.1 GL70.2
Element: Source Code A two-character code assigned to a GL70.3 GL70.6
transaction that identifies where the
transaction was created.
RJT-REFERENCE Alpha 10 (Lower Case) GL70.1 GL70.2
Element: Reference The reference number associated with GL70.3 GL70.6
the transaction.
RJT-DESCRIPTION Alpha 30 (Lower Case) GL70.1 GL70.2
Element: Description Contains the transaction description. GL70.3 GL70.6
RJT-BASE-AMOUNT Signed 18.2 GL170 GL70.1
Element: Base Amount The base amount to be posted to the GL70.2 GL70.3
General Ledger Master file. GL70.5 GL70.6
GL75.1
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.5 GL70.6
GL75.1
RJT-UNITS-AMOUNT Signed 15.2 GL170 GL70.1
Element: Units Amount Contains the transaction units amount. GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJT-AUTO-REV Alpha 1 GL70.1 GL70.2
Element: Auto Reverse When the Auto Reversal field is set to GL70.3 GL70.6
"Y," the Lawson General Ledger Closing
program GL199 creates an opposite entry
for this transaction in the next period.
N = No
Y = Yes
RJT-TO-COMPANY Numeric 4 GL110 GL70.1
Element: To Company This is the company number to which GL70.2 GL70.3
this line is to be posted. GL70.6
RJT-ACTIVITY Alpha 15 GL70.1 GL70.2
Element: Activity Activities are the processes or GL70.3 GL70.6
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
RJT-ACCT-CATEGORY Alpha 5 GL70.1 GL70.2
Element: Account CategoAccount categories are groupings of GL70.3 GL70.6
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
RJT-TRAN-AMOUNT Signed 18.2 GL170 GL70.1
Element: Tran Amount This is the amount in transaction GL70.2 GL70.3
currency to be posted. This amount GL70.5 GL70.6
creates a CUAMOUNT type 1 record. GL75.1
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.5 GL70.6
GL75.1
RJT-VOLUME Signed 16.5 GL70.1 GL70.2
Element: Volume This is value will be multiplied by the GL70.3 GL70.6
volume-rate field to determine the
transaction amount.
RJT-VOLUME-RATE Signed 10.5 GL70.1 GL70.2
Element: Volume Rate This is the rate that will be GL70.3 GL70.6
multiplied with the volume field to
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.6
Decimals in the volume field.
RJT-SEGMENT-BLOCK Alpha 103 GL70.1 GL70.2
Element: User Analysis This field identifies the user analysis GL70.3 GL70.6
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.5 GL70.6
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
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
|
