SHEET_IDLINE_NBRDISTRIB_LINE_NUMEX_APPR_PYMT_VW(SQL View) |
Index Back |
|---|---|
EX Approval to Payment viewExpense Approval to Payment view |
| SELECT A.SHEET_ID , B.MAX_LINE_NBR , B.MAX_DISTRIB_LINE , ROUND( %DateDiff(A.APPROVAL_DT, E.PYMNT_DT) ,2) AS APPR_PD FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_PYMNT E , PS_EX_MAX_LN_DL_VW B , PS_EX_SHEET_LINE C , PS_EX_SHEET_DIST D WHERE A.SHEET_ID = E.SHEET_ID AND A.BUSINESS_UNIT_GL = E.BUSINESS_UNIT_GL AND A.SHEET_STATUS = 'PD' AND A.SHEET_ID = B.SHEET_ID AND B.SHEET_ID = C.SHEET_ID AND C.SHEET_ID = D.SHEET_ID AND B.MAX_LINE_NBR = C.LINE_NBR AND B.MAX_LINE_NBR = D.LINE_NBR AND B.MAX_DISTRIB_LINE = D.DISTRIB_LINE_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 3 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 4 | EX_APPR_TO_PYMT | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Expense Approval to Payment |