IST_STTPRC_VWLG

(SQL View)
 Index Back

IST Country Stat Proc RLR


SELECT A.COUNTRY , A.ST_PROC_FSC_RGM , B.LANGUAGE_CD , B.DESCR FROM PS_SPROC_FRGM_TBL A , PS_SPROC_FRGM_LANG B WHERE A.STPROC_FSCRGM_FLG = 'S' AND A.COUNTRY = B.COUNTRY AND A.ST_PROC_FSC_RGM = B.ST_PROC_FSC_RGM

  • Related Language Record for IST_STATPROC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY_IST_RPTG Character(3) VARCHAR2(3) NOT NULL IST Reporting Country
    2 ST_PROC_FSC_RGM Character(6) VARCHAR2(6) NOT NULL Stat Procedure/Fiscal Regime
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description