EM_NOTIFY_REMND (SQL Table)	Index Back
eS - Notification Reminder Tbl eSettlements table to store vouchers/invoices that have been sent an email notification. 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_NOTIFY_REMND

(SQL Table)

eS - Notification Reminder Tbl

eSettlements table to store vouchers/invoices that have been sent an email notification. 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 EM_NOTIFY_TYPE Character(2) VARCHAR2(2) NOT NULL eS - Flag to indicate the Notification (ex. Payment Cancelled notification).
01=Agreement
02=Match Exception - Buyer
03=Match Exception - Supplier
04=Payments Awaiting Approval
05=Payment Create and Cancel
06=Invoice Extract - Buyer
07=Dispute - Payment Schedules
08=Dispute - Invoice Lines
09=Invoice Extract - Supplier
10=Cash Collections
11=Invoice Load - No Errors
12=Invoice Load - Errors
13=Resolve - Invoice Lines
14=Invoice Verification
15=Proposal Submitted
16=Proposal Accepted
17=Proposal Denied
18=1099 Report

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

#	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	EM_NOTIFY_TYPE	Character(2)	VARCHAR2(2) NOT NULL	eS - Flag to indicate the Notification (ex. Payment Cancelled notification). 01=Agreement 02=Match Exception - Buyer 03=Match Exception - Supplier 04=Payments Awaiting Approval 05=Payment Create and Cancel 06=Invoice Extract - Buyer 07=Dispute - Payment Schedules 08=Dispute - Invoice Lines 09=Invoice Extract - Supplier 10=Cash Collections 11=Invoice Load - No Errors 12=Invoice Load - Errors 13=Resolve - Invoice Lines 14=Invoice Verification 15=Proposal Submitted 16=Proposal Accepted 17=Proposal Denied 18=1099 Report
4	EM_DATE_NOTIFIED	Date(10)	DATE	Used in eS workflow to store the date an invoice was sent a notification.