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     AP36.1    EE135     EE220     EE230     EE235
EE35.1    EE35.2    EE520     AM115     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    PR514     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   AP36.1
          APPROVAL-CODE approval code for a company.             EE05.2  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   AM15.1
          APPROVAL-CODE approval code for a vendor group.        AM15.2  AM15.3
          COMPANY       KeyChange                                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  PR514
                                                                 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