GL Remote Transfer

This file is used to collect General Ledger and Activity transactions from a remote site machine. This file is populated by transferring the General Ledger transaction CSV file from the remote site into this database file for processing on this target machine.
UPDATED BY

GL311

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GTX-MACHINE-CODE Element: Machine Code	Alpha 12 Designates a code name associated with a particular machine in a multiple machine environment.
GTX-OBJ-ID Element: Obj 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 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.)
GTX-PROGRAM Element: Program	Alpha 5 Designates the program this record was created by.
GTX-SUMMARIZE Element: Summarize	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. Y = Summarize N = Detail
GTX-COMPANY Element: Company	Numeric 4 The company number as defined in GL10.1 (Company).
GTX-POSTING-DATE Element: Posting Date	Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting.
GTX-ZONE-ACCTUNIT Element: Zone Accounting 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-CNTRL-DOCUMENT Element: Control 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-NBR Element: Journal Book Number	Alpha 12 The journal book assigned to the transaction.
GTX-JE-TYPE Element: Journal Entry Type	Alpha 1 The type of journal entry. Valid values are Normal or Intercompany. N = Normal I = Intercompany
GTX-TO-COMPANY Element: To Company	Numeric 4 This is the company number a line is posted to.
GTX-SOURCE-CODE Element: Source Code	Alpha 2 A two-character code assigned to a transaction to identify where the transaction was created.
GTX-ACCT-UNIT Element: Accounting 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-ACCOUNT Element: Account	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-ACCOUNT Element: Subaccount	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-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.
GTX-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
GTX-CURRENCY-CODE Element: Currency Code	Alpha 5 This identifies the company base currency code as defined in CU01.1 (Currency Code).
GTX-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the system date the record was created.
GTX-SUMMARY-CNTRL Element: Summary Control	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-REV Element: Auto 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-FLD Element: Analysis Field	Alpha 32 Occurs 3 Times The user-defined analysis field assigned to the transaction based on the transaction's source code.
GTX-SIGN Element: Sign	Alpha 1 Indicates the sign type. 0 = Negative Sign 1 = Positive Sign
GTX-RESOURCE-TYPE Element: Resource Type	Alpha 1 Indicates whether the resource is a person or equipment.
GTX-RESOURCE Element: Resource	Alpha 10 This is the resource description.
GTX-FORCE-DETAIL Element: Force Detail	Alpha 1 Determines whether this individual transaction can be summarized along with other like transactions. Y = Detail A = Sign Summary " " = Summarize
GTX-REFERENCE Element: Reference	Alpha 10 (Lower Case) The reference number associated with the transaction.
GTX-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The reference description.
GTX-DOCUMENT-NBR Element: Document Number	Alpha 27 The document number assigned to the transaction.
GTX-BASE-AMOUNT Element: Base Amount	Signed 18.2 The base amount to be posted to the General Ledger Master file.
GTX-BASE-ND Element: Base ND	Numeric 1 The number of decimal positions defined for the company base currency.
GTX-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.
GTX-TO-BASE-AMT Element: To Base Amount	Signed 18.2 This is the To Company's base currency amount.
GTX-TO-BASE-ND Element: To Base ND	Numeric 1 This is the To Company's base currency number of decimals.
GTX-TO-BASERATE Element: To Base Rate	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-AMOUNT Element: Tran Amount	Signed 18.2
GTX-TRAN-ND Element: Tran ND	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.
GTX-ACCT-CURRENCY Element: Account Currency	Alpha 5 This is the base currency of the General Ledger account number.
GTX-ACCT-AMOUNT Element: Account Amount	Signed 18.2 This is the amount of the transaction in the General Ledger account's base currency.
GTX-ACCT-RATE Element: Account 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-ND Element: Account ND	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.
GTX-UNITS-AMOUNT Element: Units Amount	Signed 15.2 The units amount of the transaction.
GTX-EFFECT-DATE Element: Effect Date	Numeric 8 (yyyymmdd) This is the date the transaction is effective for Average Daily Balance.
GTX-PROGRAM-INFO Element: Program Info	Alpha 100 This field contains the keys to the record from the originating file.
GTX-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.
GTX-RPT-AMOUNT-1 Element: Intl Amt	Signed 18.2
GTX-RPT-RATE-1 Element: Curr Rate	Signed 14.7 The currency rate.
GTX-RPT-ND-1 Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.
GTX-RPT-AMOUNT-2 Element: Intl Amt	Signed 18.2
GTX-RPT-RATE-2 Element: Curr Rate	Signed 14.7 The currency rate.
GTX-RPT-ND-2 Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.
GTX-RESOURCE-DESC Element: Description	Alpha 30 (Lower Case) This field displays the description.

GLREMOTETX FILE INDEX

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