EM_L_NOTIFY

(SQL Table)
 Index Back

eS-Location Notify Setup

eSettlements Supplier Location Notification Setup. Header record. Field for indicating if Notification is turned on/off, the Notification type, and the number of days to send a reminder notification.

  • Parent Record Of EM_L_NOTIFY_RT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    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.