GLAUTMPMST

GL Post AU Template

This file maintains the posting account information for the posting accounting units within the template.

REFERENCED BY
GL00.3 GL123 GL216


UPDATED BY
GL124 GL14.2 GL14.4 GL14.8 GL14.1 GL14.6

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTM-TEMPLATE-NAME
Element: Template Name
Alpha 12
This field contains the name of the accounting unit template.
GL14.2 GL14.4
GL14.8
GTM-ACCT-UNIT
Element: Accounting Unit
Alpha 15
This is the name of the posting accounting unit.
GL14.2 GL14.4
GL14.8
GTM-ACCOUNT
Element: Account
Numeric 6
This is the number of the account attached to the accounting unit.
GL14.2 GL14.4
GL14.8
GTM-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field contains the number of the subaccount attached to the account and accounting unit.
GL14.2 GL14.4
GL14.8
GTM-UNITS-CODE
Element: Units Code
Alpha 1
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)
GL14.2 GL14.8
GTM-ACTIVITY-REQ
Element: Activity Required
Alpha 1
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)
GL14.2 GL14.8
GTM-POSTING-LEVEL
Element: Posting Level
Alpha 1
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.
GL14.2 GL14.8
GTM-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the account currency. It defaults to the company base currency code, but you can select a non-base currency..
GL14.2 GL14.4
GL14.8
GTM-CURR-CONTROL
Element: Currency Control
Alpha 1
This field lets you limit all transactions to the account currency. The default is N (No)..
GL14.2 GL14.8
GTM-TRANSL-CODE
Element: Translation Code
Alpha 2
This field identifies the translation rate applied against the account balance to calculate the translation value.
GL14.2 GL14.8
GTM-REVALUE
Element: Revalue Flag
Alpha 1
This field indicates whether to revalue non-base account balances to accommodate currency rate changes.
GL14.2 GL14.8
GTM-ACTIVE-STATUS
Element: Active Status
Alpha 1
This field displays The status of the account. If Inactive, no posting can be done to the account.
GL14.2 GL14.8
GTM-ACCT-CATEGORY
Element: Account Category
Alpha 5
This 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.
GL14.2 GL14.8
GTM-OPTION-FLD-1
Element: Option Field 1
Alpha 2 (Lower Case)
This a free-form user field used to store any information relevant to an account. This field is used only for reporting purposes.
GL14.2 GL14.8
GTM-OPTION-FLD-2
Element: Option Field 2
Alpha 7 (Lower Case)
This is a free-form user field used to store information relevant to an account. This field is used only for reporting purposes.
GL14.2 GL14.8
GTM-OPTION-FLD-3
Element: Option Field 3
Alpha 12 (Lower Case)
This is a free-form field user field used to store any information relevant to an account. This field is used only for reporting purposes.
GL14.2 GL14.8
GTM-CHART-NAME
Element: Chart Name
Alpha 12
This fiekd contains the name of the chart of accounts associated with the account.
GL14.2 GL14.4
GL14.8
GTM-RESTRICT-SYS
Element: Restrict System
Alpha 1
This field indicates whether account usage is restricted to specified system codes.
GL14.2 GL14.8


GLAUTMPMST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTMSET1 TEMPLATE-NAME
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GL123 GL124
GL14.1 GL14.2
GL14.4 GL14.6
GL14.8
GTMSET2 TEMPLATE-NAME
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
GL00.3 GL216


GLAUTMPMST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Trcodes TRCODES Not Required
GTM-TRANSL-CODE->TRC-TRANSL-CODE


GLAUTMPMST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:13:09 2016

Home
Contact Us



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