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     AC160     AM115     AM117     AM15.1
AM15.2    AM15.3    AM15.4    AM19.1    AM19.2    AM20.1
AM20.3    AM21.1    AM21.3    AM500     AM51.1    AM551
AM97.1    AP03.3    AP10.1    AP110     AP115     AP125
AP126     AP131     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP21.1    AP210     AP220     AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP305     AP510     AP90.1    AP91.1    API1.1    API2.1
API3.1    API4.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    MX123     MX500     MA180     MA279
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.4    MA43.6    MA43.7    MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA63.1    MA65.1
MA66.2    MA66.3    MA67.2    MA67.3    MA68.2    MA68.3
MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1
PD10.2    PD130     PD20.1    PD20.2    PD20.3    PD235
PO10.1    PO100     PO101     PO120     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO220     PO223     PO23.1    PO233     PO24.1
PO25.1    PO25.5    PO25.6    PO25.7    PO253     PO254
PO27.2    PO278     PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
PO54.1    PO54.2    PO54.3    PO54.4    POI3.1    POID.1
POII.1    POIJ.1    PR05.1    PR05.3    PR226     PR247
PR26.1    PR47.1    PR514     UK47.1    RQ10.1    RQ10.2
WH20.2    WH20.7

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: Active Flag   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                                                AP236   EE05.2
          APPROVAL-CODE                                          EE135   EE20.1
                                                                 EE20.2  EE20.4
                                                                 EE220   EE230
                                                                 EE235   EE35.1
                                                                 EE35.2  EE520

EAPSET2   VENDOR-GROUP  KeyChange                                AC160   AM115
          APPROVAL-CODE                                          AM117   AM15.1
          COMPANY                                                AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP10.1  AP110
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 ...

                         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