Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACEMPVEN


                             ACEMPVEN FILE

REFERENCED BY

AP170

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AEP-COMPANY            Numeric 4
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AEP-EMPLOYEE           Numeric 9
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

AEP-APCOMPANY          Numeric 4
Element: Apcompany

AEP-VENDOR             Alpha 9  (Right Justified)
Element: Vendor ID     The vendor's identification code.



AEP-PROC-LEVEL         Alpha 5
Element: Process Level The process level represents a
                       reporting level below company.

                         ACEMPVEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AEPSET1   COMPANY
          EMPLOYEE

AEPSET2   APCOMPANY     KeyChange                                AP170
          VENDOR
          COMPANY
          EMPLOYEE

                         ACEMPVEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            AEP-APCOMPANY       -> CPY-COMPANY

Approclev      APPROCLEV    Required

                            AEP-APCOMPANY       -> APR-COMPANY
                            AEP-PROC-LEVEL      -> APR-PROC-LEVEL

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            AEP-VENDOR          -> VEN-VENDOR

Employee       EMPLOYEE     Required

                            AEP-COMPANY         -> EMP-COMPANY
                            AEP-EMPLOYEE        -> EMP-EMPLOYEE