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 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 Nbr A unique number assigned to an employee EE520
expense.
EEM-ADVANCE-NBR Alpha 10 EE20.2 EE30.1
Element: Advance Nbr A 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 AP30.4 AP300
VENDOR EE135 EE20.2
EXPENSE-NBR EE20.4 EE220
ADVANCE-NBR EE30.1 EE35.1
EE35.2 EE520
EEMSET2 COMPANY AP30.4 EE20.1
VENDOR EE20.2 EE30.1
ADVANCE-NBR
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
|
