VALID_COMBO_TBL

(SQL Table)
Index Back

Valid Combination Codes

This record contains the account code information f

  • Related Language Record: VALID_COMBO_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
    3 FDM_HASH Character(31) VARCHAR2(31) NOT NULL Hash function
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    6 FDM_COMBO_CD Character(25) VARCHAR2(25) NOT NULL GL Combination Code

    Default Value: NEW

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