EEMATCHING

Advance-Expense Matching

The Matching file contains open and applied employee advance records and applied expense records.
UPDATED BY
AP30.4 AP300 EE135 EE20.1 EE20.2 EE20.4
EE220 EE30.1 EE35.1 EE35.2 EE520

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EEM-COMPANY
Element: Company		Numeric 4
The company number. Must be a valid record in the Accounts Payable Company file.
EE20.2 EE30.1
EE520
EEM-VENDOR
Element: 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
Element: Expense Nbr		Alpha 10
A unique number assigned to an employee expense.
EE20.2 EE30.1
EE520
EEM-ADVANCE-NBR
Element: Advance Nbr		Alpha 10
A unique number assigned to an employee advance.
EE20.2 EE30.1
EE520
EEM-AMT-APPLIED
Element: Intl Amt		Signed 18.2
The amount of the advance that is applied to the expense(s).
EE20.2 EE30.1
EE520
EEM-BASE-ADV-AMT
Element: Intl Amt		Signed 18.2
The amount of the advance in the company base currency.
EE20.2 EE30.1
EE520


EEMATCHING FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EEMSET1 COMPANY
VENDOR
EXPENSE-NBR
ADVANCE-NBR
AP30.4 AP300
EE135 EE20.2
EE20.4 EE220
EE30.1 EE35.1
EE35.2 EE520
EEMSET2 COMPANY
VENDOR
ADVANCE-NBR
EXPENSE-NBR
AP30.4 EE20.1
EE20.2 EE30.1


EEMATCHING FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:08:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.