ACRJDTL FILE
UPDATED BY
AC170 AC70.1 AC70.4 AC70.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJD-REC-GROUP Numeric 8 AC70.1 AC70.4
Rec Group The recurring journal entry number.
RJD-TRANS-TYPE Alpha 1 AC70.1 AC70.4
Transaction Type Determines if amounts or units are
processed in each transaction.
1 = AC only
2 = Both AC and GL
3 = Resource AC only
4 = Resource AC and GL
5 = GL only
RJD-LINE-NBR Numeric 6 AC70.1 AC70.4
Line Number This field contains the line number.
RJD-ACTIVITY Alpha 15 AC70.1 AC70.4
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
RJD-ACCT-CATEGORY Alpha 5 AC70.1 AC70.4
Account Category 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.
RJD-COMPANY Numeric 4 AC70.1 AC70.4
Company The company number represents an
established company and is entered on
all function codes.
RJD-ACCT-UNIT Alpha 15 AC170 AC70.1
Accounting Unit The accounting unit is a shorthand AC70.4
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.
RJD-ACCOUNT Numeric 6 AC170 AC70.1
Account This field along with the accounting AC70.4
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RJD-SUB-ACCOUNT Numeric 4 AC70.1 AC70.4
Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RJD-REFERENCE Alpha 10 (Lower Case) AC70.1 AC70.4
Reference The reference number associated with
the transaction.
RJD-DESCRIPTION Alpha 30 (Lower Case) AC70.1 AC70.4
Description This field displays the description.
RJD-UNITS-AMOUNT Signed 15.2 AC170 AC70.1
Units Amount This is the units amount included in AC70.4 AC70.6
the file.
RJD-TRAN-AMOUNT Signed 15.2 AC170 AC70.1
Invoice Amount This is the amount in transaction AC70.4 AC70.6
currency to be posted. This amount
creates a CUAMOUNT type 1 record.
RJD-AUTO-REV Alpha 1 AC70.1 AC70.4
Auto Reverse 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.
RJD-REV-OBJ-ID Numeric 12
Rev Obj Id
RJD-UNIT-MEASURE Alpha 12 AC170 AC70.1
Unit Measure AC70.4
RJD-RESOURCE-TYPE Alpha 1 AC70.1 AC70.4
Resource Type
RJD-RESOURCE-CODE Alpha 10 AC70.1 AC70.4
Resource Code
RJD-RESOURCE-DESC Alpha 30 (Lower Case) AC70.1 AC70.4
Resource Desc
RJD-BILL-RATE Signed 13.4 AC170 AC70.1
Bill Rate AC70.4
RJD-BILLABLE-AMT Signed 15.2 AC170 AC70.1
Billable Amt AC70.4
RJD-TO-BASERATE Signed 12.6 AC70.1 AC70.4
Exchange Rate
RJD-TO-BASE-AMT Signed 15.2 AC170 AC70.1
To Company Base AC70.4
Amount
RJD-TO-BASE-ND Numeric 1 AC70.1 AC70.4
To Base Number Of
Decimals
RJD-BASERATE Signed 12.6 AC70.1 AC70.4
Exchange Rate Enter the exchange rate at the time the
journal entry was made. If left blank,
the current exchange rate will default.
RJD-BASE-AMT Signed 15.2 AC170 AC70.1
Base Amount This is the amount of the transaction in AC70.4
the company base amount.
RJD-BASE-ND Numeric 1 AC70.1 AC70.4
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
RJD-SEGMENT-BLOCK Alpha 103 AC70.1 AC70.4
User Analysis 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.
RJD-MATRIX-CAT Alpha 12 Occurs 3 Times AC70.1 AC70.4
Attribute Attribute name assigned to an object
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
RJD-MX-VALUE Alpha 32 Occurs 3 Times AC70.1 AC70.4
Attribute Value
RJD-TRAN-DATE Numeric 8 (yyyymmdd)
Transaction Date
ACRJDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJDSET1 REC-GROUP AC170 AC70.1
LINE-NBR AC70.4 AC70.6
ACRJDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acrjhdr ACRJHDR Required
RJD-REC-GROUP -> RJH-REC-GROUP
|
