Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLTRANSREL


                            GLTRANSREL FILE

                       GL Transaction Conversion

The General Ledger Transaction Interface file contains the information needed
to create transaction within the Lawson General Ledger system when converting
from a non-Lawson system defined in GL65.1 (Transaction Interface
Maintenance).


REFERENCED BY

GL265

UPDATED BY

GL165     GL565     GL65.1    IFLR.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GTR-RUN-GROUP          Alpha 15                                  GL165   GL565
Element: Run Group     Run Group and Seq Number are the keys     GL65.1  IFLR.1
                       to GLTRANSREL file. They should be used
                       to group records together for
                       interfacing.

GTR-SEQ-NUMBER         Numeric 6                                 GL165   GL565
Element: Sequence NumbeA unique number assigned to each          GL65.1  IFLR.1
                       transaction to be interfaced into the
                       Lawson system.

GTR-COMPANY            Numeric 4                                 GL165   GL565
Element: Company       The company number as defined in GL10.1   GL65.1  IFLR.1
                       (Company).

GTR-OLD-COMPANY        Alpha 35                                  GL165   GL565
Element: Old Company   The old company structure associated      GL65.1  IFLR.1
                       with the Lawson Company/Accounting Unit.



GTR-OLD-CPY-SHORT      Derived
Old Company Short      Contains the short description.
Description

GTR-STRING-COMPANY     Derived
Element: String CompanyDisplays the old company.

GTR-OLD-ACCT-NBR       Alpha 25                                  GL165   GL565
Element: Old Account NuThis is the old account structure to be   GL65.1  IFLR.1
                       associated with the new
                       account/subaccount within the Lawson
                       system.


GTR-OLD-ACCT-SHORT     Derived
Old Account Short      Contains the short description.
Description

GTR-SOURCE-CODE        Alpha 2                                   GL165   GL565
Element: Source Code   A two-character code assigned to a        GL65.1  IFLR.1
                       transaction to identify where the
                       transaction was created.


GTR-DATE               Numeric 8  (yyyymmdd)                     GL165   GL565
Element: Date          Contains the system creation date.        GL65.1  IFLR.1

GTR-REFERENCE          Alpha 10  (Lower Case)                    GL165   GL65.1
Element: Reference     The reference number associated with      IFLR.1
                       the transaction.

GTR-DESCRIPTION        Alpha 30  (Lower Case)                    GL165   GL565
Element: Description   Contains the transaction description.     GL65.1  IFLR.1

GTR-CURRENCY-CODE      Alpha 5                                   GL165   GL565
Element: Currency Code This field contains the company base      GL65.1  IFLR.1
                       currency code established in Company
                       (GL10.1 ).

GTR-UNITS-AMOUNT       Signed 15.2                               GL165   GL65.1
Element: Units Amount  Contains the transaction units amount.    IFLR.1

GTR-TRAN-AMOUNT        Signed 18.2                               GL165   GL565
Element: Transaction AmThis is the amount in transaction         GL65.1  IFLR.1
                       currency to be posted.


GTR-BASE-AMOUNT        Signed 18.2                               GL165   GL565
Element: Base Amount   The base amount to be posted to the       GL65.1  IFLR.1
                       General Ledger Master file. If left
                       blank, the interfacing program will use
                       the currency routine to calculate the
                       base amount using the transaction amount
                       and transaction currency code.


GTR-BASERATE           Signed 14.7                               GL165   GL565
Element: Base Rate     The exchange rate at the time the         GL65.1  IFLR.1
                       journal entry was made. If left blank,
                       the current exchange rate will default.


GTR-SYSTEM             Alpha 2                                   GL165   GL565
Element: System        A two-character code representing an      GL65.1  IFLR.1
                       application used within the Lawson
                       system. (i.e.: GL = General Ledger, AP =
                       Accounts Payable, etc.)

GTR-PROGRAM-CODE       Alpha 5                                   GL165   GL565
Element: Program Code  A program code used to identify where a   GL65.1  IFLR.1
                       transaction was created.


GTR-AUTO-REV           Alpha 1                                   GL165   GL565
Element: Auto Rev      Auto reversal is the process of           GL65.1  IFLR.1
                       reversing the transaction. If you select
                       auto reverse, the Lawson General Ledger
                       closing program creates a reversing
                       journal entry in the next period for
                       this transaction.

                       Y = Yes
                       N = No

GTR-POSTING-DATE       Numeric 8  (yyyymmdd)                     GL165   GL565
Element: Posting Date  The date assigned to the journal entry    GL65.1  IFLR.1
                       for posting.

GTR-ACTIVITY           Alpha 15                                  GL165   GL65.1
Element: Activity      Activities are the processes or           IFLR.1
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


GTR-ACCT-CATEGORY      Alpha 5                                   GL165   GL65.1
Element: Account CategoAccount categories are groupings of       IFLR.1
                       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

GTR-DOCUMENT-NBR       Alpha 27                                  GL165   GL65.1
Element: Document NumbeContains the document number.             IFLR.1

GTR-TO-BASE-AMT        Signed 18.2                               GL165   GL65.1
Element: To Base AmountContains the To Company base amount.      IFLR.1

GTR-EFFECT-DATE        Numeric 8  (yyyymmdd)                     GL165   GL65.1
Element: Effective DateThe effective date used for converting    IFLR.1
                       transactions when the Transaction
                       Conversion program is run.


GTR-JRNL-BOOK-NBR      Alpha 12                                  GL165   GL65.1
Element: Journal Book NThe journal book assigned to the          IFLR.1
                       transaction.

GTR-MX-VALUE           Alpha 32 Occurs 3 Times                   GL165   GL65.1
Element: Matrix Value  Contains the attribute value.             IFLR.1

GTR-MX-VALUE1          Derived
Element: Mx Value1     The attribute value associated with the
                       transaction.


GTR-MX-VALUE2          Derived
Element: Mx Value2     The attribute value associated with the
                       transaction.


GTR-MX-VALUE3          Derived
Element: Mx Value3     The attribute value associated with the
                       transaction.


GTR-JBK-SEQ-NBR        Numeric 10                                GL165   GL65.1
Element: Jbk Seq Nbr   The next available journal book           IFLR.1
                       sequence number assigned to an
                       interfaced transaction when added to the
                       Lawson system.


GTR-NEGATIVE-ADJ       Alpha 1                                   GL165   GL65.1
Element: Negative Adj  Indicates a negative adjustment for       IFLR.1
                       auto-reversing interfaced transactions;
                       used if you have defined your company as
                       requiring single type accounts.


GTR-SEGMENT-BLOCK      Alpha 103                                 GL165   GL65.1
Element: Segment Block This field identifies the user analysis   IFLR.1
                       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.

GTR-RPT-AMOUNT-1       Signed 18.2                               GL165   GL65.1
Element: Intl Amt                                                IFLR.1

GTR-RPT-RATE-1         Signed 14.7                               GL165   GL65.1
Element: Curr Rate     The currency rate.                        IFLR.1

GTR-RPT-ND-1           Numeric 1                                 GL165   GL65.1
Element: Acct Nd       The number of decimals assigned to a      IFLR.1
                       particular account as determined by the
                       account currency.


GTR-RPT-AMOUNT-2       Signed 18.2                               GL165   GL65.1
Element: Intl Amt                                                IFLR.1

GTR-RPT-RATE-2         Signed 14.7                               GL165   GL65.1
Element: Curr Rate     The currency rate.                        IFLR.1

GTR-RPT-ND-2           Numeric 1                                 GL165   GL65.1
Element: Acct Nd       The number of decimals assigned to a      IFLR.1
                       particular account as determined by the
                       account currency.


                         GLTRANSREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GTRSET1   RUN-GROUP                                              GL165   GL265
          SEQ-NUMBER                                             GL565   GL65.1
                                                                 IFLR.1

GTRSET2   COMPANY       KeyChange                                GL165
          OLD-COMPANY
          OLD-ACCT-NBR
          RUN-GROUP
          SEQ-NUMBER

GTRSET3   RUN-GROUP     KeyChange                                GL165
          COMPANY
          OLD-COMPANY
          OLD-ACCT-NBR
          SEQ-NUMBER

                         GLTRANSREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        GLSYSTEM     Required

                            GTR-COMPANY          -> GLS-COMPANY

Currency Code  CUCODES      Not Required

                            GTR-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Old Company    GLCOMPREL    Required

                            GTR-OLD-COMPANY      -> GCR-OLD-COMPANY

Source Code    GLCODES      Not Required

                            GTR-SOURCE-CODE      -> GCD-SOURCE-CODE

System Code    GLCODES      Not Required

                            GTR-COMPANY          -> GCD-COMPANY
                            GTR-SYSTEM           -> GCD-SYSTEM