EM_NOTIFYLN_VW (SQL View)	Index Back
Invoice Line Dispute Notify Used to determine notifications for invoice line disputes.

EM_NOTIFYLN_VW

(SQL View)

Invoice Line Dispute Notify

Used to determine notifications for invoice line disputes.

SELECT DISTINCT A.OPRID , A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , N.EM_NOTIFY_TYPE , V.VENDOR_SETID , V.VENDOR_ID , V.VNDR_LOC , N.EM_DATE_NOTIFIED , D.EMAIL_ON , D.LINE_HOLD FROM PS_EM_NOTIFY_LINE N , PS_EM_INVLINE_APPR A , PS_VOUCHER V , PS_EM_DISPUTE_LINE D WHERE A.BUSINESS_UNIT = N.BUSINESS_UNIT AND A.VOUCHER_ID = N.VOUCHER_ID AND A.VOUCHER_LINE_NUM = N.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = N.DISTRIB_LINE_NUM AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND A.VOUCHER_LINE_NUM = D.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = D.DISTRIB_LINE_NUM AND A.OPRID = D.OPRID AND A.BUSINESS_UNIT = V.BUSINESS_UNIT AND A.VOUCHER_ID = V.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

6 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

7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

9 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

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

11 EMAIL_ON Character(1) VARCHAR2(1) NOT NULL Message Active
A=Active
I=Inactive

12 LINE_HOLD Character(1) VARCHAR2(1) NOT NULL Manual Line Holds

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
6	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
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
10	EM_DATE_NOTIFIED	Date(10)	DATE	Used in eS workflow to store the date an invoice was sent a notification.
11	EMAIL_ON	Character(1)	VARCHAR2(1) NOT NULL	Message Active A=Active I=Inactive
12	LINE_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Manual Line Holds