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
AP30.4 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
Element: 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
Element: 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
Element: Expense NumberA unique number assigned to an employee EE520
expense.
EEM-ADVANCE-NBR Alpha 10 EE20.2 EE30.1
Element: Advance NumberA unique number assigned to an employee EE520
advance.
EEM-AMT-APPLIED Signed 18.2 EE20.2 EE30.1
Element: Intl Amt The amount of the advance that is EE520
applied to the expense(s).
EEM-BASE-ADV-AMT Signed 18.2 EE20.2 EE30.1
Element: Intl Amt 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 AP30.4 AP300
VENDOR advances for a specific employee and EE135 EE20.2
EXPENSE-NBR company. EE20.4 EE220
ADVANCE-NBR EE30.1 EE35.1
EE35.2 EE520
EEMSET2 COMPANY This index is used to access applied AP30.4 EE20.1
VENDOR advances for a specific employee and EE20.2 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
|
