|
|
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
GL565 GL65.1 GL165
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
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
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
(Company).
GTR-OLD-COMPANY Alpha 35 GL165 GL565
Element: Old Company The old company structure associated GL65.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
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
transaction to identify where the
transaction was created.
GTR-DATE Numeric 8 (yyyymmdd) GL165 GL565
Element: Date Contains the system creation date. GL65.1
GTR-REFERENCE Alpha 10 (Lower Case) GL165 GL65.1
Element: Reference The reference number associated with
the transaction.
GTR-DESCRIPTION Alpha 30 (Lower Case) GL165 GL565
Element: Description Contains the transaction description. GL65.1
GTR-CURRENCY-CODE Alpha 5 GL165 GL565
Element: Currency Code This field contains the company base GL65.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.
GTR-TRAN-AMOUNT Signed 18.2 GL165 GL565
Element: Transaction AmThis is the amount in transaction GL65.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
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
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
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
transaction was created.
GTR-AUTO-REV Alpha 1 GL165 GL565
Element: Auto Reverse Auto reversal is the process of GL65.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
for posting.
GTR-ACTIVITY Alpha 15 GL165 GL65.1
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.
GTR-ACCT-CATEGORY Alpha 5 GL165 GL65.1
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.
Valid account category types are:
cost
revenue
accrual
pass thru
GTR-DOCUMENT-NBR Alpha 27 GL165 GL65.1
Element: Document NumbeContains the document number.
GTR-TO-BASE-AMT Signed 18.2 GL165 GL65.1
Element: To Base AmountContains the To Company base amount.
GTR-EFFECT-DATE Numeric 8 (yyyymmdd) GL165 GL65.1
Element: Effective DateThe effective date used for converting
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
transaction.
GTR-MX-VALUE Alpha 32 Occurs 3 Times GL165 GL65.1
Element: Matrix Value Contains the attribute value.
GTR-MX-VALUE1 Derived
Element: Attribute ValuThe attribute value associated with the
transaction.
GTR-MX-VALUE2 Derived
Element: Attribute ValuThe attribute value associated with the
transaction.
GTR-MX-VALUE3 Derived
Element: Attribute ValuThe 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 GL165 GL65.1
Element: Negative AdjusIndicates 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
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.
GTR-RPT-AMOUNT-1 Signed 18.2 GL165 GL65.1
Element: Intl Amt The transaction amount for Report
Currency 1.
GTR-RPT-RATE-1 Signed 14.7 GL165 GL65.1
Element: Currency 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 GL165 GL65.1
Account Currency The number of decimal positions for
Code Report Currency 1.
GTR-RPT-AMOUNT-2 Signed 18.2 GL165 GL65.1
Element: Intl Amt The transaction amount for Report
Currency 2.
GTR-RPT-RATE-2 Signed 14.7 GL165 GL65.1
Element: Currency 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 GL165 GL65.1
Account Currency 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 GL565 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
|
