EM_INV_VERIFY (SQL Table)	Index Back
Invoice Verification eSettlements table to store vouchers/invoices that have been sent an email notification to verify the invoice before it is processed by Voucher Batch. Check this table and based on the reminder days defined for notifications, send email again if number of days to remind has been met or surpassed.

EM_INV_VERIFY

(SQL Table)

Invoice Verification

eSettlements table to store vouchers/invoices that have been sent an email notification to verify the invoice before it is processed by Voucher Batch. Check this table and based on the reminder days defined for notifications, send email again if number of days to remind has been met or surpassed.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 EM_DATE_NOTIFIED Date(10) DATE Used in eS workflow to store the date an invoice was sent a notification.

5 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	EM_DATE_NOTIFIED	Date(10)	DATE	Used in eS workflow to store the date an invoice was sent a notification.
5	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.