GLREMOTETX – GL Remote Transfer
- System
- General Ledger Setup (IF)
- Prefix
GTX- Primary key
MACHINE-CODE,OBJ-ID- Fields
- 53
- Updated by
- 1 program
- Referenced by
- 0 programs
GLREMOTETX is the GL Remote Transfer table in Lawson General Ledger Setup (prefix GTX). It is indexed by MACHINE-CODE, OBJ-ID (GTXSET1); alternate indexes: GTXSET2. It is updated by GL311. The table has 53 fields, 2 indexes and 0 documented relations.
About GLREMOTETX
No description in the Lawson data dictionary.
Fields (53)
Column = COBOL field name without the GTX- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#GTX-MACHINE-CODE PKMACHINE_CODE | Alpha 12 | Designates a code name associated with a particular machine in a multiple machine environment. | — |
#GTX-OBJ-ID PKOBJ_ID | Numeric 12 | This is the transaction identifier. It is used to keep a record unique from other records originating from the same Machine Code. | — |
#GTX-SYSTEM SET2SYSTEM | Alpha 2 | A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.) | — |
#GTX-PROGRAM SET2PROGRAM | Alpha 5 | Designates the program this record was created by. | — |
#GTX-SUMMARIZE SET2SUMMARIZE | Alpha 1 | Determines whether transactions should be summarized to the General Ledger or if one General Ledger transaction should be created for each record in this file.
| — |
#GTX-COMPANY SET2COMPANY | Numeric 4 | The company number as defined in GL10.1 (Company). | — |
#GTX-POSTING-DATEPOSTING_DATE | Numeric 8 (yyyymmdd) | The date assigned to the journal entry for posting. | — |
#GTX-ZONE-ACCTUNITZONE_ACCTUNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | — |
#GTX-CNTRL-DOCUMENTCNTRL_DOCUMENT | Alpha 27 | This is the Document Number used to group transactions into the same Journal Entry if Journal by Document is selected. | — |
#GTX-JRNL-BOOK-NBRJRNL_BOOK_NBR | Alpha 12 | The journal book assigned to the transaction. | — |
#GTX-JE-TYPEJE_TYPE | Alpha 1 | The type of journal entry. Valid values are Normal or Intercompany.
| — |
#GTX-TO-COMPANYTO_COMPANY | Numeric 4 | This is the company number a line is posted to. | — |
#GTX-SOURCE-CODESOURCE_CODE | Alpha 2 | A two-character code assigned to a transaction to identify where the transaction was created. | — |
#GTX-ACCT-UNITACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | — |
#GTX-ACCOUNTACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | — |
#GTX-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | This field along with the accounting unit and account make up the location (account) where amounts and other account information are stored. | — |
#GTX-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. | — |
#GTX-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 | — |
#GTX-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This identifies the company base currency code as defined in CU01.1 (Currency Code). | — |
#GTX-DATEDATE | Numeric 8 (yyyymmdd) | This field contains the system date the record was created. | — |
#GTX-SUMMARY-CNTRLSUMMARY_CNTRL | Alpha 20 | This field provides a break down of transaction summarization's to a finer level of detail. Two transactions with different Summary Control values will not be summarized. | — |
#GTX-AUTO-REVAUTO_REV | Alpha 1 | When the Auto Reversal field is set to "Y," the Lawson General Ledger Closing program GL199 creates an opposite entry for this transaction in the next period. | — |
#GTX-ANALYSIS-FLDANALYSIS_FLD | Alpha 32 Occurs 3 Times ×3 | The user-defined analysis field assigned to the transaction based on the transaction's source code. | — |
#GTX-SIGNSIGN | Alpha 1 | Indicates the sign type.
| — |
#GTX-RESOURCE-TYPERESOURCE_TYPE | Alpha 1 | Indicates whether the resource is a person or equipment. | — |
#GTX-RESOURCERESOURCE | Alpha 10 | This is the resource description. | — |
#GTX-FORCE-DETAILFORCE_DETAIL | Alpha 1 | Determines whether this individual transaction can be summarized along with other like transactions. " " = Summarize
| — |
#GTX-REFERENCEREFERENCE | Alpha 10 (Lower Case) | The reference number associated with the transaction. | — |
#GTX-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The reference description. | — |
#GTX-DOCUMENT-NBRDOCUMENT_NBR | Alpha 27 | The document number assigned to the transaction. | — |
#GTX-BASE-AMOUNTBASE_AMOUNT | Signed 18.2 | The base amount to be posted to the General Ledger Master file. | — |
#GTX-BASE-NDBASE_ND | Numeric 1 | The number of decimal positions defined for the company base currency. | — |
#GTX-BASERATEBASERATE | Signed 14.7 | The exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default. | — |
#GTX-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | This is the To Company's base currency amount. | — |
#GTX-TO-BASE-NDTO_BASE_ND | Numeric 1 | This is the To Company's base currency number of decimals. | — |
#GTX-TO-BASERATETO_BASERATE | Signed 14.7 | This is the Exchange Rate used to convert the transaction's currency amount to the To Company's Base Currency. | — |
#GTX-TRAN-AMOUNTTRAN_AMOUNT | Signed 18.2 | — | — |
#GTX-TRAN-NDTRAN_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
#GTX-ACCT-CURRENCYACCT_CURRENCY | Alpha 5 | This is the base currency of the General Ledger account number. | — |
#GTX-ACCT-AMOUNTACCT_AMOUNT | Signed 18.2 | This is the amount of the transaction in the General Ledger account's base currency. | — |
#GTX-ACCT-RATEACCT_RATE | Signed 14.7 | This is the Exchange Rate used to convert the transaction currency to the General Ledger account's base currency. | — |
#GTX-ACCT-NDACCT_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
#GTX-UNITS-AMOUNTUNITS_AMOUNT | Signed 15.2 | The units amount of the transaction. | — |
#GTX-EFFECT-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | This is the date the transaction is effective for Average Daily Balance. | — |
#GTX-PROGRAM-INFOPROGRAM_INFO | Alpha 100 | This field contains the keys to the record from the originating file. | — |
#GTX-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. | — |
#GTX-RPT-AMOUNT-1RPT_AMOUNT_1 | Signed 18.2 | — | — |
#GTX-RPT-RATE-1RPT_RATE_1 | Signed 14.7 | The currency rate. | — |
#GTX-RPT-ND-1RPT_ND_1 | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
#GTX-RPT-AMOUNT-2RPT_AMOUNT_2 | Signed 18.2 | — | — |
#GTX-RPT-RATE-2RPT_RATE_2 | Signed 14.7 | The currency rate. | — |
#GTX-RPT-ND-2RPT_ND_2 | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
#GTX-RESOURCE-DESCRESOURCE_DESC | Alpha 30 (Lower Case) | This field displays the description. | — |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GTXSET1 |
| Primary | — | |
GTXSET2 |
| KeyChange | GL311 |
Programs
Updated by (1)
- GL311 Remote Site GL Transaction Upload