Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EEAPPROVAL


                            EEAPPROVAL FILE

                     Expense-Advance Approval Code

The Approval Code file contains approval code records. Approval codes
identify the person or department responsible for approving an employee
advance, expense, or payback. An approval code must be assigned to an employee
advance, expense, or payback before the transaction can be released to the
Lawson Accounts Payable system for further processing.

REFERENCED BY

AP236     EE135     EE220     EE230     EE235     EE35.1
EE35.2    EE520     AM115     AM117     AM15.1    AM15.2
AM15.3    AM15.4    AM20.1    AM20.3    AM21.1    AM21.3
AM500     AM51.1    AM551     AM97.1    AP10.1    API3.1
API4.1    IC840     PR05.1    PR05.3    PR226     PR247
PR26.1    PR47.1    UK47.1

UPDATED BY

EE05.2    EE20.1    EE20.2    EE20.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EAP-COMPANY            Numeric 4                                 EE05.2
Element: Company       The company number. Must be a valid
                       record in the Accounts Payable Company
                       file.

EAP-APPROVAL-CODE      Alpha 3                                   EE05.2
Element: Approval Code A user-defined code used for approving
                       advances, expenses, and paybacks to be
                       released to the Lawson Accounts Payable
                       system. Represents the person or
                       department responsible for approving the
                       transaction.

EAP-DESCRIPTION        Alpha 30  (Lower Case)                    EE05.2  EE520
Element: Description   The description of the approval code.

EAP-ACTIVE-FLAG        Alpha 1                                   EE05.2
Element: Status        Indicates whether the approval code is
                       active. Valid values are:

                       A = Active.
                       I = Inactive.

EAP-ACTIVITY-FLAG      Alpha 1                                   EE05.2  EE20.1
Element: Activity Flag Indicates whether this approval code is   EE20.2  EE20.4
                       used. This flag is set to "Y" once the
                       approval code is assigned to an employee
                       advance, expense, or payback. Valid
                       values are:

                       N = No.
                       Y = Yes.

EAP-VENDOR-GROUP       Alpha 4
Element: Vendor Group  The vendor group associated with the
                       company. Must be a valid record in the
                       Vendor Group file.

                         EEAPPROVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EAPSET1   COMPANY       This index is used to validate an        AP236   EE05.2
          APPROVAL-CODE approval code for a company.             EE135   EE20.1
                                                                 EE20.2  EE20.4
                                                                 EE220   EE230
                                                                 EE235   EE35.1
                                                                 EE35.2  EE520

EAPSET2   VENDOR-GROUP  This index is used to validate an        AM115   AM117
          APPROVAL-CODE approval code for a vendor group.        AM15.1  AM15.2
          COMPANY       KeyChange                                AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP10.1  API3.1
                                                                 API4.1  IC840
                                                                 PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 UK47.1

                         EEAPPROVAL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Eeadvance      EEADVANCE

                            EAP-COMPANY          -> EEA-COMPANY
                            EAP-APPROVAL-CODE    -> EEA-APPROVAL-CODE
                                                    EEA-VENDOR
                                                    EEA-ADVANCE-NBR

Eeexpense      EEEXPENSE

                            EAP-COMPANY          -> EXP-COMPANY
                            EAP-APPROVAL-CODE    -> EXP-APPROVAL-CODE
                                                    EXP-VENDOR
                                                    EXP-EXPENSE-NBR