Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            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     AP10.1

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

EAP-APPROVAL-CODE    Alpha 3                                     AP959   EE05.2
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)                      AP959   EE05.2
Description          The description of the approval code.       EE520

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

                     A = Active.
                     I = Inactive.

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

                     N = No.
                     Y = Yes.

EAP-VENDOR-GROUP     Alpha 4                                     AP959
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        AP10.1
          APPROVAL-CODE approval code for a vendor group.
                        KeyChange, Duplicates

                         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