GLAUTMPCNV

GL AU Template Interface

This file contains accounting unit template data loaded by Template Conversion Load (GL123),
UPDATED BY
GL123 GL124 GL23.1 GL23.3 GL223

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GTC-RUN-GROUP
Element: Run Group
Alpha 15
This field contains the run group identifier, used to group records together for interfacing.
GL123 GL23.1
GTC-COMPANY
Element: Company
Numeric 4
This field contains the company to which accunting unit records are added.
GL123 GL23.1
GTC-TEMPLATE-NAME
Element: Template Name
Alpha 12
This field contains the name of the acciunting unit template used to add accounting units.
GL123 GL23.1
GTC-SUMMARY-AU
Summary Accounting
Unit
Alpha 15
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.
GL123 GL23.1
GTC-ACCT-UNIT
Element: Accounting Unit
Alpha 15
This field contains the accounting unit name. It can be entered by the operator or generated automatically. It defualts from the template accounting unit.
GL123 GL23.1
GTC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the accounting unit..
GL123 GL23.1
GTC-PARENT-AU
parent Accounting
Unit
Alpha 15
This field contains the name of the parent accounting unit to which the accounting unit reports.
GL123
GTC-TMPL-ACCT-UNIT
Template Accounting
Unit
Alpha 15
This 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.
GL123 GL23.1
GTC-LEVEL-DETAIL
Element: Level Detail
Numeric 15
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.
GL123 GL23.1
GTC-VAR-LEVEL-DISP
Variable Level
Display
Alpha 34
This field displays the variable level.
GL123 GL23.1
GTC-NBR-DIGITS
Element: Number of Digits
Numeric 2
This field contains the size at the level depth if the company.
GL123 GL23.1
GTC-LEVEL-DEPTH
Element: Level Depth
Numeric 1
This field contains the depth of the accounting unit within the company.
GL123 GL23.1
GTC-PERSON-RESP
Element: Person Responsible
Alpha 15 (Lower Case)
This is the name of the person responsible for this record.
GL123 GL23.1
GL23.3
GTC-MX-TMPLT-NAME
Attribute Template
Name
Alpha 12
This field contains the name of the Matrix (MX) attribute template. Defaults from the template attribute template.
GL23.1 GL23.3
GTC-ADDR-CONTACT
Element: Address Contact
Alpha 30 (Lower Case)
This field contains the name of the main contact.
GL23.1 GL23.3
GTC-PHONE-COUNTRY
Element: Phone Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
GL23.1 GL23.3
GTC-PHONE-NUMBER
Element: Phone Number
Alpha 15
Phone number.
GL23.1
GTC-PHONE-EXT
Element: Phone Extension
Alpha 5
This field contains the telephone extension number.
GL23.1
GTC-FAX-COUNTRY
Element: Fax Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
GL23.1 GL23.3
GTC-FAX-NUMBER
Element: Fax Number
Alpha 15
Phone number.
GL23.1
GTC-FAX-EXT
Element: Fax Extension
Alpha 5
This field contains the telephone extension number.
GL23.1
GTC-TELEX-NUMBER
Element: Telex Number
Alpha 15
This field contains the telex number.
GL23.1 GL23.3
GTC-OPT-FIELD1
Element: Option Field 1
Alpha 15 (Lower Case)
This field lets you enter any additional information you would like to appear on the address.
GL23.1 GL23.3
GTC-OPT-FIELD2
Element: Option Field 2
Alpha 15 (Lower Case)
This field lets you enter any additional information you would like to appear on the address.
GL23.1 GL23.3
GTC-OPT-FIELD3
Element: Option Field 3
Alpha 30 (Lower Case)
This field lets you enter any additional information you would like to appear on the address.
GL23.1 GL23.3
GTC-ADDR-CODE
Element: Address Code
Alpha 20
This is a code representing the address for the institution or the institution location. The address is stored in the ADDRDATA file.
GL23.1 GL23.3


GLAUTMPCNV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GTCSET1 RUN-GROUP
COMPANY
TEMPLATE-NAME
ACCT-UNIT
VAR-LEVEL-DISP
GL123 GL124
GL223 GL23.1
GL23.3
GTCSET2 RUN-GROUP
COMPANY
TEMPLATE-NAME
VAR-LEVEL-DISP
ACCT-UNIT
GL123 GL124
GL223 GL23.1


GLAUTMPCNV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glautmphdr GLAUTMPHDR Required
GTC-TEMPLATE-NAME->GAH-TEMPLATE-NAME


GLAUTMPCNV FILE RELATIONS


ONE TO MANY RELATIONS

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


File created: Wed Jun 08 20:48:38 2016

Home
Contact Us



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