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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GTR-RUN-GROUP PKRUN_GROUP | Alpha 15 | Run 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 PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-COMPANYCOMPANY | Numeric 4 | The company number as defined in GL10.1 (Company). | GL165, GL265, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-OLD-COMPANYOLD_COMPANY | Alpha 35 | The old company structure associated with the Lawson Company/Accounting Unit. | GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-OLD-CPY-SHORTOLD_CPY_SHORT | Derived | Contains the short description. | — |
GTR-STRING-COMPANYSTRING_COMPANY | Derived | Displays the old company. | — |
GTR-OLD-ACCT-NBROLD_ACCT_NBR | Alpha 25 | This 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-SHORTOLD_ACCT_SHORT | Derived | Contains the short description. | — |
GTR-SOURCE-CODESOURCE_CODE | Alpha 2 | A two-character code assigned to a transaction to identify where the transaction was created. | GL165, GL565, GL65.1, GL65.4, IFLR.1 |
GTR-DATEDATE | Numeric 8 (yyyymmdd) | Contains the system creation date. | GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-REFERENCEREFERENCE | Alpha 10 (Lower Case) | The reference number associated with the transaction. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the transaction description. | GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-UNITS-AMOUNTUNITS_AMOUNT | Signed 15.2 | Contains the transaction units amount. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-TRAN-AMOUNTTRAN_AMOUNT | Signed 18.2 | This is the amount in transaction currency to be posted. | GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-BASE-AMOUNTBASE_AMOUNT | Signed 18.2 | 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. | GL165, GL565, GL65.1, GL65.4, IFLR.1 |
GTR-BASERATEBASERATE | Signed 14.7 | The 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-SYSTEMSYSTEM | Alpha 2 | A 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-CODEPROGRAM_CODE | Alpha 5 | A program code used to identify where a transaction was created. | GL165, GL565, GL65.1, GL65.4, IFLR.1 |
GTR-AUTO-REVAUTO_REV | Alpha 1 | 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.
| GL165, GL565, GL65.1, GL65.4, IFLR.1 |
GTR-POSTING-DATEPOSTING_DATE | Numeric 8 (yyyymmdd) | The date assigned to the journal entry for posting. | GL165, GL565, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-ACTIVITYACTIVITY | Alpha 15 | Activities 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-CATEGORYACCT_CATEGORY | Alpha 5 | 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. Valid account category types are: cost revenue accrual pass thru | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-DOCUMENT-NBRDOCUMENT_NBR | Alpha 27 | Contains the document number. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | Contains the To Company base amount. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-EFFECT-DATEEFFECT_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-NBRJRNL_BOOK_NBR | Alpha 12 | The journal book assigned to the transaction. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-MX-VALUEMX_VALUE | Alpha 32 Occurs 3 Times ×3 | Contains the attribute value. | GL165, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-MX-VALUE1MX_VALUE1 | Derived | The attribute value associated with the transaction. | — |
GTR-MX-VALUE2MX_VALUE2 | Derived | The attribute value associated with the transaction. | — |
GTR-MX-VALUE3MX_VALUE3 | Derived | The attribute value associated with the transaction. | — |
GTR-JBK-SEQ-NBRJBK_SEQ_NBR | Numeric 10 | The 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-ADJNEGATIVE_ADJ | Alpha 1 | Indicates 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-BLOCKSEGMENT_BLOCK | Alpha 103 | 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. | GL165, GL65.1, GL65.4, GLDT.1, IFLR.1 |
GTR-RPT-AMOUNT-1RPT_AMOUNT_1 | Signed 18.2 | — | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-RPT-RATE-1RPT_RATE_1 | Signed 14.7 | The currency rate. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-RPT-ND-1RPT_ND_1 | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-RPT-AMOUNT-2RPT_AMOUNT_2 | Signed 18.2 | — | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-RPT-RATE-2RPT_RATE_2 | Signed 14.7 | The currency rate. | GL165, GL65.1, GL65.4, IFLR.1 |
GTR-RPT-ND-2RPT_ND_2 | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | GL165, GL65.1, GL65.4, IFLR.1 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GTRSET1 | RUN-GROUP, SEQ-NUMBER | Primary | GL122, GL165, GL265, GL565, GL65.1, GL65.4, GLBO.2, GLDT.1 +22 more (list truncated in source) | |
GTRSET2 | COMPANY, OLD-COMPANY, OLD-ACCT-NBR, RUN-GROUP, SEQ-NUMBER | KeyChange | GL165 | |
GTRSET3 | RUN-GROUP, COMPANY, OLD-COMPANY, OLD-ACCT-NBR, SEQ-NUMBER | KeyChange | GL165 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | GLSYSTEM | Required | GTR-COMPANY → GLS-COMPANY | |
| Currency Code | CUCODES | Not Required | GTR-CURRENCY-CODE → CUC-CURRENCY-CODE | |
| Gltrnrlbod | GLTRNRLBOD | Not Required, Delete Cascades | GTR-RUN-GROUP → YCA-RUN-GROUP, GTR-SEQ-NUMBER → YCA-SEQ-NUMBER | |
| 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 |
Programs
Updated by (6)
- GL165 Transaction Interface
- GL565 Treasury Management to GL Upload
- GL65.1 Transaction Interface Maintenance
- GL65.4 Transaction Maintenance
- GLDT.1 Calculate posting date from year period
- IFLR.1 GLTRANSREL Speed Load from BCI
Referenced by (30)
- CU01.1 Currency Code
- CU01.2 Currency Codes
- CU02.1 Currency Relationship
- CU02.2 Relationship Summary
- CU03.1 Currency Gain Loss Accounts
- CU10.1 Exchange Rates
- CU10.2 Daily Rate Entry
- CU20.1 Currency Table Translation Rates
- CU20.3 Company Translation Rates
- GL00.1 Chart of Accounts
- GL00.2 Define Chart
- GL00.3 Detail Accounts
- GL00.6 Move Detail Account
- GL00.7 System Accounts
- GL00.8 Rename Summary Account
- GL00.9 Chart Copy
- GL02.1 Detail Subaccount Definition
- GL02.2 Multiple Detail Subaccount Definition
- GL02.3 Template Subaccount Definition
- GL02.6 Move Detail Account
- GL03.2 Move Summary Account
- GL03.4 Summary Account System Restriction
- GL10.1 Company
- GL121 Mass Account Addition
- GL122 Mass Account Change Delete
- GL20.1 Accounting Units - Accounts
- GL20.2 Posting Accounts
- GL20.4 Mass Add Accounts
- GL265 Transaction Interface Listing
- GLBO.2 GL BOD Inquiry