EX_PD_CALC_DTL

(SQL Table)
 Index Back

Expenses Calculations

  • Parent record: EX_PD_CALC_TBL

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

    Prompt Table: SP_SETID_NONVW
    Set Control Field: BUSINESS_UNIT_GL

    2 EX_CALC_CODE Character(5) VARCHAR2(5) NOT NULL Calculation Code
    3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    4 PARENTHESIS_1 Character(1) VARCHAR2(1) NOT NULL Paranthesis
    (=Open Parenthesis
    )=Close Parenthesis
    5 PERDIEM_FLG Character(1) VARCHAR2(1) NOT NULL Per Diem Value
    A=Active Amount
    G=Government Amount
    H=Hours Worked
    6 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a
    7 PARENTHESIS_2 Character(1) VARCHAR2(1) NOT NULL Paranthesis
    (=Open Parenthesis
    )=Close Parenthesis
    8 OPERATOR_1 Character(1) VARCHAR2(1) NOT NULL Operator
    *=Multiply
    +=Add
    -=Subtract
    /=Divide