|
|
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 GL950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTR-RUN-GROUP Alpha 12 GL65.1 GL950
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 GL65.1 GL950
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 GL950
(Company).
GTR-OLD-COMPANY Alpha 35 GL65.1 GL950
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
Company Displays the old company.
GTR-OLD-ACCT-NBR Alpha 25 GL65.1 GL950
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 GL950
transaction to identify where the
transaction was created.
GTR-DATE Numeric 8 (yyyymmdd) GL165 GL65.1
Date Contains the system creation date. GL950
GTR-REFERENCE Alpha 10 (Lower Case) GL65.1 GL950
Reference The reference number associated with
the transaction.
GTR-DESCRIPTION Alpha 30 (Lower Case) GL165 GL65.1
Description Contains the transaction description. GL950
GTR-CURRENCY-CODE Alpha 5 GL165 GL65.1
Currency Code This field contains the company base GL950
currency code established in GL10.1
(Company).
GTR-UNITS-AMOUNT Signed 15.2 GL65.1 GL950
Units Amount Contains the transaction units amount.
GTR-TRAN-AMOUNT Signed 15.2 GL65.1 GL950
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 GL950
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 GL950
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 GL950
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 GL950
transaction was created.
GTR-AUTO-REV Alpha 1 GL165 GL65.1
Auto Reversal Auto reversal is the process of GL950
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) GL65.1 GL950
Posting Date The date assigned to the journal entry
for posting.
GTR-ACTIVITY Alpha 15 GL65.1 GL950
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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
GTR-ACCT-CATEGORY Alpha 5 GL165 GL65.1
Account Category Account categories are groupings of GL950
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 24 GL65.1 GL950
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. GL950
GTR-EFFECT-DATE Numeric 8 (yyyymmdd) GL65.1 GL950
Effective Date The effective date used for converting
transactions when the Transaction
Conversion program is run.
GTR-JRNL-BOOK-NBR Alpha 12 GL65.1 GL950
Journal Book Number The journal book assigned to the
transaction.
GTR-MX-VALUE Alpha 20 Occurs 3 Times GL165 GL65.1
Attribute Value Contains the attribute value. GL950
GTR-MX-VALUE1 Derived
Attribute Value 1 The attribute value associated with the
transaction.
GTR-MX-VALUE2 Derived
Attribute Value 2 The attribute value associated with the
transaction.
GTR-MX-VALUE3 Derived
Attribute Value 3 The attribute value associated with the
transaction.
GTR-JBK-SEQ-NBR Numeric 10 GL65.1 GL950
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 GL165 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 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 GL65.1
Report Currency 1 The transaction amount for Report
Amount Currency 1.
GTR-RPT-RATE-1 Signed 12.6 GL65.1
Exchange Rate 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 GL65.1
Report Currency 1 The number of decimal positions for
Code Report Currency 1.
GTR-RPT-AMOUNT-2 Signed 15.2 GL65.1
Report Currency 2 The transaction amount for Report
Amount Currency 2.
GTR-RPT-RATE-2 Signed 12.6 GL65.1
Exchange Rate 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 GL65.1
Report Currency 2 The number of decimal positions for
Code 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
|