SETIDPrompt Table: SP_SETID_NONVW
EXPENSE_TYPEPrompt Table: EX_TYPES_TBL
CURRENCY_CDTXN_LOCATIONPrompt Table: EX_LOCATION_TBL
EX_LOC_AMT_VW(SQL View) |
Index Back |
|---|---|
Expenses Location Policy View |
| SELECT A.SETID , A.EXPENSE_TYPE , A.CURRENCY_CD , B.TXN_LOCATION , B.ACTIVE_AVG_AMT , B.START_DT_JULIAN , B.END_DT_JULIAN FROM PS_EX_LOC_AMOUNT A , PS_EX_LOC_AMT_DTL B WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EX_LOC_AMOUNT A1 WHERE A1.SETID = A.SETID AND A1.EXPENSE_TYPE = A.EXPENSE_TYPE AND A1.CURRENCY_CD = A.CURRENCY_CD AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.SETID = B.SETID AND A.EXPENSE_TYPE = B.EXPENSE_TYPE AND A.CURRENCY_CD = B.CURRENCY_CD AND B.EFFDT = A.EFFDT |
| # | 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 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |
| 3 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | TXN_LOCATION |
Character(5) | VARCHAR2(5) NOT NULL |
Expense Location
Prompt Table: EX_LOCATION_TBL |
| 5 | AUTHORIZED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Authorized Amount |
| 6 | START_DT_JULIAN | Number(3,0) | SMALLINT NOT NULL | Julian Start Date |
| 7 | END_DT_JULIAN | Number(3,0) | SMALLINT NOT NULL | Julian End Date |