EX_ADV_APPL_VW(SQL View) |
Index Back |
|---|---|
Cash Advance Applications |
| SELECT B.SHEET_ID , A.ADVANCE_ID , B.CURRENCY_CD , SUM(B.AMOUNT_APPLIED) , A.PROCESS_INSTANCE FROM PS_EX_ADV_HDR A , PS_EX_SHEET_ADV B WHERE B.ADVANCE_ID = A.ADVANCE_ID GROUP BY B.SHEET_ID, 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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 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 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |