EX_RISK_TOTLMT

(SQL Table)
 Index Back

Risk Total Limit Amounts

Expense Risk Total Limit Amounts for Pre-Payment and Post Payment

  • Parent record: EX_RISK_TMPL

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

    Prompt Table: SP_SETID_NONVW

    2 RISK_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Risk Template ID

    Prompt Table: EX_RISK_TMPL

    3 APPR_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Approval Transaction Type.
    CA=Cash Advance
    ER=Expense Report
    TA=Travel Authorization
    TJ=Time Adjustment
    TR=Time Report
    4 RISK_LEVEL Character(1) VARCHAR2(1) NOT NULL Risk Level
    1=Level 1
    2=Level 2
    3=Level 3
    4=Level 4
    5=Level 5
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    7 BU_EXP_MAX_AMT_PRE Number(27,3) DECIMAL(26,3) NOT NULL Prepayment Amount
    8 BU_EXP_MAX_AMT_PST Number(27,3) DECIMAL(26,3) NOT NULL Post-Payment Amount
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL