EEMATCHING FILE
Advance-Expense Matching
The Matching file contains open and applied employee advance records and
applied expense records.
REFERENCED BY
EE135 EE220 EE35.1 EE35.2
UPDATED BY
AP300 EE20.1 EE20.2 EE20.4 EE30.1 EE520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EEM-COMPANY Numeric 4 EE20.2 EE30.1
Company The company number. Must be a valid EE520
record in the Accounts Payable Company
file.
EEM-VENDOR Alpha 9 (Right Justified) EE20.2 EE30.1
Vendor ID The employee number. Must be a valid EE520
record in the Accounts Payable Vendor
file.
EEM-EXPENSE-NBR Alpha 10 EE20.2 EE30.1
Expense Number A unique number assigned to an employee EE520
expense.
EEM-ADVANCE-NBR Alpha 10 EE20.2 EE30.1
Advance Number A unique number assigned to an employee EE520
advance.
EEM-AMT-APPLIED Signed 15.2 EE20.2 EE30.1
Applied Amount The amount of the advance that is EE520
applied to the expense(s).
EEM-BASE-ADV-AMT Signed 15.2 EE20.2 EE30.1
Advance Amount The amount of the advance in the EE520
company base currency.
EEMATCHING FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EEMSET1 COMPANY This index is used to access open AP300 EE135
VENDOR advances for a specific employee and EE20.2 EE20.4
EXPENSE-NBR company. EE220 EE30.1
ADVANCE-NBR EE35.1 EE35.2
EE520
EEMSET2 COMPANY This index is used to access applied EE20.1 EE20.2
VENDOR advances for a specific employee and EE30.1
ADVANCE-NBR company.
EXPENSE-NBR
EEMATCHING FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
