HP_DED_ACC_TMPL

(SQL Table)
Index Back

Deductions Account Template

Store a "default" Account for deductions in the situation when no Account match is found during distribution.

  • Parent Record Of HP_DED_ACC_RULE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    3 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL