EX_SHEET_LN_VW4

(SQL View)
 Index Back

Expense Sheet Line View

Expense Sheet Line Information

SELECT A.EMPLID , B.SHEET_ID , B.EXPENSE_TYPE , SUM(B.MONETARY_AMOUNT) , COUNT(*) , B.CURRENCY_CD , C.EXPENSE_TYPE_EDIT , C.DESCR , C.DESCRSHORT FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_LINE B , PS_MBL_EX_TYPE_VW C , PS_SET_CNTRL_REC CNTRLREC , ps_ex_ee_org_dtl D WHERE B.SHEET_ID = A.SHEET_ID AND D.EMPLID = A.EMPLID AND D.dflt_ee_prof_flg = 'Y' AND CNTRLREC.recname='EX_TYPES_TBL' AND C.EXPENSE_TYPE = B.EXPENSE_TYPE AND C.SETID = CNTRLREC.SETID AND CNTRLREC.SETCNTRLVALUE = D.business_unit_gl GROUP BY A.EMPLID , B.SHEET_ID , B.EXPENSE_TYPE , B.CURRENCY_CD , C.EXPENSE_TYPE_EDIT , C.DESCR , C.DESCRSHORT

  • Related Language Record: EX_SHEET_LN_VL4

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
    3 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type

    Prompt Table: EX_TYPES_TBL

    4 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
    5 TOTAL_LINES Number(4,0) SMALLINT NOT NULL SpeedChart Total Lines
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    7 EXPENSE_TYPE_EDIT Character(3) VARCHAR2(3) NOT NULL Expense Type Edit
    AIR=Airfare
    ATT=Attendees
    AUT=Automobile
    HTL=Hotel
    NON=None
    PDL=Per Diem Lodging
    PDM=Per Diem
    RTL=Rental
    8 EX_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Expense Type Description
    9 EX_TYPE_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Expense Type Description