ACCOUNTORGVWLNG

(SQL View)
 Index Back

Rel Lang - Account Org View

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

SELECT a.business_unit ,a.ext_org_id ,a.account_nbr ,a.account_term ,c.language_cd ,c.descr FROM PS_ACCOUNT_ORG_SF a ,ps_bus_unit_tbl_sf b ,ps_ext_org_lang c WHERE a.business_unit=b.business_unit AND a.ext_org_id = c.ext_org_id AND c.effdt = ( SELECT MAX(effdt) FROM ps_ext_org_lang c1 WHERE c1.ext_org_id = c.ext_org_id AND c1.effdt <= %CurrentDateIn)

  • Related Language Record for ACCOUNT_ORG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    3 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    4 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description