ACCT_PP_AUVWLNG

(SQL View)
 Index Back

Rel Lang Term Summary SF

ACCT_PP_AUVWLNG is the language record view related to ACCT_PP_AU_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT DISTINCT C.BUSINESS_UNIT , A.COMMON_ID , A.STRM , B.LANGUAGE_CD , B.DESCR FROM PS_SF_PAYMENT A , PS_TERM_VAL_LANG B , PS_BUS_UNIT_TBL_SF C , PS_ISET_BU_DTL D WHERE A.INSTITUTION_SET <> ' ' AND A.INSTITUTION_SET = D.INSTITUTION_SET AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.STRM = B.STRM AND C.SF_ENABLE_WEB_PAY = 'Y' AND A.SA_ID_TYPE = 'P' AND (A.SF_PAYMENT_STATUS = 'S' OR A.SF_PAYMENT_STATUS = 'A' OR A.SF_PAYMENT_STATUS = 'B') AND A.SF_POST_STATUS <> 'S' AND A.CR_CARD_TRANS_SRC = 'P'

  • Related Language Record for ACCT_PP_AU_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description