PO_HDR_EMAIL

(SQL Table)
Index Back

PO Dispatch Email IDs

  • Parent record: PO_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_PM_NONVW

    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Default Value: NEXT

    3 EMAIL_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
    BB=Blackberry
    BUS=Business
    D=Dispatch
    HOME=Home
    N=Notification
    OTH=Other
    WORK=Work

    Default Value: D

    4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address