GLTRANSREL – GL Transaction Conversion

System
General Ledger (GL)
Prefix
GTR
Primary key
RUN-GROUP, SEQ-NUMBER
Fields
40
Updated by
6 programs
Referenced by
30 programs

GLTRANSREL is the GL Transaction Conversion table in Lawson General Ledger (prefix GTR). It is indexed by RUN-GROUP, SEQ-NUMBER (GTRSET1); alternate indexes: GTRSET2 and GTRSET3. It is related 1:1 to GLSYSTEM, CUCODES, GLTRNRLBOD, GLCOMPREL and GLCODES. It is updated by GL165, GL565, GL65.1, GL65.4, GLDT.1 and IFLR.1 and referenced by CU01.1, CU01.2, CU02.1, CU02.2, CU03.1, CU10.1, CU10.2, CU20.1 and 22 more. The table has 40 fields, 3 indexes and 6 documented relations.

About GLTRANSREL

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

Fields (40)

Column = COBOL field name without the GTR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GTR-RUN-GROUP PK
RUN_GROUP		Alpha 15Run Group and Seq Number are the keys to GLTRANSREL file. They should be used to group records together for interfacing.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-COMPANY SET2 SET3
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL165, GL265, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-OLD-COMPANY SET2 SET3
OLD_COMPANY		Alpha 35The old company structure associated with the Lawson Company/Accounting Unit.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-OLD-CPY-SHORT
OLD_CPY_SHORT		DerivedContains the short description.—
#GTR-STRING-COMPANY
STRING_COMPANY		DerivedDisplays the old company.—
#GTR-OLD-ACCT-NBR SET2 SET3
OLD_ACCT_NBR		Alpha 25This is the old account structure to be associated with the new account/subaccount within the Lawson system.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-OLD-ACCT-SHORT
OLD_ACCT_SHORT		DerivedContains the short description.—
#GTR-SOURCE-CODE
SOURCE_CODE		Alpha 2A two-character code assigned to a transaction to identify where the transaction was created.GL165, GL565, GL65.1, GL65.4, IFLR.1
#GTR-DATE
DATE		Numeric 8 (yyyymmdd)Contains the system creation date.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-REFERENCE
REFERENCE		Alpha 10 (Lower Case)The reference number associated with the transaction.GL165, GL65.1, GL65.4, IFLR.1
#GTR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the transaction description.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-UNITS-AMOUNT
UNITS_AMOUNT		Signed 15.2Contains the transaction units amount.GL165, GL65.1, GL65.4, IFLR.1
#GTR-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2This is the amount in transaction currency to be posted.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-BASE-AMOUNT
BASE_AMOUNT		Signed 18.2The 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.GL165, GL565, GL65.1, GL65.4, IFLR.1
#GTR-BASERATE
BASERATE		Signed 14.7The exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default.GL165, GL565, GL65.1, GL65.4, IFLR.1
#GTR-SYSTEM
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)GL165, GL565, GL65.1, GL65.4, IFLR.1
#GTR-PROGRAM-CODE
PROGRAM_CODE		Alpha 5A program code used to identify where a transaction was created.GL165, GL565, GL65.1, GL65.4, IFLR.1
#GTR-AUTO-REV
AUTO_REV		Alpha 1Auto 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
GL165, GL565, GL65.1, GL65.4, IFLR.1
#GTR-POSTING-DATE
POSTING_DATE		Numeric 8 (yyyymmdd)The date assigned to the journal entry for posting.GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.GL165, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 thruGL165, GL65.1, GL65.4, IFLR.1
#GTR-DOCUMENT-NBR
DOCUMENT_NBR		Alpha 27Contains the document number.GL165, GL65.1, GL65.4, IFLR.1
#GTR-TO-BASE-AMT
TO_BASE_AMT		Signed 18.2Contains the To Company base amount.GL165, GL65.1, GL65.4, IFLR.1
#GTR-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)The effective date used for converting transactions when the Transaction Conversion program is run.GL165, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.GL165, GL65.1, GL65.4, IFLR.1
#GTR-MX-VALUE
MX_VALUE		Alpha 32 Occurs 3 Times ×3Contains the attribute value.GL165, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-MX-VALUE1
MX_VALUE1		DerivedThe attribute value associated with the transaction.—
#GTR-MX-VALUE2
MX_VALUE2		DerivedThe attribute value associated with the transaction.—
#GTR-MX-VALUE3
MX_VALUE3		DerivedThe attribute value associated with the transaction.—
#GTR-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The next available journal book sequence number assigned to an interfaced transaction when added to the Lawson system.GL165, GL65.1, GL65.4, IFLR.1
#GTR-NEGATIVE-ADJ
NEGATIVE_ADJ		Alpha 1Indicates a negative adjustment for auto-reversing interfaced transactions; used if you have defined your company as requiring single type accounts.GL165, GL65.1, GL65.4, IFLR.1
#GTR-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This 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.GL165, GL65.1, GL65.4, GLDT.1, IFLR.1
#GTR-RPT-AMOUNT-1
RPT_AMOUNT_1		Signed 18.2—GL165, GL65.1, GL65.4, IFLR.1
#GTR-RPT-RATE-1
RPT_RATE_1		Signed 14.7The currency rate.GL165, GL65.1, GL65.4, IFLR.1
#GTR-RPT-ND-1
RPT_ND_1		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL165, GL65.1, GL65.4, IFLR.1
#GTR-RPT-AMOUNT-2
RPT_AMOUNT_2		Signed 18.2—GL165, GL65.1, GL65.4, IFLR.1
#GTR-RPT-RATE-2
RPT_RATE_2		Signed 14.7The currency rate.GL165, GL65.1, GL65.4, IFLR.1
#GTR-RPT-ND-2
RPT_ND_2		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL165, GL65.1, GL65.4, IFLR.1

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GTRSET1
  1. RUN-GROUP
  2. SEQ-NUMBER
PrimaryGL122, GL165, GL265, GL565, GL65.1, GL65.4, GLBO.2, GLDT.1 +22 more (list truncated in source)
GTRSET2
  1. COMPANY
  2. OLD-COMPANY
  3. OLD-ACCT-NBR
  4. RUN-GROUP
  5. SEQ-NUMBER
KeyChangeGL165
GTRSET3
  1. RUN-GROUP
  2. COMPANY
  3. OLD-COMPANY
  4. OLD-ACCT-NBR
  5. SEQ-NUMBER
KeyChangeGL165

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLSYSTEMCUCODESGLTRNRLBODGLCOMPRELGLCODESGLTRANSREL

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequired
GTR-COMPANY→GLS-COMPANY
Currency CodeCUCODESNot Required
GTR-CURRENCY-CODE→CUC-CURRENCY-CODE
GltrnrlbodGLTRNRLBODNot Required, Delete Cascades
GTR-RUN-GROUP→YCA-RUN-GROUP
GTR-SEQ-NUMBER→YCA-SEQ-NUMBER
Old CompanyGLCOMPRELRequired
GTR-OLD-COMPANY→GCR-OLD-COMPANY
Source CodeGLCODESNot Required
GTR-SOURCE-CODE→GCD-SOURCE-CODE
System CodeGLCODESNot Required
GTR-COMPANY→GCD-COMPANY
GTR-SYSTEM→GCD-SYSTEM

Programs

Updated by (6)

Referenced by (30)