|
|
GLAUTMPMST FILE
This file maintains the posting account information for the posting accounting
units within the template.
REFERENCED BY
GL123 GL124 GL00.3 GL216
UPDATED BY
GL14.2 GL14.4 GL14.8 GL14.1 GL14.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTM-TEMPLATE-NAME Alpha 12 GL14.2 GL14.4
Element: Name User This field contains the name of the GL14.8
accounting unit template.
GTM-ACCT-UNIT Alpha 15 GL14.2 GL14.4
Element: Accounting UniThis is the name of the posting GL14.8
accounting unit.
GTM-ACCOUNT Numeric 6 GL14.2 GL14.4
Element: Account This is the number of the account GL14.8
attached to the accounting unit.
GTM-SUB-ACCOUNT Numeric 4 GL14.2 GL14.4
Element: Subaccount This field contains the number of the GL14.8
subaccount attached to the account and
accounting unit.
GTM-UNITS-CODE Alpha 1 GL14.2 GL14.8
Element: Units Code This field indicates whether units are
allowed. Valid values are
Y = Yes (allow both units and accounts)
N = No (Do not allow units)
O = Only (Allow only units)
Default (Value defaulted from the
chart of accounts)
GTM-ACTIVITY-REQ Alpha 1 GL14.2 GL14.8
Element: Activity Req Indicates whether an activity is
required. Valid values are:
Y = Yes (activity is required)
N = No (Activity is optional)
B = Blank (Activity is not allowed)
Default (Value defaulted from the
chart of accounts)
GTM-POSTING-LEVEL Alpha 1 GL14.2 GL14.8
Element: Posting Level This field indicates whether interfaced
transactions posted in Summary or Detail
form. Valid values are:
D = Detail (all posted accounts)
S = Summary (summary of posted accounts)
Default (Defaulted from chart of
accounts.
GTM-CURRENCY-CODE Alpha 5 GL14.2 GL14.4
Element: Currency Code This field contains the account GL14.8
currency. It defaults to the company
base currency code, but you can select a
non-base currency..
GTM-CURR-CONTROL Alpha 1 GL14.2 GL14.8
Element: Currency ContrThis field lets you limit all
transactions to the account currency.
The default is N (No)..
GTM-TRANSL-CODE Alpha 2 GL14.2 GL14.8
Element: Add On Cost CoThis field identifies the translation
rate applied against the account balance
to calculate the translation value.
GTM-REVALUE Alpha 1 GL14.2 GL14.8
Element: Revalue This field indicates whether to revalue
non-base account balances to accommodate
currency rate changes.
GTM-ACTIVE-STATUS Alpha 1 GL14.2 GL14.8
Element: Status This field displays The status of the
account. If Inactive, no posting can be
done to the account.
GTM-ACCT-CATEGORY Alpha 5 GL14.2 GL14.8
Element: Account CategoThis field contains the default activity
account category to be associated with
the posting account.
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.
GTM-OPTION-FLD-1 Alpha 2 (Lower Case) GL14.2 GL14.8
Element: Option Field OThis a free-form user field used to
store any information relevant to an
account. This field is used only for
reporting purposes.
GTM-OPTION-FLD-2 Alpha 7 (Lower Case) GL14.2 GL14.8
Element: Option Field TThis is a free-form user field used to
store information relevant to an
account. This field is used only for
reporting purposes.
GTM-OPTION-FLD-3 Alpha 12 (Lower Case) GL14.2 GL14.8
Element: Level DescriptThis is a free-form field user field
used to store any information relevant
to an account. This field is used only
for reporting purposes.
GTM-CHART-NAME Alpha 12 GL14.2 GL14.4
Element: Name User This fiekd contains the name of the GL14.8
chart of accounts associated with the
account.
GTM-RESTRICT-SYS Alpha 1 GL14.2 GL14.8
Element: Restrict Sys This field indicates whether account
usage is restricted to specified system
codes.
GLAUTMPMST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTMSET1 TEMPLATE-NAME This index accesses posting account and GL123 GL124
ACCT-UNIT subaccount information by template name GL14.1 GL14.2
ACCOUNT and accounting unit. GL14.4 GL14.6
SUB-ACCOUNT GL14.8
GTMSET2 TEMPLATE-NAME This index access posting account and GL00.3 GL216
ACCOUNT subaccount information by template name.
SUB-ACCOUNT
ACCT-UNIT
GLAUTMPMST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Trcodes TRCODES Not Required
GTM-TRANSL-CODE -> TRC-TRANSL-CODE
GLAUTMPMST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glautmpvld GLAUTMPVLD
GTM-TEMPLATE-NAME -> GAV-TEMPLATE-NAME
GTM-ACCT-UNIT -> GAV-ACCT-UNIT
GTM-ACCOUNT -> GAV-ACCOUNT
GTM-SUB-ACCOUNT -> GAV-SUB-ACCOUNT
GAV-SYSTEM
|
