SFA_CRC_RPT_VW2

(SQL View)
Index Back

CRC prompt view for doc type

This view is used for prompting on Doc types 'DisbursementRoster' and 'DisbursementForecast'

SELECT XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME='SFA_CR_DOC_TYPE_T'AND FIELDVALUE IN ('DR','DF')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name