EEMATCHING – Advance Expense Matching

System
Accounts Payable (AP)
Prefix
EEM
Primary key
COMPANY, VENDOR, EXPENSE-NBR, ADVANCE-NBR
Fields
6
Updated by
7 programs
Referenced by
4 programs

EEMATCHING is the Advance Expense Matching table in Lawson Accounts Payable (prefix EEM). It is indexed by COMPANY, VENDOR, EXPENSE-NBR, ADVANCE-NBR (EEMSET1); alternate indexes: EEMSET2. It is related 1:1 to EEADVANCE and EEEXPENSE. It is updated by AP30.4, AP300, EE20.1, EE20.2, EE20.4, EE30.1 and EE520 and referenced by EE135, EE220, EE35.1 and EE35.2. The table has 6 fields, 2 indexes and 2 documented relations.

About EEMATCHING

The Matching file contains open and applied employee advance records and applied expense records.

Fields (6)

Column = COBOL field name without the EEM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#EEM-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.EE20.2, EE30.1, EE520
#EEM-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The employee number. Must be a valid record in the Accounts Payable Vendor file.EE20.2, EE30.1, EE520
#EEM-EXPENSE-NBR PK
EXPENSE_NBR		Alpha 10A unique number assigned to an employee expense.EE20.2, EE30.1, EE520
#EEM-ADVANCE-NBR PK
ADVANCE_NBR		Alpha 10A unique number assigned to an employee advance.EE20.2, EE30.1, EE520
#EEM-AMT-APPLIED
AMT_APPLIED		Signed 18.2The amount of the advance that is applied to the expense(s).EE20.2, EE30.1, EE520
#EEM-BASE-ADV-AMT
BASE_ADV_AMT		Signed 18.2The amount of the advance in the company base currency.EE20.2, EE30.1, EE520

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EEMSET1
  1. COMPANY
  2. VENDOR
  3. EXPENSE-NBR
  4. ADVANCE-NBR
PrimaryAP30.4, AP300, EE135, EE20.2, EE20.4, EE220, EE30.1, EE35.1 +2 more
EEMSET2
  1. COMPANY
  2. VENDOR
  3. ADVANCE-NBR
  4. EXPENSE-NBR
AP30.4, EE20.1, EE20.2, EE30.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EEADVANCEEEEXPENSEEEMATCHING

One to one (2) — lookups and parents

RelationTableRulesConditionField map
EeadvanceEEADVANCERequired
EEM-COMPANY→EEA-COMPANY
EEM-VENDOR→EEA-VENDOR
EEM-ADVANCE-NBR→EEA-ADVANCE-NBR
EeexpenseEEEXPENSERequired
EEM-COMPANY→EXP-COMPANY
EEM-VENDOR→EXP-VENDOR
EEM-EXPENSE-NBR→EXP-EXPENSE-NBR

Programs

Updated by (7)

Referenced by (4)