NET_VCHR_VN_V_L

(SQL View)
 Index Back

Netting Voucher/Supplier View


SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , R.LANGUAGE_CD , R.NAME1 FROM PS_VOUCHER A , PS_VENDOR B , PS_SET_CNTRL_REC C , PS_VENDOR_LANG R WHERE A.VENDOR_ID = B.VENDOR_ID AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.REC_GROUP_ID = 'FS_38' AND C.RECNAME = 'VENDOR' AND B.SETID = C.SETID AND (A.VCHR_APPRVL_FLG = 'P' OR A.APPR_STATUS='A') AND R.SETID = B.SETID AND R.VENDOR_ID = B.VENDOR_ID

  • Related Language Record for NET_VCHR_VN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1