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.

Field / column	Type	Description & values	Updated by
`EEM-COMPANY` PK COMPANY	Numeric 4	The 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 10	A unique number assigned to an employee expense.	EE20.2, EE30.1, EE520
`EEM-ADVANCE-NBR` PK ADVANCE_NBR	Alpha 10	A unique number assigned to an employee advance.	EE20.2, EE30.1, EE520
`EEM-AMT-APPLIED` AMT_APPLIED	Signed 18.2	The 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.2	The amount of the advance in the company base currency.	EE20.2, EE30.1, EE520

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`EEMSET1`	`COMPANY`, `VENDOR`, `EXPENSE-NBR`, `ADVANCE-NBR`	Primary		AP30.4, AP300, EE135, EE20.2, EE20.4, EE220, EE30.1, EE35.1 +2 more
`EEMSET2`	`COMPANY`, `VENDOR`, `ADVANCE-NBR`, `EXPENSE-NBR`			AP30.4, EE20.1, EE20.2, EE30.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Eeadvance	EEADVANCE	Required		`EEM-COMPANY` → `EEA-COMPANY`, `EEM-VENDOR` → `EEA-VENDOR`, `EEM-ADVANCE-NBR` → `EEA-ADVANCE-NBR`
Eeexpense	EEEXPENSE	Required		`EEM-COMPANY` → `EXP-COMPANY`, `EEM-VENDOR` → `EXP-VENDOR`, `EEM-EXPENSE-NBR` → `EXP-EXPENSE-NBR`

Programs

Updated by (7)

AP30.4 Invoice Cancel
AP300 Invoice and Vendor History Purge
EE20.1 Employee Advance
EE20.2 Employee Expense
EE20.4 Employee Payback
EE30.1 Expense and Advance Matching
EE520 Expense Interface

Referenced by (4)

EE135 Mass Employee Release
EE220 Expense, Advance, or Payback Edit
EE35.1 Advance Release
EE35.2 Expense Release