Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADMASTER


                             ADMASTER FILE

                           ADB Account Master

The AD Master file contains the company, accounting unit, account, and
subaccount that ADB records would be run for.  When an account is flagged as
ADB it is added to this file.  AD190 and AD191 will reference this file for
the accounts to run their calculations on.

UPDATED BY

GL122     GL121     GL20.2    GL20.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADM-COMPANY            Numeric 4                                 GL121   GL122
Element: Company       The Average Daily Balance Company         GL20.2  GL20.4
                       established in AD10. The company must
                       exist as a General Ledger Company.

ADM-ACCT-UNIT          Alpha 15                                  GL121   GL122
Element: Acct Unit     The accounting unit is a shorthand        GL20.2  GL20.4
                       notation representing the variable level
                       number. When used in the General Ledger
                       Master file, the accounting unit must
                       be defined in the General Ledger Names
                       file as a posting accounting unit.

ADM-ACCOUNT            Numeric 6                                 GL121   GL122
Element: Account       This field along with the accounting      GL20.2  GL20.4
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

ADM-SUB-ACCOUNT        Numeric 4                                 GL121   GL122
Element: Sub Acct      This field contains the subaccount from   GL20.2  GL20.4
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

ADM-CHART-NAME         Alpha 12                                  GL121   GL122
Element: Chart Name    This is the name you assigned to the      GL20.2  GL20.4
                       chart of accounts when you defined your
                       company structure in the General Ledger
                       system.


ADM-PER-DAYS           Numeric 2
Element: Per Days      The number of days in the period
                       established in AD20 for each account.
                       This is used in  the calculation of the
                       cost of funds.

ADM-YEAR-DAYS          Numeric 3
Element: Year Days     The number of days in the year
                       established in AD20 for each account.
                       This is used in the calculation of cost
                       of funds.

ADM-INT-ACCT-UNIT      Alpha 15
Element: Acct Unit     The Interest Accounting Unit
                       established in AD20 for an average daily
                       balance account.

ADM-INT-ACCOUNT        Numeric 6
Element: Account       The Interest Account established in
                       AD20 for an avereage daily balance
                       account.

ADM-INT-SUB-ACCT       Numeric 4
Element: Sub Acct      The Interest Sub-account established in
                       AD20 for an average daily balance
                       account.

ADM-INT-RATIO          Alpha 10
Element: Int Ratio     The Interest Total Name established in
                       AD20 for an average daily balance
                       account.

                         ADMASTER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADMSET1   COMPANY                                                GL122   GL121
          ACCT-UNIT                                              GL20.2  GL20.4
          ACCOUNT
          SUB-ACCOUNT

ADMSET2   COMPANY       KeyChange, Subset
          INT-RATIO     Where  INT-RATIO     != Spaces
          ACCT-UNIT     Or    (INT-ACCT-UNIT != Spaces
          ACCOUNT       And    INT-ACCOUNT   != Zeroes )
          SUB-ACCOUNT

ADMSET3   COMPANY
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT

                         ADMASTER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glmaster       GLMASTER     Required

                            ADM-COMPANY        -> GLM-COMPANY  (GLMSET2)
                            ADM-ACCT-UNIT      -> GLM-ACCT-UNIT
                            ADM-ACCOUNT        -> GLM-ACCOUNT
                            ADM-SUB-ACCOUNT    -> GLM-SUB-ACCOUNT