EM_NOTIFY_LINE(SQL Table) |
Index Back |
---|---|
Invoice Line Dispute NotifyUsed 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. |