GLTRANSREL

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).
UPDATED BY
GL165 GL565 GL65.1 IFLR.1 GL265

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTR-RUN-GROUP
Element: Run 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 IFLR.1
GTR-SEQ-NUMBER
Element: Sequence Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
GL165 GL565
GL65.1 IFLR.1
GTR-COMPANY
Element: Company
Numeric 4
The company number as defined in GL10.1 (Company).
GL165 GL265
GL565 GL65.1
IFLR.1
GTR-OLD-COMPANY
Element: Old Company
Alpha 35
The old company structure associated with the Lawson Company/Accounting Unit.
GL165 GL565
GL65.1 IFLR.1
GTR-OLD-CPY-SHORT
Old Company Short
Description
Derived
Contains the short description.
GTR-STRING-COMPANY
Element: String Company
Derived
Displays the old company.
GTR-OLD-ACCT-NBR
Element: Old Account Number
Alpha 25
This is the old account structure to be associated with the new account/subaccount within the Lawson system.
GL165 GL565
GL65.1 IFLR.1
GTR-OLD-ACCT-SHORT
Old Account Short
Description
Derived
Contains the short description.
GTR-SOURCE-CODE
Element: Source Code
Alpha 2
A two-character code assigned to a transaction to identify where the transaction was created.
GL165 GL565
GL65.1 IFLR.1
GTR-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the system creation date.
GL165 GL565
GL65.1 IFLR.1
GTR-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
GL165 GL65.1
IFLR.1
GTR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the transaction description.
GL165 GL565
GL65.1 IFLR.1
GTR-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
GL165 GL565
GL65.1 IFLR.1
GTR-UNITS-AMOUNT
Element: Units Amount
Signed 15.2
Contains the transaction units amount.
GL165 GL65.1
IFLR.1
GTR-TRAN-AMOUNT
Element: Transaction Amount
Signed 18.2
This is the amount in transaction currency to be posted.
GL165 GL565
GL65.1 IFLR.1
GTR-BASE-AMOUNT
Element: Base 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 IFLR.1
GTR-BASERATE
Element: Base Rate
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 IFLR.1
GTR-SYSTEM
Element: System
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 IFLR.1
GTR-PROGRAM-CODE
Element: Program Code
Alpha 5
A program code used to identify where a transaction was created.
GL165 GL565
GL65.1 IFLR.1
GTR-AUTO-REV
Element: Auto 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.
Y = Yes
N = No
GL165 GL565
GL65.1 IFLR.1
GTR-POSTING-DATE
Element: Posting Date
Numeric 8 (yyyymmdd)
The date assigned to the journal entry for posting.
GL165 GL565
GL65.1 IFLR.1
GTR-ACTIVITY
Element: Activity
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
IFLR.1
GTR-ACCT-CATEGORY
Element: Account 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
IFLR.1
GTR-DOCUMENT-NBR
Element: Document Number
Alpha 27
Contains the document number.
GL165 GL65.1
IFLR.1
GTR-TO-BASE-AMT
Element: To Base Amount
Signed 18.2
Contains the To Company base amount.
GL165 GL65.1
IFLR.1
GTR-EFFECT-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The effective date used for converting transactions when the Transaction Conversion program is run.
GL165 GL65.1
IFLR.1
GTR-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
The journal book assigned to the transaction.
GL165 GL65.1
IFLR.1
GTR-MX-VALUE
Element: Matrix Value
Alpha 32 Occurs 3 Times
Contains the attribute value.
GL165 GL65.1
IFLR.1
GTR-MX-VALUE1
Element: Mx Value1
Derived
The attribute value associated with the transaction.
GTR-MX-VALUE2
Element: Mx Value2
Derived
The attribute value associated with the transaction.
GTR-MX-VALUE3
Element: Mx Value3
Derived
The attribute value associated with the transaction.
GTR-JBK-SEQ-NBR
Element: Jbk 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
IFLR.1
GTR-NEGATIVE-ADJ
Element: Negative 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
IFLR.1
GTR-SEGMENT-BLOCK
Element: Segment 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
IFLR.1
GTR-RPT-AMOUNT-1
Element: Intl Amt
Signed 18.2
GL165 GL65.1
IFLR.1
GTR-RPT-RATE-1
Element: Curr Rate
Signed 14.7
The currency rate.
GL165 GL65.1
IFLR.1
GTR-RPT-ND-1
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL165 GL65.1
IFLR.1
GTR-RPT-AMOUNT-2
Element: Intl Amt
Signed 18.2
GL165 GL65.1
IFLR.1
GTR-RPT-RATE-2
Element: Curr Rate
Signed 14.7
The currency rate.
GL165 GL65.1
IFLR.1
GTR-RPT-ND-2
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL165 GL65.1
IFLR.1


GLTRANSREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTRSET1 RUN-GROUP
SEQ-NUMBER
GL165 GL265
GL565 GL65.1
IFLR.1
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


GLTRANSREL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:48:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.