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 GL65.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTR-RUN-GROUP Alpha 15 GL165 GL65.1
Run Group Run Group and Seq Number are the keys
to GLTRANSREL file. They should be used
to group records together for
interfacing.
GTR-SEQ-NUMBER Numeric 6 GL165 GL65.1
Sequence Number A unique number assigned to each
transaction to be transferred into the
Lawson system.
GTR-COMPANY Numeric 4 GL165 GL65.1
Company The company number as defined in GL10.1
(Company).
GTR-OLD-COMPANY Alpha 35 GL165 GL65.1
Old Company The old company structure associated
with the Lawson Company/Accounting Unit.
GTR-OLD-CPY-SHORT Derived
Old Company Short Contains the short description.
Description
GTR-STRING-COMPANY Derived
String Company Displays the old company.
GTR-OLD-ACCT-NBR Alpha 25 GL165 GL65.1
Old Account Number This is the old account structure to be
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 GL65.1
Source Code A two-character code assigned to a
transaction to identify where the
transaction was created.
GTR-DATE Numeric 8 (yyyymmdd) GL165 GL65.1
Date Contains the system creation date.
GTR-REFERENCE Alpha 10 (Lower Case) GL165 GL65.1
Reference The reference number associated with
the transaction.
GTR-DESCRIPTION Alpha 30 (Lower Case) GL165 GL65.1
Description Contains the transaction description.
GTR-CURRENCY-CODE Alpha 5 GL165 GL65.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
GTR-UNITS-AMOUNT Signed 15.2 GL165 GL65.1
Units Amount Contains the transaction units amount.
GTR-TRAN-AMOUNT Signed 15.2 GL165 GL65.1
Transaction Amount This is the amount in transaction
currency to be posted.
GTR-BASE-AMOUNT Signed 15.2 GL165 GL65.1
Base Amount The base amount to be posted to the
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 12.6 GL165 GL65.1
Base Rate The exchange rate at the time the
journal entry was made. If left blank,
the current exchange rate will default.
GTR-SYSTEM Alpha 2 GL165 GL65.1
System A two-character code representing an
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
GTR-PROGRAM-CODE Alpha 5 GL165 GL65.1
Program Code A program code used to identify where a
transaction was created.
GTR-AUTO-REV Alpha 1 GL165 GL65.1
Auto Reverse Auto reversal is the process of
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 GL65.1
Posting Date The date assigned to the journal entry
for posting.
GTR-ACTIVITY Alpha 15 GL165 GL65.1
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.
GTR-ACCT-CATEGORY Alpha 5 GL165 GL65.1
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.
GTR-DOCUMENT-NBR Alpha 27 GL165 GL65.1
Document Number Contains the document number.
GTR-TO-BASE-AMT Signed 15.2 GL165 GL65.1
To Base Amount Contains the To Company base amount.
GTR-EFFECT-DATE Numeric 8 (yyyymmdd) GL165 GL65.1
Effective Date The effective date used for converting
transactions when the Transaction
Conversion program is run.
GTR-JRNL-BOOK-NBR Alpha 12 GL165 GL65.1
Journal Book Number The journal book assigned to the
transaction.
GTR-MX-VALUE Alpha 32 Occurs 3 Times GL165 GL65.1
Matrix Value Contains the attribute value.
GTR-MX-VALUE1 Derived
Attribute Value The attribute value associated with the
transaction.
GTR-MX-VALUE2 Derived
Attribute Value The attribute value associated with the
transaction.
GTR-MX-VALUE3 Derived
Attribute Value The attribute value associated with the
transaction.
GTR-JBK-SEQ-NBR Numeric 10 GL165 GL65.1
Journal Book The next available journal book
Sequence Number sequence number assigned to an
interfaced transaction when added to the
Lawson system.
GTR-NEGATIVE-ADJ Alpha 1 GL65.1
Negative Adjustment Indicates a negative adjustment for
auto-reversing interfaced transactions;
used if you have defined your company as
requiring single type accounts.
GTR-SEGMENT-BLOCK Alpha 103 GL165 GL65.1
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.
GTR-RPT-AMOUNT-1 Signed 15.2 GL165 GL65.1
Report Currency 1 The transaction amount for Report
Amount Currency 1.
GTR-RPT-RATE-1 Signed 12.6 GL165 GL65.1
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).
GTR-RPT-ND-1 Numeric 1 GL165 GL65.1
Rpt Nd 1 The number of decimal positions for
Report Currency 1.
GTR-RPT-AMOUNT-2 Signed 15.2 GL165 GL65.1
Report Currency 2 The transaction amount for Report
Amount Currency 2.
GTR-RPT-RATE-2 Signed 12.6 GL165 GL65.1
Rpt Rate 2 The exchange rate to convert the
transaction amount to Report Currency 2.
The exchange rate is defined in CU10.1
(Exchange Rate).
GTR-RPT-ND-2 Numeric 1 GL165 GL65.1
Rpt Nd 2 The number of decimal positions for
Report Currency 2.
GLTRANSREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTRSET1 RUN-GROUP GL165 GL265
SEQ-NUMBER GL65.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
|
