SPF_INV_MNG_LV

(SQL View)
 Index Back

Invoice Header Language View

Language View for Invoice Header view records to retrieve translated descriptions for Payment Terms and Supplier Address

SELECT H.BUSINESS_UNIT , H.INVOICE_ID , PL.LANGUAGE_CD , PL.PYMNT_TERMS_CD , PL.DESCRSHORT , VL1.DESCR , VL2.DESCR FROM PS_SPF_INVOICE_HDR H , PS_PYMT_TR_HD_LANG PL , PS_VNDR_ADDRSCR_LG VL1 , PS_VNDR_ADDRSCR_LG VL2 WHERE PL.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_GROUP R WHERE R.SETCNTRLVALUE = H.BUSINESS_UNIT AND R.REC_GROUP_ID = 'FS_14') AND H.PYMNT_TERMS_CD = PL.PYMNT_TERMS_CD AND PL.LANGUAGE_CD = VL1.LANGUAGE_CD AND H.VENDOR_ID = VL1.VENDOR_ID AND H.ADDRESS_SEQ_NUM = VL1.ADDRESS_SEQ_NUM AND VL1.SETID = ( SELECT S.SETID FROM PS_SET_CNTRL_GROUP S WHERE S.SETCNTRLVALUE = H.BUSINESS_UNIT AND S.REC_GROUP_ID = 'FS_38') AND VL1.SETID = VL2.SETID AND VL1.LANGUAGE_CD = VL2.LANGUAGE_CD AND VL2.VENDOR_ID = H.REMIT_VENDOR AND VL2.ADDRESS_SEQ_NUM = H.REMIT_ADDR_SEQ_NUM

  • Related Language Record for SPA_INV_APRMG_V SPF_INV_APRMG_V SPF_INV_MNG_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR_2 Character(30) VARCHAR2(30) NOT NULL Description