Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLAUTMPCNV


                            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  Phone number.

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
                       telephone number. For example, the
                       country or city code.


GTC-FAX-NUMBER         Alpha 15                                  GL23.1
Element: Fax Number    Phone number.

GTC-FAX-EXT            Alpha 5                                   GL23.1
Element: Fax Extension This field contains the telephone
                       extension number.

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                                              GL123   GL124
          COMPANY                                                GL223   GL23.1
          TEMPLATE-NAME                                          GL23.3
          ACCT-UNIT
          VAR-LEVEL-DISP

GTCSET2   RUN-GROUP                                              GL123   GL124
          COMPANY                                                GL223   GL23.1
          TEMPLATE-NAME
          VAR-LEVEL-DISP
          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