EEAPPROVAL – Expense Advance Approval Code

System
Accounts Payable (AP)
Prefix
EAP
Primary key
COMPANY, APPROVAL-CODE
Fields
6
Updated by
4 programs
Referenced by
298 programs

EEAPPROVAL is the Expense Advance Approval Code table in Lawson Accounts Payable (prefix EAP). It is indexed by COMPANY, APPROVAL-CODE (EAPSET1); alternate indexes: EAPSET2. It is related 1:M to EEADVANCE and EEEXPENSE. It is updated by EE05.2, EE20.1, EE20.2 and EE20.4 and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 290 more. The table has 6 fields, 2 indexes and 2 documented relations.

About EEAPPROVAL

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.

Fields (6)

Column = COBOL field name without the EAP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
EAP-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.EE05.2
EAP-APPROVAL-CODE PK
APPROVAL_CODE		Alpha 3A 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.EE05.2
EAP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the approval code.EE05.2, EE520
EAP-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1Indicates whether the approval code is active. Valid values are:
  • A Active.
  • I Inactive.
EE05.2
EAP-ACTIVITY-FLAG
ACTIVITY_FLAG		Alpha 1Indicates whether this approval code is 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.
EE05.2, EE20.1, EE20.2, EE20.4
EAP-VENDOR-GROUP
VENDOR_GROUP		Alpha 4The vendor group associated with the company. Must be a valid record in the Vendor Group file.—

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EAPSET1COMPANY, APPROVAL-CODEPrimaryAP236, EE05.2, EE135, EE20.1, EE20.2, EE20.4, EE220, EE230 +4 more
EAPSET2VENDOR-GROUP, APPROVAL-CODE, COMPANYKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
EeadvanceEEADVANCEEAP-COMPANY → EEA-COMPANY, EAP-APPROVAL-CODE → EEA-APPROVAL-CODE, → EEA-VENDOR, → EEA-ADVANCE-NBR
EeexpenseEEEXPENSEEAP-COMPANY → EXP-COMPANY, EAP-APPROVAL-CODE → EXP-APPROVAL-CODE, → EXP-VENDOR, → EXP-EXPENSE-NBR

Programs

Updated by (4)

Referenced by (298)