Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACDBEMPLY


                             ACDBEMPLY FILE

UPDATED BY

AC550     AC551

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AEM-COMP-EMP           Alpha 13                                  AC550   AC551
Element: Comp Emp

AEM-COMP-VEN           Alpha 13                                  AC550   AC551
Element: Comp Ven

AEM-COMPANY            Numeric 4                                 AC550   AC551
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

AEM-SALARY-CLASS       Alpha 1                                   AC550   AC551
Element: Salary Class

AEM-CURRENCY-CODE      Alpha 5                                   AC550   AC551
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

AEM-HM-ACCT-UNIT       Alpha 15                                  AC550   AC551
Expense Accounting
Unit

AEM-FIRST-NAME         Alpha 15  (Lower Case)                    AC550   AC551
Element: First Name    Contains the first name of the manager
                       in charge.

AEM-LAST-NAME          Alpha 30  (Lower Case)                    AC550   AC551
Element: Name

AEM-MIDDLE-INIT        Alpha 1                                   AC550   AC551
Element: Middle InitialContains the middle initial of the
                       manager in charge.

AEM-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    AC550   AC551
Element: Email Address

AEM-FICA-NBR           Alpha 15                                  AC550   AC551
Social Security
Number

AEM-EXEMPT-EMP         Alpha 1                                   AC550   AC551
Element: Exempt Employee

AEM-DATE-HIRED         Numeric 8  (yyyymmdd)                     AC550   AC551
Element: Hire Date

AEM-TERM-DATE          Numeric 8  (yyyymmdd)                     AC550   AC551
Element: Termination Date

AEM-PT-FT-FLAG         Alpha 1                                   AC550   AC551
Element: Pt Ft Flag    P = Part Time
                       F = Full Time

AEM-PAY-FREQUENCY      Numeric 1                                 AC550   AC551
Element: Pay Frequency

AEM-SHIFT              Numeric 1                                 AC550   AC551
Element: Shift         Contains the shift number associated
                       with the pay.

AEM-LOCAT-CODE         Alpha 10                                  AC550   AC551
Element: Location

AEM-LOCATION           Alpha 5
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

AEM-JOB-CODE           Alpha 9                                   AC550   AC551
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

AEM-SUP-COMP-EMP       Alpha 13                                  AC550   AC551
Element: Sup Comp Emp

AEM-DIST-COMPANY       Numeric 4                                 AC550   AC551
Element: Company

AEM-COMP-PRLVL         Alpha 9                                   AC550   AC551
Element: Comp Prlvl

AEM-ACCT-CATEGORY      Alpha 5                                   AC550   AC551
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                         ACDBEMPLY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AEMSET1   COMP-EMP                                               AC550