Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRJDTL


                              ACRJDTL FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RJD-REC-GROUP          Numeric 8
Element: Rec Group     The recurring journal entry number.

RJD-TRANS-TYPE         Alpha 1
Element: Transaction TyDetermines 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
Element: Line Number   This field contains the line number.

RJD-ACTIVITY           Alpha 15
Element: 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
Element: Account CategoAccount 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
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

RJD-ACCT-UNIT          Alpha 15
Element: Accounting UniThe 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.


RJD-ACCOUNT            Numeric 6
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

RJD-SUB-ACCOUNT        Numeric 4
Element: Subaccount

RJD-REFERENCE          Alpha 10  (Lower Case)
Element: Requester     The reference number associated with
                       the transaction.

RJD-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field displays the description.

RJD-UNITS-AMOUNT       Signed 15.2
Element: Adj Amt       This is the units amount included in
                       the file.

RJD-TRAN-AMOUNT        Signed 15.2
Element: Adj Amt

RJD-AUTO-REV           Alpha 1
Element: 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
Object
Identification

RJD-UNIT-MEASURE       Alpha 12
Element: Unit Measure

RJD-RESOURCE-TYPE      Alpha 1
Element: Resource Type

RJD-RESOURCE-CODE      Alpha 10
Element: Resource Code

RJD-RESOURCE-DESC      Alpha 30  (Lower Case)
Element: Description

RJD-BILL-RATE          Signed 13.4
Element: Document Total

RJD-BILLABLE-AMT       Signed 15.2
Element: Adj Amt

RJD-TO-BASERATE        Signed 12.6
Element: Account Rate

RJD-TO-BASE-AMT        Signed 15.2
Element: Adj Amt

RJD-TO-BASE-ND         Numeric 1
Account Currency
Code

RJD-BASERATE           Signed 12.6
Element: Account Rate

RJD-BASE-AMT           Signed 15.2
Element: Base Amount   This is the amount of the transaction in
                       the company base amount.

RJD-BASE-ND            Numeric 1
Account Currency
Code

RJD-SEGMENT-BLOCK      Alpha 103
Element: 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
Element: 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
Element: Attribute Value

RJD-TRAN-DATE          Numeric 8  (yyyymmdd)
Element: Date

                         ACRJDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RJDSET1   REC-GROUP
          LINE-NBR

                         ACRJDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acrjhdr        ACRJHDR      Required

                            RJD-REC-GROUP    -> RJH-REC-GROUP  (RJHSET1)