EM_B_NOTIFY_AGR

(SQL Table)
 Index Back

eS-Buyer Notifiy Setup Agrment

eSettlements header/parent record for Buyer Notification Setup at Agreement level.

  • Parent Record Of EM_B_NOTIFY_AG2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    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 NOTIFY_FLAG Character(1) VARCHAR2(1) NOT NULL Recieve Notification

    Y/N Table Edit

    7 EM_CC_LATEDAYS Number(3,0) SMALLINT NOT NULL This field stores the number of days after the due date the seller would like to send reminder messages to the buyer. It will be activated if EM_CASH_COL_NOT is Y (Yes).
    8 EM_REMINDER_DAYS Number(4,0) SMALLINT NOT NULL eS - Specifies the number of days before re-sending a reminder Notification.