GLREMOTETX

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTXSET1 MACHINE-CODE
OBJ-ID
GTXSET2 MACHINE-CODE
SYSTEM
PROGRAM
SUMMARIZE
OBJ-ID
COMPANY
KeyChange
GL311


File created: Wed Jun 08 20:49:45 2016

Home
Contact Us



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