EM_AGR_PAY_LANG

(SQL View)
 Index Back

Agreement Registration - Lang

Related language view of EM_AGREE_PAY_VW

SELECT A.SETID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , LANG.LANGUAGE_CD , B.EFFDT , LANG.DESCR , VL.NAME1 FROM PS_EM_AGREEMENT A , PS_EM_AGMT_PAY_TBL B , PS_VENDOR C , PS_SETID_TBL D , PS_SETID_LANG LANG , PS_VENDOR_LANG VL WHERE A.SETID = B.SETID AND A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.VENDOR_SETID = C.SETID AND A.VENDOR_ID = C.VENDOR_ID AND A.SETID = D.SETID AND LANG.SETID = D.SETID AND VL.SETID = C.SETID AND VL.VENDOR_ID = C.VENDOR_ID

  • Related Language Record for EM_AGREE_PAY_VW

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

    Prompt Table: EM_AGREBUSEC_VW

    2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETVC_NONVW

    3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: EM_VNREG_SEC_VW

    4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: EM_VNDR_LOC_VW

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1