|
|
GLAUTMPCNV FILE
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: Name User This field contains the name of the
acciunting unit template used to add
accounting units.
GTC-SUMMARY-AU Alpha 15 GL123 GL23.1
Element: Summary Au This field contains the name of the
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
Element: Parent Au This field contains the name of the
parent accounting unit to which the
accounting unit reports.
GTC-TMPL-ACCT-UNIT Alpha 15 GL123 GL23.1
Element: Tmpl Acct UnitThis field contains the name of the
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
Element: Var Level DispThis field displays the variable level.
GTC-NBR-DIGITS Numeric 2 GL123 GL23.1
Element: Number Fields This 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: First Name GL23.3
GTC-MX-TMPLT-NAME Alpha 12 GL23.1 GL23.3
Element: Mx Tmplt Name This field contains the name of the
Matrix (MX) attribute template. Defaults
from the template attribute template.
GTC-NAME Alpha 30 (Lower Case) GL124 GL23.1
Element: Name Contains the name of the address. GL23.3
GTC-ADDR1 Alpha 30 (Lower Case) GL23.1 GL23.3
Element: Address 1 This field contains the first line of
address information.
GTC-ADDR2 Alpha 30 (Lower Case) GL23.1 GL23.3
Element: Address 1
GTC-ADDR3 Alpha 30 (Lower Case) GL23.1 GL23.3
Element: Address 1
GTC-ADDR4 Alpha 30 (Lower Case) GL23.1 GL23.3
Element: Address 1
GTC-ADDR5 Alpha 18 (Lower Case) GL23.1 GL23.3
Element: City This field contains the fifth line of
address information.
GTC-STATE-PROV Alpha 2 GL23.1 GL23.3
Element: State or ProviThis field contains the state or
province.
GTC-POSTAL-CODE Alpha 10 (Lower Case) GL23.1 GL23.3
Element: Postal Code This field contains the postal code.
GTC-COUNTY Alpha 25 (Lower Case) GL23.1
Element: County This field contains the United States
county of the address.
GTC-COUNTRY-CODE Alpha 2 GL23.1 GL23.3
Element: Country Code This field contains the country code.
GTC-COUNTRY Alpha 30 (Lower Case) GL23.1
Element: Country or OthThis field contains the country of the
address.
GTC-ADDR-CONTACT Alpha 30 (Lower Case) GL23.1 GL23.3
Element: Contact This field contains the name of the
main contact.
GTC-PHONE-COUNTRY Alpha 6 GL23.1 GL23.3
Telephone Country This field contains the prefix of the
Code telephone number. For example, the
country or city code.
GTC-PHONE-NUMBER Alpha 15 GL23.1
Element: Telephone Number
GTC-PHONE-EXT Alpha 5 GL23.1
Element: Telephone ExteThis field contains the telephone
extension number.
GTC-FAX-COUNTRY Alpha 6 GL23.1 GL23.3
Telephone Country
Code
GTC-FAX-NUMBER Alpha 15 GL23.1
Element: Telephone Number
GTC-FAX-EXT Alpha 5 GL23.1
Element: Telephone Extension
GTC-TELEX-NUMBER Alpha 15 GL23.1 GL23.3
Element: Telephone NumbThis field contains the telex number.
GTC-OPT-FIELD1 Alpha 15 (Lower Case) GL23.1 GL23.3
Element: Optional FieldThis 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: Optional FieldThis 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: User Defined FThis field lets you enter any
additional information you would like to
appear on the address.
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
|
