Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLREMOTETX


                            GLREMOTETX FILE

                           GL Remote Transfer

This file is used to collect General Ledger and Activity transactions from a
remote site machine. This file is populated by transferring the General Ledger
transaction CSV file from the remote site into this database file for
processing on this target machine.


UPDATED BY

GL311

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GTX-MACHINE-CODE       Alpha 12
Element: Machine Code  Designates a code name associated with
                       a  particular machine in a multiple
                       machine environment.


GTX-OBJ-ID             Numeric 12
Element: Obj ID        This is the transaction identifier. It
                       is  used to keep a record unique from
                       other records originating from the same
                       Machine Code.


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

GTX-PROGRAM            Alpha 5
Element: Program       Designates the program this record was
                       created by.


GTX-SUMMARIZE          Alpha 1
Element: Summarize     Determines whether transactions should
                       be summarized to the General Ledger or
                       if one General Ledger transaction should
                       be created for each record in this file.


                       Y = Summarize
                       N = Detail

GTX-COMPANY            Numeric 4
Element: Company       The company number as defined in GL10.1
                       (Company).


GTX-POSTING-DATE       Numeric 8  (yyyymmdd)
Element: Date

GTX-ZONE-ACCTUNIT      Alpha 15
Element: Zone Accounting Unit

GTX-CNTRL-DOCUMENT     Alpha 27
Element: Control DocumeThis is the Document Number used to
                       group transactions into the same Journal
                       Entry if Journal by Document is
                       selected.


GTX-JRNL-BOOK-NBR      Alpha 12
Element: Journal Book NThe journal book assigned to the
                       transaction.

GTX-JE-TYPE            Alpha 1
Element: Journal Entry The type of journal entry. Valid values
                       are Normal or Intercompany.

                       N = Normal
                       I = Intercompany

GTX-TO-COMPANY         Numeric 4
Element: To Company    This is the company number a line is
                       posted to.


GTX-SOURCE-CODE        Alpha 2
Element: Source Code   A two-character code assigned to a
                       transaction to identify where the
                       transaction was created.


GTX-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.


GTX-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.

GTX-SUB-ACCOUNT        Numeric 4
Element: Subaccount    This field along with the accounting
                       unit and account make up the location
                       (account) where amounts and other
                       account information are stored.


GTX-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.


GTX-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.

GTX-CURRENCY-CODE      Alpha 5
Element: Currency Code This identifies the company base
                       currency code as defined in CU01.1
                       (Currency Code).


GTX-DATE               Numeric 8  (yyyymmdd)
Element: Date          This field contains the system date the
                       record was created.


GTX-SUMMARY-CNTRL      Alpha 20
Element: Summary ControThis field provides a break down of
                       transaction summarization's to a finer
                       level of detail. Two transactions with
                       different Summary Control values will
                       not be summarized.


GTX-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.



GTX-ANALYSIS-FLD       Alpha 32 Occurs 3 Times
Element: Analysis FieldThe user-defined analysis field
                       assigned to the transaction based on the
                       transaction's source code.


GTX-SIGN               Alpha 1
Element: Sign          Indicates the sign type.
                       0 = Negative Sign
                       1 = Positive Sign

GTX-RESOURCE-TYPE      Alpha 1
Element: Resource Type Indicates whether the resource is a
                       person or equipment.


GTX-RESOURCE           Alpha 10
Element: Resource      This is the resource description.

GTX-FORCE-DETAIL       Alpha 1
Element: Force Detail  Determines whether this individual
                       transaction can be summarized along with
                       other like transactions.

                       Y = Detail
                       A = Sign Summary
                       " " = Summarize

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

GTX-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   The reference description.

GTX-DOCUMENT-NBR       Alpha 27
Element: Document NumbeThe document number assigned to the
                       transaction.


GTX-BASE-AMOUNT        Signed 15.2
Element: Base Amount   The base amount to be posted to the
                       General Ledger Master file.


GTX-BASE-ND            Numeric 1
Element: Base ND

GTX-BASERATE           Signed 12.6
Element: Base Rate     The exchange rate at the time the
                       journal entry was made.  If left blank,
                       the current exchange rate will default.


GTX-TO-BASE-AMT        Signed 15.2
Element: To Base AmountThis is the To Company's base currency
                       amount.


GTX-TO-BASE-ND         Numeric 1
Element: To Base ND    This is the To Company's base currency
                       number of decimals.


GTX-TO-BASERATE        Signed 12.6
Element: To Base Rate  This is the Exchange Rate used to
                       convert the transaction's currency
                       amount to the To Company's Base
                       Currency.


GTX-TRAN-AMOUNT        Signed 15.2
Element: Tran Amount

GTX-TRAN-ND            Numeric 1
Element: Tran ND

GTX-ACCT-CURRENCY      Alpha 5
Element: Account CurrenThis is the base currency of the
                       General Ledger account number.


GTX-ACCT-AMOUNT        Signed 15.2
Element: Account AmountThis is the amount of the transaction
                       in the General Ledger account's base
                       currency.


GTX-ACCT-RATE          Signed 12.6
Element: Account Rate  This is the Exchange Rate used to
                       convert the transaction currency to the
                       General Ledger account's base currency.


GTX-ACCT-ND            Numeric 1
Element: Account ND    The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


GTX-UNITS-AMOUNT       Signed 15.2
Element: Units Amount  The units amount of the transaction.

GTX-EFFECT-DATE        Numeric 8  (yyyymmdd)
Element: Date          This is the date the transaction is
                       effective for Average Daily Balance.


GTX-PROGRAM-INFO       Alpha 100
Element: Program Info  This field contains the keys to the
                       record from the originating file.


GTX-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.

GTX-RPT-AMOUNT-1       Signed 15.2
Element: Adj Amt

GTX-RPT-RATE-1         Signed 12.6
Element: Rpt Rate 1    The exchange rate to convert the
                       transaction amount to Report Currency 1.
                       The exchange rate is defined in CU10.1
                       (Exchange Rate).

GTX-RPT-ND-1           Numeric 1
Account Currency
Code

GTX-RPT-AMOUNT-2       Signed 15.2
Report Currency 2      The transaction amount for Report
Amount                 Currency 2.

GTX-RPT-RATE-2         Signed 12.6
Element: Rpt Rate 1

GTX-RPT-ND-2           Numeric 1
Element: Rpt Nd 2      The number of decimal positions for
                       Report Currency 2.


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

                         GLREMOTETX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GTXSET1   MACHINE-CODE
          OBJ-ID

GTXSET2   MACHINE-CODE  KeyChange                                GL311
          SYSTEM
          PROGRAM
          SUMMARIZE
          OBJ-ID
          COMPANY

GTXSET3   COMPANY       KeyChange
          MACHINE-CODE
          OBJ-ID