EM_S_NOTIFY_RT (SQL Table)	Index Back
eS - Supplier SetID Routings eSettlements child record for Supplier SetID level Notification setup. Parent record EM_S_NOTIFY. Indicates for each Notificaton type the UserID, Role name, or email address Notification is to be routed to. Also indicates whether the route to is Carbon Copied (CC) or sent notification directly as the addressee of notification (To).

EM_S_NOTIFY_RT

(SQL Table)

eS - Supplier SetID Routings

eSettlements child record for Supplier SetID level Notification setup. Parent record EM_S_NOTIFY. Indicates for each Notificaton type the UserID, Role name, or email address Notification is to be routed to. Also indicates whether the route to is Carbon Copied (CC) or sent notification directly as the addressee of notification (To).

Parent record: EM_S_NOTIFY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 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

3 EM_EMAIL_FIELD Character(1) VARCHAR2(1) NOT NULL Used by eS as a flag to determine whether the notification was addressed to the To field, CC field (carbon copied), or BCC field (blind carbon copied).
1=Email To Field
2=Email CC Field

4 EM_ROUTE_TYPE Character(1) VARCHAR2(1) NOT NULL Field indicates whether the eS Notification is sent to a Role Name, OPRID (UserID), or Email Address. See associated field: EM_ROUTE_TO
1=Requester
2=Role Name
3=OPRID

5 EM_ROUTE_TO Character(70) VARCHAR2(70) NOT NULL Specifies the Role name, OPRID (UserID), or Email Address the eS Notification is sent to. Works in association with field EM_ROUTE_TYPE.
Prompt Table: %EDITTABLE

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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
3	EM_EMAIL_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Used by eS as a flag to determine whether the notification was addressed to the To field, CC field (carbon copied), or BCC field (blind carbon copied). 1=Email To Field 2=Email CC Field
4	EM_ROUTE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field indicates whether the eS Notification is sent to a Role Name, OPRID (UserID), or Email Address. See associated field: EM_ROUTE_TO 1=Requester 2=Role Name 3=OPRID
5	EM_ROUTE_TO	Character(70)	VARCHAR2(70) NOT NULL	Specifies the Role name, OPRID (UserID), or Email Address the eS Notification is sent to. Works in association with field EM_ROUTE_TYPE. Prompt Table: %EDITTABLE
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code