SPF_INV_PLOG_LV

(SQL View)
 Index Back

Invoice PLOG Language View

Language View for progress-log based Invoice Detail view

SELECT A.BUSINESS_UNIT , A.INVOICE_ID , B.INVOICE_LINE , B.PLOG_ID , B.SHEET_ID , B.LINE_NBR , L1.LANGUAGE_CD , L2.DESCR , L1.DESCRSHORT FROM PS_SPF_INVOICE_HDR A , PS_SPF_INVOICE_DTL B , PS_PAYTRMS_SPF_VW C , PS_PYMT_TR_HD_LANG L1 , PS_VENDOR_ADDR_VW F , PS_VENDOR_ADDR_LVW L2 , PS_SET_CNTRL_GROUP R , PS_SET_CNTRL_GROUP S WHERE B.PLOG_ID <> ' ' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE_ID = B.INVOICE_ID AND A.PYMNT_TERMS_CD = C.PYMNT_TERMS_CD AND R.SETCNTRLVALUE = A.BUSINESS_UNIT AND R.SETID = C.SETID AND R.REC_GROUP_ID = 'FS_14' AND A.VENDOR_ID = F.VENDOR_ID AND A.ADDRESS_SEQ_NUM = F.ADDRESS_SEQ_NUM AND A.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_38' AND F.SETID = S.SETID AND C.SETID = L1.SETID AND C.PYMNT_TERMS_CD = L1.PYMNT_TERMS_CD AND L2.SETID = F.SETID AND L2.VENDOR_ID = F.VENDOR_ID AND L2.ADDRESS_SEQ_NUM = F.ADDRESS_SEQ_NUM AND L2.EFFDT = F.EFFDT

  • Related Language Record for SPF_INV_PLOG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    3 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
    4 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
    5 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
    6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description