EMPLIDY/N Table Edit
Default Value: N
EX_NAPP_ADV_VW(SQL View) |
Index Back |
|---|---|
Advances Not Applied ViewThis view returns Cash Advances that are not applied to an Expense Sheet |
| SELECT A.EMPLID, ' ' AS SHEET_ID, A.ADVANCE_ID, 'N' AS ADVANCE_SELECTED, B.MONETARY_AMOUNT, 0 AS AMMOUNT_APPLIED, B.MONETARY_AMOUNT FROM PS_EX_ADV_HDR A, PS_EX_ADV_SUM_VW B WHERE A.ADVANCE_ID = B.ADVANCE_ID AND NOT EXISTS(SELECT A1.ADVANCE_ID FROM PS_EX_ADV_HDR A1, PS_EX_SHEET_ADV B1 WHERE B1.ADVANCE_ID=A.ADVANCE_ID) |
| # | 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 | ADVANCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 4 | ADVANCE_SELECTED | Character(1) | VARCHAR2(1) NOT NULL |
Select Advance
Y/N Table Edit Default Value: N |
| 5 | 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. |
| 6 | AMOUNT_APPLIED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Applied |
| 7 | BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance |