|
|
GLREMOTETX FILE
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 Alpha 12
Element: Machine Code Designates a code name associated with
a particular machine in a multiple
machine environment.
GTX-OBJ-ID Numeric 12
Element: Obj ID This is the transaction identifier. It
is used to keep a record unique from
other records originating from the same
Machine Code.
GTX-SYSTEM Alpha 2
Element: System A two-character code representing an
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
GTX-PROGRAM Alpha 5
Element: Program Designates the program this record was
created by.
GTX-SUMMARIZE Alpha 1
Element: Summarize 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 Numeric 4
Element: Company The company number as defined in GL10.1
(Company).
GTX-POSTING-DATE Numeric 8 (yyyymmdd)
Element: Posting Date The date assigned to the journal entry
for posting.
GTX-ZONE-ACCTUNIT Alpha 15
Element: Zone AccountinThis is the Accounting Unit the
transaction originated from. This field
is used for interzone balancing. This
Accounting Unit value can be ignored by
setting the Ignore Base Zone on the
Company / system Code relationship.
GTX-CNTRL-DOCUMENT Alpha 27
Element: Control DocumeThis is the Document Number used to
group transactions into the same Journal
Entry if Journal by Document is
selected.
GTX-JRNL-BOOK-NBR Alpha 12
Element: Journal Book NThe journal book assigned to the
transaction.
GTX-JE-TYPE Alpha 1
Element: Journal Entry The type of journal entry. Valid values
are Normal or Intercompany.
N = Normal
I = Intercompany
GTX-TO-COMPANY Numeric 4
Element: To Company This is the company number a line is
posted to.
GTX-SOURCE-CODE Alpha 2
Element: Source Code A two-character code assigned to a
transaction to identify where the
transaction was created.
GTX-ACCT-UNIT Alpha 15
Element: Accounting UniThe 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 Numeric 6
Element: Account 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 Numeric 4
Element: Subaccount This field along with the accounting
unit and account make up the location
(account) where amounts and other
account information are stored.
GTX-ACTIVITY Alpha 15
Element: Activity 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 Alpha 5
Element: Account CategoAccount 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 Alpha 5
Element: Currency Code This identifies the company base
currency code as defined in CU01.1
(Currency Code).
GTX-DATE Numeric 8 (yyyymmdd)
Element: Date This field contains the system date the
record was created.
GTX-SUMMARY-CNTRL Alpha 20
Element: Summary ControThis 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 Alpha 1
Element: Auto Reverse 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 Alpha 32 Occurs 3 Times
Element: Analysis FieldThe user-defined analysis field
assigned to the transaction based on the
transaction's source code.
GTX-SIGN Alpha 1
Element: Sign Indicates the sign type.
0 = Negative Sign
1 = Positive Sign
GTX-RESOURCE-TYPE Alpha 1
Element: Resource Type Indicates whether the resource is a
person or equipment.
GTX-RESOURCE Alpha 10
Element: Resource This is the resource description.
GTX-FORCE-DETAIL Alpha 1
Element: Force Detail Determines whether this individual
transaction can be summarized along with
other like transactions.
Y = Detail
A = Sign Summary
" " = Summarize
GTX-REFERENCE Alpha 10 (Lower Case)
Element: Reference The reference number associated with
the transaction.
GTX-DESCRIPTION Alpha 30 (Lower Case)
Element: Description The reference description.
GTX-DOCUMENT-NBR Alpha 27
Element: Document NumbeThe document number assigned to the
transaction.
GTX-BASE-AMOUNT Signed 18.2
Element: Base Amount The base amount to be posted to the
General Ledger Master file.
GTX-BASE-ND Numeric 1
Element: Base ND The number of decimal positions defined
for the company base currency.
GTX-BASERATE Signed 14.7
Element: Base Rate The exchange rate at the time the
journal entry was made. If left blank,
the current exchange rate will default.
GTX-TO-BASE-AMT Signed 18.2
Element: To Base AmountThis is the To Company's base currency
amount.
GTX-TO-BASE-ND Numeric 1
Element: To Base ND This is the To Company's base currency
number of decimals.
GTX-TO-BASERATE Signed 14.7
Element: To Base Rate This is the Exchange Rate used to
convert the transaction's currency
amount to the To Company's Base
Currency.
GTX-TRAN-AMOUNT Signed 18.2
Element: Tran Amount This is the amount in transaction
currency to be posted. This amount
creates a CUAMOUNT type 1 record.
GTX-TRAN-ND Numeric 1
Element: Tran ND The number of decimal positions defined
for the transaction currency.
GTX-ACCT-CURRENCY Alpha 5
Element: Account CurrenThis is the base currency of the
General Ledger account number.
GTX-ACCT-AMOUNT Signed 18.2
Element: Account AmountThis is the amount of the transaction
in the General Ledger account's base
currency.
GTX-ACCT-RATE Signed 14.7
Element: Account Rate This is the Exchange Rate used to
convert the transaction currency to the
General Ledger account's base currency.
GTX-ACCT-ND Numeric 1
Element: Account ND The number of decimals assigned to a
particular account as determined by the
account currency.
GTX-UNITS-AMOUNT Signed 15.2
Element: Units Amount The units amount of the transaction.
GTX-EFFECT-DATE Numeric 8 (yyyymmdd)
Element: Effective DateThis is the date the transaction is
effective for Average Daily Balance.
GTX-PROGRAM-INFO Alpha 100
Element: Program Info This field contains the keys to the
record from the originating file.
GTX-SEGMENT-BLOCK Alpha 103
Element: User Analysis 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 Signed 18.2
Element: Intl Amt The transaction amount for Report
Currency 1.
GTX-RPT-RATE-1 Signed 14.7
Element: Currency Rate The exchange rate to convert the
transaction amount to Report Currency 1.
The exchange rate is defined in CU10.1
(Exchange Rate).
GTX-RPT-ND-1 Numeric 1
Account Currency The number of decimal positions for
Code Report Currency 1.
GTX-RPT-AMOUNT-2 Signed 18.2
Element: Intl Amt The transaction amount for Report
Currency 2.
GTX-RPT-RATE-2 Signed 14.7
Element: Currency Rate The exchange rate to convert the
transaction amount to Report Currency 2.
The exchange rate is defined in CU10.1
(Exchange Rate).
GTX-RPT-ND-2 Numeric 1
Account Currency The number of decimal positions for
Code Report Currency 2.
GTX-RESOURCE-DESC Alpha 30 (Lower Case)
Element: Description
GLREMOTETX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTXSET1 MACHINE-CODE
OBJ-ID
GTXSET2 MACHINE-CODE KeyChange GL311
SYSTEM
PROGRAM
SUMMARIZE
OBJ-ID
COMPANY
|
