ORIGIN_PAY_LVW

(SQL View)
 Index Back

Payment Origins


SELECT A.setid ,A.origin_id , L.LANGUAGE_CD ,A.effdt ,L.descr ,L.descrshort FROM PS_ORIGIN_TBL A , PS_ORIGIN_TBL_LG L WHERE A.origin_type = 'D' AND A.SETID = L.SETID AND A.ORIGIN_ID = L.ORIGIN_ID AND A.EFFDT = L.EFFDT

  • Related Language Record for ORIGIN_PAY_VW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Specifies the source or method of entry for a pending item group.

    Prompt Table: ORIGIN_PAY_VW

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description