Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMSYSTEM


                             GMSYSTEM FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GMB-INSTITUTION        Numeric 4
Element: Institution   Institution ID.  Code identifying the
                       institution receiving the award.

GMB-INST-LOCALE        Alpha 15
Element: Inst Locale   Institution location.  Code identifying
                       the institution's location that received
                       the award.

GMB-NAME               Alpha 30  (Lower Case)
Element: Name          Displays the company description.

GMB-LEGAL-NAME         Alpha 80  (Lower Case)
Element: Legal Name    Institution's legal name used on the
                       GM269 and GM272 reports.

GMB-CONTACT-NAME       Alpha 30  (Lower Case)
Element: Contact Name  Primary contact at the institution.

GMB-EMAIL-ADDRESS      Alpha 60  (Lower Case)
Element: Email Address e-mail address.

GMB-ADDR-CODE          Alpha 20
Element: Addr Code     This is a code representing the address
                       for the institution or the institution
                       location.  The address is stored in the
                       ADDRDATA file.

GMB-PHONE-COUNTRY      Alpha 6
Telephone Country      This field contains the prefix of the
Code                   telephone number. For example, the
                       country or city code.


GMB-PHONE-NUMBER       Alpha 15
Element: Telephone NumbContains the telephone number,
                       including area code.

GMB-PHONE-EXT          Alpha 5
Element: Telephone ExteThis field contains the telephone
                       extension number.

GMB-FAX-COUNTRY        Alpha 6
Telephone Country      This field contains the prefix of the
Code                   fax number. For example, the country or
                       city code.


GMB-FAX-NUMBER         Alpha 15
Element: Telephone NumbThis field contains the fax number.

GMB-FAX-EXT            Alpha 5
Element: Telephone ExteThis field contains the fax number
                       extension.


GMB-EMP-ACCT-NBR       Alpha 20
Element: Emp Acct Nbr  Employer identification number.

                         GMSYSTEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMBSET1   INSTITUTION
          INST-LOCALE

GMBSET2   INSTITUTION   Subset
          INST-LOCALE   Where INST-LOCALE != Spaces