EM_NOTIFY_LINE

(SQL Table)
Index Back

Invoice Line Dispute Notify

Used to determine notifications for invoice line disputes.

# 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 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 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
6 EM_DATE_NOTIFIED Date(10) DATE Used in eS workflow to store the date an invoice was sent a notification.