Lawson Insight Technical Documentation

                             ACDBEMPLY FILE

UPDATED BY

AC550     AC551     AC750

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AEM-COMP-EMP         Alpha 13                                    AC550   AC551
Comp Emp                                                         AC750

AEM-COMP-VEN         Alpha 13                                    AC550   AC551
Comp Ven                                                         AC750

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

AEM-SALARY-CLASS     Alpha 1                                     AC550   AC551
Salary Class                                                     AC750

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

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

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

AEM-LAST-NAME        Alpha 30  (Lower Case)                      AC550   AC551
Last Name            Contains the last name of the manager       AC750
                     in charge.

AEM-MIDDLE-INIT      Alpha 1                                     AC550   AC551
Middle Initial       Contains the middle initial of the          AC750
                     manager in charge.

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

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

AEM-EXEMPT-EMP       Alpha 1                                     AC550   AC551
Exempt Employee                                                  AC750

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

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

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

AEM-PAY-FREQUENCY    Numeric 1                                   AC550   AC551
Pay Frequency                                                    AC750

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

AEM-LOCAT-CODE       Alpha 10                                    AC550   AC551
Location                                                         AC750

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

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

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

AEM-DIST-COMPANY     Numeric 4                                   AC550   AC551
Distribution Company The company number used for posting the     AC750
                     transaction. A valid intercompany
                     relationship must be defined in the
                     Lawson General Ledger system.

AEM-COMP-PRLVL       Alpha 9                                     AC750
Comp Prlvl

                         ACDBEMPLY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AEMSET1   COMP-EMP                                               AC550   AC750