VALID_CD_NEW_VW

(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 , A.FDM_COMBO_CD ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,'N' ,A.DESCRSHORT ,%subrec(CHARTFLD_KY_SBR, A) , ' ' FROM PS_VALID_COMBO_TBL A

  • Related Language Record: VALID_CD_VW_LNG

    • # 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 GL Combination Code

    Default Value: NEW

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 CHARTFLDS_OLD Character(1) VARCHAR2(1) NOT NULL Search Original Chartfields

    Y/N Table Edit

    9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    10 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    11 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department
    12 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    13 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    14 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    15 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    16 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    17 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    18 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    19 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    20 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    21 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    22 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    23 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    24 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    25 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    26 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).