Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACDBEMPLY FILE

UPDATED BY

AC550     AC551

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AEM-COMP-EMP         Alpha 13                                    AC550   AC551
Comp Emp

AEM-COMP-VEN         Alpha 13                                    AC550   AC551
Comp Ven

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


AEM-SALARY-CLASS     Alpha 1                                     AC550   AC551
Salary Class

AEM-CURRENCY-CODE    Alpha 5                                     AC550   AC551
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
First Name           Contains the first name of the manager
                     in charge.

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

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

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

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

AEM-EXEMPT-EMP       Alpha 1                                     AC550   AC551
Exempt Employee

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

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

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

AEM-PAY-FREQUENCY    Numeric 1                                   AC550   AC551
Pay Frequency

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

AEM-LOCAT-CODE       Alpha 10                                    AC550   AC551
Location

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
                     represents a type of job.

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

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

AEM-COMP-PRLVL       Alpha 9                                     AC550   AC551
Comp Prlvl

AEM-ACCT-CATEGORY    Alpha 5                                     AC550   AC551
Account Category     Account 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