SHEET_IDEX_RSUM_SHT_VW(SQL View) |
Index Back |
|---|---|
Sum of Reimbursable Expenses |
| SELECT A.SHEET_ID , A.ADVANCE_ID , A.CREATION_DT , A.APPROVAL_DT , B.CURRENCY_CD , SUM(B.MONETARY_AMOUNT) , A.PROCESS_INSTANCE FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_LINE B , PS_EX_EXP_MTHD_TBL C , PS_SET_CNTRL_REC D WHERE B.REIMBURSEMENT_CD='R' AND B.SHEET_ID = A.SHEET_ID AND B.EXPEND_MTHD = C.EXPEND_MTHD AND D.SETCNTRLVALUE=A.BUSINESS_UNIT_GL AND D.RECNAME='EX_EXP_MTHD_TBL' AND C.EFFDT=( SELECT MAX(X.EFFDT) FROM PS_EX_EXP_MTHD_TBL X WHERE X.SETID = C.SETID AND X.EXPEND_MTHD = C.EXPEND_MTHD AND X.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND D.SETID = C.SETID AND C.EXPEND_MTHD_EDIT = 'EMP' GROUP BY A.SHEET_ID, A.CREATION_DT, A.APPROVAL_DT, A.ADVANCE_ID, B.CURRENCY_CD, A.PROCESS_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | ADVANCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 3 | CREATION_DT | Date(10) | DATE | Creation Date |
| 4 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | 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. |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |