IST_FSCRGM_VWLG

(SQL View)
 Index Back

Intrastat Country Fisc Rgm RLR


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

  • Related Language Record for IST_FSCRGM_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