Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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     EE135     EE220     EE230     EE235     EE35.1
EE35.2    EE520     AP10.1    API3.1    API4.1

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

                     A = Active.
                     I = Inactive.

EAP-ACTIVITY-FLAG    Alpha 1                                     EE05.2  EE20.1
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
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        AP10.1  API3.1
          APPROVAL-CODE approval code for a vendor group.        API4.1
          COMPANY       KeyChange

                         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