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
| GL165 | GL565 | GL65.1 | GL65.4 | GLDT.1 | IFLR.1 |
| 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. |
|
||||||||
| GTR-SEQ-NUMBER Element: Sequence Number | Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system. |
|
||||||||
| GTR-COMPANY Element: Company | Numeric 4 The company number as defined in GL10.1 (Company). |
|
||||||||
| GTR-OLD-COMPANY Element: Old Company | Alpha 35 The old company structure associated with the Lawson Company/Accounting Unit. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| GTR-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the system creation date. |
|
||||||||
| GTR-REFERENCE Element: Reference | Alpha 10 (Lower Case) The reference number associated with the transaction. |
|
||||||||
| GTR-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Contains the transaction description. |
|
||||||||
| GTR-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||
| GTR-UNITS-AMOUNT Element: Units Amount | Signed 15.2 Contains the transaction units amount. |
|
||||||||
| GTR-TRAN-AMOUNT Element: Transaction Amount | Signed 18.2 This is the amount in transaction currency to be posted. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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.) |
|
||||||||
| GTR-PROGRAM-CODE Element: Program Code | Alpha 5 A program code used to identify where a transaction was created. |
|
||||||||
| 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 |
|
||||||||
| GTR-POSTING-DATE Element: Posting Date | Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting. |
|
||||||||
| 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. |
|
||||||||
| 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 |
|
||||||||
| GTR-DOCUMENT-NBR Element: Document Number | Alpha 27 Contains the document number. |
|
||||||||
| GTR-TO-BASE-AMT Element: To Base Amount | Signed 18.2 Contains the To Company base amount. |
|
||||||||
| GTR-EFFECT-DATE Element: Effective Date | Numeric 8 (yyyymmdd) The effective date used for converting transactions when the Transaction Conversion program is run. |
|
||||||||
| GTR-JRNL-BOOK-NBR Element: Journal Book Number | Alpha 12 The journal book assigned to the transaction. |
|
||||||||
| GTR-MX-VALUE Element: Matrix Value | Alpha 32 Occurs 3 Times Contains the attribute value. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| GTR-RPT-AMOUNT-1 Element: Intl Amt | Signed 18.2 |
|
||||||||
| GTR-RPT-RATE-1 Element: Curr Rate | Signed 14.7 The currency rate. |
|
||||||||
| GTR-RPT-ND-1 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||
| GTR-RPT-AMOUNT-2 Element: Intl Amt | Signed 18.2 |
|
||||||||
| GTR-RPT-RATE-2 Element: Curr Rate | Signed 14.7 The currency rate. |
|
||||||||
| GTR-RPT-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GTRSET1 |
RUN-GROUP SEQ-NUMBER |
|
|||||||||
| GTRSET2 |
COMPANY OLD-COMPANY OLD-ACCT-NBR RUN-GROUP SEQ-NUMBER |
|
| ||||||||
| GTRSET3 |
RUN-GROUP COMPANY OLD-COMPANY OLD-ACCT-NBR SEQ-NUMBER |
|
| ||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Company | GLSYSTEM |
Required
| ||||||
| Currency Code | CUCODES |
Not Required
| ||||||
| Gltrnrlbod | GLTRNRLBOD |
Not Required, Delete Cascades
| ||||||
| Old Company | GLCOMPREL |
Required
| ||||||
| Source Code | GLCODES |
Not Required
| ||||||
| System Code | GLCODES |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.