FULLY_DEPR_SWF=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense
FULLY_DPR_SW_VW(SQL View) |
Index Back |
|---|---|
Fully Depr Sw viewFully Depr Sw View from XLats for Mass Change prompt |
| SELECT DISTINCT %Substring(a.fieldvalue, 1, 1) , a.xlatlongname FROM PSXLATITEM a WHERE A.FIELDNAME = 'FULLY_DEPR_SW' AND A.EFF_STATUS = 'A' AND a.effdt = ( SELECT MAX(b.effdt) FROM PSXLATITEM b WHERE a.fieldvalue = b.fieldvalue AND a.fieldname = b.fieldname ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FULLY_DEPR_SW |
Character(1) | VARCHAR2(1) NOT NULL |
Retire As Fully Depreciated SW
F=Fully Depr with Future Expense N=Calculate Gain/Loss Y=Fully Depr no Future Expense |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |