SCR_EMAILP_O_VW

(SQL View)
 Index Back

SCR Location email original


SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.SEQ_NUM , A.PYMNT_METHOD , A.EFFDT FROM PS_EMAIL_PAY_MTHD A ,PS_SCR_LOC_SCRL_VW B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.EFFDT = B.EFFDT

  • Parent record: SCR_LOC_SCRL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    5 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer

    Prompt Table: PYCYCL_MTHD_VW

    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date