VALID_CD_VW_LNG

(SQL View)
 Index Back

Account Codes

This record contains the account code information for GL. It is used for the payroll / GL interface.

SELECT A.SETID , A.PROCESS_GROUP , A.FDM_HASH , B.FDM_COMBO_CD , A.EFFDT , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_VALID_COMBO_LNG A , PS_VALID_COMBO_TBL B WHERE A.SETID = B.SETID AND A.PROCESS_GROUP = B.PROCESS_GROUP AND A.FDM_HASH = B.FDM_HASH AND A.EFFDT = B.EFFDT

  • Related Language Record for VALID_CD_NEW_VW VALID_CD_OLD_VW VALID_CD_PC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
    3 FDM_HASH Character(31) VARCHAR2(31) NOT NULL Hash function
    4 FDM_COMBO_CD Character(25) VARCHAR2(25) NOT NULL The code represents a combination of GL and PC chartfields
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description