|
|
GLAUTMPCNV FILE
GL AU Template Interface
This file contains accounting unit template data loaded by Template Conversion
Load (GL123),
REFERENCED BY
GL223
UPDATED BY
GL123 GL124 GL23.1 GL23.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTC-RUN-GROUP Alpha 15 GL123 GL23.1
Element: Run Group This field contains the run group
identifier, used to group records
together for interfacing.
GTC-COMPANY Numeric 4 GL123 GL23.1
Element: Company This field contains the company to which
accunting unit records are added.
GTC-TEMPLATE-NAME Alpha 12 GL123 GL23.1
Element: Template Name This field contains the name of the
acciunting unit template used to add
accounting units.
GTC-SUMMARY-AU Alpha 15 GL123 GL23.1
Summary Accounting This field contains the name of the
Unit company summary accounting unit to which
the template is attached. If this field
is blank the the template starts at
level 1.
GTC-ACCT-UNIT Alpha 15 GL123 GL23.1
Element: Accounting UniThis field contains the accounting unit
name. It can be entered by the operator
or generated automatically. It defualts
from the template accounting unit.
GTC-DESCRIPTION Alpha 30 (Lower Case) GL123 GL23.1
Element: Description This field contains the description of
the accounting unit..
GTC-PARENT-AU Alpha 15 GL123
parent Accounting This field contains the name of the
Unit parent accounting unit to which the
accounting unit reports.
GTC-TMPL-ACCT-UNIT Alpha 15 GL123 GL23.1
Template Accounting This field contains the name of the
Unit accounting unit from the tempate. If no
accounting unit is entered by the
operator, or generated automatically,
this name defaults.
GTC-LEVEL-DETAIL Numeric 15 GL123 GL23.1
Element: Level Detail This field contains the address to be
assigned at the level depth defined for
the accounting unit. This value can be
entered by the operator or automatically
generated. Defaults to the template
level detail.
GTC-VAR-LEVEL-DISP Alpha 34 GL123 GL23.1
Variable Level This field displays the variable level.
Display
GTC-NBR-DIGITS Numeric 2 GL123 GL23.1
Element: Number of DigiThis field contains the size at the
level depth if the company.
GTC-LEVEL-DEPTH Numeric 1 GL123 GL23.1
Element: Level Depth This field contains the depth of the
accounting unit within the company.
GTC-PERSON-RESP Alpha 15 (Lower Case) GL123 GL23.1
Element: Person ResponsThis is the name of the person GL23.3
responsible for this record.
GTC-MX-TMPLT-NAME Alpha 12 GL23.1 GL23.3
Attribute Template This field contains the name of the
Name Matrix (MX) attribute template. Defaults
from the template attribute template.
GTC-ADDR-CONTACT Alpha 30 (Lower Case) GL23.1 GL23.3
Element: Address ContacThis field contains the name of the
main contact.
GTC-PHONE-COUNTRY Alpha 6 GL23.1 GL23.3
Element: Phone Country This field contains the prefix of the
telephone number. For example, the
country or city code.
GTC-PHONE-NUMBER Alpha 15 GL23.1
Element: Phone Number Contains the telephone number,
including area code.
GTC-PHONE-EXT Alpha 5 GL23.1
Element: Phone ExtensioThis field contains the telephone
extension number.
GTC-FAX-COUNTRY Alpha 6 GL23.1 GL23.3
Element: Fax Country This field contains the prefix of the
fax number. For example, the country or
city code.
GTC-FAX-NUMBER Alpha 15 GL23.1
Element: Fax Number This field contains the fax number.
GTC-FAX-EXT Alpha 5 GL23.1
Element: Fax Extension This field contains the fax number
extension.
GTC-TELEX-NUMBER Alpha 15 GL23.1 GL23.3
Element: Telex Number This field contains the telex number.
GTC-OPT-FIELD1 Alpha 15 (Lower Case) GL23.1 GL23.3
Element: Option Field 1This field lets you enter any
additional information you would like to
appear on the address.
GTC-OPT-FIELD2 Alpha 15 (Lower Case) GL23.1 GL23.3
Element: Option Field 2This field lets you enter any
additional information you would like to
appear on the address.
GTC-OPT-FIELD3 Alpha 30 (Lower Case) GL23.1 GL23.3
Element: Option Field 3This field lets you enter any
additional information you would like to
appear on the address.
GTC-ADDR-CODE Alpha 20 GL23.1 GL23.3
Element: Address Code This is a code representing the address
for the institution or the institution
location. The address is stored in the
ADDRDATA file.
GLAUTMPCNV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTCSET1 RUN-GROUP This index accesses trmplate data by GL123 GL124
COMPANY run group, company, template name, GL223 GL23.1
TEMPLATE-NAME accounting unit, and variable level.. GL23.3
ACCT-UNIT
VAR-LEVEL-DISP
GTCSET2 RUN-GROUP This index accesses accounting unit GL123 GL124
COMPANY template data by run group, company, GL223 GL23.1
TEMPLATE-NAME template name, variable level, and
VAR-LEVEL-DISPaccounting unit..
ACCT-UNIT
GLAUTMPCNV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glautmphdr GLAUTMPHDR Required
GTC-TEMPLATE-NAME -> GAH-TEMPLATE-NAME
GLAUTMPCNV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glautmpmst GLAUTMPMST
GTC-TEMPLATE-NAME -> GTM-TEMPLATE-NAME
GTC-ACCT-UNIT -> GTM-ACCT-UNIT
GTM-ACCOUNT
GTM-SUB-ACCOUNT
Glautmpmxv GLAUTMPMXV
GTC-TEMPLATE-NAME -> GXV-TEMPLATE-NAME
GTC-ACCT-UNIT -> GXV-ACCT-UNIT
GXV-MATRIX-CAT
Glautmpvld GLAUTMPVLD
GTC-TEMPLATE-NAME -> GAV-TEMPLATE-NAME
GTC-ACCT-UNIT -> GAV-ACCT-UNIT
GAV-ACCOUNT
GAV-SUB-ACCOUNT
GAV-SYSTEM
|
